rumour has it that using evaluate is evil. you can avoid it by using
the same syntax on the left and right side of the equation:
cfloop from=1 to=5 index=counter
cfset session.order[currency#counter#] = form[currency#counter#]
cfloop
G
i'd do it javascripty, myself. he's a func from apple's site:
function testCookies() {
var exp = new Date();
exp.setTime(exp.getTime() + 180);
// first write a test cookie
setCookie(cookies, cookies, exp, false, false, false);
if
Hi,
The default coldfusion error page includes the SQL of a query if the error is
query related.
Using the site site wide error template, is it possible to get hold of and
display this sql?
Using cfdump var=#error# label=error structure, there is no sql
displayed, and only the
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
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]
Scott,
does the amount of information available to the site-wide template
change when check/uncheck the Enable Robust Exception Information in
the Debugging Logging Debugging Settings of CF admin?
Cheers
Gav
On 3/30/06, Joel Cass [EMAIL PROTECTED] wrote:
This seems to work for me:
cfif
11 matches
Mail list logo