Database Results

[Ralph Fulvio]

Hi All,

This one is too tough for me to do..but I'm hoping you
folks can help! This is how this field data appears on
the web page...with most recent comment first.

07/28/03 13:40:19 DAB
NOTAM IS STILL GOOD.
07/28/03 13:26:54 DAB
PER SSC SUPV/SL, NEW RETURN DATE IS 8/22/03 DUE TO PORT
AUTH SCHEDULE SLIPPAGE.
07/28/03 12:19:34 DAB
BRIEFED ON A.M. TELCON, SSC MGR/RM WILL FOLLOW UP WITH
THE PORT AUTH AND REPORT STATUS BACK TO US.

Is there a way to get the webpage or SQL server to
display this data with the most recent comment last ?

 

[Thomas A. Rowe]

You need to add a Order By clause with ASC or DESC to the end of your query.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Ralph Fulvio]

Thanks Thomas !

I'll give this ago...I just have to figure out how to use
it.