Solved

Using a table for lookup on a web page

Posted on 2004-09-28
27
157 Views
Last Modified: 2013-12-24
I am using access as my database for our website.  Currently I have a search form for members by business classification page which works fine.  However I have to hard copy in HTML all the business classifcations for the lookup.  If we add a new business classifcation we add it to the access database, notify the webmaster to add the new classification.

Is there a way to make the Business Classification table (tblBusinessClassification) be the look up linked to the page.  This would mean that every new entry wuld be on the list as soon as we upload, without concern that we miss adding a new business classification to the website
0
Comment
Question by:ukbusiness
  • 14
  • 13
27 Comments
 
LVL 12

Expert Comment

by:rcmb
ID: 12179808
Please provide a little more detail.

Do you have two tables in the same database? (business classification and something else)
If yes, is there a common link between the two tables?

I am not real sure what you are asking - Are you just trying to add the classification directly to the database through a web page? and then search the table for information?

RCMB
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12208182
Is this question still open?
0
 

Author Comment

by:ukbusiness
ID: 12208633
Yes it is still open.  i have been out of coutry for a few days.

The business classification is in the same database.  I am trying to determine if I can use it for looking up all the companies in my tblMembers that are under that classification.  Currently, I have to hard code the business Classifications into the html code for search by classification on the wedsite  please look at www.lakecitieschamber.com/members.asp
Thank you
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12208998
So I understand completely -- you actually type in all of the members that display at the bottom section of the page and you desire to have this information display on the fly vice manual creation -- am I correct?

Curtis
0
 

Author Comment

by:ukbusiness
ID: 12212581
No - we have to enter the business classifications on the html section as follows:
<!--

function buildArray() {
var a = buildArray.arguments;
for (i=0; i<a.length; i++) {
this[i] = a[i];
}
this.length = a.length;
}

