interesting so, the data structure says char(#) but it seems to be
stored as varchar. so there is no ending.
so it is like the data is coming is as like
"BOONE "
and witango is seeing it defined as a char(length)
so essentially it is cutting off the ending
"BOONE
Ben
On Feb 12, 2007, at 12:21 PM, David Green wrote:
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
