Query results

[L]

Is it possible to use "OR" with the database query results? For example, if I
select Elementary schools. How can I display records that have Elementary
schools and Middle schools without having middle schools as an option.

 

[L]

Basically instead of using the "If No Records are returned" option, to always
display a particular record.

 

[Jens Peter Karlsen[FP MVP]]

It is possible. But you must write the necessary ASP yourself. FP has no
way to know that you want to find a middle school if no elementary
schools are returned.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[L]

What about this, instead of using the "If No Records are returned" option,
is there a way to display a particular record if no records match the user
option.

It is possible. But you must write the necessary ASP yourself. FP has no
way to know that you want to find a middle school if no elementary
schools are returned.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: L [mailto:[email protected]]
Posted At: 2. marts 2005 15:57
Posted To: microsoft.public.frontpage.programming
Conversation: Query results
Subject: Query results


Is it possible to use "OR" with the database query results?
For example, if I select Elementary schools. How can I
display records that have Elementary schools and Middle
schools without having middle schools as an option

 

[L]

What about this, instead of using the "No records returned" option, to
display a particular record if the user option doesn't match a record in the
database.

It is possible. But you must write the necessary ASP yourself. FP has no
way to know that you want to find a middle school if no elementary
schools are returned.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: L [mailto:[email protected]]
Posted At: 2. marts 2005 15:57
Posted To: microsoft.public.frontpage.programming
Conversation: Query results
Subject: Query results


Is it possible to use "OR" with the database query results?
For example, if I select Elementary schools. How can I
display records that have Elementary schools and Middle
schools without having middle schools as an option

 

[Kathleen Anderson [MVP - FrontPage]]

I know that it's possible to modify the look (font, text color, etc.) of the
"No records returned" message generated by the DRW; maybe you could modify
it to include a link to the record you want displayed, or a link to another
web page.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

What about this, instead of using the "If No Records are returned" option,
is there a way to display a particular record if no records match the user
option.

It is possible. But you must write the necessary ASP yourself. FP has no
way to know that you want to find a middle school if no elementary
schools are returned.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: L [mailto:[email protected]]
Posted At: 2. marts 2005 15:57
Posted To: microsoft.public.frontpage.programming
Conversation: Query results
Subject: Query results


Is it possible to use "OR" with the database query results?
For example, if I select Elementary schools. How can I
display records that have Elementary schools and Middle
schools without having middle schools as an option

 

[Jens Peter Karlsen[FP MVP]]

Like Kathleen wrote, you may be able to exchange the message for an URL,
but to use it to trigger a new search is impossible.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: L [mailto:[email protected]]
Posted At: 2. marts 2005 22:39
Posted To: microsoft.public.frontpage.programming
Conversation: Query results
Subject: Re: Query results


What about this, instead of using the "No records returned"
option, to display a particular record if the user option
doesn't match a record in the database.

It is possible. But you must write the necessary ASP yourself. FP has
no way to know that you want to find a middle school if no elementary
schools are returned.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: L [mailto:[email protected]]
Posted At: 2. marts 2005 15:57
Posted To: microsoft.public.frontpage.programming
Conversation: Query results
Subject: Query results


Is it possible to use "OR" with the database query results?
For example, if I select Elementary schools. How can I display
records that have Elementary schools and Middle schools without
having middle schools as an option