Two things: 1. Have you the syntax checker? 2. Can you click open the advanced button on the IF action and post the actual code that Witango is seeing
-- Bill ---------- Original Message ----------- From: David Green <[EMAIL PROTECTED]> To: [email protected] Sent: Mon, 12 Feb 2007 13:41:58 -0500 Subject: Re: Witango-Talk: Upgrading from Witango 5.0 to Witango 5.5 - Syntax Errors > Yep, sure did. Same error. > > Thanks, > > David Green > [EMAIL PROTECTED] > Web Services > Systems Insight, Inc. > http://www.systemsinsight.com/ > > William M. Conlon wrote: > > Have you tried expanding these to the full metatag expressions: > > > > @@request$MLS_Records[<@CALC "@@request$i - 1">,12] > > @@request$MLS_Records[@@request$i,12] > > > > > > <@VAR SCOPE="request" NAME="MLS_Records[<@CALC EXPR='<@VAR SCOPE="request" NAME="i"> > > - 1'>,12]"> > > <@VAR SCOPE="request" NAME="MLS_Records[<@VAR SCOPE='request' > > NAME='i'>,12]"> > > -- > > Bill > > > > > > > > ---------- Original Message ----------- > > From: David Green <[EMAIL PROTECTED]> > > To: [email protected] > > Sent: Mon, 12 Feb 2007 13:23:19 -0500 > > Subject: Re: Witango-Talk: Upgrading from Witango 5.0 to Witango 5.5 - > > Syntax Errors > > > >> Hi Guys, > >> > >> I work with Adam and I'm trying to help him with the upgrade. I > >> wanted to give a little more info since the last email from support. > >> We're upgrading from Server 5.0 to 5.5 because of the database > >> upgrade from Pervasive.SQL 2000 to 9.5. For some reason, we cannot > >> get ODBC to work in the 5.0 scenario and are forced to upgrade > >> Witango so that we can use JDBC. That's what started all this. > >> > >> The error Adam is referring to is in an application that is running > >> in production on 5.0 just fine with the same exact data. We've > >> installed > >> 5.5 on a test server and changed the datasources to JDBC and now > >> we're receiving this error. > >> > >> ----------------------------- > >> Error > >> An error occurred while processing your request: > >> File: html_mailer.taf > >> Position: If_Write_County_Header > >> Class: Internal > >> Main Error Number: -18 > >> > >> Error during expression evaluation. > >> Closing bracket missing in statement [(""!="BOONE] > >> ----------------------------- > >> > >> This is an IF ACTION and is very simple. The code simply compares > >> the two values to verify that they're not the same. These are the > >> two values: > >> > >> @@request$MLS_Records[<@CALC "@@request$i - 1">,12] > >> @@request$MLS_Records[@@request$i,12] > >> > >> Notice in the Witango error the first value is empty and the second > >> is BOONE. For some reason, Witango is cutting off end quote and > >> parenthesis. And you can see in this specific instance, there isn't > >> any quotes in the values themselves. > >> > >> The thing that's driving us crazy is that it's worked just fine on 5.0. > >> > >> I know this is kind of the same thing Adam has already reported, I > >> just wanted to put it back out there again, because we're getting no > >> where. > >> > >> Also, I tried using the suggestion that the Witango Support offered, > >> but still no change. In fact, the exact error from above is produced. > >> > >> Any help? Anyone? > >> > >> Thanks, > >> > >> David Green > >> [EMAIL PROTECTED] > >> Web Services > >> Systems Insight, Inc. > >> http://www.systemsinsight.com/ > >> > >> Customer Support wrote: > >>> Adam, > >>> This issue is probably due to one of the array elements of the variables > >>> containing a single quote. You can fix this by using an encoding on the > >>> variables. > >>> > >>> e.g. > >>> ('<@VAR request$MLS_Records[@@request$i,12] ENCODING="HTML">'!='<@VAR > >>> request$MLS_Records[@@request$i,11] ENCODING="HTML">' > >>> <mailto:'@@request$MLS_Records%5B@@request$i,12%5D'!='@@request$MLS_Records% > > 5B@@request$i,11%5D'>) > >>> You can also try URL instead of HTML encoding and you could also try > >>> removing the quotes from the expression in the if action. > >>> > >>> Regards > >>> > >>> Witango Support > >>> > >>> On 10/02/2007, at 2:44 AM, Adam Leisring wrote: > >>> > >>>> Actually Robert, I had installed 5.5.020 but once I couldn't seem to > >>>> get around this issue I uninstall the server and re-installed > >>>> 5.5.009. It DID correct the specific issue that I was working on, but > >>>> another similar issue dealing with "Closing bracket missing at end of > >>>> statement" showed up in another application. So the 'downgrade' did > >>>> fix one of our issues, but others still remain - all dealing with the > >>>> way it's parsing. I've opened the actual XML up to verify the closing > >>>> brackets are there, and they look correct. It seems the remaining > >>>> issue deals only with IF actions... > >>>> > >>>> Adam > >>>> > >>>>>>> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 02/08/07 07:58PM >>> > >>>> We are tracking a bug, that appeared in 5.5.020. Did you upgrade to > >>>> 5.5.020, or 009? I am guessing, 020. I bet, you don't have the issue > >>>> with 009. I would like to know if you check. > >>>> > >>>> -- > >>>> > >>>> Robert Garcia > >>>> President - BigHead Technology > >>>> VP Application Development - eventpix.com > >>>> 13653 West Park Dr > >>>> Magalia, Ca 95954 > >>>> ph: 530.645.4040 x222 fax: 530.645.4040 > >>>> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> - > >>>> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > >>>> http://bighead.net/ - http://eventpix.com/ > >>>> > >>>> On Feb 6, 2007, at 8:19 AM, Adam Leisring wrote: > >>>> > >>>>> Hello everyone, > >>>>> > >>>>> We're in the process of upgrading our Witango Server from 5 to 5.5 > >>>>> and we've encountered an odd issue. Applications that work > >>>>> properly in the 5 environment are throwing Syntax errors. > >>>>> Specifically, it deals with 'Missing closing brackets' and 'Missing > >>>>> quote at the end of the statement' kinds of problems. Again, these > >>>>> applications work without issue in the 5 environment. > >>>>> > >>>>> Has anyone encountered something like this? Am I missing a > >>>>> configuration option? Is there a conversion application I should > >>>>> run against the Witango 5 applications to bring them up to 5.5? > >>>>> > >>>>> Any help is greatly appreciated! > >>>>> > >>>>> Thanks, > >>>>> Adam Leisring > >>>>> Fischer Homes, Inc. > >>>>> ______________________________________________________________________ > >>>>> __ > >>>>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >>>> ________________________________________________________________________ > >>>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >>>> > >>>> ________________________________________________________________________ > >>>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >>> ________________________________________________________________________ > >>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> ________________________________________________________________________ > >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ------- End of Original Message ------- > > ________________________________________________________________________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ------- End of Original Message ------- ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
