I used this approach when adding new users to my site. I simpy enter their userID, firstname, lastname and hit submit. The next page I see has their birtdate, contact information, etc. I took your approach and just removed the organization from it. Works like a champ and I no longer have keep two forms updated (insert form and an edit form) just as your titles suggests.
By: Rhino
<--- Your basic HTML form with two boxes for first and
last name --->
<html>
<head>
<title></title>
</head>
<body>
<center>
<form method="POST"
action="newposition.cfm">
<font face="Century Gothic"
size="2">
First: <input type="text"
name="firstname">
<br>
Last: <input type="text"
name="lastname" size="20"
tabindex="2">
<br>
<input type="submit"
value="Submit" name="B1"
tabindex="3">
</font>
</form>
</body>
</html>
<--- NEW FILE: newposition.cfm --->
<--- First you insert the three basic parts, or two, or just one. Here I do
three. --->
<cfquery name="[ queryname ]"
datasource="[ dsn ]">
INSERT INTO [ tablename ]
(
firstname,
lastname,
organization
)
VALUES(
'#firstname#',
'#lastname#',
'National Council'
)
</cfquery>
<--- Then we grab the highest ID from the DB, which
should be what was just entered --->
<cfquery name="[ queryname ]"
datasource="[ dsn ]">
SELECT MAX(ID)as newmem
FROM [ tablename ]
</cfquery>
<--- Now we go to the edit form to edit the information
related to the highest ID --->
<CFLOCATION URL="[same file
as used for updates].cfm?id=#[queryname].newmem#">
About This Tutorial
Author: Rhino
Total Views: 27,274
Submission Date: April 07, 2004
Last Update Date: June 05, 2009
All Tutorials By This Autor: 10
Skill Level: Beginner
Platforms Tested: CF5Total Views: 27,274
Submission Date: April 07, 2004
Last Update Date: June 05, 2009
All Tutorials By This Autor: 10
Discuss This Tutorial
-
-
National Council, not New Council.
-
I dont understand. You are adding a person with New Council as their organization but what if you didn't want their ogranization to be that? I understand what the page is doing but not how it would benefit me... Can you provide more details, please? From a tutorial standpoint, it is lacking so I rated it as two stars.
Advertisement
