Client Not Showing All Data, But SQL Query Retrieves Correctly
780237Jun 18 2010 — edited Jun 20 2010Just to preface this, I'm a computer apprentice working for my school. I've been tasked with troubleshooting an odd error that is occuring in my departments database. My understanding of and experience with databases is extremely limited (1 quarter working with MySql on SqlExpress), so I hope you'll go easy on me.
Our department is using Oracle 10g coded in ColdFusion 8. For some reason, the data in a particular table of our database will only partially show up when accessed by the client, however SQL queries of the database will return the proper set of data. When I say partially, I mean that the client only sees 122 of the 347 rows that should be in the table.
The table in question is a combination of data from a couple of other tables, using an ID number as the uniting key. There is some simple code written to check whether or not a specific ID number exists in the table in question, and if it does not, it adds the row into the table. Based on the fact that the SQL queries are returning the correct set of data, we can assume that the code is working fine. What's confounding is the fact that our client is unable to access the full set of data correctly.
Again I appologize if I've left out anything or if the information seems shoddy. This is the problem to the best of my knowledge, with all of the information that I've been given. Any help/guidance will be hugely appreciated. Thanks!