PC Review


Reply
Thread Tools Rate Thread

Database query is killing me!!

 
 
=?Utf-8?B?U29jY2VyQm95?=
Guest
Posts: n/a
 
      30th Mar 2005
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
 
Reply With Quote
 
 
 
 
Kevin Spencer
Guest
Posts: n/a
 
      30th Mar 2005
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" <(E-Mail Removed)> wrote in message
news:9DF982C2-9E6B-4518-92B3-(E-Mail Removed)...
>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



 
Reply With Quote
 
=?Utf-8?B?U29jY2VyQm95?=
Guest
Posts: n/a
 
      30th Mar 2005
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.
>
> "SoccerBoy" <(E-Mail Removed)> wrote in message
> news:9DF982C2-9E6B-4518-92B3-(E-Mail Removed)...
> >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

>
>
>

 
Reply With Quote
 
Kevin Spencer
Guest
Posts: n/a
 
      30th Mar 2005
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.

"SoccerBoy" <(E-Mail Removed)> wrote in message
news:AB45395E-590A-4643-8CAB-(E-Mail Removed)...
> 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.
>>
>> "SoccerBoy" <(E-Mail Removed)> wrote in message
>> news:9DF982C2-9E6B-4518-92B3-(E-Mail Removed)...
>> >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

>>
>>
>>



 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      31st Mar 2005
Or look at http://www.asp101.com/samples/

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Kevin Spencer" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
| 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.
|
| "SoccerBoy" <(E-Mail Removed)> wrote in message
| news:AB45395E-590A-4643-8CAB-(E-Mail Removed)...
| > 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.
| >>
| >> "SoccerBoy" <(E-Mail Removed)> wrote in message
| >> news:9DF982C2-9E6B-4518-92B3-(E-Mail Removed)...
| >> >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
| >>
| >>
| >>
|
|


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Killing a child process of NTVDM.exe without killing NTVDM.exe itself tristin.colby@gmail.com Microsoft Windows 2000 CMD Promt 1 22nd Jan 2010 06:51 PM
Simple Counting Query Question... But it's killing me. Brendan Microsoft Access Queries 4 17th Mar 2009 11:17 PM
Killing the off-line database Janis Rough Microsoft Access 1 9th Jul 2007 04:28 PM
Killing print drivers from a user's profile without killing entire profile? Jessica Nielsen Microsoft Windows 2000 Printing 1 17th Jun 2004 09:29 PM
How to Add an All Values Item to a Database Query by Using the FrontPage 2003 Database Results Wizard =?Utf-8?B?RGFuaWVs?= Microsoft Frontpage 4 2nd Feb 2004 05:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:44 AM.