Can you include the call to the GetSubjects query too...........
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 10 May 2001 15:32
To: CF-Talk
Subject: Update problem
I am showing information in columns. Each column represents a different
quarter. We need the user to do an update every quarter. To achieve this
look I used the code:
<CFOUTPUT QUERY="GetSubjects" GROUP="SkillID">
<TR>
<TD COLSPAN="2">#Skill#</TD>
<CFOUTPUT>
<TD>
<CFIF Val(GetSubjects.GradeForSubject)>#GetSubjects.GradeForSubject#
<CFELSE><INPUT NAME="GradeForSubject" VALUE="#GradeForSubject#" SIZE="4">
</CFIF>
</TD>
</CFOUTPUT>
</TR>
<INPUT TYPE="Hidden" NAME="SkillID" VALUE="#SkillID#">
<INPUT TYPE="Hidden" NAME="GradesID" VALUE="#GradesID#">
<INPUT TYPE="Hidden" NAME="PERMNUM" VALUE="#PERMNUM#">
<INPUT TYPE="Hidden" NAME="GradeForSubject" VALUE="#GradeForSubject#">
</CFOUTPUT>
</TABLE
Now I need to be able to update each quarter. On my update query I have:
<CFQUERY NAME="EditGrades" DATASOURCE="#Request.maindsn#">
UPDATE tbl_StudentGrade
SET GradeForSubject='#trim(GradeForSubject)#'
WHERE GradesID=#GradesID#
</CFQUERY>
What is happening is that it is only updating the 1st entry- and putting all
the variables in that first column! (with a comma delimiter). as a test I
added the primary key to the columns - that shows up in the number correctly
so it looks like they are corresponding correctly, but the update button
will plunk it into the first variable only....any ideas?
Thanks for the brain power.
j
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
