Not in database?

[dagaffer]

Hi,
I have a form sending the information in it to the same page, how would i check if the info the users put in2 the form is in a database?

Thanx, Gaffer:thumbsup:

[Phip]

put this in your submition form:
<input type="hidden" name="doInput" value="1">


use this to see if it was submited:
IF doInput <> "" Then ' if doInput is different then nothing ("") then it will do

INSERT INTO DATBASE

END IF

[whammy]

Actually, you'd check if the recordset is at EOF (end of file).

I would be more specific, but you weren't... so I'll just give you an example:


MYQUERY = "WHATEVER"
rs = Conn.Execute(MYQUERY)

If NOT rs.EOF Then
Do While NOT rs.EOF
' Display some records here
rs.MoveNext 'This is an important line otherwise it will kill the server!
Loop
Else
Response.Write("No Records Found!")
End if