[thelist] Getting Latest Date from SQL DB

[Mike Cohen - Tabletools.com]

I need to retrieve the latest date from a SQL db. The way I'm doing it now
is extremely inefficient. I'm selecting all the dates, ordering by date,
then using ColdFusion putting them in a list, then selecting the last
element of the list. It works, but there must be a better way.

Thanks for any help.

Michel Cohen
http://www.tabletools.com
888-211-6603
----- Original Message -----
From: McCreath_David <McCreath_David at xmail.asd.k12.ak.us>
To: <thelist at lists.evolt.org>
Sent: Thursday, April 12, 2001 1:09 PM
Subject: RE: [thelist] How can I generate a printable page froma any web
page (CSS, ASP?) Also - An Idea


> >From: J. Blanchard
> >
> >----problem needing solution----
> >Is there a way to do this witout having to create "printer-friendly"
> >pages? I have searched but cannot find a how-to model for this
> >
> >I have settled on HTML 4.01, CSS1, ASP2.0, and SQL Server 7.0 as the
> >standards, so the answer needs to fit within those parameters
> >if possible.
> >----end problem----
>
> John,
>
> We're working with pretty much the same tools here, and we just offer a
link
> that passes a variable to the query string to switch to a different
> stylesheet and table structure. Basically we turn off everything but the
> content cell of the main table, a header, and a link back to the formatted
> version.
>
> We wrapped it all up in an include so we can drop it on any page we need
to.
> Realistically, not *every* single page on your site needs to have a
printer
> friendly version, although that's possible, too.
>
> 4guysfromrolla has a detail article about how they did theirs, which might
> be helpful:
>
> http://www.4guysfromrolla.com/webtech/080600-1.shtml
>
> David
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>