HI,
kindly check the below mention code. i want to use Date as category search. I am having problem and my code doesnt work, What i am doing wrong. Please help!
'Category
stSQL = "select count(ID) as numbers, ticket_date from south group by ticket_date"
Set data = server.CreateObject("ADODB.Recordset")
Set data2 = server.CreateObject("ADODB.Recordset")
data.open stSQL, dbConnection
while not data.eof
category = replace(data("ticket_date")," ","+")
message = "<a href=""south_list.asp?a=search&value=1&SearchFor=" & ticket_date & "&SearchOption=Contains&SearchField=ticket_date"">" & data("ticket_date") & " (" & data("numbers") & ")</a>
"
response.write message
'subcategories
stSQL2 = "select count(ID) as numbers2, [zone] from south where ticket_date='" & data("ticket_date") & "' group by [zone]"
data2.open stSQL2,dbConnection
while not data2.eof
subcategory = replace(data2("[zone]")," ","+")
message = " <a href=""south_list.asp?a=search&value=1&SearchFor=" & [zone] & "&SearchOption=Contains&SearchField=[zone]"">" & data2("[zone]") & " (" & data2("numbers2") & ")</a>
"
response.write message
data2.MoveNext
wend
data2.close
data.MoveNext
wend
data.close