[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-plusplus
Subject:    Re: problem saving and retrieving an AUTO_INCREMENT value using MySQL
From:       Ovidiu Bivolaru <ovidiu () targujiu ! rdsnet ! ro>
Date:       2005-10-10 19:09:00
Message-ID: 434ABC4C.5050802 () targujiu ! rdsnet ! ro
[Download RAW message or body]

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:ovidiu@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.
>  
>


-- 
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    http://lists.mysql.com/plusplus?unsub=mysql-plusplus@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]