Thanks a lot both of you. I actually do have THE BOOK by Forta, I guess my
brain is just fried tonight that I didn't figure both of those out on my
own! :-)
I'm going to sleep now!
Thanks again,
Britta
----- Original Message -----
From: "Stephen Kellogg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:58 PM
Subject: RE: Advanced Database Search Form
> Try using one of the following in your query statements:
> 1.
> Where tableField1 = '#form.variable#'
>
> 2.
> Where tableField1 LIKE '#form.variable#%'
> The % is a "wild card" so bu would return anything that started with bu,
ie
> bulb, bulbous but not xbulb
>
> 3.
> Get one of Uncle Ben's (or someone's) books ;-)
> or
> http://www.thenetprofits.co.uk/coldfusion/faq/#answer82
>
> HTH
>
> Stephen
> -----Original Message-----
> From: B. Wing [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 03, 2001 12:51 AM
> To: CF-Talk
> Subject: Advanced Database Search Form
>
>
> There are two things that I'm trying to figure out how to do: an Exact
> Search - if I put in a search for "bulb" it would return only "bulb" not
> "bulbous".
>
> Secondly, I've got a client who wants a search which will search only
> beginning of word: For instance a search for, "bu" would return "bulbous"
> but not "babudigalia".
>
> Has anyone done either of these before? I'd appreciate any idea of where
to
> start to build this.
>
> Thanks a lot!
>
> Britta
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
