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.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

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


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.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw