Vista - Help with SQL statement

I am trying to check for the existance of a server record in our SQL
db. My sql statement returns an error of: Microsoft VBScript
compilation error: Expected end of statement.

My statement is:
strSqlQuery = "SELECT item.item_sc, item.item_n,item.item_keya FROM
assyst.dbo.item WHERE item.item_sc = ' " & strComputer " ' "

There are several more fields I want to return in addition to what's
in the current statement, but getting this to work will do for now.

I'm assuming it will return a NULL recordset if the server was not
entered.

TIA,

Seymour

> My statement is:You didn't concatenate the last string segment.
"SELECT item.item_sc, item.item_n,item.item_keya FROM
assyst.dbo.item WHERE item.item_sc = ' " & strComputer & " ' "

"krazymike" <krazymike@xxxxxx> wrote in message
news:4dbee183-b17f-48db-89c5-63e82def063d@xxxxxxYou didn't concatenate the last string segment.
"SELECT item.item_sc, item.item_n,item.item_keya FROM
assyst.dbo.item WHERE item.item_sc = ' " & strComputer & " ' "
------
Also, I believe the extra spaces around the value of strComputer are a
problem. I would use:
======
strSqlQuery = "SELECT item.item_sc, item.item_n, item.item_keya " _
& "FROM assyst.dbo.item " _
& "WHERE item.item_sc = '" & strComputer & "'"
====
Otherwise you have concatenated space characters to the computer name.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

Thanks to you both. I figured out the concatenation and was coming
back here to post that I solved it. You guys are QUICK! Now it
appears that I need to do a JOIN as some of the fields I'm looknig for
might be in another table.

I may be back for more help <g>

Seymour

On Sep 8, 3:39*pm, "Richard Mueller [MVP]" <rlmueller-
nos...@xxxxxx> wrote: