MOD Tutorials: Series I

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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.  