Sign up page in Frontpage 2003

[LouisG]

I have a reunion page that i'm trying to set up a sort of sign in page that
will collect the data from the person signing up eg: email address , home
address/phone number etc. and then show the persons name and graduation
year on another page so that others can see who's coming.

Does anyone have any suggestions how to do this or where to get a template
to put this on my page?

I do have one set up so far , but don't know how to re-direct the
information to a database and then show the signee's names on another page.
This is the page i've got so far if anyone would care to see what i'm
trying to do ,, http://www.waporteralumni.com/alumni members.htm ,,

Thank you for your help.
Gord

 

[Andrew Murray]

To direct the form's data to a database, right click the form and go to
"Form Properties" then select "Send to Database" and follow the prompts and
screens that follow.

To display the data from the database, follow the tutorial at this site:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp. Also feel
free to ask more questions on this group about this as well.

Note these options require the Frontpage Server Extensions (check with your
host as to whether they support them) and the ability to use MS Access
databases. This would seem to be a standard thing these days. Also in the
majority, ASP requries a Windows Server.

If so, then it's an easy matter. If not, a third party solution would need
to be found, that is a server side script that will write the results to the
database, and display them on the web page.

This reply is being sent only to microsoft.public.frontpage.client only as
I"m not subscribed to the other groups you posted this message to.

 

[LouisG]

To direct the form's data to a database, right click the form and go
to "Form Properties" then select "Send to Database" and follow the
prompts and screens that follow.

To display the data from the database, follow the tutorial at this

I've tried the solution below ,, but it seems that maybe my host doesn't
support asp ,, do you have any idea as to the third party solution that i
might look into??

Thanks for all your help

 

[Ronx]

First check with your host that they support PHP and mySQL, or move to a
Windows server where asp, asp.NET and Access or MS SQL is supported.
You will need to write (at least) three pages:

1 - Registration page, similar to the page you already have. This will
update the database with the new users details. Add fields for a userId
and password.

2 - Login Page, where existing users can gain access to the third and
fourth page.

3 - Results page, which displays the other registrants details - you may
need to filter the results and provide details pages.

4 - A page where a registrant can change their own details.

You will also have to secure the database from unwanted interlopers, for
example by verifying email addresses before allowing access to the site
after completing the registration form.

For an ASP solution, requires a Windows server with support for asp and
Access, see the database results wizard (for 1 and 3), the Dataface
Interface Wizard for 4, and you might need:
Protect individual pages: (Requires Windows Server with support for
ASP and Access database)
http://support.microsoft.com/default.aspx?scid=kb;en-us;825498
for the login - though this is built into the Database Interface Wizard.

Try Googling for PHP Membership Database Template or ASP Membership
Database Template (depending on what your host supports)

 

[L Covey]

I have a reunion page that i'm trying to set up a sort of sign in page that
will collect the data from the person signing up eg: email address , home
address/phone number etc. and then show the persons name and graduation
year on another page so that others can see who's coming.

Does anyone have any suggestions how to do this or where to get a template
to put this on my page?

I do have one set up so far , but don't know how to re-direct the
information to a database and then show the signee's names on another page.
This is the page i've got so far if anyone would care to see what i'm
trying to do ,, http://www.waporteralumni.com/alumni members.htm ,,

Thank you for your help.
Gord

You might right click within the form. In the Form Properties dialog
box, you will see an option to redirect to a database.

I considered that, but thought it too big a chance for error.

You could just collect the information using an email address...that
option is located within the same form properties dialog box and
manually type it in a table on another page.

I understand that this is not what you originally wanted to do, but it
may save a lot of time.

May I suggest in your site that when you write text, that you NOT
capitalize every word? It is not very easy to read.
Example: "Here You Can Sign Up Along With Your Other Fellow Alumni And
Then Be Able To See..."

I take it that this reunion is for all school graduation years. About
how many people are you encompassing?

LC

 

[LouisG]

I've been able to get the form to email me finally , took some doing but
i've got it sending me what i need and then i manually add it to a mdb so
that i can forward it to the reunion committee.

I know what you mean about the capitalization , it looked better that way
to me from when i tried it without the capitalization , the non-capitals
looked really weird , i will put that option to the reunion committee to
see what they think.

We had a small get-together in 2004 and it drew around 800 people , with
this being the big 50 , we're expecting to see between 1000-1200 people.

The 2004 one was put together fast and wasn't held at the school or had a
pub nite beforehand , it was a one day event compared to three day this
time. We had people coming from Europe , Austrailia , Asia , and the U.S.
, this was held in Canada , so we're expecting many more than 04's
hastily put together bash.

 

[LouisG]

I contacted my web host , they are running Linux , so i guess the asp.net
is out.
Changing horses at this point , seeing that the site is paid through to
2009 is out of the question , i guess i'll have to rely on the results
being forwarded by email and manual input to the .mdb file and updates to
the site being done manually.

 

[L Covey]

I've been able to get the form to email me finally , took some doing but
i've got it sending me what i need and then i manually add it to a mdb so
that i can forward it to the reunion committee.

I know what you mean about the capitalization , it looked better that way
to me from when i tried it without the capitalization , the non-capitals
looked really weird , i will put that option to the reunion committee to
see what they think.

We had a small get-together in 2004 and it drew around 800 people , with
this being the big 50 , we're expecting to see between 1000-1200 people.

The 2004 one was put together fast and wasn't held at the school or had a
pub nite beforehand , it was a one day event compared to three day this
time. We had people coming from Europe , Austrailia , Asia , and the U.S.
, this was held in Canada , so we're expecting many more than 04's
hastily put together bash.

Glad you have made some progress.

As far as the capitalization goes...

If you choose to do so, at least don't capitilize "prepositions" (with,
on, to, etc.) and the word "and".

LC