Hey, I am trying to output a dynamic variable within a ColdFusion query and have hit a wall. I'm creating a golf package website that dynamically pulls course names, tee times, and the cost of tee times. In a form on the previous page they select the tee time, course they want to play, and date they want to play. All these are pulled from a database. Here is my query:
<cfset Time1 = Form.TeeTime1> <cfset Course1 = Form.Course1> <cfset Date1 = #DateFormat(CreateODBCDate(Form.Date1), "yyyy-mm-dd")#> <cfquery datasource="usagolf" name="Rate1"> SELECT #Time1# FROM #Course1# WHERE Date = '#Date1#' </cfquery> So the problem I'm having is outputting the price for that time from the above query. This is what I would have to do do have it display right: <cfoutput>#Rate1.#Time1##</cfoutput> But ColdFusion throws an error when I do that because it's improper syntax. I was hoping someone knew of another way I could call the output from the above query. Any insight would be much appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
