It is true that the luasql driver is overly basic and poorly documented . Unfortunately mysql doesn't support RETURNING clause like pgsql and oracle. You should however try SELECT LAST_INSERT_ID(); right after the insert query. I cannot guarantee it works due to the unknown nature(to me that is) of the luasql transaction handling, but it should keep a transaction open for as long as a db handler lives.

On May 25, 2013 7:03 AM, "John M" <j_mj@aol.com> wrote:
Hi Seven Du,

I'd really like to know if this is possible too, couldn't find it documented anywhere.

Instead of being cryptic, if you know the answer won't you please help by explaining what the RETURNING clause is and how to use it?

Does it somehow return mysql_insert_id()?

How should we use it.

You help is invaluable and is contributing to the freeswitch community.

-Jm


-----Original Message-----
From: Seven Du <dujinfang@gmail.com>
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Sent: Sat, May 25, 2013 12:52 pm
Subject: Re: [Freeswitch-users] dbh:query - insert id

Maybe try the RETURNING clause ?
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:

FreeSWITCH-powered IP PBX: The CudaTel Communication Server

Official FreeSWITCH Sites

FreeSWITCH-users mailing list
 

_________________________________________________________________________
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

_________________________________________________________________________
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