William, Thank you for the reply. Question was related to freeswitch dbh driver. Not related to sql specific. Most of the SQL Driver have a method to get the id after the insert record. My questions was does freeswitch dbh have any method to get the id? For Example dbh have a method dbh:affected_rows() for insert , update. Like this do we have a method for ID? Thanks Lloyd * * * <http://www.sunteltech.ca/blog/>* On Sat, May 25, 2013 at 10:23 AM, John M <j_mj@aol.com> wrote:
Yep, super helpful.. /sarcasm
Point us to general sql related pages, none of which are related to freeswitch and the way the language interacts with the db ..
We all know that insert_id exists that's why we are asking. What we don't know is how specifically the freeswitch:dbh handler interacts and can return the inserted record id.
-----Original Message----- From: William King <william.king@quentustech.com> To: freeswitch-users <freeswitch-users@lists.freeswitch.org> Sent: Sat, May 25, 2013 11:24 pm Subject: Re: [Freeswitch-users] dbh:query - insert id
http://lmgtfy.com/?q=sql+returning+clause http://en.wikipedia.org/wiki/Insert_%28SQL%29#Retrieving_the_key http://www.postgresql.org/docs/9.2/static/sql-insert.html
Much less useful unless you have no other choice than to use mysql:http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_l...
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com
On 05/24/2013 08:59 PM, John M 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 ?
-- 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@freeswitch.org <mailto:consulting@freeswitch.org <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 <mailto:FreeSWITCH-users@lists.freeswitch.org <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 <mailto:consulting@freeswitch.org <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 <mailto:FreeSWITCH-users@lists.freeswitch.org <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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services:consulting@freeswitch.orghttp://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ 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