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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
