Database Results Wizards, More Options, Criteria, Comparison.....

[robert]

Hello,
I am trying to retrieve records based on certain criteria and thought the Comparison selection might have something to do with it. There are many options to choose from unfortunately I do not know what these options mean and how to use them. I checked my book and the help menu, but I need more info. Does anybody know what these mean.. equals less than, not equal and so on….
Thanks robert

 

[Kathleen Anderson [MVP - FP]]

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

 

[Jim Buyens]

Howdy.

The DRW is going to create a SQL (Structured Query
Language) statement that tells the database what record
to select. When you run the DRW and specify criteria,
those criteria end up in that SQL statement.

So, if you want to select records where the database
field "city" equals "Boise" here's what you would specify
in the Criteria dialog box:

Use This Search
Field Comparison Value Form Field And/Or
----- ---------- ----- --------------- ------
city Equals Boise Cleared And

If you wanted record with a price greater than $10.00 you
would code:

Use This Search
Field Comparison Value Form Field And/Or
----- ------------ ----- --------------- ------
price Greater Than 10 Cleared And

The And/Or field applies only if you specify multiple
criteria, as shown below:

Use This Search
Field Comparison Value Form Field And/Or
----- ------------ ----- --------------- ------
state Equals AZ Cleared Or
state Equals CA Cleared Or

This selects records having a value of AZ or CA in
the "state" field.

If you select Use This Search Form Field, the Web page
will get the criteria value from an HTML form field. In
this example:

Use This Search
Field Comparison Value Form Field And/Or
-------- ------------ ----- --------------- ------
proddesc Contains pdesc Selected And

the Web Page will display all records whose product
description contains whatever text the Web visitor enters
in a text box named pdesc.

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-----
Hello,
I am trying to retrieve records based on certain

criteria and thought the Comparison selection might have
something to do with it. There are many options to
choose from unfortunately I do not know what these
options mean and how to use them. I checked my book and
the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so onâ?
¦.

 

[robert]

Hello,
Thanks for responding.
Yes, that is it,
Now what if I wanted all records greater than $10 and located in just Boise.
Or in my case, all antiques on just one specified island-Oahu?
Thanks
Robert

 

[robert]

Hello,
This is useful information, especially the second link, however I don't understand how to incorporate that information into my site and why it doesn’t create the formula the same way the DBW did or if it will work within DBW and how and how...oh god!! Lost here……………..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display only the results within the specified town ( I set that up via Field, Equal, Value “specified town†) That works great, it only calls up the records with the specified towns. Now I also wish to retrieve a category such as antiques, but only the antiques located in the above towns.
Is this even possible, if so, any idea where to begin and what to research?
Thanks
Exhausted

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Hello,
I am trying to retrieve records based on certain criteria and thought
the Comparison selection might have something to do with it. There
are many options to choose from unfortunately I do not know what
these options mean and how to use them. I checked my book and the
help menu, but I need more info. Does anybody know what these mean..
equals less than, not equal and so on…. Thanks robert

 

[Kathleen Anderson [MVP - FP]]

Using the "Add Criteria" dialog box, which is where you created the first
search criteria (town), you would click "Add" and then you can add more
search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site and
why it doesn’t create the formula the same way the DBW did or if it
will work within DBW and how and how...oh god!! Lost
here……………..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via Field,
Equal, Value “specified town†) That works great, it only calls
up the records with the specified towns. Now I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so on….
Thanks robert

 

[robert]

Yes, I used the "Add Criteria" box to add the selected towns to the search criteria.
and now i want to add a criteria to for "categories" value Antiques, I did that too. but now I only want the antiques records from the categories that are in the town search criteria.. I don’t think I can explain this in words
look here for a better understanding of what i want to do.
Note. on this page i only want to see Antiques ads from the Island of OHAU
http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp
this site only works on a PC with IE
Thanks
Robert

Using the "Add Criteria" dialog box, which is where you created the first
search criteria (town), you would click "Add" and then you can add more
search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site and
why it doesn’t create the formula the same way the DBW did or if it
will work within DBW and how and how...oh god!! Lost
here……………..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via Field,
Equal, Value “specified town†) That works great, it only calls
up the records with the specified towns. Now I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so on….
Thanks robert

 

[Kathleen Anderson [MVP - FP]]

