dynamic table name:- [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrec

[smanif1]

Report_Name_Final = "TABLENAME"
DIM mySQL1
 mySQL1 = "SELECT * FROM [TABLENAME]"
 mySQL1 = replace(mySQL1,"[TABLENAME]",Request.Form("Report_Name_Final"))

response.write objRS1("Value")

trying to get dynamic table name
i getting this error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FROM'.

[jhardman]

shouldn't you have to specify the query before you open the recordset? Or did you just leave off that part? When I get a syntax error that isn't obvious, I like to print out (response.write ) the final query just to see how it looks, sometimes that's enough to see where the error is. Otherwise, you can take your final query and drop it in a query analyzer.

Jared