Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Problem with asp page
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Problem with asp page

 Post Reply Post Reply
Author
photoshop_god View Drop Down
Newbie
Newbie
Avatar

Joined: 21 January 2004
Location: United States
Status: Offline
Points: 18
Post Options Post Options   Thanks (0) Thanks(0)   Quote photoshop_god Quote  Post ReplyReply Direct Link To This Post Topic: Problem with asp page
    Posted: 21 January 2004 at 12:54pm

Hi everyone,

I'm still learning asp and doing alright until today.  I'm creating pages that will access customer information and allow you to view, edit, and delete records.  When I try to view the records in a list I get this error message. 

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

/customertest/custdbtest2.asp, line 31

Here is the line 31 of the code.

'Open recordset 
rsCustomer.Open strSQL, adoCon

I apologize if I'm missing something glaringly obvious.  Any help would be appreciated.

Thanks in advance.

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: 21 January 2004 at 1:14pm

It's the select statement that is causing the trouble. As the error message said:

Originally posted by <SPAN =bold>photoshop_god photoshop_god wrote:

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

Cristian Banu
Soft 4 web
Back to Top
photoshop_god View Drop Down
Newbie
Newbie
Avatar

Joined: 21 January 2004
Location: United States
Status: Offline
Points: 18
Post Options Post Options   Thanks (0) Thanks(0)   Quote photoshop_god Quote  Post ReplyReply Direct Link To This Post Posted: 21 January 2004 at 1:32pm

I'm an idiot.  I had a comma before FROM on my select statement.  I need more sleep.

Thanks for the quick reply Zaboss

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.