What is you just did
SUM(ISNULL(tbldetailentry.reghrs))
Would this work?
At 03:59 PM 11/19/2001 -0400, you wrote:
>None of this ..is working and it is just not making much sense as to why
>it isn't working.
>
>Using the SUM(ISNULL(tbldetailentry.reghrs),0) results in an error,
>Wrong Number Of Arguments.
>
>SELECT SUM(ISNULL(tbldetailentry.reghrs),0) AS Daystotals
>
> FROM tblMainEntry,TblDetailEntry
>
> WHERE
>
> tbldetailentry.MainID = tblMainEntry.MainID
>
> AND
>
> tblDetailEntry.recorddate =
>to_date('#currentdate#','mm/dd/yyyy')
>
> AND
>
> tblMainEntry.empid = #client.emplid#
>
> AND
>
> Attendance_Code > 8000
>
>
>Any other ideas as to why this just won't work? Is it some problem with
>the fact that it is a Join between TblMainEntry and TblDetailEntry?
>
>Using that standard time comparison has always worked before.
>
>-Gel
>
>-----Original Message-----
>From: Bryan Love [mailto:[EMAIL PROTECTED]]
>
>if you don't specify a time when using to_date Oracle will use zeros
>(midnight of previous day, or beginning of new day) for the timestamp.
>That timestamp is part of the date so if you used Oracle's default
>sysDate when inserting the record then the timestamps won't match. Try
>this:
>
>to_char(tblDetailEntry.recorddate,'mm/dd/yyyy') = '#currentdate#'
>
>instead of your current date comparison (it will strip off the
>timestamp).
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
