OK I'm going to assume SQL Server is your DB.
I haven't worked with SQL Server for almost a year now, so you have to
excuse me if my answer doesn't work.
You might have to replace UPPER with whatever the SQL command is. I gave
you the Oracle Functions. I think its like UCASE or something like that.
TRY
<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
UPPER(mybounty.watch2) like '%(UPPERadvert_details.body)%' OR
UPPER(mybounty.watch3) like '%UPPER(advert_details.body)%'
</cfquery>
That might not work too. But your DB schema needs a lot of normalization as
it stands now.
Won
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 03, 2000 7:38 PM
To: CF-Talk
Subject: Re: Advanced Queries (take 2)
> 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.
I had tried that, but resorted to removing them seeing as they hadn't
helped. I'm really confused with this - the code I originally posted is
just one application, but I need to do another similar one (and maybe 2 more
on top of those) run as weekly tasks (filters).
Thanks anyway
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
