popularanky
Posts: 53
|
| Posted: 08/03/2010, 3:03 AM |
|
I am looking for a serious help. I have looked round CCS and can find the solution.
I have about three forms on a page with different Database table (Educational profile, work profile). I want to use ONE Add button to add the forms into their tables in the database.
I will be glad if this solve 
_________________
EKERE UBONG UBONG
IT Officer
CognitiveDrive |
 |
 |
Oper
Posts: 1195
|
| Posted: 08/03/2010, 7:49 PM |
|
Not Possible (not cuase CCS)
its how HTML / Web Work
you will have to design only one Form
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
cvboucher
Posts: 191
|
| Posted: 08/09/2010, 8:57 AM |
|
You didn't say what database you are using but you may be able to create a stored procedure with parameters for fields from all three tables that inserts into all three tables. Then create a record form based on the stored procedure.
Craig
|
|
|
|
popularanky
Posts: 53
|
| Posted: 08/09/2010, 9:06 AM |
|
I am using MySQL DBMS
_________________
EKERE UBONG UBONG
IT Officer
CognitiveDrive |
|
|
|
cleyan
Posts: 136
|
| Posted: 08/18/2010, 12:21 AM |
|
maybe with ajax?
the button call a procedure that read the data in the forms and then save it in each table
_________________
**************************************************
Carlos Leyan B.
Temuco, Chile
www.leytec.net |
|
|
|
popularanky
Posts: 53
|
| Posted: 08/18/2010, 12:55 AM |
|
How, I don't know how to use ajax.
_________________
EKERE UBONG UBONG
IT Officer
CognitiveDrive |
|
|
|
ReneS
Posts: 225
|
| Posted: 08/18/2010, 11:49 AM |
|
Hi,
cvboucher gives you the easiest and best option in my opinion...
Go with a stored procedure,
Rene
|
|
|
|
popularanky
Posts: 53
|
| Posted: 08/19/2010, 12:45 AM |
|
I don't think MySQL allow Stored procedure.
_________________
EKERE UBONG UBONG
IT Officer
CognitiveDrive |
|
|
|
ReneS
Posts: 225
|
| Posted: 08/19/2010, 1:31 AM |
|
From version 5 MySql has stored procedures.
http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html
Which is great!
Rene
|
|
|
|
Oper
Posts: 1195
|
| Posted: 08/23/2010, 7:47 PM |
|
store procedure wont solve the issue of 3 form (just 1 Click)
you have to create only one form. and (use Custom Update, Insert in CS)
or dont allow to modify all 3 form at the same time. (but show them all)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
