This is why it's a good idea to scope your variables.
If Store is a field in your database, you have to use #STORE.store#
Your query name is the same as your table column name.
Tony
Bob Gillham wrote:
> I am new and learning CF. I am converting some ASP apps that we have
> to CF to show the benefits to my management. I am getting the
> following error:
>
> Expression result cannot be converted to a string
>
> Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must
> evaluate to a value that can be converted to a string for output or
> dynamic text accumulation purposes. Complex objects, such as queries,
> arrays, and COM/DCOM objects, cannot be represented as strings.
>
> The error occurred while processing an element with a general
> identifier of (#store#), occupying document position (75:26) to
> (75:32).
>
> When I execute this code:
>
> <cfoutput query="store">
> <cfif division is "W" >
> <option value="#store#">#store#
> </cfif>
> </cfoutput>
>
> The variable store is a numeric field in my Access database.
>
> Thanks in Advance!!
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
