Inventory search form

Ralph · May 24, 2004

I built an inventory search form by using the wizard and
then inserting a new result in the original result page.
www.isisco.com/data1 will give a view of it. the problem
I'm having is I can't get the search function to work
correctly I'm not able to return any record as a result
although, I chose a record parameters that I know exist.

Any help is appreciated.
A gentleman by the name of Rich Palarea helped me to
create the search form. Rich, if you out there and can
give some tips, I would really appreciate it.

Ralph

Bill Schroyer · May 24, 2004

Hard to tell, post the page code.
Check your crieria, change it to begins with and use AND
not OR

Bill Schroyer
(e-mail address removed)
http://www.frontpagewiz.com

Bill Schroyer · May 24, 2004

Hard to tell, post the page code.
Check your crieria, change it to begins with and use AND
not OR

Bill Schroyer
(e-mail address removed)
http://www.frontpagewiz.com

Ralph · May 25, 2004

Bill,
Thanks for yur help. here is code:

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage
Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Results -- View</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">

<table width="100%" align=left>
<tr>
<td width="50%">
<b><font size=+3 color="#000080"> Results Page
</font></b>
</td>
<td width="50%" align=right>
<table>
<tr>
<td>
Results Page
| <a href="editor/submission_form.asp"
target="_top">Submission Form</a>
| <a href="editor/database_editor.asp"
target="_top">Database Editor</a>
</td>
</tr>
</table>
</td>
</tr>
</table>

<p>
<br clear="all">
<hr>
<p>

<table width="100%" border="1">
<thead>
<tr>
<th align="left"><b>Key</b></th>
<th align="left"><b>Date_In</b></th>
<th align="left"><b>Supplier</b></th>
<th align="left"><b>Supplier_Stock</b></th>
<th align="left"><b>Shape</b></th>
<th align="left"><b>Color</b></th>
<th align="left"><b>Clarity</b></th>
<th align="left"><b>Size</b></th>

</tr>
</thead>

<tbody>


<% 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 Results"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=8 align=""LEFT""
width=""100%"">No records returned.</td></tr>"
fp_sDataConn="inventory_db1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Date_In=135&Supplier=202&Supplier_Stoc
k=202&Shape=202&Color=202&Clarity=202&Size=202&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>



<tr>

<td>
<%=FP_FieldVal(fp_rs,"Key")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Date_In")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Supplier")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Supplier_Stock")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Shape")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Color")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Clarity")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"Size")%>
</td>

</tr>


</tbody>

</table>

<p> </p>
<form BOTID="1" METHOD="POST" action="results_page.asp">
<input type="hidden" name="fpdbr_1_PagingMove"
value=" |< ">
<table BORDER="0">
<tr>
<td><b>Shape</b></td>
<td><select size="1" name="Size">
<option>All</option>
<option value="BR">BR</option>
<option value="MQ">MQ</option>
</select></td>
</tr>
<tr>
<td><b>Color</b></td>
<td><select size="1" name="Color">
<option>All</option>
<option value="E">E</option>
<option value="D">D</option>
</select></td>
</tr>
<tr>
<td><b>Clarity</b></td>
<td><select size="1"
name="Clarity">
<option>All</option>
<option value="IF">IF</option>
<option value="VVS1">VVS1</option>
</select></td>
</tr>
<tr>
<td><b>Size</b></td>
<td><select size="1" name="Size">
<option value="All">All</option>
<option value="1.0">1.0</option>
<option value="2.0">2.0</option>
</select></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"><p> </p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>Shape</b></th>
<th ALIGN="LEFT"><b>Color</b></th>
<th
ALIGN="LEFT"><b>Clarity</b></th>
<th ALIGN="LEFT"><b>Size</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-
columnnames="Key,Date_In,Supplier,Supplier_Stock,Shape,Colo
r,Clarity,Size" s-
columntypes="3,135,202,202,202,202,202,202" s-
dataconnection="inventory_db1" 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="TRUE" s-
recordsource="Results" s-
displaycolumns="Shape,Color,Clarity,Size" s-
criteria="[Shape] EQ {Shape} + [Color] EQ {Color} +
[Clarity] EQ {Clarity} + [Size] EQ {Size} +" s-order s-
sql="SELECT * FROM Results WHERE (Shape = '::Shape::' AND
Color = '::Color::' AND Clarity = '::Clarity::' AND Size
= '::Size::')" b-procedure="FALSE" clientside
suggestedext="asp" s-
defaultfields="Shape=&Color=&Clarity=&Size=" s-
norecordsfound="No records returned." i-maxrecords="256" i-
groupsize="5" botid="1" 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 --

<% 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 Results WHERE (Shape = '::Shape::'
AND Color = '::Color::' AND Clarity = '::Clarity::' AND
Size = '::Size::')"
fp_sDefault="Shape=&Color=&Clarity=&Size="
fp_sNoRecords="<tr><td colspan=4 align=""LEFT""
width=""100%"">No records returned.</td></tr>"
fp_sDataConn="inventory_db1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Date_In=135&Supplier=202&Supplier_Stoc
k=202&Shape=202&Color=202&Clarity=202&Size=202&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Date_In,Supplier,Supplier_Stock,Shape,Colo
r,Clarity,Size" s-column="Shape" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="<font size="-
1">&lt;&lt;</font>Shape<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

<td>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Date_In,Supplier,Supplier_Stock,Shape,Colo
r,Clarity,Size" s-column="Color" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="<font size="-
1">&lt;&lt;</font>Color<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

<td>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Date_In,Supplier,Supplier_Stock,Shape,Colo
r,Clarity,Size" s-column="Clarity" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="<font size="-
1">&lt;&lt;</font>Clarity<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

<td>
<!--webbot
bot="DatabaseResultColumn" s-
columnnames="Key,Date_In,Supplier,Supplier_Stock,Shape,Colo
r,Clarity,Size" s-column="Size" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="<font size="-
1">&lt;&lt;</font>Size<font
size="-1">&gt;&gt;</font>"

startspan --> said:
</td>

</tr>
<!--webbot bot="DatabaseRegionEnd" b-
tableformat="TRUE" b-menuformat="FALSE" u-
dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY" preview="<tr><td
colspan=64 bgcolor="#FFFF00" width="100%
"><font color="#000000">This is
the end of a Database Results
region.</font></td></tr><TR><TD
VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
TYPE=Button VALUE=" |< "><INPUT
TYPE=Button VALUE=" < "><INPUT
TYPE=Button VALUE=" > "><INPUT
TYPE=Button VALUE=" >| "> [1/5]
</NOBR><BR></td></tr>" startspan --

</tbody>
</table>

</body>

Help creating a search form in Access XP	0	Mar 4, 2022
Custom toolbar button for search and replace	1	Apr 9, 2023
WORD VBA Search and switch to advanced ...	1	Jul 21, 2021
Dynamic Naming of Form Button	3	May 8, 2023
MS ACCESS: SEARCH in a split form	0	Apr 3, 2017
Inventory search form	0	Jun 1, 2004
inventory search form - help!!	0	Jun 10, 2004
Search assistance	1	Apr 5, 2016

Inventory search form

Ralph

Bill Schroyer

Bill Schroyer

Ralph

Ask a Question

Similar Threads