Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | 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 July 7th, 2005, 11:27 AM
Registered User
 
Join Date: Jun 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to braheem Send a message via Yahoo to braheem
Default Diplay records from database

Hi I am trying to display a few records from MS Access but I keep getting an error stating:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot find the input table or query 'MailingList'. Make sure it exists and that its name is spelled correctly.

I have a database called test.mdb with a table called MailingList, which contains the following data:

MailinList

MailingListID FirstName LastName WorkPhone EmailAddress
1 Homer Simpson 212K345835 hsimpson@snp.com
2 Carl Carlson 212K352981 ccarlson@snp.com
3 Lenny Leonard 212K363284 lleonard@snp.com


What I want my query to do is display the first name and last name in the MailingList table. The query I am using is:

string strSQL = "SELECT MailingList.FirstName, MailingList.LastName FROM MailingList";

Which should display the first and last names, when I do that it generates the error I mentioned above. Any idea whats wrong with it I have been working on this for two days and just need some fresh eyes to take a look at it. Any help is greatly appreciated.

Thanks,
braheem

Reply With Quote
  #2 (permalink)  
Old July 14th, 2005, 01:35 AM
Friend of Wrox
 
Join Date: Sep 2003
Location: Minneapolis, MN, USA.
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

If you don't mind, could you just post your complete code for the page?

Reply With Quote
  #3 (permalink)  
Old July 19th, 2005, 05:28 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi braheem,

As you say in your post, the table name seems to be MailinList(g missing). Check if the table name is the same in the mdb file, as what you use in the SELECT query.

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #4 (permalink)  
Old July 25th, 2005, 10:08 PM
Authorized User
 
Join Date: Nov 2003
Location: Phnom Penh, , Cambodia.
Posts: 44
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to eapsokha
Default

Please ensure the name of table you used inside SQL statement is correct. You may provide the full code.

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
form diplay in full screen mateenmohd Access 2 November 15th, 2007 08:26 AM
pls give query to diplay XML data in Sqlserver2005 veeruu XML 0 July 27th, 2006 05:06 AM
Don;t diplay text box if it is empty or null abdul_wasie Classic ASP Databases 5 May 20th, 2005 11:49 PM
please help me! how to diplay chinese normal? james007 Crystal Reports 5 April 26th, 2004 10:48 PM



All times are GMT -4. The time now is 10:43 PM.


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