Can anyone see what's wrong with my logic here? I have a series of properties, and some booking dates. I run a query on a table of bookings and dates and i want to produce a list for each property, containing the bookings for that property, e.g.:
property78 = (date1, date4, date17) property79= (date1, date22, date24, date19) etc. Here's my query: <cfquery name="getbookings" datasource="#dsn#"> SELECT propertyID, date FROM bookings ORDER BY propertyID </cfquery> And here's the list generation part that doesnt work (but I dont see why - can you?) <cfoutput query="getbookings"> <cfset listname="property" & #propertyID#> <cfset listname = listappend(#listname#, "#date#")> </cfoutput> The two properties in this test data are property 78 and 79. when i try to output the list "property78" it throws an error 'unable to determine the value of the parameter'. I assume that's because there is no #property78#. But i guess i've been too close to this for too long now. I cant see why there isnt. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
