Yep in is much better, quicker too! [EMAIL PROTECTED] writes: ><cfquery datasoure="xxx" name="listsQuery"> >SELECT this, that, theotherthing >FROM tblName >WHERE ID IN (#id#) ></cfquery> > ><cfoutput query="listsQuery"> >#this#<br>#that#<br>#theotherthing#<br><br> ></cfoutput>
~~~~~~~~~~~~~~~~~~~~~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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

