4 messages in com.mysql.lists.plusplusRe: problem saving and retrieving an ...
FromSent OnAttachments
Steve Povilaitis10 Oct 2005 10:46 
Steve Povilaitis10 Oct 2005 11:41 
Warren Young10 Oct 2005 11:48 
Ovidiu Bivolaru10 Oct 2005 12:08 
Subject:Re: problem saving and retrieving an AUTO_INCREMENT value using MySQL variable and LAST_INSERT_ID()
From:Ovidiu Bivolaru (ovi@targujiu.rdsnet.ro)
Date:10/10/2005 12:08:38 PM
List:com.mysql.lists.plusplus

Hi Steve,

Keep the the insert_id() after each executed QueryParent in a variable which you can use later for storing in child queries.

PS: I will always forget to use Reply to All and my initial reply was not sent to the list too. Sorry!

Regards, Ovidiu

Steve Povilaitis wrote:

Thanks for the prompt reply! I also noticed another problem. From reading the mySQL documentation variable's aren't persistent across connections. Since I was using separate connections for the parent and child classes the variable isn't visible between the two. Thanks again for your help!

Steve

-----Original Message----- From: Ovidiu Bivolaru [mailto:ovi@targujiu.rdsnet.ro] Sent: Monday, October 10, 2005 2:13 PM To: Steve Povilaitis Subject: Re: problem saving and retrieving an AUTO_INCREMENT value using MySQL variable and LAST_INSERT_ID()

Hi Steve,

You could use: Connection::insert_id().

Regards, Ovidiu

Steve Povilaitis wrote:

Hi,

This is more of a mySQL question but I hope someone can help me out.

I'm trying to save the most recent AUTO_INCREMENT value from

a parent

table to use, later, in multiple records of a child table

that also has

an AUTO_INCREMENT field. My relevant code:

// In the parent class queryParent << "SET @sim_id = LAST_INSERT_ID()";

queryParent.execute();

// In the child class get the value of the last auto_inc

field from the

parent and insert into child

queryChild << "INSERT INTO child (simid) values (@simid)"; queryChild.execute();

Yet looking at the child table each record has a NULL value

for simid,

where I would expect the value from the parent table to be.

So either

I'm not setting or retrieving the MySQL variable properly. Any ideas?

Thanks in advance!

This e-mail and any attachments are provided through AEgis Technologies' e-mail services and may contain company

sensitive and/or

privileged information. If you are not the intended

recipient, please

notify the sender immediately by return e-mail, delete this

e-mail and

destroy any copies. Any dissemination or use of this

information by a

person other than the intended recipient is unauthorized and may be illegal.

This e-mail and any attachments are provided through AEgis Technologies' e-mail services and may contain company sensitive and/or privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal.