Classic ASP Discussion - Changing the cell value in database

Print Page | Close Window

Changing the cell value in database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=17243
Printed Date: 29 March 2026 at 5:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Changing the cell value in database

Posted By: mantey
Subject: Changing the cell value in database
Date Posted: 14 November 2005 at 7:59am

I want to change the value of the partuicular field in database. How can I do that using some sort of script.

E.g If I have MS Access database (let's say Addresses.mdb) and inside a table with 3 columns and 3 rows. The table name is tblNames.

Eg.

tblNames

FIELD 1 (Name)	FILED 2 (Name ID)	FILED 3 (Group ID)
Jason	1	4
Jane	2	2
Jill	3	7

I want to change Jane's group ID number from 2 to 5 using asp script.

tblNames

FIELD 1 (Name)	FILED 2 (Name_ID)	FILED 3 (Group_ID)
Jason	1	4
Jane	2	5
Jill	3	7

How to achieve that.

I want to use some sort of form with, let's say two fields: One filed to type in a Name ID (which is unique), and other input filed to put the new group ID.

Example:

Name id: ____________, New Group_id:_________ SUBMIT

Note: (lines represent input fields, SUBMIT represents Submit button)

Does anyone know, how to do that? What is the script?

Please, help.

Replies:

Posted By: Gullanian
Date Posted: 14 November 2005 at 1:47pm

If you don't really know how to do that, then someone telling you how isn't going to help because you'll have the same problem next time.

Check out this sites ASP tutorials, they are really good and should help you learn.

Posted By: mantey
Date Posted: 14 November 2005 at 2:06pm

I realised that this can be solved by using Database Tool, Database and Table Editor. I will ask question in the database forum.

Posted By: mantey
Date Posted: 21 November 2005 at 5:52pm

I just want to say that borg's (Bruce's) database tutorial is really good and it helped me to create wanted script.