is #rs_View.Project_Type_ID2# a coma list of numbers? if so, try not adding the ' around it in the IN statment....
like this <cfquery name="rs_pc2" datasource="Project_Set_Up2" dbtype="ODBC"> SELECT Profile_Code2, Profile_Name2 FROM tbl_Profile_Codes_2 WHERE Profile_Code2 IN (#rs_View.Project_Type_ID2#) </cfquery> jason >From: Paul Ihrig <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: IN condition... help? >Date: Mon, 17 Dec 2001 15:56:29 -0500 > >ok >i must be missing something, so if you can see the problem i would >appreciate it >i am not able to view the out put of a cfloop query, but can see the ids >output? > ><cfquery name="rs_pc2" datasource="Project_Set_Up2" dbtype="ODBC"> >SELECT Profile_Code2, Profile_Name2 FROM tbl_Profile_Codes_2 >WHERE Profile_Code2 IN ('#rs_View.Project_Type_ID2#')</cfquery> > ><td><cfloop query="rs_pc2"> ><cfoutput>#rs_pc2.Profile_Name2#</cfoutput><br> ></cfloop> > ><!--- below, does show the right IDs such as 0264,0039 SF,0258,0257 ---> ><cfoutput>#rs_pc2.Profile_Name2# #rs_View.Project_Type_ID2#</cfoutput> ></td> > > >Thanks, i appreciate it > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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