I actually was pondering that same thing :D On Wed, Jan 26, 2011 at 7:33 AM, Paul Belanger <pabelan...@digium.com> wrote: > On 11-01-26 08:19 AM, Sherwood McGowan wrote: >>> While, LAST_INSERTID(); is a MySQL-ism, I've been able to use it with >>> func_ODBC. Of cource, my database is MySQL and this function would not >>> work on anything else. >>> >>> [CREATECALL] >>> dsn=Example >>> writesql=INSERT INTO x (y) VALUES (z) >>> readsql=SELECT LAST_INSERT_ID(); >>> >> >> Hey, thanks for the tip Paul! >> > I should also note, make sure you create a 2nd DSN for your specific > ODBC commands that will use LAST_INSERT_ID(), otherwise if you are using > ODBC CDR or CEL, there is a chance LAST_INSERT_ID() will return the ID > of those records. > > -- > Paul Belanger > Digium, Inc. | Software Developer > twitter: pabelanger | IRC: pabelanger (Freenode) > Check us out at: http://digium.com & http://asterisk.org > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
