Help With Feedback Page

[Rob]

I have a page
http://www.rollingbluethunder.com/Feedback2.asp

The shows the results from a table in a database. My problem is this table
is not set as a mandatory field.

What I need to know is if there is a way I can set it up so that if there is
no answer, it does not show up as a blank space on the results page?

Hope this question makes sense.

 

[Jim Buyens]

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

I have a page
http://www.rollingbluethunder.com/Feedback2.asp

The shows the results from a table in a database. My
problem is this table is not set as a mandatory field.

What I need to know is if there is a way I can set it up
so that if there is no answer, it does not show up as a
blank space on the results page?

This page processes results from a form, and not results
from a database table. But I guess you want to stop
visitors from submitting form fields if some fields are
empty. To do this:

1. In FrontPage, right-click the text box that
should never be blank, and choose Form Field
Properties.
2. When the Text Box Properties dialog box appears,
click the Validate button.
3. When the Text Box Validation dialog box appears,
look for the Data Length section and then click
Required.
4. Click OK and OK.
5. Save the page and test.

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

 

[Rob]

Actually I don't care if they pur a response in the box or not. What I want
to happen is if there is no response, it does not show a blank space on the
page.

If you scroll down the page you will see where some folks made comments and
other pages where they didn't, but there is still a space where the comment
would have been had one ben made.

 

[Kathleen Anderson [MVP - FP]]

Rob:
You can wrap the field in some script that will only display the field if
it's not empty:

<% If fp_rs("comment") > " " then %>
webbot stuff goes here
<% End If %>

 

[Jim Buyens]

Actually I don't care if they pur a response in the box or not. What I want
to happen is if there is no response, it does not show a blank space on the
page.

If you scroll down the page you will see where some folks made comments and
other pages where they didn't, but there is still a space where the comment
would have been had one ben made.

If you configured FrontPage to append each comment to this Web page,
they you're going to get *every* comment, blank or not.

To be more selective, you'd have to add the comments to a database,
and they use the Database Results Wizard to display them. That way,
you can set criteria to bypass blank records.

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