On 4/9/2012 2:40 AM, Gonzo Rock wrote:
Then using
cfset theDate = CreateODBCDateTime(RightNow)
the value returned from now() should be ok to insert into DB, no need for this
step.
Going through all the time and time zone settings on the linux box all
seems right.
db cf on same server?
Uh, oh... you guys just couldn't let a sleeping dog lie, huh? ;o)
Rick
-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Friday, March 05, 2010 10:39 PM
To: cf-talk
Subject: RE: time difference
Is there really a need to bring one of his threads back to life
into this and figure out all teh
changes made in the last 7 years LOL (man this is gonna hurt)
From: Rick Faircloth r...@whitestonemedia.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sat, March 6, 2010 7:04:50 AM
Subject: RE: time difference
Uh, oh... you guys just
quite coughcough(this part was not intelligible)/cough/cough!!!
Rick
-Original Message-
From: Christopher Stowell [mailto:christopher.stow...@yahoo.com]
Sent: Saturday, March 06, 2010 9:23 AM
To: cf-talk
Subject: Re: time difference
Ya know.. after being out of ColdFusion development
: Saturday, March 06, 2010 8:23 AM
To: cf-talk
Subject: Re: time difference
Ya know.. after being out of ColdFusion development since 2003 (joined the
army and just got out late 2009), i must say.. its odd seeing some of the
same names on the list. Not to mention the fact people still have a sense
2 ?'s
I need to show a difference between to dates
basically how much time is left between the ending date and now. can
cf do this or should I use a java script?
also, how do I use a Now() but add 3 hours to the output?
server is 3 hours behind but I need to be the current time. I don't
actually
I already have it:)
just really sick of reading it at the moment. lots to absorb, short amount
of time
Dave,
CF is a lot to absorb chief!! LOL!!!
~|
Want to reach the ColdFusion community with something they want?
Is there really a need to bring one of his threads back to life? Especially
one that has been dead for #dateDiff(, '02-10-2003', now())# years...
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Friday, March 05, 2010 7:39 PM
To: cf-talk
Subject: Re: time
The sad part here is that now 7 years later Will still would have to look this
up!
And thank god we got bobbie here to referee the proper count!
~|
Want to reach the ColdFusion community with something they want? Let them know
Thanks for the tip, Dave. One quick question:
If one's server(s) do not utilize flash in any way (e.g. no flash in any
application), is it still vulnerable?
~|
Want to reach the ColdFusion community with something they want?
If one's server(s) do not utilize flash in any way (e.g. no flash in any
application), is it still vulnerable?
My understanding is, yes, your servers are still vulnerable unless you
specifically disabled BlazeDS/Remoting/LCDS functionality.
Dave Watts, CTO, Fig Leaf Software
Ok, cool. Thanks. I have those turned off. :-)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Ok, cool. Thanks. I have those turned off. :-)
You have remoting turned off? Are you sure? I don't recall an off
switch for that, really - you have to edit configuration files
manually to disable this if I recall correctly.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
You can remove the servlet mappings from web-xml. I suppose that's
technically editing configuration files manually, but everyone
already does that for RDS, so it's not that foreign.
cheers,
barneyb
On Thu, Feb 18, 2010 at 1:50 PM, Dave Watts dwa...@figleaf.com wrote:
Ok, cool. Thanks. I
You can remove the servlet mappings from web-xml. I suppose that's
technically editing configuration files manually, but everyone
already does that for RDS, so it's not that foreign.
Alas, let me tell you, everyone does not already do that for RDS in production.
Dave Watts, CTO, Fig Leaf
I have my sites on Sydney time too and the java timezone thing got the
change almost right.I have servers in the USA as well, and
timezone on my sites set to Sydney. The clock was out an hour for a
day, but corrected itself automatically.
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe
CF is getting the time zone from the JVM.
Sent from my iPhone
On Oct 6, 2009, at 12:46, Toby King ptansw...@gmail.com wrote:
Hi there
I am running 2 Coldfusion servers in Sydney Australia.
This last weekend Sydney adjusted clocks and moved to Summertime (4
weeks earlier than normal -
I am running 2 Coldfusion servers in Sydney Australia.
This last weekend Sydney adjusted clocks and moved to Summertime (4 weeks
earlier than normal - this is going to be the case
permantently rom now to the best of my knowledge).
I was just on the CF administrator and checked the server
Hmmm...I don't quite get it...by the time you hit a server to do this
checking, they have already hit a server with the request, so the choice has
been made...or are you saying they can choose a server for all subsequent
requests? Maybe a little more elaboration of what you're going for is in
Put cfsetting requesttimeout=number of seconds here in your page.
Adrian
-Original Message-
From: Ron Gruner [mailto:webmas...@gruner.com]
Sent: 17 March 2009 10:50
To: cf-talk
Subject: Time-our on compute intensice page
I'm executing a compute-intensive page that has 500
try putting cfsetting requesttimeout=600 at the top of your page.
that will set the request timeout to 600 seconds.
alternatively, consider breaking your routine into several different
pages pages... or running it a scheduled task... or using cfthread if
you are on cf8...
Azadi Saryev
Put cfsetting requesttimeout=number of seconds here in your page.
Adrian
Works! This is a great forum for folks like me. Your help is really
appreciated.
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Hmmm... That might be a bit overkill for what I need, but I would be happy to
take a look at it. If we can use it, I'd be more then happy to give you some
great feedback or fill out some microsoft surveys.
Does it require a MS SQL database or can I use MySQL?
We have a desktop application
I'm nearly complete a more robust AIR / PHP application that has all that
and a few other handy features. If you want, I can email you when it's ready
to go to Beta.
I might even make a port to CF. ;)
!k
-Original Message-
From: Jeff Gladnick [mailto:[EMAIL PROTECTED]
Sent: Saturday,
I would be very interested! shoot me an email at jeffglad a t ^^ gmail
I'm nearly complete a more robust AIR / PHP application that has all that
and a few other handy features. If you want, I can email you when it's ready
to go to Beta.
I might even make a port to CF. ;)
!k
I am
We have a desktop application called Timealyzer built on .NET 2.0, but it
doesn't have offline capabilities (i.e., it has to always be connected to
the shared database). Tracks customers, projects, deliverables, and tasks.
Provides countdowns to deadlines, reports, lots of other features. Built
or this
cfset minuteTime = 8 /
cfset round15 = round(minuteTime/15) * 15
cfoutput#minuteTime# : #round15#br //cfoutput
If round15 equal 60
you will need to increment the hour
and set minutes to 0
On Wed, Jun 4, 2008 at 1:36 PM, Michael E. Carluen [EMAIL PROTECTED]
wrote:
Terry,
Try this:
Terry,
Try this:
cfoutput#minute(now())#/cfoutput
cfset theminute = minute(now())
cfset roundedhour = hour(now())
cfif theminute lte 7
cfset roundedMinute = 0
cfelseif theminute lte 23
cfset roundedMinute = 15
cfelseif theminute lte 37
cfset roundedMinute = 30
cfelseif
SeeFusion gives you two page times. The time to first byte and the
total page time. TTFB is the amount of time that elapses before CF
starts sending back data to the browser. If you are using cfflush this
could begin before the page is finished processing. Total page time is
the time that
) or
if you just have a bunch of long running tasks (such as file uploads going
on.)
-Dan
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 08, 2008 1:58 PM
To: CF-Talk
Subject: RE: Time to First Byte
SeeFusion gives you two page times. The time to first byte
On Thursday 06 Dec 2007, Richard Meredith-Hardy wrote:
Obviously we will deploy on a nice new server, but will CF5 and CF8 run
happily together with iis on our dev Win2k3 r2 server?
Yes.
VMWare would be a worst-case solution.
--
Tom Chiverton
Helping to adaptively fashion next-generation
Richard,
A couple of notes may be of reference to you since I just installed cf8
standard trial edition on an XP box with an existing cf4.5 supporting a
simple app and yes they now seem to live happily together using the same IIS
5 web server.
a) be very careful about various
Don
Thanks for this.
I will try an install and see what happens...
Richard
-Original Message-
From: d l [mailto:[EMAIL PROTECTED]
Sent: 06 December 2007 14:44
To: CF-Talk
Subject: Re: Time to come out of the stone age
Richard,
A couple of notes may be of reference to you
Obviously we will deploy on a nice new server, but will CF5
and CF8 run happily together with iis on our dev Win2k3 r2 server?
Yes, although by default CF5 will monopolize your web server's
configuration, so that all requests for .cfm files are sent to it. The
below-mentioned article
Watts [mailto:[EMAIL PROTECTED]
Sent: 06 December 2007 16:53
To: CF-Talk
Subject: RE: Time to come out of the stone age
Obviously we will deploy on a nice new server, but will CF5 and CF8
run happily together with iis on our dev Win2k3 r2 server?
Yes, although by default CF5
Obviously we will deploy on a nice new server,
that's because you have more resources while I don't.
Dear all
We've been merrily running quite a big intranet on CF 5.1 for years but
it's time to take advantage of some of the new stuff in CF8.
Obviously we will deploy on a nice new server, but
Jul 16 23:55:55 2007
Subject: Re: Time for another CF hosting site thread...
Personally, I'm suspicious of any hosting company that offers disk
space in those amounts (500GB) for prices like $10/month. I know disk
space is cheap.. but it ain't that cheap!
I wonder if they're backing up those
Or if your database was hacked, or your code stolen; I asked this
question of hostingatoz today:
Do you sandbox datasources and the filesystem too, as standard for
all accounts?
The response:
No. This is not standard with the all the accounts. You need to
request this, however, it is free.
On
To: CF-Talk
Subject: Re: Time for another CF hosting site thread...
Hello Charlie and listers,
I'll join this thread. I'm finding that most ColdFusion Hosting
companies while they offer support for many of CF's features they tend to be
quite stingy on disk space. During the National Federation
server, the other as your
main domain server.
Just a thought.
-Original Message-
From: Peter Donahue [mailto:[EMAIL PROTECTED]
Sent: Monday, July 16, 2007 4:50 PM
To: CF-Talk
Subject: Re: Time for another CF hosting site thread...
Hello Charlie and listers,
I'll join
for fairly simple, basic and cheap, i use www.hostingAtoZ.com.
They're definitely cheap :)
$20 a year gets you CFMX7 Enterprise and mySQL. $35 a year gets you
CFMX7 Enterprise and SQL Server2k5.And -very- few restrictions on
disabled tags/functions.
since i've started mentioning them more
I've used GearHost.com for nearly 5 years.
-Original Message-
From: Brian Yager [mailto:[EMAIL PROTECTED]
Sent: Monday, July 16, 2007 4:07 PM
To: CF-Talk
Subject: Time for another CF hosting site thread...
I have a client that wants a fairly simple website. I REALLY want to use
Cheap but reliable: Crystaltech.com
Enterprise level/PERFECT support: EdgeWebHosting.com
-Original Message-
From: Brian Yager [mailto:[EMAIL PROTECTED]
Sent: Monday, July 16, 2007 5:07 PM
To: CF-Talk
Subject: Time for another CF hosting site thread...
I have a client that wants a
On 7/16/07, Brian Yager [EMAIL PROTECTED] wrote:
I have a client that wants a fairly simple website. I REALLY want to use
CFdynamics but I am not going to tell him it's $50/month just for CFFILE.
So...If you all can direct me to who you use, I will gladly look at them and
give you the
16, 2007 4:27 PM
Subject: Re: Time for another CF hosting site thread...
for fairly simple, basic and cheap, i use www.hostingAtoZ.com.
They're definitely cheap :)
$20 a year gets you CFMX7 Enterprise and mySQL. $35 a year gets you
CFMX7 Enterprise and SQL Server2k5.And -very- few
www.viux.com
I have been with them for a year and that's only because they have my
money and won't give it back. CFSchedule is another $10/month and I plan
on leaving them at the end of the year when the credit ends.
The credit was given when they migrated everyone to a new type of server
and
appreciated.
Peter Donahue
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, July 16, 2007 4:27 PM
Subject: Re: Time for another CF hosting site thread...
for fairly simple, basic and cheap, i use www.hostingAtoZ.com
pound instead of the Yankee Dollar. Again your
suggestions and recommendations will be very much appreciated.
Peter Donahue
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, July 16, 2007 4:27 PM
Subject: Re: Time
I have several clients hosted with dantor.com with all the bells and whistles
at a fraction of what you'll find elsewhere. They're hosting wholesalers and
have a nice reseller matrix. I've used these guys for about 6 years now with
very few issues and are always ready to help even though
I'd go with hostmysite.com - they have the FEWEST tag restrictions of
anyone that I'm aware of (ie, cfobject and cffile work out of the
box).
They're affordable, and offer unparalleled tech support as far as I'm concerned.
Rick
Personally, I'm suspicious of any hosting company that offers disk
space in those amounts (500GB) for prices like $10/month. I know disk
space is cheap.. but it ain't that cheap!
I wonder if they're backing up those servers =)
Rick
I would just like to come back on this one -
I've been hosting a site on hostingatoz for the past month.
So far it has been down for a total of 16 hours.
The first time for about 4, then after than for around 12 hours.
The 99.9% up time is not real, neither is the 24 hour support.
I hate to
Bob -
Dantor looks like it might be decent, a few quick questions (I'll
contact them directly too)
- Does it run cfmx7? it only seems to list 6.1 on the site?
- can you run createObject? I see cfobject is disabled? (can that be turned on?)
- What is their support response time like?
Mark
On
PROTECTED]
Sent: Monday, July 16, 2007 7:29 PM
To: CF-Talk
Subject: Re: Time for another CF hosting site thread...
Bob -
Dantor looks like it might be decent, a few quick questions (I'll
contact them directly too)
- Does it run cfmx7? it only seems to list 6.1 on the site?
- can you
I just wanted to throw in the following about hosts running CF7. They
have absolutely no reason to disable cfobject fully.
One of the little known tidbits of CF7 is that it introduced type
specific sandboxing.
What I mean by this is that you can now enable cfobject (and therefore
createObject)
I don't know how hostingatoz.com can possibly be legal with their
software licensing.
I mean seriously... $20 a year for a site powered by CF enterprise,
with SQL Server Enterprise Edition? Even academic pricing on SQL
Server Enterprise is EXPENSIVE. And the price of Coldfusion
Enterprise is
I don't think it's necessary to go with an expensive provider for
your average web site, but I certainly wouldn't go to that level of
cheap either unless you simply didn't care if the site was up or not.
I went with them, and frankly, for that price, I didn't care if my site
is up or not (you
Sean Corfield wrote:
CFDynamics is new to me and I was not thrilled with how they handled
the changeover from the previous UG manager to me, nor how they set up
a DSN (or failed to). We'll see how they do long term.
cfdynamics is a bit pricey for what they offer but they're so reliable i often
which returns 10:24.
I need to get the 1:36 now.
First off - forget the format. Format means nothing.
I would think the easiest thing to do would be to (conceptually) treat
every period like it began at exactly midnight. You can then use the
methods described in my first post
130/60 = 2.167
there's your 2 minutes, then take the remainder (using the modulus
function) the .17 * 60 and round the result?
On 7/3/07, Jim H [EMAIL PROTECTED] wrote:
which returns 10:24.
I need to get the 1:36 now.
First off - forget the format. Format means nothing.
Ok, so here is how I worked this out. Can this be cleaned up any?
cfif IsDefined(EnteredTime)
!--- Does Time Have a : In It? ---
cfif #find(:,FORM.EnteredTime)#
cfoutputError :/cfoutput
cfelse
cfif #FORM.EnteredTime# GT 0
I am building a hockey stats application. I need to be able to allow
the user to enter in any 2-4 numbers. I then need a way to convert
the 2-4 numbers into a time format. Will the TimeFormat function do
this? EX: 24 = 00:24132 = 1:32
I also need to subtract that time from
Any thoughts?
Yeah I foresee issues :-)
But to get started you could do something like this to get your numbers
formatted like you said.
cfset thenumber = 123 /
cfset thenumber = left(numberformat(thenumber, ), 2) :
right(numberformat(thenumber, ), 2) /
cfoutput#timeformat(thenumber,
Well, since its hockey, you know that there are 20 minutes in a period,
so any numbers greater than 20 (ie 36) are going to be seconds (00:36)
but two digit numbers 20 or less are going to be an area that needs more
definition. Is 18 supposed to be 18:00 or 00:18? I think that needs to
get
That's a nice method Jim.
-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 10:43 AM
To: CF-Talk
Subject: Re: Time Question
I am building a hockey stats application. I need to be able to allow
the user to enter in any 2-4 numbers. I then need
Well since its hockey YOU might know :-)
I have no clue about hockey.
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Judah McAuley [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 12:23 PM
To: CF-Talk
Subject: Re: Time
Well, since its hockey, you know that there are 20 minutes in a period,
so any numbers greater than 20 (ie 36) are going to be seconds (00:36)
but two digit numbers 20 or less are going to be an area that needs more
definition. Is 18 supposed to be 18:00 or 00:18? I think that needs to
get
which returns 10:24.
I need to get the 1:36 now.
Then all you need is the dateDiff() function which may not be clear in the name
can handle time increments as well as calendar increments.
~|
ColdFusion MX7 by Adobe®
I need to get the 1:36 now.
UGH!
You should be able to do DateAdd to do this - create a date for your 12
minutes:
periodlength = CreateDateTime(2000,1,1,0,12,0)
Then, figure out the number of seconds in your submitted time:
secs = minute(mytime) * 60 + second(mytime)
and then subtract secs
You should be able to do DateAdd to do this -
or just use DateDiff as Ian said.
-- Josh
~|
ColdFusion 8 beta â Build next generation applications today.
Free beta download on Labs
: Monday, July 02, 2007 1:38 PM
To: CF-Talk
Subject: Re: Time Question
You should be able to do DateAdd to do this -
.or just use DateDiff as Ian said.
-- Josh
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard
: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 1:38 PM
To: CF-Talk
Subject: Re: Time Question
You should be able to do DateAdd to do this -
or just use DateDiff as Ian said.
-- Josh
~|
ColdFusion MX7
which returns 10:24.
I need to get the 1:36 now.
First off - forget the format. Format means nothing.
I would think the easiest thing to do would be to (conceptually) treat every
period like it began at exactly midnight. You can then use the methods
described in my first post to create
this year.
This is a very helpful forum with developers who have a lot patience
with us newbies or semi-newbies!
-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 12:51 PM
To: CF-Talk
Subject: Re: time/date
Simple: Because CreateODBCDateTime(now()-1) doesn't cover the proper
time span that he needed to cover. He needed to check for entries in the
database that occurred between midnight yesterday (00:00:00) and
23:59:59 of today. now()-1 doesn't give that sort of control.
Claude Schneegans wrote:
Christopher Jordan wrote:
Simple: Because CreateODBCDateTime(now()-1) doesn't cover the proper
time span that he needed to cover. He needed to check for entries in the
database that occurred between midnight yesterday (00:00:00) and
23:59:59 of today. now()-1 doesn't give that sort of
I don't *think* so (though I could be wrong).
From the original post,Quote:
I have a SQL statement that searches a date/time field in MS Access
which has data such as 12/20/2006 10:02:18 AM.
So it would appear that his data is being stored as a timestamp.
This code:
WHERE timereceived =
He needed to check for entries in the
database that occurred between midnight yesterday (00:00:00) and
23:59:59 of today. now()-1 doesn't give that sort of control.
Then use CreateODBCDate instead of CreateODBCDateTime.
CreateODBCDate(now()) is equivalent to CreateODBCDateTime (now() at
time
Christopher Jordan wrote:
Results in:
WHERE timereceived = {d '2006-12-20'} AND
timereceived {d '2006-12-22'}
I haven't tried it, but if the datatype on the field is 'ts' and you're
trying to compare it with just 'd' (meaning it's holding data like, {ts
'2006-12-20 13:43:24'} and
Not positive on this, but you might want to try the DateAdd() function
for day2. Just subtracting 1 from the date usually doesn't work.
cfset day2 = DateAdd('dd', -1, Now())
Steve Brownlee
http://www.fusioncube.net/
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Hi Steve, thanks, but got a: dd is not a valid date/time format.
-Original Message-
From: Steve Brownlee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 10:55 AM
To: CF-Talk
Subject:RE: time/date format in Access
Not positive on this, but you might want
, 2006 11:00 AM
To: CF-Talk
Subject: RE: time/date format in Access
Hi Steve, thanks, but got a: dd is not a valid date/time format.
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http
Now that I think about it, you may want to use the day of year instead
cfset day2 = DateAdd('y', -1, Now())
Steve Brownlee
http://www.fusioncube.net/
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 11:00 AM
To: CF-Talk
Subject: RE
Now I get an error on: CFSET onedaybehind = Createdate(Year2,Month2,day2)
-Original Message-
From: Steve Brownlee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 11:08 AM
To: CF-Talk
Subject:RE: time/date format in Access
Now that I think about it, you
Hi Robert,
I think the problem is that your dates are not in ODBC date format.
Try something like this:
cfset Today = now() !--- should automatically be in ODBC date format ---
cfset Yesterday = DateAdd(d,-1,Today) !--- Notice it's 'd' not 'dd'
---
cfquery name=get datasource=barracuda_log
it, you may want to use the day of year instead
cfset day2 = DateAdd('y', -1, Now())
Steve Brownlee
http://www.fusioncube.net/
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 11:00 AM
To: CF-Talk
Subject: RE: time/date format
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 11:16 AM
To: CF-Talk
Subject:Re: time/date format in Access
Hi Robert,
I think the problem is that your dates are not in ODBC date format.
Try something like this:
cfset Today = now() !--- should automatically be in ODBC
: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 11:16 AM
To: CF-Talk
Subject:Re: time/date format in Access
btw this:
cfset month = #dateformat(now(),mm)#
cfset year = #dateformat(now(),)#
cfset year2 = #dateformat(now(),)#
cfset month2
?
-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 11:41 AM
To: CF-Talk
Subject:Re: time/date format in Access
Robert, have you looked at the idea I shot out? I really think it will
work for you, and it also reduces all
Orlini, Robert wrote:
I have a SQL statement that searches a date/time field in MS Access
which has data such as 12/20/2006 10:02:18 AM. I want to display
dates between the current day and one day behind.
This statement keeps giving me 0 records.
cfset month = #dateformat(now(),mm)#
You might want to look at using the Access datediff function
cfquery name=get datasource=barracuda_log
SELECT *
FROM message_log_20391
WHERE datediff(d,timereceived,now()) = 1
/cfquery
Although note that languages aren't consistent as to whether they take
the time part into
Subject: Re: time/date format in Access
Hi Robert,
I think the problem is that your dates are not in ODBC date format.
Try something like this:
cfset Today = now() !--- should automatically be in ODBC date format ---
cfset Yesterday = DateAdd(d,-1,Today) !--- Notice it's 'd' not 'dd
PM
To: CF-Talk
Subject:Re: time/date format in Access
Oh! Duh... hadn't thought of that. *smack*
In that case:
cfset today = now()
cfset today = CreateDateTime(year(today), month(today), day(today),
23, 59, 59)
cfset yesterday = DateAdd(d, -1, today)
cfset yesterday = CreateDate(year
: Christopher Jordan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 12:51 PM
To: CF-Talk
Subject: Re: time/date format in Access
Oh! Duh... hadn't thought of that. *smack*
In that case:
cfset today = now()
cfset today = CreateDateTime(year(today), month(today), day
Hi Robert:
I harped on it not because it might eventually crash SQL. Yes, those
are reserved words in SQL, but they're -also- reserved words in
ColdFusion. Any built in function name (as well as scope names) are
reserved words in CF and really shouldn't be used as variable names.
It might not
Gee, why not simply use this:
where timereceived between #createODBCDate(now()-1)# and
#createODBCDate(now())#
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
cfset Start = getTickCount()
do a bunch of stuff
cfset End= getTickCount()
cfset Time Elapsed = End - Start (in milliseconds)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL
Could you be a bit more specific, getTickCount()seem to be ignoring the time I
entered as start and end times I entered for testing. Could it be using system
time instead?
cfset Start = getTickCount()
do a bunch of stuff
cfset End= getTickCount()
cfset Time Elapsed = End - Start (in
getTickCount() isn't what you want if you are trying to manually set
start/end times.
check the docs for dateDiff()
On 2/27/06, Love Sponge [EMAIL PROTECTED] wrote:
Could you be a bit more specific, getTickCount()seem to be ignoring the time
I entered as start and end times I entered for
Subject: Re: Time Calculations
Could you be a bit more specific, getTickCount()seem to be ignoring the
time I entered as start and end times I entered for testing. Could it
be using system time instead?
(StartTime,
~|
Message
1 - 100 of 322 matches
Mail list logo