Re: bulk insert to SQL server but not from file
What about doing your conversion to relational locally to Access (or even to Paradox) and then just shooting up the complete final data. James Sleeman wrote: > > Hi all, > I have an old, ugly and large Paradox database that I inherited and am >converting into a new, beautiful and large SQL Server (7) driven schema. > > Problem is the importing of this old database - it takes a VERY long time and i >have to watch it like a hawk because invariably the Paradox data is broken beyond >belief in places and I have to fix the data or scrap that row or work around it... > > The reason it takes so long (it's not to do with Paradox itself, those queries >get cached), is that the inserting of this data generates, about 500 insert queries >per row of data in the old paradox database (it was a big flat file thing more or >less, my schema is fully relational), there are just under 1000 rows, that's, 50 >inserts ! Not to mention the fact that the SQL server is all the way across the net >:-) > > So, is there any way to do a BULK insert into single tables aside from using >"BULK INSERT" itself, which inserts from a file on the SQL server (I don't have >access to put files on the SQL server anyway), so that instead of 500 individual >inserts per old database row I can just do one insert for each of my new tables (that >is insert all the "Education" data for a row in one shot, insert all the "Staff" data >in one shot etc) there by reducing the load to maybe 40 "bulk" inserts per row, and >the total down to 4 "bulk" inserts (which is still a lot, but not staggeringly). > > Ideas anybody ? > > --- > James Sleeman > > Innovative Media Ltd > Ph: (03) 377 6262 > http://www.websolutions.co.nz > > CAUTION: The information contained in this email message is confidential and may be >legally privileged. If the reader of this message is not the intended recipient you >are notified that any use, dissemination, distribution or reproduction of this >message is prohibited. If you have received this message in error please notify the >sender immediately and destroy the original message and any attachments. > > Views expressed in this communication may not be those of Innovative Media Ltd. > > __ 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
bulk insert to SQL server but not from file
Hi all, I have an old, ugly and large Paradox database that I inherited and am converting into a new, beautiful and large SQL Server (7) driven schema. Problem is the importing of this old database - it takes a VERY long time and i have to watch it like a hawk because invariably the Paradox data is broken beyond belief in places and I have to fix the data or scrap that row or work around it... The reason it takes so long (it's not to do with Paradox itself, those queries get cached), is that the inserting of this data generates, about 500 insert queries per row of data in the old paradox database (it was a big flat file thing more or less, my schema is fully relational), there are just under 1000 rows, that's, 50 inserts ! Not to mention the fact that the SQL server is all the way across the net :-) So, is there any way to do a BULK insert into single tables aside from using "BULK INSERT" itself, which inserts from a file on the SQL server (I don't have access to put files on the SQL server anyway), so that instead of 500 individual inserts per old database row I can just do one insert for each of my new tables (that is insert all the "Education" data for a row in one shot, insert all the "Staff" data in one shot etc) there by reducing the load to maybe 40 "bulk" inserts per row, and the total down to 4 "bulk" inserts (which is still a lot, but not staggeringly). Ideas anybody ? --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ 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: Log File Analysis [OT]
Scott, I appreciate the links and I'm definitely going to look into Analog as well as Report Magic. Report Magic looks like it can create some pretty amazing graphs. I'll check it out and see what I can come up with. Thanks again, Dennis -Original Message- From: Scott Kellogg [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:01 PM To: CF-Talk Subject: RE: Log File Analysis [OT] Dennis, I used a program called 'Analog 5.22' available from http://www.analog.cx If you are familiar with the apache.conf style of setup then this is right up your alley. It can be run from a local/remote computer to analyze logs remotely or locally. It also comes in many formats (FreeBSD to Win32)It can be customized out the wazoo and works well with helper programs. Check out 'Report Magic 2.13' from http://www.reportmagic.org/ This comes in Mac, Win32, and perl source packages. It has many more detailed and visually pleasing reports to display the logfile information generated by 'Analog 5.22' Both of the programs are Open Source and have very extensive documentation. Analog also has an online searchable forum for even more information. The only drawback is that it is complicated. Hope this helps Scott Kellogg Network Administrator Website/Database Management Media Odyssey Inc. -Original Message- From: dennis baldwin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 9:10 AM To: CF-Talk Subject: Log File Analysis [OT] I apologize for the somewhat off-topic post (but we're runnin' CF ;). Anyways, does anyone have some suggestions for a good web stats program that will run on Linux and analyze apache logs? We've tried webalyzer, which seems to be pretty good, but I'm curious as to what other options are available. Thanks in advance for your time and feedback. Regards, Dennis __ 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: Log File Analysis [OT]
Thanks Tony, yeah I've looked into it and just wanted to see what else was available. Regards, Dennis -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:14 PM To: CF-Talk Subject: Re: Log File Analysis [OT] I was going to say webalizer, but it seems you already found that. ;) > I apologize for the somewhat off-topic post (but we're runnin' CF ;). > Anyways, does anyone have some suggestions for a good web stats program that > will run on Linux and analyze apache logs? We've tried webalyzer, which > seems to be pretty good, but I'm curious as to what other options are > available. Thanks in advance for your time and feedback. > > Regards, > Dennis > > __ 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: COM Objects
> I am slowly working on on SNPP with ColdFusion and have found > a COM object to handle some of the traffic. Below is my code > that I am currently using. Question is with COM objects, is > their a standard listing on commands that has been published > that I can use for reference. If I understand you correctly, no, each COM object has its own objects, properties and methods. > I am wanting to retrieve information back from the page object > and depending on what the first 3 characters are, depends on > what page gets displayed. I have tried to do a Left(page, 3) > and set that to a variable which produced a blank variable. > Then I tried to do a Left(HTMLCodeFormat(page), 3) to see if > this worked and received the same blank variable back. Are you getting any content within the returned page at all? 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 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 based classifieds
Does anyone have or know of a CF based classified ads app that can be integrated into a corporate intranet? Preferably fusebox? Thanks, John __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
Matthew R. Small wrote: > We're not talking about bad code. We're talking about forgotten table > tags. We're talking about not fully scoping a variable. We're talking > about the fact that when bad code does get written, you're a whole lot > better off if you have internet explorer than when you have netscape. But when evil code gets written you are a whole lot better of if you have Netscape (Nimda anyone?). Jochem __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
OK... :-) I'm done thinking about Netscape, IE and browsers. I'm going to go jetski the rest of my day away. I hope that everybody had a good time with this little thread today. Take care, - Matt Small -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 6:24 PM To: CF-Talk Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) > We're not talking about bad code. We're talking about > forgotten table tags. We're talking about not fully > scoping a variable. I'd argue that's bad code. It might not be as bad, comparatively speaking, as not using CFLOCK around a memory variable, but forgetting a table tag is an invalid instruction, and not scoping a variable is a potentially ambiguous instruction. It's important to remember that computers are very, very stupid, and will generally do exactly what we tell them to do, with very little ability to "fill in the blanks" when we provide incomplete or incorrect instructions. While I prefer IE to Netscape, there's a reason that IE is such a big install, and why the Gecko parser in Mozilla is as fast as it is. This is because IE attempts to render HTML even if it's not well-formed, and does a decent job of it. Of course, for this to happen, IE has to include all kinds of code to cover every eventuality. We're not going to have this luxury in the future, probably - as browsers become smaller, and as they're found in more devices, the necessity of writing well-formed HTML, or XHTML, more likely, will be much greater than it may be now. > We're talking about the fact that when bad code does get > written, you're a whole lot better off if you have internet > explorer than when you have netscape. If you had to choose > between riding in a car that was based on the fact that > everything was always perfect in a perfect world then > netscape works quite nicely. The fact is, IE takes into > account the fact that code doesn't always get written > like the rules say. It figures out the right most of the > time and leaves you with options so your code is not left > broken when multiple people who work on the application > make a mistake here or there then it's left to somebody > else to fix. A couple of points worth noting here: 1. IE may figure out the optimal thing to display, but your code is in fact "left broken". 2. If you follow your car analogy to its logical conclusion, you could compare IE to a Humvee, and Netscape to, say, a Yugo. However, as a road-builder, your roads should work for both, and if you build roads with giant potholes, you can't blame the problems encountered by Yugo drivers on their choice of cars - maybe they can't afford a Humvee! (The analogy here would be that they're running Linux or something, rather than Windows or Mac, I suppose.) > You're right, writing things properly is always a good > thing. Being able to account and correct mistakes rapidly > is also. Yes, both of those are important. The second one is usually called "debugging", and in an ideal world, most of it happens before an application is deployed, and isn't performed by end users. > Now, let's attack me personally because I have these > views. Yes, go ahead and attack the person instead of > the views themselves. Show me how much class you've got. I hope you don't take this as a personal attack. I don't think that Jerry intended for you to take his criticism as a personal attack, either, based on my reading of it: "What you are talking about is bad coding. Pure and simple. And laziness. Just because IE currently allows you to code so poorly, and the page sometimes renders the way you want, doesn't mean it is a good idea." Laziness is actually a positive asset of a programmer, of course - the lazy programmer takes his time and does it right, once, instead of doing it more than once. And, based on your own statements, it sounds likely that you have in fact written bad HTML. We've all done that our fair share, I'm sure, but few have defended it as a valid practice. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
> We're not talking about bad code. We're talking about > forgotten table tags. We're talking about not fully > scoping a variable. I'd argue that's bad code. It might not be as bad, comparatively speaking, as not using CFLOCK around a memory variable, but forgetting a table tag is an invalid instruction, and not scoping a variable is a potentially ambiguous instruction. It's important to remember that computers are very, very stupid, and will generally do exactly what we tell them to do, with very little ability to "fill in the blanks" when we provide incomplete or incorrect instructions. While I prefer IE to Netscape, there's a reason that IE is such a big install, and why the Gecko parser in Mozilla is as fast as it is. This is because IE attempts to render HTML even if it's not well-formed, and does a decent job of it. Of course, for this to happen, IE has to include all kinds of code to cover every eventuality. We're not going to have this luxury in the future, probably - as browsers become smaller, and as they're found in more devices, the necessity of writing well-formed HTML, or XHTML, more likely, will be much greater than it may be now. > We're talking about the fact that when bad code does get > written, you're a whole lot better off if you have internet > explorer than when you have netscape. If you had to choose > between riding in a car that was based on the fact that > everything was always perfect in a perfect world then > netscape works quite nicely. The fact is, IE takes into > account the fact that code doesn't always get written > like the rules say. It figures out the right most of the > time and leaves you with options so your code is not left > broken when multiple people who work on the application > make a mistake here or there then it's left to somebody > else to fix. A couple of points worth noting here: 1. IE may figure out the optimal thing to display, but your code is in fact "left broken". 2. If you follow your car analogy to its logical conclusion, you could compare IE to a Humvee, and Netscape to, say, a Yugo. However, as a road-builder, your roads should work for both, and if you build roads with giant potholes, you can't blame the problems encountered by Yugo drivers on their choice of cars - maybe they can't afford a Humvee! (The analogy here would be that they're running Linux or something, rather than Windows or Mac, I suppose.) > You're right, writing things properly is always a good > thing. Being able to account and correct mistakes rapidly > is also. Yes, both of those are important. The second one is usually called "debugging", and in an ideal world, most of it happens before an application is deployed, and isn't performed by end users. > Now, let's attack me personally because I have these > views. Yes, go ahead and attack the person instead of > the views themselves. Show me how much class you've got. I hope you don't take this as a personal attack. I don't think that Jerry intended for you to take his criticism as a personal attack, either, based on my reading of it: "What you are talking about is bad coding. Pure and simple. And laziness. Just because IE currently allows you to code so poorly, and the page sometimes renders the way you want, doesn't mean it is a good idea." Laziness is actually a positive asset of a programmer, of course - the lazy programmer takes his time and does it right, once, instead of doing it more than once. And, based on your own statements, it sounds likely that you have in fact written bad HTML. We've all done that our fair share, I'm sure, but few have defended it as a valid practice. 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: CSS and Netscape - was(CSS and dynamically changing classes)
I've got plenty of class. And I didn't attack you personally. I did make a comment that I wouldn't want to follow in your coding footsteps, based on your assertion that unclosed tables are perfectly fine. >I truly hope I never have to maintain your codebase. (Although I am >currently fixing one probably quite like it). I am just finishing up fixing some 140,000 htm files that were written and debugged in IE. The scripters never bothered to close TD, TR, TABLE or FONT tags (I won't but mention the attempts by a more conscientious coder.) In some cases, there were a nested set of 7 tables without sets to close them off. Worked fine in IE, but how about trying to display this stuff in other standards/browsers. WML? On a Rocket E-book? Now, try moving from to something a little more strict. Ain't gonna happen. As for developing in IE vs Netscape, I would rather the browser let me know when something is wrong. So I can fix it. It is the exact same reason I use error checking when compiling C or running perl. I'm not saying that leaving a table open here and there is grounds for the death penalty, but I think the GOAL should be code that will pass through a decent code scrubber. (And just for clarity, I BROWSE the Internet with IE. Cause it is more forgiving on those sites that don't bother with QA.) Jerry Johnson >>> [EMAIL PROTECTED] 04/16/02 05:21PM >>> We're not talking about bad code. We're talking about forgotten table tags. We're talking about not fully scoping a variable. We're talking about the fact that when bad code does get written, you're a whole lot better off if you have internet explorer than when you have netscape. If you had to choose between riding in a car that was based on the fact that everything was always perfect in a perfect world then netscape works quite nicely. The fact is, IE takes into account the fact that code doesn't always get written like the rules say. It figures out the right most of the time and leaves you with options so your code is not left broken when multiple people who work on the application make a mistake here or there then it's left to somebody else to fix. You're right, writing things properly is always a good thing. Being able to account and correct mistakes rapidly is also. Now, let's attack me personally because I have these views. Yes, go ahead and attack the person instead of the views themselves. Show me how much class you've got. - Matt Small -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 5:07 PM To: CF-Talk Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) I certainly hope he is defending Netscape for requiring decent code. What you are talking about is bad coding. Pure and simple. And laziness. Just because IE currently allows you to code so poorly, and the page sometimes renders the way you want, doesn't mean it is a good idea. "Pushing code out" is, IMHO, no excuse for bad coding. Quite the opposite, in fact. Good code takes less time than bad code. To write, to debug, to maintain. I truly hope I never have to maintain your codebase. (Although I am currently fixing one probably quite like it). Shivering at the thought, Jerry Johnson >>> [EMAIL PROTECTED] 04/16/02 05:01PM >>> > Think about what you just said... Umm... no... I spent the afternoon debugging my pages because netscape isn't as forgiving as ie. I don't feel like thinking anymore. I guess that makes me a bad programmer though, and unprofessional. I use ie only here on the intranet because I don't have to spend time searching through the piles of code that I have looking for that forgotten table tag and its nice features that I can get to work the first time. If you love netscape, good for you. I don't, I know a LOT of people who don't, and it's an inferior product for that reason alone. No, I haven't read the w3 standardization for css or html or javascript or whatever. I have to spend my time pushing code out the door for production purposes. I don't even use stuff that is ie-only. I have a 1998 O'Reilly javascript book that I use and everything in it works on ie except where it says it won't. > I keep screaming for a tag too, but nobody > listenssigh. Oh, gosh, you're right. I wish I had a tag that does that also, but instead, I'll use ie, which saves me a lot more tedious tag-searching work than ns ever did. So, you're right. Sometimes I forget to put at the end of my page. Sometimes I forget to fully qualify my scopes when writing javascript and my css doesn't work. These are the things that I use that make netscape break into pieces. You're defending this? Matt Small -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:24 PM To: CF-Talk Subject: Re: CSS and Netscape - was(CSS and dynamically changing classes) - Original Message - From: "Matthew R. Small" <[EMA
Re: Error starting CF service
You have to make registry changes and there are a ton of permissions. There is an article at Defusion but its a little dated. Neil - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 4:31 PM Subject: RE: Error starting CF service > post the what permission you changed for clarity and for archive purposes > > Anthony Petruzzi > Webmaster > 954-321-4703 > [EMAIL PROTECTED] > http://www.sheriff.org > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 16, 2002 4:34 PM > To: CF-Talk > Subject: Re: Error starting CF service > > > In writing this email I figured out my own problem. It was a > permissions issue. > > BJ > > = = = Original message = = = > > I just set up a new server and when I attempt to view the web > > page I get this error: > > * > An error occurred while attempting to establish a connection > > to the service. > The most likely cause of this problem is that the service is > > not currently running. You can use the 'Services' Control Panel > > to verify that the service is running and to restart it if necessary. > > > Windows NT error number 2 occurred. > ** > > > So, I looked and the CF Application Server is not started. When > > I attempt to start it I get this error: > > *** > Could not start the Cold Fusion Application Server service on > > Local Computer. > The service did not return an error. This could be an internal > > Windows error or an internal service error. > If te problem persists, contact your system administrator. > *** > > I checked the password on the cfserver account and everything > > looks ok. Any ideas? > > bjorno > > ___ > Sent by ePrompter, the premier email notification software. > Free download at http://www.ePrompter.com. > > > > __ 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: Recursive Query: Anything better??
You didn't say what DB you are using but this should work on SQL Server ...
select count(id) as Num, datepart(ww, date) as weekofyear, year(date) as
year
from main
where date > #firstDate# and date < #lastDate#
group by datepart(ww, date), year(date)
order by year, weekofyear
-Original Message-
From: Venable, John [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 5:25 PM
To: CF-Talk
Subject: Recursive Query: Anything better??
I'm sure there is something better than what I'm doing, basically I want to
do a weekly count of how many people have signed up for our newsletter.
Here's what I have, it seems VERY inefficient. Any SQL gurus out there wanna
help me out? Thanks in advance.
SELECT count(id) as num
FROM MAIN
WHERE date between '#dateformat(DateAdd("d", -7, end))#' AND
'#dateformat(end, "mm/dd/yy")#'
[formatting clipped for
clarity]
John Venable
__
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: CSS and Netscape - was(CSS and dynamically changing classes)
> We're not talking about bad code. We're talking about forgotten table > tags. We're talking about not fully scoping a variable. We're talking What's the difference? A missing closing tag in HTML is bad code, just as a missing closing tag in CF throws an error. > about the fact that when bad code does get written, you're a whole lot > better off if you have internet explorer than when you have netscape. Right, and that's why I use IE in my day-to-day surfing and development process. I also use other browsers for testing pages as they are written so that a greater number of end-users will see things they are meant to be seen. The end-users are why we have jobs and clients right? Should we not cater to them? As developers, we don't really have the luxury of being bigots (I don't mean to imply that you are specifically) when it comes to the browsers, unless of course you're writing HTML, JS and CSS that will be strictly internal and you control what browsers the users are using. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ 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: Blowfish Encryption w/ ColdFusion?
Grrr... the site is down. If anybody else knows of Blowfish encryption for CF... let me know please. COM objects will work too. -Jon -Original Message- From: Jim Priest [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 3:43 PM To: CF-Talk Subject: Re: Blowfish Encryption w/ ColdFusion? Did a quick search on google: http://www.on-idle.com/ look under o-iCore framework (whole site is in Flash so I can't link directly to it - that's what I call 'rich' media) :) jp On Tuesday, April 16, 2002, Jon wrote: JB> I'm looking for a custom tag or component of some type that will let me JB> utilize blowfish encryption in my project. I found the CFX_ENCRYPT tag at JB> http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347373-2830-11D4 JB> -AA9700508B94F380&method=Full but there is nowhere to download the tag, and JB> emails to the author bounce back. __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
I wasn't trying to attack your professionalness or whatever. However people attacking Netscape (especially 6, which is going to be awesome imho) for invalid reasons in one of pet peeves. We have around 6 months before we see IE7 and it's probably going to be the same old IE4 clone we have been seeing for years with DotNet added on. I don't think Microsoft saw Netscape as a threat when IE7 was being planned, so we are going to have to wait a long time until we see IE catch up on some of the new features Mozilla is bringing to the new browser war. I won't argue that when MS puts it's mind to something, no one can compete, but IE really has been stagnant for a long time. Either way, Compuserve officially made the switch to Gecko today, and AOL8 proabably isn't far off. Time to bookmark that validator :) jon - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 5:01 PM Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) > > Think about what you just said... > Umm... no... I spent the afternoon debugging my pages because netscape > isn't as forgiving as ie. I don't feel like thinking anymore. > > I guess that makes me a bad programmer though, and unprofessional. > > I use ie only here on the intranet because I don't have to spend time > searching through the piles of code that I have looking for that > forgotten table tag and its nice features that I can get to work the > first time. > > If you love netscape, good for you. I don't, I know a LOT of people who > don't, and it's an inferior product for that reason alone. > > No, I haven't read the w3 standardization for css or html or javascript > or whatever. I have to spend my time pushing code out the door for > production purposes. > > I don't even use stuff that is ie-only. I have a 1998 O'Reilly > javascript book that I use and everything in it works on ie except where > it says it won't. > > > I keep screaming for a tag too, but nobody > > listenssigh. > Oh, gosh, you're right. I wish I had a tag that does that also, but > instead, I'll use ie, which saves me a lot more tedious tag-searching > work than ns ever did. > > So, you're right. Sometimes I forget to put at the end of my > page. Sometimes I forget to fully qualify my scopes when writing > javascript and my css doesn't work. These are the things that I use > that make netscape break into pieces. You're defending this? > > > Matt Small > > > > > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 16, 2002 4:24 PM > To: CF-Talk > Subject: Re: CSS and Netscape - was(CSS and dynamically changing > classes) > > - Original Message - > From: "Matthew R. Small" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 16, 2002 2:27 PM > Subject: RE: CSS and Netscape - was(CSS and dynamically changing > classes) > > > > You're right, this is a can of worms, but...Really, I am asking that > > Steve Case drop the Netscape browser altogether. I'm not exactly sure > > which standards that IE supports or doesn't support, or how NS > compares > > to it. > > Think about what you just said... > > > But the fact is that IE it's extremely forgiving, feature-rich, > > and just a great browser altogether, while NS is just a headache for > > designers. > > Sure it's a headache, and so are all those old Canadian drivers who come > down here every winter. Doesn't mean they are going away, nor do I want > them > to. They have money... > > > To tell you the truth, I don't know how they keep producing > > the NS browser. I't doesn't seems to me that it makes any money for > the > > company. > > AOL 8.0 is going to use the Gecko rendering engine. I'm sure that is > saving > them quite a bit in licensing fees and MS headaches. > > > The fact is that there are standards and that anything which > > makes the code easier to program and maintain should be included in > the > > standard. > > I keep screaming for a tag too, but nobody > listenssigh. > > > jon > > > __ 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
Recursive Query: Anything better??
I'm sure there is something better than what I'm doing, basically I want to
do a weekly count of how many people have signed up for our newsletter.
Here's what I have, it seems VERY inefficient. Any SQL gurus out there wanna
help me out? Thanks in advance.
SELECT count(id) as num
FROM MAIN
WHERE date between '#dateformat(DateAdd("d", -7, end))#' AND
'#dateformat(end, "mm/dd/yy")#'
[formatting clipped for
clarity]
John Venable
__
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 server and Interval data type
It seems to me you would need to store the string in the db, as the actual
amount of time would be different in different circumstances. e.g. for a
month you can't simply store 30 or 31 or 28
Perhaps you could store something like: 0:0:0:0:1:0:0:0:0:0 (for one month)
Hmm, just needs a cool UDF
- Original Message -
From: "Brian Scandale" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 9:09 AM
Subject: Re: SQL server and Interval data type
> Ahh yes Jochem... so true, However my puzzle still remains... what/how is
that handled in SQL Server... I did notice that one source says to import
interval data into SQL server set up a char field
>
> Now I'm wondering how that would work inside CF... trying to process it
that is...
>
>
>
>
> At 09:12 PM 4/16/02 +0200, you wrote:
> >Mark A. Kruger - CFG wrote:
> >> Ok - explain the interval data type. what is it and what does it
contain?
> >
> >Interval data type contains an interval (copy/paste from manual):
> >Type interval [ (precision) ]
> >Description for time intervals
> >Storage 12 bytes
> >Earliest -17800 years
> >Latest17800 years
> >Resolution1 microsecond
> >
> >Usage:
> >Quantity Unit [Quantity Unit...] [Direction]
> >Quantity: number
> >Unit: second, minute, hour, day, week, month, year, decade,
> >century, millennium, or abbreviations or plurals of these units;
> >Direction:empty or "Ago"
> >
> >Examples:
> >'1 12:59:10'
> >'1 day 12 hours 59 min 10 sec'
> >'1 day 10 sec'
> >'16 centuries 1 sec'
> >SELECT datefield + 5 * intervalfield - Cast('1 sec' AS INTERVAL) AS
duedate
> >etc.
> >
> >PostgreSQL Date/Time handling is cool and compliant :-)
> >
> >Jochem
> >
> >
>
__
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: CSS and Netscape - was(CSS and dynamically changing classes)
We're not talking about bad code. We're talking about forgotten table tags. We're talking about not fully scoping a variable. We're talking about the fact that when bad code does get written, you're a whole lot better off if you have internet explorer than when you have netscape. If you had to choose between riding in a car that was based on the fact that everything was always perfect in a perfect world then netscape works quite nicely. The fact is, IE takes into account the fact that code doesn't always get written like the rules say. It figures out the right most of the time and leaves you with options so your code is not left broken when multiple people who work on the application make a mistake here or there then it's left to somebody else to fix. You're right, writing things properly is always a good thing. Being able to account and correct mistakes rapidly is also. Now, let's attack me personally because I have these views. Yes, go ahead and attack the person instead of the views themselves. Show me how much class you've got. - Matt Small -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 5:07 PM To: CF-Talk Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) I certainly hope he is defending Netscape for requiring decent code. What you are talking about is bad coding. Pure and simple. And laziness. Just because IE currently allows you to code so poorly, and the page sometimes renders the way you want, doesn't mean it is a good idea. "Pushing code out" is, IMHO, no excuse for bad coding. Quite the opposite, in fact. Good code takes less time than bad code. To write, to debug, to maintain. I truly hope I never have to maintain your codebase. (Although I am currently fixing one probably quite like it). Shivering at the thought, Jerry Johnson >>> [EMAIL PROTECTED] 04/16/02 05:01PM >>> > Think about what you just said... Umm... no... I spent the afternoon debugging my pages because netscape isn't as forgiving as ie. I don't feel like thinking anymore. I guess that makes me a bad programmer though, and unprofessional. I use ie only here on the intranet because I don't have to spend time searching through the piles of code that I have looking for that forgotten table tag and its nice features that I can get to work the first time. If you love netscape, good for you. I don't, I know a LOT of people who don't, and it's an inferior product for that reason alone. No, I haven't read the w3 standardization for css or html or javascript or whatever. I have to spend my time pushing code out the door for production purposes. I don't even use stuff that is ie-only. I have a 1998 O'Reilly javascript book that I use and everything in it works on ie except where it says it won't. > I keep screaming for a tag too, but nobody > listenssigh. Oh, gosh, you're right. I wish I had a tag that does that also, but instead, I'll use ie, which saves me a lot more tedious tag-searching work than ns ever did. So, you're right. Sometimes I forget to put at the end of my page. Sometimes I forget to fully qualify my scopes when writing javascript and my css doesn't work. These are the things that I use that make netscape break into pieces. You're defending this? Matt Small -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:24 PM To: CF-Talk Subject: Re: CSS and Netscape - was(CSS and dynamically changing classes) - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 2:27 PM Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) > You're right, this is a can of worms, but...Really, I am asking that > Steve Case drop the Netscape browser altogether. I'm not exactly sure > which standards that IE supports or doesn't support, or how NS compares > to it. Think about what you just said... > But the fact is that IE it's extremely forgiving, feature-rich, > and just a great browser altogether, while NS is just a headache for > designers. Sure it's a headache, and so are all those old Canadian drivers who come down here every winter. Doesn't mean they are going away, nor do I want them to. They have money... > To tell you the truth, I don't know how they keep producing > the NS browser. I't doesn't seems to me that it makes any money for the > company. AOL 8.0 is going to use the Gecko rendering engine. I'm sure that is saving them quite a bit in licensing fees and MS headaches. > The fact is that there are standards and that anything which > makes the code easier to program and maintain should be included in the > standard. I keep screaming for a tag too, but nobody listenssigh. jon __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionau
Re: SQL server and Interval data type
Ahh yes Jochem... so true, However my puzzle still remains... what/how is that handled
in SQL Server... I did notice that one source says to import interval data into SQL
server set up a char field
Now I'm wondering how that would work inside CF... trying to process it that is...
At 09:12 PM 4/16/02 +0200, you wrote:
>Mark A. Kruger - CFG wrote:
>> Ok - explain the interval data type. what is it and what does it contain?
>
>Interval data type contains an interval (copy/paste from manual):
>Type interval [ (precision) ]
>Description for time intervals
>Storage 12 bytes
>Earliest -17800 years
>Latest17800 years
>Resolution1 microsecond
>
>Usage:
>Quantity Unit [Quantity Unit...] [Direction]
>Quantity: number
>Unit: second, minute, hour, day, week, month, year, decade,
>century, millennium, or abbreviations or plurals of these units;
>Direction:empty or "Ago"
>
>Examples:
>'1 12:59:10'
>'1 day 12 hours 59 min 10 sec'
>'1 day 10 sec'
>'16 centuries 1 sec'
>SELECT datefield + 5 * intervalfield - Cast('1 sec' AS INTERVAL) AS duedate
>etc.
>
>PostgreSQL Date/Time handling is cool and compliant :-)
>
>Jochem
>
>
__
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: CSS and Netscape - was(CSS and dynamically changing classes)
> I use ie only here on the intranet because I don't have to spend time > searching through the piles of code that I have looking for that > forgotten table tag and its nice features that I can get to work the > first time. > Boy, that reminds me of the mechanic that says 'Hey, I can't find that last lug nut, but it'll work with only 4' __ 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: Looking for fast, reliable and potentially cheap CF Hosting
Hey... Check out CFDynamics.com...terrific hosts! Fast servers, reliable (our monitoring shows them at 99.86% uptime) servers, high speed network with a lot of bandwith, good support...all at what I would consider good rates. Check them out. I am not associated with other than being a satisfied customer! Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 3:34 PM To: CF-Talk Subject: RE: Looking for fast, reliable and potentially cheap CF Hosting I agree - you get what you pay for. However, www.readyhosting.com has excellent rates, CF and SQL Support, and a ton of other advantages. I have a client with two sites on there, and have experienced almost no problems that weren't code related. My thoughts, not yours Shawn Grover -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:01 PM To: CF-Talk Subject: RE: Looking for fast, reliable and potentially cheap CF Hosting One thing to watch. What you pay for is what you get. If its almost to cheap.thats because it is. What do you want reliable or cheap(note this has nothing to do with mirhouse just simply a reply to the first post...) >>> [EMAIL PROTECTED] 04/16/02 03:37PM >>> http://www.mirhouse.com/ Rick -Original Message- From: slurpy slurpy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:36 PM To: CF-Talk Subject: Looking for fast, reliable and potentially cheap CF Hosting Hi guys, I've just finish a small web site for one of my clients. Need good and reliable hosting. The site is very small and there are small access DB currently MS Access, however will be glad if could switch to MS SQL. Any suggestions regarding the quality as well as pricings of such hosting are welcome. Thank you, Slurpy. - Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
I certainly hope he is defending Netscape for requiring decent code. What you are talking about is bad coding. Pure and simple. And laziness. Just because IE currently allows you to code so poorly, and the page sometimes renders the way you want, doesn't mean it is a good idea. "Pushing code out" is, IMHO, no excuse for bad coding. Quite the opposite, in fact. Good code takes less time than bad code. To write, to debug, to maintain. I truly hope I never have to maintain your codebase. (Although I am currently fixing one probably quite like it). Shivering at the thought, Jerry Johnson >>> [EMAIL PROTECTED] 04/16/02 05:01PM >>> > Think about what you just said... Umm... no... I spent the afternoon debugging my pages because netscape isn't as forgiving as ie. I don't feel like thinking anymore. I guess that makes me a bad programmer though, and unprofessional. I use ie only here on the intranet because I don't have to spend time searching through the piles of code that I have looking for that forgotten table tag and its nice features that I can get to work the first time. If you love netscape, good for you. I don't, I know a LOT of people who don't, and it's an inferior product for that reason alone. No, I haven't read the w3 standardization for css or html or javascript or whatever. I have to spend my time pushing code out the door for production purposes. I don't even use stuff that is ie-only. I have a 1998 O'Reilly javascript book that I use and everything in it works on ie except where it says it won't. > I keep screaming for a tag too, but nobody > listenssigh. Oh, gosh, you're right. I wish I had a tag that does that also, but instead, I'll use ie, which saves me a lot more tedious tag-searching work than ns ever did. So, you're right. Sometimes I forget to put at the end of my page. Sometimes I forget to fully qualify my scopes when writing javascript and my css doesn't work. These are the things that I use that make netscape break into pieces. You're defending this? Matt Small -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:24 PM To: CF-Talk Subject: Re: CSS and Netscape - was(CSS and dynamically changing classes) - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 2:27 PM Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) > You're right, this is a can of worms, but...Really, I am asking that > Steve Case drop the Netscape browser altogether. I'm not exactly sure > which standards that IE supports or doesn't support, or how NS compares > to it. Think about what you just said... > But the fact is that IE it's extremely forgiving, feature-rich, > and just a great browser altogether, while NS is just a headache for > designers. Sure it's a headache, and so are all those old Canadian drivers who come down here every winter. Doesn't mean they are going away, nor do I want them to. They have money... > To tell you the truth, I don't know how they keep producing > the NS browser. I't doesn't seems to me that it makes any money for the > company. AOL 8.0 is going to use the Gecko rendering engine. I'm sure that is saving them quite a bit in licensing fees and MS headaches. > The fact is that there are standards and that anything which > makes the code easier to program and maintain should be included in the > standard. I keep screaming for a tag too, but nobody listenssigh. jon __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
> I use ie only here on the intranet because I don't have to spend time > searching through the piles of code that I have looking for that > forgotten table tag and its nice features that I can get to work the > first time. > If you love netscape, good for you. I don't, I know a LOT of people who > don't, and it's an inferior product for that reason alone. > No, I haven't read the w3 standardization for css or html or javascript > or whatever. I have to spend my time pushing code out the door for > production purposes. > So, you're right. Sometimes I forget to put at the end of my > page. Sometimes I forget to fully qualify my scopes when writing > javascript and my css doesn't work. These are the things that I use > that make netscape break into pieces. You're defending this? I'll just say that I'm glad you are not in the automotive safety field. You may now remove your head from your arse and go back to writing bad code. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
Sure it's a headache, and so are all those old Canadian drivers who come down here every winter. Doesn't mean they are going away, nor do I want them to. They have money... OK...you wanna talk about Americans coming to Canadaoh I could have a field day with that one ;-) 1) Americans asking if the Canadian flag comes in any other colours (yes I spell it with a u..deal with it). Ask them the same question about the US flag and gee they get offended ;-) 2) Americans swearing they got to Victoria BC (where I live...it's on a big island) by a bridge. They will fight and bitch and moan that they are right. Now I'll tell you there is no bridge and the only way to the mainland is by ferry or plane!! 3) 4) 5) I could go on forever...but I won't ;-) Now Netscape sucks (standards compliant or not). It is our jobs as developers to code for it until the day it dies..it sucks but it's true. The 1 option that is coming available is to code your whole application in Flash MX and do away with the browser design issues once and for all. It may take just as long to write in Flash MX as it would to do proper cross browser code...but hey..no little design suprises like...hmmm...where's the whole page...oh ya I didn't close a table and Netscape puked. My 2 cents Canadian (about 2/3 a penny down south) Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com __ 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: CSS and Netscape - was(CSS and dynamically changing classes)
> Think about what you just said... Umm... no... I spent the afternoon debugging my pages because netscape isn't as forgiving as ie. I don't feel like thinking anymore. I guess that makes me a bad programmer though, and unprofessional. I use ie only here on the intranet because I don't have to spend time searching through the piles of code that I have looking for that forgotten table tag and its nice features that I can get to work the first time. If you love netscape, good for you. I don't, I know a LOT of people who don't, and it's an inferior product for that reason alone. No, I haven't read the w3 standardization for css or html or javascript or whatever. I have to spend my time pushing code out the door for production purposes. I don't even use stuff that is ie-only. I have a 1998 O'Reilly javascript book that I use and everything in it works on ie except where it says it won't. > I keep screaming for a tag too, but nobody > listenssigh. Oh, gosh, you're right. I wish I had a tag that does that also, but instead, I'll use ie, which saves me a lot more tedious tag-searching work than ns ever did. So, you're right. Sometimes I forget to put at the end of my page. Sometimes I forget to fully qualify my scopes when writing javascript and my css doesn't work. These are the things that I use that make netscape break into pieces. You're defending this? Matt Small -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:24 PM To: CF-Talk Subject: Re: CSS and Netscape - was(CSS and dynamically changing classes) - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 2:27 PM Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) > You're right, this is a can of worms, but...Really, I am asking that > Steve Case drop the Netscape browser altogether. I'm not exactly sure > which standards that IE supports or doesn't support, or how NS compares > to it. Think about what you just said... > But the fact is that IE it's extremely forgiving, feature-rich, > and just a great browser altogether, while NS is just a headache for > designers. Sure it's a headache, and so are all those old Canadian drivers who come down here every winter. Doesn't mean they are going away, nor do I want them to. They have money... > To tell you the truth, I don't know how they keep producing > the NS browser. I't doesn't seems to me that it makes any money for the > company. AOL 8.0 is going to use the Gecko rendering engine. I'm sure that is saving them quite a bit in licensing fees and MS headaches. > The fact is that there are standards and that anything which > makes the code easier to program and maintain should be included in the > standard. I keep screaming for a tag too, but nobody listenssigh. jon __ 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: Custom Tag
I would pass a list as a parameter and
make the whole stuff inside the custom tag code
Mario
--- Justin Scott <[EMAIL PROTECTED]> escribió: > > I
have a custom tag that I want to add some statements but I'm not
> > sure if this can be done.
> > Has anyone had experience doing this before?
> >
> > I'm passing the username, fullname and password
> from input boxes and the
> > password items with checkboxes
> > to my template.
>
> The syntax you're suggesting is not valid and will
> not work. When you call
> a custom tag, the actual number of attributes and
> attribute names being
> passed to it are static in the code.
>
> Your options are:
>
>
> 1. Use IIF() within the attribute values to
> determine the value to be
> passed, such as:
>
>MustChangePassword="#iif(FORM.select IS "mcp",
> de('yes'), de('no'))#"
>
> Using IIF() should be avoided whenever possible
> because it's slow, difficult
> for many developers to grasp and just plain evil.
> Not to mention your
> nested CFIF statements will need to be integrated
> into each of the IIF()
> calls. Very messy. Please don't do this.
>
>
> 2. Use a block of code (CFIF's, CFPARAM's, whatever
> you need) to determine
> the value of all of the variables in advance and
> pass them to the call to
> the custom tag. This is probably your best bet.
>
>
> 3. If the tag has mutually exclusive attributes, you
> can run your CFIF block
> and call the custom tag with the required attributes
> and values at each
> level of the nest. This would be the most flexible,
> but you'll end up
> repeating a lot of code.
>
>
> Hopefully that will shine a little bit of light on
> it..
>
> -Justin Scott, Lead Developer
> Sceiron Internet Services, Inc.
> http://www.sceiron.com
>
>
>
__
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: Error starting CF service
I made the cfserver user an administrator. BJ = = = Original message = = = post the what permission you changed for clarity and for archive purposes Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:34 PM To: CF-Talk Subject: Re: Error starting CF service In writing this email I figured out my own problem. It was a permissions issue. BJ = = = Original message = = = I just set up a new server and when I attempt to view the web page I get this error: * An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. ** So, I looked and the CF Application Server is not started. When I attempt to start it I get this error: *** Could not start the Cold Fusion Application Server service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error. If te problem persists, contact your system administrator. *** I checked the password on the cfserver account and everything looks ok. Any ideas? bjorno ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ 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 this SQL Error?
are you sure you are using transaction statements.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:11 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
We've run into this from time to time, it occurs when two or more users thry
to access the data at exactly the same time even though SQL is suppose to
handle it. Just refreshing it seems to clear up the deadlock. I haven't
heard any other solutions for resolving the problem though. Let me know if
you do.
***
Bob Imperial
Software Development Team
Schoollink, Inc.
910-223-2116 ext. 108
***
"Linking Schools to The World .. One Classroom at a Time"
-Original Message-
From: Houk, Gary [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 3:06 PM
To: CF-Talk
Subject: What is this SQL Error?
First time I've seen this one...what does it mean?
Diagnostics: ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID
60) was deadlocked on {lock} resources with another process and has been
chosen as the deadlock victim. Rerun the transaction.
__
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: Looking for fast, reliable and potentially cheap CF Hosting
Look at www.atswebnet.com. They have the best deal around for CF and SQL Server. Clint - Original Message - From: "slurpy slurpy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 2:35 PM Subject: Looking for fast, reliable and potentially cheap CF Hosting > Hi guys, > > I've just finish a small web site for one of my clients. Need good and reliable hosting. The site is very small and there are small access DB currently MS Access, however will be glad if could switch to MS SQL. Any suggestions regarding the quality as well as pricings of such hosting are welcome. > > Thank you, Slurpy. > > > > - > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > __ 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: Error starting CF service
post the what permission you changed for clarity and for archive purposes Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:34 PM To: CF-Talk Subject: Re: Error starting CF service In writing this email I figured out my own problem. It was a permissions issue. BJ = = = Original message = = = I just set up a new server and when I attempt to view the web page I get this error: * An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. ** So, I looked and the CF Application Server is not started. When I attempt to start it I get this error: *** Could not start the Cold Fusion Application Server service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error. If te problem persists, contact your system administrator. *** I checked the password on the cfserver account and everything looks ok. Any ideas? bjorno ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ 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: Error starting CF service
In writing this email I figured out my own problem. It was a permissions issue. BJ = = = Original message = = = I just set up a new server and when I attempt to view the web page I get this error: * An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. ** So, I looked and the CF Application Server is not started. When I attempt to start it I get this error: *** Could not start the Cold Fusion Application Server service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error. If te problem persists, contact your system administrator. *** I checked the password on the cfserver account and everything looks ok. Any ideas? bjorno ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ 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: Looking for fast, reliable and potentially cheap CF Hosting
I agree - you get what you pay for. However, www.readyhosting.com has excellent rates, CF and SQL Support, and a ton of other advantages. I have a client with two sites on there, and have experienced almost no problems that weren't code related. My thoughts, not yours Shawn Grover -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:01 PM To: CF-Talk Subject: RE: Looking for fast, reliable and potentially cheap CF Hosting One thing to watch. What you pay for is what you get. If its almost to cheap.thats because it is. What do you want reliable or cheap(note this has nothing to do with mirhouse just simply a reply to the first post...) >>> [EMAIL PROTECTED] 04/16/02 03:37PM >>> http://www.mirhouse.com/ Rick -Original Message- From: slurpy slurpy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:36 PM To: CF-Talk Subject: Looking for fast, reliable and potentially cheap CF Hosting Hi guys, I've just finish a small web site for one of my clients. Need good and reliable hosting. The site is very small and there are small access DB currently MS Access, however will be glad if could switch to MS SQL. Any suggestions regarding the quality as well as pricings of such hosting are welcome. Thank you, Slurpy. - Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax __ 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
Error starting CF service
I just set up a new server and when I attempt to view the web page I get this error: * An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. ** So, I looked and the CF Application Server is not started. When I attempt to start it I get this error: *** Could not start the Cold Fusion Application Server service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error. If te problem persists, contact your system administrator. *** I checked the password on the cfserver account and everything looks ok. Any ideas? bjorno ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.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: CSS and Netscape - was(CSS and dynamically changing classes)
- Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 2:27 PM Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) > You're right, this is a can of worms, but...Really, I am asking that > Steve Case drop the Netscape browser altogether. I'm not exactly sure > which standards that IE supports or doesn't support, or how NS compares > to it. Think about what you just said... > But the fact is that IE it's extremely forgiving, feature-rich, > and just a great browser altogether, while NS is just a headache for > designers. Sure it's a headache, and so are all those old Canadian drivers who come down here every winter. Doesn't mean they are going away, nor do I want them to. They have money... > To tell you the truth, I don't know how they keep producing > the NS browser. I't doesn't seems to me that it makes any money for the > company. AOL 8.0 is going to use the Gecko rendering engine. I'm sure that is saving them quite a bit in licensing fees and MS headaches. > The fact is that there are standards and that anything which > makes the code easier to program and maintain should be included in the > standard. I keep screaming for a tag too, but nobody listenssigh. jon __ 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: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
Actually, it was a problem specific to ADO. We switched the site to ODBC and the problem went away. Queries stayed the same. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 10:42 AM To: CF-Talk Subject: RE: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite Sounds like someone may have an overworked server. -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 10:20 AM To: CF-Talk Subject: RE: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite You generally see this error any time you lose a connection to the SQL Server. We see it every time we boot a SQL Server, which fortunately isn't that often. However, it also appeared when a particular query using ADO tied the SQL Server up in knots, preventing it from responding to requests from ColdFusion templates. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 12:31 AM To: CF-Talk Subject: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite Has anyone any experience with this error ? It started happening periodically a couple of weeks ago. Hit refresh, and the page usually comes up. No info on microsoft or macromedia's site. Four sites turn up on google that evidently have had the same problem. - Tracy -- 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. __ 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: Log File Analysis [OT]
I was going to say webalizer, but it seems you already found that. ;) > I apologize for the somewhat off-topic post (but we're runnin' CF ;). > Anyways, does anyone have some suggestions for a good web stats program that > will run on Linux and analyze apache logs? We've tried webalyzer, which > seems to be pretty good, but I'm curious as to what other options are > available. Thanks in advance for your time and feedback. > > Regards, > Dennis > > __ 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: What is this SQL Error?
Thanks Bob...I'll let you know if I find a workaround.
- Gary
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:11 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
We've run into this from time to time, it occurs when two or more users
thry
to access the data at exactly the same time even though SQL is suppose
to
handle it. Just refreshing it seems to clear up the deadlock. I haven't
heard any other solutions for resolving the problem though. Let me know
if
you do.
***
Bob Imperial
Software Development Team
Schoollink, Inc.
910-223-2116 ext. 108
***
"Linking Schools to The World .. One Classroom at a Time"
-Original Message-
From: Houk, Gary [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 3:06 PM
To: CF-Talk
Subject: What is this SQL Error?
First time I've seen this one...what does it mean?
Diagnostics: ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID
60) was deadlocked on {lock} resources with another process and has been
chosen as the deadlock victim. Rerun the transaction.
__
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: CSS and Netscape - was(CSS and dynamically changing classes)
Matthew R. Small wrote: > You're right, this is a can of worms, but...Really, I am asking that > Steve Case drop the Netscape browser altogether. And how is that going to help? Will that mean that all the installs of NN 4.x will magically disappear? Quite the contrary, the release of Mozilla 1 RC1 means that a new Netscape can't be far away. The arrival of Netscape 6.x (6.5 I believe) will be a much better incentive for NN 4.x users to get a standards compliant browser as anything else. > I'm not exactly sure > which standards that IE supports or doesn't support, or how NS compares > to it. http://webstandards.org/upgrade/ > But the fact is that IE it's extremely forgiving, feature-rich, > and just a great browser altogether, while NS is just a headache for > designers. Why a headache? Because you are required to use document.formname instead of formname? I'm sorry, but they actually mean something different. And if you have to code a secure CF application you have to code exactly the same way, up to using the variables scope for every normal variable. Try installing IE on *BSD/Linux/Solaris and you will know the real meaning of headache. > The fact is that there are standards and that anything which > makes the code easier to program and maintain should be included in the > standard. I strongly disagree. The people making the code are the professionals and the people visiting the website are the cluebies. Therefore, standards should be geared towards making the code work on the end of the person that receives it, because he doesn't understand anything. If that makes the code more diffcult for the professional, so be it. But if you really feel this way, maybe you are better of directing your energy at the W3C. Did you know that the behaviour of NN 4.x when it encounters a table with a missing end tag is more standard compliant as the behaviour of IE? After all, it says that the browser should make clear to the user there is an error in the code. Did you ever read any of the discussed standards? > If NS was the all around better browser, we would be using > that instead of IE, right, Mac and Betamax arguments not withstanding > because this is a free item we're talking about. Just because it is free the principles of marketing, bundling with other products, breaking stuff on purpose would not apply? Are you sure you live on Earth? > The whole point of this is that it's cost companies MILLIONS of > dollars in lost time developing and lost revenue due to features not > working similarly in both browsers because one company can't get it > right. I agree. The question is which company. http://www.eweek.com/article/0,3658,s=709&a=24177,00.asp Jochem __ 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: writing code dinamically
Looks like you need to use single quotes instead of double. It is most likely
taking the double quotes as string values
"Success is a journey, not a destination!!"
Doug Brown
- Original Message -
From: "Mario Martinez R." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002 12:29 PM
Subject: writing code dinamically
> Hi friends:
> Down there is the code that is eating my brain.
> If I take out the piece:
> It goes better. The inclusion of anything between
>is what is bringing me troubles.
> Basically what I 'm doing is writing dinamically
> javascript code in another frame.
> Any ideas ??
> Thank you in advance friends.
> Mario
>
>
>
>
>
>
>
> parent.catalogs.document.write(" rel=\"stylesheet\" type=\"text/css\"
> href=\"styles/framestyle.css\">