On Wed, 1 Nov 2000 10:51:25 +0800, "Kay Smoljak" <[EMAIL PROTECTED]>
wrote:
>Hi all,
>
>I have this simple search query that's perplexing me somewhat.
<snip>
Thanks to everyone who replied, I figured it out - because I had
'#form.keywords#%' it was only matching where the keyword was the first word
in the field. I changed it to '%#form.keywords#%' and now it works fine. I'd
still be interested in what people consider more efficient/faster than
searching text fields this way.
Thanks,
K.
______________________________________________________
Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