var urls1 = new buildArray("",
"http://www.lakecitieschamberofcommerce.com/memberstest3.asp?Business+Ckassification=Accounting+Services",
"http://www.lakecitieschamberofcommerce.com/memberstest3.asp?Business+Ckassification=Advertising+and+Public+Relations",
"http://www.lakecitieschamberofcommerce.com/memberstest3.asp?Business+Ckassification=Advertising+Specialties",
"http://www.lakecitieschamberofcommerce.com/memberstest3.asp?Business+Ckassification=Air+Conditioning+and+Heating",
"http://www.lakecitieschamberofcommerce.com/memberstest3.asp?Business+Ckassification=Antiques",
etc.  

followed by a look uo selection as follows:

 </font><font color="#0000FF" SIZE="2" FACE="Arial"><select name="menu1" onChange="go(this, 1, false)">
<option>Select Business Classification

<option> - Accounting Services
<option> - Advertising and Public Relations
<option> - Advertising Specialties
<option> - Air Conditioning and Heating
<option> - Antiques
etc.

I hope this helps in trying to help me on this.
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12213174
Okay,

So what you need to do is simply create a database results on the page that populates when you select something from the dropdown.

Place this code inside your first body tag:
<script language="JavaScript">
function openDir( form ) {
      var newIndex = form.fieldname.selectedIndex;
      if ( newIndex == 0 ) {
            alert( "Please select a Database!" );
      } else {
            cururl = form.fieldname.options[ newIndex ].value;
            window.location.assign( cururl );
      }
}
</script>

Create your drop-down like you have it and then modify your select to something like this:

<select NAME="fieldname" SIZE="1" onChange="openDir( this.form )">

In the option section make it read like so:

<option value="members.asp?=Business Classification=<%=fp_rs("Business Classification")%>"><%=FP_FieldHTML(fp_rs,"Business Classification")%></option>

It would be best if you create the drop-down from the FP Database Results Wizard. This would ensure you get everything and if something changes in the database then you will not need to redo your page.

Delete the drop-down you have and leave your cursor in the cell.
Select Insert, Database, Region
Step 1 Select your database
Step 2 Edit the query to read SELECT [Business Classification] FROM TableName GROUP BY [Business Classification] ORDER BY [Business Classification] ASC
Step 3 Just click OK
Step 4 Select Drop Down
Step 5 Do not check the search form option and make sure the radio is set to display all records together.
Finish

This will insert your drop down and you do not need any form buttons.
Modify the html code to look like my example above. You may need to adjust based on your form name and field name.

Now in the same page where you normally display the information simply insert a database results wizard to display you information based on the selection of the drop down.

Step 1 Select your database
Step 2 Select your table
Step 3 Remove any fields you do not desire to display
Click on More Options..., Criteria and select Business Classification
Click on Ordering and select the method you desire to have the data sorted.
 (this will make your query look like SELECT * FROM Tablename WHERE [Business Classification] = '::Business Classification::' ORDER BY YourChoice ASC
Step 4 Select a method to display -- I recommend Paragraphs and then modify to make it look like you desire.
Step 5 Display all records together and do not display a search form.

RCMB
0
 

Author Comment

by:ukbusiness
ID: 12228814
I am a real newby to this html and not cetain where I need to interject myformname versus a note of reference.  If I could send you my current page html could you give me some guidence?  If this is beyond the norm pleas elet me know _ I would fully uinderstand

I am also having some troubles in statements like Select Insert, Database, Region  I get a Insert, Database but NO Region am I in the wrong spot (or just confused)?

Thanks
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12229493
I will get back to you on editing the current page later today.

For the Region -- Change it to Select, Database, Results
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12236376
Here is your page with some modifications. Copy the below information and paste it into Notepad first and then copy it again and paste it into Front Page html view. Remember to delete all HTML code on the new blank page before pasting:


<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>MEMBERSHIP SEARCH</title>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=.75)">
<meta name="Microsoft Border" content="b, default">
</head>

<body bgproperties="fixed" bgcolor="#D4D4D4">
<script language="JavaScript">
function openDir( form ) {
     var newIndex = form.fieldname.selectedIndex;
     if ( newIndex == 0 ) {
          alert( "Please select a Business!" );
     } else {
          cururl = form.fieldname.options[ newIndex ].value;
          window.location.assign( cururl );
     }
}
</script>

  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td width="33%">
        <applet code="fphover.class" width="97" height="24">
          <param name="textcolor" value="#FFFFFF">
          <param name="text" value="Home">
          <param name="color" value="#0000FF">
          <param name="hovercolor" value="#FFFF00">
          <param name="effect" value="reverseGlow">
          <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
        </applet>
      </td>
      <td width="56%">
        <p align="center"><b><font size="4" color="#0000FF">MEMBERSHIP SEARCH
        <br>
        By Business Classification<br>
        <br>
&nbsp; </font></b><b><font size="4" color="#0000FF"><br>
        </font></b><font color="#0000FF"><b>
        <img border="0" src="images/logo.jpg" width="65" height="76" align="right"></b></font></td>
      <td width="28%"></td>
    </tr>
  </table>
<p><strong><font color="#800000">
Last update:
Tuesday, October 05, 2004</font></strong></p>
<form BOTID="0" METHOD="POST" name=form ACTION="members.asp">
  <table BORDER="0">
    <tr>
      <td><b><font color="#0000FF">Business Classification</font></b></td>
      <td>Insert first database results here<br>
      Select Insert, Database, Region<br>
Step 1 Select your database<br>
Step 2 Edit the query to read SELECT [Business Classification] FROM TableName GROUP BY [Business Classification] ORDER BY [Business Classification] ASC<br>
Step 3 Just click OK<br>
Step 4 Select Drop Down<br>
Step 5 Do not check the search form option and make sure the radio is set to display all records together.<br>
Finish
     
     
      </td>
    </tr>
    <tr>
      <td></td>
      <td><font color="#0000FF"><input NAME="Business Ckassification" VALUE="" size="48">&nbsp;&nbsp;&nbsp; </font></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </table>
  <p>
  <font color="#0000FF">
  <input TYPE="Submit"><input TYPE="Reset"><br>
&nbsp;</font></p>
</form>

<p>
<applet code="fphover.class" width="97" height="24">
  <param name="textcolor" value="#FFFFFF">
  <param name="text" value="Home">
  <param name="color" value="#0000FF">
  <param name="hovercolor" value="#FFFF00">
  <param name="effect" value="reverseGlow">
  <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
</applet>
</p>
Insert your second database results here<br>
ep 1 Select your database<br>
Step 2 Select your table<br>
Step 3 Remove any fields you do not desire to display<br>
Click on More Options..., Criteria and select Business Classification<br>
Click on Ordering and select the method you desire to have the data sorted.<br>
 (this will make your query look like SELECT * FROM Tablename WHERE [Business Classification] = '::Business Classification::' ORDER BY YourChoice ASC<br>
Step 4 Select a method to display -- I recommend Paragraphs and then modify to make it look like you desire.<br>
Step 5 Display all records together and do not display a search form.<br>
</body></html>
0
 

Author Comment

by:ukbusiness
ID: 12238845
Now i have a new problem - The lookup table has a business Classification field BusinessType instead of Business Classification.  The drop down is working fine, but it will not find the record until I type in the listing in the second search search box.  Is there a link I have to put in the code that compares BussinessType to Business Ckassification?  I herited this database with some spelling errors and slight variances on Field Names.  I have enclosed the code as I now have it on the test page:

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>MEMBERSHIP SEARCH</title>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=.75)">
<meta name="Microsoft Border" content="b, default">
</head>

<body bgproperties="fixed" bgcolor="#D4D4D4">
<script language="JavaScript">
function openDir( form ) {
     var newIndex = form.fieldname.selectedIndex;
     if ( newIndex == 0 ) {
          alert( "Please select a Business!" );
     } else {
          cururl = form.fieldname.options[ newIndex ].value;
          window.location.assign( cururl );
     }
}
</script>

  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td width="33%">
        <applet code="fphover.class" width="97" height="24">
          <param name="textcolor" value="#FFFFFF">
          <param name="text" value="Home">
          <param name="color" value="#0000FF">
          <param name="hovercolor" value="#FFFF00">
          <param name="effect" value="reverseGlow">
          <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
        </applet>
      </td>
      <td width="56%">
        <p align="center"><b><font size="4" color="#0000FF">MEMBERSHIP SEARCH
        <br>
        By BusinessType<br>
        <br>
&nbsp; </font></b><b><font size="4" color="#0000FF"><br>
        </font></b><font color="#0000FF"><b>
        <img border="0" src="images/logo.jpg" width="65" height="76" align="right"></b></font></td>
      <td width="28%"></td>
    </tr>
  </table>
<p><strong><font color="#800000">
Last update:
Tuesday, October 05, 2004</font></strong></p>
<form BOTID="0" METHOD="POST" name=form ACTION="members.asp">
  <table BORDER="0">
    <tr>
      <td><b><font color="#0000FF">Business Classification</font></b></td>
      <td><nobr>
      <!--webbot bot="DatabaseRegionStart" s-columnnames="BusinessType" s-columntypes="202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="BusinessType" s-menuvalue="BusinessType" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource s-displaycolumns="BusinessType" s-criteria s-order s-sql="SELECT [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" 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 [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="BusinessType"
fp_sMenuValue="BusinessType"
fp_sColTypes="&BusinessType=202&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="16695" --><select NAME="BusinessType" SIZE="1">
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
      <option><%=FP_FieldHTML(fp_rs,"BusinessType")%></option>
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
      </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><br>
   
     
      </td>
    </tr>
    <tr>
      <td></td>
      <td><font color="#0000FF"><input NAME="Business Ckassification" VALUE="" size="48">&nbsp;&nbsp;&nbsp; </font></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </table>
  <p>
  <font color="#0000FF">
  <input TYPE="Submit"><input TYPE="Reset"><br>
&nbsp;</font></p>
  <!--webbot bot="DatabaseRegionStart" s-columnnames="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-columntypes="202,202,3,3,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,3,202,202,202,202,202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-criteria s-order s-sql="SELECT *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM &quot;members Query&quot; WHERE (&quot;Business Ckassification&quot; =  '::Business Ckassification::') ORDER BY &quot;Business Ckassification&quot; ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Business Ckassification=" 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" tag="BODY" 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;" 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 *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM ""members Query"" WHERE (""Business Ckassification"" =  '::Business Ckassification::') ORDER BY ""Business Ckassification"" ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC"
fp_sDefault="Business Ckassification="
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Expr1000=202&Expr1001=202&MemberID=3&MembershipID=3&Business Ckassification=202&WorkCompany=202&FirstName=202&LastName=202&WorkAddress=202&WorkAddress2=202&WorkCity=202&WorkStateOrProvince=202&WorkPostalCode=202&WorkPhone=202&FaxNumber=202&EmailName=202&WebSite=203&Location1=202&Location2=202&Location City=202&Location State=202&Location ZIP=202&MemberTypeID=3&PrefixTitle=202&FullName=202&Fulladdress=202&FullCity=202&Extension=202&"
fp_iDisplayCols=28
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="25228" --><p><b>
<font color="#0000FF" size="2">Business Classification:</font><font size="4" color="#FF0000">&nbsp;</font><font color="#FF0000" size="3"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Business Ckassification" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Business Ckassification&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Business Ckassification")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="57982" -->
</font></b></p>
<p><font color="#0000FF"><b><font size="4"><u>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkCompany" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkCompany&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkCompany")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31658" --></u></font><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullName" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16570" -->&nbsp;&nbsp;&nbsp;&nbsp;<br>
</b><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Fulladdress" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Fulladdress&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Fulladdress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32176" -->
<br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullCity" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullCity&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullCity")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="17342" -->
</font></p>
<p><font color="#0000FF"><b><font size="3">Phone:</font></b>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkPhone" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkPhone&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkPhone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20872" -->
</font><b><font color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Extension" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-menuformat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Extension&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Extension")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21582" --></font><font color="#0000FF"><br>
<font size="3">FAX:&nbsp; </font></font></b><font color="#0000FF">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FaxNumber" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FaxNumber&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FaxNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="18464" -->
&nbsp; <b><br>
Email:</b>&nbsp;<a href="mailto:<%=FP_FieldLink(fp_rs,"EmailName")%>"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="EmailName" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;EmailName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"EmailName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="24526" -->
</a><b><br>
WebSite:</b>&nbsp;<a href="<%=FP_FieldLink(fp_rs,"WebSite")%>" target="_blank"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WebSite" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WebSite&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"WebSite")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12464" -->
</a></font></p>
  <!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" 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;/table&gt;" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></form>

