I have seen many ways to do this and I have instituted a
'poor mans' way of
doing it, but doesnt anyone know a complete method to be able
to insert an
entry into a database and then turnaround and grab the id key
to pass along
to the next page?
I am seeking a way to do it with MySQL and MS SQL (if that
difference) but using CF / SQL.
What I am refering to (and I may be wrong and you supplied
the right answer)
is this senerio.
My user, demo, creates a project using a 2 step form.
Fills in information such as project name, due date, client,
type and clicks 'continue'.
That information is inserted into the database (project
table) and they are
taken to another form to finish the project information.
The second form captures the project_id (key and auto
increment) that was
just inserted and when the user completes the second form
it update the data in the project table.
Currently I have it where the 2nd page queries the database
for the last
entry by that username (in this case: demo) and gets the
way. However, I don't think it is the most effective way to