ok, that may work
solves the error and returns this: 159679
so should i just format that? to show the time left?
Dave
----- Original Message -----
From: <"Everett>; <Al <[EMAIL PROTECTED]>>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 5:17 PM
Subject: RE: OK, lets start over........Re: any ideas on this error?
> Try this: <cfset timeLeft = DateDiff("s", Now(), deadline)>
>
> > -----Original Message-----
> > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 13, 2003 5:00 PM
> > To: CF-Talk
> > Subject: OK, lets start over........Re: any ideas on this error?
> >
> >
> > heres what i need
> >
> > i have to make this small auction page for my competitors client.
> > what i need right now is to be able to show on the details
> > page how much
> > time is left before the end of the auction.
> > see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25
> >
> > ok, so in my application.cfm template i have this variable set:
> > <cfset deadline = createDateTime(2003, 2, 15, 13, 42, 0)>
> >
> > the reason for this is that i need this to manually set the
> > end time of the
> > auction on all of the pages.
> > they arent paying enough to make it dynamic and they want
> > each auction to
> > start and end all at the same time, just a 1 shot deal.
> > but I figure i should use this for what i need now.
> >
> > so on the details page i need to basically show how much time
> > is left, just
> > like Ebay:)
> >
> > thats where dateDiff comes in, correct?
> >
> > which should be like such
> > <cfset timeLeft = DateDiff("datepart", "date1", "date2")>
> >
> > so i was thinking that Now() should go where "date1" is
> > And "deadline" from the application.cfm should go where "date2" is
> > tony i think you may be right in putting 's' in where "datePart" is
> >
> > which now looks like
> >
> > <cfset timeLeft = DateDiff("'s'", "Now()", "deadline")>
> >
> > and that produces this error
> >
> > Parameter validation error for function DATEDIFF.
> > The value of the parameter 2, which is currently
> > "Now()", must be a
> > class java.util.Date value.
> >
> > The error occurred in
> > C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line
> > 14
> >
> > 12 :
> > 13 : <body>
> > 14 : <cfset timeLeft = DateDiff("'s'", "Now()", "deadline")>
> > 15 :
> > 16 :
> >
> >
> >
> >
> >
> >
> >
> >
> > Dave
> >
> > ----- Original Message -----
> > From: "Tony Weeg" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 13, 2003 4:40 PM
> > Subject: RE: any ideas on this error?
> >
> >
> > > send the code ur using....
> > >
> > > ...tony
> > >
> > > Tony Weeg
> > > Senior Web Developer
> > > UnCertified Advanced ColdFusion Developer
> > > Information System Design
> > > Navtrak, Inc.
> > > Mobile workforce monitoring, mapping & reporting
> > > www.navtrak.net
> > > 410.548.2337
> > >
> > > -----Original Message-----
> > > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, February 13, 2003 4:36 PM
> > > To: CF-Talk
> > > Subject: Re: any ideas on this error?
> > >
> > >
> > > using just Now() throws the same error
> > >
> > >
> > > Dave
> > >
> > > ----- Original Message -----
> > > From: "Tony Weeg" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Thursday, February 13, 2003 4:30 PM
> > > Subject: RE: any ideas on this error?
> > >
> > >
> > > > why use all that....can u just use
> > > >
> > > > Now()
> > > >
> > > > ...tony
> > > >
> > > > Tony Weeg
> > > > Senior Web Developer
> > > > UnCertified Advanced ColdFusion Developer
> > > > Information System Design
> > > > Navtrak, Inc.
> > > > Mobile workforce monitoring, mapping & reporting
> > > > www.navtrak.net
> > > > 410.548.2337
> > > >
> > > > -----Original Message-----
> > > > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, February 13, 2003 4:26 PM
> > > > To: CF-Talk
> > > > Subject: any ideas on this error?
> > > >
> > > >
> > > > Parameter validation error for function DATEDIFF.
> > > > The value of the parameter 2, which is currently
> > > > "CreateDateTime(Now())", must be a class java.util.Date value.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
