OK, strangest thing!
I have a page that calls a custom tag repeatedly to add up totals for
records on a form.
Now for some reason, although there are NO ENTRIES in the table, this
custom tag is somehow finding entries
When I run :
Select * FROM tblDetailEntry,tblMainEntry
Where
tblDetailEntry.Attendance_Code = 8000
AND
tblDetailEntry.RecordDate = to_date('11/21/2001','mm/dd/yyyy')
AND
tblMainEntry.Empid = 60597
AND
tblMainEntry.MainID = tblDetailEntry.MainID
This query from Coldfusion, it is returning two records.
(There can supposedly only be one to begin with, if it is present at
all).
However when I run the query in SQL Plus..it shows nothing.
Nada.
No Rows Selected.
Which is what it is supposed to show. Does anyone have any idea how this
could be possible?
-Gel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