<p>
<applet code="fphover.class" width="97" height="24">
  <param name="textcolor" value="#FFFFFF">
  <param name="text" value="Home">
  <param name="color" value="#0000FF">
  <param name="hovercolor" value="#FFFF00">
  <param name="effect" value="reverseGlow">
  <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
</applet>
</p>
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12238921
In normal view double click on the drop down box that is listing the Business Type

In the name box change it to read Business Ckassification

Now the sql query will pass the imformation as Business Ckassification vice Business Type

RCMB
0
 

Author Comment

by:ukbusiness
ID: 12239740
I am trying to change the name but I am getting an eror message:

Name is not valid.

To allow the name to be used in a scripting language, it must start with a letter or underscore, and subsequent
characters must be letters, digits, or underscores.

Any suggestions?
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12239836
Remove the spaces and then edit the sql code in the lower part of the page to read:

.... WHERE (""Business Ckassification"" =  '::BusinessCkassification::')

FYI -- The information between ':: ::' is equal to the actual name of the form field (text box, drop-down, etc.) or if you are passing via a URL it would be like ...file.asp?BusinessCkassification=Something here

Curtis
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:ukbusiness
ID: 12243702
Dear Curtis,

I am having some comprehension problems with the statement:
Remove the spaces and then edit the sql code in the lower part of the page to read:

