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
