I have a design dilemna
Facts are this:
1. Each quarter grade information must be updated in each subject. Total
subject + subcategories are gt 50 for each grade level. To display them in
columns I am using:
<TD>
<cfif Val(CourseGrade.GradeForSubject)>#SubjectGrade#
<cfelse><input name="GradeForSubject" SIZE="4">
</cfif>
</CFOUTPUT>
</td>
I need to update this #SubjectGrade# but keep getting error messages.
on the update query I put:
<CFQUERY NAME="Edit" DATASOURCE="Edu" DBTYPE="ODBC">
UPDATE tbl_Grade
SET
GradeForSubject='#SubjectGrade#'
WHERE GradeID=#GradeID# and STUDENTID=#STUDENTID#
</CFQUERY>
the GradeID is the unique number.
2. I need to make it so that only the current quarter can be updated. I
want to show all quarters so the user can compare the information. How do I
get it so that this is possible? Current quarter would be a variable named
#Quarter#.
Is this all doable?
Thanks for any input.
j
-
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
