|
| |
|
|
duke
Posts: 26
From: Denver, PA USA
Status: offline
 |
What's wrong with this query? - 9/4/2001 13:14:00
I keep getting this error and I'm sure I have some punctution wrong but cant figure out where.Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. Here is the code I am trying to use, f = "WHERE week_no = '"&Request.QueryString("sweekno")&"'"
sSQL = "SELECT * FROM " & sTableName & f
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sSQL, db, adOpenStatic
I am using this similarly in another part of this site without trouble, so I don't understand waht's going on.
Thanks in advance. ------------------
Duke
|
|
|
|
duke
Posts: 26
From: Denver, PA USA
Status: offline
|
RE: What's wrong with this query? - 9/4/2001 14:30:00
Nevermind, I got bitten by not having a space in one of my statements.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 