quote:

---

Originally posted by Mnemonic

In my ASP .net page, there will always be a querystring equaling 0 or 1... how do i make my query select based on that? Here's what i got.. but it's probably wrong

(
@WindowAir int,
@CentralAC int
)
AS

SET NOCOUNT ON

DECLARE @SQL VARCHAR(8000)

SET @SQL = '
SELECT

r.REListingID,
r.REListingDate,
r.RESubject,
a.RentCharge,
b.thumb

FROM db_REListings as r
LEFT JOIN db_RentalAmenities AS a ON a.REListingID = r.REListingID INNER JOIN (
Select Row_Number() over (Partition by aa.ListingID order by aa.thumb) as RowID,aa.*
from db_REPics aa
) b ON a.REListingID = b.ListingID
WHERE 1 = 1 and b.RowID = 1
'

IF @WindowAir = '1'
SET @SQL = @SQL + ' AND a.WindowAir = ' + CONVERT(VARCHAR(20), @WindowAir)
IF @CentralAC = '1'
SET @SQL = @SQL + ' AND a.CentralAir = ' + CONVERT(VARCHAR(20), @CentralAC)

EXEC @SQL

Any ideas?

When i run that query i get

Msg 102, Level 15, State 1, Line 6
Incorrect syntax near '@WindowAir'.


I dont really know the syntax..

---

IF @WindowAir = 1
SET @SQL = @SQL + ' AND a.WindowAir = ''' + CONVERT(VARCHAR(20), @WindowAir) + ''
IF @CentralAC = 1
SET @SQL = @SQL + ' AND a.CentralAir = ''' + CONVERT(VARCHAR(20), @CentralAC) + ''