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
|