Inserting info into a database
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8621
Printed Date: 30 March 2026 at 12:10pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Inserting info into a database
Posted By: k_mustard
Subject: Inserting info into a database
Date Posted: 06 January 2004 at 3:37pm
|
ok, so i have a database, and i want to add information to it. But it keeps adding in a new record for me instead of inserting in information into the current records. This is what i have to insert my records.... ____ Rs("QtyFour") = Trim(Request.Form("qty")) _______ so what do i have to add, in order for me to add information to current records??? thanks |
Replies:
Posted By: Semikolon
Date Posted: 06 January 2004 at 3:47pm
|
you should delete the recordset.addnew line.. |
Posted By: k_mustard
Date Posted: 06 January 2004 at 3:50pm
|
awesome..works great...i thought it would be way more complicated thanks again |
Posted By: Semikolon
Date Posted: 06 January 2004 at 3:56pm
| but now ure not able to add records if u used the same script for both adding and editing |
Posted By: k_mustard
Date Posted: 06 January 2004 at 3:56pm
|
ok i lied....its just inserting it on the first line/record of the database i have about 25 records in my DB, and the RowID is being passed through all the pages. How do i link it so the record goes into the right RowID?? |
Posted By: Semikolon
Date Posted: 06 January 2004 at 4:00pm
|
use this in your sql string "SELECT * FROM table WHERE RowID = " & integersource |
Posted By: k_mustard
Date Posted: 07 January 2004 at 8:27am
|
ok...so excuse my stupidity...but...for this... "SELECT * FROM table WHERE RowID = " & integersource would i just write integersource...or would i write one of my variable names?? |
Posted By: michael
Date Posted: 07 January 2004 at 9:13am
|
You would replace integersource with whatever variable you have your integer in ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |