Hi,
I've got a complicated query I need to run involving just 2 tables, to be
emailed to customers. One, members, contains user-preferences and details,
and the other, main_details, contains content. I'm not sure how to approach
this.
In members, there are 4 fields - email, watch1, watch2 and watch3.
In main_details I'm only concerned with fields ID and body.
All I need to do is go through each record in members, and search watch1,2
and 3 in main_details.body (just a basic WHERE body like ...) If any
results are returned, I'd then need to grab the ID and email in members, and
send them out.
Can anyone point me in the right direction? I've tried, tried and failed
and failed again and again.
Thanks
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
