sorry, bit too obtuce...
<cfquery name="qFilteredSpList" dbtype="query">
SELECT *
FROM
qSpList
WHERE
course_type = #filterCourseType#
ORDER BY
course_name
</cfquery>
On 3/30/06, Barry Beattie <[EMAIL PROTECTED]> wrote:
> and if you take out the <cfqueryparam, what happens?
>
>
>
> On 3/30/06, Gavin Cooney <[EMAIL PROTECTED]> wrote:
> >
> > simple stuff.
> >
> > here's a dump of it (until i fix the problem!)
> > http://202.125.174.217/go/hsc/std-packs/
> >
> > I put the "xx"s in the first row because if i don't i get a different
> > error: "15090G" is not numeric (row 88 of query)
> >
> > Gav
> >
> > On 3/30/06, Mark Mandel <[EMAIL PROTECTED]> wrote:
> > > 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
> > >
> > >
> >
> >
> > --
> > www.gavcooney.com
> >
> >
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
