[Freeswitch-users] dbh:query - insert id

[John M]

I'd like to offer an apology to you Seven and to the list in general for an inappropriate comment I made about your offer of free assistance regarding the dbh insert id.

My comment was rude and uncalled for and I will behave more appropriately in the future.

The mailing list is an invaluable source of help and any offers of assistance large or small should be accepted graciously.

I hope you will accept this apology.

Humbly, sincerely,
John

 

 

 

-----Original Message-----
From: Seven Du <dujinfang at gmail.com>
To: FreeSWITCH Users Help <freeswitch-users at 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


                                 
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
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
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 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
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/20130528/69b5477a/attachment.html