Dreamweaver - ASP/Access problem

Author

ASP/Access problem

Phil Barnett

2004-04-21, 2:49 pm

Hi all,

I want display a list of events, if the number of subscribers for a given
event exceeds 30 it will show 'sold out'

Recordset1 is the events, they are displayed down the page with a repeat
region.

Recordset2 is the subscribers for a given events (the one I'm counting to
see if it exceeds 30). The sql will be:

WHERE events.eventID like subscribers.eventID

My question how does events.eventID 'update' depending which record it is
in. In other words how does recordset2 get the eventID from recordset1.

many thanks

Phil

matt_12511

2004-04-21, 2:50 pm

you need to give more information. what is the whole sql statement? are you getting an error? what is it?

show more code :D

Matt

Les Matthews

2004-04-21, 2:50 pm

"Phil Barnett" <phil653@yahoo.com> wrote in message
news:407fe55b$0$11588$65c69314@mercury.nildram.net...
> Hi all,
>
> I want display a list of events, if the number of subscribers for a given
> event exceeds 30 it will show 'sold out'
>
> Recordset1 is the events, they are displayed down the page with a repeat
> region.
>
> Recordset2 is the subscribers for a given events (the one I'm counting to
> see if it exceeds 30). The sql will be:
>
> WHERE events.eventID like subscribers.eventID
>
> My question how does events.eventID 'update' depending which record it is
> in. In other words how does recordset2 get the eventID from recordset1.
>

Like Matt said you haven't provided enough information to give a very
informed response, but it sounds to me like you need to either nest the
subscribers repeat region within the events repeat region or combine the two
by doing a join adding the adding the WHERE clause to the events recordset.