Incorrect syntax near '['

[ice]

I have another problem here. I really cannot find any error, Can anyone please help!

explorer say:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '['.

databaseo.asp, line 493

line1 says: <SCRIPT LANGUAGE="JavaScript" RUNAT="Server">

line 493 says: rsRecordSet.Open(strSQL, cnDBConnection, adOpenKeyset, adLockOptimistic, adCmdText);

[bmcgee]

What is the contents of strSQL?

Something in your query has bad syntax presumably. Dump out strSQL right before that executes and paste in here for us.

[ice]

strSQL is as follows:

var strSQL = "";
strSQL += "SELECT * FROM ";
strSQL += config.ADMINSETTING_DatabaseTable;
strSQL += " WHERE ";
strSQL += config.DATABASE_FieldDateCreated;
strSQL += " = {d '";
strSQL += dtDateCreated.getODBCNormalisedDate ();
strSQL += "'}";