Gossamer Forum: Products: Gossamer Links: Discussions: How to get back the value of an auto

Jan 13, 2008, 5:59 AM

cwschroeder

User (179 posts)

Jan 13, 2008, 5:59 AM

Post #1 of 5

Shortcut

How to get back the value of an auto_increment field

I added a global which inserts some data in a new table Transaktion

Code:
sub {  
 my $tags = shift; 
 my $db = $DB->table ('Transaktion'); 
 my $sth = $db->insert ( {  
 TR_CustomerNo => $tags->{Kundennummer},  
 TR_CustomerRef => $tags->{BestNo}, 
 TR_LinkID => $tags->{ID}, 
 TR_Preis => $tags->{Preis} }); 
 return "transaktion_insert: $sth "; 
}

Now I want, that I get back the auto_incremet field in my table called TRNR. I thought like something with

Code:

  $db->select (  LAST_INSERT_ID() );

but GLinks does not support that.
Thanks a lot for your help,
Christian

Jan 13, 2008, 6:34 AM

Andy

Veteran / Moderator (17366 posts)

Jan 13, 2008, 6:34 AM

Post #2 of 5

Shortcut

Re: [cwschroeder] How to get back the value of an auto_increment field In reply to

Hi,

It depends on what your field name is. If its ID, it would be:

Code:
$db->select ( ['MAX(ID)'] )->fetchrow;

If its something else, it would be something like:

Code:
$db->select ( ['MAX(Field_Name)'] )->fetchrow;

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Jan 13, 2008, 9:09 AM

cwschroeder

User (179 posts)

Jan 13, 2008, 9:09 AM

Post #3 of 5

Shortcut

Re: [Andy] How to get back the value of an auto_increment field In reply to

Thanks a lot, thats it.

Christian

Jan 13, 2008, 10:06 AM

brewt

Staff (4071 posts)