Any more feedback on taking a MMDDYY string and outputting as an MM.DD.YY
string? The last tip didn't seem to work and neither did all the
variations...?
----- Original Message -----
From: Christian L. Watt <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Monday, February 26, 2001 10:48 AM
Subject: RE: Re[2]: encrypt values in text controls
> Depending on what you want to do, there are a couple of ways. this is
what
> I would Suggest:
> First Create your date from the string-
> 1) <cfset thedate = "#CreateDate(left(id, 2), mid(id, 3, 2),
right(id,2))#">
> Then Format your date for the output-
> 2)#DateFormat(thedate, 'MM.DD.YY.')
>
> For your in between selection, you can either do it in your query using
> between -
> Select *
> From Table
> Where
> date between '#id1#' and '#id2'
>
> Or in a loop-
> <cfloop query="query" Condition="(date gte #id1#) and (date lte
> #id2#)
>
> Hope this helps.
>
> CW
>
>
> -----Original Message-----
> From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 26, 2001 9:31 AM
> To: CF-Server
> Subject: Re: Re[2]: encrypt values in text controls
>
>
> hopefully someone can help here because ive tried and had less than no
> luck...
>
> I have files named by dates ie: 022001 and ive managed to grab the
filename
> without into the field #id# but now i want to take my mmddyy date and make
> it mm.dd.yy instead... please help?
>
> and is there a way to use tags like <startdata><endata> and select only
the
> content between?
>
> As you can tell, i don't do much file manipulation... ive learned all i
need
> from databases and now its on to file manipulation
>
> ----- Original Message -----
> From: brendan avery <[EMAIL PROTECTED]>
> To: CF-Server <[EMAIL PROTECTED]>
> Sent: Sunday, February 25, 2001 5:46 PM
> Subject: Re[2]: encrypt values in text controls
>
>
> > SOMETHING is wrong with my email client or this list, but this is what i
> MEANT to post...
> >
> > --
> >
> > you'll want to use regular expressions if you want to use "wildcards".
> >
> > try this one to strip out all HTML tags from a document:
> > <cfset mytextonly=#REReplace(myhtmlsource, "<[^>]*>", "", "ALL")#>
> >
> > check your cf documentation for more on regular expressions.
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