You want to use the "And" option, so that you get a match only when the town
matches AND the category matches.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Yes, I used the "Add Criteria" box to add the selected towns to the
search criteria.
and now i want to add a criteria to for "categories" value Antiques,
I did that too. but now I only want the antiques records from the
categories that are in the town search criteria.. I don’t think I
can explain this in words look here for a better understanding of
what i want to do.
Note. on this page i only want to see Antiques ads from the Island of
OHAU
http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp
this site only works on a PC with IE
Thanks
Robert

Using the "Add Criteria" dialog box, which is where you created the
first search criteria (town), you would click "Add" and then you can
add more search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site
and
why it doesn’t create the formula the same way the DBW did
or if it will work within DBW and how and how...oh god!! Lost
here……………..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via
Field, Equal, Value “specified town†) That works
great, it only calls up the records with the specified towns. Now
I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted


:

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so
on…. Thanks robert

 

[robert]

I changed them all to "And" and now I get "no records returned"

You want to use the "And" option, so that you get a match only when the town
matches AND the category matches.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Yes, I used the "Add Criteria" box to add the selected towns to the
search criteria.
and now i want to add a criteria to for "categories" value Antiques,
I did that too. but now I only want the antiques records from the
categories that are in the town search criteria.. I don’t think I
can explain this in words look here for a better understanding of
what i want to do.
Note. on this page i only want to see Antiques ads from the Island of
OHAU
http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp
this site only works on a PC with IE
Thanks
Robert

Using the "Add Criteria" dialog box, which is where you created the
first search criteria (town), you would click "Add" and then you can
add more search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site
and
why it doesn’t create the formula the same way the DBW did
or if it will work within DBW and how and how...oh god!! Lost
here……………..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via
Field, Equal, Value “specified town†) That works
great, it only calls up the records with the specified towns. Now
I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted


:

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so
on…. Thanks robert

 

[Thomas A. Rowe]

The first must be EQUAL and the second must be AND

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

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

I changed them all to "And" and now I get "no records returned"

You want to use the "And" option, so that you get a match only when the town
matches AND the category matches.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

Yes, I used the "Add Criteria" box to add the selected towns to the
search criteria.
and now i want to add a criteria to for "categories" value Antiques,
I did that too. but now I only want the antiques records from the
categories that are in the town search criteria.. I donâ?Tt think I
can explain this in words look here for a better understanding of
what i want to do.
Note. on this page i only want to see Antiques ads from the Island of
OHAU

http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp

this site only works on a PC with IE
Thanks
Robert

:

Using the "Add Criteria" dialog box, which is where you created the
first search criteria (town), you would click "Add" and then you can
add more search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site
and
why it doesnââ,¬â"¢t create the formula the same way the DBW did
or if it will work within DBW and how and how...oh god!! Lost
hereââ,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via
Field, Equal, Value ââ,¬Å"specified townââ,¬Â ) That works
great, it only calls up the records with the specified towns. Now
I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted


:

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so
onÃf¢ââ?s¬Ã,¦. Thanks robert

 

[robert]

I've tried it many differant ways
My SQL statement currently shows like this:
SELECT * FROM Results WHERE (Neighborhood = 'OAHU_Central' OR Neighborhood = 'OAHU_Honolulu' OR Neighborhood = 'OAHU_Leeward' OR Neighborhood = 'OAHU_North_Shore' OR Neighborhood = 'OAHU_Southeast' OR Neighborhood = 'OAHU_Southwest' OR Neighborhood = 'OAHU_Windward' OR Category = 'Antiques/Collectibles')

I want the results page to retrieve the Antiques/Collectibles records from just the Island of Oahu towns, (no other island)
Is this as painful for you as it is for me....sorry
Mycomputer needs to go swimming in the pool.............

The first must be EQUAL and the second must be AND

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

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

I changed them all to "And" and now I get "no records returned"

You want to use the "And" option, so that you get a match only when the town
matches AND the category matches.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Yes, I used the "Add Criteria" box to add the selected towns to the
search criteria.
and now i want to add a criteria to for "categories" value Antiques,
I did that too. but now I only want the antiques records from the
categories that are in the town search criteria.. I donâ?Tt think I
can explain this in words look here for a better understanding of
what i want to do.
Note. on this page i only want to see Antiques ads from the Island of
OHAU

