Re: SQL IN and cfqueryparam lists
So you're saying that it's an inappropriate use of the null parameter. Wasn't that part of the original question? - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 08, 2006 4:26 PM Subject: Re: SQL IN and cfqueryparam lists NULL should NOT work in an IN clause. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234763 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Conditional HTML headers?
Is there any way (in CF5) that I can conditionally generate an HTML header if it is not already defined by a CFHTMLHEAD tag? Is there a particular variable scope that contains this information that I might examine while generating the page? I'd like to add a default page title tag, plus default metatags such as description and keywords, but only if they haven't already been defined by a cfhtmlhead tag. Taking that a step further, is it possible to know if something like a title tag has already been generated in a page output, but this time by a standard HTML title tag rather than by a CF tag? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234107 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: IIS URL rewriter?
I've noticed a lot of other web sites these days redirecting http://domain.com to http://www.domain.com. And I've read that serving a web site under both host names may invoke a duplicate content penalty in some search engines. We'd also like to use a URL rewriter to force certain areas or pages of the site, such as http://www.domain.com/myaccount/ to use SSL/https, while expressly keeping any other areas of the same site from being served using SSL. What is a good URL rewriter that can be used with both IIS 5 and IIS 6? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: IIS URL rewriter?
Actually, I'm doing some similar things in CF, although not to redirect 'host.name' to 'www.host.name'. For non-CF content you can use a combination of IIS's error handling templates and either CF or ASP, but it gets fairly complicated and is easily broken by configuration changes. I'm sure using an ISAP plugin and it doing at the server level is also much more efficient than using CF. For the SSL, yes, I've tried using IIS capabilities, but haven't really been able to do what I want. I believe it can be done by a rewriter, but I'll have to see what Dave's recommendation can do. I think you can use a regex to tell it that anything requested using https:// and not under, say, '/myaccount/' would be redirected to http://. If I have an SSL cert attached to a web site I always find it difficult making sure that any links leaving the secure area do not use SSL. - Original Message - From: Jim Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 01, 2006 3:08 PM Subject: Re: OT: IIS URL rewriter? Not having used a URL rewriter, I may be off here, but is it going to solve either one of your issues? The domain.comwww.domain.com issue can be solved with a 301 redirect...in cf you can detect what the host header is, and then redirect using something like: cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=http://www.domain.com; And I don't see how a URL rewriter is going to solve the SSL issue. IIS has the ability to require SSL (although not real good capabilities to automatically redirect to https, if I remember correctly). Does a URL rewriter generally give you that kind of control? On 3/1/06, Jim McAtee [EMAIL PROTECTED] wrote: I've noticed a lot of other web sites these days redirecting http://domain.com to http://www.domain.com. And I've read that serving a web site under both host names may invoke a duplicate content penalty in some search engines. We'd also like to use a URL rewriter to force certain areas or pages of the site, such as http://www.domain.com/myaccount/ to use SSL/https, while expressly keeping any other areas of the same site from being served using SSL. What is a good URL rewriter that can be used with both IIS 5 and IIS 6? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233815 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Debit vs. Credit Card
- Original Message - From: Michael Traher [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 28, 2006 3:07 AM Subject: Re: Debit vs. Credit Card The first 4 digits of the card determines the type of card it is and who issued it. Thanks, but by 'type' do you mean to say that it can be determined if a card is a debit or credit card? If so, what is the algorithm? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Debit vs. Credit Card
Two questions, probably unrelated: To an online merchant, is there any way to tell a debit card from a credit card of the same type (VISA, MasterCard, etc.) just from the card number? I've dealt with some companies (Verizon comes to mind) that run some kind of preauthorization against a credit card before running the actual charge transaction immediately afterward. What is the reasoning behind doing this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Developing for 800 x 600 on monitor at higher resolution
Who views pages with the brower full screen when using a monitor with 1280x1024 resolution? Other than my gramma, that is... I'd either go to a liquid layout, or keep on doing what you've been doing. If it looks like hell then users will most likely just resize the browser's viewport to better fit the page. - Original Message - From: Earl, George [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 22, 2006 2:13 PM Subject: SOT: Developing for 800 x 600 on monitor at higher resolution We just got new LCD monitors that have a native resolution of 1280 x 1024 but we develop for 800 x 600 (inTRAnet standard). Like lots of LCDs, these look like crap at anything other than their native resolution. If you are in the same boat, how do you develop for a non-native resolution like 800 x 600 and make sure that everything fits and looks right? Do you pop up an 800 x 600 browser window to view the pages? Use a second monitor set to 800 x 600? Use a utility? Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: A very specific message board/forum question...
Get (and pay for) vBulletin - another php app, but heads and shoulders above phpBB. I'm sure there must be data migration scripts from php. Use the vBulletin database as your site's user base. You can authenticate user logins from CF against the vBulletin user database and you can take registrations and create new users within the vBulletin database from your CF apps. There's likely little that you'd want in a forum that isn't already in vBulletin. The only thing you'll probably want to do is skin it, which is fairly trivial. - Original Message - From: Jeff Small [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 21, 2006 1:53 PM Subject: Re: A very specific message board/forum question... Not directly, but I got pretty well aquainted with it trying to install it, never installed PHP directly and ran into a few issues. I have done what I have talked about with other systems, ASP comes to mind. Run any questions you have, I'm sure we can figure out how to make it work without you having to find a new solution then run into a headache of moving data. Yeah, after reading some of the responses here, and poking around, it actually doesn't seem like it's going to be that hard to do. I'm going to go off and ponder this and see what everyone else wants to do. It might be a decision that's out of my hands at this point. Thanks for all the quick replies and great info. Appreciate it all. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233049 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: missing posts???
A lot of spam engines will simply turn the message away at the door (so to speak) by cutting off the connection when they see something they don't like. Usually this is something foobar in the headers. Doesn't HOF do a lot of manipulation of messages with its email server? Maybe something's out of spec there under certain conditions. I thought someone else mentioned seeing some sort of non-compliance in the headers of some messagees received from this list. - Original Message - From: Ken Ferguson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 19, 2006 11:43 AM Subject: Re: missing posts??? I checked -- nothing there! Thanks for trying though. --Ferg Ian Skinner wrote: So, I was confused by the conversation about Jennifer's bounce... I wasn't confused by the subject matter though; it's the fact that I've NEVER gotten any post from her. I realized that I was getting parts of the conversation and could see her replies inline in the other posts. Out of curiosity, I looked back through all of my emails (I never delete the cftalk emails) and saw that I've NEVER seen a post from her. Now, the question I pull out of this is why and how many other people are posting that I'm missing altogether?? --Ferg I know the spam service my company uses, even though I have CF-Talk white listed, will still pick random to my eyes CF-Talk messages to quarantine. Every now and then I go into the tool and forward them on to myself. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230025 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Since were on the topic of Credit Cards... A best practices question...
- Original Message - From: Stacy Young [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 13, 2006 1:58 PM Subject: RE: Since were on the topic of Credit Cards... A best practices question... I'm not sure about our competitors but generally it is possible to do partial settles. (just pass auth reference #) One thing u need to keep in mind is that there's a time limit on those auths (which u may know already) which varies by card type and is not controlled by the processor. Also crediting back to a card is pretty much frowned upon by CC folks in case u were thinking about that approach. Crediting cards must be extremely common with merchandise returns at virtually any retailer. How can they be frowned upon if they're a part of everyday business with so many merchants? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229525 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Since were on the topic of Credit Cards... A best practices question...
You're scenario is unique in that you wouldn't need to store the CC number for future purchases through the reservation system. Amazon and other online retailers who store CC numbers do so to facilitate easy checkouts on future purchases. You could save the CC number offline and then have someone manually process them once a trip has taken place. If they really wanted to cut down on no shows, they'd charge everyone the full amount up front. Why take a deposit when they're going to be charging the full amount unless the trip doesn't happen? Refund 1/2 if the trip gets rained out by mailing refund checks back to the customer. The other thing about this plan is what will they do with folks who pay the deposit by cash or check rather than with a credit card? Anyone with half a brain is going to figure out that paying by check protects them from getting charged the balance if they decide not to show up. - Original Message - From: J W [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 13, 2006 12:49 PM Subject: Since were on the topic of Credit Cards... A best practices question... With all this talk of encrypting and storing passwords, I have a best practices question. I am currently working on a reservations system for a tours company. One of the BIG goals of this system is to cut down on no shows. Each space needs to be reserved since there are only X amount of spaces to fill on each trip. They want to require a 50% non refundable deposit when ordering through this system. Say each one is $80 total, so they want 40 up front. BUT here is the big but. Since the remainder of the payment is due at the time of the tour, they want to let the customer choose method of payment for the whole thing, whether that is putting the total amount on the CC, Check or cash. Basically they want the card number to charge you the 40 if you no show and charge the 40 bucks and in case the trip is rained out, they don't have to refund the 40 for everyone else who reserved. At firstthey wanted me just to take and store the CC # to which I said No F'n way. SO I need to come up with an acceptable solution. BTW, Customer is made aware of the 50% non refundable charge by answering yes to a disclaimer BEFORE they place the reservation. The slight catch is that these reservations can be made up to a year in advance.. What would you do? Here is my thinking Pre auth everyone for 40, don't settle. Day of trip, the owner goes in to the online processer and finds the preauths for the trip and either settles or runs an entirely new transaction based on if the preauth is still available. My question is it possible to create a new transaction or settle on a n older preauth from a previous transaction within Authorize.net's or payflow's merchant control panel??? THat way day of the trip, he can go in and charge all the customers that want to pay with CC and settle his no shows. Am I barking up the right tree or is there a better way??? Thanks, Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Debugging CSS Layout
Who is the they that you're waiting for? Microsoft just dropped Mac IE, so that situation will never change. - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 13, 2006 6:49 PM Subject: Re: CF Debugging CSS Layout And nested table based layouts don't??? :) No, they don't, not like CSS. I build a css layout, and gotta start hackin' crap all over the place to make it work in a few different browsers? Then it won't show up at all in MAC IE? And it all validates? Screw that! I'll keep usin' tables or a css/table combo until they get things squared away. Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
AuthorizeNet Recurring Payments?
The CC thread reminded me of this... We've been using AuthorizeNet for many years and recently (well, in the last couple of years, anyway) they began offering a means of doing recurring payments. It looks like these payment have to be set up manually through forms on the AN web site, but I could be wrong. Does anyone know if there's some kind of API that allows you to set up recurring payments, halt them, check the success of transactions, etc.? I'd like our sales associates to be able to set up these payments themselves, but I don't want to give them administrative access to the AuthorizeNet merchant login. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229414 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: AuthorizeNet Recurring Payments?
We have some instances where we have a need for 'subscription' type payments - mostly monthly charges for web hosting for clients. Our main need, however, is for periodic payments for services. For example, someone purchases one year of advertising and the salesperson agrees to allow them to pay quarterly. The only way this is convenient for either us or the customer is to take a CC number. So then we're tasked with how/where this CC number is stored. I've instructed sales to keep CC numbers out of all computer records, as our sales applications reside on systems reachable from the net for telecommuting purposes. But I've found CC numbers in _plain_text_ within notes fields of our contact management application. - Original Message - From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 12, 2006 7:26 PM Subject: Re: AuthorizeNet Recurring Payments? I've used the Authorize.net recurring payments for about six months, and it works fine, but as of the last time I checked (a few months ago), there's no API to interact with the recurring billing system -- only the single transactions. You have to set up the subscriptions manually through their website forms. I think they do have a batch processing feature, where you can upload multiple subscriptions from a flat file, but I haven't looked into that feature personally, and I think you still have to do it through the AN website, there's no API for that. -- Josh Nathanson - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 12, 2006 5:20 PM Subject: AuthorizeNet Recurring Payments? The CC thread reminded me of this... We've been using AuthorizeNet for many years and recently (well, in the last couple of years, anyway) they began offering a means of doing recurring payments. It looks like these payment have to be set up manually through forms on the AN web site, but I could be wrong. Does anyone know if there's some kind of API that allows you to set up recurring payments, halt them, check the success of transactions, etc.? I'd like our sales associates to be able to set up these payments themselves, but I don't want to give them administrative access to the AuthorizeNet merchant login. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229419 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: AuthorizeNet Recurring Payments?
I looked through the linked AIM documentation and noticed the same thing. You need to be able to specify an interval and a duration, but there appears to be no way to do so. - Original Message - From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 12, 2006 11:29 PM Subject: Re: AuthorizeNet Recurring Payments? H...when I talked to them recently, that x_billing_recurring attribute was not being used...if you can use that, then where do you specify other data, such as whether the recurring billing is every month, every other month, or every 12 months for example? Also the starting and ending date for the subscription? Look more closely at the AIM API fields and you won't find anywhere to send that data. Simply specifying x_billing_recurring yes|no would not be enough information to actually get the subscription up and running. I think they stuck that x_billing_recurring field in there in hopes of setting up an API for recurring billing at some point, but it's not doable at the moment. I think there are issues with changing subscriptions frequently, that would be a disincentive for AuthNet to make recurring billing subscriptions accessible via an API, so they may never actually offer that capability. -- Josh Nathanson - Original Message - From: John C. Bland II [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 12, 2006 8:12 PM Subject: Re: AuthorizeNet Recurring Payments? Yes, there is. Specify x_billing_recurring (Yes|No) when you send your data and it will setup the recurring payment. Look at the AIM guide on the Auth.net site. Better yet, here's the location of the file. http://www.authorize.net/solutions/merchantsolutions/merchantservices/connectionmethods/ http://www.authorize.net/support/AIM_guide.pdf On 1/12/06, Josh Nathanson [EMAIL PROTECTED] wrote: I've used the Authorize.net recurring payments for about six months, and it works fine, but as of the last time I checked (a few months ago), there's no API to interact with the recurring billing system -- only the single transactions. You have to set up the subscriptions manually through their website forms. I think they do have a batch processing feature, where you can upload multiple subscriptions from a flat file, but I haven't looked into that feature personally, and I think you still have to do it through the AN website, there's no API for that. -- Josh Nathanson - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 12, 2006 5:20 PM Subject: AuthorizeNet Recurring Payments? The CC thread reminded me of this... We've been using AuthorizeNet for many years and recently (well, in the last couple of years, anyway) they began offering a means of doing recurring payments. It looks like these payment have to be set up manually through forms on the AN web site, but I could be wrong. Does anyone know if there's some kind of API that allows you to set up recurring payments, halt them, check the success of transactions, etc.? I'd like our sales associates to be able to set up these payments themselves, but I don't want to give them administrative access to the AuthorizeNet merchant login. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229423 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: eGovernment and Wiki's --- anyone making Wiki's with CF?
- Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, January 11, 2006 10:04 AM Subject: eGovernment and Wiki's --- anyone making Wiki's with CF? E-government researchers have suggested that collaborative Wiki software may be the best avenue for getting public information to the citizenry. ... I have little experience with wiki's...I've did have a look at wikopedia, or whatever it's called. I'm not too impressed with the idea of just any person being able to edit content. Who's would oversee such entries? That's the whole idea behind the opinion that it's the best avenue for getting public information to the citenzry. It's probably the only way the information will ever get published in many cases, especially with smaller municipalities with little or no budget for web development and information publishing. Basically the idea is that you can get something for free by letting anyone volunteer to do the work for you. Sometimes it works and sometimes it fails miserably. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: eGovernment and Wiki's --- anyone making Wiki's with CF?
That's the way most Wikis work. Like you say, if you limit access,then it's just another CMS, which means you're paying someone to maintain it. Which means it doesn't get done because there's no money to pay anyone to do it. So, by the something is better than nothing rule, you open it up to anyone or forget about having the information on the web at all. Note the phrase _public_ information in the original quote. This is information already available in some form, so anyone can enter it. Accuracy will be only as good as the level of participation, not the level of access. - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, January 11, 2006 6:10 PM Subject: RE: eGovernment and Wiki's --- anyone making Wiki's with CF? But what would concern me the most would be the quality and, especially, the reliability of the information... -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 11, 2006 5:47 PM To: CF-Talk Subject: Re: eGovernment and Wiki's --- anyone making Wiki's with CF? - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, January 11, 2006 10:04 AM Subject: eGovernment and Wiki's --- anyone making Wiki's with CF? E-government researchers have suggested that collaborative Wiki software may be the best avenue for getting public information to the citizenry. ... I have little experience with wiki's...I've did have a look at wikopedia, or whatever it's called. I'm not too impressed with the idea of just any person being able to edit content. Who's would oversee such entries? That's the whole idea behind the opinion that it's the best avenue for getting public information to the citenzry. It's probably the only way the information will ever get published in many cases, especially with smaller municipalities with little or no budget for web development and information publishing. Basically the idea is that you can get something for free by letting anyone volunteer to do the work for you. Sometimes it works and sometimes it fails miserably. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
IIf() - Mix literal with variable evaluation
I always run into this, and I've probably come across a solution, but forgotten it. In an IIf() I can easily return the value of a varible by surrounding it in quotes, or return a literal by using DE(), but how to use both? What would be the correct syntax to use in the first argument to IIf() in the following example: cfset a = loc.address IIf(Len(loc.city), DE(, ) loc.city, DE()) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228934 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Stats Program
I've had so much trouble with LiveStats 5 6 that I'd never again consider another DeepMetrix product or service. With LiveStats 5 it was constant database (proprietary) corruption, forcing me to reinstall and reimport, ad nauseam. With LiveStats 6 it just decides not to import logs for several days at a time. Whether it's unable to read the logs, or it can't communicate with the MySQL database where it keeps data, I can never tell. Once again, I end up wiping the database and reimporting logs about every two months or so. I'm going to take a look at SmarterStats. However, this little tidbit in their knowledge base has me thinking twice about how bright the developers might be. It involves running the service under a user account so that logs on network shares can be read: Click on the This account radio button and enter a domain level username and password. For the least hassle in dealing with permissions, use a domain administrator account. - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 12, 2005 2:58 PM Subject: Re: Stats Program Some of my clients use SmarterStats. I just got a look ant the fairly new v3 of the product and it looked pretty good. Resource usage is indeed very low. On my own servers I still use LiveStats. I think I have 6.5. Upgraded from 5 only when they were going to drop support for it. I was just thinking about upgrading to 8 but a) its $400 and B) that sucker is just a killer in terms of resources. The thing needs MSDE and eats quite a bit of memory and CPU cycles. Great results but its a pig. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226960 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Stats Program
How well does that work? I would think that for moderately high traffic sites with detailed logs that you'd be pushing a lot of data to their servers. Or is the data first compressed? - Original Message - From: Kristopher Pilles [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 12, 2005 1:23 PM Subject: RE: Stats Program Why not use Google Stats? It is free And runs on their servers... -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 3:21 PM To: CF-Talk Subject: Sot: Stats Program What's a good stats program (with the least performance overhead) to install on my dedicated server? I'm finally getting rid of livestats 5 :) TIA, dov ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226857 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Regex Help Needed
CF5. In the following I keep getting a bad backreference error. I thought the nested expressions in parens should give me \1 = entire matching string, then \2 = first submatch, \3 = 2nd submatch, etc. I'm taking a string containing concatenated three-character weekday abbreviations and expanding them. Example: SatSun = Sat,Sun re = '((sun)(mon)|(mon)(tue)|(tue)(wed)|(wed)(thu)|(thu)(fri)|(fri)(sat)|(sat)(sun))'; s = REReplaceNoCase(s, re, '\2,\3', 'all');// adjacent weekdays ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Regex Help Needed
Not exactly. It has to be a replace opertion in mid-string. It's doable with ReplaceList(), except that ReplaceList() has no NoCase counterpart. s = 'Hours of operation: MonFri 11a8p SatSun 11a5p'; - Original Message - From: Ben Nadel [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, December 07, 2005 11:56 AM Subject: RE: Regex Help Needed You could just do something a bit more simple: strTarget = SatSun; strResult = (Left(strTarget, 3) , Right(strTarget, 3)); ... Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com Vote for Pedro -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 07, 2005 1:46 PM To: CF-Talk Subject: Regex Help Needed CF5. In the following I keep getting a bad backreference error. I thought the nested expressions in parens should give me \1 = entire matching string, then \2 = first submatch, \3 = 2nd submatch, etc. I'm taking a string containing concatenated three-character weekday abbreviations and expanding them. Example: SatSun = Sat,Sun re = '((sun)(mon)|(mon)(tue)|(tue)(wed)|(wed)(thu)|(thu)(fri)|(fri)(sat)|(sat)(su n))'; s = REReplaceNoCase(s, re, '\2,\3', 'all');// adjacent weekdays ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [QUARRANTINE] Regex Help Needed
- Original Message - From: Ben Doom [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, December 07, 2005 1:05 PM Subject: Re: [QUARRANTINE] Regex Help Needed Well, you don't really need the outside parens, so you could just ditch those. I thought that might be the case, but the following also throws the same backreference error: re = '(sun)(mon)|(mon)(tue)|(tue)(wed)|(wed)(thu)|(thu)(fri)|(fri)(sat)|(sat)(sun)'; s = REReplaceNoCase(s, re, '\1,\2', 'all');// adjacent weekdays Ah... I think I see what the problem is. If the match is SatSun then I'd need to use \13 \14. I'm not sure I know how to deal with that. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Custom Tags Folder
You could change your cf_[tagname] style calls to CFMODULE calls, in which case you can specify a (absolute) tag path based on a CD mapping. Say you map /tags_v3/ - D:\MyApplication\v3\tags\ In the new version of the app change cf_myCustomTag attribute=... to cfmodule template=/tags_v3/myCustomTag attribute=... It would probably be fairly easy to do a global search replace to do this, then if you need to, change it back at some point. - Original Message - From: Brian Peddle [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, December 07, 2005 5:31 PM Subject: Custom Tags Folder Not sure this is possible. We have a version of an application and we are releasing an updated version. Some of the Custom Tags have been updated along with code. We plan on rolling this out a few clients at a time. Is it possible to set some type of application variable to override the customtag directory in CFADMIN? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226516 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Run another CF template without waiting for return
How can I run (call) another CF template without waiting for the return of that template? The other template resides on the same server, same directory as the caller. Can't cfinclude it or call it as cfml tag. Can I use cfhttp somehow? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225155 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
View raw HTTP/XML request?
Is there some way for a CF template to see a raw HTTP header (CF5) in a GET or POST request? I'm trying to troubleshoot an XML-RPC call and would like to see exactly what the incoming request looks like. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Moving directories via CF code
I think cfdirectory action=rename may be able to move a directory. - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 19, 2005 5:13 PM Subject: Moving directories via CF code Hi guys, Does anyone know whether it's possible to move a directory and its contents to a different place without actually physically moving it via a shell command or dragging and dropping (on Windows). Is there a CF command to do it in my script or would that be a security problem? I have a directory structure like: venues/venueID/events/eventID/image.jpg For instance I may have 3 files under the directory /venues/12/events/8/ mypic.jpg, mypic2.jpg and mypic3.jpg. It's possible an event will move to a different venue therefore it would be good if i could move the eventID directory and its contents to a new venueID directory. Any ideas or is it just plain stupid what i'm doing? Thanks, Saturday ps: i know i could have all the images one directory but it just keeps them in good order this way. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221591 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Disabling Flash Links
We run our own ad server, written in CF. Customers often send us Flash banner ads with embedded links in them. This keeps us from being able to track click-throughs like we normally do with standard image banners. Is there any way to place a Flash movie on a web page and replace or disable all embedded links, so that we can force the link to go through our click.cfm script and record the click-through? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Disabling Flash Links
To tell the truth, it's more for the advertisers' benefit than our own. They give us Flash ads with hard-coded links and then wonder why we can't track click-throughs. It would be nice to have such a requirement, and I've tried several times to get ads either with no links or else using the tracking guidelines. Often, though, we get the creative from a third party marketing service, with a long way 'round to relay those instructions back to the client, who then often has to go back to the contractor that created the Flash ad. Who usually has no idea what I'm talking about. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 10, 2005 5:46 PM Subject: RE: Disabling Flash Links We run our own ad server, written in CF. Customers often send us Flash banner ads with embedded links in them. This keeps us from being able to track click-throughs like we normally do with standard image banners. Is there any way to place a Flash movie on a web page and replace or disable all embedded links, so that we can force the link to go through our click.cfm script and record the click-through? This doesn't directly answer your question, but Flash banner ads can be written to conform with clickthrough tracking: http://www.macromedia.com/devnet/rich_media_ads/articles/flash_ad_kit.html http://www.macromedia.com/resources/richmedia/tracking/designers_guide/ http://www.macromedia.com/resources/richmedia/tracking/adserving_guide/ Perhaps you can require that Flash banners conform to these standards? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220624 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Disabling Flash Links
- Original Message - From: John Dowdell [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 10, 2005 6:22 PM Subject: Re: OT: Disabling Flash Links Jim McAtee wrote: Is there any way to place a Flash movie on a web page and replace or disable all embedded links, so that we can force the link to go through our click.cfm script and record the click-through? It might be easier to talk with the client, have them grab their button's links from parameters in the HTML you supply. (If you check the markup of banner ads then the target URL is usually either in PARAMs or as query terms to the calling URL, both of which can be accessed by the SWF.) One way to actually break clicks in any SWF is to put something atop it, but then you get into browser differences... which browsers will draw their markup instructions atop plugin content, which ones let clicks go through, and so on. Another tack to break the SWF's created functionality is to host it within your own SWF, which has something atop that. But the original creator might have broken your plan to break his plan, there's always something wacky possible with so many potential authors. Easiest might be to tell the client that this SWF they're creating for use on your site should have its URLs specified in the calling markup, rather than locked into the SWF. That might take some negotiation, though. Exactly. But the creative often isn't developed for use on only our site. It might also appear on their own web site, and often runs on other sites where they advertise. We usually get it after it's been created for all of the above. I imagine they run into the same problem of not being able to track clicks on the other advertising sites, unless those sites have found a way around the same issue. The second problem is that because of the way our ad server works, we'd have to create the ad campaign first, and _then_ give the advertiser the HTML afterwards, since the click link needs to reference a record ID that gets created when the campaign is created. Which is bass ackwards of how we usually book advertising. I usually don't know when an ad will be submitted, so we end up going roundy-round. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Query Help
I have a number of real estate properties, each associated with one or more city. If I select by specifying a city then I get a list of unique properties. But if I do a broader select, then I get duplicates of the property record when a record is assocuated with two or more cities. How do I limit the select results returned so that I get no more than one of each property record? SELECT p.propertyid, p.name, c.name AS city FROM property p INNER JOIN property_city pc ON pc.propertyid = p.propertyid property -- propertyid name city -- cityid name property_city -- propertyid cityid ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query Help
Thanks, Mathew. That works. It looks familiar... I remember doing this before, where it required the use of 'fake' aggregate functions on all other columns I needed returned by the query, as well as in the ORDER BY clause. The real query is a little more complicated. SELECT p.propertyid, MIN(p.adtype) AS adtype, MIN(p.name) AS name, MIN(p.longitude) AS longitude, MIN(p.latitude) AS latitude, MIN(p.address1) AS address1, MIN(p.address2) AS address2, MIN(p.city) AS city, MIN(p.state) AS state, MIN(p.zip) AS zip, MIN(a.areacode) AS areacode FROM properties p INNER JOIN propertyareas a ON a.propertyid = p.propertyid cfif Len(form.areacode)WHERE a.areacode = '#form.areacode#'/cfif GROUP BY p.propertyid ORDER BY MIN(a.areacode), MIN(p.name) Seems to me that there's enough 'kludge factor' in this query that I can't help thinking either it should be designed differently or that there's something I'm missing in the design of the database that would allow me to do this more easily. - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 05, 2005 4:50 PM Subject: RE: Query Help SELECT p.propertyid, p.name, min(c.name) AS city FROM property p INNER JOIN property_city pc ON pc.propertyid = p.propertyid GROUP BY p.propertyid, p.name -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, 6 September 2005 10:31 a.m. To: CF-Talk Subject: Query Help I have a number of real estate properties, each associated with one or more city. If I select by specifying a city then I get a list of unique properties. But if I do a broader select, then I get duplicates of the property record when a record is assocuated with two or more cities. How do I limit the select results returned so that I get no more than one of each property record? SELECT p.propertyid, p.name, c.name AS city FROM property p INNER JOIN property_city pc ON pc.propertyid = p.propertyid property -- propertyid name city -- cityid name property_city -- propertyid cityid ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217396 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: I love CSS :-)
Use CF to generate your CSS. - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, August 24, 2005 10:47 AM Subject: Re: OT: I love CSS :-) Welcome to 1997? Css does indeed rule, and I use it exclusively for presentation layer chrome. Makes it really easy to repurpose code for use on other sites, I have a core set of .class and #id definitions that are part of every site/corresponding CSS file that I write. I just wish that CSS files included some level of logic and variable setting capability, my color schemes tend to have 3-6 core colors and it would be much nicer to be able to set each color once as a variable and then call it whenever needed. Sure, I can do that with CF but I prefer straight CSS files because they get cached by the client. Pete ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216204 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 15 minute rule
We have one called the three times rule. A software or web site enhancement has to be requested a _minimum_ of three times before any actual work is begun. In practice it goes a little like this: The first time, you can just nod your head and not really listen. It could be a job that takes 5 minutes or 5 months, but it doesn't matter, because it's not likely to ever actually happen. The second time it's permitted to give actual thought to the request. State whether it's doable, give a vague time estimate, but don't even consider doing any real design work and God help you if you start any coding. The third time, it's ok to start the work, but giving it a high priority usually isn't wise. If a fourth or fifth request come in then consider the project to be real. Needless to say, things are fairly informal around here. The boss commonly gets a wild hair and asks for some random software or web site change. In the past I've forgotten the rule and whipped out a solution in a couple of hours, only to have it never put into production in a live web site or software system. Now, nine times out of ten, the original request is forgotten within a few days. If a second request comes in then there's still a better than even chance that it will eventually be forgotten. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, August 03, 2005 7:15 PM Subject: OT: 15 minute rule Hey All, Around Electric Edge we have something called The 15 Minute Rule. I'm not sure if this is a common sort of rule, but it sure does help keep development moving ;-) When the rule applies: You've been staring at the same error or unexpected output and you've exhausted your arsenal of coding kung fu and still can't get it sorted. Around Electric Edge we then call out I'd like to invoke the 15 Minute Rule!. At this pooint any available developers will come over so you can share your heartache over this mysterious situation you just can't solve. One of them barely glances at your code and says You spelled that var name wrong (you knowthe one you double checked 25 times becuase it was a var undefined error) and wanders back to his/her desk leaving your jaw on the floor. Although techies asking for help is often like guys asking for directions, it does solve those stupid issues but quick ;-) Anyways...just figured other teams may have similar rules?? I often use this list as my 15 minute rulehehe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213695 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Data driven local maps
We're looking for some type of mapping software that could plot locations on local street maps. Things like restaurants in a city neighborhood, or lodging properties in a ski resort. The maps could be Flash (with mouseovers giving additional location detail, like business name, address and phone#) or gif/jpg with JavaScript. The maps would be generated from data in our database that changes fairly often, but not so often that the maps would need to be generated in real-time. They could be generated when locations are added or removed from the database or perhaps once per day a new set could be rendered. They'd also need to be generated from only street addresses, since we don't have lat/long coordinates for any of the locations. Any ideas for server-based software that could accomplish this? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213426 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFCONTENT Bug?
I'm running CF5 on Win2k Server with IIS5. We're consolidating a number of web sites into a single site. I have IIS' 404 error handler for the old web sites pointing at a CF page. The CF page does some processing and redirects the browser to a page on the new site by using HTTP headers. I also want this CF template to generate a simple robots.txt file for the old web sites so that they're eventually removed from external search engines. The easiest way to do this seems to be with the CFCONTENT tag to serve up a text file. cfcontent type=text/plain file=#ExpandPath('.')#\r.txt The contents of r.txt: User-agent: * Disallow: / The above file has a CR/LF at the end of each line, so is exactly 28 characters long. I'm using wfetch to test this and I see a content-length header being set to 28 characters. But what is happening is that I'm also getting an extra CR/LF pair returned at the end of the file. Wfetch shows an error due to the extra data being returned. I'm not sure whether this will cause a problem, but it's not definitely not right. Is this a known bug? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
HomeSite+ and Perl Files
When I attempt to open a Perl file (with .pl or .pm extension) in HomeSite+ I first get a dialog box stating that the file isn't a recognized text document. After I tell HomeSite to open it any way, the color coding is correct. In the File Settings, Extension Manager I have these extensions entered and checked off as editable. What else is necessary? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211951 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 5th Most Trafficked Site Switches to BlueDragon
Neither have I. Looks like a lonely hearts club for the not-so-hip. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, June 28, 2005 9:32 AM Subject: Re: 5th Most Trafficked Site Switches to BlueDragon Wowmyspace.com must be huge.hm...no waitI've never heard of it?? ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210755 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF5 Regex Backreferences
In CF5 are backreferences ($1, $2, etc.) available for use in REReplace(), or do you have to do an REFind() and then use the array returned if returnsubexpressions is set to TRUE? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Registrar that does DNS management?
eNom includes DNS with registrations. Find an inexpensive reseller (such as namecheap.com) and they'll provide a web based DNS management interface. Enom's DNS is top notch, with servers around the US and one in the UK. C:\dig enom.com ns ; DiG 9.2.3 enom.com ns ;; global options: printcmd ;; Got answer: ;; -HEADER- opcode: QUERY, status: NOERROR, id: 41 ;; flags: qr; QUERY: 1, ANSWER: 5, AUTHORITY: 0, ADDITIONAL: 5 ;; QUESTION SECTION: ;enom.com. IN NS ;; ANSWER SECTION: enom.com. 172800 IN NS dns1.name-services.com. enom.com. 172800 IN NS dns2.name-services.com. enom.com. 172800 IN NS dns3.name-services.com. enom.com. 172800 IN NS dns4.name-services.com. enom.com. 172800 IN NS dns5.name-services.com. ;; ADDITIONAL SECTION: dns1.name-services.com. 172800 IN A 69.25.142.1 dns2.name-services.com. 172800 IN A 216.52.184.230 dns3.name-services.com. 172800 IN A 63.251.83.36 dns4.name-services.com. 172800 IN A 64.74.96.242 dns5.name-services.com. 172800 IN A 212.118.243.118 ;; Query time: 109 msec ;; SERVER: 192.168.3.3#53(192.168.3.3) ;; WHEN: Tue Jun 21 13:41:18 2005 ;; MSG SIZE rcvd: 215 - Original Message - From: Damien McKenna [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, June 21, 2005 11:16 AM Subject: RE: Registrar that does DNS management? To answer my own question, Domain Direct (Tucow's OpenSRS company) does this for $14.99 per year, or $12.99 for a transfer (inc one year). -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h -Original Message- From: Damien McKenna Sent: Tuesday, June 21, 2005 12:57 PM To: CF-Talk Subject: OT: Registrar that does DNS management? I'm looking for a registrar that supports DNS management, preferably at little or no additional cost over the domain name transfer price. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210165 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: UNC vs Mapped Drive
For file zipping/archiving I don't think you'd want to copy files to the local computer first. It shouldn't make a difference in terms of bandwidth and just adds another step to the process. We use UNC paths - much easier than dealing with drive mappings and troubleshooting whether or not they're mapped for a particular user account. - Original Message - From: Dawson, Michael [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, June 13, 2005 11:52 AM Subject: RE: UNC vs Mapped Drive I don't think there is any difference in performance, but I do know that I would keep all operations local to the same server than have them go across the network. Depending on your task, the first thing would be to copy any remote files to the local server. Or, the last thing would be to copy local files to the remote server. Again, this is to keep as much file processing on the local server rather than through network traffic. M!ke -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 11:13 AM To: CF-Talk Subject: UNC vs Mapped Drive Is there any difference in performance when accessing files on another server between these two methods? The access would be in terms of cffile and some zipping using a java based zip util. Thanks, Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
There's a much larger developer base for LAMP. I'd consider that a factor in selecting the environment - probably even in selecting the developer if a developer insists on using a particular environment. If I were the customer I'd try to do my best to get a feel for the environment that the developer is proposing. They may foresee dropping your company (or at least they should keep it in the back of their minds as a possibility) and then finding someone to continue site development or maintenance may become an issue. While there are plenty of CF shops out there, going with LAMP gives them a lot more options. - Original Message - From: Russ [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 31, 2005 11:25 AM Subject: CF vs LAMP We have a client that is trying to decide whether to go with my company or another company. We are a CF/MS SQL shop, and the other company does LAMP development (Linux, Apache, MySQL, Perl). I was wondering if anyone on this list can give some ideas of the pros and cons of using CF/MS SQL vs LAMP. I know for a fact that perl code is harder to read and maintain, and that's it's probably slower since it's interpreted every time instead of pre-compiled as CF is. I know MS SQL has more features (such as stored procs) that MySQL lacks. What other pros does CF/MySQL have over LAMP that might sway a potential client? Personally, except for the fact that LAMP is free, I don't see any advantages of it at all. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208141 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Short URL / URL redirection
It's easily done, but I'm not sure why using application.cfm is necessary. Why not do both the db lookup and server side redirect in one CF file? - Original Message - From: Robert Munn [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, May 19, 2005 5:02 PM Subject: RE: Short URL / URL redirection tinyurl is great for posting on forums and the like, but I don't think I would use it for commercial purposes. I'm not sure the way their system works, but it seems like it would be easy to make a URL-forwarding system using nothing but application.cfm and index.cfm. application.cfm would contain a lookup system that would intercept the incoming url and look it up against a database of short-to-long url conversions. index.cfm would do a server-side re-direct to the long url. simple. http://tinyurl.com/ -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: May 19, 2005 14:07 To: CF-Talk Subject: Short URL / URL redirection Hi all, I'm wanting to figure out how to take a long CF URL and convert to a short URL for use in emails, etc. Any methods, best practices, etc. I really don't know where to start. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Short URL / URL redirection
I know a LOT of people are very skeptical about clicking on tinyurls and similarly obvious redirection URLs. They can be used to shorten a URL for convenience, but can also be abused and send unsuspecting users to web pages that they'd rather not visit. This probably isn't a problem if both the target URL and the shortened version reside on your website - nobody is likely to notice the difference. But if you're sending someone to a web page by going through a redirect located at a different site, then a user may click such a link once and then never again. - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, May 19, 2005 3:06 PM Subject: Short URL / URL redirection I'm wanting to figure out how to take a long CF URL and convert to a short URL for use in emails, etc. Any methods, best practices, etc. I really don't know where to start. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Php MySQL Wiki?
Thanks, Damien. I just need something simple. Needs to support the standard group editing thing, plus the ability to upload images such as screen shots as well as attachments like spreadsheets, pdfs and other files. Did a bit more research yesterday. coWiki: In development, but looks really nice. Unfortunately no real support for running under IIS. TikiWiki: Very powerful, but as you say, overkill by a factor of about 100. DokuWiki: Recommended by some folks in the TikiWiki chat room. Next on the list to be evaluated. I don't foresee doing much if any modification of the wiki engine. The only additional requirement from an implementation standpoint will be the ability to easily modify the look. Good use of CSS is all I ask. One thing that would be nice, but I don't expect from a php based open source package: The wiki will reside on our Intranet which requires user Windows domain login. In my CF applications on the Intranet I just pull cgi.auth_user to get the logged in user name. It would be nice if we could avoid a second login within the wiki that would be used only for the purpose of identifying users. - Original Message - From: Damien McKenna [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 7:29 AM Subject: RE: Php MySQL Wiki? Do you want something extremely powerful, or do you want something a bit simpler. Some good ones include: * MediaWiki, which is used to run the huge Wikipedia site but might be too much for your needs. * Wikka Wakka Wiki (http://wikka.jsnx.com/) is fairly simple, has user permissions and can embed FreeMind charts if you want (a neat feature). * PmWiki (http://www.pmwiki.org/) is pretty simple too. I don't recommend TikiWiki at all, it is way too complex for most people to get to grips with; I was on the development team two years ago and was one of several people promoting a major rewrite of the system to simplify it, but the main developers didn't see the need to continued as they were, the result being a huge system that is overbearing. IMHO of course. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206858 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Shared CF Host security
So what exactly is the security issue? Username/password set in the datasource? Full access to the file system? - Original Message - From: James Holmes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 10:29 PM Subject: RE: Shared CF Host security This should illustrate the point regarding HMS - _everyone_ who shared-hosts there is susceptible to the same problem. http://www.robrohan.com/blog/ http://www.robrohan.com/blog/index.cfm?mode=entryentry=EDCB81D8-C8F0-B5 37-1824A53C962059D3 (watch for any wrapping in the url) -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Wednesday, 18 May 2005 10:51 To: CF-Talk Subject: Re: Shared CF Host security Try what Dave? You have an example? I'd be glad to. Rey... dave wrote: you wanna try this on your host and see what happens? ~Dave the disruptor~ From: Rey Bango [EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 10:34 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Shared CF Host security I guess I'm trying to understand how your host can be so sloppy. I don't recall ever being on a shared hosting environment that had that problem. Forget VPS, get yourself a new host. Rey.. James Holmes wrote: While security can never be perfect in a shared hosting environment, am I expecting too much to have at least a modicum of security on a shared server? For example, if others can access my datasources and do whatever they want to my database and they can read all of the source code of my apps, I get a little concerned. I know I can buy VPS hosting for genuine security, but would anyone else expect a shared host to at least attempt some security or would they be happy to just have them give up and allow open slather? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206986 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Php MySQL Wiki?
I'm looking for recommendations for a well written, easy to use wiki application. Must be written in php and use MySQL. From what I can tell the ColdFusion pickings are pretty slim in this area and most of the third-party web apps we've implemented in recent years are written in php anyway. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion WHOIS Proxy?
Has anyone done a WHOIS proxy in ColdFusion, similar to the one at GeekTools.com? http://www.geektools.com/whois.php ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205423 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion WHOIS Proxy?
Thanks, Howie. I just downloaded it and took a look at the documentation. What is the server attribute for? Ideally, I'd like a tag that will recursively figure out which registry to query, which is what GeekTools proxy does. - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 03, 2005 2:04 PM Subject: Re: ColdFusion WHOIS Proxy? We have a free cfx tag here: http://www.coolfusion.com/downloads/index.cfm?id=6 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205455 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion WHOIS Proxy?
Who do you query to get the registrar of a .com domain or other domain with more than one registrar (gTLD)? For those you generally have to first find the registrar that actually has the domain in their database, then you query that registrar. For instance, if you query Network Solutions whois server for a domain regitered through Register.com you get only a tiny bit of the actual public data. - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 03, 2005 3:23 PM Subject: Re: ColdFusion WHOIS Proxy? That refers the the server that should be queried based on the TLD (the default is rs.internic.net. There is a list of servers per TLD here: http://www.micronicos.com/whatsnew/whois-servers-list.html HTH, Howie --- On Tuesday, May 03, 2005 5:15 PM, Jim McAtee scribed: --- Thanks, Howie. I just downloaded it and took a look at the documentation. What is the server attribute for? Ideally, I'd like a tag that will recursively figure out which registry to query, which is what GeekTools proxy does. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion WHOIS Proxy?
That certainly true of of the WHOIS proxies. I'm not so sure about the registry WHOIS servers, though. If they do have limits, I'm sure we wouldn't exceed them. I think some of them just rate-limit the queries rather than having a quantity limit. The limits set by the proxies I've used are pretty low - maybe 100 or 200 queries per day. When I set up a form for a server-based WHOIS then all queries to the proxy come from the server IP address, so it's pretty easy to exceed that number of queries in a day. I think I'll probably have to cross-code a PHP or Perl script to do this. The basic single query stuff is fairly easy - it's doing the recursive lookups that I was looking to avoid by finding a canned CF tag or script. - Original Message - From: Jon Austin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 03, 2005 5:13 PM Subject: Re: ColdFusion WHOIS Proxy? One point, most servers will have a query threshold which if you exceed (by continually making whois requests), you will find yourself banned. On 5/4/05, Jim McAtee [EMAIL PROTECTED] wrote: Who do you query to get the registrar of a .com domain or other domain with more than one registrar (gTLD)? For those you generally have to first find the registrar that actually has the domain in their database, then you query that registrar. For instance, if you query Network Solutions whois server for a domain regitered through Register.com you get only a tiny bit of the actual public data. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Dealing with unworkable query column names
I'm trying to query a MySQL 3.23 database to get table names that match a naming pattern. Unfortunately, there doesn't seem to be any way to alias the column name returned, plus the name contains both a space and the percent sign used in my original SQL statement. Also, the syntax of SHOW TABLES doesn't permit column aliasing. The column name generated by the code example below ends up being TABLES_IN_LIVESTATS (SERVER%_DEMOGRAPHICS) cfquery datasource=livestats name=q SHOW TABLES like 'server%_demographics' /cfquery cfoutput Query Columns: #q.ColumnList# cfloop query=q cfset tblname = Evaluate(q. q.columnList) #tblname#br /cfloop /cfoutput The error I receive from CF is: - An error occurred while evaluating the expression: tblname = Evaluate(q. q.columnList) Error near line 23, column 9. An error has occurred while processing the expression: q.TABLES_IN_LIVESTATS (SERVER%_DEMOGRAPHICS) Invalid token found on line 1 at position 30. ColdFusion was looking at the following text: %Invalid expression element. The usual cause of this error is a misspelling in the expression text. - Is there an alternative method for addressing query columns, say, similar to using array notation when addressing the rows of a query? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dealing with unworkable query column names
- Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, May 02, 2005 1:00 PM Subject: Re: Dealing with unworkable query column names Ouch... I'm glad I don't have to deal with that schema... But you don't want to use evaluate anyway... plus, unless the table only has one column, this won't work anyway: tblname = Evaluate(q. q.columnList) -- q.columnlist is a comma delimited list of the column names, so you would be trying to say evaluate(q.first,last,middle,bloodtype) which won't work... The query does indeed only return a single column, so q.columnlist == ListFirst(q.columnlist). I was just looking for a way to reference it without spelling it out. you want to use array notation: cfoutput query=q cfloop index=colname list=#q.columnlist# #q[colname]# /cfloop /cfoutput Thanks. That worked. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFSCHEDULE ability to log in
I need to schedule a CF template that is on an IIS-served web site protected by an NTFS ACL. Login requires a Windows domain username password. The web site in question is on the same server where the CF scheduled task will run. Can CFSCHEDULE login to this site properly using the username and password tag attributes or is it a bit more involved? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205338 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Search Engine Spiders - user-agents
Does anyone know where I could find a current list of user_agent strings used by the bigger search engine spiders? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Programmatically figuring out path to CF installation dir
The path is stored in the registry. On our CF5 servers it's at HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\RootDirectory Should be just as easy to find on later versions. - Original Message - From: Andrew Hewitt [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, April 27, 2005 3:18 PM Subject: RE: Programmatically figuring out path to CF installation dir So nobody has any idea how to do this? -Original Message- From: Andrew Hewitt [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 1:30 PM To: CF-Talk Subject: Programmatically figuring out path to CF installation dir Is there a way programmatically to figure out what the full path to the ColdFusion installation directory is? I mean the actual installation directory and not cfide and docs and all that. Thanks in advance. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204853 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using CF to connect to Windows fax
Does Windows fax service offer an SMTP gateway? If not, it might be worth installing a decent third party fax server such as GFI Faxmaker (about $400) that does. With an SMTP gateway you can just use CFMail to send an HTML formatted message to the email address of the gateway. - Original Message - From: Scott Stroz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, April 27, 2005 7:04 PM Subject: Re: Using CF to connect to Windows fax On 4/27/05, JediHomer [EMAIL PROTECTED] wrote: I cant seem to see anything obvious, you might want to try dropping the .1 in both cfobject calls, letting COM decide the object version. The other thing to try is to write a COM wrapper, where you can send all the details in say one call and get the wrapper to then talk to the Fax COM object HTH I took the .1 out, but continue to get the same error. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204869 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple submitt + variable
Try this. The trick is that when you get to your action page you loop through the form fields looking for one with a name beginning with ActivateMe_. When you find it, then you peel the user id value off of the field name. I don't use fusebox, so I have no idea how consistent this is with that methodology. form action=somepage.cfm method=post ... cfloop query=q #myquery.username# input type=submit name=ActivateMe_#q.user_id# value=This One /cfloop /form In somepage.cfm: cfset theuserid = cfloop index=fieldname list=#form.fieldnames# cfset fieldvalue = Evaluate(form. fieldname) cfif Left(fieldvalue), 12) is ActivateMe_ cfset theuserid = ListLast(fieldvalue, _) cfbreak /cfif /cfloop - Original Message - From: Douglas Fentiman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, April 17, 2005 4:11 PM Subject: Multiple submitt + variable Hi all, I have a form with multiple submit buttons. Each button has a unique associated id value. I want to pass the associated id value with the submit button that is pressed. I have checked out the Multiple_Submit Tag, using input type=submit name=_fuseaction=#XFA.userApprove#, which works well with a single id value that can be passed as a hidden form field, but haven't been able to figure out a way to use it with multiple id values. Also played with appending the id value, input type=checkbox name=ActivateMe_#user_id# value=1, and using a single submit button. Then peeling the id value off in the recieving template. This works but uses a single submit button. I would like to use multiple submit buttons to make it a one click action for the user. Any Ideas on how to do this? -CFMX -FB3 -no JavaScript Thks, Doug ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203156 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Conditional CFInclude
In the following does CF include only one page on the fly, or does it bring in both pages, but execute the code in only one? cfif somecondition cfinclude template=somepage.cfm cfelse cfinclude template=someother.cfm /cfif ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202839 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Regex help
(CF5 on IIS, Win2k Server) I have a CF template set up as the IIS 404 error handler on a web site. When IIS detects a 404 error it calls the CF page and passes the original request within the CGI variable cgi.query_string in the following form: 404;http://www.mydomain.com/missingpage.htm or if the request was for a directory it might look like: 404;http://www.mydomain.com/missingdirectory/ In my template I need to extract what would have been the original cgi.path_info: /missingpage.htm or /missingdirectory/ What might a CF function look like using regexes to extract the trailing part of the URL? There will be many different host (domain) names pointed at the site, so I can't match the domain name. The function would be called by passing cgi.query_string: cfset path_info = getPathInfo(cgi.query_string) The function below is start, but it matches the entire string rather than extracting just the end part. function getPathInfo(qs) { var re = '404;http://[^/]+/*'; var stuff = REFindNoCase(re, qs, 1, 'yes'); if (stuff.pos[1]) { return Mid(qs, stuff.pos[1], stuff.len[1]); } else { return ''; } } ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question on randomizing multiple times on the same page
You can reseed the random number generator with the Randomize() function, but that may not be your problem. CFSET random_number=RandRange(1, 10) CFOUTPUT #random_number# #random_number# #random_number# /CFOUTPUT Here you set a single variable to a random value, then you output it on the page three times. The variable's value isn't going to change each time. If you made random_numer a user defined function, then it may do what you're looking for. Or create three different variables and set each one using RandRange(). - Original Message - From: Chris McCarthy [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 31, 2005 5:10 PM Subject: Question on randomizing multiple times on the same page Hi gurus, Currently I've setup a variable like so: CFSET random_number=RandRange(1, 10) Now, when I call it in output: CFOUTPUT #random_number# /CFOUTPUT It works fine and generates a random number (i.e. 5). But when I list it multiple times: CFOUTPUT #random_number# #random_number# #random_number# /CFOUTPUT It just generates the same seeded number (i.e. 5 5 5) How do I get RandRange to refresh itself each time I call it on the same page? I don't want to have to invoke a page refresh to get a new number each time. Thanks! :) -Chris ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201110 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: drop down dilemma
Would this work for you? form action=faq_list2.cfm method=post name=dropdown select name=category onchange=this.form.submit(); option value=Select/option cfoutput query=getlistoftopics option value=#categorynum#,#categoryname##categoryname# /cfoutput /select /form Usually you'd just use: option value=#categorynum##categoryname# and then look up the category name on the form's action page. But the above should work if you want to avoid doing another query to get the name. - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 30, 2005 12:45 PM Subject: drop down dilemma I have a dropdown that I want to pass to vales similar to a URL. The url passes two values: a href=faq.cfm?categoryname=#categoryname#num=#categorynum#/a How do I get the dropdown below to pass both categoryname and categorynum? I tried a hidden field: form action=faq_list2.cfm method=post name=dropdown input type=hidden name=num value=#form.categorynum# select name=category onchange=this.form.submit(); option value=Select/option cfoutput query=getlistoftopics option value=#categoryname# #categoryname#/option /cfoutput /select /form Thanks. Robert at HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 3/30/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Alternating Row Colour - Here's What Finally Worked
- Original Message - From: Les Mizzell [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 30, 2005 2:49 PM Subject: Re: Alternating Row Colour - Here's What Finally Worked This is what I finally went with (watch the wrap): !--- Default the previous day to the first returned item --- cfparam name=prevDay default=#LSDateFormat(calendar[event_date][1], 'mm/dd/')# / You could just start with a bogus date such as 1/1/1988 before you jump into your loop. cfoutput query=calendar group=theMONTH h4#LSDateFormat(calendar.event_date,' - ')#/h4 div id=eventBODY cfoutput cfif LSDateFormat(calendar[event_date][currentRow],'mm/dd/') neq prevDay) cfset prevDay = LSDateFormat(calendar[event_date][currentRow], 'mm/dd/') / There shouldn't be any need to do all that date formatting. If you have dates in your DB then you can compare them straight away. Also, no need to use array addressing if you're just addressing the current row. cfif calendar.event_date neq prevDay) cfset prevDay = calendar.event_date cfset switch = 2 - switch + 1 /cfif ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200853 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is this campsite available
This is the same scenario as a concert or sports ticketing system where you purchase reserved seats. In most of these systems they reserve the ticket as soon as you indicate you wish to buy it. If you don't complete the transaction then it becomes available once again after X minutes - usually something like 5 to 15 minutes, whatever is reasonable for completing the checkout process, but also depending on demand. For a campsite ticketing system, I doubt you'd have to worry about making the time period too long. Go to ticketmaster.com and begin the purchase of some tickets - I believe the system shows you how long you have to complete the purchase before the tickets are released. - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 29, 2005 5:32 PM Subject: Is this campsite available I'd be most grateful for a little bit of advice from this list please. I am working on a campsite booking system. The main issue of course is that unlike an item in a shop, any given campsite is only available once on any given day. Here's a likely scenario... User A indicates that he wants Campsite 1 for Day X. He is then moved through to the payment system and payments is processed and the booking is recorded in the system. Campsite 1 is now not available for Day X to anyone other than User A. That works fine. However, along comes User B who also picks Campsite 1 for Day X before User A's payment is processed. We could deal with this by placing a reserved flag on Campsite 1 as soon as User A indicates he wants it which precludes User B from selecting it. If User A's payment is rejected then we unreserve Campsite 1. However, what happens if User A does not actually complete the transaction (as opposed to it being rejected) We now have a campsite sitting there with a reserved lock on it but no booking. Any clues on strategy greatly appreciated ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Read a scheduled task's settings?
CF5/IIS5 Is there an easy way to read the current settings of a scheduled task? I have a scheduled task that I suspend and unsuspend by changing its start date to a date in the future or in the past. But I have no way of telling what its current state is. cfregistry? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is BlueDragon.NET the greatest thing since sliced bread?
Is blatant advertising permitted on this list? (hint: you know the answer) - Original Message - From: Vince Bonfanti [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 28, 2005 1:36 PM Subject: Is BlueDragon.NET the greatest thing since sliced bread? That's the question raised in my new blog (hint: the answer is no): http://blog.newatlanta.com/index.cfm Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Alternating Row Colour - Sorta
Here's one way. cfset olddate = 1/1/1950 cfset bgcolor = 0 cfloop query=myquery cfif myquery.eventdate neq olddate cfset olddate = myquery.eventdate cfset bgcolor = 1 - bgcolor /cfif tr style=background-color:#IIf(bgcolor, DE('white'), DE('gray'))# td.../td td.../td /tr /cfloop - Original Message - From: Les Mizzell [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 28, 2005 2:44 PM Subject: Alternating Row Colour - Sorta Here's the page in question: http://www.stpaulscolumbia.com/calendar.cfm Client is asking for alternating colors for DAYS - not rows. At first, I figured, OK, Odd Dates one colour, Even Dates another. Nope, don't work because there may be something on the 5th and 7th, both odd dates - but not the 6th ... and then you'd get two groups of events - those on the 5th and 7th, the same colour. I'm looking at various convoluted ideas for this, but bet the list can comeup with something a little more compact than I... Ideas? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Whitespace Woes
CF5/IIS5 I have a CFML tag constructed to produce as little white space as possible - or so I thought. Basically, as shown bellow. Much more complex, including many queries, but the key is that only one cfoutput block gets executed between the cfsetting tags. The whole tag should produce only about 50 characters of output. cfsetting enablecfoutputonly=yes cfinclude template=constants.cfm cfscript /cfscript cfif somecondition cfscript ... /cfscript cfoutputa href=../a/cfoutput cfelse cfscript ... /cfscript cfoutputa href=../a/cfoutput /cfif cfsetting enablecfoutputonly=no But the tag is producing a _lot_ of white space, both before and after the executed cfoutput block, and I cannot figure out where it's coming from. Everything within the cfinclude'd template shown above is itself contained within a cfsilent block, as it only sets some variables. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Whitespace Woes
Application.cfm is entirely within a cfsilent block as well. - Original Message - From: Gaulin, Mark [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 22, 2005 2:16 PM Subject: RE: Whitespace Woes The standard answer for this question is Did you check any application.cfm files? -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 4:10 PM To: CF-Talk Subject: Whitespace Woes CF5/IIS5 I have a CFML tag constructed to produce as little white space as possible - or so I thought. Basically, as shown bellow. Much more complex, including many queries, but the key is that only one cfoutput block gets executed between the cfsetting tags. The whole tag should produce only about 50 characters of output. cfsetting enablecfoutputonly=yes cfinclude template=constants.cfm . cfscript . /cfscript cfif somecondition cfscript ... /cfscript cfoutputa href=../a/cfoutput cfelse cfscript ... /cfscript cfoutputa href=../a/cfoutput /cfif . cfsetting enablecfoutputonly=no But the tag is producing a _lot_ of white space, both before and after the executed cfoutput block, and I cannot figure out where it's coming from. Everything within the cfinclude'd template shown above is itself contained within a cfsilent block, as it only sets some variables. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Whitespace Woes
I think that's it. Thanks Barney. - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 22, 2005 2:18 PM Subject: Re: Whitespace Woes CFOUTPUT carries across includes and tags for enableCFOUTPUTonly processing. So if the tag is called within a CFOUTPUT block, your CFSETTING tag will have no effect. Since that info is outside the scope of what the tag can possibly know, you're better off skipping CFSETTING and only using CFSILENT inside custom tags. It might be overkill sometimes, but it's always guarenteed to work. cheers, barneyb On Tue, 22 Mar 2005 14:09:54 -0700, Jim McAtee [EMAIL PROTECTED] wrote: CF5/IIS5 I have a CFML tag constructed to produce as little white space as possible - or so I thought. Basically, as shown bellow. Much more complex, including many queries, but the key is that only one cfoutput block gets executed between the cfsetting tags. The whole tag should produce only about 50 characters of output. cfsetting enablecfoutputonly=yes cfinclude template=constants.cfm cfscript /cfscript cfif somecondition cfscript ... /cfscript cfoutputa href=../a/cfoutput cfelse cfscript ... /cfscript cfoutputa href=../a/cfoutput /cfif cfsetting enablecfoutputonly=no But the tag is producing a _lot_ of white space, both before and after the executed cfoutput block, and I cannot figure out where it's coming from. Everything within the cfinclude'd template shown above is itself contained within a cfsilent block, as it only sets some variables. Donations Support: http://www.houseoffusion.com/tiny.cfm/54 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199705 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Whitespace Woes
What I've decided to do is build the output of the tag within a string and use: cfsilent !--- tag body: build tag ouput string) --- /cfsilentcfoutput#tagout#/cfoutput But the old tag had a conditional where it would call another tag cfif something cfoutputcf_anothertag attr1=... attr2=.../cfoutput /cfif Can I capture the output of that called tag and place it into the tagout string variable? - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 22, 2005 2:25 PM Subject: Re: Whitespace Woes I think that's it. Thanks Barney. - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 22, 2005 2:18 PM Subject: Re: Whitespace Woes CFOUTPUT carries across includes and tags for enableCFOUTPUTonly processing. So if the tag is called within a CFOUTPUT block, your CFSETTING tag will have no effect. Since that info is outside the scope of what the tag can possibly know, you're better off skipping CFSETTING and only using CFSILENT inside custom tags. It might be overkill sometimes, but it's always guarenteed to work. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199709 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Editing HomeSite language schemes
How do you modify the language schemes used by the HomeSite editor for color coding? I'm using an older version of HomeSite+, v5.2, and lately find myself doing a bit of scripting in VBScript. There are some problems with the scheme for this file type that I'd like to fix - the way it treats backslashes and some unrecognized keywords, for instance. Is there any way I can do this? Looking at the .scc files, which I believe are the language definitions they're in binary, so not directly modifiable. Are newer, more up to date scheme files available to download for HomeSite? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199648 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Phone dialer via TAPI?
I'd like to implement a phone dialer from within a CF application. FWIW, our office phone system is a Panasonic KX-TD1232. Let's say I had a TAPI application running on each user's computer that is capable of dialing a number from that user's phone extension. Can a web application communicate with a TAPI compliant application? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199401 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL licensing question
Another thing to consider: I don't know whether this applies to your situation at all, but if you resell services on the server, then you must use service provider licensing (SPLA). An example would be offering MS SQL to web hosting customers in a shared environment. Another would be operating as an ASP where you're reselling applications using MS SQL. http://www.microsoft.com/serviceproviders/licensing/default.mspx SPLA licensing is paid for on a monthly basis, like a subscription, and isn't available as a one-time license fee. You'd also need to license the underlying Windows OS in the same manner. - Original Message - From: Scott Mulholland [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 17, 2005 3:55 PM Subject: RE: SQL licensing question Thanks Dave, I'll pass that along. Ironically they were told the opposite by whoever answered the phone at MS ;) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 5:55 PM To: CF-Talk Subject: RE: SQL licensing question What is the general practice in terms of licensing SQL server for use in a web app? Per-processor licensing. Is it the standard or the only option to go with the processor license, or can you use an existing X client seat license and CF is considered 1 seat or user of the X' available? Each end-user is considered one seat. Read about multiplex licensing at the URL below. CF falls into this category. Is there any performance difference in the SQL Server itself if its licensed for processor or per client seat? No. All this, and much more, is available here: http://www.microsoft.com/sql/howtobuy/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Get Disk Space from CF?
Does anyone know how I can retrieve the amount of disk space remaining in a disk volume on the server on which CF is running? CF5, IIS5, Windows 2000 Server Standard. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get Disk Space from CF?
Thanks everyone. Should have thought to look at cflib.org in the first place. - Original Message - From: Jon Austin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 17, 2005 6:26 PM Subject: Re: Get Disk Space from CF? Hmmm, brain is firing on all neurons today. http://cflib.org/udf.cfm?ID=105 On Fri, 18 Mar 2005 11:26:04 +1000, Jon Austin [EMAIL PROTECTED] wrote: Here is a tidy little UDF for you. On Thu, 17 Mar 2005 18:05:25 -0700, Jim McAtee [EMAIL PROTECTED] wrote: Does anyone know how I can retrieve the amount of disk space remaining in a disk volume on the server on which CF is running? CF5, IIS5, Windows 2000 Server Standard. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Asynchronous logging
Many of the pages on our sites require up to 30 sql select queries to generate the various bits and pieces, including the queries done by our in-house ad server. We do internal page view logging of data such as date, site section, and page, plus the logging of ad impressions. Most of these write queries are updates rather than inserts and all of them are much faster than some of the more complex selects we do. That handful of writes per page are anything but a bottleneck. - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 16, 2005 2:04 PM Subject: Asynchronous logging A thought just came to me. Many people use CF for logging and the logging 'takes up' time on a page, slowing it down. Why bother? Most logging is just posting information to a DB and returns nothing to the page. Here's my solution to logging being a bottleneck: Asynchronous logging. When you want to log a page, you just call an asynchronous gateway on CF 7 and pass it all the info you want to log. If it fails, it fails. If it succeeds then it has all the info it needs to go through. No real 'hit' to the page being called other than the calling of the gateway. The page does not wait for a result, it does not care if the logging table times out or fails, it just goes on. What do you think? Any flaws in my logic? Will an asynchronous gateway used for logging be a different form of bottleneck? Too much overhead (as its another page being run)? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: E-commerce - Make them register or don't make them register
For a small site without the potential for a lot of repeat sales, I say you don't make them register. For someone like an Amazon there's a lot of advantage to _Amazon_ if the user registers - it makes repeat shopping easier. For the small e-commerce site, what real advantage is there to the seller if the user registers? The only thing I can think of would be where you offer tools like order status tracking, wishlists, etc. Most simple e-commerce apps don't offer these capabilities. - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 14, 2005 1:45 PM Subject: E-commerce - Make them register or don't make them register Ok guys, I just read in my Internet Retailer about how teen shoppers do NOT want to register before shopping online. This plays right into my plan on the Volleyball site as teen shoppers *are* my target audience. My client and myself did not want to force them to register. Some argue that they have to enter all that info anyway when actually making the purchase so what's the big deal? Also, that registration info comes in handy in many different ways. What's everyone's opinion on the matter? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198748 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL masking and application.cfc
- Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 14, 2005 10:17 AM Subject: URL masking and application.cfc I've been thinking of a new method of presenting dynamic content, specifically the list archives. At the moment you get to a single post by passing an ID on the url. Even if this is 'hidden' using SES Urls or the like, your still passing something. My idea is to use the application.cfc to 'catch' a specific type of 404 error and in place of an error, run a page. Take for example this url: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:38946 In its place I want to use this url: http://www.houseoffusion.com/cf_lists/messages_4_38946.cfm When the onRequestStart or onRequest action is run, I'd like to change the page requested from messages_4_38946.cfm to messages.cfm and turn the rest of the url into the proper variables. Looks totally do-able and I'll be playing with it tonight. The reason I'm mentioning it is to see if anyone else has done this already, anyone finds this interesting and wants to try it and anyone wants to comment on it. I think it's a nice usage of application.cfc, but if others find it to be flawed, I'd like to hear it early on. Will application.cfc be executed whenever CF fails to find the messages_4_38946.cfm page? Unless you're using a shared server you can accomplish this by specifying a missing template handler in CF Administrator and doing the work in that CF page. I've done this recently for some web sites whose URL structure was changed - we pick up the error in the missing template handler, rewrite the URL and do a redirect. There is some advantage to doing this in CF - you can run queries, for instance, if necessary for rewriting the URL. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198761 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Parsing XML in CF5
I have a task where I'll need to parse incoming XML (SOAP) documents in CF5. I'll probably want to create structs containing the data to then be placed into database tables. What tools do I have at my disposal in CF5 running on Windows 2000 Server Standard and IIS5? If nothing is available natively, what third party tools, CFX tags, etc. are available? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf-community and something pretty damn funny!
Wow. That gets my vote for weakest security argument of 2005. That said, if the entire HoF membership list, passwords and all, were compromised, it isn't very likely anyone would notice. What's the worst someone could do with your login - subscribe you to cf-community? The thing that really makes this ugly is that you have many people dumb enough to re-use passwords at sites like HoF that they've used other places where security is a lot more critical. A few years back we kept unhashed passwords in our database and I found that I could take about 1/3 of them and log in to things like Yahoo! mail and even PayPal. You might think software developers and the other folks on this list would be smart enough not to do this, but people are basically lazy. I've seen system and network administrators who use the same password for every root and admin account they have. It's sobering. - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 03, 2005 4:24 PM Subject: RE: cf-community and something pretty damn funny! I don't let anyone other than myself have access to the machine and am rather paranoid about security. Don't share subscriber lists, etc. So no, the passwords are not hashed. As for encrypted, I do have the decrypt keys. :) From: Michael Dinowitz [mailto:[EMAIL PROTECTED] I logged in with your username/password and went to the CF-Community subscribe page and signed you up. No problems. What problem were you having subscribing? No hashed passwords? Not even encrypted? :-() ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Homesite 5.5 vs. Dual Monitors
Is there any way to get HomeSite to permit the running of two instances of the program at the same time? What if you installed it into two different directories? - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 01, 2005 2:31 PM Subject: Homesite 5.5 vs. Dual Monitors I have dual 19's and I REALLY want to be able to view to different files at the same time, one on each monitor, in Homesite. Homesite will not let me have more than one window open at a time. Does DW support multi windows? I know eclipse does, but I can't get passed the over complicated snipit keys. I may have to try DW again. Argh... Anyone? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197017 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to set virtual sites for localhost viewing?
Go to the configuration in IIS for the default website and remove any identies that have blank host header names. This way, no web site will be displayed by IIS for a bare IP address or for host names that you've pointed at the IP address without having yet set up a virtual web site. You'll get something like a No web site is configured at this address message returned in your browser. Also consider creating the virtual web site as soon as you do the DNS, then put up a blank index page or an under construction page. If you have both development and production servers and this is a brand new site, then do this on the production server. That way you don't have to migrate from the dev server IP to the new IP in the future. - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 28, 2005 2:54 PM Subject: RE: How to set virtual sites for localhost viewing? One thing I noticed about the DNS handling is that without a host header to handle www.ShellmanBluffOutfitters.com, it defaults to my default website, which is just a placeholder for an old site. I went into the DNS and took out the www A Record and when that didn't cause www.ShellmanBluffOutfitters.com to display a can't be found error, I went into the CName's and took out the www there, too. It may be too early, time-wise, for the changes to have taken effect, but what I want is for a site to show a can't be found error until I have the site ready to go live. I don't want it to go to my default site; that could confuse someone who might be trying to see the SBO site. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196881 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: mySQL to PostGreSQL on Windows (was Pro/Con Moving from MSSQL to MySQL)
- Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, February 24, 2005 12:39 PM Subject: Re: mySQL to PostGreSQL on Windows (was Pro/Con Moving from MSSQL to MySQL) Matt Robertson wrote: A week or so ago I peeked at the PostGreSQL web site and looked over their Windows port. All of the Experimental and total rewrite and not fully tested messages convinced me to keep waiting, as my needs are for full production. The PostgreSQL hackers do not consider PostgreSQL experimental, they consider Windows experimental. Wow. There's a real confidence builder. I think I'll cross it off the list as well then. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Sloppy - Yahoo! Slurp throwing CFerrors
It strikes me that you shouldn't be allowing those munged or extraneous URL variable values to cause CF to throw errors. For example, I'd never use something like the following cfparam name=url.detailedview default=no type=boolean Instead, I'd use cfparam name=url.showdetails default=no cfif not IsBoolean(url.showdetails) cfset url.showdetails = no /cfif You might accomplish something similar by wrapping the first in a cftry/cfcatch, but this is so much simpler, why bother? If passing a numeric value directly from the url scope into a query, do something like cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#Val(url.view)# Your query may come up empty, but at least you're not throwing errors because someone (or something, in your case) decided to get creative with the URL. - Original Message - From: Mark W. Breneman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 21, 2005 10:21 AM Subject: Sloppy - Yahoo! Slurp throwing CFerrors Does anyone else see CFerrors from Yahoo's spider / bot Slurp? We monitor all CFerrors that are generated on our servers. It seems that Yahoo! Slurp is responsible for over 60% of the errors per week that are thrown by our production webservers. It looks like Slurp is appending almost random values to the query strings. id=5%E2%84%91=2 or it may append an old URL var that has not been used for years like view=archive. (This one throws a CF_SQL_NUMERIC error now.) Does anyone know of a way I can get Slurp to stop hitting these pages with invalid URL vars? And still keep Slurp indexing the site normaly? FYI I have a custom cf error page. After thinking about this for a little while I can see where my custom cf error page may not look like an error page to Slurp. Any idea of what I can do to make Slurp understand it is an error? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196142 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to set virtual sites for localhost viewing?
We do this all the time by setting up host names in DNS under our own domain name. For example nicksbakery.ourdomain.com bobstire.ourdomain.com If you know how to set up the virtual web sites in IIS using host headers, then what you may be missing is the need to configure the DNS. We manage our own DNS, so it's pretty simple. If you don't have direct access to the DNS for your domain this could be more trouble than its worth to have your ISP do it for you. But your could have whoever does your domain's DNS delegate a zone to a DNS server that you could run on your development server exclusively for these development host names. Have them delegate a sub-zone to your DNS server. For instance dev.ourdomain.com Then you can manage the dev.ourdomain.com zone and create host names below that: nicksbakery.dev.ourdomain.com bobstire.dev.ourdomain.com Alternately, you could register a domain name just for development purposes and run the DNS on your development server. - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 23, 2005 11:05 AM Subject: RE: How to set virtual sites for localhost viewing? Anyone else have any thoughts on what Calvin suggested below as far as setting up a development site for online client viewing of a site in progress? I can't figure out what I'm missing in the setupprobably something Calvin figured I knew...but apparently don't... Rick Hi, Calvin... I decided to try your approach with dev.myclient.com as a staging site for clients, but when I put the host header in with a current site, it's not showing... For example: Current Online Site: www.online.net Also has as host header: online.net Added host header: dev.online.net But if I go to http://dev.online.net, it's not coming up. I'm missing something somewhere...what could it be? Rick -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 6:54 AM To: CF-Talk Subject: RE: How to set virtual sites for localhost viewing? How about this: Your site: www.defaultwebsite.com Client site: www.myclient.com Client development site: dev.myclient.com Setup your development sites to have hostheaders for the dev.myclient.com site. This would more closely mirror their site in production. - Calvin -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 8:29 PM To: CF-Talk Subject: RE: How to set virtual sites for localhost viewing? it's good to have your development environment mirror your production one as much as possible. For sure...that's what I've done in the past and trying to setup this time. It just takes some time to figure out the settings and procedures when things are setup differently... In production, presumably, that client's content will have its own virtual server Yes, that's what I've done in the past...the idea of using a virtual directory was for an intermediate step between initial (for my eyes only) development and deployment of the finished site to the public. For the client to be able to access the site on the Internet, without using host headers for a virtual site (server), the website would have to be setup in a virtual directory under the default website so it could be accessed by domain name of the default website, e.g. http://www.DefaultWebsite.com/website/index.cfm, or by IP, e.g. http://66.xx.xx.xxx/website/index.cfm, right? That seems to be the only two ways I can get a site to show up without using the host headers and for those ways to work, I had to setup a virtual directory for the site and wait to setup a virtual site when I was ready to use the domain name with Host Headers... Am I understanding things or am I missing something? Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 5:33 PM To: CF-Talk Subject: RE: How to set virtual sites for localhost viewing? The reason I don't go to a virtual server (site in IIS) at first is to avoid having to use Host Headers and expose the site to the public via the domain name before it's complete. Usually, I would just tell a client to go http://66.xx.xx.79/cfdocs/yoursite/index.cfm to view their site. Looks like that'll just change to telling to go to http://www.DefaultWebsite.com/yoursite/index.cfm, which will work the same, promote my website (when I finally build it!) and be easier for the client to remember. Does this sound like it will work well? You don't have to expose anything to anyone you don't want to, whether you use virtual servers or not. I guess my whole point here is just to mention that it's good to have your development environment mirror your production one as much as possible. In production, presumably, that client's
Re: How to set virtual sites for localhost viewing?
There can be a big difference between using a dedicated site and trying to accomplish the same thing by simulating a site within a subdirectory. For instance, you can't easily use references like img src=/images/abc.gif. I doubt you'll be managing DNS constantly, but it depends on how often you accept new client projects. If you have a client for whom you regularly work on their web site then you could always leave the virtual site client.ourdomain.com configured in DNS. The other thing you might do is create a fixed number of 'generic' development virtual web sites. test01.ourdomain.com test02.ourdomain.com test20.ourdomain.com Create and leave the host names in DNS. One time and then forget about it. Set up the virtual sites within IIS and then stop/start them as needed. You'll probably want to implement a login system to view these sites while under development, even if they're intended to be publicly available sites. - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 23, 2005 12:03 PM Subject: RE: How to set virtual sites for localhost viewing? I manage my DNS through GoDaddy.com, where I register my sites. Haven't ventured into the land of managing my own DNS. After looking into this at GoDaddy, it seems simpler, just to use a virtual directory under my DefaultWebsite for online development viewing, sending my client to http://www.DefaultWebsite.com/ClientSite, then, once the site is ready to go live, make a virtual site for it... http://www.ClientSite.com Is that not easier than manipulating DNS constantly? (It probably seems easier because I understand it! ;o) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196164 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (Admin) New feature question
- Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, February 20, 2005 11:09 AM Subject: (Admin) New feature question I'm adding in a new feature and wanted to hear what people thought about it and what should be added/altered. Basically, any subscriber to House of Fusion/Fusion Authority (not just to a specific list) What exactly does it mean to be a subscriber to houseoffusion.com beyond being signed up for this or other of your mailing lists? can enter personal keywords in association to a piece of data. This means that if you like the FA article on CF 7 little notes (http://www.fusionauthority.com/Article.cfm/ArticleID:4399), then you can add a keyword to it like CF 7, CF 7 gotcha's, freitag or whatever else you want. If you like a thread on RegEx in CF-Talk or the RegEx list, you can label it as RegEx or the like. I'm definitely missing something here. Isn't there a difference between an article and an archived list thread? One question I have concerns threads vs. messages. Would you prefer to label an entire thread or a specific message (or both)? What do you think is missing here? Let me know what you think. You don't say what anyone would do with these labels... I seldom visit House of Fusion and have never been to the other site. I've tried hof to search the list archive, but the site is usually so slow as to be unusable. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195679 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick IIS 6 Question with regards to SSI...
If the page on which the SSI directive is included has an extension of ..html then that extension would have to be mapped to the SSI engine ssinc.dll. Look under Application settings. You'll probably see .stm and a couple other extensions mapped to this dll. If I'm not mistaken, the extension of the included file is incidental. http://www.microsoft.com/resources/documentation/iis/6/all/proddocs/en-us/pub_svrsideincludes.mspx - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, February 18, 2005 3:50 PM Subject: Quick IIS 6 Question with regards to SSI... Setup: Win 2003 Server w/ IIS6. Default install. I need to use server side includes on a simple HTML web site (all pages are HTML). I use !--#include file=inc_header.shtml-- to call the page, yet nothing is displayed. I've changed the file extension many times. Each time it still did not parse/load the include. The only IIS6 'Web Service Extensions' that are allowed are: Server Side Includes and Macromedia Server Extensions. What do I need to do? Thanks in advance. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Alternatives to Windows SMTP service
If your needs are that simple (for instance, you don't do a lot of mass mailings) then why can't you use the Windows SMTP server? - Original Message - From: Eric Creese [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 16, 2005 11:41 AM Subject: RE: Alternatives to Windows SMTP service Not sure if I mentioned or not but I do not offer email service to my clients they usually get that from their ISP. I simply build sites and host them for them. And in my sites I have some very basic features that send emails from my server from the app but the apps are not email applications like outlook or something like that. They ar esimple communication pieces. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple Banner Ad System
I recently wrote a banner ad server that serves up to four, sometimes five ads per page. I can't really say how well it will scale when our page views approach a million per day, but I don't think there's much of a performance hit for recording impressions. I keep daily performance records for ad/creative/date. When I record the impression I do a two-query process of check if record exists, if not, do an insert, else do an update. But the key is that I don't check the number of impressions every time I pull an ad. I have a scheduled CF template that runs once every two hours and checks to see if ads have run their course, either having exceeded their number of impressions or their end date, then marks them inactive. Running an ad for just a couple extra hundred, or even a couple thousand impressions is the only compromise and the advertiser seldom minds. - Original Message - From: Katz, Dov B (IT) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 15, 2005 6:19 AM Subject: RE: Simple Banner Ad System Word of warning here. I have been using fuseads for 4 years on www.onlysimchas.com -- DB inserts/updates to record banner impressions *does not scale* Updating a DB on every page view, *especially* when you're constantly reading from the same data to display things will eventually lead to a degradation of site performance which could become overwhelming. Fuseads gets around this with their high performance mode (I don't think they sell this product any more).. The High performance mode inserts banner views/impressions into a separate table, and aggregates the count back into the main banner table every night. This keeps the read/write conflicts to a minimum. Inserts every page view, however are pretty ugly as well. Might be good for small sites, but as my site grew to get 700k page views a day (Each with multiple banners on the page) it totally hosed me out. Here are some of the fixes/extremes I went to to avoid banner serving impacting performance: 1) Cache the banner query for 4-6 hours at a time 2) Store struct in app scope of banners and counts, increment that on every view, and CFLOG to the datbase every 1000 views 3) I wrote a log parser I run once weekly to update views in the DB This reduced my # if DB inserts per day from 3-5 million to 0 :) Just some of my scars, thought I'd share -dov -Original Message- From: Jason Bartholme [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 6:58 AM To: CF-Talk Subject: Re: Simple Banner Ad System Hi Dwayne, Give this tut a look: http://www.tacktech.com/display.cfm?ttid=97 We run about 7 different ad managers that I based off of this code. I'm looking for a banner ad system to intergrate into a CMS that I've built. From a administratative perspective, I don't mind using a seperate admin panel. However, on the front end I would like to call the ads via a custom tag, cffunctioin, or a cf component. Tracking click throughs is a plus, but not necessary, Multiple banners for each sponsor is a plus but not neccessary, Assigning some sort of random frequency weight or priority is a plus but not a requirements and managing campaign duration is a plus but not a requirement. I recall seeing this type of request pass through the list but unfortuanately I did not save the thread. Dwayne D. Cole www.fluxflow.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFLOCATION page execution
I'd just to verify that I understand how CFLOCATION works (after using the tag for six+ years :). The help says: Stops page execution and opens a ColdFusion page or HTML file. This means that when a CFLOCATION tag is encountered by CF that CF returns the necessary HTTP headers to the web server and then request is immediately aborted. No further code is executed for the request, correct? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194610 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFQUERYPARAM data checking
When a cfqueryparam tag is executed, does CF do any type of bounds checking on numeric values? (CF 5) For instance, if I'm inserting a longint into a table, with the following code would CF throw an error if the value of the id were greater than some integer value? cfqueryparam cfsqltype=cf_sql_integer value=#id# Would the following behave any differently? cfqueryparam cfsqltype=cf_sql_bigint value=#id# ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFQUERYPARAM data checking
Then what's the reason behind all the possible values (data types) for the cfsqltype attribute? - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 14, 2005 5:04 PM Subject: Re: CFQUERYPARAM data checking I'm pretty sure it just does type checking, not bound checking. The exception would be the maxlength attribute for string lengths. cheers, barneyb On Mon, 14 Feb 2005 16:57:17 -0700, Jim McAtee [EMAIL PROTECTED] wrote: When a cfqueryparam tag is executed, does CF do any type of bounds checking on numeric values? (CF 5) For instance, if I'm inserting a longint into a table, with the following code would CF throw an error if the value of the id were greater than some integer value? cfqueryparam cfsqltype=cf_sql_integer value=#id# Would the following behave any differently? cfqueryparam cfsqltype=cf_sql_bigint value=#id# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194632 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFQUERYPARAM data checking
So is it any better to use bigint rather than integer for a data whose value might be a long integer? Are the actual definitions of smallint, integer, bigint, etc. fixed (no indication of this in the CF5 help) or are they dependant upon the DBMS driver? What about for ODBC datasources - does CF differentiate between the different drivers, or does it treat all of them the same? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 14, 2005 5:44 PM Subject: Re: CFQUERYPARAM data checking Jim McAtee wrote: When a cfqueryparam tag is executed, does CF do any type of bounds checking on numeric values? (CF 5) It tries to cast it to a certain type in the driver and throws an error if that fails. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Moving from CF 5 to MX6 or MX7
- Original Message - From: Robert Munn [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, February 11, 2005 1:53 PM Subject: Re: Moving from CF 5 to MX6 or MX7 I had one developer who was fond of using a variable called url. That worked in CF5 but in MX it is reserved for the url scope. There are all kinds of little things like that you will find when you start digging into your app. How much pain you experience depends on how your code is written. In my example above, that was a poorly named variable and should have never been in our code-base to begin with. What constitutes a poorly named variable? Do you mean that the variable name didn't fit its use, or that the developer should have foreseen the name conflict in a future version of the language? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Firewall question
- Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 09, 2005 12:52 PM Subject: RE: Firewall question I think the most secure arrangement is to: 1. Replace router with hardware Firewall Solution (adding VPN at same time ::-)) You might not necessarily be able to replace your router. Depends a bit on the actual connection. For instance if you currently had a T1 and a Cisco router with a T1 CSU/DSU module then you'll still need the router to make T1 connection. Similarly, with DSL, you need a router capable of making the DSL connection. That said, there _are_ combo boxes that can terminate the connection, and act as router, firewall and VPN endpoint. 2. Go from Firewall solution to NTServer running Firewall software If your server is truly behind the firewall on an internal network, you can dispense with running firewall software on the server itself. There probably aren't many shops running firewall software on things like file and print servers on their LAN. Only if the server is Internet-facing might you need to worry about this. But while defense in depth is a good philosophy, it can sometimes be a PITA to manage. For instance if you add a new service on some odd IP port then you need to open a hole through both your outer firewall and any software firewall on the server itself. Personally, if I thought I had a reliable hardware firewall between my Internet-facing servers _and_ I trusted my ability to administer the firewall then I wouldn't run a software firewall on any of those servers. 3. Go from NTServer to rest of internal network. I'm not sure why you'd need to do this unless you need to use the server as a router. You probably should explain the nature of your connection and network a little better. Is it purely a web hosting network? Or a company LAN - with or without Internet-facing servers such as web and email servers? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Firewall question
No, I wouldn't route through the Windows server. The only times I'd consider using Windows as a router would be on a network where for some reason it's your only routing option, or if you wanted to run Microsoft's ISA Server as your firewall. I've never used it, but ISA can do some things that most firewalls cannot by integrating security with your NT domain. But this would be in the context of an office network with users behind the firewall, not a web hosting network. http://www.microsoft.com/ISAServer/ You still haven't mentioned the nature of the network - perhaps it's just a theoretical question, but if the NT server is a web or email server and the network also has users and/or private servers, then you'll want to isolate the NT server in a DMZ. -- DMZ: Web email servers / Internet -- router/firewall -- \ -- PRIVATE: LAN users and servers - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 09, 2005 4:19 PM Subject: RE: Firewall question Jim, What I am try to figure out is what exactly is the safest configuration. What seems to be the last remaining question is whether I want to route all internet traffic through my single server or whether I should not. Config 1 Firewall ---NT Server -- Hub Config 2 Firewall ---Hub --NT Server What do folks out there think? -Original Message- From: Jim McAteeon I think the most secure arrangement is to: 1. Replace router with hardware Firewall Solution (adding VPN at same time ::-)) You might not necessarily be able to replace your router. Depends a bit on the actual connection. For instance if you currently had a T1 and a Cisco router with a T1 CSU/DSU module then you'll still need the router to make T1 connection. Similarly, with DSL, you need a router capable of making the DSL connection. That said, there _are_ combo boxes that can terminate the connection, and act as router, firewall and VPN endpoint. 2. Go from Firewall solution to NTServer running Firewall software If your server is truly behind the firewall on an internal network, you can dispense with running firewall software on the server itself. There probably aren't many shops running firewall software on things like file and print servers on their LAN. Only if the server is Internet-facing might you need to worry about this. But while defense in depth is a good philosophy, it can sometimes be a PITA to manage. For instance if you add a new service on some odd IP port then you need to open a hole through both your outer firewall and any software firewall on the server itself. Personally, if I thought I had a reliable hardware firewall between my Internet-facing servers _and_ I trusted my ability to administer the firewall then I wouldn't run a software firewall on any of those servers. 3. Go from NTServer to rest of internal network. I'm not sure why you'd need to do this unless you need to use the server as a router. You probably should explain the nature of your connection and network a little better. Is it purely a web hosting network? Or a company LAN - with or without Internet-facing servers such as web and email servers? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193997 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Firewall question
ZyWALLs here as well. I have a ZyWALL 2 on my home network and keep a VPN nailed up into our office LAN where we have a ZyWALL 10II for about a dozen users. Then we have a ZyWALL 35 in front of our web and email servers in colocation. - Original Message - From: Duane Boudreau [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 09, 2005 5:16 PM Subject: RE: Firewall question Depends on your budget I've used both SonicWall and ZyWall. I have a zywall running on my home network http://www.zywall.com/products/model.php?indexcate=1037588623indexcate1=in dexFlagvalue=1021873683 I think this box runs between $250 $300 USD HTH, Duane -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 12:03 PM To: CF-Talk Subject: RE: Firewall question what firewalls to folks recommend? -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 11:00 AM To: CF-Talk Subject: RE: Firewall question Have a firewall between your router and server. Router -- Firewall -- Windows 2003 Server Use access list on your router, along with a good rule set on firewall, and a hardened web server. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 8:42 AM To: CF-Talk Subject: OT: Firewall question Which is more secure: Running your firewall on the NT 2003 Server or running it on a router? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194008 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Google Maps
http://maps.google.com The interface is beyond cool. Some of the searches, no doubt tied to google's web index, are uncanny. Anyone know the technology behind the interface? Just JavaScript, or is there more to it? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54