I have an odd problem on my sql2000 and hoping someone can help. I am doing a report card system. What I do is run append queries for all the schools. The teachers when "adding" grades are actually doing an update query. Because the fields are populated with an array I have set placeholders in each field so the update query won't shift the grades up. I have one teacher who's grades shifted- several of his students had invalid grades for one subject. I did a query asking for all grade <>.. (the placeholder) Sure enough the students whose grades had shifted appeared on the list! I added a fake grades but when I took out the fake grades and returned the field to .. it again showed up in my query that said all grades but .. So for these students the database isn't seeing the grades as having any placeholders- then the updates go into the wrong spaces if he does not do the report cards in the report cards in the order that they are set up as the array is populating the database starting with the "blank" grades. I don't get it and I'm pretty confused. I've never seen this before. Any ideas out there? ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
