Not really sure what you are after I think I may be pointing you in the right direction if I suggested you use setVariable() rather than listAppend().
GC Original Message: ----------------- From: Mike Kear [EMAIL PROTECTED] Date: Thu, 21 Oct 2004 14:41:34 +1000 To: [EMAIL PROTECTED] Subject: [cfaussie] Where is my logic error please? 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/ -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . --- 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/
