Hello.. i need help on updating multiple data using loop..actually im still newbie on coldfusion and this is the code for the loop.. is it the best one to be use in updating multiple text box? thanks <cfif isDefined("form.save")> <cfset news_array = ListToArray(Form.mark)> <cfloop index="counter" from="1" to="#ArrayLen(news_array)#"> <cfquery name="qd" datasource="#Variables.fw.Config.DSN#"> UPDATE stu_result SET marks = <cfqueryparam value = "#NumberFormat(mark, '_.__')#" cfsqltype = "cf_sql_char">, Lastupdate_date = '#DateFormat(Now(),"dd/mmm/yyyy")#' WHERE student_code='#qs.student_code#' AND subject_code='#qs.course_code#' AND stu_result.aca_year='#qs.aca_year#' AND stu_result.session='#qs.session#' AND stu_result.semester='#qs.semester#' </cfquery> </cfloop> PHP:
First try getting rid of your cfsqltype I have ran into problems in the past with this. Also could you post more code so I can look at it in more detail you can even PM me it if you want.
full code : <cfparam name="url.codem" default=""> <cfparam name="form.year" default=""> <cfparam name="form.sesi" default=""> <cfparam name="form.stu_code" default=""> <cfparam name="form.subject" default=""> <cfparam name="form.year" default=""> <cfparam name="form.sesi" default=""> <cfparam name="form.semester" default=""> <cfparam name="form.test" default=""> <cfparam name="i" default="0"> <cfset i = i+1> <!--- Select From Database ---> <cfquery name="qs" datasource="#Variables.fw.Config.DSN#"> SELECT * FROM stu_result,stu_subjects,stu_profile,stu_programmes WHERE stu_result.subject_code=stu_subjects.code AND stu_result.student_code=stu_profile.student_code AND stu_result.student_code=stu_programmes.student_code AND stu_result.subject_code='#form.subject#' AND stu_result.aca_year='#form.year#' AND stu_result.session='#form.sesi#' AND stu_result.semester='#form.semester#' </cfquery> <body background="Themes/Default/images/background/gray_background_op_800x600.jpg"><table width="883" border="2" align="center" cellspacing="0" bordercolor="#623100"> <tr> <td width="877" height="216" valign="top" bgcolor="#FFFFFF"> <form id="form1" name="form2" method="post" action=""> <input type="hidden" name="section" value="academic"> <input type="hidden" name="action" value="result_form"> <cfif isDefined("form.save")> <cfset news_array = ListToArray(Form.mark)> <cfloop index="counter" from="1" to="#ArrayLen(news_array)#"> <cfquery name="qd" datasource="#Variables.fw.Config.DSN#"> UPDATE stu_result SET marks = <cfqueryparam value = "#NumberFormat(mark, '_.__')#" >, Lastupdate_date = '#DateFormat(Now(),"dd/mmm/yyyy")#' WHERE student_code='#qs.student_code#' AND subject_code='#qs.course_code#' AND stu_result.aca_year='#qs.aca_year#' AND stu_result.session='#qs.session#' AND stu_result.semester='#qs.semester#' </cfquery> </cfloop> <!--- Print Message ---> <cfscript> Application.fw_Notice("Record is successfully added.<br/> Press <a href=index.cfm?section=academic&action=result>| Finish |</a>."); </cfscript> <cfreturn "True"> </cfif> <table width="775" border="1" align="center" cellspacing="0" bordercolor="#FFFFFF"> <tr> <td colspan="5"> <div align="center"><font size="5" face="Arial, Helvetica, sans-seri"><strong><font color="#B35900">KOLEJ YAYASAN SABAH</font></strong></font><font color="#B35900"><br/> <br/> <strong><font size="2" face="Arial, Helvetica, sans-seri">RESULT ENTRY FORM <cfoutput>#qs.aca_year# #qs.session#</cfoutput><br/> ACADEMIC SEMESTER: <cfoutput>#qs.semester#</cfoutput><br/> MATAPELAJARAN : <cfoutput>#QS.SUBJECT_CODE# - #qs.description#</cfoutput> </font></strong></font><strong></strong></div> <br/></td> </tr> <tr> <td width="32" height="29" bgcolor="#004080"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">BIL</font></div></td> <td width="123" bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">NO KP</font></td> <td width="298" bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">NAMA PELAJAR</font></td> <td width="122" bgcolor="#004080"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">KURSUS</font></div></td> <td width="178" bgcolor="#004080"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">MARKAH</font></div></td> </tr> <cfset c = "0"> <cfoutput query="qs"> <cfset c = c + 1> <tr onMouseOver="this.bgColor='##CFCF9A' ;" onMouseOut="this.bgColor='##F1F1E2'; "> <td><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">#c#</font></div></td> <td><font size="2" face="Arial, Helvetica, sans-serif">#qs.student_code#</font></td> <td><font size="2" face="Arial, Helvetica, sans-serif">#qs.student_name#</font></td> <td><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">#qs.course_code#</font></div></td> <td><label> <div align="center"> <input name="mark" type="text" id="mark" value="0.00" size="10" maxlength="20"> </div> </label></td> </tr> </cfoutput> <tr> <td colspan="5"><label> <div align="center"> <input type="hidden" name="index" value="<cfoutput>#i#</cfoutput>"> <input type="submit" name="save" id="save" value="Save"> <input type="submit" name="add" id="add" value="Add"> </div> </label></td> </tr> </table> </form> </td> </tr> </table> PHP: