"HartAch" <dvanderm@twcny.rr.com> wrote in message
news:uovi9Y3ZFHA.3168@TK2MSFTNGP10.phx.gbl...
> Just converted by website from Access to SQL. The below code works fine
in
> Access, but I am getting an error in SQL
>
> strSQL = "SELECT Count(Status) as 17LCD FROM Monitors Where left(mSize,2)
=
> '17' and Type='LCD'"
> rs.Open strSQL, conn, 3, 3
>
> Here is the error
>
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> Line 1: Incorrect syntax near '17'.
> /inv/monitors.asp, line 60
>
>
> Any ideas?
>
>
>

On Thu, 2 Jun 2005 09:23:17 -0400, HartAch wrote:

>Just converted by website from Access to SQL. The below code works fine in
>Access, but I am getting an error in SQL
>
>strSQL = "SELECT Count(Status) as 17LCD FROM Monitors Where left(mSize,2) =
>'17' and Type='LCD'"
>rs.Open strSQL, conn, 3, 3
>
>Here is the error
>
>Microsoft OLE DB Provider for SQL Server (0x80040E14)
>Line 1: Incorrect syntax near '17'.
>/inv/monitors.asp, line 60
>
>
>Any ideas?
>
>