Jeff,
If that type of search isnt working for you, you could do a query of queries
to get your result, something like this...
<cfquery name="Getdata" datasource="DSN">
SELECT
field1,
field2,
field3
FROM
Table1
WHERE
(other criteria except for your like statement)
</cfquery>
Then do this:
<cfquery name="Filtered" dbtype="query">
SELECT
*
FROM
GetData
WHERE
Field1 LIKE '%search%'
</cfquery>
Kind of a round-about way to do it, but it should work for you! :)
Chris Peterson
-----Original Message-----
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 3:48 PM
To: SQL
Subject: Re: like %whatever% doesn't work in access?
on 3/13/03 3:39 PM, Dina Hess at [EMAIL PROTECTED] wrote:
> Not if he's using MX. Bug.
>
Really? Trim()? Do explain...does it just bomb whenever you use it? Or just
in SQL?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
