Re: Possible to optimise CFHTTP Response Time?
On Thu, Feb 13, 2014 at 4:57 PM, Craig Brown craigpbr...@gmail.com wrote: I have an API running on my server where I can receive an average ping response to the host server of 1ms yet when I make a CFHTTP request to the host server it takes anywhere from 300-500ms to return a response. Are you by any chance on Amazon AWS ? Or maybe some other virtualized XEN solution ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: postSizeLimit and postParameterLimit
On Thu, Mar 28, 2013 at 11:26 PM, Justin Hansen jhan...@uhlig.com wrote: There is a bit of a debate going on, I was hoping the community could chime in... What is a reasonable limit for the postSizeLimit and postParameterLimit settings (aka maximum number of form fields)? 100, 1,000, 10,000? Tomcat has a default value of 1 for a somewhat equivalent parameter (maxParameterCount): http://tomcat.apache.org/tomcat-7.0-doc/config/http.html -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Video Processing?
I've used ffmpeg for transcoding and appending videos to one another so if you're requirements are to transcode and append then ffmpeg will work nicely in my experience. I think you can also insert one video into another by splitting the second video and appending the parts in the right order. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: the ##2 will not print with Bar Code 39 f HR cfprint comand
Yes, it prints from the server fine if I open the pdf and print from acrobat reader. it just wont print the #2 with the cfprint command. Can you put somewhere a copy of the PDF with the problem ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Changing the Mail/Spool folder
You can move the folders to the other partition and then create a symbolic link to them in the cf mail dir. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: imageGeEXIFMetaData
Do you have an image that demonstrates the problem ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Commons Logging issues
On Thu, Sep 29, 2011 at 6:25 PM, Paul Giesenhagen p...@quilldesign.com wrote: SO there was a directory that had the commons logging files in it .. removed those - restarted the CF Service and still have the same error - so at this time, it I believe is just loading the CF defaults. Do you have a piece of code that demonstrates the problem ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MyFax and CFMail
Make sure there are is no white space in your text email (cfmail from=... to=.../cfmail). -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Commons Logging issues
Delete org\apache\commons\logging from pdf-transcoder.jar, download the newest common logging jar file from http://commons.apache.org/logging/ and load that with JavaLoader. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Commons Logging issues
Paul, Do you have access to CF's logs ? You should see something in the exception.log ... -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Weird ColdFusion Admin Error
500 coldfusion.runtime.CfJspPage._setCurrentLineNo(I)V coldfusion.runtime.CfJspPage._setCurrentLineNo(I)V anyone ever see this before? tw -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Weird ColdFusion Admin Error
Did you ever resolve this? I'm getting it now on an MX 7 installation when I try to access the administrator page. It's a Virtual Private Server and I bet some config change was made that screwed up the encryption. May have to reinstall and reconfigure ColdFusion -- ugh! Bob Mack 500 coldfusion.runtime.CfJspPage._setCurrentLineNo(I)V coldfusion.runtime.CfJspPage._setCurrentLineNo(I)V anyone ever see this before? tw -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE / CFCATCH
On Fri, Jul 1, 2011 at 4:16 AM, morgan l greyk...@gmail.com wrote: Looks like you're the victim of scenario #2 in this KB article: http://kb2.adobe.com/cps/181/tn_18171.html That article applies to CF5 and I doubt Jenny is running CF5. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF security update released today
I'm seeing some problems after applying the update to 2 CF servers (both standard): - CF 8.0.1 the version in Server Settings Settings Summary is now 8,0,1,0; - CF 9.0.1 and 8.0.1 I'm logged out when I click on Verify all datasources in CFIDE: There was an error accessing this page. Check logs for more details. and this is from application.log: Warning,jrpp-10,06/16/11,04:48:46,CFADMIN,There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected. Anybody else seeing this ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: same content different result CFFile vs CFContent
First, make sure that cfsavecontent doesn't introduce any spaces: cfsavecontent variable=strTextcfoutput#myFile#/cfoutput/cfsavecontent Second, I would include the file name in quotes in the Content-Disposition header: cfheader name=Content-Disposition value='attachment; filename=#userInfo.lName#-#userInfo.fName#-#userInfo..UserID#-FI.txt' Third, just output the variable in the cfcontent tag, there's no need to pass through base64 -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to pass a file to a web service.
Use the binary type when declaring the web service parameter for the file content, have a separate parameter for the file name (if necessary) and use the normal CF way to invoke the web service. Theoretically you shouldn't get Out of Memory errors but I haven't tested this... ws.cfc cffunction name=dataSubmit access=remote cfargument name=file_name type=string cfargument name=file type=binary cfset fileWrite(arguments.file_name, arguments.file) /cffunction test.cfm cfset ws = createObject(webservice, http://ws.cfc?wsdl;) cfset ws.dataSubmit(ppur-test.xml, fileRead(expandPath('ppur-test.xml'))) -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfx_pwtextcrypt CF9
I think you might be able to use java.security.KeyPairGenerator to generate the keys and then javax.crypto.Cipher to do the encryption/decryption. I haven't tested it though so i don't know if it will work. Personally I've used gnupg (GNU Privacy Guard) for RSA key generation and encryption/decryption. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to get sql sent to sql server
Wrap the query in cftry/cfcatch, dump the error and the sql should be somewhere in the nested errors. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) passing URL parameters
Most probably a caching issue, the 404 page is cached in the browser or an intermediate proxy. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Apache Permission Error - extension cannot load, apache cannot start
Is selinux enabled ? Is there something in /var/log/audit/audit.log about the error ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Webservice error after CF 8.01 update
Hi Mack, Just wondering if you filed this as a bug. Brook, It's bug 85391. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: FileHandles in memory
On Wed, Dec 15, 2010 at 8:02 AM, Leigh cfsearch...@yahoo.com wrote: What do you suppose happens when you store a file handle in the session scope, and the session expires? Going strictly off the documentation http://livedocs.adobe.com/coldfusion/8/functions_e-g_12.html ...If you do not close a file, the stream remains open; in that case, the operating system can lock the file, which results in the file not being usable until the server is restarted... I think if the session expires the file handles will be closed by the finalizer thread but I don't think there's a guarantee regarding the time it takes until the handles are closed. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Counting photos on a remote server
Does anybody have a suggestion? (Please keep it G rated.) You can use HEAD requests to verify that the images exists and cache the results of the tests locally, something like: cfloop condition=remoteFile exists cfhttp method=head url=remoteFile cfif (cfhttp.statusCode eq 404) // file does not exist, break the loop cfbreak cfelse // file exist, try next one remoteFile = next remoteFile /cfif /cfloop application.lastFileThatExists = remoteFile -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Not Restarting after Java Update
Anything in the log files ? If it's a CF server install then check #cfhome#/logs and #cfhome#/runtime/logs -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Not Restarting after Java Update
On Tue, Dec 14, 2010 at 5:06 PM, Chad Baloga cbal...@gmail.com wrote: I see a few errors: Error: no `server' JVM at `C:/Java/jre6\bin\server\jvm.dll'. (after I installed the update, and changed the jvm.config file) You need to point CF to the JRE directory inside the JDK and not to the standalone jre directory. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Webservice error after CF 8.01 update
Your getting a different error, which is actually the same one I get on my production server. However, I don't have to modify any filenames or ANY code to get this error. I think it happens when there is a cache pop in the template cache. That's my guess also and I think renaming the cfc does a cache pop so the bug can be duplicated quickly. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Webservice error after CF 8.01 update
Grrr I've pretty much exhausted all my options now, this is driving me batty.. Brook, I think this is a bug in CF. I've made a small testcase on which I can reproduce the error all the time: http://dl.dropbox.com/u/15688335/wstest.zip 1. Put the files in a wstest folder in your root. 2. create a file to test the web service : cfset ws = createObject(webservice, http://SERVER/wstest/ws.cfc?wsdl;).function1() 3. run the test file once. It should work properly. 4. rename wstest/result/function1Response.cfc (adding 1 at the end of the file works just fine) 5. run the test file. It should complain about function1Response.cfc not being found. 6. rename the cfc back to function1Response.cfc 7. run the test file. On my server (9.0.1) it alternates between 'java.lang.LinkageError : loader (instance of coldfusion/xml/rpc/SkeletonClassLoader): attempted duplicate class definition for name: wstest/result/Function1Response' and 'java.lang.ClassNotFoundException : wstest.result.Function1Response][java.lang.NullPointerException : null' The error is cleared temporarily by: - changing ws.cfc (adding spaces at the start for example); - using the clearTrustedCache function like in your code. If you can duplicate the error I will log this as a bug with Adobe. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Memory Usage Question (HEAPDUMP Included)
On Wed, Dec 8, 2010 at 6:09 PM, Brook Davies cft...@logiforms.com wrote: One again my memory usage was steady at 20%, something happened and now its up and down from 15% to 90% and back down within minutes. Here is a screen shot of the memory graph in seeFusion. GC seems to be doing its job, but this does not seem normal or does it!? http://screencast.com/t/6SkU3bF9Gsx Considering that the number of requests is not increasing this shouldn't happen (unless requests after 7:00am retrieve much more records from the database for example) So I did a heapdump and analyzed it in MAT for eclipse: When I took the dump memory on the server was reported at 90% by seefusion. The JVM has 1 gig allocated to it. The dump doesn't show near that much memory in use, so maybe a GC ran right before I took the dump, I'm not sure. Your total memory seems low in the screenshot (aprox 200M) so I suspect that you took the heap-dump right after a gc. Does anyone see anything that stands out in these reports? Should there be that many jdbc.base.preparedStatement items? http://screencast.com/t/Th4ZiLZw http://screencast.com/t/IdGqa6Uh In my experience 2775 is not that big for the number of PreparedStatements. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: checking for active links/pages (OT)
Actually neither of those would work because I'm not checking to see if the links are valid, I would like to return a list of all .cfm files that are used within a website. Maybe that's a better way of stating what I'm trying to do. Depends on how much time you want to dedicate to this you can: - find out what .cfm files are access from the logs; - find out what CF files are access by parsing the compiled CF classes after starting with an empty cfclasses directory (each compiled class contains the name of the CF source file - .cfc or .cfm) Creating a list of all the files and the removing the ones that are present in the above 2 lists will give you hopefully a much shorter third list of files that you can check manually to see if they are used. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Memory Usage Question
I wish I could see WHAT was taking up the ram, i.e a specific array, cfc instances, etc etc It can be done but it's not easy. Basically you need to do a heap dump of the CF process (you can do that without shutting down the server) and then analyze the heap dump using MAT for Eclipse. MAT can tell you what are the objects on the heap, etc. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Memory Usage Question
Java byte code - that is what is going to be in memory. I expect a CFC etc would relate to a particular Java object however while I can dump what is in RAM have not learned how to understand the output and join a CFM to an object. I might be wrong but I don't think you can dump the permanent JVM space so you don't have access to the actual bytecode. I think you can use jmap -permstat to see what classes are loaded and that might give you an idea of what CFC are loaded, etc I wish I could see WHAT was taking up the ram, i.e a specific array, cfc instances, etc etc I think JVM logging or even Java Dev Kit programs like Jconsole and Jvisualvm will perhaps show which Java memory buffer (New/Tenure/Perm) is being consumed. CF monitor will probably help you see what CFM CFC etc is running. So once you know which buffer is being consumed perhaps you can allocate more to that until your able to short out which CFM etc is taking the RAM. Jvisualm is a good suggestion and gives you some of insight into the JVM. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfinvoke smartermails webservices
cfdump var=#wsResults.getListNames()# ? I think usually web service responses are Java objects that are accessed via getters (for example if you have listNames in your response then you can access it with getListNames(), etc). -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Webservice error after CF 8.01 update CF FAILS TO START! [FIXED]
On Thu, Dec 2, 2010 at 12:36 AM, Mark A. Kruger mkru...@cfwebtools.com wrote: It's used by the installer - probably to register DLLs and add other stuff to the registry. I've noticed that CF9 will check and install these libraries if it doesn't find them. ... but it seems like an awfully low level OS problem to be affecting a Java ap eh? Dave is correct here, jvm.dll has a dependency on msvcr71.dll. In this case jrun.exe would terminate immediately after msvcr71.dll was loaded and write an error to the log file about not being able to load jvm.dll. The fix was to copy a newer version of msvcr71.dll to runtime\bin so CF used that and leave the older dll in system32. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Webservice error after CF 8.01 update CF FAILS TO START! [FIXED]
On Thu, Dec 2, 2010 at 3:47 PM, Mark A. Kruger mkru...@cfwebtools.com wrote: Mack, Thanks for that info so copying to the /bin directory does the trick? I would think you would have to un register and re register nice to know. Mark, When loading a DLL Windows searches first in the current directory and then in the system directories I think. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Clear template cache causes a server hang
Now that my server is back online, I'm back to investigating why I am getting the duplicate class name error. When I click 'clear template cache', I can watch the threads stack up (via seefusion) and the server eventually hang. I am not using trusted cache. I do have the 'save class files' box checked. Anybody have ideas about why this would happen? I've seen this a lot on CF9 while developing web services with complex return types, I haven't seen it in production though. The fix was to clear the template and component cache (I think in CF8 you only have the button to clear the template cache). Does it happen even if you don't touch the CFC's that are part of the web service ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Find duplicated contacts (and typos)
Hi! I have a contact application where I need to display possible duplicates within the existing contacts. Possible duplicates means different contact entries that refer to the same person and might have the same or slightly different information (typos). What I currently do is search for different levels of duplication (it's a single union of 3 queries): - the first query searches for exact duplicates (exactly the same name, address, email, phone, etc); - second query searches for matches using the soundex algorithm on a restricted set of fields and is given a lower matching score; - third query applies soundex on more fields and is given an even lower matching score. Is there a better algorithm or way to do this fuzzy duplication search over multiple fields (firstname, lastname, address, etc) ? Pointers to wikipedia, books, etc appreciated. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cant access cf administrator
On Tue, Oct 19, 2010 at 6:32 PM, Jay Birdsell john_birds...@hotmail.com wrote: HI I have just installed CF9 on a Solaris 10 box with weblogic 11g, when i try to log into cf administrator, I get a 500 error, cf itself is running as I can pull the log in pages for all my apps, of course when actually log in i get an error, as expected, because I have not configured anything. anyone have an idea what could be causeing the 500 error? What do the CF and web server logs say ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Find duplicated contacts (and typos)
On Wed, Oct 20, 2010 at 4:22 PM, Russ Michaels r...@michaels.me.uk wrote: Sadly I don;t think soundex is going to help you as this finds words that sound like other words (there, their, they're), which isn't going to pickup typos. In my testing soundex works reasonable well if I allow the 2 values to be within a distance of each other (I'm not searching for exact soundex matching but for the 2 numbers to be close to each other). For example select soundex('Morris'), soundex('Moris'); returns the same value M620 and that is ok for me. I think comparing each contact field on an OR basis is a sufficient way to find dupes, if none of those fields are the same then it is not really a duplicate. Even if you have a typo in the same, the other fields are going to have a match surely. Unfortunately I get very little duplicates that way because of small differences, especially in the address (East Drive vs East Dr.). -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cant access cf administrator
Jay, From the log file it seems for some reason CF cannot find the K2Encrypt class. On a standard install the class should be in #cf_home#/wwwroot/web-inf/lib/verity.jar. Do you have that file ? Is this the only error message that you get or do you get some other error messages early in the initialization phase ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Find duplicated contacts (and typos)
On Wed, Oct 20, 2010 at 7:35 PM, Russ Michaels r...@michaels.me.uk wrote: Crikey, you must just have a really shagged contacts list LOL. Have you tried Plaxo, this does a very good job of removing duplicates. Or does it need to be an in-house app ? Russ, This is part of a larger app and the contacts are coming from different sources (a couple of websites that currently have their own databases with customers and need to be integrated into the intranet app). -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cant access cf administrator
On Wed, Oct 20, 2010 at 9:25 PM, Jay Birdsell john_birds...@hotmail.com wrote: Jay, Mack I do have that file, but in a different directory web-inf/cfusion/lib. I might have to add it to the class path. the only other error message shows up as a single line entry in the application log Jay, I found this http://www.lmft4u.com/?p=36 by googling for the error message. See if it helps. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: High ASCII characters and jQuery
On Thu, Aug 19, 2010 at 6:37 AM, Rick Root rick.r...@gmail.com wrote: The jquery calls are going directly to a cfc method with returntype=JSON .. when viewed in firebug, I see the space, but in the HTML output I see the funky block questionmark. Rick, It might help if you set the charset explicitly in your cfc method: cfheader name=Content-Type value=application/javascript; charset=UTF-8 -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: High ASCII characters and jQuery
On Thu, Aug 19, 2010 at 3:40 PM, Rick Root rick.r...@gmail.com wrote: A fine idea... I already had a cfcontent in there so I added the charset cfcontent reset=Yes type=text/plain; charset=utf-8 (also tried application/json, which is apparently the proper mime type for json return values) didn't make a difference. A few things to check: - does the CFC have cfprocessingdirective pageEncoding=utf-8/ ? - does the cfm generated page have a charset defined either in a header or a meta tag ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
Thanks. That solved the problem. I installed the 32-bit version of ColdFusion 8, then set Enable 32-bit Applications to True for the Application Pool in IIS. Bob Mack I'm having trouble creating Access Data Sources in ColdFusion 9 (same issue with CF8) on a 64 bit Windows 7 box. Two questions: 1) Does anyone know when a 64 bit version of ColdFusion 9 will be released that is compatible with Windows 7? The current version is compatible with Windows 7. 2) Does anyone have a workaround for this issue, apart from installing ColdFusion on the XP Virtual PC? If you want to use 32-bit stuff, use the 32-bit version of CF. It'll work fine on a 64-bit OS. There will be some issues if you want to hook it to IIS, but those issues are documented and pretty easy to fix. On the other hand, maybe this is the divine hand of Providence pushing you away from Access and towards, well, anything else. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
I'm having trouble creating Access Data Sources in ColdFusion 9 (same issue with CF8) on a 64 bit Windows 7 box. Two questions: 1) Does anyone know when a 64 bit version of ColdFusion 9 will be released that is compatible with Windows 7? 2) Does anyone have a workaround for this issue, apart from installing ColdFusion on the XP Virtual PC? The specific errors are: When I create the Data Source in ColdFusion I get Unable to update the NT registry. Variable DRIVERPATH is undefined. When I try to use the Data Source I get Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application There apparently is no 64 bit Access ODBC driver but I can get to the 32 bit drivers at C:\Windows\SysWOW64\odbcad32.exe. Setting up the Access DSN there first, or replacing it after the Data Source is created in ColdFusion does not solve the problem. Thanks for any help you can offer. Bob Mack cantabr...@comcast.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Comcast SmartZone Incompatibility With CFMAILPARAM
When there's a space in the name of an attachment placed in a CFMAIL message by CFMAILPARAM Comcast SmartZone doesn't display the correct attachment name or type. SmartZone shows a random file name and an unknown type. The attachment can be downloaded from the web interface and is intact other than being misnamed. The attachment has the correct name when the message is popped from the Comcast mail server instead of being downloaded from the web interface. This issue affects attachments sent using CFMAIL but not attachments sent directly from my PC through Comcast, so I don't know whether the issue is at Adobe's end or Comcast's end. The workaround I'm using is to change spaces to underscores in the names of all attachments until either Comcast or Adobe fixes this incompatibility. Bob Mack memdir.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Exporting from ColdFuion to a Excel file
I have a different problem falling under the same topic. I'm trying to download a .csv file from ColdFusion to Excel via a browser. My code is: cfheader name=Content-Type value=text/csv cfheader name=Content-Disposition value=attachment; filename=Target_File_Name.csv cfcontent type=application/vnd.ms-excel file=Source_File_Name deletefile=No IE has no problem with this but Firefox strips off the .csv extension. It offers to open the file in Excel as Target_File_Name without the .csv, but this puts everything in the first column since the format is .csv, not .xls Or Firefox will save the file with no extension. I'm currently telling users to save the file, add the extension, then open in Excel. This works but it's a pain in the neck. Can anyone tell me why Firefox is stripping off the .cvs extension, and how I can prevent this? Firefox is evidently getting Target_File_Name.csv, so I wonder whether it's zapping the extension as a security issue. I can't find a setting for this, however. Thanks, Bob Mack ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ANSWER: Can a ColdFusion application see what processes are scheduled?
I can see the current scheduled processes through the administrator, but is there a way for my application to see what scheduled processes are active, and when they will next run? Thanks, Bob Mack The answer is on Ben Fortas' blog: http://www.forta.com/blog/index.cfm/2006/8/28/GetScheduledTasks-Function-Returns-Scheduled-Task-List CF can't to it directly, but a block of code written by none other than Michael Dinowitz provides a workaround. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Exporting from ColdFuion to a Excel file
I have a different problem falling under the same topic. I'm trying to download a .csv file from ColdFusion to Excel via a browser. My code is: cfheader name=Content-Type value=text/csv cfheader name=Content-Disposition value=attachment; filename=Target_File_Name.csv cfcontent type=application/vnd.ms-excel file=Source_File_Name deletefile=No IE has no problem with this but Firefox strips off the .csv extension. It offers to open the file in Excel as Target_File_Name without the .csv, but this puts everything in the first column since the format is .csv, not .xls Or Firefox will save the file with no extension. I'm currently telling users to save the file, add the extension, then open in Excel. This works but it's a pain in the neck. Can anyone tell me why Firefox is stripping off the .cvs extension, and how I can prevent this? Firefox is evidently getting Target_File_Name.csv, so I wonder whether it's zapping the extension as a security issue. I can't find a setting for this, however. Thanks, Bob Mack ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can a ColdFusion application see what processes are scheduled?
I can see the current scheduled processes through the administrator, but is there a way for my application to see what scheduled processes are active, and when they will next run? Thanks, Bob Mack ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Server Crashing
We are having some trouble with Coldfusion MX 7 on one of our servers. Every few days for some reason Coldfusion runs into a problem and can not connect to any of our data sources, bringing all of our sites down. Error: Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. I have to then actually restart the server to get Coldfusion working again. Do you think this is a problem with code that we have written on one of our sites or a problem with Coldfusion on this machine? Thanks, Heath Stein ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
Greetings. I intended to just read the earlier post in this thread but I inadvertently reposted it. I have the same problem, with Access databases and ODBC drivers using a current version of MX7. I'm investigating the suggestions previously posted earlier in the thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:51767 Bob Mack Which DB? We have seen similiar errors when using SQL 2005. It looks more than likely a network issue. Is the DB an ODBC connection or JDBC? Which drivers? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite Issue
HMS makes *NO* exceptions to the 50 second rule, even for rarely used administrative templates. This basically forces you off their shared server if you ever need any template to run more than 50 seconds. I had to spring for a $1,600 VPS to keep my site alive. While this has been a giant pain in the neck for me I do respect HMS` fanatical commitment to defending the performance of their shared servers. Their shared servers had persistent performance issues before they imposed the 50 second rule. Bob Mack Well, that's good to know at least. HMS has been telling me there is no way at all to override the setting. Yeah, that's crap. Ask to speak with a manager if they tell you that again. SeeFusion lets you exclude URL substrings. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Jingle Bells
Ha! You think thats bad?? Try living in the snow belt of the great lakes (ie...upstate nyseasonal depression capital haha) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and Microsoft Excel
Yep that helps! Both of these sound great, but i am not exactly sure on how to go about coding this. Subject: RE: ColdFusion and Microsoft Excel From: Ben Nadel Date: Mon, 27 Nov 2006 15:45:37 -0500 Thread: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:49062#261780 The simple solution (but not the *best*): Create the Excel table using very simple HTML in a ColdFusion string buffer (CFSaveContent). Then save that file to a temporary file (CFFile to a file in a temp directory, possibly GetTempDirectory()). Use CFMailParam tag inside of CFMail to attach the File (FILE attribute). Make sure SPOOLING is NOT enabled. Send the email. Delete the temporary file. You have to make sure not to spool as you might delete the file before the email is sent. If you cannot control this, you can safe the file to a temp directory then just clear that directly periodically (say, every night or so). Does that help? . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Question: I am a newb to CF and I have been assigned the daunting task of dynamically generating an excel file with absolutely no user action entailed. We currently have code that takes HTML and throws it in an excel file, but the user is prompted to download/save it. We dont want that. I have seen many different solutions given here, but i am not sure which to follow. The overall task is to create and excel file on the fly and then email it out to a user. Any help is appreciated. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion and Microsoft Excel
Ok I understand everything except this chunk of bad boy: !--- Get xls file name. --- cfset strXlsFile = REReplace( strTempFile, \.[a-z]+$, .xls, ONE ) / Thank you so much for your help by the way. Are you single ;-P ? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion and Microsoft Excel
This is a great solution. But what, dare i ask, would you consider to be the *best*? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion and Microsoft Excel
Question: I am a newb to CF and I have been assigned the daunting task of dynamically generating an excel file with absolutely no user action entailed. We currently have code that takes HTML and throws it in an excel file, but the user is prompted to download/save it. We dont want that. I have seen many different solutions given here, but i am not sure which to follow. The overall task is to create and excel file on the fly and then email it out to a user. Any help is appreciated. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Annoying CF Studio 4.5a Interface problems
Nevermind. It's always nice when Allaire updates the forums to indicate that a new release is out. Chris -Original Message- From: William James [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 1:07 PM To: [EMAIL PROTECTED] Subject: Re: Annoying CF Studio 4.5a Interface problems Forgot to mention, this goes for Studio and Server. It's been fixed since 4.5.1 RC1, but now the full versions are available from the Allaire site, so it soundsl ike today is upgrade day for you ;) - Original Message - From: "Kent Runyan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 06, 2000 3:05 PM Subject: RE: Annoying CF Studio 4.5a Interface problems I have another on for you related to windows 2000 Pro. With 4.5a I can't connect to my existing projects and I can't create new ones. When I navigate to where I want the projects to be, it seems to lose the path and only lists the current directory and says it can't find the RDS server. Studio 4.0.1 works fine on the same machine. -Original Message- From: Mike Hughes [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 1:02 PM To: Reuben King Subject: Re: Annoying CF Studio 4.5a Interface problems Hello Reuben, Thursday, Thursday, April 06, 2000, you wrote to me: RK I have Win 2000 on a Compaq Armada 1750.. I just recieved a Compaq Presario 1800 with Windows 2000 RK In CF Studio 4.5a (also tried 4.5.1rc2) Currently using 4.5a What mouse are you using? Touch pad? I use a Logitech Mouse Man Plus with a wheel, I do not use the Touch Pad RK Double clicking on a word doesn't select the word like normal -- it selects everything to RK the left of the cursor and to the beginning of the word. Always has worked for me this way (I like it), from Studio 3 I believe - but I know 4 work like this RK The mouse wheel doesn't work inside CF Studio.. Other such RK annoying behavior. My logitech works great in Studio RK The mouse works great in every other app on the system, its just CF RK Studio that acts like this. Maybe look at the driver for the mouse RK These may seem like minor whines but they can become quite irritating RK when working full time inside CF Studio. I know I would hate it. Thanks, Mike Hughes Web Applications Developer mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Security holes revisited -- reward offered
Pick up a copy of BlackIce Defender from Network Ice. Cost $40. I've read it will prevent just about every type of "kiddy script" attack known and is a must have for cable modem users. http://www.netice.com/ Chris R. Mack Manager, Internet Strategies Lockheed Martin Technology Services [EMAIL PROTECTED] -Original Message- From: Nick Call [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 04, 2000 11:44 AM To: [EMAIL PROTECTED] Subject: Security holes revisited -- reward offered Ok, fellow Listees, here's the deal... My boss's daughter has a boyfriend.. (can you smell the trouble already???). He is bent out of shape over the fact that I did not recommend that we hire him (I interviewed him and gave his skill sets an honest, thorough exam). He is good at A/V stuff, but his web experience/database experience is null. Anyway, back to the situation.. He has convinced the boss to pay him 2 grand to attempt to hack the system I built. He claims to be a super hacker, blah, blah, blah. I am not too confident that he can do it, but there is a small chance Multiple minds are better than one. I have gone over and over all the stuff I know, but I am more than likely missing some stuff. Anyone care to share their CF/NT/IIS security checklist or other advice? It's escalated into all-out war. He is going to stop at nothing to make me look bad, and I will stop at nothing to prevent him from succeeding. Thanks in advance. I will custom print 5 free T-shirts with your logo (in one color) on them if you give me advice that plugs up a hole that I didn't know about. Thanks in advance. Nick Call [EMAIL PROTECTED] http://www.graphixonline.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Who Said netscape is dead as for People dressed in black we aring berets.....
One reason to not use Netscape is the mailto links will only pull up Netscape Messenger unless you find an Outlook Express dll so that Netscape will use OE instead of itself. I agree that the page needs to "work" in both browsers, it's just that a major annoyance with the email will prevent people from using Netscape. I personally use them both, because I still run across pages that only one or the other browser will display properly. I also use Mozilla, but I don't recall the messaging being any more robust than the 4.x versions. I will have to look at it again. Chris -Original Message- From: Will [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 10:51 AM To: [EMAIL PROTECTED] Subject: Re: Who Said netscape is dead as for People dressed in black wearing berets. Well, that's no reason to not use Netscape as a browser since Outlook Express has nothing to do with IE. Plus, the new Mozilla Browser (Netscape 6.0 when it's released) will have multiple mail accounts, and from the alpha version, it looks like it'll handle them even better than OE. But the fact remains that you need to use both browsers if you're a good developer ;) Gotta make sure all your compatibilites are in place. hehe - Original Message - From: "lsellers" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 28, 2000 10:49 PM Subject: RE: Who Said netscape is dead as for People dressed in black wearing berets. Wonder how many people switched to IE/OE just for the fact they could handle multiple email accounts / newsgroups in the same sign - on. Netscape blew that one too! Duoooh. Shut down browser | Login as a new User just to check another email account, bad move NS. I would be one. That was _THE_ reason I switched. --min -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Search Engine Friendly Variables (?)
There's an article about the entire process in the January 2000 issue of Cold Fusion Developers Journal. The code can be found at www.coldfusionjournal.com. Here is the link to the forum thread: http://forums1.allaire.com/DevConf/index.cfm?Message_ID=18401 For those of you that don't read it, I have found every issue of CFDJ to be very informative and well written. Chris R. Mack Manager, Internet Strategies Lockheed Martin Technology Services -Original Message- From: Jay Sudowski [mailto:[EMAIL PROTECTED]] Sent: Monday, March 27, 2000 6:45 PM To: [EMAIL PROTECTED] Subject: Re: Search Engine Friendly Variables (?) Allen, I'm not sure about the internetsoccer link you have there, but the first link is from a Vignette StoryServer. I've actaully got a friend who just landed a job at sportal, and they're teaching him TCL, the lanague that StoryServer is based upon. Each set of numbers between the comma's mean something to Story Server, but I don't have a clue ;-). The major problem, as I understand it, with search engines not indexing ColdFusion based urls is that they don't visit and URLs that have a question mark in them. IE, Altavista wouldn't spider something like www.yoursite.com/order.com?a=1234b=5345867. Many moons ago, there was a long thread about how to create search engine friendly links on the Allaire Forums. The gist of it was to create a link using /'s rather than question marks, equal signs and ampersands. IE, to make that URL above search engine friendly, you link to www.yoursite.com/order.cfm/a/1234/b/5345867. A URL like this will still get executed by the CF server, you just have to create a list, using the / as a delimiter, and then set your vars using the list. Sorry I don't have any specific code examples. This topic was discusssed long ago and I never go around to implementing it into any of my sites. - Jay Hello, I've noticed some URL's set up in ways like these two. Could someone please explain them for me? The little understading I have it is so that the search engines will index the pages. Is that correct? How the commas function? As "="? ( http://www.sportal.co.uk/football/news/article/0,5081,47198,00.html ) http://www.internetsoccer.com/handler.cfm/article,display/Con_ID,2/Locatio nCode,NAmerica/ID,26307/At_ID, ) Thank you. == - == == - ==== - == Allen Graetz USI - Web Application Programmer 1-800-USINTERNET x241 612-253-3241 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.