Help with RecordSet filtering

[slakker01]

Hi all,

I have a page with a recordset built that displays the data from my releases
database.
The purpose of this page is to show people all the applications that are being
released within each release.
an example would be: we may have a release on 3/21, and then another one on
4/25, and so on..

Please see my MS Access DB structure below:

------------------------------
(DB) releases.mdb

(tbl) ReleaseDates
(fld) rlsDatesID (linked)
(fld) ReleaseDate

(tbl) Releases
(fld) Application
(fld) Time Created
(fld) Description
(fld) Contact Info
(fld) releaseDate (linked)
-------------------------------

currently, this the recordset listed below display ALL applications in the DB,
and I would like it to filter based on a release date (3/21 or 4/25) selected
using a dropdown form on the page.
The dropdown will pull all available release dates from the 'ReleaseDates'
table.

-----------------------------------------------------------------
<%
Dim releasesRS
Dim releasesRS_numRows

Set releasesRS = Server.CreateObject("ADODB.Recordset")
releasesRS.ActiveConnection = MM_releases_STRING
releasesRS.Source = "SELECT Releases.*, Resource.Resource FROM Releases LEFT
JOIN Resource ON Releases.Resource = Resource.resourceID ORDER BY Application
ASC"
releasesRS.CursorType = 0
releasesRS.CursorLocation = 2
releasesRS.LockType = 1
releasesRS.Open()

releasesRS_numRows = 0
%>
-----------------------------------------------------------------

Any help on this would be much appreciated, guys.
If you have any ideas, I will try them.

Thanks in advance!
George

[Paul Whitham TMM]

What specific problem are you running into?

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"slakker01" <webforumsuser@macromedia.com> wrote in message
news:d2bu4j$7ss$1@forums.macromedia.com...

> Hi all,
>
> I have a page with a recordset built that displays the data from my

releases

> database.
> The purpose of this page is to show people all the applications that are

being

> released within each release.
> an example would be: we may have a release on 3/21, and then another one

on

> 4/25, and so on..
>
> Please see my MS Access DB structure below:
>
> ------------------------------
> (DB) releases.mdb
>
> (tbl) ReleaseDates
> (fld) rlsDatesID (linked)
> (fld) ReleaseDate
>
> (tbl) Releases
> (fld) Application
> (fld) Time Created
> (fld) Description
> (fld) Contact Info
> (fld) releaseDate (linked)
> -------------------------------
>
> currently, this the recordset listed below display ALL applications in

the DB,

> and I would like it to filter based on a release date (3/21 or 4/25)

selected

> using a dropdown form on the page.
> The dropdown will pull all available release dates from the

'ReleaseDates'

> table.
>
> -----------------------------------------------------------------
> <%
> Dim releasesRS
> Dim releasesRS_numRows
>
> Set releasesRS = Server.CreateObject("ADODB.Recordset")
> releasesRS.ActiveConnection = MM_releases_STRING
> releasesRS.Source = "SELECT Releases.*, Resource.Resource FROM Releases

LEFT

> JOIN Resource ON Releases.Resource = Resource.resourceID ORDER BY

Application

> ASC"
> releasesRS.CursorType = 0
> releasesRS.CursorLocation = 2
> releasesRS.LockType = 1
> releasesRS.Open()
>
> releasesRS_numRows = 0
> %>
> -----------------------------------------------------------------
>
> Any help on this would be much appreciated, guys.
> If you have any ideas, I will try them.
>
> Thanks in advance!
> George
>