sorry charlie but i get the same error:(
----- Original Message -----
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 5:07 PM
Subject: Re: OK, lets start over........Re: any ideas on this error?
> no quotes around now()
> <cfset timeLeft = dateDiff("'s'", now(), "deadline")>
>
>
> Dave Lyons writes:
>
> > 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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
