Odd behavior

[jmj]

I'm having something weird happen and I'm hoping someone can explain it. I have a sql2000 machine that I'm using for a grade card. When I dump all the skills I put in a placeholder of ... When teachers "add" grades they are actually running an update query.
I have one teacher who has some students that have invalid grades. (ie: the writing grades move over to his reading grades). I went through to make sure there were no nulls in the grade category (the update is an array hence the placeholders).
Then I did some queries and I said <>&quot;...&quot;
Well sure enough the same students showed up in that list- even though they had ... in their grade field!
I changed the grade to something else then returned it to ... When I again ran the <>... query these same kids showed up with ... in the same field.
It is only happening to this one teacher out of 80 teachers.
Any ideas? I'm utterly confused, frustrated and amazed!!
Thanks in advance.
J

 

[jhall156]

How are you getting to the SQL Server tables? I feel sure it's not T-SQL since you're using arrays. JHall

 

[jmj]

This is an intranet web program so we are using ColdFusion middleware. I have coldfusion loop through an update query to update the grades by subject. (ie: Reading/is fluent/reads at grade level Math/can count to 10...)
So it is
<Loop>
<sql Update query>
<end loop>
But it seems that if the loop was the problem then there would be more than one teacher effected by this issue.

 

[jhall156]

Would you show us the SQL? JHall

 

[jmj]

<CFLOOP INDEX=&quot;X&quot; FROM=1 TO=&quot;#ListLen(Grade)#&quot;>
<CFQUERY NAME=&quot;EditGrades&quot; DATASOURCE=&quot;#Request.dsn#&quot;>
UPDATE tbl_Grades
SET GradeForSubject='#ListGetAt(attributes.Grade,X)#'
WHERE STUDENTID='#CLIENT.STUDENTID#' and Quarter=#Quarter# And TopicID=#Evaluate(X + TopicOffset)#
</CFQUERY>
</CFLOOP>
Thats the code that sends it to the database.
But I don't think the update query is the problem.
I went up and changed the data in sql manager to the fake grade.
It was sql manager that gave me the query result that gave me the results that made me realize that some of the ... aren't recognized by sql for some reason.
Have you ever heard of this?

 

[jhall156]

I see what those cf tags are about, but I'm afraid my lack of knowledge in that area precludes me from offering anything intelligent. Sorry. JHall