.... WHERE (""Business Ckassification"" =  '::BusinessCkassification::')
What are you referring to when you say  the sql code in the lower part of the page to read:

I don't know exactly where on the page you mean.  



0
 
LVL 12

Expert Comment

by:rcmb
ID: 12243828
When you created the section that actually displays the results from what you have selected in the drop down you added a SQL statement that looks like:

SELECT *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM ""members Query"" WHERE (""Business Ckassification"" =  '::Business Ckassification::') ORDER BY ""Business Ckassification"" ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC"

You need to modify this information.

Find the Start Database Results Region Yellow Bar in the normal view of your document and double click on it. This will start the wizard to allow you to edit the configuration of your database results region.

In step 2 edit the SQL statement and make the changes I stated above.

Curtis

I have modified your page with the necessary changes in case you do not understand my directions. Copy everything below and paste it into notepad and then copy it and paste it into frontpage html view and replace all code in your page.

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>MEMBERSHIP SEARCH</title>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=.75)">
<meta name="Microsoft Border" content="b, default">
</head>

<body bgproperties="fixed" bgcolor="#D4D4D4">
<script language="JavaScript">
function openDir( form ) {
     var newIndex = form.fieldname.selectedIndex;
     if ( newIndex == 0 ) {
          alert( "Please select a Business!" );
     } else {
          cururl = form.fieldname.options[ newIndex ].value;
          window.location.assign( cururl );
     }
}
</script>

  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td width="33%">
        <applet code="fphover.class" width="97" height="24">
          <param name="textcolor" value="#FFFFFF">
          <param name="text" value="Home">
          <param name="color" value="#0000FF">
          <param name="hovercolor" value="#FFFF00">
          <param name="effect" value="reverseGlow">
          <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
        </applet>
      </td>
      <td width="56%">
        <p align="center"><b><font size="4" color="#0000FF">MEMBERSHIP SEARCH
        <br>
        By BusinessType<br>
        <br>
&nbsp; </font></b><b><font size="4" color="#0000FF"><br>
        </font></b><font color="#0000FF"><b>
        <img border="0" src="images/logo.jpg" width="65" height="76" align="right"></b></font></td>
      <td width="28%"></td>
    </tr>
  </table>
