now( ) is off by an hour

2013-03-12 Thread daniel kessler
I am working on an application that does it's own timeout, at 45 minutes. It gets the last logged in time and compares it to the database current time. The database time is correct. However, the now() time is incorrect by an hour. I assume this is due to daylight savings time. So where

RE: now( ) is off by an hour

2013-03-12 Thread DURETTE, STEVEN J
Check the date and time on the ColdFusion server. Also, make sure that your DB server and ColdFusion server are in the same time zone. -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: Tuesday, March 12, 2013 8:49 AM To: cf-talk Subject: now( ) is off by an hour

Re: now( ) is off by an hour

2013-03-12 Thread Paul Hastings
On 3/12/2013 7:48 PM, daniel kessler wrote: So where does now() get it's time? I'm on a VPN and that has the correct time when I check it's clock. Would it then be the server that hosts the VPN? Or someplace else? time could be fine but maybe JRE that cf is using is running in a different

Re: now( ) is off by an hour

2013-03-12 Thread daniel kessler
It's a localhost CFServer (developer mode). That is on a VPN that I am using. The VPN has the correct time. However the now() is incorrect. It was correct until daylight savings time. At this point, I assume that it's getting the time from the machine that is hosting the VPN, which means

Re: now( ) is off by an hour

2013-03-12 Thread Bobby
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions _m-r_07.html Gets the current date and time of the computer running the ColdFusion server It doesn't get its time form the VPN, it gets its time from the host machine running the CF service. Clock in the bottom right

Re: Adding Salt and Password Hash to existing acocunts

2013-03-12 Thread Torrent Girl
I've been playing around lately with hashing via both SQL Server 2008 and CF. The following should give you the same results in both: cfset hashpwd = hash(pwd uuid,SHA-1 ) SET @pwdHash = CONVERT(VARCHAR(40),HashBytes('SHA1', @pwd + @UUID),2) My understanding is, SQL Server 2012 is the only

Re: now( ) is off by an hour

2013-03-12 Thread daniel kessler
Thanks bobby. I can only see the VPN OS, not the computer that serves up the VPN. It sounds like I should ask them to check that server's time. thank you. It doesn't get its time form the VPN, it gets its time from the host machine running the CF service. Clock in the bottom right corner of

Re: now( ) is off by an hour

2013-03-12 Thread daniel kessler
I get: JRE:=Java(TM) 2 Runtime Environment, Standard Edition 1.4.2_09-b05 tz:=Eastern Daylight Time dst savings:=1 uses DST: YES in DST now: NO I saw that there is an update to 1.4.2_11, but that came out around 2007 I think. So I would need a more recent update. A coworker said that she

Re: now( ) is off by an hour

2013-03-12 Thread daniel kessler
I've been using the term VPN when I meant VM (virtual machine). Sorry about any confusion and thank you all for your help so far. ~| Order the Adobe Coldfusion Anthology now!

Re: Adding Salt and Password Hash to existing acocunts

2013-03-12 Thread Roger Austin
Torrent Girl moniqueb...@gmail.com wrote: Thanks. Is there any benefit to using SHA512 over anything else? What is the risk profile of the site? What regulations do you have to meet if any? i.e., FIPS-140-2? http://en.wikipedia.org/wiki/FIPS_140

Re: 32 vs 64 bit CF and DSNs

2013-03-12 Thread Claude Schnéegans
I finally pulled the plug on the 64 but and installed the 32 bit CF version. I'm also using CF 32bit, but it is because of some 32bit CFXs, but I did have the 64bit running with Access datasources. I have Access 2003 installed on the server, may be you need it to bring the correct 32bit

Validation Query Question

2013-03-12 Thread DeMarco, Alex
I have a question regarding Validation Query: The CF 9 online help says this about the Validation Query: Called when a connection from the pool is reused. This can slow query response time because an additional query is generated. You should specify this just before restarting the database

cfinvoke and Proxy Auto Configuration

2013-03-12 Thread Bill Franklin
Configuration: So our ColdFusion 9.0.1 instance has a dedicated active directory account under which the ColdFusion services run. It has been granted internet access by the network guys, and the internet configuration has been setup with a proxy auto configuration script, as our proxy

Re: cfinvoke and Proxy Auto Configuration

2013-03-12 Thread Russ Michaels
there is nothing special you need to do, as long as the server can make external connections to the internet that is all that is required. To confirm all permissions, simply login to the server as the AD user ColdFusion runs under and make sure you can make outward connections. On Tue, Mar 12,

Re: now( ) is off by an hour

2013-03-12 Thread Paul Hastings
On 3/12/2013 8:31 PM, daniel kessler wrote: JRE:=Java(TM) 2 Runtime Environment, Standard Edition 1.4.2_09-b05 kind of old problematic. When it says in dst now, that means that JVM thinks it's not in DST or that the computer does not think it's in DST? the JVM that cf's using thinks that

(ot) .NET vs. CF

2013-03-12 Thread Dave Hatz
I know I have seen a lot of threads on this in the past, but didn't pay much attention to them until now. I have been using CF since v4.0 and now we have clients telling us that we can not use CF anymore and that we need to switch to .NET. Now I know our client's upper management couldn't

RE: (ot) .NET vs. CF

2013-03-12 Thread Robert Harrison
To be honest, if the reason is that is what others are doing, wouldn't it be more appropriate to use PHP or Word Press? Those are in far greater use that .net. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct   125 Kennedy Drive,  

