Hi everybody need help on the following: I have two cfquery which are
<cfquery name="english" datasource="db"> select * from lang where langid=1 </cfquery> <cfquery name="spanish" datasource="db"> select * from lang where langid=2 </cfquery> <cfparam name="Session.Lang" default="1"> <CFSWITCH expression="#Session.Lang#"> <cfcase Value="1"> <cfoutput> <cfset qtext="#english#"> </cfoutput> </cfcase> <cfcase Value="2"> <cfoutput> <cfset qtext="#spanish#"> </cfoutput> </cfcase> </cfswitch> <cfoutput query="#qtext#"> #field1# </cfoutput> the error is coming from cfoutput query which says Complex object types cannot be converted to simple values. IS THERE A WAY TO POST THE QUERY DYNAMICALLY IN THE CFOUTPUT I HAVE BEEN TRYING MANY METHODS BUT COULDN'T GET IT.... THANKS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
