I have this function, but can't seem to loop it correctly to display the results.
so anyways, I want to loop through the months and show the results of the users search results....
Function fGetMemberSearchPageStats(iMemberId, iLogType, strTimePeriod, dtReqDate)
Dim rsLog, iResult
Set rsLog = Conn.Execute("spGetMemberProfileHits " & iMemberId & ", " & iLogType & ", '" & strTimePeriod & "', '" & dtReqDate & "' ")
If Not rsLog.EOF Then
iResult = rsLog.Fields("hit_count")
Set rsLog = Nothing
fGetMemberSearchPageStats = iResult
I want to pop them in to a table once its all said in done.
'' sp Arguments - Member Number, Log Type, DatePeriod, Requested Date
iMonthCount = fGetMemberSearchPageStats(iMemberId, 1, "month", "04/01/06")
I know that logic is totally invalid, but what would make this more helpful for me?
if iMonthCount = fGetMemberSearchPageStats(iMemberId, 1, "month", "01/01/06" Then <%=iMonthCount %> Else If iMonthCount = fGetMemberSearchPageStats(iMemberIf, 1, "month", " 02/01/06" then <%=iMonthCount %>
I appreciate you help.