Maybe try the RETURNING clause ?

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

Sent with Sparrow

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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org