Form Validation - if value already exists

I have the SuperSuite, and I'm wanting to validate a particular form field to make sure that the entered value doesn't already exist in the database.
I know that I can go to the Server Behaviors panel choose WA Validation Toolkit > Server Validation, but it doesn't seem like it has the option I'm looking for.
Does that really not exist, or am I just blind?

I just realized that I put this thread in the eCart forum... sorry about that, can somebody move it for me?

create a recordset to lookup the value that was entered in the database.


Add server validation. Set the server variable to "$totalRows_RecordsetName" where RecordsetName is the name of the recordset.

Use number validation. set the minimum to -1 and the maximum to 0.

I tried what you explained, but it doesn't really work. I think it is because the "value" I want to validate isn't a number (I should have made that clear before). Will this work with varchar, or only numbers? If it only works with numbers, how can I do this with alphabet characters?

it doesn't matter if the value is a number or not.


the idea is that you create a recordset to lookup the value that is entered, the recordset returns a variable named $totalRows_RecordsetName, this contains the number of rows in the recordset.


the numeric validation is making sure that the $totalRows_RecordsetName is equal to 0, which would mean the recordset is empty, the recordset would be empty if the entered value is not found in the database.

send a copy of your page so i can look at the code.

Here's my file.

code order is the problem


the code order goes like this on your page:

Server Validation
Insert record
Recordsets


the code needs to be rearranged so the code order is:
recordsets
Server Validation
Insert record

NICE! Works great now.
Thanks!

glad to hear it is working.