getting a handle to the current ID using DBI

[carpeliam]

I've prepared and executed an "INSERT" statement, but now I want to insert the ID into another table as a foreign key. How do I get a handle on the ID that I just executed?

I'm using MySQL and the DBI.pm module. I appreciate any help that anybody can give me; if I haven't given enough information, please let me know. Liam Morley
imotic@hotmail.com
"light the deep, and bring silence to the world.
light the world, and bring depth to the silence."

 

[stillflame]

ooo. i tried to get an ID once, and i just couldn't figure out how to do it. you might try asking this questions on the DBI mailing list, which you can access through

http://www.symbolstone.com

. also, i don't have a copy of Programming the Perl DBI, but the answer might be in there (and it's a really good book otherwise).

sorry i couldn't be of more help :-( "If you think you're too small to make a difference, try spending a night in a closed tent with a mosquito."

 

[carpeliam]

I tried that URL, and the server could not be found.. is this a bad link, or is there a temporary problem with the server?<br><br>Thanks for helping.. <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;

 

[stillflame]

D'oh! try this

http://dbi.symbolstone.org

heh.. &quot;If you think you're too small to make a difference, try spending a night in a closed tent with a mosquito.&quot;

 

[carpeliam]

Hmm... that doesn't seem to be working either, although my browser recognized the URL- apparently I've been to pages in this domain before (probably the last time I was looking for something, it came up on a Google search).. might be down temporarily, or maybe my ISP is having problems. Thanks, though.. <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;