Selective Database Results hurdle

[Guest]

Helllo
I have a submittal form with a drop down fields box and a text box
That drop down box is called Neighborhoods and the users selects from a list of towns displayed within the drop down selection, the text box is a description of the town that the users writes about when filling out the form.

I set up my results page via wizard to displays the results that the users have selected and written about from the submittal form, so the results page shows the entire database contents with each record consisting of the users selected townS and accompanying text box written contents

What I’d like to do is create another results page that singles out the database records from just one town and its accompanying text box written description.

I’ve been reading a lot about databases and such and can’t figure out how to achieve this task
If I was to guess, I might think it had something to do with the Criteria, valves, value. I just don’t know it’s not making sense to me

I am very new to FrontPage and amassed that I have gotten this far so fast with the limited time I have to work on my site
Hope this makes sense and you can help me get over this last huge hurdle.
thank
robert

 

[Jim Buyens]

Howdy.

In your first DRW page, on page 2 of the wizard, you need
to click Custom Query and Edit. This should expose a SQL
statement that begins

SELECT * FROM ...

change this to

SELECT '<a href="secondpg.asp?town=' & [townid] & '">' &
[townname] & '</a>' as linkfield, *, FROM ...

where secondpg.asp is the URL of the second DRW page,
townid is the database field that identifies each town
record, and townname is the database field for the town
name.

After the wizard completes, you'll also need to right-
click the linkfield field, select Database Column Value
Properties, and check Column value contains HTML.

Then, in the DRW on the secondpg.asp page (or whatever)
advance to page three of the wizard, then click More
Options, Criteria, Add. Set

Field Name: townid
Comparison: equals
Value: town
Use This Search Form Field: checked.

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

-----Original Message-----
Helllo,
I have a submittal form with a drop down fields box and a text box.
That drop down box is called Neighborhoods and the users

selects from a list of towns displayed within the drop
down selection, the text box is a description of the town
that the users writes about when filling out the form.

I set up my results page via wizard to displays the

results that the users have selected and written about
from the submittal form, so the results page shows the
entire database contents with each record consisting of
the users selected townS and accompanying text box
written contents.

What Iâ?Td like to do is create another results page

that singles out the database records from just one town
and its accompanying text box written description.

Iâ?Tve been reading a lot about databases and such and

canâ?Tt figure out how to achieve this task.

If I was to guess, I might think it had something to do

with the Criteria, valves, value. I just donâ?Tt know
itâ?Ts not making sense to me.

I am very new to FrontPage and amassed that I have

gotten this far so fast with the limited time I have to
work on my site.

 

[Thomas A. Rowe]

The best solution is to assign IDs to the city, etc. then use those IDs for look up. Do not use the
autonumber field if you want to relate records between tables..

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Hello,
Thanks for your response, most of my pages are working well!
I am having trouble retreiving records from the valves that have spaces and commas. I will have to change my form.
Thank you for your help,
Aloha
Robert

----- Jim Buyens wrote: -----

Howdy.

In your first DRW page, on page 2 of the wizard, you need
to click Custom Query and Edit. This should expose a SQL
statement that begins

SELECT * FROM ...

change this to

SELECT '<a href="secondpg.asp?town=' & [townid] & '">' &
[townname] & '</a>' as linkfield, *, FROM ...

where secondpg.asp is the URL of the second DRW page,
townid is the database field that identifies each town
record, and townname is the database field for the town
name.

After the wizard completes, you'll also need to right-
click the linkfield field, select Database Column Value
Properties, and check Column value contains HTML.

Then, in the DRW on the secondpg.asp page (or whatever)
advance to page three of the wizard, then click More
Options, Criteria, Add. Set

Field Name: townid
Comparison: equals
Value: town
Use This Search Form Field: checked.

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

-----Original Message-----
Helllo,
I have a submittal form with a drop down fields box and a text box.
That drop down box is called Neighborhoods and the users

selects from a list of towns displayed within the drop
down selection, the text box is a description of the town
that the users writes about when filling out the form.results that the users have selected and written about
from the submittal form, so the results page shows the
entire database contents with each record consisting of
the users selected townS and accompanying text box
written contents.that singles out the database records from just one town
and its accompanying text box written description.canâ?Tt figure out how to achieve this task.

If I was to guess, I might think it had something to do

with the Criteria, valves, value. I just donâ?Tt know
itâ?Ts not making sense to me.gotten this far so fast with the limited time I have to
work on my site.

Hope this makes sense and you can help me get over this last huge hurdle.
thanks
robert
.

 

[Guest]

Hello Thomas
That sounds very interesting, I would like to pursue assigning ID numbers. Fortunately, my results page does not have tables and so, autonumber should be ok ?
My page is set up to list each record on separate lines. As you know, the towns are displayed within my dropdown submittal form and the values for that list currently contain spaces and commas. So what your saying is that I can keep my value with spaces and commas and somehow include an ID within the value and have the DBW retrieve the id number for my desired value, can that ID number be hidden? This sounds great; unfortunately I don’t know where to begin and how to do it
If possible, I would appreciate your help achieving this goal
Aloh
Rober


----- Thomas A. Rowe wrote: ----

The best solution is to assign IDs to the city, etc. then use those IDs for look up. Do not use th
autonumber field if you want to relate records between tables.

