Didn't work. Here's the error it gave me: Complex object types cannot be converted to simple values.
Zach Firestone Web/Graphic Design and Internet Marketing Emerson Communications Corp. www.EmersonCommunications.com www.EZReservation.net (407)387-3001 Phone (407)387-3002 Fax -----Original Message----- From: austen rustrum [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 6:23 PM To: CF-Talk Subject: Re: Problem Outputting Dynamic Variable from a Query 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 is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
