[cfaussie] Re: query of query error CF7
What sort of data is in the query?MarkOn 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=querySELECT *FROMqSpListWHEREcourse_type = cfqueryparam cfsqltype=CF_SQL_VARCHARvalue=#filterCourseType# ORDER BYcourse_name/cfqueryand 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.comICQ: 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 -~--~~~~--~~--~--~---
[cfaussie] Re: query of query error CF7
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 xxs 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 -~--~~~~--~~--~--~---
[cfaussie] Re: query of query error CF7
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 xxs 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 -~--~~~~--~~--~--~---
[cfaussie] Re: query of query error CF7
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 xxs 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 -~--~~~~--~~--~--~---
[cfaussie] Re: query of query error CF7
I wonder? cfquery name=qFilteredSpList dbtype=query SELECT * FROM qSpList WHERE course_type = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#filterCourseType# and course_type is not null !--- HERE --- ORDER BY course_name /cfquery there *was* a change to QofQ (and to do with nulls) but for the life of me I can't remember exactly what On 3/30/06, Barry Beattie [EMAIL PROTECTED] wrote: 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 xxs 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 -~--~~~~--~~--~--~---
[cfaussie] Re: query of query error CF7
it works. you legend! Thanks a lot. On 3/30/06, Mark Mandel [EMAIL PROTECTED] wrote: Hmnnn... Maybe try adding the 'xx' across the rows at the top until you find which one is causing the issue. It is definatley a data typing issue. Mark 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 xxs in the first row because if i don't i get a different error: 15090G is not numeric (row 88 of query) Gav -- 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 -~--~~~~--~~--~--~---