Re: (ot) .NET vs. CF

2013-03-12 Thread Justin Scott
For those of u on this list that have experience with both, can I please get your feedback on the Pros and Cons of going to the .NET framework from ColdFusion? Hi Dave, that will depend on what you're doing with it. I don't have anything against .NET and have done some coding with it. The

Re: (ot) .NET vs. CF

2013-03-12 Thread Gerald Guido
A couple of things come to mind. First is the primary reason I use CF: Speed of development. CF can be seen as a framework for Java much like jQuery is a framework for JavaScript. It takes care of the bulk of the heavy lifting and grunt work so you can focus on writing productive code. ,NET is a

Re: (ot) .NET vs. CF

2013-03-12 Thread Carl Von Stetten
Justin, With regard to a CFML engine running on .NET, New Atlanta has a BlueDragon .NET edition http://www.newatlanta.com/products/bluedragon/index.cfm that does exactly that. -Carl V. On 3/12/2013 2:07 PM, Justin Scott wrote: For those of u on this list that have experience with both, can

Re: now( ) is off by an hour

2013-03-12 Thread Carl Von Stetten
Daniel, What version of ColdFusion are you running? Maybe you can upgrade the JVM to a newer version that has updated DST settings? I think the start/end dates for DST in the US were changed in 2007, while Java 1.4 hasn't been current since around 2004. -Carl V. On 3/12/2013 6:31 AM,

Re: now( ) is off by an hour

2013-03-12 Thread Wil Genovese
Here is your answer: This JVM version is SO old that it has the OLD DST change over date. The DST change over dates changed in 2008. See this tech note from (Sun) Oracle. http://www.oracle.com/technetwork/java/javase/releasenotes-138306.html#142_19 Regards, Wil Wil Genovese Sr. Web

Re: (ot) .NET vs. CF

2013-03-12 Thread Justin Scott
With regard to a CFML engine running on .NET, New Atlanta has a BlueDragon .NET edition that does exactly that. Thanks Carl, I knew they had a Java version but wasn't aware of the .NET edition. Good to know if I ever run across one of those types of clients. -Justin

Re: (ot) .NET vs. CF

2013-03-12 Thread Carl Von Stetten
Justin, As a one-time Java BlueDragon user, I'd say the .NET version is the only reason I'd use BlueDragon over ACF at this point. They have fallen way behind in comparable feature support (last time I checked they were about equivalent to ACF 7/8). -Carl V. On 3/12/2013 3:49 PM, Justin

Re: (ot) .NET vs. CF

2013-03-12 Thread Andrew Scott
Justin... OpenBD began its days as a .Net engine... Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Mar 13, 2013 at 8:07 AM, Justin Scott leviat...@darktech.orgwrote: For those of u on this list that have

Re: (ot) .NET vs. CF

2013-03-12 Thread Andrew Scott
And I am sure that if you get to the real nuts and bolts of it, Java is more popular on the Enterprise level than .Net is. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Mar 13, 2013 at 9:00 AM, Gerald Guido

Re: (ot) .NET vs. CF

2013-03-12 Thread Adam Cameron
I can't vouch for New Atlanta itself, but BD.NET has not seen any activity for a number of years, and never got beyond CFMX 7 compat, as far as I can recollect. OpenBD is - as far as I can tell - a stagnant project (except for Alan doing what best suits Alan: fair enough... that was always the

Re: (ot) .NET vs. CF

2013-03-12 Thread Adam Cameron
This is a traditionally unpopular metric with CF developers, but there's this: http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html Java's more prevalent than .NET platform languages, but that's not a compelling reason to use either (/or). And let's not forget that CFML is not Java,

Re: (ot) .NET vs. CF

2013-03-12 Thread Russ Michaels
well, , being as it compiles to java byte code, and you can distribute any CFML app as pure JAVA, no CFML in sight, which would make it a java app. I have never tried this TBH, but I would presume you just deploy your app as a war file, so it presumably would not even need a CFML engine, it will

Re: (ot) .NET vs. CF

2013-03-12 Thread Adam Cameron
Well that's fine (and, yes, that's how you do the deployment). But a language is what you type in to the IDE or text editor, not what it compiles down to, or that one deploys. Java byte code is no more Java than CFML is, for that matter. CFML is not Java. Java is Java. A better defence of

Re: (ot) .NET vs. CF

2013-03-12 Thread Andrew Scott
Russ, From memory as I haven't done it for awhile, is that the runtime is bundled with your application meaning you need to supply a serial number with the war as well. All that assumption was prior to ColdFusion 10, so it may handle it differently. Regards, Andrew Scott WebSite:

Re: (ot) .NET vs. CF

2013-03-12 Thread Andrew Scott
No Adam, the compiled version is Java. Same as both Java and .Net compile down to a bytecode that is interpreted at the machine language level, which makes machine code not .Net or Java either :P Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+:

Re: (ot) .NET vs. CF

2013-03-12 Thread Gerald Guido
To the OP: CFML is withering away... get used to it. Take whatever opportunity you can to shift to a different language. Either .net-based languages or Java would be good options. * * True but tizz a crying shame. I have been all over the map but I have yet to find a replacement that I *really*

Re: (ot) .NET vs. CF

2013-03-12 Thread Dave Watts
Well that's fine (and, yes, that's how you do the deployment). But a language is what you type in to the IDE or text editor, not what it compiles down to, or that one deploys. Java byte code is no more Java than CFML is, for that matter. CFML is not Java. Java is Java. That's true from a