Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › How can I check if a record exists before inserting

How can I check if a record exists before inserting

Thread began 5/05/2009 5:40 am by doggyDivemaster | Last modified 6/03/2009 12:12 pm by doggyDivemaster | 15050 views | 25 replies

5/06/2009 9:25 amRay BorduinWebAssist

You create a recordset filtered by the form element, say the email address... then that recordset will set a record count variable. You use that variable in validation toolkit and validate it as a number that is equal to zero. If it isn't zero the validation fails.

This is how it is done in the User Registration Solution and the Powerstore solution if you happen to have them as examples.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.