Perhaps your syntax for setting this.attribute wasn't right? This should
work.

<cfset this = StructNew()>
<cfset this.attribute = "color">

<cfquery datasource=#dsn# name="#this.attribute#attributes"
        cachedafter=#DateAdd('d', '-1', Now())#>
        SELECT  *
        FROM    EQUIP.ATTRIBUTE_OPTION
        WHERE   ATTR_NAME = '#this.attribute#'
        Order by ATTR_VALUE
</cfquery>


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to