Update Database

Results 1 to 3 of 3

Thread: Update Database

  1. #1
    Pedro Rodrigues Guest

    Default Update Database

    I have this problem:<BR><BR>id=request.form("id")<BR>newpwd=re quest.form("pwdn")<BR><BR>..... Open dsn .... <BR><BR>sql_update="update Assoc set Pwd=&#039;&newpwd&&#039; where Assoc_id=&#039;&id&&#039;<BR>With this I can&#039;t update my database. <BR>Please, help me where did I go wrong!<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Update Database

    What is the error message?<BR><BR>--&#062;Debug&#060;--<BR>Make a response.Write of your SQL Query, then copy/paste it in Query Analyzer to see if the syntax is ok.

  3. #3
    Join Date
    Dec 1969

    Default RE: Update Database

    I&#039;ve never seen it written that way. If your going to use request.form then try<BR><BR>sql = "Update Assoc"<BR>sql=sql & "Set Pwd = " & newpwd & "<BR>sql=sql & "Where Assoc_id = &#039;" & id & "&#039; "<BR><BR>cnn.Execute sql

Posting Permissions

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