--
=============================================
Thomas A. Rowe (Microsoft MVP - FrontPage
WEBMASTER Resources(tm
http://www.ycoln-resources.co
FrontPage Resources, WebCircle, MS KB Quick Links, etc
=============================================
To assist you in getting the best answers for FrontPage support see
http://www.net-sites.com/sitebuilder/newsgroups.as

Hello
Thanks for your response, most of my pages are working well
I am having trouble retreiving records from the valves that have spaces and commas. I will hav to change my form
Thank you for your help
Aloh
Rober

----- Jim Buyens wrote: ----
Howdy
In your first DRW page, on page 2 of the wizard, you nee

to click Custom Query and Edit. This should expose a SQ
statement that begin

SELECT * FROM ..
change this t
SELECT '<a href="secondpg.asp?town=' & [townid] & '">' &> [townname] & '</a>' as linkfield, *, FROM ..
where secondpg.asp is the URL of the second DRW page

townid is the database field that identifies each tow
record, and townname is the database field for the tow
name

After the wizard completes, you'll also need to right

click the linkfield field, select Database Column Valu
Properties, and check Column value contains HTML

Then, in the DRW on the secondpg.asp page (or whatever

advance to page three of the wizard, then click Mor
Options, Criteria, Add. Se

Field Name: towni

Comparison: equal
Value: tow
Use This Search Form Field: checked

Jim Buyen

Microsoft FrontPage MV
http://www.interlacken.co
Author of
*---------------------------------------------------
|\--------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Ou
||--------------------------------------------------
|| Web Database Development Step by Step .NET Editio
|| Microsoft FrontPage Version 2002 Inside Ou
|| Faster Smarter Beginning Programmin
|| (All from Microsoft Press
|/--------------------------------------------------
*---------------------------------------------------

Helllo
I have a submittal form with a drop down fields box an a text box
That drop down box is called Neighborhoods and the user

selects from a list of towns displayed within the dro
down selection, the text box is a description of the tow
that the users writes about when filling out the formresults that the users have selected and written about
from the submittal form, so the results page shows the
entire database contents with each record consisting of
the users selected townS and accompanying text box
written contents.that singles out the database records from just one town
and its accompanying text box written description.canâ?Tt figure out how to achieve this task.

If I was to guess, I might think it had something to do

with the Criteria, valves, value. I just donâ?Tt know
itâ?Ts not making sense to me.gotten this far so fast with the limited time I have to
work on my site.

Hope this makes sense and you can help me get over this last huge hurdle.
thanks
robert
.

 

[Thomas A. Rowe]

Robert,

I would still avoid using the AutoNumber field type for this, however don't remove it from your
table. Add a new Text field, called CityID, 6 character, and then assign number, for example, 100001
to 100300, etc.

Then when you create your dropdown it would need to be set up like:

<select size="1" name="CityID">
<option value="100001">ALGONA</option>
<option value="100002">ALTA</option>
<option value="100003">ALTON</option>

Then on the page where you want to display the details you would create your query similar to the
following:

sql = "Select * FROM tablename WHERE CityID = '" & Request.Form("CityID") & "' "

Note: I do not work with the FP database components, I write all of my ASP code by hand, so if you
need help on do this with FP database component, post back here for help and either Kathleen or
someone else that use the FP database component can help you.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Hello Thomas,
That sounds very interesting, I would like to pursue assigning ID numbers. Fortunately, my

results page does not have tables and so, autonumber should be ok ?

My page is set up to list each record on separate lines. As you know, the towns are displayed

within my dropdown submittal form and the values for that list currently contain spaces and commas.
So what your saying is that I can keep my value with spaces and commas and somehow include an ID
within the value and have the DBW retrieve the id number for my desired value, can that ID number be
hidden? This sounds great; unfortunately I don't know where to begin and how to do it.

If possible, I would appreciate your help achieving this goal.
Aloha
Robert


----- Thomas A. Rowe wrote: -----

The best solution is to assign IDs to the city, etc. then use those IDs for look up. Do not use the
autonumber field if you want to relate records between tables..

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Hello,
Thanks for your response, most of my pages are working well!
I am having trouble retreiving records from the valves that have spaces and commas. I will

have
to change my form.

Thank you for your help,
Aloha
Robert

----- Jim Buyens wrote: -----
Howdy.
In your first DRW page, on page 2 of the wizard, you need

to click Custom Query and Edit. This should expose a SQL
statement that begins

SELECT * FROM ...
change this to
SELECT '<a href="secondpg.asp?town=' & [townid] & '">' &> [townname] & '</a>' as linkfield, *, FROM ...
where secondpg.asp is the URL of the second DRW page,

townid is the database field that identifies each town
record, and townname is the database field for the town
name.

After the wizard completes, you'll also need to right-

click the linkfield field, select Database Column Value
Properties, and check Column value contains HTML.

Then, in the DRW on the secondpg.asp page (or whatever)

advance to page three of the wizard, then click More
Options, Criteria, Add. Set

Field Name: townid

Comparison: equals
Value: town
Use This Search Form Field: checked.

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

-----Original Message-----
Helllo,
I have a submittal form with a drop down fields box and a text box.
That drop down box is called Neighborhoods and the users

selects from a list of towns displayed within the drop
down selection, the text box is a description of the town
that the users writes about when filling out the form.

I set up my results page via wizard to displays the

results that the users have selected and written about
from the submittal form, so the results page shows the
entire database contents with each record consisting of
the users selected townS and accompanying text box
written contents.

What Iâ?Td like to do is create another results page

that singles out the database records from just one town
and its accompanying text box written description.

Iâ?Tve been reading a lot about databases and such and

canâ?Tt figure out how to achieve this task.

If I was to guess, I might think it had something to do

with the Criteria, valves, value. I just donâ?Tt know
itâ?Ts not making sense to me.

I am very new to FrontPage and amassed that I have

gotten this far so fast with the limited time I have to
work on my site.

Hope this makes sense and you can help me get over this last huge hurdle.
thanks
robert
.