Can you post a code snippet to show us an idea of what you're doing? Without seeing any, the suggestion might be to use CFParam to define your form checkboxes and in your SQL statement, use the IN (#form.fieldname#) as opposed to looping through a list. You'll need to make sure the formfield is defined, hence the referent to the cfparam.
Also, if you've got a loop inside the cfmail tag, you'll probably need to drop the query parameter from the cfmail tag and do a query loop inside it. Hatton > -----Original Message----- > From: Stephen Adams [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 25, 2002 11:12 AM > To: CF-Talk > Subject: Using CFmail and loops > > > Hi, > > I am having a serious problem with CFMAIL. > > I have a form that has a collection of checkboxes, about nine of > them, the user can select any one of them or as many as they > want. This form also contain some other details that the user fills in. > > When they submit this form a search is carried out using the > criteria they have entered in the form, in order to get my query > to work I need to loop around the comma delimited list of values > sent by these checkboxes. Within each loop I have the search > query and the table in which the results are displayed. I have > to also loop around the results of this query in order for all of > them to be > displayed in the table and not just the last one. > > The problem I am having with cfmail is that I wish to send the > user these search results all within one email. > > Does anyone know how I can still have my outer loop and inner > loop, and send the result in one email. > > Thanks > > Stephen > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
