[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 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 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
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?? > > > > "java.math.BigDecimal").init(RandRange(100,1))> > "java.math.BigDecimal").init(a*2)> > "java.math.BigDecimal").init(val(a))> > > > #a#-#b#+#c# = #d# > > > 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? >> >> >> >> >> >> >> >> >> >> >> >> #d# >> >> >> 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
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: Strange calculation behavior on CF 7.02
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 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Robin Hilliard Sent: Wednesday, 21 February 2007 8:03 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Strange calculation behavior on CF 7.02 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?? > > > > "java.math.BigDecimal").init(RandRange(100,1))> > "java.math.BigDecimal").init(a*2)> > "java.math.BigDecimal").init(val(a))> > > > #a#-#b#+#c# = #d# > > > 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? >> >> >> >> >> >> >> >> >> >> >> >> #d# >> >> >> 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: Query Parameter List in the Error Structure
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: select * from employees where lastname = 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] 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: wierd problem: can't run CF7 uninstaller
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: wierd problem: can't run CF7 uninstaller
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
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] Re: Strange calculation behavior on CF 7.02
Gareth Why are you doing this: ? What's wrong with int() or round()? This strikes me as a very round about way to knock some decimals off. Is there some special reason for this, or is it an exercise in trying to confuse the CF engine as to whether its dealing with a number or a string? Darren On Feb 20, 11:04 am, Gareth Edwards <[EMAIL PROTECTED]> wrote: > --~--~-~--~~~---~--~~ 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
Darren, at first I didn't know what was causing it, so I was trying to pass some values around as strings rather than numbers. Hence the list part, I would not normally do that. Cheers Gareth. Darren Tracey wrote: Gareth Why are you doing this: ? What's wrong with int() or round()? This strikes me as a very round about way to knock some decimals off. Is there some special reason for this, or is it an exercise in trying to confuse the CF engine as to whether its dealing with a number or a string? Darren On Feb 20, 11:04 am, Gareth Edwards <[EMAIL PROTECTED]> wrote: --~--~-~--~~~---~--~~ 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
I apologize for my initial comments, at first I saw it a major problem with Coldfusion and was getting quite annoyed at it. I did later mention that it should be outlined in some sort of documentation. As far as nothing to do with Coldfusion, as Rod has outlined, although Coldfusion might not be the direct cause of the problem, I think Adobe should offer something that allows these calculations to return the correct result. Cheers Gareth. Andrew Scott wrote: 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:cfaussie@googlegroups.com] 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] Re: Strange calculation behavior on CF 7.02
Gareth, That comment is a fair call, but I doubt it will happen. Maybe I can wave some mojo. 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 11:48 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Strange calculation behavior on CF 7.02 I apologize for my initial comments, at first I saw it a major problem with Coldfusion and was getting quite annoyed at it. I did later mention that it should be outlined in some sort of documentation. As far as nothing to do with Coldfusion, as Rod has outlined, although Coldfusion might not be the direct cause of the problem, I think Adobe should offer something that allows these calculations to return the correct result. 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
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
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
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
> 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
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
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
OK, I've done a little digging and this works in CFMX 6 and 7: select * from employees where lastname = select * from debug where template = '#cgi.cf_template_path#' and type='SqlQuery' Query name: #name# SQL statement: #body# 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 -~--~~~~--~~--~--~---