Re: Can anyone decode this?
On 5/17/2011 6:13 AM, Will Blake wrote: Will cfqueryparam not protect input sufficiently enough to disrupt this kind of attack? Yes, cfqueryparam would prevent the SQL code in that attack from executing. Content of parametrized values are never evaluated by the database for SQL statements. Should additional measures be used? Yes additional measures should be used, because there are other types of attacks that do not use SQL injection. ~| 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:344566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: screenshots
On 5/16/2011 1:11 PM, John M Bliss wrote: Hi! Has anyone built anything with CF that'd take as an argument a URL and would return an image representing a screenshot of that page? Is this crazy talk? Yes, it is pretty crazy, ColdFusion has NO SCREEN of which to take a SHOT. There is the cfdocument... tag that will create a PDF of HTML. There is the cfhttp... tag that will make a request to an URL for HTML. But the rendered document will be based on the internal rules, not anything that necessarily aligns with any make or model of browser or OS. ~| 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:344558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help us Please - CF 5 Server Licenses
On 5/5/2011 5:11 AM, Ralph B Littleleaf wrote: PS A friend tried our legacy code on their CF 8 box, and it works. So CF 5-8 versions are possibilities so long as we can get the licenses at a price we can afford. I can not speak to the affordability for you, but I just wanted to make sure you know that CF8 *IS* still officially supported and sold by Adobe. ~| 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:344262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how to restart a specific CF application (not app server)
I know I could restart the ColdFusion service and that would probably do the trick. However I'm anticipating needing to do modify onApplicationStart several times during the course of development, and I would prefer to find a way to restart just this particular application. Set the applicationTimeOut values (i.e. this.applicaitonTimeOut) to 0. Run a template in the application and the application immediately times out. Then the next time (and all times until you again change the applicationTimeOut value) the onApplicationStart event will fire. ~| 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:344270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 301 Redirect on an HTML page
On 5/5/2011 12:05 PM, Chris Bracciano wrote: Yes, Application.cfm|cfc files are only executed in conjunction with other cfml templates. If worst comes to worst, you could do META and|or JavaScript redirects, but these would probably be little better then the current situation. The better answer is to work with your hosting provider. If you are on *nix hosting, htaccess can be set up site by site and|or directory by directory so being on shared hosting _should_ not be an issue. But doing this at the web server level is the best way to capture ALL the searching engine mojo of older pages. ~| 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:344277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 301 Redirect on an HTML page
On 5/5/2011 1:26 PM, Jacob wrote: If not, then you can use something like this which I have used in the past: cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=http://www.domain.com/url.htm; cfabort Except that this code does not work so well on HTML pages, which is what the OP was asking for help with. ~| 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:344281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 301 Redirect on an HTML page
On 5/5/2011 3:55 PM, Jenny Gavin-Wear wrote: I'd be interested in what everyone thinks about using the above, I've always used the meta way before. My understanding is that it is better the META tags from search engines point of view. But it is slightly more work on the servers part then letting the web server return the 301 response immediately. ~| 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:344290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS XML Parse
On 5/3/2011 9:14 AM, Torrent Girl wrote: cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' That looks to be a pretty large XML document. There are definite limits on how large of document that xmlParse() can process. As xmlParse uses a DOM parsing methodology, the entire resulting data structure (which will be several times larger the the original text document) must fit into memory. If this document is too large to dom parse you need to do something that parses it segment by segment, such as a sax parser. ColdFusion does not have a built in sax parser. I used Ben Nadel's pseudo parser [http://www.bennadel.com/blog/1345-Ask-Ben-Parsing-Very-Large-XML-Documents-In-ColdFusion.htm] once when I needed a quick solution. One could also dive into the underlining Java and access some true sax parser through it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS XML Parse
On 5/3/2011 10:18 AM, Torrent Girl wrote: Actually, I can dump the contents of the cfhttp.filecontent return with no problem. That is because at that point, the data is still flat text. One can fit a WHOLE LOT of flat text into a gigabyte or two of ram memory. The problem will occur when you try to parse that flat text into a DOM relational data structure. Now IF you do not need to parse the flat data, you can use xmlTransform(), and maybe xmlSearch(), to apply XPATH to the large flat text data and create smaller subsets of the XML. That might get you where you need to go. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Strange Hack... WHY?
On 4/15/2011 10:47 AM, Mark A. Kruger wrote: I'd say they want to steal any leads that come in to you guys through the website. And|or deliver malicious content to those visitors that accidentally end up there. ~| 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:343763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Parsing .css files with CF
On 4/14/2011 9:21 AM, Rick Faircloth wrote: So just use: style.cfm - cfcontent type=text/css charset=ISO-8859-1 cfset variables.color = ##fff cfoutput body { color:#variables.color#; } /cfoutput Pretty Close. You only need to double the ## symbols, if the content is INSIDE a cfoutput block. As you start the cfoutpout block on the next line, you do not need to double ## where you have them. ~| 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:343722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Parsing .css files with CF
On 4/14/2011 10:43 AM, Rick Faircloth wrote: Nevermind... duh... wrong file path... I was about to suggest typing the CSS path into your browser url bar to make sure there is actually a file located there. ~| 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:343729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom tags in CF 9
On 4/12/2011 12:04 PM, Donnie Carvajal wrote: Hi, I recently installed an enterprise version of CF9 and the default directory is c:\jrun4 and there is no CustomTags directory. I added my customtags directory from my MX7 server and the custom tags calls are returning errors that they can't be found. Does anyone know where the CustomTags default directory is? BTW, this is a library of tags that all of the apps on the server will use, so placing them in the root of the web app is not an option. Thanks, Donnie If you have a c:\jrun4 folder, that means you installed the multi-server or J2EE version that puts ColdFusion as a Java Server under a JRun, rather then the other way around. That means your Custom Tags path is going to be deep inside each of these servers. For example for the default 'cfusion' server it is located here: C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\ Obviously if you use the multi-server feature and create other ColdFusion server instances, there will be a corresponding path for each of them. ~| 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:343680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom tags in CF 9
On 4/12/2011 12:28 PM, Donnie Carvajal wrote: Thanks for the feedback. The intention is to set up a multi-server instance. I did find the customtags and the cfx directories for this instance; however, the customtags are more of a library that we use across servers. Is there a generic place that i can put these files so that all instances that I will install on this server will see them? I would like to put the CFX tags and components in a common place as well. Donnie Not out of the box. But you define as many custom tag locations as you like in the administrator. So it would be easy enough to use your c:/jrun4/customtags/ and just define that in each and every instance that you would like to search that directory for tags. ~| 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:343683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom tags in CF 9
On 4/12/2011 1:21 PM, Raymond Camden wrote: Don't forget that in CF8 you gained the ability to specify custom tag folders in your Application.cfc file instead. I know you are looking for the simplest solution, but this is an option as well. I do forget about that cool option all to often. ~| 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:343687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: replacelist question
On 4/5/2011 9:46 AM, Jenny Gavin-Wear wrote: I can't understand how the is not replaced when it is the first word in the list. When the word is at the beginning of the string it DOES NOT have a white space character in front of it. Your list is including a white space character in front of each word. ALL the characters between the comma's count, even the invisible ones. ~| 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:343549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: replacelist question
On 4/5/2011 9:46 AM, Jenny Gavin-Wear wrote: Cfset session.realSearch = lcase(replacelist(session.realSearch, and, or, in, of, at, it, the, on, )) What you probably want is: Cfset session.realSearch = lcase(replacelist(session.realSearch, and,or,in,of,at,it,the,on, )) Assuming you do NOT want to replace these strings when they are part of larger words. ~| 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:343550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSEARCH puzzle
On 3/29/2011 3:32 PM, Kevin Parker wrote: That's correct - context is working fine but no mark-up. Now that's actually quite interesting - I added a cfdump as you hinted and the markup is in the dump but when I output the context to the page as part of the search results it's not. Is it there if you view source in your browser? ~| 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:343396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What event specifically triggers OnApplicationStart?
On 3/28/2011 11:10 AM, Dave Burns wrote: My code looks like this: configName = dev if CGI.SERVER_NAME contains blah.com configName = production Which means that if I (or any joker poking at your site to see if they can do something) who requests your site by its IP address could set your production server into dev mode. CGI.SERVER_NAME is probably populated, but it is populated by what I put into MY browser, just as long as that resulted in a request to YOUR server. ~| 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:343367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Text to voice
On 3/11/2011 2:06 PM, Judah McAuley wrote: someone says, Hello? it will trigger a Human CPA event and restart your dialog that plays the we really need help message. I would also hope this project is being done with the cooperation and assistance of the authorities that will potentially be receiving these calls. I'm not sure how the average 911 or police operator would react to receiving robo-help calls, if they have not been advised on this possibility ahead of the time. ~| 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:342941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion License and Builder
On 3/10/2011 6:47 AM, DURETTE, STEVEN J (ATTASIAIT) wrote: I swear that I saw somewhere (I thought on this list but couldn't find it) that the licensing for CF9 was a change for what I had said before about the dev/hot spare, and it didn't have the ip restrictions. Yes, the EULA for CF9 has language that allows one to use the same license for a production server on a staging/cold backup/development environments. I don't know about the web site, but you should be able to find it in the EULA, and an internet search should turn up a couple of blogs that highlight the changes in the EULA. The free developer license (aka no license) that has long existed has a two IP restriction. ~| 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:342888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to pass a file to a web service.
What would be the web service equivalent of this HTTP request? wsTest.cfm |cfhttp url=https://secure-devsite/pur-loader/ws/ppur_v0.cfc; method=post multipart=yes cfhttpparam name=authentication value= type=formfield cfhttpparam name=ppurfile file=#expandPath('ppur-test.xml')# type=file cfhttpparam name=method value=dataSubmit type=url /cfhttp cfoutput#htmlEditFormat(cfhttp.FileContent)#/cfoutput | ppur_v0.cfc |cffunction name=dataSubmit access=remote output=no returntype=xml cfargument name=authentication type=string required=yes hint=authentication value cfargument name=ppurFile type=string required=yes hint=file upload field cfset var dataResult = cfset var rootpath = getDirectoryFromPath(getCurrentTemplatePath()) cfset path = replace(rootpath,htdocs/pur-loader/ws/,uploadedFiles/ppur/,ONE) cffile action=upload filefield=ppurFile destination=#path# nameconflict=overwrite cfset var validate = xmlValidate(cffile.serverDirectory '/' cffile.serverFile,replace(rootpath,'/ws/','/schema/ppur-data-transmission.xsd','ONE')) ... /cffunction | I.E. How would one pass a 'file' to a web service? Or can you only pass the content of the file as a string? Which is differernt and apparently does not work for what we are trying to do. When I did that, we would start getting 'java heap out of memory' errors dealing with the quanty of content we need to pass to this web service. To clarify, is there a way to pass a file reference through a web service object that can be used in a cffile action=upload... tag in the cffunction... block? ~| 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:342890 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.
On 3/10/2011 8:05 AM, Dean Lawrence wrote: Ian, you would need to convert the uploaded file to base64 before submitting it to the web service. This essentially will transfer the file as text. What would be the result of converting a text file to base64? I'm not dealing with a binary file format. This file is XML data stored as basic text, ASCII I presume. It is the size of the file that is causing problem. For some reason, ColdFusion can handle it works with a file that has been uploaded by the web server to the temp folder. But receiving the contents directly through a web service invocation throws Java Heap Out Of Memory errors. ~| 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:342893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: file upload - preventing double or more full stops in file name
On 3/7/2011 11:40 AM, Don wrote: Why do you need to do this before you process it with CFFILE? Because once its uploaded the server hacks off the last (.) For example: original file: somefile.mack.txt renamed file on server: somefile.mack Well, as Dave indicated, ColdFusion is not actually involved in the file upload. No matter that the parameter of the cffile... tag is called. The flow is: User picks file with client (i.e. browser) file form control. The user submits the request. The client reads the file from the user's file system and encrypts it into the header of the request. It then sends the request to the web server (i.e. IIS, Apache, etc). The web server decrypts the file from the header to a temporary location. (C:\JRun4\servers\cfusion25\SERVER-INF\temp\cfusion.war-tmp\neotmp4910092545170934955.tmp) for example. The web server then tells ColdFusion about the uploaded file and where it was. If you want to do anything with the file data before the last step, you will either have to have code running on the Client system OR you might be able to get some of the data from the raw request headers. ~| 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:342817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Aligning text from top to bottom
On 3/7/2011 11:54 AM, Torrent Girl wrote: Disregard - I found it :) div style=-moz-transform: rotate(90deg); -moz-transform-origin: bottom left;font-size:30px This will be rotated 90 degrees. /div In Mozilla based browsers. ~| 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:342818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: file upload - preventing double or more full stops in file name
On 3/7/2011 12:52 PM, Don wrote: 200 Content-Disposition: form-data; name=b_file; filename=C:\Documents and Settings\dsdfsd\Desktop\clean up\test.docupload.doc And that is different from the cffile.clientFile property? Do note that cffile.clientFile is the full file name, cffile.clientFileName is the file name with the extension (i.e. the part after the list 'full stop' as you call it) stripped off. ~| 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:342821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Calculating Percentage
On 3/1/2011 12:31 PM, John Eubanks wrote: I know this is probably a dumb question, but I need help anyways. I am building a test in coldfusion for end users. I need to calculate the total percentage and display it. How do I do that? For example, if a user gets six out of ten questions correct, calculate 60% and display it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 2r hour time format
On 2/7/2011 8:14 AM, Orlini, Robert wrote: Thank you all. I looked over the livedocs for CF and formatted it this way: #TimeFormat(get.prodreccounttime, hh:mm:ss)# However, instaed of the time 1630 becoming 16:30 I get 12:00:00. What did I do wrong here? RO What type of data is 'get.prodreccounttime'? Is it a date-time object, which is what the TimeFormat() function requires. Or is it a numeric value that just looks like a time value to a human? ~| 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:341939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 2r hour time format
On 2/7/2011 8:24 AM, Orlini, Robert wrote: Ahh. Good question. It is just numeric. I beleive I need to change it to date-time object? You will need to convert it, if you want to use the timeFormat() function. Otherwise you could just use some basic string manipulation functions to format the output in the desired way. ~| 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:341942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Math weirdness
On 2/3/2011 12:56 PM, Jen McVicker wrote: Can someone explain it to me in small words so that I will understand? ;-) Computers do not understand decimal (base 10) numbers. They only truly understand binary (base 2) numbers. Sometimes when converting back and forth between the base 10 numbers we humans like to use and the base 2 numbers that computers have to use, small differences in rounding occur. 99.9% of the time, the computer systems handle these and we humans can ignore the base 2 nature of computers. But sometimes we really must be computer programmers and understand the real world of binary computers. ~| 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:341852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 9:41 AM, Aaron Renfroe wrote: Hello All! SELECT DISTINCT PartNumber FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number WHERE Top200.part_number = GriffinDataRevised.PartNumber INNER JOIN will enforce a filter that will only return records in a given 'partnumber' is in BOTH tables. The return of 98 recrods would indicate that there are only 98 values of 'partnumber' that are in both tables. If that is expected and known behavior then what you want is an OUTER JOIN that says return all records from one table PLUS any records from the other table IF they match. IE FROM GriffinDataRevised LEFT OUTER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number This will return all the records from the table on the LEFT side of the JOIN 'GriffinDataRevised' OR FROM GriffinDataRevised RIGHT OUTER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number This will return all the recrods from the table on the RIGHT side of the JOIN, 'Top200' Some database management systems support the FULL OUTER JOIN that will return unmatched records from BOTH sides of the join. ~| 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:341793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 10:22 AM, Aaron Renfroe wrote: Hello Ian and thank you! But my query was still running wrong, correct? Not necessarily, maybe your data is wrong. You may need to provide some more description on what data is in each of these tables and how you are trying to utilize it before we can help much more. IS there a ONE TO ONE or a ONE TO MANY relationship between Top200 and GriffinDataRevised? If ONE TO MANY, do you not want all the record from the MANY side? IF not all the records, which record of the MANY is the one that you want? ~| 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:341796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: But i'm now getting an error that the part_number field is ambiguous. Ugh That just means that the field is in both (multiple) tables and the database wants you to tell it which table you want to use to get the value for this column to use in this record set. Just prepend that column name with a table name. You seem to be doing that in all the fields except the 'Make' field in the ORDER BY clause. Just add a table name to that field as well. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: On another note, the query that brought back 98 results may have been working right, i found another 78 records in another table for race car radiators, i'm almost guessing that the last few are in another table that would make the total 200 records. Then you are probably looking at three SELECT statements to return all the desired data for the record set. My first choice would probably to do all three SELECTS in a single query with a UNION clause to combine them into one record set. But this is not the only option available. ~| 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:341799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL query question
On 2/1/2011 1:23 PM, Debbie Morris wrote: What am I overlooking? The evil of using * in SELECT clauses. When that is done, database drivers are know to cache the columns and datatypes of the SQL queries. Then somebody comes along and changes the database structure, like you adding a field. Now the database structure does not match the cached structure stored by the database driver and this type of disconnect occurs. The solution: Replace those p.* and pt.* short cuts with that actual columns you need in your record set. ~| 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:341804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL query question
On 2/1/2011 2:21 PM, Charlie Stell wrote: I assume this is something on CF's side - as restarting the CF service also fixes it. Not ColdFusion itself, but the database drivers used by ColdFusion and the cached (pooled) data source settings. Changing the Datasource to not used pooled settings might eliminate the caching of the database columns and types. But I have never tried it, having long ago accepted the better practice of not using * in my SQL. ~| 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:341805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Application.cfc cfinclude
On 1/27/2011 3:12 PM, Michael Grant wrote: can't you just docfset onApplicationStart() / to get the method to fire? Do you really need to rename the app scope? Yes, you can /fire/ the method that way. But that is OFTEN not exactly the same as triggering the onApplicaitonStart *event*. Sometimes one just really wants to experience the true event trigger. You can do this relatively simply by renaming the application name value OR setting the application timeout value to 0. ~| 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:341582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: URL variable security
On 1/24/2011 8:50 AM, Richard White wrote: ok thanks for the help I just wanted to add that your question, concerns and the replies DO NOT just apply to URL variables. They apply to ANY and ALL data received from the client. Including form POST values, COOKIE values, ect. Anything and everything received from external, untrusted sources must be considered suspect. I mention this because many people have the mistaken impression that form POST variables are more secure and thus do not need to be tested just because they are not written in the URL bar of the browser. This is most definitely not true. ~| 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:341132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Session variables security
On 1/24/2011 8:57 AM, Richard White wrote: Hi, When the user logs in, I save their username to the session scope. Would i need to re-validate that username at the top of every page that uses it in a database query? I previously thought this was not necessary but if it is possible for someone to send malicious sql injection then surely it is also possible (even though very unlikely) for someone to send code that changes the username stored in the session to some malicious sql injection. thanks Only if there is a place in your code for them to do so. If you have a vulnerable piece of code that can give unexpected and undesired results because of malicious inputs form the client, then you have a problem. But it is not an insecurity in the session variables is is an insecurity in your application and how it is setting those variables. There is no way for a user to send random code at a CF server and have it do anything to session variables unless it is happening somewhere in the CFML codebase. ~| 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:341133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Oh The evils: .NET on a Unix w/ Apache web server
Is this even possible. Some internet searching is giving me hints about projects like Mono and DotGNU. Are these (or something else) viable ways to run an .NET web application on a Unix box? Or is this just a crazy idea. Our organization has a contract to produce an external web application to bring one of our business processes on-line. Just yesterday it was revealed that this project will be done in .NET. But we do not currently have external windows web servers. So now the question is do we rush out and acquire an windows box to be an external server. Or is there some practical way to run a .NET application on a Unix web server? ~| 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:341052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Permanent Redirect (301)???
On 1/18/2011 1:31 PM, Justin Scott wrote: There are also non-CF ways of doing this such as URLRewrite engines. IIS 7 has a preferred domain URL filter which makes this really, really easy and applicable to the entire site with a few clicks. -Justin Scott Of which the best is probably at the DNS (Domain Name Server) level. Set one domain to be an alias of the other so that everybody everywhere (including search engines) know that both names are to the same content. ~| 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:340994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Permanent Redirect (301)???
On 1/18/2011 1:41 PM, Aaron M Renfroe wrote: Would i place that in my application.cfm or at the top of my pages? Technically the same thing. The purpose of Application.cfm|cfc is that is is code that is run before (at the top of) all normal pages. ~| 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:341003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Show time in field on click
On 1/4/2011 7:16 AM, Orlini, Robert wrote: Still not showing when I click the button. I also tried putting my_time into the field. RO document.myForm.myDate.value = my_time; IIRC, I believe that those refer to the ID's of DOM elements, not names. Try changing your form to. form id=myForm input id=myDate type=text size=10 / ~| 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:340370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Show time in field on click
On 1/4/2011 7:44 AM, Orlini, Robert wrote: Russ/Mike, Is there a way just to show the time and not the date? Use the appropriate methods of the date object. http://www.w3schools.com/js/js_obj_date.asp I would probably start with the getTime() method. document.myForm.myField.value = my_time.getTime(). ~| 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:340378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Show time in field on click
On 1/4/2011 7:44 AM, Orlini, Robert wrote: Russ/Mike, Is there a way just to show the time and not the date? Ok, looking closer at the full date object reference. http://www.w3schools.com/jsref/jsref_obj_date.asp toTimeString() OR toLocalTimeString() are probably what you are looking for. ~| 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:340380 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Show time in field on click
On 1/4/2011 10:05 AM, Russ Michaels wrote: Michael, you do indeed need an ID to be defined to use getElementById(), True, if you use the getElementByID() function. But Russ was showing the docuement.formName.inputName syntax which is based on names and thus you do not need to use IDs with that method. ~| 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:340392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Both mime types and file extensions can be spoofed by a hacker as both are just data that hackers can manipulate on their end of the client-server relationship. Unless you are running code that actually inspects the content of the file to confirm that it matches the file type and the mime type reported by the http headers (which are trivial to set by users who know how from the client) in the request, you are opening a vulnerability here. Even if you do check, the file is already uploaded while the checking is occurring, and a hacker can take advantage of the delay to execute his code before your validation has a chance to reject the file. And ALL of this is based on what the hackers are doing today with today's vulnerabilities. Why leave your framework in a position where it would be at risk if hackers figure out tomorrow some other way to hide code in innocent looking files and execute it if the file is under a web root. ~| 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:340435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Exporting a Spreadsheet file
On 12/20/2010 10:41 AM, Rick Colman wrote: This works fine in IE, etc. : cfheader name=Content-Disposition value=buylist_job_#session.projectid#.xls This is the way I usually see and use that tag. cfheader name=Content-Disposition value=filename=Result.xls NOTE the *filename=* part of the value parameter. ~| 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:340166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Database query - match 1 or more zeros
I have a varchar field that can (shouldn't, but can) contain a variable number of zero[0] characters. I want to return all rows where this field only contains zeros, no matter how many zeros it may contain. Due to too much holiday potluck, my lethargic brain can not produce even a glimmer of an idea of a concept for this. TIA for any suggestions or guidance. Ian ~| 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:340104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database query - match 1 or more zeros
On 12/17/2010 11:41 AM, Michael Grant wrote: I think regex is the way to go for you. WHERE field = [0]* I think would work. Thanks, that was the seed of the idea I needed. WHERE REGEXP_LIKE(grower_id, '0+') I just changed it to 0+ because I wanted to match one or more zeros NOT zero or more zeros, which I expect would have matched ALL rows. ~| 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:340110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Tutorial on creating this pagination?
On 12/17/2010 12:54 PM, Adam Parker wrote: What am I doing wrong? You need to put them inside of foutput blocks. cfoutput#pagination.getRenderedHTML()#/cfoutput ... cfoutput#pagination.getRenderedHTML()#/cfoutput ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Log That Keeps Track of Scheduled Tasks
On 12/10/2010 8:53 AM, Asaf Peleg wrote: Is there a log that CF keeps that records when it ran a task or something of this nature. You have to enable it from the ColdFusion Administrator. But then it will record the execution and scheduling of all the tasks. ~| 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:339982 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMail problem since upgrading to CF9
On 12/10/2010 9:04 AM, Rick Root wrote: [Error,scheduler-4,12/10/10,11:40:51,,Could not connect to SMTP host: 69.41.172.242, port: 25, response: 421 and [Error,mailWorker-6,12/10/10,10:50:29,,Could not connect to SMTP host: 69.41.172.242, port: 25, response: 421 Does the user that your ColdFusion run as have permissions to make connections to the mail server? ~| 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:339983 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Files Management Question
cfdirectory http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_d-e_03.html cffile... http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_02.html ~| 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:339934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: REQUEST.cfdumpinited
On 11/30/2010 11:23 AM, Sean Henderson wrote: CF9 workaround? The output format property of CF9 that allows you only output a text version of the cfdump content? ~| 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:339632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Get day of week of fourth Thursday of month.
I know I've done this in the past, but for the life of me, my mind is not coming up with any ideas at the moment. I'm looking for an algorithm to to find the calendar date for the x-th day of the n-th week of a month. TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Get day of week of fourth Thursday of month.
On 11/29/2010 2:56 PM, Matt Quackenbush wrote: http://www.cflib.org/udf/GetNthOccOfDayInMonth Thanks no thinking involved. Though I was half way there on my own. ~| 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:339599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Get day of week of fourth Thursday of month.
On 11/29/2010 4:18 PM, Matt Quackenbush wrote: Heh. Sometimes, like when your brain feels like mush, no thinking involved is a good thing. ;-) IT SURE i...@#! +infinity ~| 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:339603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
If you don't want to use a table or grid, you may also want to try then under utilized pre.../pre tags that gives you old fashioned character alignment, over riding the HTML default to ignore spaces and character in output. ~| 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:339462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
On 11/23/2010 10:40 AM, Rick Colman wrote: pre by itself works great, but then I get one giant long 500 character text line ... Well, either populate the string with some carriage returns and|or new line characters. OR You can apply CSS to the pre element, it's falls somewhere between a paragraph and a division tag contextually. But it can be given a width and height and all that fun CSS stuff. ~| 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:339466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
New Apache sites return 500 Internal Server Error for all CFML requests.
This is an ugly one. I think it is an Apache2 - ColdFusion 9 web server connector problem. I have two Solaris Unix web servers. Each of these servers have a dozen and a half Apache web sites each one connected to one of five ColdFusion instances. All, but *TWO* of them are working properly. We created two new Apache web sites and connected them to a new ColdFusion instance. This worked fine on one of our boxes, the development one, but not on the other, production of course. Whenever we try to request a cfm url from one of these sites on the production server we get a 500 Internal Server Error. HTML pages serve up just fine, and the new instance's Administrator runs fine on its 8305 port. So both Apache and ColdFusion seem to be working independently, but they are not talking to each other. All the other Apache sites connected to the other four ColdFusion instances also work properly. This has led me to investigate the web server connectors. They have always been tricky and problematic to set up on these boxes. The built in tools have never worked for us on these boxes and we have always had to manually compile the connectors and configure the connections in the web sites.. But, as far as I can tell, all the connection setups are the same between working examples and these non-working sites. Any insights into what else I should be checking and|or how web server connectors actually work (they have alwasy been mysterious black boxes to me) would be greatly appreciated. TIA Ian ~| 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:339479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
Just an off-the-wall idea. Did you try a different order to the words? I.E. chemical NEAR romance AND my I was speculating what might happen of the 'noise' word came later in the list. ~| 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:339480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
On 11/23/2010 2:48 PM, Dave Watts wrote: In the directory in which the connector modules are installed, there should also be a text file. You should be able to enable the log level from this text file. What text file where? I looked into the /opt/jrun4/lib/wsconfig folder and each 'connector' folder under that, and I do not see any text files, let alone any text files that I recognize as affecting logging details. ~| 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:339485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
In the mean time, I took a closer look at the logs (I wasn't looking in the Apache logs before). I found this block for the last attempt to request a cfm page. [Tue Nov 23 15:17:17 2010] [notice] jrApache[18177: 60758] could not open serverstore /opt/jrun4/lib/wsconfig/www/jrunserver.store: No such file or directory[Tue Nov 23 15:17:17 2010] [notice] jrApache[18177: 60758] Couldn't initialize from remote server, JRun server(s) probably down. What I don't understand is why could it not open that file, it is there and it has the same permissions as all the other web server connectors. /opt/jrun4/lib/wsconfig/www $ ls -al total 166 drwxr-xr-x 2 root root 512 May 29 13:51 . drwxr-xr-x 8 root root 512 May 29 13:51 .. -rw-r--r-- 1 root root 14 May 29 13:51 jrunservers.store -rwxr-xr-x 1 root root 81528 May 29 13:51 mod_jrun20.so The following is the 'calpip' connector folder that is working just fine. /opt/jrun4/lib/wsconfig/calpip $ ls -al total 166 drwxr-xr-x 2 root root 512 May 29 13:51 . drwxr-xr-x 8 root root 512 May 29 13:51 .. -rw-r--r-- 1 root root 14 May 29 13:51 jrunservers.store -rwxr-xr-x 1 root root 81528 May 29 13:51 mod_jrun20.so ~| 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:339487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
On 11/23/2010 3:59 PM, Dave Watts wrote: I don't think the file should be jrunservers.store. I'm not sure why that's working in the existing directories (maybe it isn't being read properly in those directories either, though). I would guess not either, which leads me back to why I find these web server connectors to be such a black box! They just make so little sense to me. Especially since each and every system I have looked at that file is a single, empty, proxyservers= line. But changing those file names on the working public servers is not something I can do today. If I bring down the working sites 30 minutes before the end of the last day before my five day holiday, might just ruin that holiday for me. So I will come back to this issue on Monday and advise you all on what the results are then. ~| 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:339489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion standard edition version switched to developer edition?!
On 11/18/2010 12:58 PM, Tim Do wrote: I was able to find a key that matched. Server is back up now. Question is, how/why did the config file get set to developer edition... it was never installed as a developer edition to begin with. How long was the server running? If it was something around 1 month, could it have unintentionally been configured as a 'trial'. Those run for 30 days as a full server with only a few differences and then revert to a developer edition at the end of the trial. ~| 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:339384 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFCs for AJAX
On 11/16/2010 12:06 PM, Donnie Carvajal wrote: I thought the onRequest method caused issues with calling CFCs remotely. Can cause problems. The problem usually being that the onRequest, onRequestStart and|or onRequestEnd cause data to be added to the request response that AJAX can not digest. White-space being a very easy to over look addition. But if you understand that your request functions are going to (or may) be consumed by a web service or AJAX. And you take care to create them so as to not break the response to the web service or AJAX request then they can be used. ~| 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:339297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Blog software
On 11/9/2010 9:54 AM, Jason Fisher wrote: Granted they shouldn't have unrestricted access, but I would argue that you should be able to call them within your own application or else the ability to build complex applications begins to be pretty well hampered, no? Well, true. But hosting complex applications on shared hosting servers is pretty hampering right at the start, isn't it? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
On 11/8/2010 9:55 AM, Robert Gallagher wrote: Using attachment forces the user to make a selection on a dialog box and I wanted to bypass that dialog box and have the file open every time. You do not get to make that choice. It is *MY* computer and *MY* browser and *I* get to say what happens to any content you choose to send me. ~| 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:338957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm just making this way too hard...
On 11/5/2010 12:14 PM, Rick Faircloth wrote: What am I doing wrong? (Besides mostly likely making this way harder than it should be... just fog on the brain today) Rick I suspect that datatime is a column name in your database scheme. IF so that would mean you are trying to use a ColdFusion function to parse the value of a database column in the record set from a sql query inside the cfquery... block used to send the SQL statement to the database to ask for a recrord set. Or, maybe, more simply -- you have put the cart before the horse. You need to be using a database function around the database column, which for date functions varies from DBMS to DBMS. ~| 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:338861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm just making this way too hard...
On 11/5/2010 12:14 PM, Rick Faircloth wrote: What am I doing wrong? (Besides mostly likely making this way harder than it should be... just fog on the brain today) Rick On 11/5/2010 12:25 PM, Ian Skinner wrote: You need to be using a database function around the database column, which for date functions varies from DBMS to DBMS. P.S. And while there would be nothing wrong with continuing to use a ColdFusion function to create the date time value to be compared to the results of the database function us choose to use around the database column. It might just be simpler to use database function through out, as all DBMS have perfectly fine functions to get the current time from the system. ~| 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:338863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm just making this way too hard...
On 11/5/2010 1:20 PM, Rick Faircloth wrote: Variable dateOfTotal is undefined. How can that column name be undefined? Why is it not being understood in the SQL? Because ColdFusion is NOT your database server, it has NO IDEA what column exist or do not exist. It does not see 'dateOfTotal' as a database column. It sees it as a COLDFUSION variable. And it is telling you there is no such variable in your CFML code. All cfquery... does is bundle up a big string and send it to the database. It is the database the is able to parse the string into SQL commands and references to the Database schema, such as Column Names. To do what you want to do you need to include some strings that will represent DATABASE functions inside your cfquery... block, then when the string gets to the database server it will recognize them and give you the results you so desperately desire. Now I can't easily show you how this would work because database date and time functions vary considerably between one Database Management System and another. And you haven't told us what DBMS you are using. ~| 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:338867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm just making this way too hard...
On 11/5/2010 12:14 PM, Rick Faircloth wrote: select totalNew from 04a_dailyNumberNewHMLSProperties where '#dateFormat(datetime, 'mmm d, ')#' = '#dateFormat(createODBCDateTime(dateDiff('d', '-1', now())), 'mmm d, ')#' But here is an example of how I would do it on one my Oracle Databases. SELETCT totalNoe FROM 04a_dailyNumberNewHMLSPropertise WHERE to_char(dateTime,'MON D, ') = to_char(CURRENT_DATE, 'MON D, ') Note: No ColdFusion at all and Oracle has some of the strangest date time functions around. ~| 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:338868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm just making this way too hard...
On 11/5/2010 2:44 PM, Rick Faircloth wrote: Anyway, here's what finally worked: select totalNew from 04a_dailyNumberNewHMLSProperties where day(date_add(dateOfTotal, interval -1 day)) = #dateFormat(dateAdd('d', -1, now()), 'd')# I'm glad you got something to work! But you may want to reconsider your choice of function. A quick internet search showed that the MySQL 5 day() function is to: Returns the day of the month for /|date|/, in the range |1| to |31| Thus day('2010-11-05') will return 5 as will the associated dateFormat() function. But since you do not include month or year portion you are going to return results of every dateOfTotal record that is the 5th day of the month for every month for every year in your database. I imagine that is not the desired result. ~| 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:338874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm just making this way too hard...
On 11/5/2010 3:31 PM, Rick Faircloth wrote: Something is still not right... I would suggest you stop looking at date-time values as a collection of sub values, such as Days or Minutes. You need to consider it as a single value that you want to compare to another value. Trying me best to understand the MySQL documentation, it looks like it would be as simple as. WHERE date(date_add(dateOFTotal, interval -1 day))) = date_add(curdate(), interval 01 day) ~| 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:338879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm just making this way too hard...
On 11/5/2010 3:52 PM, Ian Skinner wrote: WHERE date(date_add(dateOFTotal, interval -1 day))) = date_add(curdate(), interval 01 day) And if I could type and|or proof read: WHERE date(date_add(dateOFTotal, interval -1 day))) = date_add(curdate(), interval -1 day) ~| 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:338880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
cfheader name=Content-Disposition value=*inline*;filename=download.xls / Change inline to attachment so that the browser knows this is a separate, attached file to view OR download AND NOT an inline part of the currently viewed file: test.cfm. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Closing Browser expires session/cookie
On 11/5/2010 4:26 PM, Tony Bentley wrote: How can I remove the user from the log when they close the browser? You really can't! Browsers don't go back to all the web servers that the user visted and tell them I'm being closed now. So yeah, the user closes the browser but that doesn't fire the logout method or clear the cookie or session. When the user tries to login with another browser without actually hitting logout, they cant log in. The only way is to use the same browser that they originally closed. And it is not going to. The better way is probably to not prevent the logging in of user, but close the login state of the previous session. ~| 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:33 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduling lots of ColdFusion tasks in a limited window
Scheduled tasks are just URLs requested by a computerize built-in browser rather then a client in front of a human. If the CFML code being run by the Scheduled task(s) could execute properly if two humans requested the URLs at the same time, their should be no problem with a computer doing the same thing. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 -- Manually installing ODBC services
Can anybody tell me if this technote still applies to ColdFusion 9? http://kb2.adobe.com/cps/191/tn_19135.html What, if anything, might be changed because the server in question is multi-server not standalone. TIA Ian ~| 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:338733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 9.0 Schedule Tasks didn't execute.
Schedule tasks that have been running for weeks, months, or years decided not to exectute this week. I can see in the Schedule Task log that they all executed Monday , then somewhere between Tuesday and Wednesday, the entire list just did not execute. For every task I can see it running and scheduling a new task to run, but that task never executed. There are no enteries in the Appliction nor the Exception logs. Any suggestions on anything else I can look at, or what steps I can try? TIA Ian ~| 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:338640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
OT Windows Command line HTTP request
In the simplest manner possible. What ways can one make a Windows DOS Command line HTTP request. TIA Ian ~| 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:338646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT Windows Command line HTTP request
On 10/28/2010 10:00 AM, Dave Watts wrote: Use a program like wget or cURL. Any suggestions for where to get wget? My first search attempts ended up in ancient (1997) ports and broken links. TIA Ian ~| 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:338649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installation Instructions Coldfusion Enterprise 9
On 10/25/2010 7:10 AM, Dawn Sekel wrote: Does anyone have installation instructions for Coldfusion Enterprise 9? Do I just try downloading the Developer edition and then upgrade with our upgrade license number? I tried calling Adobe Technical support and got someone in India who directed me to download the Enterprise Installation manager for CS5 -- which made no sense to me. Thanks in advance NO CS5|4|3 are developer tools not the ColdFusion Application Server. Go two www.coldfusion.com/ or www.adobe.com/products/coldfusion/ which it directs you to. Then you can get the trail or get the free developer edition. Either one can be turned into a full, licensed version by applying your license number. If that is truly an upgrade license number, you will need the original license number you have upgraded from as well, if you are installing on a clean machine that does not have a previously licensed ColdFusion installation on it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Memory Upgrade - Revisited
On 10/21/2010 6:42 AM, Steve LaBadie wrote: Just to be clear my assumptions are correct that I do not need to purchase the Enterprise version in order to utilize the memory? -Original Message- From: David McGraw [mailto:david.mcg...@gmail.com] There is something wrong with the idea of using such a beastly web-server with an Access DB backend, upgrade your DB while you are at it. On Wed, Oct 20, 2010 at 11:48 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: We purchase 12 GB of memory for our web server and come to find out that we need Windows 2003 Enterprise or upgrade to Windows 2008 in order for the memory to be recognized. We currently have MX 7 standard installed. I am going to upgrade to CF 9, Standard. I understand that CF 9 Standard comes in 64 bit and can run 64 bit heaps. And I believe you can still run 32 bit ODBC drivers on a 64 bit windows so I can still use my Access DB's. I believe it is more complex then that. Yes you probably get 32bit ODBC drivers to *work* on your 64 bit windows, but they will only work with other 32 bit applications. I.E. using them may very well require you to use 32 bit IIS which would in turn require you to use 32 bit ColdFusion. So as said earlier, you may very well need to and probably should upgrade your databases. ~| 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:338422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: generating eticket
On 10/21/2010 7:00 AM, fun and learning wrote: Hi All - I was just curious if this can be done using coldfusion. Can we generate an e-ticket in Coldfusion. Suppose a user books a movie ticket or a bus ticket, can we send an email with eticket embedded in it Is your output going to be text, html, images, and|or pdf (as a few examples). Then yes, ColdFusion can easily do something like this. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 20 fields to compare
On 10/14/2010 2:01 PM, Robert Harrison wrote: Sorry ... nothing wrong with a loop. Just this particular program has bunches and bunches of loops already (76 and counting). It's beginning to look redundant and make my eyes cross. This program is becoming a loop de loop. :-) Loops are one of the most basic programming structures, if your not looping your probably branching. With that, it is awfully nice with high level languages like CF, that many of those low level loop de loop structures are abstracted into convenient functions or tags. But, sometimes a programmer must travel far enough off the well traveled road, and have to create the low level logic for his|her self! Sometimes I find that kind of refreshing. ~| 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:338213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lions, Tigers and Images, Oh My!
On 10/12/2010 11:41 AM, Everett Alexander wrote: /opt/jrun4/servers/DISCOVERY/SERVER-INF/temp/cfusion.war-tmp/neotmp2153518236327741178.tmp That is the temporary location where the web server (IIS or Apache) put the uploaded file after it decoded the data from the HTTP request. It then put that file location into the form field so that what ever Application server is processing the form would know where the file is. When it should be this: /images/news/volcanos.jpg You would use the cffile action=upload... to process the above form filed so ColdFusion would get the temporary file and put it where you instruct it to. Then you would probably use the #cffile[]#, or equivalent, structure to find the relevant file path information to input into your database. ~| 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:338087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Javascript Cfquery
On 10/12/2010 1:20 PM, fun and learning wrote: Hi All - I am trying to do the following: script language=text/javascript function abc(arg1, arg2) { cfquery name=q datasource=.. select * from table1 where col1 = arg1 /cfquery .. } /script Not simultaneously! ColdFusion runs on the server and JavaScript runs on the client. Complete different systems with completely different memory and variables executing completely different code and completely different times. I.E. Never will the twain, ColdFusion and JavaScript, meet. But there are plenty of ways to have JavaScript make request of ColdFusion and for ColdFusion to return JavaScript, just note that they are now working together. ~| 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:338092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Site not load - only show HTTP header
On 10/12/2010 3:25 PM, Bryan Stevenson wrote: While I don't have an answer for you, I'd suggest the user try the site from another location (perhaps from home)helps eliminate an office firewall as the culprit or simply an issue of different DNS servers being used from office/home Good luck! Along these lines, I would suggest the user try different, well known, ColdFusion sites. Just to see if they experience the problems on all CF sites or just yours. ~| 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:338098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Reading text files
On 10/1/2010 8:32 AM, Dave Watts wrote: No, CF isn't that low-level. But you could do this in Java, then call your Java class from CF. I've found fileSeek () and FileSkipBytes (), that might do the trick. Well then, I was wrong. CF is that low-level in this case! Oh CF, is there anything you can't do? Is it not fun when one learns something new about something one has enjoyed using for so long! ~| 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:337744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: arrays and looping around
On 9/27/2010 7:37 PM, Michael Grant wrote: #form['ExpOrg_ID_' loopCount]# A.K.A. Array Notation and can be applied to any variable scope, not just the form scope, though that is probably the most common. ~| 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:337594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 3 layers of validation?
On 9/23/2010 7:01 AM, Rick Root wrote: If someone finds your database and executes a stored procedure, you've got *WAY* bigger problems than application coding. Not necessarily. The someone just may be some future developer that has been tasked to do something new with all this great data your application has been collecting for the past years. ~| 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:337377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery not returning results with apostrophe
On 9/16/2010 6:44 AM, Richard White wrote: thanks for the replies, although the preserveSingleQuotes doesnt work You should be looking at the actual SQL that is being sent to the database. It would be provide clear evidence of what is wrong. Looking at this line: cfset havingClause = HAVING categoryname IN (#arraytolist(value)#) I expect you are getting SQL output that looks like this: HAVING categoryname IN (aaa'a) What proper SQL should look like is: HAVING categoryname IN ('aaa''a') !--- note the double single quotes inside the outer quotes --- You may want to investigate the listQualify() function. ~| 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:337120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Rounding Numbers
On 9/16/2010 7:37 AM, Jeanmarie Richardson wrote: Hi -- I need to round numbers consistently to the highest 1000. Is there a CF Function that will do this? Combined with some basic math, yes. cfoutput#ceiling(4397/1000) * 1000#/cfoutput Replace the literally value '4397' with useful variables. ~| 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:337128 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Authorization and Security for a web service
I do enjoy when I get to branch out and do things I've never done before. We are getting deep into the planning stage of a new project that will be a web service to be consumed by an outside agency to integrate their data systems with ours. We will want there to be security and authorization so that our system has a reasonable assurance that the submitted data only comes from their system. I'm pretty sure there are several ways to do this, but I have never done anything like it before. So I'm hoping some of you can point me to any good information on what we need to think about? How we might do this. What the process and code might look like to implement. Information along those lines. A couple of ideas that have already been raised. We creating a public|private key that they use to connect to our server as well as standard user name|password authentication. Thanks Ian ~| 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:336814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Function to Output a query as an ol or ul
I *THINK* what you are trying to do is a classic problem for a recursive function. Create a function that handles one level of your list with the proper ul and li tags. Then for each record inside the logic for the li... test to see if there is another level, if so call the same function. Rough and incomplete pseudo code. cffunction name=myMenu... ul cfloop li #anMenuItem# cfif anotherLevelmyMenu()/cfif li /cfloop /ul cfreturn theMenu /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Journaling
cfloop collection=form item=field cfoutput#form[field]#cfoutput /cfloop cfloop query=query cfloop list=#query.columinlist# index=column cfoutput#query[column]#/cfoutput /cfloop /cfloop But I think if I was in your shoes, I would be looking at a database solution. Something done with triggers probably. Then it does not matter what user interface is used to update the data. It will be 'journaled' as you put it. ~| 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:336408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Regex question
I need to turn some relative links into absolute links in a string. I have this rereplace() working well to do that. rereplace(links,'(href=)([^]*)','\1http://www.cdpr.ca.gov\2','ALL') But there is one link in the string that is already absolute going to a different domain. Is there an easy way to filter it out? This replace will happily prepend the above domain in front of the other domain in the absolute link. TIA Ian ~| 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:336415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Regex question
On 8/19/2010 8:32 AM, Ian Skinner wrote: I need to turn some relative links into absolute links in a string. I have this rereplace() working well to do that. rereplace(links,'(href=)([^]*)','\1http://www.cdpr.ca.gov\2','ALL') Thank you Ian, adding the forward slash[/] character in two places solved this nicely! rereplace(links,'(href=)/([^]*)','\1http://www.cdpr.ca.gov/\2','ALL') ~| 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:336417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm