Good idea Shane. I just added it and got the same error.
David Green
[EMAIL PROTECTED]
Web Services
Systems Insight, Inc.
http://www.systemsinsight.com/
Shane Pearlman wrote:
David ... just for the sake of hitting everything (though it shouldn't
matter) .... can you try using the formal use of the <@calc> tag?
<@calc expr="">
Shane Pearlman
831.345.7033
S&P, Inc.
-----Original Message-----
From: David Green [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 10:23 AM
To: [email protected]
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
