Duh, thanks to all who replied. It would help id 'store' was an available field. I changed to the field that has the store value in it and it works!! I am sorry to take up time with such a simple oversight. Again, Thanks!! Johnny Thompson wrote: > 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
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
