I need to loop through the months and call the sp each time per month.

binici · 04-11-2006, 05:43 PM

Hello,

I have this function, but can't seem to loop it correctly to display the results.

Code:

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")
	End If
	Set rsLog = Nothing
	fGetMemberSearchPageStats = iResult
End Function

so anyways, I want to loop through the months and show the results of the users search results....

Code:

<%
'' sp Arguments - Member Number, Log Type, DatePeriod, Requested Date
iMonthCount = fGetMemberSearchPageStats(iMemberId, 1, "month", "04/01/06")

%>

I want to pop them in to a table once its all said in done.

Code:

if iMonthCount = fGetMemberSearchPageStats(iMemberId, 1, "month", "01/01/06" Then <%=iMonthCount %> Else If iMonthCount = fGetMemberSearchPageStats(iMemberIf, 1, "month", " 02/01/06" then  <%=iMonthCount %>

I know that logic is totally invalid, but what would make this more helpful for me?

I appreciate you help.

binici · 04-11-2006, 06:53 PM

Would it best to use a For Each...Next Statement?

Thanks!

Archangel · 04-12-2006, 03:30 PM

Sorry, I read through it and want to help, but just don't really understand what's going on.