Allen Patrick
|
| Posted: 06/18/2002, 9:20 AM |
|
I am trying to write a registration form in codecharge studio that will take two values the user enters into the form and does a lookup to another table. If the query is sucsessful and they entered the right varification information. I want to approve them to use the system automatically . Basically they enter an organization id along with a barcode that they should already know. Then the form would do a lookup to another table and make sure that the record exists, and if it does it would varify the first name, last name, and data of birth from the other table. Then if every thing matched I would set the appoved field to 'Y'. If someone could post an example of how to do this it would be a big help. I am using php4.
Thanks
|
|
|
 |
Nicole
|
| Posted: 06/20/2002, 7:06 AM |
|
Allen,
I do not have working example, but I suppose the problem is related to lookup queries need to verify entered information and to assign appropriate value to approved field.
Please try the code like below in Before Execute Insert and/or Before Execute Update events:
global $form_name;
global $DBconnection_name;
$name = CCDLookUp("project_name", "projects", "project_id=".$DBconnection_name->ToSQL($form_name->project_id->Value, ccsInteger), $DBconnection_name);
if ($name != "")
$form_name->bool->SetValue(1);
|
|
|
|
|
