Performing Update

Results 1 to 2 of 2

Thread: Performing Update

  1. #1
    Join Date
    Dec 1969

    Default Performing Update

    Ok, i have information being posted back to my form from my DB perfectly.<BR><BR>Now i want to be able to go in and update the info. <BR><BR>For some reason i am receiving an error for ReferenceID. ReferenceID and Correct_Answer are drop down menus and the rest of the Inputs are Text Areas.<BR><BR>here is my update statement:<BR><BR>SQL = "Update PILOT_QUIZ_QUESTIONS Set " &_<BR><BR> "QuestionText = &#039;" &_<BR> CStr(Request.Form("QuestionText"))& "&#039;"&_<BR> "ReferenceID = &#039;" &_<BR> CStr(Request.Form("ReferenceID"))& "&#039;"&_ <BR> "Answer_A = &#039;" &_<BR> CStr(Request.Form("Answer_A"))& "&#039;"&_<BR> "Answer_B = &#039;" &_<BR> CStr(Request.Form("Answer_B"))& "&#039;"&_<BR> "Answer_C = &#039;" &_<BR> CStr(Request.Form("Answer_C"))& "&#039;"&_<BR> "Answer_D = &#039;" &_<BR> CStr(Request.Form("Answer_D"))& "&#039;"&_ <BR> "Correct_Answer = &#039;" &_<BR> CStr(Request.Form("Correct_Answer"))& "&#039;"&_<BR> "Explanation = &#039;" &_<BR> CStr(Request.Form("Explanation"))& "&#039;"&_<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Are you

    sure referenceid is a character type datatype in the DB. If it is integer type then you should convert it into cint.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts