Hi,
I want to validate the value entered in a textbox against the values of a field from a table. The value entered must not be duplicate. Can I scan a table using Javascript.

Well, couldn't get exactly what you are asking for? Are you trying to say that you have fetched value of a field from the database, stored it somewhere, and then trying to compare it with the user entered value in the textbox?

Regards
Mike

Don't expect too much, too soon.

Hi,
Say the Product Name is entered in a text box. The product name must be unique. So I'd like to compare it with the values of the ProductName field (from Products table)for duplicate values.

Well, that can't be done using javascript, for that you have to implement a check in your stored procedure, an e.g. can be as below:

IF EXISTS(SELECT TOP 1 1 FROM products WHERE productname = @productname)
    BEGIN
        RETURN -2
    END

The above means that if product name already exists the SP will return -2, then you can check the return code in your programming, and display the message for duplicate product name if return code is -2. Do let us know if you need a sample SP for inserting a new product in products table keeping in mind duplicate values.

Regards
Mike

Don't expect too much, too soon.