In your query b
Select * from X
where whatever = whatever
order by date
You can tell the order to be ascending or descending by adding it
as follows:
order asc by date
order desc by date
good luck,
kaigler
---------- Original Message ----------------------------------
From: "Kidd, Stuart" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 28 Mar 2001 16:04:55 +1000
>I just hate when you send something and you accidently send
something to the
>whole list!
>
>Anyhow, now I'm here I may as well ask you guys to help me with a
ColdFusion
>problem that is bugging me.
>
>I have created a database with lots of records (which are news
articles in
>this case).
>
>I am pulling the first 5 records from the database and displaying
them on a
>page (a news type page) but I'd like to pull them by latest date,
how do I
>do that? And how do I just pull say the first 200 characters
(for a
>summary)?
>
>Thanks for your help and apologies for my previous unwanted
designer posting
>that wasn't meant to go to the list.
>
>Regards,
>
>Stuart Kidd.
>
>
>-----Original Message-----
>From: Kidd, Stuart
>Sent: Wednesday, March 28, 2001 3:57 PM
>To: '[EMAIL PROTECTED]'
>Subject: RE: We need some OFFSITE CF GURUS!
>
>
>Hi Brian,
>
>Are you looking for any designers? I have gambling experience
working at
>http://www.pluslotto.com
>
>Regards,
>
>Stuart Kidd
>Communication Team
>Customer Service
>vodafone australia
>[EMAIL PROTECTED]
>
>
>
>-----Original Message-----
>From: Brian Thornton [mailto:[EMAIL PROTECTED]]
>Sent: Monday, March 26, 2001 8:48 PM
>To: CF-Server
>Subject: OT: We need some OFFSITE CF GURUS!
>
>
>Hi Everyone,
>Me and My great staff have been very busy working with the casino
vendors
>and tons of marketing teams here in bright Las Vegas! We are in
need of a
>few good freelance REMOTE coders. We have several small projects
and one big
>project due to start in 2 weeks. Obviously this would be a great
place for
>someone to step in create a alliance/partnership which we could
constantly
>send projects to. We want to have a definite individual lined up
by the 1st.
>Since there are a couple of client the prices range with work,
but once we
>take a peek at the following we'll bring you into the loop. We
have prepared
>the scope of work; So you just have to focus on coding.
>
>WE DON'T WANT THIRD PARTIES! LOOKING FOR DEDICATED OPEN
INDIVIDUALS ONLY.
>YOU MUST BE WILING TO SIGN A NON_DISCLOSURE/NON-COMPETE.
>
>Please complete the linked form at:
http://24.234.179.102/emp/1.cfm . The
>window for application will be open till 3/28/01 at which point
we will be
>making selections.
>
>
>Thanks,
>Brian Thornton
>LASVEGAS.COM
>[EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
