Decrypting MD5
Hey all sorry if this has been asked before. I did Google and didn't come up with a result. I want to know if I can decrypt passwords stored as MD5 in a SQL Server database using the Decrypt function? There are online tools out there that decrypt MD5 so I'm hoping that I can do this in CF. Thanks. Kind regards, Rick ~| 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:360234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Decrypting MD5
So basically MD5 is useless if you can't decrypt the value! That sucks. Kind regards, Rick -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, March 12, 2015 9:57 AM To: cf-talk Subject: Re: Decrypting MD5 I want to know if I can decrypt passwords stored as MD5 in a SQL Server database using the Decrypt function? There are online tools out there that decrypt MD5 so I'm hoping that I can do this in CF. There are no tools that actually decrypt MD5 hashes, to the best of my knowledge. MD5 is a hashing algorithm, not an encryption algorithm. It lets you take a plaintext value and generates a hashed value, which cannot be decrypted. These online tools don't decrypt MD5 hashes. Instead, they have large databases of plaintext values and their corresponding MD5 hashes. When you hash a value, you should always get the same hash, so these tools compare the hash you provide against their database of existing hash values, and then lookup the corresponding plaintext value. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| 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:360236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Sending SMS
Hey guys, Does anyone know a service I can use for sending sms messages from cold fusion? I want to make an app that notifies someone by sms when their product is ready. Kind Regards, Rick Sanders Canada: USA: 171 Main St 1205 N. Second Ave Dartmouth, NS Siler City, NC T: 902-401-7689 T: 919-799-9076 W: www.webenergy.cahttp://www.webenergy.ca/ W: www.webenergyusa.comhttp://www.webenergyusa.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:359660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Sending SMS
Thanks Bryan, So it's like online payment. You need a gateway then a payment processor. -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Tuesday, November 18, 2014 7:32 PM To: cf-talk Subject: Re: Sending SMS Hey Rick, I'd say the answer depends on your situation. A big determining factor is what carrier are the folks on that you would be sending to? I ask because if only one carrier you can go low cost and failry easy. If multiple carriers, you may want to consider using an SMS aggregator as they know how to connect and send SMS messages through all the various carrier networks (for a fee per text message - those fees vary wildly depending on the various APIs you have to choose from). I use Clickatel for SMS aggregation services in the state of Maryland and I think we are talking pennies per text (you load account with credits and they get consumed - can notify as you get low etc). Once you have the carrier details sorted, then it's HOW you send (there is an SMS gateway in CF, but you can also just call APIs with say Clickatel using their HTTP API (one of 3-5 they offer). SOme APIs are meant fo super high volume - some for lowsome offer different feautures. So there is a simple primer to aid in some core decision making - I'll keep an eye on this thread - ask away! ;-) Take care -Bryan *Bryan Stevenson*B.Comm. President CEO Electric Edge Systems Group Inc. - makers of FACTS^(TM) phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com mailto:br...@electricedgesystems.com web: www.electricedgesystems.com http://www.electricedgesystems.com and www.fisheryfacts.com http://www.fisheryfacts.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:359667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Sending SMS
That's great but what about sending to different carriers? I'm guessing you have to know what carrier the customer you're sending a sms is on right? Kind Regards, Rick Sanders Canada: USA: 171 Main St 1205 N. Second Ave Dartmouth, NS Siler City, NC T: 902-401-7689 T: 919-799-9076 W: www.webenergy.ca W: www.webenergyusa.com -Original Message- From: richpaul7 . [mailto:richpa...@gmail.com] Sent: Tuesday, November 18, 2014 8:26 PM To: cf-talk Subject: Re: Sending SMS I added SMS support using email. for example, for Verizon, it's the phonenum...@vtext.com I googled it and found eahc carriers domain for email-to-text and then added a dropdown list for the carriers when my users enter their phone number to receive texts. I don't use any service at all, it's a simple cfmail ~| 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:359672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HMail server
We use mailenable for our regular email services. Kind Regards, Rick Sanders, CEO Canada: USA: T: 902-401-7689 T: 919-799-9076 W: www.webenergy.ca W: www.webenergyusa.com -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Monday, May 12, 2014 12:38 PM To: cf-talk Subject: Re: HMail server Which email server do you guys use? I mention it here becuase it is one of the common mail servers to use for cf. It is? I have never heard of hmail until about 2 minutes ago. -- ~| 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:358620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFML tags was: The long tail of ColdFusion fail
I come from the days of Everyware and Pervasive using the Tango technology. Same idea as CF being a tag-based language with an application server. Tag-based is easier to learn and has many benefits. When Macromedia bought CF, it was a God-send to integrate CF and Dreamweaver together without having to use Homesite or the bulky Allaire CF editor. Unfortunately, Macromedia bombed when it came to marketing Cold Fusion. Remember Ultradev? Macromedia's response to a WYSIWYG java, html, database application which was supposed to replace Dreamweaver? Macromedia focused too much on Ultradev and ignored the much needed CF marketing. Fast forward to Adobe (The document and printing solutions company) with failing web products to buy Macromedia. Like everyone, I was hoping for a re-brand of CF. Nothing happened. They never marketed it. At a trade show in New York (Internet World) I went to the Adobe booth. No one wanted to talk about CF, and there was one brochure with a paragraph mentioning CF that's it. Adobe came out with Cold Fusion Builder which is sort of nifty, but not nearly as good as Dreamweaver for building CF websites. Now Adobe is pushing their Creative Cloud (copying Office 365 are we?) which I would never use because of the continuous hacks to Adobe's servers and private information breaches. So what are the alternatives? PhP. Not secure, messy code, can't load balance between multiple servers unless you BUY an app server for it. Most PhP hosters throw the web server, database server and email server on the same box and call it a day. I programmed PhP code for a year and will never do it again. The problems with hacking, SQL injection attacks, URL hacks etc... take up time to fix at the developer's expense. PhP, Linux, MYSQL, Cpanel, Wordpress Joomla and many others are free. You get what you pay for. A proper coded CF site won't get hacked if the code is well written and the server is configured properly. There's ASP.net but personally I don't want to program something for 3 months in .NET that takes 3 weeks in CF. Plus Microsoft changes things around way too much, and Visual Studio is stupid expensive. Sure there's Expression web (does anyone really use it?) and some plugins for Dreamweaver. There's Dot Net Nuke if you have lots of time on your hands too. Most of my clients don't want to wait. And .NET developers are the snobs of the development community expecting high hourly rates. Content Management Server was a nice touch if you had deep pockets and lots of staff to maintain multiple servers but Microsoft did away with that too. Is CF dying? It is dying a slow death in my opinion. Adobe has dropped the ball with marketing. Heck, they don't even use it on their own site! PhP is the internet king for programming, and Wordpress is keeping developers making thousands of plugins for it. In the technical colleges and universities they teach PhP, Java, and .NET. New developers aren't even exposed to CF anymore. When you say Adobe, the first 2 things that come to mind are PDF and Photoshop. I'll continue to use CF for as long as I can, then just leave the web development game since the only player is PhP and I don't have the time nor desire to get into that technology. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Jon Clausen [mailto:jon_clau...@silowebworks.com] Sent: Tuesday, March 18, 2014 11:32 AM To: cf-talk Subject: Re: CFML tags was: The long tail of ColdFusion fail On Mar 18, 2014, at 10:17 AM, Adam Cameron dacc...@gmail.com wrote: Tag-based code is godawful anywhere other than in a view, or some other situation in which text-processing is needed. Which does not describe an awful lot of CFML code out there. That Macromedia/Adobe pushed the tag side of CFML over the script side is probably the worst strategic move they ever made. Agree, now. I think at that moment in webdev history, it served a purpose, which was ease of entry in to development. Now, it's a liability, seems antiquated, and is unnecessarily verbose - especially if you are coming from a different programming language. I do like wrapping an entire content block with cfoutput and just double escaping the pound symbols, as necessary, compared to having to deal with ?php echo $variable? or PHP short tags ?= $variables ?. I haven't written a tag-based component in a long while though, as I can build something out faster in script - especially when I'm coming back to CF after using a different language for a bit. ~| 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:358031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http
Twitter feed
Hey guys n' gals! I want to put a Twitter live feed on a CF site like Wordpress. Is there anything like that already out there or do I need to code it from scratch? If I need to code it, has anyone done it? Is it difficult? Thanks! Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:357939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Twitter feed
Thanks Russ! That's exactly what I want! Control! Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, March 14, 2014 8:11 PM To: cf-talk Subject: Re: Twitter feed this is what you want http://monkehtweet.riaforge.org/ On Fri, Mar 14, 2014 at 9:44 PM, Rob Parkhill robert.parkh...@gmail.comwrote: Why not just use what Twitter provides? dev.twitter.com You can embed a bunch of stuff straight from Twitter, no muss, no fuss. On Fri, Mar 14, 2014 at 5:36 PM, Rick Sanders r...@webenergy.ca wrote: Hey guys n' gals! I want to put a Twitter live feed on a CF site like Wordpress. Is there anything like that already out there or do I need to code it from scratch? If I need to code it, has anyone done it? Is it difficult? Thanks! Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:357942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Cold Fusion source code stolen from Adobe in Cyber attack
Not sure if you guys heard about this yet: http://www.cbc.ca/news/technology/adobe-customer-data-stolen-in-cyberattack-1.1912301 The hackers took source code for Adobe Acrobat, which is used to create electronic documents in the PDF format, as well as ColdFusion and ColdFusion Builder, used to create internet applications, Adobe said Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfmail Exchange 2010
Dave I want to thank you for your help. I resolved the issue. Because my Exchange server and CF server are on different machines I had to create a new receive connector allowing relay from the IP address of my CF server. Out of the box, Exchange doesn't allow any relay from a remote machine. Your note made me realize this and I was able to resolve it: That doesn't mean that any server can relay through your Exchange server (I hope!). Typically, you have to enable relay for each individual IP address that you want to allow. Have a great weekend. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, September 04, 2013 8:33 PM To: cf-talk Subject: Re: cfmail Exchange 2010 OK, this is weird. I can send fine to any email address from the account I set up t...@mycompany.com mailto:t...@mycompany.com I'm doing a cfoutput query=emails and sending an email out to the people in my query. The emails are valid. However, only the people on the local Exchange server receive them. Anyone outside doesn't get them. I tested with my gmail account and I don't receive the email. But I get it on my exchange account. I tested and can send to my gmail account from the t...@mycompany.commailto:t...@mycompany.com directly no problems. My Cold Fusion server is on a different server than my Exchange server. I've tested the mail settings in the Cold fusion admin and tried with and without TLS and the settings are fine. By default, your Exchange server won't proxy SMTP messages. You have to specifically configure it to do so. Messages to Exchange mailboxes on that server don't need to be proxied, so they get delivered. Thanks for the info, but my Exchange server is set up to send to the outside world. My send connector type is SMTP. I even tried relaying through my ISP as a smart host and still no sending to outside addresses from my Cold fusion Server. That doesn't mean that any server can relay through your Exchange server (I hope!). Typically, you have to enable relay for each individual IP address that you want to allow. In any case, you can verify this easily enough yourself. Open a telnet connection to your Exchange server from your CF server's console, and try to send an email that way. Google smtp telnet for more information on how to do that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:356720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfmail Exchange 2010
OK, this is weird. I can send fine to any email address from the account I set up t...@mycompany.commailto:t...@mycompany.com I'm doing a cfoutput query=emails and sending an email out to the people in my query. The emails are valid. However, only the people on the local Exchange server receive them. Anyone outside doesn't get them. I tested with my gmail account and I don't receive the email. But I get it on my exchange account. I tested and can send to my gmail account from the t...@mycompany.commailto:t...@mycompany.com directly no problems. My Cold Fusion server is on a different server than my Exchange server. I've tested the mail settings in the Cold fusion admin and tried with and without TLS and the settings are fine. Any help would be appreciated. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfmail Exchange 2010
Thanks for the info, but my Exchange server is set up to send to the outside world. My send connector type is SMTP. I even tried relaying through my ISP as a smart host and still no sending to outside addresses from my Cold fusion Server. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, September 04, 2013 5:18 PM To: cf-talk Subject: Re: cfmail Exchange 2010 OK, this is weird. I can send fine to any email address from the account I set up t...@mycompany.com mailto:t...@mycompany.com I'm doing a cfoutput query=emails and sending an email out to the people in my query. The emails are valid. However, only the people on the local Exchange server receive them. Anyone outside doesn't get them. I tested with my gmail account and I don't receive the email. But I get it on my exchange account. I tested and can send to my gmail account from the t...@mycompany.commailto:t...@mycompany.com directly no problems. My Cold Fusion server is on a different server than my Exchange server. I've tested the mail settings in the Cold fusion admin and tried with and without TLS and the settings are fine. By default, your Exchange server won't proxy SMTP messages. You have to specifically configure it to do so. Messages to Exchange mailboxes on that server don't need to be proxied, so they get delivered. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:356706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Syntax is driving me nuts!
Hey guys, I'm trying to add multiple items to a database based on if a check box is checked. This code works fine: cfif IsNumeric(#form['qty_' upd]#) But I want to make sure the box is checked or not. When I do this: cfif IsDefined(#form['rel_' ar]#) I get: Element rel_1 is undefined in a Java object of type class coldfusion.filter.FormScope. If I do this: cfif IsDefined(form['rel_' ar]) I get: Parameter 1 of function IsDefined, which is now form['rel_' ar], must be a syntactically valid variable name. I'm doing all this in a loop. The form's check boxes are defined as: rel_#currentrow#. Then I'm looping around them: cfloop index=ar from=1 to=#form.numrows# Numrows comes from the recordcount of the hidden form variable output query displaying the checkboxes. All I need to know is what the right syntax I need to use for IsDefined? Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Syntax is driving me nuts!
Thanks a lot guys. I still have a lot to learn about CF. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: DURETTE, STEVEN J [mailto:sd1...@att.com] Sent: Tuesday, August 20, 2013 12:56 PM To: cf-talk Subject: RE: Syntax is driving me nuts! Try structkeyexists cfif structKeyExists(Form, rel_ ar) If you really need to use isdefined, it would be: cfif isDefined(form.rel_ ar) Steve -Original Message- From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Tuesday, August 20, 2013 11:49 AM To: cf-talk Subject: Syntax is driving me nuts! Hey guys, I'm trying to add multiple items to a database based on if a check box is checked. This code works fine: cfif IsNumeric(#form['qty_' upd]#) But I want to make sure the box is checked or not. When I do this: cfif IsDefined(#form['rel_' ar]#) I get: Element rel_1 is undefined in a Java object of type class coldfusion.filter.FormScope. If I do this: cfif IsDefined(form['rel_' ar]) I get: Parameter 1 of function IsDefined, which is now form['rel_' ar], must be a syntactically valid variable name. I'm doing all this in a loop. The form's check boxes are defined as: rel_#currentrow#. Then I'm looping around them: cfloop index=ar from=1 to=#form.numrows# Numrows comes from the recordcount of the hidden form variable output query displaying the checkboxes. All I need to know is what the right syntax I need to use for IsDefined? Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Pausing a loop or query
Here's the situation. A client of mine has an email list he sends a flyer to once a month to about 5000 addresses. I need to pause after sending 250 so the server doesn't get flagged for spamming. What's the best way to do this? It's easy to do multiple queries of 250 rows each, but how can I pause for say 5 or 10mins in between? Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Pausing a loop or query
OK thanks guys. So similar to doing a cron job. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: Monday, August 19, 2013 12:13 PM To: cf-talk Subject: Re: Pausing a loop or query Kinda hacky, but: Use a db table/column for misc crap, or hell, even a server variable, and save something called: lastRow, 1 Do a SQL to get 250 addresses starting at row lastRow. Process your mail. When done, set lastRow to lastRow + 250. All of the above would be a CFM hit via cfschedule. On Mon, Aug 19, 2013 at 9:55 AM, Rick Sanders r...@webenergy.ca wrote: Here's the situation. A client of mine has an email list he sends a flyer to once a month to about 5000 addresses. I need to pause after sending 250 so the server doesn't get flagged for spamming. What's the best way to do this? It's easy to do multiple queries of 250 rows each, but how can I pause for say 5 or 10mins in between? Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
C-Panel
Hi Folks. I run a hosting company and need an interface like C-Panel. I was wondering if there were and snippets of code out there that have an interface to manage Windows accounts since my servers are windows based. Since I'm developing this myself I may be asking questions here, but I'm willing to share my work with you folks here in the community. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: C-Panel
Hi again Brian, I agree with you about windows. However, I haven't had enough experience with Linux servers in order to set one up for web hosting. I've been working with windows servers since NT 3.5. Windows can host Wordpress, PhP and any other web technology today. Until I absolutely have to set up a Linux server, my limited time is best served in other areas. WebSitePanel looks to be a good solution for what I need. I don't need billing, only file management. Thanks for the info on webhostingtalk.com too! Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Byron Mann [mailto:byronos...@gmail.com] Sent: Wednesday, July 10, 2013 11:22 AM To: cf-talk Subject: Re: C-Panel Having supported home-grown provisioning code for several years my suggestion would be to use something off the shelf. We implemented Parallels Automation and Billing last year and have drastically reduced our costs across the board, development, support, operations. We now only have one additional developer supporting our legacy applications, instead of 5, and most of his time is spent on new work. Next question is do you need billing and automation or just automation? WHMCS is a nice all in one solution a lot of smaller hosts seem to use for both provisioning and billing. It integrates with various control panels on the servers. Pretty inexpensive, limited a bit on services you can offer however. Windows and Linux should you decide to offer Linux in the future. WebSitePanel, OpenSource, .NET, backed by Microsoft. Windows Only, might be a bit difficult to implement Linux. Simple billing. Seems like it is not a very active project however. We started using this a while back just for provisioning and had to customize things quite a bit for how we wanted to do things. So a bit restrictive. We no longer use it. Parallels has taken Plesk to the next level and can now centrally manage Plesk servers: http://www.parallels.com/products/plesk-automation/, we are actually going to start offering this to our resellers. Windows and Linux. Provisioning only. Just need the Plesk management node actually, can connect to existing Plesk servers and can add new servers without Plesk. There is just an agent that runs on the remote machines. No Billing, Parallels has a new billing thing coming out next year specifically for this. Parallels Automation Billing, this is what we use for provisioning. This is their most comprehensive product and will provision just about everything a web host would probably need. You can just get the Automation component without billing. Expensive and does require Parallels implementation (and I would suggest training) as part of the purchase. Can also do fully branded resellers. If you stick with an in-house solution, use powershell scripts. I've found it to be the most flexible and reliable thing out there, plus there are a ton of scripts floating out there already. Windows hosting is shrinking with the advent of more good Control Panels that make Linux a no brainer. Not sure what your business model is, but I would consider this a future possibility. webhostingtalk.com is an excellent resource for hosters as well, if you aren't part of that community already. Byron Mann Lead Engineer Architect HostMySite.com On Wed, Jul 10, 2013 at 7:38 AM, Rick Sanders r...@webenergy.ca wrote: Hi Folks. I run a hosting company and need an interface like C-Panel. I was wondering if there were and snippets of code out there that have an interface to manage Windows accounts since my servers are windows based. Since I'm developing this myself I may be asking questions here, but I'm willing to share my work with you folks here in the community. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356158 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: C-Panel
Thanks for your input Ross. I'm installing it now on a test machine then I will implement it on our live server. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, July 10, 2013 12:14 PM To: cf-talk Subject: Re: C-Panel Fyi websitepanel is more active now, 2.0 released this year and 2.1 currently in beta, supports Windows 2012. Do not use its ecommerce system though it is awful, but the rest of it works really well. We use it for all our Windows hosting and I also use it for cfmldeveloper.com Russ Michaels www.michaels.me.uk On 10 Jul 2013 15:21, Byron Mann byronos...@gmail.com wrote: Having supported home-grown provisioning code for several years my suggestion would be to use something off the shelf. We implemented Parallels Automation and Billing last year and have drastically reduced our costs across the board, development, support, operations. We now only have one additional developer supporting our legacy applications, instead of 5, and most of his time is spent on new work. Next question is do you need billing and automation or just automation? WHMCS is a nice all in one solution a lot of smaller hosts seem to use for both provisioning and billing. It integrates with various control panels on the servers. Pretty inexpensive, limited a bit on services you can offer however. Windows and Linux should you decide to offer Linux in the future. WebSitePanel, OpenSource, .NET, backed by Microsoft. Windows Only, might be a bit difficult to implement Linux. Simple billing. Seems like it is not a very active project however. We started using this a while back just for provisioning and had to customize things quite a bit for how we wanted to do things. So a bit restrictive. We no longer use it. Parallels has taken Plesk to the next level and can now centrally manage Plesk servers: http://www.parallels.com/products/plesk-automation/, we are actually going to start offering this to our resellers. Windows and Linux. Provisioning only. Just need the Plesk management node actually, can connect to existing Plesk servers and can add new servers without Plesk. There is just an agent that runs on the remote machines. No Billing, Parallels has a new billing thing coming out next year specifically for this. Parallels Automation Billing, this is what we use for provisioning. This is their most comprehensive product and will provision just about everything a web host would probably need. You can just get the Automation component without billing. Expensive and does require Parallels implementation (and I would suggest training) as part of the purchase. Can also do fully branded resellers. If you stick with an in-house solution, use powershell scripts. I've found it to be the most flexible and reliable thing out there, plus there are a ton of scripts floating out there already. Windows hosting is shrinking with the advent of more good Control Panels that make Linux a no brainer. Not sure what your business model is, but I would consider this a future possibility. webhostingtalk.com is an excellent resource for hosters as well, if you aren't part of that community already. Byron Mann Lead Engineer Architect HostMySite.com On Wed, Jul 10, 2013 at 7:38 AM, Rick Sanders r...@webenergy.ca wrote: Hi Folks. I run a hosting company and need an interface like C-Panel. I was wondering if there were and snippets of code out there that have an interface to manage Windows accounts since my servers are windows based. Since I'm developing this myself I may be asking questions here, but I'm willing to share my work with you folks here in the community. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| 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:356160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Weird attack
Looks as if to me someone is using a javascript in the url of your sites to generate their own url. Either that or you have a virus, malware, proxy redirection or your DNS has been changed on your machine. It's worth it to do a scan at http://housecall.trendmicro.com even if you have an antivirus. Good luck. Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca -Original Message- From: Paul Stewart [mailto:p...@whichfranchise.com] Sent: Thursday, November 24, 2011 8:13 AM To: cf-talk Subject: Re: Weird attack On 24/11/2011 11:10, Russ Michaels wrote: or give Fuseguard a try http://foundeo.com/security/ On Thu, Nov 24, 2011 at 10:56 AM, Paul Stewartp...@whichfranchise.com wrote: On 18/11/2011 16:57, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote: Hi, Since a few days, I have all my sites receiving requests in which a string like /**/or/**/1=@@version)-- is added in the URL. Has someone any idea what this guy is actually trying to do ? ~| 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:348860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Outputting telephone numbers
Sorry for the newbie question. For the life of me I can't see anywhere how to output a telephone number from a database that stores a number like 2125551212 to display as (212) 555-1212. Thanks. Kind Regards, [WebLogomailsig] Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.cahttp://www.webenergy.ca/ ~| 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:347984 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Outputting telephone numbers
Thanks Andrew Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Thursday, October 06, 2011 12:52 PM To: cf-talk Subject: Re: Outputting telephone numbers If this format is fixed use NumberFormat with the mask. On Fri, Oct 7, 2011 at 2:48 AM, Rick Sanders r...@webenergy.ca wrote: Sorry for the newbie question. For the life of me I can't see anywhere how to output a telephone number from a database that stores a number like 2125551212 to display as (212) 555-1212. Thanks. Kind Regards, [WebLogomailsig] Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.cahttp://www.webenergy.ca/ ~| 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:347986 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Timing out a webpage
Thank you for your reply. This looks like a great solution on top of the java script. Have a good day. Rick Sanders Webenergy www.webenergy.ca -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, June 22, 2011 4:10 PM To: cf-talk Subject: Re: Timing out a webpage ...but note that Javascript can be turned off. So, in addition, you'd want to do something like this on page load (including first page where timer should start and last page that processes test): cfparam name=session.starttime default=#now()# cfif datediff(n, session.starttime, now()) GT 15 !--- run some test timed out code --- /cfif On Wed, Jun 22, 2011 at 2:02 PM, Russ Michaels r...@michaels.me.uk wrote: well you have 2 options. set your session timeout to 15 minutes, this will then mean they cannot sit on a page doing nothing for more than 15 minutes. If you want to time them for 15 minutes regardless of how many pages they load or refresh then you could create a Javascript timer, Google will garnish you with one of these. Russ On Wed, Jun 22, 2011 at 7:39 PM, John M Bliss bliss.j...@gmail.com wrote: Can the timeout check happen on a page load? Or do you need to have it happen while page is displayed? On Wed, Jun 22, 2011 at 1:32 PM, Rick Sanders r...@webenergy.ca wrote: Hey all. I have an online test that I want to timeout after 15mins. Does ColdFusion have a feature built-in to do this? It's my first time doing this sort of thing. Thanks. Kind Regards, WebLogomailsig Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca http://www.webenergy.ca/ ~| 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:345564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Timing out a webpage
Hey all. I have an online test that I want to timeout after 15mins. Does ColdFusion have a feature built-in to do this? It's my first time doing this sort of thing. Thanks. Kind Regards, WebLogomailsig Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca http://www.webenergy.ca/ ~| 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:345538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
decimals and variables
Hey all, I'm pulling up an integer from the database which is 15. This is a tax rate, so I need to get the tax on the subtotal. Say the #subtot# is 100 and #tx# is 15. cfset tax = #subtot# * .#tx# This should bring back the number 15. However, cf is throwing an error because of the decimal in front of the #tx#. cfset tax = #subtot# * .15 This works. However I need to pull from the database in case the tax rate changes. Rick ~| 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:342097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: decimals and variables
Thank you. this worked great. I didn't realize you had to convert it to a decimal in cf. -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Thursday, February 10, 2011 10:24 AM To: cf-talk Subject: RE: decimals and variables You need to do this: cfset tax = subtot * (tx / 100) / This actually converts the tx to a decimal. Also you don't need the #s in the cfset. :) Steve -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Thursday, February 10, 2011 9:14 AM To: cf-talk Subject: decimals and variables Hey all, I'm pulling up an integer from the database which is 15. This is a tax rate, so I need to get the tax on the subtotal. Say the #subtot# is 100 and #tx# is 15. cfset tax = #subtot# * .#tx# This should bring back the number 15. However, cf is throwing an error because of the decimal in front of the #tx#. cfset tax = #subtot# * .15 This works. However I need to pull from the database in case the tax rate changes. Rick ~| 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:342104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: decimals and variables
Yup, I certainly am! Paying the highest taxes in North America! lol! -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Thursday, February 10, 2011 10:33 AM To: cf-talk Subject: Re: decimals and variables Does this mean you are in Nova Scotia? On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote: Hey all, I'm pulling up an integer from the database which is 15. This is a tax rate, so I need to get the tax on the subtotal. Say the #subtot# is 100 and #tx# is 15. cfset tax = #subtot# * .#tx# This should bring back the number 15. However, cf is throwing an error because of the decimal in front of the #tx#. cfset tax = #subtot# * .15 This works. However I need to pull from the database in case the tax rate changes. Rick ~| 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:342107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: decimals and variables
I used to live in Kitchener back in 2006. You gas prices are cheaper than ours though! The gov didn't mention how long temporary was! -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Thursday, February 10, 2011 10:43 AM To: cf-talk Subject: Re: decimals and variables I come a close second. I'm in ON. Damn you Harper! Remember in the 80's when the GST was a temporary measure? On Thu, Feb 10, 2011 at 9:38 AM, Rick Sanders c...@webenergy.ca wrote: Yup, I certainly am! Paying the highest taxes in North America! lol! -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Thursday, February 10, 2011 10:33 AM To: cf-talk Subject: Re: decimals and variables Does this mean you are in Nova Scotia? On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote: Hey all, I'm pulling up an integer from the database which is 15. This is a tax rate, so I need to get the tax on the subtotal. Say the #subtot# is 100 and #tx# is 15. cfset tax = #subtot# * .#tx# This should bring back the number 15. However, cf is throwing an error because of the decimal in front of the #tx#. cfset tax = #subtot# * .15 This works. However I need to pull from the database in case the tax rate changes. Rick ~| 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:342111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Parsing RSS feeds
Hey all, I have code for parsing feeds that works very well on several feeds. cfhttp url=http://rss.cbc.ca/lineup/canada-novascotia.xml method=get/cfhttp cfset objRSS = xmlParse(cfhttp.filecontent) cfoutput#objRSS#/cfoutput cfdump var=#objRSS# However, when I use the same code to parse the following feed it causes an error: cfhttp url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp cfset objRSS = xmlParse(cfhttp.filecontent) cfoutput#objRSS#/cfoutput cfdump var=#objRSS# The error: Content is not allowed in prolog. The error occurred in E:\Websites\ConnectNS\testrss.cfm: line 11 9 : pEmpire Theatres RSS:/p 10 : cfhttp url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp 11 : cfset objRSS = xmlParse(cfhttp.filecontent) 12 : cfoutput#objRSS#/cfoutput 13 : cfdump var=#objRSS# Can anyone help point me in the right direction? I'm perplexed! Google, Yahoo, and the browser parse the feed fne! Thanks, Rick Webenergy www.webenergy.ca ~| 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:341286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Parsing RSS feeds
I found the answer after some trial and error and digging around! It turns out, this character which is creating problem is something called as Byte-Order-Mark and in an XML document, it is used to flag the encoding type of the XML. Unfortunately, ColdFusion does not appreciate the use of this Byte-Order-Mark, or BOM. In order to get this kind of XML feed to play nicely with ColdFusion, we have to remove the BOM before we parse the document. Luckily, getting rid of this requires nothing more than a simple regular expression that strips out all characters before the first bracket. Source and credit goes to: http://blog.webvirtue.com/2009/05/coldfusion-xml-parsing.html Finally here is the code that worked: cfhttp url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp cfset RSS = REReplace( cfhttp.filecontent, ^[^]*, , all ) cfset objRSS = xmlParse(RSS) Rick Webenergy www.webenergy.ca -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Tuesday, January 25, 2011 10:57 PM To: cf-talk Subject: Parsing RSS feeds Hey all, I have code for parsing feeds that works very well on several feeds. cfhttp url=http://rss.cbc.ca/lineup/canada-novascotia.xml method=get/cfhttp cfset objRSS = xmlParse(cfhttp.filecontent) cfoutput#objRSS#/cfoutput cfdump var=#objRSS# However, when I use the same code to parse the following feed it causes an error: cfhttp url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp cfset objRSS = xmlParse(cfhttp.filecontent) cfoutput#objRSS#/cfoutput cfdump var=#objRSS# The error: Content is not allowed in prolog. The error occurred in E:\Websites\ConnectNS\testrss.cfm: line 11 9 : pEmpire Theatres RSS:/p 10 : cfhttp url=http://www.empiretheatres.com/rss/showtimes/43; method=get/cfhttp 11 : cfset objRSS = xmlParse(cfhttp.filecontent) 12 : cfoutput#objRSS#/cfoutput 13 : cfdump var=#objRSS# Can anyone help point me in the right direction? I'm perplexed! Google, Yahoo, and the browser parse the feed fne! Thanks, Rick Webenergy www.webenergy.ca ~| 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:341296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Writing cfml content to an html file
Hey all, I'm trying to take some cfml content and write it to an html file using cffile. The cfml content has queries etc I'm getting all kinds of errors. Is there any way I can just get the cffile tag to write exactly what I want to the file parsing the cfml content? Error example: Invalid CFML construct found on line 18 at column 303. ColdFusion was looking at the following text: # The CFML compiler was processing: * A cffile tag beginning on line 1, column 2. The error occurred in E:\Websites\nscomputers\emailquote.cfm: line 18 16 : /tr 17 : cfquery name=sys datasource=nscomputers 18 : SELECT S1.SystemID,S1.SessionID,S1.CPU,S1.RAM,S1.RAMqty,S1.MB,S1.HD,S1.HDqty,S1.Tow er,S1.Optical,S1.Video,S1.OS,S1.Keyboard,S1.Mouse,S1.Monitor,S1.Printer,S1.S peaker,S1.acc1,S1.acc2,S1.acc3,S1.acc4,S1.acc5,S1.acc6,S1.acc7,S1.acc8,S1.Su bTotal,S1.CreatedBy FROM dbo.SystemBuilder S1 WHERE (S1.SessionID='#cookie.sid#') 19 : /cfquery ~| 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:338424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Writing cfml content to an html file
Sorry, I am writing to a cfm file. I tried escaping the # with ##variable## and it still throws the same error. -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Thursday, October 21, 2010 11:31 AM To: cf-talk Subject: Re: Writing cfml content to an html file Right. Also, if you use cffile to write CFML to a file, then the file you're writing to should be a .cfm file (unless you have your server configured to pass .htm files to the CF server). On Thu, Oct 21, 2010 at 9:27 AM, Andy Matthews li...@commadelimited.comwrote: You shouldn't have any problems writing CFML code to a page. The error you're getting is likely from your hashmarks not being escaped. andy -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Thursday, October 21, 2010 9:23 AM To: cf-talk Subject: Writing cfml content to an html file Hey all, I'm trying to take some cfml content and write it to an html file using cffile. The cfml content has queries etc I'm getting all kinds of errors. Is there any way I can just get the cffile tag to write exactly what I want to the file parsing the cfml content? Error example: Invalid CFML construct found on line 18 at column 303. ColdFusion was looking at the following text: # The CFML compiler was processing: * A cffile tag beginning on line 1, column 2. The error occurred in E:\Websites\nscomputers\emailquote.cfm: line 18 16 : /tr 17 : cfquery name=sys datasource=nscomputers 18 : SELECT S1.SystemID,S1.SessionID,S1.CPU,S1.RAM,S1.RAMqty,S1.MB,S1.HD,S1.HDqty,S1.Tow er,S1.Optical,S1.Video,S1.OS,S1.Keyboard,S1.Mouse,S1.Monitor,S1.Printer,S1.S peaker,S1.acc1,S1.acc2,S1.acc3,S1.acc4,S1.acc5,S1.acc6,S1.acc7,S1.acc8,S1.Su bTotal,S1.CreatedBy FROM dbo.SystemBuilder S1 WHERE (S1.SessionID='#cookie.sid#') 19 : /cfquery ~| 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:338430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Writing cfml content to an html file
Perfect, thanks! This is exactly what I was looking for. Still haven't totally got used to Cold Fusion yet. I was using Tang (Witango), and the file write action didn't require additional formatting because it doesn't use ## symbols. Rick -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Thursday, October 21, 2010 11:33 AM To: cf-talk Subject: RE: Writing cfml content to an html file Break this down into steps. 1. Get you code and queries correct to the can generate output to the screen 2. Then move that code inside a savecontent tag and write the content to a variable cfcontent reset=truecfsavecontent variable=my_variable_nameMY CODE TO MAKE THE OUTPUT HERE/cfsavecontent 3. Then write the variable content to a file: cffile action=write file=MYPATH\MYFILENAME output=# my_variable_name # That should help. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Thursday, October 21, 2010 10:23 AM To: cf-talk Subject: Writing cfml content to an html file Hey all, I'm trying to take some cfml content and write it to an html file using cffile. The cfml content has queries etc I'm getting all kinds of errors. Is there any way I can just get the cffile tag to write exactly what I want to the file parsing the cfml content? Error example: Invalid CFML construct found on line 18 at column 303. ColdFusion was looking at the following text: # The CFML compiler was processing: * A cffile tag beginning on line 1, column 2. The error occurred in E:\Websites\nscomputers\emailquote.cfm: line 18 16 : /tr 17 : cfquery name=sys datasource=nscomputers 18 : SELECT S1.SystemID,S1.SessionID,S1.CPU,S1.RAM,S1.RAMqty,S1.MB,S1.HD,S1.HDqty,S1.Tow er,S1.Optical,S1.Video,S1.OS,S1.Keyboard,S1.Mouse,S1.Monitor,S1.Printer,S1.S peaker,S1.acc1,S1.acc2,S1.acc3,S1.acc4,S1.acc5,S1.acc6,S1.acc7,S1.acc8,S1.Su bTotal,S1.CreatedBy FROM dbo.SystemBuilder S1 WHERE (S1.SessionID='#cookie.sid#') 19 : /cfquery ~| 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:338431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Totaling items in a recordet
Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
totaling items in a recordset
Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: totaling items in a recordset
Thanks! I'm used to another programming language where the db query is actually stored in a temporary array, then I can easily total the array with a built-in function. The example you gave is helpful and I've used it before when totaling something. This works for my current application! Thanks, Rick -Original Message- From: David McGraw [mailto:david.mcg...@gmail.com] Sent: Tuesday, October 19, 2010 4:24 PM To: cf-talk Subject: Re: totaling items in a recordset Actually... the best way would be to use a query of queries... cfquery name=priceTotal dbtype=querySELECT SUM(prices) as result FROM query/cfquery cfoutput#priceTotal.result#/cfoutput Again this is all assuming you don't want just the total and still need the individual items from the DB. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 19, 2010 at 3:18 PM, Rick Sanders c...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Totaling items in a recordet
This is something along the lines of what I was looking for. Now, is there a way to display the full array and have the totaled column as well? Kind regards, Rick -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, October 19, 2010 4:26 PM To: cf-talk Subject: Re: Totaling items in a recordet The best way would be to sum() it in the query itself. Failing that you can get the list of values, set it to an array, then sum it. #arraysum(listtoarray(valuelist(query.column)))# On Tue, Oct 19, 2010 at 3:16 PM, Rick Sanders r...@webenergy.ca wrote: Hey all. I am pulling prices from a database and want to total them. Is there a function like #total(query.column)# ? Kind Regards, Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca ~| 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:338332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfif contains
How can I do a cfif contains? Error I am getting: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. The error occurred in E:\Websites\nscomputers\systembuilder2.cfm: line 6 4 : cfif #Trim(cpu.description)# contains AMD 5 : cfset cpu = AMD 6 : cfif #Trim(cpu.description)# contains AM2 I hope someone can shed some light on this. thanks! Rick ~| 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:338258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfif contains
Thanks! I realized what I did afterwards. Just coping and pasting code isn't the best way to do things always. I re-coded it and it works great thanks! Rick -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Sunday, October 17, 2010 6:06 PM To: cf-talk Subject: Re: cfif contains 1. No need for # inside the cfif. :) 2. You shouldn't need to trim it if you use a contains. 3. You set CPU to a single value of AMD. Therefore, cpu.description doesn't exist anymore. On Sun, Oct 17, 2010 at 2:03 PM, Rick Sanders c...@webenergy.ca wrote: How can I do a cfif contains? Error I am getting: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. The error occurred in E:\Websites\nscomputers\systembuilder2.cfm: line 6 4 : cfif #Trim(cpu.description)# contains AMD 5 : cfset cpu = AMD 6 : cfif #Trim(cpu.description)# contains AM2 I hope someone can shed some light on this. thanks! Rick ~| 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:338260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Reading text files
Nice to see some people still have a sense of humor! Rick Sanders Webenergy www.webenergy.ca -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, October 01, 2010 2:34 PM To: cf-talk Subject: Re: Reading text files what about make coffee, and bring my slippers and the morning paper. If it could do that CF would truly rock. I don't know if CF can do that. Java can do that, but if you're not extremely careful, you'll end up drinking the outflow from the toilet, getting your feet cut off and having the paper stuffed up your ass. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Chat or IM program
Hey all, I was wondering if there is a chat or IM program out there in CF similar to Facebook. It's for a dating website. Coding this from scratch would take awhile so if someone knows of anything let me know. Thanks, Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Chat or IM program
Thanks, but if there's something out there already that I can build on it would be much quicker. There's alot of open source PhP and .net stuff out there so I was hoping for something in CF. I'm on a time constraint with a project. Rick -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Friday, September 17, 2010 9:21 AM To: cf-talk Subject: RE: Chat or IM program I have to say that these are the easiest of things to program, especially with Enterprise and gateways. But just as easy with ExtJS or JQuery in standard editions. The basics are sending and receive, and who receives. The client is this easiest part and the server side is not as hard and just needs to know who to push the info too. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Friday, 17 September 2010 10:10 PM To: cf-talk Subject: Chat or IM program Hey all, I was wondering if there is a chat or IM program out there in CF similar to Facebook. It's for a dating website. Coding this from scratch would take awhile so if someone knows of anything let me know. Thanks, Rick ~~ ~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:337174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Chat or IM program
Thanks but I don't want a third party hosting the chat for me. I want to host it and link it with my database of existing users so when they login to the site, they get logged in to the chat as well. I already looked on Google and all I found was thousands of companies that offer chat software but they host it. Some are Java, some are not. If anyone has a better direction to point me in, please let me know. Rick -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, September 17, 2010 10:25 AM To: cf-talk Subject: Re: Chat or IM program Wondering if something like this might be up your alley... http://www.forta.com/blog/index.cfm/2007/2/12/ColdFusion-IM-Gateways-Power-I Mified http://www.imified.com/ IMified http://www.imified.com/ is an IM based productivity tool that works across all the major networks and offers access to a number of popular web applications, as well as tools like notes, reminders, and to-do's all in your favorite IM client. The service just launched on February 5th, and has been adding lots and lots of users, and getting lots of positive feedback. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Chat or IM program
Russ, I am actually waiting for the confirmation email to activate my account to try the IM bot. Thanks, Rick -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, September 17, 2010 1:55 PM To: cf-talk Subject: Re: Chat or IM program Rick, did you actually look at the coldfusion solution I gave ? On Fri, Sep 17, 2010 at 4:06 PM, Rick Sanders c...@webenergy.ca wrote: Thanks but I don't want a third party hosting the chat for me. I want to host it and link it with my database of existing users so when they login to the site, they get logged in to the chat as well. I already looked on Google and all I found was thousands of companies that offer chat software but they host it. Some are Java, some are not. If anyone has a better direction to point me in, please let me know. Rick -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, September 17, 2010 10:25 AM To: cf-talk Subject: Re: Chat or IM program Wondering if something like this might be up your alley... http://www.forta.com/blog/index.cfm/2007/2/12/ColdFusion-IM-Gateways-Power-I Mified http://www.imified.com/ IMified http://www.imified.com/ is an IM based productivity tool that works across all the major networks and offers access to a number of popular web applications, as well as tools like notes, reminders, and to-do's all in your favorite IM client. The service just launched on February 5th, and has been adding lots and lots of users, and getting lots of positive feedback. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Chat or IM program
Thanks James. I didn't think to search coldfusion chat. I searched up hundereds of java ones. Rick -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, September 17, 2010 12:58 PM To: cf-talk Subject: Re: Chat or IM program Fourth link down searching for coldfusion chat room on Google: http://www.opensourcecf.com/cfopenchat/ -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 17 September 2010 23:06, Rick Sanders c...@webenergy.ca wrote: Thanks but I don't want a third party hosting the chat for me. I want to host it and link it with my database of existing users so when they login to the site, they get logged in to the chat as well. I already looked on Google and all I found was thousands of companies that offer chat software but they host it. Some are Java, some are not. If anyone has a better direction to point me in, please let me know. Rick -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, September 17, 2010 10:25 AM To: cf-talk Subject: Re: Chat or IM program Wondering if something like this might be up your alley... http://www.forta.com/blog/index.cfm/2007/2/12/ColdFusion-IM-Gateways-Power-I Mified http://www.imified.com/ IMified http://www.imified.com/ is an IM based productivity tool that works across all the major networks and offers access to a number of popular web applications, as well as tools like notes, reminders, and to-do's all in your favorite IM client. The service just launched on February 5th, and has been adding lots and lots of users, and getting lots of positive feedback. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Extracting part of a string
Hey All, What I need is simple, but I'm struggling with how to do it. I want to extract everything between [y] and [/y] example: [y] http://www.youtube.com/watch?v=uBV00ZGkRJ0[/y] I just want to extract the URL between the opening and closing y tags. Thanks! Rick Sanders www.webenergy.ca ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Extracting part of a string
Thank you Andy, this was most helpful! -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Tuesday, July 20, 2010 11:49 AM To: cf-talk Subject: RE: Extracting part of a string Assuming there's nothing more to your search, then this regex would do you fine: \[y\](.+)\[/y\] -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Tuesday, July 20, 2010 9:23 AM To: cf-talk Subject: Extracting part of a string Hey All, What I need is simple, but I'm struggling with how to do it. I want to extract everything between [y] and [/y] example: [y] http://www.youtube.com/watch?v=uBV00ZGkRJ0[/y] I just want to extract the URL between the opening and closing y tags. Thanks! Rick Sanders www.webenergy.ca ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Facebook Connect and coldfusion
Awesome! Thank you for posting this! Rick Sanders Webenergy www.webenergy.ca -Original Message- From: Jeff Gladnick [mailto:jeff.gladn...@gmail.com] Sent: Monday, July 19, 2010 8:16 PM To: cf-talk Subject: Re: Facebook Connect and coldfusion I finally got this roughly working using some different code: http://facebookgraph.riaforge.org/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Remove html characters
Hey all, What's the best way to remove html characters and make something plain text? reReplace? Thanks, Rick Webenergy ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Remove html characters
That's what I thought. I would have to put all the tags in there I want to remove like div, strong, font, etc... Thanks. -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Tuesday, May 18, 2010 10:57 AM To: cf-talk Subject: RE: Remove html characters Try this... cfset html = 'pa href=test with link/a /p' cfset withoutHtml = REReplaceNoCase(html,a .*(href=[']?)([^' ]+)[' ][^]+([^]+)/a,\3: \2,all) cfset withoutHtml = REReplaceNoCase(withoutHtml,p[^]*,Chr(10),all) cfset withoutHtml = REReplaceNoCase(withoutHtml,[^]+,,all) cfoutput#withoutHtml#/cfoutput Paul Alkema http://Paulalkema.com/ -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Tuesday, May 18, 2010 9:38 AM To: cf-talk Subject: Remove html characters Hey all, What's the best way to remove html characters and make something plain text? reReplace? Thanks, Rick Webenergy ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Error trapping
Hey all, I've tried using the cferror tag and having the error emailed to me but instead it throws an http 500 error and the error doesn't get emailed. What's the easiest way to have an error on a cfm page trapped, emailed, and then redirected to an error page? Thanks, Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Joomla?
I am curious to know if there's any Open-source free ColdFusion CMS out there like Joomla? Joomla is the latest craze in CMS making it easy for people to manage their own websites. I'm wondering if there's anything comparable in CF? Currently I build my own CMS depending on the site I'm doing for my client. Thanks Rick Webenergy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Joomla?
Hey thanks for the link! I just don't like losing to Joomla because of the fact it's free and many not for profits use it. -Original Message- From: Jordan Michaels [mailto:jor...@viviotech.net] Sent: Monday, April 19, 2010 9:40 PM To: cf-talk Subject: Re: Joomla? +1 for Mura. Great CMS system and a great price too! (free) http://www.getmura.com/ Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions Rick Mason wrote: Take a look at Mura. Not as full featured yet but its only a little over a year old. On Apr 19, 2010 8:00 PM, Rick Sanders c...@webenergy.ca wrote: I am curious to know if there's any Open-source free ColdFusion CMS out there like Joomla? Joomla is the latest craze in CMS making it easy for people to manage their own websites. I'm wondering if there's anything comparable in CF? Currently I build my own CMS depending on the site I'm doing for my client. Thanks Rick Webenergy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
http header
I need to assign the http header to export a document to excel from the web. Here's an example from another programming language. I assign a variable called httpHeader and it changes the http header to an excel document. How can I do the same thing in Cold Fusion? HTTP/1.0 200 OK@CRLFContent-Disposition: attachment;filename=mydoc.xls@CRLFContent-Type: application/msexcel@CRLFCache-control: private@CRLF@CRLF Thanks, Rick Sanders Webenergy www.webenergy.ca ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: http header
Thank you! This was very helpful for me to get the proper syntax! -Original Message- From: Wil Genovese [mailto:jugg...@visi.com] Sent: Monday, April 05, 2010 11:59 AM To: cf-talk Subject: Re: http header I normally push MP3 files including sending the filesize so the browser knows how much there is to download and can display the status correctly. So I just swapped out the values for your excel file and this should work for you. cfset filename = mydoc.xls cfset foldername = [path to file] cfdirectory action=list directory=#foldername# filter=#filename# name=fileSize cfheader name=Content-Disposition value=Attachment; filename=#filename# cfheader name=Expires value=#Now()# cfheader name=Content-Length value=#fileSize.size# cfcontent type=application/msexcel file=#foldername##filename# deletefile=No Wil Genovese http://www.trunkful.com On Mon, Apr 5, 2010 at 8:53 AM, Dave Watts dwa...@figleaf.com wrote: I need to assign the http header to export a document to excel from the web. Here's an example from another programming language. I assign a variable called httpHeader and it changes the http header to an excel document. How can I do the same thing in Cold Fusion? HTTP/1.0 200 OK@CRLFContent-Disposition: attachment;filename=mydoc.xls@CRLFContent-Type: application/msexcel@CRLFCache-control: private@CRLF@CRLF You can use the CFCONTENT and CFHEADER tags to do this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
java.lang.String as a structure with members
I've done this a dozen times before, and now the following code gives me this error: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. This is the line throwing the error: cfset logo1 = #Trim(t1.Logo)# The logo being pulled from the database is just the image name logo.jpg cfquery name=Games datasource=hockey SELECT Team1, Team2, GameDate, GameTime, Location, Comments FROM Games where (GameID=#url.gameid#) /cfquery cfset team1 = #Games.Team1# cfquery name=t1 datasource=hockey SELECT Team,Logo FROM Teams WHERE (TeamID=#team1#) /cfquery cfset t1 = #Trim(t1.Team)# cfset logo1 = #Trim(t1.Logo)# Thanks, Rick Webenergy www.webenergy.ca ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: java.lang.String as a structure with members
Thanks, I realized it after I saw I didn't have the cfoutput tags after the queries! Rick -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Monday, April 05, 2010 4:34 PM To: cf-talk Subject: Re: java.lang.String as a structure with members Your query assumes that there is only one row expected. What happens when you put the cfset inside of a cfoutput query tag? How many records are there? See my modified markup below. cfquery name=Games datasource=hockey SELECT Team1, Team2, GameDate, GameTime, Location, Comments FROM Games where (GameID=#url.gameid#) /cfquery cfoutput query=Games cfset team1 = #Games.Team1# cfquery name=t1 datasource=hockey SELECT Team,Logo FROM Teams WHERE (TeamID=#team1#) /cfquery cfoutput query=Games cfset t1 = #Trim(t1.Team)# cfset logo1 = #Trim(t1.Logo)# /cfoutput /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: IE8 is killing my website
This seems to only be a problem on Windows XP. Myself nor my clients have problems with IE8 on Vista or Windows 7. Are your users on a network on an Active Directory domain with a domain policy? If the Server hasn't been updated with the new IE8 policies, then it defaults to the IE7 policies which are different than IE8. In the Internet options, particularly the Privacy tab, the Medium setting restricts 1st party cookies that save information that can be used to contact you without consent. This setting is default in IE8. If you're using an older version of CF server than 8, it may be time to think about upgrading. I have not had any issues with IE8 on any Windows platform with 1st party cookies. Rick Sanders Canada: 902-431-7279 USA: 919-799-9076 www.webenergy.ca -Original Message- From: subscripti...@advantex.net [mailto:subscripti...@advantex.net] Sent: Tuesday, February 02, 2010 1:34 PM To: cf-talk Subject: IE8 is killing my website The curse of the Microsoft browsers continues. This time, it's not even a design issue, it's a functional issue, and it's ruining our user experience. Plainly put, a certain subset of IE8 users are unable to log in to our site. Mind you, this is a signup/login process that has worked, literally for years. Along comes IE8, and suddenly there has to be a problem. It appears that IE8 is not storing our cookies, that track a successful login. Every other browser works fine. Some group of IE8 users, however, get our successful login screen, but when they click to go to a members area of the site, they are NOT logged in. We've done everything, including the setup of a P3P policy. This should work, for everyone, but it does not. I'm at my wits end here, and embarrassed as hell that I can't figure out what this issue is. I can't even reproduce it here, but I've seen it happen via remote desktop on some (gracious) member's PCs. We've tried telling them to check their security settings, clear cache, clear cookies, and more. But damn, they shouldn't HAVE to do all this stuff. Not this many people (and growing). They can accept cookies and view other sites (presumably), just not ours. I need ideas... fast. Can I solicit the help of the CF community on this? I have no idea where else to look. Thanks, Marc ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: hosting
We also host CF: http://host.webenergy.ca/plans.htm Executive Plan is for CF -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: January-14-10 11:01 AM To: cf-talk Subject: Re: hosting http://hostek.com/ Plans start $5 I have hosted with them on a couple of sites. Over all I was pleased. They have good support for the price. Much better than I expected. They will work to keep your business (or did with me) They also have CF 9. HTH On Thu, Jan 14, 2010 at 9:40 AM, Scott Stewart sstwebwo...@bellsouth.netwrote: Ray, I appreciate the sentiment, but right now cheap is all I can do -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Thursday, January 14, 2010 9:20 AM To: cf-talk Subject: Re: hosting Please consider how cheap you want to go. Your host is like the foundation of your business. Would you set up your store on top of a volcano? Quicksand? Cheap isn't always the way you want to go for hosts. On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com wrote: I've used atoz before, and it was just an aweful experience all around. I'd vote no to atoz. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Load-balancing servers
I have 2 Cold Fusion Enterprise servers. What I would like to do is balance the load between 2 machines, and maybe more in the future. I have a very large and demanding portal app that is going live soon. I've looked over the documentation and it doesn't seem to cover much about it. Can anyone offer some insight on this? I know I'll have to change any absolute paths to UNC paths and set up any ODBC databases, but is there anything else from the app side I need to do? Thanks! Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Load-balancing servers
Thanks Shannon but I'm running on Windows Server. Rick -Original Message- From: Shannon Peevey [mailto:spee...@stolaf.edu] Sent: December-10-09 12:26 PM To: cf-talk Subject: Re: Load-balancing servers Here is a couple of Clustering FAQs that I wrote back in 2007, which may have some points of interest for you: http://speeves.erikin.com/2007/02/how-to-setup-apache-2-with-coldfusion-7.ht ml http://speeves.erikin.com/2007/01/coldfusion-clustering-faq.html speeves On Thu, Dec 10, 2009 at 9:52 AM, WebSite CFTalk cft...@website.no wrote: Maybe something like: - Hardware load balancer in front of web/app servers, or NLB load balancing between web/app servers (Windows) - Instead of UNC path to shared folders synchronize web folders/content folders using DFS Replication (Windows 2003 R2 - Windows 2008) - If windows 2008, IIS 7.5 with shared config. Clustering CF is covered many places, this one is good and thorough: http://www.bpurcell.org/viewContent.cfm?ContentID=121 -Helge -Original Message- From: Rick Sanders [mailto:r...@webenergy.ca] Sent: 10. desember 2009 15:59 To: cf-talk Subject: Load-balancing servers I have 2 Cold Fusion Enterprise servers. What I would like to do is balance the load between 2 machines, and maybe more in the future. I have a very large and demanding portal app that is going live soon. I've looked over the documentation and it doesn't seem to cover much about it. Can anyone offer some insight on this? I know I'll have to change any absolute paths to UNC paths and set up any ODBC databases, but is there anything else from the app side I need to do? Thanks! Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Load-balancing servers
Hi Mark, I only use cookies for client sessions. I've had too many issues with people stealing sessions. As for files, I keep the files on one server and will just convert the absolute paths to unc paths. I'm running full 1gb on the internal network and the servers are brand-new so I don't forsee an issue with speed or bandwidth. The only thing the cf server does is serve the website. Database, email, and load-balancing servers are all separate machines. Rick -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: December-10-09 12:05 PM To: cf-talk Subject: RE: Load-balancing servers Rick, The questions to ask are - what are you doing with session variabls and client variables, and .. What are the capabilities of your chosen load balancing method. Remember that the potential here is for a user to bounce back and forth between your servers while surfing your site - so you have to be able to imagine the impact of that on the user. Will he lose his session? Will that matter? Etc. If you are using a hardware load balancer they typically come with choices to help mitigate these issues (like sticky sessions for example). As for files - you have to be able to either sync files between the servers or use a shared file storage - and there are trade offs to each of these approaches. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Thursday, December 10, 2009 8:59 AM To: cf-talk Subject: Load-balancing servers I have 2 Cold Fusion Enterprise servers. What I would like to do is balance the load between 2 machines, and maybe more in the future. I have a very large and demanding portal app that is going live soon. I've looked over the documentation and it doesn't seem to cover much about it. Can anyone offer some insight on this? I know I'll have to change any absolute paths to UNC paths and set up any ODBC databases, but is there anything else from the app side I need to do? Thanks! Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Load-balancing servers
Thank you! This is very helpful! Rick -Original Message- From: WebSite CFTalk [mailto:cft...@website.no] Sent: December-10-09 11:53 AM To: cf-talk Subject: RE: Load-balancing servers Maybe something like: - Hardware load balancer in front of web/app servers, or NLB load balancing between web/app servers (Windows) - Instead of UNC path to shared folders synchronize web folders/content folders using DFS Replication (Windows 2003 R2 - Windows 2008) - If windows 2008, IIS 7.5 with shared config. Clustering CF is covered many places, this one is good and thorough: http://www.bpurcell.org/viewContent.cfm?ContentID=121 -Helge -Original Message- From: Rick Sanders [mailto:r...@webenergy.ca] Sent: 10. desember 2009 15:59 To: cf-talk Subject: Load-balancing servers I have 2 Cold Fusion Enterprise servers. What I would like to do is balance the load between 2 machines, and maybe more in the future. I have a very large and demanding portal app that is going live soon. I've looked over the documentation and it doesn't seem to cover much about it. Can anyone offer some insight on this? I know I'll have to change any absolute paths to UNC paths and set up any ODBC databases, but is there anything else from the app side I need to do? Thanks! Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Custom scopes
Hey All. Quick question, can I define custom scopes for my variables in CF? Example: cfset myscope.var = myvar I've searched the documentation and didn't see anything on it. Thanks, Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326456 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Custom scopes
Thanks. Makes sense I have to create the scope before assigning a var to it! -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: September-21-09 1:50 PM To: cf-talk Subject: Re: Custom scopes In other words, you're implicitly creating a structure called 'myscope' with a key called 'var' (and then that structure gets put into the local/variables scope anyways). On Mon, Sep 21, 2009 at 9:46 AM, Alan Rother alan.rot...@gmail.com wrote: Of course. However... what you have really done is create a variable called variables.myscope.var =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Custom scopes
I have 2 forums I want to host in CF on one server and the vars are shared. So if I put both forums on the server, the vars will interchange between the 2 forums even if they are on different domains. So instead of going and changing all the names of the vars in the application scope, I would just assign the vars to a new scope and call them from there. Easy find/replace in DW that takes a minute and fixes the issue. It's cfbb. Rick -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: September-21-09 2:43 PM To: cf-talk Subject: Re: Custom scopes No, you don't have to create the 'scope' first. Just saying: cfset myScope.name = Charlie / will implictly create a struct called myScope with a key of name. but, as Cameron points out... referring to this as a custom scope will likely lead to confusion. Might be a good idea to back up a step or two and ask why you're looking to do this? On Mon, Sep 21, 2009 at 10:30 AM, Rick Sanders c...@webenergy.ca wrote: Thanks. Makes sense I have to create the scope before assigning a var to it! -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: September-21-09 1:50 PM To: cf-talk Subject: Re: Custom scopes In other words, you're implicitly creating a structure called 'myscope' with a key called 'var' (and then that structure gets put into the local/variables scope anyways). On Mon, Sep 21, 2009 at 9:46 AM, Alan Rother alan.rot...@gmail.com wrote: Of course. However... what you have really done is create a variable called variables.myscope.var =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Replacing characters in a string
Hey all, I'm trying to replace a hyperlink and just display the text. I need to remove the a href=http://www.google.ca;www.google.ca http://www.google.ca%3c/a /a from text within fckeditor and just display the text www.google.ca I tried finding a setting for the editor so it doesn't automatically create hyperlinks when you type www. Or http:// but didn't see such a setting. Here's what I have so far: cfset ad = Replace(#form.addesc#, http://,;) cfset ad2 = Replace(#ad#, a href=#chr(34)#,) cfset ad3 = Replace(#ad2#, #chr(34)#,) cfset ad4 = Replace(#ad3#, /a,) cfoutput#ad4#/cfoutput It works, but it duplicates the link. How can I remove the duplicate? Thanks, Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Replacing characters in a string
Hello Andy Jason, Thank you so much, this worked well. I wasn't sure of the syntax so this really helped. Kind regards, Rick -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: August-19-09 6:19 PM To: cf-talk Subject: RE: Replacing characters in a string Just so you know, this is what that expression is doing: / - literal string ? - zero or one a - literal string [^] - character set which says everything BUT * - zero or more times - literal string So the expression says 1) Look for a 2) With zero or one / 3) Followed by a 4) Any character (but ) any number of times 5) Followed by a This wouldn't match anchor tags with upper case, but could be changed like so: /?[a|A][^]* And I think it might be best to use a lazy match: /?[a|A][^]+ The plus says one or more rather than zero or more like the kleene star. Andy matthews -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, August 19, 2009 2:38 PM To: cf-talk Subject: re: Replacing characters in a string Try this: cfset ad = reReplace(form.addesc, (/?a[^]*), , all) / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Invalid parameter binding - again!
Hey all, I've tried adding params on all fields, then only some. I've changed the type from clob to varchar to char.. I still get the same error. Help please, thanks! cfquery name=bus datasource=ConnectNS INSERT INTO dbo.Businesses INSERT INTO dbo.Businesses (CountyID,CityID,CategoryID,SubCatID,SubCat2ID,BusinessName,Address,Zip,Tele phone,Fax,Email,Website,TypeID,DateListed,Paid) VALUES (#county.countyid#,#form.city#,#form.combo0#,#form.combo1#,#form.combo2#,'c fqueryparam value=#FORM.compname# cfsqltype=cf_sql_clob maxlength=25','cfqueryparam value=form.address cfsqltype=CF_SQL_VARCHAR','cfqueryparam value=form.zip cfsqltype=CF_SQL_VARCHAR','#form.area#-#form.prefix#-#form.suffix#','#for m.farea#-#form.fprefix#-#form.fsuffix#','cfqueryparam value=form.email cfsqltype=CF_SQL_VARCHAR','cfqueryparam value=form.website cfsqltype=CF_SQL_VARCHAR',2,'#today#','No') /cfquery Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Invalid parameter binding - again! ignore
Hey all, I found the problem. Seems just posting the question fixed it, lol! Rick Sanders ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Invalid parameter binding - again!
Thanks. I did have it right, but I was trying different things to get it to work to the query got messed up. I did end up figuring it out though. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-28-09 5:09 PM To: cf-talk Subject: re: Invalid parameter binding - again! Don't put ' marks around CFQUERYPARAM ... it already handles that for you. Also, you were missing pound signs around several of the params. INSERT INTO dbo.Businesses ( CountyID, CityID, CategoryID, SubCatID, SubCat2ID, BusinessName, Address, Zip, Tele phone, Fax, Email, Website, TypeID, DateListed, Paid ) VALUES ( #county.countyid#, #form.city#, #form.combo0#, #form.combo1#, #form.combo2#, cfqueryparam value=#FORM.compname# cfsqltype=cf_sql_varchar maxlength=25, cfqueryparam value=#form.address# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#form.zip# cfsqltype=CF_SQL_VARCHAR, '#form.area#-#form.prefix#-#form.suffix#', '#form.farea#-#form.fprefix#-#form.fsuffix#', cfqueryparam value=#form.email# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#form.website# cfsqltype=CF_SQL_VARCHAR, 2, '#today#', 'No' ) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird error
OK, I'm updating a record in my MSSQL database table. The column that's causing the error is an ntext column. The error I'm getting is: [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). Here's my SQL query: cfquery name=upcourse datasource=cft UPDATE dbo.Courses SET CourseName='#Trim(form.coursename)#',CourseDesc='cfqueryPARAM value = #form.coursedesc# CFSQLType = 'CF_SQL_longvarchar'',Cost=#form.cost#,MaxStudents=#form.maxstudents# WHERE (CourseID=#url.courseid#) /cfquery I'm sending the data from FCK editor. I've done this before and never had a problem. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird error
When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. The only html tags in the content are p and br /. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = cfqueryPARAM value=#form.coursedesc# CFSQLType=CF_SQL_longvarchar /, Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Weird error
Tried and still getting the same error. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. cfquery name=upcourse datasource=cft UPDATE dbo.Courses SET CourseName=cfqueryPARAM value = #form.coursename# CFSQLType = CF_SQL_varchar,CourseDesc=cfqueryPARAM value = #form.coursedesc1# CFSQLType = CF_SQL_varchar,Cost=cfqueryPARAM value = #form.cost# CFSQLType = CF_SQL_money,MaxStudents=cfqueryPARAM value = #form.maxstudents# CFSQLType = CF_SQL_integer WHERE (CourseID=#url.courseid#) /cfquery I'm stumped! -Original Message- From: Matthew [mailto:a.matthe...@yahoo.com] Sent: July-14-09 4:13 PM To: cf-talk Subject: Re: Weird error Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam all the variables. Matt. On 14 Jul 2009, at 20:06, Rick Sanders c...@webenergy.ca wrote: When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. The only html tags in the content are p and br /. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = cfqueryPARAM value=#form.coursedesc# CFSQLType=CF_SQL_longvarchar /, Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird error
I found the error. I changed my form to a cfform. I'm passing the coursed from the query in the url: courseid=#courses.courseid#. When it was in the form tag I had to wrap cfoutput around the variable. When I changed it to a cfform I forgot to remove the cfoutput tags because it didn't need them. Thanks for all your help! -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: July-14-09 4:38 PM To: cf-talk Subject: RE: Weird error Tried and still getting the same error. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. cfquery name=upcourse datasource=cft UPDATE dbo.Courses SET CourseName=cfqueryPARAM value = #form.coursename# CFSQLType = CF_SQL_varchar,CourseDesc=cfqueryPARAM value = #form.coursedesc1# CFSQLType = CF_SQL_varchar,Cost=cfqueryPARAM value = #form.cost# CFSQLType = CF_SQL_money,MaxStudents=cfqueryPARAM value = #form.maxstudents# CFSQLType = CF_SQL_integer WHERE (CourseID=#url.courseid#) /cfquery I'm stumped! -Original Message- From: Matthew [mailto:a.matthe...@yahoo.com] Sent: July-14-09 4:13 PM To: cf-talk Subject: Re: Weird error Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam all the variables. Matt. On 14 Jul 2009, at 20:06, Rick Sanders c...@webenergy.ca wrote: When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. The only html tags in the content are p and br /. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = cfqueryPARAM value=#form.coursedesc# CFSQLType=CF_SQL_longvarchar /, Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Values in a loop
Hey Jason, Thanks! It worked after I moved it like you suggested. Rick -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: April-30-09 8:17 AM To: cf-talk Subject: Re: Values in a loop An unchecked checkbox doesn't exist in the subsequent form scope. Move your CFIF up above your CFSET's: cfloop index=pmt from = 1 to = #form.numrows# cfif isDefined(form.paid_#pmt#) and Trim(pd) eq Confirmed cfset pd=form['paid_' pmt] cfset rid=form['regid_' pmt] cfquery datasource=#dsn# name=upreg UPDATE dbo.ShowRegistration SET Payment='Confirmed' WHERE (RegistrationID=#rid#) /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Values in a loop
OK, I'm a little stumped here. I have a loop that has 17 rows. It's looping over results from the database on a pervious page: cfloop index=pmt from = 1 to = #form.numrows# What I need to do is grab the form value from the previous page. It's a checkbox: input type=checkbox name=paid_#reg.currentrow# value=Confirmed cfif #Trim(reg.payment)# eq Confirmedchecked/cfif Next I want to store it in the database with the value: cfloop index=pmt from = 1 to = #form.numrows# cfset pd=#form['paid_' pmt]# cfset rid=#form['regid_' pmt]# cfif isDefined(form.paid_#pmt#) and #Trim(pd)# eq Confirmed cfquery datasource=#dsn# name=upreg UPDATE dbo.ShowRegistration SET Payment='Confirmed' WHERE (RegistrationID=#rid#) /cfquery When I try to run it I get the following error: Element paid_1 is undefined in a Java object of type class coldfusion.filter.FormScope. The error occurred in E:\Websites\gmclubofns\forum\updpayment.cfm: line 10 8 : body 9 : cfloop index=pmt from = 1 to = #form.numrows# 10 : cfset pd=#form['paid_' pmt]# 11 : cfif isDefined(form.paid_#pmt#) and #Trim(pd)# eq Confirmed 12 : cfset rid=#form['regid_' pmt]# What am I doing wrong? Am I referencing the values in a loop correctly? Thank you for your help. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
No SQL Update!
I've been trying to figure this one out. The query gets hit, but the database isn't being updated from the values in the form. The columns seem valid, and the table permissions are fine. I'm using SQL Server 2005. Here's the query: UPDATE dbo.Vehicles SET StockNo='#form.stockno#',CarMake=#form.make#,CarModel='#form.model#',ModelTr im='#form.trim#',CarYear=#form.caryear#,Category=#form.category#,Mileage='#f orm.mileage#',unit='km',VIN='#form.vin#',EngineSize='#form.engine#',Transmis sion='#form.trans#',Drivetrain='#form.drivetrain#',Price=#form.price#,Warran ty='#form.warranty#',Description='#form.description#',Inspected='#form.mm#', Financing='#form.financing#',Leasing='#form.leasing#',Active='#form.active#' ,Featured='#form.featured#',Pic1='#pic1#',Pic2='#pic2#',Pic3='#pic3#',Pic4=' #pic4#',thumb1='#pic1t#',thumb2='#pic2t#',thumb3='#pic3t#',thumb4='#pic4t#', Sold='#form.sold#',SoldPrice=#form.soldamt#,VehicleCost=#form.cost#,MVIcost= #form.mvicost#,Reconditioning='#form.reconditioning#',ReconditioningCost=#fo rm.reconcost#,Parts='#form.parts#',PartsCost=#form.partscost#,Labour='#form. labour#',LabourCost=#form.labourcost# WHERE (StockNo='#form.carid#') Thanks for any help! Rick Sanders Webenergy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No SQL Update!
Here are the values being passed: UPDATE dbo.Vehicles SET StockNo='012',CarMake=31,CarModel='ION ',ModelTrim=' ',CarYear=2004,Category=1,Mileage='135,000 ',unit='km',VIN=' ',EngineSize='4cyl',Transmission='Automatic',Drivetrain='Front Wheel Drive',Price=4300.00,Warranty='Yes',Description=' 2004 Saturn Ion, 4 Cylinder 5 speed standard, that is fully loaded and is in excellent condition. This car has Air conditioning, Power locks, windows, Keyless entry, and more. This car has 135,00,000kms that has just been MVI''d, new front brakes, 4 brand new tires with snows on the front.. This car works and looks like new, a must drive, this car looks like new inside, non smoker',Inspected='12/09 ',Financing='No',Leasing='No',Active='Yes',Featured='Yes',Pic1='012_1.jpg',P ic2='012_2.jpg',Pic3='012_3.jpg',Pic4='012_4.jpg',thumb1='012thumb_1.jpg',th umb2='012thumb_2.jpg',thumb3='012thumb_3.jpg',thumb4='012thumb_4.jpg',Sold=' Yes',SoldPrice=0,VehicleCost=0,MVIcost=0,Reconditioning='N/A',Reconditioning Cost=0,Parts='N/A',PartsCost=0,Labour='N/A',LabourCost=0 WHERE (StockNo='3') No errors from CF or the database! SELECT statements work no problem either. I can pull up anything from the DB. This is a weird one! -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: February-03-09 8:39 PM To: cf-talk Subject: Re: No SQL Update! I've been trying to figure this one out. The query gets hit, but the database isn't being updated from the values in the form. The columns seem valid, and the table permissions are fine. What does your debug output show? Are you setting the form variable used in the WHERE clause? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: No SQL Update!
Problem fixed! My dumb error! I was trying to update by vehicle ID using the stock number! Vehicle ID's and stock numbers are different, so no wonder why it didn't update. Time to step away from the puter. Thanks for listening! -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: February-03-09 9:02 PM To: cf-talk Subject: Re: No SQL Update! StockNo is a char/varchar datatype? On Tue, Feb 3, 2009 at 4:55 PM, b...@bradwood.com wrote: What do you get when you run: SELECT * FROM dbo.Vehicles WHERE (StockNo='3') ~Brad Original Message Subject: RE: No SQL Update! From: Rick Sanders c...@webenergy.ca Date: Tue, February 03, 2009 6:46 pm To: cf-talk cf-talk@houseoffusion.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No SQL Update!
Even a nickel and I'd be happy! -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: February-03-09 9:17 PM To: cf-talk Subject: Re: No SQL Update! yeah, that's one of those if i only had a dollar for every time... things :) On Tue, Feb 3, 2009 at 5:14 PM, Rick Sanders c...@webenergy.ca wrote: Problem fixed! My dumb error! I was trying to update by vehicle ID using the stock number! Vehicle ID's and stock numbers are different, so no wonder why it didn't update. Time to step away from the puter. Thanks for listening! -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: February-03-09 9:02 PM To: cf-talk Subject: Re: No SQL Update! StockNo is a char/varchar datatype? On Tue, Feb 3, 2009 at 4:55 PM, b...@bradwood.com wrote: What do you get when you run: SELECT * FROM dbo.Vehicles WHERE (StockNo='3') ~Brad Original Message Subject: RE: No SQL Update! From: Rick Sanders c...@webenergy.ca Date: Tue, February 03, 2009 6:46 pm To: cf-talk cf-talk@houseoffusion.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Random Numbers
I'm trying to do something simple here. How do I simply pull a random number? I looked at rand, randomize, and randrange but they are for mathematical calculations. All I want to do is define a rang (1 - 10) and pull a number in that range. Thanks in advance, LogoSig Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Random Numbers
Thanks. I realized as I hit the send button that was it. I was looking at something more complicated, but it was as easy as RandRange. Time to step away from the computer! -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: November-06-08 7:53 PM To: cf-talk Subject: Re: Random Numbers randRange(1, 10)? On Thu, Nov 6, 2008 at 3:51 PM, Rick Sanders [EMAIL PROTECTED] wrote: I'm trying to do something simple here. How do I simply pull a random number? I looked at rand, randomize, and randrange but they are for mathematical calculations. All I want to do is define a rang (1 - 10) and pull a number in that range. Thanks in advance, LogoSig Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adding Updating empty values
Hey all, In my form some values may be left empty. For example a form field named q1. It's fine if it's empty because the user can go back and fill it in later if they wish. How do I get passed the q1 is not defined in Form CF error? All I want to do is enter an empty value. How can I allow it to do that for insert and updates? Thanks! LogoSig Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adding Updating empty values
Is that the only way? It's a questionnaire form with 50 questions! You mean I have to do a cfif for every question and assign it a blank value if there's no value!? -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: October-28-08 4:42 PM To: cf-talk Subject: Re: Adding Updating empty values wrap it in a cfif so.. cfif isundefined(form.q1) cfset form.q1 = /cfif Rob On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders [EMAIL PROTECTED] wrote: Hey all, In my form some values may be left empty. For example a form field named q1. It's fine if it's empty because the user can go back and fill it in later if they wish. How do I get passed the q1 is not defined in Form CF error? All I want to do is enter an empty value. How can I allow it to do that for insert and updates? Thanks! LogoSig Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding Updating empty values
I hear you, and already did that for checkboxes. But, I have text fields and radio buttons in my form! -Original Message- From: Jason Fisher [mailto:[EMAIL PROTECTED] Sent: October-28-08 4:47 PM To: cf-talk Subject: Re: Adding Updating empty values The other option is to use yes and no radio buttons instead of checkboxes, where the radio buttons default to no. That way, the field always exists, but you still get the difference between 1 and 0. Checkbox that is unchecked really doesn't exist in the POST, so the CFIF solution is pretty much required otherwise, yes. Is that the only way? It's a questionnaire form with 50 questions! You mean I have to do a cfif for every question and assign it a blank value if there's no value!? wrap it in a cfif so.. cfif isundefined(form.q1) cfset form.q1 = /cfif Rob to ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding Updating empty values
Yup, you're right. It's the radio buttons that are giving me the hassle! -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: October-28-08 5:14 PM To: cf-talk Subject: Re: Adding Updating empty values text fields are defined even if they are empty. the value is simply an empty string. On Tue, Oct 28, 2008 at 12:58 PM, Rick Sanders [EMAIL PROTECTED] wrote: I hear you, and already did that for checkboxes. But, I have text fields and radio buttons in my form! -Original Message- From: Jason Fisher [mailto:[EMAIL PROTECTED] Sent: October-28-08 4:47 PM To: cf-talk Subject: Re: Adding Updating empty values The other option is to use yes and no radio buttons instead of checkboxes, where the radio buttons default to no. That way, the field always exists, but you still get the difference between 1 and 0. Checkbox that is unchecked really doesn't exist in the POST, so the CFIF solution is pretty much required otherwise, yes. Is that the only way? It's a questionnaire form with 50 questions! You mean I have to do a cfif for every question and assign it a blank value if there's no value!? wrap it in a cfif so.. cfif isundefined(form.q1) cfset form.q1 = /cfif Rob to ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adding Updating empty values
I agree, but I still have to enter all the form field names in the cfparam anyways so I'm not really gaining anything. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: October-28-08 5:32 PM To: cf-talk Subject: RE: Adding Updating empty values How do I get passed the q1 is not defined in Form CF error? All I want to do is enter an empty value. How can I allow it to do that for insert and updates? Actually, you'd never want to have to deal with not defined errors in your core code. That's what cfparam is for, all form fields should be defined (default them to if needed) higher up, along with form field validation, and so on. --- Ben -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2008 4:10 PM To: cf-talk Subject: Re: Adding Updating empty values Write a code generator for it. fill out the form, and loop over the #Form.FIELDNAMES# Like so pre cfoutput cfloop list=#form.FIELDNAMES# index=GO lt;cfif isundefined(form.#GO#) lt;cfset form.q#GO# = lt;/cfif /cfloop /cfoutput /pre On Tue, Oct 28, 2008 at 3:46 PM, Rick Sanders [EMAIL PROTECTED] wrote: Is that the only way? It's a questionnaire form with 50 questions! You mean I have to do a cfif for every question and assign it a blank value if there's no value!? -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: October-28-08 4:42 PM To: cf-talk Subject: Re: Adding Updating empty values wrap it in a cfif so.. cfif isundefined(form.q1) cfset form.q1 = /cfif Rob On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders [EMAIL PROTECTED] wrote: Hey all, In my form some values may be left empty. For example a form field named q1. It's fine if it's empty because the user can go back and fill it in later if they wish. How do I get passed the q1 is not defined in Form CF error? All I want to do is enter an empty value. How can I allow it to do that for insert and updates? Thanks! LogoSig Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding Updating empty values
Ah! Thank you! I've been looking for resources like this! Excellent! Thank you! -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: October-28-08 6:27 PM To: cf-talk Subject: Re: Adding Updating empty values Rick, It may be time to make yourself acquainted with the wonderful world of code generators. Here is a partial list of the various offerings. I make heavy use of cfcgenerator and cfcblaster. I rarely create CRUD's by hand. http://code.google.com/p/cfcgenerator/ http://completecodegen.riaforge.org/ http://beanmachine.riaforge.org/ http://mrmx.blogspot.com/2006/09/cfcblaster-simple-code-generator.html http://cfcstub.riaforge.org/ Happy coding. ~G~ On Tue, Oct 28, 2008 at 3:46 PM, Rick Sanders [EMAIL PROTECTED] wrote: Is that the only way? It's a questionnaire form with 50 questions! You mean I have to do a cfif for every question and assign it a blank value if there's no value!? -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: October-28-08 4:42 PM To: cf-talk Subject: Re: Adding Updating empty values wrap it in a cfif so.. cfif isundefined(form.q1) cfset form.q1 = /cfif Rob On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders [EMAIL PROTECTED] wrote: Hey all, In my form some values may be left empty. For example a form field named q1. It's fine if it's empty because the user can go back and fill it in later if they wish. How do I get passed the q1 is not defined in Form CF error? All I want to do is enter an empty value. How can I allow it to do that for insert and updates? Thanks! LogoSig Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web Service Issue , pls help
Dude, Read the top right of the page. The domain is expired! flash-db.com expired on 07/26/2008 and is pending renewal or deletion Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: August-19-08 10:50 PM To: CF-Talk Subject: Re: Web Service Issue , pls help Hi Dave I dont have a web service code , i tried to access the public web serive from xmethod which return the image , but somehow its not working This is the web service http://www.xmethods.net/ve2/ViewListing.po?key=uuid:861CB6D3-1E2A-BA27-BDDE- E9FEF283E518 You may be able to cfcontent it directly - or you may need to store it as a file of the correct type and extension. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com Hi We have a java webservice which will return the image as a soap attachment and another web service which will return the image as a binary data How can we use the image return by the web service in coldfusion? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
Well, The tag worked, but it doesn't write the row number in the loop, it just writes [loop]. CFLOOP from=1 to=#toloop# index=Loop var lat[Loop] = {latitude}; /CFLOOP Within the cfsavecontent, how can I make the row number show up in the loop when I define it? -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: June-24-08 10:05 PM To: CF-Talk Subject: Re: CF tags in CFFILE write Build the output using cfsavecontent and write the result using the cffile tag. On Wed, Jun 25, 2008 at 8:37 AM, Rick Sanders [EMAIL PROTECTED] wrote: Hey everyone, I need to dynamically write a javascript file from Cold fusion. However, it keeps giving me errors. Is there a way to write a file using cf tags in the output? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
Hey Brad, Thanks for the tip but I tried that already. It just outputs [#Loop#] in the file I'm writing. I am in a cfsavecontent block btw. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: June-25-08 3:02 PM To: CF-Talk Subject: RE: CF tags in CFFILE write In ColdFusion, you need to wrap a variable in pound signs (#) for its value to be output. cfoutput CFLOOP from=1 to=#toloop# index=Loop var lat[#Loop#] = {latitude}; /CFLOOP /cfoutput -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 12:55 PM To: CF-Talk Subject: RE: CF tags in CFFILE write Well, The tag worked, but it doesn't write the row number in the loop, it just writes [loop]. CFLOOP from=1 to=#toloop# index=Loop var lat[Loop] = {latitude}; /CFLOOP Within the cfsavecontent, how can I make the row number show up in the loop when I define it? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
Thanks Brad, I should have known that, and I should have looked harder. Been looking at this code for 9 hours straight now. Thanks again. Rick -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: June-25-08 3:20 PM To: CF-Talk Subject: RE: CF tags in CFFILE write You'll notice my example also has cfoutput tags wrapped around it. Does yours? ~Brad -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 1:07 PM To: CF-Talk Subject: RE: CF tags in CFFILE write Hey Brad, Thanks for the tip but I tried that already. It just outputs [#Loop#] in the file I'm writing. I am in a cfsavecontent block btw. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: June-25-08 3:02 PM To: CF-Talk Subject: RE: CF tags in CFFILE write In ColdFusion, you need to wrap a variable in pound signs (#) for its value to be output. cfoutput CFLOOP from=1 to=#toloop# index=Loop var lat[#Loop#] = {latitude}; /CFLOOP /cfoutput -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 12:55 PM To: CF-Talk Subject: RE: CF tags in CFFILE write Well, The tag worked, but it doesn't write the row number in the loop, it just writes [loop]. CFLOOP from=1 to=#toloop# index=Loop var lat[Loop] = {latitude}; /CFLOOP Within the cfsavecontent, how can I make the row number show up in the loop when I define it? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF tags in CFFILE write
Hey everyone, I need to dynamically write a javascript file from Cold fusion. However, it keeps giving me errors. Is there a way to write a file using cf tags in the output? Example: cffile action = write file = {filepath} output =var map = null; CFLOOP from=1 to=#toloop# index=Loop var lat[loop] = {latitude}; var lon[loop] = {longitude}; var latLong[loop] = new VELatLong(lat[loop], lon[loop]);','var points[loop] = [ new VELatLong(lat[loop], lon[loop] - 0.15), new VELatLong(lat[loop] + 0.1, lon[loop] - 0.05), new VELatLong(lat[loop] + 0.1, lon[loop] + 0.05), new VELatLong(lat[loop], lon1 + 0.15), new VELatLong(lat[loop] - 0.1, lon[loop] + 0.05), new VELatLong(lat[loop] - 0.1, lon[loop] - 0.05)];','shape[loop] = new VEShape(VEShapeType.Polygon, points[loop]); /CFLOOP I need to loop in the file to put all the points and latitude / longitude for a map. So, I need to parse the cfloop code in the file, but only write the results to the file. Please let me know if this can be done? Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF tags in CFFILE write
Hey James, Thanks for the tip! I'll give it a shot! Rick -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: June-24-08 10:05 PM To: CF-Talk Subject: Re: CF tags in CFFILE write Build the output using cfsavecontent and write the result using the cffile tag. On Wed, Jun 25, 2008 at 8:37 AM, Rick Sanders [EMAIL PROTECTED] wrote: Hey everyone, I need to dynamically write a javascript file from Cold fusion. However, it keeps giving me errors. Is there a way to write a file using cf tags in the output? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Date parsing and formatting...
OK, here's the scoop... I'm grabbing the date from an XML web service which is returning the date in the following format: May 21, 2008 How can I change it to 05/21/2008 ? Naturally I had to parse it to a string because Cold fusion won't parse an XML child node. I've tried dateformat, CreateDate, LSParseDateTime and they all return errors telling me that May 21, 2008 is an invalid date format. Please help and let me know if there is a way to convert this date type in to a date string. Thanks, Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Date parsing and formatting...
Hello James, I certainly did and the error I get is: May 21, 2008 is an invalid date or time string My code: cfset myDoc=XMLParse(XMLResult) cfset xdate = #ToString(myDoc.michiganMasons.event_begin_date[1])# cfset cdate = #ParseDatetime(xdate)# Rick -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: June-18-08 10:36 PM To: CF-Talk Subject: Re: Date parsing and formatting... Di you try ParseDateTime() ? On Thu, Jun 19, 2008 at 9:26 AM, Rick Sanders [EMAIL PROTECTED] wrote: OK, here's the scoop... I'm grabbing the date from an XML web service which is returning the date in the following format: May 21, 2008 How can I change it to 05/21/2008 ? Naturally I had to parse it to a string because Cold fusion won't parse an XML child node. I've tried dateformat, CreateDate, LSParseDateTime and they all return errors telling me that May 21, 2008 is an invalid date format. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Live Chat
Hello helpful people! I'm just wondering if there's a chat module anywhere that's been built already? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Live Chat
Thanks! -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: March-31-08 3:59 PM To: CF-Talk Subject: Re: Live Chat http://cfopenchat.riaforge.org/ On Mon, Mar 31, 2008 at 2:49 PM, Rick Sanders [EMAIL PROTECTED] wrote: Hello helpful people! I'm just wondering if there's a chat module anywhere that's been built already? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4