Display visitors input to another page

[bighead]

Hi Everyone,

I am new in webdesign. I would like to know how to make the visitor
input to be displayed from another page: For example, there are 1
visitors inputed something throuh a form which connected to a MS SQ
database, alone with a picture. The form has a subject field, an
some other fields. After the visitors click Submitt botton,
hyperlinked with the Subject field should be displayed into anothe
page. All the hyperlinked Subject fileds (input by the ten visitors
should be appear in the same page. After that, when the visitor clic
one of the hyperlinked Subject fields, the entire fields and th
picture of that input should be displayed.

Great thanks in advance.

Bighea

bighea

 

[Jim Buyens]

-----Original Message-----

Hi Everyone,
Howdy.

I am new in webdesign. I would like to know how to make
the visitors input to be displayed from another page:
For example, there are 10 visitors inputed something
throuh a form which connected to a MS SQL database,
alone with a picture. The form has a subject field,
and some other fields.

FrontPage has built-in facilities to create database
records from HTML form submissions, and to store files
uploaded with an HTML form. Unfortunately, it can't do
both from the same form. So, you need to either:

o Use two forms, such as one to upload the picture
and a second to describe it.
o Custom program the page in ASP, ASP.NET, or some other
environment.

In all cases, you should plan on saving the picture as a
file, and storing only the picture file name in the
database.

After the visitors click Submitt botton, A hyperlinked
with the Subject field should be displayed into another
page.

The FrontPage Database Results Wizard can do this, or you
can program it in something ASP or ASP.NET.

To display the picture, either the database query or some

All the hyperlinked Subject fileds (input by the ten
visitors) should be appear in the same page.

I presume this is a different page. In any event, either
the database query or some custom programming code will
need to construct anchor tags such as:

<a href="detail.asp?photo=moneypit.jpg">Our New Home</a>

where the fiename moneypit.jpg and the Subject text Our
New Home come from the database record.

After that, when the visitor click one of the hyperlinked
Subject fields, the entire fields and the picture of that
input should be displayed.

You would have to arrange for the detail.asp page
(mentioned in the preceding URL) to run a query using the
photo= value as a criteria.

Again, either the database query or some custom
programming code will need to construct an <img> tag that
displays the photo named in the database record.

I hope this is enough to get you started. Given the
breadth of your question, a detail answer is really beyond
the scope of a newsgroup posting.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------