Checking record exist

[stingman]

Hello:<br>
I am trying to make a signup page and I need to be able to check to make sure htat they arent already in the database but I cant quite figure out the code that I need to use I have seen lots of examples of reading from a database or just flat out inserting everything from a form but not actual record checking.<br>
Thanks in advance<br>
Steve<br>
<A HREF="mailto:Admin@asr.cx">Admin@asr.cx</A><br>
<A HREF="

http://www.asr.cx/"

TARGET="_new">

http://www.asr.cx/</A>

 

[craig]

Use the example that you have of reading from a database. That is all that you are doing by checking to see it the recrod is in the database. Query for the user, if you don't find them, add them, if you do, display a message. It's that simple. You can use the RecordCount property of GetResults (#GetResults.RecordCount#) to check for a match.<br>
<br>
Craig