Thanks for that. I got it working. See my previous reply.

I finally got it working.

My problem was the bug with Recordset and StoredProcedures

You need to set

rs.CursorLocation = adUseClient

otherwise RecordCount, BOF and...

OK, thanks for that. My procedure got "complicated" as I was trying to "fix" it...

I've tested the procedure in the Query Analyzer

use printing

go

exec GetPrintersByType 8

and got the expected 13 records.

I...

OK, sorry...

CREATE PROCEDURE [dbo].[GetPrintersByType]

@PrinterType INT

AS

DECLARE @sqlquery NVARCHAR(500)

SET @sqlquery = 'SELECT * FROM parameters WHERE printer_type & @PrinterType=@PrinterType'

EXEC sp_executesql

Now I've "fixed" the SQL. I've got a problem using it.

If I execute the SQL in Query Analyzer, I get 13 records

select * from parameters where printer_type & 8 =...

Thanks for the suggestions.

I figured out what I was doing wrong:

CREATE PROCEDURE [dbo].[GetPrintersByType]

@PrinterType INT

AS

DECLARE @sqlquery NVARCHAR(500)

SET @sqlquery = 'SELECT * FROM parameters WHERE printer_type &...