<cfquery name="insrt_srvy" datasource="#ds#">
INSERT INTO SURVEY_HEADER (REF_NO)
VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value="#ref_no#">)
</cfquery>

<form name="survey_form" method="post">
<table>
<tr>
  <td>Reference No. </td>
  <td><input name="ref_no" type="text" value="#ref_no#">
  </td>
</tr>
<tr>
<td>
<input type="button" name="Save"

<form name="survey_form" method="post" action="#currentfile#">
<table>
<cfloop query="GetDetailQuest">

<cfquery name="GETTOTSCORE3" datasource="#ds#">
    	select count(s.quest_score) as c
        from survey_customer_score s, survey_customer_header h
        where s.quest_score = 3
        and s.survey_id = 1757        
        and s.quest_id

<cfset totResponse = #GETTOTSCORE1.a# + #GETTOTSCORE2.b# + #GETTOTSCORE3.c#>
<cfset avg = #GetSum1.score1# + #GetSum2.score2# + #GetSum3.score3#>
<cfset totAVG = avg / #totResponse#>

<cfquery name="countDATA" datasource="#ds#">
    select count(quest_id)
    from survey_question
</cfquery>
                
 <cfset t = #countDATA#>
     #t#

<cfloop query="getQuest">
   <cfset count=0>
      <cfquery name="chechking" datasource="#ds#">
	select status_flag
	from survey_question
	where status_flag = 'N'
      </cfquery>
        count = count+1;
</cfloop>

UPDATE SURVEY_QUESTION 
SET quest_malay = <cfqueryparam cfsqltype="cf_sql_varchar" value="">,
    quest_eng = <cfqueryparam cfsqltype="cf_sql_varchar" value="">
    WHERE QUEST_ID