[cfaussie] Re: query of query error CF7

Wed, 29 Mar 2006 20:51:49 -0800

What sort of data is in the query?

Mark

On 3/30/06, Gavin Cooney <[EMAIL PROTECTED]> wrote:

I have some code that worked fine in CF 6.1 but doesn't work in CF7.

I try to do a simple query of query like this

<cfquery name="qFilteredSpList" dbtype="query">
SELECT *
FROM
        qSpList
WHERE
        course_type = <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#filterCourseType#">
ORDER BY
        course_name
</cfquery>

and i get this error:

Query Of Queries runtime error.<br> Unsupported Cast Excpetion:
Casting to type "NULL" is unsupported.




--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
ICQ: 3094740
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to