> "cf-talk list also -- there are a
> lot of smart folks subscribed to talk who don't subscribe
> to
> community."
> Sooooooooo...the smart ones know better then to come to
> this list, eh?
> ;-)
> -----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]
