Re: Editing MS Word Documents with ColdFusion
require me to replicate the rows many times depending on the amount of records in the database. Not trivial, but feasible. I have done some work where I generate congress badges with many fields and even images like logo and photographs. Open Office is definitely not a solution. I've never seen a Word document it was able to render properly. ~| 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:351432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Editing MS Word Documents with ColdFusion
Can you see any other easier way we could achieve this? Yes: identify each field with some string, Close the document in RTF format which is a pure text file, then read the file and search-replace the fields by their values. The result is readable under MS Word. ~| 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:351420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.0 Schedule Tasks didn't execute.
Any suggestions on anything else I can look at, or what steps I can try? Have you checked the date on the server? It might have been reset to 1998 or 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:338643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
decoding RFC 2047 encoded-words
Hi, Is any one aware of some utility that would decode RFC 2047 encoded-words, like message subjets, under CF 5? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HOF site down for several days?
Are other people seeing this? Same thing here. ~| 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:329539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Loading an CSV
Simply define an ODBC datasource using the Microsoft txt ODBC driver. Then requst the datasaource to get all records. ~| 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:329314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument not working in ie
thanks for your help You would have better help if you show us your CFDOCUMENT tag. ~| 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:328968 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Handling Character Encodings
I want to display (print) the description on subsequent CFM pages. Well, print and display are two different things. Do you mean that the characters look ok when displayed in a CF page and not when you print the same page from your browser? ~| 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:328764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Handling Character Encodings
I'm processing DB columns with text containing #8211; and #8212;. This means you are storing HTML code in your db text fileds. By doing so, you are not supposed to use these data for other purpose than HTML rendering. If you need to use them for other purpose like generating text under some non HTML environment, you must get rid of these HTML codes or convert them. For instance, I have an application which generates passports for participant in conferences in some RTF document to be printed. Of course, HTML code inside an RTF document wont be rendered properly by MsWord. ~| 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:328763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Handling Character Encodings
The characters look like glyphs when displayed in the browser. But, the actual DB content has #8211;/#8212;. This text will only be used for display on a CFM page. Then like Paul said, the font used when printing has probably not those glyphs defined. ~| 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:328767 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SYNTAX?
You have double quotes inside a double quoted string in [##%/\\*?|:$'@,(){}~`^!+;=[] Try using '[##%/\\*?|:$'@,(){}~`^!+;=[]' instead. Further more, you should escape special RegExp characters like []{}(), etc. like \[\]\{\}\(\), then try : '\[##%/\\\*\?\|:\$'@,\(\)\{\}~`\^!\+;=\[\]' ~| 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:328422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: LEFT Command question
Here is the format of the cell: Smith, Jim I want to end with jsmith How about this: CFSET cell = Smith, Jim CFOUTPUT#LCase (left(trim(listLast(cell)), 1) listFirst(cell))#/CFOUTPUT provided that cell is always a list of at least two names. ~| 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:328424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Any recommandation for a command line video converter?
Hi, Can any one recommand a good command line video converter for Windows that could - be executed from ColdFusion (any command line converter should do it) - convert to FLV Flash format; - retrieve metadata from input file like duration, original width and height; - extract thumbnail images; - reasonable price ie below 300$ So far, the best candidate seems to be Total Video Converter Command line, http://www.effectmatrix.com/total-video-converter-command-line/help.htm#cmdlineParam but $386 seems just a bit excessive to me Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Solution for Flash videos needed
Get the size however I'm not sure. I haven't had a reason to work with that sort of thing, Well, the reason is simple enough. I can resize the flash player to any size, but the best is to start with the original size of the video. ~| 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:328178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Solution for Flash videos needed
Hi, I have a content management system on a CF 5 server. A couple of customers asked me to put some videos on their site. They all come up with different solutions and implementations for Flash players, ActiveX players, etc. It is out of question I implement a different solution for each customer and each new video, so I want to provide them with ONE unique platform so that that would just have to get their video prepared in a certain format and upload one file, that's it. There is so much information over the Net about how to make Flash videos that I do not know where to start. Can some one share his experience on that matter? What I need is something as simple as this: http://www.adfo.org/index.cfm?p=pageid=42 Except that Google won't take new videos any more, so I need my own Flash player and whatever it takes to store and stream Flash videos from my own server. I don't want to format and produce the videos myself, just play them. Thanks for your advice. ~| 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:328153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Solution for Flash videos needed
OpenBD uses FlowPlayer, which is actually pretty slick: Pretty clean and simple indeed. And the domain name unlimited licence is most convenient also. Just one question: do you know if it is possible to get the actual width and height from the flv file in order to adapt the size of the viewer accordingly ? ~| 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:328159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Invalid precision value
Getting this on a query. Define Getting. Where are these values displayed? ~| 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:327759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invalid precision value
wrap dateformat() around the dateadd() function. NO. createOdbcDate expects a date value as a parameter. One should never submit a formated date to this function, the date will be de-formated anyway, with the risk that the format is not compatible (ie: european date format). ~| 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:327760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
BSC here, in math/physics, and MSC in computer technologies. Actually, CF may be the 20th language I learned and used. ~| 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:327583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Comparing upper case and lower case
It seems that NEQ or is not doesn't care about case. Exact. Use the Compare () function for case sensitive comparison. ~| 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:327615 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checking line 26 or 27
The Invoice will not change This is absolutely true,... until the guy who said it will not change is changed ;-) ~| 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:327429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: javascript and coldfusion
what are your experiences of the above and others? The best library I ever used is the one I developed myself over the years. 1º it contains about everything I need; 2º it does not contain anything I don't need; 3º it can be enhanced easily any time. ~| 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:327430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: blocking site downloaders
(c) What the hell are they doing? Some will search for copyrighted images and, if they find some, they will send you some lawyer letter with a bill of 1500$ or so for using their image. (ie: Getty images,...) Most of them are simply looking for email addresses they could collect and sell to spamers. The current offending IP reverses to China. From China, it could also be gouvernement spider check if your site is promoting human rights, and if yes, I've got bad new, your site will be BANNED form china ! ;-) PLUS email fetchers, of course. o Add a session variable that stores the last page view time down to the second. However, this may not work as the offending behavior is probably generated by a bot or desktop app that doesn't store session variables. Exact. Better store the IP address in an application (or even a server variable) and calculate a moving average of time between requests to pages. If the average gets lower than a certain minimum, ban the IP address for at least a couple or hours. The bot will be discaouraged. o Review my databased logs for the current IP's last twenty page views. This may put an extra small hit on the server, but over all not as much as an extra 2200 page views in an hour every couple of weeks. This can be a pretty heavy task for the server. Log files are pretty big files. If the requesting IP has requested more than twenty pages from the website in the current minute, I block the IP for a period of time, say, an hour or two. This is what I do, but I use a moving average in a server variable. Much more efficient than reading log files. ie: server.structPass[REMOTE_ADDR].durpass =server.structPass[REMOTE_ADDR].durpass*6/7 + thisLaps; In thisLaps I have the nb of seconds between last and current request. The formula gives a moving average over 7 consecutive requests. If this average goes below a certain amount, there are chances the agent is a bot. I use this test among others to detect bad bots. ~| 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:327289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: blocking site downloaders
in case it's a search spider, you can try adding appropriate robots.txt robots.txt file may be useful for well behaved robots like Google or Yahoo, but bad bot disguise themselves like Explorer or Mozilla and they do not comply to robots.txt directives. Most of them never read it, and some of them will even read it ... and visit the forbiden areas on purpose. This is one of the trick I use to detect them : attempt to read pages referred in robots.txt ~| 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:327291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Splitting a list...
lets say we have 650 elements in our list. split them into seperate lists with a maximun of 100 elements. I just showed you how to do it in the message you are replying to. The example will work on any list of any length. remember, each list must be in a variable Which variable? I could create dynamic variable names and put every list in it, but that would be kind of awkward. It is simpler to store them in a super list and retrieve any sublist whenever needed. ~| 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:327182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Splitting a list...
i need to have the values of each sublist in variables How about hving them in a list of lists? Then you could get each sublist pretty easily. Try this: !--- Create a 1000 elements list --- CFSET thelist = repeatString (0,1,2,3,4,5,6,7,8,9,, 100) !--- Replace every 100th comma delimiter by | as super delimiter --- CFSET thelist = Replace (REReplace (thelist, (([^,]*,){100}), \1|, all), ,|, |, all) CFDUMP var=#thelist# Now you have a | delimited list of 100 elements , delimited sublists Use listGetAt(theList, n, |) to get each nth sublist. ~| 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:327116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Splitting a list...
How do you split this list into equal lengths of 100? 1. make a function to split the list into the first 100 elements and the rest. 2. loop on the rest until its length is = 100 ~| 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:327087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 5 scheduler going wild
Hi, I've been using the same coldFusion 5 server for about 9 years with no problem. Suddenly the scheduler started acting crazy: all task are reexecuted every 2 min. starting at 00:00. It happened twice in a couple of weeks. Any one ever seen such an issue? ~| 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:327030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Splitting a list...
The slashes here are not needed: Right, I had a problem while testing and I thought slashes were needed, but the problem was somewere else and I forgot to remove the slashes. ~| 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:326959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Splitting a list...
cfset thelist =aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz What would be the most efficient way to split the list into two lists, Try this : cfset thelist =aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz CFSET st = REFind (([^\,]*\,){6}, thelist, 1, true) CFSET list1 = mid(theList, 1, st.len[1]-1) CFSET list2 = mid(theList, st.len[1]+1, ) CFOUTPUT list1 = #list1#BR list2 = #list2#BR /CFOUTPUT ~| 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:326904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Splitting a list...
I'm not sure if your method is quicker IMO, the longer is the list, the quicker it will be. ~| 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:326906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to completely stop the RDS server?
Hi, I have a CF 5 server, but I never use Remote Development, so I don't need the RDS service. The service is disabled in the Windows services. However I get this line every 2 seconds in the executive.log: Error,1716,09/28/09,16:21:15,,Unexpected Windows NT error number 1058 occurred while attempting to start the RDS service. Apparently, the executive server is still trying to start the service. I do not see any tool to manage the RDS server in the CF Administrator. Can some one tell me where to look? ~| 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:326723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to completely stop the RDS server?
... other than stopping the Executive service as well. Which of course I can't do, or all scheduled tasks won't run. I recommend you simply disregard these errors as they are harmless. No, they are harmless, except for building a hudge file for nothing. I have to remember to delete it from time to time. ~| 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:326725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: methods other than GET or POST
All that said, you should be able to do this from CF in Application.cfc/cfm, which could be shared across multiple websites if you choose to set it up that way. Just look at CGI.REQUEST_METHOD. Yeah, this is the way I finally went. Especially that I can use the same code to return errors to moron robots which GET template normally only requested with POST method. I return 405 : Method Not Allowed ~| 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:326658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: methods other than GET or POST
Have you tested this? Actually not really tested, but at least experimented. Sometimes I get errors in my error log table caused by pages requested with OPTIONS or HEAD. Apparently, the CF template is run just like the method was GET. The error is actually caused by url parameters that would normally come with the request. Ex : I have a template that returns some CSV list like .../makelist.cfm?id=1 The template is called normally with method GET first, then when the client opens the file with Excel, another request .../makelist.cfm with method OPTIONS is made by MS Office with no parameters and causes the error. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Detect OS and CPU Architecture
The question was to detect a user's OS and its CPU architecture I don't know about your CPU architecture, but I'm pretty sure about what you smoke ;-) ~| 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:326670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
methods other than GET or POST
Hi, I recently found in my error logs a request to a page using METHOD=OPTIONS... I didn't even know this couls exist. Apparently, thes requests are sent by Microsoft Office, in this occurrence, while receiving some CSV file. This caused an error in my system because no parameter the template was expecting in the URL or the FORM scope was present. Obviously, my application does not support these requests, and I don't intend to do it. I haven't find any procedure that would limit methods at server level in MSIS. Then I'm planing to add some check in my Application.cfm to limit requests to the only type I support, ie POST and GET, ie: CFIF listFindNocase(POST,GET, CGI.REQUEST_METHOD) EQ 0 cfheader statuscode=405 statustext=Method Not Allowed CFABORT /CFIF But I see many other types of requests ( http://www.askapache.com/online-tools/request-method-scanner/ ) including MOVE, COPY or DELETE! My question: is: it safe to allow only GET and POST? What is the best practice in CF? ~| 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:326634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: methods other than GET or POST
Thanks for tis clarification. ~| 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:326641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: methods other than GET or POST
Just a word of warning - PUT will in fact place a file on the webserver Ok, but I do not need this feature. ~| 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:326648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: methods other than GET or POST
(I don't know how many CFers do that). Not me anyway ;-/ IIS Manager Right-click the website Properties Home Directory tab Configuration Button Mappings Find .cfm, .cfc and any other extensions that you are worried about for CF Edit Verbs: Limit to ... Ah ok, and I enter a list like GET,POST I suppose? But this has to be done for every web site. I finally prefer my solution in a commonApplication.cfm which is included by every site Application.cfm Thanks anyway. ~| 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:326649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: malware patterns
script src=http://bgadf.cn/script Arg... chinese junk again :-( ~| 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:326407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is the most like cause lf Java Heap Space error?
I can see mostly two reasons: 1. an infinite loop, this would be in your code, 2.. some memroy leak, this would be some in other's code. ~| 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:326327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is the most like cause lf Java Heap Space error?
... hmmm, a memroy leak is not good, but a memory leak is even worse ;-/ ~| 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:326329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is the most like cause lf Java Heap Space error?
I'm running batch files using pkzip25.exe. I may be wrong, (DOS is far away), but aren't batch files supposed to contain some sort of exit command, otherwise they may stay waiting for some one to enter the next command ? ~| 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:326339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
GET insread of POST: what would you do?
Hi, From time to time, I find in my error log errors due to undefined form variables. The reason being that the template was requested using method GET instead of POST. Of course, there are dumb bots that would GET any address they find in a page, but there are also true visitors, even registered members, who will eventually cause the same error. I've also noticed that if you are in a page submitted from a FORM, you click on the address bar in the browser and press Enter, then the same page will be requested with a GET, and cause the same error. Then I intend to write some tag that will check the method used in the request, but my question is: what would you do - or already do - in case of GET instead of POST? - send some error response? - send the user back to the correct empty form? - send some Javascript code to go back in the history? ~| 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:326276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GET insread of POST: what would you do?
One thing though, if the values are showing up in the url then your form itself must be using GET, otherwise they wouldn't show in the URL. I thought it was clear in my initial post that the form was indeed submitted using POST. and of course I do validate the values received. The problem is when the user resubmits it from his browser using GET (probably not even being aware of it). I can detect this situation, my question was What would be the best do in this eventuality ~| 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:326281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GET insread of POST: what would you do?
request.data = url; StructAppend(request.data, form); This will work if the GET request transmits the form parameters in the url instead, but it is not the case: the url contains no value. ~| 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:326301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GET insread of POST: what would you do?
After processing the form, redirect the browser (302 redirect, cflocation) to the 'thank you, your form is submitted' page. Good point, except many times, the input process is not finished. There may be 4 or 5 steps of form to fill before I can say thank you. Not really simple to pass all parameters using CFLOCATION. ~| 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:326302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GET insread of POST: what would you do?
Create a required variable and use that to redirect them back to the form. Redirect them back to the form was indeed what I intent to do. However, testing CGI.REQUEST_METHOD NEQ post seems more logical. ~| 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:326303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stop cursor typing past 500 characters
ive put in in the following place but its not doing anything To my knowledge, the TEXTAREA tag takes no MAXLENGTH attribute, on INPUT tag has one. ~| 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:326231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Stung by HostMySite price increase?
Most of the companies I work for INSIST on *everything* Microsoft because in their eyes, *only* Microsoft is suitable for stuffed shirt corporate work. True, And IMHO the only reason is the incompetence of managers. The bigger the organization is, the higher the decision maker is, And the higher the decision maker is, the less he knows about software tools and hardware. Finally, the more incompetent he is, the more he needs to protect himself in case of any trouble. So, if he can say I chose Micosoft for software, the biggest in the world, and IBM for hardware, the biggest of the world... he thinks he cannot be wrong. ~| 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:326067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hardaware question for cf local server
I don't know the processor and its capabilities This is too bad, because I would say that the performance will mostly depend on the speed of the processor, and the amount of RAM it has. ~| 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:325610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: system security question
Do you see any potential security issues with this i.e. sql injection via the email As far as SQL injection is concerned, the risk is pretty low with an Access database, since it cannot process multi-statement SQL command. Unless there are tricks I don't know, all SQL injections are based on multi-statement commands. ~| 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:325434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: list from array occurences
is there a function to do this in a line of code Try this: MyList = RepeatString(,VarChar, arrayLen(MyArray)) The comma at the begining will be considered as an empty element which is ignored by CF. However, if you rather have a clean list, use this: MyList = mid(RepeatString(,VarChar, arrayLen(MyArray)) , 2, ) ~| 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:325078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: list from array occurences
Yet another solution, assuming that the array length is at least 1: MyList = VarChar RepeatString(,VarChar, arrayLen(MyArray) - 1) ~| 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:325086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange problem when navigating to a coldfusion page
Can anyone please help me in knowing what is causing this problem? May be some redirection in some /Trying/Jsonlearn/Application.cfm ? ~| 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:324963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ecommerce emergency
The client I'm doing this for is only willing to part with $450. For that price, I would advise him to do it himself, it will be even cheaper. ~| 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:324871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ecommerce emergency
Making $450 doing something beats making $0 just sitting around. Well, if you have nothing to work on, there is still something better that sitting around: looking for other customers! ~| 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:324902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ecommerce emergency
PS not responsible for keyboard damage! You bet: my dog went crazy, jumped over the keyboard and scrapped my liquid plasma screen! ~| 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:324903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF prepared statements
An attack can be made to inject SQL on a CF application using CFQuery that cannot be prevented with cfqueryparam. Well... it depends what you mean by SQL injection One thing CFQUERYPARAM cannot prevent is inserting malicious content in a text field, like links or simply reference, to porn sites or whatever. But this is NOT SQL injection, it doesn't use any SQL. SQL injection means that the attack adds malicious SQL statements in a text field in such a way parts of the text will execute some extra SQL statements. And this what CFQUERYPARAM makes impossible. ~| 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:324620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF prepared statements
2) could prepared statements have an adverse effect on performance? On readability, yes, but certainly not on performance. ~| 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:324567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF prepared statements
No, they can certainly have a bad effect on performance. I must admit two things here: 1. I was more quoting many people here about performance than giving my own experience, 2. personnally, I don't like CFQUERYPARAM, I use it only when really necessary, ie. only on text fields coming from a form in the public part of my sites. If it is only for SQL injection prevention, there are other means that do not make queries unreadable. And there are other kinds of attack CFQUERYPARAM will not protect from anyway. ~| 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:324574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Restricted access to non cf files using cf
Store them outside of the webroot and use cfcontent to serve them to the browse when necessary. Some people have no access to folders outside the webroot. In that case, one solution is to : 1. register all files in your database with their original name and type (pdf, doc, etc.) 2. store any non cfm file in a special directory; 3. rename anyFile.xxx to anyFile.cfm 4. store in the directory an Application.cfm file containing any measure to restrict access, like a simple CFABORT 5. provide a template for file request that will CFCONTENT it, restituing the original name and type, ie: CFQUERY DATASOURCE=#application.applicationName# NAME=getDoc SELECT fileName, localName FROM docs WHERE docId = #Id# /CFQUERY CFIF getDoc.recordcount EQ 0 CFABORT SHOWERROR=Document not found /CFIF CFSET PathDoc=GetDirectoryFromPath(expandPath(*.*)) contentDocuments\ cfheader name=Content-Disposition value=attachment; filename=#getDoc.filename# CFCONTENT TYPE=application/octet-stream FILE=#pathDoc##getDoc.localName# ~| 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:324243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Restricted access to non cf files using cf
any other idea without cfcontent ? Nope. Any solution to give access or not must be based on some CF code to abort the request if the user has no access, or send the document if he has. And the proper tag for CF to send the document is CFCONTENT. ~| 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:324248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
As Dominic said, putting the entire sql statement in as a variable in ColdFusion isn't necessary. Please, there IS a very good reason one would put an SQL statement in a variable: when using some tool to generate build queries for instance. I have many examples in my own CMS, like a report builder, search engine, etc. However, just for future knowledge sake, the reason your receiving this error is because when you feed in a variable with single quotes, for some reason they become duplicated when you feed it in sql. I've actually never seen this before mostly because it's not good practice in ColdFusion to do this. The some reason is simply that any single quote in values in the statement must be escaped, and CF will do it automatically for any variable inside a CFQUERY tag. If you supply your own SQL statement, you are responsible for escaping single quotes yourself, and you must prevent CF to do it, because CF is not able to distinguish quotes in the statement from quotes in values, this is the purpose of the pseudo function preventSingleQuotes(). ~| 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:324064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
And with preserveSingleQuotes() you have to hope you're better at cleaning input than hackers are at writing SQL injection. When I'm talking about a CMS, I'm talking about some tool some customers have paid for and that is only accessible by approved users with authentication. Now if they want to hack and sabotage their own application they have paid for, it's their problem, and if it ever happens, they will pay again to get their own mess cleaned up. ~| 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:324067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Help
Internal security problems are far more common than external ones. Within a large organization, not all users may be trustworthy. C'mon, if they are users and they have access to the system, if they go crazy, do they really need SQL injection to harm the system ? They can simply delete all what they have access to, they can replace content by porn, whatever. Will CFQURYPARAM protect your application against that ? ~| 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:324074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
With XSS they can do that while making it look like someone else did it. Probably, but my clients barely know the difference between a computer and a toaster, and I spend more of my time explaining them that in order to press Ctrl, they must find a key on their keyboard with the letters Ctrl on it, and not press C then t, then r then l... than fighting against malicious nerds ;-) Ah, oh yes, also when you see Press Ctrl and something, you must press the Ctrl key and the other key IN THE SAME TIME, otherwise it won't work. The best for that is to use TWO fingers, possibly from two different hands... ~| 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:324076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
Also, you talk about this like your speaking of only internal applications or applications that could never go on a production environment. Indeed, we were talking about building SQL queries in a variable inside a Content management system. Of course, for parts of the site exposed to public, things are different. ~| 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:324081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Finding tables in MS Access database
In order to query MSysObjects you must have some permissions set in the security settings of the database. If you have CF 8, you should also be able to use CFdbInfo. Otherwise, there is still CFX_ODBCinfo: http://customtags.internetique.com/ODBCInfo/E/TestODBCInfo.cfm which is not free, but which works on any ODBC datasource under Windows and under CF 8, 7, 6, 5, 4, and may be even lower. ~| 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:324044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
does it clear the vagueness? Hmmm I hardly imagine an inventory system which is not part of some product management system. In order to make an inventory, you need a list of products. So what you are looking for is rather some store or warehouse management system. If you already have one, but with no inventory system, then you better design your own, you'll never find one compatible with your system. ~| 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:324052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open source ColdFusion again
Most of these Ajax features are pretty bloated in terms of the amount of JS and CSS that need to be downloaded. Exactly, personally I do all my Ajax with about 15 lines of code ;-) ~| 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:323799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open source ColdFusion again
Are you talking about using non-cf8 built-in ajax tags or ajax functions that you built on your own using popular js libraries? First I usually develop my own Javascript code with ONLY the features I need, and try to avoid popular libraries, secondly I do not need custom tags to use Javascript, but sometimes my custom tags need some Javascript, which is different. care to show us some of your nifty code for this? Well for instancem here are two functions, one for GET requests, the othe for POST: function ajaxGET (url) { var XMLHttp = null; if (window.XMLHttpRequest)XMLHttp = new XMLHttpRequest(); // code for IE else if (window.ActiveXObject)XMLHttp = new ActiveXObject(Microsoft.XMLHttp); if(XMLHttp) { XMLHttp.open(GET, url, false); XMLHttp.send(null); if (XMLHttp.status == 200)return XMLHttp.responseText; displayError(XMLHttp.statusText) return null; } else return null; } function ajaxPOST (url, sendText) { var XMLHttp = null; if (window.XMLHttpRequest)XMLHttp = new XMLHttpRequest(); // code for IE else if (window.ActiveXObject)XMLHttp = new ActiveXObject(Microsoft.XMLHttp); if(XMLHttp) { XMLHttp.open(POST, url, false); XMLHttp.setRequestHeader(Content-Type, application/x-www-form-urlencoded; charset=iso-8859-1); XMLHttp.send(sendText); if (XMLHttp.status == 200)return XMLHttp.responseText; displayError(H2 + XMLHttp.statusText + /H2P + XMLHttp.responseText) return null; } else return null; } function displayError(text) { var errorWin = open (,Error,scrollbars=yes,resizable,width=900,height=600); errorWin.document.open(); errorWin.document.write(text); errorWin.document.close(); errorWin.focus() } I also never use XML to transmit Javascript values, just return javascrip code and evaluate it. ~| 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:323801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Limiting the display of an image to certain times of the day with CF?
If so any ideas on the best way to achieve this? Simply use CFIF tag and now() function. You'll be able to generate or not any code whenever you need. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Case Sensitive SQL
MS Access is fine for basic office use, but for web apps you're better off picking Derby, H2, MySQL, Postgres, etc - or one of the free 'Express' editions of Oracle or MS SQL Server. Legend, pure urban legend ! Access applications have a bad reputation, but do not forget that accessing an Access database through ODBC or JDBC under CF IS NOT an Access application: it is a CF application. Do not mistake the database file with the VBscript application that may be embedded in the file. ~| 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:323506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Case Sensitive SQL
There is very few reasons why you would want a Web App with Access. None of them that I can think of would be useful in a web app that is worked on by 2 or more people (which most web apps are). 1. Access is not sensitive to SQL injection. 2. Only one file for the whole database, the whole database can be moved in and out by a simple FTP transfer. 3. Searchable memo fields, Again, for small/medium applications, this is valuable. in a web app that is worked on by 2 or more people (which most web apps are). In CF Web applications there is only ONE user at a time on the database: ColdFusion. There may be several users in the CF application, but only one in the database: ColdFusion. If multiuser applications are not running properly, the problem is with the way the ColdFusion application is accessing the database file not with the datasource file per se. There is simply NO Access application on the Web, what is called an application is actually the code that makes it running. There is no Access code in a CF application using an Access database, only CF code. So everything you may have heard or read about Access applications is not applicable to access datasources under CF. I've been using Access datasources in small/medium application since ColdFusion 1.4, for more than 10 years, and I haven't encountered the slightest glitch imputable to the Access datasource. ~| 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:323511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Case Sensitive SQL
now if I add 'GROUP BY clust' then it gives an error. Where do yo add the GROUP BY clause ? ~| 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:323512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Case Sensitive SQL
now if I add 'GROUP BY clust' then it gives an error. In a GROUP BY clause, you must enumerate all fields in your SELECT See : http://msdn.microsoft.com/en-us/library/aa259187(SQL.80).aspx#_group_by_clause ~| 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:323515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Case Sensitive SQL
ID and SITE will always have unique values no duplicates allowed. Ok, but you still have to list all columns in your SELECT list, it is a matter of SQL syntax, not logic. In pure logic, a GROUP clause should be enough, since one has no choice, but this is the way SQL has been designed. ~| 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:323522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Case Sensitive SQL
Microsoft Access is terrible. Well, yet another legendary Access database bashing :-( Access database are GREAT for any small/medium web application. Most databases implement the string comparison to be case insensitive by default. They also have provisions to change it either globally or locally, and COLLATE is just one of them, not the simplest one. In Access, there is a very simple solution : the StrComp() function In your case, try WHERE strComp(password, '#from.passWord#', 0) = 0 Parameter 0 stands for binary compare, 1 would be for case insensitve compare ~| 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:323487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Case Sensitive SQL
the COMPARE function should do the trick for you. The COMPARE function is a CF function. What is needed here is an SQL function. ~| 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:323488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Anyone have recommendations for CAPTCHA? Yes: don't use captcha. Users hate them. what other programming can be used to figure out if the submission was done by a human? -Add some hidden check value by javascript on submit. I don't thing many bots execute correctly Javascript. - Add some Javascript Confirm on submit. I thought about timing the form page load and time to submission. If it took a user less than 5 seconds to fill out the form then assume they are not human. Not a good idea, some bots are able to wait between their requests; it is much easier than execute Javascript. ~| 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:323078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT, looking for an affordable SMTP/POP3 solution
Thanks all for your suggestions. I also received this one from my server host support : MailEnable Any one aware of it ? ~| 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:322959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex help...
Hi, For this type of parsing, you should have a look at CF_REextract: http://customtags.internetique.com/REextract/testREextract.cfm ~| 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:322973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT, looking for an affordable SMTP/POP3 solution
Hi, I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Any suggestion ? ~| 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:322925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic robots.txt
Another solution is to assign files with extension .txt to CF as well. Then CF will be able to generate correct paths. Unless you have very large other txt files that would then been parsed by CF as well and consume too much time. ~| 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:322824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Windows 2003 vs 2008
Hi, I'm considering moving my application to a dedicated server. The package includes Windows 2003 or 2008 at the same price. Is there a major difference, as far as CF is concerned. Memory requirements? Performance? ~| 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:322776 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form submittion redirected with 302 Moved Permanently response, Form Post Failed !!!
anyone got any idea , what is going wrong Sure ! There must be some error in the submitted template... ~| 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:322771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need to import database from filemaker Pro
Hi, I have a new customer for whom I must import most data as I can from their Filemaker Pro database to my own CMS. I plan to import their data (mostly tables for members and organizations) into an Access database, then work from there and collect what I can. Has any one here some experience with Filemaker? What are the the export format available? CMS wouldn't be an option, since it does not really transmit the column types. (for the indexes, I can manage) Thanks. ~| 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:322230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need to import database from filemaker Pro
There's a driver that's included with filemaker and several available on the web. Simply install the driver on your copy of CF and create a datasource. Ok, but then I still need to install the Filemaker database on my development server. Is it possible to just copy one file, like with an Access application? Otherwise, how can I transfer the database from the server it is actually? ~| 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:322249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) launch an IE session from Firefox?
I doubt this is feasible, however youd would certainly have more accurate answers from the Mozilla forum: http://forums.mozillazine.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:321539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: encrypt database column
i am now wondering whether there is really a need to encrypt the columns, but instead just to control the access to that data through the cf application. You are telling yourself exactly what I was thinking ;-) ~| 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:321447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: encrypt database column
yes, a cf app that has alot of security. and only people that have been given rights to the secure data Then what's the big idea to encrypt data, if they have the rights to see it anyway? If there are columns they should not see, just not provide them with the possibility to display those columns in your CF template, no? ~| 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:321448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: encrypt database column
what do you think about this? First point: if your database is correctly stored in a safe area not accessible by HTTP, the risk is really low. If is is stored in an area vieable by HTTP, then so is your template to decrypt and view data any way. It's like hanging the key of your house on the entrance door ;-) Second point, if is was really a concern and an issue, there would be some tool available on your database system to handle it. Database systems provide with other protection schemes. The best option is to use them. Database systems are develop by professionals who know what they are doing, not by customers who think they know where the danger is. ~| 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:321459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: encrypt database column
how would i get around the issue of encypting data in integer columns? - as some of the columns are set as smallint(2) for example. You need to create an extra column to contain the encrypted value. I know no encrypting algorithm capable of encrypting a smallint into a smallint, except may be an equivalence table, but can this still be called encryption. what do you think? Well, frankly, to be honest, before I think anything about this, I'd like to know a little more about the idea behind all this. Why do you need to encrypt a column in the first time? May be there is a better solution. ~| 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:321411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: encrypt database column
we appreciate your feedback Who will be able to open and read your database, and from which application? Some CF app? ~| 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:321417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cross browser CSS
First, start by writing standards compliant HTML with a valid Strict DOCTYPE - this is the best way to avoid most of the browser bugs in the first place. Of course, this will work... at least for all visitors having browsers supporting Strict DOCTYPE with no bug ;-) ~| 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:321321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: encrypt database column
1) seeing as this can be run on any column (even integer fields) is it possible to encrypt an integer and then place the resulting encrypted string back into the integer column of the database If the encrypted data is also an integer, then yes, but if is can be any string, forget it. Not even woth trying. 2) as this function will run on any table/column how can i write an sql statement that just loops through the column encrypting the data? This depends on the database you're using. May be a stored procedure could do it. ~| 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:321327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: convert doc file to html file
That's the step the end users try to avoid. They want something on the fly, letting CF to do the trick automatically after the file is uploaded. Have some HTML editor on your site like FCKeditor. Client opens his Word document; Ctrl-A, Ctrl-C, back in FCKeditor, Ctrl-V ~| 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:321203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Railo 3.1 Open Source beta released
I think it wasn't free before. Can the free version be used commercially ? Or is the soft free, but you have to buy licenses? ;-) ~| 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:321140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4