[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

[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.

[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:

[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 =

[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

[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

[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

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

[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

[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

[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

[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,