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
