Rate1[Time1][n] where 'n' is the row number.
if you're in a query driven <cfoutput>, you can use the 'currentrow' variable for 'n'. On 8/9/07, Zach Firestone <[EMAIL PROTECTED]> wrote: > 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:285893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
