RE: Fusebox
Jeff, You keep on going on about other methodologies. Which particular other methodologies using CF are publicly available? You keep mentioning all these other methodologies, but can we at least compare them to Fusebox? Fusebox is probably one of the best methodologies (if not the only public methodology) available for a ColdFusion developer. The book also covers a number of fundemental design elements that any CF'er should understand. EVEN if they don't do Fusebox. Adam -Original Message- From: Jeffry Houser [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 PM To: CF-Talk Subject:Re: Fusebox "Warrick, Mark" wrote: The fusebox methodology has many benefits, and I really don't think it adds any time to the development cycle. In fact, I'm pretty sure it helps speed up development. Well, that has nothing to do w/ Fusebox. Any programming methodology will offer this benefit. The key is having one in place and sticking to it. One of the greatest advantages of the style is that you can modularize you code, and in doing so, you can assign pieces of your application to various developers without worrying about them stepping on each other's toes. See above. This is not unique to fusebox. Another advantage is that certain companies (such as mine) require it. So if you don't do it, you're not going to get a job with certain companies. If you are not a consultant, that is complete hogwash, I think. Especially with today's job market. Fusebox (or whatever methodology the company uses) should be more than willing to train on the methodology. If you already know the language (What company doesn't have enough trouble finding people who know the language?), learning the coding practices should be easy enough. I did one job, where the first thing they did was sit me down and outline the coding practices. It took about a half hour sitting down with the lead developer. I took notes, and then followed them. No problems. Lastly, it's very simple to follow the programming flow of a fusebox app. When something goes wrong, you simply search for the fuseaction in the index file and then you'll see right away all the templates in a single handy block that could be involved with the problem. As I said previously, any methodology worth its salt should offer this. If I don't know fusebox, then your app isn't going to be any easier to follow than some other unknown methodology. (It probably will be easier to follow than random coding, though) -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Page Tracking hits :: User Movments on an Intranet
would you also need to insert the name of the page? so that you can see what page how long they where on it? thanks for the advice. -paul -Original Message- From: Warrick, Mark [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:03 PM To: CF-Talk Subject: RE: Page Tracking hits :: User Movments on an Intranet Hi Paul, I really don't think there is a tutorial. You can use the code below as an example. This is the easiest way to track visitors. You would include this into every template. (by the way, this has nothing to do with server logs) cfset ip = "#cgi.remote_addr#" cfset login_time = "#TimeFormat(Now(), "HH:MM:SS")#" cfset login_date = "#DateFormat(Now(), "MM/DD/")#" (of course you'll need to create a database for this) cfquery name="record_visit" datasource="#dsn#" INSERT INTO access_log ( ip, login_date, login_time) VALUES ( '#ip#', '#login_date#', '#login_time#') /cfquery ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 4:51 AM To: CF-Talk Subject: RE: Page Tracking hits :: User Movments on an Intranet is there a tutorial for this in the advanced wack book? guess i should just look my self, sorry. i cant use server logs. they are turned off thanks -paul -Original Message- From: Warrick, Mark [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 1:25 PM To: CF-Talk Subject: RE: Page Tracking hits :: User Movments on an Intranet The anonymous way would be to assign a random ID to each new visitor and then record that ID with every page view (or fuseaction) into a database or text file. The membership-based way would be to have a user login then track them the same way. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 5:47 AM To: CF-Talk Subject: Page Tracking hits :: User Movments on an Intranet hello all! i know this has been asked befor, but i cant find the email. What software or utilities do you guys use to track user movments on your site? i need to see what parts of our intranet are really being utalized what isnt. so i can do a rebuild. any helpp would be great! thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 Home: [EMAIL PROTECTED] 614 449-1681 [EMAIL PROTECTED] icq:47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: passing cfquery results to another page
On differece is that you don't need to bother with reading and writing session variables, or with locking. Query caching is oh so easy. Bob -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: December 21, 2000 5:08 PM To: CF-Talk Subject: RE: passing cfquery results to another page How is caching the query different from saving it as a session variable? Both are kept in memory, right? Except that the cached one will get bumped if memory is needed? -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 8:31 AM To: CF-Talk Subject: FW: passing cfquery results to another page I had another thought. Just cache the query, and, as long as it doesn't get bumped out of memory, it will be available on every page without having to requery the database (you'd still issue the CFQUERY, but it wouldn't need to hit the database). This will only work if you have a limited number of query combinations, otherwise the chances of it getting bumped out of memory are greater. Bob -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: December 7, 2000 10:19 AM To: [EMAIL PROTECTED] Subject: RE: passing cfquery results to another page There are a number of ways, the first two that come to mind are: 1. Store it in a session variable. 2. Convert it to a WDDX packet, then store it in a client or cookie variable, or pass it via a URL or form parameter. The last two aren't advisable if the query is of any reasonable size. Bob -Original Message- From: sam sidhom [mailto:[EMAIL PROTECTED]] Sent: December 7, 2000 9:42 AM To: CF-Talk Subject: passing cfquery results to another page Can anyone tell me if there is anyway CF will pass the results of a CFQuery to another page without having to requery the database? Thanks, Jennifer Johnson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Variables
No, session variables can work without browser cookies, but it's a royal pain in the behind. You need to pass the CFID and CFTOKEN between all page requests (on the URL or in a form field) - as long as the chain is never broken, your session variables will work. Same goes for client variables. Bob -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: December 21, 2000 5:45 PM To: CF-Talk Subject: RE: Session Variables Based on some of the comments in this thread, am I correct in assuming that cookies must be enabled in the client's browser in order for session variables to work? Paul Sinclair -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 4:32 PM To: CF-Talk Subject: RE: Session Variables Session variable *could* clear under those conditions, depending on how your app is configured. Sessions are tracked (by default) automatically by CF with two automatically generated cookies, CFID and CFTOKEN. As long as these cookies exist int he browser AND the session timeout has not been reached, the session will stay alive. 1. When the user goes to a different site. Doesn't destroy the cookies, therefore session does not timeout till the actual timeout value is reached. 2. When the browser closes. Again, this depends on the behavior of the cookies. Are they written to disk or set to expire when the browser is closed. I can't remember which setting CF uses automatically, but you can set CF not to automatically set the cookies, and do it yourself. Look up the setclientcookies attribute in the cfapplication tag. You can then set the cookies manually using cfcookie and by referring to session.cfid and session.cftoken. cfcookie allow you to set the cookie timeout to anything you want, so have fun... 3. When the session timeout is reached. Yes, always... When the session timeout is reached, the session is destroyed. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Kinley Pon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:02 PM To: CF-Talk Subject: Session Variables Hello everyone, I was under the understanding that session variables will reset or clear out under the following circumstances: 1. When the user goes to a different site. 2. When the browser closes. 3. When the session timeout is reached. Sometimes it appears the session variables are not resetting or clearing out. Am I missing something Justme ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session Variables and Cookies
On 12/21/00, Mark Smeets penned: From the looks of it, you don't need Last User and Current User and the cookie part is it. As far as I can remember from the book those are just little "cutesy" pieces of code. I guess another question I have is, do I just simply have to say yes to session and client management and I can start storing my variables or do I need to set this up? Basically, what Ben does there is check to see if session.rollcount is defined. If it's not,then this is the first time the site has been accessed (for this session) and he sets a test cookie and a query string (session.addtoken) which is client.cfid and client.cftoken. Every link on the site should have: page.cfm?#session.addtoken# appended to the end. On the first click, the client.cfid and client.cftoken will be passed as a query string, assuring that the session will remain active even if cookies are off. session.rollcount will then be defined and he checks for the test cookie. If the test cookie exists, then cookies are active and he sets session.addtoken as an empty value, which will make your link look like page.cfm?. If not, then cookies are not active and the link remains page.cfm?cfid=53534cftoken=46373872828, or whatever, thus keeping the session alive for the next click and so on and so on. So, to answer your question. If you want people with cookies disabled to be able to store session variables, such as items in a shopping cart, then yes, you need to pass cfid and cftoken as a query string on every click. If not, then no you don't. Or you could simply bypass all the checks and pass the query string anyway. The values of cfid and cftoken will have the same values of the cfid and cftoken cookies if they are set. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: passing cfquery results to another page
I'm not sure if the query will get bumped if memory is needed. I thot some postings here suggested worse consequences. Anyone know the answer? best, paul At 08:18 AM 12/22/00 -0500, you wrote: How is caching the query different from saving it as a session variable? Both are kept in memory, right? Except that the cached one will get bumped if memory is needed? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox
Although Fusebox is probably the most popular (and best documented) publicly available methodology for coding ColdFusion, there are several other (arguably better) methods available. Two of these include CFObjects (http://www.cfobjects.com/) and SmartObjects (http://www.smart-objects.com/). There are also some other methodologies which very in degree of structure: Black Box (http://www.black-box.org/) relies on a single tag to tie together disparate ColdFusion templates. On the other side of the spectrum, Switch_Box (http://www.switch-box.org/) is a fairly complex methodology that requires setting up special extensions on the ColdFusion Server. Some developers, who feel constrained working in a methodology, prefer working in a framework. A couple examples of ColdFusion frameworks include iiFramework (http://www.iiframework.com/) and even Spectra (http://www.allaire.com). However, both of these are commercial software. Actually, I can't think of a public or open source ColdFusion framework off the top of my head...something for the community to think about at any rate. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 4:47 AM To: CF-Talk Subject: RE: Fusebox Jeff, You keep on going on about other methodologies. Which particular other methodologies using CF are publicly available? You keep mentioning all these other methodologies, but can we at least compare them to Fusebox? Fusebox is probably one of the best methodologies (if not the only public methodology) available for a ColdFusion developer. The book also covers a number of fundemental design elements that any CF'er should understand. EVEN if they don't do Fusebox. Adam -Original Message- From: Jeffry Houser [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 PM To: CF-Talk Subject:Re: Fusebox "Warrick, Mark" wrote: The fusebox methodology has many benefits, and I really don't think it adds any time to the development cycle. In fact, I'm pretty sure it helps speed up development. Well, that has nothing to do w/ Fusebox. Any programming methodology will offer this benefit. The key is having one in place and sticking to it. One of the greatest advantages of the style is that you can modularize you code, and in doing so, you can assign pieces of your application to various developers without worrying about them stepping on each other's toes. See above. This is not unique to fusebox. Another advantage is that certain companies (such as mine) require it. So if you don't do it, you're not going to get a job with certain companies. If you are not a consultant, that is complete hogwash, I think. Especially with today's job market. Fusebox (or whatever methodology the company uses) should be more than willing to train on the methodology. If you already know the language (What company doesn't have enough trouble finding people who know the language?), learning the coding practices should be easy enough. I did one job, where the first thing they did was sit me down and outline the coding practices. It took about a half hour sitting down with the lead developer. I took notes, and then followed them. No problems. Lastly, it's very simple to follow the programming flow of a fusebox app. When something goes wrong, you simply search for the fuseaction in the index file and then you'll see right away all the templates in a single handy block that could be involved with the problem. As I said previously, any methodology worth its salt should offer this. If I don't know fusebox, then your app isn't going to be any easier to follow than some other unknown methodology. (It probably will be easier to follow than random coding, though) -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox
Adam Reynolds wrote: Jeff, You keep on going on about other methodologies. Which particular other methodologies using CF are publicly available? You keep mentioning all these other methodologies, but can we at least compare them to Fusebox? I believe you make a good point, in saying that Fusebox is a publicly defined methodology. But, I believe you missed my point. No single methodology will fulfill every need. Fusebox is not the only methodology I have come across. Once you weed out the 'programming at random' people, You can probably find a different methodology for every programmer. For other publicly available methodologies: www.black-box.org www.switch-box.org Also I was told that 'www.litter-box.org' was going to define a methodology, but the site seems blank, or broken, at the moment. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: passing cfquery results to another page
I certainly agree. I gave up on storing my database in structures when I saw how easy query caching was to work with. best, paul At 08:18 AM 12/22/00 -0500, you wrote: Query caching is oh so easy. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox
Several people have thrown out the term 'CFObjects.' But if you good read up on CFObjects it is not really fleshed out and certainly not thoroughly tested by different programmers on different types of projects. It is just a good starting point to make an object oriented methodology out of Cold Fusion programming. What I like about Fusebox is it is the first methodology I have seen that specifically addresses the idiosyncrasies of web programming. The fact that it is geared for Cold Fusion is just a plus. Web programming is not the same as procedural programming, and although close it is not exactly the same as event-driven programming either. Does anyone know of any more 'researched' web programming methodologies? At 09:47 AM 12/22/00 +, Adam Reynolds wrote: Jeff, You keep on going on about other methodologies. Which particular other methodologies using CF are publicly available? You keep mentioning all these other methodologies, but can we at least compare them to Fusebox? Fusebox is probably one of the best methodologies (if not the only public methodology) available for a ColdFusion developer. The book also covers a number of fundemental design elements that any CF'er should understand. EVEN if they don't do Fusebox. Adam -Original Message- From: Jeffry Houser [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 PM To: CF-Talk Subject:Re: Fusebox "Warrick, Mark" wrote: The fusebox methodology has many benefits, and I really don't think it adds any time to the development cycle. In fact, I'm pretty sure it helps speed up development. Well, that has nothing to do w/ Fusebox. Any programming methodology will offer this benefit. The key is having one in place and sticking to it. One of the greatest advantages of the style is that you can modularize you code, and in doing so, you can assign pieces of your application to various developers without worrying about them stepping on each other's toes. See above. This is not unique to fusebox. Another advantage is that certain companies (such as mine) require it. So if you don't do it, you're not going to get a job with certain companies. If you are not a consultant, that is complete hogwash, I think. Especially with today's job market. Fusebox (or whatever methodology the company uses) should be more than willing to train on the methodology. If you already know the language (What company doesn't have enough trouble finding people who know the language?), learning the coding practices should be easy enough. I did one job, where the first thing they did was sit me down and outline the coding practices. It took about a half hour sitting down with the lead developer. I took notes, and then followed them. No problems. Lastly, it's very simple to follow the programming flow of a fusebox app. When something goes wrong, you simply search for the fuseaction in the index file and then you'll see right away all the templates in a single handy block that could be involved with the problem. As I said previously, any methodology worth its salt should offer this. If I don't know fusebox, then your app isn't going to be any easier to follow than some other unknown methodology. (It probably will be easier to follow than random coding, though) -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev
I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government that was overtaxing the citizens. It may seem only a semantic difference, but it is actually a huge difference. Your telling of the story would make Robin evil in my eyes...and we couldn't have that. ;-) wow this is way off topic... jon Kinda like Robin Hood (stealing from the rich...) only without giving it to the poor A to steal from the corporate and give to me... ahem...not steal...i mispoke myself..."borrow permanantly". Miles. cf_sarcasm Yes what were you thinking putting us at the mercy of these ruthless and criminally minded developers. In fact i propose that all developers on this list be executed immediately to offset any danger to world democracy or the groovy capitalist system that lets us all make lots of money in the IT world. Granted many of us are not the kind of wicked, Dr. Evil type of developers, but hell why take the chance, its just not worth it. I further propose that the word coldfusion be banned as subversive and against god ---woe unto him that hath developed in a wicked way /cf_sarcasm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Another Problem Windows Error 232
Dylan, This happens to be two separate boxes. :) Thanks, Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 2:11 AM Subject: RE: Another Problem Windows Error 232 hmm. error 232 is related to named pipes sometimes. which might explain the SQL error too. not sure... -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 9:33 PM To: CF-Talk Subject: Another Problem Windows Error 232 I receive this error and another server goes down the tubes: Error number 232 occurred while attempting to write the reply to the web server." "Error","TID=1508","12/22/00","00:10:02","Windows NT error number 232 occurred." Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP question
I have been searching through the allaire boards and it seems either any posts relating to using the CFHTTP questions either don't get answered or get a beat around the bush kind of answer. I have a huge project that is using the CFHTTP tag immensely only problem is i get the famous "Connection Falure" error. I am not behind a proxy, firewall or anything weird. Is there a setting somewhere that might block me from using CFHTTP? Is Allaire ever going to fix this problem? Thanks, Misty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio list and Studio 4.5.2 released
ColdFusion Studio 4.5.2 has been released. This is a rather useful release just for its ability to lock the side tabs and 'remember' that its in an RDS session for saving. You can read about the other features in the release notes and download the update at: http://allaire11.allaire.com/download/startdownload.cfm?ProdID=4F02C6C0-D533 -11D4-B0BF00508BCF1978FamID=1953B558-7AC0-11D4-849E0010B547F60ASubFamID=77 1264D3-6E4C-11D4-849E0010B547F60ADownloadType=Update An additional announcement is the opening of the Studio list at House of Fusion. This list is for discussion about CF Studio, JRun Studio and Homesite. You can subscribe from the list page at www.houseoffusion.com. Have a happy holidays. Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev
I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government Isn't the government rich? The saying is "Steal from the Rich and Give to the Poor." The "rich" is just referring to anyone with too much money, so they piss it all way. To make this a little bit of a CF threadanyone know if there are downsides to setting up your own client database and using that instead of storing client data in the two tables generated by CF? --Greg - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 10:20 AM Subject: Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government that was overtaxing the citizens. It may seem only a semantic difference, but it is actually a huge difference. Your telling of the story would make Robin evil in my eyes...and we couldn't have that. ;-) wow this is way off topic... jon Kinda like Robin Hood (stealing from the rich...) only without giving it to the poor A to steal from the corporate and give to me... ahem...not steal...i mispoke myself..."borrow permanantly". Miles. cf_sarcasm Yes what were you thinking putting us at the mercy of these ruthless and criminally minded developers. In fact i propose that all developers on this list be executed immediately to offset any danger to world democracy or the groovy capitalist system that lets us all make lots of money in the IT world. Granted many of us are not the kind of wicked, Dr. Evil type of developers, but hell why take the chance, its just not worth it. I further propose that the word coldfusion be banned as subversive and against god ---woe unto him that hath developed in a wicked way /cf_sarcasm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox
Just to insert my two cents worth, I inherited a site that I have now see was supposed to follow the fusebox methodology. It has been a nightmare trying to figure out what they were trying to do. I may be wrong but it seems to me that too have an include on the index page point to an action file that simply points to a display file was not the proper implementation. Just from looking the fusebox docs over once I see that what I would think is the proper implementation of this would be more like this 1)an include on the index page that points to an action file that does and action 2)an include on the index page below the action file that points to a query file 3)an include on the index page below the query file that points to a display file that may show the results returned based on the action and query file. Am I correct in this? I will admit that the methodology is a good thing to have to structure code and make it easier for a new programmer to come in and see what is going on. However in this case the documentation was nearly nonexistant and the fact that some of the includes stayed within the directory structure and others did not made this application extremely hard to follow. I am not the only programmer here that felt the same way about this application. I am not saying that the methodology is wrong...quite the contrary it seems to be simple and expandable. I am saying that no matter what methodolgy someone uses, the results you get will depend on how well you understand what the methodology is doing, how well you document your work and how closely you follow the specs of the methodology. Thanks Frederic ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (OT): The +.htr bug strikes again becomes categorically execu ting want to be dev
... anyone know if there are downsides to setting up your own client database and using that instead of storing client data in the two tables generated by CF? Of course, there are downsides. For any non-trivial choice you have to make as a programmer, there will always be pros and cons. Otherwise, it would be a trivial choice! To directly answer the question, though, there are two specific issues. One is that you have to build your own state management scheme, passing a token to the client that gets returned on each subsequent page request. This isn't a big problem, though; it's just a bit of extra work. Another is that you'd probably create a normalized data schema for this data, and if you had to add a new variable, you'd have to add a new column to store it. Again, not the end of the world. Finally, you won't get the ease of use of the Client scope. Nevertheless, it's pretty easy to build your own state management. After all, that's what we all did before CF introduced its own state management abstractions. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (OT): The +.htr bug strikes again becomes categorically executing want to be dev
When CF sets up the client variable storage tables, it uses whatever DSN you tell it to use. Setting up your own database, adding the tables with the appropriate fields, then setting CF to use that DSN is exactly the same thing - it should have no deleterious effect, other than using up a few extra minutes of your time :-) Happy Holidays! Jeff Beer Senior Programmer Architect Hydrogen Media, Inc (727) 530-5500 x303 [EMAIL PROTECTED] -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 10:45 AM To: CF-Talk Subject: Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government Isn't the government rich? The saying is "Steal from the Rich and Give to the Poor." The "rich" is just referring to anyone with too much money, so they piss it all way. To make this a little bit of a CF threadanyone know if there are downsides to setting up your own client database and using that instead of storing client data in the two tables generated by CF? --Greg - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 10:20 AM Subject: Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government that was overtaxing the citizens. It may seem only a semantic difference, but it is actually a huge difference. Your telling of the story would make Robin evil in my eyes...and we couldn't have that. ;-) wow this is way off topic... jon Kinda like Robin Hood (stealing from the rich...) only without giving it to the poor A to steal from the corporate and give to me... ahem...not steal...i mispoke myself..."borrow permanantly". Miles. cf_sarcasm Yes what were you thinking putting us at the mercy of these ruthless and criminally minded developers. In fact i propose that all developers on this list be executed immediately to offset any danger to world democracy or the groovy capitalist system that lets us all make lots of money in the IT world. Granted many of us are not the kind of wicked, Dr. Evil type of developers, but hell why take the chance, its just not worth it. I further propose that the word coldfusion be banned as subversive and against god ---woe unto him that hath developed in a wicked way /cf_sarcasm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox
I can sympathize with this. Our company bought a Forums package for our site. Written entirely in fusebox, its a great package and we've never had any problems, but when it came time to go through everything and familiarize our developers with the code, it was an exercise in futility. It seems that no page actually has any native code in it, the whole thing is made up of cfincludes, referencing other templates. IT just seems a little bit on the ridiculous side to write 300 odd 1k templates and cfinclude them in every single page. It was also a nightmare when we had to inventory all our code and queries and such. I wasted about a week trying to document everything before I finally gave up. -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:12 AM To: CF-Talk Subject: Re: Fusebox Just to insert my two cents worth, I inherited a site that I have now see was supposed to follow the fusebox methodology. It has been a nightmare trying to figure out what they were trying to do. I may be wrong but it seems to me that too have an include on the index page point to an action file that simply points to a display file was not the proper implementation. Just from looking the fusebox docs over once I see that what I would think is the proper implementation of this would be more like this 1)an include on the index page that points to an action file that does and action 2)an include on the index page below the action file that points to a query file 3)an include on the index page below the query file that points to a display file that may show the results returned based on the action and query file. Am I correct in this? I will admit that the methodology is a good thing to have to structure code and make it easier for a new programmer to come in and see what is going on. However in this case the documentation was nearly nonexistant and the fact that some of the includes stayed within the directory structure and others did not made this application extremely hard to follow. I am not the only programmer here that felt the same way about this application. I am not saying that the methodology is wrong...quite the contrary it seems to be simple and expandable. I am saying that no matter what methodolgy someone uses, the results you get will depend on how well you understand what the methodology is doing, how well you document your work and how closely you follow the specs of the methodology. Thanks Frederic ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP question
no I dont think there is a need for encoding it, it is a straight URL no paramters, sapces or whatever. Its just a call to a file on another server. I used this tag on my home computer about 2 months ago and it wored just fine. I have CF 4.0 at home. But on my hosting account they have 4.5.1 and that is where it is not working. -Original Message- From: ddewey [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 10:06 AM To: misty.d.woodward Cc: ddewey Subject: RE: CFHTTP question I've found from my experience with CFHTTP, that it is very particular. Are you GETing or POSTing. Have you tried urlencoding() the actual URL that you're trying to get? Does the URL you're trying to POST have a query string? Inquiring minds want to know! Dan --- Daniel Dewey|"According to the rule of averages, if you Unix/Internet SysAdmin | stand with one foot in a bucket of ice, MCP (NT srvr/wkstn/eprise) | and the other in a bed of hot coals, you [EMAIL PROTECTED] | should be feeling fine" -- Unknown http://www.pobox.com/~dewey | 610-868-1421, x115 The National Association of Colleges and Employers These opinions are mine, and may not be the same as my employer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 10:43 AM To: CF-Talk Subject: CFHTTP question I have been searching through the allaire boards and it seems either any posts relating to using the CFHTTP questions either don't get answered or get a beat around the bush kind of answer. I have a huge project that is using the CFHTTP tag immensely only problem is i get the famous "Connection Falure" error. I am not behind a proxy, firewall or anything weird. Is there a setting somewhere that might block me from using CFHTTP? Is Allaire ever going to fix this problem? Thanks, Misty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Queries on Irish last names that have an apostrophe
I hope this is an easy question for you SQL gurus. I am not sure why someone would want an apostrophe in their last name, :) but I need to know how to get around that when writing SQL queries that search records for last names contain apostrophes. Here is a sample query that loops through the search form fields and builds a dynamic query: CFQUERY NAME="SearchMembers" DATASOURCE="#DB#" SELECT * FROM #MemberTable# WHERE 0 = 0 CFLOOP INDEX=ThisField LIST="#FORM.FIELDNAMES#" CFIF #Evaluate(ThisField)# IS NOT "" AND #ThisField# LIKE '#Evaluate(ThisField)#%' /CFIF /CFLOOP /CFQUERY And here is what gets rendered when we pass some Irish name: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o'donnell'% And of course, this produces a SQL error. Anyone have tips for getting around this and still being able to search for names that contain an apostrophe? Thanks in advance. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Anonymous access failure in IIS NT4
I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another Problem Windows Error 232
it doesn't matter. you've got sql on one and cf on the other? you can still get this error. when i was at autobytel a few years back we fought the windows error 232 problem. it was related to something with named pipes. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 7:24 AM To: CF-Talk Subject: Re: Another Problem Windows Error 232 Dylan, This happens to be two separate boxes. :) Thanks, Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 2:11 AM Subject: RE: Another Problem Windows Error 232 hmm. error 232 is related to named pipes sometimes. which might explain the SQL error too. not sure... -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 9:33 PM To: CF-Talk Subject: Another Problem Windows Error 232 I receive this error and another server goes down the tubes: Error number 232 occurred while attempting to write the reply to the web server." "Error","TID=1508","12/22/00","00:10:02","Windows NT error number 232 occurred." Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Anonymous access failure in IIS NT4
Take a look at your directory permissions. Make sure the 'Everyone' group has read permissions. jon - Original Message - From: "Emmet McGovern" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 11:37 AM Subject: OT: Anonymous access failure in IIS NT4 I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Queries on Irish last names that have an apostrophe
Use the CF function PreserveSingleQuotes() to encapsulate the last name. -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 8:48 AM To: CF-Talk Subject: SQL Queries on Irish last names that have an apostrophe I hope this is an easy question for you SQL gurus. I am not sure why someone would want an apostrophe in their last name, :) but I need to know how to get around that when writing SQL queries that search records for last names contain apostrophes. Here is a sample query that loops through the search form fields and builds a dynamic query: CFQUERY NAME="SearchMembers" DATASOURCE="#DB#" SELECT * FROM #MemberTable# WHERE 0 = 0 CFLOOP INDEX=ThisField LIST="#FORM.FIELDNAMES#" CFIF #Evaluate(ThisField)# IS NOT "" AND #ThisField# LIKE '#Evaluate(ThisField)#%' /CFIF /CFLOOP /CFQUERY And here is what gets rendered when we pass some Irish name: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o'donnell'% And of course, this produces a SQL error. Anyone have tips for getting around this and still being able to search for names that contain an apostrophe? Thanks in advance. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Queries on Irish last names that have an apostrophe
With most SQL databases, you can get around this by escaping the apostrophe with another apostrophe, so that your query reads: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o''donnell'% I also noticed that your wildcard is outside your string delimiters. I'm assuming that's a typo in your post; it would cause a problem too :). W. Troy Leaver Systems Development Consultant Solution Specialists, Inc. 888-668-9193 -- Original Message -- From: "John McKown" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 22 Dec 2000 11:48:19 -0500 I hope this is an easy question for you SQL gurus. I am not sure why someone would want an apostrophe in their last name, :) but I need to know how to get around that when writing SQL queries that search records for last names contain apostrophes. Here is a sample query that loops through the search form fields and builds a dynamic query: CFQUERY NAME="SearchMembers" DATASOURCE="#DB#" SELECT * FROM #MemberTable# WHERE 0 = 0 CFLOOP INDEX=ThisField LIST="#FORM.FIELDNAMES#" CFIF #Evaluate(ThisField)# IS NOT "" AND #ThisField# LIKE '#Evaluate(ThisField)#%' /CFIF /CFLOOP /CFQUERY And here is what gets rendered when we pass some Irish name: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o'donnell'% And of course, this produces a SQL error. Anyone have tips for getting around this and still being able to search for names that contain an apostrophe? Thanks in advance. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
Take a look at your directory permissions. Make sure the 'Everyone' group has read permissions. Instead of this, make sure that the IIS anonymous user has read permissions, or the "Authenticated Users" group. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
have you resynced the anonymous password with the IUSR_MACHINE account via the MMC? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:37 AM To: CF-Talk Subject: OT: Anonymous access failure in IIS NT4 I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL and undelivered mail
I had the same problem with CF 4.5.1 and SP1 and SP2 did not solve it. The only solution that I found was to roll back to CF 4.0.1, which ran flawlessly. If you find a reliable solution with CF 4.5.1, I would like to know. Gary Groomer - Original Message - From: "David Cummins" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 1:53 PM Subject: CFMAIL and undelivered mail Hi guys, Our CF 4.5 server is generating a lot of undelivered mail. Does anyone know what conditions make CF put mail in the undelivered directory? Also, we've tried moving mail from undelivered to spool. Sometimes it gets sent, but if you move too much into spool it doesn't seem to. Could this be timeout related? Does anyone have a solution for remailing these easily? David Cummins ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP question
Do they have the latest service packs installed for 4.5.1? I think there were many problems reported with CFHTTP on 4.5 that have hopefully all been resolved with the service packs. hth, Tobe At 11:36 AM 12/22/2000 , you wrote: no I dont think there is a need for encoding it, it is a straight URL no paramters, sapces or whatever. Its just a call to a file on another server. I used this tag on my home computer about 2 months ago and it wored just fine. I have CF 4.0 at home. But on my hosting account they have 4.5.1 and that is where it is not working. -Original Message- From: ddewey [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 10:06 AM To: misty.d.woodward Cc: ddewey Subject: RE: CFHTTP question I've found from my experience with CFHTTP, that it is very particular. Are you GETing or POSTing. Have you tried urlencoding() the actual URL that you're trying to get? Does the URL you're trying to POST have a query string? Inquiring minds want to know! Dan --- Daniel Dewey|"According to the rule of averages, if you Unix/Internet SysAdmin | stand with one foot in a bucket of ice, MCP (NT srvr/wkstn/eprise) | and the other in a bed of hot coals, you [EMAIL PROTECTED] | should be feeling fine" -- Unknown http://www.pobox.com/~dewey | 610-868-1421, x115 The National Association of Colleges and Employers These opinions are mine, and may not be the same as my employer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 10:43 AM To: CF-Talk Subject: CFHTTP question I have been searching through the allaire boards and it seems either any posts relating to using the CFHTTP questions either don't get answered or get a beat around the bush kind of answer. I have a huge project that is using the CFHTTP tag immensely only problem is i get the famous "Connection Falure" error. I am not behind a proxy, firewall or anything weird. Is there a setting somewhere that might block me from using CFHTTP? Is Allaire ever going to fix this problem? Thanks, Misty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (OT): The +.htr bug strikes again becomes categorically executing want to be dev
LOL. But actually, you are right. But aren't big corporations running the governement now anyway? They have been for 40 years. Alas, it will probably get worse now that President (S)elect Bush is in office. -Gary -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 9:20 AM To: CF-Talk Subject: Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government that was overtaxing the citizens. It may seem only a semantic difference, but it is actually a huge difference. Your telling of the story would make Robin evil in my eyes...and we couldn't have that. ;-) wow this is way off topic... jon Kinda like Robin Hood (stealing from the rich...) only without giving it to the poor A to steal from the corporate and give to me... ahem...not steal...i mispoke myself..."borrow permanantly". Miles. cf_sarcasm Yes what were you thinking putting us at the mercy of these ruthless and criminally minded developers. In fact i propose that all developers on this list be executed immediately to offset any danger to world democracy or the groovy capitalist system that lets us all make lots of money in the IT world. Granted many of us are not the kind of wicked, Dr. Evil type of developers, but hell why take the chance, its just not worth it. I further propose that the word coldfusion be banned as subversive and against god ---woe unto him that hath developed in a wicked way /cf_sarcasm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bulk Insert?
Brian,
As far as I can tell there are two ways to operate on data: on a row/record
basis OR as sets. Will you be looping through your data ? Well, it depends
on your specific situation.
Situation 1
If you are trying to enter multiple rows of free form text in the database,
then yes you are probably going to be looping over an array and following a
very similar logic path to the CF one you are trying to avoid. However, the
reason you are trying to avoid looping over a dataset and running multiple
inserts is because the connection process to a database is "heavy". So,
even though you might still be looping over data in the DB you might
actually be increasing performance. This depends on the specific factors in
your applicationfor example if the DB is running at a high utilization
.maybe this method isn't for you. If your middleware / webserver(s) are
being taxed you might want to consider this path. The string parsing
efficiency of your database server versus the string parsing efficiency of
CF connection overhead must also be factored into this equation.
I found the need to do this a while back I just can't find the sample code I
wrote. But you'll just pass in the appropriate strings that are value
delimited. Don't forget to encode the data in the strings if their is a
possibility of having the delimiter character in the data. Once you have
the string in the DB you'll need to loop over the string(s) and parse out
the nuggets of data, then run your INSERT (or whatever).
Obviously you don't want to avoid turning your database into a row based
data engine except where necessary. If you can find a way to work situation
2 ...go with it over situation 1
Situation 2
If you are trying to insert data that is coming from other tables that
already exist most likely you can pass in some strings and some clever
INSERT INTO / SELECT FROM statements. When I say data that already exists,
take for example a College that has Students and Classes. If you want to
associate a student with an arbitrary number of classes You could do
something like the following :
CREATE PROCEDURE addClasses
@StudentID INT = 1,
@classesSelectedVarChar(255) = NULL,
EXEC(
"INSERT INTO StudentClasses (StudentID,ClassID)
SELECT StudentID = " + @studentID + ", ClassID
FROMClasses
WHERE ClassID IN (" + @classesSelected + ")"
)
GO
The above route is SQL Server code, but I'm sure PL/SQL has some similar
capabilities. If you can go this route you will avoid looping ...you will be
operating on your data in a set based way.
Hope this helps.
-eric
If you don't read news.groups, the net appears to be a rather tranquil
place.
-- Karl Lehenbauer, about Usenet
Eric Barr
Zeff Design
(p) 212.714.6390
(f) 212.580.7181
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 1:30 PM
To: CF-Talk
Subject: RE: Bulk Insert?
Ok, you have me intrigued. Are you talking about a PL/SQL procedure that
takes the entire array and then parses it? Won't you be looping through the
array anyway?
Brian
-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 11:31 AM
To: CF-Talk
Subject: RE: Bulk Insert?
Jon,
You can get away with this in some situations through some clever gymnastics
in your sql.
What it will come down to is passing a string into a stored procedure that
you then do some string parsing and looping and use EXEC() (assuming your
using SQL server). Althouhg procedding in this manor does impose some
constraints: a lot of string manipulation in SQL is generally a bad idea,
limit to the length of the string that can be passed in, etc.. But, I
would try it out both ways and run some informal performance tests to figure
out which way fits your specific situation.
-eric
If to please people we offer what we ourselves disapprove, how can we
afterwards defend our work.
-George Washington
Eric Barr
Zeff Design
(p) 212.714.6390
(f) 212.580.7181
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 18, 2000 9:23 PM
To: CF-Talk
Subject: Bulk Insert?
I am wondering if anyone knows of any way to dump the entire contents of an
array into a table without having to loop over an insert query?
jon
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Queries on Irish last names that have an apostrophe
Yes, that was a typo. The % is actually within the quotes. I tried using '' to escape the last name and I still get an error. I also tried the PreserveSingleQuotes to no avail. Ugh. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 -Original Message- From: Troy Leaver [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:51 AM To: CF-Talk Subject: Re: SQL Queries on Irish last names that have an apostrophe With most SQL databases, you can get around this by escaping the apostrophe with another apostrophe, so that your query reads: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o''donnell'% I also noticed that your wildcard is outside your string delimiters. I'm assuming that's a typo in your post; it would cause a problem too :). W. Troy Leaver Systems Development Consultant Solution Specialists, Inc. 888-668-9193 -- Original Message -- From: "John McKown" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 22 Dec 2000 11:48:19 -0500 I hope this is an easy question for you SQL gurus. I am not sure why someone would want an apostrophe in their last name, :) but I need to know how to get around that when writing SQL queries that search records for last names contain apostrophes. Here is a sample query that loops through the search form fields and builds a dynamic query: CFQUERY NAME="SearchMembers" DATASOURCE="#DB#" SELECT * FROM #MemberTable# WHERE 0 = 0 CFLOOP INDEX=ThisField LIST="#FORM.FIELDNAMES#" CFIF #Evaluate(ThisField)# IS NOT "" AND #ThisField# LIKE '#Evaluate(ThisField)#%' /CFIF /CFLOOP /CFQUERY And here is what gets rendered when we pass some Irish name: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o'donnell'% And of course, this produces a SQL error. Anyone have tips for getting around this and still being able to search for names that contain an apostrophe? Thanks in advance. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (OT): The +.htr bug strikes again becomes categorically executing want to be dev
Hey Eric, I am sending you a package in the mail. It will be in a plain brown wrapper with a return address like Ed McMahon and Company, that sounds like you may have won a lot of money. Just pick it up and shake it violently before ripping it open. Think of it as a holiday present. (Note: Please do not open around children or family members. Also, you may want to call a bunch of your developer friends and gather BEFORE opening it. BIG SURPRISE inside. (thinking to self) Okay. One (or more) less developer(s) means $125 an hour x 1.45 to 2. If I send out 500 of these at a cost of -Gary -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:52 PM To: CF-Talk Subject: (OT): The +.htr bug strikes again becomes categorically executing want to be dev I wonder how the categorical execution of developers would influence the hourly rates we could work for. I mean think about it. If each developer executes one developer, the demand wouldn't change, so our rates would explode. maybe 10x what is currently available. E From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: The +.htr bug strikes again Date: Thu, 21 Dec 2000 15:05:49 -0800 cf_sarcasm Yes what were you thinking putting us at the mercy of these ruthless and criminally minded developers. In fact i propose that all developers on this list be executed immediately to offset any danger to world democracy or the groovy capitalist system that lets us all make lots of money in the IT world. Granted many of us are not the kind of wicked, Dr. Evil type of developers, but hell why take the chance, its just not worth it. I further propose that the word coldfusion be banned as subversive and against god ---woe unto him that hath developed in a wicked way /cf_sarcasm #code.monkey# ** Original Subject: RE: The +.htr bug strikes again ** Original Sender: Billy Cravens [EMAIL PROTECTED] ** Original Date: Thu, 21 Dec 2000 15:20:27 -0500 ** Original Message follows... Don't you think it would have been better to wait until after Hasbro patched it to alert a list of hundreds of developers? I often run across cf sites with the htr bug (it's hardly uncommon). I usually email the webmaster personally, as opposed to the "Hey guys! Look what I found!" Just out of curiosity (nothing against you Kevin): what are the legal implications for something like this? Even if it's just a hole which a person could find on their own, can pointing it out be a cause for liability? -- Billy Cravens [EMAIL PROTECTED] Kevin Schmidt wrote: Check out Hasbro Interactive. They run entirely CF and haven't patched the +.htr bug yet. I alerted them to this fact. Kevin Schmidt, Web Technology Manager Allaire Certified Cold Fusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP question
I have had problems with cfhttp. In one case it was my routing table on the server, and in another I was running a release candidate of W2K, the installation of the final release W2K server cleared up my remaining problems. If it helpful I can give you some server space for the interim to help with troubleshooting. ie to compare and environment that works vs one that doesn't. are you having intermittant problems? or just can't connect? Question for the group: Is it worth trying CFX_HTTP? Eric From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: CFHTTP question Date: Fri, 22 Dec 2000 09:43:12 -0600 I have been searching through the allaire boards and it seems either any posts relating to using the CFHTTP questions either don't get answered or get a beat around the bush kind of answer. I have a huge project that is using the CFHTTP tag immensely only problem is i get the famous "Connection Falure" error. I am not behind a proxy, firewall or anything weird. Is there a setting somewhere that might block me from using CFHTTP? Is Allaire ever going to fix this problem? Thanks, Misty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The +.htr bug strikes again
Someone should probably make an official "checklist" to run through when you setup a CF server. (Removing .htr extension coming soon after where you setup index.cfm as a default doc) There are a couple of these sorts of things - people just have to use them! There are IIS security checklists from Microsoft and SecurityFocus, and an IIS configuration checklist again from MS. There's a CF-specific list of items (pretty short - don't install examples) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Variables
Based on some of the comments in this thread, am I correct in assuming that cookies must be enabled in the client's browser in order for session variables to work? No, that's not correct, although it would make everybody's life a bit easier. CF can receive the CFID and CFTOKEN values from cookies or through the URL, or potentially even through form fields. All that matters is that, for every subsequent page request, the browser sends back the appropriate CFID and CFTOKEN values. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: passing cfquery results to another page
How is caching the query different from saving it as a session variable? Both are kept in memory, right? Except that the cached one will get bumped if memory is needed? Query caching is different in several ways. 1. It uses the CFQUERY attributes and the actual SQL statement within the CFQUERY tags to determine whether a recordset will be reused from the cache or retrieved from the database. If the attributes or SQL are different, the database will be queried. If you store a recordset in a persistent memory variable (Session, Application, Server) then reference that variable, you'll always get the original recordset, unless you write code to rebuild its contents yourself. 2. It's very easy to retrofit query caching into an existing application, while the use of memory variables for query caching is a bit harder to add after the fact. Query caching is easier in general. Also, cached queries will not be bumped from memory except by other cached queries, based on the maximum number of cached queries the server is configured to allow. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Queries on Irish last names that have an apostrophe
SQL7 Full-text search handles this automagically. That is, searches for O'Neill without any massaging of O'Neill to O''Neill, and so forth. Perhaps Verity does, too. But Verity doesn't allow standard SQL in the same breath as SQL7 full-text search does. Perhaps the new Verity K2 will add amazing new functionality. best, paul At 11:48 AM 12/22/00 -0500, you wrote: I am not sure why someone would want an apostrophe in their last name, :) but I need to know how to get around that when writing SQL queries that search records for last names contain apostrophes. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The +.htr bug strikes again
You are not liable for pointing out someone else mistakes. I could tell someone that a bank is open and there are no security guards. Am I liable if they go and rob it. I think not. What people do is their decision. While I'm not a lawyer, you may in fact be liable for your actions, especially in a civil suit, where the standards of proof and liability may be a lot lower. A lot of times, things like this go in favor of the guys with the bigger legal staff. My guess is, that's not you. There are plenty of limitations on free speech - you can't yell "fire" in a crowded theater - and by your negligence about who you inform, harm to third parties may result. This isn't a battle you want to be involved in. In addition, how did you find out about the vulnerability? My guess is that you used a URL which exploits the vulnerability. At this point, you're not just telling others that someone's door is open, you're checking the doorknob first yourself - in Louisiana, you might get shot for that! In any case, my original point about this is that, regardless of the legality of publishing vulnerabilities of specific sites, it's not something that should be done. We all have sites, most of us aren't security experts, and it's very easy for any one of us to not have all the latest patches or have followed all the checklist steps. Before you post a vulnerability to the public, ask yourself if you'd want someone else to post your vulnerability. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
variable problem
Hi, My variable problem is that I have a header template that appears on every single page in my application. inside this header is an img src tage whose image needs to change based on which page is being accessed: img src="#imageName#" since the variables are set at the top of each page from this 'header' template I need to be able to designate the #imageName# variable from the 'content' part of my pages. So basically I have a variable at the top of the page that needs to pull from a value at the bottom of the page. Can this be done? Maybe I should set a session variable and delete/rewrite it with every call to a new page?? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Queries on Irish last names that have an apostrophe
Hmm, what database are you using? W. Troy Leaver Systems Development Consultant Solution Specialists, Inc. 888-668-9193 -- Original Message -- From: "John McKown" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 22 Dec 2000 12:21:02 -0500 Yes, that was a typo. The % is actually within the quotes. I tried using '' to escape the last name and I still get an error. I also tried the PreserveSingleQuotes to no avail. Ugh. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 -Original Message- From: Troy Leaver [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:51 AM To: CF-Talk Subject: Re: SQL Queries on Irish last names that have an apostrophe With most SQL databases, you can get around this by escaping the apostrophe with another apostrophe, so that your query reads: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o''donnell'% I also noticed that your wildcard is outside your string delimiters. I'm assuming that's a typo in your post; it would cause a problem too :). W. Troy Leaver Systems Development Consultant Solution Specialists, Inc. 888-668-9193 -- Original Message -- From: "John McKown" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 22 Dec 2000 11:48:19 -0500 I hope this is an easy question for you SQL gurus. I am not sure why someone would want an apostrophe in their last name, :) but I need to know how to get around that when writing SQL queries that search records for last names contain apostrophes. Here is a sample query that loops through the search form fields and builds a dynamic query: CFQUERY NAME="SearchMembers" DATASOURCE="#DB#" SELECT * FROM #MemberTable# WHERE 0 = 0 CFLOOP INDEX=ThisField LIST="#FORM.FIELDNAMES#" CFIF #Evaluate(ThisField)# IS NOT "" AND #ThisField# LIKE '#Evaluate(ThisField)#%' /CFIF /CFLOOP /CFQUERY And here is what gets rendered when we pass some Irish name: SELECT * FROM Lawyers WHERE 0 = 0 AND LNAME LIKE 'o'donnell'% And of course, this produces a SQL error. Anyone have tips for getting around this and still being able to search for names that contain an apostrophe? Thanks in advance. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP question
I have been searching through the allaire boards and it seems either any posts relating to using the CFHTTP questions either don't get answered or get a beat around the bush kind of answer. I have a huge project that is using the CFHTTP tag immensely only problem is i get the famous "Connection Falure" error. I am not behind a proxy, firewall or anything weird. Is there a setting somewhere that might block me from using CFHTTP? Is Allaire ever going to fix this problem? The problem here is that diagnosing problems with an HTTP client run from a CF script isn't very easy. You don't know what's happening "behind the scenes" so to speak. You can find out, though, with a recording proxy, which you can pass your HTTP requests through. It'll write down the HTTP requests and responses, which might help you to diagnose the problem. Here are a couple that I've used successfully: Stretch: http://www.kestral.com.au/devtools/ HTTPSniffer (requires Perl): http://www.compansr.demon.co.uk/ The documentation for Stretch is nonexistent, but both tools are pretty easy to use. Simply run the utility with the IP address of the target server. Then, change your CFHTTP request so that it sends to the proxy instead of the target server - typically, you put the proxy on your web server, and it listens at port 8080 by default. Then, run your page and see what happens! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
All permissions are set correctly. I still have the same problem though. Microsofts knowledge base isnt much use either. This is threatening to kill my weekend at this point :( Emmet -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:13 PM To: CF-Talk Subject: RE: Anonymous access failure in IIS NT4 If you are running Web sites in their own memory space, then the IWAM account for the machine (either in the domain SAM if your Web server is a domain control or on the local machine's SAM otherwise) needs read access to the Web site directories. If the Web sites are running in shared memory space, then the IUSR account needs read access. You may want to make sure that the SYSTEM account (or whatever account you run ColdFusion under) has at least read to the directories if these are ColdFusion sites. Judging by your description of the problem, however, this is probably not the problem. The only other accounts that should have permissions to files in the Web site directories are, of course, the administrative account, and those users who need special permissions for FTP, password protected web sites, etc. Do not give the Guest account or the Everyone group access. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:37 AM To: CF-Talk Subject: OT: Anonymous access failure in IIS NT4 I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The +.htr bug strikes again
There are two sides to this issue. 1. Releasing bug/vulnerability information to the public will release hoards of script kiddies to cause havoc and dismay instantaniously without recourse. 2. Releasing bug/vulnerability information will cause industry leaders like Microsoft and respectively Allaire to act on the information sooner than later. I can see both sides of the fence but would lean to alerting the public to the problem. Security by obscurity is not a good policy to live by. While I agree with this as far as product vendors are concerned, that's not what's going on here. It's one thing to release general information about vulnerabilities in MS products to the public (although even within the security community, there's quite a bit of debate over whether and how this should be done - should the vendor be notified privately first, how long between vendor notification and public release, etc.). It's another thing to release specific information about who hasn't patched their installations of vendor products, which is what's going on here - "so-and-so is vulnerable to the .htr bug". This doesn't have any place within either side of the issue that you're talking about, and is pretty irresponsible in my opinion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY (OT): The +.htr bug strikes again becomes categorically executing want to be dev
Yes, the government tends to throw away too much money. For an example, my company's primary product is a client/server client and service management system that we sell to many state government agencies. We, of course, provide tech support for our customers. It amazes me how many calls we get from "system administrators" that probably get paid twice what I do, that don't even know how to do basic Windows networking. The most extreme example is where the new "systems administrator" from the largest and the most well funded state level government agency in the country, in our particular niche, E-mailed one of our tech-support guys to ask him what his E-mail address is . and this is the agency that is charged with overseeing all other such agencies in the state. Your tax dollars at work, ladies and gents. :) Todd - Original Message - From: "Greg Wolfinger" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 10:45 AM Subject: Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government Isn't the government rich? The saying is "Steal from the Rich and Give to the Poor." The "rich" is just referring to anyone with too much money, so they piss it all way. To make this a little bit of a CF threadanyone know if there are downsides to setting up your own client database and using that instead of storing client data in the two tables generated by CF? --Greg - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 10:20 AM Subject: Re: (OT): The +.htr bug strikes again becomes categorically executing want to be dev I am being anal, but you are misconstruing the Robin Hood legend. He did not steal from the "rich". He stole from the government that was overtaxing the citizens. It may seem only a semantic difference, but it is actually a huge difference. Your telling of the story would make Robin evil in my eyes...and we couldn't have that. ;-) wow this is way off topic... jon Kinda like Robin Hood (stealing from the rich...) only without giving it to the poor A to steal from the corporate and give to me... ahem...not steal...i mispoke myself..."borrow permanantly". Miles. cf_sarcasm Yes what were you thinking putting us at the mercy of these ruthless and criminally minded developers. In fact i propose that all developers on this list be executed immediately to offset any danger to world democracy or the groovy capitalist system that lets us all make lots of money in the IT world. Granted many of us are not the kind of wicked, Dr. Evil type of developers, but hell why take the chance, its just not worth it. I further propose that the word coldfusion be banned as subversive and against god ---woe unto him that hath developed in a wicked way /cf_sarcasm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The +.htr bug strikes again
isn't the bug a microsoft iis issue? i have tried it on asp pages and can see their code as well...it's not just a cf problem. could this be another "big brother" deal with microsoft by allowing them to put in the +.htr and seeing our source code? Yes, it's an IIS issue. No, it's not a "big brother" deal. My guess is that no one at Microsoft gives a rat's ass about any of our CF code. The problem here is more that Microsoft software, like that from many other vendors, provides lots of functionality that the vast majority of users don't use or want. With things like MS Office, that results in bloatware. With Outlook, it results in email macro viruses. With things like IIS, it results in server security problems. The key is to not install anything you don't need, and to disable what you can't avoid installing but still don't need. Microsoft has guidelines for securing IIS, but the vast majority of people using IIS - I hesitate to refer to them as "administrators" - simply install it, with all its sample code and ISAPI mappings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
about ssl
This is a multi-part message in MIME format. --=_NextPart_000_005D_01C06C19.6EF472B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can i do ssl with my web pages using cf? --=_NextPart_000_005D_01C06C19.6EF472B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2FONT face=3DArialHow can i do ssl FONT = color=3D#ffFONT=20 color=3D#00with my web pages/FONT /FONTFONT = color=3D#00using=20 cf?/FONT/FONT/FONT/DIV/BODY/HTML --=_NextPart_000_005D_01C06C19.6EF472B0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
All permissions are set correctly. I still have the same problem though. Microsofts knowledge base isnt much use either. This is threatening to kill my weekend at this point :( My guess is that, despite what you think, all permissions aren't set correctly. There are a couple of things you might try. 1. Can you reach HTML pages via the anonymous user, but not CF pages? If so, the problem is that you need to allow RX rights for the anonymous user to the C:\CFUSION\BIN\ISCF.DLL file, which is what IIS uses to pass requests to CF. This is a common problem. 2. Can you log onto the console as the anonymous user, and browse the filesystem and read the affected files? If not, that may be a problem. 3. Does the anonymous user have "log on locally" rights? If I recall correctly, that's required in addition to simply allowing network logons for that user. You'll need to go into User Manager and look at user rights under the Policies menu. 4. If none of those guesses are correct, you might try using a nifty little utility, NT File Monitor. It's freeware, and will let you see some of the file access permissions issues in real time: http://www.sysinternals.com/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The +.htr bug strikes again
Since this discussion is already taking so much bandwidth, here's a quote from a recent MS security mailing that you may find useful: "Administrators who have followed IIS best practices would not be vulnerable to this kind of attack. Best Practices for IIS4 and IIS5, including lockdown tools and a hotfix checker, can be found at the following URLs: IIS4 Best Practices: http://www.microsoft.com/technet/security/iischk.asp IIS5 Best Practices: http://www.microsoft.com/technet/security/iis5chk.asp IIS5 Lockdown Tool: http://www.microsoft.com/Downloads/Release.asp?ReleaseID=19889 IIS5 Hotfix Checker Tool: http://www.microsoft.com/Downloads/Release.asp?ReleaseID=24168" Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ThisTag.GeneratedContent
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there an equivalent to a custom tag's "ThisTag.GeneratedContent" variable for the base executing page? To the best of my knowledge, there is no way to retrieve this generated content from within the scope of the request itself. Answer Found! Sort of I found a bit of a kludge that accomplishes what I need with a minor amount of hacking... Vis: My basic goal here was to run a custom tag over the entire contents of a page request. I was hoping to do something like: OnRequestEnd.cfm: = !--- This doesn't work... --- cfset Content = ThisPage.GeneratedContent Cfset ThisPage.GeneratedContent = "" cf_GZipPage#Content#/cf_GZipPage Here's what I did find: In the Application.cfm, I put this code: CF_GZipPage Cfinclude template="/RootMapping#CGI.Script_Name#" cfinclude template="OnRequestEnd.cfm" /CF_GZipPage cfabort Note that you could omit the OnRequestEnd line if you don't use that file OR you could put it into a try block if you're not sure they'll be an OnRequestEnd like: cftrycfinclude template="OnRequestEnd.cfm"cfcatch type="MissingInclude"/cfcatch/cftry Also note that the above, if dropped at the end of your application.cfm would ignore any all output that was actually generated by your app.cfm. That's what I wanted in my case. If you're outputting stuff in your app.cfm that you need, then you should do something like: CF_GZipPage !--- All your app.cfm stuff here. --- Cfinclude template="/RootMapping#CGI.Script_Name#" cfinclude template="OnRequestEnd.cfm" /CF_GZipPage cfabort This whole thread of course links into the compression of HTML output thread elsewhere in this list. I've managed to setup a little tag that GZIP's all of our page content for browsers that can handle GZIP encoding. We get anywhere from 2 to 10 times compression, and our customers are already commenting on the speed increase. The system's processors are of course working a little harder now, but that means they're floating at 10% instead of at 4%. Whoopee! Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com Comment: Please use PGP! iQA/AwUBOkObMKvhLS1aWPxeEQIXSQCcD5tqlYkGzgrNN4EGvMxBZBDG1zIAoMHy nq2e9OSwdbZsF41TNdEhJmDS =ZZbS -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
little help here?
here is my code for my image viewing pages, i have two things to figure out now. one is i have all of the images seperated with a Yes or a No value. they both need to be shown on there own. (all the ones with yes in one section and all the ones with No in thier own section.) thats the first thing i need to figure out, then the next is how do i get them to show up in the format that i want 3 accross the top, 2 in the middle and 3 accross the bottom... can you help me? cfquery name="GetImages" datasource="gallery" dbtype="ODBC" Select * From ImageManager /cfquery head titleUntitled Document/title /head body bgcolor="#00"center pimg src="images/catlin_hdr.gif"/p pnbsp;/p br CFPARAM NAME="URL.StartRow" DEFAULT="1" cfoutput query="GetImages" startrow=#URL.StartRow# maxrows=8 a href="OrderManager/OrderForm.cfm?ImageId=#ImageId#"img src="ImageManager/WebImages/#GetImages.ImageName#" border="0"/a /CFOUTPUT CFOUTPUT A HREF="early.cfm?StartRow=#Evaluate(URL.StartRow + 8)#"Next 8/a /CFOUTPUT /center /body Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: about ssl
How can i do ssl with my web pages using cf? SSL doesn't really have anything to do with CF, which works the same way whether you're using SSL or not. You'll need to get an SSL certificate and install it on your web server. Verisign and Thawte (which is now owned by Verisign, but still operates independently, it looks like - Thawte certs are cheaper!) are two big SSL certificate vendors: http://www.verisign.com/ http://www.thawte.com/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [about ssl]
SSL is implemented by the webserver not CF. You need a key which can be bought from a "trusted certificate authority" or made by yourself. "sherrie" [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --=_NextPart_000_005D_01C06C19.6EF472B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can i do ssl with my web pages using cf? --=_NextPart_000_005D_01C06C19.6EF472B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2FONT face=3DArialHow can i do ssl FONT color=3D#ffFONT=20 color=3D#00with my web pages/FONT /FONTFONT color=3D#00using=20 cf?/FONT/FONT/FONT/DIV/BODY/HTML --=_NextPart_000_005D_01C06C19.6EF472B0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
Heh, it would seem that permissions are not set correctly as you are able to connect to the Web site using an account with administrator permissions. Perhaps you meant to say that the permissions were set as per the recommendations you've received so far? If that is the case, then you may want to double check what account IIS is in fact using. Are you running Web sites in their own memory space or not? Are these ColdFusion sites, HTML, etc.? Do your security logs tell you anything? Any additionally information would be helpful. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:50 PM To: CF-Talk Subject: RE: Anonymous access failure in IIS NT4 All permissions are set correctly. I still have the same problem though. Microsofts knowledge base isnt much use either. This is threatening to kill my weekend at this point :( Emmet -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:13 PM To: CF-Talk Subject: RE: Anonymous access failure in IIS NT4 If you are running Web sites in their own memory space, then the IWAM account for the machine (either in the domain SAM if your Web server is a domain control or on the local machine's SAM otherwise) needs read access to the Web site directories. If the Web sites are running in shared memory space, then the IUSR account needs read access. You may want to make sure that the SYSTEM account (or whatever account you run ColdFusion under) has at least read to the directories if these are ColdFusion sites. Judging by your description of the problem, however, this is probably not the problem. The only other accounts that should have permissions to files in the Web site directories are, of course, the administrative account, and those users who need special permissions for FTP, password protected web sites, etc. Do not give the Guest account or the Everyone group access. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:37 AM To: CF-Talk Subject: OT: Anonymous access failure in IIS NT4 I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The +.htr bug strikes again
Ok. I can see that my piece of information, that I intended to be totally harmless, has caused quite a stir. From now on I will keep my mouth shut. The only reason I let people on the list know is because the site uses CF and there had been alot of discussion on the topic over the past few day. Several people didn't even know the bug existed. I told the sites administrators about the problem and I don't know if they have fixed it yet or not. Maybe they don't care or maybe they do. There have been other sites metioned in this thread that have the same problem. People disclosed the information to warn consumers of the problem and to choose someone else to provide the service that the said company provided because the company hadn't fixed the issue. Some people on the list don't think mentioning these types of issues is a problem, others do. I am stepping of my soapbox now. If anyone has questions about the +.htr issue i'll be happy to entertain them. There have also been numerous posts with URL's to the patch posted to the list. Happy Holiday's Kevin Schmidt, Web Technology Manager Allaire Certified Cold Fusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 12:04 PM Subject: RE: The +.htr bug strikes again There are two sides to this issue. 1. Releasing bug/vulnerability information to the public will release hoards of script kiddies to cause havoc and dismay instantaniously without recourse. 2. Releasing bug/vulnerability information will cause industry leaders like Microsoft and respectively Allaire to act on the information sooner than later. I can see both sides of the fence but would lean to alerting the public to the problem. Security by obscurity is not a good policy to live by. While I agree with this as far as product vendors are concerned, that's not what's going on here. It's one thing to release general information about vulnerabilities in MS products to the public (although even within the security community, there's quite a bit of debate over whether and how this should be done - should the vendor be notified privately first, how long between vendor notification and public release, etc.). It's another thing to release specific information about who hasn't patched their installations of vendor products, which is what's going on here - "so-and-so is vulnerable to the .htr bug". This doesn't have any place within either side of the issue that you're talking about, and is pretty irresponsible in my opinion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Compress HTML output]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Okay... I think the tag is done. I made a few more changes (see below). I also figured out how to automagically compress all the pages in your site w/ one little change. Here's what I did find: In the Application.cfm, I put this code: CF_GZipPage Cfinclude template="/RootMapping#CGI.Script_Name#" cfinclude template="OnRequestEnd.cfm" /CF_GZipPage cfabort Note that you could omit the OnRequestEnd line if you don't use that file OR you could put it into a try block if you're not sure they're'll be an OnRequestEnd like: cftrycfinclude template="OnRequestEnd.cfm"cfcatch type="MissingInclude"/cfcatch/cftry Also note that the above, if dropped at the end of your application.cfm would ignore any all output that was actually generated by your app.cfm. That's what I wanted in my case. If you're outputting stuff in your app.cfm that you need, then you should do something like: CF_GZipPage !--- All your app.cfm stuff here. --- Cfinclude template="/RootMapping#CGI.Script_Name#" cfinclude template="OnRequestEnd.cfm" /CF_GZipPage cfabort We get anywhere from 2 to 10 times compression, and our customers are already commenting on the speed increase. The system's processors are of course working a little harder now, but that means they're floating at 10% instead of at 4%. Whoopee! Here's the tag for people's perusal. If you find any glaring errors or have general suggestions, please share them with me. If I don't hear anything, I'll post this in the tag gallery some time next week. Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com Comment: Please use PGP! iQA/AwUBOkObpqvhLS1aWPxeEQJAcwCaAlXKaaZrAK4UDYzvMZ/pVaT/wTUAoOuF sdj1jvSQDab6aH6Q4TV9xQHZ =3LEC -END PGP SIGNATURE- GZipPage.cfm: (This will probably be looped by your mail reader/server.) =-=-=-=-=-=-= !--- CF_GZipPage -- Let's call this Version 1.0... Make sure this tag surrounds the ENTIRE page. It will GZIP the GeneratedContent using CFX_GZip and modify the browser headers so that the browser can decode it. Anything that falls outside of the start and end tag for this tag will be ignored and never seen by the client. Parameters (All are optional): Level: The GZip Compression Level, 0 is lowest compression (biggest size, least processor usage), 9 is highest compression (smallest size, greatest processor usage) Directory: The temporary directory to use for compression. Two files will be created here for each request. This directory must exist or the tag will error. CopyLeft 2000 Zachary Bedell [EMAIL PROTECTED] Special thanks to: Orlando Correa [EMAIL PROTECTED] for suggesting the Directory attribute and for code to check the Accept-Encoding header. Peter Stolz [EMAIL PROTECTED] for reminding me that the Accept-Encoding header exists... All the folks on CF-Talk who took the time to read these posts test out the tag. You may use this code as you wish, no strings attached. No Warrenty. If it breaks, you get to keep both pieces -ZSB 18-Dec-2000 --- cfif ThisTag.ExecutionMode EQ "END" !--- Sane defaults: --- cfparam name="Attributes.Level" default="9" cfparam name="Attributes.Directory" default="c:\temp" cfparam name="Attributes.ShowDebugging" default="false" cfif ListContainsNoCase(CGI.HTTP_Accept_Encoding, "gzip") AND Attributes.Level GT 0 AND Attributes.Level LTE 9 !--- If this browser can't handle GZIP encoding, then there's no point in doing anything... If the GZIP level is 0 that means no compression, so let's not waste our time. Also, if it's greater than 9, we'd have an error, so just get on with things... --- cfset Directory = Attributes.Directory cfif Right(Directory, 1) NEQ "\"cfset Directory = Directory "\"/cfif !--- Setup path filename for tempfiles: --- cfset UniqueFilePath = "#Directory##CreateUUID()#" cfset RawHTMLFile = "#UniqueFilePath#.htm" cfset GZippedFile = "#UniqueFilePath#.gz" !--- Grab the generated content and write it out to a tempfile. --- cfset Content = Trim(ThisTag.GeneratedContent) cfif Attributes.ShowDebugging cfset DebugText = "#Chr(13)##Chr(10)#!-- Page Compressed by CF_GZipPage. Original Size: #Len(Content)#--" Cfset Content = Content DebugText /cfif cffile action="WRITE"
RE: SQL Queries on Irish last names that have an apostrophe
Did you try '#PreserveSingleQuotes(Evaluate(ThisField))#%' -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 9:51 AM To: CF-Talk Subject: RE: SQL Queries on Irish last names that have an apostrophe That sounds cool. I will check out the indexing features of SQL 7 since that is what I am working on. In the mean time, here is how I fixed it (notice the ReReplace): CFQUERY NAME="SearchMembers" DATASOURCE="#DB#" SELECT * FROM #MemberTable# WHERE 0 = 0 CFLOOP INDEX=ThisField LIST="#FORM.FIELDNAMES#" CFIF #Evaluate(ThisField)# IS NOT "" AND #ThisField# LIKE '%#REReplace(Evaluate(ThisField), "'", "''", "ALL")#%' /CFIF /CFLOOP /CFQUERY John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:38 PM To: CF-Talk Subject: Re: SQL Queries on Irish last names that have an apostrophe SQL7 Full-text search handles this automagically. That is, searches for O'Neill without any massaging of O'Neill to O''Neill, and so forth. Perhaps Verity does, too. But Verity doesn't allow standard SQL in the same breath as SQL7 full-text search does. Perhaps the new Verity K2 will add amazing new functionality. best, paul At 11:48 AM 12/22/00 -0500, you wrote: I am not sure why someone would want an apostrophe in their last name, :) but I need to know how to get around that when writing SQL queries that search records for last names contain apostrophes. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [database update?]]
replace it over FTP at night. this has nothing to do with CF Peter Benoit [EMAIL PROTECTED] wrote: It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: about ssl
At 01:24 PM 12/22/2000 -0500, you wrote: How can i do ssl with my web pages using cf? SSL doesn't really have anything to do with CF, which works the same way whether you're using SSL or not. You'll need to get an SSL certificate and install it on your web server. or if you're using a webhosting service...all you -probably- need to do is write your URL with https https://www.yourdomain.com/mysecurepage.cfm check with your webhost to make sure... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: [database update?]]
Well it kinda can't be done that way. Essentially they throw a whole new DB at me once a week and ask that the new info be presented immediately. Currently it takes about 15 mins for the new info to appear. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 2:00 PM To: CF-Talk Subject: Re: [RE: [database update?]] replace it over FTP at night. this has nothing to do with CF Peter Benoit [EMAIL PROTECTED] wrote: It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Page Tracking hits :: User Movments on an Intranet
Ooops yes, of course.
You can use the #script_name# variable.
And if you want to do it fusebox style, you can use the following logic instead:
!--- begin page hit count ---
br
br
font size="-2"
cfset page = "#script_name#" "?" "#query_string#"
cftransaction
cfquery name="gethits" datasource="#session.dsn#"
SELECT * FROM counter
WHERE page = '#page#'
/cfquery
CFIF #gethits.recordcount# is 0
CFQUERY name="makepage" datasource="#session.dsn#"
INSERT INTO counter (page,hits)
VALUES ('#page#', 2)
/cfquery
CFSET hits = 0
1
CFELSE
cfif (remote_addr eq "24.8.137.130") or (remote_addr eq "24.7.62.126")
cfoutput#gethits.hits#/cfoutput
cfelse
!-- Current Hit Count:
cfoutput#gethits.hits#/cfoutput
--
/cfif
CFSET newhits = (gethits.hits + 1)
CFQUERY name="updatehits" datasource="#session.dsn#"
UPDATE counter
SET hits = #newhits#
WHERE page = '#page#'
/cfquery
/CFIF
/cftransaction
/font
!--- end page hit count ---
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 22, 2000 4:44 AM
To: CF-Talk
Subject: RE: Page Tracking hits :: User Movments on an Intranet
would you also need to insert the name of the page?
so that you can see what page how long they where on it?
thanks for the advice.
-paul
-Original Message-
From: Warrick, Mark [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:03 PM
To: CF-Talk
Subject:RE: Page Tracking hits :: User Movments on an Intranet
Hi Paul,
I really don't think there is a tutorial. You can use the code below as
an example. This is the easiest way to track visitors. You
would include
this into every template. (by the way, this has nothing to do
with server
logs)
cfset ip = "#cgi.remote_addr#"
cfset login_time = "#TimeFormat(Now(), "HH:MM:SS")#"
cfset login_date = "#DateFormat(Now(), "MM/DD/")#"
(of course you'll need to create a database for this)
cfquery name="record_visit" datasource="#dsn#"
INSERT INTO access_log (
ip,
login_date,
login_time)
VALUES (
'#ip#',
'#login_date#',
'#login_time#')
/cfquery
---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 4:51 AM
To: CF-Talk
Subject: RE: Page Tracking hits :: User Movments on an Intranet
is there a tutorial for this in the advanced wack book?
guess i should just look my self, sorry.
i cant use server logs.
they are turned off
thanks
-paul
-Original Message-
From: Warrick, Mark [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 1:25 PM
To: CF-Talk
Subject:RE: Page Tracking hits :: User Movments
on an Intranet
The anonymous way would be to assign a random ID to each new visitor
and
then record that ID with every page view (or fuseaction) into a
database
or text file.
The membership-based way would be to have a user login then track
them
the same way.
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 5:47 AM
To: CF-Talk
Subject: Page Tracking hits :: User Movments on an Intranet
hello all!
i know this has been asked befor, but i cant find the email.
What software or utilities do you guys use to track user
movments on
your
site?
i need to see what parts of our intranet are really being
utalized
what
isnt.
so i can do a rebuild.
any helpp would be great!
thank you
-paul
Web Developer, NBBJ
Work: [EMAIL PROTECTED]
Re: [database update?]
Depending on how big the database is, if it is not too big why not just loop over each record in the new database and update the old records. Checking in each loop to see of the record is new, if so, Insert it. This is assuming that they do not change the database structure on you. This whole process would be made faster if the database that they feed you was designed to put a timestamp on each record any time a record was added or updated. That way you could just query the database for anything that has a timestamp after your last update. You could make it super easy on yourself by providing the person who gives it to you a url to go to and upload the new database to. The web site would automatically update the database, and the updater would know when the new data is up right away. jon - Original Message - From: "Peter Benoit" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 1:38 PM Subject: RE: [database update?] It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [RE: [database update?]]]
see if you can compress it somehow. Peter Benoit [EMAIL PROTECTED] wrote: Well it kinda can't be done that way. Essentially they throw a whole new DB at me once a week and ask that the new info be presented immediately. Currently it takes about 15 mins for the new info to appear. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 2:00 PM To: CF-Talk Subject: Re: [RE: [database update?]] replace it over FTP at night. this has nothing to do with CF Peter Benoit [EMAIL PROTECTED] wrote: It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LOCKING revisited...Test Results
I think you're going to have to put the spreadsheet up to be viewed online or downloaded. Doesn't this list strip off attachments? Gentlemen, cf_tease severity="gentle ribbing"Oh, I'm sorry, was I not supposed to look?/cftease -Patti -Original Message- From: Richard Kern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 2:14 PM To: CF-Talk Subject: RE: LOCKING revisited...Test Results Gentlemen, I have completed a series of tests on locking in CF and share with you my findings. You may find the results surprising and I make several conclusions as a result of the test. If you would like a copy of the CF page, database, or summary spreadsheet mail me off list and I'll send them to you. i know the experiment can be improved on. I only ran 3 iterations for each test but the number of variations cost the better part of a day. Thanks to my company for the slack time. If nothing else this will be the starting point for additional work. Richard Kern --- Summary of lock testing on CF Server A. Conclusions The overall results of the test are instructive on four counts. First the method of locking whether on the server or actual page does not significantly affect the application performance. Second the scope of the locking does not significantly affect the application performance Third, the only approach to catching all shared variables that need to be locked is either by manual coding or specifically applying ALL THREE OPTIONS in CFAS at the FULL CHECK OR AUTO READ level. LESS THAN THIS ALLOWS SOME SHARED VARS TO RUN UNLOCKED. Fourth, the locking approach makes no difference statistically. Therefore it should be accepted that the approach is a matter of individual preference. The concern should be for complete coverage either through page coding or server settings if you have access to them. B. Results Graphing the mean values of the results shows that there is some discernable difference between the methods of locking. However, the std deviation between the tests shows a low variability, lending credence to the server performance despite the small sample size. An F-Test confirms this, none of the approaches are statistically significantly different. Using a test of DF 2,2, .10 = 9.00 , none of the F values come anywhere near this, the highest calculated value is .95 and that is the exception. The graphs show that the CFSA individual scope settings are slightly faster than the baseline of no locks at all on the production server. Applying all CFSA scope settings produces times equivalent to the baseline on the production server and longer on the local machine. C. Setup Run date: 21 Dec 00. CF Server is 4.5.1 on NT server 4.0 SP5. Two servers involved - local machine and production server on LAN (light traffic). Single page submitted to server with 1000 iteration loop on database query. CF page has three session variables and one database query. Three runs for each approach were done and recorded. CF Lock applied to page using 4.5 syntax to specify scope, no name Time reported in milliseconds as reported through CF debugging. Time includes server overhead for parsing, startup and shutdown. Server useage approaches 80% during the processing of the page, no other traffic as shown on CF Perf Mon. D. Data See excel 2000 spreadsheet file. - CFLocktest.xls ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Creating an E-mail database of this list
Hey Guys: I was wondering what the best method is to store all of the e-mails that come throught these lists. What do you guys use?? Happy Holidays, ---Greg ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: little help here?
To simplfy things, I would first run two queries - one for the "yes" images and one for the "no" images. Then I would output those two queries into their respective columns. To make the images display 3 across, set a count when you start outputting the images. Evaluate the count upon each subsequent record output, and when you get to 3, put in the appropriate /TR (or line break) and reset the count. You would also want to evaluate the total recordcount to be sure you close off the table tags correctly. For example: tr cfset imagecount = 0 cfouput query="no_images" cfset imagecount = imagecount+1 tdimg src="#imgsrc#" width="#imgwidth#" height="#imgheight#" alt="#imgalt#"/td cfif currentrow eq recordcount cfif imagecount eq 1 tdnbsp/td tdnbsp/td /tr cfelseif imagecount eq 2 tdnbsp/td /tr /cfif cfelse cfif imagecount eq 3 /tr tr cfset imagecount = 0 /cfif /cfoutput -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 10:23 AM To: CF-Talk Subject: little help here? here is my code for my image viewing pages, i have two things to figure out now. one is i have all of the images seperated with a Yes or a No value. they both need to be shown on there own. (all the ones with yes in one section and all the ones with No in thier own section.) thats the first thing i need to figure out, then the next is how do i get them to show up in the format that i want 3 accross the top, 2 in the middle and 3 accross the bottom... can you help me? cfquery name="GetImages" datasource="gallery" dbtype="ODBC" Select * From ImageManager /cfquery head titleUntitled Document/title /head body bgcolor="#00"center pimg src="images/catlin_hdr.gif"/p pnbsp;/p br CFPARAM NAME="URL.StartRow" DEFAULT="1" cfoutput query="GetImages" startrow=#URL.StartRow# maxrows=8 a href="OrderManager/OrderForm.cfm?ImageId=#ImageId#"img src="ImageManager/WebImages/#GetImages.ImageName#" border="0"/a /CFOUTPUT CFOUTPUT A HREF="early.cfm?StartRow=#Evaluate(URL.StartRow + 8)#"Next 8/a /CFOUTPUT /center /body Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The +.htr bug strikes again
Here, here. Almost all Linux people who are concerned with security know that the first thing they need to do is go in and turn off ALL services they don't need to use at that absolute moment. I turn off every bloody Linux service that I don't absolutely need every time I bring up a new machine. I suggest anyone who installs ANY type of server software (i.e. ColdFusion Server) follow this practice. This applies to all OS' and all programs .. It just makes sense when you think about it :) Todd - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 1:11 PM Subject: RE: The +.htr bug strikes again isn't the bug a microsoft iis issue? i have tried it on asp pages and can see their code as well...it's not just a cf problem. could this be another "big brother" deal with microsoft by allowing them to put in the +.htr and seeing our source code? Yes, it's an IIS issue. No, it's not a "big brother" deal. My guess is that no one at Microsoft gives a rat's ass about any of our CF code. The problem here is more that Microsoft software, like that from many other vendors, provides lots of functionality that the vast majority of users don't use or want. With things like MS Office, that results in bloatware. With Outlook, it results in email macro viruses. With things like IIS, it results in server security problems. The key is to not install anything you don't need, and to disable what you can't avoid installing but still don't need. Microsoft has guidelines for securing IIS, but the vast majority of people using IIS - I hesitate to refer to them as "administrators" - simply install it, with all its sample code and ISAPI mappings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Never use session variables?
Hi, Just ran across a an article regarding session variables and ASP which takes a hard line against using them, the main reasons being server slowdown and hard to read code. I myself have never had a problem with session variables causing either in CF, and haven't seen this rationale mentioned here, so I was wondering if this was ASP specific, or maybe consultant preference. The whole article is here: http://www.4guysfromrolla.com/webtech/faq/Advanced/faq4.shtml Just curious - any comments appreciated. Thanks! Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The +.htr bug strikes again
On 12/22/00, Dave Watts penned: Before you post a vulnerability to the public, ask yourself if you'd want someone else to post your vulnerability. Yeah, kind of like "HEY LOOK EVERYBODY! JOE'S FLY IS DOWN!" rather than "pssst, Joe, your fly is down". :-D -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: variable problem
The direct answer is no. In order for this to work, you would have to make sure that the header is output after your varible is set. One trick is to capture the output of your content section into a variable, then at the bottom output your header, your variable, and any footer. Your code ends up looking something like: cf_woPageCaptureOutput r_sVar="Request.Body" include template="mods/mod_mymod.cfm" /cf_woPageCaptureOutput cfinclude template="dsp_myHeader.cfm" cfoutput#Request.Body#/cfoutput cfinclude template="dsp_myFooter.cfm" Thanks, David Sparkman Application Development Team Leader Weberize, Inc. http://www.weberize.com -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:44 AM To: CF-Talk Subject: variable problem Hi, My variable problem is that I have a header template that appears on every single page in my application. inside this header is an img src tage whose image needs to change based on which page is being accessed: img src="#imageName#" since the variables are set at the top of each page from this 'header' template I need to be able to designate the #imageName# variable from the 'content' part of my pages. So basically I have a variable at the top of the page that needs to pull from a value at the bottom of the page. Can this be done? Maybe I should set a session variable and delete/rewrite it with every call to a new page?? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
!
cf_happyholidays ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox
I agree with Hal. The major problem with CFObjects is that you have to tackle the additiona learning curve of an OO methodology, *and* the documentation/sample-apps leave a lot to be desired for a person new to the methodology. If CFO only had a like Hal hawking it, it'd get a much wider notice :) - Original Message - From: "Hal Helms" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 5:00 PM Subject: RE: Fusebox I have to disagree regarding CFObjects, a framework written by my friend, Ralph Fiol. CFObjects is completely fleshed out and has been tested by many programmers. In fact, version 2 is in beta form right now. While I prefer Fusebox as a methodology, I don't think it's fair to say CFObjects isn't there yet. Just my opinion... Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 9:53 AM To: CF-Talk Subject: RE: Fusebox Several people have thrown out the term 'CFObjects.' But if you good read up on CFObjects it is not really fleshed out and certainly not thoroughly tested by different programmers on different types of projects. It is just a good starting point to make an object oriented methodology out of Cold Fusion programming. What I like about Fusebox is it is the first methodology I have seen that specifically addresses the idiosyncrasies of web programming. The fact that it is geared for Cold Fusion is just a plus. Web programming is not the same as procedural programming, and although close it is not exactly the same as event-driven programming either. Does anyone know of any more 'researched' web programming methodologies? At 09:47 AM 12/22/00 +, Adam Reynolds wrote: Jeff, You keep on going on about other methodologies. Which particular other methodologies using CF are publicly available? You keep mentioning all these other methodologies, but can we at least compare them to Fusebox? Fusebox is probably one of the best methodologies (if not the only public methodology) available for a ColdFusion developer. The book also covers a number of fundemental design elements that any CF'er should understand. EVEN if they don't do Fusebox. Adam -Original Message- From: Jeffry Houser [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 PM To: CF-Talk Subject:Re: Fusebox "Warrick, Mark" wrote: The fusebox methodology has many benefits, and I really don't think it adds any time to the development cycle. In fact, I'm pretty sure it helps speed up development. Well, that has nothing to do w/ Fusebox. Any programming methodology will offer this benefit. The key is having one in place and sticking to it. One of the greatest advantages of the style is that you can modularize you code, and in doing so, you can assign pieces of your application to various developers without worrying about them stepping on each other's toes. See above. This is not unique to fusebox. Another advantage is that certain companies (such as mine) require it. So if you don't do it, you're not going to get a job with certain companies. If you are not a consultant, that is complete hogwash, I think. Especially with today's job market. Fusebox (or whatever methodology the company uses) should be more than willing to train on the methodology. If you already know the language (What company doesn't have enough trouble finding people who know the language?), learning the coding practices should be easy enough. I did one job, where the first thing they did was sit me down and outline the coding practices. It took about a half hour sitting down with the lead developer. I took notes, and then followed them. No problems. Lastly, it's very simple to follow the programming flow of a fusebox app. When something goes wrong, you simply search for the fuseaction in the index file and then you'll see right away all the templates in a single handy block that could be involved with the problem. As I said previously, any methodology worth its salt should offer this. If I don't know fusebox, then your app isn't going to be any easier to follow than some other unknown methodology. (It probably will be easier to follow than random coding, though) -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road
Re: [Compress HTML output]
Not sure if this has been talked about in detail but with the interest in dynamic html compression I will throw my two cents in. Why use a cfx tag with coldfusion to compress html output when you can use IIS 5.0's builtin gzip/deflate compressors? I bet the cfx/cf overhead is much higher and not suitable for high volume situations. With IIS 4.0 you need the recource kit which contains the isapi compression filters. By default, you can set IIS to do a "application" level, not "static" level compression, which would compress dynamic content. Go to the "services" tab of the server in the mmc. However, and by default, the dynamic compression only applies to "asp", "exe", and "dll" extensions. So for it to compress cf streams than you need to use METAEDIT.EXE to modify the metadata which is like the registry but specific to IIS. There you can add "cfm" to the HcScriptFileExtension key under W3SVC/Filters/Compression/+ deflate/gzip. Once done, do a "c:\inetpub\adminscripts\IISreset.exe /restart" in the cmd window and you should see the "inetinfo" process take up much more cpu usage than before. If not then it is still not configured right. You can also use the METAEDIT.EXE to change the compressing buffer size, compression level, etc... I was able to reduce the bandwith usage from 3.3mb/s to 2mb/s which is close to 40% decause in bandwith using level 7 compression. Still not sure if IIS is using GZIP or DEFLATE but I'm happy nonetheless. Xing ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Displaying Query Results in Two or More Columns
There is probably a really obvious answer to this, but I can't work out how to display records in multiple columns. I want to achieve something like this: trtdrecord 1/tdtdrecord 2/td/tr trtdrecord 3/tdtdrecord 4/td/tr trtdrecord 5/tdtdrecord 6/td/tr etc. So that my query results are displayed in balanced columns. Any ideas? Regards Barney ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Displaying Query Results in Two or More Columns
There are several ways to do what you want, the easiest imo below. Now try thinking about 3 columns of data going vertical with subcategories...ouch, I hated that site ;-) cfset startrow = 1 cfset displaycols = 2 cfquery name="stuff" ... SELECT Items /cfquery table cfloop query="stuff" tr cfoutput query="stuff" maxrows="#displaycols#" startrow="#start_row#" td#Items#/td /cfoutput cfset start_row = startrow + displaycols /tr /cfloop /table jon - Original Message - From: "Barney Stevenson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 9:31 PM Subject: Displaying Query Results in Two or More Columns There is probably a really obvious answer to this, but I can't work out how to display records in multiple columns. I want to achieve something like this: trtdrecord 1/tdtdrecord 2/td/tr trtdrecord 3/tdtdrecord 4/td/tr trtdrecord 5/tdtdrecord 6/td/tr etc. So that my query results are displayed in balanced columns. Any ideas? Regards Barney ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP question
An Allaire consultant told us that our DNS was screwed up and that it was our problem. Seems like you must be using our internal DNS server, as well ;-) So we found out if you use the actual IP address instead of the domain name, it usually worked. In addition, we found the changing the slashes (/) to (\) also helped. Until you can get Allaire to admit it is not your DNS server, you are basically screwed. Date sent: Fri, 22 Dec 2000 09:43:12 -0600 From: [EMAIL PROTECTED] Subject:CFHTTP question Send reply to: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] I have been searching through the allaire boards and it seems either any posts relating to using the CFHTTP questions either don't get answered or get a beat around the bush kind of answer. I have a huge project that is using the CFHTTP tag immensely only problem is i get the famous "Connection Falure" error. I am not behind a proxy, firewall or anything weird. Is there a setting somewhere that might block me from using CFHTTP? Is Allaire ever going to fix this problem? Thanks, Misty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Do cached querries need to be locked?
I am assuming that if multiple pages hit the same cached query, Cold Fusion internally handles it correctly without me locking it?? But then again, I would have assumed it would handle session variables correctly also if I didn't subscribe to cf-talk:) I am thinking: what happens if I have a large dataset being cached and what happens when it expires.. the next page to hit it has to re-run the query. While that query is executing, other pages are still reading it. Al Musella, DPM Musella Foundation ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Do cached querries need to be locked?
Don't know if its the final solution, but I put all my cached queries into Request scope. a la CFQUERY Name="Request.MyQuery". best, paul At 10:53 PM 12/22/00 -0500, you wrote: I am assuming that if multiple pages hit the same cached query, Cold Fusion internally handles it correctly without me locking it?? But then again, I would have assumed it would handle session variables correctly also if I didn't subscribe to cf-talk:) I am thinking: what happens if I have a large dataset being cached and what happens when it expires.. the next page to hit it has to re-run the query. While that query is executing, other pages are still reading it. Al Musella, DPM Musella Foundation ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
