RE: matching a whole word
Regex *is* the key then. Many thanks. -Nate -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, August 17, 2011 4:48 PM To: cf-talk Subject: Re: matching a whole word Yes, indeed. You want something like this: keyword = "star"; myString = "The dog sniffed at the starfish and growled"; regEx = "\b" & keyword & "\b"; if (reFindNoCase(regEx, myString)) { writeOutput("found it"); } else { writeOutput("did not find it"); } On 8/17/2011 5:20 PM, Nathan C. Smith wrote: > If I want to scan a string to match only a whole word should I be > looking at regular expressions? I want to scan a string like > > "The dog sniffed at the starfish and growled" > > And if I scan for "star" not match "starfish". > > Are regular expressions the most effective way to do that? > > Thank you. > > -Nate > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Mura or Control Panel
Peter, An email account is going to be an issue for your ISP (yes... likely through the control panel). While mura stores emails for various things it is not really "hosting" solution. It doesn't have things like datasource configuration, FTP accounts, email accounts and the like. Hope this helps! -mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Peter Donahue [mailto:pdonah...@satx.rr.com] Sent: Wednesday, August 17, 2011 4:59 PM To: cf-talk Subject: Mura or Control Panel Hello everyone,] It's been a while since I've posted but I have a question for any Mura users on the list. I'm getting ready to create a new site for a client using Mura. I need to set up e-mail accounts for this particular client. Is there a way to do this through Mura or do I need to do it via the Domain control panel? Speaking of Mura I went to www.houseoffusion.com to look up a Mura discussion list but discovered that the site is down. To be sure it wasn't a browser issue I tried accessing that site via two computers and got the same results. If someone can send me subscription information for a Mura discussion group I'll appreciate that very much. I'm entering uncharted waters and need all the navigation help I can get with Mura; particularly since I'll have others on this voyage of discovery with me. Peter Donahue "Will you come and awake our lost land from its slumber And her fetters we'll break, links that long are encumbered. And the air will resound with hosannas to greet you On the shore will be found gallant Irishmen to greet you." Will You Come to the Bower Traditional Irish Folk Song ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Mura or Control Panel
If you are just asking how to setup email in general then your client needs to use their hosts control panel to so this, Mura us a CMS. If you are asking how to provision Email via the CMS in general and plan to write your own module to do this, then you will need to use an API. I would suggest you set your client up on Google Apps and use the Google Apps API. The other option is of course to run your own mail server, all of which include an API -- Russ Michaels www.bluethunderinternet.com : Business hosting services & solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Mura or Control Panel
On Wed, Aug 17, 2011 at 5:58 PM, Peter Donahue wrote: > It's been a while since I've posted but I have a question for any Mura > users > on the list. I'm getting ready to create a new site for a client using > Mura. > I need to set up e-mail accounts for this particular client. Is there a way > to do this through Mura or do I need to do it via the Domain control panel? > you need to do that through the domain control panel. A few email systems have a API that could be wrapped in a plugin like Smartermail but as a whole they are all different, each would need seperate plugin for the most part. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Mura or Control Panel
Hello everyone,] It's been a while since I've posted but I have a question for any Mura users on the list. I'm getting ready to create a new site for a client using Mura. I need to set up e-mail accounts for this particular client. Is there a way to do this through Mura or do I need to do it via the Domain control panel? Speaking of Mura I went to www.houseoffusion.com to look up a Mura discussion list but discovered that the site is down. To be sure it wasn't a browser issue I tried accessing that site via two computers and got the same results. If someone can send me subscription information for a Mura discussion group I'll appreciate that very much. I'm entering uncharted waters and need all the navigation help I can get with Mura; particularly since I'll have others on this voyage of discovery with me. Peter Donahue "Will you come and awake our lost land from its slumber And her fetters we'll break, links that long are encumbered. And the air will resound with hosannas to greet you On the shore will be found gallant Irishmen to greet you." Will You Come to the Bower Traditional Irish Folk Song ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: matching a whole word
Yes, indeed. You want something like this: keyword = "star"; myString = "The dog sniffed at the starfish and growled"; regEx = "\b" & keyword & "\b"; if (reFindNoCase(regEx, myString)) { writeOutput("found it"); } else { writeOutput("did not find it"); } On 8/17/2011 5:20 PM, Nathan C. Smith wrote: > If I want to scan a string to match only a whole word should I be looking at > regular expressions? I want to scan a string like > > "The dog sniffed at the starfish and growled" > > And if I scan for "star" not match "starfish". > > Are regular expressions the most effective way to do that? > > Thank you. > > -Nate > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
matching a whole word
If I want to scan a string to match only a whole word should I be looking at regular expressions? I want to scan a string like "The dog sniffed at the starfish and growled" And if I scan for "star" not match "starfish". Are regular expressions the most effective way to do that? Thank you. -Nate ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
I know that it works within excel. Not sure if there is something else going on when creating a spreadsheet. I imported a tab delimited file that used the single quote preceding the zeros, and excel did not treat it the same way as when you use a single quote using excel directly. Sorry that didn't work. BTW, Steven has the right string format for the CF syntax. BC On Wed, Aug 17, 2011 at 11:46 AM, DURETTE, STEVEN J (ATTASIAIT) < sd1...@att.com> wrote: > > Shouldn't that be The ' has to be outside > of the # signs. > > -Original Message- > From: funand learning [mailto:funandlrnn...@gmail.com] > Sent: Wednesday, August 17, 2011 11:26 AM > To: cf-talk > Subject: Re: coldfusion spreadsheet leading zeroes issue > > > I tried using a single quote within coldfusion before sending it to excel. > Excel still displays the quote. This is what I am doing > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: coldfusion spreadsheet leading zeroes issue
Shouldn't that be The ' has to be outside of the # signs. -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: Wednesday, August 17, 2011 11:26 AM To: cf-talk Subject: Re: coldfusion spreadsheet leading zeroes issue I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looking for a Mura CMS consultant
We have a web site that was built using Mura CMS by a designer and he is no longer with the company. We are looking for a Consultant that is familiar with Mura to have a look at our system. Please contact me offline. Thanks, Dave Hatz dave_h...@hotmail.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
Brain, I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing On Tue, Aug 16, 2011 at 4:47 PM, Brian Cain wrote: > > The single quote does not appear. It is a special formatting rule for > excel. It makes the column display as a character field by default. It is > used specifically to handle leading zeros. > > Brian Cain > > On Tue, Aug 16, 2011 at 3:22 PM, funand learning >wrote: > > > > > If I use a single quote as leading character, then thta single quote > would > > appear in excel sheet right? At what point should I remove the quote? Can > > anything be done on database side. I mean can the query be formatted in > any > > way? > > > > On Tue, Aug 16, 2011 at 2:41 PM, Brian Cain wrote: > > > > > > > > You could also try using a single quote as your leading character. > This > > is > > > how would would enter it in excel without changing the column > formatting. > > > > > > BC > > > > > > On Tue, Aug 16, 2011 at 12:56 PM, Brook Davies > > > wrote: > > > > > > > > > > > This is an excel issue, not a CF issue. If you set the data type of > the > > > > column to text it does not happen.. > > > > > > > > > > > > > > > > > > http://www.google.ca/search?hl=en&client=firefox-a&hs=vpO&rls=org.mozilla%3A > > > > > > > > > > > > > > en-GB%3Aofficial&biw=1920&bih=1084&q=excel+truncates+leading+zero&btnG=Searc > > > > > > > > > > > > > > h&oq=excel+truncates+leading+zero&aq=f&aqi=&aql=&gs_sm=s&gs_upl=0l0l0l18408l > > > > 0l0l0l0l0l0l0l0ll0l0 > > > > > > > > Brook > > > > > > > > -Original Message- > > > > From: fun and learning [mailto:funandlrnn...@gmail.com] > > > > Sent: August-16-11 10:35 AM > > > > To: cf-talk > > > > Subject: coldfusion spreadsheet leading zeroes issue > > > > > > > > > > > > Hi All - > > > > > > > > I am facing an issue with coldfusion9 spreadsheet functions. It cuts > of > > > > leading zeroes. This is what I am trying. I am getting array of data > > and > > > > using spreadsheetaddrows. When I am constructing an array, am using > > > quotes > > > > so as to preserve the zeroes but with no effect. Adding some > characters > > > > like > > > > "~" helps. But when I am adding space, coldfusion is not preserving > the > > > > spaces. Is there a better way to handle this issue? > > > > > > > > Thanks > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: excel sheets poiutility.cfc
I don't know about poiutility.cfc, but cfhssf on riaforge can be used to do everything in memory. No files saved at all. I helped out with it a couple of years ago and that was one of the things I had to do for my own use. I actually may have made a more updated version that checks your version of poi and can do more with newer versions, but I never gave it to Ed to post up. Steve -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Tuesday, August 16, 2011 9:50 PM To: cf-talk Subject: excel sheets poiutility.cfc Hi All - This is a third version of generating to excel options that I am trying. I was going through the examples. If I am using apache poi, should I always write to excel, then read it and display it to the user? Is it possible to just read it directly from the query and display it to the user? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm