Hi there.
I'll point you to a page on the Allaire site. It was posted in another cf-talk
message today, I think:
http://www.allaire.com/Handlers/index.cfm?ID=1463&Method=Full
This will also show you how to make sure concurrency issues don't affect the value
that is returned.
- Andy
> -----Original Message-----
> From: Aimee Abbott [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 4:09 PM
> To: CF-Talk
> Subject: insert to two tables
>
>
> Hello everyone.
>
> I have mostly worked on very simple, single table, cold fusion
> projects but
> now I need to do something where I need to add information into two
> tables. I have something like this:
>
> PeopleTable
> personID Autonumber
> name Text
> address Text
>
> AppointmentTable
> aptID Autonumber
> PersonID Number
> AptName Text
> AptDate Date/Time
>
> The information for both tables come from one entry form on a web
> page. I
> have a second page to do the insert. When I insert the person into the
> person table, how do I find out what the personID was so I can enter it
> into the AppointmentTable/PersonID? Or can I do some sort of
> more complex
> insert statement that inserts into both tables at once? What if I add a
> third table? Does it get more complex? Should I setup the join as a
> relationship in microsoft access?
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
