Classic ASP Discussion - SQL Add Method

Print Page | Close Window

SQL Add Method

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=14873
Printed Date: 30 March 2026 at 6:38am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Add Method

Posted By: padoxky
Subject: SQL Add Method
Date Posted: 28 April 2005 at 9:54am

Which method will i use to add new records to user's ID profile?

I have this problem of doing that by using SELECT and INSERT METHOD.

I have try using this method 'AddNew and Update Method'

Please help.

-------------
NgWebDesigns

Replies:

Posted By: michael
Date Posted: 28 April 2005 at 10:17am

You need to be a little bit more specific on what you want to do. Generally you insert a new record into SQL Server or Access (or pretty much any other db) with an insert statement. The User ID field is very often an identity field of type integer or guid so you would not need it in your insert list. If you for whatever reason must do it, you need to enabel Identity_Insert first and the method varies based on the db system you are using.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: padoxky
Date Posted: 29 April 2005 at 5:12am

Let me tell what i want. Am designing a bank website. As an Administrator i want to add new records to each client transcation information made by the client.
I don't know how to do it to work.

Am using using Access database for it.
Hope you understand now.

-------------
NgWebDesigns

Posted By: michael
Date Posted: 29 April 2005 at 9:35am

Well just run a sql query like

Insert customerRecords (CustomerID, Rec1, Rec2,.....) Values (12345,'something','something else',....)

I cannot give you a more explicit answer without knowing your architecture. And on another note. Designing a bank website using Access is like throwing a bullet instead of shooting it. In other words, don't do it.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: ub3rl337ch3ch
Date Posted: 01 May 2005 at 7:41pm

I think 'throwing a bullet at the guy with the gun' is more accurate.

Even if it is a first foray for the bank into online transactions and such, they really need to go at it the whole hog with security, stability etc, simply because of the global nature of the internet. Basically, even though it might be the first time for the bank, it's likely that any little mailto:!@#$ - !@#$ trying to break in and damage stuff is going to be fairly experienced.

Anyway, in Access if you're having issues with inserting stuff, then the frst thing you should check is that the key field of the table is an autonumber, so that it assigns a number automatically (as key fields cannot be null and it will throw an error).