|
pipwax -> RE: Database Pages (8/3/2004 20:42:58)
|
<html>
<head>
<meta name="Keywords" content="Ruff Ryders,skating Club, skating, roller skating, artistic skating, Atlanta, Atlanta Ga,skate jams,roller,membership,jamz,skate,ruff ryders skating club,Parties">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<title>Events</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="luminosity 010, default">
</head>
<body marginheight=0 marginwidth=0 topmargin=0 leftmargin=0 rightmargin=0>
<!--webbot bot="Include" U-Include="_includes/Default.htm" TAG="BODY" --><table border="0" cellpadding="0" cellspacing="0" width="750">
<tr>
<td width="149" valign="top" bgcolor="#000000"><p>
<!--webbot
bot="Navigation" S-Type="top" S-Orientation="vertical"
S-Rendering="graphics" B-Include-Home="FALSE" B-Include-Up="FALSE"
U-Page S-Target --></p>
</td>
<td width="23" valign="top" background="images/leftcellbg.gif">
<img border="0" src="images/leftcellbg.gif"></td>
<td width="412" valign="top" bgcolor="#2F0131"><b>
<!--webbot
bot="Navigation" S-Type="banner" S-Rendering="text" S-Orientation
B-Include-Home B-Include-Up U-Page S-Target -->
</b>
<br>
<form BOTID="0" METHOD="POST" ACTION="events.asp">
<table BORDER="0">
<tr>
<td><b>Event name</b></td>
<td>
<input TYPE="TEXT" NAME="event_name" VALUE="<%=Request("event_name")%>" size="20"></td>
</tr>
<tr>
<td><b>Host</b></td>
<td>
<input TYPE="TEXT" NAME="Host" VALUE="<%=Request("Host")%>" size="20"></td>
</tr>
<tr>
<td><b>Date</b></td>
<td><input NAME="Date" VALUE="<%=Request("Date")%>" size="20"></td>
</tr>
<tr>
<td><b>Time</b></td>
<td>
<input TYPE="TEXT" NAME="Time" VALUE="<%=Request("Time")%>" size="20"></td>
</tr>
<tr>
<td><b>Event details</b></td>
<td>
<input TYPE="TEXT" NAME="event_details" VALUE="<%=Request("event_details")%>" size="20"></td>
</tr>
<tr>
<td><input TYPE="submit" value="Search"></td>
<td><input TYPE="Reset"></td>
</tr>
</table>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>event_name</b></td>
<td><b>Host</b></td>
<td><b>Date</b></td>
<td><b>Time</b></td>
<td><b>event_details</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,event_name,Host,Date,Time,event_details,Remote_computer_name,User_name,Browser_type,Timestamp,event_detals" s-columntypes="3,202,202,202,202,203,202,202,202,135,202" s-dataconnection="event_submit" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="event_name" s-menuvalue="event_name" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="Results" s-displaycolumns="event_name,Host,Date,Time,event_details" s-criteria="[event_name] CNT {event_name} + [Host] CNT {Host} + [Date] EQ {Date} + [Time] EQ {Time} + [event_details] BEG {event_details} +" s-order s-sql="SELECT * FROM Results WHERE (event_name LIKE '%::event_name::%' AND Host LIKE '%::Host::%' AND Date = '::Date::' AND Time = '::Time::' AND event_details LIKE '::event_details::%')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="event_name=null&Host=&Date=&Time=&event_details=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr>" b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE (event_name LIKE '%::event_name::%' AND Host LIKE '%::Host::%' AND Date = '::Date::' AND Time = '::Time::' AND event_details LIKE '::event_details::%')"
fp_sDefault="event_name=null&Host=&Date=&Time=&event_details="
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="event_submit"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="event_name"
fp_sMenuValue="event_name"
fp_iDisplayCols=5
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="57446" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,event_name,Host,Date,Time,event_details,Remote_computer_name,User_name,Browser_type,Timestamp,event_detals" s-column="event_name" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>event_name<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"event_name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31782" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,event_name,Host,Date,Time,event_details,Remote_computer_name,User_name,Browser_type,Timestamp,event_detals" s-column="Host" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Host<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Host")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="5344" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,event_name,Host,Date,Time,event_details,Remote_computer_name,User_name,Browser_type,Timestamp,event_detals" s-column="Date" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Date<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Date")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3267" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,event_name,Host,Date,Time,event_details,Remote_computer_name,User_name,Browser_type,Timestamp,event_detals" s-column="Time" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Time<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Time")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="5308" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,event_name,Host,Date,Time,event_details,Remote_computer_name,User_name,Browser_type,Timestamp,event_detals" s-column="event_details" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>event_details<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"event_details")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="37787" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>
<p><b><a href="event_submit.htm">Submit Your event</a></b></td>
<td width="21" valign="top" background="images/rightcellbg.gif">
<img border="0" src="images/rightcellbg.gif"></td>
<td width="145" valign="top" bgcolor="#000000">
<img border="0" src="images/rightcellspace.gif"><br>
<!--webbot bot="Include" U-Include="_includes/whatsnew.htm" TAG="BODY"
--> </td>
</tr>
<tr>
<td width="149" valign="top" bgcolor="#000000"> </td>
<td width="23" valign="top" background="images/leftcellbg.gif"> </td>
<td width="412" valign="top" bgcolor="#2F0131"> </td>
<td width="21" valign="top" background="images/rightcellbg.gif"> </td>
<td width="145" valign="top" bgcolor="#000000"> </td>
</tr>
</table>
<!--webbot bot="Include" U-Include="_includes/foot.htm" TAG="BODY" --> </body>
</html>
|
|
|
|
