I do the same!
> -----Original Message-----
> From: Jason Green [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 5:40 PM
> To: CF-Talk
> Subject: Re: insert to two tables
>
> i have had this issue before and the only way i could come up with it is
> insert into the peopletable and then query it with the same info you just
> inserted, thus giving you the id of that person....then insert into the
> appointment table....
>
> it's a pain, but i haven't found an easier solution
>
> jason
>
>
> >From: Aimee Abbott <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: insert to two tables
> >Date: Thu, 05 Apr 2001 14:08:41 -0600
> >
> >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
