If you do not want to do it in the db, you will need two queries. The first does the primary table insert and returns the auto generated key value. Then you can use that in the second insert query.
Tracy Spratt, Lariat Services, development services available _____ From: [email protected] [mailto:[email protected]] On Behalf Of johndoematrix Sent: Friday, April 03, 2009 9:46 AM To: [email protected] Subject: [flexcoders] Re: database question i would like to do it with a coldfusion query. i dont want the database to do it automatically. the thing is this, i want to insert data in the two tables at once and i would like that the primary key(auto number) in table A be reflected in table B as soon as the data is inserted. thanks
