Database help required

[Chris]

Hi

I have a database that I would like to query using a "Wildcard" the alphabet
or Numbers.

I have created the results search and it working fine.

However,

I would like to now add a dropdown box containing the alphabet and digits.

I would like the search to just select the entries with the selection made
from the drop down box

follows the script:


<td><b>Tradingas</b></td>
<td>
<!--webbot bot="Validation" B-Disallow-First-Item="TRUE" -->
<select size="1" name="Alphabetlist">
<option value="Select first letter" selected>Select first letter
</option>
<option value="A">A</option>
<option value="B">B</option>
</select></td>
</tr>
<tr>
<td><b>Province</b></td>
<td><nobr>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,PageHeader,Tradingas,Province,City,Suburb,Placementid,Cate
gories,Subcategory,Listing,Name,Birthdate,Cell1,Landline1,Email1,Partnersnam
e,BdateP,CellP,LandlineP,EmailP,Website,Address,Area,Code,S1,S2,Pic1,Pic2,Pi
c3,Pic4,Pic5,Remote_computer_name,User_name,Browser_type,Timestamp"
s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202
,202,202,202,202,202,202,202,202,203,203,202,202,202,202,202,202,202,202,135
" s-dataconnection="250" b-tableformat="FALSE" b-menuformat="TRUE"
s-menuchoice="Province" s-menuvalue="Province" b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource="Results" s-displaycolumns="Province" s-criteria s-order
s-sql="SELECT * FROM Results" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="1"
u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../_fpclass/fpdbrgn2.inc" preview=" &lt;span style=&quot;color:
rgb(0,0,0); background-color: rgb(255,255,0)&quot;&gt;Database&lt;/span&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 Results"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="250"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Province"
fp_sMenuValue="Province"
fp_sColTypes="&ID=3&PageHeader=202&Tradingas=202&Province=202&City=202&Subur
b=202&Placementid=202&Categories=202&Subcategory=202&Listing=202&Name=202&Bi
rthdate=202&Cell1=202&Landline1=202&Email1=202&Partnersname=202&BdateP=202&C
ellP=202&LandlineP=202&EmailP=202&Website=202&Address=202&Area=202&Code=202&
S1=203&S2=203&Pic1=202&Pic2=202&Pic3=202&Pic4=202&Pic5=202&Remote_computer_n
ame=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan
i-checksum="58314" --><!--webbot bot="Validation"
b-disallow-first-item="TRUE" --><select NAME="Province" SIZE="1">
<option selected value="Select Now">Select Now</option>
<!--webbot bot="AspInclude" clientside
u-incfile="../../_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="AspInclude" endspan i-checksum="7462" -->
<option><%=FP_FieldHTML(fp_rs,"Province")%></option>
<!--webbot bot="AspInclude" clientside
u-incfile="../../_fpclass/fpdbrgn2.inc" startspan --><!--#include
file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="AspInclude" endspan i-checksum="7464" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside preview=" &lt;span style=&quot;color: rgb(0,0,0);
background-color: rgb(255,255,0)&quot;&gt;Results&lt;/span&gt; "
startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></td>
</tr>
</table>
<br>
<input TYPE="Submit"><!--webbot bot="SaveAsASP" clientside
suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP"
endspan --></form>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,PageHeader,Tradingas,Province,City,Suburb,Placementid,Cate
gories,Subcategory,Listing,Name,Birthdate,Cell1,Landline1,Email1,Partnersnam
e,BdateP,CellP,LandlineP,EmailP,Website,Address,Area,Code,S1,S2,Pic1,Pic2,Pi
c3,Pic4,Pic5,Remote_computer_name,User_name,Browser_type,Timestamp"
s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202
,202,202,202,202,202,202,202,202,203,203,202,202,202,202,202,202,202,202,135
" s-dataconnection="250" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE"
i-listformat="2" b-makeform="TRUE" s-recordsource="Results"
s-displaycolumns="Tradingas" s-criteria="[Tradingas] EQ {Tradingas} +
[Province] EQ {Province} +" s-order="[Tradingas] +" s-sql="SELECT * FROM
Results WHERE (Tradingas = '::Tradingas::' AND Province = ':rovince::')
ORDER BY Tradingas ASC" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Tradingas=&amp;Province=" s-norecordsfound="No records
returned." i-maxrecords="256" i-groupsize="50" botid="0"
u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="BODY" preview="&lt;table
border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&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;&lt;/table&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 %>


Any help on this would be appreciated

Thanks
Chris