I'm assuming that 'store' is an available field within the
'store'recordset. If so, you'll need to scope it (ie 'store.store').
This is an excellent example of why one should use naming conventions (so
as not to be confused about what variables you are referencing).
Also - you might want to be more descriptive with the fields in your db.
If altering the table isn't an option, you might think about aliasing the
field...
For instance.
<cfquery name="qryStoreList"....>
select store as store_name from....
<cfoutput query="qryStoreList">
<select....
<option value="#store_name#">#store_name#</option>
......
hope that helps.
--- Bob Gillham <[EMAIL PROTECTED]> wrote:
<HR>
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
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:
<p><i>Expression result cannot be converted to a string</i><i></i>
<p><i>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.</i><i></i>
<p><i>The error occurred while processing an element with a general
identifier
of (#store#), occupying document position (75:26) to (75:32).</i>
<p>When I execute this code:
<p><i> <cfoutput query="store"></i>
<br><i> <cfif division is "W" ></i>
<br><i> <option
value="#store#">#store#&nbsp;</i>
<br><i> </cfif></i>
<br><i> </cfoutput></i>
<p>The variable store is a numeric field in my Access database.
<p>Thanks in Advance!!
<br> </html>
> begin:vcard
> n:Gillham;Bob
> tel;fax:(903) 534-2250
> tel;work:(903) 534-2174
> x-mozilla-html:FALSE
> org:Brookshire Grocery Co.;Information Technology
> adr:;;PO Box 1411;Tyler;TX;75710;
> version:2.1
> email;internet:[EMAIL PROTECTED]
> title:Programmer Analyst II
> fn:Bob Gillham
> end:vcard
>
=====
------------------------------
William Thompson
Allaire Certified Consultant
"My mind is a raging torrent, flooded with rivulets of thought cascading into a
waterfall of creative alternatives."
- Hedley Lamar
------------------------------
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-------------------------------------------------------------------------
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
