[Freeswitch-users] dbh:query - insert id

[Seven Du]

Maybe try the RETURNING clause ? 

-- 
Seven Du
http://www.freeswitch.org.cn
http://about.me/dujinfang
http://www.dujinfang.com


Sent with Sparrow (http://www.sparrowmailapp.com/?sig)


On Saturday, May 25, 2013 at 8:14 AM, Lloyd Aloysius wrote:

> Hello All
> 
> How to get the id value after insert a record a record using dbh:query
> 
> table_a - columns. 
> 
> id - auto increment
> field1
> field2
> 
> 
> dbh:query("insert into table_a ( field1,field2) values ('11','Test')")
> 
> 
> After insert how to get the table_a - id value for the inserted record?
> 
> Thanks
> Lloyd
> 
> 
> 
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org (mailto:consulting at freeswitch.org)
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org (mailto:FreeSWITCH-users at lists.freeswitch.org)
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130525/a192c916/attachment.html