Need Help Deleting Data
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=8674
Printed Date: 28 March 2026 at 9:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Need Help Deleting Data
Posted By: zorlock
Subject: Need Help Deleting Data
Date Posted: 08 January 2004 at 7:35am
|
I am trying to learn the basics i went through the tutorial on building aguest book here on this site.Everything worked great but when i tried to write a basic simple script to delete data from a very basic Table in my access database it contains two fields item and id# to be exact CrystalId and Crystal the CrystalId Field is autonumbered everytime a crystal is entered. Now the problem ADODB.Recordset error '800a0cc1'Item cannot be found in the collection corresponding to the requested name or ordinal. /delete_select.asp, line 34 Line 34 looks like this : Response .Write ("<a href=""delete_entry.asp?ID=" & rsCrystal("ID_no") & """>")I have tried everything if i comment that one line out it displays the data just fine But doesnt delete anything i am just learning and this one has got me stumped any help would be most appreciated
|
Replies:
Posted By: zaboss
Date Posted: 08 January 2004 at 7:43am
|
You have a spelling problem here. It is telling you that there is not such an item like "ID_no" ------------- Cristian Banu http://www.soft4web.ro - Soft 4 web |
Posted By: zorlock
Date Posted: 08 January 2004 at 8:37am
|
Well I am stuck then as i was basically taking the Guestbook tutorial and attempting to modify it to work with a diffrent database i followed it step by step and everything up to deleting worked out fine i am able to add to the generic database just fine and as for the "ID_no" i am still trying to figure out how or why this is being used in the iding part of the code string....
Sorry if i dont have a blasted clue |
lolPosted By: michael
Date Posted: 08 January 2004 at 9:37am
|
You need to replace ID_no with the actual primary key of your database, it could be called ID or Crystal_ID or something like that. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: zorlock
Date Posted: 08 January 2004 at 4:01pm
|
Thanks
|
Awsome Thank you that was it i just had no clue what the veriable was so wasnt sure what it needed to change or if it needed to change i was able to rewrite everything and got it to work great! Learning as i go ...I really appreciate the help!