getting SQL function results from a RS

[Nicodemas]

My SQL Statement:

strSQL = "SELECT COUNT(QuestionID) FROM tblQuestions WHERE PollId = "& intPoll_ID


How do I write out that result? I tried to put it into a recordset and then write it out like so:


response.write rsQuestionID("QuestionID")


but that doesn't work... what should I do to grab that value?

[khaki]

hi Rob...

give this a try:

strSQL = "SELECT COUNT(QuestionID) AS theIDcnt FROM tblQuestions WHERE PollId = "& intPoll_ID

and retrieve it like this:

<%response.write theIDcnt %>

let me know if that works for you...

;) k

[Ribeyed]

Hi,
just to add to what Khaki has said, you may also be getting an error if the sql statment returns empty. I suggest the following:



strSQL = "SELECT COUNT(QuestionID) AS theIDcnt FROM tblQuestions WHERE PollId = "& intPoll_ID
set RS = DataCOnnection(strSQL)

if not RS.EOF then
response.write theIDcnt
else
response.write "0"
end if

[khaki]

ah.... yes....
brilliant !!!

(will now never reveal her own nonsensical code for handling zero records :rolleyes: ) ...
;) k

[Nicodemas]

Son of gun, Khaki.... it worked!

Thanks much. I (obviously) didn't even consider aliasing.