I wanted to see my db using 3.2 so I am running the eval version. Whenever I click on VIEW I get this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Hoang'.
/all1/testall1/DSMSC_Query_view.asp, line 122
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
GET /all1/testall1/DSMSC_Query_view.asp?editid=10.206.100.60&editid2=&editid3=&TargetPageNumber=1&todo=readonly&masterkey=
Time:
Monday, August 08, 2005, 10:21:10 AM
-----------------------------------------------------
This is what line 122 reads in the view file.
sqlt = "SELECT [AnalystName] FROM [dbo].[Analysts] WHERE [AnalystName] = " & strData & " and " & " 1=1 "
