Stuart you can use the following format.
#dateformat(fieldname,"DD-MM-YY")#
----- Original Message -----
From: Kidd, Stuart <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 11:36 AM
Subject: RE: Records, not vinyl.
> Thanks John, that did the trick perfectly. I now have it lastest date
> descending and where authorisation = 1 (i added that bit!). I decided to
> make that extra summary field like you said. I suppose when I get a bit
of
> time I can use the "#left(string, 200#") on the main long text and put
that
> into the database as a summary field saving the user having to write a
> summary and the full text.
>
> Another thing, which may seem simple is that when a new article is added i
> am getting them to fill out a date field (i'm using access 2000) which is
> dd-mm-yyyy. I have noticed however that CF (or maybe Access) is changing
> this to something like 2001-30-03 00:00:00 even though I specified in the
> form for it to be only 10 characters and in the field i specified
date/time
> and format smalldate (dd-mm-yyyy).
>
> If this is the way it does that then how do I change the date so that it
> re-formats to dd-mm-yyyy?
>
> Thanks.
>
> Stuart.
>
>
> -----Original Message-----
> From: Jason E Miller [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 7:20 PM
> To: CF-Server
> Subject: RE: Records, not vinyl.
>
>
> Just do it in your query
>
> Select TOP 5 whatever Order by LatestDate Desc
>
>
> as to pulling only 200 characters in SQL Im not sure but you could just do
> it in code since its only 5 articles
> <CFSET Summary="#LEFT(string, 200)#">
>
> But I would suggest having your input template set aside an area for the
> summary so that you can control exactly what shows up in there and it will
> also make for a better query since you don't have to pull 5 Text fields
when
> you could just pull 5 varchars.
>
> Hope this helps
>
>
> -----Original Message-----
> From: Kidd, Stuart [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 10:05 PM
> To: CF-Server
> Subject: Records, not vinyl.
>
>
> 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