<p><strong><font color="#800000">
Last update:
Tuesday, October 05, 2004</font></strong></p>
<form BOTID="0" METHOD="POST" name=form ACTION="members.asp">
  <table BORDER="0">
    <tr>
      <td><b><font color="#0000FF">Business Classification</font></b></td>
      <td><nobr>
      <!--webbot bot="DatabaseRegionStart" s-columnnames="BusinessType" s-columntypes="202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="BusinessType" s-menuvalue="BusinessType" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource s-displaycolumns="BusinessType" s-criteria s-order s-sql="SELECT [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" 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 [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="BusinessType"
fp_sMenuValue="BusinessType"
fp_sColTypes="&BusinessType=202&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="16695" --><select NAME="BusinessType" SIZE="1">
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
      <option><%=FP_FieldHTML(fp_rs,"BusinessType")%></option>
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
      </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><br>
   
     
      </td>
    </tr>
    <tr>
      <td></td>
      <td><font color="#0000FF"><input NAME="Business Ckassification" VALUE="" size="48">&nbsp;&nbsp;&nbsp; </font></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </table>
  <p>
  <font color="#0000FF">
  <input TYPE="Submit"><input TYPE="Reset"><br>
&nbsp;</font></p>
  <!--webbot bot="DatabaseRegionStart" s-columnnames="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-columntypes="202,202,3,3,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,3,202,202,202,202,202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-criteria s-order s-sql="SELECT *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM &quot;members Query&quot; WHERE (&quot;Business Ckassification&quot; =  '::BusinessType::') ORDER BY &quot;Business Ckassification&quot; ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Business Ckassification=" 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" tag="BODY" 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;" 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 *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM ""members Query"" WHERE (""Business Ckassification"" =  '::BusinessType::') ORDER BY ""Business Ckassification"" ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC"
fp_sDefault="Business Ckassification="
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Expr1000=202&Expr1001=202&MemberID=3&MembershipID=3&Business Ckassification=202&WorkCompany=202&FirstName=202&LastName=202&WorkAddress=202&WorkAddress2=202&WorkCity=202&WorkStateOrProvince=202&WorkPostalCode=202&WorkPhone=202&FaxNumber=202&EmailName=202&WebSite=203&Location1=202&Location2=202&Location City=202&Location State=202&Location ZIP=202&MemberTypeID=3&PrefixTitle=202&FullName=202&Fulladdress=202&FullCity=202&Extension=202&"
fp_iDisplayCols=28
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="25228" --><p><b>
<font color="#0000FF" size="2">Business Classification:</font><font size="4" color="#FF0000">&nbsp;</font><font color="#FF0000" size="3"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Business Ckassification" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Business Ckassification&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Business Ckassification")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="57982" -->
</font></b></p>
<p><font color="#0000FF"><b><font size="4"><u>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkCompany" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkCompany&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkCompany")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31658" --></u></font><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullName" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16570" -->&nbsp;&nbsp;&nbsp;&nbsp;<br>
</b><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Fulladdress" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Fulladdress&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Fulladdress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32176" -->
<br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullCity" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullCity&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullCity")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="17342" -->
</font></p>
<p><font color="#0000FF"><b><font size="3">Phone:</font></b>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkPhone" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkPhone&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkPhone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20872" -->
</font><b><font color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Extension" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-menuformat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Extension&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Extension")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21582" --></font><font color="#0000FF"><br>
<font size="3">FAX:&nbsp; </font></font></b><font color="#0000FF">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FaxNumber" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FaxNumber&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FaxNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="18464" -->
&nbsp; <b><br>
Email:</b>&nbsp;<a href="mailto:<%=FP_FieldLink(fp_rs,"EmailName")%>"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="EmailName" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;EmailName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"EmailName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="24526" -->
</a><b><br>
WebSite:</b>&nbsp;<a href="<%=FP_FieldLink(fp_rs,"WebSite")%>" target="_blank"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WebSite" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WebSite&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"WebSite")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12464" -->
</a></font></p>
  <!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" 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;/table&gt;" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></form>

<p>
<applet code="fphover.class" width="97" height="24">
  <param name="textcolor" value="#FFFFFF">
  <param name="text" value="Home">
  <param name="color" value="#0000FF">
  <param name="hovercolor" value="#FFFF00">
  <param name="effect" value="reverseGlow">
  <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
</applet>
</p>
0
 

Author Comment

by:ukbusiness
ID: 12249401
Thank you for that clarification.  I have the page working but with one small (I hope) problem. When you select a Business Type from the drop down and submit it fills in in the next field [businessCkassification] and the you must click submit again which will bring up the records correctly.  The drop down goes back to the first Item "Accounting Services"  Is there a way to stop from having to click submit twice and is there a way to add the first item default as "Select Business Classifacation" the initial value is <%=Request("BusinessType")%>?
0
 

Author Comment

by:ukbusiness
ID: 12249712
I have the new form located as follows so you may see what I am seeing.  http://lakecitieschamber.com/Lake%20Dallas/members.asp

Thanks
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12250557
Okay here is the modified code. What should happen now is the user selects from the drop down and the page automatically reloads with the information requested. The find button is gone as it is no longer needed.

Curtis

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>MEMBERSHIP SEARCH</title>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=.75)">
<meta name="Microsoft Border" content="b, default">
</head>

