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
