RE: (cross post) SQL row numbering
Select into a temp table that has an idenity column and then select the result from that. Justin -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 4:54 PM To: CF-Talk Subject: OT: (cross post) SQL row numbering How can I get SQL server to automatically number my rows of a recordset, as I retrieve it? If I have the following information in a table (example data) NameAge Joe 20 Sally 14 Jim 15 And I do a query: Select somefunction() as rownum, name, age from table I want a recordset of RownumNameAge 1 Joe 20 2 Sally 14 3 Jim 15 Since this is going to be a small part of a larger stored procedure, I can't use CF. Thanks Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 4:42 PM To: CF-Talk Subject: RE: MM Pricing Problem on CFMX for J2EE I would agree that it is an over-generalized statement, however, the technical support DOES have its issues. I've had a problem with JVM Memory Settings in CFMX Pro but in order to speak to someone in your tech support dept. I have to pay at least $250. It seems that when you pay over $1000 for software that you should get at least SOME technical support - even for a limited time. I bought an iBook and got 90 days unlimited support. My iBook cost about the same as CFMX Pro. It would be nice to get some temporary support for our money. After all, isn't that one of the arguments about why people choose retail products over open-source? Technical Support. You're supposed to get more if you pay right? I can write PHP and pay someone to give me support on that, but since I paid $1000 for CFMX I expected some free support - or at least someone courteous on the phone. I'm not leaning towards MM bashing mind you - I love CFMX and MM products in general, but seriously, do something about your support options. Even email or chat-based support to determine if higher-level paid support is in order. Sort of a Tech Support Triage or something. That's just my opinion ... Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ** ** * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ** ** * -Original Message- From: Mike Chambers [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 4:28 PM To: CF-Talk Subject: RE: MM Pricing Problem on CFMX for J2EE -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] advantage. And of course everyone knows that their tech support sucks big time. That is quite a generalization, and one i personally feel is incorrect. While some people may have had poor experiences with tech support (such as yourself), to state that everyone feels the way you do is, in my opinion a rather large leap. mike chambers [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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 Worm
-Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 5:20 AM To: CF-Talk Subject: Re: SQL Worm Paris Lundis wrote: A good summary Jochem would be for folks to tune the firewall and ensure permissions/allowable IP list... Since when can you even buy a 10 Gbps firewall? In your environment you point out the user base... 8000... agreeable... large base for things... Tune the firewall and restrict traffic there ... allowing like port 80 in and out disbaling all other services and ports, except those in a defined list of authrozied servers... All 8000 systems are authorized servers. About 65525 of 65536 ports are authorized ports. You can't firewall a production network where the product is (supposed to be) innovation. Yes you can, and you have to. The problem is that it is a pain in the ass to maintain your rule sets as they change frequently, but that is the cost of security. Pessimistic security is a pain to maintain, which is why so many people choose not to. Every network should be firewalled and you should have specific ingress and egress rules for each host based on the needs of that host. If a host does not need outbound http, block it, then it cannot be the source of a DDOS even if it gets compromised. I have a very hard time believing that innovation means that every port on every box has to be open to the public. If the servers need to be accessible to users, they should be tunneling into the LAN to get behind the firewall. I think we have had this discussion last week already, but firewalls are not the answer to all problems. Sure, properly secured firewalls on machines running MS SQL Server would have prevented this issue (at least, nobody has convinced me that UDP should be allowed to a production server at all). But there are allways other DNS uses UDP. If you run DNS internally, you need to allow UDP port 53. PCAnywhere also uses UDP. scenario's where a firewall would not help. In the end, vigilance on all the aspects of security is the only way to make sure problems like this worm don't cause a total meltdown of the internet. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: telnet server w2k - is it safe to use ?
I believe that openSSH requires that you install their CYGWIN.dll and it is not the most current version, which they say can cause conflicts if you have the Current version installed (which is highly recommended if you do command line stuff). VanDyke SSH server and client are great and highly recommended. Justin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 26, 2003 7:07 PM To: CF-Talk Subject: RE: telnet server w2k - is it safe to use ? I wonder if anyone has experience with using the telnet server that ships with windows 2000 ? Has anyone got a things to consider before using list ? Yes, you might want to consider if you want to allow unencrypted Windows logins across the network, since telnet is unencrypted. I think that the MS telnet server supports NTLM authentication, but that only works with MS telnet clients, I suppose. If you really need telnet-like functionality, but don't want the security issues of telnet, you might consider getting an ssh server. VanDyke Software has a very nice one called VShell, and I think you can use OpenSSH on Windows also. If it has to be telnet, you might look at using something that doesn't integrate with Windows logins, but has its own logins instead. I've never deployed a telnet server on Windows, though, so there may be other considerations as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion and Telnet
We use a com object called cfx_tcpclient to speak to our mail servers CLI via telnet. Works great. Justin -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 5:47 PM To: CF-Talk Subject: Cold Fusion and Telnet Here's an interesting one and conceivable not possible, but I thought I would ask all the wise ones here on the CF-Talk list before I tell my client NO!. Has anybody ever done anything connecting Cold Fusion and Telnet? Basically the client wants to create a web-based telnet session to a back end application on a HP L3000 Unix server so that every computer in the organization doesn't have to have the customized telnet client installed and maintained/upgraded on them. Is this even possible? If not, any other suggestions on how such a system may be created? Anybody know of any tools/custom tags/CFX/applications or something else that may do this already? Thanks Ian Skinner Web Developer BloodSource Sacramento CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: SQL7 DB Update Procedure
Make your datasource a variable defined in the application.cfm. Switch the datasource between databases as needed by changing the application.cfm. It will not matter if the databases are on the same machine or not as they can have different names and you can change what CF is looking at very easily. Justin -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:16 AM To: CF-Talk Subject: SQL7 DB Update Procedure The on-line database of listings, etc, at www.SMARTERYellowpages.com , Biz1, is read-only in normal operation. The off-line database, Biz2, is not read-only in normal operation, and it is currently updated daily on a backup machine, including automatic backup, and updating of full-text indexes (SQL7). It's backup is used to update Biz1. Since the 2 databases are on different machines, they can and do have the same name. Updating of Biz1 is a simple restore using the most recent Biz2 backup, followed by updating the full-text index. Is there a way to have Biz1 Biz2 on the same machine, and: To update Biz1, switch Biz2 to read-only. Switch www.SMARTERyellwpages.com to read from Biz2 instead of Biz1 Update Biz1 using the latest backup of Biz2. I haven't tried this but I wonder how to work around the difference DB names - or even if the name difference matters. best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
The more sophisticated web bugs do not use a parameter, but instead actually use the filename itself to identify the individual and each email has a different image being requested. Quite effective in HTML email and on web pages. Justin -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:24 PM To: CF-Talk Subject: RE: web beacons Yep.. One of the ways that spammers, these days, collect info on valid email addresses when using HTML email campaigns. You simply view the email, and BAM.. they know your email address is good. Old news | -Original Message- | From: Costas Piliotis [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 10:04 AM | To: CF-Talk | Subject: RE: web beacons | | | Oh yeah, and you can pass url parameters to that image as | well... So let's say you send an email to employeeid 145. | | You can add a parameter the the src of the gif file in the | html email you send him as such: | | img src=http://www.myserver.com/image.cfm?id=145; | | Then in the source... Of image.cfm, something like this | appears: cfcontent file=foo.gif | type=application/whatever cfquery datasource=#application.ds# | insert into someTable (employeeid, date) | values (#val(url.id)#, getdate()) | /cfquery | | -Original Message- | From: Costas Piliotis | Sent: Monday, January 13, 2003 10:00 AM | To: CF-Talk | Subject: RE: web beacons | | | Easy. | | cfcontent file=foo.gif type=application/whatever | cfquery datasource=#application.ds# | ...tracking query here... | /cfquery | | You include the image, and some server-side code to process | it. Done it a few times... | | -Original Message- | From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 9:52 AM | To: CF-Talk | Subject: web beacons | | | Yahoo is using something called web beacons. Can anyone | simply explain how a single pixel gif is used as a web beacon. | http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ADMINISTRATOR Michael help (verification)
The service can be told to whitelist the maillist. The idea itself is not so new... has been around since 95ish. It is only recently going mainstream though as enough people are fed up with unsolicited email to require that you be on a whitelist to email them. Return receipts can be dealt with by the list server (I would be surprised if it doesn't already). Justin -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 3:06 PM To: CF-Talk Subject: Re: ADMINISTRATOR Michael help (verification) At 12:51 PM 1/6/2003, you wrote: I'll check your account out. As for the spamarrest thing, it's a new scheme to avoid spam by opting in anyone that you want to accept email from. I hate it and hope it dies fast. Received that spam arrest thing too. If everyone signed up, then each poster would receive thousands of spam arrest responses. Would be nice if you can kick off anyone that uses spam arrest on the account they sign up to the mailing list. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: OT: AOL?
AOL has their own internal RBL and uses their own rules. If you are sending alot of email across their network you should speak with them about being whitelisted. They may be enforcing rDNS, some anti-spam efforts do this. They probably have other criteria as well. Most of the AOL delivery problems that we have had in the past were just related to a few really slow relays that held the mail for a few hours before spitting it back out. Oh, if they are rejecting based on a non-matching rDNS, they should be doing it at the connection and not even accepting the mail. I would be very surprised to hear that it was really being sent to /dev/null. Justin -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:37 PM To: CF-Talk Subject: Re: OT: AOL? Ah, excuse me, the validate sender is a separate selection on the mail server. Sorry = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Jason Burnett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:24 PM Subject: Re: OT: AOL? | I am not trying to start a flame war here, I just want to make sure | noone gets the wrong impression and confirm or disprove what I thought | SMTP-AUTH was. As far as I can tell from RFC 2554 SMTP-AUTH | really has nothing to do with checking reverse DNS, it is just an | authentication method. | | on Wed Dec 18 samcfug spoke forth with the blessed manuscript | I see your point, however, in my own case as a email hosting provider, I have | the settings set to enable SMTP AUTH, which is what you mean by doing the | reverse lookup. I also make it a point to create the in-addr-arpa record in | DNS that takes care of it. That is just another task in hosting email domains. | In fact I use a script that takes care of all this when adding a new domain. | If you were an ISP or hosting provider, you would be aware of the constant | attacks by others trying to spoof one of your hosted addresses, including virus | attacks such as the Klez Virus, which are all turned away at the server. | That is my story, and I am sticking to it! :-) | | = | Douglas White | group Manager | mailto:[EMAIL PROTECTED] | http://www.samcfug.org | = | - Original Message - | From: Lee Fuller [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, December 18, 2002 1:12 PM | Subject: RE: OT: AOL? | | | | Ya know.. Don't let them hit you with that. | | | | The problem is, new sysadmins tend to think that making changes is part | | of their job. We had a MAJOR battle with HUD since one of our customers | | submits information to them via email regularly. Suddenly, they could | | not contact HUD, due to a policy change by a new admin who decided that | | if the email server didn't reverse to the same domain name, it was | | most-likely SPAM. The problem is (as you are most likely aware) that | | with 1000's of domain names on a single mail server, how could you | | POSSIBLY reverse to them? Even if you added all the reverse names to | | your DNS server manually, it would never answer with the right one | | first.. So it's not logical. | | | | We have to force them to understand that THEY are not the ONLY ISP on | | the planet... and that making willy-nilly admin decisions effects | | millions. If we fight back, they will change the policy. | | | | Just my .02... | | | | | | | | | -Original Message- | | | From: Kris Pilles [mailto:[EMAIL PROTECTED]] | | | Sent: Wednesday, December 18, 2002 11:05 AM | | | To: CF-Talk | | | Subject: RE: OT: AOL? | | | | | | | | | Aol says my reverse DNS is not up But everything on my | | | server appears to be working fine I guess its my fault | | | after all lol | | | | | | -Original Message- | | | From: Bud [mailto:[EMAIL PROTECTED]] | | | Sent: Wednesday, December 18, 2002 1:44 PM | | | To: CF-Talk | | | Subject: RE: OT: AOL? | | | | | | | | | On 12/18/02, Kris Pilles penned: | | | No good This sucks... MY clients are starting to notice this | | | too. Weird thing is the mail just disappears... No | | | bounce back or | | | anything like that... | | | | | | I occasionally have similar problems. I ALWAYS use them as an | | | opportunity to point out to my client that they are LIKELY losing | | | other e-mails, some which may be important. I point out to them (as | | | Howie did to you) that they don't generally bounce the e-mails, so | | | the sender has no way of knowing what the problem is so they may | | | rectify it, or even if there is a problem on his/her end
RE: cf 4.5, 5 apache ?'s
1.3.6 is older than 1.3.27. 6 27. Confusing but rational at the same time. I am running 4.5 on 1.3.27 and it works fine except for the DEAPI warnings because there is no DEAPI build of the cold fusion module for 4.5. Justin -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 11:26 AM To: CF-Talk Subject: Re: cf 4.5, 5 apache ?'s Dave, I think must be 1.3.6 is a typo as 1.3.27 is the latest [1.3] version of apache. No, I don't think it's a typo, it's just an older version of Apache. CF 4.5 worked with 1.3.6 and higher, and I presume it would work with 1.3.27. I'm amazed you managed to translate that string of rubbish into english! I must confess I didn't look into past version number of apache too closely, but logically you would assume that 1.3.6 would be a newer version than 1.3.27, but as you say 1.3.6 must be an older version and therefore cf4.5 should work fine with 1.3.27. This is what I was trying to say, but just burbled instead. Thanks for sorting me out... Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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.
RE: OT: onUnload() Issue within a CF Application.
We lots of problems with onUnload() and found that it could not be effectively used to log a user out. I believe that in Netscape, the windows was closing before the onUnload() event actually finished executing. After a while we gave up and went back to to just timing out sessions. Justin -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 9:14 AM To: CF-Talk Subject: Re: OT: onUnload() Issue within a CF Application. Oliver Cookson wrote: What I'm planning to do is popUp a window onUnload() which log's the user out, easy you say, well how do I STOP the window popping up when they user the back\forward buttons or press refresh? onClose() Jochem Except that this doesn't satisfy the condition of moving the browser out of the application by typing a url into the address field, thus leaving the user stranded and unable to log back in if they for instance, type www.google.com into the address field, browse to another page, then close the browser. I know of a way to prevent any users not using Internet Explorer from logging in to an application ( including preventing users of current versions of Opera ). This may or many not be a solution for you, however, if you can control the browser environment, then you can do some things that you might not otherwise consider for compatibility reasons. I have an app currently using a hidden iframe to submit the login command on the onbeforeunload() event which has proven to be more effective than onunload() or a popup window ( which are often killed before they open ). What I found using onunload() was that I could only get the url to fire in a killable popup -- it wouldn't load in the iframe. But onbeforeunload() gave me the functionality I needed. As to the back, forward and refresh I don't really have a solution -- the application I just mentioned has a console in the topmost window which mostly doesn't move or reload (it reloads in a couple special case conditions, but it's able to do this without logging out), with all of the tools loading into iframes. The issue of back and forward is addressed primarily by simply providing links in such a fashion that the user hopefully never has a need for a back button. If a user hits f5 or the reload button ( instead of right-clicking an iframe and reloading the frame ), they're logged out and they have to log in again. .. dunno how much help any of this is. :) s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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
RE: Importing a text file into SQL Server table
If the file is large, you can use cfexec to BCP the file into a table then run a stored procedure to process the table and put the data where it really needs to be. If the file is small, just loop through it and do a series of inserts then call a stored procedure to process the table. Justin -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:40 AM To: CF-Talk Subject: Importing a text file into SQL Server table Hello list. I have a text file that is comma and double-quote separated, with a line break that separates the lines. The first row contains the header information. What I am wanting to do is to import this into a SQL Server 2K table. I know that I can use DTS to do this, but I need to do this in ColdFusion code instead as a scheduled task. I have always in the past just used DTS Wizard to do this, not straight SQL. So, my question is, how do you import a text file into SQL Server? What would my query look like? I already have the cffile code in place looking at the text file. Thanks, Bruce ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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
RE: : FTP notification...without CF...etc.
We use sitescope (http://www.sitescope.com) to monitor the number of files in number of different directories and alert us there is a change. Actually, we use it to monitor the whole production environment to make sure everything is running smoothly... Justin -Original Message- From: Che Vilnonis [mailto:chevy;asitv.com] Sent: Friday, November 15, 2002 10:37 AM To: CF-Talk Subject: OT:: FTP notification...without CF...etc. I currently use War FTPD for FTP transfers. Do any of you gurus out there know how to automatically alert someone when a file has successfully been uploaded? I am looking for a War FTPD/Win 2K solution. Thanks... Ché Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: (Admin) New spam code
Michael, What does running a properly set up mail server mean? Justin -Original Message- From: [EMAIL PROTECTED] [mailto:mdinowit;houseoffusion.com] Sent: Monday, November 11, 2002 1:01 PM To: CF-Talk Subject: (Admin) New spam code Just a heads up: In an attempt to crack down on spam even more, I put some new code into effect yesterday which checks if your running a properly set up mail server. Most spammers don't have their mail server set up right or try to hide it. The code has been rather effective with 3 noted exceptions. These are legitimate people who's mail servers are not set up properly. If anyone gets a message about their posts being rejected due to this, you can email me at [EMAIL PROTECTED] If this becomes more of a hassle than not, I'll remove it. Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ICQ: 2995061 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: (Admin) New spam code
Thanks Matt, I actually know a fair bit about it, I just get nervous when people speak about rejecting 'improperly configured' servers. Are we talking about open relays, lack of rDNS, not rfc compliant? I am just curious what Michael's definition is. Justin p.s. Nice tools. -Original Message- From: Matt Robertson [mailto:matt;mysecretbase.com] Sent: Monday, November 11, 2002 5:20 PM To: CF-Talk Subject: RE: (Admin) New spam code Justin, You can find out all sorts of stuff about how well (or poorly) your mail server dns etc. is set up at http://dnsstuff.com. One of the handiest tools there is http://www.dnsreport.com. http://www.dnsreport.com/tools/dnsreport.ch?domain=spamex.com -- Original Message -- from: Justin Greene [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 11 Nov 2002 17:07:17 -0500 Michael, What does running a properly set up mail server mean? Justin -Original Message- From: [EMAIL PROTECTED] [mailto:mdinowit;houseoffusion.com] Sent: Monday, November 11, 2002 1:01 PM To: CF-Talk Subject: (Admin) New spam code Just a heads up: In an attempt to crack down on spam even more, I put some new code into effect yesterday which checks if your running a properly set up mail server. Most spammers don't have their mail server set up right or try to hide it. The code has been rather effective with 3 noted exceptions. These are legitimate people who's mail servers are not set up properly. If anyone gets a message about their posts being rejected due to this, you can email me at [EMAIL PROTECTED] If this becomes more of a hassle than not, I'll remove it. Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ICQ: 2995061 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MM Has No Plans to Support Apache 2.0
This is a particularly sore spot for me as I started the same thread a while back when MM refused to create a -EAPI build of the 1.3.x apache dll for CF 4.5. They tried to claim that DEAPI was post 4.5 and therefore I was asking for legacy support, then when I showed them that DEAPI actually existed prior to the release of 4.5 they ultimately said they would do it, then never came through. Because of that I will no longer support the new versions of Cold Fusion as a developer. I am still running 4.5 for most of my products, which is stable and fast enough, and will be porting to something else, either Java or PHP when a new developmetn is required. MM lost a long time Cold Fusion develment house over this (we have been developing in CF since version 1.5), which is stupid as it is a simple recompile. Clearly this is about forcing upgrades down our throats and not about providing good support for the customer base, which ultimatly makes us buy the upgrades willingly. Justin -Original Message- From: Matt Liotta [mailto:mliotta;r337.com] Sent: Monday, November 11, 2002 9:44 AM To: CF-Talk Subject: RE: MM Has No Plans to Support Apache 2.0 While I agree with you that Macromedia should support Apache 2.0 for CF 5, I disagree with your post. You seem to imply that a normal IT shop wouldn't want to upgrade to CFMX until after it matures for a couple of years, yet you want to upgrade to Apache 2.0, which is certainly immature in comparison to Apache 1.3. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Greg Bullough [mailto:gwb;outofchaos.com] Sent: Monday, November 11, 2002 9:39 AM To: CF-Talk Subject: MM Has No Plans to Support Apache 2.0 The MM Partners office informs me that MM has no plans to supply a mod_coldfusion.so for CF 5.0/Linux/Apache 2.0 'Not enough demand' they say. So know we know MM's policy on one-release- back support. They don't do what's right: they do what will not get them punished by losing too many customers. If you haven't picked the platform that's going to be most popular, you're out of luck, and even if you have, maybe you're out of luck anyway, and if you're not prepared to keep churning through releases (rather than maintaining existing release levels for several years, as is normal I/T practice) you're out of luck. As such, MM has decided that Cold Fusion is the wrong choice for mission-critical business applications, because it will not have the kind of support that the I/T industry expects. Greg ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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.
RE: Locking and clustered servers
In SQL7 and SQL2000 you can use IDENTITY safely assuming you have no triggers that are causing cascading inserts. If you have triggers causing inserts, then you need to use the select max() method as shown in original message for SQL 7: DECLARE nextid SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN TRANSACTION; INSERT INTO table ... ; SELECT nextid = IDENTITY COMMIT TRANSACTION; Justin -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Monday, October 28, 2002 12:30 PM To: CF-Talk Subject: Re: Locking and clustered servers SNIP Depends heavily on the db server in question... SQL Server 7 Stored Procedure DECLARE nextid SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN TRANSACTION; INSERT INTO table ... ; SET nextid = (SELECT TOP 1 identity FROM table ORDER BY identity DESC) COMMIT TRANSACTION; SQL Server 2000 Stored Procedure DECLARE nextid; INSERT INTO table ...; SET nextid = SCOPE_IDENTITY(); I'm not familiar enough with Oracle yet to know the specific syntax. If you're absolutely certain that you won't have any triggers which insert data into other tables with identity columns in your db on SQL Server 7, you can use IDENTITY DECLARE nextid; INSERT INTO table ...; SET nextid = IDENTITY If you have a trigger on that table that inserts data into another table with another identity column, however, IDENTITY will return the identity value from the trigger, not the stored procedure. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
RE: 3 Tier Security
I think that the 3 Tier issue is really one of performance, not security., If you can compromise the 1st tier, you can compromise the second, and then the third. Anywhere there is a hole in the firewall there is an opportunity to break in. Tiers just add layers and make it more complicated. However, on the performance side application servers can help with the load. It is easy to conceive of an application where for example, I would want 2 web servers (tier 1), 5 application servers and 1 database server. This lets me scale my app servers separately from my web servers which can make a difference in licensing cost. Justin -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 3:30 PM To: CF-Talk Subject: 3 Tier Security I am hoping someone can help me out with this. Maybe I just can't see how it would work..but anyways we have apps that are going to be accessible outside our firewall. We currently have a set-up like this. Webserver is in dmz with the ports http/https accessible to the outside world. CF code is kept on this server. Database is completely inside the firewall. The firewall is configured to only allow communitcation from the webserver IP to the SQL IP over a sql port. There are voices around here that want to see a 3rd layer or an app server inbetween. I can't visualize how this would work? I think I may just need someone to help me visualize it. Anyways taking into consideration that the webserver software is all patched up and tighened down, the code has been analized to ensure that there are no holes will adding the extra layer really do any good? Thanks Mike __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: clustering q's
Are we really speaking about clustering here or load balancing. I find that web server require load balancing whereas database servers need clustering. It is a picky semantic, but if your web servers were truely 'clustered' then they would act as one and you would not have content replication issues, session variable issues, etc. They are in fact load balanced, multiple machines with the same content sharing the workload. Justin -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 1:38 PM To: CF-Talk Subject: clustering q's Hey all. My company is currently on CF 4.5 Professional...upgrading to 5.0 this weekend (yes, we *are* the bleeding edge) :) Our system admins have recently decided that they want to cluster our win2K web servers. I've never been in a clustered environment (i've been in environments that have been a cluster, but that's a differnet story)...so I've got a few questions. We *MUST* be using CF Enterprise if we are on clustered servers? What happens if we are on Professional and one server dies? Session vars will be lost? Users who are in the middle of a web based 'app' would have to start over? Is that the only problem (not that it's a small problem...but i'm trying to find out all of the angles so I can make a report to da boss)? Also, *if* it is feasible to use CF Pro in a clustered environment, would we be responsible for having licenses for each server (this, of course, would be a moot point if clustered servers MUST be on CF Enterprise). I'd call MM on this and ask...but I have a feeling that would be like walking into a car dealership and saying, i have this much money to spend...can you help me? :) thanks in advance, charlie __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post.Office
I still run it as an internal relay and find that it is a very solid MTA but it's lack of any form of smtp AUTH makes it useless in the real world. Take a look at CommunigatePro by Stalker (http://www.stalker.com) . Very nice package. Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 3:30 AM To: CF-Talk Subject: Re: Post.Office P.O has some major problems in a number of areas. The fact that it has not been upgraded in ages and is now 'abaondonware' is a good reason to dump it asap. As for the prolog and epilog text, it worked for me so there may be some settings that you have different. If you want, contact me off list and we'll talk. I may need to get access to the list setup to look it over. If I'm not mistaken, this list use to run on Post.Office. It's not anymore, and there is a reason. Run forest run! -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 18, 2002 10:22 PM To: CF-Talk Subject: Post.Office Does anyone here use Post.Office for a listserv? I have setup a list but and everything is working but the Prologue and Epilogue text doesn't show up. Rick __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post.Office
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 3:30 AM To: CF-Talk Subject: Re: Post.Office * Replies will be sent through Spamex to [EMAIL PROTECTED] * For additional info click - http://www.spamex.com/i/?v=52 P.O has some major problems in a number of areas. The fact that it has not been upgraded in ages and is now 'abaondonware' is a good reason to dump it asap. As for the prolog and epilog text, it worked for me so there may be some settings that you have different. If you want, contact me off list and we'll talk. I may need to get access to the list setup to look it over. If I'm not mistaken, this list use to run on Post.Office. It's not anymore, and there is a reason. Run forest run! -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 18, 2002 10:22 PM To: CF-Talk Subject: Post.Office Does anyone here use Post.Office for a listserv? I have setup a list but and everything is working but the Prologue and Epilogue text doesn't show up. Rick __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 4.5, verity and memory usage
I have a CF4.5 installation that is running Verity against about 20GB of data. CF is using huge amounts of memory (570MB) that it frees if I cycle the service. Is it caching the collections or something along those lines and does running large collections require large amounts of memory? Any insight would be appreciated. Not very up on the impact of verity on performance. Justin -- Justin Greene ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 x 101 http://www.clicvu.com http://www.spamex.com Spamex - Protect your real email address forever __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL query driving me nuts
Ah, I see the issue. You just need to eliminate the other users before joining. Something like (syntax may be off a little as I do not have SQL on this machine to test it)... Justin SELECT I.ItemID, I.Name, I.LastModified, V.UserID, V.LastViewedDate FROM(Select ItemID, Name, LastModified from items where userid = 1) I LEFT OUTER JOIN Viewed V ON I.ItemID = V.ItemID WHERE V.LastViewedDate I.LastModified or V.UserID is null ORDER BY I.ItemID -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 12:23 AM To: CF-Talk Subject: RE: SQL query driving me nuts What about something like this. (note the placement of the () with the AND/OR)... Justin SELECTItems.ItemID, Items.Name, Items.LastModified, Viewed.UserID, Viewed.LastViewedDate FROM Items LEFT OUTER JOIN Viewed ON Items.ItemID = Viewed.ItemID WHERE (Viewed.UserID = 1 and Viewed.LastViewedDate Items.LastModified) or Viewed.UserID is null ORDER BY Items.ItemID -Original Message- From: Steven Duff [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 12:00 AM To: CF-Talk Subject: SQL query driving me nuts SNIP __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL query driving me nuts
What about something like this. (note the placement of the () with the AND/OR)... Justin SELECT Items.ItemID, Items.Name, Items.LastModified, Viewed.UserID, Viewed.LastViewedDate FROMItems LEFT OUTER JOIN Viewed ON Items.ItemID = Viewed.ItemID WHERE (Viewed.UserID = 1 and Viewed.LastViewedDate Items.LastModified) or Viewed.UserID is null ORDER BY Items.ItemID -Original Message- From: Steven Duff [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 12:00 AM To: CF-Talk Subject: SQL query driving me nuts SNIP __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and SQL
If you DB supports it, use if exists [query] the presence of the exists directive will cause the query to stop processing as soon as it has a match. This can save time if you are querying an unindexed table or there are multiple results. Justin -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:23 PM To: CF-Talk Subject: CF and SQL Ok, I am interested in peoples opinions on the following: Is it best practice to check for a records existence before attempting to update it? And what would the best way to go about that be? Michael Tangorre __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question: Selecting and grouping by date
We usually use convert(varchar(10),date,102) which returns .mm.dd which is best for sorting the query IMHO. Also very usefull for grouping if you need to group by day. Justin -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 7:05 PM To: CF-Talk Subject: SQL Question: Selecting and grouping by date Is there a way to select the datepart(mydate,mm/dd/yy) from MSSQL? I can only seem to return the Day, month or year, but not all three. The field contains date time data and I am trying to group on the date part but the time is throwing off the results. Brook __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Recommendations other than Verity
Does anyone have any recommendations for an indexing solution other than verity that integrates failry easily with Cold Fusion 4.5. We are indexing email and not only does verity not recognize the files as email, but it cannot index the attachments (because it does not recognize the file as email). Additionally a 250MB mailbox generates a 4GB-6GB collection and verity does not appear have a way to trim that. I do not need a way to index queries, just files. TIA, Justin -- Justin Greene ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 x 101 http://www.clicvu.com http://www.spamex.com Spamex - Protect your real email address forever __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursive queries
There is an example in the SQL Server book on-line on how to do this. I do not remember where, but it does not use recursion. Recursion is very cool (I happen to love it) but is not terribly efficient, probably why LISP never caught on. Justin -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 11:37 AM To: CF-Talk Subject: Recursive queries Still trying to decide how I like to perform some type of recursive query wth the following Table structure; ID NAME PARENT_ID If the current record IS the parent then the Parent ID is 0 Otherwise the child has the ID of the parent as it's Parent ID. Anyone have any good references on recursive queries to handle this? A way to spider down through the parents and children basically. Ive done this before using Stored Procs and temp tables, but there has to be an easier way. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Macromedia selling partner information?
The follow unsolicited email was received to a Disposable Email Address only used for my now expired Allaire Cold Fusion Partner program registration. I cannot even check my preferences as I no longer have an account. Anyone else get this and does anyone recall if the partners policy provides for the selling of our information? Justin -Original Message- From: Eric Long [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: PaperThin Offers Powerful, Affordable Content Management Solution Are you looking for an affordable, full-featured content management solution for your customers? Then consider PaperThin's award-winning CommonSpot Content Server 3.0. SNIP Call me today if you'd like to learn more about CommonSpot Content Server, the leading ColdFusion-based content management solution. Sincerely, Eric Long PaperThin, Inc. www.paperthin.com 781-934-7838 x 217 [EMAIL PROTECTED] PaperThin respects your need for privacy. If you do not wish to receive further communications from PaperThin, you can unsubscribe by replying to this email with the word REMOVE in the subject line. Â Â Â __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia selling partner information?
Here is the response from them RE: where they got my info. Honest, but a little vague as to whether Macromedia gave them the named or they harvested them. Sir Our marketing team got it from Macromedia. I am truly sorry if it upset you. I will remove your name. Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:19 PM To: '[EMAIL PROTECTED]' Subject: RE: PaperThin Offers Powerful, Affordable Content Management Solution Where did you get my email address? -Original Message- From: Eric Long [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: PaperThin Offers Powerful, Affordable Content Management Solution -Original Message- From: Meg-Ann Meaney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 5:29 PM To: CF-Talk Subject: FW: Macromedia selling partner information? Hello: Neither Allaire nor Macromedia sold the Allaire partner names. I am investigating how this may have occurred, but understand that companies have screen scraped company names from the website. As past partners, there would have been a time when you were included in search results intended for customers to locate partners with a particular expertise. I will update you when I learn more. Best regards, Meg Meaney Director, Partner Programs Macromedia, Inc. SNIP __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hardware question
The big issue with IDE v. SCSI is that with IDE the system CPU handles the I/O and therefore creates additional load. If your application is not loading the disk I/O system heavily this will probably not make much of a difference, however if it is or should you have to rebuild one of the disks in your array do to a failure, your system will slow to a crawl. I have found that servers are pretty unusable while an IDE RAID is rebuilding. Justin -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 6:57 AM To: CF-Talk Subject: Hardware question If I build a CF Server, say a Dual 1.4Gz P4 with 1 or 2 GB RAM, would I get much a performance hit if I went with a Raid 1 ATA/100 80 GB Dual HDD setup as opposed to SCSI? Curious. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying 1 million records
Are you actually planning on returning a million rows to CF and trying to display or manipulate it somehow or just indicating that the tables will be large and you are querying against a million rows? If the former, good luck. Moving a million rows out of one DB and into another using Cold Fusion will take en eternity as you will have to do the inserts one row at a time. Better to bulk out and bulk in the data or something along those lines. Justin p.s. We use CF all the time with tables that has 10+ million rows, the db is the issue, not CF. -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 9:17 PM To: CF-Talk Subject: Querying 1 million records Im going to have to deal with some large amounts of data, queries that select 1 million records. Is this something CF should be able to handle? (CF5 on win2000 with 512 RAM) One thing I want to do is query one DB and insert recs to another DB, approx. 1 million recs. Thanks for any advice, Jeff __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Skimmin the list.......? [oT]
I have been using the same Spamex Disposable Email Address (http://www.spamex.com) on this list for 18 months and this is the only place that the address has been used and my real email address is in the list going back to the very beginning, but I have not received the email in question to either. If someone is harvesting then they are being selective. BTW: It is really tough for the list owner to prevent harvesting unless subscriptions are moderated. List subscribers need to protect themselves with something like Spamex Disposable Email Addresses (http://www.spamex.com). You cannot leave the door unlocked and then get upset it you get robbed! (shameless self promotion and somewhat on target as the site is coded in CF). Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:01 AM To: CF-Talk Subject: Re: Skimmin the list...? [oT] The old archives then. The new archives do not show a persons email address unless the person is using an email package that does not show their 'normal' name. (http://www.houseoffusion.com/cf_lists/index.cfm?method=messag esthreadid=13814forumid=4) Below is the start of an article I'm writing on it (about 3 pages in already): Email addresses all follow a standard format. The problem is that there are more than one standard. Below are the 5 ways in which an email address will be formatted: Name [EMAIL PROTECTED] Name [EMAIL PROTECTED] [EMAIL PROTECTED] (Name) [EMAIL PROTECTED] [EMAIL PROTECTED] In the first 3 examples, a 'plain text' name is sent along with the email address. In the last 2, only an email address is sent. This gives us a challenge to work with; how to parse the full email address to get the plain text name and the actual email address. The answer is actually easier than one would think. Lets write a User Defined Function (UDF) to do this. They could also be using the archives for skimming... - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 11:46 PM Subject: Re: Skimmin the list...? [oT] I'll check out if this group is subscribed and remove them. I'll also ban the domain from the list. SKIMMING IS NOT ALLOWED HERE. I find out the name of the person who uses this list for spam the world will know it and he'll be blacklisted from any resource I have any connection with. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Skimmin the list.......? [oT]
What you describe is typically called a tagged email address and it is the same premise that Disposable Email Addresses work on. If you are a mail admin, you can easily create tagged addresses as you describe, however Disposable Email Address Services offer many conveniences that make them prefereable to doing it in the smtp software manually (such as the ability to reply and have it come from the Disposable Email Address, to track history of who has sent what, to selectively turn them on and off as needed, etc). Justin -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:43 AM To: CF-Talk Subject: RE: Skimmin the list...? [oT] What's the difference in spamex.com and setting up a wildcard? For instance, if your website asks for my email address, I'll put [EMAIL PROTECTED] If I get junk from that address, I know who's responsible. Plus, it's easier to remember which disposable address I entered for your site. -Brad -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:25 AM To: CF-Talk Subject: RE: Skimmin the list...? [oT] I have been using the same Spamex Disposable Email Address (http://www.spamex.com) on this list for 18 months and this is the only place that the address has been used and my real email address is in the list going back to the very beginning, but I have not received the email in question to either. If someone is harvesting then they are being selective. BTW: It is really tough for the list owner to prevent harvesting unless subscriptions are moderated. List subscribers need to protect themselves with something like Spamex Disposable Email Addresses (http://www.spamex.com). You cannot leave the door unlocked and then get upset it you get robbed! (shameless self promotion and somewhat on target as the site is coded in CF). Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:01 AM To: CF-Talk Subject: Re: Skimmin the list...? [oT] The old archives then. The new archives do not show a persons email address unless the person is using an email package that does not show their 'normal' name. (http://www.houseoffusion.com/cf_lists/index.cfm?method=messag esthreadid=13814forumid=4) Below is the start of an article I'm writing on it (about 3 pages in already): Email addresses all follow a standard format. The problem is that there are more than one standard. Below are the 5 ways in which an email address will be formatted: Name [EMAIL PROTECTED] Name [EMAIL PROTECTED] [EMAIL PROTECTED] (Name) [EMAIL PROTECTED] [EMAIL PROTECTED] In the first 3 examples, a 'plain text' name is sent along with the email address. In the last 2, only an email address is sent. This gives us a challenge to work with; how to parse the full email address to get the plain text name and the actual email address. The answer is actually easier than one would think. Lets write a User Defined Function (UDF) to do this. They could also be using the archives for skimming... - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 11:46 PM Subject: Re: Skimmin the list...? [oT] I'll check out if this group is subscribed and remove them. I'll also ban the domain from the list. SKIMMING IS NOT ALLOWED HERE. I find out the name of the person who uses this list for spam the world will know it and he'll be blacklisted from any resource I have any connection with. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Managing list subscriptions (was Skimmin the list.......? [oT ])
Personally, I avoid using catch all addresses. The first time you get hit with a dictionary attack to your mail server and have 50,000+ messages in your catch all address mailbox you will wish you assigned the addresses one by one. Using a catchall also makes it diffucult to turn off the addresses that are compromised, you now have to add a rule our router entry to blackhole the bad addresses since you are catching all... Justin -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 9:36 AM To: CF-Talk Subject: RE: Skimmin the list...? [oT] This is what we do as well. Very effective and easy to remember --- if you have the ability to have a catch-all on your domain name, that only you receiveSince I am the admin of ALL email addresses for us, I catch all the wildcards. Erika | -Original Message- | From: Brad Roberts [mailto:[EMAIL PROTECTED]] | | What's the difference in spamex.com and setting up a wildcard? | | For instance, if your website asks for my email address, | I'll put [EMAIL PROTECTED] If I get junk from | that address, I know who's responsible. Plus, it's easier | to remember which disposable address I entered for your site. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 4 million messages per hour - is it possible?
I have to say that CF does not sound like the best tool to use for something like this. Perhaps it can be done... write to the spool directly and let DART (if they still use that for mail) pick up the messages and send them, but CF is not that fast and if you want to handle max volume on min hardware you need speed end efficiency (don't you end up with a page that has to run for an hour to complete the task?). I can see using CF to admin the email app but I would think that a nice tight C++ mailer that sends email in batches and marks when things have been successfully queued (to allow restarts without re-sending to everyone) would work much better. Also, queuing the messages is not the only issue (as was pointed out earlier). You will need a fair amount of bandwidth and a huge number of outbound connections on your MTA to handle delivery of all those messages (4M messages/60min/60sec = connections/sec and a connection could take a few seconds). Plan on having a bunch of outbound MTA's handling the actual delivery. When we have built apps that send email, We typically use a queue in a table to control who is getting the mail, then let the spoolers (the app that does the sending) each query the table and grab messages in reasonable blocks for delivery. This allows multiple spoolers each handle their part of the load and deliver to multiple MTA's. Good luck doing this with CF. Justin -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 8:42 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? We did use CF to generate the email files. I can't say how, but I can tell you that using cfloop and cffile to accomplish writing millions of files in a short period of time is not a problem. -Matt -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 5:02 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? That makes sense :) Did CF call a componet that wrote the files to the queue. I dont assume you did the following but I must ask to make sure. Did you happen to write the files by querying the DB for addresses then looping over the query (Ive heard cfloop is very slow) and using cffile to write the email to the mail server's queue? jeff -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:32 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? Nope, can't be done using cfmail. We wrote files directly to the mail server's queue. -Matt -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:10 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? How exactly is this cf driven. Cant imagine you did it with cfmail. Jeff -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:25 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? I developed a system using LSMTP that could easily do 4 million messages per hour that was driven from CF. -Matt -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:15 PM To: CF-Talk Subject: 4 million messages per hour - is it possible? Hello, Has anyone had experience in creating an emailing solution driven by ColdFusion and SQL on any platform with any mail server that is capable of handling 4 million deliveries an hour? If so, would you care to share what software you used to make it happen? And do you have a live example of a company using the system? ---mark Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 4 million messages per hour - is it possible?
-Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 10:09 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? Using CF makes a lot of sense if the organizations knowledge is with CF. Writing a multi-threaded high-performance C++ application to pull data from a database and generate email files would take quite a bit of work as compared to a CF based application. Yes, but easier is not always better. If CF is the choice because it is the only option, then so be it, but I think it is not a great choice for this type of application given the volume/hour. The fact that you used C++ and tight in the same sentence makes me think you don't know much about C++ as C++ based programs are anything but tight. This really depends the definition of tight. Mine is small and fast and I see no reason why this would not be both. To handle the desired volume I suspect that it would have to be both. A more reasonable language to use for this job would be Perl, but the same knowledge problem comes up. Besides the real work is not sending the mail; it is dealing with the volume of bounces and unsubscribe requests that result. Sure, perl would be great for this, but it is not fast. We have some apps using perl to send email and some using Java to send email (all back end processes). I would not use either if performance were an issue. I prefer to spend money on the right code to do the job than extra hardware to compensate for the wrong code. 4 million messages/hour is a lot of messages, the code should be as fast (note I did not say tight) as possible or you will spend a fortune on buying more boxes. Justin -Matt -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 6:23 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? I have to say that CF does not sound like the best tool to use for something like this. Perhaps it can be done... write to the spool directly and let DART (if they still use that for mail) pick up the messages and send them, but CF is not that fast and if you want to handle max volume on min hardware you need speed end efficiency (don't you end up with a page that has to run for an hour to complete the task?). I can see using CF to admin the email app but I would think that a nice tight C++ mailer that sends email in batches and marks when things have been successfully queued (to allow restarts without re-sending to everyone) would work much better. Also, queuing the messages is not the only issue (as was pointed out earlier). You will need a fair amount of bandwidth and a huge number of outbound connections on your MTA to handle delivery of all those messages (4M messages/60min/60sec = connections/sec and a connection could take a few seconds). Plan on having a bunch of outbound MTA's handling the actual delivery. When we have built apps that send email, We typically use a queue in a table to control who is getting the mail, then let the spoolers (the app that does the sending) each query the table and grab messages in reasonable blocks for delivery. This allows multiple spoolers each handle their part of the load and deliver to multiple MTA's. Good luck doing this with CF. Justin -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 8:42 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? We did use CF to generate the email files. I can't say how, but I can tell you that using cfloop and cffile to accomplish writing millions of files in a short period of time is not a problem. -Matt -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 5:02 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? That makes sense :) Did CF call a componet that wrote the files to the queue. I dont assume you did the following but I must ask to make sure. Did you happen to write the files by querying the DB for addresses then looping over the query (Ive heard cfloop is very slow) and using cffile to write the email to the mail server's queue? jeff -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:32 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? Nope, can't be done using cfmail. We wrote files directly to the mail server's queue. -Matt -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:10 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible
RE: 4 million messages per hour - is it possible?
It is capable of sending up to a thousand emails per minute efficiently and reliably, if it could do this per second, it might work... Justin -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 10:41 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? How about ActivMail? http://www.cfdev.com/activmail/ -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 2 July 2002 12:32 PM To: CF-Talk Subject: RE: 4 million messages per hour - is it possible? CF takes it square on the chin because the CFMAIL tag is rather weak and polling frequency, maximum records in a directory and lack of expansion are nil That is only if you actually use the cfmail tag. I wouldn't be caught dead using the cfmail tag for anything whether it was a single message or millions. -Matt __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NT Firewalls
I would not run a firewall on the NT box, but rather place a firewall between the NT box and the rest of the world. Justin -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 4:52 AM To: CF-Talk Subject: SOT: NT Firewalls Running public CF Servers, what firewall software do you all use on your NT boxes? -- James Smith - [EMAIL PROTECTED] http://www.xsite.ltd.uk - Xsite Limited -- As a computer, I find your faith in technology amusing. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LinkPoint
We had problems with their CFX tag (I do not remember what they were) so we used their Java classes to create our own CFX. I can ask the developer who did it for more info if you want it. Justin -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 11:40 AM To: CF-Talk Subject: LinkPoint Anyone here using Linkpoint and there CFX tag? I'm pulling my hair out try to figure out how to do a transaction void programmatically. If anyone has code they wouldn't mind sharing please let me know. Duane __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cookie Management 3rd Party Site
We developed exactly this a while back for our ClicVU advertising product and used a pixel to cookie and track the user (which is fairly common). We ended up building an apache module because cold fusion was not capable (v4.5) of setting a cookie on a redirect or setting a cookie when returning an image as the data for a .cfm page (if memory serves...). Not sure if 5 will do this. If you need to handle any volume, you will want to make it a module for the web server that maintains it's own DB pool and not use CF. Justin -Original Message- From: Stephen Cassady [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 2:26 PM To: CF-Talk Subject: Cookie Management 3rd Party Site I've recently been tasked to create a system similiar to systems like DoubleClick in tracking users (not the click-through). Basically: (1)Client places some of our code in their web site (2)Code triggers test of our cookie on visiting browser (3)If not cookie, then set (4)Read Cookie (5)Trigger Database activity on our server to record unique user ID (from cookie) and website I'm a little lost on the type of code for our clients to place on their site. I'm assuming JavaScript, to run a script from our server. That we then set/read cookies and do database input. Not assuming any use of the IFrame. Do not need to send or set picture, though that may be required to open up the HTTP connection that allows us to set a cookied from our server. Does anybody have such code already developed, or knows of a good set of examples on the net, or in a book, that I may be able to access? Thank you for your time. Stephen Cassady [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hiding Info In View Source
You cannot block the ability for someone determined to view your source, you can only make it difficult. I can telnet into the server and get the raw html regardless of how much munging you do to the file and if you use javascript to encrypt the file, I can write a routine to unencrypt the javascript and so on and so forth... You can make it tough, but not impossible. Justin -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 2:15 PM To: CF-Talk Subject: RE: Hiding Info In View Source External javascript files maybe... Jim -Original Message- From: Double Down [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 12:55 PM To: CF-Talk Subject: Hiding Info In View Source Does anyone know of a way to hide some form fields in the view source code? TIA DDINC __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamically Naming Applications
It seems to me that if you are trying to allow the same person to have multiple sessions taking place from the same physical browser, then you just need to track sessions in the URL and not use cookies. This will allow as many logins as you like from a single machine. There should not be a reason to dynamically change the application name, you just need a mechanism for tracking sessions the is URL specific. This does not sound like a CFApplication issue. Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 9:26 AM To: CF-Talk Subject: Dynamically Naming Applications Is there a way to dynamically create an application name? By this I mean if you have a user that is accessing a site from two different browser windows is there a way to separate their sessions? I have a few applicaitons that have various variables set depending on the user level of the person logged in. What sometimes happens is that someone will log in as one user level in one window and a different one in another. In some rare instances this doesn't cause a problem, however when they log out from one window (and the applicaiton deletes the session as it's supposed to), the other window suddenly starts blowing up all over the place. My thought was if I could dynamically generate an application name for the CFApplication tag. Can this be done? Thanks! Hatton __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity quesition
I am trying to index a number of documents that are basically text documents, but have no file extension. Verity seems to want a file extension or it will not index the documents. Is there a way to define the collection to index these? Justin -- Justin Greene ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 x 101 http://www.clicvu.com http://www.spamex.com Spamex - Protect your real email address forever __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity quesition
They are text files but the application that creates them does not add file extensions. A file does not have to be .txt to be a text file. I am trying Daves solution... will see what happens. Thanks, Justin -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 1:13 PM To: CF-Talk Subject: Re: Verity quesition You can create a custom query with Verity so verity thinks it is putting together a collection of documents - while the documents are actually just records from the database.. So if that text exists in a db you can do it that way.. But question - if they are text files - individual text files - they have .txt extensions? Which Verity can search... jay Justin Greene wrote: I am trying to index a number of documents that are basically text documents, but have no file extension. Verity seems to want a file extension or it will not index the documents. Is there a way to define the collection to index these? Justin -- Justin Greene ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 x 101 http://www.clicvu.com http://www.spamex.com Spamex - Protect your real email address forever __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Random Values generated in SQL
This is not really something that Transact SQL excels in, but I think the way to handle it is to create a string 'ABCDEFGH' then in a while loop select a number between 1 len(string) and and insert the number into a temp table. After N loops, I would exit the while loop, and select substring(string,column,1) from the temp table. Justin -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 7:04 PM To: CF-Talk Subject: RE: Random Values generated in SQL \ 1 column of output - 346 rows long - All values in the list will be randomly selected from 8 possible list items (A,B,C,D,E,F,G,H) Output of 5 Rows D A B B C Thanks, Casey Cook bjohnson @hostworks.coTo: CF-Talk [EMAIL PROTECTED] m (Ben cc: Johnson) Subject: RE: Random Values generated in SQL 06/04/02 05:01 PM Please respond to cf-talk Does anyone know in SQL how to generate 346 random selections from predefined list of 8 distinct values (A,B,C,D,E,F,G,H). I will be using query analyzer to complete this task, no coldfusion is involved. Casey, Can you be more specific? Do you need 346 random rows? Are you only choosing one column per row or do you need several columns? Also, is this random or do you just need permutations/combinations of those 8 values? Basically, can you give me a mini-example of the output that you want to see? Thanks. Ben Johnson Hostworks, Inc. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORDER BY question
If you only have 4 groupings then the case statement is the best solution IMHO. It will let you create the sequence column dynamically. Justin -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 8:40 AM To: CF-Talk Subject: RE: ORDER BY question Man! you guys went way over my head hear! : ] for this purpose since there are only 4 separate groupings i may just do 4 separate queries. not sure. thought i could do it like Order By tblJobTitle.TitleID=25, tblJobTitle.TitleID=26, tblJobTitle.TitleID=28, tblJobTitle.TitleID=4; __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORDER BY question
The way to do this is definitely by creating a sequence field and ordering by this field. How the sequence is created is up to you... to hard code it you do something like select sequence = case when 'a' then 1 when 'z' then 2 when 'f' then 3 else 4 end), next field from table The case statement will let you evaluate the field and create a sequence based on it, however, looking at your example, I think it would be wiser to add a sequence table that related each job position to a sequence and generate it this way. Justin -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 3:41 PM To: CF-Talk Subject: Re: ORDER BY question Create a new field called Sequence or something. Based on the data and the two elements you displayed there is no way without Hard-Coding it. Randy Adkins [EMAIL PROTECTED] 05/28/02 15:39 PM ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... !--- tblJobTitle.TitleID Partner=25 Principal=26 Senior Associate=28 Associate=4 --- Thanks -paul __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Question on Email Addresses
We do a fair amount of parsing of email addresses for our http://www.spamex.com service and found that the regex to properly parse email and remain RFC compliant is actually about 1 page long (we found it published somewhere). We ended up not going the regex way due to the complexity and just parsing the email address one character at a time to isolate the email address. Not as elegant but much easier. Justin -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 4:13 PM To: CF-Talk Subject: Re: Question on Email Addresses CFSET email=myname [EMAIL PROTECTED] cfset x=reReplaceNoCase(email,.*(.*).*,\1) CFOUTPUT#x#/CFOUTPUT On Mon, 20 May 2002, Randell B Adkins wrote: I am trying to parse an email address due to the friendly email addresses by using CFPOP. If the #FROM# resembles: [EMAIL PROTECTED] then I am fine however since there are friendly email address which look like myname [EMAIL PROTECTED] then I have to use HTMLEditFormat to get the email address. However using this code, does not FIND the in the email addresses that are Friendly however it will fine the @ symbol. What am I missing??? cfset checkEmail = #HTMLEditFormat(from)# cfif #FindNoCase(,checkEmail,1)# Email Start Point Located cfelse !--- Use CheckEmail --- If it is a Friendly Email Address then When I validate this in the DB, it looks for the entire string myname [EMAIL PROTECTED] and NOT just the email address. /cfif sorry I am just not with it today to think about it any longer and I know it is something so dang simple that I am just overlooking... Thanks in Advance! NO - #findnocase(@,checkEmail,1)# - /cfif #LEN(checkEmail)# br /cfoutput __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access or MSDE
Anyone have a feeling about the Microsoft Data Engine, which is supposed to be a limited connection version of SQL that can upscale to SQL very easily rather than Access? Justin -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:15 AM To: CF-Talk Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access or MSDE
That is what I thought. I have not understood why people do not go this way instead of using Access... seems like a better solution in terms future scalability if one is looking to eventually move SQL Server. Justin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 5:14 PM To: CF-Talk Subject: RE: mySQL vs. Access or MSDE Anyone have a feeling about the Microsoft Data Engine, which is supposed to be a limited connection version of SQL that can upscale to SQL very easily rather than Access? It is SQL Server, essentially, with some minor limitations. I've worked with it quite a bit, and like it for use instead of Access. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading only part of a really big text file...
(response to original message) Most of the UNIX tools have been ported to NT. Do a search on cygwin. Justin -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:12 PM To: CF-Talk Subject: Re: Reading only part of a really big text file... My .02... Simply put, cffile previous to MX is not the right tool for parsing large text files. MX might not be great depending on if they used any of Java's io buffering. I haven't put cffile in mx through a torture test yet, and I had to reinstall my machine with the preview release on it. If someone out there feels like doing some comparisons, I for one am really curious :) However parsing text is one of the most basic tasks in any language. You might want to take the oppurtunity to hone your Java skills in preparation for the brave new world we are entering... Check out this UDF for how to use Java's ability to treat a file as a stream allowing you to use CF to parse bite size chunks of the file. It probably isn't that speedy as it sits, but add a buffer and performace would go way up. However if you leave out the part where it concatenates the file into memory and just do your parsing in the loop, it will probably use a lot less memory than cffile alone would require. http://www.cflib.org/udf.cfm?ID=417 On the other hand, using SQL Server would be the easiest way to do this imho. jon - Original Message - From: Charles Nahm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 6:05 PM Subject: RE: Reading only part of a really big text file... -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] What, may I ask, are you trying to do with it? I guess analyze for patterns would be the best description. Basically just wanted to do text searches for key phrases. If you are trying to garner info out of it, may I suggest grep, sed awk, or perl? Depending on your need for searching. Are these Unix tools? We are running Windows 2K. If you need to query it as if it were data, do you have access to MSSQL and DTS? You could import the whole darn thing into a table. If you need to analyze the info in it (look for patterns and such), there are a number of free web log analysis tools out there. Thanks, I was not aware of this. Charles Nahm Sonic Networks Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mySQL vs. Access or MSDE (worm note)
The easiest way to avoid this is to close port 1433 in the firewall except from relevant IP addresses. We only allow connections from our office and if someone is offsite they have to either tunnel into the production environment or tunnel into the office to access the SQL servers. I would never leave critical services exposed from any WAN IP. Justin -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:30 PM To: CF-Talk Subject: Re: mySQL vs. Access or MSDE (worm note) What about Access 2002? Does it include MSDE and does it listen on port 1433 as a default? We started to see a lot of invalid logins to our SQL Servers last night I was thinking what kind of SQL Admin in their right mind would leave the sa password blank, certainly there can't be that many irresponsible SQL Admins out there, but if these are MSDE installations getting infected it makes more sense jon - Original Message - From: chad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 5:23 PM Subject: RE: mySQL vs. Access or MSDE (worm note) I should have mentioned it in my last post about the MS SQL worm. Starting with Access 2000, Microsoft began to ship a stripped down version of SQL Server called Microsoft SQLServer Desktop Edition (MSDE). It was not installed by default in an Access 2000 install, but was available as an add-on on the installation disks. If installed, no password is set for the SA account. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS SQL vs MySQL WAS: [admin] List status
Last time I checked it did not support refrential integrity, you enforce it manually. This and lack of stored procedure support is enough to keep me away (as much as I would like a free/cheap alternative). Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:57 PM To: CF-Talk Subject: Re: MS SQL vs MySQL WAS: [admin] List status I should have been more specific, but I mean in terms of features and not just speed. I use stored procs almost exclusively and thats my only main gripe about MySQL. -- Clint Tredway -- Through Him, anything is possible. What about the recent comparison in eWeek between MySQL, Oracl9i and SQL2k? MySQL was neck and neck with Oracle in response time and throughput, both better than SQL2k? I know that MySQL cannot really stand up to MS SQL but when you are talking about the amount that MS SQL costs versus using MySQL, I would us MySQL unless someone just wanted to pay for MS SQL. -- Clint Tredway -- Through Him, anything is possible. Can you say crap. :) I am not a big fan of MySQL. I have to do some work in it and it pales in comparison. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 5:19 PM To: CF-Talk Subject: Re: [admin] List status Can you say MySQL? g - Original Message - From: Margaret Fisk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 6:10 PM Subject: RE: [admin] List status Actually, we just priced this: It is about $5000 per cpu if you get SQL Server Standard edition and about 20,000 (not sure about this one) per cpu if you want Enterprise edition. The difference between the editions is failover and uptime tools. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: clustering Cold Fusion
I Have to agree. Hardware based clustering for the front end... and either SQL Enterprise or Veritas on the backend to handle the database cluster. Very solid configuration. We have been hardware clustering CF with Alteons for over 3 years. Just need to keep sessions in the DB and make sure the web boxes keep the file systems synched. Justin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 5:32 PM To: CF-Talk Subject: RE: Re[2]: clustering Cold Fusion SNIP Not necessarily. If you use hardware-based clustering, you can continue to use CF Professional. If you want to use software-based clustering, CF Enterprise provides ClusterCATS. I'd recommend hardware-based clustering, personally, if it's an option. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling server code without reloading
I just went through a few days of trying to figure this out and found that the only two ways were using a javascript to load a .gif and passing the parameters or using a hidden frame and dynamically changing the frame src. If you have control over the page you are submitting and can cause it return a .gif content type then the .gif method is the easiest. If you do not have control over the page then the hidden frame method will work the best as you will be able to confirm that the page is loaded. I have a URL at home on this that I will forward tonight as I cannot seem to find it from here. Justin -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 4:26 PM To: CF-Talk Subject: Calling server code without reloading Lets say I have a form field on a page. When I type in it, I want what I have typed to be sent to the server and something done to it. THe result of that something will come back to me and be loaded into a different form field. This should be done without reloading the page. Normally, I'd do this with a hidden frame and some javascript. I've been asked to do it some other way using layers, objects or other stuff. I'm researching it but I might as well ask if anyone here has heard of something in this area. Thanks Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Backup/Restore Question
If you do a full backup and truncate the logs and you can only restore from the most recent backup and then rolling forward the subsequent logs. If you do a full backup but do not truncate the logs, I do not think you will be able to roll the logs forward on a restore, but I have never tried. I would suggest testing this if it is part of the decision process. Justin p.s. I have never heard of the latter being possible. Have you actually done this with informix -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 2:27 PM To: CF-Talk Subject: OT: SQL Backup/Restore Question Recently someone told me something about MS SQL backup/restore that I would like to verify. I haven't been able to find anything in any books or on the MS site to clarify. So I thought I'd ask here for either a direct answer or a place to go search. The Scenario: Backups are done every night at midnight. In between, backups of the transaction logs are done every two hours. The question: It's Thursday. I need to restore my database, but the most recent backup (e.g., Wed night) is corrupt. Can I go back to the previous backup (e.g. Tue night) and apply all of the transaction logs through Thursday? Or would I only be able to apply them up until the Wednesday night backup? I've been told that MS SQL won't let me apply transaction logs for (in this example) Thursday unless I started with the Wednesday night backup. I know Informix would allow me to apply all of the logs. We're about to switch to MS SQL and I want to be sure we set up the appropriate backup procedures. Any thoughts on how I could get to the bottom of this would be appreciated. Athelene Gieseman [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I let the ColdFusion server wait between two commands
The problem with all the solution except this one is that they tie up a connection on the server, which is the last thing you want to do. Better to put the pause on the client side or have the client keep checking whether the task is complete. Perhaps with a simple META REFRESH to check for the file. Justin -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 9:34 AM To: CF-Talk Subject: RE: How do I let the ColdFusion server wait between two commands Or better yet, cfscript function sleep(timeMillis) { var thread = createObject(java, java.lang.Thread); thread.sleep(timeMillis); } /cfscript Haven't tested it yet, but that should work. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 9:23 AM To: CF-Talk Subject: RE: How do I let the ColdFusion server wait between two commands There is a custom tag for this. CFX_SLEEP SLEEPTIME=3 Rick -Original Message- From: Broek, ir. M.A. van den [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 6:43 AM To: CF-Talk Subject: How do I let the ColdFusion server wait between two commands Hello, I would like to zip a few files with cfexecute and then redirect to this zip file (see code below). The ColdFusion server has two wait a few seconds before the cflocation is executed, because it takes some time to zip the files. How can I accomplish that? Thank you, Machteld cflock timeout=15 throwontimeout=Yes name=zipper type=EXCLUSIVE cfexecute name = D:\Progra~1\WinZip\wzzip.exe arguments = E:\ArcIMS\Output\#ID#.zip #LocationDir#\#ID#.* /cfexecute /cflock cflocation url=http://#Session.ServerName#/Output/#ID#.zip; __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL case insensitive search ???
Just to be safe I would probably recommend WHERE lower(searchfield) LIKE lower('%he%') however, anytime you perform an evaluation on the left side of the = you force a table scan, which can create performance issues. This is the problem with trying to do case insensitive searches in a DB that was installed case sensitive. If you need to be case insensitive I suggest reinstalling the DB in this mode and reloading your data. Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 11:46 AM To: CF-Talk Subject: RE: SQL case insensitive search ??? Use a string function to force the search field to the same case as the search string: WHERE lower(searchfield) LIKE '%he%' Example '%he%' finds 'the' but not 'THE' I would like to find regardless of case... How is that done? At 09:38 PM 3/14/02 -0800, you wrote: it should be case insensitive to begin with? All '%searchString%' does is cause your query to table scan the whole table since the wildcard is in front. J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 9:36 PM To: CF-Talk Subject: SQL case insensitive search ??? how does one go about structuring a case insensitive search on a text field in a database? Currently using WHERE Table.FieldName LIKE '%searchString%' Thanks, Brian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: weird sql error
How about the missing comma in the Values part of your query... looks like a temp stored procedure is being created and choking between parameters 10 and 11. Justin -Original Message- From: Jen Perkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:38 PM To: CF-Talk Subject: weird sql error I keep getting a really strange sql error and I don't know what the heck it's coming from. === DETAIL: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 33: Incorrect syntax near '@P11'. SQL = SET NOCOUNT ON INSERT INTO images ( archiveFlag, approvalTypeID, deletedFlag, imageExtensionID, contentTypeID, addedBy, modifiedBy, dateAdded, dateModified, mediaFilesize, mediaHeight, mediaWidth, filename, title, alt, caption) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, ?, ?, ?, ?, ?) SET NOCOUNT OFF SELECT @@IDENTITY AS newID Query Parameter Value(s) - Parameter #1 = 0 Parameter #2 = 10 Parameter #3 = 0 Parameter #4 = 0 Parameter #5 = 112 Parameter #6 = 100 Parameter #7 = 100 Parameter #8 = {ts '2002-03-14 10:51:32'} Parameter #9 = {ts '2002-03-14 10:51:32'} Parameter #10 = 153654 Parameter #11 = 0 Parameter #12 = 0 Parameter #13 = 9906-feeding_031402_105132.bmp Parameter #14 = test Parameter #15 = Parameter #16 = === I've done a cf_dump of all the variable scopes and I can't figure out where this @P11 is coming from. Anyone run across something like this before? Jen Perkins Macromedia Certified ColdFusion Developer Carol/Trevelyan Strategy Group http://www.ctsg.com/ Kumbaya, Dammit! http://www.kumbayadammit.com/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTransactions and SQL Transactions?
I would also like to point out that whenever you are dealing with transaction you INCREASE the possibility of incurring deadlocks and general slowdown because the lock manager overworking. You need to keep transactions short and keep a close eye on the what is happening inside of the transaction as everything you do will create some form of lock on the effected table. Putting the transaction on the CF level seems to be asking for trouble to me. Chances are the transaction does not need to encapsulate the whole procedure. Justin -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 11:58 AM To: CF-Talk Subject: RE: CFTransactions and SQL Transactions? In my experience, this would be better done in a single stored procedure call (which would then call any other required stored procs). SQL Server supports nested transactions, so each of your 'child' stored procs can also use transactions if required. If you are writing this from scratch, put as much logic as you can into the stored procs (afterall, the database server is meant to handle data for you, whereas your web server is meant to present web pages). As for CFTRANSACTION, we are unclear on how it could handle a rollback if you have stored procs within it that have committed their SQL Transactions. Until I hear more, I'm recommending to my team to NOT use CFTransaction for that reason. The data for our current app is critical, and we have to stick with methods we know to work well. Let me know if you hear any more on this. I'm not getting the impression that I'll see lots on this from the list. Shawn Grover -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 5:48 AM To: CF-Talk Subject: RE: CFTransactions and SQL Transactions? Shawn, I don't have an answer but am anxiously awaiting one. I have a case where in order to get some records into our SQL database I execute a SP to enter a blank record and then call several SP's to update different fields in the record with values. I need to wrap this in a cftransaction and am just trying to gather some more information before doing it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 3:03 PM To: CF-Talk Subject: CFTransactions and SQL Transactions? This is a repost cuz I think I got lost in the shuffle on Friday, and no-one has responed yet. TIA. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:54 AM To: CF-Talk Subject: CFTransactions and SQL Transactions? I'm looking for more information about using CFTransaction. My personal opinion is that it's better to use SQL Server transactions within our stored procedures (cuz we are using SQL 2000 as our back end), and transfer as much business logic as possible to the stored procs. However, in a few cases, we've seen the requirement for something like this: cftransaction action=BEGIN cfstoredproc/cfstoredproc cfif somecondition cfstoredproc/cfstoredproc cfelse cfstoredproc/cfstoredproc /cfif /cftransaction My concerns are that this may cause problems if the stored procedures themselves contain transaction processing. And I need to make a recommendation based on solid information on whether to allow this process, or force the developers to take the time to wrap this logic within one stored proc call. (of course, they can call existing stored procs from within a stored procedure, and check the return codes to determine if a rollback needs to happen before processing is complete). So, any suggestions? Thanks in advance. Shawn Grover __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anybody heard of this?
You can write to the registry on IE with a signed applet so make sure that you are set to warn you before running such things. This is probably what happened. Justin -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 9:26 AM To: CF-Talk Subject: Re: Anybody heard of this? -- Spamex - Forums Now Available http://forums.spamex.com/forums/ -- Replies will be sent to [EMAIL PROTECTED] -- Additional Info: http://www.spamex.com/i/?v=52 Thanks John. When these scum bags hit, it makes me wish I could send about 10K volts through the net to their servers! LOL POW! Blast 'em into a billion pieces!8-) Dave - Original Message - From: John Cummings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 05, 2002 8:51 AM Subject: RE: Anybody heard of this? Dave, Found this on Google, though I didn't have the key (probably a different version of IE): [HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Control Panel] Double-click the HomePage value and change it to 00 00 00 00 Also, you can manually change the start page back via the reg by going to HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main and changing the value of Start Page to whatever you want it to be. HTH, JC -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 8:42 AM To: CF-Talk Subject: OT: Anybody heard of this? I has some spam in my email this morning. It immediately popped me to a porn site. What it did though, was reset my start page through their server, and I now, cannot reset my start page. It's greyed out. The URL of this scum company is: http://www.duolaimi.net (don't click on the URL) My start page URL now looks like http://www.duolaimi.net/d.asp?http://myURLhere.com If I go into Internet Options, it does not allow me to change the Start Page settings. What's the fix for this? Anybody know? Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFStoredProc vs CFQUERY
Do not know about speed, but access to output parameters and the ability to trap an error (i.e. detect that an error code was returned) are in themselves worth it. Justin -Original Message- From: Steven Durette [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 11:01 PM To: CF-Talk Subject: Re: CFStoredProc vs CFQUERY Thanks for the info, does anyone know if one is faster than the other? Steve - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 8:29 PM Subject: RE: CFStoredProc vs CFQUERY Use the CFPROCRESULT name=MyQueryObject inside the CFSTOREDPROC tags (normally the last one specified)... Using cfstoredproc tags eliminates a bunch of errors - in the CFQuery call, how do you know the Date is a proper format? the cfprocparam tags handle any neccessary conversion (within reason) for you. Also, with cfstoredproc, you can have multiple recordsets returned, and have access to the Stored Procedures return value. You can't do that with CFQuery. Shawn Grover -Original Message- From: Steven Durette [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 6:15 PM To: CF-Talk Subject: CFStoredProc vs CFQUERY I was just wondering if any one knew the difference between the following: CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO dbVarName = @param2 CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABL= BAR dbVarName = @param3 /CFSTOREDPROC AND THIS: CFQUERY Name=qryMyQuery DATASOURCE=mydatasource {CALL usp_myproc(01/23/1971, 31)} /CFQUERY Also, when the stored procedure returns a query, how would you access it through the first method? The second method at least allows you to name the query so that you can access the resulting recordset. Thanks, Steve Durette Database Administrator/Web Developer Engineering/Construction System Support SBC/Ameritech __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Speeding up select queries
It will be far more efficient to do the whole query in SQL rather than creating 2 queries in CF. Let SQL do the work, it is very good at it. I suspect that you IN clause is causing the Query optimizer to have problems determining which index to use which is why you are seeing a huge difference in run time between the query with or without the ZIP list. You need to look at the plan for both queries and see which indexes it is using (the latter may be forcing a table scan). You can force the use of the right index as part of your query, just make sure you are using the right one. Converting this to a Stored procedure will save in little time as it will not have to compile the procedure every time it is run, but it may make the IN clause hard to pass (though in General I always recommend using stored procedures over pass through SQL. I would also change the nested queries to joins. Maybe something like... SELECT O.FileNo, O.Order_ID, O.Appraiser_ID, O.HouseNo, O.Street, O.UnitNo, O.City, O.County, O.State_ID, O.Date_Ordered, O.time_ordered, O.Appt_Date, O.Appt_Time, O.AMorPM, O.Lender_ID, O.Zip, S.State AS State, L.Lender AS ClientID FROMT_Orders O, T_States S, T_Lenders L WHERE StatusType_ID = 3 AND Appt_Time #DateAdd(h, -48,#Now()#)# AND O.StateID = S.StateID AND O.Lender_ID = L.Lender_ID AND O.Zip IN (#ziplist#) Justin -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 12:13 PM To: CF-Talk Subject: RE: Speeding up select queries If you are using CF5, why not do this in 2 queries. Query the database and then query the query. cfquery name=getalllateorders datasource=#AppDSN# SELECT FileNo, Order_ID, Appraiser_ID, HouseNo, Street, UnitNo, City, Cou nty, State_ID, Date_Ordered,time_ordered,Appt_Date,Appt_Time,AMorPM, Lender_ID , Zip, (SELECT State FROM T_States WHERE State_ID = O.State_ID) AS State, (SEL ECT Client_ID FROM T_Lenders WHERE Lender_ID = O.Lender_ID) AS Client_ID FROM T_Orders O WHERE StatusType_ID = 3 AND Appt_Time #DateAdd(h , - 48,#Now()#)# /cfquery cfquery name=getlateorders dbtype=query Select * from getalllateorders Where Zip IN (#ziplist#) /cfquery This way you are only selecting zips from a much smaller recordsource. Should be much faster. -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:55 AM To: CF-Talk Subject: RE: Speeding up select queries This query takes about 47ms to execute, which I can live with that: cfquery name=getlateorders datasource=#AppDSN# SELECT FileNo, Order_ID, Appraiser_ID, HouseNo, Street, UnitNo, City, Cou nty, State_ID, Date_Ordered,time_ordered,Appt_Date,Appt_Time,AMorPM, Lender_ID , Zip, (SELECT State FROM T_States WHERE State_ID = O.State_ID) AS State, (SEL ECT Client_ID FROM T_Lenders WHERE Lender_ID = O.Lender_ID) AS Client_ID FROM T_Orders O WHERE StatusType_ID = 3 AND Appt_Time #DateAdd(h , - 48,#Now()#)# /cfquery BUT when I add this to the same query: AND Zip IN (#ziplist#) It takes anywhere from 45 to 50 seconds to execute. ziplist is a variable taken from a session.ziplist that contains the user's authorized zipcodes. It j ust started going slow, maybe there is a threshold after so many zipcodes are in the list it will slow things down tremendously ? Quoting Sandy Clark [EMAIL PROTECTED]: General rules of thumb I use. Avoid Select * always specify your fields. Fastest is to select fields in the following datatype order, integers, numeric, strings according to field size. Memo or Long text fields are always last. The latter one is most important because all fields selected after a long text field will load as unbound fields and will slow the sql way down. -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:22 AM To: CF-Talk Subject: Speeding up select queries What is the best approach to speed up select statements with a sql2000 database? The data is constantly being updated,deleted,inserted, throug h out the day with each user seeing data depending on his/her access level an d assigned zip codes. I worry that using cachedwithin will not work in this senario, as using that will not allow to show data that has recently changed. ANY help, thoughts much appreciated. -- - - -- Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ Get Your
RE: CFContent (and other options)
I would look at http://www.apache.org. I believe the API is fairly well documented. When modules are loaded they are put onto an internal stack. Each page request is passed to the module at the top of the stack which looks at the request, handles or does not handle it and then passes it to the next module flagging whether it processed or not. The last module loaded is the first to receive requests if I remember correctly. When your module sees a request, you can look at pretty much anything in the request to determine if the module should handle it. This lets you intercept any page request, not just specific extensions, if desired. You can also preprocess a page, but not flag it and then it will get processed again by the appropriaste module. We have used this for a few things: 1. A cookie redirector - any page that does not have a cookie automatically self-redirects and sets a cookie. If the second request does not have a cookie, we know the browser does not support cookies. 2. Intercepting of pages - prototype in Cold Fusion, then when speed is needed, write a module to handle the one page and intercept the cold fusion request. 3. Just plain writing of modules that handle things faster than Cold Fusion. Justin -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 8:22 AM To: CF-Talk Subject: RE: CFContent (and other options) Hi Justin, This sounds really interesting. Can you point me to a reference where I can learn how to build an apache module like the one you made? --- Justin Greene [EMAIL PROTECTED] wrote: We created an apache module for doing this. We intecept the .CFM request, check if it is the CFCONTENT page and if not, pass the request to Cold Fusion, if so, we handle the user authentication and return of data in the module. This allowed us the flexibility of building in Cold Fusion with the performance of using a C++ module when we needed the speed. Our throughput, including a single database call, went from about 23 connections/sec in CF to 160 connections/sec with the module. Justin -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:36 PM To: CF-Talk Subject: RE: CFContent (and other options) What do you use instead? I've been doing some testing with the different tags and this is what I came up with: meta tag is very difficult to backup from. The users look/print the pdf then have to double click the back button. And after making a few reports the thing locks up/won't back up and they have to log in again. embed works great on the PC, but not for the mac or on our wireless. On the mac you can't read the pdf in the browser and then it prints out funny (ie: losing it's landscape formatting). Also it wouldn't pull up the bulk pdfs (over 20pgs)just the individual ones (we're doing report cards-it'll pull up individual ones but not for a whole class). It doesn't work on the wireless either. cfcontent works on almost everything, but the wireless and the few machines. On the wireless we get a msg about the index24 What's the better thing to use -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:09 PM To: CF-Talk Subject: RE: CFContent I've run into the same problem and oddly enough, it was with a 98 machine. My solution, and I don't know if this is the right answer but it worked, I told the user to uninstall their current version of Acrobat Reader and re-install Acrobat Reader 5. This worked for anyone who had the problem. I've since gone away from cfcontent as I experienced inconsistent results with that bastard of a tag. Mark -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:00 PM To: CF-Talk Subject: CFContent I'm using CFCONTENT to call a pdf form- It does fine on MAC IE and most pc IE and Netscape. However, on one browser a 98 machine with IE5.5 I can't get the pdf to show. Instead there is the box and the msg says Error Locating Object Handler There is no viewer available for the type of object you are trying to open. The following informantion is available about this object. Address: http://blahblah Content type: text/html Possible location of viewer: Microsoft ActiveXGallery I took the Ben Forta advice and checked the Folder Options in Tools of Windows Explorer. I went over it piece by piece comparing it to the settings of a browser that worked- I didn't see any differences. This browser has opened pdfs when I used the meta tag and the embed tag so I know that it does open pdfs...any suggestions? Thanks in advance, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http
RE: 3 selects related and nightmare trees
The below piece is from the SQL books online and provides a sample of handling expanding heirarchies. This may be what you are looking for (though it will probably only work in SQL, not access)... Expanding Hierarchies Databases often store hierarchical information. For example, the following data is a hierarchical representation of regions of the world. This representation does not clearly show the structure implied by the data. Parent Child -- -- World Europe World North America Europe France France Paris North America United States North America Canada United States New York United States Washington New York New York City Washington Redmond This example is easier to interpret: World North America Canada United States Washington Redmond New York New York City Europe France Paris The following Transact-SQL procedure expands an encoded hierarchy to any arbitrary depth. Although Transact-SQL supports recursion, it is more efficient to use a temporary table as a stack to keep track of all of the items for which processing has begun but is not complete. When processing is complete for a particular item, it is removed from the stack. New items are added to the stack as they are identified. CREATE PROCEDURE expand (@current char(20)) as SET NOCOUNT ON DECLARE @level int, @line char(20) CREATE TABLE #stack (item char(20), level int) INSERT INTO #stack VALUES (@current, 1) SELECT @level = 1 WHILE @level 0 BEGIN IF EXISTS (SELECT * FROM #stack WHERE level = @level) BEGIN SELECT @current = item FROM #stack WHERE level = @level SELECT @line = space(@level - 1) + @current PRINT @line DELETE FROM #stack WHERE level = @level AND item = @current INSERT #stack SELECT child, @level + 1 FROM hierarchy WHERE parent = @current IF @@ROWCOUNT 0 SELECT @level = @level + 1 END ELSE SELECT @level = @level - 1 END -- WHILE The input parameter (@current) indicates the place in the hierarchy to start. It also keeps track of the current item in the main loop. The two local variables used are @level, which keeps track of the current level in the hierarchy, and @line, which is a work area used to construct the indented line. The SET NOCOUNT ON statement avoids cluttering up the output with ROWCOUNT messages from each SELECT. The temporary table, #stack, is created and primed with the item identifier of the starting point in the hierarchy, and @level is set to match. The level column in #stack allows the same item to appear at multiple levels in the database. Although this situation does not apply to the geographic data in the example, it can apply in other examples. In this example, when @level is greater than 0, the procedure follows several steps: If there are any items in the stack at the current level (@level), the procedure chooses one and calls it @current. Indents the item @level spaces, and then prints the item. Deletes the item from the stack so it won't be processed again, and then adds all its child items to the stack at the next level (@level + 1). This is the only place where the hierarchy table (#stack) is used. Note With a conventional programming language, you would have to find each child item and add it to the stack individually. With Transact-SQL, you can find all child items and add them with a single statement, avoiding another nested loop. If there are child items (IF @@ROWCOUNT 0), descends one level to process them (@level = @level + 1); otherwise, continues processing at the current level. Finally, if there are no items on the stack awaiting processing at the current level, goes back up one level to see if there are any awaiting processing at the previous level (@level = @level - 1). When there is no previous level, the expansion is complete. -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday,
RE: CFContent (and other options)
We created an apache module for doing this. We intecept the .CFM request, check if it is the CFCONTENT page and if not, pass the request to Cold Fusion, if so, we handle the user authentication and return of data in the module. This allowed us the flexibility of building in Cold Fusion with the performance of using a C++ module when we needed the speed. Our throughput, including a single database call, went from about 23 connections/sec in CF to 160 connections/sec with the module. Justin -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:36 PM To: CF-Talk Subject: RE: CFContent (and other options) What do you use instead? I've been doing some testing with the different tags and this is what I came up with: meta tag is very difficult to backup from. The users look/print the pdf then have to double click the back button. And after making a few reports the thing locks up/won't back up and they have to log in again. embed works great on the PC, but not for the mac or on our wireless. On the mac you can't read the pdf in the browser and then it prints out funny (ie: losing it's landscape formatting). Also it wouldn't pull up the bulk pdfs (over 20pgs)just the individual ones (we're doing report cards-it'll pull up individual ones but not for a whole class). It doesn't work on the wireless either. cfcontent works on almost everything, but the wireless and the few machines. On the wireless we get a msg about the index24 What's the better thing to use -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:09 PM To: CF-Talk Subject: RE: CFContent I've run into the same problem and oddly enough, it was with a 98 machine. My solution, and I don't know if this is the right answer but it worked, I told the user to uninstall their current version of Acrobat Reader and re-install Acrobat Reader 5. This worked for anyone who had the problem. I've since gone away from cfcontent as I experienced inconsistent results with that bastard of a tag. Mark -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:00 PM To: CF-Talk Subject: CFContent I'm using CFCONTENT to call a pdf form- It does fine on MAC IE and most pc IE and Netscape. However, on one browser a 98 machine with IE5.5 I can't get the pdf to show. Instead there is the box and the msg says Error Locating Object Handler There is no viewer available for the type of object you are trying to open. The following informantion is available about this object. Address: http://blahblah Content type: text/html Possible location of viewer: Microsoft ActiveXGallery I took the Ben Forta advice and checked the Folder Options in Tools of Windows Explorer. I went over it piece by piece comparing it to the settings of a browser that worked- I didn't see any differences. This browser has opened pdfs when I used the meta tag and the embed tag so I know that it does open pdfs...any suggestions? Thanks in advance, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: SPAM lists?
It is so funny to see this discussion keep cropping up. The whole blacklisting of open relays is a very touchy issue. I agree that there is little excuse for running an open relay in today's world (though some argue that it is their right... I think this was an issue in MIT vs. MAPS). I will not agree however that running one makes you ignorant. I have been blacklisted and not notified. The blacklist claims that it is not their responsibility to let me know that I was listed. Turns out that the mail server we were using (post.office) has few bugs (or holes) in it's relay filtering and that the only way to prevent it from being used as an open relay is to IP restrict who can connect. This is contrary to the documentation. I only found out about this because a users mail was being rejected and I was able to get a copy of the test that had failed and confirm the bug. This information in hand I resolved it. It have been nice to know I had failed though so that it could have been resolved sooner, this would have been even more effective than blocking me. MAPS has basically been put out of business by getting sued over this issue (I think it was the legal costs though, not the settlements that killed them). It will probably not be long before the others follow suit (no pun intended). The Internet is a collection of private networks and it is within the rights of the owner of every single network to decide who may and may not pass traffic across their backbone, so if they want to subscribe to an ORB, it is their right, however you block someone with deep pockets and you are in for an expensive fight, right or not. my $.002 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Searching for ' with like clause with SQL Server
Just came across something interesting that I thought I would pass along. We were writing a query along the lines of select * from column where value like 'o'brien' This of course will not work and needs to be select * from column where value like 'o''brien' however this was not working either. After much head beating and hair pulling we realized that our data was imported from word and used ´ rather than ' so the query needed to read select * from column where value like 'o[''´`]brien' to actually find the data. Of course it would have been nice if the data was just clean. Hope this saves someone some grief one day :-) Justin ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apache 1.3
This is usually related to the machine failing to resolve it's own hostname. Not having the DLL loaded should not stop apache from starting. Try starting from the command line to see what error it gives you and if it hostname related, make an entry in your hosts file to fool it. Also, on W2K you do not need the addmodule directive. Just the loadmodule.\ Justin -Original Message- From: Iceraven [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:14 AM To: CF-Talk Subject: Re: Apache 1.3 Could you tell me what you put in your HTTpd.conf to make this work? I get Failed to restart the apache service. loadmodule coldfusion_module modules/mod_coldfusion.dll then addmodule mod_coldufsion.c - Original Message - From: Tracy Bost [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 12:06 AM Subject: Re: Apache 1.3 The dll has worked fine for me on w2k. The shared object(so) is for the *nix platforms. - Original Message - From: Iceraven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 11:41 PM Subject: Apache 1.3 the Coldfusion dll that comes with this appears to be bad, someone have a .so that works for coldfusion 4.5 on windows 2k? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Truncate Log on Checkpoint (was Large SQL log file)
It was an oversimplification. Didn't feel like typing then, don't mind now... the problem with truncate logs at checkpoint is that you will only be able to restore until the time of the last backup as there will be no transaction logs to roll forward to get you completely up to date. Any database that is worth backing up, probably should not use this feature, with the caveat that if you have to do a mass bcp or select into, you may want to use it temporarily to prevent filling the transaction logs and then when finished, turn it off and run a full backup immediately so that the transaction log dumps will work again. This of course gets into a discussion of backup strategies and how often to run full backups and log dumps. We typically do daily full backups and dump the logs every 15 minutes. As the db gets bigger the full backups take longer and longer and one may want to do them less and look for slow times. Justin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 10:30 AM To: CF-Talk Subject: RE: Large SQL log file If you are speaking of your transaction log, you will need to schedule more frequent backups or dump the transaction logs periodically. If you set your database to truncate on checkpoint, it will also prevent the logs from growing, however you will eliminate your ability restore a damaged database from backup. If I understand correctly, this isn't exactly true - it's an oversimplification. You can still restore databases from backup, whether you're truncating logs on checkpoint or not. If you truncate logs on checkpoint, you can't restore the database from just the transaction log itself. I can guarantee that we wouldn't use the option if it meant you couldn't restore your databases! You're right to point out, though, that using this setting does restrict the ways in which you can backup and restore your databases, and probably shouldn't be selected without that consideration. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Large SQL log file
If you are speaking of the error log, you can use set how many error logs to keep in the registry and set SQL Agent to rotate them daily, weekly, whatever. I do not remember the syntax but it is in the Microsoft knowledgebase. We are set to keep 30 days and we rotate daily. Makes for nice small logs that are easy to read. If you are speaking of your transaction log, you will need to schedule more frequent backups or dump the transaction logs periodically. If you set your database to truncate on checkpoint, it will also prevent the logs from growing, however you will eliminate your ability restore a damaged database from backup. Justin -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 7:07 PM To: CF-Talk Subject: OT: Large SQL log file Hello all I have an SQL.log file that has grown to approx 2GB. How do I reset the options for this file/Delete it? I have looked in the SQL manager, but cant seem to find were the settings are. I would like to limit what is being logged and to decrease the size of the file itself. Thanks for the help ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
After a few conversations MM agreed to compile it and said it would be available in a few weeks. That was at the end of August. I have asked for an update but have not gotten a reply. Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:25 PM To: CF-Talk Subject: RE: cf and apache Actually, now that you mention it, I forgot about that EAPI thing going on. I get the error on startup (only when using the OpenSSL compiled version) about the module, but it's been running fine and we've been hitting it pretty hard. What's the latest on the replacement module? Which version of apache are you running and what platform? I have found that SSL on win32 with 1.3.20 apache required an EAPI Cold Fusion module and MM has not yet made it available (though they said that they would after the discussions on the list and some back and forth with their support people). Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 22, 2001 9:43 PM To: CF-Talk Subject: RE: cf and apache Works great with SSL too. No problems. It was a little tricky setting it up the first time, but I'm using OpenSSL with no issues. And of course, the first time, I was trying to import certificates created with Netscape server. THAT was a fun thing to do. Works great so long as you do not need SSL. Been running it for almost 3 years without a problem. -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:53 AM To: CF-Talk Subject: cf and apache How much experience do people have with CF and Apache? Anything to be aware of if switching from IIS. We are just about to buy a new box and with all these nightmares people are having with nimba etc thought it might be a good idea. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
Correct. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 11:43 AM To: CF-Talk Subject: RE: cf and apache For the windows version of the module? -jesse -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 11:16 AM To: CF-Talk Subject: RE: cf and apache After a few conversations MM agreed to compile it and said it would be available in a few weeks. That was at the end of August. I have asked for an update but have not gotten a reply. Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:25 PM To: CF-Talk Subject: RE: cf and apache Actually, now that you mention it, I forgot about that EAPI thing going on. I get the error on startup (only when using the OpenSSL compiled version) about the module, but it's been running fine and we've been hitting it pretty hard. What's the latest on the replacement module? Which version of apache are you running and what platform? I have found that SSL on win32 with 1.3.20 apache required an EAPI Cold Fusion module and MM has not yet made it available (though they said that they would after the discussions on the list and some back and forth with their support people). Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 22, 2001 9:43 PM To: CF-Talk Subject: RE: cf and apache Works great with SSL too. No problems. It was a little tricky setting it up the first time, but I'm using OpenSSL with no issues. And of course, the first time, I was trying to import certificates created with Netscape server. THAT was a fun thing to do. Works great so long as you do not need SSL. Been running it for almost 3 years without a problem. -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:53 AM To: CF-Talk Subject: cf and apache How much experience do people have with CF and Apache? Anything to be aware of if switching from IIS. We are just about to buy a new box and with all these nightmares people are having with nimba etc thought it might be a good idea. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apache vs IIS speed on Windows
I ran tests on Apache 1.12 on windows NT 4.0/sp 5 on a dual PIII 600 with 256MB ram. Serving a .5K file it was able to push about 750 pages/sec. Serving a 14K file it dropped to about 525 pages/sec, but I also noted that the 100MB network was saturated. Probably was bottlenecking the LAN (I think this works out to about 60Mbits not counting network overhead). I never got to the follow up test which were to deliver a .CFM page with only HTML in it (test the speed of the Cold Fusion module and test a .CFM page with a database call that does nothing. Also did not get to test the other web servers (website and IIS and Apache on Linux) as intended. Justin -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:27 PM To: CF-Talk Subject: Apach vs IIS speed on Windows We all know the security concerns and what not, but what is a speed comparrison between the two. Like how many pages per second can I expect Apache to have and how many can I expect IIS to have. I would like to use Apache but not if it is gonna hurt me speed wise. I stay on top of the security issues by unmapping everything but CFM. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
Which version of apache are you running and what platform? I have found that SSL on win32 with 1.3.20 apache required an EAPI Cold Fusion module and MM has not yet made it available (though they said that they would after the discussions on the list and some back and forth with their support people). Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 22, 2001 9:43 PM To: CF-Talk Subject: RE: cf and apache Works great with SSL too. No problems. It was a little tricky setting it up the first time, but I'm using OpenSSL with no issues. And of course, the first time, I was trying to import certificates created with Netscape server. THAT was a fun thing to do. Works great so long as you do not need SSL. Been running it for almost 3 years without a problem. -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:53 AM To: CF-Talk Subject: cf and apache How much experience do people have with CF and Apache? Anything to be aware of if switching from IIS. We are just about to buy a new box and with all these nightmares people are having with nimba etc thought it might be a good idea. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
Works great so long as you do not need SSL. Been running it for almost 3 years without a problem. -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:53 AM To: CF-Talk Subject: cf and apache How much experience do people have with CF and Apache? Anything to be aware of if switching from IIS. We are just about to buy a new box and with all these nightmares people are having with nimba etc thought it might be a good idea. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf and apache
The most recent win32 release (1.3.20) is considered initial release quality and it works great. Never a problem. Justin -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 10:29 AM To: CF-Talk Subject: RE: cf and apache Apache does not officialy support Apache Web Server on windows. Apache was designed for Unix from the ground up, it is just incredibly portable so it made its way to windows. Consider it (really good) beta quality software. Jeremy Allen elliptIQ Inc. -- http://www.neighborware.com America's Leading Community Network Software -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 1:05 PM To: CF-Talk Subject: Re: cf and apache I love it, and use it on my development machine. Although if memory serves me... there were some problems with scalability on Windows units. I can't speak from experience, nor can I point to numbers though. At 02:53 PM 09/21/2001 +0100, you wrote: How much experience do people have with CF and Apache? Anything to be aware of if switching from IIS. We are just about to buy a new box and with all these nightmares people are having with nimba etc thought it might be a good idea. Ben -- Ben Whalley, Radley Yeldar 326 City Road, London, EC1V 2SP -- 0207 7130038 [EMAIL PROTECTED] www.ry.com -- --- * This message has been processed by MailGuard SMTP from NET-TEL * Computer Systems Ltd. See http://www.mailguard.co.uk. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DNS Question
skillpath.com. IN AYour IP address www IN AYour IP address note the . at the end of the first that is not at the end of the second. Also need to make sure the web server will respond to both. Justin -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:52 PM To: CF-Talk Subject: DNS Question A little off topic, but can anyone please tell me how in the world you set up DNS so that the user does not have to enter WWW. Instead of www.skillpath.com they can just enter skillpath.com and the name is resolved. Thank You, Christian ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: case sensitive sql query
If I remember correctly, when MS SQL Server is installed one determines whether the DBs will be case sensitive or case insentitive. If the former is selected, you have to cast or convert everything to upper or lower case when doing compares as 'a' != 'A'. This of course forces table scans as placing any sort of evaluation on the left side of the = prevent the use of an index and you cannot force an index to be case insensitive (I think you can do this in Oracle). I suspect that the reverse is true in the below example. If you are casting your varchar as case sensitive, it may not be able to use the indexes properly. I am not positive, but it is worth looking into if the tables are large as it will cause a performance hit. Justin -Original Message- From: Alex Santantonio [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 9:59 AM To: CF-Talk Subject: RE: case sensitive sql query SQL Queries ARE NOT case sensitive when doing a WHERE that involves a varchar. The way to do a Case sensitive WHERE clause depends largely on the database that you are using. If you are using SQL Server 7/2000 then it is quite simple. It is even more simple if you are using Stored Procedures to perform this task. Just use CAST to force your value to binary data and then compare based on the returned binary data. CAST(ColumnName AS VARBINARY(ColumnLength)) = CAST('Test Query' AS VARBINARY(ColumnLength)) in your WHERE within your Stored Procedure. Once you have that set, just make the 'Test Query' string in your Stored Procedure into a @sp_variable and pass in the value you are searching on. CAST is preferred over CONVERT. Alex Santantonio, Lead Developer Macromedia Coldfusion 5 Certified Professional Macromedia Certified Web Site Developer [EMAIL PROTECTED] www.doceus.com -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 9:11 AM To: CF-Talk Subject: Re: case sensitive sql query SQL SELECT queries ARE case sensitive. The problem is in your data -- you're using columnames from your tables as data. Depending on the database, this information is stored in auxiliary tables (in Oracle, it would be in a table like all_tab_columns), and may be in a case-insensitive form. For example, in Oracle, if I run select column_name, table_name from all_tab_columns then I see that all the column_names and table_names are all uppercase even though when I created the tables, I had mixed case for the table and column names --- Bernd VanSkiver [EMAIL PROTECTED] wrote: Is there a way to do a case sensitive SELECT query? Don't want to make a server wide change, just want to specify a single query to do a case sensitive search. SELECT ColumnName FROM tableName WHERE ColumnName = 'Test Query' Want this to do a case sensitive search on the WHERE clause. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Speak Up (WAS: Macromedia strong arms developers into 5.0 upg rade)
Matt, I had another conversation with MM yesterday with Dave Emmon (sic?) and I pointed out that the EAPI for apache was not supported in CF 5 either and was told that MM considers Win32 apache to be beta software and does not support beta software, but that they are having a meeting on Friday and he will bring it up. I was also told that Win32 apache does not have much of a user base because of it's beta status and that when 2.0 is out of beta it will be supported. I take the lack of support for beta software and the small user base as positioning statement and an attempt to set expectation. I would like to point out (and maybe you can be in the meeting) that the manual does contains installation instructions for apache and does not say anything about it being beta and unsupported. Originally I was annoyed by being told that an EAPI build was not going to be made for 4.x, that module source for win32 would not be made available and that I should upgrade to CF 5 to solve my problem. Now I find that an upgrade would make no difference and am being told that Apache is actually considered unsupported beta code. I do not know what the politics are behind the lack of support for Win32 apache developers but it seems foolish from a marketing perspective. Oh, one more point, EAPI has been available since long before apache 1.3.20, I just never ran into the issue before as I had not tried to deploy SSL, which requires it. Some snippets from the changes file (not the reference to cold fusion in the first): Changes with mod_ssl 2.1.8 (11-Jan-1999 to 21-Jan-1999): But we now to the following: We allow _both_ types of modules to be loaded by mod_so, but dispatch over the EAPI hooks only when the module magic cookie indicates EAPI. This way an Apache+EAPI server can load module DSOs built with a plain Apache. That's important to allow people for instance use mod_coldfusion (which is available only as a pre-built DSO!) or allow the Debian package maintainers to finally build their Apache package with EAPI without the need to upgrade all other module packages at the same time. Changes with mod_ssl 2.4.7 (22-Oct-1999 to 02-Nov-1999) *) Added a check to mod_so to complain with a warning if one loads a plain Apache 1.3 DSO under EAPI (which might work, but can also segfault). Changes with mod_ssl 2.8.0 (14-Oct-2000 to 30-Jan-2001) *) Upgraded to Apache 1.3.17 as base version. *) Changed ApacheModuleSSL.dll to mod_ssl.so in Makefile.Win32 to make mod_ssl not too broken after Apache 1.3.16's Win32 changes. Justin -Original Message- From: Matt Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:47 AM To: CF-Talk Subject: Re: Speak Up (WAS: Macromedia strong arms developers into 5.0 upgrade) -- Spamex - Forums Now Available http://forums.spamex.com/forums/ -- Replies will be sent to [EMAIL PROTECTED] -- Additional Info: http://www.spamex.com/i/?v=52 That is, indeed, most disturbing. Hm... Allaire heard us (and listened) when we spoke up before. Maybe we all need to speak up now, to make this work for all of our community, not just the few with deeper pockets? I am just getting on top of this thread, but I want to at least post a note and let people know that we are listening. I am going to find out what we can do about the issue. We are very committed to ColdFusion and our users. I can't tell you how often in every meeting I go to, the question comes up, how can we support CF better in product (you pick which one). My guess, off the top of my head, based on 10 years of experience in shrinkwraped software, that the code base for CF4.x was closed and archived long before CF5 shipped. It would be really unusual to come out with an update for a previous version of a product to make it compatible with a server that was not released when the product was. Perhaps there is something that we can do though so I will look into that. I am sorry this is causing frustration here, I should have been on top of it a little earlier, but the volume of mail here is quite high and I was catching up. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia strong arms developers into 5.0 upgrade
We are looking at this as an option. I believe the issue (I am not the programmer, just the interface) is that some type of modules (mod_ssl for example) must have support compiled into Apache under the standard API and with EAPI they are supported at runtime. Using EAPI allows greater flexibility as new modules can be built and deployed without rebuilding the whole core. Justin -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:36 AM To: CF-Talk Subject: RE: Macromedia strong arms developers into 5.0 upgrade And why can't you just carry on useing the normal API version ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Apache, Cold Fusion and EAPI
I did some more research to try to get a sense of the timeline and have found that the EAPI in Apache has been available since at least 1.3.14 (the docs are a little vague on when it was introduced). Apache is now on version 1.3.20. The specific problem that we are having is that mod_ssl requires EAPI support and seems to have required after mod_ssl 2.6 (now on 2.8.4). OpenSA (an apache based package for Win32) provides support for Apache, Cold Fusion and mod_ssl but seems to be frozen at Apache 1.3.12/Mod_SSL 2.6. I suspect that this is due to the lack of EAPI support for CF being in conflict with the EAPI requirement on mod_ssl. CF runs fine with all the current builds of apache using the standard API, but if one wants to run SSL, then mod_ssl is required and thus EAPI is required and thus Cold Fusion is using the wrong API (of mod_ssl is using the wrong API, depending on your point of view). So the bottom line appears to be that to support SSL on Apache and run Cold Fusion, you need an EAPI build of the Cold Fusion module, which according to Macromedia is only going to be available in 5. I have yet to install 5 to see if this is true. Does anyone else run SSL on Apache with Cold Fusion on Win32 and if so, how did you resolve this issue? Justin -- Justin Greene ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 http://www.spamex.com Sign up for your free Spamex account: Protect your real email address forever ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apache, Cold Fusion and EAPI
I have been doing this in my development environment for over a month and am getting warnings in the Apache error log (about the mix) and sporadic blank pages. I do not know that the latter is caused by mixing, however, I do not have the problem in production, which is also 1.3.20, but standard API, not SSL. I do not know what the technical issues are with Mixing API's. Justin -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 9:45 AM To: CF-Talk Subject: RE: Apache, Cold Fusion and EAPI required and thus Cold Fusion is using the wrong API (of mod_ssl is using the wrong API, depending on your point of view). Cant you mix and match API and EAPI at the same time ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Macromedia strong arms developers into 5.0 upgrade
Hi All, I just had a very disturbing conversation with Macromedia. We have been running CF/Apache on Windows for about 2.5 year now and developing on Cold Fusion since the 1.5 days (cgi only). Version 1.3.20 of Apache for Win32 (which has been available for over 6 months) is the first that Apache.org says is stable (not that there have been problems with the old versions). It has made available an enhanced API (EAPI) but modules need to be compiled with EAPI support. Unfortunately the existing Cold Fusion module for Apache on Win32 uses the standard API. I spoke with Macromedia in an effort to get an EAPI build of the module and was informed that they have no plans to compile an EAPI version of the module for Cold Fusion 4.x on Windows, but that it will be supported on Cold Fusion 5 and I should upgrade. Considering the amount of time Cold Fusion 5 has been out and the installed 4.x base (and the fact that I have a cluster of web servers and this upgrade is cost prohibitive and unnecessary), this strikes me as a blatant attempt to force upgrades. I think that they have been going to Microsoft school. I now feel that I have no alternative but to investigate alternatives to Cold Fusion as I no longer have faith that Macromedia has any intention of providing the type of support it's developer community needs. A far cry from the days that Allaire was compiling custom builds of 3.x for me while we tried to track down threading problems in the Cold Fusion Server service. This is annoying as we have a lot of code that will need to be re-written, but it will end up being cheaper in the long run if this is indicative of how Macromedia is going to respond. I hope that I am not the only one who is disturbed by this and that Macromedia will reconsider their position on this. Disappointed, Justin Greene p.s. Allaire posted a resolution to the EXACT problem for Linux on August 7, 2000 in KB# 16303, however it requires the source for the module which I was told would not be made available for windows. -- Justin Greene Co-Founder ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 http://www.clicvu.com http://www.spamex.com Spamex - Protect your real email address forever ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia strong arms developers into 5.0 upgrade
Did you actually read this message? If this is the way they choose to do business, I will take my business elsewhere. I am fairly certain that Apache 1.3.20 was released for Win32 prior to the availability of Cold Fusion 5, yet allaire did not compile an EAPI module for Cold Fusion 4.x, and now refuses to do so, nor will they release the source so we can compile it ourselves, yet they did so for Linux over a year ago. I have never seen a firm depreciate a product before the new one is even available. Justin -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 5:23 PM To: CF-Talk Subject: Re: Macromedia strong arms developers into 5.0 upgrade This is called business. If you want something you'll have to pay for it. There is no free lunch. On Tue, 28 Aug 2001, Justin Greene wrote: Hi All, I just had a very disturbing conversation with Macromedia. We have been running CF/Apache on Windows for about 2.5 year now and developing on Cold Fusion since the 1.5 days (cgi only). Version 1.3.20 of Apache for Win32 (which has been available for over 6 months) is the first that Apache.org says is stable (not that there have been problems with the old versions). It has made available an enhanced API (EAPI) but modules need to be compiled with EAPI support. Unfortunately the existing Cold Fusion module for Apache on Win32 uses the standard API. I spoke with Macromedia in an effort to get an EAPI build of the module and was informed that they have no plans to compile an EAPI version of the module for Cold Fusion 4.x on Windows, but that it will be supported on Cold Fusion 5 and I should upgrade. Considering the amount of time Cold Fusion 5 has been out and the installed 4.x base (and the fact that I have a cluster of web servers and this upgrade is cost prohibitive and unnecessary), this strikes me as a blatant attempt to force upgrades. I think that they have been going to Microsoft school. I now feel that I have no alternative but to investigate alternatives to Cold Fusion as I no longer have faith that Macromedia has any intention of providing the type of support it's developer community needs. A far cry from the days that Allaire was compiling custom builds of 3.x for me while we tried to track down threading problems in the Cold Fusion Server service. This is annoying as we have a lot of code that will need to be re-written, but it will end up being cheaper in the long run if this is indicative of how Macromedia is going to respond. I hope that I am not the only one who is disturbed by this and that Macromedia will reconsider their position on this. Disappointed, Justin Greene p.s. Allaire posted a resolution to the EXACT problem for Linux on August 7, 2000 in KB# 16303, however it requires the source for the module which I was told would not be made available for windows. -- Justin Greene Co-Founder ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 http://www.clicvu.com http://www.spamex.com Spamex - Protect your real email address forever ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apache 1.3.20 and EAPI requirements? (was: MM strongarms)
I do not code in C so this is a little out of my depth, but I believe that it is just a matter of re-linking to the apache source and recompiling with the -DEAPI directive. The actual error from the Apache logs is: [Sat Aug 18 17:16:59 2001] [warn] Loaded DSO modules/ApacheModuleColdFusion.dll uses plain Apache 1.3 API, this module might crash under EAPI! (please recompile it with -DEAPI) I understand MM not wanting to support old software, however, CF 5 is barely out the door (how many people are still running NT 4?) and I am not ready to make that leap yet. I am just now making the leap to apache 1.3.20 and it has been out for at least 6 months and I still run NT 4. I am very cautious about upgrades to a stable environment. BTW: Apache/CF has been my choice for development as it can easily be ported to Linux or Solaris and even will allow me to run a mixed environment should I need to. Justin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 7:06 PM To: CF-Talk Subject: RE: Apache 1.3.20 and EAPI requirements? (was: MM strongarms) snip It would just be one module, really. In the current version of CF 4.x for Windows, there's an API module provided for use with Apache: \cfusion\bin\ApacheModuleColdFusion.dll. This would need to be rewritten, recompiled and retested for EAPI. I don't know how difficult it would be, but it's fairly limited in its scope. For what it's worth, it shouldn't be a major project to rewrite and rebuild this - and if you decided against doing it in any case, Macromedia could certainly release the source code for the Apache API module for Windows (fairly useless by itself, I'd think) and let someone else do it. On the other hand, I don't imagine that there are too many Macromedia customers using Apache on Windows for production sites. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: which web server do you use for CF?
Which would you not want to run in production? Apache runs great in production. I just heard that a PHP module for apache was just released, but have not looked into this (this may NOT be production quality). Justin -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 2:41 PM To: CF-Talk Subject: Re: which web server do you use for CF? A little off topic here, but I am wondering about your statement concerning PHP/Apache on a win2k machine. I was unaware they would run on a windows box as I thought both were Linux only apps. there's a windows version available. I just downloaded the pre-compiled binary and it installed fine, though I gather that the Windows version is not one you would want to run in a production enviroment. The only thing I had to get used to was that (a) in Win98, the web server won't start automatically (since it's not a service as it would be in NT/W2K) and [now, if I could just get CF to only start whenever the Web Server starts now that would be convenient!] and (b) you have to configure the server via a text file. Not too bad, they both seem like small downsides for the advantage of dumping PWS :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Way Slow web pages
Make sure to config the SQL client to use TCP/IP not named pipes (especially if querying from a different machine), and try using SQL security rather than NT security. Also what happens when you try to login using query manager (using the same login the webserver uses) and run the query manually. Login slow, query slow, both, neither? Justin -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 3:05 PM To: CF-Talk Subject: OT: Way Slow web pages -- Spamex - Forums Now Available http://forums.spamex.com/forums/ -- Replies will be sent to [EMAIL PROTECTED] -- Additional Info: http://www.spamex.com/i/?v=52 sorry about the very broad question. but what are some things that could cause a web server to almost be 10times slower. web pages that were taking ~3,000ms are up to ~30,000. same with others that were at ~200ms are at ~2,000. is seems to be the query/db access time. it's affecting both Access and SQL backed web pages. Access itself seems to be running fine. but SQL Manager seems to be running real slow. takes over 2 mins to just display a list of the tables when a db is chosen. and then almost 4 mins to display the design table. I have reviewed the logs, the only listing, but is not consistent is that the administrator account fails on accessing \winlogon Object type: desktop. EventID: 560 looks to be trying the access \winlogon once a sec. but this is not going on all the time. This will happen for about 3 mins then stop. the changes to the server I can think of, MS office and SQL 7 have both been reloaded. This is not an active server, once this problem gets fixed, it will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual 800mhz CPUs. using CF 5. I have tried to turn the different services off,(CF, WEB, SQL), but this does not affect the problem. I am at a loss. any suggestions will be appreciated. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: buying/leasing SQL
SQL7 is also per CPU licensing for the Internet Connector license so there is no gain here by getting 7 over 2000. I did inquire with MS a one point about getting SQL7 rather than 2000 and was told that you can buy 2000 then call them and Downgrade the license. You could not, however purchase 7. They have a pretty large enterprise base running SQL7 (not to mention 6.5) and I do not imagine that they would get away with dropping it in the too near future. Justin -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 10:39 AM To: CF-Talk Subject: Re: OT: buying/leasing SQL To the best of my knowledge: 1. is it possible to still buy SQL server 7 somehow? does the new (per-cpu) pricing apply to this? You may be able to find a copy somewhere, but keep in mind that M$ is likely to disallow SQL 7 licensing at any time, which will mean that SQL 7 owners will be forced to upgrade to SQL 2000. 2. is it possible to lease SQL 7/2000 somewhere? Lease? I presume you can purchase on credit. 3. is it possible to have the rather high price splitted into monthly payments? See above. 4. do I have to buy per-cpu license if I use SQL with Coldfusion (IIS) to server dynamic webpages? can I buy per-seat license for this? Yes, you must buy a processor license for each CPU with SQL 2000 for use on the Internet. Quite a scam. So, if you have say Dual 500 MZ processors, you can buy a brand new server with a single 900 MZ or higher processor with the money you'll save by buying a single processor license. I don't think that applies to SQL 7, but as I said, expect M$ to disallow SQL 7 licensing at sometime in the future. -- Bud Schneehagen - Tropical Web Creations ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (maybe) : Code Red
Anyone know whether the exploit being used by code red could be used to launch a counter exploit on the infected system that patches the machine :-). Justin -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 9:54 PM To: CF-Talk Subject: OT (maybe) : Code Red I don't know about the rest of you who host web sites, but we're still getting slammed with Code Red attempts - it's been even worse since the variant came out on Saturday. I was wondering if anyone had worked out a way to automatically notify the site administrators ? When we got hit by a site called ezsecurehosting.com I figured it's about time something got done. Any suggestions ? Richard Y2K Internet Technologies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Apache 1.3.20
Forgot to mention I am running Windows NT. I do not seem to have the source for the module. Will hunt around the Allaire website for it. Thanks. Justin -Original Message- From: Deb Dickerson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 7:22 AM To: CF-Talk Subject: RE: Apache 1.3.20 The steps to rebuild the module for EAPI are here: http://www.allaire.com/Handlers/index.cfm?ID=16300Method=Full Deb -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 2:12 PM To: CF-Talk Subject: Apache 1.3.20 Is anyone running CF with Apache 1.3.20? We have just upgraded and everything appears OK but an Apache -S shows the error: [Wed Aug 01 14:04:07 2001] [warn] Loaded DSO modules/ApacheModuleColdFusion.dll uses plain Apache 1.3 API, this module might crash under EAPI! (please recompile it with -DEAPI) Anyone know if there is a -DEAPI build of the Cold Fusion DLL? Justin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Apache 1.3.20
Is anyone running CF with Apache 1.3.20? We have just upgraded and everything appears OK but an Apache -S shows the error: [Wed Aug 01 14:04:07 2001] [warn] Loaded DSO modules/ApacheModuleColdFusion.dll uses plain Apache 1.3 API, this module might crash under EAPI! (please recompile it with -DEAPI) Anyone know if there is a -DEAPI build of the Cold Fusion DLL? Justin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What is the purpose of the \cfusion\mail\undevilr directory?
Messages that Cold Fusion is not able to hand off to the smarthost appear here. Your smtp server may accept abc and 123 as valid email addresses and just try to append you domain to the end of them. Try putting a bad IP address for the SMTP server and watch the directory fill up. -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:57 PM To: CF-Talk Subject: What is the purpose of the \cfusion\mail\undevilr directory? -- Spamex - Forums Now Available http://forums.spamex.com/forums/ -- Replies will be sent to [EMAIL PROTECTED] -- Additional Info: http://www.spamex.com/i/?v=52 Firstoff, I'm using CF 4.5.1. I thought that the undevilr folder was there to catch mail that was either sent back or timed out contacting the mail server. Am I wrong? I tried this tag, which was formatted badly on purpose. cfmail from=abc to=123 subject=testTest/cfmail When I execute this tag, a spool file does appear in the \spool directory. When it is sent, the file dissapears from the \spool directory, but nothing appears in the \undelivr directory. No error in the logs, no undelived email. Kind odd. Maybe cfmail dosn't use VRFY when using SMTP. :/ Any ideas? Eric Carlisle ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Got the fellow, but....
I would take the log file entries and send them in an email to [EMAIL PROTECTED] This type of activity is in violation of most ISP's AUP (Acceptable Use Policy) and many will terminate the users account for doing this. Be sure to let them know your GMT offset so that if it is a dialup user they can look in their dialup logs and figure out who was logged in to the IP at the time. You can figure out the isp by looking up the IP at http://www.arin.net in their whois. Do not trust simple reverse lookups as they may be spoofed. Justin -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 3:15 PM To: CF-Talk Subject: Got the fellow, but I'm doing a pretty intensive watch on my server stastics and log files in real-time. sometimes I see people who try stupid stuff like: /winnt/system32/cmd.exe and trying to url hack (with ;drop tables) . my question is: when I'm seeing the guy's IP address in the stas server or log files, and the guy is still causing problem (i,e - trying to hack) what can I do to him? can I throw him, and only him away? will adding him to the banned IP in IIS helps immediatly? any other alternatives? Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backing up large database
Also bear in mind that database size also includes indexes and enough of them can turn a fairly small set of data into a large database file. There is a procedure to break down the amount of space being used by all tables, indexes etc. May be worth looking at. Justin Justin Greene Co-CEO ClicVU, Inc. 216 West 18th St., Floor 12 - NYC 10011 P: 212-242-0258 x 101 - F: 212-242-9355 http://www.clicvu.com - Sign up for your free Spamex account: http://www.spamex.com Protect your real email address forever - -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 10:26 AM To: CF-Talk Subject: RE: Backing up large database On 7/25/01, Dave Watts penned: Man, what do you have in that database? LOL I've got databases on my SQL Server that aren't HUGE, but they do have some rather large tables (30 fields or so) with several thousand records in them and they're only 11-12 MB. Do you have the database options set to Auto-Shrink? In enterprise database terms, several thousand records is a very small amount. I understand that, but 1.2 GB seems like a pretty large database. Yes, I know they can get to be terabtyes. :) I just thought maybe he wasn't shrinking it. Just something for him to look at. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backing up large database
A few thoughts 1. .zip does have a file size and file count limit. Sound like you are hitting the former. I understand the RAR does not have this limitation, but have not worked with it. 2. Perhaps you can download the file using a protocol that compresses dynamically (like zmodem) rather than trying to create a single large file and downloading it. PCAnywhere does compress during download. Try downloading without zipping first, it may take a similar amount of time 3. There are product that will split a file into smaller files. Perhaps split the db file in half before zipping and then re-combine after un-zipping. You should be able to automate all of this, including the download itself. Justin p.s. We have a tape library at our remote location and have to physically get backups with a laptop if we need then (20+ GIG of data). -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 9:00 PM To: CF-Talk Subject: Backing up large database Just ran into a problem with my backup system my server is co-located at an ISP, so I have to backup over the internet.. I have an exact copy of the website on my local server, which is backed up to CDs. I am the only person who writes code for this server.. so I know I have all of the source code and graphic files backed up already, so I never have to back them up from the server. The only thing that changes on the webserver is the database, stored in SQL server. I has an automated task in SQL server back up the data every night to a file, then used a CF scheduled task to use CF_ZIP to zip the backup file up and every night before I go to sleep, I log in with PC anywhere and download it to my home computer and back it up over my home network and once a week to CDs. Worked fine until today. It seems the data file got too large to zip. Does CF_ZIP have a size limit? The file is 2.1 gigs unzipped (200 megs zipped - goes very fast with my cable modem:). I have over 20 gigs of free hard disk space on the server. Is there any work-around, or do I have to break the database up into sections and do the parts individually? How do you handle back-up from remote servers? Al ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SPAM - how can I stop this - any ideas?
This header does not look complete to me. Is 216.9.67.204 your system? If not then where is the Received: line for your system. You need to go ARIN (http://www.arin.net) and lookup The IP addresses in the header, not the domain names (which can be easily spoofed). The most-likely-to-be-real is the one from which your mail server received the message. After that, they can be forged. Find who owns the network block and notify their abuse department (Abuse@). Include the message you received and the FULL headers. Justin Return-path: [EMAIL PROTECTED] Received: from localhost (unverified [216.9.67.204]) by mailsvr.fastdnsservers.com (Vircom SMTPRS 4.7.192) with ESMTP id [EMAIL PROTECTED] for [EMAIL PROTECTED]; Wed, 18 Jul 2001 17:46:30 -0400 Message-ID: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] From: Ken Barnes [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Wed, 18 Jul 2001 17:44:26 -0400 Subject: FREE 'REVOLUTIONARY' MONEY MAKING WEB SITES Organization: Just Rewards MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF trojen? BackdoorJY.sv
You may also want to look into a piece of software called tripwire (http://www.tripwire.com). It will create a checksum for all the files on your system and do a variety of things if something changes. I have not implemented it yet (NT4 environment) but have an associate (Linux) that swears by it (not because of it). It may not stop a hack, but it should allow you to catch it before too much damage can be done. Justin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:13 AM To: CF-Talk Subject: RE: CF trojen? BackdoorJY.sv Everyone running IIS should look at this: http://www.microsoft.com/Downloads/Release.asp?ReleaseID=24168 This has kept us pretty much out of the eye of trouble for quite some time. Hackers managed to get in almost daily, prior to us recreating our systems, adding W2K SP2, and then running this each hour, to make sure we were up-to-date. Great free tool. While HFCheck is a nice tool, there are two points worth mentioning. 1. It only works with IIS 5 (on Win2K). 2. Most of the IIS hotfixes patch functionality that isn't even used by the vast majority of IIS sites: things like Index Server, IIS-based password changing, IIS-based printing, and so forth. Rather than relying on Microsoft patches, you'll get better mileage out of properly configuring your servers up front. Here's a little secret of mine. I don't bother installing most of the IIS patches when they come out. I don't have to, because they patch things that I've already disabled or removed. I can wait until everyone else has regression-tested the patch on their production web servers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What is best way to write this report?
Write your query to return: Month (as number), Day (as number), other data order by Day, Month Then loop through the result and each time the month is the last month start a new row. Justin -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:06 PM To: CF-Talk Subject: What is best way to write this report? I've got a query that returns a date and a sales figures for the previous 365 days. I need to write this information to a report in the format of: Jan 1 Feb 1 Mar 1 Apr 1 May 1 ... Jan 2 Feb 2 Mar 2 Apr 2 May 2 ... Jan 3 Feb 3 Mar 3 Apr 3 May 3 ... Jan 4 Feb 4 Mar 4 Apr 4 May 4 ... On to the end of the days in the month. From an architectural stand point, what is the best way to do this? Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Imposing an ad hoc sort order on a SQL query
If this is SQL server should be able to accomplish it something like this... CREATE PROCEDURE adhocorder @position1 as varchar(25), @position2 as varchar(25), @position3 as varchar(25), @position4 as varchar(25) AS SELECT AdHocOrder = CASE bp.Description WHEN @position1 THEN 1 WHEN @position2 THEN 2 WHEN @position3 THEN 3 WHEN @position4 THEN 4 ELSE 5 END, bp.description, m.membername FROMmembers m, boardposition bp, board b WHERE m.memberid = b.memberid AND bp.boardpositionid = b.boardpositionid ORDER BY adhocorder Somthing like this should allow yuo to pass in varchars for positions 1-4 indicating which should appear where. Justin -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 5:06 PM To: CF-Talk Subject: Re: Imposing an ad hoc sort order on a SQL query Thanks, but that's what I was trying avoid - storing the sort order within the table. Even though it's flexible enough to be updated, I might have another page and query (perhaps pulling just a subset of the board members) where I want to use a different ordering. But now that I think about it, doing this so-called ad hoc sort in the way I was proposing may not be the smartest idea, since it's not data driven. It would require me to hardcode the board position descriptions into the template's SQL code. I guess I'll do it the way you've described and then add additional sort order fields as needed by the project. Jim - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 09, 2001 2:27 PM Subject: Re: Imposing an ad hoc sort order on a SQL query I have had to do this in the past... I just added a USERSORT field and put numeric fields in it for display order (ie: PRESIDENT= 1 VICEPRESIDENT=2, etc.) then I just create a forms based interface that lets you mod the numbers as need be... so you do a SORT BY USERSORT ASC in my example... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Jim McAtee [EMAIL PROTECTED] Date: Mon, 09 Jul 2001 11:39:25 -0600 Subject: Imposing an ad hoc sort order on a SQL query Say I've got three tables for the members of an organization and its Board of Directors. Let's say there are approximately ten board positions. I want to be able to do a query and have an ad hoc ordering of the positions for display on a page. For example: 1. President - John Doe 2. Vice President - Jane Jones 3. Secretary - Bob Smith 4. Treasurer - Neil Jones etc. Tables: Members MemberID Name BoardPositions - BoardPositionID Description Board - BoardID MemberID BoardPositionID I could add a 'sortorder' field to the Board table, but I don't think this should be in the data. Rather, I'd like to be able to specify the order when I do the query in my CF template. Is there any means in SQL to do something like: SELECT Members.Name, BoardPositions.Description FROM Board b, BoardPositions p, Members m WHERE b.MemberID = m.MemberID AND b.BoardPositionsID = p.BoardPositionsID ORDER BY ('President','Vice President', ...) Thanks, Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists