Thanks that did help.
All the best for the New Year.
Steve Kahn
-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 3:47 PM
To: CF-Community
Subject: Re: how to output query results into cfmail
Hey Steve,
This would be a good message for the cf-talk list also -- there are a
lot of smart folks subscribed to talk who don't subscribe to
community.
Asside from that, your syntax looks okay. You might want to prefix
#ticketid# in your subject line with the query name, #tkt.ticketid#.
I tend to avoid using query-driven cfoutput or cfloops around content
I know I want to display (and this includes using the query attribute
in cfmail tags), unless the intent is to display or send multiple
records, just in case the query doesn't generate any results. In other
words -- if you only expect one record in your query, I recommend not
using the query attribute in cfoutput or cfmail.
Output the value of #tkt.recordcount# prior to your cfmail tag to be
sure it actually returned the record you wanted. Beyond that, you can
also dump the queyry with <cfdump var="#tkt#"> to make sure it
contains the content you want to display.
hth
s. isaac dealey 214-823-9345
team macromedia volunteer http://www.macromedia.com/go/team
chief architect, tapestry cms http://products.turnkey.to
onTap is open source http://www.turnkey.to/ontap
> I have a formpage that passes to an actionpage and inserts
> into the
> database.
> I then query the db to retrieve the memberID.
> Now I pass the form data into a CFMail, however I am
> unable to pass the
> CFQuery data into the CFMail contents.
> I have been trying CFLoop without success, how do I put
> the query
> information into the CFMail?
> Thanks
> Steve
> <!--- ACTIONPAGE --->
> <!--- insert data --->
> <cfinsert datasource="Mysql"
> username="Myname"
> password="Mypass"
> tablename="resolve"
> formfields=" email, date_entered, time_entered, ip">
> <!--- retreive data --->
> <cfquery name="tkt" datasource="Mysql" username="Myname"
> password="Mypass"
>>
> SELECT ticketid
> FROM resolve
> WHERE email = '#form.email#'
> AND time_entered = '#form.time_entered#'
> </cfquery>
> <!--- mail data --->
> <cfmail query="tkt"
> from="[EMAIL PROTECTED]"
> to="[EMAIL PROTECTED]"
> subject="TICKET NUMBER #ticketID# New submission from
> website!"
> type="HTML">
> The follow message was posted through the website, <br>
> <br>
> Ticket Number: #tkt.ticketid#<br>
> <br>
> Sender email: #form.email#<br>
> Sender IP: #REMOTE_ADDR#<br>
> <br>
> Message Sent: #DateFormat(now(), 'mmmm dd, yyyy')#
> #TimeFormat(Now(),'hh:mm:ss tt')#<br>
> </cfmail>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
