Ooook. For some unexplained reason, there were 25121 records in the detailentry database. It seems that some rogue CFLOOP kept inserting records at a horrid rate into the database.
And I was not using the user qualifier in SQL Plus, hence it was probably looking at the wrong table indeed. *shakes head* Oh..and the SUM code from yesterday? It seems to be working. But because the datbaase was so screwed I kept getting incorrect values. -Gel -----Original Message----- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Are you sure you are pointing and viewing the same datasource? -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
