MadPhilly
Posts: 19
|
| Posted: 10/01/2007, 8:41 AM |
|
Hi,
I'm an absolute newbie to CCS other than auto-creating some pretty easy ASP pages!
What I would like to do is validate an entry in a textbox by looking up the entered value in another table of the database. The ways I've found so far via 'Events - On Change' only allow regular expressions or masks.
The scenario is, this textbox field is a Part Number which has many different patterns so a pattern match was out. We have a table listing all products and I want to make sure that what the user enters matches a valid product in the product table.
If the part number is incorrect, an error msg should popup saying so. But I would like this when the field is entered, not when the form is submitted.
Any idea's?
Thanks in advance
Andy
|
 |
 |
Nicole
Posts: 586
|
| Posted: 10/02/2007, 3:04 AM |
|
Hello,
You can try to use the approach that is described in CCS example "Retrieving fields values from the server on the fly"
http://examples.codecharge.com/CCSExamplePack2/Retrievi...ieldsValues.php
The idea is to open a pop up window when user enters a value into textbox. On the opened window validate this value and return validation result to the parent window. Then depending on it alert error message and clean the filled value or just let user continue editing form.
_________________
Regards,
Nicole |
|
|
|
MadPhilly
Posts: 19
|
| Posted: 10/03/2007, 6:18 AM |
|
Thanks for the quick reply Nicole.
I tried to go through the tutorial but it doesn't seem to match up with what actually happens in the application.
Also I'm finding it confusing how to adapt this for my needs.
|
|
|
|
|