http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp
this site only works on a PC with IE
Thanks
Robert

:

Using the "Add Criteria" dialog box, which is where you created the
first search criteria (town), you would click "Add" and then you can
add more search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site
and
why it doesnââ,¬â"¢t create the formula the same way the DBW did
or if it will work within DBW and how and how...oh god!! Lost
hereââ,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via
Field, Equal, Value ââ,¬Å"specified townââ,¬Â ) That works
great, it only calls up the records with the specified towns. Now
I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted


:

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so
onÃf¢ââ?s¬Ã,¦. Thanks robert

 

[robert]

My SQL statement currently shows like this:
SELECT * FROM Results WHERE (Neighborhood = 'OAHU_Central' OR Neighborhood = 'OAHU_Honolulu' OR Neighborhood = 'OAHU_Leeward' OR Neighborhood = 'OAHU_North_Shore' OR Neighborhood = 'OAHU_Southeast' OR Neighborhood = 'OAHU_Southwest' OR Neighborhood = 'OAHU_Windward' OR Category = 'Antiques/Collectibles')

I want the results page to retrieve the Antiques/Collectibles records from just the Island of Oahu towns, (no other island)

The first must be EQUAL and the second must be AND

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

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

I changed them all to "And" and now I get "no records returned"

You want to use the "And" option, so that you get a match only when the town
matches AND the category matches.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Yes, I used the "Add Criteria" box to add the selected towns to the
search criteria.
and now i want to add a criteria to for "categories" value Antiques,
I did that too. but now I only want the antiques records from the
categories that are in the town search criteria.. I donâ?Tt think I
can explain this in words look here for a better understanding of
what i want to do.
Note. on this page i only want to see Antiques ads from the Island of
OHAU

http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp
this site only works on a PC with IE
Thanks
Robert

:

Using the "Add Criteria" dialog box, which is where you created the
first search criteria (town), you would click "Add" and then you can
add more search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site
and
why it doesnââ,¬â"¢t create the formula the same way the DBW did
or if it will work within DBW and how and how...oh god!! Lost
hereââ,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via
Field, Equal, Value ââ,¬Å"specified townââ,¬Â ) That works
great, it only calls up the records with the specified towns. Now
I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted


:

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so
onÃf¢ââ?s¬Ã,¦. Thanks robert

 

[Thomas A. Rowe]

Try:

Find = "OAHU"
Cat = "Antiques/Collectibles"

SELECT * FROM Results WHERE (Neighborhood LIKE '%" & Find & "%') AND Category = '" & Cat & "' ORDER
BY Neighborhood"

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

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

I've tried it many differant ways
My SQL statement currently shows like this:
SELECT * FROM Results WHERE (Neighborhood = 'OAHU_Central' OR Neighborhood = 'OAHU_Honolulu' OR

Neighborhood = 'OAHU_Leeward' OR Neighborhood = 'OAHU_North_Shore' OR Neighborhood =
'OAHU_Southeast' OR Neighborhood = 'OAHU_Southwest' OR Neighborhood = 'OAHU_Windward' OR Category
= 'Antiques/Collectibles')

I want the results page to retrieve the Antiques/Collectibles records from just the Island of Oahu towns, (no other island)
Is this as painful for you as it is for me....sorry
Mycomputer needs to go swimming in the pool.............

The first must be EQUAL and the second must be AND

--
==============================================
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

I changed them all to "And" and now I get "no records returned"

:

You want to use the "And" option, so that you get a match only when the town
matches AND the category matches.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Yes, I used the "Add Criteria" box to add the selected towns to the
search criteria.
and now i want to add a criteria to for "categories" value Antiques,
I did that too. but now I only want the antiques records from the
categories that are in the town search criteria.. I donâ?Tt think I
can explain this in words look here for a better understanding of
what i want to do.
Note. on this page i only want to see Antiques ads from the Island of
OHAU

http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp

this site only works on a PC with IE
Thanks
Robert

:

Using the "Add Criteria" dialog box, which is where you created the
first search criteria (town), you would click "Add" and then you can
add more search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site
and
why it doesnââ,¬â"¢t create the formula the same way the DBW did
or if it will work within DBW and how and how...oh god!! Lost
hereââ,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via
Field, Equal, Value ââ,¬Å"specified townââ,¬Â ) That works
great, it only calls up the records with the specified towns. Now
I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted


