Hi,
Thanks for your reply. Ok, I have tried adding your code but I'm
still getting this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'user_id='.
/kathryn/doCheckout.asp, line 20
Here's my updated page:
<%
Dim strUserID
strUserID = Request.Cookies("username")
If Len(Trim(strUserID)) = 0 Then
'Redirect to login page, cookie doesn't exist.
Response.Redirect("Login.asp")
End If
Dim strUserName
strUserName = Request.Cookies("username")
' Retrieve Registration Information
Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "accessDSN"
sqlString = "SELECT * FROM users " &_
"WHERE user_id=" & userID
Con.Execute( sqlString )
IF NOT RS.EOF THEN
street = RS( "user_street" )
city = RS( "user_city" )
county = RS( "user_county" )
postcode = RS( "user_postcode" )
country = RS( "user_country" )
END IF
%>
<html>
<head><title>Check Your Address Details</title></head>
<body>
<center>
<table border=1 width=500
cellpadding=5 cellspacing=0>
<tr>
<td align="center" bgcolor="lightgreen">
<b>Confirm Order</b>
</td>
</tr>
<tr>
<td>
Your order will be sent to the following address
and charged to the following credit card.
Please review your address and payment information
and click Confirm Order to finish placing your order.
<form method="post" action="checkout2.asp">
<input name="username" type="hidden"
value="<%=username%>">
<input name="password" type="hidden"
value="<%=password%>">
<font face="Arial" size="2" color="darkgreen">
<p><b>Address Information:</b>
</font>
<font face="Courier" size="2">
<br><b>street:</b>
<input name="street" size=20 maxlength=50
value="<%=Server.HTMLEncode( street )%>">
<br><b>city:</b>
<input name="city" size=20 maxlength=50
value="<%=Server.HTMLEncode( city )%>">
<br><b>state:</b>
<input name="state" size=20 maxlength=2
value="<%=Server.HTMLEncode( state )%>">
<br><b>zip:</b>
<input name="zip" size=20 maxlength=20
value="<%=Server.HTMLEncode( zip )%>">
</font>
<p><input type="submit" value="Confirm Order">
</font>
</form>
</tr>
</table>
<p>
--- In [email protected], Mark E
<[EMAIL PROTECTED]> wrote:
> Try putting this at the top of your doCheckout or the
> page name that's not retreiving the user name:
>
> Dim strUserName
> strUserName = Request.Cookies("username")
>
> Then your SQL statement should populate with the
> username.
>
> Also, you will need to add code to check for the
> existance of the cookie. The user may delete it or it
> may expire and you would be stuck in the same
> situation.
>
> So before you do anything, check for a cookie value:
>
> Dim strUserID
> strUserID = Request.Cookies("username")
> If Len(Trim(strUserID)) = 0 Then
> 'Redirect to login page, cookie doesn't exist.
> Response.Redirect("Login.asp")
> End If
>
> '*** continue with your existing code...
>
> Mark
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
