Re: CF Editor
Tell me about it, we shell out something like £800 a month for legacy support to Microsoft. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Dave Watts To: CF-Talk Sent: Thu Jun 28 01:11:11 2007 Subject: RE: CF Editor Yeah, but EX5.5 is defunk now, I mean didn't support stop on this like 2 or so years ago? I'm sure it has, but the fact is, they have the patch. It's a very simple patch apparently. They just want you to pay - a lot - for it. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282440 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 Editor
Greg Luce wrote: Not sure what you're saying here. What is a product? And the rest of the paragraph just doesn't make sense. The product is an Eclipse distribution customized for CF development, together with a configuration customized for you and training on the proper use of it. Which you can buy from us, but only if you are located near us (because of all the training) and buy the whole package including training and support on SVN and Ant, and optionally tools, training and support for automated testing, clustering etc. Jochem ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple CF instances on same server
Due to my concern of having to purchase multiple licenses in the event that I need a cluster of servers at some point in the future I was advised that this a legitimate concern by Adobe, however they also stated that CF Enterprise allows you to install multiple CF instances on the same box with the same license. What is the benefit of having multiple CF instances on the same server? Can this assist with speed of applications, database queries, etc.? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple CF instances on same server
The biggest advantage, is if the hardware has hot swapable devices. then you minimse the actual machines downtime. So what you need to do then is look at the, keeping the application up and running. the advantage is clustering the instances so that you minimse the impact of the applications downtime. In a hosting scenario, I find it annoying that your website, or even your clients website is brought down because of some rouge developer and sloppy code. There is more, but thatwas the one I thought of from the top of my head. On 6/28/07, m g [EMAIL PROTECTED] wrote: Due to my concern of having to purchase multiple licenses in the event that I need a cluster of servers at some point in the future I was advised that this a legitimate concern by Adobe, however they also stated that CF Enterprise allows you to install multiple CF instances on the same box with the same license. What is the benefit of having multiple CF instances on the same server? Can this assist with speed of applications, database queries, etc.? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on dynamic position of fields in cfoutput for postal code
Thanks that did the trick... cfoutput query=test cfif position is 1 #CITY# #CODE# cfelse #CODE# #CITY# /cfif /cfoutput .. :.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:15 AM To: CF-Talk Subject: help on dynamic position of fields in cfoutput for postal code HI everybody... need help on how to position the postal code on either left or right of the city depending on the given value.. have this table CITY CODE POSITION CITYA 001001 CITYB 12 IF POSITION IS 1 THE CODE SHOULD BE ON THE RIGHT OF THE CITY cfoutput query=test #CITYA# #CODE# /cfoutput IF POSITION IS 1 THE CODE SHOULD BE ON THE LEFTOF THE CITY cfoutput query=test #CODE# #CITYB# /cfoutput is there a way of doing this dynamically.. THANKS.. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Mail error
I have an error I have not seen before that has recently started cropping up (since Sunday). After the server has been running for a couple of days attempts to send mail will throw the following error... An exception occurred when setting up mail server parameters. This exception was caused by: coldfusion.mail.MailSessionException: An exception occurred when setting up mail server parameters. A service restart makes the error go away for another couple of days. Several different pages all generate the same error and none of them have been edited recently so it isn't a code problem. Does anyone know how to make this go away! -- Jay ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Mail error
The sounds very similar to what Mike Kear was having. If he fixed it, or found out I am sure he will pop in... On 6/28/07, James Smith [EMAIL PROTECTED] wrote: I have an error I have not seen before that has recently started cropping up (since Sunday). After the server has been running for a couple of days attempts to send mail will throw the following error... An exception occurred when setting up mail server parameters. This exception was caused by: coldfusion.mail.MailSessionException: An exception occurred when setting up mail server parameters. A service restart makes the error go away for another couple of days. Several different pages all generate the same error and none of them have been edited recently so it isn't a code problem. Does anyone know how to make this go away! -- Jay ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Mail error
Yes it is almost the same problem, but I'm afraid i can't add much to the cause and/or solution. I had my sysadmin restart coldfusion and the problem went away. That's what you're doing and in your case it's coming back. So while I think you're doing what is the commonly held solution it's going to get pretty annoying pretty quick, I'd have thought. So we still don't really know what's causing it. If anyone can offer any suggestions in that regard, I'm all ears. I'm suspecting we're going to see the problem again sooner or laer, and it's fairly clear that James is too. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 6/28/07, Andrew Scott [EMAIL PROTECTED] wrote: The sounds very similar to what Mike Kear was having. If he fixed it, or found out I am sure he will pop in... On 6/28/07, James Smith [EMAIL PROTECTED] wrote: I have an error I have not seen before that has recently started cropping up (since Sunday). After the server has been running for a couple of days attempts to send mail will throw the following error... An exception occurred when setting up mail server parameters. This exception was caused by: coldfusion.mail.MailSessionException: An exception occurred when setting up mail server parameters. A service restart makes the error go away for another couple of days. Several different pages all generate the same error and none of them have been edited recently so it isn't a code problem. Does anyone know how to make this go away! -- Jay ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple CF instances on same server
When you run multiple instance on a single server, you can run web sites, or even application in their on space. So if one looses the plot and crashes, the other coldfusion instance is still running. But that is as long as the first instance hasn't consumed all system resourcs, or the error is at the JRun level. On 6/28/07, m g [EMAIL PROTECTED] wrote: Due to my concern of having to purchase multiple licenses in the event that I need a cluster of servers at some point in the future I was advised that this a legitimate concern by Adobe, however they also stated that CF Enterprise allows you to install multiple CF instances on the same box with the same license. What is the benefit of having multiple CF instances on the same server? Can this assist with speed of applications, database queries, etc.? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Javascript COM and CF
Hi there. I'm currently working on converting a JS script into CF. Uses a lot of COM. Anywhoo, I'm having some problems with the following line of code. JS Version. HKLM = 0x8002; oInParam.hDefKey = HKLM; CF Version. cfset HKLM = '0x8002' cfset local.oInParam.hDefKey = HKLM I think that the problem is that it doesn't like the fact that HKLM is a string in the CF version. And CF wont allow me ( for obvious reasons ) to store this as number... nor will it allow me to cast it as an int. any ideas? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Javascript COM and CF
What are you trying to do? HKLM sounds to me like a registery key? The other thing is thet 0x802 is a hex value. On 6/28/07, D F [EMAIL PROTECTED] wrote: Hi there. I'm currently working on converting a JS script into CF. Uses a lot of COM. Anywhoo, I'm having some problems with the following line of code. JS Version. HKLM = 0x8002; oInParam.hDefKey = HKLM; CF Version. cfset HKLM = '0x8002' cfset local.oInParam.hDefKey = HKLM I think that the problem is that it doesn't like the fact that HKLM is a string in the CF version. And CF wont allow me ( for obvious reasons ) to store this as number... nor will it allow me to cast it as an int. any ideas? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Javascript COM and CF
I figured it was a registry key as well I guess I'm not sure how one would store this data without it being considered a string by CF. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Javascript COM and CF
Turn the hex value to a number... but why use com? CF has cfregistry tags. On 6/28/07, D F [EMAIL PROTECTED] wrote: I figured it was a registry key as well I guess I'm not sure how one would store this data without it being considered a string by CF. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple CF instances on same server
Think about it in terms of math. An instance of CF can only utilize 1G of RAM because of the JVMs limitations. You have a dual quad proc system with 8G of RAM. You leave 2G alone for the OS (in the case of Windows 2k3), and setup 3 instances of CF, utilizing 5G of your RAM altogether. This leaves you a little wiggle room for other apps on the server (maybe monitoring), allows you to utilize a systems resources that were otherwise being wasted, and creates three separate instances of CF that could be clustered to 'share the load' of an application. Or you could just separate applications in this manner, for instance: running data heavy front-end websites on one instance while maintaining manual process intensive site administrator on another and placing scheduled process intensive (report generation, batch image processing, etc.) on another. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com m g wrote: Due to my concern of having to purchase multiple licenses in the event that I need a cluster of servers at some point in the future I was advised that this a legitimate concern by Adobe, however they also stated that CF Enterprise allows you to install multiple CF instances on the same box with the same license. What is the benefit of having multiple CF instances on the same server? Can this assist with speed of applications, database queries, etc.? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282454 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 Editor
What kind of system are you using? Even server type systems with ECC and FBDIMM don't cost that much, AFAIK. Here's the link to the Dell page for the 512MB memory for my system. I'd certainly love to know if there is a reasonable alternative to it, it does indeed seem ridiculously high-priced compared to most memory chips these days. http://tinyurl.com/39zp4f For that price, you could buy a new motherboard, a faster CPU and 2GB+ of RAM from NewEgg. The problem is the older the memory type, the less demand, so the higher the price to manufacture. Prices on DDR2 memory is really cheap right now. -Dan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Create PowerPoint Files
POI, one of the Apache projects contains Java objects to allow you to create all different kinds of M$ format documents. The specific part of it for PowerPoint is HSLF. http://poi.apache.org/hslf/index.html -- Timothy J. Heald | NIH-Contractor | iGate Enterprise Business Intelligence Branch (EBIB) Division of Enterprise and Custom Applications, CIT/NIH/DHHS Office: 301.594.5611 | Fax: 301.443.7010 | Email: [EMAIL PROTECTED] -Original Message- From: Todd Mathews [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 7:43 PM To: CF-Talk Subject: Create PowerPoint Files We need to be able to create PPT file output from CF. Has anyone else done this that can share any info? We're looking at the Aspose components and would love to hear from anyone else who has used them or might have some CF centric sample code. It is amazing how difficult it is to write PPT files. We'd be in heaven if we could simply change the output type of a .cfr file to crank out the PPT docs since we already use it for the PDF version. Unfortunately it isn't that simple so it looks like we'll be using Aspose to do the job and code the output 'old school' to generate the PPT report. If anyone has any better suggestions or experience with Aspose, please share! ;) Todd ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282455 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 Editor
I don't understand the complaints about configuration. You either point to a url or a zip file when you want to add a new plug-in. Seems easy enough to me, hell, how would you prefer to see it done? -- Timothy J. Heald | NIH-Contractor | iGate Enterprise Business Intelligence Branch (EBIB) Division of Enterprise and Custom Applications, CIT/NIH/DHHS Office: 301.594.5611 | Fax: 301.443.7010 | Email: [EMAIL PROTECTED] -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 10:32 PM To: CF-Talk Subject: Re: CF Editor Yeah, I guess that's a start. But even I figured out how to install one plugin - CFEclipse. I'm more interested in the uber-geek dozens of plugins and configurations/strategies I've heard in this thread. Makes me think I'm behind the curve using Homesite. Greg On 6/27/07, Charlie Griefer [EMAIL PROTECTED] wrote: this is pretty close... http://www.cfeclipse.org/download/ it's Eclipse with CFE already bundled in. Certainly enough to get one started, no? On 6/27/07, Greg Luce [EMAIL PROTECTED] wrote: So aside from commercial plugins, if they are all covered by gnu license could you package up a Signature Build and distribute it or even sell it? Greg On 6/27/07, Charlie Griefer [EMAIL PROTECTED] wrote: as he said... he's using a specific plugin that's commercial. so, yeah :) On 6/27/07, Greg Luce [EMAIL PROTECTED] wrote: Alright, this thread got me to open CFE back up after more than a week. Like I said earlier, is there a licensing problem with Brian setting up Eclipse how he does with all his bells and whistles and releasing it as the Brian Kotek Signature Edition or something? Greg On 6/27/07, Dave Watts [EMAIL PROTECTED] wrote: I wasn't referring to Mark at all...that was directed at the people responding to bug reports for Eclipse. Instead of basically telling everyone with Vista they are SOL because the zipping protocol they use or something within how they zip their files doesn't work in Vista...they should be trying to fix that issue so that it is compatible with Vista...even if it is a limitation coming from Vista. By telling everyone tough crap...I'm not doing squat about it...it's a Vista issue and it is MS's problem, not theirs...that is a piss poor attitude. I can't imagine Symantec, Yahoo, or any other software company just say...tough crap...Vista users are just SOL...and anyone expect them to stay in business for long. Now granted Eclipse is free...but free does ensure success when they are being rude or acting like small children in anti-MS mode. If you can't imagine any other software company would just say tough crap, you have been amazingly lucky. I get told tough crap all the time from vendors who were happy to sell me things and take my money. Sometimes, vendors won't even answer your questions without a support contract, and then when you do get one, their answer is that doesn't work or maybe in the next release. I could list just the times that's happened this week - and it's only Wednesday - but it's making me angry just thinking about it, and I'd probably regret it later. Oh, well, here's a golden oldie from earlier this year. DST 2007 support for Exchange 5.5 - Microsoft says tough crap, unless you want to pay us upward of $5k for a DLL that we have. And when tough crap boils down to use Winzip, that's not really putting you out too much. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282457 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 Editor
Personally the source control features are gravy. It's the features that are provided by CFEclipse, and the Adobe CF/Flex tools and Aptana (CSS/JS) all in the same ide, giving me the ability to easily change perspectives mid stream without having to open three different tools, which used to be my only option. As an aside, anyone playing with the JSEclispe plug-in on labs? -- Timothy J. Heald | NIH-Contractor | iGate Enterprise Business Intelligence Branch (EBIB) Division of Enterprise and Custom Applications, CIT/NIH/DHHS Office: 301.594.5611 | Fax: 301.443.7010 | Email: [EMAIL PROTECTED] -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 8:52 PM To: CF-Talk Subject: RE: CF Editor Would it be an appropriate perspective to say that Eclipse and CFEclipse would be more for companies with Multiple developers working together? I'm currently just coding everything in Homesite 5.5 and It works fine for me. I'm an independent developer, so I don't Have to worry about someone changing anything...checking out Pages, etc. I don't have a running history of changes, but for versioning, I just copy and paste the site folder and append a date and time on It in case I want to go back to that version. I have considered Eclipse and CFEclipse, but it seems overkill based On the conversation here... Thoughts on appropriateness for a sole developer? Rick -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 6:49 PM To: CF-Talk Subject: Re: CF Editor Yeah, but EX5.5 is defunk now, I mean didn't support stop on this like 2 or so years ago? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Dave Watts To: CF-Talk Sent: Wed Jun 27 14:42:56 2007 Subject: RE: CF Editor I wasn't referring to Mark at all...that was directed at the people responding to bug reports for Eclipse. Instead of basically telling everyone with Vista they are SOL because the zipping protocol they use or something within how they zip their files doesn't work in Vista...they should be trying to fix that issue so that it is compatible with Vista...even if it is a limitation coming from Vista. By telling everyone tough crap...I'm not doing squat about it...it's a Vista issue and it is MS's problem, not theirs...that is a piss poor attitude. I can't imagine Symantec, Yahoo, or any other software company just say...tough crap...Vista users are just SOL...and anyone expect them to stay in business for long. Now granted Eclipse is free...but free does ensure success when they are being rude or acting like small children in anti-MS mode. If you can't imagine any other software company would just say tough crap, you have been amazingly lucky. I get told tough crap all the time from vendors who were happy to sell me things and take my money. Sometimes, vendors won't even answer your questions without a support contract, and then when you do get one, their answer is that doesn't work or maybe in the next release. I could list just the times that's happened this week - and it's only Wednesday - but it's making me angry just thinking about it, and I'd probably regret it later. Oh, well, here's a golden oldie from earlier this year. DST 2007 support for Exchange 5.5 - Microsoft says tough crap, unless you want to pay us upward of $5k for a DLL that we have. And when tough crap boils down to use Winzip, that's not really putting you out too much. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion
Yay CFML enhancements
I didn't catch this little enhancement in any of my previous CF8 presos, but apparently the ListToArray() function has been enhanced to understand empty list elements. I didn't notice if the other list functions have.. and I forgot to ask. but... ListToArray(5,3,,4) *can* be handled properly now (it's an optional argument, which I can't remember off the top of my head right now) I don't know about the rest of you, but I got awfully tired of writing code that would cause CF to handle empty list elements properly. Rick ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282458 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 Editor
I guess that depends on your development style. I use CFE at work and at home. Work is a team environment, while home is solo. I use almost all of the features at home just as I do at work, and find that I am far more productive for it. Yes, it took some trial and error for me to figure out MY optimal configuration of Eclipse, but it's plugin architecture and configurability has been invaluable. I use: The Web Tools Platform build of Eclipse Flex Builder plugin CFEclipse plugin Aptana plugin CF8 plugins Subclipse plugin (w/SvnAnt in the Ant dirs for running Subversion tasks through Ant) Mylyn looks good, so I'll probably see how that will affect workflow. I'm also considering the Green Project plugin for UML modeling direct within Eclipse. As an aside, you can download an all-in-one Eclipse+CFEclipse install from the CFE site for vanilla editing (doesn't take additional plugins well, so I went custom). I downloaded, installed, opened to the default workspace (without creating one specifically), went to the 'File Explorer' Tab (next to Navigation and Snippets), opened a file on my system, that wasn't in a pre-defined project, and edited away with no issues. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com 'One must move forward, for the Earth continues to move. There is no standing still, for the Earth will go by without you.' Rick Faircloth wrote: Would it be an appropriate perspective to say that Eclipse and CFEclipse would be more for companies with Multiple developers working together? I'm currently just coding everything in Homesite 5.5 and It works fine for me. I'm an independent developer, so I don't Have to worry about someone changing anything...checking out Pages, etc. I don't have a running history of changes, but for versioning, I just copy and paste the site folder and append a date and time on It in case I want to go back to that version. I have considered Eclipse and CFEclipse, but it seems overkill based On the conversation here... Thoughts on appropriateness for a sole developer? Rick -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 6:49 PM To: CF-Talk Subject: Re: CF Editor Yeah, but EX5.5 is defunk now, I mean didn't support stop on this like 2 or so years ago? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Dave Watts To: CF-Talk Sent: Wed Jun 27 14:42:56 2007 Subject: RE: CF Editor I wasn't referring to Mark at all...that was directed at the people responding to bug reports for Eclipse. Instead of basically telling everyone with Vista they are SOL because the zipping protocol they use or something within how they zip their files doesn't work in Vista...they should be trying to fix that issue so that it is compatible with Vista...even if it is a limitation coming from Vista. By telling everyone tough crap...I'm not doing squat about it...it's a Vista issue and it is MS's problem, not theirs...that is a piss poor attitude. I can't imagine Symantec, Yahoo, or any other software company just say...tough crap...Vista users are just SOL...and anyone expect them to stay in business for long. Now granted Eclipse is free...but free does ensure success when they are being rude or acting like small children in anti-MS mode. If you can't imagine any other software company would just say tough crap, you have been amazingly lucky. I get told tough crap all the time from vendors who were happy to sell me things and take my money. Sometimes, vendors won't even answer your questions without a support contract, and then when you do get one, their answer is that doesn't work or maybe in the next release. I could list just the times that's happened this week - and it's only Wednesday - but it's making me angry just thinking about it, and I'd probably regret it later. Oh, well, here's a golden oldie from earlier this year. DST 2007 support for Exchange 5.5 - Microsoft says tough crap, unless you want to pay us upward of $5k for a DLL
Re: Javascript COM and CF
D F wrote: Hi there. I'm currently working on converting a JS script into CF. Uses a lot of COM. Anywhoo, I'm having some problems with the following line of code. JS Version. HKLM = 0x8002; oInParam.hDefKey = HKLM; HKLM is usually short for the registry key HKEY_LOCAL_MACHINE. CF Version. cfset HKLM = '0x8002' cfset local.oInParam.hDefKey = HKLM I think that the problem is that it doesn't like the fact that HKLM is a string in the CF version. And CF wont allow me ( for obvious reasons ) to store this as number... nor will it allow me to cast it as an int. It is hex. Remove the 0x and FormatBaseN() the resulting string to get an integer. Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282460 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 Editor
On 6/28/07, Heald, Timothy (NIH/CIT) [C] [EMAIL PROTECTED] wrote: As an aside, anyone playing with the JSEclispe plug-in on labs? I've been using it for a while now, and really enjoy it. On of the best features is that you can select a chunk of inline JS in a CFM or HTML file, right click, and open it in JSEclipse - it opens a temp file of just the JS code, with all of the JSEclipse editing features available, and when you save, it syncs it up with the original source file. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Yay CFML enhancements
Nice.. there goes my custom solution. I was gonna make millions too!... ok maybe not so much millions as... 1's ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 9:45 AM To: CF-Talk Subject: Yay CFML enhancements I didn't catch this little enhancement in any of my previous CF8 presos, but apparently the ListToArray() function has been enhanced to understand empty list elements. I didn't notice if the other list functions have.. and I forgot to ask. but... ListToArray(5,3,,4) *can* be handled properly now (it's an optional argument, which I can't remember off the top of my head right now) I don't know about the rest of you, but I got awfully tired of writing code that would cause CF to handle empty list elements properly. Rick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Default Value for Select box - Very Urgent!!!
If it is THAT urgent, the fastest method is RTFM ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282462 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 Editor
On 6/28/07, Doug Bezona [EMAIL PROTECTED] wrote: On 6/28/07, Heald, Timothy (NIH/CIT) [C] [EMAIL PROTECTED] wrote: As an aside, anyone playing with the JSEclispe plug-in on labs? I've been using it for a while now, and really enjoy it. On of the best features is that you can select a chunk of inline JS in a CFM or HTML file, right click, and open it in JSEclipse - it opens a temp file of just the JS code, with all of the JSEclipse editing features available, and when you save, it syncs it up with the original source file. Wow! I've been using it since before Adobe bought Interakt and I had no idea you could do that. Nice! -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Newsletter Application
I am looking for a commercial coldfusion newsletter application. Ease of use and ease of integration are top priority. It only needs basic features, multiple lists, template emails and opt-out via web link (to a custom page) Any suggestions would be great. Thanks. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yay CFML enhancements
And there goes Allaire saying it was desiged that way and will never fix it too. If that is true, a very big yaaahh. On 6/28/07, Rick Root [EMAIL PROTECTED] wrote: I didn't catch this little enhancement in any of my previous CF8 presos, but apparently the ListToArray() function has been enhanced to understand empty list elements. I didn't notice if the other list functions have.. and I forgot to ask. but... ListToArray(5,3,,4) *can* be handled properly now (it's an optional argument, which I can't remember off the top of my head right now) I don't know about the rest of you, but I got awfully tired of writing code that would cause CF to handle empty list elements properly. Rick ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Tracking users actions in MS Office
Hi all, Was wondering if anyone has any experience they'd like to share on the following: I am trying to figure out how I can go about opening an MS Office document (be it Word, Excel etc.) into a clients browser (using their own licensed copy of Office of course) and then tracking their actions while they make changes to that particular document. The document doesn't have to be saved back to the server; I just need to track their actions within the document. I want to capture these actions and simply write them to a database for review. Any help/suggestions or ideas on this topic would be greatly appreciated!!! ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Newsletter Application
I don't know of a commercial CF app. I've certainly built a few of these in my career. What I use currently for clients is http://www.mailbuild.com/ . It takes all of the hassle out of programming and sending email newsletters. Also it has an api that lets you programatically manage subscribers. Dave On Jun 28, 2007, at 9:58 AM, Ricardo Russon wrote: I am looking for a commercial coldfusion newsletter application. Ease of use and ease of integration are top priority. It only needs basic features, multiple lists, template emails and opt-out via web link (to a custom page) Any suggestions would be great. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282467 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 Editor
I guess I'll throw some of my 2 cents in here now. I've been using CFEclipse for about 3-4 years now, and I would use nothing else at this point. Like many have said, there are many good plugins to do whatever it is your heart desires. Ok, now my tip of the day: CTRL+K - If you've done a previous search, and not in the search window any longer, CTRL+K will do the equivalent of a Find Next. Another good tip is if you highlight something, and just hit CTRL+K, it will use that as the new search and Find Next. When I typically search a document, if I can't highlight text, I'll open up CTRL+F, enter my search, hit enter, then close my search and stick with using CTRL+K. CTRL+L - Goes to line number (Probably a given?). Oh, and btw... I'd assume a lot of us, at some point in our career, have printed out a keyboard shortcut list of some sort. Well, you can get a list of keyboard shortcuts, which we all should know by know that they are customizable, and then you can export the data and print them off as reference too. Maybe we can all come up with a HUGE list of the best Keyboard Shortcut lists that is superb for CF Developers? -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 9:40 AM To: CF-Talk Subject: Re: CF Editor On 6/28/07, Doug Bezona [EMAIL PROTECTED] wrote: On 6/28/07, Heald, Timothy (NIH/CIT) [C] [EMAIL PROTECTED] wrote: As an aside, anyone playing with the JSEclispe plug-in on labs? I've been using it for a while now, and really enjoy it. On of the best features is that you can select a chunk of inline JS in a CFM or HTML file, right click, and open it in JSEclipse - it opens a temp file of just the JS code, with all of the JSEclipse editing features available, and when you save, it syncs it up with the original source file. Wow! I've been using it since before Adobe bought Interakt and I had no idea you could do that. Nice! -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Tracking users actions in MS Office
Are you trying to produce a big brother system? J/K. I'd like to see if this is even possible. It wouldn't sound so, because you're needing Dekstop API access via a Web Browser. My guess is that you'll be better off looking to some ActiveX Control that'll have to be installed on the users machine. - Doug -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 10:10 AM To: CF-Talk Subject: Tracking users actions in MS Office Hi all, Was wondering if anyone has any experience they'd like to share on the following: I am trying to figure out how I can go about opening an MS Office document (be it Word, Excel etc.) into a clients browser (using their own licensed copy of Office of course) and then tracking their actions while they make changes to that particular document. The document doesn't have to be saved back to the server; I just need to track their actions within the document. I want to capture these actions and simply write them to a database for review. Any help/suggestions or ideas on this topic would be greatly appreciated!!! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Server 2005 Express on dual CPU machine?
SQL Server 2005 Express is limited to not work on systems with two processors. Does anyone know what happens if you try to install it on such a machine - will it limit itself to running on one CPU or will it simply not install? I wanted to install it to do some testing but our only available (non essential) server still has two processors though it's only a P3 @ 1ghz. Thanks. Damien McKenna Web Developer The LIMU Company ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Newsletter Application
I believe that Ray had a series on his site on how to build one. Thanks, Phil -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 11:09 AM To: CF-Talk Subject: Re: Newsletter Application I don't know of a commercial CF app. I've certainly built a few of these in my career. What I use currently for clients is http://www.mailbuild.com/ . It takes all of the hassle out of programming and sending email newsletters. Also it has an api that lets you programatically manage subscribers. Dave On Jun 28, 2007, at 9:58 AM, Ricardo Russon wrote: I am looking for a commercial coldfusion newsletter application. Ease of use and ease of integration are top priority. It only needs basic features, multiple lists, template emails and opt-out via web link (to a custom page) Any suggestions would be great. Thanks. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Server 2005 Express on dual CPU machine?
To answer my own question: http://support.microsoft.com/default.aspx/kb/914278 Microsoft SQL Server 2005 Express Edition can only use one CPU, even if the computer has more than one CPU. So it can be installed on a multi-CPU machine, it'll just limit how it works. Perfect. Damien McKenna Web Developer The LIMU Company ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282472 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 Editor
Yeah, I guess that's a start. But even I figured out how to install one plugin - CFEclipse. I'm more interested in the uber-geek dozens of plugins and configurations/strategies I've heard in this thread. Makes me think I'm behind the curve using Homesite. In my own case, the plugins I'm using are largely dictated by the specific work I'm doing, and I didn't have to know very much to set them up. Which is good, because I really don't know all that much about the plugin architecture, etc. Everything worked pretty smoothly, actually. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Newsletter Application
I have no idea on cost, but my client owned this before I took over and this has worked well. Handles bounce tracking, templates, opt out, multiple lists, user sign up, the whole shebang. Works very well for us. http://www.2simplifi.com/ws/page.cfm?pid=1sid=3 Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 11:09 AM To: CF-Talk Subject: Re: Newsletter Application I don't know of a commercial CF app. I've certainly built a few of these in my career. What I use currently for clients is http://www.mailbuild.com/ . It takes all of the hassle out of programming and sending email newsletters. Also it has an api that lets you programatically manage subscribers. Dave On Jun 28, 2007, at 9:58 AM, Ricardo Russon wrote: I am looking for a commercial coldfusion newsletter application. Ease of use and ease of integration are top priority. It only needs basic features, multiple lists, template emails and opt-out via web link (to a custom page) Any suggestions would be great. Thanks. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Newsletter Application
Thanks david, But i am not sure that the client would go for having another company having any type of control over their mailing list. I really need to find something that i can install on their servers. On 6/29/07, David Livingston [EMAIL PROTECTED] wrote: I don't know of a commercial CF app. I've certainly built a few of these in my career. What I use currently for clients is http://www.mailbuild.com/ . It takes all of the hassle out of programming and sending email newsletters. Also it has an api that lets you programatically manage subscribers. Dave On Jun 28, 2007, at 9:58 AM, Ricardo Russon wrote: I am looking for a commercial coldfusion newsletter application. Ease of use and ease of integration are top priority. It only needs basic features, multiple lists, template emails and opt-out via web link (to a custom page) Any suggestions would be great. Thanks. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiple CF instances on same server
On Thursday 28 Jun 2007, Cutter (CFRelated) wrote: Think about it in terms of math. An instance of CF can only utilize 1G of RAM because of the JVMs limitations. Cough. Get a recent JVM and/or a 64-bit O/S: http://www.google.com/search?hl=enq=java+address+four+gigabytesbtnG=Search -- Tom Chiverton Helping to conveniently innovate granular e-commerce on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Newsletter Application
Philip, I couldn't find anything there, but digging around the site did lead me to : http://emailcampaign.riaforge.org/ looks like exactly what i want, but all the links are going to 404's I will keep looking, but if anyone has any info on the project please let me know. Thanks. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Newsletter Application
oops, forget that, just saw 4/23/2007 - Temporarily down for some copy edits. :) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Tracking users actions in MS Office
Hi Doug, you're exactly right...unless JS has some hidden qualities I'm unaware of. Just wondering what others out there think and if anyone has already overcome this problem (be it with a 3rd party ActiveX control) It'll be interesting to see if anyone actually has done this before! - Niall -Original Message- From: Doug Arthur [mailto:[EMAIL PROTECTED] Sent: 28 June 2007 16:22 To: CF-Talk Subject: RE: Tracking users actions in MS Office Are you trying to produce a big brother system? J/K. I'd like to see if this is even possible. It wouldn't sound so, because you're needing Dekstop API access via a Web Browser. My guess is that you'll be better off looking to some ActiveX Control that'll have to be installed on the users machine. - Doug -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 10:10 AM To: CF-Talk Subject: Tracking users actions in MS Office Hi all, Was wondering if anyone has any experience they'd like to share on the following: I am trying to figure out how I can go about opening an MS Office document (be it Word, Excel etc.) into a clients browser (using their own licensed copy of Office of course) and then tracking their actions while they make changes to that particular document. The document doesn't have to be saved back to the server; I just need to track their actions within the document. I want to capture these actions and simply write them to a database for review. Any help/suggestions or ideas on this topic would be greatly appreciated!!! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Newsletter Application
Ray's series was a mailing list, but that should be a good starting point. Not sure about that project. Here's Ray's first post in his series: http://www.coldfusionjedi.com/index.cfm/2006/5/22/Creating-a-Mailing-Lis t-in-ColdFusion-Part-1, Phil -Original Message- From: Ricardo Russon [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 12:05 PM To: CF-Talk Subject: Re: Newsletter Application Philip, I couldn't find anything there, but digging around the site did lead me to : http://emailcampaign.riaforge.org/ looks like exactly what i want, but all the links are going to 404's I will keep looking, but if anyone has any info on the project please let me know. Thanks. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Newsletter Application
Thanks chris, I will look into this one more. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple CF instances on same server
That would be fantastic! (If ColdFusion was 64bit, and supported on any other 64 bit platform other than Solaris) Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Tom Chiverton wrote: On Thursday 28 Jun 2007, Cutter (CFRelated) wrote: Think about it in terms of math. An instance of CF can only utilize 1G of RAM because of the JVMs limitations. Cough. Get a recent JVM and/or a 64-bit O/S: http://www.google.com/search?hl=enq=java+address+four+gigabytesbtnG=Search ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yay CFML enhancements
Amen brother! =) Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Rick Root wrote: I didn't catch this little enhancement in any of my previous CF8 presos, but apparently the ListToArray() function has been enhanced to understand empty list elements. I didn't notice if the other list functions have.. and I forgot to ask. but... ListToArray(5,3,,4) *can* be handled properly now (it's an optional argument, which I can't remember off the top of my head right now) I don't know about the rest of you, but I got awfully tired of writing code that would cause CF to handle empty list elements properly. Rick ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282484 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 Editor
Sounds to me like your system is so old that it would pay to buy a new PC with 2-4GB of ram instead of upgrading the current ram. Yup, exactly. Although my system is not *that* old, I purchased it 4 years ago, we're not talking a 486 here. But does return to my original point that telling people to upgrade their RAM if Eclipse is being a hog is not always a viable solution. I can't really afford to upgrade my entire system at the moment (not to mention the time involved in reinstalling all my software) so have to make due to 1 gig in the meantime. Actually I have a lot less issues running Eclipse than when I'm working in Photoshop! Now there's an application I really wish I had 2 gig for. Mary Jo ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Calling a CFC within onApplicationEnd
I am currently having the same issue... when I use cfinvoke in my onApplicationEnd... doesnt matter what component, what method it fails everytime... I used cftry to catch the error... coldfusion.xml.rpc.CFCServlet cannot be cast to coldfusion.runtime.CFPage Any help for the two of us would be great!! When I restart CFMX and request a page, the onApplicationStart fires and successfully sends out an email, but onApplicationEnd consistently fails to send out the confirmation email. If I move the code to a simple .cfm file it is processed correctly, so it must be related to onApplicationEnd. Are there limitations on the types of requests the onApplicationEnd function can make when called? For example, is there any restriction on its ability to call a component (ObjectChef)? Thanks, David ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282486 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using CFINVOKE in onApplicationEnd
Has anyone else ever had a problem invoking a method from another component within onApplicationEnd I used cftry to catch the error: coldfusion.xml.rpc.CFCServlet cannot be cast to coldfusion.runtime.CFPage cffunction name=onApplicationEnd returntype=void output=false cfargument name=applicationScope required=true cftry cfinvoke component=system.settings method=save cfcatch type=any cflog file=constps text=#cfcatch.Message# /cfcatch /cftry !--- Log Application End --- cflog file=constps text=App Ended /cffunction ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282487 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Replacing #38; with
cfset thisTerm = Replace(thisTerm, ##38;, , all) I'm using this code to attempt to replace #38; with because ; is also a list delimiter in the array that this is being inserted into It screws up the looping, without making this change.. My problem is this: If I escape the pound sign ## it doesn't seem to see the string. If I don't it errors out. Any ideas? -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282489 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using CFINVOKE in onApplicationEnd
Josh Eby wrote: Does any code in your onApplicationEnd and|or any components called within it use application or session variables? These variable scopes are destroyed and no longer exist before the onApplicaitonEnd event is fired so I would expect any attempt to access them to cause a failure. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing #38; with
cfset thisTerm = Replace(thisTerm, ##38;, , all) You have a space before in the first string, and not in the second. Is it on purpose? Could it be the source of your problem. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282490 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 #38; with
In the actual code the space isn't there, it's prolly a fat finger error on my part. -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 2:07 PM To: CF-Talk Subject: Re: Replacing with cfset thisTerm = Replace(thisTerm, ##38;, , all) You have a space before in the first string, and not in the second. Is it on purpose? Could it be the source of your problem. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282491 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS SQL XML Datatype
So is there any advantage or reason I should be storing XML data in a XML field vs. varchar?? ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL to Retrieve One Record from Several Possible Records
I am trying to select records based on a precedence. I'm using SQL2005. These records are address records for our students and employees. Each person will have, at least, one address, but many people will have more than one address. The addresses are coded so that we know the type of address: H = Home, LOC = Local, RMA = Room Assignment. I want to pull only one record based on a precedence. For example, if I find an RMA record, then I want to pull that and no other records. If there is no RMA record, I need to find a LOC record, if one exists. Repeat as needed until I find that last address type. The precedence is: 1 - RMA 2 - LOC 3 - H Here is the first step to find the address type in the order I need: SELECT DISTINCT TOP 1 pseason.id ,pseason.addr_type ,pseason.person_addresses ,CASE WHEN pseason.addr_type = 'H' THEN 1 WHEN pseason.addr_type = 'AM' THEN 2 WHEN pseason.addr_type = 'ISIR' THEN 3 ELSE 999 END AS sortOrder FROM PSeason WHERE pseason.id = '133' ORDER BY sortOrder Is there a better way to select these records? Thanks M!ke ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282493 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL XML Datatype
Yep. You can actually store a DTD in the SQL database that will validate any XML inserted into it if you wish. I believe you can also build very fast indices over an XML field, where a text field w/ full text index may not be as zippy. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Chad Gray Sent: Thursday, June 28, 2007 2:52 PM To: CF-Talk Subject: MS SQL XML Datatype So is there any advantage or reason I should be storing XML data in a XML field vs. varchar?? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL to Retrieve One Record from Several Possible Records
You could do multiple joins and check for null in your case statement. (this is assuming you have multiple addresses in a separate table with a primary key somehow relating to your main user database. In my example I am joining your pSeason file with the alias A to my theoretical pAddresses file with alias B against B.seasonID. Then I join it using a left join 2 more times. If a left join returns no record, it will return NULL when checking for that field.) Hope this helps and hope it makes sense! SELECT pseason.id ,pseason.addr_type ,pseason.person_addresses ,CASE WHEN A.addr_type IS NOT NULL THEN A.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NOT NULL THEN B.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NULL THEN C.myAddressField ELSE 'No Address Found' END AS SeasonAddress FROM Pseason A LEFT JOIN Paddresses B ON A.id = B.seasonID AND B.addr_type = 'H' LEFT JOIN Paddresses C ON A.id = C.seasonID AND C.addr_type = 'AM' LEFT JOIN Paddresses D ON A.id = D.seasonID AND D.addr_type = 'ISIR' WHERE pseason.id = '133' Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer --- From: Dawson, Michael Sent: Thursday, June 28, 2007 2:56 PM To: CF-Talk Subject: SQL to Retrieve One Record from Several Possible Records I am trying to select records based on a precedence. I'm using SQL2005. These records are address records for our students and employees. Each person will have, at least, one address, but many people will have more than one address. The addresses are coded so that we know the type of address: H = Home, LOC = Local, RMA = Room Assignment. I want to pull only one record based on a precedence. For example, if I find an RMA record, then I want to pull that and no other records. If there is no RMA record, I need to find a LOC record, if one exists. Repeat as needed until I find that last address type. The precedence is: 1 - RMA 2 - LOC 3 - H Here is the first step to find the address type in the order I need: SELECT DISTINCT TOP 1 pseason.id ,pseason.addr_type ,pseason.person_addresses ,CASE WHEN pseason.addr_type = 'H' THEN 1 WHEN pseason.addr_type = 'AM' THEN 2 WHEN pseason.addr_type = 'ISIR' THEN 3 ELSE 999 END AS sortOrder FROM PSeason WHERE pseason.id = '133' ORDER BY sortOrder Is there a better way to select these records? Thanks M!ke ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL XML Datatype
So is there any advantage or reason I should be storing XML data in a XML field vs. varchar?? Yes, the same reason you use other specific datatypes in SQL. The database can validate your data, for example. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282496 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 question, just happy
Adobe must be on the ball now, I got my certificates in the mail today. Just over a week since I took the tests! It threw me for a loop at first too, because they send a cert for 'Certified Coldfusion MX 7 Developer', and one for Advanced as well. =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 8:32 AM To: CF-Talk Subject: RE: No question, just happy Does anyone know if they send you a certificate or anything like that? Yes, they do. It can take a long time to arrive, though. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282497 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MS SQL XML Datatype
Call me crazy, but I've just never liked the idea of storing XML in the database in any form. The first form of normalization states that each column should hold an atomic value and XML is anything but that. Maybe I'm old-school, but if I wanted to store a set of complex, nested data; I would use a series of tables with separate columns for each piece. If I was forced to handle XML, then that seems like work for a higher tier like a CF or Java application. At my job we do use XML to communicate between our internal apps (CF, ASP, Java, PowerBuilder), our customer's external apps, and even to pass large amounts of data to stored procs, but all that happens at the application level. We don't store XML in the database ever. I like Microsoft's ingenuity there, but it just doesn't sit right with me. Am I just stuck in the mud, or is this really one of those things that SQL server CAN do, but shouldn't necessarily do? ~Brad -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 2:16 PM To: CF-Talk Subject: RE: MS SQL XML Datatype So is there any advantage or reason I should be storing XML data in a XML field vs. varchar?? Yes, the same reason you use other specific datatypes in SQL. The database can validate your data, for example. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL to Retrieve One Record from Several Possible Records
Chris, thanks! This is an interesting solution. I assume that if I have more than three address types, then I will need a left join for each additional type? I assume I will also need to add another when to my case statement. At this point, I'm only interested in finding the first-found value in a list. The addresses are then linked with a PK/FK relation that will be easy to join. I have to go to a meeting, so I'll mess around with this when I get bored. Thanks -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 2:07 PM To: CF-Talk Subject: RE: SQL to Retrieve One Record from Several Possible Records You could do multiple joins and check for null in your case statement. (this is assuming you have multiple addresses in a separate table with a primary key somehow relating to your main user database. In my example I am joining your pSeason file with the alias A to my theoretical pAddresses file with alias B against B.seasonID. Then I join it using a left join 2 more times. If a left join returns no record, it will return NULL when checking for that field.) Hope this helps and hope it makes sense! SELECT pseason.id ,pseason.addr_type ,pseason.person_addresses ,CASE WHEN A.addr_type IS NOT NULL THEN A.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NOT NULL THEN B.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NULL THEN C.myAddressField ELSE 'No Address Found' END AS SeasonAddress FROM Pseason A LEFT JOIN Paddresses B ON A.id = B.seasonID AND B.addr_type = 'H' LEFT JOIN Paddresses C ON A.id = C.seasonID AND C.addr_type = 'AM' LEFT JOIN Paddresses D ON A.id = D.seasonID AND D.addr_type = 'ISIR' WHERE pseason.id = '133' Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer --- From: Dawson, Michael Sent: Thursday, June 28, 2007 2:56 PM To: CF-Talk Subject: SQL to Retrieve One Record from Several Possible Records I am trying to select records based on a precedence. I'm using SQL2005. These records are address records for our students and employees. Each person will have, at least, one address, but many people will have more than one address. The addresses are coded so that we know the type of address: H = Home, LOC = Local, RMA = Room Assignment. I want to pull only one record based on a precedence. For example, if I find an RMA record, then I want to pull that and no other records. If there is no RMA record, I need to find a LOC record, if one exists. Repeat as needed until I find that last address type. The precedence is: 1 - RMA 2 - LOC 3 - H Here is the first step to find the address type in the order I need: SELECT DISTINCT TOP 1 pseason.id ,pseason.addr_type ,pseason.person_addresses ,CASE WHEN pseason.addr_type = 'H' THEN 1 WHEN pseason.addr_type = 'AM' THEN 2 WHEN pseason.addr_type = 'ISIR' THEN 3 ELSE 999 END AS sortOrder FROM PSeason WHERE pseason.id = '133' ORDER BY sortOrder Is there a better way to select these records? Thanks M!ke ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282498 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 question, just happy
Wow, they must have revamped that from a year ago. I know that the guys in my study group here in Nashville... Kroll represent!... all took many months to get their certs. So once they get the CF8 cert we have a year to get re-certified? J.J. On 6/28/07, Peterson, Chris [EMAIL PROTECTED] wrote: Adobe must be on the ball now, I got my certificates in the mail today. Just over a week since I took the tests! It threw me for a loop at first too, because they send a cert for 'Certified Coldfusion MX 7 Developer', and one for Advanced as well. =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 8:32 AM To: CF-Talk Subject: RE: No question, just happy Does anyone know if they send you a certificate or anything like that? Yes, they do. It can take a long time to arrive, though. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL to Retrieve One Record from Several Possible Records
,CASE WHEN A.addr_type IS NOT NULL THEN A.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NOT NULL THEN B.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NULL THEN C.myAddressField ELSE 'No Address Found' END AS SeasonAddress rather than these CASE statements, you could use COALESCE...the myAddressField should be NULL if the addr_type is NULL COALESCE(a.myAddressField,b.myAddressField,c.myAddressField,'No Address Found') AS SeasonAddress ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282502 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 #38; with
It screws up the looping, without making this change.. Ok, which looping? Can you show a bit more of the code? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282500 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL XML Datatype
Brad, I used XML to store an un-known amount of data coming from the form scope. I wanted to, in my debug template, store any variable coming in to a page via form, url, etc. I made my primary DB columns things like IP, requested page, date time, etc. Then I made an XML column called 'variables' and stuck all my user variables into that. Just one use where XML makes sense =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 3:31 PM To: CF-Talk Subject: RE: MS SQL XML Datatype Call me crazy, but I've just never liked the idea of storing XML in the database in any form. The first form of normalization states that each column should hold an atomic value and XML is anything but that. Maybe I'm old-school, but if I wanted to store a set of complex, nested data; I would use a series of tables with separate columns for each piece. If I was forced to handle XML, then that seems like work for a higher tier like a CF or Java application. At my job we do use XML to communicate between our internal apps (CF, ASP, Java, PowerBuilder), our customer's external apps, and even to pass large amounts of data to stored procs, but all that happens at the application level. We don't store XML in the database ever. I like Microsoft's ingenuity there, but it just doesn't sit right with me. Am I just stuck in the mud, or is this really one of those things that SQL server CAN do, but shouldn't necessarily do? ~Brad ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282503 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
argumentcollection
When using argumentcollection can you dump in a query? I have done argumentCollection=form in the past to take the form structure from a page and dump it in, but what about a query? This returns a query with data from a database cfinvoke component=com.mySite method=readRecord returnVariable=qry cfinvokeargument name=ID value=#variables.ID# /cfinvoke I want to dump the query from above into this function that does a database insert. cfset create = CreateObject(component,com.mySite) / cfset create.createRecord(argumentCollection=qry) / If not, is there a way to convert my query into a structure that I can dump into it? ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: argumentcollection
Afaik you must do the conversion yourself. You might be interested in the QueryRowToStruct() function http://www.cflib.org/udf.cfm?ID=358 Or you could create a method that accepts a query object and row number. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MS SQL XML Datatype
Yeah, I see what you are saying. You could have easily had a separate attributes table with name and value columns and a record per variable, but that could definitely seem like overkill when you basically just want to stick the equivalent of a core dump somewhere for later troubleshooting. Don't think I was dogging on you for storing XML or anything, the thread just triggered something I've thought/wondered a lot about and I wanted to see what other people's take on it was. ;- Come to think of it, we have been known to wddx form and url structs for storage in our DB error logging too. ~Brad -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 3:01 PM To: CF-Talk Subject: RE: MS SQL XML Datatype Brad, I used XML to store an un-known amount of data coming from the form scope. I wanted to, in my debug template, store any variable coming in to a page via form, url, etc. I made my primary DB columns things like IP, requested page, date time, etc. Then I made an XML column called 'variables' and stuck all my user variables into that. Just one use where XML makes sense =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 3:31 PM To: CF-Talk Subject: RE: MS SQL XML Datatype Call me crazy, but I've just never liked the idea of storing XML in the database in any form. The first form of normalization states that each column should hold an atomic value and XML is anything but that. Maybe I'm old-school, but if I wanted to store a set of complex, nested data; I would use a series of tables with separate columns for each piece. If I was forced to handle XML, then that seems like work for a higher tier like a CF or Java application. At my job we do use XML to communicate between our internal apps (CF, ASP, Java, PowerBuilder), our customer's external apps, and even to pass large amounts of data to stored procs, but all that happens at the application level. We don't store XML in the database ever. I like Microsoft's ingenuity there, but it just doesn't sit right with me. Am I just stuck in the mud, or is this really one of those things that SQL server CAN do, but shouldn't necessarily do? ~Brad ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282506 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 #38; with
I got it, I was looking in the wrong place sas -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 3:39 PM To: CF-Talk Subject: Re: Replacing with It screws up the looping, without making this change.. Ok, which looping? Can you show a bit more of the code? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: argumentcollection
When using argumentcollection can you dump in a query? I have done argumentCollection=form in the past to take the form structure from a page and dump it in, but what about a query? Just pass it in a an argument and in the method type it as a query .so no...don't use argumentcollection Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL to Retrieve One Record from Several Possible Records
Just to offer an alternate. Instead of those time consuming case statements and joins, you could just add a new table to assign a sort order value to each of the Types, such as you said the table would look like this 1 - RMA 2 - LOC 3 - H Where the numeric value would be the type's ordering ID Then you could do a simple query with a basic join off of this table, order by it and only take the top record. This would be the simplest approach to solving the problem, but only if you can add another table. cfquery SELECT DISTINCT TOP 1 pseason.id ,pseason.addr_type ,pseason.person_addresses FROM PSeason INNER JOIN RoomTypes ON PSeason.addr_type = RoomTypes.addr_type WHERE pseason.id = '133' ORDER BY RoomTypes.OrderID /cfquery -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282509 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 question, just happy
Now, if only they meant something :-) This comes up now and again, but do people really are this cert as worth anything? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: J.J. Merrick To: CF-Talk Sent: Thu Jun 28 20:43:12 2007 Subject: Re: No question, just happy Wow, they must have revamped that from a year ago. I know that the guys in my study group here in Nashville... Kroll represent!... all took many months to get their certs. So once they get the CF8 cert we have a year to get re-certified? J.J. On 6/28/07, Peterson, Chris [EMAIL PROTECTED] wrote: Adobe must be on the ball now, I got my certificates in the mail today. Just over a week since I took the tests! It threw me for a loop at first too, because they send a cert for 'Certified Coldfusion MX 7 Developer', and one for Advanced as well. =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 8:32 AM To: CF-Talk Subject: RE: No question, just happy Does anyone know if they send you a certificate or anything like that? Yes, they do. It can take a long time to arrive, though. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282510 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 Editor
3-4 years? Has it even been out that long? CFEclipse plugin I mean, not Eclipse IDE. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Doug Arthur To: CF-Talk Sent: Thu Jun 28 16:15:14 2007 Subject: RE: CF Editor I guess I'll throw some of my 2 cents in here now. I've been using CFEclipse for about 3-4 years now, and I would use nothing else at this point. Like many have said, there are many good plugins to do whatever it is your heart desires. Ok, now my tip of the day: CTRL+K - If you've done a previous search, and not in the search window any longer, CTRL+K will do the equivalent of a Find Next. Another good tip is if you highlight something, and just hit CTRL+K, it will use that as the new search and Find Next. When I typically search a document, if I can't highlight text, I'll open up CTRL+F, enter my search, hit enter, then close my search and stick with using CTRL+K. CTRL+L - Goes to line number (Probably a given?). Oh, and btw... I'd assume a lot of us, at some point in our career, have printed out a keyboard shortcut list of some sort. Well, you can get a list of keyboard shortcuts, which we all should know by know that they are customizable, and then you can export the data and print them off as reference too. Maybe we can all come up with a HUGE list of the best Keyboard Shortcut lists that is superb for CF Developers? -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 9:40 AM To: CF-Talk Subject: Re: CF Editor On 6/28/07, Doug Bezona [EMAIL PROTECTED] wrote: On 6/28/07, Heald, Timothy (NIH/CIT) [C] [EMAIL PROTECTED] wrote: As an aside, anyone playing with the JSEclispe plug-in on labs? I've been using it for a while now, and really enjoy it. On of the best features is that you can select a chunk of inline JS in a CFM or HTML file, right click, and open it in JSEclipse - it opens a temp file of just the JS code, with all of the JSEclipse editing features available, and when you save, it syncs it up with the original source file. Wow! I've been using it since before Adobe bought Interakt and I had no idea you could do that. Nice! -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282511 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 question, just happy
On 6/28/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Now, if only they meant something :-) This comes up now and again, but do people really are this cert as worth anything? why would you do this? did you not get enough woo-ha excitement in the eclipse thread? :) -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282512 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
how can I dynamically build field names string in a sql update statement?
Hi,
I'm trying to construct a dynamic sql server update statement on a table with a
large number of fields, most of them type bit. First I evaluate all the
yes/no fields and convert them to 1/0. Then I build a string of column
(field) names and values, e.g, {name of field1}=0, {name of field2}=1, etc.,
iterating through all of the fields for the table.
Then I try to execute the query:
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
However, Coldfusion 6.0 bombs on #column_string#. How can I accomplish this?
Thanks much for your help!
Here is the code:
cfset numvar=0
cfset charvar=
cfset column_namestring=
cfset column_valstring=
cfset column_string=
cfset query_string=
cfquery name=bitfields datasource=rhcaccesssql
select column_name, data_type from information_schema.columns where
table_name='Requests' and data_type='bit'
/cfquery
!---
cfloop query=bitfields startrow=2
cfset column_namestring=, #column_name# =
cfif data_type eq varchar or data_type eq nvarchar
cfset charvar = evaluate(#column_name#)
cfset column_valstring=' charvar '
cfelse
cfset numvar=evaluate(#column_name#)
cfif data_type eq bit
cfif numvar eq yes
cfset numvar = 1
/cfif
cfif numvar eq no
cfset numvar = 0
/cfif
/cfif
cfset column_valstring=numvar
/cfif
cfset column_string = column_string column_namestring
column_valstring
/cfloop
cfset column_string=mid(column_string,2,len(column_string)-1)
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282513
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: argumentcollection
Doh! I thought you meant an existing function. Bryan's right. Just change the argument type of your function to query. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: how can I dynamically build field names string in a sql update statement?
define bombs and do a cfoutput on #column_string# to see exactly
what SQL you're generating.
On 6/28/07, david cowen [EMAIL PROTECTED] wrote:
Hi,
I'm trying to construct a dynamic sql server update statement on a table with
a large number of fields, most of them type bit. First I evaluate all the
yes/no fields and convert them to 1/0. Then I build a string of column
(field) names and values, e.g, {name of field1}=0, {name of field2}=1, etc.,
iterating through all of the fields for the table.
Then I try to execute the query:
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
However, Coldfusion 6.0 bombs on #column_string#. How can I accomplish this?
Thanks much for your help!
Here is the code:
cfset numvar=0
cfset charvar=
cfset column_namestring=
cfset column_valstring=
cfset column_string=
cfset query_string=
cfquery name=bitfields datasource=rhcaccesssql
select column_name, data_type from information_schema.columns where
table_name='Requests' and data_type='bit'
/cfquery
!---
cfloop query=bitfields startrow=2
cfset column_namestring=, #column_name# =
cfif data_type eq varchar or data_type eq nvarchar
cfset charvar = evaluate(#column_name#)
cfset column_valstring=' charvar '
cfelse
cfset numvar=evaluate(#column_name#)
cfif data_type eq bit
cfif numvar eq yes
cfset numvar = 1
/cfif
cfif numvar eq no
cfset numvar = 0
/cfif
/cfif
cfset column_valstring=numvar
/cfif
cfset column_string = column_string column_namestring
column_valstring
/cfloop
cfset column_string=mid(column_string,2,len(column_string)-1)
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282515
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: how can I dynamically build field names string in a sql update statement?
Well, without trying the code out or looking real hard at it.. I see that
you have quotes around #column_strings# in your cfquery. Remove those and
see what happens first.
The next obvious step would be to take a look at the outputted (is that a
word?) SQL statement in the error message.
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: david cowen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 6:44 PM
To: CF-Talk
Subject: how can I dynamically build field names string in a sql update
statement?
Hi,
I'm trying to construct a dynamic sql server update statement on a table
with a large number of fields, most of them type bit. First I evaluate
all the yes/no fields and convert them to 1/0. Then I build a string of
column (field) names and values, e.g, {name of field1}=0, {name of
field2}=1, etc., iterating through all of the fields for the table.
Then I try to execute the query:
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
However, Coldfusion 6.0 bombs on #column_string#. How can I accomplish
this?
Thanks much for your help!
Here is the code:
cfset numvar=0
cfset charvar=
cfset column_namestring=
cfset column_valstring=
cfset column_string=
cfset query_string=
cfquery name=bitfields datasource=rhcaccesssql
select column_name, data_type from information_schema.columns where
table_name='Requests' and data_type='bit'
/cfquery
!---
cfloop query=bitfields startrow=2
cfset column_namestring=, #column_name# =
cfif data_type eq varchar or data_type eq nvarchar
cfset charvar = evaluate(#column_name#)
cfset column_valstring=' charvar '
cfelse
cfset numvar=evaluate(#column_name#)
cfif data_type eq bit
cfif numvar eq yes
cfset numvar = 1
/cfif
cfif numvar eq no
cfset numvar = 0
/cfif
/cfif
cfset column_valstring=numvar
/cfif
cfset column_string = column_string column_namestring
column_valstring /cfloop cfset
column_string=mid(column_string,2,len(column_string)-1)
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282516
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiple CF instances on same server
What I have seen is mostly for reliability and security. If obviously will be faster if you have a scenario where you have a honking huge machine such as what Cutter was referring to. I prefer to go the other way and get lots of cheap less powered servers and do the hardware load balancing thing. We tend to get 1U 1 CPU machines and get a lot of them. Our biggest thing was uptime and we found that this method helped that. It tended to be faster for us just because our main application was somewhat poorly written and had a lot of long running queries that would take up threads and lock a machine up while it ran. The load balancer would take this in to account and route traffic to the other servers... thus giving us a faster application overall. J.J. On 6/28/07, m g [EMAIL PROTECTED] wrote: Due to my concern of having to purchase multiple licenses in the event that I need a cluster of servers at some point in the future I was advised that this a legitimate concern by Adobe, however they also stated that CF Enterprise allows you to install multiple CF instances on the same box with the same license. What is the benefit of having multiple CF instances on the same server? Can this assist with speed of applications, database queries, etc.? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
XSD or DTD for cfform xml format?
I'm about to store the cfform xml into MS-SQL... Is there a XML Schema (XSD) or DTD available for xml generated by cfform format=xml? Thank you! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282518 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 question, just happy
For me... and of course I am the only one whom I can talk on behalf of... I got the most out of the study group here in Nashville that Aaron West so diligently lead. It also helped that I won the free cert coupon because I attended every one of the sessions. I don't know if it really holds much clout but I would have to say that if you are trying to get a job and you are up against someone who is not certified odds are that a manager is going to swing favorably in your way. That being said I know a LOT of great developers that have never gone and gotten the certification... does that make me better then them? nope! -J.J. On 6/28/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Now, if only they meant something :-) This comes up now and again, but do people really are this cert as worth anything? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: J.J. Merrick To: CF-Talk Sent: Thu Jun 28 20:43:12 2007 Subject: Re: No question, just happy Wow, they must have revamped that from a year ago. I know that the guys in my study group here in Nashville... Kroll represent!... all took many months to get their certs. So once they get the CF8 cert we have a year to get re-certified? J.J. On 6/28/07, Peterson, Chris [EMAIL PROTECTED] wrote: Adobe must be on the ball now, I got my certificates in the mail today. Just over a week since I took the tests! It threw me for a loop at first too, because they send a cert for 'Certified Coldfusion MX 7 Developer', and one for Advanced as well. =) Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 8:32 AM To: CF-Talk Subject: RE: No question, just happy Does anyone know if they send you a certificate or anything like that? Yes, they do. It can take a long time to arrive, though. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how can I dynamically build field names string in a sql update statement?
If I remove the quote marks, then the program fails on line 0 of this
routine; i.e., this code does not execute. With the quote marks, the
routine gets executed but fails and there is a sql statement in the
resulting error message. The sql statement has quote marks around the set
field1=0, set field2=1, set field3=0 portion.
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 6:20 PM
To: CF-Talk
Subject: RE: how can I dynamically build field names string in a sql update
statement?
Well, without trying the code out or looking real hard at it.. I see that
you have quotes around #column_strings# in your cfquery. Remove those and
see what happens first.
The next obvious step would be to take a look at the outputted (is that a
word?) SQL statement in the error message.
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: david cowen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 6:44 PM
To: CF-Talk
Subject: how can I dynamically build field names string in a sql update
statement?
Hi,
I'm trying to construct a dynamic sql server update statement on a table
with a large number of fields, most of them type bit. First I evaluate
all the yes/no fields and convert them to 1/0. Then I build a string of
column (field) names and values, e.g, {name of field1}=0, {name of
field2}=1, etc., iterating through all of the fields for the table.
Then I try to execute the query:
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
However, Coldfusion 6.0 bombs on #column_string#. How can I accomplish
this?
Thanks much for your help!
Here is the code:
cfset numvar=0
cfset charvar=
cfset column_namestring=
cfset column_valstring=
cfset column_string=
cfset query_string=
cfquery name=bitfields datasource=rhcaccesssql
select column_name, data_type from information_schema.columns where
table_name='Requests' and data_type='bit'
/cfquery
!---
cfloop query=bitfields startrow=2
cfset column_namestring=, #column_name# =
cfif data_type eq varchar or data_type eq nvarchar
cfset charvar = evaluate(#column_name#)
cfset column_valstring=' charvar '
cfelse
cfset numvar=evaluate(#column_name#)
cfif data_type eq bit
cfif numvar eq yes
cfset numvar = 1
/cfif
cfif numvar eq no
cfset numvar = 0
/cfif
/cfif
cfset column_valstring=numvar
/cfif
cfset column_string = column_string column_namestring
column_valstring /cfloop cfset
column_string=mid(column_string,2,len(column_string)-1)
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282520
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Create PowerPoint Files
Thanks for the suggestion. We looked at HSLF initially but it is still a work in progress and doesn't have everything we need. Looks like we'll be doing some digging into Aspose. It's amazing how difficult PPT is to work with despite being so popular. -Original Message- From: Heald, Timothy (NIH/CIT) [C] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 8:39 AM To: CF-Talk Subject: RE: Create PowerPoint Files POI, one of the Apache projects contains Java objects to allow you to create all different kinds of M$ format documents. The specific part of it for PowerPoint is HSLF. http://poi.apache.org/hslf/index.html -- Timothy J. Heald | NIH-Contractor | iGate Enterprise Business Intelligence Branch (EBIB) Division of Enterprise and Custom Applications, CIT/NIH/DHHS Office: 301.594.5611 | Fax: 301.443.7010 | Email: [EMAIL PROTECTED] -Original Message- From: Todd Mathews [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 7:43 PM To: CF-Talk Subject: Create PowerPoint Files We need to be able to create PPT file output from CF. Has anyone else done this that can share any info? We're looking at the Aspose components and would love to hear from anyone else who has used them or might have some CF centric sample code. It is amazing how difficult it is to write PPT files. We'd be in heaven if we could simply change the output type of a .cfr file to crank out the PPT docs since we already use it for the PDF version. Unfortunately it isn't that simple so it looks like we'll be using Aspose to do the job and code the output 'old school' to generate the PPT report. If anyone has any better suggestions or experience with Aspose, please share! ;) Todd ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Tracking users actions in MS Office
I don't know about tracking, but you can create excel docs using POI (go to the Jakarta Apache Project for more info...it is already included in CFMX). POI generated office docs using java methods without the need to have office installed on your server. Eric -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 10:10 AM To: CF-Talk Subject: Tracking users actions in MS Office Hi all, Was wondering if anyone has any experience they'd like to share on the following: I am trying to figure out how I can go about opening an MS Office document (be it Word, Excel etc.) into a clients browser (using their own licensed copy of Office of course) and then tracking their actions while they make changes to that particular document. The document doesn't have to be saved back to the server; I just need to track their actions within the document. I want to capture these actions and simply write them to a database for review. Any help/suggestions or ideas on this topic would be greatly appreciated!!! ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple CF instances on same server
Thanks Folks Am always impressed at the speed and depth of responses on this forum to assist others... A further question...I posed my original question on another forum and received the response from another user: I would not suggest having more than one instance of CF running on a server. Make use of the Sandbox with in CFMX and your server will run much better Could any of you please explain the above advice cheers ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: how can I dynamically build field names string in a sql update statement?
If I remove the quote marks, then the program fails on line 0 of this routine; i.e., this code does not execute. With the quote marks, the routine gets executed but fails and there is a sql statement in the resulting error message. The sql statement has quote marks around the set field1=0, set field2=1, set field3=0 portion. Definitely remove the quotes. The sql should work if fields 1,2 and 3 are bit type. But CF will automatically escape the single quotes here: cfset column_valstring=' charvar ' Causing a syntax error. You would need to use PreserveSingleQuotes(). Though it does pose a sql injection risk if you haven't scrubbed your params. Btw, you don't need # signs here and do you really need to use evaluate()? cfset charvar = evaluate(#column_name#) ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL to Retrieve One Record from Several Possible Records
I'n not the original poster but that does look like the cleanest approach I've seen so far. I think you can even use that in a select column subquery to handle a query for multiple people (or whatever pseason.id represents)... select person.*, (SELECT TOP 1 pseason.person_addresses FROM PSeason INNER JOIN RoomTypes ON PSeason.addr_type = RoomTypes.addr_type WHERE PSeason.id = person.id ORDER BY RoomTypes.OrderID ) as best_person_addresses FROM person WHERE -- put any constraints on person here, or join person to anything else person.id = '133' This looks nasty but SQL Server can a good do a decent job of optimizing this kind of query so it performs as good as a JOIN (but you want to check the query plan to make sure). Stick it in a view and you don't even have to look at it too often. The problem with it is you can only return one column from the subquery, but sometimes that's enough. - Mark From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Thu 6/28/2007 5:47 PM To: CF-Talk Subject: Re: SQL to Retrieve One Record from Several Possible Records Just to offer an alternate. Instead of those time consuming case statements and joins, you could just add a new table to assign a sort order value to each of the Types, such as you said the table would look like this 1 - RMA 2 - LOC 3 - H Where the numeric value would be the type's ordering ID Then you could do a simple query with a basic join off of this table, order by it and only take the top record. This would be the simplest approach to solving the problem, but only if you can add another table. cfquery SELECT DISTINCT TOP 1 pseason.id ,pseason.addr_type ,pseason.person_addresses FROM PSeason INNER JOIN RoomTypes ON PSeason.addr_type = RoomTypes.addr_type WHERE pseason.id = '133' ORDER BY RoomTypes.OrderID /cfquery -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282525 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MS SQL XML Datatype
Call me crazy, but I've just never liked the idea of storing XML in the database in any form. I generally agree with you, but just like almost anything else, you should never say never. There are occasional cases where you want to store denormalized data, and sometimes that data may be XML. For example, if I wanted to store LiveCycle Designer forms in a database - the forms themselves, rather than their visual PDF representation - I'd store the raw XFA content (which is XML) rather than trying to represent them with a normalized data structure. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: XSD or DTD for cfform xml format?
I'm about to store the cfform xml into MS-SQL... Is there a XML Schema (XSD) or DTD available for xml generated by cfform format=xml? Since CFFORM's XML is XForms, I'd guess that it conforms to the XForms schema: http://www.w3.org/MarkUp/Forms/2002/XForms-Schema.xsd I haven't actually checked to make sure of this, though. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Multiple CF instances on same server
A further question...I posed my original question on another forum and received the response from another user: I would not suggest having more than one instance of CF running on a server. Make use of the Sandbox with in CFMX and your server will run much better Could any of you please explain the above advice If you're running multiple instances to isolate developers' permissions to their own sites, that will require more resources than running a single instance. On the other hand, multiple instances can improve performance and stability, by providing a separate memory space for each instance; a single instance on Windows can only use a little over 1 GB of RAM. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how can I dynamically build field names string in a sql update statement?
You do not want those quotes in your resulting SQL statement
Run this and give use the results
cfoutput
Update Requests Set br
#column_string#br
Where RequestID = #FindCurrent.requestID#
/cfoutput
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: David S. Cowen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 9:03 PM
To: CF-Talk
Subject: RE: how can I dynamically build field names string in a sql update
statement?
If I remove the quote marks, then the program fails on line 0 of this
routine; i.e., this code does not execute. With the quote marks, the
routine gets executed but fails and there is a sql statement in the
resulting error message. The sql statement has quote marks around the set
field1=0, set field2=1, set field3=0 portion.
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 6:20 PM
To: CF-Talk
Subject: RE: how can I dynamically build field names string in a sql update
statement?
Well, without trying the code out or looking real hard at it.. I see that
you have quotes around #column_strings# in your cfquery. Remove those and
see what happens first.
The next obvious step would be to take a look at the outputted (is that a
word?) SQL statement in the error message.
:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: david cowen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 6:44 PM
To: CF-Talk
Subject: how can I dynamically build field names string in a sql update
statement?
Hi,
I'm trying to construct a dynamic sql server update statement on a table
with a large number of fields, most of them type bit. First I evaluate
all the yes/no fields and convert them to 1/0. Then I build a string of
column (field) names and values, e.g, {name of field1}=0, {name of
field2}=1, etc., iterating through all of the fields for the table.
Then I try to execute the query:
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
However, Coldfusion 6.0 bombs on #column_string#. How can I accomplish
this?
Thanks much for your help!
Here is the code:
cfset numvar=0
cfset charvar=
cfset column_namestring=
cfset column_valstring=
cfset column_string=
cfset query_string=
cfquery name=bitfields datasource=rhcaccesssql
select column_name, data_type from information_schema.columns where
table_name='Requests' and data_type='bit'
/cfquery
!---
cfloop query=bitfields startrow=2
cfset column_namestring=, #column_name# =
cfif data_type eq varchar or data_type eq nvarchar
cfset charvar = evaluate(#column_name#)
cfset column_valstring=' charvar '
cfelse
cfset numvar=evaluate(#column_name#)
cfif data_type eq bit
cfif numvar eq yes
cfset numvar = 1
/cfif
cfif numvar eq no
cfset numvar = 0
/cfif
/cfif
cfset column_valstring=numvar
/cfif
cfset column_string = column_string column_namestring
column_valstring /cfloop cfset
column_string=mid(column_string,2,len(column_string)-1)
cfquery name=FindRequest datasource=rhcaccesssql
Update Requests Set
#column_string#
Where RequestID =
#FindCurrent.requestID#
/cfquery
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282529
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
query of queries question
I've not really needed to use a query of queries before, so here's a stupid question to be sure it's what I need The first set of query results comes from a search form. After the results are returned and displayed, I need to be able to refine that search based on a specific criteria. Filter your results based on When the filtered set is returned, I need to be able to apply yet another filter to refine the results even more and return a final set of records. OK, so the question - you'd cache the first query results. Then run your next filter, cache those results, and then run your final filter to return the final records - correct? Or is there a better way to do this? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF generated HTML to Word
Hi all, I have searched HOF and the net and found all kinds of different suggestions for outputing from CF to Word. However, I have not found out which method will work for MY situation: * Server does NOT have Office installed on it * I need my output to open in all versions of word from Word 97 forward * I need to retain my formatting including images and colors Can someone please give me the best approach to this? By the way, we are on CFMX 6.1. Dave ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiple CF instances on same server
Well, that's plain incorrect. The sandbox secures datasources, files and tags, preventing code in a specific directory from using resources it isn't supposed to use. It will make your server more secure but it's not going to make it run any better. On 6/29/07, m g [EMAIL PROTECTED] wrote: Make use of the Sandbox with in CFMX and your server will run much better -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
