Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 16th, 2004, 11:17 PM
Authorized User
 
Join Date: Dec 2004
Location: , , .
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default Unable to display the database

Hi all, I'm new and to asp needed some help here.
I got a problem which i uploaded on http://n.domaindlx.com/hayley/PMS_Page.asp
which will be helpful to my question.

I'm able to key the data in the last row in ms access, E34002, however after saving it, I'm unable to display the records.

Below is part of the code where the fault is:

Function TD_Prop
    if rs("Schedule")="" then
    TD_Prop = "EquipmentHead"
    else
    TD_Prop="EquipmentItem"
    end if
end function

Error Type given was:
(0x80020009)
Exception occurred.
PMS_List.asp, line 4


Line 4 is actually if rs("Schedule")="" .
Is anyone able to help me solve this?
Reply With Quote
  #2 (permalink)  
Old December 17th, 2004, 12:02 AM
Friend of Wrox
 
Join Date: Dec 2004
Location: Chennai, Tamil nadu, India.
Posts: 307
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Vadivel Send a message via Yahoo to Vadivel
Default

Hayley,

Check out www.aspfaq.com/show.asp?id=2421 which has a comprehensive list on the various reasons which would throw this error. Hope it helps!

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com
Reply With Quote
  #3 (permalink)  
Old December 17th, 2004, 03:32 AM
Authorized User
 
Join Date: Dec 2004
Location: , , .
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Vadivel,

Thanks for the advice. Had seen the pages but think it's not exactly related to the error. Wonder if I end the code properly...
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Needed - I'm unable to display the Pdf data vnaidu XSLT 1 January 16th, 2008 07:42 AM
unable to display my datalist frresh C# 2005 0 November 14th, 2006 11:52 AM
Language characters unable to display hayley Classic ASP Basics 0 June 28th, 2005 08:40 PM
Unable to display data ractim ADO.NET 5 July 31st, 2004 04:55 AM
Unable to display graph jamna Crystal Reports 0 April 28th, 2004 11:26 PM



All times are GMT -4. The time now is 07:28 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.