[cfaussie] application.cfc and currentTemplatePath
Hi all, I'm using one main application.cfc in the main folder (CFMX7) and am extending that cfc in sub folders, the main cfc has the function currentTemplatePath in it, but when called through an extended cfc it gives the path of the extended cfc while I need the one in the main directory. anyone know of a solution to this other than hard coding the root path? Thanks in advance. -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 --~--~-~--~~~---~--~~ 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: application.cfc and currentTemplatePath
try this function *GetBaseTemplatePath() * On 3/8/07, Taco Fleur [EMAIL PROTECTED] wrote: Hi all, I'm using one main application.cfc in the main folder (CFMX7) and am extending that cfc in sub folders, the main cfc has the function currentTemplatePath in it, but when called through an extended cfc it gives the path of the extended cfc while I need the one in the main directory. anyone know of a solution to this other than hard coding the root path? Thanks in advance. -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 -- If you are not living on the edge, You are taking up too much space. --~--~-~--~~~---~--~~ 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: application.cfc and currentTemplatePath
Actually now you dont need to do that either. First of, the extended application should never change the application name, so in your case that is what I am going to assume. Secondly the onApplicationStart will on be fired the once, hence when you place the setting of that variable you can do this. cfset Application.AppPath = ExpandPath('.') / Now you can be safe and cflock that if you want to be sure, but that's all you really need to do. Regards, Andrew Scott On 3/8/07, AJ Mercer [EMAIL PROTECTED] wrote: try this function *GetBaseTemplatePath() * On 3/8/07, Taco Fleur [EMAIL PROTECTED] wrote: Hi all, I'm using one main application.cfc in the main folder (CFMX7) and am extending that cfc in sub folders, the main cfc has the function currentTemplatePath in it, but when called through an extended cfc it gives the path of the extended cfc while I need the one in the main directory. anyone know of a solution to this other than hard coding the root path? Thanks in advance. -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 -- If you are not living on the edge, You are taking up too much space. -- 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: application.cfc and currentTemplatePath
Ohh, Remove the Expand Path off those. cfset Application.AppPath = 'C:\AppPath\' / cfset Application.AppPath = '\BaseAppPath\#application.name#\' / Regards Dale Fraser http://dale.fraser.id.au/blog/ http://dale.fraser.id.au/blog/ _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Thursday, 8 March 2007 8:44 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: application.cfc and currentTemplatePath Andrew, That method is prone to errors if your site has multiple directories and users book mark directories, rare but if 1. The application restarts (server or cf) 2. The next user that logs in does so from a directory bookmark Since applications don't move generally cfset Application.AppPath = ExpandPath('C:\AppPath\') / In onApplicationStart is safer and fail safe. If you don't like hard coding and you have some standard naming of directories you can go with something like cfset Application.AppPath = ExpandPath('\BaseAppPath\#application.name#\') / Regards Dale Fraser http://dale.fraser.id.au/blog/ http://dale.fraser.id.au/blog/ _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, 8 March 2007 7:36 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: application.cfc and currentTemplatePath Actually now you dont need to do that either. First of, the extended application should never change the application name, so in your case that is what I am going to assume. Secondly the onApplicationStart will on be fired the once, hence when you place the setting of that variable you can do this. cfset Application.AppPath = ExpandPath('.') / Now you can be safe and cflock that if you want to be sure, but that's all you really need to do. Regards, Andrew Scott On 3/8/07, AJ Mercer [EMAIL PROTECTED] wrote: try this function GetBaseTemplatePath() On 3/8/07, Taco Fleur [EMAIL PROTECTED] wrote: Hi all, I'm using one main application.cfc in the main folder (CFMX7) and am extending that cfc in sub folders, the main cfc has the function currentTemplatePath in it, but when called through an extended cfc it gives the path of the extended cfc while I need the one in the main directory. anyone know of a solution to this other than hard coding the root path? Thanks in advance. -- Taco Fleur - http://www.pacificfox.com.au http://www.pacificfox.com.au/ Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 . -- If you are not living on the edge, You are taking up too much space. 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: OT: webdu birds of a feather
that's the trouble with WebDU this year: too much good stuff going on. I don't think I'll have my clone ready in time. On 3/8/07, Scott Barnes [EMAIL PROTECTED] wrote: Ditto :) although I'll need to come in a dark trenchcoat and glasses :) - can i bring my spyware camera to ..ya know.. let corp know :) On 3/8/07, Toby Tremayne [EMAIL PROTECTED] wrote: I;d definitely consider getting up early for extra time with the Apollo gods :) Toby On 08/03/2007, at 16:42 , Gareth Edwards wrote: I would like to attend one of the BOFs. Most probably the Apollo one. Cheers Gareth. Geoff Bowers wrote: On Mar 7, 10:21 am, Geoff Bowers [EMAIL PROTECTED] wrote: My mention of webdu birds of a feather sparked some interest from various CF vagabonds. Was hoping to poll the collective brains trust of folks on cfaussie webdu'ers as to what they would like to see and if anyone wants to put their hand up for an early morning session. So can I confirm we have the following three BOFs or thereabouts? FarCry 4.0 --- Mat Bryant (coordinator) potential speaker ring-ins - Jeff Coughlin Apollo --- Andrew Muller (coordinator) potential speaker ring-ins - Mike C - Mike D - Ted Patrick CF Components (?) --- Mark Mandel (coordinator) Charlie Arehart (coordinator) All this assumes we can get people to stumble in around 8am ;) Any more thoughts? -- geoff http://www.daemon.com.au/ --- Life is poetry, write it in your own words --- Toby Tremayne Senior Technical Consultant Lyricist Software 0416 048 090 ICQ: 13107913 -- Regards, Scott Barnes http://www.mossyblog.com --~--~-~--~~~---~--~~ 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: CFquery SUM
Hi Claude If you want quick and nasty without a second query you could try select tt.*, tcost.total from transaction_table tt, ( select sum(cost) from transaction_table where transaction_month = 'December' /* Same as like with no % */ ) as tcost where transaction_month = 'December' This will do a cartesian join on the single row in the subquery (treated as a veiw so only called once) and the results so each row will have the total cost. The other way would be a second query that gets the total cost (basically the same as what I've done) Shane On 3/8/07, M@ Bourke [EMAIL PROTECTED] wrote: Hi Claude, This isn't syntactically best practice but if I understand your question do. Select fieldnames (Select sum(cost) as total_cost from transactions_table where transaction_month like 'December') AS total_cost from transactions_table where transaction_month like 'December' this way every total_cost in the output will be the same M@ On 3/7/07, claude raiola [EMAIL PROTECTED] wrote: Hi I have a query and I am wanting to determine the total sum of the cost field for all those matching records so that I can determine the total amount of cost of all records found by the query I know I can create the formula to add the values through each pass of the output of the cfloop of the query, however I am wondering if I can do the same within the query eg cfquery name=monthly_cost Select sum(cost) as total_cost,* from transactions_table where transaction_month like 'December' /cfquery so the the value #monthly_cost.total_cost# has value of the sum of all cost values from the records found in the query Kind Regards Claude Raiola B.Econ(Acc.); B.Hotel Mngt. Mobile: 0414 228 948 Phone: 07 5527 1990 Fax: 07 3319 6444 Websites: www.WebsiteSolutions.com.au http://www.websitesolutions.com.au/ www.AustralianAccommodation.comhttp://www.australianaccommodation.com/ www.AccommodationNewZealand.comhttp://www.accommodationnewzealand.com/ www.HospitalityPurchasing.net http://www.hospitalitypurchasing.net/ www.Samaris.net http://www.samaris.net/ --~--~-~--~~~---~--~~ 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: OT: webdu birds of a feather
As much as I hate early mornings, I'm sure I can drag myself out of bed to be there by 8am. Whether I am fully dressed is another matterpants may be optional :) Cheers Mark --~--~-~--~~~---~--~~ 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] [Ann-Syd] Flex Basics - Sydney Flash Developers Group
Tue 13 March 6pm. Introduction to Flex Basics. This is a joint meeting with The Programming Special Interest Group of Sydney PC Users Group. 6pm start. Please note this meetings venue has changed. 1st Floor, The Sydney Mechanics School of Arts, 280 Pitt Street, Sydney. Please RSVP on http://www.flashdev.org.au/rsvp Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095 www.flashdev.org.au --~--~-~--~~~---~--~~ 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] QLD CFUG March meeting announcement.
WOW! this looks like a big meeting for this months Queensland CFUG and is bound to be a not to be missed event. Why? Because we're all gearing up for the next version of ColdFusion: CF8, which is currently known (or so we're told) as Scorpio. but it's in beta! you say and none can say what's in it for fear of Saurons spies finding out there's lots to find out, believe it or not, if you know where to look. We have our super-sleuth detectives hard at work, reading between the lines in press releases, unraveling the red herrings, leaving no unturned stone... er, unturned (wha-tever!) to prove the point, we've even tracked down a date it'll be released http://www.numtopia.com/terry/blog/archives/2007/03/scorpio_in_august.cfm (and there's other reasons of the suggested date that didn't make it to the comments - come along and find out why) So join us this Wednesday's CFUG and discover the secrets to Dan Brown's unwritten mystery thriller... The Scorpio Code [any references to actual deities or prophets, living or dead, is purely coincidental...] Also this month, we'll be giving the subject of Flex and Coldfusion Data-typing a darn good shake with full demonstrations and seeing what's happening behind the scenes. What works? what's doesn't? and is wishful thinking? guaranteed to save you time putting a Flex front end to your ColdFusion server code. And, as this will be the CFUG's pre-WebDU meeting for this year, we'll be looking at what's on offer at WebDU, how to try and survive wanting to be in three WebDU sessions at the same time - and how to still get something out of it if the boss still refuses to let you go. so, if you're not already a member, sign up to the QLD CFUG usergroup http://groups.google.com/group/qldcfug/ and that will give us your RSVP so you can go into the prize draw (and ensure we do a good job on catering) - we hope to see you there cheers The QLD CFUG crew. Meeting Details: 6:30 pm - ?, Wednesday, 14th March 2007 If doors are locked, call 0414 328 902 for entry QANTM Auditorium QANTM House Level 9, 138 Albert St Brisbane City (Opposite the Coffee Club) Find it on WHEREIS: http://www.whereis.com/whereis/retrieveEmailMap.do?linkId=-;7243212240990709884 Find it on Google Maps: http://maps.google.com/maps?f=qhl=enq=138+Albert+St,+City+QLD+4000,+Australiaie=UTF8sll=37.0625,-95.677068sspn=28.168051,68.90625z=17om=1iwloc=addr --~--~-~--~~~---~--~~ 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: QLD CFUG March meeting announcement.
You're just too cool for school Barry :) On 3/9/07, Barry Beattie [EMAIL PROTECTED] wrote: WOW! this looks like a big meeting for this months Queensland CFUG and is bound to be a not to be missed event. Why? Because we're all gearing up for the next version of ColdFusion: CF8, which is currently known (or so we're told) as Scorpio. but it's in beta! you say and none can say what's in it for fear of Saurons spies finding out there's lots to find out, believe it or not, if you know where to look. We have our super-sleuth detectives hard at work, reading between the lines in press releases, unraveling the red herrings, leaving no unturned stone... er, unturned (wha-tever!) to prove the point, we've even tracked down a date it'll be released http://www.numtopia.com/terry/blog/archives/2007/03/scorpio_in_august.cfm (and there's other reasons of the suggested date that didn't make it to the comments - come along and find out why) So join us this Wednesday's CFUG and discover the secrets to Dan Brown's unwritten mystery thriller... The Scorpio Code [any references to actual deities or prophets, living or dead, is purely coincidental...] Also this month, we'll be giving the subject of Flex and Coldfusion Data-typing a darn good shake with full demonstrations and seeing what's happening behind the scenes. What works? what's doesn't? and is wishful thinking? guaranteed to save you time putting a Flex front end to your ColdFusion server code. And, as this will be the CFUG's pre-WebDU meeting for this year, we'll be looking at what's on offer at WebDU, how to try and survive wanting to be in three WebDU sessions at the same time - and how to still get something out of it if the boss still refuses to let you go. so, if you're not already a member, sign up to the QLD CFUG usergroup http://groups.google.com/group/qldcfug/ and that will give us your RSVP so you can go into the prize draw (and ensure we do a good job on catering) - we hope to see you there cheers The QLD CFUG crew. Meeting Details: 6:30 pm - ?, Wednesday, 14th March 2007 If doors are locked, call 0414 328 902 for entry QANTM Auditorium QANTM House Level 9, 138 Albert St Brisbane City (Opposite the Coffee Club) Find it on WHEREIS: http://www.whereis.com/whereis/retrieveEmailMap.do?linkId=-;7243212240990709884 Find it on Google Maps: http://maps.google.com/maps?f=qhl=enq=138+Albert+St,+City+QLD+4000,+Australiaie=UTF8sll=37.0625,-95.677068sspn=28.168051,68.90625z=17om=1iwloc=addr -- Regards, Scott Barnes http://www.mossyblog.com --~--~-~--~~~---~--~~ 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] SQL Server 2005 - latest version?
Have applied SP2 and have a critical patch supplied today (automatically which is not too appreciated - at least for SQL Server)... States current version is: Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86) Mar 2 2007 20:01:28 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2) Is this the latest or is something even newer out? I don't need any of the Vista rubbish either :) --~--~-~--~~~---~--~~ 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] Flex List
Hey guys, I need a flex list to ask questions. Do we do it here on aussie or is there one specific to flex. if so whats the url. I'm getting dirty with flex and I'm coming up not smellin of roses. jeremy --~--~-~--~~~---~--~~ 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: Flex List
flexcoders? cfgroupie wrote: Hey guys, I need a flex list to ask questions. Do we do it here on aussie or is there one specific to flex. if so whats the url. I'm getting dirty with flex and I'm coming up not smellin of roses. jeremy -- Haikal Saadh Applications Programmer ICT Resources, TALSS QUT Kelvin Grove --~--~-~--~~~---~--~~ 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: Flex List
flexaussie and flexcoders http://groups.yahoo.com/group/flexcoders http://groups.yahoo.com/group/flexaussie On 09/03/2007, at 5:01 PM, cfgroupie [EMAIL PROTECTED] wrote: Hey guys, I need a flex list to ask questions. Do we do it here on aussie or is there one specific to flex. if so whats the url. I'm getting dirty with flex and I'm coming up not smellin of roses. jeremy --~--~-~--~~~---~--~~ 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: Flex List
Try http://groups.yahoo.com/group/flexaussie/ or http://groups.yahoo.com/group/flexcoders/ Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095 www.flashdev.org.au --~--~-~--~~~---~--~~ 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: QLD CFUG March meeting announcement.
The QLD meetings have been awesome - at least the few I managed to visit when in QLD. The camaraderie is hard to beat. A few drinks and pizza - never got that sort of stuff for my UG unfortunately. The sheer depth of presentations, at QLDCFUG, and the varying uses of technology (then Macromedia now Adobe) was amazing. And they manage to get gurus like Tim Buntel for meetings too - that was way back for MX7. And here we are on the verge of so many new Adobe coolness it hurts. Best I have managed was a Saturday phone call from Charlie Arehart from San Francisco. But that was a great conversation at least. I wish I had more help with our UG as the work is building up and sleep is becoming a luxury. So I won't WebDU 2007 (still paying for last year when I shouted a mate lol) but for those that are - enjoy! Maybe next year! -- Peter Tilbrook ColdGen Internet Solutions President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA http://www.coldgen.com/ http://www.actcfug.com/ Tel: +61-2-6284-2727 Mob: +61-0432-897-437 Email: [EMAIL PROTECTED] MSN Messenger Live: Desktop General --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---