<body bgproperties="fixed" bgcolor="#D4D4D4">
<script language="JavaScript">
function openDir( form ) {
     var newIndex = form.BusinessType.selectedIndex;
     if ( newIndex == 0 ) {
          alert( "Please select a Business!" );
     } else {
          cururl = form.BusinessType.options[ newIndex ].value;
          window.location.assign( cururl );
     }
}
</script>

  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td width="33%">
        <applet code="fphover.class" width="97" height="24">
          <param name="textcolor" value="#FFFFFF">
          <param name="text" value="Home">
          <param name="color" value="#0000FF">
          <param name="hovercolor" value="#FFFF00">
          <param name="effect" value="reverseGlow">
          <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
        </applet>
      </td>
      <td width="56%">
        <p align="center"><b><font size="4" color="#0000FF">MEMBERSHIP SEARCH
        <br>
        By BusinessType<br>
        <br>
&nbsp; </font></b><b><font size="4" color="#0000FF"><br>
        </font></b><font color="#0000FF"><b>
        <img border="0" src="images/logo.jpg" width="65" height="76" align="right"></b></font></td>
      <td width="28%"></td>
    </tr>
  </table>
<p><strong><font color="#800000">
Last update:
Tuesday, October 05, 2004</font></strong></p>
<form BOTID="0" METHOD="POST" name=form ACTION="members.asp">
  <table BORDER="0">
    <tr>
      <td><b><font color="#0000FF">Business Classification</font></b></td>
      <td><nobr>
      <!--webbot bot="DatabaseRegionStart" s-columnnames="BusinessType" s-columntypes="202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="BusinessType" s-menuvalue="BusinessType" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource s-displaycolumns="BusinessType" s-criteria s-order s-sql="SELECT [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" 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 [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="BusinessType"
fp_sMenuValue="BusinessType"
fp_sColTypes="&BusinessType=202&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="6074" --><select NAME="BusinessType" SIZE="1">
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
      <option>--- Select Business Classification ---</option>
      <option value="members.asp?=BusinessType=<%=fp_rs("Business Classification")%>"><%=FP_FieldHTML(fp_rs,"BusinessType")%></option>
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
      </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><br>
   
     
      </td>
    </tr>
  </table>
  <!--webbot bot="DatabaseRegionStart" s-columnnames="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-columntypes="202,202,3,3,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,3,202,202,202,202,202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-criteria s-order s-sql="SELECT *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM &quot;members Query&quot; WHERE (&quot;Business Ckassification&quot; =  '::BusinessType::') ORDER BY &quot;Business Ckassification&quot; ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Business Ckassification=" 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" 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 region will not work unless the page has a file extension of &quot;.asp&quot;.&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 %>
<%
fp_sQry="SELECT *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM ""members Query"" WHERE (""Business Ckassification"" =  '::BusinessType::') ORDER BY ""Business Ckassification"" ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC"
fp_sDefault="Business Ckassification="
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Expr1000=202&Expr1001=202&MemberID=3&MembershipID=3&Business Ckassification=202&WorkCompany=202&FirstName=202&LastName=202&WorkAddress=202&WorkAddress2=202&WorkCity=202&WorkStateOrProvince=202&WorkPostalCode=202&WorkPhone=202&FaxNumber=202&EmailName=202&WebSite=203&Location1=202&Location2=202&Location City=202&Location State=202&Location ZIP=202&MemberTypeID=3&PrefixTitle=202&FullName=202&Fulladdress=202&FullCity=202&Extension=202&"
fp_iDisplayCols=28
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="20514" --><p><b>
<font color="#0000FF" size="2">Business Classification:</font><font size="4" color="#FF0000">&nbsp;</font><font color="#FF0000" size="3"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Business Ckassification" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Business Ckassification&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Business Ckassification")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="57982" -->
</font></b></p>
<p><font color="#0000FF"><b><font size="4"><u>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkCompany" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkCompany&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkCompany")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31658" --></u></font><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullName" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16570" -->&nbsp;&nbsp;&nbsp;&nbsp;<br>
</b><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Fulladdress" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Fulladdress&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Fulladdress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32176" -->
<br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullCity" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullCity&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullCity")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="17342" -->
</font></p>
<p><font color="#0000FF"><b><font size="3">Phone:</font></b>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkPhone" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkPhone&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkPhone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20872" -->
</font><b><font color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Extension" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-menuformat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Extension&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Extension")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21582" --></font><font color="#0000FF"><br>
<font size="3">FAX:&nbsp; </font></font></b><font color="#0000FF">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FaxNumber" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FaxNumber&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FaxNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="18464" -->
&nbsp; <b><br>
Email:</b>&nbsp;<a href="mailto:<%=FP_FieldLink(fp_rs,"EmailName")%>"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="EmailName" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;EmailName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"EmailName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="24526" -->
</a><b><br>
WebSite:</b>&nbsp;<a href="<%=FP_FieldLink(fp_rs,"WebSite")%>" target="_blank"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WebSite" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WebSite&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"WebSite")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12464" -->
</a></font></p>
  <!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside 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 end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="23298" --></form>

