Nice website however your MAILTO tags do not work.
Try using "mailto:[EMAIL PROTECTED]"
use the QUOTES!

Also when doing a lookup for travel accommodations
it generated the following:

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (11:1) to (11:52).


Date/Time: 11/07/00 05:35:10
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 159.142.134.132
HTTP Referer:
http://australianaccommodation.com/austonline/signupwork/accomm/signup/enter
_password.cfm




















-----Original Message-----
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 8:23 AM
To: CF-Talk
Subject: CFMAIL ERROR


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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to