Edit/Add/Delete from Web Page?

Results 1 to 2 of 2

Thread: Edit/Add/Delete from Web Page?

  1. #1
    Join Date
    Dec 1969

    Default Edit/Add/Delete from Web Page?

    I know this is probably really easy, but I ain&#039t too bright, so...<BR><BR>Let&#039s say I have a database with my collection of DVD&#039s and I want to add and delete them from my web page. What would be the coding to do this.<BR><BR>Say my database is dvds.mdb where my table would be "my_dvds" and the only fields would be "column_one" and "column_two".<BR><BR>Thanks in advance,<BR>Matt <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Edit/Add/Delete from Web Page?

    Add...<BR><BR>INSERT INTO my_dvds (column_one, column_two) VALUES (2, &#039This is a text insert&#039)<BR><BR>Delete...<BR><BR>DELETE FROM my_dvds WHERE column_one = 2 AND column_two = &#039This is a text delete&#039<BR><BR>You would then execute these statements as you would any other SQL statement in ADO.<BR><BR>E.G.<BR><BR>Set objConn = CreateObject("ADODB.Connection")<BR><BR>strSQL = "INSERT ..."<BR><BR>objConn.Execute strSQL, "DSN=DSNName" &#060;- This can also be a connection string.<BR><BR>Set objConn = Nothing<BR><BR><BR>HTH<BR><BR>Jerry<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