Itamar
|
| Posted: 05/08/2002, 9:16 AM |
|
I have a page where a visitor have to fill there name and email before continuing to the next page.
I use 2 table 1 for porspects and the second for advertiser
Visitor orgin is tracked by $_GET[advertiser]
ie http://domain.com/?advertiser=100100
step 1 If !advertiser in TableAdvertiser --> error stop;
step 2 If exsit_in_Prospects --> nextpage;
step 3 If !exsit_in_Prospects --> insertProspects; nextpage;
step 3 is working using CCS
step 2 is coverd by MySQL since email in each prospect table is Indexed as Unique. Though I would like to know how to do it using CCS.
Step 1 I managed to do only by editing the code itself and make it work.
So what I would like to know is how can I do step 1 and 2 using CCS
Thanks
Itamar
|
|
|
 |
Nicole
|
| Posted: 05/09/2002, 5:09 AM |
|
Itamar,
I think you should create OnValidate event for the form.
I think you do not need a lot of custom code to implement what you want. The trick is you should open new connection first, then you'll be able to work with table. Use CCDLookUP uunction to find if record exists in table. You'll find CCDLookUp() in common file. The only difference from CC LookUP() function is CCS function requires forth parameter - dbconnection.
Depending on look up results you can redirect user to different pages.
If you need help with code let me know your programming language.
|
|
|
|
Itamar
|
| Posted: 05/12/2002, 9:25 PM |
|
that was very helpful
Itamar
|
|
|
|
|
