UPdating record in Oracle Database

Results 1 to 2 of 2

Thread: UPdating record in Oracle Database

  1. #1
    Join Date
    Dec 1969

    Default UPdating record in Oracle Database

    I got connection to the Oracle database and am able to display records...but all the code I'm writing doesnt seem to work when I try to use a form to update records..is there a website where you can read about it....believe it or not I'm searching the web but its mostly telling you about SQL...well if anyone know kindly tell me .....thanks you soooo much!!

  2. #2
    Join Date
    Dec 1969

    Default Use SQL

    Use SQL commands to update the DB. <BR><BR>You say the Web is telling you mostly about SQL...well, use it!<BR><BR>For example, if you have a form with the USERID (which is NOT editable, let&#039;s say), the USERNAME, and the USEREMAIL, then you might do:<BR><BR>&#060;%<BR>SQL = "UPDATE userInfoTable " _<BR> & " SET USERNAME=&#039;" & Request("UserName") & "&#039;, USEREMAIL=&#039;" & Request("UserEMail") & "&#039; " _<BR> & " WHERE USERID = " & Request("UserID") <BR><BR>yourConnectionObject.Execute SQL<BR>%&#062;<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