Frågan#1
Hej!
Sitter har och jobbar mig med soksript, simpelt ar det, men det verkar inte som om den vill hitta det som finns.. inga felmess, bara "Det fanns inget som matchade din sokning" kommer ut... iaf, borjar med formularet:
<form name="search" method="post" action="includes/search_results.asp">
<input type="text" name="name"> i kategori
<select name="category">
<%
strGetCats = "Select * from t_FilesCat"
set rs = objConn.execute(strGetCats)
%>
<option value="all">Alla kategorier</option>
<%
Do Until rs.eof
response.write "<option value="""&rs("CatID")&""">"&rs("CatName")&"</option>"
rs.movenext
loop
%>
</select>
<input type="submit" value="Sök skript">
</form>
och sen search_results.asp:
<%
strName = request.form("name")
strCat = request.form("category")
If request.form("category") = "none" then
strList = "SELECT t_Files.*, t_FilesCat.* FROM t_Files INNER JOIN t_FilesCat ON t_Files.CatID = t_FilesCat.CatID "&_
"Where controlled = True AND scriptName LIKE '%"&strName&"%'"
Else
strList = "SELECT t_Files.*, t_FilesCat.* FROM t_Files INNER JOIN t_FilesCat ON t_Files.CatID = t_FilesCat.CatID "&_
"Where controlled = True AND scriptName LIKE '%"&strName&"%' AND catName = '"&strCat&"'"
End IF
set rs = objConn.execute(strList)
If rs.eof then
response.write "<br><br><center><b>Det fanns inget som matchade din sökning.</b></center>"
Else
Do Until rs.eof
response.write "<table width=""100%"" cellpadding=""4"" bgcolor=""#eeeeee"" cellspacing=""0"">"&_
"<tr><td><b>"
If rs("catName") <> ref then
response.write rs("catName")
End IF
response.write "</b></td></tr></table>"
response.write "<table width=""100%"" cellpadding=""2"" bgcolor=""#ffffff"" cellspacing=""0"">"&_
"<tr><td width=""20%"" valign=""top""><a title="""&rs("fileDesc")&""" href=""includes/script_count.asp?fileID="&rs("fileID")&"&filename="&Server.HTMLEncode(rs("fileURL"))&""">"&rs("scriptName")&"</a></td>"&_
"<td width=""20%"" valign=""top"">"&rs("dt")&"</td>"&_
"<td width=""10%"" valign=""top""><font title=""Nerladdad "&rs("downloaded")&" gång(er)"">"&rs("downloaded")&"</font></td></tr></table>"
ref = rs("catName")
rs.movenext
loop
End IF
%>
det finns ju i databasen!! Har sakert gjort nagot simpelt fel nu igen.. hehe
