Database query is killing me!!

[SoccerBoy]

I am new to FP so please explain it as if I were 10.

My database has the following fields:
Name|Age|PhoneType|AreaCode|Prefix|Line|Email

I want to search the first record and display the Age only if the Name is
equal to Pete - then continue in the same record and display
AreaCode|Prefix|Line only if PhoneType is not equal to home - then continue
in the same record and display the Email only if the field is not empty.

I am only familiar with the database wizard and I have dabbled with the
Criteria option but not sure how to combine all these searches.

Is this too challenging? Somebody please help me.

 

[Kevin Spencer]

Hi Soccer Boy,

As if you were 10, huh? Okay, ask your Mommy to hire you a programmer.

;-)

What I mean is (speaking now to the man inside the boy), what you're
describing is much more than the FrontPage Database tools can do for you. It
would require a custom ASP (PHP, CGI, what-have-you) web application to
create. There is a lot of conditional and formatting logic in there.

So, if you know ASP (and assuming that you're hosted on a Windows server),
you can write your own custom database interface. Or, if you're hosted on a
Unix/Linux server, you can write it with PHP, CGI, etc.

And if you are not a programmer, yes, it's too challenging for you, and you
would need to either re-think your requirements or hire a programmer.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

 

[SoccerBoy]

Thanks Kevin. That the news I did not want to hear. I will look online at
the ASP code and try to figuge it out. Even at 10 years old I can be very
resourceful.

 

[Kevin Spencer]

Well, in that case, good for you! You can find some articles, tutorials, and
samples at my web site: http://www.takempis.com.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

 

[Stefan B Rusynko]

Or look at http://www.asp101.com/samples/




| Well, in that case, good for you! You can find some articles, tutorials, and
| samples at my web site: http://www.takempis.com.
|
| --
| HTH,
|
| Kevin Spencer
| Microsoft MVP
| .Net Developer
| What You Seek Is What You Get.
|
| | > Thanks Kevin. That the news I did not want to hear. I will look online
| > at
| > the ASP code and try to figuge it out. Even at 10 years old I can be very
| > resourceful.
| >
| > "Kevin Spencer" wrote:
| >
| >> Hi Soccer Boy,
| >>
| >> As if you were 10, huh? Okay, ask your Mommy to hire you a programmer.
| >>
| >> ;-)
| >>
| >> What I mean is (speaking now to the man inside the boy), what you're
| >> describing is much more than the FrontPage Database tools can do for you.
| >> It
| >> would require a custom ASP (PHP, CGI, what-have-you) web application to
| >> create. There is a lot of conditional and formatting logic in there.
| >>
| >> So, if you know ASP (and assuming that you're hosted on a Windows
| >> server),
| >> you can write your own custom database interface. Or, if you're hosted on
| >> a
| >> Unix/Linux server, you can write it with PHP, CGI, etc.
| >>
| >> And if you are not a programmer, yes, it's too challenging for you, and
| >> you
| >> would need to either re-think your requirements or hire a programmer.
| >>
| >> --
| >> HTH,
| >>
| >> Kevin Spencer
| >> Microsoft MVP
| >> ..Net Developer
| >> What You Seek Is What You Get.
| >>
| >> | >> >I am new to FP so please explain it as if I were 10.
| >> >
| >> > My database has the following fields:
| >> > Name|Age|PhoneType|AreaCode|Prefix|Line|Email
| >> >
| >> > I want to search the first record and display the Age only if the Name
| >> > is
| >> > equal to Pete - then continue in the same record and display
| >> > AreaCode|Prefix|Line only if PhoneType is not equal to home - then
| >> > continue
| >> > in the same record and display the Email only if the field is not
| >> > empty.
| >> >
| >> > I am only familiar with the database wizard and I have dabbled with the
| >> > Criteria option but not sure how to combine all these searches.
| >> >
| >> > Is this too challenging? Somebody please help me.
| >> > --
| >> > Thanks
| >>
| >>
| >>
|
|