Re: dbh:query - insert id
Thanks for your description, it is much appreciated.

5 word one liners from people too lazy to explain properly would really be best if they didn't reply at all.
Cheers, thanks again.
-Jm
From: Daniel Ivanov <sertys-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
To: FreeSWITCH Users Help <freeswitch-users-PD4FTy7X32k3T7AR8gHRW2D2FQJk+8+b@public.gmane.org>
Sent: Sat, May 25, 2013 5:57 pm
Subject: Re: [Freeswitch-users] dbh:query - insert id
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 <at> gmail.com>
To: FreeSWITCH Users Help <freeswitch-users-PD4FTy7X32k3T7AR8gHRW2D2FQJk+8+b@public.gmane.org>
Sent: Sat, May 25, 2013 12:52 pm
Subject: Re: [Freeswitch-users] dbh:query - insert idMaybe try the RETURNING clause ?On Saturday, May 25, 2013 at 8:14 AM, Lloyd Aloysius wrote:Hello AllHow to get the id value after insert a record a record using dbh:querytable_a - columns.id - auto incrementfield1field2dbh:query("insert into table_a ( field1,field2) values ('11','Test')")
After insert how to get the table_a - id value for the inserted record?ThanksLloyd_________________________________________________________________________Professional FreeSWITCH Consulting Services:FreeSWITCH-powered IP PBX: The CudaTel Communication ServerOfficial FreeSWITCH SitesFreeSWITCH-users mailing list
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting-YF8E+gPBBv73h3GqohbjpQ@public.gmane.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 <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
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting-YF8E+gPBBv73h3GqohbjpQ@public.gmane.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 <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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@... 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@... http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
RSS Feed