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

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_tut..._ng/index.html





robert <(E-Mail Removed)> wrote:
> 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

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â?
¦.
>Thanks 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" wrote:

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

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


"Kathleen Anderson [MVP - FP]" wrote:

> 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_tut..._ng/index.html
>
>
>
>
>
> robert <(E-Mail Removed)> wrote:
> > 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
>
>

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_tut..._ng/index.html





robert <(E-Mail Removed)> wrote:
> 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
>
>
> "Kathleen Anderson [MVP - FP]" wrote:
>
>> 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_tut..._ng/index.html
>>
>>
>>
>>
>>
>> robert <(E-Mail Removed)> wrote:
>>> 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

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.mygayneighborhoodclassifi...llectibles.asp
this site only works on a PC with IE
Thanks
Robert

"Kathleen Anderson [MVP - FP]" wrote:

> 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_tut..._ng/index.html
>
>
>
>
>
> robert <(E-Mail Removed)> wrote:
> > 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
> >
> >
> > "Kathleen Anderson [MVP - FP]" wrote:
> >
> >> 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_tut..._ng/index.html
> >>
> >>
> >>
> >>
> >>
> >> robert <(E-Mail Removed)> wrote:
> >>> 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
>
>

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_tut..._ng/index.html





robert <(E-Mail Removed)> wrote:
> 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.mygayneighborhoodclassifi...llectibles.asp
> this site only works on a PC with IE
> Thanks
> Robert
>
> "Kathleen Anderson [MVP - FP]" wrote:
>
>> 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_tut..._ng/index.html
>>
>>
>>
>>
>>
>> robert <(E-Mail Removed)> wrote:
>>> 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
>>>
>>>
>>> "Kathleen Anderson [MVP - FP]" wrote:
>>>
>>>> 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_tut..._ng/index.html
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> robert <(E-Mail Removed)> wrote:
>>>>> 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

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

"Kathleen Anderson [MVP - FP]" wrote:

> 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_tut..._ng/index.html
>
>
>
>
>
> robert <(E-Mail Removed)> wrote:
> > 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.mygayneighborhoodclassifi...llectibles.asp
> > this site only works on a PC with IE
> > Thanks
> > Robert
> >
> > "Kathleen Anderson [MVP - FP]" wrote:
> >
> >> 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_tut..._ng/index.html
> >>
> >>
> >>
> >>
> >>
> >> robert <(E-Mail Removed)> wrote:
> >>> 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
> >>>
> >>>
> >>> "Kathleen Anderson [MVP - FP]" wrote:
> >>>
> >>>> 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_tut..._ng/index.html
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> robert <(E-Mail Removed)> wrote:
> >>>>> 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
>
>

The first must be EQUAL and the second must be AND

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
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

"robert" <(E-Mail Removed)> wrote in message
news:A6E1772D-2E05-4C77-B8F1-(E-Mail Removed)...
> I changed them all to "And" and now I get "no records returned"
>
> "Kathleen Anderson [MVP - FP]" wrote:
>
> > 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_tut..._ng/index.html
> >
> >
> >
> >
> >
> > robert <(E-Mail Removed)> wrote:
> > > 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.mygayneighborhoodclassifi...llectibles.asp
> > > this site only works on a PC with IE
> > > Thanks
> > > Robert
> > >
> > > "Kathleen Anderson [MVP - FP]" wrote:
> > >
> > >> 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_tut..._ng/index.html
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> robert <(E-Mail Removed)> wrote:
> > >>> 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
> > >>>
> > >>>
> > >>> "Kathleen Anderson [MVP - FP]" wrote:
> > >>>
> > >>>> 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_tut..._ng/index.html
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>> robert <(E-Mail Removed)> wrote:
> > >>>>> 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
> >
> >