Error while trying the update query

Expand Post »

Hi,
Okay, here's the deal. I've created a project which requires user registration. Now, the registration part works like a dream. However, when I tried implementing an option where the user can update his details, the update isn't working. It says I have an error in my update statement. I'm posting the code here. For the first recordset, when I comment out the line which actually carries out the command, the asp works perfectly. However, when I try to uncomment it and run the asp, I get an error :Error in UPDATE query". I've checked the asp and it's fine. Can anyone help me out please?

Quote ...

<%@ Language="VBScript" %>
<%reg=Request("reg")%>
<%
if reg = 1 then
%>

<%

Set con1 = server.CreateObject ("ADODB.Connection")
Set rs1 = server.CreateObject ("ADODB.Recordset")

con1.Provider="Microsoft.Jet.OLEDB.4.0"
con1.Open (server.MapPath ("\databasecore\mediaguide.mdb"))

sql = "UPDATE authenticatedusers SET "
sql=sql & "password='"&TRIM(Request.Form("output"))&"', "
sql=sql & "name='"&TRIM(Request.Form("name"))&"', "
sql=sql & "address='"&TRIM(Request.Form("address"))&"', "
sql=sql & "country='"&TRIM(Request.Form("country"))&"', "
sql=sql & "age='"&TRIM(Request.Form("age"))&"', "
sql=sql & "tel='"&TRIM(Request.Form("tel"))&"', "
sql=sql & "dateofbirth='"&TRIM(Request.Form("dateofbirth"))&"', "
sql=sql & "monthofbirth='"&TRIM(Request.Form("monthofbirth"))&"', "
sql=sql & "yearofbirth='"&TRIM(Request.Form("yearofbirth"))&"', "
sql=sql & "email='"&TRIM(Request.Form("email"))&"' "
sql=sql & "WHERE username='"&Request.QueryString("user")&"'"
rs1.Open sql, con1

response.write(sql)

end if

Set con2 = server.CreateObject ("ADODB.Connection")
Set rs2 = server.CreateObject ("ADODB.Recordset")

con2.Provider="Microsoft.Jet.OLEDB.4.0"
con2.Open (server.MapPath ("\databasecore\mediaguide.mdb"))

sql2="SELECT * FROM authenticatedusers WHERE username='"&Request.QueryString("user")&"'"

rs2.Open sql2,con2
%>
<HTML>
<HEAD>
<TITLE>Registration</TITLE>
<SCRIPT LANGUAGE="JavaScript">
var str_in;
var str_out = "";
var num_in;
var num_out = "";

function str_to_num(form) {
num_out = "";
if(form.password.value == "") ;
else {
str_in = escape(form.password.value);
for(i = 0; i < str_in.length; i++) {
num_out += str_in.charCodeAt(i) - 23;
}

rannum=str_in.length+32
pwhash=rannum*num_out/100000000000
finalop=pwhash+rannum
form.output.value = finalop;
}
}
</script>

<SCRIPT>
function password()
{
window.open("passwordeg.htm", "","toolbar=no, height=650, width=600, directories=no,status=no,scrollbars=yes,resizable=yes,menubar=no")
}
</SCRIPT>
<meta name="Microsoft Theme" content="folio 111, default">
</HEAD>
<BODY><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>
<td width="100%">
<p align="right">
<br>
<font size="2">
</font></p>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>
<td width="50%">



<SCRIPT LANGUAGE="Javascript">

var digit="0123456789";

function val()
{
if(username_v() && password_v())
if(name_v() && add_v())
if(telno_v() && email_v())
return true;
return false;
}

function username_v()
{
if(document.auth.username.value=="")
{
alert("Please enter a valid username");
document.auth.username.focus();
return false;
}
return true;
}

function password_v()
{

if(document.auth.password.value=="")
{
alert("Please enter password");
document.auth.password.focus();
return false;
}

if(document.auth.cnfrmpwd.value=="")
{
alert("Please re-type password");
document.auth.cnfrmpwd.focus();
return false;
}

if(document.auth.password.value!=document.auth.cnfrmpwd.value)
{
alert("Please re-type password correctly");
document.auth.password.select();
document.auth.cnfrmpwd.value="";
return false;
}
return true;
}

function name_v()
{
if(document.auth.name.value=="")
{
alert("Please enter your name");
document.auth.name.focus();
return false;
}
return true;
}

function add_v()
{
if(document.auth.address.value=="")
{
alert("Please enter your address");
document.auth.address.focus();
return false;
}

if(document.auth.country.value=="")
{
alert("Please enter your country");
document.auth.country.focus();
return false;
}

if(document.auth.tel.value=="")
{
alert("Please enter your contact number");
document.auth.tel.focus();
return false;
}

if(document.auth.dateofbirth.value=="Date")
{
alert("Please select your Date of Birth");
document.auth.dateofbirth.focus();
return false;
}

if(document.auth.monthofbirth.value=="Month")
{
alert("Please select your Month of Birth");
document.auth.monthofbirth.focus();
return false;
}

if(document.auth.yearofbirth.value=="Year")
{
alert("Please select your Year of Birth");
document.auth.yearofbirth.focus();
return false;
}

if(document.auth.age.value=="")
{
alert("Please enter your Age");
document.auth.age.focus();
return false;
}
return true;
}

