Just to clarify...you are saying that a QoQ sometimes changes the datatype of a column?
btw...you should be able to rewrite the cfreturn without the eval as: <cfreturn this[arguments.InstanceName] /> it's a bit cleaner imho. -- jon mailto:[EMAIL PROTECTED] Tuesday, July 1, 2003, 4:52:23 PM, you wrote: JA> Here�s the function in a cfc that�s causing the error. JA> It seems like the problem re-occurs whenever the runtime query being appended does not match the first one instantiated....:-( JA> <cffunction name=�appendqry� JA> returntype=�query� JA> hint=�Appends a query in a named instance� output=�No�> JA> <cfargument name=�Query� type=�query� required=�Yes�> JA> <cfargument name=�InstanceName� type=�string� default=�Query�> JA> <cfif not isDefined(�this.#arguments.InstanceName#�)> JA> <cfscript> JA> �this.#arguments.InstanceName#� = arguments.query; JA> </cfscript> JA> <cfelse> JA> <cfquery name=�this.#arguments.InstanceName#� dbtype=�query�> JA> SELECT * FROM this.#arguments.InstanceName# JA> UNION ALL JA> SELECT * FROM arguments.Query JA> </cfquery> JA> </cfif> JA> <cfreturn evaluate(�this.� & arguments.InstanceName) /> JA> </cffunction> JA> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
