HOW TO GET A RECORD VALID

[100dtl]

mySQL ="select top 1 EMAIL, password from customers where email = '"&Request.Form("email&quot&"'"
Response.Write mySQL

set rstemp=conntemp.execute(mySQL)

if rstemp.eof then
....
else



...How come my above code goes to 'else' even though running it in access query box it returns a result?

 

[alsoknownas]

do you only have 1 record in your database? and are you selecting top 1 because you want to retrieve the last record you inserted??

it would probably be better for you to either loop thru the recordset and or sort the table descentding

Just a thought

[/tt]

 

[100dtl]

fix ed it