[thelist] Sigh. More ASP. This time, trouble reading a file

[Lightening]

Here is another piece of asp code that should work, but doesn't.

Same calendar I asked about before. If the calendar says there is a party,
the person can click on it and get more info about the party. So I am
passing an ActivityId off a valid record.


I am displaying the sql statement, so I know it is being formated correctly
and activityID = correct ID. But every time, it returns zero records found-
I get the "Sorry no items were found" routine.

Can anyone see what O might be doing wrong?

thanks
Laura

___________________________________________________________________________




set rsActivity=Server.CreateObject("ADODB.RecordSet")
 sql="SELECT activityId,  event, eventType,  " & _
 " MemberFee, NonMemberFee, Description, " & _
 " from activityTable "

sql=sql & " where ActivityId= " & aActivityId & ";"


Response.write    sql & "<br>"
rsActivity.Open sql,dsn

if rsActivity.recordcount<=0 then
 response.write "<h2><font align=center  color='#55eeee' >Sorry no items
were found</font></h2>"
 rsActivity.close
 set rsActivity=nothing
 response.end
end if


response.write "<tr><th>Activity Id</th>"
response.write "<td>" & rsActivity.Fields("ActivityId").value & "</td>"
response.write "</tr>"