March 23, 200917 yr Author Been toying around with the code and different variations of it but still no joy on this edit page. Still giving: Microsoft VBScript runtime error '800a01a8' Object required: '' /admin/events/edit.asp, line 192 where 192 is if not(rstypeentry.BOF and rstypeentry.EOF) then Looking on Google it appears that you get this error when: This is usually because you've tried to close or set to nothing an object that hasn't been defined.
March 23, 200917 yr In that case I'm really sorry mate but I'm all out. It's probably something really simple (just needs a check to see if a valid recordset was returned or not, before testing for EOF), but it needs someone who runs IIS and uses ASP on a daily basis. It's about 4 years since I last built a pure ASP site, and when I did, I never used ADO recordsets - I just executed queries directly and interrogated the resulting object. Hence my "stumpedness". Any takers, folks?
March 23, 200917 yr Author In that case I'm really sorry mate but I'm all out. It's probably something really simple (just needs a check to see if a valid recordset was returned or not, before testing for EOF), but it needs someone who runs IIS and uses ASP on a daily basis. It's about 4 years since I last built a pure ASP site, and when I did, I never used ADO recordsets - I just executed queries directly and interrogated the resulting object. Hence my "stumpedness". Any takers, folks? No problem mate, really appreciate all of your help with it. Couldn't have gotten as far without you. Cheers
March 24, 200917 yr Author Posted this on another forum and it was an extra e in tbltypentry on some of the lines!! Now the checkboxes all display with the correct selections that I made when adding!! I now need to tell the 'Update Record' query that I need to update that table also. Not sure if I can do this in same query or I would need to create a 2nd Update Record query?
Create an account or sign in to comment