Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to get frontpage to search a database

Status
Not open for further replies.
nath01

nath01

Technical User
Apr 13, 2004
74
GB
I am trying to get frontpage to search a database (access) for multiple critera i have 4 fields i want it to search either 1 a mixture of them or all of them.

the code uses SQL statments it might work useing wildcards but when ever i try them it gives me an error.

Here is the code i am useing:

i am useing front page to make the pages.

here is the compleate code for the page:
i tyred putting * and % and "%" "*" nothing works, i might be doing something realy simple wrong im not sure.

Thanks alot for the help

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="search.asp">
<table BORDER="0">
<tr>
<td><b>ID</b></td>
<td><input NAME="ID" VALUE="%" size="20"></td>
</tr>
<tr>
<td><b>name</b></td>
<td><input NAME="name" VALUE="%" size="20"></td>
</tr>
<tr>
<td><b>fixed</b></td>
<td><input NAME="fixed" VALUE="%" size="20"></td>
</tr>
<tr>
<td><b>Assigned_To</b></td>
<td><input NAME="Assigned_To" VALUE="%" size="20"></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" CLIENTSIDE
SuggestedExt="asp" PREVIEW=" " -->
<p>&nbsp;</p>
</form>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="ID,name,date_rep,issue_request,priority,other,description,follow_up,fixed,Assigned_To"
s-columntypes="3,202,135,202,202,202,203,203,202,203" s-dataconnection="Network"
b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="7" b-makeform="TRUE"
s-recordsource="Network"
s-displaycolumns="ID,name,date_rep,issue_request,priority,other,description,follow_up,fixed,Assigned_To"
s-criteria="{ID} EQ {ID} + [name] EQ {name} + [fixed] EQ {fixed} + [Assigned_To] EQ {Assigned_To} +"
s-order
s-sql="SELECT * FROM Network WHERE (ID = ::ID:: AND name = '::name::' AND fixed = '::fixed::' AND Assigned_To = '::Assigned_To::')"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="ID=11&amp;name=&amp;fixed=&amp;Assigned_To="
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="1"
BOTID="0" u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="BODY"
local_preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#include file="../../../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM Network WHERE (ID = ::ID:: AND name = '::name::' AND fixed = '::fixed::' AND Assigned_To = '::Assigned_To::')"
fp_sDefault="ID=11&name=&fixed=&Assigned_To="
fp_sNoRecords="No records returned."
fp_sDataConn="Network"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=10
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" I-CheckSum="59764" endspan -->
<form METHOD="POST">
<!--webbot bot="PurpleText"
PREVIEW="Set this form's properties so it submits user input to the appropriate page."
-->
<table BORDER="0">
<tr>
<td><b>ID:</b></td>
<td><input TYPE="TEXT" NAME="ID" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"></td>
</tr>
<tr>
<td><b>name:</b></td>
<td><input TYPE="TEXT" NAME="name" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"name")%>"></td>
</tr>
<tr>
<td><b>date_rep:</b></td>
<td><input TYPE="TEXT" NAME="date_rep" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"date_rep")%>"></td>
</tr>
<tr>
<td><b>issue_request:</b></td>
<td><input TYPE="TEXT" NAME="issue_request" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"issue_request")%>"></td>
</tr>
<tr>
<td><b>priority:</b></td>
<td><input TYPE="TEXT" NAME="priority" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"priority")%>"></td>
</tr>
<tr>
<td><b>other:</b></td>
<td><input TYPE="TEXT" NAME="other" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"other")%>"></td>
</tr>
<tr>
<td><b>description:</b></td>
<td><input TYPE="TEXT" NAME="description" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"description")%>"></td>
</tr>
<tr>
<td><b>follow_up:</b></td>
<td><input TYPE="TEXT" NAME="follow_up" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"follow_up")%>"></td>
</tr>
<tr>
<td><b>fixed:</b></td>
<td><input TYPE="TEXT" NAME="fixed" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"fixed")%>"></td>
</tr>
<tr>
<td><b>Assigned_To:</b></td>
<td><input TYPE="TEXT" NAME="Assigned_To" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"Assigned_To")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset" NAME="fp_reset"></td>
</tr>
</table>
</form>
<hr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="1"
clientside tag="BODY"
local_preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End of Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT VALIGN=MIDDLE&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt; [1/1]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT VALIGN=MIDDLE&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt; [1/1]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" I-CheckSum="9297" endspan -->

</body>

</html>

Thanks for any help!!!!
 
Status
Not open for further replies.

Similar threads

aromol47
  • Locked
  • Question
FrontPage
Replies
0
Views
342
aromol47
aromol47
rlgconsulting
  • Locked
  • Question
FrontPage 2003 - How to Fix/Anchor Header Panel to top of Page
Replies
0
Views
432
rlgconsulting
rlgconsulting
Viandit
  • Locked
  • Question
Frontpage. Links to listen songs
Replies
0
Views
268
Viandit
Viandit
Viandit
  • Locked
  • Question
mp4 on FrontPage
Replies
0
Views
292
Viandit
Viandit
leifoet
  • Locked
  • Question
Upload index.htm in FrontPage does not work well
Replies
0
Views
283
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top