R
Roger
Hoe kan ik in onderstaande code mijn select statement aanpassen.
Ik wel de variable filter1 toevoegen aan mijn sql statement.
<body>
<%
dim filter1
filter1 = Request.Form("filter1")
%>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>Nummer</b></th>
<th ALIGN="LEFT"><b>Artikelnummer</b></th>
<th ALIGN="LEFT"><b>Field1</b></th>
<th ALIGN="LEFT"><b>Omschrijving</b></th>
<th ALIGN="LEFT"><b>ART_en_Omschr</b></th>
<th ALIGN="LEFT"><b>Apparaat</b></th>
<th ALIGN="LEFT"><b>Artikelnr</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-
columnnames="Nummer,Artikelnummer,Field1,Omschrijving,ART_en_Omschr,Apparaat,Artikelnr"
s-columntypes="3,203,202,203,203,202,202" s-dataconnection="Database1"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-
tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-
listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-
makeform="FALSE" s-recordsource="Bouwmappen" s-
displaycolumns="Nummer,Artikelnummer,Field1,Omschrijving,ART_en_Omschr,Apparaat,Artikelnr"
s-criteria s-order s-sql="SELECT * FROM Bouwmappen" b-
procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-
norecordsfound="No records returned." i-maxrecords="256" i-
groupsize="5" botid="0" u-dblib="_fpclass/fpdblib.inc" u-
dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc"
tag="TBODY" preview="<tr><td colspan=64
bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results
region. The page must be fetched from a web server with a web browser
to display correctly; the current web is stored on your local disk or
network.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Bouwmappen"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=7 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Nummer=3&Artikelnummer=203&Field1=202&Omschrijving=203&ART_en_Omschr=203&Apparaat=202&Artikelnr=202&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#i
Ik wel de variable filter1 toevoegen aan mijn sql statement.
<body>
<%
dim filter1
filter1 = Request.Form("filter1")
%>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>Nummer</b></th>
<th ALIGN="LEFT"><b>Artikelnummer</b></th>
<th ALIGN="LEFT"><b>Field1</b></th>
<th ALIGN="LEFT"><b>Omschrijving</b></th>
<th ALIGN="LEFT"><b>ART_en_Omschr</b></th>
<th ALIGN="LEFT"><b>Apparaat</b></th>
<th ALIGN="LEFT"><b>Artikelnr</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-
columnnames="Nummer,Artikelnummer,Field1,Omschrijving,ART_en_Omschr,Apparaat,Artikelnr"
s-columntypes="3,203,202,203,203,202,202" s-dataconnection="Database1"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-
tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-
listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-
makeform="FALSE" s-recordsource="Bouwmappen" s-
displaycolumns="Nummer,Artikelnummer,Field1,Omschrijving,ART_en_Omschr,Apparaat,Artikelnr"
s-criteria s-order s-sql="SELECT * FROM Bouwmappen" b-
procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-
norecordsfound="No records returned." i-maxrecords="256" i-
groupsize="5" botid="0" u-dblib="_fpclass/fpdblib.inc" u-
dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc"
tag="TBODY" preview="<tr><td colspan=64
bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results
region. The page must be fetched from a web server with a web browser
to display correctly; the current web is stored on your local disk or
network.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Bouwmappen"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=7 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Nummer=3&Artikelnummer=203&Field1=202&Omschrijving=203&ART_en_Omschr=203&Apparaat=202&Artikelnr=202&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#i