yes I usually use a series of CFIF statements to display the results
something like the following.
In the following example the possible options come from a database.
<select name="Examcode" size="<CFOUTPUT>#exams.recordcount#</CFOUTPUT>"
multiple>
<CFOUTPUT Query = "Exams">
<option value="#Trim(Uniquenumber)#" <CFIF #list.examcode# Contains
#Trim(Exams.Uniquenumber)#> SELECTED </cfif> >#TRIM(Examname)#</option>
</CFOUTPUT>
</select>
----- Original Message -----
From: Kidd, Stuart <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 12:36 PM
Subject: RE: Records, not vinyl.
> That works a treat, thanks Douglas.
>
> One last problem that has also been bugging me which i have looked up and
> down for an answer around websites is that i have a multiple select field
> with say 8 options. I let my users choose any they want and then put
those
> into the database. When i allow users to edit the form the only way i can
> get the box to select all the options is by sticking them in a line like
> "Option 1, Option 2, Option 3". So that would be the first Option and
then
> the others are listed. Is there a way to make it so that it'll display
just
> like when the user first multiple selected options?
>
> Cheers,
>
> Stuart.
>
>
> -----Original Message-----
> From: Douglas Purdie [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 30, 2001 11:45 AM
> To: CF-Server
> Subject: Re: Records, not vinyl.
>
>
> 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
