Id seggest using structures and arrays for this type of data storage e.g propery.name = "whatever" propery.name["whatever"].date = arraynew(1) propery.name["whatever"].date[1] = "date1" propery.name["whatever"].date[2] = "date2"
or somethine like that Gav "Mike Kear" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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/
