Web Wiz Forums Modifications - MOD Tutorials: Series I

Print Page | Close Window

MOD Tutorials: Series I

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20683
Printed Date: 28 March 2026 at 8:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MOD Tutorials: Series I

Posted By: Demon
Subject: MOD Tutorials: Series I
Date Posted: 14 July 2006 at 6:40pm

MOD Tutorials: Series I

Tutorial I: Manipulating the Database (SQL and ACCESS)
Well, to make database changes from a webpage or form, use the following examples.

Adding a Row to a Table:

strSQL = "INSERT INTO table_name VALUES (value1, value2,....)"

adoCon.execute(strSQL)

Updating a Row in a Table:

strSQL = "UPDATE table_name SET column_name = new_value WHERE indexColumn_name = some_value"

adoCon.execute(strSQL)

Deleting a Row from a Table:

strSQL = "DELETE FROM table_name WHERE indexColumn_name = some_value"

adoCon.execute(strSQL)

These should all work fine if used correctly.

More Installments coming soon.

-------------
So Sayith the Demon.

Replies:

Posted By: LuckyMan
Date Posted: 11 August 2006 at 7:42pm

thanks

Posted By: damaster
Date Posted: 26 August 2006 at 12:18pm

nice lill tutorial thanx for the efforts :) keep it up!

-------------

>>>>>>> www.damasterz.com <<<<<<<

Posted By: Praveen
Date Posted: 29 October 2006 at 1:34am

Thank You. Worked fine.

-------------

Posted By: WebWiz-Bruce
Date Posted: 29 December 2006 at 3:41pm

You should read the following if you plan on modifying the database:-

forum_posts.asp?TID=22292 - Guide To Using Modifications - READ FIRST

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: longcong
Date Posted: 09 January 2009 at 7:48am

Thanks!