Hi
When I request from the boolean fields, I get true or false.
Here is the code:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="dwzSearch/dwzSearch.asp" -->
<!--#include file="Connections/VKCdatabase.asp" -->
<%
Dim rsVidensbank
Dim rsVidensbank_numRows
Set rsVidensbank = Server.CreateObject("ADODB.Recordset")
rsVidensbank.ActiveConnection = MM_VKCdatabase_STRING
rsVidensbank.Source = "SELECT * FROM tblVidensbank"
rsVidensbank.CursorType = 0
rsVidensbank.CursorLocation = 2
rsVidensbank.LockType = 1
rsVidensbank.Open()
rsVidensbank_numRows = 0
%>
<%
'**************************
' Advanced Search
' http://www.DwZone-it.com
' Version: 2.0.2
'**************************
dim dwzSearch_1
set dwzSearch_1 = new dwzSearch
dwzSearch_1.Init
dwzSearch_1.SetFormName "form1"
dwzSearch_1.SetSubmitName "Submit"
dwzSearch_1.SetBooleanValue "True / False"
dwzSearch_1.SetJollyChar "%_@@_None"
dwzSearch_1.AddFilter "KatKultur", "=", "", "Kat", "", "B", "0"
dwzSearch_1.AddFilter "KatUndervisning", "=", "", "uv", "", "B", "0"
dwzSearch_1.SetStrSQL rsVidensbank.source
dwzSearch_1.Create()
if dwzSearch_1.HasFilter() then
dwzSearch_1.FilterRecordset rsVidensbank
end if
'**************************
' Advanced Search
' End code
'**************************
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
rsVidensbank_numRows = rsVidensbank_numRows + Repeat1__numRows
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/verdenbasic.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="EditRegion3" --><title>Untitled Document</title><!-- InstanceEndEditable -->
<script language="JavaScript" type="text/javascript" src="openpopups/openpopups.js"></script>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
}
-->
</style>
<link href="styles.css" rel="stylesheet" type="text/css" />
<script language="JavaScript">
<!-- Gem koden for gamle browsere
function PopWin(url,h,w) {
popupWin = window.open(url, 'popup', 'height=' + h + ',width=' + w + ',top=50,left=25')
}
// -->
</script>
</head>
<body>
<!-- DO NOT MOVE! The following AllWebMenus linking code section must always be placed right AFTER the BODY tag-->
<!-- ******** BEGIN ALLWEBMENUS CODE FOR menu ******** -->
<script type="text/javascript">var MenuLinkedBy="AllWebMenus [4]",awmMenuName="menu",awmBN="632";awmAltUrl="";</script><script charset="UTF-8" src="menu.js" type="text/javascript"></script><script type="text/javascript">awmBuildMenu();</script>
<!-- ******** END ALLWEBMENUS CODE FOR menu ******** -->
<table width="960" height="170" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" bgcolor="#FFF3E2"><table width="100%" height="170" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="#FFFFFF">
<td height="20"> </td>
<td height="20"> </td>
<td height="20" align="center" valign="middle"> </td>
<td height="20" align="center" valign="middle"> </td>
<td height="20" align="center" valign="middle"> </td>
<td height="20" align="center" valign="middle"> </td>
<td height="20" align="center" valign="middle"> </td>
<td height="20" align="center" valign="middle"> </td>
<td height="20" align="center" valign="middle"> </td>
</tr>
<tr>
<td width="10" height="120" bgcolor="#F59F1A"> </td>
<td height="120"><a href="index.htm"><img src="grafikNY/netlogo.gif" alt="logo" width="170" height="100" hspace="10" vspace="10" border="0" /></a></td>
<td width="100" height="120" align="center" valign="top" id="awmAnchor-topmenu"><img src="grafikNY/smalltopbilleder1.gif" width="75" height="75" vspace="12" /><br />
<span class="toptekst"><a href="programdebat.asp" class="topmenulink">DEBAT</a></span></td>
<td width="100" height="120" align="center" valign="top"><img src="grafikNY/smalltopbilleder2.gif" width="75" height="75" vspace="12" /><br />
<span class="toptekst"><a href="programfilm.asp" class="topmenulink">FILM</a></span></td>
<td width="100" height="120" align="center" valign="top"><img src="grafikNY/smalltopbilleder3.gif" width="75" height="75" vspace="12" /><br />
<span class="toptekst"><a href="programmusik.asp" class="topmenulink">MUSIK</a></span></td>
<td width="100" height="120" align="center" valign="top"><img src="grafikNY/smalltopbilleder4.gif" width="75" height="75" vspace="12" /><br />
<span class="toptekst"><a href="programkunst.asp" class="topmenulink">KUNST</a></span></td>
<td width="100" height="120" align="center" valign="top"><img src="grafikNY/smalltopbilleder5.gif" width="75" height="75" vspace="12" /><br /> <span class="topmenulink"><a href="programteater.asp" class="topmenulink">TEATER</a></span></td>
<td width="100" height="120" align="center" valign="top"><img src="grafikNY/smalltopbilleder6.gif" width="75" height="75" vspace="12" /><br />
<span class="topmenulink"><a href="programborn.asp" class="topmenulink">BØRN</a></span></td>
<td width="10" height="120" align="center" valign="middle" bgcolor="#F59F1A"> </td>
</tr>
<tr valign="middle">
<td width="10" valign="middle" bgcolor="#F59F1A"> </td>
<td valign="top"> </td>
<td width="100" align="center" valign="top" class="toptekst"> </td>
<td width="100" align="center" valign="top" class="toptekst"> </td>
<td width="100" align="center" valign="top" class="toptekst"> </td>
<td width="100" align="center" valign="top" class="toptekst"> </td>
<td width="100" valign="top"> </td>
<td width="100" valign="top"> </td>
<td width="10" valign="middle" bgcolor="#F59F1A"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="960" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="10" valign="top" bgcolor="#F59F1A"> </td>
<td width="190" valign="top" bgcolor="#FFF3E2"><table width="100%" border="0" cellpadding="0" cellspacing="0" id="awmAnchor-menu">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
<td valign="top" bgcolor="#FFF3E2"><!-- InstanceBeginEditable name="main" -->
<p class="toptekst">Search</p>
<form id="form1" name="form1" method="post" action="">
Kultur
<label>
<input name="Kat" type="checkbox" id="Kat" value="<%=request("KatKultur")%>" />
</label>
<p>Undervisning
<label>
<input name="uv" type="checkbox" id="uv" value="<%=request("KatUndervisning")%>" />
</label>
</p>
<p>
<label>
<input type="submit" name="Submit" value="Søg" />
</label>
</p>
</form>
<%
While ((Repeat1__numRows <> 0) AND (NOT rsVidensbank.EOF))
%>
<p>Navn: <%=(rsVidensbank.Fields.Item("Navn").Value)%> Kultur: <%=(rsVidensbank.Fields.Item("KatKultur").Value)%> Undervisning: <%=(rsVidensbank.Fields.Item("KatUndervisning").Value)%></p>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsVidensbank.MoveNext()
Wend
%>
<p> </p>
<!-- InstanceEndEditable --></td>
<td width="190" valign="top" bgcolor="#FFF3E2"><!-- InstanceBeginEditable name="right" --><!-- InstanceEndEditable --></td>
<td width="10" valign="top" bgcolor="#F59F1A"> </td>
</tr>
</table>
<p> </p>
</body><!-- InstanceEnd --></html>
<%
rsVidensbank.Close()
Set rsVidensbank = Nothing
%>
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Login
Unread message![Read message [popular]](http://forum.dwzone-it.com/template/subSilver/images/folder_hot.gif)
Read message [popular] ![Unread message [popular]](http://forum.dwzone-it.com/template/subSilver/images/folder_new_hot.gif)
Unread message [popular]![Read message [locked]](http://forum.dwzone-it.com/template/subSilver/images/folder_lock.gif)
Read message [locked] ![Unread message [locked]](http://forum.dwzone-it.com/template/subSilver/images/folder_lock_new.gif)
Unread message [locked]