> Hi guys, thanks for the responses. For some reason I'm not > getting email > from this group suddenly -- I had to see the responses to > my post on the > dfwcfug website (very cool to have those up to date > archives there!).
> Btw the reason I don't use Now() is my belief was it was > different depending > on user time. I'll read more on that, sheesh, that's a > pretty basic thing to be > clueless about. Appreciate the table query, I will try > that. > PS I have $30 on paypal for someone who can translate > some helpful > instructions from my server guy into english so I better > understand how to > follow them. For someone familiar with the server side of > cf or advanced > coding it would probably take about 5 minutes. > PJ I'm always available via private email to answer these sorts of questions if you don't want to send them to the list. I'm happy to look over anything your admin sends you -- and I don't charge for that service. :) At least -- not unless I find it's swallowing up large blocks of my time. :) Otherwise it's just part of the purpose of Team Macromedia -- helping people out, making sure people get answers. Using now() in ColdFusion can on some occasions cause problems if the db server is not located in the same time-zone as the ColdFusion server. Which in most cases isn't an issue, but it can be on occasion, usually with large corp. projects for companies that require all their db's to be hosted in a central location regardless of the location of their applications. I believe both sql server and oracle have functions which also return the current GMT time -- with sql server I think it's GETUTCDATE() (utc being short for "universal time coordinate" -- who makes up this stuff?) s. isaac dealey 972-490-6624 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
