RE: [ACFUG Discuss] Disabling CF Extras
What about non-windows platforms? :) Thanks. mf -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Tuesday, July 12, 2011 11:45 AM Eastern Standard Time To: discussion@acfug.org Subject:Re: [ACFUG Discuss] Disabling CF Extras There all run as separate services. Assuming windows - usually I go into the Services panel and set anything I am not using (ie: the .NET stuff, Verity) and set it to start manually. This way you can always turn it back on if you need it but it's not running all the time. If running in multi-instance mode, I also switch the JRun Admin instance to start manually. There are no security or performance issues that I know of by turning these off. Just remember they are off when you try to use some Verity code and nothing works. -Cameron On Tue, Jul 12, 2011 at 10:39 AM, Mark Fennell fenn...@armc.org wrote: Greetings, I was looking over our server and it's various processes looking for opportunities to improve performance. The server isn't slow and we're not currently experiencing any problems, but I noticed things like Verity, FlexAssembler and .NET are running. Among other things, we don't use these features of CF. Normally, if we don't use something, we like to turn it off just to reduce any overhead and as a matter of general security. So, I have two questions. 1) can individual features of CF be dis/enabled? 2) are there any performance or security or other reasons why one shouldn't dis/enable said features? Thank you for your input. mf -- mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. Furthermore, the opinions and thoughts expressed herein do NOT represent the policies or opinions of Athens Regional Health Services, Inc. (ARHS). ARHS is NOT responsible for the thoughts and opinions expressed in this communication. -- - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitter http://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985
RE: [ACFUG Discuss] Disabling CF Extras
What about non-windows platforms? :) Thanks. mf -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Tuesday, July 12, 2011 11:45 AM Eastern Standard Time To: discussion@acfug.org Subject:Re: [ACFUG Discuss] Disabling CF Extras There all run as separate services. Assuming windows - usually I go into the Services panel and set anything I am not using (ie: the .NET stuff, Verity) and set it to start manually. This way you can always turn it back on if you need it but it's not running all the time. If running in multi-instance mode, I also switch the JRun Admin instance to start manually. There are no security or performance issues that I know of by turning these off. Just remember they are off when you try to use some Verity code and nothing works. -Cameron On Tue, Jul 12, 2011 at 10:39 AM, Mark Fennell fenn...@armc.org wrote: Greetings, I was looking over our server and it's various processes looking for opportunities to improve performance. The server isn't slow and we're not currently experiencing any problems, but I noticed things like Verity, FlexAssembler and .NET are running. Among other things, we don't use these features of CF. Normally, if we don't use something, we like to turn it off just to reduce any overhead and as a matter of general security. So, I have two questions. 1) can individual features of CF be dis/enabled? 2) are there any performance or security or other reasons why one shouldn't dis/enable said features? Thank you for your input. mf -- mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. Furthermore, the opinions and thoughts expressed herein do NOT represent the policies or opinions of Athens Regional Health Services, Inc. (ARHS). ARHS is NOT responsible for the thoughts and opinions expressed in this communication. -- - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitter http://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985
RE: [ACFUG Discuss] ColdFusion Datasource to MySQL over SSH tunnel on windows
It might be more trouble than it's worth but you might could use CygWin to maintain the tunnel. Since cygwin runs as a service, the tunnel could be init'd as part of the cygwin process. I know Cygwin has an sshd module that might help. Just a thought. mf mark fennell athens regional medical center athens, ga - This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. - -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mike Staver Sent: Wednesday, October 13, 2010 3:44 PM Cc: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion Datasource to MySQL over SSH tunnel on windows I think I found a little tutorial that I just used to set this up: http://realprogrammers.com/how_to/set_up_an_ssh_tunnel_with_putty.html I'm a little bummed I can't just have this fire up with windows automagically, but this will do for now. Thanks again Frank and Steve. On 10/13/2010 12:24 PM, Frank Moorman wrote: Assuming that you have the ssh daemon running already on your MySql/Linux box... Download and install PuTTY. http://www.putty.org/ You can then create a tunnel in Putty and tell it which ports to forward. (in this case, 3306) It is fairly easy, I can help some more if you have questions about it. Personally I use a linux client to connect to cygwin SSH on a windows server, but I have instructed the non-techie owner of the website how to use Putty to connect from his own windows PC. Once Putty is installed and is running you can connect with the normal MySql Query Browser/Admin tools. You just replace the server IP with 127.0.0.1 in order to utilize the forwarding provided by Putty. --Frank On 10/13/2010 12:56 PM, Mike Staver wrote: I'm trying to set up a remote dev instance for one of my applications, and what I would like to do is have it connect to my mysql instance on a linux box I run. I don't plan on opening up port 3306 to the outside world for obvious reasons, and I shouldn't need to if I'm correct in my thinking here. Currently, I use Navicat to connect to the DB over an SSH tunnel and it works great. I'm not entirely sure how Navicat does this behind the scenes, and I'd love to know how to duplicate this on both windows and Mac OS Has anyone done this before? On the Mac or Linux side, I would imagine you'd just set up some kind of port forwarding that would do this for you. I'm very unsure of how that would work on windows. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] ColdFu...I mean Homesite is dead!
My uncontrollable sobbing has begun. -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org]on Behalf Of Douglas Knudsen Sent: Saturday, July 04, 2009 12:34 PM To: discussion@acfug.org Subject: [ACFUG Discuss] ColdFu...I mean Homesite is dead! http://www.adobe.com/products/homesite/ Seems like Homesite is getting the boot for good now. Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] NEVERMIND RE: CF in the database?
I figured it out, but if you have a more elegant solution, I'm open to suggestions. Here's my current solution. cfquery name=myQuery datasource=dataSource select myText from welcome_statements /cfquery cfoutput#evaluate(#de(myQuery.myText)#)#/cfoutput Thanks. mf -Original Message- From: Fennell, Mark P. Sent: Tuesday, June 30, 2009 4:57 PM To: 'discussion@acfug.org' Subject: CF in the database? Greetings all, I'm trying to figure out a way in CF7 to store CF variables in the database to be selected out later and evaluated just like regular CF variables. For example, and I know this is a stupid example, but it's simple and makes the point, let's assume I have a database table called welcome_statements and it has a single column that contains string data such as Welcome, #cookie.user_name#. In my home.cfm file, I write a query like select my_text from welcome_statements and have a CFOUTPUT block like cfoutout#myQuery.my_text#/cfoutput. I've tried using various combinations of evaluate() and de() and replacing the # in the database with something that is replaced on evaluation in the query and in the cfoutput. All to no avail. I know you're wondering, Why would you want to do a fool thing like that? Well, I'm trying to figure out how to allow users to write form letters or MS Word-like mail-merge documents. I imagine it would be simpler in CF than to write some manner of database function/procedure which is why I'm asking for your assistance. Many thanks in advance. mf mark fennell athens regional medical center athens, ga --- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. --- - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] CF in the database?
Greetings all, I'm trying to figure out a way in CF7 to store CF variables in the database to be selected out later and evaluated just like regular CF variables. For example, and I know this is a stupid example, but it's simple and makes the point, let's assume I have a database table called welcome_statements and it has a single column that contains string data such as Welcome, #cookie.user_name#. In my home.cfm file, I write a query like select my_text from welcome_statements and have a CFOUTPUT block like cfoutout#myQuery.my_text#/cfoutput. I've tried using various combinations of evaluate() and de() and replacing the # in the database with something that is replaced on evaluation in the query and in the cfoutput. All to no avail. I know you're wondering, Why would you want to do a fool thing like that? Well, I'm trying to figure out how to allow users to write form letters or MS Word-like mail-merge documents. I imagine it would be simpler in CF than to write some manner of database function/procedure which is why I'm asking for your assistance. Many thanks in advance. mf mark fennell athens regional medical center athens, ga --- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. --- - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] NEVERMIND RE: CF in the database?
Thank you all very much for your suggestions, however, I'm afraid I didn't fully explain the complexity of the situation. See, I'll need to select the text of the form letter that contains the CF variables which will reference other queries on the same page. So, for example, let's say we're going to be generating Happy Birthday letters for employees at the beginning of each month and the letters will be printed and stored in the database or on the file system. So, we'll need queries for the letter text and the person's name, address, DOB and maybe some tidbits from other tables like the employee's department and job title. So, we'll have a select statement to find all the peeps with upcoming DOBs. We'll also have a select statement to retrieve the text of the letter. Then we'll cfoutput the dob query into the letter with some CSS to separate pages. I'm going to knock out the code today or tomorrow and will share my eventual solution here. But, I do appreciate your input and advice. Thank you! mf -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org]on Behalf Of Wes Byrd Sent: Wednesday, July 01, 2009 9:53 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] NEVERMIND RE: CF in the database? Mark, I use to do something very similar to what you are doing. I once thought it was very handy to store CF code into the DB and then evaluate it. Fun stuff! However, not so fun for your server. I would advise against this if you are looping over a record set. As a rule, I would stay away from using evaluate() inside a loop... or from using it at all unless you have to. Doug's suggestion below is a good solution. But, you don't really have to add the function to make it happen (though I agree with Doug and like the function based solution). You could simply change the code in your database (replace the #cookie.username# with $:1) and then slightly modify your output loop... like this: cfquery name=myQuery datasource=dataSource select myText from welcome_statements /cfquery cfoutput#replace(myQuery.myText, $:1, cookie.username)#/cfoutput This is much more efficient that using evaluate(). Hope that is helpful. salute Wes _ From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Douglas Knudsen Sent: Wednesday, July 01, 2009 9:23 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] NEVERMIND RE: CF in the database? Another approach is using replace(). SO in your DB store Welcome $:1 to the end of the Internet Then use a function call to wrap things fetchWelcomeText( cookie.username ) fetchWelcomeText() would look something like cfquery name=myQuery datasource=dataSource select myText from welcome_statements /cfquery cfreturn replace( myQuery.myText, $:1, arguments.username ) / This approach is a bit more flexible, you can say easily switch between cookies and sessions or spit out the same text for some other name. Douglas Knudsen http://www.cubicleman.com this is my signature, like it? On Tue, Jun 30, 2009 at 5:07 PM, Fennell, Mark P. fenn...@armc.org wrote: I figured it out, but if you have a more elegant solution, I'm open to suggestions. Here's my current solution. cfquery name=myQuery datasource=dataSource select myText from welcome_statements /cfquery cfoutput#evaluate(#de(myQuery.myText)#)#/cfoutput Thanks. mf -Original Message- From: Fennell, Mark P. Sent: Tuesday, June 30, 2009 4:57 PM To: ' discussion@acfug.org' Subject: CF in the database? Greetings all, I'm trying to figure out a way in CF7 to store CF variables in the database to be selected out later and evaluated just like regular CF variables. For example, and I know this is a stupid example, but it's simple and makes the point, let's assume I have a database table called welcome_statements and it has a single column that contains string data such as Welcome, #cookie.user_name#. In my home.cfm file, I write a query like select my_text from welcome_statements and have a CFOUTPUT block like cfoutout#myQuery.my_text#/cfoutput. I've tried using various combinations of evaluate() and de() and replacing the # in the database with something that is replaced on evaluation in the query and in the cfoutput. All to no avail. I know you're wondering, Why would you want to do a fool thing like that? Well, I'm trying to figure out how to allow users to write form letters or MS Word-like mail-merge documents. I imagine it would be simpler in CF than to write some manner of database function/procedure which is why I'm asking for your assistance. Many thanks in advance. mf mark fennell athens regional medical center athens, ga --- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named
RE: [ACFUG Discuss] Connecting to iSeries DB2
We are using the stock IBM DB2 UDB driver that shipped with MX7. It took a DB2 network specialist to figure it out, but under the Advanced Settings in the connection string, we had to enter the locationName and noprompt attributes like this locationName=ARMC;noprompt=true but without the quotes and we connected to port 446. I think the locationName is the DB name, kind of like master on SQL server or the SID in Oracle. Prior to figuring that out, we used the JTOpen jdbc driver. hth mf ps. this is on a FC7 x86 system running CFMX 7,0,0,91690 Enterprise. -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org]on Behalf Of Andrew Powell Sent: Thursday, May 21, 2009 2:32 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Connecting to iSeries DB2 I believe there are third party JDBC drivers for this. ap On May 21, 2009, at 2:27 PM, Kevin Hellriegel wrote: Does anyone have any experience connecting to a DB2 database on an AS400 with ColdFusion MX 7? If I use the example on livedocs: http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=1747.htm#1277913 I get an error: java.sql.SQLException: No suitable driver I'm assuming I need a different connector or maybe I am leaving a parameter out? Any help would be greatly appreciated. Kevin - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Update graph without refresh
There's also a handy YahooUI tool for this. http://developer.yahoo.com/yui/charts/ -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org]on Behalf Of Tepfer, Seth Sent: Friday, April 10, 2009 11:07 AM To: discussion@acfug.org Cc: ad...@acfug.org Subject: RE: [ACFUG Discuss] Update graph without refresh Thanks Brooks - good idea. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of brooks.wil...@atl.frb.org Why not put the graph in an Iframe and then use javascript to refresh it every so many seconds on a timer? You would set a timer - when it expired do a window.location=blah.cfm and reset the timer. To Teddy and all - I'm sorry my Outlook client keeps making it difficult for folks to read my posting. Here's the posting again: --- I'm new to AJAX and CF8. I've got a graph that is monitoring a small set of data (0-60 rows). I want to have a graph that automatically updates - without using constant refreshes. Is this possible? I assume AJAX is how I'd do this. If AJAX - how would I do it in AJAX If this answer is out there tell me what search terms to use! Thanks --- This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments). - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Switch to CF8
It might be faster and less painful to use an FTP client to transfer files since ftp is the file transfer protocol. ;) mf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Justin Haygood Sent: Monday, October 27, 2008 1:39 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Switch to CF8 IE can only upload files up to 2 GB or 4 GB (one of the two...) anything smaller should work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Forrest C. Gilmore Sent: Friday, October 24, 2008 9:04 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Switch to CF8 The thing that has me stumped about the upload, and seems to point to an issue with IE, is that Mozilla uploads the large file, using the exact same CF pages, that have no browser-specific code, without any problem. Forrest C. Gilmore -- Shane Heasley wrote: CF7 and earlier have to load the entire file into memory when doing uploads - so with large files you can run into heap problems. CF8 uses a different method. It was possibly coincidence that you only noticed the problem using IE? Moving to 8 might solve the problem. Cheers, www.CTek-Media.com To deal with my upload issue, my ISP wants to switch my site from CF7 to CF8. I am inclined to do so. Are there any Gotcha's I need to be aware of? Forrest C. Gilmore - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Oracle + JDBC
is cf in a jrun cluster? is oracle in a rac cluster? what versions? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Childress Sent: Wednesday, June 18, 2008 3:52 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Oracle + JDBC Anyone out there have good experience configuring some of the more advanced JDBC options for a CF - Oracle Cluster connection? ...and the time to help out with it? (and get paid for your time) Email me @ [EMAIL PROTECTED] -Cameron -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Purchasing CF8 upgrade
Does anyone have any leads on purchasing a CF8 EE upgrade from CF7 EE for Linux for less than the msrp of $3750? Thanks much. mf mark fennell athens regional medical center athens, ga - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Need example - XML Import/parse help - 3 questions about sample data
Is there no way to normalize (if that's the right term) the XML? Granted, you'd have to be the one generating the XML, but it would sure be nice to have rm:image1, rm:image2, etc. That would also give you the ability to have descriptions for each of the images. Barring that, and this isn't what you asked for, but I wonder if you could read the file and write a new file and for each rm:image change the name to rm:image#x# where x is some loop index value? Just random thoughts. I'll see if I can spawn an example for you. :) mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrick Peavy Sent: Wednesday, June 11, 2008 4:11 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Need example - XML Import/parse help - 3 questions about sample data Steven, thank you. I did go through the W3School article after you sent it as well as skimming the doc that Charlie sent. I actually use that site a lot. With your help, I solved the two small problems, but the problem with duplicate children still plagues me. At this point, i am back to my original question with perhaps a more direct approach--- Can someone provide an example of accessing the data within an XML file wherein a parent element has several exactly named children. I still have not found the answer within the documents or on line. I appreciate the documentation that folks are sending - but I also learn about, oh I don't know, maybe 1000X faster by seeing actual code. But, that's just me. Example code, demonstrating my problem feed entry titleA sample XML Child of entry element/title link href=http://www.someplace.com;/link summaryLooks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. /summary rm:id852/rm:Id rm:imagehttp://www.someplace.com/img/user/442/852/4551594.jpg/rm:imag e rm:imagehttp://www.someplace.com/img/user/442/852/4551594a.jpg/rm:ima ge rm:imagehttp://www.someplace.com/img/user/442/852/4551594b.jpg/rm:ima ge rm:imagehttp://www.someplace.com/img/user/442/852/4551594c.jpg/rm:ima ge rm:imagehttp://www.someplace.com/img/user/442/852/4551594d.jpg/rm:ima ge /entry /feed And parsing that type of structure into an array is no problem EXPECT where the image is concerned. The following example works except for the last array element [4]. If it worked, it would at least insert the first instance of the rm:image child element. But nothing seems to work. cfscript selectedElements = XmlSearch(XmlParse(trim(cfhttp.fileContent)), /feed/entry/); for (i = 1; i LTE ArrayLen(selectedElements); i = i + 1) arrayImport[i][1] = selectedElements[i].summary.XmlText; for (i = 1; i LTE ArrayLen(selectedElements); i = i + 1) arrayImport[i][2] = selectedElements[i].link.XmlAttributes.href; for (i = 1; i LTE ArrayLen(selectedElements); i = i + 1) arrayImport[i][3] = selectedElements[i][rm:id].XmlText; for (i = 1; i LTE ArrayLen(selectedElements); i = i + 1) arrayImport[i][4] = selectedElements[i][rm:image].XmlText; /cfscript So, documents and tutorials are always useful and appreciated, but after 6 hours on this today, I think I would understand the problem and solution much, much faster if someone out there had an actual example to point to. Thanks! _ Derrick Peavy 404-786-5036 Sales and Web Services CollegeClassifieds.com http://www.collegeclassifieds.com A Service of Universal Advertising, inc. ___ On Jun 11, 2008, at 1:32 PM, Steven Ross wrote: I also recommend using the w3c xpath tutorial when i forget syntax I always look there first... http://www.w3schools.com/XPath/default.asp On Wed, Jun 11, 2008 at 11:53 AM, Charlie Arehart [EMAIL PROTECTED] wrote: Derrick, besides Steven's useful replies to you so far, since you said you were green with CF/XML processing, I can't recommend highly enough that you spend 30 minutes reading this wonderful guide: Utilizing XML and XSLT in ColdFusion MX http://www.adobe.com/devnet/coldfusion/articles/xmlxslt.pdf Sure, it's 6 years old, and written for CF 6, but it's a classic and all the info still applies. Just the best intro to the whole subject I ever saw. Lots of examples, no presumption of your knowing anything about XML, XSLT, XPATH, yet by the end of it's 30 pages you'll understand it all well enough to do nearly anything you'd need. And, yes, it explains all those CFML variables, structures, and functions you need to understand in order to process XML with CFML. I honestly wouldn't propose to try to help someone with a question on the subject without strongly urging them to read it first. It's that good, and thorough, and does a better
RE: [ACFUG Discuss] Need example - XML Import/parse help - 3 questions about sample data
I couldn't agree with you more. I can't tell you the number of vendors who fail to grasp the concepts and importance of primary and foreign keys in databases. I think the right way is often detoured by someone doing it the wrong way upstream... Hence the old addage, if you want something done right, do it yourself. :) Try this example. It's not perfect, but it should get you started. I think. Dump it in a file and run it. mf !--- this is a file called xml_test.cfm --- cfif isDefined(url.xml) cfcontent type=text/xml reset=true feed entry titleA sample XML Child of entry element/title link href=http://www.someplace.com; / summaryLooks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. /summary rm:id852/rm:id rm:imagehttp://www.someplace.com/img/user/442/852/4551594.jpg/rm:imag e rm:imagehttp://www.someplace.com/img/user/442/852/4551594a.jpg/rm:ima ge rm:imagehttp://www.someplace.com/img/user/442/852/4551594b.jpg/rm:ima ge rm:imagehttp://www.someplace.com/img/user/442/852/4551594c.jpg/rm:ima ge rm:imagehttp://www.someplace.com/img/user/442/852/4551594d.jpg/rm:ima ge /entry /feed cfabort /cfif cfhttp url=http://iandev/ian/mf/xml_test.cfm?xml; method=GET/cfhttp cfset xm = replace(cfhttp.fileContent,'rm:','rm','all') cfscript selectedElements = XmlSearch(XmlParse(trim(xm)), /feed/entry/); txt1 = selectedElements[1][rmimage][1].XmlText; txt2 = selectedElements[1][rmimage][2].XmlText; /cfscript cfoutput First Child = #txt1#br Second Child = #txt2#br /cfoutput cfdump var=#selectedElements# !--- end this is a file called xml_test.cfm --- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrick Peavy Sent: Wednesday, June 11, 2008 4:39 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Need example - XML Import/parse help - 3 questions about sample data Mark: Thank you! Yes, to all of that, I can do that, have done it. May resort to that. But it's not the right way and I am trying hard to learn the finer points of this. The problem is simply that I can't find an example and even thinking outside the box seems to be of no use in solving the problem. It makes me wonder, either the developers who do this in any language keep the finer points to themselves, or there is a whole lot of unnecessary re-writing and parsing of XML files going on across the web - which defeats the whole point. Just my thoughts. _ Derrick Peavy 404-786-5036 Sales and Web Services CollegeClassifieds.com http://www.collegeclassifieds.com A Service of Universal Advertising, inc. ___ On Jun 11, 2008, at 4:21 PM, Fennell, Mark P. wrote: Is there no way to normalize (if that's the right term) the XML? Granted, you'd have to be the one generating the XML, but it would sure be nice to have rm:image1, rm:image2, etc. That would also give you the ability to have descriptions for each of the images. Barring that, and this isn't what you asked for, but I wonder if you could read the file and write a new file and for each rm:image change the name to rm:image#x# where x is some loop index value? Just random thoughts. I'll see if I can spawn an example for you. :) mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrick Peavy Sent: Wednesday, June 11, 2008 4:11 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Need example - XML Import/parse help - 3 questions about sample data Steven, thank you. I did go through the W3School article after you sent it as well as skimming the doc that Charlie sent. I actually use that site a lot. With your help, I solved the two small problems, but the problem with duplicate children still plagues me. At this point, i am back to my original question with perhaps a more direct approach--- Can someone provide an example of accessing the data within an XML file wherein a parent element has several exactly named children. I still have not found the answer within the documents or on line. I appreciate the documentation that folks are sending - but I also learn about, oh I don't know, maybe 1000X faster by seeing actual code. But, that's just me. Example code, demonstrating my problem feed entry titleA sample XML Child of entry element/title link href=http://www.someplace.com;/link summaryLooks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. Looks like greek to me. /summary rm:id852/rm:Id rm:imagehttp://www.someplace.com/img/user/442/852/4551594.jpg/rm:imag e rm:imagehttp://www.someplace.com/img/user/442/852/4551594a.jpg/rm:ima ge
RE: [ACFUG Discuss] Speed and resources: better to do client or session var?
From my experience anything will be faster than a cookie. mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Tuesday, May 27, 2008 9:57 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Speed and resources: better to do client or session var? I'd look at what you need to solve here: do you really need client vars or session vars? performance wise, session vars would be faster as they are in RAM where you have your client vars set to use a DB. A DB lookup is going to be slower than RAM. DK On Tue, May 27, 2008 at 9:05 AM, Derrick Peavy [EMAIL PROTECTED] wrote: Probably discussed to death 10 years ago, 5 years ago, one day ago. I don't know. Can't find definitive answers. Wondering... Does anyone think or dare I ask does anyone know if one type of variable structure is faster or less resource intensive than another? In particular, I have an app where I am using client variables for a lot of very simple integer values. I could just as easily use session. The client storage option is a database and so, the larger the number of client variables in the app, and the larger the number of users (visitors), then the larger that database becomes. Again, these are simple values such as one char text values, 1-8 digit integers, etc., Nothing complex. So, does anyone have strong feelings as to which structure would be better for purposes of speed (overall page load), and system resources - larger database for client variables versus more memory used for session? _ Derrick Peavy Sales and Web Services CollegeClassifieds.com http://www.collegeclassifieds.com A Service of Universal Advertising, inc. ___ -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Anyone ever have this cfinput or cfselect validation issue?
Have you tried it in a different browser? It seems to work fine in IE7
and FF.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard
Sent: Thursday, March 27, 2008 4:13 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Anyone ever have this cfinput or cfselect
validation issue?
Ok, I created a very simple form and I am getting the exact same error
on the same line number. I've written my own js validation at this
point but I would like to solve this issue if at all possible.
CF code:
cfform name=test action=#CGI.SCRIPT_NAME#
CFINPUT type=TEXT name=texttest required=yes message=text
test!
INPUT type=submit
/cfform
View Source code:
script type=text/javascript src=/CFIDE/scripts/cfform.js/script
script type=text/javascript src=/CFIDE/scripts/masks.js/script
script type=text/javascript
!--
function _CF_checktest(_CF_this)
{
//reset on submit
_CF_error_exists = false;
_CF_error_messages = new Array();
_CF_error_fields = new Object();
_CF_FirstErrorField = null;
//form element texttest required check
if( !_CF_hasValue(_CF_this['texttest'], TEXT, false ) )
{
_CF_onError(_CF_this, texttest,
_CF_this['texttest'].value, text test!);
_CF_error_exists = true;
}
//display error messages and return success
if( _CF_error_exists )
{
if( _CF_error_messages.length 0 )
{
// show alert() message
_CF_onErrorAlert(_CF_error_messages);
// set focus to first form error, if the field supports
js focus().
if( _CF_this[_CF_FirstErrorField].type == text )
{ _CF_this[_CF_FirstErrorField].focus(); }
}
return false;
}else {
return true;
}
}
//--
/script
On Thu, Mar 27, 2008 at 3:47 PM, Mischa Uppelschoten ext 10
[EMAIL PROTECTED] wrote:
Yes, I've had that and IIRC it had something to do with my own
form validation that I added. Have you tried a CFFORM/CFINPUT on a
virgin page without any added js?
: I am coding a form and trying to use the built in CF(MX 7)
validations to the
: CFINPUT and CFSELECT tags.
:
: When I submitthe form, the js that CF writes is throwing
errors (Object
: expected). The fucntionality is something Ive used before
and did not have
: this problem.
:
: I was trying to validate email format and that something was
selected.
:
: Any ideas?
:
:
: -
: Annual Sponsor - Figleaf Software
:
: To unsubscribe from this list, manage your profile @
: http://www.acfug.org?fa=login.edituserform
http://www.acfug.org/?fa=login.edituserform
:
: For more info, see http://www.acfug.org/mailinglists
http://www.acfug.org/mailinglists
: Archive @ http://www.mail-archive.com/discussion%40acfug.org/
http://www.mail-archive.com/discussion%40acfug.org/
: List hosted by FusionLink
: -
Mischa Uppelschoten
The Banker's Exchange, LLC.
4200 Highlands Parkway SE
Suite A
Smyrna, GA 30082-5198
Phone:(404) 605-0100 ext. 10
Fax:(404) 355-7930
Web:www.BankersX.com http://www.bankersx.com/
Follow this link for Instant Web Chat:
http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
--- Original Message ---
From: Jeff Howard [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
To: discussion@acfug.org mailto:discussion@acfug.org
Date: Thu, 27 Mar 2008 14:48:23 -0400
Subject: [ACFUG Discuss] Anyone ever have this cfinput or
cfselect validation issue?
I am coding a form and trying to use the built in CF(MX 7)
validations to the CFINPUT and CFSELECT tags.
When I submit the form, the js that CF writes is throwing errors
(Object expected). The fucntionality is something I've used before and
did not have this problem.
I was trying to validate email format and that something was
selected.
Any ideas?
-
Annual Sponsor - Figleaf Software http://www.figleaf.com/
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
http://www.acfug.org/?fa=login.edituserform
For more info,
RE: [ACFUG Discuss] looking for opinions on duplicate form submissions
A couple of things spring to my mind that don't involve ajax. 1. Accept the form and then prompt for the upload. It adds a separate page but it reduces your duplication. 2. Accept the uploaded document. Yep, save it to your server and if the data turns out to be a duplicate entry, action=DELETE 3. Use the CFID or jsessionid as the name of the uploaded file and allow files to be overwritten. nameconflict=OVERWRITE mf mark fennell athens regional medical center athens, ga From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Thursday, March 20, 2008 10:52 AM To: discussion@acfug.org Subject: [ACFUG Discuss] looking for opinions on duplicate form submissions I'm working on an application where a form is submitted along with various attachments (doc, pdf, xls, etc). Apparently users are submitting the same request several times and I've been asked to address this issue. At first thought, it seemed quick and simple to me, but as I've started working on it I can't decide exactly how to handle the attachments in associated with the form in the most efficient way. That brings me here. I was looking for suggestions on how to handle the attachments while I run validation on the db to see if the input from the form already exists in the db. It seems like something that would be perfect for AJAX to handle, but my AJAX skills are virtually nonexistent. So, without using AJAX (or if you can break it down using AJAX for a novice) how would you handle the situation? The main issue I'm having, is that if I do the validation after the form submission, CF is assigning a temp directory to my attachment file. So what is submitted as this: C:\Documents and Settings\JHoward\Desktop\PO Request mods.doc ends up as this after submission and validation: C:\ColdFusion8\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\n eotmp13963.tmp and then when I pass it to the CFFILE, it tells me the file doesn't exist. I'm really just looking at the different ways other people would handle this situation to try and decide so any input would be great. Thanks in advance. Jeff - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] looking for opinions on duplicate form submissions
Another thought... I don't know about Windows, but on *nix machines you could use diff to compare files and if they are identical, just toss one. Assuming you know which files to compare... From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Thursday, March 20, 2008 11:16 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions I'm one of those users. NoScript is a very good extension if you want to know what marketing companies and other unsavory types are harvesting your surfing habits to target advertising. I enable scripting on a whitelist of trusted sites only. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Great spirits have often encountered violent opposition from weak minds. --Einstein On Mar 20, 2008, at 11:10 AM, Douglas Knudsen wrote: My first thought is...disable the submit button after its mashed once. My second thought is, some people disable JavaScript. Now, what type of user disables JavaScript? Would that type of user go 'mash the button crazy', does it really matter then? If so, could use Flash(read Flex). Aside from that, maybe some sort of random key deal that you could test server side, if the key is inprocess, do nothing, ow process. But the upload issue might still be there as this occurs before your CFM processing does. I might re-factor the UI putting document uploads on a separate view from the data input. hope the rambling helps... :) DK On Thu, Mar 20, 2008 at 10:51 AM, Jeff Howard [EMAIL PROTECTED] wrote: I'm working on an application where a form is submitted along with various attachments (doc, pdf, xls, etc). Apparently users are submitting the same request several times and I've been asked to address this issue. At first thought, it seemed quick and simple to me, but as I've started working on it I can't decide exactly how to handle the attachments in associated with the form in the most efficient way. That brings me here. I was looking for suggestions on how to handle the attachments while I run validation on the db to see if the input from the form already exists in the db. It seems like something that would be perfect for AJAX to handle, but my AJAX skills are virtually nonexistent. So, without using AJAX (or if you can break it down using AJAX for a novice) how would you handle the situation? The main issue I'm having, is that if I do the validation after the form submission, CF is assigning a temp directory to my attachment file. So what is submitted as this: C:\Documents and Settings\JHoward\Desktop\PO Request mods.doc ends up as this after submission and validation: C:\ColdFusion8\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\n eotmp13963.tmp and then when I pass it to the CFFILE, it tells me the file doesn't exist. I'm really just looking at the different ways other people would handle this situation to try and decide so any input would be great. Thanks in advance. Jeff - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com
RE: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion)
disbelief lemme get this straight. you can decrypt SSL traffic into a human readable format? you can crack a 128-bit certificate? what about a high-grade AES 256-bit pipe? /disbelief From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Friday, February 08, 2008 4:01 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion) If secure AMF is just AMF over SSL... its easy enough to modify in transit. Darrin, if you or your organization wants a demo of why these things are insecure, let me know. I'll be more than happy to do some live web hacking for you. (And yes, Charlie, I haven't forgotten about you and the meetup...) -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Dissent is the purest form of patriotism. --Thomas Jefferson On Feb 8, 2008, at 3:55 PM, Dean H. Saxe wrote: *cough* BS. Flash can be decompiled. I can watch all of the traffic. Even over SSL. I can modify AMF (I'd have to look @ secure AMF). If you'd like to challenge me to hack the app, let me know. I'm up for it. ;-) -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] If liberty means anything at all, it means the right to tell people what they do not want to hear. -- George Orwell, 1945 On Feb 8, 2008, at 11:52 AM, Darin Kohles wrote: You can always build a Flex (or Flash for that matter) application that can be put in you page as a 1px by 1px (I'm not sure if 0 by 0 will work) that has nothing on the stage with wmode=transparent. This application can now act as your portal between the browser via JS using the External Interface (or fsCommand going back to Flash ~6). Then your invisible Flex/Flash app can leverage all the connection types available (AMF/SecureAMF, Webservice, HttpService etc...) in a manner that is not easily accessible to any hacker (you can hide all kinds of security checks within this app). I've always wanted to do a bench mark of this type of app side by side with standard Ajax, but the bottom line is that the only browser specific code would be in how the returned data is applied to effect the client content. On Feb 8, 2008 11:20 AM, shawn gorrell [EMAIL PROTECTED] wrote: Charlie, my main issues with AJAX are dealing with cross-browser issues, and security. AJAX exposes some of the most annoying cross-browser DHTML sort of things. Using libraries and frameworks can insulate you from that to a degree, but not always completely. I've got a customer doing things with Google Maps and we've had some differences between IE and FF that have been difficult to solve. People have gotten so excited about using AJAX that they have forgotten basic security principles (things like validating input). I recently read an article that discussed the security holes in the more commonly used frameworks, so the issue isn't just with roll your own AJAX, it is more pervasive. But, those things said, ultimately I think it is a step forward in making a richer browser experience (not as much as Flex though). There are just some fleas on the dog that folks should be aware of in advance. - Original Message From: Charlie Arehart [EMAIL PROTECTED] To: discussion@acfug.org Sent: Friday, February 8, 2008 10:58:47 AM Subject: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion) That seems a curious statement, Forrest, and I'm sure some would enjoy a bit of discussion on it. For those who weren't following closely, he had
RE: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion)
sad but true users will be users despite our best efforts. I was worried that I missed something and all security evaporated overnight. Stranger things have happened. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Friday, February 08, 2008 4:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion) Yes. Man in the middle proxy to decrypt traffic on the fly. I don't need to decrypt the traffic, I let SSL do all the work and just pass the communications through my proxy. Encrypted tunnels exist between browser - proxy and proxy- server. You receive a certificate warning, but most users will accept them not knowing what the warning is or why it exists. Google Paros, Fiddler, Burp Proxy, etc. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] I have always strenuously supported the right of every man to his own opinion, however different that opinion might be to mine. He who denies another this right makes a slave of himself to his present opinion, because he precludes himself the right of changing it. -- Thomas Paine, 1783 On Feb 8, 2008, at 4:13 PM, Fennell, Mark P. wrote: disbelief lemme get this straight. you can decrypt SSL traffic into a human readable format? you can crack a 128-bit certificate? what about a high-grade AES 256-bit pipe? /disbelief From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Friday, February 08, 2008 4:01 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion) If secure AMF is just AMF over SSL... its easy enough to modify in transit. Darrin, if you or your organization wants a demo of why these things are insecure, let me know. I'll be more than happy to do some live web hacking for you. (And yes, Charlie, I haven't forgotten about you and the meetup...) -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Dissent is the purest form of patriotism. --Thomas Jefferson On Feb 8, 2008, at 3:55 PM, Dean H. Saxe wrote: *cough* BS. Flash can be decompiled. I can watch all of the traffic. Even over SSL. I can modify AMF (I'd have to look @ secure AMF). If you'd like to challenge me to hack the app, let me know. I'm up for it. ;-) -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] If liberty means anything at all, it means the right to tell people what they do not want to hear. -- George Orwell, 1945 On Feb 8, 2008, at 11:52 AM, Darin Kohles wrote: You can always build a Flex (or Flash for that matter) application that can be put in you page as a 1px by 1px (I'm not sure if 0 by 0 will work) that has nothing on the stage with wmode=transparent. This application can now act as your portal between the browser via JS using the External Interface (or fsCommand going back to Flash ~6). Then your invisible Flex/Flash app can leverage all the connection types available (AMF/SecureAMF, Webservice, HttpService etc...) in a manner that is not easily accessible to any hacker (you can hide all kinds of security checks within this app). I've always wanted to do a bench mark of this type of app side by side with standard Ajax, but the bottom line is that the only browser specific code would be in how the returned data is applied to effect the client content. On Feb 8, 2008 11:20 AM, shawn gorrell [EMAIL PROTECTED] wrote: Charlie, my main issues with AJAX are dealing with cross-browser issues, and security. AJAX exposes some of the most annoying cross-browser DHTML sort of things. Using libraries and frameworks can insulate you from that to a degree, but not always completely. I've got a customer doing things with Google Maps and we've had some differences
RE: [ACFUG Discuss] queryNew() ?
But, if I tell you then you'll know just how stupid my theoretical test with no potential for real world application really is... It's basically a small chat engine stored as an application variable so that it's not easily traceable and it only resides in the server's memory and the browser window. And to limit the impact on performance and traceability, I wanted it to purge older messages. Alas, here's the code snippet I finally used. Perhaps it will help someone else. In the end moving an object from query type to something else such as a struct was too much code and since data volatility isn't an issue, it was easier just to recreate the query. If anyone's interested I'll post the code somewhere. It's just 3 files: 1 Application.cfm, 1 index.cfm and 1 datarequestor.js. It's about 150 lines of CF code. The JS file does all the ajaxy stuff and it's 490+ lines. kthxbye. mf cfquery name=qSelect dbtype=query select * from application.msgs where id#evaluate(getTickCount()-25)# /cfquery cflock timeout=10 throwontimeout=Yes name=msgs type=EXCLUSIVE cfset application.msgs=QueryNew(ID,USR,MSG,DTS,BigInt,VARCHAR,VARCHAR,DATE ) cfoutput query=qSelect cfset temp = queryAddRow(application.msgs) cfset temp = QuerySetCell(application.msgs, ID, id) cfset temp = QuerySetCell(application.msgs, USR, usr) cfset temp = QuerySetCell(application.msgs, MSG, msg) cfset temp = QuerySetCell(application.msgs, DTS, dts) /cfoutput /cflock From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 10, 2008 7:49 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] queryNew() ? Mark; Is there any chance you could give a better explination on what you are trying to accomplish? Please use sudo code to explain, there might be someone out here in ACFUG land that has accomplished the same thing your are looking to do but in a different manner. Thanks Jason L West --- Quote --- Learn to ask yourself at least three times through out your day, Am I being productive or just active?, in order to keep yourself on track to what produces effective results instead of just looking efficient. Fennell, Mark P. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/10/2008 06:54 Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] queryNew() ? Yeah. I don't know if it was the right thing to do, but I basically just used a QoQ to selected the desired data and rebuilt the queryNew variable. Thanks. mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darin Kohles Sent: Wednesday, January 09, 2008 1:23 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] queryNew() ? Your best bet is to simply to do a query of queries - you can then filter either columns or row using SQL cfquery name=q_newQuery dbtype=query SELECT row1, row5, etc... FROM q_oldQuery WHERE uncle like '%bob%' /cfquery Darin Kohles, Application Developer [EMAIL PROTECTED] Digital Positions, Inc. 2289 Peachtree Road NE Atlanta, GA 30309 404-351-8878 support phone 404-351-2366 main phone 404-351-4055 fax http://www.d-p.com/ http://www.d-p.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fennell, Mark P. Sent: Wednesday, January 09, 2008 1:04 PM To: discussion@acfug.org Subject: [ACFUG Discuss] queryNew() ? Is there anyway to delete data from a query? Yes, delete from a _query_ not from a table or other database object. See, I want to use the queryNew() family of functions to collect some data from the client before I stick it in the database, kind of like in a shopping cart. You should be able to smell the stench of AJAX... Can structDelete() be used? I seem to recall that this can be done. I just don't remember the details. Thanks. mf - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org
[ACFUG Discuss] queryNew() ?
Is there anyway to delete data from a query? Yes, delete from a _query_ not from a table or other database object. See, I want to use the queryNew() family of functions to collect some data from the client before I stick it in the database, kind of like in a shopping cart. You should be able to smell the stench of AJAX... Can structDelete() be used? I seem to recall that this can be done. I just don't remember the details. Thanks. mf - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] queryNew() ?
Yeah. I don't know if it was the right thing to do, but I basically just used a QoQ to selected the desired data and rebuilt the queryNew variable. Thanks. mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darin Kohles Sent: Wednesday, January 09, 2008 1:23 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] queryNew() ? Your best bet is to simply to do a query of queries - you can then filter either columns or row using SQL cfquery name=q_newQuery dbtype=query SELECT row1, row5, etc... FROM q_oldQuery WHERE uncle like '%bob%' /cfquery Darin Kohles, Application Developer [EMAIL PROTECTED] Digital Positions, Inc. 2289 Peachtree Road NE Atlanta, GA 30309 404-351-8878 support phone 404-351-2366 main phone 404-351-4055 fax http://www.d-p.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fennell, Mark P. Sent: Wednesday, January 09, 2008 1:04 PM To: discussion@acfug.org Subject: [ACFUG Discuss] queryNew() ? Is there anyway to delete data from a query? Yes, delete from a _query_ not from a table or other database object. See, I want to use the queryNew() family of functions to collect some data from the client before I stick it in the database, kind of like in a shopping cart. You should be able to smell the stench of AJAX... Can structDelete() be used? I seem to recall that this can be done. I just don't remember the details. Thanks. mf - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Transactions and Commits
Setup: Oracle 10g CF Version: 7,0,0,91690 JVM 1.6.0_02 Fedora release 7 (Moonshine) 2.6.22.1 41.fc7PAE (32-bit) Questions: When does CF commit transactions by default when no CFTransaction tags are used? Can the transaction level (Serializable, Repeatable Read, Read Committed, etc.) be set on an application level? I'm using CFTransaction in some apps because I need to ensure that everything is golden. I seem to recall that CF runs all the queries on a page and then commits at the end. That seems to be causing many can't serialize access for this transaction errors. Anyone have any suggestions or tips? Thanks in advance. mf mark fennell athens regional medical center athens, ga This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Transactions and Commits
It helps alright. Helps confirm that the problem is probably in the database. Thank you! As always, ACFUG rocks. mf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Childress Sent: Monday, December 03, 2007 10:13 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Transactions and Commits I didn't realise cftransaction made everything golden. Good to know. Seriously though, it sounds a little like you may be trying to wrap your entire application or page in a giant cftransaction block. If so, that's generally a pretty bad idea since heavy use of transactions can cause locking contention problems. I would definitely suggest only using transactions when absolutely needed. I did a quick google on your exact error message and got a number of solutions returned including checking to make sure that serializable transactions are enabled in Oracle. You may want to do the same. As far as setting a transaction level on an applcation level, you could certainly store the level in a variable and use it in all your trasaction block. I would caution you from doing this in a blanket fashion across your entire application though. Usually there are very specific reasons for using transactions and you should take care that you are not causing more problems than you think you are solving with your transaction blocks. I know this wasn't the answer you were looking for but I hope it helps... -Cameron On 12/3/07, Fennell, Mark P. [EMAIL PROTECTED] wrote: Setup: Oracle 10g CF Version: 7,0,0,91690 JVM 1.6.0_02 Fedora release 7 (Moonshine) 2.6.22.1 41.fc7PAE (32-bit) Questions: When does CF commit transactions by default when no CFTransaction tags are used? Can the transaction level (Serializable, Repeatable Read, Read Committed, etc.) be set on an application level? I'm using CFTransaction in some apps because I need to ensure that everything is golden. I seem to recall that CF runs all the queries on a page and then commits at the end. That seems to be causing many can't serialize access for this transaction errors. Anyone have any suggestions or tips? Thanks in advance. mf mark fennell athens regional medical center athens, ga This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] JS thing
Check on using opener.document.formname.textfield.value in the child
window.
Also, we use this as part of a custom tag to built date cfinput text
boxes. http://www.dynarch.com/projects/calendar/
Looks something like this...
cfinput type=Text name=#attributes.fname# value=#value#
message=#message# [#attributes.fname#] required=#req# size=#size#
id=#attributes.fname# maxlength=12 onFocus=return
showCalendar('#attributes.fname#', '#dateForm#');
hth.
mf
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of shawn
gorrell
Sent: Friday, September 07, 2007 8:13 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] JS thing
No, it isn't like that. Think of a text field with a calendar picker
that pops up and injects the picked date back into the field. Then the
full form is submitted.
- Original Message
From: Douglas Knudsen [EMAIL PROTECTED]
To: discussion@acfug.org
Sent: Friday, September 7, 2007 8:05:00 AM
Subject: Re: [ACFUG Discuss] JS thing
Anyway to just do a GET or POST to the non CF box? Might need to mod
a little of the CF code though.
On 9/7/07, shawn gorrell [EMAIL PROTECTED] wrote:
I'm having an issue where browser security is getting in the way of
something I need to do and was wondering if any of you have an idea of
how
to solve it.
Here's the deal. We have a non-CF application on a server which has an
HTML
form that pops up a window with a form on a different CF server. What
I'm
trying to do is inject the selected data back into the form field on
the
non-CF box. Normally that is pretty easy if the whole thing is on one
box
with an opener.blahblah. But since it is across boxes we're getting a
permission denied sort of error.
I was considering doing a copy to clipboard sort of thing and make
them
paste it in the other form, but that is very clunky.
Any ideas for a fix or work around?
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
-
Annual Sponsor - Figleaf Software http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink http://www.fusionlink.com
-
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
RE: [ACFUG Discuss] Running a system command from ColdFusion
Why cfstoredproc no worky on this?
If we must kludge
...try execute immediate dbms_wm.gotoworkspace('x')
...using cfexecute to run a shell script or bat file that runs sqlplus,
connects, execs the command and exits sqlplus.
...create a trigger on a table that is one column and one row and when
you update the row to edsWorkspace, the trigger executes the dbms_wm
procedure.
...I'll have to do some research on this, but I think you might can set
the default workspace based on the oracle user and so if your CF DSN
user is x then the workspace will be 1 and when the dsn user is y then
the workspace could be 2.
hth.
mf
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, September 06, 2007 4:10 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Running a system command from ColdFusion
I would like to run an Oracle system command from ColdFusion. My
research revealed a way to execute PL/SQL with a cfset tag as shown
below.
cfset variables.plsql = declare x number; begin := 0; end;
cfquery name=q datasource=yourDSN #variables.plsql# /cfquery
But I need to run an exec command.
I tried this:
cfset variables.plsql = exec DBMS_WM.GoToWorkspace('edsWorkspace')
cfquery name=gotoWorkspace datasource=emstraining.1
#variables.plsql# /cfquery
and I get an invalid SQL statement error. Anyone know if this can be
done, and how?
Thanks!
--
Ed Szwedo
Web Development Team Lead
CSC
E-mail: [EMAIL PROTECTED]
919-541-3955 (Voice)
919-685-3395 (Fax)
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
-
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
[ACFUG Discuss] Session variables
Greetings, Is is possible to use J2EE session variables in one CFApplication and standard session variables in another? I have a server that is running two cfapplications and one uses J2EE variables and seems to not work so well when J2EE Sess Vars is disabled in cf admin. The other applications totally breaks if I have J2EE enabled. I was hoping that, before I set about actually fixing the problem with code that there might be some setting in the cfapplication tag that I can use to enable/disable j2ee vars for a specific application... I'm completely prepared to recode, I just wanted to check and see if anyone had an easy way out. Thanks. mf - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Session variables
Yes, it is odd that the change would break something. I'm using lylaCaptcha and when I enable the J2ee session vars it stops generating the image. I'm going to dig through the cfc and see if it relies on something specifically anti-j2ee. But that doesn't make sesnse as it uses java to create the image. Weirdness. Wishing I had CF8. Thanks. mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Wednesday, August 29, 2007 9:30 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Session variables well...if your on CF8 I believe you can set this at the application level. Aside from that, what is breaking? In the past I had several apps running on a server with standard cf session vars and turned 'use J2EE session vars' on without incident. DK On 8/29/07, Fennell, Mark P. [EMAIL PROTECTED] wrote: Greetings, Is is possible to use J2EE session variables in one CFApplication and standard session variables in another? I have a server that is running two cfapplications and one uses J2EE variables and seems to not work so well when J2EE Sess Vars is disabled in cf admin. The other applications totally breaks if I have J2EE enabled. I was hoping that, before I set about actually fixing the problem with code that there might be some setting in the cfapplication tag that I can use to enable/disable j2ee vars for a specific application... I'm completely prepared to recode, I just wanted to check and see if anyone had an easy way out. Thanks. mf - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Tuning CFMX 7 DB Connections
Speaking of CF8, does anyone have a line on a good price for the upgrade? We've got 4 lics we'd like to upgrade for as little as possible. Thanks. mf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: Monday, August 06, 2007 1:55 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Tuning CFMX 7 DB Connections JVM 1.6 is a rocket compared to 1.4.2. I've got some code that i've used to run some real world tests on 1.6 vs 1.4.2 Data Retrieval, Creation Population of 10K CFCs: CF7 / JVM 1.4.2 - 80499 ms CF7 / JVM 1.6.0 - 73216 ms CF8 / JVM 1.6.0 - 56013 ms Andy On Aug 6, 2007, at 1:29 PM, Fennell, Mark P. wrote: Thank you. Yes, I was wondering about an oracle-supplied jdbc driver. I will say that with the sun 1.6 jvm cf performance soared through the roof in case anyone was wondering. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: Monday, August 06, 2007 1:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Tuning CFMX 7 DB Connections The built-in CF datasource is a JDBC connection. I would make sure you're on the latest data direct drivers. That should be task #1. http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a My two cents. Andy On Aug 6, 2007, at 1:17 PM, Fennell, Mark P. wrote: Does anyone have any references for tuning the data source connections in CFMX? We're moving to new hardware after 5 years and we've found the max capacity for apache (200 connections), cfmx (190 connections) and oracle 10g (6k connections), but when we put them together performance drops (70 connections). So, I was wondering if anyone has any experience with tuning oracle and cfmx? For example, are there known benefits to configuring an Oracle JDBC connection over using the built-in CF datasource? TIA. mf mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. -- - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Tuning CFMX 7 DB Connections
Does anyone have any references for tuning the data source connections in CFMX? We're moving to new hardware after 5 years and we've found the max capacity for apache (200 connections), cfmx (190 connections) and oracle 10g (6k connections), but when we put them together performance drops (70 connections). So, I was wondering if anyone has any experience with tuning oracle and cfmx? For example, are there known benefits to configuring an Oracle JDBC connection over using the built-in CF datasource? TIA. mf mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. -- - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Tuning CFMX 7 DB Connections
Thank you. Yes, I was wondering about an oracle-supplied jdbc driver. I will say that with the sun 1.6 jvm cf performance soared through the roof in case anyone was wondering. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: Monday, August 06, 2007 1:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Tuning CFMX 7 DB Connections The built-in CF datasource is a JDBC connection. I would make sure you're on the latest data direct drivers. That should be task #1. http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a My two cents. Andy On Aug 6, 2007, at 1:17 PM, Fennell, Mark P. wrote: Does anyone have any references for tuning the data source connections in CFMX? We're moving to new hardware after 5 years and we've found the max capacity for apache (200 connections), cfmx (190 connections) and oracle 10g (6k connections), but when we put them together performance drops (70 connections). So, I was wondering if anyone has any experience with tuning oracle and cfmx? For example, are there known benefits to configuring an Oracle JDBC connection over using the built-in CF datasource? TIA. mf mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. -- - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Tuning CFMX 7 DB Connections
True, but raw performance is like a good donut. It's just really, really good. :D -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Monday, August 06, 2007 2:15 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Tuning CFMX 7 DB Connections I think people worry about the raw performance too much and forget to write code that is well designed and scalable. The JVM and Adobe tweaks will only get you so far, developers also have to be responsible for ensuring their designs are not the cause of bottlenecks. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] What is objectionable, what is dangerous about extremists is not that they are extreme, but that they are intolerant. -- Robert F. Kennedy, 1964 On Aug 6, 2007, at 2:11 PM, John Mason wrote: Yep, I've seen the same here. Newer jvms are going to be faster so it's always a good idea to keep an eye on them. Adobe clearly also cleaned up their coding on CF8 to make things run faster. But if you're stuck on CF7 or 6, a jvm upgrade can certainly do a lot. John Mason [EMAIL PROTECTED] 770.337.8363 www.FusionLink.com - ColdFusion and Flex hosting Now offering ColdFusion 8 Enterprise hosting FREE Subversion hosting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: Monday, August 06, 2007 1:55 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Tuning CFMX 7 DB Connections JVM 1.6 is a rocket compared to 1.4.2. I've got some code that i've used to run some real world tests on 1.6 vs 1.4.2 Data Retrieval, Creation Population of 10K CFCs: CF7 / JVM 1.4.2 - 80499 ms CF7 / JVM 1.6.0 - 73216 ms CF8 / JVM 1.6.0 - 56013 ms Andy On Aug 6, 2007, at 1:29 PM, Fennell, Mark P. wrote: Thank you. Yes, I was wondering about an oracle-supplied jdbc driver. I will say that with the sun 1.6 jvm cf performance soared through the roof in case anyone was wondering. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: Monday, August 06, 2007 1:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Tuning CFMX 7 DB Connections The built-in CF datasource is a JDBC connection. I would make sure you're on the latest data direct drivers. That should be task #1. http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a My two cents. Andy On Aug 6, 2007, at 1:17 PM, Fennell, Mark P. wrote: Does anyone have any references for tuning the data source connections in CFMX? We're moving to new hardware after 5 years and we've found the max capacity for apache (200 connections), cfmx (190 connections) and oracle 10g (6k connections), but when we put them together performance drops (70 connections). So, I was wondering if anyone has any experience with tuning oracle and cfmx? For example, are there known benefits to configuring an Oracle JDBC connection over using the built-in CF datasource? TIA. mf mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. -- - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http
[ACFUG Discuss] Catching SQL Errors
Does anyone know of a simple way to catch the SQL command which causes an error? For example, I have request_error.cfm that records the error.diagnostics and the error.template as well as decodes most errors to let the user know why they've been bad. But, I'd like to be able to see the statement that generates the error especially if it's a inserted value too large for column or something else that would indicate user-induced problems. Thanks. mf ps. Red Hat Linux Advanced Server release 2.1AS, CFMX 7.0.0.91690, Oracle 9.2.0.4 mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. -- - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] cfoutput and grouping
If you weren't doing this as a grouped query, I've found the following to be quite handy... cfset myList=valueList(myQuery.myColumn) cfoutput#myList#/cfoutput valueList() also has a delimiter param that can accept BR or , depending on how you like your list. You might could use currentrow compared to recordcount. Just a thought. mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Tuesday, May 15, 2007 2:36 PM To: discussion@acfug.org Subject: [ACFUG Discuss] cfoutput and grouping Does anyone have a good routine for chopping the last comma in the #orderid# of this output: cfoutput query=myquery group=accountid p#accountid# cfoutput#orderid#, /cfoutput /cfoutput Normally I use a counter compared to the recordcount but that won't work in this case. I suppose I could run additional queries to get this but for overhead I need to do it all with one query. Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
Can you share a sample of sql statement causing the error? Thanks. mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Tuesday, February 13, 2007 3:18 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS I just updated our JDBC drivers to the latest 3.5 versions for testing out in a dev instance. We are planning to move to Oracle 10g next Q. A developer is seeing some errors with a query using GROUP BY GROUPING SETS. The error is [Macromedia][Oracle JDBC Driver][Oracle]ORA-03001: unimplemented feature Developer claims that he can use 3 or less GROUPING SETS, but as soon as he uses 3 this error shows up. Anyone seen this before? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
Dang... now that's some serious sql spaghetti. While I don't see
anything in the documentation for 9.2 regarding limits on grouping sets,
it might not hurt to consider
using the cube or rollup group statement keywords,
creating a view to simplify the decodes and rounds and other
functions, and,
this might actually help, put the joins in the where clause.
Apparently, oracle doesn't do joins in the from clause quite up to SQL
standards and in fact will mess up results. It's a feature.
hth.
mf
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas
Knudsen
Sent: Tuesday, February 13, 2007 3:29 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
darn lack of sleep. might have missed a paren or semi on the copy, but
this is the gist. The GROUPING SETS is new to me.
SELECT
RS.REPNAME ,
U.EMPLID ,
TO_CHAR(U.DSMDATE,'HH24') AS GROUPHOUR ,
U.INTERVAL ,
ROUND(DECODE(SUM(DATA9)*RETURN_THRESHOLD(US.BUSUNIT,'DLRCPH',SYSDATE),0,
0,SUM(DATA12)/(SUM(DATA9)*RETURN_THRESHOLD(US.BUSUNIT,'DLRCPH',SYSDATE))
)*100,2 AS DLRATTAINPCT ,
ROUND(SUM(DATA12),2) AS DLRCALLS ,
ROUND(DECODE(NVL(SUM(DATA13),0),0,0,SUM(DATA19)/SUM(DATA13)),2) AS
DLRCPH ,
ROUND(SUM(DATA11),2) AS EPYCOUNT ,
ROUND(SUM(DATA10),2) AS EPYDOLLARS
FROM
USER_SUP US
LEFT JOIN REP_TO_SUP RS
ON US.EMPLID = RS.SUPID
LEFT JOIN UNIVERSAL_SUMMARY U
ON RS.EMPLID = U.EMPLID
WHERE
US.BUSUNIT = '1234567890'
AND US.EMPLID = '13579'
AND TRUNC(U.DSMDATE) BETWEEN TO_DATE('02/13/2007','MM/DD/') AND
TO_DATE('02/13/2007','MM/DD/')
AND (
U.DSMDATE BETWEEN TO_DATE('02/13/2007 7:00 AM','MM/DD/ HH:MI
AM') AND TO_DATE('02/13/2007 5:00 PM','MM/DD/ HH:MI AM') - 1/24
OR U.INTERVAL = 1
)
GROUP BY GROUPING SETS (
(RS.REPNAME, U.EMPLID, TO_CHAR(U.DSMDATE,'HH24'), U.INTERVAL,
US.BUSUNIT),
(RS.REPNAME, U.EMPLID, U.INTERVAL, US.BUSUNIT),
(TO_CHAR(U.DSMDATE,'HH24'), U.INTERVAL, US.BUSUNIT),
(U.INTERVAL, US.BUSUNIT)
)
ORDER BY
RS.REPNAME,
GROUPHOUR
On 2/13/07, Fennell, Mark P. [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Can you share a sample of sql statement causing the error?
Thanks.
mf
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] On Behalf Of Douglas Knudsen
Sent: Tuesday, February 13, 2007 3:18 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING
SETS
I just updated our JDBC drivers to the latest 3.5 versions for
testing out in a dev instance. We are planning to move to Oracle 10g
next Q. A developer is seeing some errors with a query using GROUP BY
GROUPING SETS. The error is
[Macromedia][Oracle JDBC Driver][Oracle]ORA-03001: unimplemented
feature
Developer claims that he can use 3 or less GROUPING SETS, but as
soon as he uses 3 this error shows up. Anyone seen this before?
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink http://www.fusionlink.com
-
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink http://www.fusionlink.com
-
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink http://www.fusionlink.com
-
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
One last thought. If it works in toad just create or replace myViewName
as select... and then select from the view in your cfquery.
:)
mf
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas
Knudsen
Sent: Tuesday, February 13, 2007 4:22 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
if only you knew the meatball. :) passed the info along. thanks. We
are able to execute this in Toad, SQL+, PL/SQL Developer, and SQL
Developer. SQL Developer uses JDBC, so seems its related to teh 3.5
version of the data direct drivers.
DK
On 2/13/07, Fennell, Mark P. [EMAIL PROTECTED] wrote:
Dang... now that's some serious sql spaghetti. While I don't see
anything in the documentation for 9.2 regarding limits on grouping sets,
it might not hurt to consider
using the cube or rollup group statement keywords,
creating a view to simplify the decodes and rounds and other
functions, and,
this might actually help, put the joins in the where clause.
Apparently, oracle doesn't do joins in the from clause quite up
to SQL standards and in fact will mess up results. It's a feature.
hth.
mf
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] On Behalf Of Douglas Knudsen
Sent: Tuesday, February 13, 2007 3:29 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY
GROUPING SETS
darn lack of sleep. might have missed a paren or semi on the
copy, but this is the gist. The GROUPING SETS is new to me.
SELECT
RS.REPNAME ,
U.EMPLID ,
TO_CHAR(U.DSMDATE,'HH24') AS GROUPHOUR ,
U.INTERVAL ,
ROUND(DECODE(SUM(DATA9)*RETURN_THRESHOLD(US.BUSUNIT,'DLRCPH',SYSDATE),0,
0,SUM(DATA12)/(SUM(DATA9)*RETURN_THRESHOLD(US.BUSUNIT,'DLRCPH',SYSDATE))
)*100,2 AS DLRATTAINPCT ,
ROUND(SUM(DATA12),2) AS DLRCALLS ,
ROUND(DECODE(NVL(SUM(DATA13),0),0,0,SUM(DATA19)/SUM(DATA13)),2) AS
DLRCPH ,
ROUND(SUM(DATA11),2) AS EPYCOUNT ,
ROUND(SUM(DATA10),2) AS EPYDOLLARS
FROM
USER_SUP US
LEFT JOIN REP_TO_SUP RS
ON US.EMPLID = RS.SUPID
LEFT JOIN UNIVERSAL_SUMMARY U
ON RS.EMPLID = U.EMPLID
WHERE
US.BUSUNIT = '1234567890'
AND US.EMPLID = '13579'
AND TRUNC(U.DSMDATE) BETWEEN
TO_DATE('02/13/2007','MM/DD/') AND
TO_DATE('02/13/2007','MM/DD/')
AND (
U.DSMDATE BETWEEN TO_DATE('02/13/2007 7:00 AM','MM/DD/
HH:MI AM') AND TO_DATE('02/13/2007 5:00 PM','MM/DD/ HH:MI AM') -
1/24
OR U.INTERVAL = 1
)
GROUP BY GROUPING SETS (
(RS.REPNAME, U.EMPLID, TO_CHAR(U.DSMDATE,'HH24'), U.INTERVAL,
US.BUSUNIT),
(RS.REPNAME, U.EMPLID, U.INTERVAL, US.BUSUNIT),
(TO_CHAR(U.DSMDATE,'HH24'), U.INTERVAL, US.BUSUNIT),
(U.INTERVAL, US.BUSUNIT)
)
ORDER BY
RS.REPNAME,
GROUPHOUR
On 2/13/07, Fennell, Mark P. [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Can you share a sample of sql statement causing the
error? Thanks.
mf
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] On Behalf Of Douglas Knudsen
Sent: Tuesday, February 13, 2007 3:18 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY
GROUPING SETS
I just updated our JDBC drivers to the latest 3.5
versions for testing out in a dev instance. We are planning to move to
Oracle 10g next Q. A developer is seeing some errors with a query using
GROUP BY GROUPING SETS. The error is
[Macromedia][Oracle JDBC Driver][Oracle]ORA-03001:
unimplemented feature
Developer claims that he can use 3 or less GROUPING
SETS, but as soon as he uses 3 this error shows up. Anyone seen this
before?
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink http://www.fusionlink.com
RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
From TFM...
GROUPING SETS
GROUPING SETS are a further extension of the GROUP BY clause that let
you specify multiple groupings of data. Doing so facilitates efficient
aggregation by pruning the aggregates you do not need. You specify just
the desired groups, and Oracle does not need to perform the full set of
aggregations generated by CUBE or ROLLUP. Oracle computes all groupings
specified in the GROUPING SETS clause and combines the results of
individual groupings with a UNION ALL operation. The UNION ALL means
that the result set can include duplicate rows.
Within the GROUP BY clause, you can combine expressions in various ways:
* To specify composite columns, you group columns within
parentheses so that Oracle treats them as a unit while computing ROLLUP
or CUBE operations.
* To specify concatenated grouping sets, you separate multiple
grouping sets, ROLLUP, and CUBE operations with commas so that Oracle
combines them into a single GROUP BY clause. The result is a
cross-product of groupings from each grouping set.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 4:32 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
I know, I know, RTFM, but it has walked off. What does GROUP BY
GROUPING SETS do for you?
Are you sure that's a query, and not a novel in some foreign language?
mcg
Douglas Knudsen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/13/2007 03:28 PM
Please respond to
discussion@acfug.org
To
discussion@acfug.org
cc
Subject
Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
darn lack of sleep. might have missed a paren or semi on the copy, but
this is the gist. The GROUPING SETS is new to me.
SELECT
RS.REPNAME ,
U.EMPLID ,
TO_CHAR(U.DSMDATE,'HH24') AS GROUPHOUR ,
U.INTERVAL ,
ROUND(DECODE(SUM(DATA9)*RETURN_THRESHOLD(US.BUSUNIT,'DLRCPH',SYSDATE),0,
0,SUM(DATA12)/(SUM(DATA9)*RETURN_THRESHOLD(US.BUSUNIT,'DLRCPH',SYSDATE))
)*100,2 AS DLRATTAINPCT ,
ROUND(SUM(DATA12),2) AS DLRCALLS ,
ROUND(DECODE(NVL(SUM(DATA13),0),0,0,SUM(DATA19)/SUM(DATA13)),2) AS
DLRCPH ,
ROUND(SUM(DATA11),2) AS EPYCOUNT ,
ROUND(SUM(DATA10),2) AS EPYDOLLARS
FROM
USER_SUP US
LEFT JOIN REP_TO_SUP RS
ON US.EMPLID = RS.SUPID
LEFT JOIN UNIVERSAL_SUMMARY U
ON RS.EMPLID = U.EMPLID
WHERE
US.BUSUNIT = '1234567890'
AND US.EMPLID = '13579'
AND TRUNC(U.DSMDATE) BETWEEN TO_DATE('02/13/2007','MM/DD/') AND
TO_DATE('02/13/2007','MM/DD/')
AND (
U.DSMDATE BETWEEN TO_DATE('02/13/2007 7:00 AM','MM/DD/ HH:MI AM')
AND TO_DATE('02/13/2007 5:00 PM','MM/DD/ HH:MI AM') - 1/24
OR U.INTERVAL = 1
)
GROUP BY GROUPING SETS (
(RS.REPNAME, U.EMPLID, TO_CHAR(U.DSMDATE,'HH24'), U.INTERVAL,
US.BUSUNIT),
(RS.REPNAME, U.EMPLID, U.INTERVAL, US.BUSUNIT),
(TO_CHAR(U.DSMDATE,'HH24'), U.INTERVAL, US.BUSUNIT),
(U.INTERVAL, US.BUSUNIT)
)
ORDER BY
RS.REPNAME,
GROUPHOUR
On 2/13/07, Fennell, Mark P. [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Can you share a sample of sql statement causing the error? Thanks.
mf
From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] On Behalf Of Douglas Knudsen
Sent: Tuesday, February 13, 2007 3:18 PM
To: discussion@acfug.org mailto:discussion@acfug.org
Subject: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
I just updated our JDBC drivers to the latest 3.5 versions for testing
out in a dev instance. We are planning to move to Oracle 10g next Q. A
developer is seeing some errors with a query using GROUP BY GROUPING
SETS. The error is
[Macromedia][Oracle JDBC Driver][Oracle]ORA-03001: unimplemented feature
Developer claims that he can use 3 or less GROUPING SETS, but as soon as
he uses 3 this error shows up. Anyone seen this before?
--
Douglas Knudsen
http://www.cubicleman.com http://www.cubicleman.com/
this is my signature, like it?
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
http://www.acfug.org?fa=login.edituserform/
For more info, see http://www.acfug.org/mailinglists
http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink http://www.fusionlink.com/
-
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
http://www.acfug.org?fa=login.edituserform/
For more info, see http://www.acfug.org/mailinglists
http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
http://www.mail-archive.com/discussion
RE: [ACFUG Discuss] Building my IDE Tool Box
The best CF IDE of all time? Homesite+, formerly known as CFStudio. I have 30 files open in it right now and it's chewing on all of 25M of RAM, including 10+ years of user-defined keyboard shortcuts and snippets. Yee-ha! mf From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 26, 2007 3:33 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Building my IDE Tool Box Briefly... The ONLY reason I've ever liked DW is the fact that you can synchronize files between the local machine and a server very easily. Eclipse is supposed to have synchronize plugins but they've never seemed to work (at all). Also, DW is great for design type of work, as Ajas mentions below, but it's a resource hog. If you're low on memory you should probably look elsewhere - that being stated, Eclipse isn't exactly a light-weight either! One last thing - a negative for eclipse...if you're working with files that contain thousands of lines of code (I know, everyone says it shouldn't happen, but it does), just typing in a line of code in the middle of the page can be very annoying...it is SO SLOW... But, other than that, both have their uses but the one huge plus of eclipse - it's free -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ajas Mohammed Sent: Friday, January 26, 2007 3:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Best IDE? well thats a tough question and it depends on persons own taste preferences. I like to play with all IDE's there in market and finally stick to ones which I like more. In this case its DW Eclipse. As John Mason mentioned earlier, from coder's point of view no one can beat Eclipse for the simple reason that its meant for a developer who does coding day in day out. Its a very wise option to get familiar with Eclipse because sooner or later some place you join will have developers who only use Eclipse. As for DW is concerned, it is also a great tool for a developer who wants to do design as well write code. Personally, I use both DW Eclipse. I use DW a lot because when I want to edit code, I just select the html element and I get to the point where I want to make the changes instead of searching for it. Thats the biggest plus for me as far as using DW is concerned. On the other side, whenever I have to refactor code or make code changes in CFC's etc, I prefer to stick to Eclipse. Also the Eclipse IDE has some very cool features like 1) You can go to previously viewed file by using cntl + F6 keys. I dont think you could do the same in DW. In DW, cntl + tab takes you through list of files that are open. I hate that. Usually i have lots of files open and I always like to go back forth between 2 open windows/files. Its much easier to do this in Eclipse. 2) The appearance of Eclipse editor looks very good to the eyes when compared to DW's appearance. This remark is based of how code looks in IDE and has nothing to do with fancy stuff. 3) Lot of plugin options. There is another tool which gives TortoiseSVN features in eclipse. I dont want to write it here as we are already discussing that in other thread. Bottom line, I use both. Of late I have been using DW only. But if you want to use Subversion commands in IDE, then Eclipse is by far the best option. Anyone who would like to add or comment on my post is more than welcome. I want to see ppl's opinion when it comes to there favourite editors. Ajas Mohammed. On 1/26/07, Steven Ross [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I know you said windows but I have to chime in... if your on a mac. I like textmate... lean and consise. On 1/26/07, John Mason [EMAIL PROTECTED] wrote: From a purely coding side of things, I would think the majority of people would vote for Eclipse. Now, that isn't to say DW doesn't have it's place, but I think it's more on the design side. John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 26, 2007 1:26 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Building my IDE Tool Box It would seem that Teddy's CFEclipse and my Subversion questions are all heading towards the ultimate question.
RE: [ACFUG Discuss] Image from DB
I'm just curious. What are the benefits of storing the image in the db rather
than storing the file on the filesystem and the path in the db? I mean, for a
web page, all you need is the img and the path. I can understand how it might
be useful in some VB or C or Java app where the client doesn't display images
with such ease, but for a web app...? Thanks.
mf
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Mason
Sent: Thursday, January 18, 2007 10:16 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Image from DB
I believe there would still be three http requests here. The images would still
be called up in the html like img src= right? Sorry but in http that would
still create seperate http requests.
John
[EMAIL PROTECTED]
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrick Peavy
Sent: Thursday, January 18, 2007 9:35 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Image from DB
Probably an easy problem for someone...
I want to put two small images in my database and then output them in my app,
so that they do not constitute additional http requests. Consider it an
experiment - I know that it may seem a bit silly. The goal is for the entire
page to be delivered to the browser in one http request, instead of 3 (two
images and one cf page) without doing any Apache tinkering. I have looked
around the net for answers and cannot seem to make this work.
Database field is imageFile of type BLOB in MySQL 4.1.13. What is the proper
way to insert the image?
Example: INSERT into Images (imageFile) values ('#base64(image)#')
-Or-
Example: INSERT into Images (imageFile) values ('#image#')
And then of course, how do you retrieve it? Example: SELECT imageFile FROM
Images WHERE imageID=1
cfoutput
#toString(imageFile)#
/cfoutput
-OR-
cfoutput
#toBinary(imageFile)#
/cfoutput
As I say, I've not been able to make this work. If I use toString(), I simply
get the raw data. If I use toBinary(), I get an error that the data cannot be
converted to a string. Also, using CFCONTENT is fine to output the image, but
then any code after that is ignored. So, short of saving the entire page and
then outputting, it, I don't see a way to use CFCONTENT.
_
Derrick Peavy
Sales and Web Services
Universal Advertising
Phone: 404-786-5036
Fax: 404-370-0470
http://www.universaladvertising.com
http://www.collegeadvertising.com
http://www.collegeclassifieds.com
___
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink http://www.fusionlink.com
-
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
RE: [ACFUG Discuss] Image from DB
In that case, why not save the entire page html, images, etc. in the database
then use one cfquery and one cfoutput with a cfcontent type=text/html...? And
with equal respect and forgiveness, an experiment without a why or what if, is
little more than a stunt. It's usually easier to find a solution if you can
identify the problem, pose the hypothesis, conduct the experiment and then
extrapolate a conclusion. :)
mf
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Derrick Peavy
Sent: Thursday, January 18, 2007 11:56 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Image from DB
Kindly, and with respect to everyone that replied:
1. As I stated, the goal is to reduce http requests, not file sizes. And this
is an experiment, please forgive, but the Why of why I want to do this is
not part of the answer.
2. Don't really need a discussion about the database design or benefits of A or
B
3. Looking for an answer to the question - How to get image in DB, image out of
DB, using CF and MySQL?
Any takers for that?
_
Derrick Peavy
Sales and Web Services
Universal Advertising
Phone: 404-786-5036
Fax: 404-370-0470
http://www.universaladvertising.com
http://www.collegeadvertising.com
http://www.collegeclassifieds.com
___
On Jan 18, 2007, at 10:32 AM, Teddy Payne wrote:
This seems to be asked often about images and BLOBs. I know you are testing an
idea out and maybe you can get it to work somehow, but from a data perspective
you just don't want to use a BLOB. There is only one technique to reduce up
front cost of a BLOB and that is to have a BLOB table. The table would not be
a part of the primary table, so you would not intefere with indexing and
collation. You would have a normalized table with a foreign key that you would
only use for that web service.
Now for the webservice, wouldn't you want to return the lowest common
denomenator of data? If you are returning HTML or something that needs to
reference the image, it is acceptable to have a reference with an absolute URL
back to your server. The benefit here is that the web service is consumed
quicker, but the page load would be based on the network retrieving the data.
In addition, you would want inside of your web service a way not to return the
image that would even speed up the browsing unless the user really wants the
image.
Teddy
On 1/18/07, Fennell, Mark P. [EMAIL PROTECTED] wrote:
I'm just curious. What are the benefits of storing the image in the db rather
than storing the file on the filesystem and the path in the db? I mean, for a
web page, all you need is the img and the path. I can understand how it might
be useful in some VB or C or Java app where the client doesn't display images
with such ease, but for a web app...? Thanks.
mf
-Original Message-
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] Behalf Of John Mason
Sent: Thursday, January 18, 2007 10:16 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Image from DB
I believe there would still be three http requests here. The images would still
be called up in the html like img src= right? Sorry but in http that would
still create seperate http requests.
John
[EMAIL PROTECTED]
_
From: [EMAIL PROTECTED] [mailto: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
On Behalf Of Derrick Peavy
Sent: Thursday, January 18, 2007 9:35 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Image from DB
Probably an easy problem for someone...
I want to put two small images in my database and then output them in my app,
so that they do not constitute additional http requests. Consider it an
experiment - I know that it may seem a bit silly. The goal is for the entire
page to be delivered to the browser in one http request, instead of 3 (two
images and one cf page) without doing any Apache tinkering. I have looked
around the net for answers and cannot seem to make this work.
Database field is imageFile of type BLOB in MySQL 4.1.13. What is the proper
way to insert the image?
Example: INSERT into Images (imageFile) values ('#base64(image)#')
-Or-
Example: INSERT into Images (imageFile) values ('#image#')
And then of course, how do you retrieve it? Example: SELECT imageFile FROM
Images WHERE imageID=1
cfoutput
#toString(imageFile)#
/cfoutput
-OR-
cfoutput
#toBinary(imageFile)#
/cfoutput
As I say, I've not been able to make this work. If I use toString(), I simply
get the raw data. If I use toBinary(), I get an error that the data cannot be
converted to a string. Also, using CFCONTENT is fine to output the image, but
then any code after that is ignored. So, short of saving the entire page and
then outputting, it, I don't see a way to use CFCONTENT.
_
Derrick Peavy
Sales and Web Services
Universal Advertising
Phone: 404-786-5036
Fax: 404-370-0470
http
RE: [ACFUG Discuss] Image from DB
Additionally, I think HTTP 1.1 allows connection keep-alives so that you only
make one http call for the entire page. Right?
mf
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Mason
Sent: Thursday, January 18, 2007 12:03 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Image from DB
Don't get me wrong, I understand it's an experiement and it's fun to try.
1. You're not actually reducing your http requests. -- My main point with this.
3. You can save the image data in the database as a BLOB and output it onto a
page. You'll need to use cfcontent to set the precise MIME type. If you're
using IIS 6, the MIME types are much more strict than they use to be.
John
[EMAIL PROTECTED]
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derrick Peavy
Sent: Thursday, January 18, 2007 11:56 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Image from DB
Kindly, and with respect to everyone that replied:
1. As I stated, the goal is to reduce http requests, not file sizes. And this
is an experiment, please forgive, but the Why of why I want to do this is
not part of the answer.
2. Don't really need a discussion about the database design or benefits of A or
B
3. Looking for an answer to the question - How to get image in DB, image out of
DB, using CF and MySQL?
Any takers for that?
_
Derrick Peavy
Sales and Web Services
Universal Advertising
Phone: 404-786-5036
Fax: 404-370-0470
http://www.universaladvertising.com
http://www.collegeadvertising.com
http://www.collegeclassifieds.com
___
On Jan 18, 2007, at 10:32 AM, Teddy Payne wrote:
This seems to be asked often about images and BLOBs. I know you are testing an
idea out and maybe you can get it to work somehow, but from a data perspective
you just don't want to use a BLOB. There is only one technique to reduce up
front cost of a BLOB and that is to have a BLOB table. The table would not be a
part of the primary table, so you would not intefere with indexing and
collation. You would have a normalized table with a foreign key that you would
only use for that web service.
Now for the webservice, wouldn't you want to return the lowest common
denomenator of data? If you are returning HTML or something that needs to
reference the image, it is acceptable to have a reference with an absolute URL
back to your server. The benefit here is that the web service is consumed
quicker, but the page load would be based on the network retrieving the data.
In addition, you would want inside of your web service a way not to return the
image that would even speed up the browsing unless the user really wants the
image.
Teddy
On 1/18/07, Fennell, Mark P. [EMAIL PROTECTED] wrote:
I'm just curious. What are the benefits of storing the image in the db rather
than storing the file on the filesystem and the path in the db? I mean, for a
web page, all you need is the img and the path. I can understand how it might
be useful in some VB or C or Java app where the client doesn't display images
with such ease, but for a web app...? Thanks.
mf
-Original Message-
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] Behalf Of John Mason
Sent: Thursday, January 18, 2007 10:16 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Image from DB
I believe there would still be three http requests here. The images would still
be called up in the html like img src= right? Sorry but in http that would
still create seperate http requests.
John
[EMAIL PROTECTED]
_
From: [EMAIL PROTECTED] [mailto: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
On Behalf Of Derrick Peavy
Sent: Thursday, January 18, 2007 9:35 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Image from DB
Probably an easy problem for someone...
I want to put two small images in my database and then output them in my app,
so that they do not constitute additional http requests. Consider it an
experiment - I know that it may seem a bit silly. The goal is for the entire
page to be delivered to the browser in one http request, instead of 3 (two
images and one cf page) without doing any Apache tinkering. I have looked
around the net for answers and cannot seem to make this work.
Database field is imageFile of type BLOB in MySQL 4.1.13. What is the proper
way to insert the image?
Example: INSERT into Images (imageFile) values ('#base64(image)#')
-Or-
Example: INSERT into Images (imageFile) values ('#image#')
And then of course, how do you retrieve it? Example: SELECT imageFile FROM
Images WHERE imageID=1
cfoutput
#toString(imageFile)#
/cfoutput
-OR-
cfoutput
#toBinary(imageFile)#
/cfoutput
As I say, I've not been able to make this work. If I use toString(), I simply
get the raw data. If I use toBinary(), I get an error that the data cannot be
converted to a string. Also, using CFCONTENT is fine to output
RE: [ACFUG Discuss] OT: Client talking points
I've been dealing with our HR dept too much lately. I think it's rubbing off on me. Don't forget to sell your skills. Obviously, the client is interested in your work, even if it is done in CF. It might help to think of it this way: a baseball player could probably play football, but when it comes to winning the game, the baseball player plays baseball... and you want to win the game. Don't you? :) See? Too much HR. Additionally, CF8 will support native access to .net objects ( http://labs.adobe.com/wiki/index.php/Scorpio:FAQ) As an aside and an example of my meager knowledge, could you write a CF app, package the CF war/ear/jar and run the app under .net? I know you can run CF under websphere and other app servers by deploying the war/ear files, but I don't know how or if .net could do the same thing. hth. mf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Teddy Payne Sent: Thursday, December 07, 2006 10:54 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: Client talking points Seth, You also have to look at your selling point. The client did not make this decision on his/her own. Someone has influenced this person. Are you primarily a CF developer? This may be a deal breaker if you cannot deliver the product in the same amount of time as if it was written in CF. Just real quick: CF can be deployed using more than just Microsoft products, so legacy support and future hybrid network topologies is possible. Teddy On 12/7/06, Tepfer, Seth [EMAIL PROTECTED] wrote: I have been in the preliminary stages with a client. I had set up an extensive project charter and a prototype website. Suddenly this client emails me last night and says I think I should be using .net instead of ColdFusion. Let's meet on Thursday afternoon and discuss this I am looking for some quick and dirty speaking points to say why CF over other languages (including .net). The obvious ones to me are * rapid development * ease of maintenance * less time in development/maintenance = lower bottom line * other? * stats to justify this? I do not want to start a flame war over .net versus CF. I'm just looking for speaking points (perhaps with some URLs for reference for some useful statistics). Any help would be appreciated. If this has been done previously and is archived in an FAQ, please point me in the right direction. I didn't see clear case justification at the Adobe/MM site – is it there and I just missed it? Thanks. Seth - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org nNryزXfjꮇj|q
RE: [ACFUG Discuss] Read Receipts
In my case, it's born out of an environment where you need to enforce accountability. Alas, I've turned off the automatic rr on my side. I'll use it more reasonably in the future. Your responses are, as usual, quite enlightening. Thank you. mf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Arehart Sent: Thursday, December 07, 2006 12:49 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Read Receipts Oh, that there were so. :-) Our List Admin, John, may have an answer, but I think not. It is an annoyance, and always makes me wonder what situations lead folks to have read receipts always turned on. I would think it a very rare requirement, indeed, to track ones emails that way. I mean, even if one's work requires it, wouldn't one typically send lots of emails other than just such work ones? :-) And given that folks can say no, don't send the receipt, it just seems a quaint notion that is more trouble than it's worth. But that's not what you asked, and it's certainly kind of you to ask if there may be a way to block them if sent to the list. Let's see what John or others may have to say. /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fennell, Mark P. Sent: Thursday, December 07, 2006 11:51 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Read Receipts Is there anyway a mail server could be setup to strip out the read_receipt requested part of the mail header so that idiots like myself who forget to turn the option off before sending mail to the list don't have to share their memory lapses? Just curious. Thanks. mf - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Spell Checker for FCKeditor
S. I use FF at work too. :) Unfortunately our other web-based sw vendors demand IE for their clinical apps and so we'll be stuck with it for the foreseeable future. I'll probably work on a FF version for my own convenience. :) I'll keep you posted. mf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Teddy Payne Sent: Friday, November 17, 2006 4:31 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Spell Checker for FCKeditor I can understand that practice. Most intranets that I have I have worked for tend to adopt IE only policies. I can see how it can save time for developers to not have to test for multiple browser environments, but innately I wish I could FF for my day to day work. Thanks for the code snippet. I will have to test it out and have a go at it. Teddy On 11/17/06, Fennell, Mark P. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: IE only. It's for our intranet and every PC in the organization is pushed via scriptlogic with a very specific IE flavor so I confess to abusing that luxury. mf -Original Message- From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] Behalf Of Teddy Payne Sent: Friday, November 17, 2006 4:01 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Spell Checker for FCKeditor Mark, What test considerations have you made for this tag? IE? FF? Opera? Teddy On 11/17/06, Fennell, Mark P. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Awhile back I posted a simple CFMX on Linux spellchecker. I'm nearing completion on the custom tag and thought that this might be an appropriate dumping point. The custom tag is ~120 lines with 50 dedicated to comments. There are other files required for spelling suggestions (using google mini) and datarequestor.js for XMLrequests and serialization. It's not pretty and it has low self-esteem. So, please criticize it kindly. :) Anyways, here goes. mf !--- Custom Tag Name : spell Location: /CustomTags/spell.cfm Created:17 November 2006 Creator:Mark Fennell Purpose:SpellChecking form fields in CFMX on Linux ToDo: Currently only supports ONE field per page; attributes for location of dependencies; Attributes: stage requiredstage=1 draws a contenteditable div that feeds your form field stage=2 draws the spelling form and the targeted iframe for subversive stuff stage=3 draws the submit button w/ the js needed to stuff your form field with the corrected spelling fieldName optionalRequired if stage=1 this will the name of the form field that is submitted to your action page formNameoptionalRequired if stage=1 this is the name of the form that the form field belongs to and that will ultimately be submitted buttonText optionalRequired if stage=3 this is the name of the form submit button Directions for use: This tag MUST be called three times; once as stage=1, once as stage=2 and as stage=3. They do NOT have to be called in order. Stage=1 cf_spell stage=1 formName=myForm Stage=2 cf_spell stage=2 Stage=3 cf_spell stage=3 formName=myForm buttonText=submit fieldName=comments Stage 1 and 3 will plop the text box and button where they are called so location is important to you. Stage 2 is all hidden so it's location doesn't matter as much. Sample Calling Document: cfform action=demo.cfm method=POST name=myForm id=myForm cf_spell stage=1 formName=myForm fieldname=comments cf_spell stage=3 formName=myForm buttonText=submit fieldname=comments /cfform cf_spell stage=2 This tag relies on bunches of other stuff gian.cfm and datarequestor.js and sample.txt. datarequestor.js is from http://mikewest.org/ takes care of some XMLHTTPRequest and Serialization stuff gian.cfm is the google mini-based spelling suggester sample.txt is where we store the text being checked. Sample gian.cfm: cfhttp url= http://google-mini/search?site=IAN http://google-mini/search?site=IANclient=IANoutput=xml_no_dtdie=oe=lr=skin=q=#x%23 client=IANoutput=xml_no_dtdie=oe=lr=skin=q=#x# method=GET resolveurl=yes multipart=yes cfoutput cfset res=#XMLParse(cfhttp.filecontent)# cftry cfset ret = #toString( res.GSP.Spelling.Suggestion.XmlAttributes.q)# cfcatchcfset ret=No suggestions available./cfcatch /cftry #ret# /cfoutput --- cfif isDefined(attributes.stage) and attributes.stage eq 2 iframe name=spellFrame id=spellFrame width=0 height=0 marginwidth=0 marginheight=0 scrolling=no frameborder=0/iframe form action=/ian/CustomTags/spell.cfm name=spellForm id=spellForm
RE: [ACFUG Discuss] Best Practice for Assembling Pages
I've been told I did it wrong, but I'm from the school that says if it works and works well, then it's not wrong. What we did and have been doing since CF5 is using the Application.cfm to setup the variables as well as the frame of the page using CFINCLUDES for the header and after that we open up a table and include a directory-dependent subnav in the left TD and open the right TD for the content of the actual page being called. We use OnRequestEnd.cfm for the footer which ends the table and includes the header links file. This allows the page layout to remain constant across our entire site while affording the flexibility of including the directory-dependent subnav.cfm. We do some access control in the included headers and subnavs too. The Application.cfm establishes the css, but you could easily stash that in thesubnav.HTH mf mark fennell athens regional medical center athens, ga -- This email is intended only for the named recipient(s). It may containinformation that is proprietary, confidential or otherwise prohibited fromdisclosure. If you are not the named addressee,you are not authorized to read, print, retain, copy or disseminatethis message or anypart of it. Ifyou have received this message inerror, pleasereply immediately by email or telephoneme at 706-475-4357 and delete all copiesof the message. -- -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Clarke BishopSent: Tuesday, November 07, 2006 10:29 AMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Best Practice for Assembling Pages Did my questions not make sense to anyone or was everyone just feeling sorry for me sending messages out on Saturday night? If this is confusing, please let me know. Clarke From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clarke BishopSent: Saturday, November 04, 2006 8:01 PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Best Practice for Assembling Pages I am building a simple information-oriented site. Each page will have the same header, footer, right-hand column and a content area. Ideally, I'd like my customer to be able to edit the content area, but nothing else. I'd like to ask all of you about the best practice for assembling the page. Here are the ways I'm thinking about: 1. Use a Dreamweaver template and/or Dreamweaver library. I've done this before, so I know it works. 2. Use Dreamweaver templates as in #1, but cfinclude the header, footer, etc. 3. Use onRequestStart in Application.cfc to cfinclude the header, footer, etc. 4. Some other more CF-oriented approach, but hopefully not FuseBox I like method #1 or #2, because then I can use Contribute and allow my customer to edit certain content. Right now, the site will only use the most minimal CF for a Contact Form, etc. Still, I want to get this right from the start. Thanks for any ideas! Clarke- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Data grid
As does spry http://labs.adobe.com/technologies/spry/and activeWidgets http://www.activewidgets.com/grid/ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ben JohnsonSent: Tuesday, November 07, 2006 3:52 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Data gridCheck out the Rico website.They have a LiveGrid tool.http://openrico.org/rico/livegrid.pageBen On 11/7/06, Mischa Uppelschoten ext 10 [EMAIL PROTECTED] wrote: Can anybody recommend a simple widget for building a dhtml web data grid? CFGrid is a bit too cumbersome on the client side to use. I basically just need striped output and the ability to sort columns. No need to be able to edit data. Thanks!Mischa.-To unsubscribe from this list, manage your profile @http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com-- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Best Image upload tag (manipulate, etc.)?
On Linux, we use CFEXECUTE to run convert and resize images as well as resample/compress them. mf -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, November 03, 2006 2:54 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Best Image upload tag (manipulate, etc.)? I don't have any links right on hand, but just do some Googling for JAI (Java Advanced Imaging) and ColdFusion. mcg [EMAIL PROTECTED] wrote: - To: discussion@acfug.orgFrom: Precia [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]Date: 11/03/2006 02:45PMSubject: Re: [ACFUG Discuss] Best Image upload tag (manipulate, etc.)? No, cffile has not changed...it's the tag used to upload the file. Preica On 11/3/06, Dusty Hale [EMAIL PROTECTED] wrote: I know that cffile used to not let you perform image manipulation. Has that changed with new cf versions? Anyone? From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] ] On Behalf Of Precia Sent: Friday, November 03, 2006 2:17 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Best Image upload tag (manipulate, etc.)? cffile On 11/3/06, Derrick Peavy [EMAIL PROTECTED] wrote: Wondering about your mileage... What is the best, most flexible image upload tag you have used? Free is not a requirement in this case. But solid, no known bugs and fast execution are a must. Would also like: image resize, take a 1 MB photo someone uploads and make it smaller without changing the size (H or W). file type restriction (easy, I know) multiple files uploaded at once Important - tag needs to work in either Cold Fusion or Blue Dragon and have been tested in Firefox and Safari (at least), in addition to IE. _ Derrick Peavy Sales and Web Services Universal Advertising ___ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com- - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
[ACFUG Discuss] superSimpleSpellCheck v 0.0.1a
I was about tired of all the PHP spell checkers out
there and so I set about to writing one in CF.
I figured ifmy frustration could spark someone
else's delight, then I shouldshare it.
Here's the first working draft for anyone
interested.
style type="text/css".wrong {
background-color: red; }/stylecffile action=""
file="/www/html/mf/spellCheck/sample.txt"
variable="v_txt"cfexecute
name="/usr/bin/spell"
arguments="/www/html/mf/spellCheck/sample.txt"
variable="v_spell"
timeOut="30"/cfexecutecfoutputcfloop
index="x" list="#v_spell#" delimiters="#chr(10)#"cfif x neq
""cfset v_txt=replace(v_txt,x,'a
class=wrong#x#/a','ALL')/cfif/cfloop#v_txt#/cfoutput
HappyFriday.
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-
[ACFUG Discuss] CFDOCUMENT + PDF = ?!?
Greetings Geniuses, I have a question regarding the creation of a PDF using CFDocument. The document I hope to end up with is what we call the New Employee Paperwork. I hope that I can soon call it the New Employee PDF. Anyway, the pdf will or should contain some dynamic content collected from our db of job descriptions and the employee's application and stuff as well as the W-4 and G-4 pdfs. Currently I have 2 PDFs: 1 dynamic cfdocument pdf and 2 PDFs from government agencies which I have acrobatted together into 1. Does anyone have any ideas on how to merge the two into one? CF is running on Linux so no cfexecuting .exe files. However, the server is internal and fairly well isolated so some degree of Linux shell hanky panky is ok. So far, I've tried the following: putting a cfhttp.filecontent of the w/g-4 pdf inside the cfdocument not using cfdocument, but setting the cfcontent and http header to pdf and appending the w/g-4 pdf to the rest of the content cfincluding the pdf Thanks in advance. mf mark fennell athens regional medical center athens, ga This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CFDOCUMENT + PDF = ?!?
Found it... http://www.physics.ohio-state.edu/~ntg/scripts/pdfmerge.pl Ah perl. Ah, sweet, sweet perl. mf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bryan Tidd Sent: Friday, October 20, 2006 12:52 PM To: discussion Subject: RE: [ACFUG Discuss] CFDOCUMENT + PDF = ?!? You might try pdftk. Check this out. http://www.accesspdf.com/pdftk/ I don't know if it gets what you want, but may be a start. Bryan -Original Message- From: Fennell, Mark P. [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 12:27 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CFDOCUMENT + PDF = ?!? Greetings Geniuses, I have a question regarding the creation of a PDF using CFDocument. The document I hope to end up with is what we call the New Employee Paperwork. I hope that I can soon call it the New Employee PDF. Anyway, the pdf will or should contain some dynamic content collected from our db of job descriptions and the employee's application and stuff as well as the W-4 and G-4 pdfs. Currently I have 2 PDFs: 1 dynamic cfdocument pdf and 2 PDFs from government agencies which I have acrobatted together into 1. Does anyone have any ideas on how to merge the two into one? CF is running on Linux so no cfexecuting .exe files. However, the server is internal and fairly well isolated so some degree of Linux shell hanky panky is ok. So far, I've tried the following: putting a cfhttp.filecontent of the w/g-4 pdf inside the cfdocument not using cfdocument, but setting the cfcontent and http header to pdf and appending the w/g-4 pdf to the rest of the content cfincluding the pdf Thanks in advance. mf mark fennell athens regional medical center athens, ga This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?faslogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
