Or better explanation. How do I set the #form.material# so I can access it as a query variable?
Emmet -----Original Message----- From: Emmet McGovern Sent: Wednesday, July 16, 2003 12:42 PM To: CF-Talk Subject: dynamic query question I was handed a poorly designed to integrate into an app. The record set is fairly huge. I need to access the db using a dynamic query where the select column statement is populated by a form. <CFQUERY NAME="cc" DATASOURCE="#request.mainDSN#"> SELECT #form.material#, FROM cc, compat where chemicalID = #chemicalID# </CFQUERY> My question is how do I reference the column name for output if I don't know the column name on the processing page? I know ive seen something about this somewhere. Emmet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
