Benign
Posts: 6
|
| Posted: 08/04/2006, 10:38 PM |
|
Hi everybody:
I need to make a multi step registration form with 3 pages and 3 tables(each table for each form) and the table one is related to the others with a one-to-many relation ship. I mean the primary key for table one is foreign key for two othe tables.
Please help me find a soultion. Please give me a hand it is very critical for me.
Thanks
Benign
|
 |
 |
kevind
Posts: 251
|
| Posted: 08/10/2006, 5:57 PM |
|
what CCS version are you using ?
what is your Language ? ASP ? PHP ?
what is the backend database ? Access, SQL, MySQL ?
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 08/10/2006, 8:39 PM |
|
Benign
You might want to check out the included CodeCharge Studio Example Pack. Try these links: http://examples.codecharge.com/ExamplePack/MultiStepReg...trationGrid.php
http://examples.codecharge.com/
|
|
|
|
Benign
Posts: 6
|
| Posted: 08/11/2006, 2:14 AM |
|
Hi:
I use Codecharge 3.0,
I use Coldfusion as my server side technology,
And I use MS Access as my DB.
Thanks
Benign
|
|
|
|
Benign
Posts: 6
|
| Posted: 08/11/2006, 2:16 AM |
|
I have seen the examples but the problem is the example is made for one table while I want to use a multi page registration form (wizard like form) that insert data into different table (which have one-to-many relationships)
Thanks
Benign
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 08/11/2006, 2:58 AM |
|
You've seen the examples and understand them.
If so, then you will be able to do what you describe.
Just (in your mind) split it into two separate actions, get the one working and then do the same for the other,
Basically you let the form add the main table and then directly after the succesful insert, store the primary id from that table and write your own inserts for the other two tables.
It's not that hard, assuming you understand what is happening in the example.
(this is ment to stimulate you)
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
