Problem with asp page
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=9113
Printed Date: 29 March 2026 at 6:49pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Problem with asp page
Posted By: photoshop_god
Subject: Problem with asp page
Date 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 I apologize if I'm missing something glaringly obvious. Any help would be appreciated. Thanks in advance. |
Replies:
Posted By: zaboss
Date Posted: 21 January 2004 at 1:14pm
|
It's the select statement that is causing the trouble. As the error message said:
------------- Cristian Banu http://www.soft4web.ro - Soft 4 web |
Posted By: photoshop_god
Date 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 |