June 18th, 2012, 04:30 PM
|
|
Registered User
|
|
Join Date: Jun 2012
Posts: 17
Time spent in forums: 4 h 1 m 32 sec
Reputation Power: 0
|
|
|
Conditional Statement Not Working...
What's wrong with this syntax?
Code:
<%
saleid = Request.QueryString("saleid")
Response.Write(saleid)
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("users.mdb")
set rs = server.CreateObject ("ADODB.Recordset")
rs.open "SELECT * FROM Sales ", conn, 3,3
do while not rs.EOF
Response.Write(rs.Fields("id"))
If rs.Fields("id") = saleid then
Response.Write(rs("id"))
Response.Write(rs("level2id"))
Response.Write(rs("itemdesc"))
Response.Write(rs("itemprice"))
Response.Write(rs("saletime"))
else
Response.Write("xxx")
end if
rs.Movenext
loop
set rs = nothing
set conn = nothing
%>
I am not getting an error, but this is what it outputs:
2121xxx22xxx23xxx24xxx26xxx27xxx28xxx29xxx31xxx32xxx33xxx
You can see that saleid DOES equal rs.fields("id") for the first field in database.
Thanks!
Gabriel
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
