Quick SQL Question

Results 1 to 2 of 2

Thread: Quick SQL Question

  1. #1
    Join Date
    Dec 1969

    Default Quick SQL Question

    I was wondering if anyone could help...I am trying to update some information in my database but when entering comments in the textarea on my form using apostrophes cause a syntax error...i know that the translate() is probably my best option but I&#039;m not too sure how I could use it in an update statement?<BR><BR><BR>MySql="Update Schedules Set UID = " & Session("CUSTID") & ", treatment =&#039;" & request.form("treatment") & "&#039;, Comments=&#039;" & request.form("comments") & "&#039; Where id=" & id<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default AspFaqs.com has a FAQ on this. (eop)


Posting Permissions

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