I have problem with the following code. The MANUFACTOR was selected from the Manufactor_model field in SQL table, but when I run this, the code CAN'T find the record. Do I need to add someting to the line sqltemp="select * from HWtable where Manufactor_model = '"& MANUFACTOR &"'", since the Manufactor_model field type is nvarchar?

Thanks....

<%
myDSN="DSN=INVENTORY;uid=xxx;pwd=xxx"
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
MANUFACTOR=Request.QueryStrin("MANUFACTORY")

sqltemp="select * from HWtable where Manufactor_model = '"& MANUFACTOR &"'"

set rstemp = conntemp.execute(sqltemp)

PROCESSOR= rstemp("processor")
RAM_INSTALLED= rstemp("RAM_INSTALL")
RAM_MAX= rstemp("RAM_MAX")
VIDEO_CARD= rstemp("VIDEO_CARD")
VIDEO_MEM= rstemp("VIDEO_MEM")
RESOLUTION= rstemp("RESOLUTION")

rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%>