[cfaussie] Re: Strange calculation behavior on CF 7.02

2007-02-20 Thread Steve Armstrong
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
documentation and training guides - which is what Gareth was suggesting.
Robin's suggestion looks to be the neatest solution so far.

Steve


On 2/20/07, Andrew Scott [EMAIL PROTECTED] wrote:

  Gareth,



 Again you have been politely told it has nothing to do with Coldfusion, if
 you are aware how Coldfusion works under the hood, then accept that it is a
 know problem not a bug then deal with it and move on.



 Complaining about CF is not going to change the fact that Java has the
 issue and not CF.





 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:* Tuesday, 20 February 2007 2:40 PM
 *To:* cfaussie@googlegroups.com
 *Subject:* [cfaussie] Re: Strange calculation behavior on CF 7.02



 Indicating you know how Coldfusion works really proves nothing, I'm quite
 aware of how it all works. I'm just annoyed that Coldfusion doesn't deal
 with this situation better than it does.

 Once again, Javascript, although not strictly typed, is a typed language.
 If I could type in Coldfusion I would.

 Also, Coldfusion should get this one right, but it doesn't cfdump
 var=#1024.00-1024.10# returns -0.0

 Cheers
 Gareth.



 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Strange calculation behavior on CF 7.02

2007-02-20 Thread Robin Hilliard

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. init(0.1) because otherwise ColdFusion will  
convert the literal 0.1 to a ColdFusion number (with it's more  
limited precision) before passing it to Java.

Robin

__

Robin Hilliard
Director - RocketBoots Pty Ltd
Consulting . Recruitment . Software Licensing . Training
http://www.rocketboots.com.au

For schedule/availability call Pamela Higgins:
w+61 7 5451 0362
m+61 419 677 151
f+61 3 9923 6261
e[EMAIL PROTECTED]

or Direct:
m+61 418 414 341
e[EMAIL PROTECTED]


On 20/02/2007, at 6:43 PM, rod higgins wrote:


 If you use the java class and methods that handle these types of
 numbers I don't see the problem??

 cfloop from=1 to=1000 index=i
   cfset diff = CreateObject(Java, java.math.BigDecimal).init(0.1)
 cfset a = CreateObject(Java,
 java.math.BigDecimal).init(RandRange(100,1))
 cfset b = CreateObject(Java,
 java.math.BigDecimal).init(a*2)
 cfset c = CreateObject(Java,
 java.math.BigDecimal).init(val(a))
   cfset c = c.add(diff)
   cfset d = a.subtract(b).add(c)
 cfoutput#a#-#b#+#c# = #d#br //cfoutput
 /cfloop

 It seems CF is using some sort of toString() value during the
 calculation at some stage??

 hth
 Rod

 On Feb 20, 12:04 pm, Gareth Edwards [EMAIL PROTECTED] wrote:
 If you are running coldfusion 7.02, or maybe 7.01 or 7.0? (don't  
 know)

 Run this script below, and tell me if you get the same results for  
 each
 line. The way I see it, d should equal 0.1 on every row. But this  
 isn't
 the case. Is this a bug introduced by Coldfusion 7.02?

 cfset a = 0
 cfset b = 0
 cfset c = 0

 cfloop from=1 to=1000 index=i
 cfset a = RandRange(1,2)
 cfset b = a*2
 cfset c = #ListFirst(Trim(a),.)#.00
 cfset c = c + 0.1
 cfset d = a - val(b) + val(c)
 cfoutput#d#br //cfoutput
 /cfloop

 Cheers
 Gareth.


 

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Query Parameter List in the Error Structure

2007-02-20 Thread Scott Thornton

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:
error.rootCause.SQL

If I try to dump error.rootCause to take a look what is inside I get [Unknown 
Type] displayed.

Any ideas?


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Query Parameter List in the Error Structure

2007-02-20 Thread Charlie Arehart
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 = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=smith
/CFQUERY

cfdump var=#demoq#
cfdump var=#test#

that returns:
 
query - Top 2 of 2 Rows 
 DEPARTMENT  EMAIL   EMP_ID  FIRSTNAME   IM_ID   LASTNAME
LOCATION PHONE  
1Accounting ASMITH  4   Aaron   [EMAIL PROTECTED]   Smith   
San
Francisco   (612) 832-7201  
2Administration JSMITH  9   Jenna   [EMAIL PROTECTED]
Smith   San Diego   (612) 832-7422  
struct  
CACHED   false  
COLUMNLIST
DEPARTMENT,EMAIL,EMP_ID,FIRSTNAME,IM_ID,LASTNAME,LOCATION,PHONE 
EXECUTIONTIME250
RECORDCOUNT  2  
SQL  select * from employees where lastname = ? 
SQLPARAMETERS
array   
1smith  
 
If you're using an older release, I seem to recall some undocumented
functions, accessing the debug info I think, or perhaps accessing the
underlying query result set object, that may help. But in case you're at 7,
check out the above which is fully supported.


/Charlie
http://www.carehart.org/blog/ 

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Tuesday, February 20, 2007 5:52 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Query Parameter List in the Error Structure


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:
error.rootCause.SQL

If I try to dump error.rootCause to take a look what is inside I get
[Unknown Type] displayed.

Any ideas?





--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: wierd problem: can't run CF7 uninstaller

2007-02-20 Thread Barry Beattie

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 2/21/07, Steve Onnis [EMAIL PROTECTED] wrote:

 Barry

 Is this the password for CF or the password for the MAC user? Depending on
 how the MAC is set up, your user may not have permissions to uninstall the
 program.  Maybe try the sys admin user.

 Steve

 -Original Message-
 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
 Of Barry Beattie
 Sent: Wednesday, 21 February 2007 11:03 AM
 To: cfaussie@googlegroups.com
 Subject: [cfaussie] wierd problem: can't run CF7 uninstaller


 I'm trying to uninstall ColdFusion7 on Mac OS X

 running /Applications/ColdFusionMX7/uninstall/uninstall.app ...

 enter the password for the current user

 I enter (and confirm) my usual, bog standard, used a million times
 before user (root) password - the same one used to install the thing
 in the first place (and start Apache and MySQL), checking for caps-lock,
 etc

 the password you have entered for [me] is invalid. Please enter the
 correct password

 WTF?!? this is indeed the correct root password.

 I've run the uninstall.app from terminal with sudo and, after
 prompting me for the password still does the same thing. doesn't like
 my password.

 I need to get rid of all traces of JRun and CF7 so I can install a
 diff version. and I've astounded a couple of Mac friends with this
 grief.


 any suggestions?
 anyone come across this before?

 thanx
 b




 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Strange calculation behavior on CF 7.02

2007-02-20 Thread Andrew Scott
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 some form of docs etc. And to expect CF not to have this problem
is where he got our backs up, not that it should have been documented
somewhere but his quote says it all.

 

 



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 Steve Armstrong
Sent: Tuesday, 20 February 2007 8:47 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Strange calculation behavior on CF 7.02

 

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
documentation and training guides - which is what Gareth was suggesting.
Robin's suggestion looks to be the neatest solution so far. 

 

Steve

 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Query Parameter List in the Error Structure

2007-02-20 Thread Scott Thornton

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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Query Parameter List in the Error Structure

2007-02-20 Thread Charles Condon


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: cfaussie@googlegroups.com
Subject: [cfaussie] Query Parameter List in the Error Structure


Hi Charlie,

Using CF MX 6.1. 

Damn.




__
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright.  If you
have received this email in error, please advise the sender and delete
it.  If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone.  You must not copy or 
communicate to others content that is confidential or subject to 
copyright, unless you have the consent of the content owner.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Strange calculation behavior on CF 7.02

2007-02-20 Thread Andrew Scott
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 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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Strange calculation behavior on CF 7.02

2007-02-20 Thread Robin Hilliard

 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 optional second  
argument to round(), fix(), ceil() etc that defaulted to 0 and  
specified the number of decimal places to round to (Excel VBA has this).

I imagine that changing the type used to represent numbers internally  
or building rounding into all number handling may impact legacy cf  
apps and server performance - I would be against a change if either  
were true.

Cheers,
Robin


__

Robin Hilliard
Director - RocketBoots Pty Ltd
Consulting . Recruitment . Software Licensing . Training
http://www.rocketboots.com.au

For schedule/availability call Pamela Higgins:
w+61 7 5451 0362
m+61 419 677 151
f+61 3 9923 6261
e[EMAIL PROTECTED]

or Direct:
m+61 418 414 341
e[EMAIL PROTECTED]


On 21/02/2007, at 10:32 AM, Rod Higgins wrote:


 Hi Robin,

 What exactly is a 'CF number'? It seems to be CF can store it as a  
 string or
 a double / float depending on the way it is constructed or what  
 methods are
 used on the var. I agree with Gareth in that CF needs to make untyped
 numbers in CF more consistent. The values generated from Gareth's code
 shouldn't happen and no I don't agree with the opinion it is a  
 fault / known
 issue of the Java language, it is simply the way CF was written to  
 use Java.
 They decided to go with a smaller memory footprint for storing numeric
 values. This is a very annoying issue when dealing with very small  
 numbers
 in CF and has driven me nuts plenty of times before.

 Obviously using BigDecimal for every numeric in CF would use too  
 much memory
 but maybe some option for the construction of 'CF numbers' so  
 developers can
 choose to be more precise.

 Rod

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Strange calculation behavior on CF 7.02

2007-02-20 Thread Gareth Edwards





Andrew,

What option?

Cheers
Gareth.

Andrew Scott wrote:

  
  
  

  
  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 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?hl=en  -~--~~~~--~~--~--~---





[cfaussie] Re: Strange calculation behavior on CF 7.02

2007-02-20 Thread Andrew Scott
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 February 2007 1:41 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Strange calculation behavior on CF 7.02

 

Andrew,

What option?

Cheers
Gareth.

Andrew Scott wrote: 

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 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?hl=en
-~--~~~~--~~--~--~---



[cfaussie] Re: Query Parameter List in the Error Structure

2007-02-20 Thread Charlie Arehart

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, coldfusion.server.ServiceFactory)
cfset debug = factory.DebuggingService.getDebugger().getData()

cfquery dbtype=query name=getqueries
select * from debug
where template = '#cgi.cf_template_path#' and type='SqlQuery'
/cfquery

cfoutput query=getqueries
Query name: #name#br
SQL statement: #body#br
cfdump var=#getqueries.attributes#!--- this is an array---
p
/cfoutput

!--- cfdump var=#debug# ---

Note that if you wanted to get just one particular query on a page, you
could add a WHERE clause for name='yourqueryname' in the Q of Q.

/Charlie
http://www.carehart.org/blog/  

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Tuesday, February 20, 2007 8:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Query Parameter List in the Error Structure


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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---