I cant say that ive used LIKE in a table join either but its always been
common practice to encase the parameters in single quotes like bob just
said.
>From: Bud <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: Advanced Queries (take 2)
>Date: Sun, 03 Dec 2000 11:16:56 -0500
>
>On 12/3/00, W Luke penned:
> ><cfquery name="big_query" datasource="localads">
> >
> >SELECT mybounty.watch1, mybounty.watch2, mybounty.watch3, mybounty.email,
> >advert_details.body, advert_details.ID
> >FROM mybounty, advert_details
> >WHERE advert_details.body like mybounty.watch1 <!--- OR mybounty.watch2
>like
> >%advert_details.body% OR mybounty.watch3 like %advert_details.body%
> >--->
> ></cfquery>
> >
> >I've commented out the "OR" part because it was retreiving no results at
> >all. How can I fix the query above, and then email the results?
>
>Without getting too far into it, try using single quotes around the
>like parameters. Not sure though. I've never used "LIKE" in a table
>join.
>--
>
>Bud Schneehagen - Tropical Web Creations
>
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>ColdFusion Solutions / eCommerce Development
>[EMAIL PROTECTED]
>http://www.twcreations.com/
>954.721.3452
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
