|
 |
asp_web_howto thread: Eliminating unuseful information.
Message #1 by "T.L. Jackson" <actionjackson@a...> on Thu, 30 Nov 2000 06:09:21 -0000
|
|
Hello everybody, I'm new to the list here. For the past month I have been
looking for a way to eliminate a problem I'm having with my webpage that I
have created and could use some help. If you take a look at the following
URL at: http://www.cappnet.org/specialtysearch.asp You will notice how
the same doctor's information comes up over and over and the only change
in the information is the highlighted specialty area of the doctor. I'm
trying to only get the doctor's information to come up once with all their
specialty area with that information. How would I do that? In the
database, I set up three different tables. One is called
"lookupspecialty" which has the listing of specialty area. Then I have a
second table called "members" which has the doctor's information. Now,
the relationship is a one to many. One doctor can have many specialty
area. Everything I have tried to do isn't working and now I'm stuck
looking for answers. Can somebody help me? If so, please e-mail me at:
actionjackson@a... If you need more infomation please let me
know.
Sincerely,
T.L. Jackson
actionjackson@a...
Message #2 by Kavanjit Singh <kavanjit.singh@i...> on Thu, 30 Nov 2000 16:48:21 +0530
|
|
hi
oks let me assume few things
u have one table of members...which has doctor info.
other table havin speciality...
i guess they must be linkied by some doctorID or memberID.
if i would to do this thing here is how i will do it..
make 2 loops.
lets say 2 tables r named as members and speciality
and memberID is linkin the both tables.
rstmembers.open "Select * from members"
do while not rstmembers.EOF
DISPLAY MEMBER INFO
rstSpeciality.open "Select * from Speciality where
Speicality.MemberID=" & rstMembers("MemberID")
do while not rstSpeciality.EOF
DISPLAY MEMBERS SPECIALITIES
rstSpeciality.MoveNext
Loop
rstSpeciality.Close
rstMembers.MoveNext
Loop
I hope this should work
Ricky.
> ----------
> From: T.L. Jackson[SMTP:actionjackson@a...]
> Reply To: ASP Web HowTo
> Sent: Thursday, November 30, 2000 11:39 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Eliminating unuseful information.
>
> Hello everybody, I'm new to the list here. For the past month I have been
> looking for a way to eliminate a problem I'm having with my webpage that I
> have created and could use some help. If you take a look at the following
> URL at: http://www.cappnet.org/specialtysearch.asp You will notice how
> the same doctor's information comes up over and over and the only change
> in the information is the highlighted specialty area of the doctor. I'm
> trying to only get the doctor's information to come up once with all their
> specialty area with that information. How would I do that? In the
> database, I set up three different tables. One is called
> "lookupspecialty" which has the listing of specialty area. Then I have a
> second table called "members" which has the doctor's information. Now,
> the relationship is a one to many. One doctor can have many specialty
> area. Everything I have tried to do isn't working and now I'm stuck
> looking for answers. Can somebody help me? If so, please e-mail me at:
> actionjackson@a... If you need more infomation please let me
> know.
>
> Sincerely,
>
> T.L. Jackson
> actionjackson@a...
>
Message #3 by "Walter Burrough" <lists@c...> on Thu, 30 Nov 2000 11:30:49 -0000
|
|
some pseudo code:
------------------------------
' go fetch your recordset (doctors linked to specialities)
' order it by doctorId and specialty id (rst)
lastDoc='x'
while not rst.eof
if rst(doctorId) <> lastDoc then
' now this is a new doctor so seperate from previous doctor
' write out doctor details
lastDoc = rst(doctorId)
end if
' now write out the specialty details below the doctor details
rst.movenext
wend
good luck
walter
-----Original Message-----
From: T.L. Jackson [mailto:actionjackson@a...]
Sent: 30 November 2000 06:09
To: ASP Web HowTo
Subject: [asp_web_howto] Eliminating unuseful information.
Hello everybody, I'm new to the list here. For the past month I have been
looking for a way to eliminate a problem I'm having with my webpage that I
have created and could use some help. If you take a look at the following
URL at: http://www.cappnet.org/specialtysearch.asp You will notice how
the same doctor's information comes up over and over and the only change
in the information is the highlighted specialty area of the doctor. I'm
trying to only get the doctor's information to come up once with all their
specialty area with that information. How would I do that? In the
database, I set up three different tables. One is called
"lookupspecialty" which has the listing of specialty area. Then I have a
second table called "members" which has the doctor's information. Now,
the relationship is a one to many. One doctor can have many specialty
area. Everything I have tried to do isn't working and now I'm stuck
looking for answers. Can somebody help me? If so, please e-mail me at:
actionjackson@a... If you need more infomation please let me
know.
Sincerely,
T.L. Jackson
actionjackson@a...
Message #4 by Roger Balliger <Roger@i...> on Thu, 30 Nov 2000 08:11:43 -0800
|
|
you may try writing an SQL statement which will create a 'right outer join'.
In this particular case, a recordset would be created where record1 from the
left table (doctor) is matched to all the relevant records of the second
table (specialty) and then looped. The result would be a new recordset
where all the doc info is displayed once along with all the relevant
specialty listings.
You may have to break out an SQL book to get the correct syntax, but I think
a right outer join is the way to go. This new SQL statement should replace
the current SQL statement(s) in your page used to create the working
recordset.
Roger
-----Original Message-----
From: T.L. Jackson [mailto:actionjackson@a...]
Sent: Wednesday, November 29, 2000 10:09 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Eliminating unuseful information.
Hello everybody, I'm new to the list here. For the past month I have been
looking for a way to eliminate a problem I'm having with my webpage that I
have created and could use some help. If you take a look at the following
URL at: http://www.cappnet.org/specialtysearch.asp You will notice how
the same doctor's information comes up over and over and the only change
in the information is the highlighted specialty area of the doctor. I'm
trying to only get the doctor's information to come up once with all their
specialty area with that information. How would I do that? In the
database, I set up three different tables. One is called
"lookupspecialty" which has the listing of specialty area. Then I have a
second table called "members" which has the doctor's information. Now,
the relationship is a one to many. One doctor can have many specialty
area. Everything I have tried to do isn't working and now I'm stuck
looking for answers. Can somebody help me? If so, please e-mail me at:
actionjackson@a... If you need more infomation please let me
know.
Sincerely,
T.L. Jackson
actionjackson@a...
Message #5 by TL Jackson <actionjackson@a...> on Thu, 30 Nov 2000 16:17:27 -0500
|
|
Roger,
Where can I find more information about this "right outer
join"? Everything I look up is only coming back with "inner join".
T.L.
At 08:11 AM 11/30/00 -0800, you wrote:
>you may try writing an SQL statement which will create a 'right outer join'.
>In this particular case, a recordset would be created where record1 from the
>left table (doctor) is matched to all the relevant records of the second
>table (specialty) and then looped. The result would be a new recordset
>where all the doc info is displayed once along with all the relevant
>specialty listings.
>
>You may have to break out an SQL book to get the correct syntax, but I think
>a right outer join is the way to go. This new SQL statement should replace
>the current SQL statement(s) in your page used to create the working
>recordset.
>
>Roger
>
>-----Original Message-----
>From: T.L. Jackson [mailto:actionjackson@a...]
>Sent: Wednesday, November 29, 2000 10:09 PM
>To: ASP Web HowTo
>Subject: [asp_web_howto] Eliminating unuseful information.
>
>
>Hello everybody, I'm new to the list here. For the past month I have been
>looking for a way to eliminate a problem I'm having with my webpage that I
>have created and could use some help. If you take a look at the following
>URL at: http://www.cappnet.org/specialtysearch.asp You will notice how
>the same doctor's information comes up over and over and the only change
>in the information is the highlighted specialty area of the doctor. I'm
>trying to only get the doctor's information to come up once with all their
>specialty area with that information. How would I do that? In the
>database, I set up three different tables. One is called
>"lookupspecialty" which has the listing of specialty area. Then I have a
>second table called "members" which has the doctor's information. Now,
>the relationship is a one to many. One doctor can have many specialty
>area. Everything I have tried to do isn't working and now I'm stuck
>looking for answers. Can somebody help me? If so, please e-mail me at:
>actionjackson@a... If you need more infomation please let me
>know.
>
>Sincerely,
>
>T.L. Jackson
>actionjackson@a...
>
>
|
|
|
View Cart
