Try this:
<cfoutput query="getbookings">
<cfparam name="property#propertyID#" default=""/>
<cfset "property#propertyID#" =
listappend(Evaluate("property#propertyID#"), date)/>
</cfoutput>
<cfdump var="#variables#">
In your code I can't see that a variable called "propertyXX" is
actually getting created.
Cheers
Abhi
On Thu, 21 Oct 2004 14:41:34 +1000, Mike Kear <[EMAIL PROTECTED]> wrote:
> 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/
>
---
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/