<p>
<applet code="fphover.class" width="97" height="24">
  <param name="textcolor" value="#FFFFFF">
  <param name="text" value="Home">
  <param name="color" value="#0000FF">
  <param name="hovercolor" value="#FFFF00">
  <param name="effect" value="reverseGlow">
  <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
</applet>
</p>
0
 

Author Comment

by:ukbusiness
ID: 12251726
I have the new form located as follows so you may see what I am seeing.  http://lakecitieschamber.com/Lake%20Dallas/members.asp

Somthing is blowing out the code on line 87 But 87 appears blank to me
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12252179
Find  this line:

<option value="members.asp?=BusinessType=<%=fp_rs("Business Classification")%>"><%=FP_FieldHTML(fp_rs,"BusinessType")%></option>


and change it to read:

<option value="members.asp?=BusinessType=<%=fp_rs("BusinessType")%>"><%=FP_FieldHTML(fp_rs,"BusinessType")%></option>
0
 

Author Comment

by:ukbusiness
ID: 12252384
Curtis,

Made the change - new problem

I have the new form located as follows so you may see what I am seeing.  http://lakecitieschamber.com/Lake%20Dallas/members.asp
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12252909
Okay I found the problems. This should work now.


<body bgproperties="fixed" bgcolor="#D4D4D4">
html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>MEMBERSHIP SEARCH</title>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=.75)">
<meta name="Microsoft Border" content="b, default">
</head>

<script language="JavaScript">
function openDir( form ) {
     var newIndex = form.BusinessType.selectedIndex;
     if ( newIndex == 0 ) {
          alert( "Please select a Business Classification!" );
     } else {
          cururl = form.BusinessType.options[ newIndex ].value;
          window.location.assign( cururl );
     }
}
</script>

  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td width="33%">
        <applet code="fphover.class" width="97" height="24">
          <param name="textcolor" value="#FFFFFF">
          <param name="text" value="Home">
          <param name="color" value="#0000FF">
          <param name="hovercolor" value="#FFFF00">
          <param name="effect" value="reverseGlow">
          <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
        </applet>
      </td>
      <td width="56%">
        <p align="center"><b><font size="4" color="#0000FF">MEMBERSHIP SEARCH
        <br>
        By BusinessType<br>
        <br>
&nbsp; </font></b><b><font size="4" color="#0000FF"><br>
        </font></b><font color="#0000FF"><b>
        <img border="0" src="images/logo.jpg" width="65" height="76" align="right"></b></font></td>
      <td width="28%"></td>
    </tr>
  </table>
<p><strong><font color="#800000">
Last update:
Tuesday, October 05, 2004</font></strong></p>
<form BOTID="0" METHOD="POST" name=form ACTION="members.asp">
  <table BORDER="0">
    <tr>
      <td><b><font color="#0000FF">Business Classification</font></b></td>
      <td><nobr>
      <!--webbot bot="DatabaseRegionStart" s-columnnames="BusinessType" s-columntypes="202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="BusinessType" s-menuvalue="BusinessType" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource s-displaycolumns="BusinessType" s-criteria s-order s-sql="SELECT [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" 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 [BusinessType] FROM BusinessClassification GROUP BY [BusinessType] ORDER BY [BusinessType] ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="BusinessType"
fp_sMenuValue="BusinessType"
fp_sColTypes="&BusinessType=202&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="6074" --><select NAME="BusinessType" SIZE="1" onChange="openDir( this.form )">
      <option>--- Select Business Classification ---</option>
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
      <option value="members.asp?=BusinessType=<%=fp_rs("BusinessType")%>"><%=FP_FieldHTML(fp_rs,"BusinessType")%></option>
      <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
      </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><br>
   
     
      </td>
    </tr>
  </table>
  <!--webbot bot="DatabaseRegionStart" s-columnnames="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-columntypes="202,202,3,3,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,3,202,202,202,202,202" s-dataconnection="Database3" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="Expr1000,Expr1001,MemberID,MembershipID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-criteria s-order s-sql="SELECT *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM &quot;members Query&quot; WHERE (&quot;Business Ckassification&quot; =  '::BusinessType::') ORDER BY &quot;Business Ckassification&quot; ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Business Ckassification=" 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" 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 region will not work unless the page has a file extension of &quot;.asp&quot;.&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 %>
<%
fp_sQry="SELECT *,Format(workphone, '(000) 000-0000'), FORMAT(FAXNumber, '(000) 000-0000') FROM ""members Query"" WHERE (""Business Ckassification"" =  '::BusinessType::') ORDER BY ""Business Ckassification"" ASC,WorkCompany ASC,MemberTypeID ASC,Fullname ASC,FullCity ASC,WorkPhone ASC,FaxNumber ASC,EmailName ASC"
fp_sDefault="Business Ckassification="
fp_sNoRecords="No records returned."
fp_sDataConn="Database3"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Expr1000=202&Expr1001=202&MemberID=3&MembershipID=3&Business Ckassification=202&WorkCompany=202&FirstName=202&LastName=202&WorkAddress=202&WorkAddress2=202&WorkCity=202&WorkStateOrProvince=202&WorkPostalCode=202&WorkPhone=202&FaxNumber=202&EmailName=202&WebSite=203&Location1=202&Location2=202&Location City=202&Location State=202&Location ZIP=202&MemberTypeID=3&PrefixTitle=202&FullName=202&Fulladdress=202&FullCity=202&Extension=202&"
fp_iDisplayCols=28
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="20514" --><p><b>
<font color="#0000FF" size="2">Business Classification:</font><font size="4" color="#FF0000">&nbsp;</font><font color="#FF0000" size="3"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Business Ckassification" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Business Ckassification&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Business Ckassification")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="57982" -->
</font></b></p>
<p><font color="#0000FF"><b><font size="4"><u>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkCompany" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkCompany&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkCompany")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31658" --></u></font><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullName" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16570" -->&nbsp;&nbsp;&nbsp;&nbsp;<br>
</b><br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Fulladdress" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Fulladdress&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"Fulladdress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32176" -->
<br>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FullCity" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FullCity&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink="FALSE" b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FullCity")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="17342" -->
</font></p>
<p><font color="#0000FF"><b><font size="3">Phone:</font></b>
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WorkPhone" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WorkPhone&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"WorkPhone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20872" -->
</font><b><font color="#800000">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="Extension" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-menuformat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Extension&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Extension")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21582" --></font><font color="#0000FF"><br>
<font size="3">FAX:&nbsp; </font></font></b><font color="#0000FF">
<!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="FaxNumber" b-tableformat="FALSE" b-hashtml="FALSE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;FaxNumber&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_FieldVal(fp_rs,"FaxNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="18464" -->
&nbsp; <b><br>
Email:</b>&nbsp;<a href="mailto:<%=FP_FieldLink(fp_rs,"EmailName")%>"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="EmailName" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;EmailName&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"EmailName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="24526" -->
</a><b><br>
WebSite:</b>&nbsp;<a href="<%=FP_FieldLink(fp_rs,"WebSite")%>" target="_blank"><!--webbot bot="DatabaseResultColumn" s-columnnames="MemberID,Business Ckassification,WorkCompany,FirstName,LastName,WorkAddress,WorkAddress2,WorkCity,WorkStateOrProvince,WorkPostalCode,WorkPhone,FaxNumber,EmailName,WebSite,Location1,Location2,Location City,Location State,Location ZIP,MemberTypeID,PrefixTitle,FullName,Fulladdress,FullCity,Extension" s-column="WebSite" b-tableformat="FALSE" b-hashtml="TRUE" clientside preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;WebSite&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink b-menuformat startspan --><%=FP_Field(fp_rs,"WebSite")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12464" -->
</a></font></p>
  <!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside 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 end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="23298" --></form>

<p>
<applet code="fphover.class" width="97" height="24">
  <param name="textcolor" value="#FFFFFF">
  <param name="text" value="Home">
  <param name="color" value="#0000FF">
  <param name="hovercolor" value="#FFFF00">
  <param name="effect" value="reverseGlow">
  <param name="url" valuetype="ref" value="Http://lakecitieschamber.com/default.htm">
</applet>
</p>
0
 

Author Comment

by:ukbusiness
ID: 12252991
Nope.  No records are being brought up - the selection is working great but no records are being pulled up.


I have the new form located as follows so you may see what I am seeing.  http://lakecitieschamber.com/Lake%20Dallas/members.asp

0
 
LVL 12

Accepted Solution

by:
rcmb earned 259 total points
ID: 12253578
First thing change the top of the page that reads:

<body bgproperties="fixed" bgcolor="#D4D4D4">
html>

to read:

<html>

Next find the line that begins with:

<option value="members.asp?=BusinessType=<%=fp_rs("BusinessType")%>">

and make it read:

<option value="members.asp?BusinessType=<%=fp_rs("BusinessType")%>">

Curtis
0
 

Author Comment

by:ukbusiness
ID: 12254331
Curtis,

Thank you.  What are few hoops to jump through.  Great Solution and eliminates all the possible missed setups from the past.

great job I learned a lot.
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12254646
Gald we got it working.

If you need more help just let me know.

Curtis
0
 

Author Comment

by:ukbusiness
ID: 12254752
Thank you  - If I need more help I found the "go-to" guy.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now