Re: Synonym Dictionary
Just to confirm Dave's suggestion, Solr can do this, yes. If you get particularly down and dirty with your configuration, you can have individual fields in your search collection each with their own set of synonyms (amongst many other things). This is not possible using the native CF9 search and index methods and the setup would most certainly take some learning curve time (perhaps overkill for your problem). You can, AFAIK, setup a global synonym list in CF9 that should work fairly smoothly. Here's hoping 9.5 brings some extended Solr goodness :) Dominic On 1 May 2011 18:06, Dave Watts dwa...@figleaf.com wrote: hi dave, had a look at Google Search Appliance and thought it was only for searching our web pages, do you think i could possibly utilize it in some way to get the synonyms for my database searches? Well, as much as I love the appliance, I wasn't really recommending it for your use, as it's fairly expensive if you were to buy it just to solve this one problem. I was just pointing out that Solr/Lucene probably have similar synonym features. That said, yes, the appliance can index all sorts of content in addition to web pages. Database content, filesystem content, CMS/DMS content, Google Apps content, etc, etc. So, you could very easily build a search against your MySQL data that would use synonyms - in fact, we actually do that in the GSA classes I teach. If you have any questions about the Google Search Appliance, feel free to contact me off-list. Fig Leaf Software is a Google Enterprise partner - and the first certified Enterprise training partner - and we sell, implement, and train people on the appliance and on Google Apps. We provide quite a bit of training on behalf of Google, to other Google Enterprise partners, as well as to the public at large. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 SQL Server 2008 XML bulkload
First SQL has to be running under an account that has access to that directory. Then it is easiest if you make a share, then you reference it as \\sernername\sharename\filename Steve Sent from my iPhone On May 3, 2011, at 12:48 AM, Kam Heydari heyda...@yahoo.com wrote: Hi, Anyone know how to pass file name to the bulkload when sqlserver and coldfision servers are on different physical servers; The following xml load works when both SQl and CF servers are residing on the same physical server. - How I can refer to the local file where sqlserver can access it? - Any alternative ways? Thanks K EXEC(' INSERT INTO [ProjectXML](Code, Reference, xmlFileName, [xmlDocument]) SELECT '''+'2503'+''','''+'455'+''', ''' + 'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp' + ''', xmlData FROM ( SELECT * FROM OPENROWSET (BULK ''' + 'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp' + ''' , SINGLE_BLOB) AS XMLDATA ) AS FileImport (XMLDATA) ') Error when on different servers: Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot bulk load because the file C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp4527544419188947137.tmp could not be opened. Operating system error code 3(The system cannot find the path specified.). sqlStatement: HY000 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344155 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 SQL Server 2008 XML bulkload
Or you should be able to read the file with cffile and then pass it to SQL Server in a cfprocparam... On Tue, May 3, 2011 at 6:01 AM, Steven Durette st...@durette.org wrote: First SQL has to be running under an account that has access to that directory. Then it is easiest if you make a share, then you reference it as \\sernername\sharename\filename Steve Sent from my iPhone On May 3, 2011, at 12:48 AM, Kam Heydari heyda...@yahoo.com wrote: Hi, Anyone know how to pass file name to the bulkload when sqlserver and coldfision servers are on different physical servers; The following xml load works when both SQl and CF servers are residing on the same physical server. - How I can refer to the local file where sqlserver can access it? - Any alternative ways? Thanks K EXEC(' INSERT INTO [ProjectXML](Code, Reference, xmlFileName, [xmlDocument]) SELECT '''+'2503'+''','''+'455'+''', ''' + 'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp' + ''', xmlData FROM ( SELECT * FROM OPENROWSET (BULK ''' + 'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp' + ''' , SINGLE_BLOB) AS XMLDATA ) AS FileImport (XMLDATA) ') Error when on different servers: Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot bulk load because the file C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp4527544419188947137.tmp could not be opened. Operating system error code 3(The system cannot find the path specified.). sqlStatement: HY000 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 SQL Server 2008 XML bulkload
Thanks Steve, Kambiz Heydari (781) 898-8857 On May 3, 2011, at 7:01 AM, Steven Durette st...@durette.org wrote: First SQL has to be running under an account that has access to that directory. Then it is easiest if you make a share, then you reference it as \\sernername\sharename\filename Steve Sent from my iPhone On May 3, 2011, at 12:48 AM, Kam Heydari heyda...@yahoo.com wrote: Hi, Anyone know how to pass file name to the bulkload when sqlserver and coldfision servers are on different physical servers; The following xml load works when both SQl and CF servers are residing on the same physical server. - How I can refer to the local file where sqlserver can access it? - Any alternative ways? Thanks K EXEC(' INSERT INTO [ProjectXML](Code, Reference, xmlFileName, [xmlDocument]) SELECT '''+'2503'+''','''+'455'+''', ''' + 'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp' + ''', xmlData FROM ( SELECT * FROM OPENROWSET (BULK ''' + 'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp' + ''' , SINGLE_BLOB) AS XMLDATA ) AS FileImport (XMLDATA) ') Error when on different servers: Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot bulk load because the file C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp4527544419188947137.tmp could not be opened. Operating system error code 3(The system cannot find the path specified.). sqlStatement: HY000 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344157 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 on Win 2008 w/1 gig of ram
With RAM being so cheap, is it worth worrying about buying more? I personally wouldn't run a server with less than 2gb RAM. -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: 02 May 2011 19:43 To: cf-talk Subject: CF 9 on Win 2008 w/1 gig of ram We are looking at a Win 2008 VPS for some low traffic hobby sites and for general dev purposes and I was wondering if one gig of ram would suffice. I would most probably be running IIS 7, Mysql 5.5 (or MSSQL 2008 Express), CF9 std. and possibly a name server and/or a (S)FTP server. I would only be running a couple static html sites and the following Cf apps: one instance of Blog.cfc, one instance of Project Tracker http://projecttracker.riaforge.org And a couple instance of miniwiki http://miniwiki.riaforge.org/. I know that Win 2003 and Centos could handle that readily using a gig of ram but I have yet to work with 2008 server other than installing and playing with it for a couple of weekends. Has anyone had any experience with such a rig and care to pass along any advice? As always many TIA G! No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3611 - Release Date: 05/02/11 15:51:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344158 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) A word of hosting caution
Hi All, Just a notice to possibly help save someone some grief if you host at Hosting.com (formerly HostMySite.com before the merger). Make sure that they have your account up to date!! They have a policy where if they find a database who's name is not found on anyone's account - they blindly delete it with no notice!!! This is an odd policy given the number of errors I found in our own accountI can only assume other accounts are in similar states and this policy could be destructive. One of our SQL Server DBs on a shared box had a name that WAS the same as the datasource setup pointing to it, however it was not the name they had on file with our account. Boomthe DB for the backend of our corporate site was gone! Thankfully they still had a backup. So just a word of caution to make sure your accounts are up to date and accurate or you might just get a nasty surprise ;-) ...and for the record, this is not sour grapes in any wayjust looking out for the community.the issue was resolved to my satisfaction. Cheers -- 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: br...@electricedgesystems.com 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. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Is there a sample out there somewhere? I messed with it but couldn't get it to work. Is there a reason you cannot just read in the file as binary. Then display it inline with cfcontent and correct mime header (assuming the user's browser settings allow ...)? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
MS XML Parse
Hello all. I am trying to parse thru an XML feed using the method that I always use and it's not working: Here is my code: cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' cfhttp url=#getJobs# method=GET timeout=1/cfhttp !--- Read the file and convert it to an XML document object--- cfset msJobs = XmlParse(cfhttp.filecontent) cfdump var=#msJobs# The dump doesn't show up. I just get a blank screen. Any suggestions? TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: MS XML Parse
Are you sure that someone didn't screw up the XML in the file? -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Tuesday, May 03, 2011 12:15 PM To: cf-talk Subject: MS XML Parse Hello all. I am trying to parse thru an XML feed using the method that I always use and it's not working: Here is my code: cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' cfhttp url=#getJobs# method=GET timeout=1/cfhttp !--- Read the file and convert it to an XML document object--- cfset msJobs = XmlParse(cfhttp.filecontent) cfdump var=#msJobs# The dump doesn't show up. I just get a blank screen. Any suggestions? TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Something like: !--- make sure user is authenticated --- !--- read in the file as binary. --- cffile action=readbinary file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')# variable=myvar !--- Then display it inline with cfcontent and correct mime header (assuming the user's browser settings allow ...)? --- cfcontent variable=#myvar# type=application/msexcel Note: if you need to do this in a page that has other stuff on it, you could use a frame or an iframe. On Tue, May 3, 2011 at 11:07 AM, Liz Maher ohl...@gmail.com wrote: Is there a sample out there somewhere? I messed with it but couldn't get it to work. Is there a reason you cannot just read in the file as binary. Then display it inline with cfcontent and correct mime header (assuming the user's browser settings allow ...)? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) A word of hosting caution
To be honest, after HMS became part of Hosting.com, their service went so far downhill so fast that I moved everything to other hosting companies. HMS used to be awesome when Lou and Neil were in charge but after the acquisition I had nothing but problems and once Lou and Neil left things really fell apart :( And can I just take this opportunity yet again to say that shared hosting is not appropriate to run a business on? Anyone on the same server can read your entire application scope and get access to any information you have cached there - and the uptime of your business is dependent on the good behavior of everyone who shares that server. I ran my blog on HMS shared hosting for several years but eventually had to move it to VPS due to performance problems (I suspect HMS put 100's of customers on each server...). Later I had performance problems with the HMS VPS as well (again, too many customers sharing a server I think). Now I'm on an EWH enterprise cloud server (which I believe has a strictly limited number of customers per box?). Sean On Tue, May 3, 2011 at 8:54 AM, Bryan Stevenson br...@electricedgesystems.com wrote: Just a notice to possibly help save someone some grief if you host at Hosting.com (formerly HostMySite.com before the merger). Make sure that they have your account up to date!! They have a policy where if they find a database who's name is not found on anyone's account - they blindly delete it with no notice!!! This is an odd policy given the number of errors I found in our own accountI can only assume other accounts are in similar states and this policy could be destructive. One of our SQL Server DBs on a shared box had a name that WAS the same as the datasource setup pointing to it, however it was not the name they had on file with our account. Boomthe DB for the backend of our corporate site was gone! Thankfully they still had a backup. So just a word of caution to make sure your accounts are up to date and accurate or you might just get a nasty surprise ;-) ...and for the record, this is not sour grapes in any wayjust looking out for the community.the issue was resolved to my satisfaction. Chee ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS XML Parse
Maybe it's too big a file this time. the XMlParse function isn't the best when it gets to large documents, time to drop into java :) SAX parsers work even better for large documents. I looked at it and it seems to be a rather big file BTW. Regards Mark Drew On 3 May 2011, at 12:14, Torrent Girl wrote: Hello all. I am trying to parse thru an XML feed using the method that I always use and it's not working: Here is my code: cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' cfhttp url=#getJobs# method=GET timeout=1/cfhttp !--- Read the file and convert it to an XML document object--- cfset msJobs = XmlParse(cfhttp.filecontent) cfdump var=#msJobs# The dump doesn't show up. I just get a blank screen. Any suggestions? TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) A word of hosting caution
Sean, let me add that I have written code that not only accesses ALL the application scopes running on a shared server, but I can also wrote code that can access all the session scopes inside each application. Shared hosting is not a safe secure option for a business. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 3, 2011, at 11:29 AM, Sean Corfield wrote: To be honest, after HMS became part of Hosting.com, their service went so far downhill so fast that I moved everything to other hosting companies. HMS used to be awesome when Lou and Neil were in charge but after the acquisition I had nothing but problems and once Lou and Neil left things really fell apart :( And can I just take this opportunity yet again to say that shared hosting is not appropriate to run a business on? Anyone on the same server can read your entire application scope and get access to any information you have cached there - and the uptime of your business is dependent on the good behavior of everyone who shares that server. I ran my blog on HMS shared hosting for several years but eventually had to move it to VPS due to performance problems (I suspect HMS put 100's of customers on each server...). Later I had performance problems with the HMS VPS as well (again, too many customers sharing a server I think). Now I'm on an EWH enterprise cloud server (which I believe has a strictly limited number of customers per box?). Sean On Tue, May 3, 2011 at 8:54 AM, Bryan Stevenson br...@electricedgesystems.com wrote: Just a notice to possibly help save someone some grief if you host at Hosting.com (formerly HostMySite.com before the merger). Make sure that they have your account up to date!! They have a policy where if they find a database who's name is not found on anyone's account - they blindly delete it with no notice!!! This is an odd policy given the number of errors I found in our own accountI can only assume other accounts are in similar states and this policy could be destructive. One of our SQL Server DBs on a shared box had a name that WAS the same as the datasource setup pointing to it, however it was not the name they had on file with our account. Boomthe DB for the backend of our corporate site was gone! Thankfully they still had a backup. So just a word of caution to make sure your accounts are up to date and accurate or you might just get a nasty surprise ;-) ...and for the record, this is not sour grapes in any wayjust looking out for the community.the issue was resolved to my satisfaction. Chee ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS XML Parse
On 5/3/2011 9:14 AM, Torrent Girl wrote: cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' That looks to be a pretty large XML document. There are definite limits on how large of document that xmlParse() can process. As xmlParse uses a DOM parsing methodology, the entire resulting data structure (which will be several times larger the the original text document) must fit into memory. If this document is too large to dom parse you need to do something that parses it segment by segment, such as a sax parser. ColdFusion does not have a built in sax parser. I used Ben Nadel's pseudo parser [http://www.bennadel.com/blog/1345-Ask-Ben-Parsing-Very-Large-XML-Documents-In-ColdFusion.htm] once when I needed a quick solution. One could also dive into the underlining Java and access some true sax parser through it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
I'll take a whack at it, thanks much! Something like: !--- make sure user is authenticated --- !--- read in the file as binary. --- cffile action=readbinary file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')# variable=myvar !--- Then display it inline with cfcontent and correct mime header (assuming the user's browser settings allow ...)? --- cfcontent variable=#myvar# type=application/msexcel Note: if you need to do this in a page that has other stuff on it, you could use a frame or an iframe. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFQUERYPARAM and caching
Having read the blog and comments about CFQUERYPARAM and caching:- http://www.coldfusionjedi.com/index.cfm?mode=entryentry=7D417738-DF64-B270- 3056B422E2F6FCAB I am wondering if it is a viable option to leave Maintain connections across client requests unchecked in a development environment? No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3611 - Release Date: 05/02/11 15:51:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERYPARAM and caching
Having read the blog and comments about CFQUERYPARAM and caching:- http://www.coldfusionjedi.com/index.cfm?mode=entryentry=7D417738-DF64-B270- 3056B422E2F6FCAB I am wondering if it is a viable option to leave Maintain connections across client requests unchecked in a development environment? Sure, that's a viable option in development. Less so in production, as the creation of new database connections is expensive - that's why JDBC provides connection pooling. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFQUERYPARAM and caching
Awesome, thanks Dave. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 03 May 2011 18:03 To: cf-talk Subject: Re: CFQUERYPARAM and caching Having read the blog and comments about CFQUERYPARAM and caching:- http://www.coldfusionjedi.com/index.cfm?mode=entryentry=7D417738-DF64-B270- 3056B422E2F6FCAB I am wondering if it is a viable option to leave Maintain connections across client requests unchecked in a development environment? Sure, that's a viable option in development. Less so in production, as the creation of new database connections is expensive - that's why JDBC provides connection pooling. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS XML Parse
On 5/3/2011 9:14 AM, Torrent Girl wrote: cfset getJobs = 'http://www.microsoft-careers. com/Microsoft-Diversity-AAWIT116obs.xml' That looks to be a pretty large XML document. There are definite limits on how large of document that xmlParse() can process. As xmlParse uses a DOM parsing methodology, the entire resulting data structure (which will be several times larger the the original text document) must fit into memory. If this document is too large to dom parse you need to do something that parses it segment by segment, such as a sax parser. ColdFusion does not have a built in sax parser. I used Ben Nadel's pseudo parser [http://www.bennadel. com/blog/1345-Ask-Ben-Parsing-Very-Large-XML-Documents-In-ColdFusion. htm] once when I needed a quick solution. One could also dive into the underlining Java and access some true sax parser through it. Actually, I can dump the contents of the cfhttp.filecontent return with no problem. cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' cfhttp url=#getJobs# method=GET timeout=1/cfhttp cfdump var=#cfhttp.filecontent# top=10 I usually have to dump the parse to see what available for outputing the actual values. Here is my page with the cfhttp content dumped: http://www.aawit.net/xmlJobFeedtest.cfm If I can get the structure of the values I'd be good: i.e., #msjobs.job.title.XmlText# I am not familiar with XML enough to know how to output the parsing. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9's cfmail remove attribute not working at Crystal Tech
I just spent an hour working with a tech at Crystal Tech diagnosing an email problem which ended up with me realizing that the very convenient remove attribute that is new to CF9's cfmail tag will not work in their environment. The reason for this is that they don't use CF's built-in mail client, instead handing off to SmarterMail. So although CF believes an email has left the spooler and its attachments can be deleted, SmarterMail will still come back for them but fail when it finds the attachments are gone. What do people recommend as a viable way to deal with this (I assume everyone had to deal with this anyway before CF9)? Is the answer to set up a scheduled task that cleans out some directory of email attachments at regular intervals? db ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) A word of hosting caution
Yes I saw the samejust wasn't going to rant as we are already in the processing of moving to Viviotech ;-) +1 on the no shared hosting.in our case it was a small DB left behind after we went VPS at HMS. It's truly sadevery awesome host I've ever dealt with has gone through a merger that killed all the reasons why I selected them in the first place Cheers On Tue, 2011-05-03 at 09:29 -0700, Sean Corfield wrote: To be honest, after HMS became part of Hosting.com, their service went so far downhill so fast that I moved everything to other hosting companies. HMS used to be awesome when Lou and Neil were in charge but after the acquisition I had nothing but problems and once Lou and Neil left things really fell apart :( And can I just take this opportunity yet again to say that shared hosting is not appropriate to run a business on? Anyone on the same server can read your entire application scope and get access to any information you have cached there - and the uptime of your business is dependent on the good behavior of everyone who shares that server. I ran my blog on HMS shared hosting for several years but eventually had to move it to VPS due to performance problems (I suspect HMS put 100's of customers on each server...). Later I had performance problems with the HMS VPS as well (again, too many customers sharing a server I think). Now I'm on an EWH enterprise cloud server (which I believe has a strictly limited number of customers per box?). Sean On Tue, May 3, 2011 at 8:54 AM, Bryan Stevenson br...@electricedgesystems.com wrote: Just a notice to possibly help save someone some grief if you host at Hosting.com (formerly HostMySite.com before the merger). Make sure that they have your account up to date!! They have a policy where if they find a database who's name is not found on anyone's account - they blindly delete it with no notice!!! This is an odd policy given the number of errors I found in our own accountI can only assume other accounts are in similar states and this policy could be destructive. One of our SQL Server DBs on a shared box had a name that WAS the same as the datasource setup pointing to it, however it was not the name they had on file with our account. Boomthe DB for the backend of our corporate site was gone! Thankfully they still had a backup. So just a word of caution to make sure your accounts are up to date and accurate or you might just get a nasty surprise ;-) ...and for the record, this is not sour grapes in any wayjust looking out for the community.the issue was resolved to my satisfaction. Chee ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Well it appears that MX 6.1 doesn't support the variable attribute of cfcontent. I may have access to CF9 tomorrow, but in the meantime is there any way to get this file delivered with MX 6.1? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS XML Parse
On 5/3/2011 10:18 AM, Torrent Girl wrote: Actually, I can dump the contents of the cfhttp.filecontent return with no problem. That is because at that point, the data is still flat text. One can fit a WHOLE LOT of flat text into a gigabyte or two of ram memory. The problem will occur when you try to parse that flat text into a DOM relational data structure. Now IF you do not need to parse the flat data, you can use xmlTransform(), and maybe xmlSearch(), to apply XPATH to the large flat text data and create smaller subsets of the XML. That might get you where you need to go. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfdocument layout precision, labels
Hello, I am trying to create label sheets. I noticed quickly that specified sizes have to be smaller to end up as I need them. For instance, a .5 top margin must be specified as .4 to give the desired result. The same is true with table cells. Through trial and error I was able to arrive at what I needed. I applied borders to the cells just to make the printout easier to measure, but this seemed to have no effect on the layout; it was just as wrong with or without borders. Has anyone run across this issue? Is there a fix? I am using CF7, which I have no choice about. Many thanks, Bruce ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
8.0.1 Updater and Internet Access
Hi, Does anyone know if the 8.0.1 Updater for Linux tries to retrieve resources via the Internet? I would think it wouldn't seeing that some users may be behind firewalls that don't allow this. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS XML Parse
On 5/3/2011 10:18 AM, Torrent Girl wrote: Actually, I can dump the contents of the cfhttp.filecontent return with no problem. That is because at that point, the data is still flat text. One can fit a WHOLE LOT of flat text into a gigabyte or two of ram memory. The problem will occur when you try to parse that flat text into a DOM relational data structure. Now IF you do not need to parse the flat data, you can use xmlTransform(), and maybe xmlSearch(), to apply XPATH to the large flat text data and create smaller subsets of the XML. That might get you where you need to go. Great thanks! I'll try one of these. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Try: cfcontent file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')# type=application/msexcel On Tue, May 3, 2011 at 12:32 PM, Liz Maher ohl...@gmail.com wrote: Well it appears that MX 6.1 doesn't support the variable attribute of cfcontent. I may have access to CF9 tomorrow, but in the meantime is there any way to get this file delivered with MX 6.1? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344180 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Thanks! I've got it prompted to download the file with: cffile action=readbinary file=path-to-the-dir\deliveryschedule.xls variable=myvar cfheader name=Content-Disposition value=inline; filename=deliveryschedule.xls cfcontent type=application/vnd.ms-excel file=path-to-the-dir\deliveryschedule.xls ...but it's still a no-go on displaying inline. Presumably the downloader can still edit the file if they want to. Try: cfcontent file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')# type=application/msexcel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocument layout precision, labels
First thought that comes to mind is whether or not, in your stylesheet or inline applied margin:0px and padding:0px to prevent the default margins and paddings applied to certain elements by the browsers. Use Firebug to check the layout and you can easily spot margins and borders that have been applied to elements. -Original Message- From: Bruce Keplinger [mailto:bkeplin...@cnyrpdb.org] Sent: Tuesday, May 03, 2011 1:37 PM To: cf-talk Subject: cfdocument layout precision, labels Hello, I am trying to create label sheets. I noticed quickly that specified sizes have to be smaller to end up as I need them. For instance, a .5 top margin must be specified as .4 to give the desired result. The same is true with table cells. Through trial and error I was able to arrive at what I needed. I applied borders to the cells just to make the printout easier to measure, but this seemed to have no effect on the layout; it was just as wrong with or without borders. Has anyone run across this issue? Is there a fix? I am using CF7, which I have no choice about. Many thanks, Bruce ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Did you try it in IE? It might display inline in IE. Also, with cfcontent file= you no longer need the cffile at all. On Tue, May 3, 2011 at 12:49 PM, Liz Maher ohl...@gmail.com wrote: Thanks! I've got it prompted to download the file with: cffile action=readbinary file=path-to-the-dir\deliveryschedule.xls variable=myvar cfheader name=Content-Disposition value=inline; filename=deliveryschedule.xls cfcontent type=application/vnd.ms-excel file=path-to-the-dir\deliveryschedule.xls ...but it's still a no-go on displaying inline. Presumably the downloader can still edit the file if they want to. Try: cfcontent file=#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')# type=application/msexcel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Well it appears that MX 6.1 doesn't support the variable attribute of cfcontent. I may have access to CF9 tomorrow, but in the meantime is there any way to get this file delivered with MX 6.1? The VARIABLE attribute lets you point to a variable to get your content. You don't really need that: !--- turn off whitespace, etc first --- cfcontent ...cfoutput#yourVariable#/cfoutput Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
cffile action=readbinary Put the file outside a web accessible directory and serve it up as binary using cfcontent variable=#binaryData# not cfcontent file=... ...but it's still a no-go on displaying inline. That is all controlled by user's browser settings. If the browser is configured to display office files within the browser, then it will happen. Otherwise, their browser will prompt to download the file/open it with the appropriate program. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9's cfmail remove attribute not working at Crystal Tech
your host should actually be the ones cleaning up the temp folders not you :-) we run scheduled tasks to do things like this on all our servers 1. respool failed mail for 24 hours before deleting it 2. clean up all the coldfusion temp folders 3. delete old class files and reduce the memory usage. 4. delete old log files (not just CF) on top of these I actually review the CF logs and FusionReactor logs and inform customers of recurring problems so that they can fix them and improve the performanc eof their site. I can tell you now that not many hosts do that :-) -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Well it appears that MX 6.1 doesn't support the variable attribute of cfcontent. Did not see the 6.1 requirement !--- turn off whitespace, etc first --- cfcontent ...cfoutput#yourVariable#/cfoutput I could be wrong, but you might need to use ToString() as well: cfoutput#toString(yourVariable)#/cfoutput ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Intelligent Mail Bar Code Algorithm
Hi folks Anyone know of an intelligent Mail bar code algorthm I need to generate the FADT code from all the numbers so I can create mailing barcodes. Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFFILEUPLOAD total confusion
I have been on adobe forums, I have dialogued with Ray Camden and scoured the web. I will also say that I have been doing CF for a long time but this one has me stumped. call me dumb but it is what it is. Here is my index.cfm file: -- cffileupload url=index_action.cfm?#urlEncodedFormat(session.urlToken)# progressbar=true name=myupload width=400 height=300 title = UPLOAD MULTIPLE FILES TO PRIVATE FOLDER maxuploadsize=200 extensionfilter=*.jpg, *.png, *.flv, *.txt, *.doc, *.docx, *.xls, *.xlsx *.pdf BGCOLOR=##0078AE MAXFILESELECT=10 / -- Here is the action file called: index_action.cfm -- cffile action=uploadall destination=#expandPath('uploads')# nameconflict=overwrite result=myVar / cfdump var=#myVar# cfset str.STATUS = 200 cfset str.MESSAGE = passed cfoutput#serializeJSON(str)#/cfoutput -- Well we all know this s a flash application so there is not a postback to the server. I need the filename of the uploads to be available to me so I can insert the names into the database via the directory that are in. this will allow the users of the site to download and read the given files. My problem is that I do not know how to return the file names so I can insert them into the given data table. There is no return here. All I can imagine is there must be some kind of JavaScript the will provide me with the name so I can insert the names as the files are uploaded to the given directory. Question 1: How do I get the application to retrieve and provide the file or files name(s)? Question 2: Is this display an actual output or is this .cgi information that I pull behind the seens? Question 3: If this is done with jQuery or some kind of JavaScript call is it possible to get an example to I can replicate it in process? Thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILEUPLOAD total confusion
If you want to go the jQuery route, you could try Uploadify. I recently used it and had no issues. http://www.uploadify.com/ Regards, Che -Original Message- From: Gene Godsey [mailto:gene.god...@comcast.net] Sent: Tuesday, May 03, 2011 3:21 PM To: cf-talk Subject: CFFILEUPLOAD total confusion I have been on adobe forums, I have dialogued with Ray Camden and scoured the web. I will also say that I have been doing CF for a long time but this one has me stumped. call me dumb but it is what it is. Here is my index.cfm file: -- cffileupload url=index_action.cfm?#urlEncodedFormat(session.urlToken)# progressbar=true name=myupload width=400 height=300 title = UPLOAD MULTIPLE FILES TO PRIVATE FOLDER maxuploadsize=200 extensionfilter=*.jpg, *.png, *.flv, *.txt, *.doc, *.docx, *.xls, *.xlsx *.pdf BGCOLOR=##0078AE MAXFILESELECT=10 / -- Here is the action file called: index_action.cfm -- cffile action=uploadall destination=#expandPath('uploads')# nameconflict=overwrite result=myVar / cfdump var=#myVar# cfset str.STATUS = 200 cfset str.MESSAGE = passed cfoutput#serializeJSON(str)#/cfoutput -- Well we all know this s a flash application so there is not a postback to the server. I need the filename of the uploads to be available to me so I can insert the names into the database via the directory that are in. this will allow the users of the site to download and read the given files. My problem is that I do not know how to return the file names so I can insert them into the given data table. There is no return here. All I can imagine is there must be some kind of JavaScript the will provide me with the name so I can insert the names as the files are uploaded to the given directory. Question 1: How do I get the application to retrieve and provide the file or files name(s)? Question 2: Is this display an actual output or is this .cgi information that I pull behind the seens? Question 3: If this is done with jQuery or some kind of JavaScript call is it possible to get an example to I can replicate it in process? Thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Lookig for tutorials on how to build a plugin system
I was wondering if anyone had any tutorials, sample code or links on how to build your own plugin system. I am looking to build an App and would like to make it extensible via plugins. I've search high and low and couldn't find anything. thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lookig for tutorials on how to build a plugin system
Are you using a framework for your app? On Tue, May 3, 2011 at 2:49 PM, Richard Beck richardb...@gmail.com wrote: I was wondering if anyone had any tutorials, sample code or links on how to build your own plugin system. I am looking to build an App and would like to make it extensible via plugins. I've search high and low and couldn't find anything. thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) A word of hosting caution
I moved my blog out of there a while ago, I found Allurium http://alurium.com/clients/aff.php?aff=011 I couldn't beat the price. As an FYI, they're running Railo, if your code is running anything specific to ACF then you'll need to make changes. On Tue, May 3, 2011 at 11:54 AM, Bryan Stevenson br...@electricedgesystems.com wrote: Hi All, Just a notice to possibly help save someone some grief if you host at Hosting.com (formerly HostMySite.com before the merger). Make sure that they have your account up to date!! They have a policy where if they find a database who's name is not found on anyone's account - they blindly delete it with no notice!!! This is an odd policy given the number of errors I found in our own accountI can only assume other accounts are in similar states and this policy could be destructive. One of our SQL Server DBs on a shared box had a name that WAS the same as the datasource setup pointing to it, however it was not the name they had on file with our account. Boomthe DB for the backend of our corporate site was gone! Thankfully they still had a backup. So just a word of caution to make sure your accounts are up to date and accurate or you might just get a nasty surprise ;-) ...and for the record, this is not sour grapes in any wayjust looking out for the community.the issue was resolved to my satisfaction. Cheers -- 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: br...@electricedgesystems.com 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. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lookig for tutorials on how to build a plugin system
Are you using a framework for your app? No, I am not using a framework. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Thank you both. In IE it opens in the browser window (prompts first), in Firefox it prompts for download. This may be as good as I can get without reading the file and writing tables..? Currently using cfheader name=Content-Disposition value=inline; filename=deliveryschedule.xls cfcontent type=application/vnd.ms-excel file=file-location\deliveryschedule.xls (if i add the cfoutput code it does the same thing) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Displaying an Excel file in a CF page, period.
Will this do something different than what i'm doing in 6.1 now? If so I'll try it tomorrow when I'll hopefully access to CF9. Put the file outside a web accessible directory and serve it up as binary using cfcontent variable=#binaryData# not cfcontent file=.. . ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344196 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lookig for tutorials on how to build a plugin system
Hm. Well, I'm not sure this is the easiest/best answer...but...you could look at a popular framework/app, dig into the source code, and see how they handle plugins. Two that spring immediately to mind are: http://cfwheels.org/plugins/ http://cfwheels.org/plugins/http://www.mangoblog.org/docs/plugins On Tue, May 3, 2011 at 2:49 PM, Richard Beck richardb...@gmail.com wrote: Are you using a framework for your app? No, I am not using a framework. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lookig for tutorials on how to build a plugin system
Right, I've done some of that already. I was hoping to find a barebones tutorial so i wouldnt have to sift through other stuff. Hm. Well, I'm not sure this is the easiest/best answer...but...you could look at a popular framework/app, dig into the source code, and see how they handle plugins. Two that spring immediately to mind are: http://cfwheels.org/plugins/ http://cfwheels.org/plugins/http://www.mangoblog.org/docs/plugins ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Question about CF / MS Word Integration
Anyone? Anyone? Bueller? Hello there. We're researching the feasibility of integrating our CF based CMS / CRM application with MS Word and I want to get a sense of how easy / hard this might be. An example of the kind of thing that we would want to achieve would be to allow a client to use a web editor (e.g. CKEditor) to create a letter (e.g. a thank you note for a donation) within our web based application and then export that to a word document while merging in the name and address info of a particular person so that the result would be an MS Word document that is personalized to a particular person and is ready for printing. Any suggestions on how to do this? I'm guessing that it would be easier to send it out to a PDF but the down side of that is that it would not be editable at that point. Thanks in advance! Nick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lookig for tutorials on how to build a plugin system
I have not seen any tutorials like that but I would take a look at Mangoblog as a good example, this seems to be a very easy app to write plugins for. One key thing is to use CFC's and make use of the EXTENDS attribute, this allows any plugins to simply extend your core components. Custom tags seem to have been dismissed by menu in favour of CFC's, but they are still immensely useful, especially for outputting dynamic content. One trick that I use is to use cfimport without a prefix then you can create custom tags that will replace all occurrences of HTML tags. e.g. cfimport prefix= taglib=customtags create a file called div.cfm in your taglibs folder every time a div tag is encountered it will be replaced with your CFML :-) I find this very extensible as you can use a different taglib on every page so great for plugins. Also make sure you make all your variables easily accessible, either by putting then in application scope or via methods in a cached component. just a few ideas On Tue, May 3, 2011 at 8:59 PM, Richard Beck richardb...@gmail.com wrote: Right, I've done some of that already. I was hoping to find a barebones tutorial so i wouldnt have to sift through other stuff. Hm. Well, I'm not sure this is the easiest/best answer...but...you could look at a popular framework/app, dig into the source code, and see how they handle plugins. Two that spring immediately to mind are: http://cfwheels.org/plugins/ http://cfwheels.org/plugins/http://www.mangoblog.org/docs/plugins ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Intelligent Mail Bar Code Algorithm
http://www.idautomation.com/java/font-encoder.html Then, you just use the Postnet font to convert. We used the VB solution from ID Automation. Not difficult at all. Jacob -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Tuesday, May 03, 2011 12:12 PM To: cf-talk Subject: Intelligent Mail Bar Code Algorithm Hi folks Anyone know of an intelligent Mail bar code algorthm I need to generate the FADT code from all the numbers so I can create mailing barcodes. Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Intelligent Mail Bar Code Algorithm
Hi Jacob Thanks. After scouring the usps website and the web in general I finally managed to get the usps Excel spreadsheet to work. Also very easy when you know how;-) Rob On 3 May 2011 at 16:15, Jacob wrote: http://www.idautomation.com/java/font-encoder.html Then, you just use the Postnet font to convert. We used the VB solution from ID Automation. Not difficult at all. Jacob -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Tuesday, May 03, 2011 12:12 PM To: cf-talk Subject: Intelligent Mail Bar Code Algorithm Hi folks Anyone know of an intelligent Mail bar code algorthm I need to generate the FADT code from all the numbers so I can create mailing barcodes. Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 4201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question about CF / MS Word Integration
I'm not sure what you mean by integration with MS word, but making a word doc in CF is pretty simple. http://www.jensbits.com/2009/06/21/using-coldfusion-to-generate-a-word-document/ http://www.jensbits.com/2009/06/21/using-coldfusion-to-generate-a-word-document/ On Tue, May 3, 2011 at 4:44 PM, Nick Gleason n.glea...@citysoft.com wrote: Anyone? Anyone? Bueller? Hello there. We're researching the feasibility of integrating our CF based CMS / CRM application with MS Word and I want to get a sense of how easy / hard this might be. An example of the kind of thing that we would want to achieve would be to allow a client to use a web editor (e.g. CKEditor) to create a letter (e.g. a thank you note for a donation) within our web based application and then export that to a word document while merging in the name and address info of a particular person so that the result would be an MS Word document that is personalized to a particular person and is ready for printing. Any suggestions on how to do this? I'm guessing that it would be easier to send it out to a PDF but the down side of that is that it would not be editable at that point. Thanks in advance! Nick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILEUPLOAD total confusion
you could try Uploadify I also used this recently and thought it was great. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILEUPLOAD total confusion
On Tue, May 3, 2011 at 2:21 PM, Gene Godsey gene.god...@comcast.net wrote: Question 1: How do I get the application to retrieve and provide the file or files name(s)? The value, myVar, is an array of file structs. Each struct contains information about the file upload. Look up the docs for cffile/action=upload. The data is the same, but action=upload lets you handle multiple - hence the use of an array. Point is - all the data is there. Question 2: Is this display an actual output or is this .cgi information that I pull behind the seens? Is that a display? Thie last code block you showed, the one with uploadall, handles the request sent by the Flash on the front end. It returns JSON back. So the code on the client gets the JSON, parses it, and works with it. So it' snot visible per se. It's a bit like a robot doing a http request for you. Question 3: If this is done with jQuery or some kind of JavaScript call is it possible to get an example to I can replicate it in process? It's all Flash and JS. Not sure what you mean by 'replicate the process' though. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Bless cfqueryparam - helped defend against a persistent hack attempt
Same here. I'm not aware of a way (in CF) to achieve caching of execution plans without fully qualified, paramterized SQL. CFQUERYPARAM gets you the latter when done right. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Monday, May 02, 2011 4:28 PM To: cf-talk Subject: RE: Bless cfqueryparam - helped defend against a persistent hack attempt I almost always see a significant gain in query performance - at least on all versions of MSSQL - as much as 20-30 percent in some cases. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, May 02, 2011 1:54 PM To: cf-talk Subject: Re: Bless cfqueryparam - helped defend against a persistent hack attempt cfqueryparam creates bound sql parameters, which improve query performance. This is purely theoretical, in practice, the gain in performance is neglectible. I prefer have a query to take 11 ms and see the values submitted in case of error, than having the same query take 10 ms, but no information in errors. In your practice, perhaps. In the practice of others, not so much. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Generate jdf files with Coldfusion
Hi, I was wondering if anybody used Coldfusion to generate jdf files. Thanks Victor ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bless cfqueryparam - helped defend against a persistent hack attempt
You forgot a round in there too. ;) On Mon, May 2, 2011 at 9:10 PM, Justin Scott leviat...@darktech.org wrote: of course). If I have a numeric ID, I'm going to min(abs(val(trim(url.id))), 200) that variable before it ever makes it to the query (forces a positive in-range integer or zero; the two billion value can be modified if you're using larger numbers in your situation; an error can occur if the integer value is out of range so I force it in range as well). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm