Thats how CFMAIL is supposed to work when you pass a query to it. What you should do is use a <CFLOOP query="queryname"> inside your CFMAIL content section to output the data you need in the table.
bye! ----------------------- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig > -----Original Message----- > From: Srimanta [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 1 October 2002 2:51 PM > To: CF-Talk > Subject: CF Mail Problem.. > > > Hello Forum, > > Need Help. > > I am trying to send data generated by a query using CFMAIL tag to a > recepient whose email is obtained from a Form. > However Instead of including and sending only one email > containing all the > rows returned by the query to the email address obtained > from the Form in > the previous page CFMAIL is sending multiple emails to the > same email > address > --one email for each record generate from the query. Thus each email > contains only one seperate record. > I cant understand why? > The recepient email address comes from the Form. The > contents of the email > is generated by the db query. > Any help will be much appreciated. > > This is my code: > > <CFQUERY name= "Get_Products" DataSource="XYZ"> > Select * FROM Products WHERE product id=#Form.productid# > </CFQUERY> > > <cfmail query="Get_Products" > to="#Form.Email_Address#" > from="myemail.com" > subject="Product" > > type="HTML"> > > <!--- The variables #productid# and #Email_Address# come > from the Previous > Page (Form.cfm). > > <Table> > <TR> > <TD> Productid: Get_Products.productid <BR> </TD> > <TD>Details: Get_Products.details <BR> </TD> > <TD>Model : Get_Products.modelno <BR> </TD> > </TR> > </Table> > </cfmail> > > The purpose is to send more details about the product > selected by the user > in the Form.cfm Page. > Thanks > > Srimanta > ----- Original Message ----- > From: "jon hall" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, October 01, 2002 4:13 PM > Subject: Re: Using Java nulls in CF? > > > > For anyone wondering...with smaller files it really > doesn't matter, > > but with a 2.3MB IIS logfile, the Java ReadLine method is > about 30-40 > > percent faster than the old standby looping over the file > as a string > > using chr(10) as a delimiter. > > > > -- > > jon > > mailto:[EMAIL PROTECTED] > > > > Monday, September 30, 2002, 11:43:44 PM, you wrote: > > jh> Actually I didn't even think of using isDefined(), and I think > > jh> you answered my question without knowing it :). > > > > jh> All I really wanted to do was use java's readLine() > method, but > > jh> readLine returns a null when the last line has been > read. So I stuck > > jh> isDefined() in there an voila! It worked. > > > > jh> <cfscript> > > jh> fr = createObject("java", "java.io.FileReader"); > > jh> br = createObject("java", "java.io.BufferedReader"); > > jh> fr.init(filename); > > jh> br.init(fr); > > > > jh> line = br.readLine(); > > jh> while (isDefined("line")) { > > jh> writeOutput(line & '<br>'); > > jh> line = br.readLine(); > > jh> } > > > > jh> fr.close(); > > jh> br.close(); > > jh> </cfscript> > > > > > > jh> Now I'm going to see if this is any faster than > looping over line > > jh> breaks in a string. I hope so after all I tried to > get this to work :) > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
