It must have been a corruption in the taf because if I create a new one and try the same action it is fine. Still a little scary because it was a brand new taf I had created that day not a 4.5 one converted.
I'll try it in that taf with a newly created search action to see if that fixes it. Glad to know it is not more pervasive issue ( no pun intended). Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: "Ben Johansen" <[EMAIL PROTECTED]> > Organization: Intelisoft, Inc. > Reply-To: [EMAIL PROTECTED] > Date: Wed, 9 Jul 2003 18:41:21 -0700 > To: <[EMAIL PROTECTED]> > Subject: RE: Witango-Talk: Bug in Search Action? > > Crystal :-) > > This is very interesting; I would love to see the debug output of this > SQL statement. > > I have tried it with Access and Sybase SQL Anywhere and no problem. > I even tried messing with the <@ASSIGN noSQLEncoding true> configuration > variable. > > Good Luck > > Ben Johansen - http://www.pcforge.com > Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm > Authorized MDaemon Mail Server Reseller > http://www.pcforge.com/AltN.htm > > > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 6:11 PM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: Bug in Search Action? > > I do not understand why this is so hard to understand. > > I dragged a search action in > The the criteria I dragged over the column email > Selected contains > Then type a in the value > > I also tried typing @ > I also tried typing . > > > I dragged over another columns > Selected = > Value 1 > > So the SQL that the taf rights out should be > > SELECT C1."First Name",C1.Middlename,C1."Last Name" FROM "Client Table" > C1 WHERE (C1."Email" LIKE '%.%' and hold=1) > > > Instead it is writing out > > SELECT C1."First Name",C1.Middlename,C1."Last Name" FROM "Client Table" > C1 WHERE (C1."First Name" LIKE '.%%' and hold=1) > > I am using Witango 5.0 > SQL 2000 > > So if someone has a similar setup and can either verify this is a > problem > for them or they get something different I would like to know. > > I understand how to right SQL syntax which is why I was able to solve > this > problem with a DBMS > > My question is their a reproducible bug in the WiTango server or Dev > studio > causing this. > > So to figure that out I would really appreciate it is someone would try > to > do the same thing with the same OS and DB > > I am not looking for a solution or the differences between the search > action > terminology and SQL syntax. Just if this is a bug I need to watch for > and > report or some flaw somewhere else. > > Thanks > > Hope this make is clear. > > > > -- > Dan Stein > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Mobile: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,SQL 2000 > [EMAIL PROTECTED] > www.dss-db.com > > >> From: "Ben Johansen" <[EMAIL PROTECTED]> >> Organization: Intelisoft, Inc. >> Reply-To: [EMAIL PROTECTED] >> Date: Wed, 9 Jul 2003 15:31:43 -0700 >> To: <[EMAIL PROTECTED]> >> Subject: RE: Witango-Talk: Bug in Search Action? >> >> Ok, totally confused here >> >> SELECT C1."First Name",C1.Middlename,C1."Last Name" FROM "Client > Table" >> C1 WHERE (C1."First Name" LIKE '%B%') >> >> Ok >> >> Operator Entered what Witango Does >> --------- --------- ---------------- >> Contains B Like %B% >> Begin With B Like B% >> Ends With B Like %B >> >> You do not need to add the % in the value >> Witango will add the appropriate % pattern >> >> If I am missing your point, Please let me know >> >> Ben Johansen - http://www.pcforge.com >> Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm >> Authorized MDaemon Mail Server Reseller >> http://www.pcforge.com/AltN.htm >> >> >> -----Original Message----- >> From: Dan Stein [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, July 09, 2003 1:44 PM >> To: [EMAIL PROTECTED] >> Subject: Re: Witango-Talk: Bug in Search Action? >> >> In the search action there is no like syntax. I would think that > contain >> would be the same as like. I know how to do this with a DBMS which is >> what I >> ended up using but if you put a single character in the value part of >> the >> search action and use contains you get back the wrong SQL >> >> So in the ben example it would bring back >> Like B%% >> >> But it should be Like %B% >> >> So Bens test is not a real test. It seems to work fine with more than >> one >> character but fails with just one. >> >> This seems like a bug. >> >> To confirm would you try it with one character and see if you get the >> same >> result? >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> Land: 215-799-0192 >> Mobile: 610-256-2843 >> Fax 413-410-9682 >> FMP, WiTango, EDI,SQL 2000 >> [EMAIL PROTECTED] >> www.dss-db.com >> >> >>> From: "Harpreet Matharu" <[EMAIL PROTECTED]> >>> Reply-To: [EMAIL PROTECTED] >>> Date: Wed, 9 Jul 2003 15:03:40 -0500 >>> To: <[EMAIL PROTECTED]> >>> Subject: RE: Witango-Talk: Bug in Search Action? >>> >>> try the 'LIKE' syntax >>> >>> LIKE '%%' >>> >>> '%test%' - contains test >>> 'test%' - begins with test >>> '%test' - ends with test >>> >>> cheers... >>> >>> -----Original Message----- >>> From: Dan Stein [mailto:[EMAIL PROTECTED] >>> Sent: Wednesday, July 09, 2003 1:59 PM >>> To: [EMAIL PROTECTED] >>> Subject: Witango-Talk: Bug in Search Action? >>> >>> >>> Anyone else found this or is it just me. >>> >>> In criteria I am looking for contains ( I've tried @, a, .) and they >> all >>> fail because in the debug I can see it is doing >>> @%% >>> Or >>> A%% >>> Or >>> .%% >>> >>> When it should do >>> %a% >>> Or >>> [EMAIL PROTECTED] >>> Or >>> %.% >>> >>> If someone else can confirm I'll report it. Seems pretty serious to >> me. >>> -- >>> Dan Stein >>> Digital Software Solutions >>> 799 Evergreen Circle >>> Telford PA 18969 >>> Land: 215-799-0192 >>> Mobile: 610-256-2843 >>> Fax 413-410-9682 >>> FMP, WiTango, EDI,SQL 2000 >>> [EMAIL PROTECTED] >>> www.dss-db.com >>> >>> >>> >> > ________________________________________________________________________ >>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf >>> >>> >> > ________________________________________________________________________ >>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf >>> >> >> > ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf >> >> > ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
