By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,336 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Error in display output from cfquery

P: 13
I have query which count all data in table and I try to display the output of count but I got an error
here the code

Expand|Select|Wrap|Line Numbers
  1. <cfquery name="countDATA" datasource="#ds#">
  2.     select count(quest_id)
  3.     from survey_question
  4. </cfquery>
  5.  
  6.  <cfset t = #countDATA#>
  7.      #t#
Error is
- Complex object types cannot be converted to simple values. in line 481

481 : #t#
I'm new in coldfusion,
tq.. :)
Jan 22 '13 #1
Share this Question
Share on Google+
1 Reply


acoder
Expert Mod 15k+
P: 16,027
#t# is the query object. You need to access the field name, e.g. #t.field_name#
Jan 22 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.