Andrew,
To say that it has nothing to do with ColdFusion is incorrect - as a
developer has come across the issue developing an application using
ColdFusion. Sure it is an 'across the board of programming languages' issue
- but that doesn't mean that Adobe cannot note the issue in its
Hi Rod,
Big Decimal has far more precision than a CF number (only 12
significant digits) and has built in rounding - you can set the
precision with it's setScale(scale, rounding-mode) method.
One point to note if you are using BigDecimal - you should use the
string constructor i.e.
Hi,
I use a site wide error template that emails the text of the query that caused
a problem.
When the query uses cfqueryparam tags the parameters passed are in the form
(param 1) etc in the text of the query.
Is it possible to find out what these params are?
To get the SQL I use:
What version of CF are you using? In 7, there is the new RESULT attribute
allowing you to name a variable which is a structure, and one of its keys is
SQL and another is sqlparameters:
CFQUERY NAME=demoq DATASOURCE=cfdocexamples result=test
select * from employees
where lastname =
thanx Steve
me and the sysadmin are one and the same. and I'm using the same
password that installed CF7 (and anything else) in the first place.
the only other password I use anywhere else on this machine is the CF
admin password (which I tried, of course, just hoping)
woe.
cheers
b
On
Steve,
Gareth stated and I quote, It hasn't been a problem previously, why would
it be a problem now? CFML is not a strong typed language and there for
should evaluate situations like this correctly.
So as you see I am correct by saying it has nothing to do with CF, but yes I
agree about
Hi Charlie,
Using CF MX 6.1.
Damn.
--~--~-~--~~~---~--~~
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
The [Unknown Type] can normally be fixed with this hotfix
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=1a9c83c
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Scott Thornton
Sent: Wednesday, 21 February 2007 12:08 PM
To:
Hmm, interesting you used to be able to select that option in previous
versionJ
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
--~--~-~--~~~---~--~~
You received this message because you
What exactly is a 'CF number'?
All simple CF variables are stored as strings. When used as numbers
in an expression they have 12 significant digits according to the
documentation, which I assume is a java Float (a Double would have
more).
As for a solution in CFML, I wouldn't mind an
LOL, that was sent to the wrong list. Sorry for the confusion.
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Gareth Edwards
Sent: Wednesday, 21
OK, I've done a little digging and this works in CFMX 6 and 7:
CFQUERY NAME=demoq DATASOURCE=cfdocexamples
select * from employees
where lastname = cfqueryparam value=smith
cfsqltype=CF_SQL_VARCHAR
/CFQUERY
cfdump var=#demoq#
cfset factory = createobject(java,
12 matches
Mail list logo