Announcement: ColdBox Developer Week - FREE training
Team ColdBox is excited to announce an entire week of free ColdBox training coming up at the end of this month-- July 23rd through 27th. We've lined up 15 sessions of beginner and advanced topics from ColdBox experts all around the world. Please check out the session schedule on the official CBDW page of our site and get signed up now. http://www.coldbox.org/cbdw What the heck IS ColdBox? ColdBox is an event-driven, convention-based ColdFusion Development Platform. Read more about ColdBox here: http://www.coldbox.org/about Thanks! ~Brad ColdBox Platform Evangelist Ortus Solutions, Corp E-mail: b...@coldbox.org ColdBox Platform: http://www.coldbox.org Blog: http://www.codersrevolution.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Salesforce CFC?
riaforge.com should give you a way to submit a ticket and contact the project owner so he can include your updates into the main project. ~Brad - Original Message - From: Billy Cox bi...@oldworldspices.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, July 22, 2010 10:40 AM Subject: Re: Salesforce CFC? For the benefit of anyone else who wants to use Salesforce.CFC with the Salesforce API v.19... There are only a handful of changes needed, the most consequential of which are a couple of lines in the parseQueryXML function code. Salesforce API v.19 returns XML a bit differently than version 11.1. I have tested the Login, QueryObject and SaveObject functions and all of their child functions. I would be happy to share the updated cfc if you want to email me off-list. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Missing CFM Pages
Check the Verify that file exists checkbox on the IIS mapping. Beware, this will break things like cfimage display in browser, cfchart output and RDS sine those rely on the wildcard mapping to non-existent directories that CF still processes. ~Brad - Original Message - From: Robert Harrison rob...@austin-williams.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, July 22, 2010 11:46 AM Subject: IIS Missing CFM Pages How can I make IIS 404 work for missing CFM pages? It works for any except CFM. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Connecting to CFC's in the same directory in CF9.
What ColdFusion mappings do you have set up on the CF8 and CF9 boxes? That could explain a difference in behavior. If I can't use virtual directories, what is the approach that others use for testing on a desktop with multiple CF websites? Install Apache, set up multiple sites, and use your host file to have a separate domain for each of them. For instance, www.example.com could be devww.example.com on your desktop. ~Brad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: logout and back button
By citation needed I think the implication was that you didn't know what what you were talking about. The original poster's problem had nothing to do with persisted session vars and everything to do with browser cache. This can be an issue regardless of sever-side technology in use. ~Brad Sent from my HTC on the Now Network from Sprint! - Reply message - From: Anene Isioma Wealth anene.quor...@yahoo.com Date: Thu, Jul 15, 2010 8:04 am Subject: logout and back button To: cf-talk cf-talk@houseoffusion.com seconded... Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Tom Chiverton tom.chiver...@halliwells.com To: cf-talk cf-talk@houseoffusion.com Sent: Thu, July 15, 2010 1:59:38 AM Subject: Re: logout and back button On Wednesday 14 Jul 2010 14:49:29 you wrote: If other programming languages can effectively end session variables, i still dont know what MX's problem is. Citation needed. -- Tom Chiverton Helping to globally deliver collaborative best-of-breed eye-catching open- source solutions as part of the IT team of the year 2010, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word âpartnerâ to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Looking for a CF Recipe script!
And if you want to just go way too far-- these logic gates are actually only aware of the current flowing through their traces which is pushed by the voltage and inversely proportional to the resistance in the circuit per Ohm's law. Current is measured in amperes whereas one amp-second is a coulomb of electrical charge, or 6.241E18 electrons flowing through the conductor. So the real question is this: when your computer starts counting all those electrons does it start at 1 as the first one flows by? I believe the answer is yes, so it turns out CF was right after all. ~Brad - Original Message - From: Judah McAuley ju...@wiredotter.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, July 12, 2010 11:13 PM Subject: Re: Looking for a CF Recipe script! If you want to be extremely extremely pedantic, computers only know voltage differential. Those voltage differentials are just cleverly organized into logic gates, which it is useful (currently) to represent with binary numbers and basic arithmetical operations. Judah On Mon, Jul 12, 2010 at 7:56 PM, Andrew Scott andr...@andyscott.id.au wrote: No, if you want to be extremely pedantic about it. Computers only know 0 and 1's. So by that logic it knows zero before it knows one. -Original Message- From: Claude Schnéegans schneeg...@internetique.com [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneeg...@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Friday, 9 July 2010 10:31 PM To: cf-talk Subject: Re: Looking for a CF Recipe script! Nobody calls their thumb their zeroth finger. Sure, but computers do not count on their fingers... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ByteArray objects
If you want to be able to visually represent something that is a little cumbersome to display, why don't you try hashing it? That may help comparing them as well. ~Brad - Original Message - From: Sisk, Kris ks...@gckschools.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, July 01, 2010 9:38 AM Subject: RE: ByteArray objects I've got all that worked out except how to make it readable so that a human can verify that it grabbed the right one. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dump out CFC properties/variables
I usually include a dump method in my CFC's that simply cfdumps out whatever internals you want to see and cfaborts. If all your CFCs extend a single base component, this is even easier since you can put the method there. ~Brad - Original Message - From: Scott Brady dsbr...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, June 26, 2010 9:17 PM Subject: Dump out CFC properties/variables What's a good way to dump out the properties/instance variables of a CFC? I have a page where I can pass in a variable name and dumping it out dynamically. But, with CFCs, obviously all I get are method names, which aren't that useful, when, in the case of beans, I want the values of the variables in the CFC (basically, the result of every getter). Typically, these beans are in the session scope. It seems like it shouldn't be that hard, but I'm not having much luck. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
It's a bit more code, but if you switch to having a cfargument tag for each parameter and enforce the type there, you can pass in your struct as an argument collection. You'll get a more meaningful error that way. Sent from my HTC on the Now Network from Sprint! - Reply message - From: Marc Funaro subscripti...@advantex.net Date: Thu, Jun 24, 2010 5:43 pm Subject: Seriously PO'd - cfqueryparam and/or struct dereference flakes out To: cf-talk cf-talk@houseoffusion.com The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Server Survey
According to the link, the survey is closed. This survey is currently closed. Please contact the author of this survey for further assistance. ~Brad - Original Message - From: Shilpi Khariwal shilpi.an...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, June 20, 2010 11:39 PM Subject: ColdFusion Server Survey Dear All, If you have not already filled the ColdFusion Survey, please do so using the following link: http://www.surveymonkey.com/s/6N7QWPQ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Branching Strategies
Thanks to all who replied to my question. You guys gave me a lot of help and info I will share with the rest of my team to help decide how we set up Subversion. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion files aren't found.
The user that Cf runs as needs to have access to that drive. The html file is being served directly by iis and using its permissions. Sent from my HTC on the Now Network from Sprint! - Reply message - From: Richard Steele r...@photoeye.com Date: Sun, Jun 13, 2010 4:17 pm Subject: Coldfusion files aren't found. To: cf-talk cf-talk@houseoffusion.com We're trying to get our IIS7 webserver to serve cfm files that are on a different drive, but they aren't being found even though they are there. This works: http://localhost/sites/test.html This doesn't work: http://localhost/sites/test.cfm even though it is there. Here's the CF error message: File Not Found: /sites/test.cfm /sites/test.cfm is on a different drive than jrun. Many thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Home Site+ and Windows 7
How many folks think of a web site or a web application when they're editing / creating new files? Do folks really find it a stretch to go from that concept to an actual site/project in their IDE? I'm genuinely curious about this because I can't imagine working without sites / projects and I want to really understand why there is such a pushback on this... Thanx! It's not the files that are already part of my web application that usually present a problem-- it's the exceptions that crop up from time to time that are really annoying. One of the most common scenarios for me is when I've downloaded some bit of code or UDF off the Internet. Since it's not part of any actual site yet and probably laying on my desktop in a zip file, I'll just want to quickly open it up and read through it to see if I feel like using it or just want to delete it. My 2nd most common scenario is usually some bit of javascript or HTML code that I have copied and wish to toss in a temporary .html file and quickly edit for the sake of veiwing in a browser. My 3rd scenario is the very handy HTML and XML code formatted from Homesite. I would regularly use Homsite to open random config files off my hard drive for formatting that had nothing to do with the web. So, sometimes I will want to use a feature of the editor on a random text file. And my 4th scenario is the rare occasion that I would need to open a file directly off one of my staging or production servers via a UNC file path. Loading hundreds of megs of code over a network into a project just to deal with one file is not really an option. Now there might be work-arounds or alternative methods for each of my scenarios, but the fact of the matter is that's what I'm used to, it works very well, and why should I shoe-horn each of those exceptions into a project when they don't need to be? For the rest of the files I edit that are actually part of an established application, I don't have any problem with projects with the exception that Eclipse can sometimes be painfully slow when switching from one to another. ~Brad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Color Code XML
I'm looking for a way to take a text XML document and add the appropriate HTML markup to it so it can be viewed in a browser and color-coded and indented properly. I don't really care if it is programmatic and I don't even care what colors are used as long as it is pretty-- I just need to include some XML samples in a handful of documentation pages written in HTML. I can't find any color coding libraries that handle XML. The closest I got was to open the XML in Internet Explorer, copy and paste it into word, and then save as HTML, but that was a hideous solution that still required a number of find and replaces to finish getting rid of the JavaScript. Suggestions? Thanks! ~Brad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333998 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Color Code XML
Hmm, that's a slick little library. I like the customizability of it and the separate CSS files. Thanks! ~Brad - Original Message - From: Justin Scott jscott-li...@gravityfree.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, May 25, 2010 10:41 PM Subject: RE: Color Code XML Suggestions? http://alexgorbatchev.com/wiki/SyntaxHighlighter SyntaxHighlighter should make pretty quick work of it and allow the code to be displayed on the page in a viewer-friendly way. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 Windows vs Linux
As far as programming, there should be very little difference. The biggest problems you would have porting over code would be case-sensitivity and the silly little slashes in your file paths all going a different direction. I'm not sure what you mean by tags our there for the Linux version. It's still CFML-- and because it all runs inside the JVM, it's all surprisingly consistent. The only main differences are where you touch the OS. As far as installation and server maintenance, you would have significantly different experience. Firstly, you'll probably be running Apache and MySQL which puts you out there in RTFM land, but it's all doable. I've deployed CF on RedHat and Open Suse with good results. Honestly, I think the real determining factor is going to be how comfortable you are with Linux and command line stuff in general. ~Brad - Original Message - From: Terry Troxel te...@it-werks.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, May 21, 2010 7:52 PM Subject: Coldfusion 9 Windows vs Linux I have been using CF since version 3 and never once tried it on anything but a windows based system. My question is how much of a learning curve should I expect and are there tags out there for the Linux version as well as the windows? I would like to set up a development server and would also like to know which is the ones most used in production. I have Ubunto, but can get whatever is recommended. I would appreciate any and all the help I can get so I can get to learning. Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Transaction locking table, not sure where or why...
Store the data in a temporary structure in memory and then write it to the DB once the uploads are finished. +1 Store the data in a struct or array and wait until you have all the data to open your transaction. Do this and your problem with disappear. Also, in the places you are reading from the album table I would recommend setting the isolation for that connection only. Also keep in mind that the cftransasction tag's default isolation level is read committed, and it will reset it every time you open the tag. If you want to change the isolation level of the transaction, use the isolation attribute of the cftransaction tag. That being said, I don't think that's what you want to do. You want to change the isolation level of the query READING from the table. Also, run some traces to see if your updates are causing row locks or are escalating to table locks. I think that might be what Leigh was getting at. I don't know that I can recommend setting your global isolation level to read uncommitted. Locks are for a reason and I've seen some weird hard-to-find errors in systems where over-zealous DBA's used read uncommitted for EVERYTHING. :) ~Brad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading mp3s
I haven't used it, but Amazon's S3 has the ability to create temporary URLs for a user that even enforce what IP they will serve to. If you store your files in an S3 bucket, you can use the API to generate temp links for a specific user on the fly. As far as your original question-- I've always found it difficult to control user experience when downloading files based on all the different configurations of file associations and browsers. ~Brad - Original Message - From: andy matthews li...@commadelimited.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, May 08, 2010 10:40 AM Subject: RE: Downloading mp3s You can do one of a few things. Serve up the MP3 file through ColdFusion like so: http://lab.artlung.com/coldfusion-force-download/ Or you can set up your web server to deliver MP3 files as downloads instead of playing them. andy -Original Message- From: Rob Voyle [mailto:r...@voyle.com] Sent: Saturday, May 08, 2010 7:16 AM To: cf-talk Subject: Downloading mp3s Hi Folks I have a series of mp3 sound files on my website. I would like people to be able to download them to listen on their ipod or in their car on a cd etc. People are able to listen to them from the web but their ability to download and save them seems very variable. Some can see save as others can't. There is great variability between browsers and the media programs that people are using. Some mp3 files are able to be saved others aren't though I am not sure of any difference as I haven't set any specific permissions Is there a way to create saving permission for mp3 that all browsers/media players would recognize? Thanks Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Substitute/conversion for Flash Interactive Menus for iPad?
Have you looked into HTML 5? I hear it does everything Flash does. Your clients can wait another 5 years for the spec to be implemented, right? /sarcasm ~Brad On Tue, May 4, 2010 at 5:13 PM, Dawn Sekel dse...@ciber.com wrote: Hi-I have several web templates that use Flash widgets for interactive menus-the buttons are non-standard floating bubbles or have sound and interactivity in them when the user mouses over them. Now my boss said that he wants to do away with them and go to something different because of the Apple iPad debate. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:43 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL data integrity
Firstly I have absolutely no experience here and you should probably consult with an attorney with experience in this kind of thing. My best idea would be to institute a process to automatically ship all your nightly backups and or transaction logs to a third party to hold on to. If your data was ever brought into question that third party could independently verify that the data really was there on that date. That would be a heck of a lot of data- but I guess you have to ask yourself how much you are willing to pay for this kind of thing. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfhttp Connection Failure
I'd like to second Dave Watts' comments. It is true that cfhttp can't handle compressed responses and if you are hitting a web server that is gzipping the HTTP response you will get a Connection Failure message even though that doesn't seem at all like the appropriate message for the occaision. Adding the following header values will tell the remote server that the client (CF) can't handle compressed responses: cfhttpparam type=Header name=Accept-Encoding value=deflate;q=0 cfhttpparam type=Header name=TE value=deflate;q=0 ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed?
Do you mean using Windows Authentication, where the client automatically passes the credentials it has logged into the domain controller with? As far as I know that still can't be done but I'm not sure why. Is there are particular reason you can't create a SQL account for CF to connect with? I actually like that because it makes it a bit easier to audit permissions with explicit accounts. ~Brad - Original Message - From: Thomas Harper harpe...@upmc.edu To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, April 06, 2010 7:26 AM Subject: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed? I've been trying to pass with CF8 on a Windows Server 2008 box to SQL Server 2005 on a separate server. The references I've been seeing for previous versions say it can only pass the username and password of the account the CF8 service runs under. Kerberos references say it could be possible with the proper setup. Is it still impossible? Has it been done, and how? Thank you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion dateDiff() function?
Nope, it's working as designed. Here is an excerpt from the docs: The DateDiff function determines the number of complete datepart units between the two dates; for example, if the datepart parameter is m and the dates differ by 55 days, the function returns 1. So basically, using date diff is like using the floor operator, it is only counting the total number of COMPLETE days. Your example has a difference of only 2 minutes which is nowhere near a day. If you simply want to know if the files were created prior to midnight of the current day, then you should check for that specifically with something like so: cfset variables.yesterday = 04-04-2010 11:59 PM cfset variables.today = 04-05-2010 12:01 AM cfoutput#yesterday LT dateformat(today,mm/dd/)#/cfoutput - Original Message - From: Qing Xia txiasum...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, April 05, 2010 9:05 PM Subject: ColdFusion dateDiff() function? Okay, I am probably splitting hairs over here, but I ran into an icky situation with the native ColdFusion function DateDiff() today and just thought I'd check whether anyone else has experienced this before. Basically, I wrote a CF Scheduled Task that is supposed to go to a directory and delete all PDF files that are created before today. Simple enough, right? It should be really, but the DateDiff() function is behaving strangely. Try running the code below: cfset variables.yesterday = 04-04-2010 11:59 PM cfset variables.today = 04-05-2010 12:01 AM cfoutputtoday - yesterday = #dateDiff(d,yesterday,today)#/cfoutput You see how it thinks the the date difference is ZERO??? Shouldn't it be ONE???!!! There are ways to get around this (elegantly or otherwise)... but now I am just irked and curious. Is this expected behavior and I am just not understanding the function correctly or is this a bug that should get fixed? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332615 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Builder Released!
I hate to say it, but even without Flash Builder, Coldfusion Builder probably would have cost the same. Flash Builder was most likely thrown in to sweeten the deal and add value. Flash Builder is probably already has a foothold large enough to cover more of its development costs-- not to mention the professional version is $699. They can probably afford to toss a copy of the standard version in CFB for the people who want it. Creating a bundle for every person's needs is not always the best thing either. If you get your pricing matrix too confusing it just frustrates people. Also, you can call the shareholders greedy but unless you know how much money Adobe poured into CFB for the past year and a half you really can't prove their making bank on anything. ~Brad - Original Message - From: Eric Cobb cft...@ecartech.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, March 23, 2010 8:56 AM Subject: Re: ColdFusion Builder Released! Charlie Griefer wrote: Bundling it with FlashBuilder may be their way of trying to increase the uptake of the language as a whole and thus ultimately sell more server licenses. By doing this, they're potentially introducing CF to PHP developers, Java developers, etc. I have to say that I don't agree with that last statement. FlashBuilder 4 (Standard Edition) with CFBuilder costs $299, and FlashBuilder 4 (Standard Edition) without CFBuilder costs $249. So for an existing PHP/Flex developer who has no use for CF, do you think they're going to pay $299 to get an extra IDE for a language they don't use, or spend $50 less and just get the IDE they need? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Daylight Savings Scheduled Tasks
I usually use the following JVM arg (I'm in the central time zone): -Duser.timezone=America/Chicago ~Brad - Original Message - From: Terry Ford terryfor...@yahoo.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, March 11, 2010 9:48 PM Subject: Re: Daylight Savings Scheduled Tasks Do you have any idea how CF picks up server timezone? I would have thought that the JVM would have picked up that change. I'm not sure where CF is getting that CST from. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331631 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Default Flash behavior when crossdomain.xml is absent
My understanding is that the default behavior is the same for Flash 7 and higher. It should deny access from your swf to content fetched from another domain unless that domain has the appropriate cross domain policy file allowing content to be fetched from the domain containing your swf. Yeah, that seems to align with what I've been finding. Thing is, that's not what's been happening. So, I suspect that there's something else going on. Maybe some (most?) requests are actually being served from servers within your CDN initially, rather than from your original domain. For example, if I go to www.microsoft.com, I'm actually going to someserver.www.ms.akadns.net. Perhaps that's the default behavior for many of your users? I'm kind of grasping at straws here. Straws appreciated and accepted. I don't think that's the case though. I opened MS Fiddler and hit on of our pages myself. (All of the streaming content on our site uses the same dynamic page and the same SWF player. The SWF player is not located on the CDN). This is what Fiddler showed me: Request for www.mysite.com/thePage.cfm Request for www.mysite.com/player.swf Request for www.mycdn.com/crossdomain.xml (Returned 404) Request for www.mycdn.com/theFile.mp3 It defies logic. By all rights flash should have shut down the SWF and never allowed it to access the last file. Hmm, a bit more Googling, and apparently that isn't always necessarily the case. According to this knowledge base article, Flash differentiates between simply playing an MP3 and extracting data from it. http://kb2.adobe.com/cps/963/50c96388.html This article appears to say that flash WILL allow an MP3 from another domain to be played, but will stop short of allowing you to extract data from it (like ID3 tags) without a crossdomain.xml file. Interesting... I'm not sure if that is affecting me or not. I'm using the JWPlayer and I'm pretty certain it doesn't do anything special to the MP3s. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: null500 on nested custom tag
You should try a variable called lolcat. :) Seriously though, it sounds like an endless loop to me. If you check your server's coldfusion-out log you will probably see an out of memory exception. Put in some external logging to a text file or something to follow what is happening to your variables. Or use a counter in session to keep yourself from recursing more than 10 times so you can output debugging info in your page. Without really digging in to your code I can't really say where the problem is. It sounds like your issue is pretty straight forward-- you have a series of categories which are arranged in a hierarchy via your pivot table. Given a leaf node of your tree, you wish to climb until you reach the root node. I guess you're trying to make sure that none of your categories are orphaned with no active parents? Honestly, it might be a little simpler to write this using iteration, but don't let that keep you from recursive tags if that's what you like. As to whether or not you can do it in a single SQL statement-- maybe. If you are on SQL Server 2005 or later CTE's (common table expressions) allow recursion but I don't know that it would be any simpler. If your hierarchy of categories always has a known depth, you can just keep joining to your pivot table that many times. Other than that, you are out of luck using an adjacency list model. Nested sets are much better for calculating ancestors and descendants. One question: if your query returns no records, won't the line cfif nParentCatID LT 1 error trying to convert to a number? ~Brad - Original Message - From: Me Too must...@wabba.net To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, March 11, 2010 10:31 PM Subject: null500 on nested custom tag This is driving me nuts. Pretty simple, I have a little custom tag that runs through a pivot table trying to reach the bottom (categoryID=0) of a category tree by way of active (bActive=1) categories. The logic is: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: query passed by value from a udf?
So the question now is if GC can be called programatically after all references to a large 'object' is removed during a single request. Yes. cfset obj = CreateObject(java, java.lang.System) cfset result = obj.gc() Careful though-- Garbage Collection can be an expensive operation. Also, GC can be a little complicated. Just because you run the code above may not guaruntee everything you expect to be collected will be. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: query passed by value from a udf?
This is starting to sound like one of those Hibernate knows best sort of discussions. lol A sentiment I generally agree with, mind you. Second guessing Java's GC logic is probably for pretty darn special scenarios. ~Brad - Original Message - From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, March 09, 2010 11:52 PM Subject: Re: query passed by value from a udf? So the question now is if GC can be called programatically after all references to a large 'object' is removed during a single request. While Brad points out that this is possible, I don't know if objects are actually marked for deletion until the request has finished. In addition, it's the kind of thing that you really don't want to get into - if you want to manage memory directly, that's why we have C/C++. The thrust of modern languages like Java is that memory management should be something that the computer does, rather than the programmer. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Pretty XML
ToString(XmlParse(xmlString)) This is redunant. You just turned a string into an object, and back into a string again. XmlFormat(ToString(XmlParse(xmlString))) 5 yard penalty for misuse of the xmlFormat function. That function is designed to make a string safe for inclusion in an XML document without being confused with the XML markup of the document it is being included in. Try this: pre #xmlString# /pre If you want more control, htmlEditFormat it, and manually replace line breaks with br, spaces with nbsp; and tabs with nbsp;nbsp;nbsp;nbsp;nbsp; etc... ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Pretty XML
pre #xmlString# /pre Sorry, should have typed pre #htmlEditFormat(xmlString)# /pre ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sql on Linux
From the looks of that error message, you don't need to worry about the connection, you need to worry about the username and password you are using. What database are you connecting to, and what login are you using? Can you connect to the same database using the same login from another SQL client? ~Brad - Original Message - From: Orlini, Robert rorl...@hwwilson.com To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, March 03, 2010 10:30 AM Subject: sql on Linux I'm running CF7 on Linux and it won't connect to the datasources. It generates a Connection verification failed for data source: status_internal_test []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'wweb_status_internal_test'. Login fails. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'wweb_status_internal_test'. Login fails. error. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PCI Compliance Help
PCI reports that I've seen show the cookie in question that they think you are using to identify your sessions. The fact of the matter is how can the scanning company know what cookie values you are using to track sessions unless they can see your code. They can't unless they can successfully demonstrate a session highjacking with your server. That means they are guessing. That whole bit kind of irks me. I recently had a PCI scan that claimed I had the same problem. The thing was, the cookies their little automated scanner picked up had absolutely nothing to do with our session tracking and was a random cookie used only to help the load balancer keep server affinity. I was rather annoyed with that prognosis seeing as how any competent programmer worth his salt could look at my response headers and see the jsessionid in there, but a professional PCI compliance scanning company was charging us 600 dollars so their silly automatic scanner could pick up random cookies and assume they had anything at all to do with session tracking. Don't ask me how I really feel. :) So, what do you do? Well, firstly check the report again to see what cookies they think are you session ids. If you are using CFIDs, it probably picked that up because they are too dumb to read Adobe's technotes that clearly state CFID is NEVER used without CFTOKEN (which is random) to identify a session. (http://kb2.adobe.com/cps/404/kb404762.html) If you passed your scan, I wouldn't worry about it-- all you need is a passing grade. If you failed your scan and need to fix it, change to jssessionid and stop using CFID and CFTOKEN. If the cookie they are complaining about turns out NOT to be CFID, then consider refactoring so it is not in use or has a non-sequential value. Lastly, you can submit a rebuttal to them that basically says You don't know what you're talking about and here's why, and they might not make it count against you. ~Brad - Original Message - From: Deanna Schwint dea...@vimm.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, February 15, 2010 8:58 PM Subject: PCI Compliance Help We just had a PCI Compliance scan done through SecurityMetrics and have one issue: Synopsis: The remote web server generates predictable session IDs Description: The remote web server generates a session ID for each connection. A session ID is typically used to keep track of the actions of a user while he visits a web site. The remote server generates non-random session IDs. An attacker might use this flaw to guess the session IDs of other users and therefore steal their session. We are using the UUID for CF Token that is set in the ColdFusion administrator and are also setting : ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Broken images in CFADMIN
In my experience this happens when your CFIDE folder is not web-accessable, but you have a mapping for CFIDE in ColdFusion. The .cfm pages are resolving becuase CF is using the mapping it has, but when IIS is asked for an image (which doesn't involve CF), the path is non-existant. You need to confirm that the CFIDE/administrator directory is actually in the web root of the IIS site you are accessing. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Server Outages/ Stops Responding
We are having same outage issues. We don't know what happens (CF hangs, Jrun freezes etc.) in background but CF just stops processing requests. 1) Buy SeeFusion for all you servers. 2) Configure database logging and active monitoring alerts 3) Analyze your traffic, memory, slow pages, slow queries, and stack traces 4) Re-factor as needed and go back to step 3 as long as problems persist. If all that sounds too complicated, it's a not really as bad as you think. If you don't have time, call WebApper and pay them to help you. They make SeeFusion, and Mike Brunt works for them so you can't go wrong. :) ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: directory protection
Well, if you're going to use CFCONTENT to serve the files, there's no point in renaming them, is there? Yes, if you cannot store them in some non Web accessible directory, which was my case for many years before I got my own dedicated server. By renaming them .cfm, they are automatically protected by some Application.cfm in the same directory. Were you using IIS or apache in those days? If the latter, an .htaccess file could have been placed in the directory to deny access. Shared hosting on IIS give you no such ability though. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: My ColdFusion JRun service is running at 50% CPU but I have no Idea why.
http://www.ilsweb.com/JRun4-stack-traces/ Hmm, I don't see anything too useful in there. There were a few threads running, but I'm thinking they were all related to getting the stack trace. To allow the jConsole tool to connect to each instance I had to configure each one with a separate jvm.config so that each instance uses a different port number to report the JRun statistics to the console. Thus I can tell what instance I am looking at by the port number of the jConsole window and that is the one I connected to and dumped the threads. So, you know which instance jConsole is attached to, but do you know which instance is causing the CPU usage? Are you getting CPU usage from jConsole somewhere or are you looking at Windows Processes? If you are super duper sure you are getting stack traces from the instance that is causing the CPU spike, then I would add garbage collection debugging args to your JVM and analyze if garbage collection is running. I'm not sure if GC shows up as a thread in your stack trace or not. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: NullPointer exceptions
Can you give us a sample stack trace for one of the errors? ~Brad - Original Message - From: Tom McNeer tmcn...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, February 11, 2010 8:00 AM Subject: NullPointer exceptions Hi, I have a relatively complex application that uses a Flex app as a front end. Recently, I have begun to see a spate of NullPointerExceptions being generated when methods are called from the Flex app. The calls are Flash/Flex Remoting calls, not directly to Blaze. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sample ldap
http://www.google.com/search?hl=ensource=hpq=coldfusion+ldap+example The first result looks pretty comprehensive. http://www.15seconds.com/issue/020710.htm ~Brad - Original Message - From: fun and learning funandlrnn...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, February 11, 2010 8:37 AM Subject: sample ldap Hi All, Is there a sample or example ldap for learning purposes? I am learning LDAP for implementing in Coldfusion Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: NullPointer exceptions
Hmm, looks like the error happened while getMetaData was being called from Transfer. Have you posted this on the Transfer list? Also, out of curiosity, are you using trusted cache? ~Brad - Original Message - From: Tom McNeer tmcn...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, February 11, 2010 8:54 AM Subject: Re: NullPointer exceptions On Thu, Feb 11, 2010 at 9:40 AM, Brad Wood b...@bradwood.com wrote: Can you give us a sample stack trace for one of the errors? Sure. But hang on - they're long. This one is from the CF exception log: = Error,jrpp-3,02/10/10,22:38:05,, java.lang.NullPointerException at coldfusion.util.Utils.getServletPath(Utils.java:86) at coldfusion.util.Utils.getServletPath(Utils.java:76) at coldfusion.util.Utils.getBaseTemplatePath(Utils.java:405) at coldfusion.runtime.TemplateProxyFactory.getTemplateFileHelper(TemplateProxyFactory.java:1514) at coldfusion.runtime.MetadataUtils.getComponentMetadata(MetadataUtils.java:112) at coldfusion.runtime.CfJspPage.GetComponentMetaData(CfJspPage.java:2667) at coldfusion.runtime.TemplateProxy.getRuntimeComponentMetadata(TemplateProxy.java:1755) at coldfusion.runtime.TemplateProxy.getRuntimeMetadata(TemplateProxy.java:1616) at coldfusion.runtime.MetadataUtils.getMetaData(MetadataUtils.java:54) at coldfusion.runtime.CfJspPage.GetMetaData(CfJspPage.java:2640) at cfAbstractBaseMeta2ecfc803585718$funcCLONE.runFunction(C:\webApps\frameworks\transfer\com\object\AbstractBaseMeta.cfc:33) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Determining CF8's UNIX Account
Robert, can you tell us if you had any luck changing the groups around like I suggested? Thanks! ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Problem - is file type extension required?
Gerald, What do you mean when you say it doesn't work? Does the remote server respond? What HTTP status code comes back? What is in the body of the response? I would recommend installing a packet sniffer like wireshark. Install it on your CF server and run your browser tests from there. Start it up and make a request from a browser (on that server) and follow the TCP stream to find the exact request headers being sent to the server. Then run the CF page with the cfhttp call and get the request headers from that and compare. Also, Microsoft Fiddler has a request builder tab that lets you build any HTTP request you want for testing that has whatever headers you specify. Good Luck. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reducing a query result
If you are looping over the query with a cfoutput tag, you can specify the
startRow and maxRows attribute to make pagination easy. That actually
modify the query object though.
The easiest way to pare down a result set is with a query of queries which
lets you run SQL commands against a query object in memory. The trick is
you need to have a column that represents the row numbers for you. So,
assuming one of the columns in your resultset is rowNumber which contains
1 - 500, you could do this:
cfquery dbtype=query name=youOriginalQueryName
SELECT *
FROM youOriginalQueryName
WHERE rowNumber 50 and rowNumber = 100
/cfquery
or alternatively:
cfquery dbtype=query name=youOriginalQueryName maxrows=50
SELECT *
FROM youOriginalQueryName
WHERE rowNumber 50
/cfquery
Note, those cfquerys do NOT run anything against the database.
Alternatively, if you REALLY want, you can loop over the result set manually
and build a new result set with CF's query functions.
cfscript
qryNewQuery = queryNew(#qryOrigQuery.columnList#);
i = 0;
startRow = 1;
endRow = 50;
while (++i = qryOrigQuery.recordcount)
{
if(i = startRow i endRow)
{
queryAddRow(qryNewQuery,1);
c = 0;
while (++c = listLen(qryOrigQuery.columnList))
{
QuerySetCell(qryNewQuery,
listGetAt(qryOrigQuery.columnList,c),
qryOrigQuery[listGetAt(qryOrigQuery.columnList,c)][i],
qryNewQuery.recordCount);
}
}
}
/cfscript
- Original Message -
From: Chad Gray cg...@careyweb.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, June 04, 2009 10:07 AM
Subject: reducing a query result
Say I have a query returned with 500 records.
Is there a way in CF (not SQL) to reduce the query to only rows 1-50,
51-100 etc?
I talking physically reducing the query object.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323173
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server just.... stops?
If Fusion Reactor is like SeeFusion, I have actually seen more examples of where the monitoring application is still available even when the CF Server does not seem responsive. The most common cause of this is due to the CF server being out of active threads to respond to requests with due to DB locks, or other I/O locks on threads. Since SeeFusion (and I assume Fusion Reactor as well) are implemented as a Java servlet filter they can usually manage to keep going even if CF is out of threads. I believe what you are saying though-- so it sounds like something is locking up the whole JVM. If memory looks good, I guess I would check for Hot Spot JVM crashes. First, check your out logs in CFRoot\runtime\logs\coldfusion-out.log Next check for the existence of any file in CFRoot\runtime\bin\ that look like hs_err_pid.log where was the process id of the JVM when it crashed. Also, you mentioned you were using CFX_Image. Check this blog entry of Steven Erat's that discusses a very similar problem they had on a server using CFX_image. http://www.talkingtree.com/blog/index.cfm?mode=entryentry=B13095A3-45A6-2844-799942B3CBA5269E ~Brad What does fusion reactor say is happening on the server when it stops. How many running threads are there? How many database calls are happening? Get a full thread dump and look at everything that is running. What are you memory levels? Hard drive usage on the box? (perfmon) Unfortunately, FusionReactor runs in conjunction with the jrun process, so when ColdFusion locks up, FusionReactor is not accessible. Memory and hard drive use appear normal whenever the lockups occur. We've enabled request logging in FusionReactor so it writes the start and end of requests to a file so we will have something more to reference the next time it happens. I guess what I'm looking for specifically is any advice on additional metrics we can/should be collecting from the JVM (tools or JVM settings) or the ColdFusion service that might shed some light on what the system is doing when the lock occurs. -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 7.02 Distributed Mode
Now I am a little lost. Each one of the 3 servers will need to have JRun installed on them? No, not JRUN-- just the web server connectors. It is what routes the requests between the web server and the JRUN instances in your cluster. The issue I am having is when I try and run the wsconfig.jar file I keep getting a message that says - -JNDI listen port in jndi.properties blocked by TCP/IP filtering or firewall on server - -host restriction in security.properties blocking communication with server. I fixed the host restriction by doing a search through google but can not solve what I think is the jndi issue. I would assume you needed some ports open in the 5 range, but I'm not sure what you mean by JNDI issues. I would start by looking in the your security.properties file located in runtime/lib like it suggests and see what subnets and hosts are allowed to connect to jrun. Is the machine running Apache on a different subnet? If so, you will need to allow for it in the security.properties file. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: decrypt
Hashes are a one-way deal and cannot be decrypted by nature. The only way to reverse a hash is by brute force. (Google Rainbow Tables) I guarantee you the PHP app did not decrypt whatever it was it was hashing. Generally, when it comes to something like passwords, you hash the password and store it. When someone attempts to login, you hash the password they provided and see if that hash matches the stored hash. ~Brad - Original Message - From: Chad Gray cg...@careyweb.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, April 18, 2009 12:01 PM Subject: decrypt Hello, I need to decrypt a hash. Can I do this in CF? I am trying to get a PHP application that stores some information as an MD5 hash to work with a CF application. So want to decrypt it and use it in my CF application. This web site can decrypt it, but the CF decrypt() function needs a key. How do I figure out the key? http://tools.benramsey.com/md5/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about hack
Technically, no. In this post I have an example of a procedure which would be venerable to all kinds of SQL injection attacks. http://www.codersrevolution.com/index.cfm/2008/7/22/When-will-cfqueryparam-NOT-protect-me SQL injection is made possible when you don't differentiate between your SQL code and arbitrary parameters. ANY form of dynamic SQL can be susceptible to that. ~Brad - Original Message - From: Matthew Allen a.matthe...@yahoo.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, April 10, 2009 12:10 PM Subject: Re: Question about hack This is yet another example where CFQUERYPARAM would have prevented the attack. Every time someone says it's unnecessary, I'm going to point them to this thread. Is it safe to assume then that using stored procedure would have prevented the attack? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Question about hack
Not necessarily. With the proper configuration of MySQL (multiple statements allowed, and \ escaping single quotes) your example below could be hacked. http://www.codersrevolution.com/index.cfm/2008/7/13/Just-when-you-felt-safe-SQL-Injection-and-MySQL The underlying reason is because you are not explicitly telling your SQL server what is SQL code and what is the parameter. The one and only sure-fire way to do that is with the likes of cfqueryparam, cfprocparam, or sp_executesql (MS SQL Server). ~Brad - Original Message - From: Matthew Allen a.matthe...@yahoo.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, April 10, 2009 12:25 PM Subject: Re: Question about hack To be more precise, would the code below prevent an injection attack? Store proc: ... @uid uniqueidentifier AS BEGIN SELECT ID,column1, column2..etc FROM tbltable WHERE UID = @uid END CF Code: cfquery name=doStuff datasource=application.DSN EXEC usp_getSomeData @param = '#url.uid#' /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java now available on Google App engine - how long til CFML?
From: Barney Boisvert bboisv...@gmail.com Out of the box, I doubt any of the CFML engines follow the AppEngine rules, While I think it would be cool to run CFML on Google's App engine, I think one of the major hurdles would be files system access. Log files, temp directories, and even cached class files would all have to be refactored. And according to the docs, any running program wouldn't even be allowed to open a socket connection. http://code.google.com/appengine/docs/whatisgoogleappengine.html For instance, bytecode that attempts to open a socket or write to a file will throw a runtime exception I think you'd have to use all of Google's APIs to do all that stuff. CFMAIL would be out in favor of the JavaMail API. Seems like a lot of that would be a step backwards from the basic stuff ColdFusion already does for us. Either way, unless Adobe REALLY wanted to rearrange CF to fit that mold, I think an open source project like Railo or OpenBD would have to take up the mantle of making a CFML engine that followed the Googles App sandbox rules. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about hack
Using MS SQL the code below would be safe as long as all your parameters are strings and encased in single quotes since the cfquery tag will automatically escape any single quotes that exist in the #url.uid variable. If you were to pass in a numeric value to the stored procedure which did not have single ticks around it, you would be vulnerable again even though it is a stored proc call. If it's all the same to you, I would recommend using the cfstoreproc tag to call your procedure. It allows for the cfprocparam tag for your parameters which can optionally validate your inputs' data type as well. (just like cfqueryparam does) ~Brad - Original Message - From: Matthew Allen a.matthe...@yahoo.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, April 10, 2009 1:04 PM Subject: Re: Question about hack OK point taken, not safe with MySQL but fine with MSSQL? I just need to know if I should start working on my old MS SQL codes, so far none have suffered with injection attacks it might be by sheer luck or maybe all is well with it as it is on a MS SQL server, right? Not necessarily. With the proper configuration of MySQL (multiple statements allowed, and \ escaping single quotes) your example below could be hacked. Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: uml modelling tool
End of the day, bar napkins and pictures on white boards are where 90% of our design comes from Amen to that. We used MyEclipse UML for a while, but eventually we found that the whiteboard was much better suited for early planning where our ideas were still fluid. By the time we have a concrete enough design we are out of time to plan and end up just going from the white board, to the DB design, and then SQL and CF from there. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help requested - Syntax for GROUP BY with HAVING ... ommitted code
I don't see how that SQL would work. You are using deptName in your select list and order by, but you aren't grouping by it. Unless MySQL allows you to do stuff that SQL Server doesn't, that should throw an error. Also, I had originally suggested placing the amount in the group by, but I hadn't noticed that you were getting the avg and sum of the amount column as well so you probably don't want to be grouping by amount. To use an aggregate function on the same column you are primarily grouping by would be useless, since the final result will return one row for every distinct value of the amount column. I'm not sure what the purpose of this query is, but if you are expecting to get one record back for each unique department with totals and average amounts for that department I think you would want to group by deptName and take amount out of the select list and the group by. ~Brad - Original Message - From: BobSharp bobsh...@ntlworld.com CFquery name=DeptAverage datasource=bs3578 SELECT a.Amount AS aAmount, d.DeptName AS dName, AVG(a.Amount) AS AverageAward, SUM(a.Amount) AS DeptTotal FROM incentiveawards a INNER JOIN employeedirectory e ON (e.ID = a.RecipientIDfk) INNER JOIN departments d ON (d.DepartmentID = e.DepartmentIDfk) GROUP BY a.Amount HAVING SUM(a.Amount) 5000 AND AVG(a.Amount) 3000 ORDER BY d.DeptName DESC; /CFquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) about Vista
heh. I figured it would ask if you wanted to allow or deny... ~Brad - Original Message - From: Will Tomlinson w...@wtomlinson.com echo %OS% from DOS prompt It crashed on me. Thanks don L. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hash symbol in string
ColdFusion thinks the # is the start of a variable name. All you need to do is double it up to escape it: cfset MyDoc.rows.XmlChildren[1].XmlChildren[2].XmlText = ##cspan / ~Brad - Original Message - From: Richard White rich...@j7is.co.uk To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, March 21, 2009 3:24 PM Subject: hash symbol in string we are trying to add a string to an xml document as follows: cfset MyDoc.rows.XmlChildren[1].XmlChildren[2].XmlText = #cspan / however, the # symbol throws an error. We understand why it is throwing an error but dont know how to get around it. we need to use just one has symbol but how do we do it in this case thanks for any help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Read email contents and enter into database
Have you read the docs? http://www.cfquickdocs.com/cf8/#cfpop The cfpop tag returns you a regular old result set that you can loop over just like a result set and access each column to do whatever you want with it. All the column names in the query you get back are documented on livedocs. cfdump out the result set and it should make pretty good sense. Hit us back if you have any specific questions. And here's a hint, use uid *not* messageNumber to delete the messages after you are done. Deleting by messageNumber is like deleting from an Array by index-- it changes as you delete the items. ~Brad - Original Message - From: Jason Congerton ja...@jasoncongerton.co.uk To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, March 17, 2009 11:45 AM Subject: Read email contents and enter into database Hi I have had look via google and found no answers, has anybody ever needed to read the contents of an email and enter them into a database. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cffile - cfftp questions..
I'm not quite sure what you're suggesting, but cffile must be used to upload files submitted from the client in a form post as far as I know. cfhttp is for sending http request from your coldfusion server to another machine. I don't really see how you could accomplish a file upload from a client via that. You could consider giving your users FTP accounts. The FTP protocol is a bit better suited for large files and won't consume an app server thread. However, it wouldn't be part of a web interface. The only other option I have seen for easily uploading large files from the web are custom applets or active x controls etc. Truthfully, you aren't going to get any better network transfer right from them-- just more control. ~Brad - Original Message - From: Les Mizzell lesm...@bellsouth.net To: cf-talk cf-talk@houseoffusion.com Sent: Friday, March 13, 2009 9:35 AM Subject: cffile - cfftp questions.. Working on an admin section for a client to upload podcasts and video to his site. I've always used plain old cffile for this sort of thing, but his files are a bit on the hefty side compared to what I've usually used cffile for. Could performance be improved by used cfftp along with cffile, or is there really not much of a difference? Or is there a better ?best practice way for large files I'm not looking at yet? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 8 developer/IPSec/VSClient Problem
We are assuming that ColdFusion running on your local machine. Go to your desktop, right click on My Computer, and click Manage. Expand Services and Applications, then click Services Look for the following services in the list: ColdFusion 8 .NET Service ColdFusion 8 Application Server ColdFusion 8 ODBC Agent ColdFusion 8 Search Server ColdFusion 8 ODBC Server Does the status column show as Started next to any of them. Right click on each one and select Stop to stop each service. ~Brad - Original Message - From: Adam Haskell a.hask...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, March 10, 2009 10:38 PM Subject: Re: CF 8 developer/IPSec/VSClient Problem I think dave was asking exactly what you are looking for, he was asking if you turn off all the CF 8 related services if it was working. A very good question but not to helpful if you don't know what to turn off ;) . Things that may conflict would be cf8 service itself (doubtful but who knows) the .Net Service (maybe ColdFusionDotNetService or something like that) that CF 8 now has (most likely culprit) and a verity service (probably not but it has been updated since MX so possible). I don't have cf8 installed this way on a windows box anywhere so I can not provide the exact service names but pretty sure they all have ColdFusion in the name or some sort of identifier as being related to CF8. Adam On Tue, Mar 10, 2009 at 5:34 PM, Roger Dear de...@cox.net wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
Yes, that was much clearer. Thank you :) Are you using the cfapplication tag in your application? Do you have session management enabled? If so, you can keep a list of the user's operations in a session variable. cfset session.array_of_user_actions = arrayNew(1) cfset arrayAppend(session.array_of_user_actions,User Inserted Record A) cfset arrayAppend(session.array_of_user_actions,User Updated Record B) cfset arrayAppend(session.array_of_user_actions,User Scratched His Head) This would create an array that you could append to as you saw fit with the user's actions. I don't neccessarily think it's the best way to audit your users actions, but it would work. Session variables do not get deleted at the end of your page request. They will be available on each subsequent request from the same user providing his session has not timed out. h3User's Activity During This Session/h3 cfloop array=#session.array_of_user_actions# index=this_action #this_action#br /cfloop As far as knowing whether you are inserting or updating-- Generally when a user is updating a record, he selects it from some list and you populate the values for it into a form. At that point simply place the primary key from that table in a hidden field in the form. When you submit the form, the processing page can look for the existence of that hidden form field. If the primary key was passed, it's an update, otherwise it's an insert. ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, March 09, 2009 9:49 AM Subject: Re: Compare FieldValues with DataBase Values Yes, I can use select statement but I am able to display only the latest taction taken to the coldfusion page but not all the list of actions taken in a user session. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
By the time the cfquery tag has finished executing the entire data set has been returned from the database and is loaded into memory in ColdFusion. If the cfquery tag is taking a very long time to complete then: 1) The actual SQL is taking a long time to complete. 2) and/or you are returning a very large amount of data to the ColdFusion server 3) and/or you have very slow connection between your SQL server and your CF server. 302 thousands records is quite a bit-- especially if you have a memo field in there. Can you even add indexes in Access? If so, you might want to consider it. If you just want a count, then just do select count(1) and only a single record has to pass from your database to CF. There are a number of reasons why running the select directly in Access may appear much faster. 1) You are probably running it locally so there is no costly transfer of data between servers. 2) In my experience, Access spools the data behind the scenes and only loads in the records which are visible on the screen which gives your query a very fast turn-around and then it lazy-loads the data in as your scroll down. ~Brad - Original Message - From: Claude Schneegans schneeg...@internetique.com To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, March 08, 2009 5:42 PM Subject: What the heck is happening during CFQUERY? Hi, I've always thought that all what CFQUERY was doing was to create some connection to the database, and then the actual content of all records would be read as needed during some loop on the result set. I have this statement on some Access database : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT armeId, armTexte FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.recordCount#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/CFOUTPUTCFABORT The query semms to take for ever. Actually, the output says: getArmes.recordCount = 303203 cfquery.ExecutionTime = 614469 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Compare FieldValues with DataBase Values
- Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Ok, what about these field names? Can you explain for us please? Are these columns in a table? Columns in a result set? Do you realize you have EmployerID in there twice?? Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Is EmployerID the primary key or a foreign key? I would have expected it to be called EmployeeID if it were the primary key, since an employer employs the employee. Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. What field value?? Is this in a ColdFusion page or a SQL statement? Where is the fieldvalue coming from? A form? The Url? In what way do you want to compare? Do you want to compare a single record, or more than one? ? I thought of using arrays but I don't know how to add database date to the array and compare. What is a database date? None of the columns you have mentioned so far seem to have anything to do with dates. Setting a date into an array is easy as cfset myArray = [now()] but I'm not sure where you are going with this. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). What table is this? The employee table? If EmployerID is the primary key of the Employee table, why is that column also in the Department table? If two people are in the same department, do you have two department records with the same department name, but different EmployerIds? I'm quite confused. If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Is the table in session, or do you simply mean inserts into the database during a user's session? So you want to have a screen that shows someone the records they entered since their session started? You could store the data in a session variable, or store the primary key of the records they inserted. I'm not sure where you are headed, but this would also be possible if you had a userIDModified in the table and a datetimeCreated column. You could simply query out the records that user had inserted since the time their session started. Can anyone help me with this? Probably, but we need a bit more direction on what it is you are doing. I'm pretty bad at guessing. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF restart daily
Michael, do you have any word on this? I'm kind of curious. Could you clarify if the ColdFusion service is restarting or the OS. You said cron job-- are you hosting on Linux? First of all, how do you know it is restarting? What is the symptom? If it is ColdFusion that is restarting, start with the server out logs in /log/ Also on ColdFusion: Do you have SeeFusion installed to log long requests and server memory levels? If it is windows that is restarting check the window system event log (and check for Windows update auto-restarts) Also on Windows: Check windows scheduled tasks under system tools. If it is Linux that is restarting, start looking in /var/log/message Also on Linux: how are you viewing cron jobs? If it is root's cron job, you won't see it with crontab until you su to root. Hope you get the source. :) Thanks. ~Brad - Original Message - From: Michael Dinowitz mdino...@houseoffusion.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, March 06, 2009 12:22 PM Subject: CF restart daily I've looked through the archives. I've checked my settings. I've done just about everything possible to be done and I still can't find out why HoF reboots every day at about 12:00. If it was memory, I'd expect it to be more random. It looks like some sort of scheduled event but there is no cron job on the server. Any other scheduled events I could look at? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HTTP_USER_AGENT question
I can't think of many sites I've built that had session management turned on but didn't use session variables somewhere on every page request, so the point would largely be moot since sessions were guaranteed to be used. If I wasn't using them I probably would have turned them off in CF Admin in the first place. ~Brad - Original Message - From: John M Bliss bliss.j...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, February 20, 2009 7:20 AM Subject: Re: HTTP_USER_AGENT question Interesting. That seems like a more server-memory-friendly approach. Wonder why Adobe CF does not do it that way... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HTTP_USER_AGENT question
In those cases, I give the separate admin/members only it's own cfapplication tag. Disable session management for the public app and enable if for the private one. ~Brad - Original Message - From: John M Bliss bliss.j...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, February 20, 2009 9:51 AM Subject: Re: HTTP_USER_AGENT question You've not built many sites with a public-facing, no-sessions-needed front-end and some admin and/or members-only interfaces that require auth? That describes 2/3 of the sites I've built... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server 2005 Datasource failing
What port is SQL Server 2005 listening on? Also, can you connect using the same password in Enterprise Manager? Run a trace on the 2005 database and include failed login events from the audit group. Can you see the login failures coming through. If not, CF isn't hitting the correct SQL instance. ~Brad - Original Message - From: Stan Winchester s...@aftershockweb.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, February 17, 2009 9:38 PM Subject: SQL Server 2005 Datasource failing On my local network I've been using SQL Server 2000 and connecting to it with BD7 CF8 with no problems. I also have SQL Server 2005 on it and am having trouble creating a datasource that logins. It seems to see SQL Server 2005, but I am getting the following error: Connection verification failed for data source: [my datasource] java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database [my datasource] requested by the login. The login failed. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database [my datasource] requested by the login. The login failed. With SQL Server 2000 I just connected using the [server name] over port 1433 with no problems. SQL Server 2005 is on the box so the server is called [server name]\sqlserver2005 as shown in the connections properties in MS SQL Server Management Studio, with the instance name sqlserver2005. I have checked and re-checked the user name / password and they are the same in CF8 the SQL Server 2005 database. Any ideas what I am missing? Thanks, Stan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Configure Apache and ColdFusion 8
You will not be able to bind both Apache and IIS to port 80. You will need to pick one or use a non-standard port for one. Here is the livedocs page for configuring Apache and CF8 on Windows: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=configuring_07.html ~Brad - Original Message - From: Chad McCue c...@advmediaproductions.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, February 17, 2009 9:06 PM Subject: Configure Apache and ColdFusion 8 I just installed apache on my development server. My development server is also running IIS. ColdFusion is installed and running associated with IIS with no issues. Is there a way to have my Coldfusion 8 server run with IIS and Apache? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question about cfproperty
On the topic of cfproperty-- don't write them off completely. :) They look like they will play a big part in CF 9's ORM features. Additionally, some frameworks like ColdBox use cfproperty tags' metadata to autowire dependencies into your components. Just food for thought. :) ~Brad - Original Message - From: Mike Soultanian msoul...@csulb.edu To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, February 15, 2009 12:16 PM Subject: Re: question about cfproperty Dave Watts wrote: CFPROPERTY is really only useful for web services. For most CFCs, you don't want to document properties because those properties aren't public; the use of public properties breaks the concept of encapsulation. Ahhh... cool. Thanks for the info! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Did you read any of the Google results that Mark pointed you towards? Chances are since you are using SQL Server Express, you are trying to connect on the wrong port or SQL Server is not configured for TCP connections at all. You can use netstat -a on your machine to verify what ports are being listened on. But firstly, read a few of the many blog entries out there on the topic. http://www.fusioncube.net/index.php/coldfusion-sql-server-express ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 12:47 PM Subject: Re: Unable to create Datasource ColdFusion8 This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Wow, we've really made it angry now, huh? I've got to say I didn't have this much trouble, so I don't know how much help I can offer at this point. If I were you, I would start by looking in your windows system and application logs for clues. Also see if you have this log file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG I have SQL Server 2005 express installed on my machine, and that appears to be the location of the log file. Something must be preventing the service from starting properly so I'm guessing you will need to find the real error message and make a trip to Google with it. As for the 11 Arrested, Indicted in Multi-State Operation Targeting Visa and Mail Fraud-- that really too bad for them. I don't suppose they would have been much help to your SQL server set up anyway. :) ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 2:03 PM Subject: Re: Unable to create Datasource ColdFusion8 Brad, I followed the link and now I am unable to restart service and error I get is sql server(SQLEXPRESS) service on Local Computer started and then stopped. SOme services stop automatically if they are not in use by other services or programs.http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=da75d676b6b6f110VgnVCM104718190aRCRDvgnextchannel=68439c7755cb9010VgnVCM1045f3d6a1RCRD ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maybe I need a SQL Service Consultant...
This isn't a bug in SQL Server. Rick said that his primary key column was a char field and so was the index. Since Unicode support was enabled, parameters were coming in as nchars or nvarchars. SQL Server cannot compare a char to an nchar so it must convert one so the data types match. http://www.codersrevolution.com/index.cfm/2009/2/13/SQL-Server-Gotcha-Implicit-Unicode-Conversion ~Brad That's fascinating. But why would sql server create an index in a codeset that didn't match the column? You'd think that the index would match the declared type of the column automatically. I would think of that as a bug in sql server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maybe I need a SQL Service Consultant...
resolving the way my database driver was configured helped clear up a lot of problems by reducing the # of reads we were doing. @Rick, can you provide any specifics on the above change? What did he change? How did it reduce reads? Thanks. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: More SQL Profiler questions
In case anyone else comes across this via google... Once a query is compiled with sp_prepare, it is stored in a system table however only the first 128 characters of the SQL are stored in a visible form in SQL 2000 To be more specific, the name of the table in question is master.dbo.syscacheobjects. This select will give you a list of all the cached prepared statements: select c.* from master.dbo.syscacheobjects c inner join master.dbo.sysdatabases d on c.dbid = d.dbid where objtype = 'Prepared' and cacheobjtype = 'Compiled Plan' and d.name = 'database_name' The objid column should correspond with the id you see in your trace. Looking at this table and ordering by usecounts can actually give you a pretty good feel for the cached plans which are getting used the most. Also, the docs say 128 charactesrs, but I'm looking at the contents of this table on a sql server 2000 database and I'm getting WAY more than 128 chars. The longest sql entry in the table is 3,900 characters long so I'm not sure how the 128 character thing comes into play. http://msdn.microsoft.com/en-us/library/aa260394(SQL.80).aspx ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hosting
Charlie Arehart's CF411 to the rescue. He has a decent list of CF hosting companies. GoDaddy is probably the cheapest of them all, but you will get what you pay for. http://www.carehart.org/cf411/#cfhost ~Brad - Original Message - From: Robert Bailey robert.bai...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, February 11, 2009 9:48 PM Subject: Hosting I am trying to find a decent CF8 hosting company that offers SQL Server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: tools for creating DAO, Gateway, Bean, etc CFCs
http://cfcgenerator.riaforge.org/ - Original Message - From: Mike Soultanian msoul...@csulb.edu To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, February 12, 2009 12:12 AM Subject: tools for creating DAO, Gateway, Bean, etc CFCs So I've been reading a bunch of stuff about CFCs and I read in a few blog posts where people said something like ...if you're still writing your DAO CFC by hand..., implying that there was a tool to do this for you. Are there tools that help in writing CFCs? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 JVM Versions
It is possible for a thread to be completed but waiting on network I/O to complete transferring the response back to the client This can happen for very large files or a large HTML report over a slow connection. I don't know about Fusion Reactor, but SeeFusion has a time to first byte stat that tells you how long the request processed before the FIRST byte of data started being returned. Unless you are using cfflush your network delay is generally total request time minus time to first byte. Of course, this may not be your problem. Things like heavy garbage collection can cause a pause in your server. ~Brad - Original Message - From: Justin Scott jscott-li...@gravityfree.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, February 09, 2009 7:23 PM Subject: Re: CF7 JVM Versions we're seeing some requests that will appear to complete but the thread will stay open for 30-40 seconds before it finally closes out. FusionReactor shows them there in the running requests screen with no stack trace available (jvm reports it as finished). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maybe I need a SQL Service Consultant...
SQL Server 2000 (we don't have a lot of money and the licence was cheaper... but we are planning to upgrade sometime soon) Ok. 2000 doesn't give you near the info 2005 does, but it will give you quite a bit. First you need to keep an eye on when your performance spikes hit (which I think you're already doing) so you can try and get a handle on what is happening right then with the currently running requests. When a slow down starts, you need to get a snap shot of what was going on. First of all on your CF server. Grab a full stack trace. This is trivial with SeeFusion, and I assume Fusion Reactor as well. You can scan through it to look for patterns. Were multiple pages running the same query, etc? If Fusion Reactor allows you to log slow DB calls, turn that on with a threshhold low enough to log the stuff running at the time of the slow down. Now, for your SQL server. select * from master.dbo.sysprocesses http://msdn.microsoft.com/en-us/library/aa260456(SQL.80).aspx will return a record for every process on the SQL server. This will tell you where the server the request is coming from (the DB doesn't know the client's ip-- only the web servers') usually I filter out sleeping processes and order by CPU desc. Of course, if the problem is locks, then the cpu usage won't be high for the problem processes since they aren't doing anything but waiting. You can get the command the processes is running, but it is just basic info like select, update. Also in the sysprocesses table is the blocked column. It contains the spid of any processes which are blocking it. If select * from master.dbo.sysprocesses where blocked 0 returns a lot of records, you are dealing with a lot of locks. Often times one process will chain down and block a number of requests all blocking others... you've got to keep climbing the lock tree to see who's blocking who until you find a process who is blocking other processes, but not being blocked themselves: select * from master.dbo.sysprocesses p1 where blocked = 0 and spid in ( select blocked from master.dbo.sysprocesses p2 where blocked 0) I didn't test that, but I think it is right. If you have one processes blocking everyone else, then you need to pull out sp_lock which is a system proc that shows you all the locks that exist in the database right then. You might get a TON of records back, but you need to know which ones to worry about. The spid column tells you what spid is holding or waiting for the lock. Cross references this with sysprocesses. Lock are a course of their own. In general keep your eyes peeled for the following: A TON of RID locks for one process. This may indicate a table scan or an update to many records at a time TAB locks are a lock on an entire table FIL locks can show occaisionally while writing a large tranny log file to a slow disk Of course, the lock type has to be taken in conjuction with the lock mode: Shared locks are generally harmless, but it depends on your isolation level. Exclusive locks are the ones to look out for. Lock status tells you if the lock is aquired or still being waited for. The database id and object id are your key to finding what the object (usually a table) was being locked. select * from sysdatabases will give you the database ids use databasename object_name(object_id) If you want to make your life easier, google for sp_lock2 which a proc that looks up the object names for you. Your goal is to find the pattern of what sql statements/tables are the repeat offenders and which ones are creating a large number of locks or leaving locks open for a long time before committing them. If you are using transactions in your SQL you need to be careful how long you wait to commit those. This would be bad: begin transaction update table with(holdlock) set col = foo -- run database maintneance plan... commit transaction Once you know what statement is giving you problems, take it and run it in query analyzer to get the real execution plan (not the estimated one). Reading an execution plan is a whole topic of its own, but you want to find the slowest parts of it. Look for any table scans or extremely large amount of records being returned by one of the inner operations. An index seek is most always better than an index scan. If you are doing a large amount of reads and the data doesn't need to be transanctionally safe, use with(nolock) which sets the isolations level for that statement to read uncommitted. Make sure you are updating tables on an indexed key to avoid table scans which want to escalate to exlcusive table locks. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 110) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. This kind of error message has only happened 8 times
Re: How to stop auto translation?
I just realized that either sql JDBC driver or CF automatically translates symbols like into HTML code of lt; prior to saving the data into a database table. I've never seen CF or JDBC do this. If your HTML is being escaped, I would look for a stray htmleditformat function. Dump out the data immediately prior to inserting it into the database and see what it looks like then. Also, how are you looking at the data to confirm how it was saved? Tags like cfdump escape any html in the data for display purposes. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to stop auto translation?
I'm wondering if there's some regExp to convert all HTML code back to its orginial form. I'm sure there could be if you wanted. You've only got four characters to put back according to the docs: lt; gt; amp; quot; If your goal is to not have the HTML escaped in the first place, I would focus on finding out how/where it is getting that way in the first place. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about Discovering CFCs
Correct me if I'm wrong, but based on my initial reading of CFCs on the web, it seems like there are three ways of setting up constructor data: Is there a preferred method? The difference between code at the top of your component outside any methods (which gets ran on the component's creation) and a pseduo-constructor method like init() that you call yourself upon the creation of the component is that you can pass arguments into the init method. If your only initialization is something really basic like cfset variables.instance = structnew() then the init isn't really doing anything for you. If you want to pass data into the component upon its creation to aid in its initilization or population, you will want to use init() myPerson = createobject(component,person).init(firstName=Brad,lastName=Wood); Maybe I'm not understanding the goal of the init() method and to whom that data is supposed to be made available. Is it for the purpose of providing data to the newly created object or is it to initialize data for the other methods in the class.. or both? It can be for whatever you want. :) Both of those would be fine. - We can now call super.[method] to invoke methods on a superclass. seems simple enough. Don't have any near-future plans to call super methods just yet until I get my head wrapped around this :) You won't really until you start uning inheritance and want augment functionality provided through a base class. The most often place I use super. is in my init methods. If you are extending a class with an init method, you need to make sure the child init does a super.init() or the base class's init() won't be called. What's the difference between private and protected? Private is only available to methods in that component. Protected is available to any component in the same folder. In my opinion this assumes you are using the package set up where your components are in folders like /CFC/business/person/personBean.cfc /CFC/business/person/personService.cfc /CFC/business/person/personFoo.cfc Any of those components could access each other's protected methods. Someone correct me if I am wrong, but I do not believe ColdFusion provides a way to mark a variable as protected. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about Discovering CFCs
Brad, you're confusing protected with package. Package allows objects in the same package (folder) to access a variable. Protected means the variable is accessible by subclasses. Oops, you're right Brian. For some reason I'm confusing the two tonight. Thanks for the correction. I've been painting tonight, so I'll blame it on the fumes :) ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319035 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connection pooling - why bother?
Oh man, you fell for it. Now Jochem has all your datasource passwords. :) His plan for total world annihilation is one step closer now... ~Brad - Original Message - From: Jaime Metcher jaime.metc...@medeserv.com.au Sent to you off-list. Thanks for having a look. Jaime Could you grab the full settings from neo-datasource.xml so we can see what is configured there? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why is debugging info showing up in my ajax response?
1) Do you have coldfire installed? 2) What do you see when you hit the Ajax URL in your browser? 3) When you say at the top of the calling page do you mean the page that contains the jQuery javascript MAKING the ajax call, or do you mean in floor_duty.cfc which is RESPONDING to the ajax call. It's only going to do good if you are talking about the second one. Take a look at a CFAJAX call and you will see there is a URL parameter CF adds to make sure debugging is off. That could come in handy. ~Brad - Original Message - From: Rick Faircloth r...@whitestonemedia.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, January 27, 2009 5:42 PM Subject: Why is debugging info showing up in my ajax response? I have cfsetting showdebugoutput=false at the top of the calling page. My ajax json response is coming back fine, but below it, in firebug, is ColdFusion debugging code...why? What's triggering that? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connection pooling - why bother?
I don't know Oracle, but in SQL Server global temp tables are by design available to all connections. (##table_name) If you were using them, wouldn't you expect them to be shared? On the other hand, regular temp tables (#table_name) are per connection, but isn't it proper to drop them after usage if for no other reason than to not have them laying around later if a connection is reused? ~Brad - Original Message - From: Craigsell craigs...@charter.net To: cf-talk cf-talk@houseoffusion.com Sent: Friday, January 30, 2009 10:16 PM Subject: Re: Connection pooling - why bother? There is one other thing to consider in using connection pooling. I admit it is a bit off the beaten path but it bit me pretty good. I use Oracle stored procedures as much as I can. You cannot use connection pooling if your stored proc uses Global Temporary Tables. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Submitting larger data using cfajaxproxy: throwing error
Is there a CF error being thrown? (the CFC is not able to handle it) ~Brad - Original Message - From: dev losh devl...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, January 26, 2009 10:14 PM Subject: Submitting larger data using cfajaxproxy: throwing error Hi all, I'm submitting my form using cfajaxproxy(using remote method invocation). it is working fine with small data. my page is having a text area. if we give larger text say like 500 chars, the sumbit action is throwing javascript error. the CFC is not able to handle it. is there any solution for this issue ? please help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do I traverse XML using ColdFusion?
A web service is not like a CFC where you can cfdump it out and get all the methods. Those underlying methods you are seeing aren't going to help you at all. The actual methods you can call are documented in the WSDL itself. I glanced through it and holy cow it is long. Didn't the web service vendor provide some documentation on calling it? I must say I've never really passed authentication info via the header before. Chances are, you will need to use the AddSOAPRequestHeader function (http://livedocs.adobe.com/coldfusion/8/htmldocs/functions_a-b_03.html) I would try to fool around and get a working example, but I'm not too good at deciphering WSDL's and I don't have a username/pass anyway. ~Brad - Original Message - From: Chris Jordan chris.s.jor...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, January 23, 2009 5:36 PM Subject: Re: How do I traverse XML using ColdFusion? John, The stub methods I'm referring to are part of apache Axis which are part of some parent class that get's created when I do: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe Bolt anyone?
*Poison dart flies in the window to Eric's house striking him in the neck as he slumps lifelessly over his keyboard.* :) - Original Message - From: Eric Roberts ow...@threeravensconsulting.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, January 23, 2009 7:05 PM Subject: Re: Adobe Bolt anyone? That is incorrect...I am on the CF9 alpha...there is nothing to stop one from admitting they are on the alpha or the beta. Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf server for education
I believe you actually need to be teaching a class in ColdFusion to get the education license. If the school wants to build their site in CF, they will need to pay. If you are a student and just want to play around, just download the developer edition directly off the adobe website. It is restricted to 2 IP addresses and watermarks your PDFs. Other than that, it is a fully-functional enterprise install. ~Brad - Original Message - From: John Barrett barrjo...@yahoo.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, January 23, 2009 1:42 AM Subject: cf server for education Hi, I don't know where the best place to ask this on cf talk, so I try here. Has anybody used the free education server from adobe? I am working on a free site for the University of Hawaii(http://manoa.hawaii.edu/gotnutrients), I am also a student there. Are there any limits on this server, or do you just need to be a student. I am not sure if you need to use it for education, such as having it for classes, etc. Thanks so much, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Graceful Restart of Apache Causes JRun Connector Protocol Error
I dunno-- this seems pretty obvious to me, but if I understand you correctly you want to restart the Apache daemon WHILE it is serving a webpage? I don't think that is going to fly no matter how gracefully you do it. Perhaps if you explain for reasoning for this we can help. Are you trying to update the apache config and you want to restart in order for changes to take affect? ~Brad - Original Message - From: John G ciscoldfus...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, January 17, 2009 11:37 AM Subject: Graceful Restart of Apache Causes JRun Connector Protocol Error Hello, Can anyone shed some light on how I can get Apache to do a graceful restart without causing a JRun Connector Protocol error. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Beefing up authentication
Security works best in layers. In general my experience with salting is that it just makes it harder for the hacker. For instance, if you are using encryption with multiple iterations and salt; it just makes more pieces of information a hacker would have to get a hold of successfully decrypt it. Of course, hashes are a one-way street, but rainbow tables get much more difficult when you are salting a doing multiple hashes. Also, if your users might not be accessing your site over SSL. You can pass a salted encrypted version of the password over the wire along with the salt used. (CF Administrator does this). It's obfuscation at best, bit now our packet sniffing hacker has to have basic knowledge of your login screen (what algorithm to use etc) and be able to intercept multiple pieces of data from the request to put the puzzle back together. ~Brad - Original Message - From: msoul...@csulb.edu To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, January 14, 2009 8:41 PM Subject: Re: Beefing up authentication does salting a hashed password really make a difference? Is the goal such that if a hacker gets to the database they won't have the salt used to hash the pw making it more difficult to crack the pw? Just curious... Thanks, mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317972 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Beefing up authentication
So you can download a db of MD5 hashes of all 6 character strings with a character space of A-Za-z0-9 for instance. Usually you just by a hard drive pre loaded with the DB. $300 to $1000 will get you the fruit of months/years of someone else's work-- a database or series of databases ranging from GBs to TBs. I tried to create some rainbow tables of SHA-1 hashes once as an experiment. It was slow as heck, and I didn't get past 5 character alpha/numeric combinations before I already had 4 Gigs of data and it was growing exponentially. A 20 character salt of special characters like Judah suggested will generally put the number of possible hashes into the stratosphere and effectively rule out brute force. Social engineering is sadly MUCH easier. Have you ever called up your ISP to have them reset an account password only to hang up and realize they didn't ask you a shred of verification information? You can't overlook those kind of weak links either when it comes to security. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOAP XML Respone Example from CFC
http://www.w3schools.com/soap/soap_example.asp Is there a particular bit of information you are looking for? Also, let it be known that you can create and consume SOAP web services in ColdFusion without every having to know anything about the actual XML being passed back and forth. ~Brad - Original Message - From: Andy Ousterhout a...@omygoodness.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, January 08, 2009 8:22 PM Subject: SOAP XML Respone Example from CFC What does the SOAP XML Response document returned from a web services call to a CFC look like? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to fire off onBlur event for CFTEXTAREA
CF 8's rich text area uses the FCKEditor. A little digging in their docs
shows you how to do this. You must attach the event after the editor loads
like so:
cfform format=HTML name=test
cftextarea name=myfield richtext=Yes/cftextarea
/cfform
script LANGUAGE=JavaScript TYPE=text/javascript
function FCKeditor_OnComplete(editorInstance)
{
editorInstance.Events.AttachEvent( 'OnBlur', handleOnBlur ) ;
}
function handleOnBlur(editorInstance)
{
alert(editorInstance.Name + ' has blurred!');
}
/script
~Brad
- Original Message -
From: Alex Sorokorensky al...@gtree.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, January 08, 2009 8:33 PM
Subject: How to fire off onBlur event for CFTEXTAREA
CFTEXTAREA is great in CF8, but there seems to be a bug that the richtext
editor will not react to onBlur events. For a regular textarea it works
fine.
Can anyone figure out a workaround for this?
I just have a form with the 1 CFTEXTAREA field and want to submit it
onBlur.
-Alex
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317640
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Appending one file to another
This isn't a direct answer to your question, but if your process involves creating or concatenating a very large amount of strings you should look into Java's StringBuffer class (or StringBuilder depending on your JVM). They can dramatically help a ton of string manipulations. Also, using cfsavecontent will allow for the joining of many strings quickly without the performance problems, but that comes with its own problems. ~Brad - Original Message - From: Stephens, Larry V steph...@indiana.edu To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, January 01, 2009 3:44 PM Subject: Appending one file to another Can I use cffile to append one file to another? cffile action=append output=File2.txt file=File1.txt Doesn't seem to work. (This is assuming File2.txt is too large to store in a variable.) My problem is running data through a loop to convert HTML to rtf. The process times out after about 130 records, so I have to split the process into multiple attempts. I'd like to then put the finished product all together into one file. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is there a non-aggregate Max() function in MySQL?
Off the top of my head, you could use a case statement: select * from (select 1 as col1, 5 as col2 union select 5, 0 union select 3, 10 union select 8, 0 union select 6, 0) t order by case when col1 col2 then col1 else col2 end desc You could probably also write a SQL function in MySQL, but I haven't tried that yet. ~Brad - Original Message - From: Jim McAtee jmca...@mediaodyssey.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, December 13, 2008 9:26 PM Subject: Is there a non-aggregate Max() function in MySQL? I have a table with two columns containing min and max values minprice INT maxprice INT The max price may not be present and is set to zero when that's the case, so data might look like: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: locking session variables in cf8
To ditto what has already been said, but also to clarify: It is not necessary to lock your shared scope access for the purpose of not obtaining corrupted reads. i.e. process 1 attempts to read large session variable while session 2 is writing to it. ColdFusion will take care of that for you and won't let you read a shared variable that is currently in the process of being written. What is necessary though, is using locks to eliminate race-conditions in code. An example would be where process 1 needs to read from a session variable, perform some computations and read/write that variable again and it is mandatory that the value of the variable did not change since it was first read. A second process could have modified the contents of the session variable after the first process read it but before the second process accessed it again. If you are trying to prevent something like that, then you would probably want to use a lock. Another common idiom where locking is required is when you want to check for the existence of a shared variable (session/application/server), and if it is not there create it where the creation is a costly operation. A lock would prevent multiple processes from trying to instantiate the shared variable all at the same time. ~Brad - Original Message - From: j s [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, December 07, 2008 3:12 PM Subject: locking session variables in cf8 When creating session structures is it still necessary to cflock in cf8? I think i read somewhere that it was no longer needed but I was probably dreaming. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql query help
- Original Message - From: Jason Fisher [EMAIL PROTECTED] Cool, yeah I never remember until I do it when an aggregate query is going to want HAVING vs WHERE. Glad it's working for you! This bites me too when I'm not paying attention. Just remember that the WHERE applies to the records BEFORE the are grouped up and the HAVING applies to the grouped result set after the aggregates have been applied. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316384 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: INSERT INTO from another table
Sure, just explicitly list your columns. In fact, I would recommend ALWAYS doing that since if you script a table and the columns get into an different order it will really screw up your insert into table select * stuff. Just do this: INSERT INTO backup_name (col1,col2,col3,timestamp) (SELECT col1,col2,col3,getdate() FROM source_table WHERE col1 = 'filtervalue') ~Brad - Original Message - From: Dan LeGate [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, December 04, 2008 2:50 AM Subject: INSERT INTO from another table Was just reading how to do an INSERT INTO from another table in SQL Server 2000 (like SELECT INTO, but without creating a new table) like this: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I do not understand SeeStack at all
Barney has a good point that Eclipse's debugger can be used to inspect your server's threads even if CF isn't responding. Here are some basic steps to connect Eclipse debugger to CF that I wrote up for a blog post once: I added the following lines to my JVM startup args: -Xdebug -Xrunjdwp:transport=dt_socket,address=28000, server=y, suspend=n This tells the JVM to start in debug mode and listen on port 28000 for a debugger to connect. suspend=n tells the JVM NOT to suspend until the debugger connects. The port number is arbitrary, just make sure it's not already in use by something. Then I placed Eclipse in the Debug perspective, and chose Run Debug... Remote Java Application. I entered the address of my server for host and 28000 for the port number and then clicked Debug. This connected to my ColdFusion server's JVM and brought up all the threads in its existance. ~Brad - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, December 03, 2008 1:50 AM Subject: Re: I do not understand SeeStack at all You running the standalone version of CF, or are you in JEE mode? If the latter, launch the container in debug mode from Eclipse. Or if that's not possible, set up the java debugging port on the JVM, launch it normally, and connect to it with Eclipse. You can easily browse through all the threads stacks, as well as easily identify hung threads (and what they got hung on). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why is my CF8 server constantly hanging?
When jrun is doing the 100% thing, look at the currently running requests in fusion-reactor. How many are there? How long have they been running? What are they doing? (stack trace) I'm more familiar with seefusion than reactor, but the stack trace has the stuff you are the most about on the top. It should give you the cf file being executed and the line number. It sounds like you might have an endless loop or something. ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, December 03, 2008 12:07 AM Subject: Why is my CF8 server constantly hanging? Hi, I give up. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why is my CF8 server constantly hanging?
I'm not sure about fusion-reactor, but the product SeeFusion does a pretty good job of staying de-coupled from Jrun and CF. Usually it will respond up until the JVM dies. Perhaps fusion reactor has a feature similar to seefusion's active monitor rules. you can have triggers shoot you an e-mail that show you all the running request and a stack dump at the time the server is slowing down. A full thread dump of your JVM can be a little crazy. Just stick to the threads named jrrp-xx (I think) Those are the threads related to actual web requests. Most of the threads won't be doing anything. The ones you are about are the ones processing files. That is most helpful at a time like yours is to see specifically what requests are running and exactly what those specific requests are doing. That will help you narrow down all the stack trace stuff. IF you have something like an endless loop, you will see the threads stuck on the same like of code over and over as you pull a stack trace. The trick to reading a full thread dump is usually just looking for patterns. Anytime you repeatedly see a file/function coming up during your thread dump that is a sign you need to inspect what that code is doing. Please paste a dump from a single thread that you don't know how to read and we will point out the important pieces. ~Brad - Original Message - From: Philip Kaplan [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, December 03, 2008 12:31 AM Subject: Re: Why is my CF8 server constantly hanging? When jrun is doing the 100% thing, look at the currently running requests in fusion-reactor Usually when Jrun is doing its 100% thing, FusionReactor won't load. I suppose the server is hogged. But there are never more than 12 requests running at a time (that's the max I set). How long have they been running? Whatever requests are running during the 100% thing, will continue to run forever until the server (or process) is restarted. What are they doing? (stack trace) I admit I don't really know how to effectively read a stack trace. There's a ton of stuff in there. Would it be useful or annoying if I pasted one to cf-talk, next time it happens? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why is my CF8 server constantly hanging?
I look forward to another crash so I can use the SeeStack tool :-] You don't have to wait for a crash-- just pull some thread dumps of long running processes when your server is under load (or just any time really) and play around with looking through the stack to see what that process was doing. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
