ADODB.Connection.Question

Set conn = Server.CreateObject("ADODB.Connection")
strSQL = "Select nomer from table WHERE field1 = &var
conn.Open strConn
conn.Execute strSQL ,adCmdText

vaprosa e kak da polucha stoinostta na nomer poleto?

Preporachvam ti da go napravish sashtoto s ADODB.Recordset
imash po goliama gavkavost v boraveneto s zapisi
Primerno
strConn = "...."
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "Select *from table"
rs.Open strSQL ,strConn,adOpenkeyset,adLockOptimistic
strID = rs("number")
i posle si polzvash nadolu v koda strID kadeto iskash

с малко уточнение:

strID = rs.Fields("number").Value

за да нема ядове.

"За да чуеш, трябва да мълчиш !" (Оджиън)