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