Extension for Date

[jhutchdublin]

I'm looking to see if anyone knows where I can get an extension for Dreamweaver
that lets me search based on a start date and end date and display a list of
available resources not booked between the two dates

[Joris van Lier]

"jhutchdublin" <webforumsuser@macromedia.com> wrote in message
news:fcd8e9$n40$1@forums.macromedia.com...

> I'm looking to see if anyone knows where I can get an extension for
> Dreamweaver
> that lets me search based on a start date and end date and display a list
> of
> available resources not booked between the two dates

What servermodel?

[jhutchdublin]

Coldfusion 8 is what I'm using

[Joris van Lier]

"jhutchdublin" <webforumsuser@macromedia.com> wrote in message
news:fcei0d$a8p$1@forums.macromedia.com...

> Coldfusion 8 is what I'm using

Sorry I don't know about coldfusion, hopefully a ColdFusion expert will come
to your aid.

On the other hand, it shouldn't be too difficult to create something like
that using standard Dreamweaver.
the SQL would look like this:

SELECT * FROM resources WHERE resource_date_available >= start_date AND
resource_date_available <= end_date

START_DATE and END_DATE would be variables that are input by the user.