| | |
Registration form help
Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jul 2004
Posts: 1
Reputation:
Solved Threads: 0
I can't seem to find a tutorial or anything about this kind of registration form. It is extremely urgent, so any help is *greatly* appreciated.
Ok, i have a registration form needing to submit the following information:
DSN: userlogin
User_ID: i want this submitted to all the tables in my database. It's not an autonumber.
Align_Name: I want this submitted to the alignment table only.
And last, I want the email, password, and user_name submitted to the registration_form table.
Also if you have any other tips - THANKS!
Ok, i have a registration form needing to submit the following information:
DSN: userlogin
User_ID: i want this submitted to all the tables in my database. It's not an autonumber.
Align_Name: I want this submitted to the alignment table only.
And last, I want the email, password, and user_name submitted to the registration_form table.
Also if you have any other tips - THANKS!
•
•
Join Date: Jul 2004
Posts: 8
Reputation:
Solved Threads: 0
This should get you started
<cfform Action= "Put the name of the page that your insert query is on" Method= "Post" Name="InsertCustInfo" enablecab="Yes">
First Name: <input type="text" Name="FName">
Last Name: <input type="text" Name="LName">
EMail: <input type="text" Name="Email">
UserName: <input type="text" Name="UserName"></td></tr>
Password: <input type="text" Name="Password">
<td><INPUT type ="Submit" Value ="Submit"></td>
</cfform>
Query page
<cfquery datasource="myDSN" name="GetCustInfo">
INSERT INTO CustTable (CustFirstName, CustLastName, CustAddress, CustCity, CustZipCode, UserName, Password, Password2)
VALUES ('#Form.FName#', '#Form.LName#', '#Form.Email#', '#Form.UserName#', '#Form.Password#')
</cfquery>
<cfform Action= "Put the name of the page that your insert query is on" Method= "Post" Name="InsertCustInfo" enablecab="Yes">
First Name: <input type="text" Name="FName">
Last Name: <input type="text" Name="LName">
EMail: <input type="text" Name="Email">
UserName: <input type="text" Name="UserName"></td></tr>
Password: <input type="text" Name="Password">
<td><INPUT type ="Submit" Value ="Submit"></td>
</cfform>
Query page
<cfquery datasource="myDSN" name="GetCustInfo">
INSERT INTO CustTable (CustFirstName, CustLastName, CustAddress, CustCity, CustZipCode, UserName, Password, Password2)
VALUES ('#Form.FName#', '#Form.LName#', '#Form.Email#', '#Form.UserName#', '#Form.Password#')
</cfquery>
![]() |
Similar Threads
- registration form - check if username is taken (PHP)
- registration form not connecting to database (ASP.NET)
- Registration form,where is my mistake (JavaScript / DHTML / AJAX)
- Registration form,where is my mistake (Java)
- Any recommendations on an easy to follow php registration form tutorial? (PHP)
- Registration form (MySQL)
- Product Registration Code! (Visual Basic 4 / 5 / 6)
- Help With Registration Form (JSP)
Other Threads in the ColdFusion Forum
- Previous Thread: Setting up user name and password
- Next Thread: IF statement
| Thread Tools | Search this Thread |





