Nope, just BOONE. It's a county here in Kentucky.
I actually have sort of figured it out. And of course, I don't think
it's a Witango issue now. It is, after all that, a data issue.
Something we've never had to deal with because of the stripChars
configuration variable. Although it's still set to true, there's
something not working. I believe it's related to the upgrade from
Pervasive.SQL 7.x to 9.5 and using JDBC instead of ODBC. The field is
defined in the DB as a CHAR. There are other legacy systems that manage
some of the data in the DB. These systems use a different method to
manage the data than SQL. They have their own definitions and
everything, but same data files, etc. That other system is incorrectly
NOT space filling the field.
So the field is defined as a CHAR, but the data isn't space filled. I'm
guessing on production 5.0 using ODBC, the ODBC connection was working
with Witango and the stripChars was working correctly. With the 5.5
server using JDBC, it's not stripping them. I can prove that it isn't
Witango because I tried to rtrim() the field in the sql statement which
didn't change anything. Then I did a convert to varchar in the
statement and it worked perfectly.
Does anyone know of any connection parameters I can use in the
<parameters> node in the jdbc.ini file that could help?
So, I'm no where near a solution yet, but at least it's not Witango!
Thanks for all the help and sorry to clutter everyone's inboxes!
Thanks,
David Green
[EMAIL PROTECTED]
Web Services
Systems Insight, Inc.
http://www.systemsinsight.com/
Ben Johansen wrote:
by chance is the data BOONE'S?
(with a apostrophe in the Name)
Ben
On Feb 12, 2007, at 11:06 AM, David Green wrote:
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
