I ran into that aspect of contains within Expressions but I think the subject is in search action with regards to sql
I created a simple search action set criteria to me :-) r-clicked on search action and viewed the sql SELECT C1."Inquiry Date",C1."First Name",C1.Middlename FROM "Client Table" C1 WHERE (C1."First Name" LIKE '%ben%') Notice what Witango turned the criteria "First Name contains Ben" Into 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: ServerSmiths Tango Development [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 12:42 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Bug in Search Action? On Wednesday, July 9, 2003, at 12:27 PM, Ben Johansen wrote: > That's what the contain operator is for ;-) > Also Witango adjusts the operators to pick from based on the datatype > of > the column. > You can't contains or like on an integer I first used the contains operator just a short time back. It may have changed since 3.6 but if it hasn't, I might mention I wasted a lot of time until I understood that the contains is boolean only. My IF statement <@IF this contains that > do this <@else> do something else </@IF> failed because I had to Assign the <@IF above to a var and then evaluate the var as being equal to 1 or 0. The docs actually point out the boolean aspect but I assumed a normal <@IF type statement would work, it didn't for me on 3.6. Hope it helps. Michael Heth Web Information Architect __________________S E R V E R S M I T H S__________________ http://www.serversmiths.com/ Technology Infrastructure Provider I N T E R N E T P R E S E N C E S O L U T I O N S | EWordSmith | LightningSite | Enigma.Engine | ________M A R I N C O U N T Y C A L I F O R N I A________ ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
