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
