[cfaussie] Re: Dev Tools and toys
Sean, there were no more replies in the thread you started under the subject above. Did the resource I pointed to below help you? Did anyone else check it out? It's got the kind of info that people seem to ask about all the time: what tools exist to do ... I'd like to hear back from folks what you think of it, and if there's anything you think I need to add. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Wednesday, February 20, 2008 7:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Dev Tools and toys Sean, you don't say what sort of tools and toys you're looking for, so I can point you to a smorgasbord of several dozen in dozens of categories: http://carehart.org/resourcelists/tools_to_consider/ I list tools that either work with CF or would be typically useful by CF developers, in the following categories: * Blog Aggregators * Blogging Tools * Certification Prep Tools * CF Job Resources (Hire/Be Hired) * CFMAIL Replacement/Enhancement Tools * CFML Caching Tools * CFML Debugging Tools * CFML Documentation/Help Tools * CFML Engine Alternatives * CFML Frameworks/Methodologies * CFML Resource Sites * CFML Tutorial Sites * Code Generators o CFML Code Generators o Flex Code Generators * Comparison Tools o File/Dir Comparison Tools o Database Comparison Tools * Content Management Systems * Database Engines o Name brand DBMS's o Alternative Databases * Database Tools o Database Coding Tools o Database Comparison Tools o Database Monitoring Tools o Database Query/Explore Tools o Database Testing Tools * E-commerce Enabling Solutions * Editors/IDEs * Excel File Processing Tools * File Upload Tools * Forums/Bulletin Boards * Graphing/Charting Tools * HTTP Debugging Proxy Tools o Free, General-purpose HTTP Debugging Proxies o Free, Firefox-only Proxies o Free, IE-only Proxies o Commercial Proxies * Image Processing Tools * Monitoring Tools o Application Monitoring Tools o ColdFusion Monitoring Tools o Database Monitoring Tools o Site Monitoring Tools o System Monitoring Tools * Regular Expression Generation/Testing Tools * RSS to Email Tools * Server-side Spell Checkers * Source Code Control Tools * Testing Tools o Code Testing Tools o Database Testing Tools o Load and Application Testing Tools o Page Testing Tools o Regex Testing Tools o Site Security Testing Tools o Web Services Testing Tools * Web Services Browsing/Testing Tools * Web Site Design Repositories * Wiki Tools * WYSIWYG/Rich Text Editors /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sean Bucklar Sent: Wednesday, February 20, 2008 6:40 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Dev Tools and toys I've recently been reviewing my chosen dev tools and toys, and having a play with some new stuff. I'm fairly sold on Eclipse after the numerous earlier reccomendations and html formatter (http://www.logichammer.com/html-formatter/) with it's native CF support has done wonders for some of my more hurried code's readability. But I assume there's plenty of other useful stuff out there, any suggestions for stuff I should check out? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
Scott, it's not clear from your email whether you've considered the CF Report Builder that was added in CF 7. It would seem it does most of what you want. It's a combination of the ReportBuilder to build the reports (used by developers) and then CFREPORT in CFML to connect your data to the report (and control its output) in the ways you describe. I know some will jump up and say it's a piece of . But I'd ask if they (and you, Scott) have been following its evolution and how it improved in 7.01, then in 8. Don't judge it based solely on what you read from people who used it in its initial launch, which did have issues. Even then, you may still read some who complain about it even in its latest incarnation. But we all know that some could complain about a given framework, or database engine, or editor, or indeed the very CF we know and love. Folks need to consider things for themselves. Only they can decide if it suits their needs (whether greater or lesser than most who've commented on a thing). Just not clear, Scott, if you'd considered it. Hope that's helpful. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, February 19, 2008 4:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Web Reporting Hi, I am curious to know what solution you guys may use to produce professional reports from your web applications? Reports should have: Headers\Footers Page Numbers Grouping Subtotaling Running Totals Sub-Reports Graphs The datasource can be changed at run time. Reports should be able to be saved by the end user (export as pdf etc). Reports can be written against stored procs\views\tables. Report Parameters can be changed at run time. Reports can be exported to be pdf server side for copying\emailing? We currently use crystal reports. the server version either 9 or 11. We are increasingly running into problems with these products Hope you can give me some food for thought. Thanks, Scott Thornton, Programmer Billing Unit Hunter-New England Area Health Service ext: 24505 p: +61 02 4941 4505 m: 0413 800 242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: XML Search
I'll throw out here that if anyone else ever struggles with doing XML integration in CFML, there's a really great 30-page PDF that Nate Weiss did a few years back. It's still as valuable today as then: http://www.adobe.com/devnet/coldfusion/articles/xmlxslt.pdf Oh, and Paul, if you happen to be on CF 7 or 8, you can skip the CFFILE step. XMLParse now accepts the filename to read in (or a URL) as the first argument. Nice little hidden gem. :-) /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Paul Kukiel Sent: Wednesday, February 20, 2008 5:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: XML Search Thanks Zac that was it. On Wed, Feb 20, 2008 at 10:49 PM, Zac Spitzer [EMAIL PROTECTED] wrote: try cfoutput# xmlformat(selected[1].XmlChildren[1].XmlText)#br/cfoutput On Feb 20, 2008 3:29 PM, Paul Kukiel [EMAIL PROTECTED] wrote: Hi, I have a problem with some XML. !DOCTYPE TS TS context message sourceDonapos;t ask me again today/source translationDonapos;t ask me again today/translation /message message sourceCancel/source translationCancel/translation /message /context /TS cffile action=read charset=utf-8 file=C:\ColdFusion8\wwwroot\test\ZZ.xml variable=xml cfset selected = XmlSearch(xml, //message) / cfoutput#xml#br//cfoutput Gives what I need: ieDonapos;t ask me again today cfoutput#selected[1].XmlChildren[1].XmlText#br/cfoutput Converts the HTML special chars which is not what I want. Ie: Don't ask me again today It seam's that when I use xmlsearch its converting the chars for me. Any ideas on how to handle this as I need the actual text from the xml special chars and all. Paul. -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 -- Paul Kukiel --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Dev Tools and toys
Sean, you don't say what sort of tools and toys you're looking for, so I can point you to a smorgasbord of several dozen in dozens of categories: http://carehart.org/resourcelists/tools_to_consider/ I list tools that either work with CF or would be typically useful by CF developers, in the following categories: * Blog Aggregators * Blogging Tools * Certification Prep Tools * CF Job Resources (Hire/Be Hired) * CFMAIL Replacement/Enhancement Tools * CFML Caching Tools * CFML Debugging Tools * CFML Documentation/Help Tools * CFML Engine Alternatives * CFML Frameworks/Methodologies * CFML Resource Sites * CFML Tutorial Sites * Code Generators o CFML Code Generators o Flex Code Generators * Comparison Tools o File/Dir Comparison Tools o Database Comparison Tools * Content Management Systems * Database Engines o Name brand DBMS's o Alternative Databases * Database Tools o Database Coding Tools o Database Comparison Tools o Database Monitoring Tools o Database Query/Explore Tools o Database Testing Tools * E-commerce Enabling Solutions * Editors/IDEs * Excel File Processing Tools * File Upload Tools * Forums/Bulletin Boards * Graphing/Charting Tools * HTTP Debugging Proxy Tools o Free, General-purpose HTTP Debugging Proxies o Free, Firefox-only Proxies o Free, IE-only Proxies o Commercial Proxies * Image Processing Tools * Monitoring Tools o Application Monitoring Tools o ColdFusion Monitoring Tools o Database Monitoring Tools o Site Monitoring Tools o System Monitoring Tools * Regular Expression Generation/Testing Tools * RSS to Email Tools * Server-side Spell Checkers * Source Code Control Tools * Testing Tools o Code Testing Tools o Database Testing Tools o Load and Application Testing Tools o Page Testing Tools o Regex Testing Tools o Site Security Testing Tools o Web Services Testing Tools * Web Services Browsing/Testing Tools * Web Site Design Repositories * Wiki Tools * WYSIWYG/Rich Text Editors /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sean Bucklar Sent: Wednesday, February 20, 2008 6:40 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Dev Tools and toys I've recently been reviewing my chosen dev tools and toys, and having a play with some new stuff. I'm fairly sold on Eclipse after the numerous earlier reccomendations and html formatter (http://www.logichammer.com/html-formatter/) with it's native CF support has done wonders for some of my more hurried code's readability. But I assume there's plenty of other useful stuff out there, any suggestions for stuff I should check out? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
No, it has no connection with Crystal that I know of, and certainly you're being at CF6.1, it just won't work for you. Hope you find a good solution. If you're on a windows machine, perhaps consider SQL Server Reporting Services. You ask what big businesses would use, and that's one end of the spectrum. Another would be open source solutions like JasperReports, JFreeReport, Eclipse BIRT, Datavision, and so on. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, February 20, 2008 9:26 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Web Reporting Hi Charlie, I had not considered the report builder that comes with 7 and 8. While I have not used it, I have kept my eye out for references to it via blogs and posts here, and it seemed to have quite a few problems I really should take a new look at it. We have invested a lot of time into Crystal Reports over the years, and it is felt that we would lose a lot of functionality if we used this product. Unfortunately, we only use CF MX 6.1 in our live environment at the moment. I don't know if it is possible, but if it could take a Crystal report and convert it into the report builder format it might help. I attempted to call Crystal reports developed reports with the cfreport tag and ran into a few problems. (actually i couldn't get a single simple report to work will attempt it again today). I am just curious to know what corporate\big business types might use in this instance. Over the years we have progressed from using Crystal 8.5 and its ActiveX viewer, to versions 9 and 11 and exporting as pdf's and served up in a new browser window. ... Charlie Arehart (lists account) [EMAIL PROTECTED] 21/02/2008 11:42 am Scott, it's not clear from your email whether you've considered the CF Report Builder that was added in CF 7. It would seem it does most of what you want. It's a combination of the ReportBuilder to build the reports (used by developers) and then CFREPORT in CFML to connect your data to the report (and control its output) in the ways you describe. I know some will jump up and say it's a piece of . But I'd ask if they (and you, Scott) have been following its evolution and how it improved in 7.01, then in 8. Don't judge it based solely on what you read from people who used it in its initial launch, which did have issues. Even then, you may still read some who complain about it even in its latest incarnation. But we all know that some could complain about a given framework, or database engine, or editor, or indeed the very CF we know and love. Folks need to consider things for themselves. Only they can decide if it suits their needs (whether greater or lesser than most who've commented on a thing). Just not clear, Scott, if you'd considered it. Hope that's helpful. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, February 19, 2008 4:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Web Reporting Hi, I am curious to know what solution you guys may use to produce professional reports from your web applications? Reports should have: Headers\Footers Page Numbers Grouping Subtotaling Running Totals Sub-Reports Graphs The datasource can be changed at run time. Reports should be able to be saved by the end user (export as pdf etc). Reports can be written against stored procs\views\tables. Report Parameters can be changed at run time. Reports can be exported to be pdf server side for copying\emailing? We currently use crystal reports. the server version either 9 or 11. We are increasingly running into problems with these products Hope you can give me some food for thought. Thanks, Scott Thornton, Programmer Billing Unit Hunter-New England Area Health Service ext: 24505 p: +61 02 4941 4505 m: 0413 800 242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: cf8 server monitor on jrun multi instance
As a followup to the below, the part 4 article on the Server Monitor at the Adobe DevCenter is now published (http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt4.html). The section related to Duncan's challenge (or anyone else with problems connecting the Multiserver Monitor to other CF instances) is at: http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt4_03.html So Duncan, did that help solve your problem at all? (I had sent him a pre-publication copy of that section.) /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Thursday, January 17, 2008 5:33 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: cf8 server monitor on jrun multi instance Duncan, and others, it's indeed easy to get confused about setting up the multiserver monitor, and in fact I discuss it at length in the 4th and final part of my 4-part series on the CF8 monitor at the Adobe Dev Center: http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt2.html http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt2.html http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt3.html The 4th part is set to be published Monday. In it, I spell out considerable detail on that policy file, as well as other hassles in setting up the MS monitor. Indeed, one of them you may be hitting, Duncan, could be a hassle with browser caching of that XML file even after you change it. Duncan, I'll send you off-list the couple of pages related to that. The rest of the folks here can see it when it's posted online on Monday (or drop me a note off-list if you're interested). But let me be clear: there's really nothing about the multiserver (multi-instance) deployment mode of CF that really is special when it comes to the multiserver monitor feature of the CF 8 monitor. It's perhaps a poor choice of words on their part. As far as one server's MS monitor is concerned, it doesn't matter what mode of deployment the other CF server (or instance) is--as long as it's CF8 enterprise. The real challenge is getting that policy file right if it's on another domain. (And even if you have multiple sites on a single physical machine, the MS monitor will still regard a call to monitor another domain as requiring permission on that server via its policy file.) Again, all that is explained in considerable detail in the article (just one of many things covered in that 4th part) I hope anyone interested in the CF8 monitor will check out the article. As has been said, the docs and other resources have left a lot to be desired. All that said, I of course stand by FusionReactor as well, along with Mr. Buzzy. Certainly if you're on CF 6 or 7, or CF8 Standard, it and SeeFusion are going to be your best bets for CF server monitoring. (And even on CF8 Enterprise, there are some things that each do that the CF8 monitor does not--especially tremendous logging. But yes, the CF8 monitor clearly also does a lot more things given its being built into the CF engine, so there can be a lot to consider. I'll throw in that as a consultant, this is one of the things I can help anyone with if they're struggling with challenges regarding any of the monitoring tools.) /charlie _ snip On Jan 15, 2008 11:13 AM, Duncan [EMAIL PROTECTED] wrote: How does the server monitor in a multi instance environment behave? Is each instance treated as another 'server', therefore requiring the use of the multiserver monitor? I am having issues adding either an instance or a complete server to the multiserver monitor, I cannot get the monitor to connect. The instructions on the use of the multiservermonitor-access-policy.xml are not entirely clear to me, especially when it comes to the separate instances. For example I have tried adding localhost:9301 with no success, the policy xml file even has allow-access-from domain=* / a whitelist for all domain in it, but still no joy. Thanks -- Duncan I Loxton [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: using an ezxcel file as a datasource under cf8
Thanks, Barry. Claude, I had offered the URL in a note just a couple minutes before that one I responded with. That's the only reason I didn't repeat it. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Tuesday, January 15, 2008 10:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: using an ezxcel file as a datasource under cf8 I'll jump in here, since Charlie works out of Atlanta, Georgia in the U.S and is probably snoring by now. he's referring to a previous post on of his on CFAussie with a similar topic. the resource lists are the ones on his website. http://carehart.org/resourcelists/ have a good poke around the site: lots of stuff there (inc UserGroup TV) HTH barry,b On Jan 16, 2008 1:33 PM, Claude Raiola [EMAIL PROTECTED] wrote: Resource list Please direct me to the page you are reffering to Regards Claude Raiola --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: cf8 server monitor on jrun multi instance
Duncan, and others, it's indeed easy to get confused about setting up the multiserver monitor, and in fact I discuss it at length in the 4th and final part of my 4-part series on the CF8 monitor at the Adobe Dev Center: http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt2.html http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt2.html http://www.adobe.com/devnet/coldfusion/articles/monitoring_pt3.html The 4th part is set to be published Monday. In it, I spell out considerable detail on that policy file, as well as other hassles in setting up the MS monitor. Indeed, one of them you may be hitting, Duncan, could be a hassle with browser caching of that XML file even after you change it. Duncan, I'll send you off-list the couple of pages related to that. The rest of the folks here can see it when it's posted online on Monday (or drop me a note off-list if you're interested). But let me be clear: there's really nothing about the multiserver (multi-instance) deployment mode of CF that really is special when it comes to the multiserver monitor feature of the CF 8 monitor. It's perhaps a poor choice of words on their part. As far as one server's MS monitor is concerned, it doesn't matter what mode of deployment the other CF server (or instance) is--as long as it's CF8 enterprise. The real challenge is getting that policy file right if it's on another domain. (And even if you have multiple sites on a single physical machine, the MS monitor will still regard a call to monitor another domain as requiring permission on that server via its policy file.) Again, all that is explained in considerable detail in the article (just one of many things covered in that 4th part) I hope anyone interested in the CF8 monitor will check out the article. As has been said, the docs and other resources have left a lot to be desired. All that said, I of course stand by FusionReactor as well, along with Mr. Buzzy. Certainly if you're on CF 6 or 7, or CF8 Standard, it and SeeFusion are going to be your best bets for CF server monitoring. (And even on CF8 Enterprise, there are some things that each do that the CF8 monitor does not--especially tremendous logging. But yes, the CF8 monitor clearly also does a lot more things given its being built into the CF engine, so there can be a lot to consider. I'll throw in that as a consultant, this is one of the things I can help anyone with if they're struggling with challenges regarding any of the monitoring tools.) /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Sent: Wednesday, January 16, 2008 7:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: cf8 server monitor on jrun multi instance My problem lies in connecting the multi server monitor to the instances on the same machine I have 2 instances on each of my servers and I cant get the multi instance of being able to register the servers. entering localhost:9301 doesnt allow it to connect - I have tried all the common ports, and the help doesnt seem to be much help to me. On Jan 17, 2008 11:18 AM, MrBuzzy [EMAIL PROTECTED] wrote: I've done it... works for me. Sorry, I'd like to help but I can't really see where you're going wrong. FYI The muti-server monitor seems to capture summary information from each of the servers. You can 'drill down' to the single instance monitor to view further details. Have you been able to monitor a single instance? I find the CF8 server monitor is buggy and problematic, hence FusionReactor is the current weapon of choice. On Jan 17, 2008 9:41 AM, Duncan [EMAIL PROTECTED] wrote: Can anyone help with this? On Jan 15, 2008 11:13 AM, Duncan [EMAIL PROTECTED] wrote: How does the server monitor in a multi instance environment behave? Is each instance treated as another 'server', therefore requiring the use of the multiserver monitor? I am having issues adding either an instance or a complete server to the multiserver monitor, I cannot get the monitor to connect. The instructions on the use of the multiservermonitor-access-policy.xml are not entirely clear to me, especially when it comes to the separate instances. For example I have tried adding localhost:9301 with no success, the policy xml file even has allow-access-from domain=* / a whitelist for all domain in it, but still no joy. Thanks -- Duncan I Loxton [EMAIL PROTECTED] -- Duncan I Loxton [EMAIL PROTECTED] -- Duncan I Loxton [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Cold Fusion Exporting To Excel
Claude, just this week I created an extensive list of resources on the many ways to process Excel files (input and output, including multiple worksheets) in CFML, which I introduced in this blog entry: How can I process Excel files in CFML? Let me count the ways http://carehart.org/blog/client/index.cfm/2008/1/12/coldfusion_excel_xls_pro cessing I list several solutions, and while I don't specifically name one that does multiple worksheets, I know that among those listed are some that do. Shouldn't take too long to sort through them. And I hope it may serve as a repository for others to keep in mind to reference when others ask about ways to process Excel files in CFML. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Peter Bell Sent: Monday, January 14, 2008 5:29 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Cold Fusion Exporting To Excel I know Ben Nadel did a bunch on Excel - might be worth searching www.bennadel.com to see if he's got anything on point. Best Wishes, Peter On 1/14/08 5:24 PM, Ryan Sabir [EMAIL PROTECTED] wrote: Easiest way is to mock up the spreadsheet you want in Excel, with the multiple workbooks, then export it as XML. Then you can view the generated XML and recreate it dynamically from your Cold Fusion app. Only problem is that this won't work as easily on versions of Excel prior to 2003, or on the Mac. _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Claude Raiola Sent: Tuesday, 15 January 2008 9:18 AM To: [EMAIL PROTECTED]; cfaussie@googlegroups.com Subject: [cfaussie] Cold Fusion Exporting To Excel Hi, I have a bookings table containing details of guests who have stayed rooms within a hotel I am wanting to output the table grouping the data into room number and then sorting the bookings by arrival date. All that is easy However I am wanting the output to be stored in one single excel spreadsheet where the each room number has its own tab (workbook) within the single spreadsheet file and then the bookings relevant to each room number appear within each workbook Kind Regards Claude Raiola B.Econ(Acc.); B.Hotel Mngt. Mobile: 0414 228 948 Phone: 07 3666 0981 Fax: 07 3319 6444 Websites: www.WebsiteSolutions.com.au http://www.websitesolutions.com.au/ http://www.websitesolutions.com.au/ www.AustralianAccommodation.com http://www.australianaccommodation.com/ http://www.australianaccommodation.com/ www.AccommodationNewZealand.com http://www.accommodationnewzealand.com/ http://www.accommodationnewzealand.com/ www.HospitalityPurchasing.net http://www.hospitalitypurchasing.net/ http://www.hospitalitypurchasing.net/ www.Samaris.net http://www.samaris.net/ http://www.samaris.net/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Georgiou Sent: Tuesday, 15 January 2008 7:52 AM To: [EMAIL PROTECTED] Subject: Re: [coldfusion-howto] SQL Statement needs a line break? thanks all! I will try all these suggestions and let you know.. George On Jan 14, 2008 1:46 AM, Hank Miller [EMAIL PROTECTED] mailto:hankcfman%40yahoo.com mailto:hankcfman%40yahoo.com wrote: You can try... USE [mydb]; SET ANSI_NULLS ON; SET QUOTED_IDENTIFIER ON; SET ANSI_PADDING ON; CREATE TABLE [dbo].[tbl_test]( Get rid of the GOs. -hankcfman - Original Message From: George Georgiou [EMAIL PROTECTED] mailto:george1977%40gmail.com mailto:george1977%40gmail.com george1977%40gmail.com To: [EMAIL PROTECTED] mailto:coldfusion-howto%40yahoogroups.com mailto:coldfusion-howto%40yahoogroups.com coldfusion-howto%40yahoogroups.com Sent: Sunday, January 13, 2008 1:47:29 PM Subject: [coldfusion-howto] SQL Statement needs a line break? Hi there, I am an experienced coldfusion developer (7 years now). This is the first time i see this. I am trying to create a table from a CFQuery. I have something like : cfquery USE [mydb] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_test]( . etc etc etc If I paste this in the query analyzer it works great. If I run this through a cfquery I get an error like [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'GO'. The problem is that it seems that coldfusion sends the sql statement as a single line (i.e. no line-breaks). Is there any way to add a 'line-break' to the cfquery after each sql-line? I have tried using the #chr(10)#, the #chr(13)# (and also the br) but it does not work. In other words I have tried something like: USE [mydb] #chr(10)# GO#chr(10)# SET ANSI_NULLS ON #chr(10)# GO #chr(10)# SET QUOTED_IDENTIFIER ON #chr(10)# GO #chr(10)# etc but still, this doesn't work :-( Any ideas on how to do this ? thanks, George [Non-text portions of this message have been removed] ~ *** Yahoo's No. 1 and the biggest group of ColdFusion Developers ColdFusion MX Hosting - 250 MB
[cfaussie] liotta effect (Was RE: [cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())?)
That was too funny, Geoffbest laugh we've had here at the old CFers retirement community since...why...since we listened to the 8 track of Don Rickles last week. Or was it last year? Oh, here comes the orderly to give me my Geritol. :-) Seriously, though, I do kind of miss Matt (Liotta) on the lists. As you say, for the flaws in his email style, he was indeed very nearly always right. I can report too that I've seen him on and off in recent years here in Atlanta and he's definitely mellowed with age. Married now, and quite happy in home and work, last I saw him. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Geoff Bowers Sent: Saturday, January 12, 2008 11:34 PM To: cfaussie Subject: [cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())? ... what the Methuselah amongst us would recognise as a Liotta Complex. ... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Small but large problem
Just an FYI: if one is on CF8, you can see the generated SQL in a dump of the query (or by using the RESULT attribute and dumping it). And even in CF7 and 6, I seem to recall that there are some undocumented java objects you can call to show you the generated SQL in a query. (Not denying the value of what you proposed, Haikal, and FusionReactor has the same sort of jdbc wrapper feature that can also show you the generated SQL. But if one wants JUST that, the monitor tools are overkill--though most would benefit from running either one.) /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Haikal Saadh Sent: Thursday, January 10, 2008 12:41 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Small but large problem Are you using SeeFusion? If you are, you should be able to see what the exact SQL passed to CF is. (And also, why are you not using cfqueryparam ?) Andrew Scott wrote: I have spent a day on this, and I can see the potential problem but having one of those days where it is just not working out. I have an application that needed a bit of a tweak, and got so far before I ran into a problem. So here is a bit of history on this section of the application. I have a component that is to do with Car Hire, the Database structure is set in place that it is difficult to modify the database too much. It was all working fine until the client wanted to be able to filter results based on a pickup / drop off location. This then through the calculation of the Car Hire into total kaos. The query is as this to return the records. *Select* CarHire.CarHireId, CarHire.Location, CarHire.Inclusions, CarHire.CarSeats, CarHire.CarCode, CarHire.OperatorId, CarHire.CompanyId, CarHirePrices.CurrencyId, CarHire.CarGroup, CarHire.CarType, CarHire.RegionId, CarHire.IsActive, CarHire.GSTApplies, Currency.CU_Code, Currency.CU_Currency, Currency.CU_CountryName, Currency.CU_Symbol, Currency.CU_Position, Currency.CU_Rate, Currency.CU_DateEntered, Currency.CU_isActive, CarHireCompany.CC_Name, CarHireCompany.CC_Details, CarHirePrices.Markup, CarHirePrices.Tax, CarHirePrices.Commision, CarHirePrices.SellBy, CarHirePrices.CarHirePricesId, CarHireSeasonality.IsSeasonal, CarHireSeasonality.FromDate, CarHireSeasonality.ToDate, CarHirePrices.EnteredDate, *from*CarHire *inner* *join* CarHirePrices *ON* CarHire.CarHireId = CarHirePrices.CarHireId *inner* *join* CarHireCompany *ON* CarHire.CompanyId = CarHireCompany.CC_ID *inner* *join* Currency *ON* CarHirePrices.CurrencyId = Currency.CU_ID *inner* *join* CarHireSeasonality *ON* CarHirePrices.CarHirePricesId = CarHireSeasonality.CarHirePricesId *where* CarHire.IsActive = 1 Now that works, fine. I created two tables for pickup and dropoff, which are basic ID, CarHireId, LocationId and wanted to add it to the above code in a manner as. Select ... *cfif LocationPickup neq * * , PickupRegion.LocationName like '%LocationPickup%'* */cfif* *cfif LocationDropOff neq * *, DropOffRegion.LocationName like '%LocationDropOff%'* */cfif* From carHire *cfif LocationPickup neq * *inner* *join* regions as PickupRegion *ON* CarHire.CarHireId = CarHirePickup.CarHireId */cfif* *cfif LocationDropOff neq * *inner* *join* regions as DropOffRegion *ON* CarHire.CarHireId = CarHireDropOff.CarHireId */cfif* *inner* *join* CarHirePrices *ON* CarHire.CarHireId = CarHirePrices.CarHireId *inner* *join* CarHireCompany *ON* CarHire.CompanyId = CarHireCompany.CC_ID *inner* *join* Currency *ON* CarHirePrices.CurrencyId = Currency.CU_ID *inner* *join* CarHireSeasonality *ON* CarHirePrices.CarHirePricesId = CarHireSeasonality.CarHirePricesId *where* CarHire.IsActive = 1 But for some reason the query doesn't work and starts to complain, when there is either a Pickup or DropOff about error in syntax. Now the above was typed in a hurry so there maybe a problem. But when I run the query in SQL Manager it seems to reorganise the SQL Code so that it runs of one of the Location Tables, anyone have any ideas? Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au http://www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())?
Glad you clarified that, Mr. Buzzy. I was about to use your comment as nomination for a new CFEmmy category next year: most perverse coding practice. :-) /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of M@ Bourke Sent: Tuesday, January 08, 2008 8:17 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())? giving javascript to the head sorry sending probably would have been better M@ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())?
Doh!.I was just so tickled by the Freudian slip that I wrote in haste. :-) It didn't help that Mr. B had also written 2 notes (on the cf admin issue thread) just before I read your notes. Sorry, [EMAIL PROTECTED] /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of M@ Bourke Sent: Tuesday, January 08, 2008 12:28 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())? I aint Mr Buzzy I'm M@ like on the floor --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Multipage PDF as Blob in database
Justin, you don't show using type=application/pdf in the CFCONTENT. I realize you may be saying that it was working for you as long as the PDF wasn't multi-page, but how about adding that? Or it could also be your lack of reset=Yes, if any other content had been generated on the page prior to the CFCONTENT. BTW, another hidden gem in CF8 is that if you were using the FILE attribute in CFCONTENT (as opposed to your use of variable), you could get away with not specifying the TYPE, and it would to try to figure out the mime type from the file. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Justin Raymond Sent: Monday, January 07, 2008 12:13 AM To: cfaussie Subject: [cfaussie] Multipage PDF as Blob in database Hi all, (IIS,SQL Server, CF7) I am having been storing files as blobs successfully for a while and am streaming it directly to the browser using the following: CFHEADER NAME=content-disposition value=attachment; filename=#fileDetails.file_name# cfcontent type=#fileDetails.content_type# variable=#fileDetails.file_object# However i have noticed that whenever a MULTI-PAGE pdf file is uploaded and then streamed back to the browser it opens as a damaged and corrupt file. Has anyone experienced this or have any suggestions? Thanks again Justin --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())?
I step into these waters carefully, as I know that it's a serious issue for many here. As for the whole debate about DateFormat vs LSDateformat, etc., it really is just a remnant of history. I wouldn't say it's there for backward compatibility but rather it was there first. The LS functions were added back in CF4, if I recall correctly (or maybe 3.1), and of course by then thousands if not millions of lines of code would have been written using the older DateFormat. Also, since this was before the move to CFMX (and the standardization on Java locale processing), there may well have been issues that kept some from even moving to the LS functions if they wanted to. Then there's the point made about whether Americans (and software makers) pay enough attention to I18N. Surely we don't, and it's embarrassing, but this is similar to Owen's complaint: why don't we Americans just get with the program on using the dateformat used by many others. As above, I don't know who was first, but we could also debate driving on the left vs right, race tracks going clock-wise versus counter-, and using the metric system. :-) Honestly, having lived in both countries, I wouldn't argue against the latter (nor against the date formatting change). I was a child in school in the 70's when metric conversion was attempted. We kids were all for it. It was the older folks who fought it. Changes like that are really tough to make, what with folks clinging to old ways, fearing change, etc. I honestly see it the same with DateFormat. Could they deprecate it? Sure? Should they? Why not. Will they ever obsolete it (make it no longer work)? That will take some backbone, considering the millions of lines of code that would likely use it. I doubt it would happen. Just too painful. I'm just one voice, and not even an informed one on this subject. This is clearly something (internationalization) that affects some far more than others (and I might add, sadly for some, more than most.) That's probably the root of the problem: typical American ignoring of international matters. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Owen West Sent: Monday, January 07, 2008 1:21 AM To: cfaussie@googlegroups.com Subject: [cfaussie] should DateFormat() be depricated (in favour ofLSDateFormat())? or, we could just make idiot American's use the same date formats as the rest of the English-speaking world! or is that too harsh (methinks not, having been burned by Allaire/Macromedia/Adobe/Microsoft/Borland/the list goes on and on with regards to storing, interpreting and using dates across international boundaries). The whole thing makes me see red!! Owen West MCP MCAD MCSD Computer Programmer Applications Development Team Information Technology Telecommunications Hunter New England Health Ph: (02) 4921 4194 Fax: (02) 4921 4191 Email: [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: should DateFormat() be depricated (in favour of LSDateFormat())?
And in case it's of any value, if one felt that changing the locale request-wide was still a problem (issuing setlocale in a given template to affect a given function), note that one of the many hidden gems in CF8 is that the LS functions now accept locale as an argument, so you don't even need to use setLocale if you don't want to for some reason. (It also helps for the situation where SetLocale doesn't work after a CFFLUSH, etc.) For those curious, yes I did mention this in my Hidden Gems talk, but many surely have not seen it, and even those who did might have forgotten it. :-) /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Raymond Camden Sent: Monday, January 07, 2008 12:15 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: should DateFormat() be depricated (in favour of LSDateFormat())? setLocale isn't server wide, not even application wide. It is request based. If you want it app wide, you need to add it to onRequestStart(). On Jan 7, 2008 12:07 AM, MrBuzzy [EMAIL PROTECTED] wrote: I'd really like to keep this going but I'm confused about who is talking to who :( @Andrew I don't agree it's a hack, I could accept that it's a necessary evil. @hakal I totally agree that date strings are evil and probably at the heart of the problems. Someone mentioned using setlocale()... Feel free to correct me, but isn't that a server wide function? Changing the locale this way *could* cause problems to other apps. It'd be nice if it was an application property instead. -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())?
I'm not sure I want to be dragged into this, but I'll offer at least one reply. Can you clarify what you mean to say you disagree with? It's not clear. Are you challenging why people used DateFormat historically over LSDateformat? Or debating that I've erred in how/why people have not moved to the latter? I didn't think it was debatable, just historical. But if you see it differently... As for your saying, the only difference is that LSDateFormat takes an option argument called locale, what do you mean? The locale argument is new in CF8, yet the LS functions have existed for nearly 10 years. They are certainly different. The LS functions are driven by SetLocale (if the locale argument is not specified) where the older ones (like DateFormat) are not. They have no notion of locales at all. You say, instead of taking the servers locale / region settings ColdFusion went its own method that didn't work--what method are you referring to? Just to be clear? Is it that you think that when they considered adding LSDateFormat, they should have instead just made DateFormat work based on selocale? I suppose they could have. You'd need to take it up with Allaire/MM/Adobe engineers to fully understand their motivation. Sure, sometimes it's faulty, but often we find (even in current discussions over things in 8/8.1) that there are debates where a choice seems obvious--until someone points up a compatibility or other issue. Just saying we ought to have a little grace when considering such things, rather than presume people were being stupid. Anyway, I have no investment in this either way. Please don't set me up as a strawman/punching bag. I was just offering another perspective. You're certainly free to disagree, but don't feel that I'm trying to pick a fight with you. I'm really not. Just want to help you (help everyone) get on the same page in the discussion. Finally, I hesitate to ask, but what's your beef with CFHTMLHEAD? If it's been debated before, feel free (someone, anyone) to point to a URL. I use it all the time in a site where the HTML head tags are written previously but later I want to set a specific title for a given page. That's the best way (and only way I know) to do that. Or are you complaining about some subtlety of it that doesn't work always? /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Monday, January 07, 2008 1:32 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())? Charlie, I will disagree with you, and this is why. If you look at the attributes / arguments that both functions take, the only difference is that LSDateFormat takes an option argument called locale. But if you do not set the Locale it is by default set to USA date format (I can't confirm this, I can only go by the fact if the local is not set it ends up that way). So in hindsight, instead of adding that extra argument to DateFormat the developers moved over to a set of LS functions... Why? To me that is a hack, or blindsighted. So, to overcome the problem of such things the rest of the world outside of the USA has to use the locale to get proper date formating, and instead of taking the servers locale / region settings Coldfusion went its own method that didn't work. So now we have something where we can use LS functions for locale, but we now have a function that is left behind because it can't be depricated and that is why I call it a hack. However, any developer worth their salary would design with locale in mind and allow for the application to switch to what ever the user of the application would want the date in and not what the Developer of the Application wants them to be. I guess it can be debated all you like, but at the end of the day LSDateformat is not the only function that was added as a hack, I can name so many of these functions that have been added without any thinking at all. CFHTMLHEAD, is just one of those tags. On 1/8/08, Charlie Arehart (lists account) [EMAIL PROTECTED] wrote: I step into these waters carefully, as I know that it's a serious issue for many here. As for the whole debate about DateFormat vs LSDateformat, etc., it really is just a remnant of history. I wouldn't say it's there for backward compatibility but rather it was there first. The LS functions were added back in CF4, if I recall correctly (or maybe 3.1), and of course by then thousands if not millions of lines of code would have been written using the older DateFormat. Also, since this was before the move to CFMX (and the standardization on Java locale processing), there may well have been issues that kept some from even moving to the LS functions if they wanted to. Then there's the point made about whether Americans (and software makers) pay enough attention to I18N. Surely we don't, and it's embarrassing, but this is similar to Owen's complaint
[cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())?
Andrew, I know people hate to see these kind of debates drawn out, and I've been warned before not to be pulled into the web you weave :-), but I can't let you stand on your assertions. You say The code behind LSDateFormat is identical to DateFormat, the only difference is that LSDateFormat has a wrapper to call DateFormat and guess what DateFormat returns the default Locale. So my question is this, why? I can see that with the new argument locale, that could be the only reason behind it. Again, the function came out several years ago, before the addition of the new argument locale. All the discussion here yesterday was about how it works with SetLocale. I was the first to bring up the new locale functionality in CF8. So all the other folks here are clearly discussing (as they should) how the LS functions can be manipulated based on the SetLocale. DateFormat, as an example, cannot. They're not the same, dude! I think your Software Engineer point of view is clouding your perspective. Or others jump in. Am I missing something? Again, I prefaced my first note here by admitting that I'm no expert on localization. Many of you are. Is Andrew on to something here? Or missing the boat? And what about Barry and others earlier in the thread who brought all this up: have any of my points helped you? As for CFHTMLHEAD, again, I find your argument pretty specious. But please read me carefully before responding. I'm not debating your suggested enhancement. You accuse it of appearing to have ... been thrown in at the last minute, but again it's one of the oldest tags in CFML. You can complain that it doesn't do what you want (that seems your beef), but you can't argue that it was thrown together at the last minute just because it doesn't meet a need you see. Again, you're accusing the engineers of being stupid, and not foreseeing what you see is clearly a superior approach. I daresay no one has reconsidered that tag and its uses in the several years since it came out. Should they? Perhaps. That's where you can file an enhancement request, so it's good to hear that you have. (So you see, I'm not arguing that your proposed suggestion is specious--just the assertion about the tag being so brain dead. It does serve the needs for which it was originally created.) I only pressed this because you threw out the off-hand comment at the conclusion of your earlier note that this was another example of things in CFML that have been added without any thinking at all. I just think those kind of comments are incendiary and inappropriate. Again, we don't have insight into the many decisions that go on in the engineering team, whether when creating a tag/function or when modifying it. Do I always agree with them? Heck no. But that's what the betas are for. Get in there early and make your case known, as it seems you have. Just think twice about casting the aspersions (as I now see someone else said in that other forum that cannot be named which you hinted at). Really, you can make your point without that. :-) /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Monday, January 07, 2008 5:58 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: should DateFormat() be depricated (in favour ofLSDateFormat())? Sure, First things first I did not read your post in its entirety so the context of disagreeing with you, goes right out the window:-) But to keep the subject in its context, I do wonder what was going through the developers minds when they created the LSDateFormat and for what purpose. But I can tell you this. The code behind LSDateFormat is identical to DateFormat, the only difference is that LSDateFormat has a wrapper to call DateFormat and guess what DateFormat returns the default Locale. So my question is this, why? I can see that with the new argument locale, that could be the only reason behind it. Anyway, I speak from a Software Engineer point of view and I do not see any reason for 2 functions that technically do the same thing. Now let's talk about cfhtmlhead. While converting some of my extJS code over to coldfusion 8, I found that a lot of it broke with JS code couldn't be found. Yet there they are in the view source, so when I went investigating and did some further tests, the JS HAS to be in the html HEAD tag. So with that in mind I got told that is why this tag exists. So let's now look at why this is a hack at its best. To use this as it currently is one has to do this. cfsavecontent variable=Test ... Some JS code. /cfsavecontent cfhtmlhead text=#Test# Now I can't discuss where I am talking about this, but I can tell you that I have full support on some recommendations from suggested by Sean Corfield and it has been filed as an ER. My reasoning is simple, the one thing I hate is messy code, JS all over the place code not where it should be etc. And I didn't even know about this
[cfaussie] Re: sites to submit cf tutorials to.
Ah, sorry Taco. I was focused on it more as a place to find tutorials, but of course you were asking for a place to offer them. I do believe that the CMX folks accept tutorials from new contributors. I've looked for a place to propose them but find none, so have asked someone I know involved in it (as I once was and will be again soon). I'll let you know here when I find out. (But no, you'd never have to pay to submit one. Rather, the question is whether you'd get a share of the revenue if you did. Again, I don't know the answer for one-off or sporadic contributors, but again will ask.) /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Saturday, January 05, 2008 6:48 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: sites to submit cf tutorials to. umm, how does one submit an article without paying? On 1/6/08, Charlie Arehart (lists account) [EMAIL PROTECTED] wrote: Here's yet another: communitymx.com http://communitymx.com/ . They have a specific section on CF tutorials at: http://www.communitymx.com/category.cfm?catID=4 http://www.communitymx.com/category.cfm?catID=4typeid=2 typeid=2 While some of the content costs money (inexpensive) to see, much does not. /charlie _ From: cfaussie@googlegroups.com [mailto: mailto:cfaussie@googlegroups.com [EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Saturday, January 05, 2008 4:00 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: sites to submit cf tutorials to. Thanks, will have a look. On 1/5/08, flew [EMAIL PROTECTED] wrote: coldfusioncookbook.com http://coldfusioncookbook.com/ Mark F On Jan 5, 3:03 am, MrBuzzy [EMAIL PROTECTED] wrote: Err... Learncf.com http://learncf.com/ just ask dale :) On 1/5/08, Taco Fleur [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Does anyone know a list of sites where to submit cf tutorials to? I tried Google, but thats just page after page of easycfm.com http://easycfm.com/ gave up on that one. Thanks -- Looking for a business, product or service? Try the new Australian search enginewww.clickfind.com.au http://enginewww.clickfind.com.au/ blog:http://australian-search-engine.blogspot.com/ http://australian-search-engine.blogspot.com/ -- Sent from Gmail for mobile | mobile.google.com http://mobile.google.com/ -- http://www.clickfind.com.au http://www.clickfind.com.au/ Looking for a business, product or service? Try the new Australian search engine www.clickfind.com.au http://www.clickfind.com.au/ blog: http://australian-search-engine.blogspot.com/ http://www.clickfind.com.au Looking for a business, product or service? Try the new Australian search engine www.clickfind.com.au blog: http://australian-search-engine.blogspot.com/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: sites to submit cf tutorials to.
Taco, as for submitting tutorials to the CommunityMX site as a non-partner contributor, here's the info I got from my contact there: As for guest authors, you can have him contact Bill Horvath, [EMAIL PROTECTED] as he coordinates the outside authors. Frequently guest authors articles are free, but not always. We pay a flat fee per article. So give them a shot, Taco. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Sunday, January 06, 2008 10:54 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: sites to submit cf tutorials to. Ah, sorry Taco. I was focused on it more as a place to find tutorials, but of course you were asking for a place to offer them. I do believe that the CMX folks accept tutorials from new contributors. I've looked for a place to propose them but find none, so have asked someone I know involved in it (as I once was and will be again soon). I'll let you know here when I find out. (But no, you'd never have to pay to submit one. Rather, the question is whether you'd get a share of the revenue if you did. Again, I don't know the answer for one-off or sporadic contributors, but again will ask.) /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Saturday, January 05, 2008 6:48 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: sites to submit cf tutorials to. umm, how does one submit an article without paying? On 1/6/08, Charlie Arehart (lists account) [EMAIL PROTECTED] wrote: Here's yet another: communitymx.com http://communitymx.com/ . They have a specific section on CF tutorials at: http://www.communitymx.com/category.cfm?catID=4 http://www.communitymx.com/category.cfm?catID=4typeid=2 typeid=2 While some of the content costs money (inexpensive) to see, much does not. /charlie _ From: cfaussie@googlegroups.com [mailto: mailto:cfaussie@googlegroups.com [EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Saturday, January 05, 2008 4:00 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: sites to submit cf tutorials to. Thanks, will have a look. On 1/5/08, flew [EMAIL PROTECTED] wrote: coldfusioncookbook.com http://coldfusioncookbook.com/ Mark F On Jan 5, 3:03 am, MrBuzzy [EMAIL PROTECTED] wrote: Err... Learncf.com http://learncf.com/ just ask dale :) On 1/5/08, Taco Fleur [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Does anyone know a list of sites where to submit cf tutorials to? I tried Google, but thats just page after page of easycfm.com http://easycfm.com/ gave up on that one. Thanks -- Looking for a business, product or service? Try the new Australian search enginewww.clickfind.com.au http://enginewww.clickfind.com.au/ blog:http://australian-search-engine.blogspot.com/ http://australian-search-engine.blogspot.com/ -- Sent from Gmail for mobile | mobile.google.com http://mobile.google.com/ -- http://www.clickfind.com.au http://www.clickfind.com.au/ Looking for a business, product or service? Try the new Australian search engine www.clickfind.com.au http://www.clickfind.com.au/ blog: http://australian-search-engine.blogspot.com/ http://www.clickfind.com.au Looking for a business, product or service? Try the new Australian search engine www.clickfind.com.au blog: http://australian-search-engine.blogspot.com/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] recording CFUGs, or presenting on the CF Meetup (was RE: [cfaussie] Re: Melbourne CFUG Tomorrow night - Are you coming?)
Thanks, Mark. You said, We don't tend to have our presentations over connect. Maybe you're aware but I'll point out for any CFUG managers here that if you do want to record your meetings, you don't need to have either a remote speaker or remote attendees. You can just fire it up and hit record for a single local speaker, as long as you have a mic in internal or external mic. Of course, some don't want to record their meetings. Not trying to force that on anyone. Dale, if you'd like to present your Ajax talk again on the ColdFusion Meetup (a weekly online CFUG, at coldfusionmeetup.com for those who've not heard of it), just drop me a note at [EMAIL PROTECTED] The invitation is open to anyone there who might like a chance to speak (or speak again) to an entirely online audience. We have a few slots open in January and all slots open in the months to follow. Our 6pm (Eastern US) time is 10am EST for you guys. For more on the group and speaking to it, see http://carehart.org/blog/client/index.cfm/2007/11/5/seeking_speakers_for_the _CF_Meetup. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Sunday, December 23, 2007 10:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Melbourne CFUG Tomorrow night - Are you coming? Charlie, We don't tend to have our presentations over connect... so I'm sorry to say, there was no recording. Mark --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Melbourne CFUG Tomorrow night - Are you coming?
Hey Mark, did you guys happen to record that talk? Sounds compelling. If so, besides sharing the URL here, could you (or someone) consider adding it to the UGTV list (carehart.org/ugtv/)? Thanks, mate. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Tuesday, December 18, 2007 7:39 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Melbourne CFUG Tomorrow night - Are you coming? Well, I've got a few more RSVP's now, so it looks like the meeting is on! So a reminder then to all: Location: NGA.net, Level 2, 17 Raglan St, South Melbourne Map: http://link.toolbot.com/google.com/73016 When: 20TH of December, Meeting starts at 7:00, so get there before hand (doors open at 6:30). Agenda: Da Fraser will be presenting on CFAJAX! ColdFusion 8 includes a lot of Ajax features, and if you think Ajax is complicated, think again. Ajax will make some of the things you do now easier, and if you can write ColdFusion code, you can easily use Ajax with ColdFusion Ajax features. So if you have always wanted to do some Ajax stuff or you want to learn what Ajax is, then this is for you. Topics covered include: * CFAJAXPROXY to bind to controls and CFC's * CFGRID a DHTML grid with binding and paging * CFINPUT an autosuggest feature using Ajax binding * The ColdFusion. javascript methods that come with ColdFusion 8 * And more If you are going to attend, please RSVP to [EMAIL PROTECTED] Only those that RSVP are eligible for the door prizes, so make sure you apply! See the CFUG Melbourne Calendar at: http://www.cfcentral.com.au/Events/index.cfm Or add to your Google Calendar - search for 'CFUG Melbourne'. As per usual, we'll grab pizza during the evening, so we have something to scoff down! Look forward to seeing you all there. On Dec 19, 2007 11:27 AM, George Lu [EMAIL PROTECTED] wrote: Sorry Mark. It's my wording problem. I should say - I'll come if the meeting is not canceled. On 19/12/2007, Mark Mandel [EMAIL PROTECTED] wrote: George, Does that mean.. you are coming.. or you aren't? ;) That was dreadfully cryptic. Mark On Dec 19, 2007 10:46 AM, George Lu [EMAIL PROTECTED] wrote: Hi Mark, I'd like to come. Cheers, George On 19/12/2007, Mark Mandel [EMAIL PROTECTED] wrote: All, I've only received one RSVP for tomorrow night's CFUG meeting in Melbourne. If you are planning on attending, please email me, as we are considering cancelling the night. Cheers, Mark -- E: [EMAIL PROTECTED] W: www.compoundtheory.com -- E: [EMAIL PROTECTED] W: www.compoundtheory.com -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: 301 redirect not changing URL [SOLVED]
Hey folks, I know this discussion of 301 redirects is a couple weeks old, and that Ryan says he's solved the problem, but I don't recall anyone bringing something that could be useful, if one's on CF8 (and I don't recall Ryan saying if he is). CFLOCATION now accepts the StatusCode as an attribute itself, so you can do a 301 with CFLOCATION. It muddies the waters a bit, since for so long all have associated CFLocation instantly as being a 302, as in this thread. Oh well. It's Christmas. Consider it a new toy. :-) It's one of the 100+ hidden gems I've chronicled in the talk I've given, Hidden Gems in CF8, which I intend to turn into a modestly priced half-day online course in the new year. More on this CFLOCATION STATUSCODE feature (other than the docs, of course) is at: http://www.petefreitag.com/item/648.cfm http://www.coldfusionguy.com/ColdFusion/blog/index.cfm/2007/12/6/301-Redirec ts-With-CFLocation-StatusCode-Attribute http://www.coldfusionjedi.com/index.cfm/2007/6/7/Automatically-pushing-to-a- new-URL-and-how-ColdFusion-8-makes-this-a-bit-simpler More on the concept in general is also available at: http://www.wrox.com/WileyCDA/Section/id-306460.html Seriously, though, Merry Christmas to all. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sabir Sent: Monday, December 17, 2007 7:27 PM To: 'cfaussie@googlegroups.com' Subject: [cfaussie] Re: 301 redirect not changing URL [SOLVED] Hi all, Andrew here came up with the solution: You need to write the header tag like this : cfheader statuscode=301 statustext=Moved Permanently#Chr(13)##Chr(10)#Location:#newurl# All in one line. Now the redirect works.. and the URL changes. Yippee! From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rony Fayyad Sent: Tuesday, 18 December 2007 11:10 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: 301 redirect not changing URL You could also try running that snippet of code on a different Coldfusion instance and see if the issue still ocurrs - may be try it on your local host or another dev box. See if its a CF thing - Original Message - From: Ryan Sabir mailto:[EMAIL PROTECTED] To: 'cfaussie@googlegroups.com' Sent: Tuesday, December 18, 2007 10:48 AM Subject: [cfaussie] Re: 301 redirect not changing URL CFLOCATION is a 302 redirect. It tells the search engine that the resource requested has been moved temporarily. A 301 redirect tells a search engine that the resource has been moved permanently, so no longer look for it at the original URL. At least that's how I understand how it works. From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Blair McKenzie Sent: Tuesday, 18 December 2007 10:42 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: 301 redirect not changing URL Is there any reason not to use cflocation? Does it not handle that stuff? Blair On Dec 18, 2007 10:38 AM, Ryan Sabir [EMAIL PROTECTED] wrote: Yeah but I want the redirect to be a Moved Permanently rather than Moved Temporarily. Its for a site that has changed its URL structure. From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, 18 December 2007 10:06 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: 301 redirect not changing URL Try 302 instead. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sabir Sent: Tuesday, 18 December 2007 9:59 AM To: 'cfaussie@googlegroups.com' Subject: [cfaussie] 301 redirect not changing URL Heya, I'm doing a 301 redirect using CFHEADER like so: cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=http://www.new-url.com; The redirect correctly shows the new page content, but the URL in the browser window is still the old URL. If I bookmark it, its actually bookmarking the old URL. How can I do an SEO friendly redirect, and change the URL as well? thanks.
[cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder
I'll just say one last comment. You conclude with: So arguing about how long it has been around is not relevant to me. What is relevant is what I can't do with it. I wasn't proposing that Derby's merit stands on its heritage alone. I brought it up only because you asserted it was young. I also proposed that if one was going to accuse it of being lacking, it would help that argument (and the community) to name what those limitations are. But I hear you saying you just don't care for it and can't be bothered. No worries. I won't press you for it. I just want to leave people to look into it and decide for themselves, then. No hard feelings. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Wednesday, December 05, 2007 7:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder Charlie, Barry asked a specific question, I gave him an answer we'll leave it at that. As for you not having to use the top scenario, trust me we use it on a daily basis with any form of pagination code. You can live without it as Geoff pointed out, but I do not see caching a query then using QoQ as a solution to data that is constantly changing. In the web2.0, and RIA world the TOP / OFFSET option(s) is mandatory for fast reliable code. So in my eyes, this makes it a non contender for today's market. I am not going to debate with you the pros / cons, I do think it is a fabulous product. But with a very serious limitation. I could go on about other code that I have tested against Derby, but right now it is pointless arguing about something that our company, and many others are going to be needing on a daily basis. That was my point, and I will not change my stance on my original statement. So arguing about how long it has been around is not relevant to me. What is relevant is what I can't do with it. Andrew Scott --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder
But Andrew, can you name anything other than that that it lacks? It's about the only limitation listed here: http://developers.sun.com/javadb/features/faqs.jsp (Derby is known also as Sun's JavaDB, as well as formerly--and still-as IBM Cloudscape.) Really, I just think you're stuck on this TOP thing. Would you be shocked to learn that many developers could go years without needing or using the TOP predicate in SQL? I have, and I'm sure I'm not unique. (There've been other DBMS's over the years that didn't support it at one time or another, so some just have gotten used to accepting a lowest common denominator and programming around such a challenge.) You just keep saying Derby's got serious limitations, yet I don't see them. Since I keep pointing to things that show so much that it's capable of, I'm just asking if you can point at something that says what it doesn't do. I simply want people to be able to decide for themselves, not take either of our assertions as fact. That's all. As for using a cached query, goodness, why would you be averse to that out of hand? There can be times when it may not be wise (a huge result, or too many variations stored over and over), but I can totally argue in favor of using cached queries (whether in a shared scope or using CachedWithin) if done well. You seem to live in a world of absolutes, Andrew. :-) As a consultant, I can't help but be more flexible and say always, it depends. Again, in that regard, I'm all about sharing info to let people decide for themselves. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Wednesday, December 05, 2007 9:23 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder Charlie, No I am not getting hot under the collar, I made a very healthy statement that means that people will seriously need to take into consideration when it comes to Derby. To not support the most basic of retrieving the top n records (whether it be top n or offset n) to me is young, regardless whether the application has been around for 10 years or not. Don't get me wrong, anything that is open source is seriously worth a look at. Just that in this case people need to be aware that there a serious limitations to Derby, that when compared to mySQL, postrgress, msSQL, informix etc. It is young at heart, because it has a long way to go to be compariable to those DB's. As for Geoff, I bawk at anyone who says to cache the query and do a QoQ on that query. It might be a quick fix for now, but in the long run it is not a quick fix and should be refactored to be the best solution as quickly as possible. There is a good book that is out there on Software maintenance, and why one should not look at a band aid solution. Geoff's example, to me is a band aid solution and should be avoided at all costs. Again if I came across angry, it wasn't my intention. On 12/5/07, Charlie Arehart (lists account) [EMAIL PROTECTED] wrote: Andrew, you seem to be getting awfully hot under the collar over all this. snip --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder
Barry, I'll say again that I find is curious to argue that you wouldn't dare run it into production, or use it for serious development. Do you have some objective reference to argue against it? I find nothing but many resources that suggest it's perfectly adequate for it. (Some misconstrue it as a single user DBMS, when that's not the case. It's just that in its embedded mode it permits connections only from within the single JVM in which it's installed, which is CF in our case, so it's absolutely a multi-user DBMS.) As for a DB having to have a RAD tool or RAD tools that work with it to be useful for serious development, I'll say again that it can be used with any tool that supports JDBC. No, it isn't a RAD tool itself, but really most DBs are not. Access is pretty unique in that regard. But sure, visual query builders, sure, there are many. We in CF have those based on RDS, whether in Eclipse using Adobe's CF 8 extensions (and its RDS Dataview), or in Dreamweaver's ApplicationDatabase tab, and CF Studio/HomeSite+'s DB tab. Then there are tools that work with JDBC DBs, such as those I list in the query tools section of my Derby resource. Again, guys, I'm not so much arguing for Derby, but just sharing my observations that seem to counter some that I keep hearing. I just want to help the community get accurate info. Not picking fights or meaning to put anyone down. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, December 05, 2007 5:03 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder my origional post was for using Derby as a prototyping database - get some ideas down, see how it works, get a bit of code written to support it, etc. if it's rubbish, throw it out or store the ideas for later. A few limitations with the core db functionality is survivable. Derby potentially is a good package for teaching, sharing small proof of concept apps, rah rah. I wouldn't dare run it into production, or use it for serious development. to do that though, means that the db itself *has* to be (and let me stress this) a RAD tool itself - or have RAD tools that can work easily with it. Quick and simple generation of the basic db objects and visual indicators (such as relationship diagrams and visual query builders) are essential. It's more than prototyping the code, it's prototyping the concepts and ideas of an app or section of an app. this is why I've been saying MSAccess is king of the mountain in this area - even easier than SQLServer. But it's no good on my Mac when I'm trying ideas on a long train ride... On Dec 6, 2007 12:22 AM, Andrew Scott [EMAIL PROTECTED] wrote: Charlie, No I am not getting hot under the collar, I made a very healthy statement that means that people will seriously need to take into consideration when it comes to Derby. To not support the most basic of retrieving the top n records (whether it be top n or offset n) to me is young, regardless whether the application has been around for 10 years or not. Don't get me wrong, anything that is open source is seriously worth a look at. Just that in this case people need to be aware that there a serious limitations to Derby, that when compared to mySQL, postrgress, msSQL, informix etc. It is young at heart, because it has a long way to go to be compariable to those DB's. As for Geoff, I bawk at anyone who says to cache the query and do a QoQ on that query. It might be a quick fix for now, but in the long run it is not a quick fix and should be refactored to be the best solution as quickly as possible. There is a good book that is out there on Software maintenance, and why one should not look at a band aid solution. Geoff's example, to me is a band aid solution and should be avoided at all costs. Again if I came across angry, it wasn't my intention. On 12/5/07, Charlie Arehart (lists account) [EMAIL PROTECTED] wrote: Andrew, you seem to be getting awfully hot under the collar over all this. Look, I'm not an engineer (or even an apologist) for Derby. I just wanted to help CF folks take advantage of the newly available embedded DB. If it doesn't suit all needs, so be it. I never asserted it was the perfect DB nor the answer to all problems. :-) As for you saying it's been debated here many times, I just don't recall that. Sorry. I did search the Google group just now and find you making a brief mention of this same concern with top and offset back on Sep 24. Is that what you mean? Anyway, thanks, Geoff, for your kind reply. Andrew, I'll still argue that you're incorrect to call it young at the moment (as you did in that note of Sep 24, http://groups.google.com/group/cfaussie/msg/898d1b3cf761979c). It's 10 years old, and while one may say, well, yeah, but maybe that just means it's not been updated
[cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder
Andrew, you seem to be getting awfully hot under the collar over all this. Look, I'm not an engineer (or even an apologist) for Derby. I just wanted to help CF folks take advantage of the newly available embedded DB. If it doesn't suit all needs, so be it. I never asserted it was the perfect DB nor the answer to all problems. :-) As for you saying it's been debated here many times, I just don't recall that. Sorry. I did search the Google group just now and find you making a brief mention of this same concern with top and offset back on Sep 24. Is that what you mean? Anyway, thanks, Geoff, for your kind reply. Andrew, I'll still argue that you're incorrect to call it young at the moment (as you did in that note of Sep 24, http://groups.google.com/group/cfaussie/msg/898d1b3cf761979c). It's 10 years old, and while one may say, well, yeah, but maybe that just means it's not been updated, that doesn't seem the case. Besides the fact that it's in its 10th release, there's also this page outlining SQL-99 and -2003 features supported: http://wiki.apache.org/db-derby/SQLvsDerbyFeatures Just trying to help share info about it, folks. :-) That's all. I've continued to update the page I'd made: http://www.carehart.org/resourcelists/derby_for_CFers/ /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, December 04, 2007 8:45 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder Geoff, I agree, and this has been debated here many times about Derby and I made a statement and backed it up. Now it is up to Charlie to agree or disagree about the limitations that this DB has:-) On 12/4/07, Geoff Bowers [EMAIL PROTECTED] wrote: On Dec 4, 12:50 pm, Andrew Scott [EMAIL PROTECTED] wrote: With the version of Derby that comes with Coldfusion 8, try to do a pagination query. You can track this specific feature here: https://issues.apache.org/jira/browse/DERBY-581 I wrote a tutorial to do pagination with the CFGrid, and both Dale and Myself couldn't get it to work with Derby. And if you read all the notes on the Apache website, you'll see that even they say it is not supported. You could always put the whole query in memory and do query of queries. That would see you through to several thousand rows of data before you would notice any impact. Would you like to debate this even further Charlie? Not sure what point you are trying to make. Charlie seems to have been nothing but helpful. Derby is what it is -- an ideal replacement for Access. It's cross platform, pre-installed, a breeze to set up and very sophisticated despite some missing areas of functionality. -- geoff http://www.daemon.com.au/ -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: good server/website monitoring tool
Barry, I have presented on SeeFusion in the past but it was not recorded. The recordings there are by the guys from Webapper, who make the tool. I have presented on FusionReactor, and have one talk in the UGTV on that. I also teach classes on it for Intergral, the makers of the tool (more at http://www.fusion-reactor.com/support/traininginformation.cfm). If anyone has questions on FusionReactor, I'm happy to answer them. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Saturday, December 01, 2007 6:37 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: good server/website monitoring tool Taco, I coulda sworn that Charlie Arehart has presented on this very topic... but can't find it anywhere my former place of employ used an older version on their production servers, and (IMHO) it was a godsend as far as keeping informed of server health. (Haikal: additional comments?) going thru the captured Breezo's here http://carehart.org/ugtv shows there *is* a presso or two that could be a good start. HTH barry.b On Dec 2, 2007 7:48 AM, Taco Fleur [EMAIL PROTECTED] wrote: That does look like a cool app.. Is anybody out there using this? I thought I'd read some posts saying it slowed the server down? I could be wrong, but it looks like there is no SMS notification going out when down? On 12/1/07, Slava Khokhlov [EMAIL PROTECTED] wrote: try seefusion http://www.seefusion.com/ The new Australian search engine for businesses, products and services --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: [OT] good server/website monitoring tool
Going back to Taco's original question about monitoring site uptime, I can share that there are lots of tools out there, and they vary depending on what you want to pay, how often you want them to check, etc. There are many free versions of the paid ones. I've got a list at http://www.carehart.org/resourcelists/tools_to_consider/index.cfm#mon This is part of a long list of many tools of different sorts (WYSIWYG editors, CMSs, DBs, tools for blogging, query building, load testing and much more) that I (re)launched recently, as explained on the page. I welcome additions and corrections. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Friday, November 30, 2007 12:11 AM To: cfaussie@googlegroups.com Subject: [cfaussie] [OT] good server/website monitoring tool Can anyone recommend a good tool/service for monitoring uptime of website, and be notified by SMS? Thanks. -- *** http://www.clickfind.com.au The new Australian search engine for businesses, products and services --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: good server/website monitoring tool
Doh, Duncan's note arrived just before mine. I've added his to my list. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Sent: Sunday, December 02, 2007 6:27 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: good server/website monitoring tool There are a number of services that are generic, and do things like hit a port to see if it responds, or a URL and look for specific text. We use www.alertra.com and www.watchmouse.com HTH Duncan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder
Hey Andrew, are you speaking of Derby itself or the DTP support for it? I'll assume you mean the latter. I just wouldn't want readers just want to infer from your comments (very basic implementation) that Derby is some new kid on the blog. Folks may be interested to know that it's in fact a 10 year old DBMS (known formerly as Cloudscape, which was first independent, then was bought by Informix, then by IBM before they turned it over to Apache). IBM says that it accepts the same SQL and API calls as DB2, and DB2's been around longer than most enterprise SQL databases. But if you meant the DTP tools, that's cool. Haven't used them yet myself, and honestly I've only just started using Derby. I'm sure some will ask questions like, so what is Derby is good for?, and why would I use it over MySQL? I answer those in the getting started page I pointed to earlier. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Wednesday, November 28, 2007 2:55 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder Yes, This is certainly a work in progress with Derby, do not expect much to work that you would normally expect to work. The basics like top 100, offset or whatever they will end up using for returning top x records is NOT supported at the moment. There is a good little utility called Execute Query @ ExecuteQuery.org, if you have the JDBC driver you will have no problems setting this utility up with any Database. So to sum it up, the select, insert etc queries are very basic implementations at this stage. On 11/28/07, Barry Beattie [EMAIL PROTECTED] wrote: Hi all I'm trying to use the embeded Derby database as a scratch db, try out some ideas, do simple stuff, etc. I'm also trying to get a visual editor/schema explorer going for it - using the Data Tools Platform plug-ins for Eclipse. The Data Tools Platform have a configuration for Derby, but when I point it to the Derby JDBC library, it doesn't take (the Derby Client JDBC jar is in /ColdFusion8/lib ) Has anyone used the Derby database, and more importantly been able to do more than throw create table scripts at it via CF and a DSN? -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder
So please elaborate. What you're saying is inconsistent with what I've seen and/or read so far. Do you have anything (or know anywhere) that documents what you're suggesting? Just really surprises me. You're saying that select, insert etc queries are very basic implementations? That's totally inconsistent with what I've read. The reference at http://publib.boulder.ibm.com/infocenter/cscv/v10r1/topic/com.ibm.cloudscape .doc/crefsqlj39374.html seems very complete, and the support for SQL-92 features doesn't show much not supported: http://publib.boulder.ibm.com/infocenter/cscv/v10r1/topic/com.ibm.cloudscape .doc/rrefsql9241891.html. Again, not trying to be too much of an apologist. Just want to head off any casting of aspersions without solid evidence. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Sunday, December 02, 2007 10:21 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder No I mean Derby as the database itself. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone:Â +613 Â 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Monday, 3 December 2007 12:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Derby Embeded Database (CF8) and Eclipse/FlexBuilder Hey Andrew, are you speaking of Derby itself or the DTP support for it? I'll assume you mean the latter. I just wouldn't want readers just want to infer from your comments (very basic implementation) that Derby is some new kid on the blog. Folks may be interested to know that it's in fact a 10 year old DBMS (known formerly as Cloudscape, which was first independent, then was bought by Informix, then by IBM before they turned it over to Apache). IBM says that it accepts the same SQL and API calls as DB2, and DB2's been around longer than most enterprise SQL databases. But if you meant the DTP tools, that's cool. Haven't used them yet myself, and honestly I've only just started using Derby. I'm sure some will ask questions like, so what is Derby is good for?, and why would I use it over MySQL? I answer those in the getting started page I pointed to earlier. /charlie --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF8 - Getting more than 1.4 GB in the heap?
If we did and had, we couldn't talk about it. :-) Beta experiences are under NDA. Sorry. But the beta is fairly open (and you just have to agree to its stipulations like this). Check out more on that blog entry. If you were hoping to hear from folks without installing it, well, I suppose you don't HAVE to install it once you're on the beta. They certainly prefer that, and may even expect it (haven't read the agreement that closely), but I'm sure others have joined the beta just to be able to watch the forums and be involved in any such discussions. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Wiltshire Sent: Tuesday, November 27, 2007 3:38 PM To: cfaussie Subject: [cfaussie] Re: CF8 - Getting more than 1.4 GB in the heap? This is great news! - We've been looking forward to this, nice to see things are moving along... :) Has anyone in here tried the Beta yet? - If so, have you noticed any speed gains? Cheers, Chris Wiltshire. (Enigma) On Nov 26, 4:02 am, Charlie Arehart \(lists account\) [EMAIL PROTECTED] wrote: Sure, but just to be clear, since you've been referring to Windows in this thread, you won't be able to run CF on 64 bit Windows, if that may be what you're thinking. It's not supported, though it's coming in 8.1 (http://www.webbschofield.com/index.cfm/2007/11/19/Interested-in-CF-on... t-or-Leopard). /charlie --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF8 - Getting more than 1.4 GB in the heap?
Sure, but just to be clear, since you've been referring to Windows in this thread, you won't be able to run CF on 64 bit Windows, if that may be what you're thinking. It's not supported, though it's coming in 8.1 (http://www.webbschofield.com/index.cfm/2007/11/19/Interested-in-CF-on-64-bi t-or-Leopard). /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Sunday, November 25, 2007 9:08 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF8 - Getting more than 1.4 GB in the heap? We're running Java 1.6, as it's a CF8 install. I'm not a hardware guy, so I have no idea, but will a 64 bit architecture allow us to give more RAM to the Java Heap? Mark On Nov 26, 2007 1:06 PM, Kai Koenig [EMAIL PROTECTED] wrote: Hi Mark, you will find that the heap size is limited to various values, depending on the underlying JVM and on the operating system. On Windows with a JVM 1.4.x it used to be something around 1.2/1.3 GB, that increased to roughly 1.4 GB with JVM 1.5 . A while ago I heard someone mentioning that JRockit JVMS allow you to address more heap memory but then you might run into other issues in regards to running CF on them (not supported etc.) You will find memory limitations on Linux and Solaris as well - a nice way out would be to run a 64 bit OS/JVM or to look into Bruce's suggestion to set up a multi-server CF/Jrun installation. Cheers, Kai We're setting up our production boxes, and we would very much like to take advantage of the 4GB of ram sitting on them. Currently if we set the heap size in CFAdmin to larger htan 1.4 GB, CF refuses to start up. I'm wondering if there is a way to push this value up higher, as we tend to store a lot of things in memory. They are Windows 2003 Servers, but we're happy to look at other OS options if necessary. Cheers, Mark Kai Koenig Director Software Solutions Architect Adobe Certified Master Instructor Ventego Creative Ltd 154 Parkvale Road, Karori Wellington, New Zealand Office: +64 4 476 6781 Mobile: +64 21 928 365 e-mail: [EMAIL PROTECTED] web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Anyone seen this error before?
Yep, all good additional reasons. :-) I was just focusing on why it was needed for using the debugger in multiserver mode, but useful additional info for those debating it. As for the URLs I offered on setting up multiple jvm.configs, somehow they got mashed together. They are: http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver and http://www.alagad.com/go/blog-entry/cf7-cf8-jrun-and-the-jvm /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Pat Branley Sent: Sunday, October 21, 2007 10:54 PM To: cfaussie Subject: [cfaussie] Re: Anyone seen this error before? Anyone who has run int issues with AXIS and log4J jar conflicts is someone who'd want multiple JVM configs. Id recommend anyone using multiple instances (for distinct applications) to use a separate jvm.config pointing to a separate install of JRE. This allows you to independantly run different versions of JRE. For example, 1.6 for cf8 and 1.4 for cf7 instanes. It also lets you have an independant lib\ext folder in each JRE setup to resolve any JAR conflicts with CF built in classes. Pat On Oct 22, 12:17 pm, Charlie Arehart \(lists account\) [EMAIL PROTECTED] wrote: Andrew (and others), you don't want to say that this isn't a problem on Windows. It'll bite anyone using the multiserver (multiple instance) configuration. As MrBuzzy hinted, it is that the default setup of the multiserver config is to have all instance share on jvm.config, and that's where you tell CF what port to use for the new CF8 debugger. The problem is that if any of the instances are up when another instance tries to come up, the other instances won't come up because the port is already in use. It can be tricky knowing what's happening and why. A real common example of this is that the cfusion instance goes down but the admin instance stays up. In this case, you only have 1 CF instance, but it doesn't matter. So MrBuzzy indicates that you need to create a separate jvm.config for each instance, but adds who'd wannna do that[?] Well, anyone who wants to use the debugger in multiserver mode will need to. No way around it (well, at least if one instance may ever go down). A couple blog entries discuss setting that up (not specific to the problem of the debugger but just for those who wanted to do it in general, such as perhaps to have other different JVM settings): http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserverhttp://ww w.alagad.com/go/blog-entry/cf7-cf8-jrun-and-the-jvm HTH /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, October 18, 2007 7:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? Actually under windows it isn't a problem, but under Linux for some reason it is a problem. The thing is that it works fine if you first change the setting, and restart ./jrun -start cfusion but once the server is rebooted the admin and cfusion refuse to start at all because of this error. There is just not enough documentation to get this to work at the moment, hopefully Adobe can shed some light at some point. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd.www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of MrBuzzy Sent: Thursday, 18 October 2007 6:51 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? This one is a bit of a pain when using the default multi-server setup. There's only one jvm.config to edit, making the debug port the same for all CF instances. There are ways to have more than one jvm.config but bah, who'd wannna do that. On 10/18/07, Andrew Scott [EMAIL PROTECTED] wrote: Yeah it was the debugger, apparently something else had taken over that port. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd.www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Thursday, 18 October 2007 3:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? Its related to the debugger, google that second line and there are lots of references. Regards Dale Fraser http://learncf.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, 18 October 2007 2:55 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Anyone seen this error before? This is a multi server configuration, jrun is running fine, cfusion is not and the error in the logs are. FATAL ERROR in native method: JDWP No transports initialized, jvmtiError=AGENT_ERROR_TRANSPORT_INIT(197) ERROR: transport error 202: bind failed: Address already in use ERROR: JDWP Transport dt_socket failed to initialize
[cfaussie] Re: REMINDER: Melbourne CFUG - This Thursday!
Yes, I dropped a note of thanks to Mark earlier: I got his message to the CDDUG list announcing this, and then I got a note from my UGTV system telling me he'd posted the URL. I appreciated his quickly thinking to post the recording URL. Again, if anyone else creates any recordings or finds any recordings they think others would enjoy (related to CF), they can be added easily at the URL Barry offered below. No need to register, etc. If all you have is the title and URL, that's all that's needed at a minimum. (If you have the speaker and a description, etc., that's appreciated.) Thanks to all concerned. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Monday, October 22, 2007 3:22 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: REMINDER: Melbourne CFUG - This Thursday! pffft ;) did it ges ago ;) Mark On 10/22/07, Barry Beattie [EMAIL PROTECTED] wrote: don't forget to add this to Charlie Areharts's User Group TV site; http://www.carehart.org/ugtv --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Anyone seen this error before?
Andrew, in that multiinstance deployment, did you have more than one CF instance configured? And if not, did you start the Admin instance? If not, then you only had one instance running, using what would be a shared jvm.config. As soon as you try to run one of them when the other is running, you should get the no transports initialized error. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Monday, October 22, 2007 12:51 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? Charlie, I have a multiple instance of CF8 running on Windows 2003, and I have no problems with this and the debugger. But under ubuntu and linux have major problems with the debugger. Could it be that I somehow setup the separate configuration for JVM under windows 2003 without knowing it? Anyway, thanks all for the input. I would have thought that the debugger is something everyone is going to use that it would have setup multiple jvm configs from the start. Oh well Who knows why Adobe chose that path then. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Monday, 22 October 2007 12:18 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? Andrew (and others), you don't want to say that this isn't a problem on Windows. It'll bite anyone using the multiserver (multiple instance) configuration. As MrBuzzy hinted, it is that the default setup of the multiserver config is to have all instance share on jvm.config, and that's where you tell CF what port to use for the new CF8 debugger. The problem is that if any of the instances are up when another instance tries to come up, the other instances won't come up because the port is already in use. It can be tricky knowing what's happening and why. A real common example of this is that the cfusion instance goes down but the admin instance stays up. In this case, you only have 1 CF instance, but it doesn't matter. So MrBuzzy indicates that you need to create a separate jvm.config for each instance, but adds who'd wannna do that[?] Well, anyone who wants to use the debugger in multiserver mode will need to. No way around it (well, at least if one instance may ever go down). A couple blog entries discuss setting that up (not specific to the problem of the debugger but just for those who wanted to do it in general, such as perhaps to have other different JVM settings): http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver http://www.alagad.com/go/blog-entry/cf7-cf8-jrun-and-the-jvm HTH /charlie --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Anyone seen this error before?
Well, you refer to jrun in this and the last note, and that's confusing. Do you mean the Admin instance? In the multiinstance mode, Jrun is always running (and the CF instance runs within it). But my point was about in fact whether you had the Admin instance running. If not, that would be why you had no conflict. Sorry, won't see your reply for several hours. Bed time for me. :-) /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, October 23, 2007 12:42 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? Oh and I forgot to add that if jrun is not running, then there is no problem with the debugger conflict on linux. On 10/23/07, Andrew Scott [EMAIL PROTECTED] wrote: Charlie, That's the thing no it has only one instance of jrun4 and one instance of cfusion, this was a complete fresh install on linux. But the thing that I took extreme notes on was that it was a shared JVM instance between jrun and cfusion. Now the other thing to note here, is that on windows 2003 this is not a problem on one server, but here on linux the jrun and cfusion are the ones that seem to be conflicting. As to why this is the case only on linux is what has me stumped. On 10/23/07, Charlie Arehart (lists account) [EMAIL PROTECTED] wrote: Andrew, in that multiinstance deployment, did you have more than one CF instance configured? And if not, did you start the Admin instance? If not, then you only had one instance running, using what would be a shared jvm.config. As soon as you try to run one of them when the other is running, you should get the no transports initialized error. /charlie --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Coldfusion 8 - Developer
Going back to this note from last week, while the answer to how to reset the IP addresses is indeed to restart the server, David mused below, I would suspect they are help in memory, but that is only a guess. If anyone ever needed to know what the IP addresses were (which were the ones allowed to access the Dev edition until restart), I blogged how: Programmatically accessing allowed IP Addresses in Developer Edition (and understanding the limits) http://carehart.org/blog/client/index.cfm/2006/12/13/programmatically_access ing_allowed_ip_addresses_in_dev_edition FWIW, this relies on the undocumented ServiceFactory. There is no equivalent method (that I could find) in the Admin API. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David Harris Sent: Tuesday, October 16, 2007 11:18 PM To: cfaussie Subject: [cfaussie] Re: Coldfusion 8 - Developer The only way I am aware to reset them is a restart of the CF instance. The first 3 ips are used and then the licensing limits kick in. I would suspect they are help in memory, but that is only a guess Barry Beattie wrote: I think Andrew means the 3 or so IP addresses that can connect to the CF server (127.0.0.1 being one of them) perfect for getting the PM to see your app on your dev box. I'm looking too on CF8 - maybe it;s the Debugging IP addresses? On 10/17/07, Steve Onnis [EMAIL PROTECTED] wrote: Just restart the CF Server and it should be reset From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Wednesday, 17 October 2007 12:49 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Coldfusion 8 - Developer Anyone know where the list of ip's are stored for restriction? Need to remove / reset them J Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Anyone seen this error before?
Andrew (and others), you don't want to say that this isn't a problem on Windows. It'll bite anyone using the multiserver (multiple instance) configuration. As MrBuzzy hinted, it is that the default setup of the multiserver config is to have all instance share on jvm.config, and that's where you tell CF what port to use for the new CF8 debugger. The problem is that if any of the instances are up when another instance tries to come up, the other instances won't come up because the port is already in use. It can be tricky knowing what's happening and why. A real common example of this is that the cfusion instance goes down but the admin instance stays up. In this case, you only have 1 CF instance, but it doesn't matter. So MrBuzzy indicates that you need to create a separate jvm.config for each instance, but adds who'd wannna do that[?] Well, anyone who wants to use the debugger in multiserver mode will need to. No way around it (well, at least if one instance may ever go down). A couple blog entries discuss setting that up (not specific to the problem of the debugger but just for those who wanted to do it in general, such as perhaps to have other different JVM settings): http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver http://www.alagad.com/go/blog-entry/cf7-cf8-jrun-and-the-jvm HTH /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, October 18, 2007 7:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? Actually under windows it isn't a problem, but under Linux for some reason it is a problem. The thing is that it works fine if you first change the setting, and restart ./jrun -start cfusion but once the server is rebooted the admin and cfusion refuse to start at all because of this error. There is just not enough documentation to get this to work at the moment, hopefully Adobe can shed some light at some point. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of MrBuzzy Sent: Thursday, 18 October 2007 6:51 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? This one is a bit of a pain when using the default multi-server setup. There's only one jvm.config to edit, making the debug port the same for all CF instances. There are ways to have more than one jvm.config but bah, who'd wannna do that. On 10/18/07, Andrew Scott [EMAIL PROTECTED] wrote: Yeah it was the debugger, apparently something else had taken over that port. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Thursday, 18 October 2007 3:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Anyone seen this error before? Its related to the debugger, google that second line and there are lots of references. Regards Dale Fraser http://learncf.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, 18 October 2007 2:55 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Anyone seen this error before? This is a multi server configuration, jrun is running fine, cfusion is not and the error in the logs are. FATAL ERROR in native method: JDWP No transports initialized, jvmtiError=AGENT_ERROR_TRANSPORT_INIT(197) ERROR: transport error 202: bind failed: Address already in use ERROR: JDWP Transport dt_socket failed to initialize, TRANSPORT_INIT(510) JDWP exit error AGENT_ERROR_TRANSPORT_INIT(197): No transports initialized [../../../src/share/back/debugInit.c:690] Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Anyone using SQL Delta?
Hey Toby, last week you asked for a tool to compare schemas and generate DDL. Do you mean generic schemas (not yet defined as databases), or you do you mean that term to refer to the schema as defined in SQL Server? In addition to the tool Ryan mentioned, I'll point out a couple others. One is among a set of tools I blogged about a couple od weeks ago: Free Tool Friday: Several free enterprise-class tools from Adventnet / ManageEngine http://carehart.org/blog/client/index.cfm/2007/10/12/free_tool_friday_manage engine The SQL compare tool is called SwisSQL DBChangeManager 4: http://www.swissql.com/products/database-compare-synchronize-tool/index.html There is a link to the free edition (which explains its limits) at the top right of that page. Other such tools include RedGate SQL Compare: http://www.red-gate.com/products/SQL_Compare/index.htm. It's not free, though. If you need still more choices for your needs, I see a list of what seems to be many pages of such tools, at http://compare-sql.qarchive.org. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, October 17, 2007 11:49 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Anyone using SQL Delta? Toby, Can you name a product that creates and compares schemas and generates DDL? I use an old version of powerdesigner but I'd like to know what else is out there. Toby Tremayne [EMAIL PROTECTED] 18/10/2007 1:23 pm I've used it a couple of times - fantastic product for managing changes during dev cycles to a live database. Generally I like to base everything from a schema diagram in a db that can generate scripts - some of these products can handle making changes / additions directly in the db, but when you don't have one of those, sqldelta can be very handy. Toby On 18/10/2007, at 12:18 , Ryan Sabir wrote: Hi all, For those following the recent thread about SQL Server 2005 database transfering woes... We've just discovered this great tool: http://www.sqldelta.com/ You point it at 2 databases and it will tell you the difference between them, and then creates scripts that synchronise the schema and data between the 2. Just wondering if anyone has used it extensively and can vouch for its reliability? We tried it one a fairly large database and it seemed to run fine... has anyone had any good or bad experiences with it? thanks. Ryan Sabir Technical Director p: (02) 9274 8030 f: (02) 9274 8099 m: 0411 512 454 w: www.newgency.com Newgency Pty Ltd Web | Multimedia | eMarketing 115 Cooper St Surry Hills NSW 2010 Sydney, Australia --- Life is poetry, write it in your own words --- Toby Tremayne Senior Technical Consultant Code Poet and Zen Master of the Heavy Sleep Lyricist Software 0416 048 090 ICQ: 13107913 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFHTTP Connection Failure
Taco, were you using GetAsBinary? And wer eyou outputting it with CFCONTENT and the right mimetype? When I do the following,it works fine (hello, Yoda!): cfsetting showdebugoutput=No cfhttp url=http://i5.ebayimg.com/03/i/08/c6/cb/fc_1.JPG?set_id=7 http://i5.ebayimg.com/03/i/08/c6/cb/fc_1.JPG?set_id=7uniqueString=92B0FF05 -8C01-2C47-FF0F14FBB5A4A211 uniqueString=92B0FF05-8C01-2C47-FF0F14FBB5A4A211 getasbinary=yes cfcontent variable=#cfhttp.filecontent# type=image/jpeg Hope that helps. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Friday, October 12, 2007 1:34 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CFHTTP Connection Failure Hello all, I'm trying to download and save an image to disk with cfhttp, but its returning Connection Failure, however, not all the time, and when I access the url via the browser the image is there. When I look at the response with LIVEHEADERS (in firefox) I aslo don't see the same result as I get when using cfhttp. Anyone any ideas? Header: HTTP/1.1 200 OK Connection: close Expires: Mon, 26 Nov 2007 05:30:20 GMT Accept-Ranges: bytes Date: Fri, 12 Oct 2007 05:30:20 GMT Server: Apache/1.3.27 (Unix) Content-Length: 29556 Cache-Control: max-age=3888000 ETag: 236371-7374-4557d99d Last-Modified: Mon, 13 Nov 2006 02:34:05 GMT Via: 1.1 qsxcache58 (NetCache NetApp/5.5R6) Content-Type: image/jpeg The url being: http://i5.ebayimg.com/03/i/08/c6/cb/fc_1.JPG?set_id=7 http://i5.ebayimg.com/03/i/08/c6/cb/fc_1.JPG?set_id=7uniqueString=92B0FF05 -8C01-2C47-FF0F14FBB5A4A211 uniqueString=92B0FF05-8C01-2C47-FF0F14FBB5A4A211 I've added the uniquestring so it would not cache in the proxy or anything. Thanks. -- *** http://www.clickfind.com.au The new Australian search engine for businesses, products and services *** Virtual and Dedicated Servers with MS SQL from $250 a month *** Virtual and Dedicated Servers with registered version of ColdFusion from $350 a month *** ColdFusion licenses at the lowest price --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Connection Pooling
On this matter of connection pooling, and the assertion by your host, Chris, that you're using too many of them, I've got a couple of thoughts. Unfortunately, it will take a rather lengthy note to reply. Since some don't like long notes and won't even start to read them, I wanted to offer this note of advanced warning. :-) If you're at all interested in the topic, though, I hope you'll read along, since I make some points it doesn't seem anyone else has yet. Hope it's useful. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of silverbeetle Sent: Sunday, September 23, 2007 7:46 PM To: cfaussie Subject: [cfaussie] Re: Connection Pooling Hey Barry Well - could well be a scapegoat. i think my code is pretty clean and efficient. I dont have any long running queries apart from a few admin related ones. Some of the nav is generated from queries but this is all cached to avoid database getting hammered with each users request. So i guess i was looking here to check that isn't some cf code related connection pooling technique that i'm not aware of and that they indeed are just passing the buck. Wouldnt be the first time... Cheers Chris On Sep 21, 2:56 pm, Barry Beattie [EMAIL PROTECTED] wrote: Chris, are you sure they're not just picking on you and treating you as a scapegoat for some other problem? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Connection Pooling
OK, here's the longer note with some thoughts. Executive summary It may be that you're dealing with a host who simply doesn't understand CF very well, so their recommendation to look at your code regarding connections may be dodgy. But there are indeed settings in the CF Admin that could be affecting this, which haven't been discussed in this thread yet. Also, if you use USERNAME/PASSWORD attributes in CFQUERY, that could affect pool reuse (and from that standpoint, then, they could be right in their recommendation). First, as for their recommendation to revise your code and ensure that you are utilising connection pooling, it could be that your host is more familiar with .NET, Java, or other languages where one does indeed control pooling manually (in code). As has been said, though, in CFML we do not typically and instead rely on the engine to do it, as per our Admin console settings for the DSN. (Only rarely might one bother to manipulate the pooling process in CFML code.) But there are indeed settings in the CF Admin that can affect this. No one has mentioned, but what are your settings related to connections for the DSNs in question? First and foremost, what about maintain connections? Do you have that enabled? If not, then you would indeed use more connections than needed. I do realize some argue against enabling it--but that will cause higher connection use and prevent pool reuse. Perhaps you have enabled that setting: how might one generate a lot of connections even so? Well, do you use the username and password attributes on CFQUERY? If so, that would prevent reuse of a connection by someone using a different username/password. If you had no choice in that matter, there is another setting to limit how many connections you do create. In fact, even if you don't use per-user authentication of CFQUERY, that setting could help you. It's the DSN connection setting for limit connections which, along with its restrict connections to value. That would seem just the solution here to restrict how many you create. Still, I saw Sean's later note that this is a rather high-volume site, so you will want to be careful in evaluating (and understanding) the impact of any such changes. You seem to be asking for ideas, though, which is why I write. Steven Erat of Adobe did a nice blog entry on this, including some case examples and recommendations, back in 2005 at: http://www.talkingtree.com/blog/index.cfm/2005/3/14/ConnPooling1 Note also that there are two other DSN settings related to connections: timeout and interval options (as opposed to login timeout). Perhaps those need to be tweaked. Finally, take note if you may have any values in the connection string which might have an impact on connection pooling? There are some. You had mentioned in an earlier note that you might hit up the host for more info and check they have their CF Admin settings correct. Let's hear what you have. If it's just that your site is a higher volume CF site than your host is used to, and none of the above help, then perhaps there's nothing to be done other than to negotiate with them to let you use more connections, or change plans, or change hosts. Hope that's helpful to you and others. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of silverbeetle Sent: Sunday, September 23, 2007 7:46 PM To: cfaussie Subject: [cfaussie] Re: Connection Pooling Hey Barry Well - could well be a scapegoat. i think my code is pretty clean and efficient. I dont have any long running queries apart from a few admin related ones. Some of the nav is generated from queries but this is all cached to avoid database getting hammered with each users request. So i guess i was looking here to check that isn't some cf code related connection pooling technique that i'm not aware of and that they indeed are just passing the buck. Wouldnt be the first time... Cheers Chris On Sep 21, 2:56 pm, Barry Beattie [EMAIL PROTECTED] wrote: Chris, are you sure they're not just picking on you and treating you as a scapegoat for some other problem? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Connection Pooling
You're singing my tune, Barry (about the bene's of monitoring and debugging). :-) And no worries for your late-night lapse. I just wanted to make sure both parties were well-represented. :-) As for the red/green lights of SeeFusion, I'll note that FusionReactor's Enterprise Dashboard has that and more: Not saying all this at all to knock SeeFusion, or indeed the new CF8 Monitor and its multiserver monitor which also offers a dashboard. Just offering it for completeness. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Saturday, September 22, 2007 12:26 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Connection Pooling I'm always surprised to see someone mention only SeeFusion. It's a great product, but there is also FusionReactor. I'd be surprised one could hear of one but not the other. :-) Anything more to just mentioning the one, Barry? mea maximus culpa, Charlie. FusionReactor is indeed worth mentioning and I should have known better. The other server monitor only came to my tired (up too late) mind simply because my last job used it for their CF6.1 servers and the red and green report screen just flashed into my mind. That's what I get staying up late to watch JTV In any case, I don't think either tool will provide info on connection pooling. CF8's monitor does, however, though only on Enterprise/Developer. not pooling per-se, but anything that might indicate something was wrong, possibly leading on to investigate any long running queries, or deadlocks (unlikely but you never know), etc. It's a pain to have a problem but no tools to track it down. Just like the benefits that can be gained using a step-debugger ... like FusionDebug. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~--- inline: Outlook.jpg
[cfaussie] Re: Connection Pooling
I'm always surprised to see someone mention only SeeFusion. It's a great product, but there is also FusionReactor. I'd be surprised one could hear of one but not the other. :-) Anything more to just mentioning the one, Barry? In any case, I don't think either tool will provide info on connection pooling. CF8's monitor does, however, though only on Enterprise/Developer. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Friday, September 21, 2007 8:36 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Connection Pooling in that case my curiosity has been piqued... only closed connections can be returned to the pool, yes? what would be keeping a bunch of connections open? excessively long queries? a cftransaction gone silly? a trapped error running a query, taking too long to get resolved? pity it's not cf8 with monitoring tool. got SeeFusion handy? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: starting now - breezo What's new in CF8
Tha Adobe program is Adobe Community Experts, but since Barry is already a recognized Adobe User Group Manager, there's not much additional benefit to being an ACE as well. But yes, Barry (and others here) are indeed great assets to the community. As for the URL below, that was for a room that's now closed. Was there a recording, Barry? /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Barnes Sent: Friday, September 21, 2007 8:19 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: starting now - breezo What's new in CF8 I'm not sure what MVP style program Adobe have, but to Adobe folks on the list, I hereby nominate Barry for a community award or something of that kind. I can think of 5 others to boot... Way to go bazza! :) you Evangelist you.. On 9/21/07, Barry Beattie [EMAIL PROTECTED] wrote: pacific.adobe.acrobat.com/developer http://www.mossyblog.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: MSSQL 2005 Developer Edition
Yes, the developer edition comes with SQL Server Management Studio, the replacement/upgrade from EM. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Friday, September 21, 2007 5:25 AM To: cfaussie@googlegroups.com Subject: [cfaussie] MSSQL 2005 Developer Edition Has anyone got this and can they tell me if it comes with the SQL management tool? Like the new enterprise manager http://www.inevative.com.au/images/email-stationary/inevativeLogo_small.jpg Steve Onnis Director / Head Developer http://www.inevative.com.au/images/email-stationary/email.jpg [EMAIL PROTECTED] http://www.inevative.com.au/images/email-stationary/phone.jpg Australia : 1300 856 623 International : +61 3 9882 5875 http://www.inevative.com.au/images/email-stationary/mobile.jpg 0401 667 996 http://www.inevative.com.au/images/email-stationary/web.jpg www.inevative.com.au http://www.novahost.com.au http://www.threesquares.com.au http://www.smsonline.com.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~--- inline: inevativeLogo_small.jpginline: email.jpginline: phone.jpginline: mobile.jpginline: web.jpginline: novahost.gifinline: threesquares.gifinline: smsonline.gif
[cfaussie] Re: List/Menu Question.
Yep, good point. I was just responding to Travis' immediate need. Now that you mention it, Ben, another suggestion for Travis to consider would be to not show the actual description and cost in the value of the select control but instead just pass the primary key of the product being shown, and then do a lookup on the form action page. That would address the concern Ben raises. Yes, it does mean another DB I/O (though caching may help with that), but it's indeed an important point to keep in mind that on a form someone could mess with the data. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bsmith Sent: Thursday, August 30, 2007 1:32 AM To: cfaussie Subject: [cfaussie] Re: List/Menu Question. relying on cost values from form fields is a bad idea i think... if you have to do it make sure you at least have some referer checking included in the processing code. B. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: List/Menu Question.
Um, Steve, I did do a listlast to get the cost. That was my first example. I see below it got all mashed onto one line for some reason, so perhaps you missed that. No worries. I did go on to explain, though, that if one used any other list function, it could be compromised by their being that separator string ( - ) in that first description field. The listlast worked, indeed because it seems reasonable to presume that cost would never have the - in it. As I said, if it ever could, then no, this would no longer work. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, August 29, 2007 2:18 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: List/Menu Question. Even that though, if the value was cfset form.shippingservice = Item1 - blue - 15.45 and the description was Item1 - blue then the description would only get the Item1 part. If you know the last item in the list is always going to be the cost you could use the ListLast() to get the cost value and then do something like.. desc = listSetAt(list, listLen(list), , -) to strip out the cost part of the string and leave the rest. This is ofcourse if you know that things are going ot be in specific positions. In that instance when you have values that could hold the delimiter your using, put them last like COST - DESCRIPTION, that way you can be certain that ListFirst() gets the cost and ListRest() gets you everything else. Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Thursday, 30 August 2007 2:17 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: List/Menu Question. Travis, do you mean that when the form is submitted, you want to take the form field (shippingservice, which has 2 values in it) and split that into 2 separate variables? You can do that using list functions that split the string at the - . Consider this: cfset form.shippingservice = Item1 - 15.45 cfset desc = listfirst(form.shippingservice, - ) cfset cost = listlast(form.shippingservice, - ) cfoutput desc=#desc# br cost=#cost# /cfoutput Now, someone may ask why I didn't just use listgetat, as in: cfset desc = listgetat(form.shippingservice,1, - ) cfset cost = listgetat(form.shippingservice,2, - ) The problem comes as soon as the description itself had a - in it, which seems reasonable. Consider this: cfset form.shippingservice = Item1 - blue - 15.45 That listgetat code would produce the wrong result, splitting on the first dash, and returning cost=blue. Since the cost is not likely to ever have a - in it, the listfirst and listlast seem the better choice. There are, of course, still other ways to skin the cat, and some will want to talk about the performance of list functions, and why the heck are you doing such basic coding, why aren't you using CFCs and objects. I won't go there. Sometimes people are still walking in CFML. Let the runners pass. Not everyone's in a race. That said, I will note that I always lament seeing query-driven selects being built by hand that way. That's what CFSELECT does in one tag. I know, some don't like that it forces you to use CFFORM. That's my lament. There's no reason it should have to. Unlike other CFFORM tags, this use of CFSELECT has nothing to do with Javascript or Flash. I'll leave that for Travis and others to consider on their own. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of TJS Sent: Wednesday, August 29, 2007 10:19 AM To: cfaussie Subject: [cfaussie] List/Menu Question. Hi Everyone, I was wondering whether anyone knew of a simple solution to the following:- select name=shippingService id=select cfloop query=Freight option value=#Freight.Description# - #Freight.Cost##Freight.Description# - #Freight.Cost#/option /cfloop /select As you can see in the code above, a CFLOOP is being used to populate the options of a List/Menu inside a form. What I would like to do is put the #Freight.Description# and #Freight.Cost# into two seperate session variables. i.e:- CFSET freightDescription = CFSET freightCost = At the moment, my single session variable includes both description and cost. Many thanks in advance to any suggestions. Cheers, Travis. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Help
OK, so have you considered looking into its text indexing features, based on this discussion? :-) /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Wednesday, August 29, 2007 7:26 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Query Help SQL Server 2005 Regards Dale Fraser http://dalefraser.blogspot.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Thursday, 30 August 2007 8:12 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Query Help Dale, it just seems you're asking SQL (and the DBMS, and indeed traditional relational design) to solve a problem it's not meant for. What you need is text indexing and related functionality. You mentioned using SQL Server in your first note of the thread. What version? Text indexing is much improved in both 2000 and 2005. You may find that it has just the solutions you need. Similarly, even CF's Verity might offer functionality to help. I'm pretty sure it's got more power than most people realize, even in the free version bundled with CF. Of course, to do it, you'd need to index your query results. For some situations, that's not optimal, but it may be better than the SQL hacks you're attempting. :-) Trying to help. /charlie --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....
Taco, if the ideas suggested so far (and later) don't resolve this, I'd like to make a proposal: you say you can't replicate this. One almost never can. The problems involved are often too unique for you to replicate. (I can say, as others have, that this is not as unique as you may think--but by the same token, it's almost never CF playing up. Shame that it's always blamed.) But as for being able to better observe/diagnose this, note that you could do something like CFLOG in the suspected code to write out things (to a file) like the user's CFID and CFTOKEN, or any other data (perhaps CGI variables) that might help to determine what's different, as they go from one page to the next. It would seem the only way they'd get a different session would be if the session token changes between the page requests. CFLOG will tell you. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Wednesday, August 29, 2007 8:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? It's nothing like that. We don't append cftoken to the url. The user signs in, sees the correct information, then goes to another page and sees the information from another user they don't know (so they say). I have not been able to replicate this myself. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Any way to get a list of all cftags?
Easier than CFInclude? Or easier than the OO solution? I'll assume you mean the latter, and will bow out of that debate, as I have nothing more to add. And to Steve, who wondered how I could assert OO could ever be overkill, since I don't know your stance, I don't know if you're being cheeky--and even then if in favor of OO or against it. I started to offer a little more to explain what I meant, but decided to let it go. Again, I don't mean to open that can of worms. That was not my intent. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, August 28, 2007 1:11 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Any way to get a list of all cftags? Charlie, Again I would agree with you, but with the differences in all CFML Engines would there actually be an easier solution? It would be nice to know because others are going to fall into this category at some point as well. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Tuesday, 28 August 2007 2:40 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Any way to get a list of all cftags? Fair enough. I wasn't keeping in mind that this was about Transfer, so naturally that would be appealing to Mark. Still, the simpler approach would certainly be important to those solving a problem where a full OO solution would be overkill. :-) /charlie --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Any way to get a list of all cftags?
Well, maybe, but really, I took no offense (and meant none). I really do just mean that I have no more to offer in the thread. All said with a smile on my face. :-) /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, August 28, 2007 7:38 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Any way to get a list of all cftags? Charlie, No easier than Marks original problem, if it was a case of being able to catch the runtime exception then that would be great, problem solved. As for cfincludes, they are great as for OO in CF can make refactoring code extremely easy if you approach it right. As for bowing out, no Charlie you took my email wrong. Andrew Scott --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Any way to get a list of all cftags?
I'll throw out that for the same reason, it wouldn't have worked if one tried to say if running cf8, do cfdbinfo, else do whatever. That, too, would fail on other than CF8 because the appearance of the CFDBINFO in the page would trigger the compile error. I'll share a trick I figured out when needing to do things like this in my former life with New Atlanta: you could do if running cf8, cfinclude file to do cfdbinfo, else do whatever. I know some will doubt me, because they think that CFINCLUDE in a compile-time directive that pulls code in, but it's not. It's a run-time directive. If the IF test is not true, then the CFINCLUDE is not executed. It also doesn't pull code in even at runtime, but I won't open that can of worms. :-) Anyway, this doesn't solve Mark's problem, I know, but it might serve as a catalyst for someone to think of another solution. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of MrBuzzy Sent: Monday, August 27, 2007 4:32 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Any way to get a list of all cftags? I don't think that would work... you'd hit a just in time compile error (on CF7). The cfcatch wouldn't ever get to run. On 8/27/07, Andrew Scott [EMAIL PROTECTED] wrote: Dale, I was going to suggest that, and it might be the only way to succesfully do the trick. On 8/27/07, Dale Fraser [EMAIL PROTECTED] wrote: Could you at application start or some other point do (for the tags you want to use) cfset isDbInfo = true / cftry cfdbinfo ... cfcatch type=any cfset isDbInfo = false / /cfcatch /cftry There are probably only a small number of tags that you want to use that won't be in all versions. Then you could say cfif isDbInfo And you don't need to code against specific products (assuming they all catch). Regards Dale Fraser --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Flex Data Services Express
Oh yeah, that's what's included (if you don't enter a serial number for LCDS during the install, you get the Express edition). I'm pretty sure, at least. No time this morning to investigate. Hopefully someone else will confirm. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Saturday, August 18, 2007 10:05 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Flex Data Services Express Is this the same as what's included with CF8, or is it something different? Regards Dale Fraser http://dalefraser.blogspot.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Sunday, 19 August 2007 1:58 AM To: cfaussie@googlegroups.com Subject: [cfaussie] RE: Flex Data Services Express Dale, I'd be curious where you looked. :-) If you do a google search for livecycle data services (or even using live cycle), the first result is the Adobe page for LCDS: http://www.adobe.com/products/livecycle/dataservices/ The getting started tab there has among its contents a link to a FAQ with a section about the Express edition (http://www.adobe.com/products/flex/productinfo/faq/#livecycle_dsexpress) which seems to answer the questions you ask: Does the per-CPU pricing for LiveCycle Data Services ES pertain to per CPU as in server or per CPU as in processor? Per CPU as in processor. CPU is defined as a central processing unit in a hardware device, including devices accessed by multiple users through a network (a server). A dual-core CPU is considered a single CPU for licensing purposes. It goes on to explain that there are no other limitations (including connection, data throughput, users, etc). It's really just a licensing limitation--and then only for production. No CPU limits at all in development. Now, I don't mean the above to sound snide (in that you said you'd looked on the Adobe site). I'm really curious: I'm betting you got to that page, since it's so apparent in Google. I wonder if the challenge may have been that getting started tab, and I wonder if it's a challenge we should all consider in using them in our own code. More on that in the next email. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Saturday, August 18, 2007 8:38 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Flex Data Services Express I'm confused. I think they changed the name of this to Live Cycle Data Services, right? I know that it comes with CF8, is that Express edition if you don't enter the key. I can't find info on it on Adobe site, what the limitations are etc. Feature Matrix. I think it's limited to a single processor, what happens if the processor is Quad core, does it work, does it use a single core. Anyone know anything, or the link to the correct Adobe website where I can find out more about the express edition? Regards Dale Fraser http://dalefraser.blogspot.com BR --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] tabbed interfaces (was RE: Flex Data Services Express)
Following up my last note, about a possible challenge Dale may have had in seeing info in the tabbed interface of the LiveCycle page (http://www.adobe.com/products/livecycle/dataservices/). I'm just guessing if that was the issue. Maybe it was not, but I've wondered if some people may not always think to click such tabs. CF 8 makes them so easy, but I wonder if they may take some getting used to among folks just not used to seeing them (within the content of a page, I mean). Just curious. Anyone have thoughts? I'll note, in case anyone wonders, For instance, also, if you search (on google, for instance) for text that appears within such tabs, Google does find it. If you do a view source of the page, you see that all the content (even in the tabs) is there on one page, so if you then do a find (in the view source view) it does find text even within tabs. But if one uses the browser find feature while looking on a page not viewing the tab content, it will of course not be found. Since the search engine brought you to the page saying the content is there, I just wonder if this will cause some confusion for some. Something to think about. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Saturday, August 18, 2007 8:38 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Flex Data Services Express I'm confused. I think they changed the name of this to Live Cycle Data Services, right? I know that it comes with CF8, is that Express edition if you don't enter the key. I can't find info on it on Adobe site, what the limitations are etc. Feature Matrix. I think it's limited to a single processor, what happens if the processor is Quad core, does it work, does it use a single core. Anyone know anything, or the link to the correct Adobe website where I can find out more about the express edition? Regards Dale Fraser http://dalefraser.blogspot.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Installing Lifecycle Dataservices
Don't know if you've seen these already, Steve, but a google search turns up others discussing this: http://www.onflexwithcf.org/index.cfm/2007/7/17/ColdFusion-with-LCDS-Express -in-a-machine-with-multiple-CPUs And just to be clear, as he says, this is about multiple physical CPUs, not dual/quad-core CPUs. More here: http://www.adobe.com/products/flex/productinfo/faq/#item-31 http://www.adobe.com/products/flex/productinfo/faq/#item-22 Hope that helps. I know nothing more myself. /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, August 02, 2007 4:17 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Installing Lifecycle Dataservices I am installing CF8 and it says is if i do not have a serial number for LCDS after the 120 day it changes to the Express Edition which can only be used on a single machine with not more than one CPU. I am installing it on a duel CPU machine so is it possible to have LCDS only use one of the CPUs? http://www.inevative.com.au/images/email-stationary/inevativeLogo_small.jpg Steve Onnis Director / Head Developer http://www.inevative.com.au/images/email-stationary/email.jpg [EMAIL PROTECTED] http://www.inevative.com.au/images/email-stationary/phone.jpg +61 3 9001 2258 http://www.inevative.com.au/images/email-stationary/mobile.jpg 0401 667 996 http://www.inevative.com.au/images/email-stationary/web.jpg www.inevative.com.au http://www.novahost.com.au http://www.threesquares.com.au http://www.smsonline.com.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~--- inline: inevativeLogo_small.jpginline: email.jpginline: phone.jpginline: mobile.jpginline: web.jpginline: novahost.gifinline: threesquares.gifinline: smsonline.gif
[cfaussie] Re: Coldfusion Books
Well, hey, as long as we're still recognizing the possible value of older CF books, I'll note that there was also the CFMX Bible (which I did with Adam and David Churvis, and Hal Helms). Now, I'm sure it may seem self-serving for me to mention these (and Ray to mention his), but Steve made a very good point about how some subjects were covered more at that time as new in 6 or 6.1, where later books may have scaled back such coverage to make room to focus on newer features of 7. Another good measure of an older book's value is the Amazon ratings (high for the CFMX Bible and others) and whether you can still find it on bookshelves. I see the CFMX Bible often--though I know this thread was about poor coverage of CF books down under. :-) Anyway, before someone says: yeah, well if the books were so good why weren't they updated for 7, or 8? That was just economics of the publishing industry in those few of years after the bust. Lots of books were shelved and not updated as tech took a hit in general. Fortunately, there will be the CF8 updates to the WACK books, and I'm fortunate to be contributing (as Ray's been for years). There will be 3 books, split between beginner, intermediate, and advanced. Look for them to be out in coming months (can't be any more specific than that: keep an eye on Ben's blog for any more info). /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Raymond Camden Sent: Sunday, July 22, 2007 10:16 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Coldfusion Books Speaking for myself, I thought the Mastering CF books were very well done. I know we worked hard on them and I thought they came out well. I may be a bit defensive since I was one of the contributing authors, but I'll won't stand by and let you call them worthless. I also know that Rob's ORA CF book is _still_ very highly regarded as well. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Are You A Queenslander?
Hey Barry, I want to share a tip with you (and anyone else who runs a google group or would want to join one): People can join just by sending an email to: [EMAIL PROTECTED] (where GGname is the Google Group name) So for yours, they'd send to [EMAIL PROTECTED] The user will receive an email from google asking them to confirm their interest in joining. Once they confirm, they're in, and the next email to the list will come to them (and they can reply to it). If the group requires the manager's permission to join, this won't work and they'll be told they have to request permission to join via the group's home page. Of course, they should send that email from whatever email account whose address they want to join from. And as you said, they don't need a google account for it (nor a gmail address), though if they do subscribe through the group's web interface (and create a google account, whether for a gmail address or any other), that will give them access to the google group's web interface, which will allow them to search the archives and provide access to any calendar or files area. Most groups don't seem to bother with those, so for many, this quick subscription by email can be a help. And it should save you needing to be the middle man to subscribe them, Barry. :-) PS And yes, I just tested it and did indeed join the group. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Friday, July 20, 2007 4:14 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Are You A Queenslander? the Queensland ColdFusionUserGroup is inviting ALL Queenslander CF people to become members of the QLDCFUG. To enjoy the goodness of a Coldfusion Adobe user group. So ...if you're _not_ currently a member AND snip Don't have a google mail account? - You don't need one to join. Just send me an email with email address and whatever name you want notifications to be addressed to. We'll make sure you won't miss out. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF8 beta on Intel OSX
I'm sure Sean Corfield does, and he's pretty open to questions: seancorfield at gmail dot com /charlie _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of MrBuzzy Sent: Tuesday, July 10, 2007 7:38 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF8 beta on Intel OSX bump seriously, no one runs cf8 on mac? On 7/7/07, MrBuzzy [EMAIL PROTECTED] wrote: Good mornin' Does anyone out there have the CF8 beta (multi-server/j2ee) running on Intel OSX? It's meant to work, right? ... No joy for me :( Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Struct notation - whats wrong with this?
Thanks very much, Rod. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Monday, July 09, 2007 11:54 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Struct notation - whats wrong with this? Hi Charlie, I must say your Hidden Gems in CF8 is a great way to wet ones appetite on CF8. I would also like to thank you on your work with the UGTV site - it really is a wonderful resource and I would recommend all having a look. Sorry all for the cross post, I'm having issues creating new posts - I must be banned .. :) Rgds Rod --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF Server stress testing tools and methodologies
Chris, I'm sure you'll want ideas from many (including their thoughts on the tools), but I'll point out that an old site I have (that I still update occasionally), I have a page of tools related to CF, including a list of load testing tools. http://www.systemanage.com/cff/considering_products.cfm A popular one in some CF circles is Selenium (http://www.openqa.org/selenium/), which is open source. John Paul Ashenfelter, in particular, promotes it often at CF conferences. Sadly, his site (where I'm sure he offers more thoughts on using the tool) is temporarily inaccessible. I've let him know. It doesn't take more than a few concurrent requests to test many aspects easily missed by no testing at all. For such moderate testing, I have long preferred myself to use a commercial tool, Paessler Web Server Stress tool, which offers a free dev edition for up to 10 concurrent users. It's on the list as well. Hope that's helpful. /charlie Member, Adobe Community Experts program www.carehart.org My latest blog entry: Still more CFEclipse Resources http://carehart.org/blog/client/index.cfm/2007/7/8/still_more_cfeclipse_res ources --Blogsigs.com, Link your own blog posts. http://www.blogsigs.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Ellem Sent: Tuesday, July 10, 2007 2:03 AM To: cfaussie Subject: [cfaussie] CF Server stress testing tools and methodologies Can anyone share their insight into... I am just looking at different approaches people use for stress testing thier apps. I have an ColdFusion Enterprise MX 7.0.2 server(multi server config) deployed on WIN 2000 with a Oracle backend. I want to stress test the application. What tools and methodologies are people currently using? Regards Chris --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFHTTP Resolving Host Names
Here are three articles that address the subject of CF caching the hostname for tags like CFHTTP: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=13115e61 http://www.talkingtree.com/blog/index.cfm/2006/5/23/Configuring-the-Caching- of-Hostname-Resolution-for-ColdFusion-MX http://tjordahl.blogspot.com/2004/10/cfmx-and-dns-caching.html I pulled these from a talk I've done in the past (at WebDU, in fact) on caching issues in CF, where beyond the traditional features like query and page caching I also discussed such obscure details as this. /charlie Member, Adobe Community Experts program www.carehart.org http://www.carehart.org/ My latest blog entry: http://carehart.org/blog/client/index.cfm/2007/7/8/still_more_cfeclipse_res ources Still more CFEclipse Resources --Blogsigs.com, Link your own blog posts. http://www.blogsigs.com/ http://www.blogsigs.com _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of AJ Mercer Sent: Sunday, July 08, 2007 8:48 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFHTTP Resolving Host Names I have always had to restart ColdFusion to pick up changes to the host file On 7/8/07, MrBuzzy [EMAIL PROTECTED] wrote: Hmmm... HOSTS should work, it has for me. On windows you might need to ipconfig /flushdns CF also caches the names, or at least it used to (?). It might need a kick over. On 7/8/07, Steve Onnis mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Can anyone shed some light on what CFHTTP uses to resolve host names? I have added some entries into my windows HOSTS file but CFHTTP does not seem to use them. I am trying to run some testing locally so i am using the HOSTS file to change where the DNS is pointing so i dont have to update it live. http://www.inevative.com.au/images/email-stationary/inevativeLogo_small.jpg Steve Onnis Director / Head Developer http://www.inevative.com.au/images/email-stationary/email.jpg [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.inevative.com.au/images/email-stationary/phone.jpg +61 3 9001 2258 http://www.inevative.com.au/images/email-stationary/mobile.jpg 0401 667 996 http://www.inevative.com.au/images/email-stationary/web.jpg www.inevative.com.au http://www.novahost.com.au http://www.threesquares.com.au http://www.smsonline.com.au -- If you are not living on the edge, You are taking up too much space. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~--- inline: inevativeLogo_small.jpginline: email.jpginline: phone.jpginline: mobile.jpginline: web.jpginline: novahost.gifinline: threesquares.gifinline: smsonline.gif
[cfaussie] Re: QLD CFUG this Wednesday!
Sounds interesting, Barry. Do you any any chance plan to offer that online to those of us living outside the area? Or recording it, even if the speaker is local to you? I did an article on this topic back in the CF5/6 timeframe and had been considering a reprisal, so would enjoy seeing the discussion. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Monday, July 09, 2007 12:52 AM To: cfaussie@googlegroups.com Subject: [cfaussie] QLD CFUG this Wednesday! This month we'll be looking at what it takes (how easy/limitations) to get multiple versions of ColdFusion working on the same box. Especially useful if you're developing (or testing) for current apps in CF7 while getting used to CF8, with both installs on your dev box, working at the same time. Also good for seeing if your CF7 code works fine for CF8 - on the same box. plus lots of news, tips, etc. so, if you're not already a member, sign up to the QLD CFUG usergroup http://groups.google.com/group/qldcfug/ and that will give us your RSVP so you can go into the prize draw (and ensure we do a good job on catering) - we hope to see you there cheers The QLD CFUG crew. PS: if you're interested but not in Brisbane, please contact us. Meeting Details: 6:30 pm - ?, Wednesday, 11th July 2007 If doors are locked, call 0414 328 902 for entry QANTM Auditorium QANTM House Level 9, 138 Albert St Brisbane City (Opposite the Coffee Club) Find it on WHEREIS: http://www.whereis.com/whereis/retrieveEmailMap.do?linkId=-;7243212240990709 884 Find it on Google Maps: http://maps.google.com/maps?f=qhl=enq=138+Albert+St,+City+QLD+4000,+Austra liaie=UTF8sll=37.0625,-95.677068sspn=28.168051,68.90625z=17om=1iwloc=a ddr --- Upcoming Meetings for your Calendar: 18th July: Brisbane Flash Platform Group - What's new for Flex3 - onAIR tour 1st August: QMUG - details to be confirmed 8th August: CFUG - Robi Senn on Testing and ColdFusion Development (his CFUnited presso done just for us, live via Adobe Connect) 15th June: Brisbane Flash Platform Group - onAIR tour wrap-up 22nd - 23rd of August 2007 Web on the Piste Queenstown, New Zealand. - The Ultimate Conference for Rich Internet Technologies! http://www.webonthepiste.com/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Struct notation - whats wrong with this?
Mike, to your point about using square bracket notation not being in the docs, are you looking only at the Reference manual? Not everything is documented there, or it can be hard to find, with its primary focus on tags and functions. But I'd be surprised if it wasn't at least covered in the Developer's Guide (the 1100+ page guide that is often missed). It's nearly 11pm here in the US, so I'll leave it to others to find where it is documented, if interested. But I really doubt it's not documented at all. /charlie Member, Adobe Community Experts program www.carehart.org My latest blog entry: Still more CFEclipse Resources --Blogsigs.com, Link your own blog posts. http://www.blogsigs.com http://carehart.org/blog/client/index.cfm/2007/7/8/still_more_cfeclipse_res ources -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Monday, July 09, 2007 10:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Struct notation - whats wrong with this? Yes! thanks Paul, that did work indeed. Barry you shouldn't be at work without your CF head on. So the lesson to learn is: 1.You CAN have a struct element name that is only a numeral. 2.The square-bracket notation requires a dot after it if what follows is to be another element name 3. there is nothing in the docs about using square bracket notation in naming struct elements. 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 Change this to: segment[#counter#].thispage = counter; segment[#counter#].nextpage = (counter + 1); segment[#counter#].content = #contentelement#; and it should work. Paul Haddon Technical Services Manager Formstar Print Technologies --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Coldfusion Server Using JRUN
Steve, since it's not new to 7 (was introduced in 6.1), I'll point you to a couple of articles from that time frame: Introducing Multiple Server Instances in ColdFusion MX 6.1, Tim Buntel http://www.adobe.com/devnet/coldfusion/articles/multiple_61.html Using Multiple Instances with ColdFusion MX Enterprise 6.1 video http://www.adobe.com/products/coldfusionmx61/productinfo/features/multiple_i nstances/ Now, CF7 did introduce the new Instance Manager within the Admin, and that (and instances in general) is covered in the CF manual, Configuring and Administering ColdFusion MX (Chapter 7, Using Multiple Server Instances) Finally, there is also a new Adobe article as of CF7: http://www.adobe.com/products/coldfusion/whitepapers/pdf/cfmx7_mulitpleinsta nces.pdf There are certainly other articles folks have done in the CFDJ or at CommunityMX.com, but these should get you started. Even though it's old news to some, it does seem that like many things, use of instances is something that may have been missed by folks. I've been contemplating a new user group presentation on the topic. Nothing new for CF8, but it seems people are considering things now that they may have ignored when 6, 6.1, or 7 came out (which is why I did my daylong class at CFUnited on what was new in 6 and 7 that folks may have missed). One last point, if those don't make it: if you're running on Windows, don't try to create an instance with a JVM heap greater than about 1.3 GB. Though Windows should allow 2GB per app, this is just a number many found that beyond which CF won't start. Hope that all helps. /charlie Member, Adobe Community Experts program www.carehart.org http://www.carehart.org/ My latest blog entry: CF8 http://carehart.org/blog/client/index.cfm/2007/7/3/cf8_admin_changes Admin Changes: A compendium of new/changed features since 7.02 --Blogsigs.com, Link your own blog posts. http://www.blogsigs.com _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, July 05, 2007 1:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Coldfusion Server Using JRUN Where can i get more info about running CF Server on JRUN, dealing with instances and that sort of thing? http://www.inevative.com.au/images/email-stationary/inevativeLogo_small.jpg Steve Onnis Director / Head Developer http://www.inevative.com.au/images/email-stationary/email.jpg [EMAIL PROTECTED] http://www.inevative.com.au/images/email-stationary/phone.jpg +61 3 9001 2258 http://www.inevative.com.au/images/email-stationary/mobile.jpg 0401 667 996 http://www.inevative.com.au/images/email-stationary/web.jpg www.inevative.com.au http://www.novahost.com.au http://www.threesquares.com.au http://www.smsonline.com.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~--- inline: inevativeLogo_small.jpginline: email.jpginline: phone.jpginline: mobile.jpginline: web.jpginline: novahost.gifinline: threesquares.gifinline: smsonline.gif
