Recordset Query Help

[neilmunn]

Hi

I am trying to setup an asp page which will display meeting details.

At the moment I have got two pages. One displaying normal meetings and another displaying private meetings (using a cookie). Is there anyway that I can combien these onto one page?

Here is my code:

SELECT *
FROM meetings, clients, people
WHERE PeopleID = meetingPeople AND meetingClientID = ClientID AND PeopleClientID = varCompany AND ClientCompanyID = varCompanyID AND meetingprivate = false
ORDER BY meetingTime

varCompany | 1 | Session("Company&quot
varCompanyID | 1 | Session("Company&quot

---

SELECT *
FROM meetings, clients, people
WHERE PeopleID = meetingPeople AND meetingClientID = ClientID AND PeopleClientID = varCompany AND ClientCompanyID = varCompanyID AND meetingprivate = true and PeopleID = MMColParam
ORDER BY meetingTime

varCompany | 1 | Session("Company&quot
varCompanyID | 1 | Session("Company&quot
MMColParam | 1 | Request.Cookies("Synergy&quot("UserID&quot

Thanks
Neil Munn
neil.munn@hotpop.com

 

[Cheech]

You can have 2 recordsets on one page.

But why not have 1 recordset sorted on meetingprivate?

Cheech The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)