the following code works fine when there is only one record that meets the
cfquery condition
<cfquery datasource="Australianaccomm" username="#username#"
password="#password#" name="advert">
select *
from retail
where activestatus= 'b'
</cfquery>
<CFMAIL QUERY="advert"
TO="#BusinessEmailaddress#"
FROM="#app_settings.default_emailaddress#"
SUBJECT="test"
SERVER="#app_settings.default_mailserver#">
#website#/austonline/marketing/businessadvert.cfm?adminid=#advert.adminid#&c
ategory=shops
</CFMAIL>
however when there is more than one record that meets the condition the
system generates the following error
Error Diagnostic Information
unknown exception condition
TagCFMail::sendMessage
The error occurred while processing an element with a general identifier of
(CFMAIL), occupying document position (14:1) to (18:47).
I look forward to your suggestions
Kind Regards
Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
Website: www.AustralianAccommodation.com
Website: www.AccommodationNewZealand.com
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
