how to go to a specific record

[Johnny]

[I posted this over in general_discussion, but this might be a better
group for it.]

DB is mySQL

I'm trying to display a schedule of events, and only want to display
dates that had/have events scheduled.

Considerations:

1) not all dates have events

2) The first date to display should be the most recent date before
"today" that had any events scheduled.

3) If there are events "today", I want to display today's events and the
next date that has events scheduled.

4) If there are no events today, I want to display the next two dates
that have events scheduled.

I've done a SELECT DISTINCT (sorted by date) of my schedule to pull all
dates that had any events scheduled. Now what? I know I need to query
my schedule to pull the events for the dates I need, but how do I
establish the low & high dates?


Suppose I've done a SELECT DISTINCT that pulled five dates that have
data:

2005-08-01
2005-08-02
2005-08-03
2005-08-06
2005-08-08

Suppose MyDate = 2005-08-06

I want to set MinDate to the previous date that had an event (2005-08-
03) and Max date to the highest of the next two dates that have events
(2005-08-08).

It looks like mysql_data_seek might help me, but I don't know how to use
it in CF (fairly new to CF, just done the basics).

Thanks,
John

[BKBK]

D?j? vu?

[Johnny]

> D?j? vu?

Wasn't sure if this was a more appropriate forum. Does .database_access
mean accessing databases, or MS Access?

Anyway, I've made progress (but am stuck again) and continued the thread
in the general_discussion NG.

Thanks,
John