This will get you the email addresses for exact matches (zapSearch =
body) for one advert_details record. This should at least help get you
started.
SELECT zapEmail
FROM zap z
WHERE zapSearch
IN (SELECT body
FROM advert_details
WHERE advertID = @LastAdverAddedID)
--- W Luke <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Not sure what I need to do for this - hope someone can help.
>
> After someone posts an advert, it's entered into the database table
> advert_details. A table called zap contains 2 fields, zapSearch and
> zapEmail, with zapSearch being a search string. After posting the
> advert, I
> need to run through zapSearch to search for the text in the
> just-posted
> advert. If it finds anything, send an email to zapEmail.
>
> I just can't fathom how to do this. The fields in advert_details
> we're
> worried about are body and subject. I've had a go, but this is out
> of my
> depth. Can anyone help?
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
