> Maybe one of the Gurus here can enlighten us. I have used the Attribute
> variables in many SQL queries. Here is an example query I use:
>
> SELECT AssetName, ...
> FROM Asset
> WHERE AssetID = #ATTRIBUTES.AssetID#
>
> AssetID is a select box value in the previous form. This query has never
> given me a problem.
I use the attributes scope all the time from within custom tags for SQL
Where and Inser without any problems
The only thing I can suggest if anyone is having problems is to display the
SQL in a CFOutput before you run the CFQuery, that way you'll see what the
problem is likely to be before it hits the SQL engine - if the SQL doesn't
run then it won't appear in the Debug list of queries - although it SHOULD
show you the SQL in the error box...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
