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