Good point. That suggests its probably that darn data dictionary. Probably need to rebuild the search action in some way (edit the xml).
Another reason I only use DirectDMBMS -- the DataDictionary is always getting messed up. -- Bill ---------- Original Message ----------- From: Ben Johansen <[EMAIL PROTECTED]> To: [email protected] Sent: Mon, 12 Feb 2007 12:56:03 -0800 Subject: Re: Witango-Talk: Upgrading from Witango 5.0 to Witango 5.5 - Syntax Errors > 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 ------- End of Original Message ------- ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
