Will,
Have you considered treating the textbox string as a list, breaking it apart
for your query (in your example) "bass" OR "guitar" OR "other list item".
This way you can allow your users to enter multiple words. The part I'm not
sure about is how my example below affects performance (I'm still new to
things like database tuning)
e.g.
mySearchParams = "Bass Guitar Music"
<CFSET SearchLen = ListLen(mySearchParams)>
<CFSET SearchArr = ListToArray(mySearchParams)>
<CFSET SeachFormat = "">
<CFLOOP FROM="1" TO="#SearchLen#" INDEX="x">
<CFIF SearchFormat EQ "">
<CFSET SearchFormat = "myColName = """ & "#SearchArr[x]#""">
<CFELSE>
<CFSET SearchFormat = " OR myColName = """ & "#SearchArr[x]#""">
</CFIF>
</CFLOOP>
<CFQUERY ...>
SELECT blah1, blah2, blah3
FROM myTable
WHERE #SearchFormat#
</CFQUERY>
>From: "W Luke" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: Textbox validation
>Date: Fri, 23 Mar 2001 13:30:28 -0000
>
>Thanks for all the replies. The reason I need to prevent more than one
>word
>being entered, is I'm finding it impossible to use wildcard filtering using
>Access' Instr function (any clues anyone?) - for example, if the search
>string contained "Bass Guitar" it would only return True if it *matches*
>it,
>and not if it's similar (Like).
>
>Anyways, thanks - going to do what Aidan suggests, and add the Javascript
>when I have time.
>
>Will
>--
>[EMAIL PROTECTED] -=- www.lukrative.com
>Local-Advertising -=- www.localbounty.com
>
> > Really the best way is *both*.
> > JavaScript is much nicer from a user interface point of view.
> > But if the validation is important you need to do it again on
> > the server, because you can't guarantee the user has JavaScript
> > running in their browser.
> >
> > Nick
> >
> > -----Original Message-----
> > From: W Luke [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 23, 2001 12:39 AM
> > To: CF-Talk
> > Subject: Textbox validation
> >
> >
> > Hi,
> >
> > On one textbox I need to prohibit users entering more than one word - I
> > don't want them to enter a space. What's the best way of doing this -
> > Javascript, or Cold Fusion after the form has been posted?
> >
> > Thanks.
> >
> > Will
> > --
> > [EMAIL PROTECTED] -=- www.lukrative.com
> > Local-Advertising -=- www.localbounty.com
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
