Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Need Help Deleting Data
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Need Help Deleting Data

 Post Reply Post Reply
Author
zorlock View Drop Down
Newbie
Newbie


Joined: 08 January 2004
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote zorlock Quote  Post ReplyReply Direct Link To This Post Topic: Need Help Deleting Data
    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

 

Back to Top
zaboss View Drop Down
Senior Member
Senior Member


Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
Post Options Post Options   Thanks (0) Thanks(0)   Quote zaboss Quote  Post ReplyReply Direct Link To This Post 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
Soft 4 web
Back to Top
zorlock View Drop Down
Newbie
Newbie


Joined: 08 January 2004
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote zorlock Quote  Post ReplyReply Direct Link To This Post 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  lol

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
zorlock View Drop Down
Newbie
Newbie


Joined: 08 January 2004
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote zorlock Quote  Post ReplyReply Direct Link To This Post Posted: 08 January 2004 at 4:01pm

 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!

Thanks

 

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.