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
