Hi there !!
Please help me to sort out the error's. I have to submit this assignmnet on monday at any cost.
I got an assignment where i have to generate 5 html reports .. like Total events per month ( last 6 month), Daily events Analysis ( last 30 days) and so on.. based on campaigns.
If the user select all campaigns / single/ double comapiagns then i have to show reports accordingly. I have no issue of carrying the campaign information page to respective pages. The issue is on the above mentions reports.
In Total Events per month( last 6 month) :
Query 1: How can I get the last 6 month data and header dynamically ?
Below is the brief snippet code ..What i am doing so far..
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
set rs1 = Server.CreateObject("ADODB.Recordset")
conn.open "DSN=abc;UID=sqlboy;PWD=sqlboy;DATABASE=sqlboy "
' collecting selected campaigns number
Dim strchecked,acheckarray,iloop, tot
strchecked = Request.Querystring("camplist")
aCheckarray = split(strchecked, ",") %>
'fetching records one by one in arrays
<% For iloop = LBound(aCheckarray) to Ubound(acheckarray)
strsql="select * from campaigns where campnum = '"& acheckarray(iloop)&"'"
set rs = conn.execute(strsql) %>