function telno_v()
{
if(document.auth.email.value=="")
{
alert("Please enter your email address");
document.auth.email.focus();
return false;
}
return true;
}

</script>

</td>
</tr>
</table></td>
</tr>
</table>
<p align="justify">The following form lists your details as provided. To update,
click the Update buttonx</p>

<p align="justify">Section 1: Login Information </p>
<blockquote>
<blockquote>
<p align="justify">In this section, you will be asked to enter a unique username
and password for identifying yourself to us. Please note that passwords are case
sensitive, so make sure you use the correct case.</p>
</blockquote>
</blockquote>

<form name="auth" onSubmit="return val()" action="updateuserdetails.asp?reg=1&user=<%=Request.QueryString("user")%>" method="post">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="82%" height="45">
<tr>
<td width="100%" align="center" height="45" colspan="2">
<p align="center">Username:
<input type="text" size="30" name="username" value="<%=rs2("username")%>" readonly></p>
</td>
</tr>
<tr>
<td width="50%" align="center" height="45">
<blockquote>
<blockquote>
<blockquote>
<p align="justify">Password:<br>
<input type="password" size="30" name="password" maxlength="15"></blockquote>
</blockquote>
</blockquote>
</td>
<td width="50%" align="center" height="45">
<blockquote>
<blockquote>
<blockquote>
<p align="justify">Confirm Password:<br>
<input type="password" size="30" name="cnfrmpwd" maxlength="15">
<input type="hidden" size="30" name="output"></blockquote>
</blockquote>
</blockquote>
</td>
</tr>
</table>
</center>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<ul>
<li>
<p align="left"><font size="2">Passwords are case sensitive</font></li>
<li>
<p align="left"><font size="2">Ensure the password length is of 8 characters minimum
and 15 characters maximum [<a href="javascript:password()">What's this?</a>]</font></li>
</ul>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<hr>
</blockquote>
</blockquote>

<p align="justify">Section 2: Personal Information</p>
<blockquote>
<blockquote>
<p align="justify">In this section, we require you to fill out a few
personal details for our records. We will not sell or give out your personal
information to any third party.</p>
</blockquote>
</blockquote>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>
<td width="50%" valign="top" align="center">Name:<br>
<input type="text" size="30" name="name" value="<%=rs2("name")%>"><p>Date of Birth:<br>
<input type="text" name="dateofbirth" size="12" value="<%=rs2("dateofbirth")%>"> /
<input type="text" name="monthofbirth" size="17" value="<%=rs2("monthofbirth")%>"> /
<input type="text" name="yearofbirth" size="14" value="<%=rs2("yearofbirth")%>"></p>
<p>Age:<br>
<input type="text" size="30" name="age" value="<%=rs2("age")%>"></p>
<p> </td>
<td width="50%" valign="top" align="center">E-Mail Address: <br>
<input type="text" size="30" name="email" value="<%=rs2("email")%>"><p>Country: <br>
<input type="text" size="30" name="country" value="<%=rs2("country")%>"></p>
<p>Contact Number: <br>
<input type="text" size="30" name="tel" value="<%=rs2("tel")%>"><br>
 </td>
</tr>
</table>
<br>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr>
<td width="100%">
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<p style="text-align: left">Address:</p>
<blockquote>
<p style="text-align: left">
<textarea rows="10" cols="36" name="address"><%=rs2("address")%></textarea></p>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<p> </td>
</tr>
</table>

<p>

You're done. Just click the register button to continue.<p>

<input type="submit" value="Update" onClick="javascript:str_to_num(this.form)">
<input type="reset" value="Reset"> <input type="button" value="Cancel" name="B1" onclick="location.href('/mediaguidehome.asp')"></FORM>
</HTML>

Similar Threads

How can i update a query that have more than 3 tables using adodc in vb? in Visual Basic 4 / 5 / 6
UPDATE query not working properly... in PHP
Need update query--Remove the coma "," in PHP
Update query (mysql) in PHP
Php newsletter error in PHP

goldeagle2005

Team Colleague

Reputation Points: 67

Solved Threads: 45

Finkus Stinkalotus

Offline

1,423 posts
since Jun 2005

Permalink

Oct 20th, 2005

Re: Error while trying the update query

any ideas ppl?

goldeagle2005

Team Colleague

Reputation Points: 67

Solved Threads: 45

Finkus Stinkalotus

Offline

1,423 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Check existing users in the database

Next Thread in ASP Forum Timeline: login check

DaniWeb Message

Cancel Changes

User Name
Password