checking for a record, if not say so 1

[derwent]

People need to enter their login id to progress to the next page. My script works ok if they enter a valid number however if they enter a wrong login that isn`t in the DB, I get an unfriendly error message. Is there a way to check first if the login is correct and if not display a friendly message.

I have

SQL = "SELECT * FROM logins where id = " & request.form("loginid")
set rs = server.CreateObject("ADODB.RECORDSET")
rs.open SQL,objConn, 3,3

which returns

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/login/index,asp, line 18

(line 18 is the rs.open line)

 

[DotNetGnat]

SQL = "SELECT * FROM logins where id = " & request.form("loginid")
set rs = server.CreateObject("ADODB.RECORDSET")
rs.open SQL,objConn, 3,3

if rs.BOF and rs.EOF then
response.write " Sorry, Invalid Login. Please try again"
else
response.redirect "main.asp"
end if

-DNG

 

[tsuji]

Also quote the string id.
>...where id = " & request.form("loginid")
[tt]...where id = [red]'[/red]" & request.form("loginid") [red]& "'"[/red][/tt]

 

[derwent]

aha, that was it tsuji, thanks

 

[DotNetGnat]

that would solve the problem of getting the records...but still if there are no records returned...you need to do the if condition that i suggested...

-DNG