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).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
