I would love to be able to issues the necessary Mysql commands to have
true TRANSACTIONS
Such as - Begin Transaction
Select @var=agent.id, agent.exstension where
agent.status='free'
Update agent.status='BUSY' where [EMAIL PROTECTED]
End Transaction
Of Course the syntax I used above is just psuedo-code and NOT correct MySQL
but I think you can see what I am trying to do. Which I think would be
darn handy !!!
Tilghman Lesher wrote:
> On Friday 09 May 2008 01:39:53 Al Baker wrote:
>
>> Quote "
>>
>> func_odbc can do whatever queries you give it. SELECT/UPDATE are
>> simply the simplest cases that make it easy to understand the
>> functionality"
>>
>> *OK - but are the Limited to SINGLE STATEMETS or can you have a
>> Muli-Statemnt Transaction ?*?
>>
>
> As we don't isolate connections to a single channel, we do not support
> multi-statement transactions, no. It's an interesting idea, though. Could
> you expound on what you would like to see? It may wind its way into a
> future version of func_odbc.
>
> Perhaps only three extra statements, one to start a transaction, which
> also reserves the connection handle to the channel (note that this would
> require turning off connection sharing, which is the default, except for TDS
> databases), one to commit, and one to rollback (the last two here would
> also release the connection handle back to the pool). Would that be
> sufficient?
>
>
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
