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
-~----------~----~----~----~------~----~------~--~---

Reply via email to