Try #rate1["#time1#"]# instead. I think that should work. > 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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
