set column with a string into null in coldfusion

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jsungmin
    New Member
    • Jan 2013
    • 13

    set column with a string into null in coldfusion

    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
    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#"
    but this code have error..
    thanks.
    Last edited by Rabbit; Jan 16 '13, 05:17 AM. Reason: Please use code tags when posting code.
  • acoder
    Recognized Expert MVP
    • Nov 2006
    • 16032

    #2
    Try
    Code:
    <cfqueryparam ... null="yes">

    Comment

    Working...