update records in database

Results 1 to 2 of 2

Thread: update records in database

  1. #1
    Join Date
    Dec 1969

    Default update records in database

    hello! can somebody help me write a simple code that updates a column in database using values passwed by a querystring where the querystring is a number. I have been trying to do that for a time now but i cant seem to get the correct syntax. <BR><BR>anyhelp from you guys would be highgly appreciated.<BR><BR>willmar

  2. #2
    Join Date
    Dec 1969

    Default Update *ALL* records???

    Not just one record?<BR><BR>If so:<BR><BR>&#060;%<BR>SQL = "UPDATE table SET fieldName = " & Request("theNewNumber") <BR><BR>... make your connection object and open it...<BR><BR>conn.Execute( SQL )<BR>%&#062;<BR><BR>That&#039;s it.<BR><BR>But *all* records will have their "fieldName" value changed to the new value.<BR><BR>

Posting Permissions

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