:

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so
onÃf¢ââ?s¬Ã,¦. Thanks robert

 

[robert]

Hello Thomas,
It's over..
Kathleen discovered the trick of using (( and ))
Perhaps someday i'll understand why, but it works, a liitle thing like ) can make the differance. i'm wiped out. I cant image tackling these problems like you all do. I would be insane.
Thanks
robert

Try:

Find = "OAHU"
Cat = "Antiques/Collectibles"

SELECT * FROM Results WHERE (Neighborhood LIKE '%" & Find & "%') AND Category = '" & Cat & "' ORDER
BY Neighborhood"

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

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

I've tried it many differant ways
My SQL statement currently shows like this:
SELECT * FROM Results WHERE (Neighborhood = 'OAHU_Central' OR Neighborhood = 'OAHU_Honolulu' OR

Neighborhood = 'OAHU_Leeward' OR Neighborhood = 'OAHU_North_Shore' OR Neighborhood =
'OAHU_Southeast' OR Neighborhood = 'OAHU_Southwest' OR Neighborhood = 'OAHU_Windward' OR Category
= 'Antiques/Collectibles')

I want the results page to retrieve the Antiques/Collectibles records from just the Island of Oahu towns, (no other island)
Is this as painful for you as it is for me....sorry
Mycomputer needs to go swimming in the pool.............

The first must be EQUAL and the second must be AND

--
==============================================
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

I changed them all to "And" and now I get "no records returned"

:

You want to use the "And" option, so that you get a match only when the town
matches AND the category matches.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Yes, I used the "Add Criteria" box to add the selected towns to the
search criteria.
and now i want to add a criteria to for "categories" value Antiques,
I did that too. but now I only want the antiques records from the
categories that are in the town search criteria.. I donâ?Tt think I
can explain this in words look here for a better understanding of
what i want to do.
Note. on this page i only want to see Antiques ads from the Island of
OHAU


http://www.mygayneighborhoodclassif...i-50/Islands/Oahu-56/antiquescollectibles.asp
this site only works on a PC with IE
Thanks
Robert

:

Using the "Add Criteria" dialog box, which is where you created the
first search criteria (town), you would click "Add" and then you can
add more search criteria to search other fields.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
This is useful information, especially the second link, however I
don't understand how to incorporate that information into my site
and
why it doesnââ,¬â"¢t create the formula the same way the DBW did
or if it will work within DBW and how and how...oh god!! Lost
hereââ,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦Ã¢â,¬Â¦..
All I want to do is retrieve fields within a certain town.
I have set up a separate asp page to retrieve records and display
only the results within the specified town ( I set that up via
Field, Equal, Value ââ,¬Å"specified townââ,¬Â ) That works
great, it only calls up the records with the specified towns. Now
I also wish to
retrieve a category such as antiques, but only the antiques located
in the above towns. Is this even possible, if so, any idea where to
begin and what to research?
Thanks
Exhausted


:

These links may help:

FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

SQL The WHERE Clause
http://www.w3schools.com/sql/sql_where.asp


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html





Hello,
I am trying to retrieve records based on certain criteria and
thought the Comparison selection might have something to do with
it. There are many options to choose from unfortunately I do not
know what these options mean and how to use them. I checked my
book and the help menu, but I need more info. Does anybody know
what these mean.. equals less than, not equal and so
onÃf¢ââ?s¬Ã,¦. Thanks robert

 

[Jim Buyens]

Hello,
Thanks for responding.
Yes, that is it,
Now what if I wanted all records greater than $10 and located in just Boise.

Use This Search
Field Comparison Value Form Field And/Or
----- ------------ ----- --------------- ------
price Greater Than 10 Cleared And
city Equals Boise Cleared And

Or in my case, all antiques on just one specified island-Oahu?

It's hard to be exact because I don't know the structure of your
database. However, assuming it also contains items other than
antiques:

Use This Search
Field Comparison Value Form Field And/Or
-------- ---------- ------- --------------- ------
category Equals Antique Cleared And
island Equals Oahu Cleared And

Thanks
Robert

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