The strange one we've come across is a dbms with <@if></@if> This dbms works perfectly for 100's/1000's of iterations, then mysteriously, the sql will fail for a single time and then go on and work perfectly...
our error checking shows the sql is perfectly formed. I am wondering if there is a timing conflict between tango and the odbc driver. in our other "pure" sql, there are no tango metatags (just vars) and we never have a problem. but in dbms that has <@if>, we've identified at least 2 cases where the dbms has failed (even though the debug showed no problem with the sql... we can cut/paste it and it works fine), while working properly 99.99999 majority of the time. the sql is doing a simple count of records, nothing esoteric... it sure looks like the <@if> is the culprit. <@if blah> sel count(*)...... <@else> sel count(*) ....... </@if> I am thinking we need to move the <@if> back out to tango action level, not keep them in the dbms. Anyone else have any similiar experience? Brent Skean Current Solutions -----Original Message----- From: Anthony M. Humphreys <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, February 11, 2003 7:51 AM Subject: RE: Witango-Talk: tango tags within DBMS actions >Often it's because of a typo in a tag, > or else a mis-matched tag pair, ie a @IF without a /@IF > or else an array is expected and the var is not an array or is empty > >Sometimes it's a bugger to find... > > > > >-----Original Message----- >From: Atrix Wolfe [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 10, 2003 7:32 PM >To: [EMAIL PROTECTED] >Subject: Witango-Talk: tango tags within DBMS actions > > >does anyone have any idea why tango tags within DBMS actions would stop >being processed? Im wondering if we tweaked a setting somewhere... > >thanks for the help! >Atrix >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
