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
-----------------------------------------------------------------------
Posted via http://www.forum4designers.co
-----------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message33037.htm

>-----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
custom programming code needs to construct an <img> tag
that points to the picture file name in the database.

>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)
|/---------------------------------------------------
*----------------------------------------------------