Re: Convert XML doc to array or structure or query?
Yes: XLMParse() A CF XML object is a series of nested arrays of structs. On 3/10/07, Andy Matthews [EMAIL PROTECTED] wrote: Does anyone have code that will take an XML doc (any doc) and convert it to a series of nested structures or arrays or queries or some combination? I'm working on my basecamp API and I'd like to offer users the option of receiving the data in XML (the default format) or other formats. I checked cflib and found lots of stuff that converts those other formats into XML, but none that go the other way. Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Convert XML doc to array or structure or query?
Or even XMLParse() when spelled properly. On 3/11/07, James Holmes [EMAIL PROTECTED] wrote: Yes: XLMParse() A CF XML object is a series of nested arrays of structs. On 3/10/07, Andy Matthews [EMAIL PROTECTED] wrote: Does anyone have code that will take an XML doc (any doc) and convert it to a series of nested structures or arrays or queries or some combination? I'm working on my basecamp API and I'd like to offer users the option of receiving the data in XML (the default format) or other formats. I checked cflib and found lots of stuff that converts those other formats into XML, but none that go the other way. Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Escaping ampersands
Okay, I can usually figure out my regular expressions when needed, but this one has me a bit stumped. Basically I have an unknown chunk of text in which I need to make sure any URLs are XHTML-compliant...i.e. any ampersands are escaped, if not already. I need to be sure to only replace within the a tags, not the rest of the text, and to not replace any ampersands that are already escaped. Anyone want to take a stab at it? --- Mary Jo ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping ampersands
Assuming what you're actually asking is how to escape any ampersands that are not part of an existing entity, try this... REReplace(Text,(?!([##A-Za-z0-9]{2,6};)),amp;,all) (because any non-entity ampersands must be escaped everywhere, not just in links) Okay, I can usually figure out my regular expressions when needed, but this one has me a bit stumped. Basically I have an unknown chunk of text in which I need to make sure any URLs are XHTML-compliant...i.e. any ampersands are escaped, if not already. I need to be sure to only replace within the a tags, not the rest of the text, and to not replace any ampersands that are already escaped. Anyone want to take a stab at it? --- Mary Jo ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping ampersands
Hmm, the result argument is displaying as just [ampersand], but I definitely put [ampersand]amp; in it. :/ Assuming what you're actually asking is how to escape any ampersands that are not part of an existing entity, try this... REReplace(Text,(?!([##A-Za-z0-9]{2,6};)),amp;,all) (because any non-entity ampersands must be escaped everywhere, not just in links) Okay, I can usually figure out my regular expressions when needed, but this one has me a bit stumped. Basically I have an unknown chunk of text in which I need to make sure any URLs are XHTML-compliant...i.e. any ampersands are escaped, if not already. I need to be sure to only replace within the a tags, not the rest of the text, and to not replace any ampersands that are already escaped. Anyone want to take a stab at it? --- Mary Jo ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Timezone.cfc and US DST changes
Running 7.02 and 1.4.2_11 JVM and using Paul Hastings' timezone.cfc to calculate various times around the globe. It looks like I'm getting errors because of the change in US DST when using the castFromServer method. The time on the server is correct. If my understanding is correct I thought castFromServer generated the correct time factoring in DST. Can someone confirm/deny that the cast from server time is incorrect for EST (for example) on the timezone.cfc test page? http://www.sustainablegis.com/projects/tz/testTZCFC.cfm Am I supposed to manually factor in the DST difference (or is this something else)? Thanks. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
Hi Gareth, I don't use the timezone.cfc, but the time shown on the testsite for my timezone using castFromServer is definitely 1 hour off. It is not considering the DST change. Cheers, Kris Running 7.02 and 1.4.2_11 JVM and using Paul Hastings' timezone.cfc to calculate various times around the globe. It looks like I'm getting errors because of the change in US DST when using the castFromServer method. The time on the server is correct. If my understanding is correct I thought castFromServer generated the correct time factoring in DST. Can someone confirm/deny that the cast from server time is incorrect for EST (for example) on the timezone.cfc test page? http://www.sustainablegis.com/projects/tz/testTZCFC.cfm Am I supposed to manually factor in the DST difference (or is this something else)? Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
Thanks Kris I appreciate the confirmation. As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping ampersands
Assuming what you're actually asking is how to escape any ampersands that are not part of an existing entity, try this... Hhm, yeah that might work. I really don't need to worry too much about any ampersands outside links (without getting too into detail, they are generally escaped earlier) but wouldn't mind making sure they are all done. Problem is if the text block has any javascript code embedded, which is possible, I don't want to replace ampersands in there too. --- Mary Jo ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping ampersands
Hmmm, in that case I'd probably replace out any JS ones first, then run the above, then swap back in the JS ones. And the easiest way of doing that would probably be something like this: cfset Text = JREReplace(Text,(?=script[^]*).*?(?=/script),RemoveJsAmp,all)/ [code from above] cfset Text = JREReplace(Text,(?=script[^]*).*?(?=/script),RestoreJsAmp,all)/ Where JREReplace is a handy function by Ben Nadel which allows use of regex callback functions. ( See http://www.bennadel.com/index.cfm?dax=blog:191.view ) And the two callback functions mentioned above would be along the lines of: cffunction name=RemoveJsAmp cfargument name=Text/ cfreturn REReplace(Arguments.Text,'','{{AMP}}','all')/ /cffunction cffunction name=RestoreJsAmp cfargument name=Text/ cfreturn REReplace(Arguments.Text,'{{AMP}}','','all')/ /cffunction Assuming what you're actually asking is how to escape any ampersands that are not part of an existing entity, try this... Hhm, yeah that might work. I really don't need to worry too much about any ampersands outside links (without getting too into detail, they are generally escaped earlier) but wouldn't mind making sure they are all done. Problem is if the text block has any javascript code embedded, which is possible, I don't want to replace ampersands in there too. --- Mary Jo ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Timezone.cfc and US DST changes
As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. Hate to burst your bubble but according to the Sun website, your JVM is too old... http://java.sun.com/developer/technicalArticles/Intl/USDST/ They state the version that has the correct timezone calcs is 1.4.2_13 Before you go any further, I'd update to the right version of the JVM and re-test. Paul ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
Thanks Paul, I found that same page earlier but 1.4.2_11 is the latest officially recognised JVM by Adobe and although Sun say _13 is required they (sun and adobe) both say _11 supports the US DST changes: http://java.sun.com/developer/technicalArticles/Intl/USDST_Faq.html#jdkversion http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=d2ab4470 Having said that, according to my tests it looks as though _11 is returning the wrong info so I'll upgrade the JVM and see if it makes a difference. - Original Message - From: Paul Vernon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, March 11, 2007 8:36 PM Subject: RE: Timezone.cfc and US DST changes As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. Hate to burst your bubble but according to the Sun website, your JVM is too old... http://java.sun.com/developer/technicalArticles/Intl/USDST/ They state the version that has the correct timezone calcs is 1.4.2_13 Before you go any further, I'd update to the right version of the JVM and re-test. Paul ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Subject: How to invoke a method from inside another method in a cfc
Hello everybody, somebody knows how can I invoke a method from inside another method in a cfc? Please help me! I have something like this: cffunction name=method1... ... cfif... do method 2 /cfif /cffunction cffunction name=method2... ... /cffunction Thanks for your help ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
it's the same on _13 - Original Message - From: Paul Vernon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, March 11, 2007 8:36 PM Subject: RE: Timezone.cfc and US DST changes As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. Hate to burst your bubble but according to the Sun website, your JVM is too old... http://java.sun.com/developer/technicalArticles/Intl/USDST/ They state the version that has the correct timezone calcs is 1.4.2_13 Before you go any further, I'd update to the right version of the JVM and re-test. Paul ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Subject: How to invoke a method from inside another method in a cfc
All you need to do is simply call the method: cffunction name=method1... ... cfif... cfset method2() / /cfif /cffunction cffunction name=method2... /cffunction HTH, Rich Kroll ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping ampersands
Where JREReplace is a handy function by Ben Nadel which allows use of regex callback functions. ( See http://www.bennadel.com/index. cfm?dax=blog:191.view ) That's some pretty neat stuff, I definitely will bookmark that for the future. I've found a work-around for my particular application so I don't have to do a regex replace, I didn't want it getting too complex as it's going to run pretty frequently under load. MJS ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
That is interesting then, as if _13 is the version to use, everyone who uses it with ColdFusion is technically unsupported by Adobe. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Gareth Hughes To: CF-Talk Sent: Sun Mar 11 21:29:05 2007 Subject: Re: Timezone.cfc and US DST changes .it's the same on _13 - Original Message - From: Paul Vernon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, March 11, 2007 8:36 PM Subject: RE: Timezone.cfc and US DST changes As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. Hate to burst your bubble but according to the Sun website, your JVM is too old... http://java.sun.com/developer/technicalArticles/Intl/USDST/ They state the version that has the correct timezone calcs is 1.4.2_13 Before you go any further, I'd update to the right version of the JVM and re-test. Paul ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Fwd: Subject: How to invoke a method from inside another method in a cfc
can't you just cfinvoke the method from inside the first method? -Ken -- Forwarded message -- From: Mike Oldfield [EMAIL PROTECTED] Date: Mar 11, 2007 4:58 PM Subject: Subject: How to invoke a method from inside another method in a cfc To: CF-Talk cf-talk@houseoffusion.com Hello everybody, somebody knows how can I invoke a method from inside another method in a cfc? Please help me! I have something like this: cffunction name=method1... ... cfif... do method 2 /cfif /cffunction cffunction name=method2... ... /cffunction Thanks for your help ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java to CF translation
Andrew, Are you saying that I can almost directly copy and paste that java example into a cfscript block? What you have in this email seems to be a copy of the wiki example... Duncan, This is off the top of my head, but you would be best to do it this way, and remember cfdump is your friend here too. script for ( Iterator entries = logEntries.iterator( ); entries.hasNext( ) ; ) { logEntry = entries.next( ); WriteOutput( - ); WriteOutput(revision: + logEntry.getRevision( ) ); WriteOutput( author: + logEntry.getAuthor( ) ); WriteOutput( date: + logEntry.getDate( ) ); WriteOutput( log message: + logEntry.getMessage( ) ); if ( logEntry.getChangedPaths( ).size( ) 0 ) { WriteOutput( ); WriteOutput( changed paths: ); /script On 3/9/07, Duncan [EMAIL PROTECTED] wrote: ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java to CF translation
Sorry - on closer examination that isnt the case. I will get back to you and we can see if this is more on the right lines. Andrew, Are you saying that I can almost directly copy and paste that java example into a cfscript block? What you have in this email seems to be a copy of the wiki example... ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
coldfusion and jboss/tomcat
Hi! I'm enjoying running CF on jboss/tomcat, with the sole exception being- JBoss wants everything under the root context (say, /cfusion) It wouldn't be a problem if all my projects were set up to not care, but sadly, some of them expect to be @ / vs /cfusion/cfapp/. I could set up a context for each CF app, but I've got like 20 of them, and I don't really want to put a WEB-INF folder in each. Or add 20 tomcat virtual hosts to match my apache virtual hosts. I've got apache set up to use mod_proxy_ajp, and my projects are all hosted at 127.0.0.1, with different host names, using apache NamedVirtualHosts. (http://proj1/, http://proj2/, etc.) Any suggestions on how to use a single CF instance to serve multiple websites when running on top of tomcat/jboss? I like separate instances for production, but I've only got s much RAM locally. -- All truth is simple... is that not doubly a lie? -Friedrich Nietzsche ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Timezone.cfc and US DST changes
Thanks Paul, I found that same page earlier but 1.4.2_11 is the latest officially recognised JVM by Adobe and although Sun say _13 is required they (sun and adobe) both say _11 supports the US DST changes: http://java.sun.com/developer/technicalArticles/Intl/USDST_Faq .html#jdkversion http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=d2ab4470 To a point, _13 has updates to the timezone data that don't exist in _11 Having said that, according to my tests it looks as though _11 is returning the wrong info so I'll upgrade the JVM and see if it makes a difference. it's the same on _13 That seems to be a problem then Have you read: http://java.sun.com/developer/technicalArticles/Intl/alert.html and http://java.sun.com/developer/technicalArticles/Intl/alertFurtherInfo.html Paul ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
Gareth Hughes wrote: because of the change in US DST when using the castFromServer method. The welcome to timezone hell: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77 the older versions of that CFC used datetime objects which are subject to cf's eccentricities when it comes to datetime handling. besides the stuff i outlined in that blog entry, one of its quirks is that dateConvert() doesn't take DST into account when converting to/from UTC. and that's what castFromServer() uses: cfreturn castFromUTC(dateConvert(local2UTC,arguments.thisDate),arguments.thisTZ) the newer versions of that CFC (which some OS projects like machIIblog use) uses java epoch offsets instead of datetimes (again i need to give credit to spike for helping me stop over-thinking the solution). since this is kind of a big hit in terms of an application (changing data from datetimes to longs) i've let this version of the CFC stand handled stuff on a case-by-case basis. confirm/deny that the cast from server time is incorrect for EST (for example) on the timezone.cfc test page? hmm, i guess i need to talk to my host (cfdynamics) though they are usually so good about this kind of thing i kind of forget about them ;-) Am I supposed to manually factor in the DST difference (or is this something else)? Thanks. review the suggested solutions in that blog entry. i understand that swapping server tz or making changes to data isn't very palatable for long established apps, so let me see if i can come up w/a workaround for the short term. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
Yes :( To clarify, if you use _11 then EST is reported as being in DST. If you use _13 then EST is not reported as being in DST. This is as expected according to the alerts from Sun. The problem is, whether you use EST (_11) or America/New_York (_13), the returned time offset (and hence the time) calculated by the cfc (which, I believe, is calculated by the jvm) is incorrect. In other words, the cfc recognises the fact that the time zone is in DST but does not appear to factor it into the returned time. All other time zones in DST, other than those affected by the US changes, are reported correctly. it's the same on _13 That seems to be a problem then Have you read: http://java.sun.com/developer/technicalArticles/Intl/alert.html and http://java.sun.com/developer/technicalArticles/Intl/alertFurtherInfo.html Paul ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
Paul Vernon wrote: http://java.sun.com/developer/technicalArticles/Intl/alert.html and http://java.sun.com/developer/technicalArticles/Intl/alertFurtherInfo.html those aren't very relevant to the real issue at hand (dateConvert's behavior w/DST) while sun's blaming the olson data, ibm (well the icu4j project anyway) is blaming sun's tz IDs. there are plenty of short IDs that overlap, for instance see the entries for EST here: http://www.timeanddate.com/library/abbreviations/timezones/ for icu4j's take on this see: http://icu-project.org/userguide/dateTimezone.html ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
'timezone hell'. Oh boy :) Thanks for the reply Paul, I'm reading the blog post now... - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 12:19 AM Subject: Re: Timezone.cfc and US DST changes Gareth Hughes wrote: because of the change in US DST when using the castFromServer method. The welcome to timezone hell: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Can I use CLIENT variable storage with MySQL 5?
I'm trying very hard to figure out how to get MySql 5 to work with CF client variable storage. I need that... its a requirement. Has anybody done it before? The CF administrator does not have it built in, and when I try to manually create CFDATA and CFGLOBAL, my front end app errors out with a 500 database error. Thank you, Jon ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Java to CF translation
andrew, Thanks for the push here is what I ended up with: cfif f.getChangedPaths().size() gt 0 cfset changedPathsSet = f.getChangedPaths().keySet() cfset changedPaths = changedPathsSet.iterator() cfloop condition=changedPaths.hasNext() cfset t=changedPaths.next() cfset QueryAddRow(Q) cfset Q.Message[Q.RecordCount]=f.getMessage() cfset Q.Date[Q.RecordCount]=f.getDate() cfset Q.Author[Q.RecordCount]=f.getAuthor() cfset Q.Revision[Q.RecordCount]=f.getRevision() cfset Q.Path[Q.RecordCount]=t /cfloop /cfif Duncan, This is off the top of my head, but you would be best to do it this way, and remember cfdump is your friend here too. script for ( Iterator entries = logEntries.iterator( ); entries.hasNext( ) ; ) { logEntry = entries.next( ); WriteOutput( - ); WriteOutput(revision: + logEntry.getRevision( ) ); WriteOutput( author: + logEntry.getAuthor( ) ); WriteOutput( date: + logEntry.getDate( ) ); WriteOutput( log message: + logEntry.getMessage( ) ); if ( logEntry.getChangedPaths( ).size( ) 0 ) { WriteOutput( ); WriteOutput( changed paths: ); /script On 3/9/07, Duncan [EMAIL PROTECTED] wrote: ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: coldfusion and jboss/tomcat
JBoss wants everything under the root context (say, /cfusion) I don't use JBoss for CF, but can't you just define the context root as / when you build your CF WAR/EAR? That's how CF works with JRun by default. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4