[asterisk-users] Return variables from func_odbc calls?

[Paul Belanger]

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