ensuring that I'm getting the correct "last insert ID"

2002-05-02 Thread Jonnycattt
Hi all, I know this has been asked a bunch of times, but i need some clarity (new mySQL user). I have an app that inserts a new user into one table, then inserts some user preferences into another table. the procedure is as follows: 1) insert new user 2) query for that user's id using select max(u

Re: Re: Re: ensuring that I'm getting the correct "last insert ID"

2002-05-02 Thread Jonnycattt
Gotcha. So far, selecting the last_insert_id() is working. I'll see what the CF forums have to say. thanks. --- Original Message From: "Jeff Kilbride" To: "Jonnycattt" CC: Subject: Re: Re: ensuring that I'm getting the correct "last insert I