Grasping at straws ... Why are you comparing the HTML encoded values? It seems inefficient. But just maybe, the raw comparison will work?
-- Bill ---------- Original Message ----------- From: David Green <[EMAIL PROTECTED]> To: [email protected] Sent: Mon, 12 Feb 2007 14:06:02 -0500 Subject: Re: Witango-Talk: Upgrading from Witango 5.0 to Witango 5.5 - Syntax Errors > Yes, I opened the IF Action in Advanced mode and this is what it shows: > > ('<@VAR NAME="MLS_Records[<@CALC EXPR="@@request$i - 1">,12]" > SCOPE="request" ENCODING="HTML">'!='<@VAR > NAME="MLS_Records[@@request$i,12]" SCOPE="request" ENCODING="HTML">') > > I know I'm trying to jump to the bug conclusion quickly, but it > worked just fine in 5.0. That's the only difference, the upgrade. > It only occurs in IF Actions, not statements. And it doesn't occur > in all of them. > > Thanks, > > David Green > [EMAIL PROTECTED] > Web Services > Systems Insight, Inc. > http://www.systemsinsight.com/ > > William M. Conlon wrote: > > 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 > > > > > ________________________________________________________________________ > 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
