Re: deleting duplicates in table
> Hi list, with the following script (below) I am > checking duplicate eMails and I delete > them after checking them. you don't say what db BUT if its sql server (or another db with similar index functionality), i'd just let the db do the hard work: create another table duplicating your original table but put a unique index with ignore duplicate key property on your email column. CREATE UNIQUE INDEX emailIDX ON blabla(email) WITH IGNORE_DUP_KEY then simply INSERT/SELECT from the old table into the new one. sql server will accept the first email, but throw away (ignore) all the duplicate ones. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Question: (Brainfart Saturday...)
Morning all... I have a list of about 6000 skus. Say the SKU numbers look like this: 1 2 3 3 4 5 6 6 7 7 7 7 8 9 10 Basically, I want to write a SQL query to find all occurrences of the duplicate SKU values. Is there any way to make the SQL server do the filtering and not CF? TIA...Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Question: (Brainfart Saturday...)
Che Vilnonis wrote: > > I have a list of about 6000 skus. Say the SKU numbers look like this: > > 1 > 2 > 3 > 3 > 4 > 5 > 6 > 6 > 7 > 7 > 7 > 7 > 8 > 9 > 10 > > Basically, I want to write a SQL query to find all occurrences of the > duplicate SKU values. SELECTSKU, Count(SKU) AS occurences FROM table GROUP BY SKU HAVINGCount(SKU) > 1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Question: (Brainfart Saturday...)
> I have a list of about 6000 skus. Say the SKU numbers look like this: > > 1 > 2 > 3 > 3 > 4 > 5 > 6 > 6 > 7 > 7 > 7 > 7 > 8 > 9 > 10 > > Basically, I want to write a SQL query to find all > occurrences of the duplicate SKU values. Is there any way to > make the SQL server do the filtering and not CF? SELECT SKU, COUNT(SKU) AS Counted FROM SKU_TABLE GROUP BY SKU HAVING (COUNT(SKU) > 1) That should do it ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
track duplicate survey votes
I have a basic yes/no survey question at a site that is not password protected (we'd like to keep it that way so as not discourage response) Our recent survey question was obviously jumped on by somebody who placed many more yes votes than would be realistic for the issue I'm trying to figure out the best way to track duplicate votes if this is possible ... this may be a simple problem but its new to me and was hoping someone could give me a "best way to do this" nudge in the right direction Thanks in advance Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Downloading zip files
Hello. Please help me, I'm just not getting cfcontent! First of all, I HAVE searched the archives, and tried everything I have found, and gone through each example at http://www.figleaf.com/demo/mimetest/. My code looks like this: where variables.dl_zipname is the relative path to the file, and variables.zipname is the absolute path. In IE6, all of my testing and that of my helpers has resulted in getting the download dialog box with the default filename being the page name with a .zip extension. This is what I want. In NS7, my testing has gotten the download dialog with the default filename being the pagename.cfm.zip. I would like to know how to change this, but it is acceptable. So, with this status, we went live on Tuesday. Since then, we have had 3300 downloads, including two complaints. The first got a file called pagename.cfm, but it was an actual zipfile and renaming it did the trick. She was using IE6. However, the second one attached the file that she downloaded, also using IE6, and it was the page source! Does anyone have any idea how these things could happen, and how to avoid them in the future? Also, how to get Netscape to stop putting .cfm on the filename? Thanks very much. -- Carol Chandler Stitchery Mall (http://www.stitcherymall.com) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: mouseovers and disappearing menus
Hello. I have a simple CSS thing where the menu item background changes while hovering. When my menu us longer than the main part of the page, the end of the menu doesn't show up until you drag the mouse over it. Taking off the hovers fixes the diesappearance - but I LIKE the color change on hover. Do you know any way to make this behave better? Thanks very much. -- Carol Chandler Stitchery Mall (http://www.stitcherymall.com) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Downloading zip files
Carol Chandler wrote: > > Use: > deletefile="Yes"> > In NS7, my testing has gotten the download dialog with the default filename > being the pagename.cfm.zip. I would like to know how to change this, but > it is acceptable. The code above should fix that. > So, with this status, we went live on Tuesday. Since then, we have had > 3300 downloads, including two complaints. The first got > a file called pagename.cfm, but it was an actual zipfile and renaming it > did the trick. She was using IE6. I am surprised it was only one complaint, considering the HTTP spec says you need to use "filename" in the content-disposition header. > However, the second one attached the > file that she downloaded, also using IE6, and it was the page source! If it was the HTML source, user error. If it was the CFML source, you have bigger problems. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Question: (Brainfart Saturday...)
select count(*), sku from sku_table Group BY sku Having count(*) >1 -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Saturday, July 19, 2003 7:40 AM To: CF-Talk Subject: SQL Question: (Brainfart Saturday...) Morning all... I have a list of about 6000 skus. Say the SKU numbers look like this: 1 2 3 3 4 5 6 6 7 7 7 7 8 9 10 Basically, I want to write a SQL query to find all occurrences of the duplicate SKU values. Is there any way to make the SQL server do the filtering and not CF? TIA...Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Chr in CF MX and ASP 3.0
Hassan_Arteaga_Rodríguez wrote: > CF > ASP > 216--Ø216--Ø > 227--ã227--ã .. > 206--Î206--Î > 178--²178--² > > > Some numbers return differents values with chr in both technologies. Unlikely. Make sure you use the same charset on both ends. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Question: (Brainfart Saturday...)
> select count(*), sku > from sku_table > Group BY sku > Having count(*) >1 Problem with not aliasing the Count() is that it'll be a LOT more difficult to access in ColdFusion Count() as Alias ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Chr in CF MX and ASP 3.0
jon hall wrote: > They all look the same to me...I think something is not translating to > email correctly. Outlook is famous for not telling which charset it is sending. But apart from that, cf-talk is not very well suited for discussing these issues. Charset headers are stripped out by the mailinglist software. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Question: (Brainfart Saturday...)
agreed, just giving the SQL -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Saturday, July 19, 2003 10:01 AM To: CF-Talk Subject: RE: SQL Question: (Brainfart Saturday...) > select count(*), sku > from sku_table > Group BY sku > Having count(*) >1 Problem with not aliasing the Count() is that it'll be a LOT more difficult to access in ColdFusion Count() as Alias ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Question: (Brainfart Saturday...)
Thank you...that was it! -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, July 19, 2003 8:48 AM To: CF-Talk Subject: Re: SQL Question: (Brainfart Saturday...) Che Vilnonis wrote: > > I have a list of about 6000 skus. Say the SKU numbers look like this: > > 1 > 2 > 3 > 3 > 4 > 5 > 6 > 6 > 7 > 7 > 7 > 7 > 8 > 9 > 10 > > Basically, I want to write a SQL query to find all occurrences of the > duplicate SKU values. SELECTSKU, Count(SKU) AS occurences FROM table GROUP BY SKU HAVINGCount(SKU) > 1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cons to Fusebox
This is almost rediculous. I've seen complete newbies with little or no CF experience pick up fusebox in a week. Although I haven't been into FB4 yet, the transition from FB2 to FB3 took about a half hour. 4) Fusebox does have a learning curve (IMO, a pretty steep one if you want to truly and properly use all that FB offers) but once learned, you're in pretty good company (until the next release and then there usually seems to be another learning curve). -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:27 PM To: CF-Talk Subject: RE: Cons to Fusebox Brian: I appreciate all the effort you've been pouring into this thread. That said, allow *me* to back up a bit 8^). I am familiar with FB3 and have had opportunities to use it and its various features. I've also spent some (but not enough) time going over FB4 and I'm fairly well aware of what new features it brings to the table. All that said, I was never actually interested in discussing the pros/cons of Fusebox (despite the unfortunate email subject). I was really interested (and still am) in the pros/cons of one aspect of Fusebox... the controller. The central index.cfm file that all requests must pass through. That said, this thread has become interesting to me in its own right. To date, the main and generic points that I've noticed being made in this thread are, in no particular order: 1) Some people love FB, others hate it, still others don't care, and everyone seems to be very passionate about it all (except maybe for those who don't care). 2) Fusebox doesn't offer anything that can't otherwise be accomplished, however, it essentially prepackages it for you so you don't have to worry about it. 3) Fusebox offers its own set of advantages and disadvantages (perceived or actual) and it's up to the individual developer/architect to determine whether or not the tradeoffs make sense for that developer or project. 4) Fusebox does have a learning curve (IMO, a pretty steep one if you want to truly and properly use all that FB offers) but once learned, you're in pretty good company (until the next release and then there usually seems to be another learning curve). 5) While I wouldn't call Fusebox the de facto ColdFusion framework (there are too many people/sites not using it for that) it is certainly the most popular and used ColdFusion framework out there. 6) Fusebox is not a panacea. It's just as easy to write crappy code in FB as it is to write crappy code without FB. >From my own perspective, and arguably for my own personal reasons, Fusebox tends to be too much for me. It doesn't overwhelm me, it just offers too much stuff that I don't feel I need, and doesn't offer other stuff that I do want. It also requires a style of managing/writing code that I don't find beneficial. I'm willing to be flexible and change my coding style and mannerisms when I see benefit in doing so but, again for my own reasons, I don't find FB's way of doing things to be beneficial to what I do. Finally, FB tends to restrict how projects can be organized. I don't know much about FLiP but what I do seems to be impractical for how my own experiences suggest most projects succeed. I recognize that any framework will restrict to some extent how you do what you do, but I find FB's restrictions to be too restrictive/impractical. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Brian Kotek [mailto:[EMAIL PROTECTED] > Sent: Friday, July 18, 2003 10:26 AM > To: CF-Talk > Subject: Cons to Fusebox > > > Mosh, I think we're getting wrapped up too much in specifics. Let me > back up for a moment. First, XFA's are not required, only suggested. > You can write an entire FB app without a single XFA. They just offer > some nice benefits, like: > > keeping decisions about application flow in the realm of the > architect. keeping decisions about application flow out of any > individual code file. allowing you to change at runtime how the > application behaves. allowing for components that respond differently > in different situations. > > So, the decision on whether or not to use XFA's is a personal one. If > you think this is not worth the effort (though in reality the effort > required is neglegible), then you aren't required to use it. > > Regarding reuse and the question of building up end content from > smaller pieces, this too is a decision, not a requirement. But having > the ability to do this by adding a single attribute to an XML element > is pretty impressive, at least to me. Let me give a more realistic > example: > > Someone calls the controller to execute the fuseaction > "store.productDetails". The store circuit is targeted, and the action > productDetails is executed. productDetails is a controller-level > action so it doesn't do any
RE: Cons to Fusebox
This debate has been informative, but not really about pros or cons of Fusebox. I didn't realize there were so many developers out there that dislike a proven tool because they don't have the time/energy to understand it. I've never heard a developer who's actually architected and developed a project with FB say "I wish I hadn't used FB". Just developers that adopt code and don't understand how it works, or it's done differently then they do it. "There is a principle which is a bar against all information, which is proof against all arguments and which cannot fail to keep a man in everlasting ignorance - that principle is contempt prior to investigation." Greg -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 11:55 PM To: CF-Talk Subject: RE: Cons to Fusebox Hi, >> I'm sorry that you feel this is >> personally directed at you. I don't feel that way and never said that I did feel that way. I realize you aren't attacking any individual, much less me. This has actually been the best most informative Fusebox debate I have ever witnessed. I am glad I had the opportunity to speak during it. >> I reserve the right to answer honestly and fully. Of course you do. I would just like to hear a response with some meat to it; not necessarily from you, but in general. I would like to see examples that support views. Most of all I would like to see an unbiased opinion that is not based on trivial issues. Even though I don't speak out much, I have always respected your opinions. And I have always tried to keep an open mind, especially when it comes to frameworks and the like. I agree with some of the issues you raised; however others are, imo, minor obstacles with simple solutions and really don't reflect the bigger picture of the framework. These same types of obstacles also exist outside the realm of Fusebox. >> if "kiss my ass" is the best argument you can find, >> well, good luck with that Kiss my ass isn't my reply; sorry it seemed that way, I had intended it as a joke not as a direct comment towards you. I was commenting on your point about emoticons and certain remarks. Just because one smiles doesn't mean they think it is going to make you feel better or hope that their comments sit better with you. If I told you to kiss my ass and smiled about it, I would likely be smiling because it made me feel better; however childish it might be. :) I don't take offense to any of your comments; although, I disagree with many of them and as I said earlier I am not trying to convert you. I apologize if my comments were too blunt; I posted too hastily on my way out of the office, which was irresponsible on my part. I think we all agree Fusebox isn't for everyone or every situation, but for me--at the moment--it is. Although I have nothing to gain personally, I hope it continues to grow as it has and that it becomes more useful to more people. I think Fb4 is a great stride in that direction. Best regards, Michael Wilson ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cons to Fusebox
> This debate has been informative, but not really about pros > or cons of Fusebox. I didn't realize there were so many > developers out there that dislike a proven tool because they > don't have the time/energy to understand it. I've never heard > a developer who's actually architected and developed a > project with FB say "I wish I hadn't used FB". Just > developers that adopt code and don't understand how it works, > or it's done differently then they do it. Prior to FuseBox 4, there was a HUGE issue which meant that I couldn't/wouldn't use it; All of the FB files had to be held in folders under each website/application that it was running on When you run 30-40 sites on the same technology, spread over 3-4 servers, this was completely unusable With FB4 allowing centralised files, this helped an awful lot, but there are still restrictions I tried to build an app on FB2, then another client wanted a site with exactly the same technology - this meant duplicating the files over the 2 folders - whenever I did updates, I had to upload to 2 locations Over time it went to several more sites, thus more uploads At that point, I thought "I REALLY wish I hadn't used FuseBox for this" - I had to scrap most of the code and start again It would have been easier to have started with a centralised system - at the time, FuseBox was fine for individual sites, but as soon as you wanted the same technology on multiple sites, it became unmanageable... At this point, I'm too far away from anything FuseBox to convert to it, and I'm happy developing my way - although the current FuseBox architecture is VERY similar to the system I designed for myself about 4 years ago, and am still using something very similar What does that say about FuseBox? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Downloading zip files
It didn't help. Didn't hurt either (once I took out the extra " after filename - only two were needed there *g*), but it didn't change the behavior in either IE or NS. I tend to agree about the case where the user got the page source (and it was the html, not the CF - not THAT big of trouble. LOL) being user error. Anyway, thanks for trying. >Carol Chandler wrote: >> >> > >Use: > > > >> > deletefile="Yes"> > >> In NS7, my testing has gotten the download dialog with the default filename >> being the pagename.cfm.zip. I would like to know how to change this, but >> it is acceptable. > >The code above should fix that. > > >> So, with this status, we went live on Tuesday. Since then, we have had >> 3300 downloads, including two complaints. The first got >> a file called pagename.cfm, but it was an actual zipfile and renaming it >> did the trick. She was using IE6. > >I am surprised it was only one complaint, considering the HTTP >spec says you need to use "filename" in the content-disposition >header. > > >> However, the second one attached the >> file that she downloaded, also using IE6, and it was the page source! > >If it was the HTML source, user error. If it was the CFML source, >you have bigger problems. > >Jochem > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: track duplicate survey votes
Done a couple of these: One potential way of approaching this is simple cookies - drop a cookie as to whether or not someone voted - (granted they must have cookies turned on). Forced registration before polling, (something simple like email input) - to track responses. Used in conjunction with the cookies you can effectively strip responses from those that abuse the system. And now for the really creepy one: given that a majority of browsers are using an IE/Win combination there's this: http://www.computerbytesman.com/privacy/supercookiedemo.htm But as you can see, cookies/JS are about the only effective way to identify a client: but building the system to detect and store responses (building identifier hidden form fields with JS) based on whether or not it was a "clean" poll will allow you to at least filter out multiple or invalid responses at report time. Erik Yowell [EMAIL PROTECTED] http://www.shortfusemedia.com > -Original Message- > From: Tim Laureska [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 19, 2003 6:18 AM > To: CF-Talk > Subject: track duplicate survey votes > > I have a basic yes/no survey question at a site that is not password > protected (we'd like to keep it that way so as not discourage response) > > Our recent survey question was obviously jumped on by somebody who > placed many more yes votes than would be realistic for the issue > I'm trying to figure out the best way to track duplicate votes if this > is possible ... this may be a simple problem but its new to me and was > hoping someone could give me a "best way to do this" nudge in the right > direction > > Thanks in advance > Tim Laureska > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cons to Fusebox
Oh, in that case fusebox sucks. I'm not going to use it anymore! You're the smartest guy ever! Greg -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Saturday, July 19, 2003 11:46 AM To: CF-Talk Subject: RE: Cons to Fusebox > This debate has been informative, but not really about pros or cons of > Fusebox. I didn't realize there were so many developers out there that > dislike a proven tool because they don't have the time/energy to > understand it. I've never heard a developer who's actually architected > and developed a project with FB say "I wish I hadn't used FB". Just > developers that adopt code and don't understand how it works, > or it's done differently then they do it. Prior to FuseBox 4, there was a HUGE issue which meant that I couldn't/wouldn't use it; All of the FB files had to be held in folders under each website/application that it was running on When you run 30-40 sites on the same technology, spread over 3-4 servers, this was completely unusable With FB4 allowing centralised files, this helped an awful lot, but there are still restrictions I tried to build an app on FB2, then another client wanted a site with exactly the same technology - this meant duplicating the files over the 2 folders - whenever I did updates, I had to upload to 2 locations Over time it went to several more sites, thus more uploads At that point, I thought "I REALLY wish I hadn't used FuseBox for this" - I had to scrap most of the code and start again It would have been easier to have started with a centralised system - at the time, FuseBox was fine for individual sites, but as soon as you wanted the same technology on multiple sites, it became unmanageable... At this point, I'm too far away from anything FuseBox to convert to it, and I'm happy developing my way - although the current FuseBox architecture is VERY similar to the system I designed for myself about 4 years ago, and am still using something very similar What does that say about FuseBox? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Faking Out IIS?
How do you implement something like the following: http://www.mydomain.com/93288 ... where 93288 is a product id (not a physical directory). I'd like it to display the detail page for that product id. I guess it's got something to do with custom error handling in IIS, but I'm clueless on where to start. Anyone know of a reference for doing this on IIS? Thanks in advance, Brad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: anyone take a MySQL training class from mysql.com?
I am considering taking the Using and Managing MySQL training class and was wondering if anyone here had any feedback on the class (from www.mysql.com) Anyone take any other training class on MySQL that they could recommend? I am interested in coming up to speed quickly on MySQL. It seems a class is the best mechanism. Any other recommendations? Thanks. - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Faking Out IIS?
Try: http://cfhub.com/contributions/ses/ >How do you implement something like the following: > >http://www.mydomain.com/93288 ... where 93288 is a product id (not a >physical directory). > >I'd like it to display the detail page for that product id. I guess it's >got something to do with custom error handling in IIS, but I'm clueless on >where to start. > >Anyone know of a reference for doing this on IIS? > >Thanks in advance, > >Brad > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Faking Out IIS?
Brad Roberts wrote: > How do you implement something like the following: > > http://www.mydomain.com/93288 ... where 93288 is a product id (not a > physical directory). > > I'd like it to display the detail page for that product id. I guess it's > got something to do with custom error handling in IIS, but I'm clueless on > where to start. It might be a better idea to use some URL rewrite ISAPI filter for that: http://www.google.com/search?q=IIS%20URL%20rewrite Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Billing Advertisers
While the below link has provided some great information on advertising standards I still need numbers. I have been working on redesigning our website (http://www.seacrets.com) and several organizations have approached us about advertising on the site. We have never offered advertising in the past, but it makes sense for us to offer this product as the site generates an extreme amount of traffic but currently generates next to no income by itself other than as a marketing tool (I've temporarily removed the shopping cart for the Boutique since I'm redesigning it.) Can anyone provide me with what they may be asking? Even if it's off list? Any help is greatly appreciated. Cutter Eric Dawson wrote: > Internet Advertising - checkout > http://www.iab.net/ > http://www.iab.net/standards/adunits.asp > > > > > From: "Russ" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: CF-Talk <[EMAIL PROTECTED]> > Subject: RE: Billing Advertisers > Date: Fri, 18 Jul 2003 01:58:28 -0500 > > Sorry, just realized my response went a bit OT on what you originally > asked for, but an addition to phpMyAds is that it shows you common > sizes, common practices, etc. > > It's difficult to gauge a range of rates without knowing the traffic, > the target audience, etc. I'd recommend scoping the competition and see > if you can figure out what they're doing. > > Best, > > Russ > > > -Original Message- > > From: Cutter (CF-Talk)2 [mailto:[EMAIL PROTECTED] > > Sent: Friday, July 18, 2003 4:54 PM > > To: CF-Talk > > Subject: OT: Billing Advertisers > > > > > > Our organization has come to me saying that they now want to begin > > selling advertising space on our site. The only item of which > > we truly > > agree is that we will not allow pop-ads. > > > > My question is this, are there other standard options to web > > advertising > > other that the banner/click-through pricing schemas? Where > > could I find > > information on what might be good rates to charge? etc. Any help is > > greatly appreciated. > > > > Cutter > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Billing Advertisers
P.S. Don't look at the ugly site that's up there now. The new ones not up and I never would have done something like that (but my boss did). Cutter Cutter (CF-Talk) wrote: > While the below link has provided some great information on advertising > standards I still need numbers. I have been working on redesigning our > website (http://www.seacrets.com) and several organizations have > approached us about advertising on the site. We have never offered > advertising in the past, but it makes sense for us to offer this product > as the site generates an extreme amount of traffic but currently > generates next to no income by itself other than as a marketing tool > (I've temporarily removed the shopping cart for the Boutique since I'm > redesigning it.) Can anyone provide me with what they may be asking? > Even if it's off list? Any help is greatly appreciated. > > Cutter > > Eric Dawson wrote: > >>Internet Advertising - checkout >>http://www.iab.net/ >>http://www.iab.net/standards/adunits.asp >> >> >> >> >>From: "Russ" <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: CF-Talk <[EMAIL PROTECTED]> >>Subject: RE: Billing Advertisers >>Date: Fri, 18 Jul 2003 01:58:28 -0500 >> >>Sorry, just realized my response went a bit OT on what you originally >>asked for, but an addition to phpMyAds is that it shows you common >>sizes, common practices, etc. >> >>It's difficult to gauge a range of rates without knowing the traffic, >>the target audience, etc. I'd recommend scoping the competition and see >>if you can figure out what they're doing. >> >>Best, >> >>Russ >> >> > -Original Message- >> > From: Cutter (CF-Talk)2 [mailto:[EMAIL PROTECTED] >> > Sent: Friday, July 18, 2003 4:54 PM >> > To: CF-Talk >> > Subject: OT: Billing Advertisers >> > >> > >> > Our organization has come to me saying that they now want to begin >> > selling advertising space on our site. The only item of which >> > we truly >> > agree is that we will not allow pop-ads. >> > >> > My question is this, are there other standard options to web >> > advertising >> > other that the banner/click-through pricing schemas? Where >> > could I find >> > information on what might be good rates to charge? etc. Any help is >> > greatly appreciated. >> > >> > Cutter >> > >> > >> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Billing Advertisers
Sorry was in a bit of a rush yesterday. I am quite far from being an expert on the topic, but have thoughts on Internet advertising. ... internet advertising. I have heard of rates as low as $0.50 to $2.00 cpm. but other people talk about the $100 cpm they get. (yeah right) my ad model (not really implemented) is to separate inventory into three pieces (1) Sponsorships (2) Premium Ad spots (3) General Rotation spots I decide an amount I think is easy to sell - say $25 per month, decide what a fair CPM rate is for the inventory. $6.25 cpm for example ==> approx 4000 impressions. I divide my monthly inventory by the 4000 impressions to get a number of monthly ad spots to sell. I have one site which does more than 200k page view per month. - by my formula I have room for 50 advertisers @ $25 per month. $1250 per month. Once I get the advertisers going they have acccess to the premium inventory and sponsorship spots available throughout the site. On the premium spots (behind logins where you know a little about the person viewing the site, content specific pages, or high visibility pages) I would try to get $25cpm for those spots or even auction off to the existing advertisers. sponsorships I use on a cost+/project basis - and I might use the revenue to pay for domain registrations, hosting considerations, content gathering etc. just some ideas. hth. eric From: "Cutter (CF-Talk)" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: Billing Advertisers Date: Sat, 19 Jul 2003 16:49:40 -0400 P.S. Don't look at the ugly site that's up there now. The new ones not up and I never would have done something like that (but my boss did). Cutter Cutter (CF-Talk) wrote: > While the below link has provided some great information on advertising > standards I still need numbers. I have been working on redesigning our > website (http://www.seacrets.com) and several organizations have > approached us about advertising on the site. We have never offered > advertising in the past, but it makes sense for us to offer this product > as the site generates an extreme amount of traffic but currently > generates next to no income by itself other than as a marketing tool > (I've temporarily removed the shopping cart for the Boutique since I'm > redesigning it.) Can anyone provide me with what they may be asking? > Even if it's off list? Any help is greatly appreciated. > > Cutter > > Eric Dawson wrote: > >>Internet Advertising - checkout >>http://www.iab.net/ >>http://www.iab.net/standards/adunits.asp >> >> >> >> >>From: "Russ" <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: CF-Talk <[EMAIL PROTECTED]> >>Subject: RE: Billing Advertisers >>Date: Fri, 18 Jul 2003 01:58:28 -0500 >> >>Sorry, just realized my response went a bit OT on what you originally >>asked for, but an addition to phpMyAds is that it shows you common >>sizes, common practices, etc. >> >>It's difficult to gauge a range of rates without knowing the traffic, >>the target audience, etc. I'd recommend scoping the competition and see >>if you can figure out what they're doing. >> >>Best, >> >>Russ >> >> > -Original Message- >> > From: Cutter (CF-Talk)2 [mailto:[EMAIL PROTECTED] >> > Sent: Friday, July 18, 2003 4:54 PM >> > To: CF-Talk >> > Subject: OT: Billing Advertisers >> > >> > >> > Our organization has come to me saying that they now want to begin >> > selling advertising space on our site. The only item of which >> > we truly >> > agree is that we will not allow pop-ads. >> > >> > My question is this, are there other standard options to web >> > advertising >> > other that the banner/click-through pricing schemas? Where >> > could I find >> > information on what might be good rates to charge? etc. Any help is >> > greatly appreciated. >> > >> > Cutter _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF to Linkpoint
Has anyone set-up a CF page to talk to Linkpoint and back? I set-up a regular html form and got it working and then switched it to cfhttp and its acting link it doesn't link at all. I figured either I need to do something or there system isn't handling something. Thank you Troy Montour ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF to Linkpoint
Yup, we've done it. I think Linkpoint has their own tags now available for free but it requires an API account to be setup. We have Linkpoint basic and basically used CFHTTP to fake out their form. IIRC, we had to do some creative work with the HTTP referer that we sent along with the cfhttp call. If you'd like I'll see if I can dig up some code examples, email me off-list if you are interested. Matt -Original Message- From: Troy Montour [mailto:[EMAIL PROTECTED] Sent: Saturday, July 19, 2003 7:03 PM To: CF-Talk Subject: CF to Linkpoint Has anyone set-up a CF page to talk to Linkpoint and back? I set-up a regular html form and got it working and then switched it to cfhttp and its acting link it doesn't link at all. I figured either I need to do something or there system isn't handling something. Thank you Troy Montour ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF to Linkpoint
Matthew, that would be great if you could dig it up.. cause I I'm totally stumped. we have the basic account so you know Thank you for your help on this Troy - Original Message - From: "Matthew Fusfield" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, July 19, 2003 6:06 PM Subject: RE: CF to Linkpoint > Yup, we've done it. I think Linkpoint has their own tags now available > for free but it requires an API account to be setup. We have Linkpoint > basic and basically used CFHTTP to fake out their form. IIRC, we had to > do some creative work with the HTTP referer that we sent along with the > cfhttp call. > > If you'd like I'll see if I can dig up some code examples, email me > off-list if you are interested. > > Matt > > > -Original Message- > From: Troy Montour [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 19, 2003 7:03 PM > To: CF-Talk > Subject: CF to Linkpoint > > > Has anyone set-up a CF page to talk to Linkpoint and back? > > I set-up a regular html form and got it working and then switched it to > cfhttp and its acting link it doesn't link at all. > > I figured either I need to do something or there system isn't handling > something. > > Thank you > Troy Montour > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Faking Out IIS?
>It might be a better idea to use some URL rewrite ISAPI filter >for that: http://www.google.com/search?q=IIS%20URL%20rewrite Found this: http://www.smalig.com/url_rewrite-en.htm Extremely useful, thanks for the heads up, Jochem! Jack ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: SQL statements
I'm rewriting the shopping cart for a boutique. It's a generous mixture of JS and CFM. An issue that I have is this... I have a table of sizes and their IDs I have a table of colors and their IDs I have a table of Items and their specs. Two of the fields hold a comma delimited listing of IDs, one field for the sizes and one for the colors. When I call my initial query it gives me the specs of the items within a specific category Select c.txtBoutCat as Cat, i.txtSubCat as SubCat, i.txtDesignName as Name, i.mnyItemPrice as Price, i.mnyXXAdd as XX, i.mnyXXXAdd as XXX, i.txtColors as Colors, i.txtSizes as Sizes, i.blEmbroider as Embroider, i.txtImageName as Image, i.intImgWidth as Width, i.intImgHeight as Height, i.intImgThmbWidth as TWidth, i.intImgThmbHeight as THeight, i.blWomens as Womens Fromtblboutcat c, tblboutitems i Where c.intBoutCatID = i.intBoutCatID And i.blActive = 1 Then I will cfoutput for the query qItems, writing my form within the output, basically creating the display for each individual item. My problem is getting my comma delimited lists of IDs into actual text entries of my select boxes. What is the best way of going about this? Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help with first connection to ODBC SQL datasource
I just migrated/imports my first Access database to my new SQL2000 server named DEVELOPER. I added a datasource in CF Administrator called formsSQL. Checked off used trusted connection and the administrator said OK to the Verify. I went in and tried to do a simple cfquery which works in the Access original database: select * from cthru which returned the following error: ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'cthru'. I know I am doing something stupid, but sure would appreciate some pointers. Terry Troxel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with first connection to ODBC SQL datasource
I just tried this and I got a different error. Had to drop the dbserver name, then all worked well. Also, you do not need the dbtype attribute since you are not doing a QofQ. Presuming that the DSN you created is pointing to the correct server, and there is a table named cthru, this should work: select * from cthru Bruce Sorge From: "Terry Troxel" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Help with first connection to ODBC SQL datasource Date: Sat, 19 Jul 2003 19:05:06 -0700 I just migrated/imports my first Access database to my new SQL2000 server named DEVELOPER. I added a datasource in CF Administrator called formsSQL. Checked off used trusted connection and the administrator said OK to the Verify. I went in and tried to do a simple cfquery which works in the Access original database: select * from cthru which returned the following error: ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'cthru'. I know I am doing something stupid, but sure would appreciate some pointers. Terry Troxel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: track duplicate survey votes
store cgi.remote_addr with each submission and dont let the same IP vote twice its easy to delete cookies and vote again. It's more of a pain to change ur ip to vote again and if someone does... hey... they've got nothing better to do anyway : ) "Tim Laureska" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a basic yes/no survey question at a site that is not password > protected (we'd like to keep it that way so as not discourage response) > > Our recent survey question was obviously jumped on by somebody who > placed many more yes votes than would be realistic for the issue > I'm trying to figure out the best way to track duplicate votes if this > is possible ... this may be a simple problem but its new to me and was > hoping someone could give me a "best way to do this" nudge in the right > direction > > Thanks in advance > Tim Laureska > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: deleting duplicates in table
here is a custom tag i wrote a while back to do just what you want i believe if anyone wants to workaround the evalute()'s feel free and let me see : ) someone i know had a huge DB table full of emails with duplicates and this is what i came up with to help... then i said set all email fiields to NO DUPLICATES when you make the table : ) SELECT #ATTRIBUTES.PrimaryKey#, #ATTRIBUTES.Column# FROM #ATTRIBUTES.TableName# ORDER by #ATTRIBUTES.Column# SELECT DISTINCT #ATTRIBUTES.Column# FROM #ATTRIBUTES.TableName# ORDER BY #ATTRIBUTES.Column# Before Purge Of Duplicates: -- #GetAll.RecordCount# entries in the database. #GetDistinct.RecordCount# are unique (#extras# extras) -- There were no duplicates in the database. No data will be deleted. SELECT #ATTRIBUTES.PrimaryKey#, #ATTRIBUTES.Column# FROM #ATTRIBUTES.TableName# WHERE #ATTRIBUTES.Column# = '#evaluate(ATTRIBUTES.COLUMN)#' #Evaluate(ATTRIBUTES.Column)# is in the database #getdups.recordcount# times The Following list is a list of Primary Keys that will need to be deleted to rid the table of duplicate entries #FinalList# DELETE FROM #ATTRIBUTES.TableName# WHERE #ATTRIBUTES.PrimaryKey# = '#i#' "Paul Hastings" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Hi list, with the following script (below) I am > > checking duplicate eMails and I delete > > them after checking them. > > you don't say what db BUT if its sql server (or another db with similar > index functionality), i'd just let the db do the hard work: > create another table duplicating your original table but put a unique index > with ignore duplicate key property on your email column. > > CREATE UNIQUE INDEX emailIDX > ON blabla(email) >WITH IGNORE_DUP_KEY > > then simply INSERT/SELECT from the old table into the new one. sql server > will accept the first email, but throw away (ignore) all the duplicate ones. > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: deleting duplicates in table
Guess that kinda got chopped up huh... I'll send you the .cfm offlist sorry - Original Message - From: "Ewok" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, July 19, 2003 11:03 PM Subject: Re: deleting duplicates in table > here is a custom tag i wrote a while back to do just what you want i believe > if anyone wants to workaround the evalute()'s feel free and let me see : ) > > someone i know had a huge DB table full of emails with duplicates and this > is what i came up with to help... then i said set all email fiields to NO > DUPLICATES when you make the table : ) > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >"No"> > > > > > > > > > > > > > > > > > > > > > > > > > "YES"> > > > > > > > > > > > > > blockfactor="100"> > SELECT #ATTRIBUTES.PrimaryKey#, #ATTRIBUTES.Column# > FROM #ATTRIBUTES.TableName# > ORDER by #ATTRIBUTES.Column# > > > > blockfactor="50"> > SELECT DISTINCT #ATTRIBUTES.Column# > FROM #ATTRIBUTES.TableName# > ORDER BY #ATTRIBUTES.Column# > > > > > > > > > > > Before Purge Of Duplicates: > -- > #GetAll.RecordCount# entries in the database. > #GetDistinct.RecordCount# are unique (#extras# > extras) > -- > > There were no duplicates in the database. No data will be deleted. > > > > > > > > > > > blockfactor="50"> > SELECT #ATTRIBUTES.PrimaryKey#, #ATTRIBUTES.Column# > FROM #ATTRIBUTES.TableName# > WHERE #ATTRIBUTES.Column# = IsNumeric(ATTRIBUTES.Column)>'#evaluate(ATTRIBUTES.COLUMN)# IsNumeric(ATTRIBUTES.Column)>' > > > > > > > > > > #Evaluate(ATTRIBUTES.Column)# is in the database > #getdups.recordcount# times > > > > > > > > > > > > > > > > > > > > > The Following list is a list of Primary Keys that will need to be > deleted to rid the table of duplicate entries > > #FinalList# > > > > > > > > > > DELETE > FROM #ATTRIBUTES.TableName# > WHERE #ATTRIBUTES.PrimaryKey# = '#i# NOT IsNumeric(I)>' > > > > > > > > > > > "Paul Hastings" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > Hi list, with the following script (below) I am > > > checking duplicate eMails and I delete > > > them after checking them. > > > > you don't say what db BUT if its sql server (or another db with similar > > index functionality), i'd just let the db do the hard work: > > create another table duplicating your original table but put a unique > index > > with ignore duplicate key property on your email column. > > > > CREATE UNIQUE INDEX emailIDX > > ON blabla(email) > >WITH IGNORE_DUP_KEY > > > > then simply INSERT/SELECT from the old table into the new one. sql server > > will accept the first email, but throw away (ignore) all the duplicate > ones. > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reporting Software
we've been using sawmills for a while now and pretty satisfied http://www.sawmill.net/ "Dave Sueltenfuss" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Afternoon Everyone, > > I am looking for some software to write reports for distribution through > ColdFusion. I have tried using Crystal Reports, but have had too many > issues with the software to be able to use it on the web sever. Does > anyone know of a good report writing package for the web? Any info is > appreciated > > Thanks > > Dave Sueltenfuss > Application Developer > Certified ColdFusion MX Developer > Arch Wireless > Phone: 508-870-6711 > Fax: 508-870-8011 > Email: [EMAIL PROTECTED] > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: track duplicate survey votes
If you are looking for the closest thing to secure as you can without requiring a log-in..the do track both cookies and IP. There are two things with just tracking IP.. that you should know about anyway..I If you have a client on a network behind NAT or behind a firewall..and he tells his co-worker behind the firewall..then they will probably both have the same IP address.. so it won't let his co-worker vote.. and Dial up users get a new IP address when they disconnect and reconnect(a process that takes all of 30 seconds). The point is though.. that while tracking cookie and ip is a good solution.. it can't beat having the user log-in for higher security type polls. For all other polls/surveys where you want the most security that you can without requiring the user to log-in.. then IP and cookie is as high as you can go as far as I know. You might also look into getting one of those images that have numbers that only humans can read.. so people will not be able to program bots that will simply submit over and over again. -Zine -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Sunday, July 20, 2003 1:53 AM To: CF-Talk Subject: Re: track duplicate survey votes store cgi.remote_addr with each submission and dont let the same IP vote twice its easy to delete cookies and vote again. It's more of a pain to change ur ip to vote again and if someone does... hey... they've got nothing better to do anyway : ) "Tim Laureska" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a basic yes/no survey question at a site that is not password > protected (we'd like to keep it that way so as not discourage response) > > Our recent survey question was obviously jumped on by somebody who > placed many more yes votes than would be realistic for the issue > I'm trying to figure out the best way to track duplicate votes if this > is possible ... this may be a simple problem but its new to me and was > hoping someone could give me a "best way to do this" nudge in the right > direction > > Thanks in advance > Tim Laureska > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Faking Out IIS?
Just want to throw this in: if you need even more flexibility you should look at http://www.isapirewrite.com/ the paying version let's you rewrite url's but even allows you to proxy request to another server depending on the url, so your request can arrive at your iis server, but may actually be processed by another webserver (eg apache) sitting on an other port they also have a lite version that is free but lacks the proxying and some other stuff - Original Message - From: "Jack Dalaa" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, July 20, 2003 2:27 AM Subject: SOT: Faking Out IIS? > >It might be a better idea to use some URL rewrite ISAPI filter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
