[dba-SQLServer]ADO FInd and SQL Server

Try this...

strSQL = "SELECT * FROM tblBuilding WHERE fldClusterID = " & Val(Nz(txtClusterID) & " AND fldBuildingNumber = '" & Nz(txtBuildingNumber) & "'"

rstBuilding.Open strSQL, cnn, adOpenKeyset, adLockPessimistic

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Mwp.Reid at Queens-Belfast.AC.UK
Sent: Monday, August 25, 2003 9:30 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer]ADO FInd and SQL Server


We need to pass multipe values to FInd or Filter in ADO.

Any ideas?

  rstBuilding.Open ("select * from tblBuilding"), cnn, adOpenKeyset, 
adLockPessimistic

        rstBuilding.Filter "fldClusterID = " & Val(Nz(txtClusterID)) & " AND 
fldBuildingNumber = '" _
            & Nz(txtBuildingNumber) & "'"


Martin
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003