|
| |
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
 |
Database Pages - 7/26/2004 17:52:16
Can anyone suggest a good site for learning to create database web pages using frontpage. I want to create a database of events and then make a page that viewers can come and search for the event they want to attend
|
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/26/2004 17:56:33
I would start here:
http://www.outfront.net/spooky/index.htm
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/26/2004 18:33:31
Thanks It is helpful already
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/26/2004 19:46:47
According to the error message, there is no table titled "events"
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/26/2004 20:16:57
so how would I create a table, using access? I created my database using Access and I know I little bit about this but I am not sure about the table that you speak of, hum.
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/26/2004 20:39:09
What are you hoping to do on the page events2.asp? Submit a new event? If so, you need to right-click your form and choose submit to database. Then either select a current database table to submit to or allow frontpage to create a database for you.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/26/2004 20:49:36
show a list of all available events.
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/26/2004 21:02:46
So is the form supposed to be a search form?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/27/2004 0:31:10
yes it is, I guess that helps
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/27/2004 8:41:34
OK, so what database table are you trying to search?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/27/2004 10:11:22
events, so let me ask you this when I create my database in Access in design view and I save it do I need to save it as a table or ?
what I am trying to do is create a page that will allow a user to visit the site and search for an event instead of looking through all events on a static page. Then I need to create a page that will allow me the administrators to update the database.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/27/2004 10:13:43
thanks for working with me, I know a lot of people will not do this thanks a lot. I have been doing page in HTML for sometime next but I am trying to get to the next level.
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/27/2004 11:09:07
What may be easiest is this. Create an HTML form for entering events. Be sure to include all the fields you want to display. When finished, right-click the form and choose "Form Properties. Then mark the "Send to Database" option. Then click the "Options" button. Then click the "Create Database" button. Frontpage will then create your db for you as well as the table and necessary database connection that you can then use to create results pages. Give it a whirl.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/27/2004 12:42:58
Thanks and I will at that, you have a good day and I will be in touch.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/27/2004 21:03:03
Ok That work, Thanks a Million. Now if you have any tips I should consider when making my search page I would be greatful, Thanks.
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/27/2004 22:28:10
Now you should be able to use the database results wizard to create a results page with whatever search criteria you want. Open a new page and choose Insert - Database - Results. Then in step one, choose the connection to your the db you just created. In step 2, choose the table you wish to query. It is probably named "Results". Then in step 3, choose all the fields you want displayed in your results. Then click "More Options" and then "Criteria" followed by "Add". Then choose a field you wish to search by. You can add others or just stick with one. Then click "OK" until you get to Step 4. In Step 4, choose how you want your records displayed. Then, in Step 5, specify whether to show all records on one page or limit the number to be shown and be sure to check the "Add Search Form" checkbox. That's it!
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/28/2004 5:46:09
thanks
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/28/2004 21:35:09
Well That went fine I have the query form set-up but I seems to not find the events In the database, do you have any suggestions on how I can fine tune everything.
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/28/2004 22:07:20
Open the page your results page, switch to HTML view and copy and paste the code here. It may be that your query is so restrictive that no results are returned. Can you post a link to the page?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/29/2004 5:24:20
sure I can
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 7/29/2004 6:30:23
well I have been testing this on my local server using IIS that may be why it did not work. and as far as the remote I am rebuilding it and I may have to empty the remote and load everything up again.
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 7/29/2004 10:47:50
How are you getting your web from your local server to the hosted site? Make sure you use the FP publish option and not FTP or the database connection will break. Also, once you publish, you may need to open the published site in FP and verify the connection. This is done by choosing, Tools - Web Settings - Database. Then single click your connection and then the "Verify" button.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 8/3/2004 16:48:20
And if this won't work what would you suggest/
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 8/3/2004 17:01:48
I would suggest getting your site published to the server. Then, if problems arise, post a description of the problem here and we'll be able to help you remedy them. Whatever error message you get, I am sure somebody here has seen it. Keep in mind that your asp pages will run best on a Windows server with ASP enabled. There are some Linux servers that will run FrontPage extensions, but IMHO you will have far less headaches on a Windows server.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 8/3/2004 20:01:02
Well there are no errors I just get no records returned
http://ruff-ryders.org/events.asp
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 8/3/2004 20:14:12
OK. Tell me some search criteria that should give me a result. Second, open the page events.asp, switch to HTML view, copy all of the code and paste it here so I can see it. That will help me see any potential problems.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
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>
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages (this should bring a result) - 8/3/2004 20:44:45
skate-A-Thon 2004 is almost here. Groups need to make preparations for one of the skating community's greatest skating events. John and Joi are working extra hard to provide for a great party, and will be making more Skate-A-Thon information available soon! But don't sit back, work on transportation now and plan ahead for September 3 - 6, 2004 , and make sure that you get to Atlanta's Hottest
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
