hwg-techniques archives Apr 2003 new search results previous next

RE: ASP Problem

by "Juliana Halvorson" <juliana(at)graphmaster.com>

 Date:  Thu, 17 Apr 2003 16:22:34 -0600
 To:  "'Juliana Halvorson'" <juliana(at)graphmaster.com>
 Cc:  <hwg-techniques(at)hwg.org>
 In-Reply-To:  julianasnetwork
  todo: View Thread, Original 
Sorry, here is the code from the page (not all of it is included):


<p>You can search for an event by specific information, or see the<a
href="2003springmaster.asp" style="text-decoration: none; font-weight:
700">
Master List.</a></p>

<p>All three fields (school, sport and level) must be selected for the
search to 
work.</p>

<!--webbot BOT="GeneratedScript" PREVIEW=" " startspan --><script
Language="JavaScript" Type="text/javascript"><!--
function FrontPage_Form2_Validator(theForm)
{

  if (theForm.School.selectedIndex < 0)
  {
    alert("Please select one of the \"School\" options.");
    theForm.School.focus();
    return (false);
  }

  if (theForm.Sport.selectedIndex < 0)
  {
    alert("Please select one of the \"Sport\" options.");
    theForm.Sport.focus();
    return (false);
  }

  if (theForm.Level.selectedIndex < 0)
  {
    alert("Please select one of the \"Level\" options.");
    theForm.Level.focus();
    return (false);
  }
  return (true);
}
//--></script><!--webbot BOT="GeneratedScript" endspan --><form
BOTID="0" METHOD="POST" ACTION="2003springsearch.asp" onsubmit="return
FrontPage_Form2_Validator(this)" language="JavaScript"
name="FrontPage_Form2" class="smtext">
  <table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse; " bordercolor="#111111" width="100%"
id="AutoNumber7" class="smtext">
    <tr>

<b>

      <td width="15%" style="border-style: none; border-width: medium"
align="right">
      <font face="Arial"><b>School:</b></font></td>
      <td width="85%" style="border-style: none; border-width: medium">
      <!--webbot bot="Validation" b-value-required="TRUE" --><select
size="1" name="School" class="smtext">
      <option selected value=".">.</option>
      <option>Goddard</option>
      <option>Roswell</option>
      <option>Berrendo</option>
      <option>Mesa</option>
      <option>Mt. View</option>
      <option>Sierra</option>
      </select></td>
</b>

    </tr>
    <tr>

<b>

      <td width="15%" style="border-style: none; border-width: medium"
align="right">
      <font face="Arial"><b>Sport:</b></font></td>
      <td width="85%" style="border-style: none; border-width: medium">
      <!--webbot bot="Validation" b-value-required="TRUE" --><select
size="1" name="Sport" class="smtext">
      <option selected>.</option>
      <option>Boys & Girls Track</option>
      <option>Girls Golf</option>
      <option>Boys Golf</option>
      <option>Boys & Girls Golf</option>
      <option>Boys Soccer</option>
      <option>Girls Soccer</option>
      <option>Boys & Girls Tennis</option>
      <option>Baseball</option>
      <option>Softball</option>
      </select></td>
</b>

    </tr>
    <tr>

<b>

      <td width="50%" style="border-style: none; border-width: medium"
align="right">
      <font face="Arial"><b>Level:</b></font></td>
      <td width="85%" style="border-style: none; border-width: medium">
      <!--webbot bot="Validation" b-value-required="TRUE" --><select
size="1" name="Level" class="smtext">
      <option selected value=".">.</option>
      <option>JV</option>
      <option>Midschool</option>
      <option>Soph</option>
      <option>Varsity</option>
      <option>Freshman</option>
      </select></td>
</b>

    </tr>
  </table>
  <p class="smtext"><input TYPE="submit" class="smtext"><input
TYPE="reset" class="smtext"><!--webbot bot="SaveAsASP" clientside
suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP"
endspan --></p>
</form>

</center>


<b>

<table width="100%" border="0" class="smtext" style="border-collapse:
collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
  <thead>
    <tr>
      <td bgcolor="#2387C2"><font
color="#FFFFFF"><b>Date</b></font></td>
      <td bgcolor="#2387C2"><font
color="#FFFFFF"><b>Sport</b></font></td>
      <td bgcolor="#2387C2"><font
color="#FFFFFF"><b>School</b></font></td>
      <td bgcolor="#2387C2"><font
color="#FFFFFF"><b>Level</b></font></td>
      <td bgcolor="#2387C2"><font
color="#FFFFFF"><b>Opponent/Description</b></font></td>
      <td bgcolor="#2387C2"><font
color="#FFFFFF"><b>Time</b></font></td>
      <td bgcolor="#2387C2"><font
color="#FFFFFF"><b>Site</b></font></td>
    </tr>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-columntypes="135,202,202,202,202,202,202,202,11"
s-dataconnection="spring2003" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Schedule"
s-displaycolumns="Date,Sport,School,Level,Opponent/Description,Time,Site
" s-criteria="[Sport] EQ {Sport} + [School] EQ {School} + [Level] EQ
{Level} +" s-order s-sql="SELECT * FROM Schedule WHERE (Sport =
'::Sport::' AND School =  '::School::' AND Level =  '::Level::')"
b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Sport=&amp;School=&amp;Level=" s-norecordsfound="No
records returned." i-maxrecords="0" i-groupsize="0" botid="0"
u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region. The page must be fetched from a web server with a web browser to
display correctly; the current web is stored on your local disk or
network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Schedule WHERE (Sport =  '::Sport::' AND School =
'::School::' AND Level =  '::Level::')"
fp_sDefault="Sport=&School=&Level="
fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="spring2003"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan --><tr>
      <td>
      <!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-column="Date" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Date&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Date")%><!--webbot bot="DatabaseResultColumn"
endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-column="Sport" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Sport&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Sport")%><!--webbot bot="DatabaseResultColumn"
endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-column="School" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;School&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"School")%><!--webbot bot="DatabaseResultColumn"
endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-column="Level" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Level&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Level")%><!--webbot bot="DatabaseResultColumn"
endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-column="Opponent/Description" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Opponent/Description
&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Opponent/Description")%><!--webbot
bot="DatabaseResultColumn" endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-column="Time" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Time&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Time")%><!--webbot bot="DatabaseResultColumn"
endspan --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Sport,School,Level,-,Opponent/Description,Time,Site,
Local" s-column="Site" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Site&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Site")%><!--webbot bot="DatabaseResultColumn"
endspan --></td>
    </tr>
    <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;
width=&quot;100%&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;" startspan --><!--#include
file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan --></tbody>
</table>



-----Original Message-----
From: owner-hwg-techniques(at)hwg.org [mailto:owner-hwg-techniques(at)hwg.org]
On Behalf Of Juliana Halvorson
Sent: Thursday, April 17, 2003 12:47 PM
Cc: hwg-techniques(at)hwg.org
Subject: ASP Problem


I have created an ASP page that links to a database at
http://www.risd.k12.nm.us/athletics/2003springsearch.asp

I am having a problem that is new to me as I have created several of
these pages before and they worked fine.  The page works wonderfully
when I run it from my local server. The searches come up will all the
correct information.  But when I post it to the remote server, no
results are posted.  The information is coming from the same database as
the master list link on the page and the database is verified in
Frontpage so I really don't understand the problem - especially since it
works on my server.

Does anyone have any suggestions?

Thanks so much!
Juliana

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA