RE: any idea how to
Date format? Left, mid, right? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:05 PM To: CF-Talk Subject: any idea how to Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any idea how to
LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any idea how to
crude, but it works consistently: cfset year = Left(20060523,4) cfset month = Mid(20060523,5,2) cfset day = Right(20060523,2) cfoutput#CreateDate(year,month,day)#/cfoutput On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any idea how to
There is probably a trick i don't know, but something like... dTemp=createODBCDate(mid(date,3,2)right(date,2)left(date,4)) sDate=dateFormat(dTemp,m/d/) On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any idea how to
Using SQL CONVERT(VARCHAR,CONVERT(DATETIME,'20060523'),101) Using CF Mid('20060523',5,2) '/' Right('20060523',2) '/' Left('20060523',4) -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 11:10 AM To: CF-Talk Subject: RE: any idea how to Date format? Left, mid, right? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:05 PM To: CF-Talk Subject: any idea how to Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any idea how to
Scott Stewart wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas createDate(left('20060523'),mid('20060523',5,2),right('20060523')) is how I have done this in the past, you will probably want to use a variable here and there. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any idea how to
Alan, This worked... Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:11 PM To: CF-Talk Subject: Re: any idea how to LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any idea how to
Coolio.. Make sure I got the MID function right, I tossed it together real quick and it might be 5, not 4. =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Alan, This worked... Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:11 PM To: CF-Talk Subject: Re: any idea how to LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any idea how to
Convert 20060523 Into 5/23/2006 See ConvertDate(): http://www.contentbox.com/claude/customtags/convertDate/viewConvertDate.cfm It would be: CFSET myDate = convertDate ( 20060523, string, string, mmdd, US) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any idea how to
cfset new_date=rereplace (20060523, ([\d]{4})([\d]{2})([\d]{2}),\2/\3/\1,ALL)/ On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: any idea how to
LOL. I miss those perl days, when hackers were real hackers and the top line of the keyboard was nervous. -Original Message- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: Thursday, 9 August 2007 12:57 PM To: CF-Talk Subject: Re: any idea how to cfset new_date=rereplace (20060523, ([\d]{4})([\d]{2})([\d]{2}),\2/\3/\1,ALL)/ On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285789 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any idea how to introduce CF in my area?
You could always start a local CFUG chapter: http://www.adobe.com/cfusion/usergroups/ -Cameron Ali Majdzadeh wrote: Hey people: CF is not popular in my area and the main reason is .Net adds and PHP open source reputation. Do u have any idea how I can iontroduce it to people? I am planing to make a website (my personal blog) to introduce it more but I need new ideas. Thanks Benign ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any idea how to introduce CF in my area?
Install the 30-day trial and start building something. You can re-build an existing application, or build a new one. M!ke -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 2:37 PM To: CF-Talk Subject: Any idea how to introduce CF in my area? Hey people: CF is not popular in my area and the main reason is .Net adds and PHP open source reputation. Do u have any idea how I can iontroduce it to people? I am planing to make a website (my personal blog) to introduce it more but I need new ideas. Thanks Benign ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any idea how to introduce CF in my area?
Specifically in regards to OS, show them RIAForge.org. It isn't as large as the PHP OS world, but it is growing. On 7/18/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: Hey people: CF is not popular in my area and the main reason is .Net adds and PHP open source reputation. Do u have any idea how I can iontroduce it to people? I am planing to make a website (my personal blog) to introduce it more but I need new ideas. Thanks Benign ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any idea how to introduce CF in my area?
Bah! stupid fingers! coal = goal... sheesh! ;o) Chris On 7/18/07, Christopher Jordan [EMAIL PROTECTED] wrote: That's what I'd do (or find out if there is already a CFUG chapter in your area). Also, this is sort of the coal of RIAForge.org, GotCFM.com, and sites like that. I guess another way to introduce it would be to (if you're a contractor) suggest to all of your clients that they make the switch. You could point to the laundry list of *huge* companies and government (including military) entities who already use ColdFusion. Ben Forta's blog is also another great place that has a list of folks who use CF. Maybe you could have a parade too. ;o) Good luck, and spread the word my brotha! Chris On 7/18/07, Cameron Childress [EMAIL PROTECTED] wrote: You could always start a local CFUG chapter: http://www.adobe.com/cfusion/usergroups/ -Cameron Ali Majdzadeh wrote: Hey people: CF is not popular in my area and the main reason is .Net adds and PHP open source reputation. Do u have any idea how I can iontroduce it to people? I am planing to make a website (my personal blog) to introduce it more but I need new ideas. Thanks Benign ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any idea how to introduce CF in my area?
That's what I'd do (or find out if there is already a CFUG chapter in your area). Also, this is sort of the coal of RIAForge.org, GotCFM.com, and sites like that. I guess another way to introduce it would be to (if you're a contractor) suggest to all of your clients that they make the switch. You could point to the laundry list of *huge* companies and government (including military) entities who already use ColdFusion. Ben Forta's blog is also another great place that has a list of folks who use CF. Maybe you could have a parade too. ;o) Good luck, and spread the word my brotha! Chris On 7/18/07, Cameron Childress [EMAIL PROTECTED] wrote: You could always start a local CFUG chapter: http://www.adobe.com/cfusion/usergroups/ -Cameron Ali Majdzadeh wrote: Hey people: CF is not popular in my area and the main reason is .Net adds and PHP open source reputation. Do u have any idea how I can iontroduce it to people? I am planing to make a website (my personal blog) to introduce it more but I need new ideas. Thanks Benign ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4