|
| |
|
|
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
|
|
|