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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
