I have a table which display quest_id,quest_ no, quest_malay, quest_eng and delete. After I click button delete I want to set my table row quest_malay and quest_eng into null.
this is my coding
but this code have error..
thanks.
this is my coding
Code:
UPDATE SURVEY_QUESTION SET quest_malay = <cfqueryparam cfsqltype="cf_sql_varchar" value="">, quest_eng = <cfqueryparam cfsqltype="cf_sql_varchar" value=""> WHERE QUEST_ID = <cfqueryparam cfsqltype="CF_SQL_NUMERIC" value="#getDelete.QUEST_ID#"
thanks.
Comment