Select statement aanpassen in asp gedeelte middels variable

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="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;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.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" 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
 
S

Stefan B Rusynko

Don't understand the question,
but see if this helps
http://spiderwebwoman.com/thingumajig/tweaks.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| 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="&lt;tr&gt;&lt;td colspan=64
| bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font
| color=&quot;#000000&quot;&gt;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.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" 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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to understand this code... 3
@ my wits end 1
FP Database help needed... 6
Help with this calculation!!! 17
any ideas why I can update one table in my database but not the other? 2
Begginer with problems in OLE Object field (imagen) from MS Access. Please help. 8
Please help, FP generated code produces a "Too few parameters. Expected1" error! 7
SELECT DISTINCT Query not working 4

Top