Really? I use that syntax with Access and don't have a problem:
t.summary LIKE <CFQUERYPARAM CFSQLTYPE="CF_SQL_LONGVARCHAR" VALUE="%#form.txtsearch#%"> ~Dina ----- Original Message ----- From: "Jeff" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, March 13, 2003 2:06 PM Subject: Re: like %whatever% doesn't work in access? > on 3/13/03 2:56 PM, Raster, Tim at [EMAIL PROTECTED] wrote: > > > Access might require * instead of % perhaps. > > > > > > -----Original Message----- > > From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, March 13, 2003 13:49 > > To: SQL > > Subject: like %whatever% doesn't work in access? > > > > WHERE tbl.field LIKE '%#form.criteria#%' > > > > Does this syntax not work in access? I get 0 records no matter what. > > It's > > for a search. > > > > Thanks for any help, > > I've got the Macromedia Fast Track to ColdFusion book right in my lap and > your syntax looks entirely correct. I just made wildcard searches last week > using % signs and it worked perfectly. I'm not sure why that doesn't work. > Have you tried hardcoding something in just to make sure that's where the > problem is? > > (if I *know* that "Frank" is in the database, I'd try hardcoding '%ank%' > just to see if a record was returned.) > > Btw, that's Access 2000. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
