CFMail again

[Bill]

Man this Mail tag has been giving me big kahoonas lately

Can anyone see why this doesn't work??

here's what I have

<cfcase value="text">

<cfquery name="rsCreateMailList" datasource="My_DSN">
SELECT * FROM tbl_maillist WHERE active = TRUE
</cfquery>
<!--- <cfdump var="#rsCreateMailList#"> --->
<cfmail query="rsCreateMailList"
to="#email#"
replyto="info@MyServer.com"
failto="info@MyServer.com"
from="info@MyServer.com"
subject="#txtSubject#"
server="mail.MyServer.com"
timeout="10"
groupcasesensitive="no">
<cfmailparam name = "Importance" value = "High" >
<cfmailpart type="text">
#txtHeader#

Hello #rsCreateMailList.firstname#

#txtMessage#

#txtFooter#

</cfmailpart>
</cfmail>
Thank you, Your Newsletter has been successfully sent to all in your list.
</cfcase>

It runs fine as long as I don't add the quiry attribute. I need the tag to
loop through all emails in the database so as I understand it the mail
attribute would need to be defined prior to the "TO" attribute.

Here's the error.

Attribute validation error for tag CFMAIL.
# The tag has an invalid attribute combination:
failto,from,groupcasesensitive,query,replyto,serve r,subject,timeout,to.
Possible combinations are:Required attributes: 'from,subject,to'. Optional
attributes:
'bcc,cc,charset,debug,failto,mailerid,mimeattach,p assword,port,replyto,server,spoolenable,timeout,ty pe,username,wraptext'.
# Required attributes: 'from,group,subject,to'. Optional attributes:
'bcc,cc,charset,debug,failto,groupcasesensitive,ma ilerid,maxrows,mimeattach,password,port,replyto,se rver,spoolenable,timeout,type,username,wraptext'.
# Required attributes: 'from,query,subject,to'. Optional attributes:
'bcc,cc,charset,debug,failto,mailerid,maxrows,mime attach,password,port,replyto,server,spoolenable,st artrow,timeout,type,username,wraptext'.
# Required attributes: 'from,group,query,subject,to'. Optional attributes:
'bcc,cc,charset,debug,failto,groupcasesensitive,ma ilerid,maxrows,mimeattach,password,port,replyto,se rver,spoolenable,startrow,timeout,type,username,wr aptext'.

The error occurred in
C:\Inetpub\wwwroot\datapacks\wwwroot\Administratio n\Maillist\CreateMailingList.cfm:
line 20

18 : </cfquery>
19 : <!--- <cfdump var="#rsCreateMailingList#"> --->
20 : <cfmail query="rsCreateMailList"
21 : to="#email#"
22 : replyto="info@datapacks.com"


Am I missing something here???

TY

Bill

[Stressed_Simon]

To use groupcasesensitive you must have group to use it with a query. Just take it out.

[Bill]

:-)

That kinda ticks me off. I've been frigg'n with this thing for a few hours
now and the issue was as simple as that.

Thank you very much

Bill
"Stressed_Simon" <webforumsuser@macromedia.com> wrote in message
news:d5nk16$aju$1@forums.macromedia.com...

> To use groupcasesensitive you must have group to use it with a query. Just
> take it out.

[Bill]

Well, I thought it was solved. Works fine locally but I get that same error
on the plublic server. It's like I didn't even change anything.

Bill


"Stressed_Simon" <webforumsuser@macromedia.com> wrote in message
news:d5nk16$aju$1@forums.macromedia.com...

> To use groupcasesensitive you must have group to use it with a query. Just
> take it out.

[MattRobertson]

maybe the live server has trusted cache turned on?