SQL Server Cursor Problem

Hi. I have a cursor in my SQL Server 2000 usp that doesn't seem to be working. It returns 0's for all counts within the cursor. I assigned a value to one of the variables after the cursor and the assigned value came back to my asp.net code. This leads me to believe the cursor variables lose their value once the cursor is done. What am I doing wrong?





--------------------------------------


DECLARE @numFPrintNA int


DECLARE @txtPrintSuit varchar(1)





DECLARE curs_Count CURSOR


FOR


SELECT numFPrintNA,


txtPrintSuit


FROM tblRecords


WHERE txtLocationCode = @txtLocationCode


AND (dtmOffDate >= @dtmFrom


AND dtmOffDate <= @dtmTo)





OPEN curs_Count





FETCH curs_Count INTO @numFPrintNA, @txtPrintSuit





IF @@FETCH_STATUS = 0


BEGIN





IF @numFPrintNA = 0 SELECT @numNACount = @numNACount + 1 ELSE SELECT @numAppCount = @numAppCount + 1





IF @txtPrintSuit = 'U' SELECT @numUnkCount = @numUnkCount + 1


IF @txtPrintSuit = 'Y' SELECT @numSuitCount = @numSuitCount + 1


IF @txtPrintSuit = 'N' SELECT @numUnsuitCount = @numUnsuitCount + 1





FETCH curs_Count INTO @numFPrintNA, @txtPrintSuit





END





GO


---------------------------------------