RE: ODBC/SQL Server Errors
I just wanted to post an update to the issue I posted earlier (below) in case someone else runs into this problem in the future. After having tried every other possible outlet, I created a temp database, transferred the data from the old database into the temp database, recreated the old database, and transferred the data back. This seems to have fixed the problem. Apparently, the database had become corrupt, and SQL Server didn't realize it. I still don't know what caused the problem, but at least I know how to fix it. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message----- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 24, 2000 9:53 AM To: [EMAIL PROTECTED] Subject: ODBC/SQL Server Errors We're experiencing a fairly difficult to troubleshoot SQL issue using ColdFusion 4.01/SQL Server 6.5 (w/ whatever the latest service pack is). Almost all UPDATE and INSERT statements started generating "37000 (Syntax error or access violation)" messages when executing queries involving VARCHAR fields, though not INTEGER IDENTITY fields. In other words, if I add a row with a mess of NULL values, the query executes. When I copy and paste the SQL statements into Enterprise Manager, it spits out: Msg 7134, Level 16, State 2 Command has been aborted. The ODBC error is too general to be of any use; the SQL Server error barely appears in the MSKB, and when it does, it's only in inapplicable situations that seem to have been solved by some early service pack. I've stopped and started the services, booted, and run all appropriate DBCC commands against the database. As far as I know, nothing has changed (famous last words). In fact, I was sitting at my workstation by the servers on Saturday surfing the site the server in question when errors first started appearing. I've already spent my weekend on this one. If anybody can spare my week, it would be greatly appreciated. Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF on WebsitePro - Frequent hangs
We used to run CF (4.01) on WebSite and the only time we ran into problems was when ColdFusion driven apps would have to make calls through a slow network. Specifically, we were making calls from a high traffic Web site across the Internet to a database server. The clients were connected via SSL and the SSL threads would pile up until the pool ran out. We increased the size of the pool and that seemed to fix the problem. I'd call O'Reilly's tech support. They have the best tech support staff that I've ever dealt with. Tell them what your problem is and any weird situations/work a rounds in place, and they'll tell you what you need to get back up and running. They won't laugh at you if you're doing something stupid: well, at least they didn't laugh at us. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Reed Powell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 25, 2000 10:48 AM To: [EMAIL PROTECTED] Subject: CF on WebsitePro - Frequent hangs Hello everyone - we're running CF on Website Pro on our production box, and see frequent hangs of the CF service(s). It's not uncommon for them to hang a couple of times a day. We ended up putting in a workstation that keeps an eye on the production box, and restarts the CF services if they don't respond. Do others see this behavior, either with Website or other webservers (such as IIS)? tia, -reed -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Books
What makes a SQL book good is subjective: it depends on what you want to do with SQL, which vendor's SQL implementation you are using, and what skill level you are at. Despite the fact that SQL is a "standard," you'll want to get yourself a book that discusses your vendor specific flavor of SQL (e.g. Microsoft, Oracle, Sybase, mySQL). We use Microsoft SQL Server almost exclusively so my choices are biased in that direction. Unfortunately, I haven't read any decent database administration books (vendor specific or otherwise), but I do have a few recommendations on the programming side: Beginners: The Practical SQL Handbook : Using Structured Query Language I believe this one is written by a bunch of ex-Sybase employees, but it is pretty universal. Advanced: Transact-SQL Programming by O'Reilly Covers Sybase and Microsoft SQL Server Both are excellent books. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call a javascript button
This will close the current window. However, if JavaScript did not create the window, the client will receive a JavaScript prompt. I've added a button which can be used to redirect the window to another page without submitting the form. This is only supported in newer browsers (4+). You may just want to embed another form for this if you want to support older browsers. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call a javascript button
>This is only supported in newer browsers (4+) I should explain my statement a little better. The JavaScript function "close()" and property "location" are almost universally supported by any client that supports JavaScript. It's the HTML INPUT element of type "button" that is only really supported in 4+ generation browsers. Sorry if I confused you. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call a javascript button
>Are you saying you can nested forms? No, at least not from my experience. I meant that for backwards compatibility, you would have to make use of multiple forms in the page. Something like: To the end user it would appear like a single form since the only input elements displayed by the second to forms are submit buttons. Since the form buttons are of the type "Submit" rather than "Button," they are backwards compatible. The down side to this method is that you may have to create some invalid nesting structures to try and lose the white space created by the various tags, a particularly egregious design/display issue in the various browsers. Since most of my forms are tabled for layout purposes, I usually nest the tags in tags, much to the horror of the W3C, I imagine. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: $1,000 servers (was: High-Powered Scaling)
Where I used to work, the decision to use Dell something of a company policy. I prefer to purchase, build and maintain "clone" machines for the following reasons: 1) %50 to %75 cost savings for the same or better system. 2) Dell uses proprietary RAM and charges at least 3x the going rate. 3) Dell puts unrealistic (and in my mind, unnecessary) restrictions on the amount of RAM you can put in a box, killing the one true upgrade path left in modern computers. 4) Dell short-changes the consumer on DIMM slots: you have to throw out memory to add more. 5) Dell uses proprietary motherboards with onboard video (and sound in the case of their desktops). 6) Dell's warrantee/replacement policy is great if something breaks on a week day between the hours of 5 and 9: otherwise, you're screwed. Although their phone support is fine (minus the hours on hold with Mozart's 5th), they've never walked into my office to fix anything: I end up doing all the work anyway. The only time a member of their tech support staff has told me something I didn't already know, it was because Dell was using a proprietary setup (RAID card, Motherboard, Video Card, etc.) that I couldn't find information about anywhere else. As far as the applications they load on servers before you get them, you can keep them. The fact that they would even preload so many computer crashing applications of questionable usefulness onto a server is absolutely ridiculous. I made a practice of reinstalling NT on Dell's immediately after I took them out of the box. I find this greatly increases the OS life expectancy and reduces the crash frequency. Now, I don't mean to pick on Dell in particular, but their name was mentioned, and I happen to have quite a bit of experience with their servers, desktops and support. All in all, Dell is in my mind, the best of the brand name products, both for servers and for the desktops. And, to give the Devil his due, I really appreciated their online driver library: I found it very comprehensive, accurate and up-to-date. I'll stop ranting now. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 The facts, in my case, are that the 15 percent that I might pay for Dell over SAG (I couldn't find telenet) is worth it to me, because, over the past five years, Dell has really stood by their machines. I have purchased about 50 Dells and speced hundreds. We have had a DOA machine, which was replaced the next day and we have had machines fail in the last month of warrantee, but the service has been great. The phone support is also great, but the best thing, from my perspective, are the setup and configuration utilities and instructions which ship with the machines. These save hours on machines with complex setups and greatly simplify management. A few years ago we were buying (on the NT side) a mix of IBM, HP, Compaq and Dell. We whittled it down to just Compaq and Dell and, now, we are buying Dells almost exclusively. SAG, BTW, charges about the same price for RAM as Dell At 11:51 AM 7/27/2000 -0700, you wrote: --- snip --- >The savings comes down to the fact that if you build your own, or >preferably hook up with a company like telenet, you won't pay for the name >"Dell", which adds about 20% to the price tag. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: what is better varchar or char
>I was told that char is better than varchar. Is this right? >I am going to have fields that are set to be either 25 50 100 or 150 >characters long. Is there a reason any of these fields should be char or >varchar? I have always used varchar but I would like to know what is best. As in most things, "Better" is a relative judgment. The primary difference is that CHAR fields are right padded with spaces which can make them difficult to work with if your data is not all of the same size (say an SKU that is always a certain number of characters in length). VARCHAR fields store variable length character data without padding the data with white space. In my experience, the data stored in VARCHAR fields is easier to work with because I find I'm using the TRIM() function often with CHAR fields to eliminate the excess spaces. One other key difference in terms of functionality is that the CHAR data type does not allow null values. If you create a field in a table as CHAR with nulls allowed, SQL Server will just create that field as VARCHAR and you'll never know the difference except if you expect the data to be padded. Since the CHAR data type has less overhead associated with it, it is slightly faster than the VARCHAR data type. However, this is very minimal performance gain, one that is completely negated if you find yourself using the TRIM() function on the ColdFusion side. >Feel free to respond directly to me since it is OT ;-) Actually, I think this is pretty right on. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: appropriate SQL 7 licensing for CF website
SQL Server w/ as many client licenses as servers/workstations will be connecting to it (including the server SQL Server is running on) and the Internet Connector License (about $3000). -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 6:05 PM To: [EMAIL PROTECTED] Subject: OT: appropriate SQL 7 licensing for CF website Hi All, I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. I need to know which version of sql 7 I should purchase for unlimited internet connections/not developer connections I seem to recall that it's different than the true UNLIMITED client version which retails for something like $30K ... is there something cheaper than that -- what do most people do for their web sites?? THX! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: appropriate SQL 7 licensing for CF website
It sounds like the only thing that changed is that the server on which SQL Server is installed now needs its own special license, a "Server License." The CALs for workstations and ancillary servers are still necessary, as well as the Internet Connector for Internet users. Could they make this stuff any more complicated? Oh well, I guess it's still not as convoluted as the Oracle licensing scheme. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 9:30 AM To: [EMAIL PROTECTED] Subject: Re: appropriate SQL 7 licensing for CF website FYI new pricing model from microsoft http://www.microsoft.com/sql/productinfo/pricing.htm ~Justin - Original Message - From: "Benjamin S. Rogers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 01, 2000 2:20 PM Subject: RE: appropriate SQL 7 licensing for CF website > SQL Server w/ as many client licenses as servers/workstations will be > connecting to it (including the server SQL Server is running on) and the > Internet Connector License (about $3000). > > -Original Message- > From: PC [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 6:05 PM > To: [EMAIL PROTECTED] > Subject: OT: appropriate SQL 7 licensing for CF website > > > Hi All, > > I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. > I need to know which version of sql 7 I should purchase for unlimited > internet connections/not developer connections I seem to recall that > it's different than the true UNLIMITED client version which retails for > something like $30K ... is there something cheaper than that -- what do > most people do for their web sites?? > > THX! > > -- -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: appropriate SQL 7 licensing for CF website
One thing to note when pricing these products is that Microsoft's site only lists the suggested retail price. I just saw a site that listed the Internet Connector for $1500. SQL Server itself (and its CAL packs) didn't have quite the same price reduction. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 11:17 AM To: [EMAIL PROTECTED] Subject: RE: appropriate SQL 7 licensing for CF website > >To run SQL Server legally on the internet, you NEED the Internet > > Connection License - this is not a cheap thing. > > Nope. Not so. You only need as many CALs as you have > simultaneous connections. Of course, if you have a lot > of connections, the Internet Connector is less expensive > than CALs. True, but since SQL Server and a 25 user license costs $3,999 and SQL Server (with 5 user) costs $1,399 plus internet one costs $2,999 (total cost of $4,398), then you'd have to NEVER have over (roughly) 27 concurrent users on-line, in which case, you're VERY light on load, so is SQL Server really necessary? Since Access 2000 handles light loads quite easily (better than Access 97 anyways), then with that load level, you could use that and save yourself thousands of dollars Put it this way, we have one fair load site, and it hits about 30-40 concurrent quite often - as soon as you break the amount of users you've bought, then you're breaking the agreement (and therefore the law), even if it's only for a fraction of a second, it's still breaking your client level. Here's the funny thing with their licensing; SQL Server & 5 Client $1,399 20 Client Licenses $2,369 Total £3,768 SQL Server & 25 Client $3,999 WHY is the separate license version over $200 cheaper, and how stupid would you have to be to buy the more expensive one? (that took me 5 seconds of math to save me $231 - unless you get paid more than that, then it's worth buying separates!) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: appropriate SQL 7 licensing for CF website
The pricing I mentioned was for Microsoft SQL Server 7 and the appropriate version 7 license add-ons. And before you ask, no, this is not Academic pricing. :) In fact, most sites offer SQL Server 7, CAL packs, and the Internet Connector at significantly discounted rates. Our company wholesales hardware and software, but we can't get SQL Server as cheap as most of the major online software retailers are selling it for. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 12:31 PM To: [EMAIL PROTECTED] Subject: RE: appropriate SQL 7 licensing for CF website > One thing to note when pricing these products is that Microsoft's > site only > lists the suggested retail price. I just saw a site that listed > the Internet > Connector for $1500. SQL Server itself (and its CAL packs) didn't > have quite the same price reduction. Check the version - I saw the same offer on another website for SQL Server 6.5 - this wouldn't (legally) effect SQL Server 7 Some sites don't mention the version until you get it delivered, which is REAL useful Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Rackmount Monitor/Keyboard/Mouse Switches
My apologies for the off topic post, but I rarely receive responses off the CF-Community list. Anyway, on to the question. What's everyone using for rack mount monitor/keyboard/mouse switches? We're a little dissatisfied with our current solution. We're looking for a piece of hardware that: 1. Requires absolutely no software loaded on the server. 2. Can support (preferably) up to 16 servers with a single unit. 3. Supports true hardware emulation (not a scenario in which the switch has to be turned to a server when it boots so that the server picks up the keyboard and mouse) Any suggestions would be greatly appreciated. Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Functions in Cold Fusion
Hmm...a very interesting proposition. How about the following: ArrayFind() ArrayFindNoCase() ArrayContains() ArrayContainsNoCase() In regards to your requirements, I imagine the ColdFusion function ArrayToList() could be used in conjunction with the respective list functions to "mimic" the functionality of the aforementioned functions. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 1:10 PM To: [EMAIL PROTECTED] Subject: Re: Functions in Cold Fusion OK, I need some community input here. For my article on custom functions, I've written one for IsEmail and IsPhone. Can people send me a few others to 'add in'. I'd like the article to have a few pre-built functions that can be used right off the bat. The only limits are that they must be built using functions in CF. No tags. For example, IsPhone uses this code: REFindNoCase('([0-9]{3}[-_. /]?)?[0-9]{3}[-_. /]?[0-9]{4}', number) - Original Message - From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 01, 2000 12:42 PM Subject: Re: Functions in Cold Fusion > I'm currently writing an article for the next Fusion Authority (out in the > next day) on how to write and use custom functions in CF. This is not using > modules or any CF tags but is actually using function calls. It's a bit of a > hack and can look ugly in places, but it works. The result is that I can > have something like IsValidEmail(email) and it'll return a value that says > yes or no. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Safari Issues
> A lot of the benefits of web standards will only be available in the future, > so they offer little current benefit. However, if you're building a web > application that you expect will be around for three to five years, it makes > sense to build it in such a way that you won't have to replace things > unnecessarily over the lifespan of that application. Though I agree in principle, this hasn't proved an issue (yet). Most public Web sites I've worked on get a major look-and-feel overhaul (for marketing purposes if nothing else) every one to two years. There simply isn't any longevity as far as the public sites go. Designing intranets for corporate customers is a different story. They pick a version of Internet Explorer and use that for 4 years. So, we design to that version, using every proprietary trick Internet Explorer provides to provide the best experience, usability wise, that we can. If they chose Mozilla, we'd use every proprietary Mozilla trick. Some would argue about my definition of proprietary since Mozilla's open source. Nevertheless, Mozilla offers a lot of technologies that aren't Web standards (though they may utilize them). Regardless, corporations tend to pick one thing and stick with it for a long time. If they do upgrade, they generally pick the path of least resistance (i.e. the latest version of Internet Explorer) and Microsoft tends to be pretty good about backward compatibility (hence, the tangled mess that many of the applications and APIs are in). -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: printing
To my knowledge, there is no way to do it without plugins like ScriptX from MeadCo: http://www.meadroid.com/scriptx/index.htm Even then, it only works in IE. However, the same company makes a product which embeds IE in the Netscape browser. :) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 7:51 PM To: CF-Talk Subject: printing Hello, I'd like to allow users to print out letters generated by CF - and I'd like to avoid the page title top, URL on the bottom of the page. What is the simplest way of doing this? I'd really like to use plain HTML, is there a Javascript command which will disable header/footer printer output? I'm triggering the letter to print with: function sendPrinter() { if( window.print ) { window.print(); } } Thanks in advance! -Lou (I orginally posted when the list was down, so I'm giving this another shot...) __ 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: CFPOP Question
> 1. The date field when it comes in is not a TRUE > date field thus I can not use CreateODBCDate or > DateFormat on this field to grab JUST THE DATE and > then JUST the time. IDEAS??? ParseDateTime(Date, "POP") Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ 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: CFPOP Question
Not off hand, sorry. :( Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:48 AM To: CF-Talk Subject: RE: CFPOP Question Thanks.. any idea on the 2nd question? >>> [EMAIL PROTECTED] 05/21/02 10:45 AM >>> > 1. The date field when it comes in is not a TRUE > date field thus I can not use CreateODBCDate or > DateFormat on this field to grab JUST THE DATE and > then JUST the time. IDEAS??? ParseDateTime(Date, "POP") Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ 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: Webtrends alternative
> >StatsServer from MediaHouse/DeepMetrix works very well. Try to get your > >hands on v5.03 tho, its the best. > > I agree. They really bloated the latest version. I'm running 5.03 and > all my clients love it. Our experience has been opposite. Though we were in general happy with 5.x and had some issues with early 6.x releases, the latest version is by far the fastest, most stable statistics analysis application we have ever run. That server has been running flawless for months. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ 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: Webtrends alternative
> I stuck to 5.x because of the stories about 6.x. We upgraded almost as soon as we could because we were having problems with 5.x corrupting its own database and some other issues. The first builds of 6.x were fast, but they were buggy. Then, they got the functionality squared away, but generating reports was slow (though not much slower than 5.x). Finally, the 6.2 build pulled it all together. We haven't had a single problem with that. > How > much memory is v6 using? Currently I'm drawing about > 15 mb, but have plenty to spare on the server. We're reporting stats on a couple hundred Web sites hosted off of several Web servers. The collector runs on the same box as the stats and the database engine (mySQL). Our current memory usage is: Collector: 70 Megs LiveStats: 42 Megs mySQL: 5 Megs Basically, LiveStats is using all the available memory in the system as, say, Microsoft SQL Server would do. I think part of the reason that the new LiveStats is so much faster than prior versions is because of 1) the distributed model and 2) better memory management. Our current uptime is only 17 days because of a Windows 2000 patch. We haven't booted the server because of a LiveStats related problem since installing the latest version. By the way, DeepMetrix actually recommends using Microsoft SQL Server for better performance. However, since just about every report request generates in a second or two, we don't see the need to place the burden on our SQL Server. > Was upgrading relatively painless? The upgrade (especially in the latest build) was pretty painless. When we did it, there wasn't a completely automated way to bring the data over from the old installation. You had to export the data from the old Web servers and import them into the new site. What we should have done was just unzipped all the log files for all the sites and allowed LiveStats to re-import them. That would have probably been less tedious in the long run (we missed some, we imported some twice, we imported some into the wrong server, etc.). Additionally, since the new LiveStats extracts so much more information from the logs, it would have given us much historical data that a lot of our Web sites do not have. Anyway, hope this helps. We are really pretty happy with the latest version. Though we probably would have been better served to wait out the first few builds, we were anxious to get away from 5.x. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ 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: TO ALL: Request for ColdFusion SP2 Input - locking
Amen. Automatic locking should be the default. After all, this is how a good RDBMS works (and a good application server for that matter). If the developer wants to override the default locking mechanism to ensure transactional integrity, then that tool should be available to the them. But don't shuffle the entire burden of locking off onto the developer because you're asking a single threaded application server to behave as a multi-threaded one. That's inexcusable. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:34 PM To: CF-Talk Subject: Re: TO ALL: Request for ColdFusion SP2 Input - locking It is probably too big a change for just a service pack - but maybe keep it in mind for the next point release: I would like to request an option to automatically lock variables. I read the "best practices" paper on the allaire site that explains why you don't have it - but you have to understand our point of view. I (and I am sure everyone else on this list) have thousands of templates that I started writing with Cold Fusion 2.0, that work perfectly. There isn't time to look at every template that I ever wrote, and add the locking code for it, so it is just sitting on the server, probably causing the server to become unstable. I would gladly give up a little performance to have automatic locking, to gain stability. I would set it up so that you can turn it on | off in the cfapplication tag on a project by project basis, so for apps where it is important for consistency issues or perfomance issues, I can do it manually, or if the app is on a shared server - we can be sure to have the right setting, not having to rely on the isp to decide which setting is best. I would have it default to automatic locking unless explicited selected not to have it. thanks Al Musella, DPM Musella Foundation >i know one of the items that makes me very uncomfortable is the apparent >code incompatibility on the locking issues. i.e. code written for CF server >4.5.1 locking doesn't easily work on 4.0 and vice versa.. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Moreover.com Categories List via WDDX
You need to CFHTTP the feed your after. Don't grab the WDDX version but the ColdFusion WDDX version. They've created a separate feed to "overcome a bug in ColdFusion." I'm not exactly sure to what they're referring, but oh well. Here's some code from a site I'm working on right now site. I had to condense it a little since I actually store the news feed in the Application scope and only refresh the query every hour. Hope this helps. By the way, a custom tag was recently added to the Allaire Tag Gallery for just this purpose. It probably simplifies the code substantially. http://p.moreover.com/cgi-local/page?index_health+cf" method="GET" resolveurl="false"> Health News #Headline_Text# #Source# - #DateFormat(Harvest_Time, " d ")# -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 10, 2000 9:40 AM To: CF-Talk Subject: Moreover.com Categories List via WDDX Good Morning, Is anyone out there grabbing the list of categories from Moreover.com using WDDX? I have been grabbing individual headlines using it, but their example page of using CF for grabbing the categories is blank. If you are doing this (grabbing the complete category list via WDDX), would you be willing to share the code? Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF 5.0 "Bug Vote" is Now Open!
Wow, relax, man. How long have you been programming? Better yet, how long have you been programming in ColdFusion? How many times have you referenced a Session variable or called CFFILE without using CFLOCK? How many times have you neglected to not used CFLOCK around transaction sensitive queries? Better yet, do you really expect us to believe that you look at the ColdFusion error logs on every one of your servers every morning and fix every single error that caused that message even if you can't reproduce the error and don't know what might have caused it? My guess would be you do your best to fix the errors that are reported to you and that you can verify and that how much time you spend trying to verify an error is determined by how easy it is to reproduce, the number of users reporting the error, and whether or not one of those users happens to also be the client. Am I far off? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 7:48 PM To: CF-Talk Subject: Re: CF 5.0 "Bug Vote" is Now Open! If you have known bugs in CF 4.x (well, not *if*), why would you knowingly release the next major revision without correcting them Are you stating that unless someone "votes" to remove a bug, we can expect to see it perpetuated in the next release? Do bug fixes have that low of a priority at Allaire? Jim - Original Message - From: "Damon Cooper" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 24, 2000 4:42 PM Subject: CF 5.0 "Bug Vote" is Now Open! > Register your bug for the Most Wanted list that will be targeted for > inclusion in CF 5.0! > > Email mailto:[EMAIL PROTECTED]?subject=CF%5.0%20Bug%Vote to vote > your CF Bugs in! (Bug Reporter #'s required, please). > > If you don't have a Bug Reporter #, you can enter and create one > using the Bug Reporter at > http://beta.allaire.com/bugreport/beta_bugtrack.cfm > If you aren't signed up on the Beta site, NEW Beta customers can > sign up at http://beta.allaire.com/bart. > > Regards, > > Damon Cooper > CF Release Manager > Allaire Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: .htaccess for IIS?
Nothing built in. AuthentiX by Flicks (http://www.flicks.com) is probably your best bet. It's a COM object so you can talk to it with CFOBJECT. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 5:11 AM To: CF-Talk Subject: OT: .htaccess for IIS? I realize this may be off-topic, but I'm looking for a way to manage directory access on IIS with a CFM application. The rub is that the web pages to be protected themselves will be asp and/or standard html (Frontpage Extensions of all things!), so I can't simply plonk an application.cfm in there to keep everything in check. We've made a small application to do the same on Linux, but there it's relatively easy since you can create htaccess files. Is there an equivalent thing for IIS? Or failing that, is there a simple way to add/modify/delete directory access in IIS? We're talking a database of possibly hundreds of people who each need their individual passwords, and *no* way to use ColdFusion for the serving end of things. Michel Vuijlsteke Netpoint NV Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cybercash or Authorizenet
I haven't run CyberCash in the past few years and I've heard that they've made some substantial improvements to the application and the underlying architecture, but we had some serious problems with the application on the server side. It was an incredible resource hog, prone to frequent crashes. When we used AuthorizeNet for the first few times, we couldn't believe how easy it was and how much more quickly transactions seemed to process. Of course, that was all a couple years ago. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 9:13 AM To: CF-Talk Subject: Cybercash or Authorizenet These are my 2 choices what are the good and what are the bad? Robert Everland III Web Developer Dixon Ticonderoga Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HTML Editor
Most of the solutions out there (especially the ColdFusion ones) are all based on the MSHTML editor. Information developing applications using this component can be found here: http://msdn.microsoft.com/workshop/browser/overview/editing.asp Here's a list of the most popular ones that I've seen around. I know there are a couple people from some of these companies on this list who will probably want to interject on behalf of their company. However, we just researched this fairly extensively. This is a combination of our opinions from evaluating the products and information gathered from the sales people. Please take it for what it is worth: HTMLEdit This is not a ColdFusion solution but I would be remiss not to mention it since it is such a quick and easy solution that probably meets many peoples' needs. http://javaboutique.internet.com/HTMLEdit/ Pros: Simple and Open Source. Cross-platform and cross-browser. Cons: Very, very few features (i.e. only includes basic HTML editing). HTMLAREA http://www.iautomated.com/ Pros: Free (Lite) Version. Cross Platform. Cons: Interface needs some work (i.e. bulky and clumsy); missing some of the features. Pay version is not particularly cheap. Not cross-browser (IE only). ActiveEdit http://www.cfdev.com/ Pros: Cross-platform and Inexpensive. Integration with some other products from the same company like ActiveScan. Cons: Interface needs a little work (i.e. a little clumsy and can't be embedded into a page) and it's missing a couple features (e.g. dictionary), most of which are coming out in the next version. It is not cross-browser (IE only). eWebEdit http://www.ektron.com/ Pros: Nice interface with all the features. Cross-browser and Spectra-ready. Cons: Really (really) high price tag (Although according to their sales rep they haven't figured out their pricing yet so this may change). Not cross-platform (Windows only). Hope this helps. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Deepak Agarwal [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 11:50 AM To: CF-Talk Subject: HTML Editor This is a multi-part message in MIME format. --=_NextPart_000_0013_01C0400C.0B8318A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can anyone suggest me a good HTML Editor tag, that can be used in cfm = templates/Spectra. Thanks in advance. Deepak 703.633.4257 --=_NextPart_000_0013_01C0400C.0B8318A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can anyone suggest me a good HTML Editor tag, = that can be=20 used in cfm templates/Spectra. Thanks in advance. Deepak 703.633.4257 --=_NextPart_000_0013_01C0400C.0B8318A0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: mail server
I second this one. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 3:05 PM To: CF-Talk Subject: Re: mail server Check out VOPMail at www.vircom.com. Great product with great support and a good user community. The unlimited license runs about $750. Jim - Original Message - From: "Brad Roberts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 30, 2000 12:55 PM Subject: OT: mail server > We are getting ready to set up our server and need a mail server package. > Anyone have suggestions? Running Win2k, 733mhz, 512meg ram. Would like to > stay under $1000 with unlimited email accounts. > > Thanks, > > Brad Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mail Servers
> Vopmail still has a problem with from lines of just a name and no domain. > Vopmail assumes the sender must be from the default domain and the server > and then will let it relay. That is a definite no-no. Thus it is very hard > to get VOPMail off the spam block lists. Oddly enough, this just went through the VOPmail list. Indeed, VOPmail does not check the actual account, only the domain. This is not a bug but by design as checking the existence of the actual account is next to worthless since almost all domains have a postmaster account. Even if the domain does not have a postmaster account, a DNS lookup should reveal one or more accounts. > Vircom has been aware of the problem for some time, yet they have been > unwilling to do anything about it. Actually, they've been busy working on features that will actually have some benefit, such as preventing spam without disrupting service. > I too have strongly recommended Vircom's > VOPMail in the past. But this recent discovery of a spam hole and lack of a > fix from Vircom over a known spam hole makes me question my past > recommendations. Actually, even the RBLs call VOPmail a "Best of Breed" product when it comes to anti-relay/anti-spam functionality: http://maps.vix.com/tsi/ar-fix.html#vopmail Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mail Servers
Steve, The only way to prevent entry into the ORBS database is to restrict relay to your local network, either by IP address or by blocking the port, or to perform some sort of authentication such as SMTP AUTH or POP before SMTP. Do not think for one minute that your mail server is secure because it checks the validity of the account specified in the RCPTTO command. Most relay checkers, including those used by ORBS, check for this vulnerability. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: [OT] Mail Servers
> Someone else on this list recommended VOPMail and I was simply pointing out > that VOPMail has a known problem with RBL's that you might want to watch out > for. As to why Vircom leaves that spam hole open, is probably a topic for > off this list. Steve, Again, filtering by the RCPTO command is itself a whole. That is why Vircom has not pursued it. To everyone else, my apologies for perpetuating an off topic discussion, but inaccurate information like this can leave servers open, making relay possible. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mail Servers
> If a host receives 1,000,000 e-mails from a single host in a day, can't it > be flagged as suspicious activity and rerouted to a temp account or dumped? Many mail servers are capable of this or some similar behavior. For instance, as you probably guessed by watching this thread :), our shop uses VOPmail (among other mail servers). VOPmail has a feature that forces the server to wait a period time in between each message over a certain number of legitimate or illegitimate messages from a single source. The delay is nice because it doesn't touch the mail and tie up resources on the VOPmail server. Instead, it places the burden on the sender (ostensibly the offending relay mail server). Although this is a nice feature for decreasing the amount of mail that accumulates through a dictionary attack, this is not good relay protection because it only take one piece to get through and get reported to the ORBS database. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 At 10:18 PM 11/13/00 -0500, you wrote: > >> Our spam protection is basically not allowing any > >> messages originating outside our network to be > >> delivered to any domain not hosted on that VOPMail > >> machine > >That spam protection won't help you if a spammer uses a dictionary list to >send email. The most common type of spam right now is a dictionary attack on >domains you host, not relaying to hosts you don't. > >meaning they will send hundreds of thousands of messages addressed like this > >[EMAIL PROTECTED] >[EMAIL PROTECTED] >[EMAIL PROTECTED] >[EMAIL PROTECTED] >[EMAIL PROTECTED] >[EMAIL PROTECTED] > >And so on. One host I know routinely gets upwards of a million emails a day >addressed like this. This is the greatest single threat to ISP's today. Most >servers can't handle this. > > - Steve > > >-Original Message- >From: Justin Scott [mailto:[EMAIL PROTECTED]] >Sent: Monday, November 13, 2000 5:15 PM >To: CF-Talk >Subject: Re: Mail Servers > > >Interesting. I'll see if we can contact Sylvain and get something done >about that if it really is a confirmed spam hole. > >Our spam protection is basically not allowing any messages originating >outside our network to be delivered to any domain not hosted on that VOPMail >machine. Since this is configured by IP address, the "from" address really >isn't an issue in our configuration. > >-Justin Scott > > >- Original Message - >From: "Steve Pierce" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Monday, November 13, 2000 1:14 PM >Subject: RE: Mail Servers > > > > Vopmail still has a problem with from lines of just a name and no domain. > > Vopmail assumes the sender must be from the default domain and the server > > and then will let it relay. That is a definite no-no. Thus it is very hard > > to get VOPMail off the spam block lists. > > > > Vircom has been aware of the problem for some time, yet they have been > > unwilling to do anything about it. I too have strongly recommended >Vircom's > > VOPMail in the past. But this recent discovery of a spam hole and lack of >a > > fix from Vircom over a known spam hole makes me question my past > > recommendations. > > > > - Steve > > > > > > -Original Message- > > From: Justin Scott [mailto:[EMAIL PROTECTED]] > > Sent: Monday, November 13, 2000 2:10 PM > > To: CF-Talk > > Subject: Re: Mail Servers > > > > > > > Having problems with SMTP and hops. > > > What mail server(s) does anyone recommend to work well with CF 4.5. > > > > > > Thanks for your time. > > > > I prefer VOPMail from Vircom myself. It handles just about whatever you >can > > throw at it very well, and has full database integration built in so you >can > > manage all your mailboxes via ODBC if you want. > > > > ___ > > > > Justin Scott :: [Staff Developer] > > http://www.annex.com > > > > > > -- >-- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send >a > > message with 'unsubscribe' in the body to >[EMAIL PROTECTED] > > > > -- >-- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe:
RE: Netscape 6 out UGH!!!!
> In case it helps anyone, this is the resource that I used to > make my stuff work in N6 as well as the other two: Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Internet Explorer Not Expiring Session Cookies
Hi Folks, We've come across a difficult to track down problem and we're wondering if anyone has experienced this behavior before. We use client variables exclusively. With the initial request to the site, we perform all the usual browser checks and such, caching that information in Client variables. In addition, we set a session cookie (e.g. one that expires when the browser is closed). With each successive request, we check to see if the session cookie exists: if it does, we extract the cached information from the client variables. This seems to work fine in most of the time. However, there seems to be a problem with generation 4 and up versions of Internet Explorer in which the session cookie never gets expired. Consequently, if a user hasn't been to the site in some time, the client variables have been deleted, yet the cookie exists so the application expects the client variables to exist. Needless to say the application tries to access a non-existent client variable and throws and error. We have a work around in place but it bothers us that we can't determine what the actual cause of the problem is. Our best guess is that some users are running personal security software with cookie management, something that integrates into Internet Explorer. If anybody has any ideas, we'd love to hear them. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~ 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_BOOLSEARCH tag
> I am new to Cold Fusion have inherited an application written by outside > consultants that is being brought in-house. In the code I see a tag > CF_BOOLSEARCH. I have not installed any custom tags, so I don't think it is > one, yet I can't find any documentation/information on this tag. If the tag begins with "CF_", then it is a custom tag. Since custom tags can be stored in the \CFUSION\CustomTags\ directory, they are not necessarily bound to the site and the folks who gave you the site my not have known that the site made use of that tag. In any case, there is a custom tag in the Developer's Exchange of the same name. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476C7-2830-11D4-AA 9700508B94F380&method=Full I would download and research this tag to see if it isn't the same one the developer's used on the site. If it isn't, perhaps it performs the same function and you can convert the site to make use of this tag. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~ 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:
You might try adding "table-layout:fixed" to the style attribute of your table tag. I haven't tried it myself but it might be worth a shot. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 2:49 PM To: CF-Talk Subject: RE: > So it appears that does not work within a table. Am I > correct? This seems like a SEVERE limitation of the tag. What site > doesn't use tables to format output? This isn't a limitation of the tag, but rather a limitation of the browser. To display a table on the page, the browser needs to know everything about the table at once, generally, so if you don't provide all of the table data at once, the browser won't show any of the table until it receives the rest. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ 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: E-commerce
Also, there is also a shopping cart system in the example applications that come with ColdFusion. -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 12:54 AM To: CF-Talk Subject: Re: E-commerce Hi Mike, WebMonkey has a tutorial on creating a simple shopping cart. It's a good place to start. HTH, Kay. "Mike Tangorre" <[EMAIL PROTECTED]> wrote in message 023f01c14d4a$02873aa0$72a35495@tangormt">news:023f01c14d4a$02873aa0$72a35495@tangormt... > Hi everyone. > I am trying to elarn how to create a simple E-commerce site (for > practice purposes). > I have no experience with this yet and could use some pointers. > > What is the est way to store information when the user wants to add > something to their basket? > I was thinking about using a structure of arrays, or a structure of > lists... or just arrays.. im not really sure what is easiest to work > with for a novice? > > Does anyone know some online examples with code that I could study from? > Should the cart be stored as a session var? > > Any help would be appreciated. > > Thanks > > Mike > > === > Michael T. Tangorre > Web Applications Developer > > Alfred University Webteam Slave :-) > [EMAIL PROTECTED] > AIM: CrazyFlash4=== > "Friends don't let friends code before coffee!"=== > > ~~ 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: Macromedia/Allaire Knowledge Base
I've been using google to search Allaire's own Knowledgebase lately. :) It seems to work better. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 10:41 AM To: CF-Talk Subject: RE: Macromedia/Allaire Knowledge Base I have never liked the KB myself either. You find more on the support forums then you do on there. I would like it if they were able to update the KB as an issue is resolved with CF. Microsoft, although they are the devil, has an awesome KB that you can find answers to every question you can think of. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 10:36 AM To: CF-Talk Subject: RE: Macromedia/Allaire Knowledge Base What is wrong w/ the KB? I mean what issues are you running into? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Tracy Bost [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 24, 2001 11:21 AM > To: CF-Talk > Subject: Macromedia/Allaire Knowledge Base > > > I'm am very frustrated with the "Knowledge Base" at > Macromedia/Allaire. > If it wasn't for posting a problem here or doing a search > through the CF > Talk archives, I would have > ditched ColdFusion a long time ago. Its just when this list > is down, that > something like that is appreciated. > One would think Macromedia/Allaire would take the "Knowledge > Base" section > of their web site a lot more serious. > As much as I dislike microsoft's products, they do have a > great knowledge > base, and makes the problems easy to find in the searches. > > ~~ 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 Authentication
We tried the ColdFusion solutions and several of the commercial solutions. The best thing we've come across (for the price) is a set of COM objects discussed in the book Windows NT/2000 ADSI Scripting for System Administration. The author distributes the precompiled COM objects from his Web site at http://www.newriders.com/adsi_web/index.htm. Don't forget to buy the book though. :) For examples of how to use the COM objects, have a look at the tag CF_ADSI in the Allaire Developer Exchange. It is a wrapper for the one of the COM objects. The tag may provide enough functionality for what you want to do. However, it only implements a subset of the functionality in one of the available COM objects. We were using Lewis Seller's CFX tags before we found this. The CFX tags were a god send when we found them. However, we had some difficulty getting them to talk to some of our servers. In addition, they made for tricky development. By this I mean that two tags will seemingly do the same thing but return the results in different variable datatypes. Also, naming conventions were not completely standardized between the tags. It got a bit confusing. If you have a C++ programmer on staff, these issue can be overcome. We didn't, so we made do. In general, the COM objects require more code than the CFX tags, but the author was religious about naming conventions and datatypes, though lots of the results are returned in lists. We haven't experienced any problems talking to various 2000 and NT servers. Both should work for what you want to do. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 1:15 PM To: CF-Talk Subject: CF and Authentication Hello Everyone. I have a question (might be a conglomerate of a few). I am working on an application here at school (Alfred University) and need to authenticate users off of our NT domain. Our Network admin tells me that the NT list is not separated, but could be separated into the following groups: Faculty Staff Students Now what I need to figure out is how to keep this entire application secure. I want to be able to have users to be able to peruse the site while accessing all secure parts while they are logged in. Also, based upon what the user is (student, faculty, staff, or a combination) they will see different things. Does anyone have any thoughts or ideas on how to go about authenticating off the domain and keeping their session open until they logout? 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
Programmatically Timeout Code
We're looking for a way to programmatically timeout sections of ColdFusion code. Specifically, we are calling a COM object from within ColdFusion. The COM object talks ADSI to various servers. Some of the servers sit behind a firewall which throws away the packets, causing the COM object, and the ColdFusion thread, to hang indefinitely. We'd like to be able to timeout that request and catch the error with CFTRY. I think there was a discussion about this very subject not too long ago, but for the life of me, I can't find it in the archives. In any case, perhaps someone can tell me what the conclusion of that conversation was. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~ 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: Complete lack of locking...
> BTW, a corollary of this is that, if your site does not use frames, ***you > don't have to worry about locking session variables ever***. Regardless of > the setting of "Single Threaded Sessions" . That is not true. A framed site can greatly increase the chances of simultaneous access to session variables, but it is certainly not the only scenario. In fact, most of the other events that can cause this are out of the developer's control such as users who double click links (a la the Windows environment). Even users who have figured out that they only need to click once on the Internet will get impatient when a server doesn't seem to respond right away. You can see this problem manifest itself in things like duplicate form submissions, an oft discussed problem on this list. These are just a couple examples of scenarios that can result in requests from the same user getting processed simultaneously, even without frames. The latter example is particularly egregious since a slow or seemingly unresponsive server can become unstable, usually at the time you can least afford the problem (i.e. when your server is busy). Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 22, 2001 2:07 PM Subject: RE: Complete lack of locking... > For those of you adverse to locking, why not simply set the server to lock > all reads? > Doing so means you can refer to you session variables (and others that > should be locked) without explicitly locking them, > however, you do not sacrifice the performance gains (as you would going to > single thread mode). > > You still need to lock the variables when you set them, but if you're like > me you only set the variables in a couple of places, but use them all over. > > Am I missing a performance issue on this? Is there some reason why this > option wouldn't be reasonable? > > Shawn Grover ~~ 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
Global User-Defined Functions
Is there a way to access a user-defined function throughout a request (e.g. from within custom tags or templates invoked with the CFMODULE tag)? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~ 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: Global User-Defined Functions
That's exactly what I was looking for. I seemed to recall something about that awhile back but, for the life of me, couldn't track down where I'd seen that before. Thanks. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 2:53 PM To: CF-Talk Subject: RE: Global User-Defined Functions Yes, you can do this: function foo() { return true; } request.foo = foo; Then inside the custom tag you can say: === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 26, 2001 2:30 PM > To: CF-Talk > Subject: Global User-Defined Functions > > > Is there a way to access a user-defined function throughout a > request (e.g. > from within custom tags or templates invoked with the CFMODULE tag)? > > Benjamin S. Rogers > http://www.c4.net/ > v.508.240.0051 > f.508.240.0057 > ~~ 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: SELECT MAX(ID), Access & SQL Server - confused!
> bottom line is that it is a pain in the keester to make a DB portable with > identity fields as a PK That hasn't been my experience. Not only does every database I've used in the past several years support an Auto Number/Identity field, but most provide a way to override the Identity field to allow insertion of user-defined identities (e.g. importing data from another database). Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~ 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
CFHTTP and FQDN
Searching through the Allaire forums, we see that we're not the only ones experiencing a problem with ColdFusion 5 in respect to CFHTTP and FQDNs. Specifically, a CFHTTP request to the same domain that is making the request fails. The error message is the ubiquitous CFHTTP "Connection Failure." I've included the debugging information from CFDUMP below. Substituting the IP address for the domain works. In addition, substituting a domain other than the one making the request but one still pointed at the same IP address works. It would seem that ColdFusion parses a CFHTTP request for its own domain differently than in any other scenario. Perhaps this is for performance reasons? Who knows but it is clear there is a problem. Has anyone come across a real fix or been able to narrow down the cause of problem? We're experiencing the problem on Windows 2000 running IIS 5 and ColdFusion Server 5 Professional Edition, though many of the people reporting the problem in the Allaire forums seem to be running Apache on Linux. Here is one of the discussions on the Allaire forums: http://forums.allaire.com/coldfusion/messageview.cfm?catid=7&threadid=214174 &highlight_key=y&keyword1=cfhttp&keyword2=connection%20failure Thanks in advance for any insight. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 == CFDUMP Output == FILECONTENT connection failure HEADER HTTP/1.1 404 Object Not Found Server: Microsoft-IIS/5.0 Date: Tue, 27 Nov 2001 15:38:49 GMT Content-Type: text/html Content-Length: 111 MIMETYPE text/html RESPONSEHEADER CONTENT-LENGTH 111 CONTENT-TYPE text/html DATE Tue, 27 Nov 2001 15:38:49 GMT EXPLANATION Object HTTP_VERSION HTTP/1.1 SERVER Microsoft-IIS/5.0 STATUS_CODE 404 STATUSCODE 404 Not Found ~~ 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 Webstore
The CFTRANSACTION tag is used to bundle multiple queries into a single transaction so that the queries can be committed or rolled back as a group. This is a fundamental aspect of SQL itself: it is not a short cut. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 1:42 PM To: CF-Talk Subject: Re: CF Webstore A good piece of software would not rely on cftransaction at all It's a handy shortcut that's all. jon - Original Message - From: "C Runyan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 04, 2001 12:49 PM Subject: CF Webstore > Thanks to all for the comments about AbleCommerce. Based on what we're > hearing and looking at the CFDJ readers survey CF Webstore looks like a > reasonable alternative. If anyone has used CF Webstore and modified the > code let me know what you think. Another consideration is whether it can > handle a large amount of traffic. Hopefully a good package would use > CFTRANSACTION processing for reliability. > > Chris > > > > ~~ 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 Webstore
Ah, yes, in that sense, I would agree with him, too, from a performance stand point. It still might be preferable to use CFTRANSACTION and rely on ColdFusion's inherent database abstraction when building a packaged application or any other application that could be expected to run against different databases. I still don't believe that an application that uses CFTRANSACTION is necessarily a bad one, as Jon stated. Perhaps there are some issues with CFTRANSACTION I'm not aware of though? In any case, I hadn't considered Jon's statement from the performance standpoint when comparing the use of CFTRANSACTION to its native equivalents. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 3:18 PM To: CF-Talk Subject: RE: CF Webstore > The CFTRANSACTION tag is used to bundle multiple queries into a > single transaction so that the queries can be committed or rolled > back as a group. This is a fundamental aspect of SQL itself: it > is not a short cut. I think that what Jon meant (and I kind of agree with him, if this is in fact what he meant) is that transactional processing should be handled within the database, as opposed to within the application. So, rather than using CFTRANSACTION, you'd put your transactional processing within a stored procedure, and simply call that from CF. Of course, maybe he meant something else entirely. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: Releasing Access locks with Coldfusion?
Perhaps there is a better way in newer version of ColdFusion, but in ColdFusion 4.0.1 we just generated an ODBC error by querying a column that doesn't exist. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:31 AM To: CF-Talk Subject: Releasing Access locks with Coldfusion? Anyone know how to release all locks on an access database via coldfusion? I am having some trouble with getting one of our datasources to release its current locking thus preventing me from uploading a new copy of the DB. Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~ 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: Shopping Cart
The company I worked for used AbleCommerce 2x for some time. In general, we liked the product as it had most of the features clients want as well as some fairly easy to customize "wizards." We purchased the open source license with the 1 year subscription but the folks over at Able seemed to get sidetracked with their auction product and didn't release a major upgrade to AbleCommerce for over a year. They did, however, release many minor upgrades and the tech support staff was fantastic. The open source license was helpful in a few cases, however, the code base was immense (600+ templates), undocumented, and real spaghetti code. In addition, the databases tables were not as normalized as we would have liked. For the most part, it was better to leave the source code alone. The administration interface was not something you could turn over to the client. It was unintuitive and buggy (e.g. windows would pop open in the wrong frame, ask for a login every time a link was clicked, etc.). That was the biggest point of contention, actually, since we were looking to turn the maintenance of the site over to the client. Although AbleCommerce is billed as a consumer end product, it really takes a ColdFusion programmer with at least a rudimentary skill set to install and maintain AbleCommerce. It looks like the new version has been updated some. This one only runs on ColdFusion 4+, which is probably a good thing: much of the old code base could have been simplified just by bringing it up to speed with the latest versions of ColdFusion. Unfortunately, it looks like the price has increased (or rather doesn't decrease with the number of stores purchased). It's still affordable, but there are quite a few other canned ColdFusion (and not ColdFusion for that matter) shopping carts out there for much less money. If your boss has already chosen AbleCommerce, though, I wouldn't worry too much. Just try and stay out of the source as much as possible, and make use the AbleCommerce support staff. They're a good bunch. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Eric Homa [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 12:14 PM To: CF-Talk Subject: Re: Shopping Cart Looks like the boss wants to try Able Commerce. Anyone have any good or bad experiences with it? Any undocumented features (bugs) that I should know about? Thanks, Eric Homa compudigital.com -Original Message- From: Warrick, Mark <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tuesday, December 19, 2000 2:34 PM Subject: RE: Shopping Cart >AbleCommerce is a nice out-of-the-box solution. (http://www.ablecommerce.com) - It requires no ColdFusion knowledge to maintain. > >I haven't tried this one, but it's cheaper than AbleCommerce: http://www.cartease.com/ > >If you want to "roll your own" you might try this tutorial: http://hotwired.lycos.com/webmonkey/99/49/index4a.html?tw=programming > >I'm sure there's more. These just came off the top of my head. > > >---mark > >-- >Mark Warrick >Phone: (714) 547-5386 >Efax.com Fax: (801) 730-7289 >Personal Email: [EMAIL PROTECTED] >Personal URL: http://www.warrick.net >Business Email: [EMAIL PROTECTED] >Business URL: http://www.fusioneers.com >ICQ: 346566 >-- > > >> -Original Message- >> From: Eric Homa [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, December 19, 2000 9:44 AM >> To: CF-Talk >> Subject: Shopping Cart >> >> >> Can anyone recommend a shopping cart that is written in CF that >> can be integrated into our own code? Any shopping cart >> experiences, good and bad, would be welcome information. >> >> Thanks, >> >> Eric Homa >> compudigital.com >> >> >> > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox
Although Fusebox is probably the most popular (and best documented) publicly available methodology for coding ColdFusion, there are several other (arguably better) methods available. Two of these include CFObjects (http://www.cfobjects.com/) and SmartObjects (http://www.smart-objects.com/). There are also some other methodologies which very in degree of structure: Black Box (http://www.black-box.org/) relies on a single tag to tie together disparate ColdFusion templates. On the other side of the spectrum, Switch_Box (http://www.switch-box.org/) is a fairly complex methodology that requires setting up special extensions on the ColdFusion Server. Some developers, who feel constrained working in a methodology, prefer working in a framework. A couple examples of ColdFusion frameworks include iiFramework (http://www.iiframework.com/) and even Spectra (http://www.allaire.com). However, both of these are commercial software. Actually, I can't think of a public or open source ColdFusion framework off the top of my head...something for the community to think about at any rate. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 4:47 AM To: CF-Talk Subject: RE: Fusebox Jeff, You keep on going on about other methodologies. Which particular other methodologies using CF are publicly available? You keep mentioning all these other methodologies, but can we at least compare them to Fusebox? Fusebox is probably one of the best methodologies (if not the only public methodology) available for a ColdFusion developer. The book also covers a number of fundemental design elements that any CF'er should understand. EVEN if they don't do Fusebox. Adam -Original Message- From: Jeffry Houser [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 PM To: CF-Talk Subject:Re: Fusebox "Warrick, Mark" wrote: > The fusebox methodology has many benefits, and I really don't think it adds any time to the development cycle. In fact, I'm pretty sure it helps speed up development. > Well, that has nothing to do w/ Fusebox. Any programming methodology will offer this benefit. The key is having one in place and sticking to it. > > One of the greatest advantages of the style is that you can modularize you code, and in doing so, you can assign pieces of your application to various developers without worrying about them stepping on each other's toes. > See above. This is not unique to fusebox. > > Another advantage is that certain companies (such as mine) require it. So if you don't do it, you're not going to get a job with certain companies. > If you are not a consultant, that is complete hogwash, I think. Especially with today's job market. Fusebox (or whatever methodology the company uses) should be more than willing to train on the methodology. If you already know the language (What company doesn't have enough trouble finding people who know the language?), learning the coding practices should be easy enough. I did one job, where the first thing they did was sit me down and outline the coding practices. It took about a half hour sitting down with the lead developer. I took notes, and then followed them. No problems. > > Lastly, it's very simple to follow the programming flow of a fusebox app. When something goes wrong, you simply search for the fuseaction in the index file and then you'll see right away all the templates in a single handy block that could be involved with the problem. > As I said previously, any methodology worth its salt should offer this. If I don't know fusebox, then your app isn't going to be any easier to follow than some other unknown methodology. (It probably will be easier to follow than random coding, though) -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
If you are running Web sites in their own memory space, then the IWAM account for the machine (either in the domain SAM if your Web server is a domain control or on the local machine's SAM otherwise) needs read access to the Web site directories. If the Web sites are running in shared memory space, then the IUSR account needs read access. You may want to make sure that the SYSTEM account (or whatever account you run ColdFusion under) has at least read to the directories if these are ColdFusion sites. Judging by your description of the problem, however, this is probably not the problem. The only other accounts that should have permissions to files in the Web site directories are, of course, the administrative account, and those users who need special permissions for FTP, password protected web sites, etc. Do not give the Guest account or the Everyone group access. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:37 AM To: CF-Talk Subject: OT: Anonymous access failure in IIS NT4 I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
Heh, it would seem that permissions are not set correctly as you are able to connect to the Web site using an account with administrator permissions. Perhaps you meant to say that the permissions were set as per the recommendations you've received so far? If that is the case, then you may want to double check what account IIS is in fact using. Are you running Web sites in their own memory space or not? Are these ColdFusion sites, HTML, etc.? Do your security logs tell you anything? Any additionally information would be helpful. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:50 PM To: CF-Talk Subject: RE: Anonymous access failure in IIS NT4 All permissions are set correctly. I still have the same problem though. Microsofts knowledge base isnt much use either. This is threatening to kill my weekend at this point :( Emmet -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:13 PM To: CF-Talk Subject: RE: Anonymous access failure in IIS NT4 If you are running Web sites in their own memory space, then the IWAM account for the machine (either in the domain SAM if your Web server is a domain control or on the local machine's SAM otherwise) needs read access to the Web site directories. If the Web sites are running in shared memory space, then the IUSR account needs read access. You may want to make sure that the SYSTEM account (or whatever account you run ColdFusion under) has at least read to the directories if these are ColdFusion sites. Judging by your description of the problem, however, this is probably not the problem. The only other accounts that should have permissions to files in the Web site directories are, of course, the administrative account, and those users who need special permissions for FTP, password protected web sites, etc. Do not give the Guest account or the Everyone group access. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:37 AM To: CF-Talk Subject: OT: Anonymous access failure in IIS NT4 I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox
> Amen to that, i have been using fusebox for a while now, and my > opinion is that it is another layer of stuff on top of what you > already have to do. When you get down to it, any methodology is just "another layer of stuff." Fundamentally, however, a methodology is an attempt to superimpose an order or structure to code. Although it would be nice if a methodology decreased the amount of work a single developer had to perform to code a given application, a methodology usually has some loftier goals such as synchronizing disparate developers on the same team, quality assurance, code documentation, etc. It's been my experience that the larger the project, the better Fusebox is at accomplishing these goals. If, however, you are simply adding a guest book to a relatively static site, then Fusebox would add quite a bit of overhead and development time while gaining the developer very little, short term or long. > I think i would p[ersonally tone down the fusebox methodology myself, > it needs to be alot less complicated to trully be a catch all > solution. Many people, myself included, have adopted pieces of the Fusebox methodology. How much you adopt, if any at all, is up to you. > When the fuse breaks its maddening, and is just another layer to run > through to fix stuff. Debugging a Fusebox application takes a little getting use to (like an hour :), but I prefer it to other attempts I've seen which try and make the best use of code through reuse. A Fusebox application has one entry point and one exit point. All the developer has to do is trace the path of the FuseAction. The only time I really run into problems is when I have several included query templates in a row and I get a cryptic ODBC error message and a ColdFusion "Problem occurred in tag at or around line 1" Then it takes the extra step of aborting processing of the page a couple times to determine which query is in error. > And i don't buy the whole makes it easier to bring in other > programmers, because almost all of them will have to learn fusebox > and the particular way its used where they are working. I don't think you're being asked to buy anything. :) We require that our programmers be familiar with Fusebox and to be able to code in a manner similar to Fusebox. The same was true at the last place I worked where I was head of production. This is, of course, not a requirement to getting hired, nor do we code all our applications in this methodology. But we have found that it works very well on larger projects with several different specialized developers and teams working on dedicated tasks. With many a notable exception, most programmers/designers/DBAs I've met and worked with seem to like the style, which is always a bonus. But of course, this is a highly subjective generalization. :) > I still like the idea of a methodology, im just not sold on fusebox As someone already noted, it is not necessary to like or "buy" fusebox, but it is necessary to choose a methodology. Even if your methodology changes from project to project (and hopefully it will evolve), routinely dealing with reoccurring problems in the same manner and being able to expedite the daily chores of programming is essential. In regards to Fusebox, it doesn't hurt that some very talented and experienced ColdFusion programmers have tackled these issues already. That, to me, is one of the greatest benefits of Fusebox. Although we don't need many aspects of the Fusebox standard, they already exist and are freely available for us to implement when and if we do need them. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Transactions
Correct. Kind of cool, isn't it. :) Actually, it's all done on the SQL side. CFTRANSACTION is just a way of wrapping it all up with ColdFusion logic and processing. If you want to know more about what is actually going on, or you would prefer a pure SQL solution, have a look at the BEGIN|COMMIT TRANS[ACTION] statements. However, I'd recommend just using the statement because it works very well and is extremely easy to implement. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 26, 2000 11:44 AM To: CF-Talk Subject: CF Transactions If you wrap a CF transaction around two 's, one being an INSERT and the NEXT being an UPDATE, if there is an error in the UPDATE, will it actually roll back the INSERT? Thanks, Scott ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re: The +.htr bug strikes again
Mike, This may be one of the most ignorant statements I've seen posted to a list in awhile. I use the word "ignorant," first, because of the ill-conceived attack on Dave Watts, who has been contributing to this list (and the ColdFusion community at large) for some time. Although I'm sure Dave doesn't care, I would think an apology is in order. Second, I believe your statement was bred of ignorance if you think the destructive behavior of solitary script kiddies executing precompiled executables against distant servers is necessarily predisposed to becoming the skilled programmers that you would like to work with: a good part of what it takes to be on a team is trust and good natured comradery, things the script kiddies are more times than not lacking. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 26, 2000 1:26 PM To: CF-Talk Subject: re: Re: The +.htr bug strikes again I for one appreciate the heads up, not everyone considers people on this list to be script kiddies !! we are all developers here and we don't need mr Watts to baby sit us. on the topic of script kiddies, there is another side to that, there is the annoying older internet worker who looks at everything like a lawyer and put disclaimers on everything and want to protect us from ourselves. Gimme the script kiddies anyday, script kiddies grow up to be internet workers and innovators, annoying legally minded (old )programmers are just plain dull > ** Original Subject: Re: The +.htr bug strikes again > ** Original Sender: "Kevin Schmidt" <[EMAIL PROTECTED]> > ** Original Date: Fri, 22 Dec 2000 14:21:39 -0500 > ** Original Message follows... > > Ok. I can see that my piece of information, that I intended to be totally > harmless, has caused quite a stir. From now on I will keep my mouth shut. > The only reason I let people on the list know is because the site uses CF > and there had been alot of discussion on the topic over the past few day. > Several people didn't even know the bug existed. > I told the sites administrators about the problem and I don't know if they > have fixed it yet or not. Maybe they don't care or maybe they do. There > have been other sites metioned in this thread that have the same problem. > People disclosed the information to warn consumers of the problem and to > choose someone else to provide the service that the said company provided > because the company hadn't fixed the issue. Some people on the list don't > think mentioning these types of issues is a problem, others do. I am > stepping of my soapbox now. If anyone has questions about the +.htr issue > i'll be happy to entertain them. There have also been numerous posts with > URL's to the patch posted to the list. > > Happy Holiday's > > Kevin Schmidt, Web Technology Manager > Allaire Certified Cold Fusion Developer > pwb inc. > integrated marketing communications > 350 S. Main St., Suite 350 > Ann Arbor, MI 48104 > 734.995.5000 (tel) > 734.995.5002 (fax) > www.pwb.com > > > - Original Message -From: "Dave Watts" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, December 22, 2000 12:04 PM > Subject: RE: The +.htr bug strikes again > > > > > There are two sides to this issue. 1. Releasing bug/vulnerability > > > information to the public will release hoards of script > > > kiddies to cause havoc and dismay instantaniously without > > > recourse. 2. Releasing bug/vulnerability information will cause > > > industry leaders like Microsoft and respectively Allaire to > > > act on the information sooner than later. > > > > > > I can see both sides of the fence but would lean to alerting > > > the public to the problem. Security by obscurity is not a good > > > policy to live by. > > > > While I agree with this as far as product vendors are concerned, that's > not > > what's going on here. It's one thing to release general information about > > vulnerabilities in MS products to the public (although even within the > > security community, there's quite a bit of debate over whether and how > this > > should be done - should the vendor be notified privately first, how long > > between vendor notification and public release, etc.). It's another thing > to > > release specific information about who hasn't patched their installations > of > > vendor products, which is what's going on here - "so-and-so is vulnerable > to > > the .htr bug". This doesn&
RE: MOD math function?
-Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:27 PM To: CF-Talk Subject: MOD math function? Maybe I should have paid attention in math, but here is my problem. I have 2 numbers, for example 40 and 4. All I need to do is find out if (40 / 4) has a remainder. For some reason, (40 MOD 4) does not seem to be working. jon ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: SNMP Tag?]
Easier said than done. :) We recently played with MRTG and some of the extensions that are part of the distribution. It was easy enough to get MRTG up and running: we had it monitoring the throughput on one of our Cisco routers and dumping the data to the RRDTool. However, we wanted to monitor bandwidth utilization by IP address using Cisco's IP Accounting. We never did get that working properly. This despite the fact that several MRTG extensions (hacks) distributed with MRTG that supposedly handle this. I think this is because the current incarnation of MRTG (even using the RRDTool) is not very extensible. However, I think this is mostly due to complexity of SNMP itself (yeah, I know what the acronym stands for :). It didn't help that we have no good Perl programmers on staff. To make a long story short, if you are not very knowledgeable about SNMP and don't have a terrible amount of time to devote to it, I wouldn't try to adapt MRTG to whatever you are going to do. If you don't know Perl, skip it all together. I am interested in Lewis Sellers' CFX_TCPClient. I wonder if one couldn't write an SNMP wrapper in the form of a CFML tag. Of course, a fairly good working knowledge of SNMP would still be required. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 29, 2000 12:31 PM To: CF-Talk Subject: Re: [RE: SNMP Tag?] http://www.mrtg.org [EMAIL PROTECTED] (lsellers) wrote: > > Is anyone aware of a CF tag that can communicate with an SNMP enabled > service? I really just need basic read-only capability for device > monitoring, such as reading traffic throughput from a router or switch, or > retrieving performance metrics from some other services. Well, assuming they are set up for tcp, you can use TCPClient. http://www.intrafoundation.com/freeware.html If know of a couple people that have used the original cfx version to chat with their cisco routers from cf (sh line, etc). There's a brand new version I wrote last month that's a c++ com object as well. Much nicer to use. (The Second Edition). No specific SNMP, etc examples though but routers are usually telnetable something like: #HTMLCodeFormat(page)# #HTMLCodeFormat(page)# ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Request VS Application scope
> The reason why locking is visible to the developer is because it is much > more efficient if the person writing the code, who knows how the application > should work, decides where to lock and more importantly what type of lock to > use. If the ColdFusion server had to decide whether to use a ReadOnly or > Exclusive lock, there would be enormous performance degradation. It is much > more efficient if the programmer tells the server which type of lock to use. > It's the same thing as telling the server which scope a variable is in, > instead of having the CF Server go through the variable scope hierarchy. This is incorrect. ColdFusion should handle all locking internally except transactional locking. I have yet to see a reason (aside from developer laziness) that an exclusive lock should not occur when a session variable is being written or a read lock should occur when a session variable is being read. A much better analogy is that of the RDBMSs we all know and love. In those environments, locking is handled by the application. If the developer needs to combine a series of commands into a single lock (a.k.a. a transaction), then that option is available to the developer. Unlocked commands can cause dirty data at best and system instability at worst. I don't see why this would be the default behavior of ColdFusion as opposed to locking all commands except where the developer chooses to override this to ensure transactional integrity. I've argued this point before, both on this list and elsewhere. I maintain that the issues with are the result of asking a single threaded application server to behave as a multithreaded application server. Rather than rewrite the portions of the ColdFusion server that did not behave properly in a multithreaded environment, they have shuffled off this responsibility to ColdFusion developers. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ 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: line breaks in cfmail
What platform are you developing on (e.g. Mac, Windows, Unix, etc.). Is the ColdFusion Server on Windows or Unix? What mail server is ColdFusion relaying mail off of? What mail clients are having difficulty displaying the mail properly? Perhaps the client you are developing on is only placing carriage returns or line feeds at the end of each line and the OS expects both or the opposite. Also, Some mail servers like qmail have a nasty habit of strip CR/LF pairs into bare LFs. At which point, the client you are using may not be savvy enough to render the page correctly (like the difference between opening up a document created on a Unix system using Edit as opposed to an early version of notepad). There could be quite a few possible explanations for this. To troubleshoot, you may want to try relaying mail off a different mail server and viewing the mail from a different client. If neither of these fixes the problem, you could try the following code: Email Address: #form.email##Chr(13)##Chr(10)#Business Name: #form.businessname# That will place a CR/LF pair at the end of the e-mail address. If this fixes the problem, then you may want to switch your IDE (or switch the way your IDE handles end of line ASCII characters). If your still having problems, please post back the answers to some of these questions as well as the results of these test. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 10:23 AM To: CF-Talk Subject: line breaks in cfmail Hey all, I have this ongoing problem with line breaks not being respecting when formatting my email bodies using the cfmail tag. For example something like this: Email Address: #form.email# Business Name: #form.businessname# Is showing up like this when sent: Email Address: #form.email# Business Name: #form.businessname# Any suggestions? Thx! Rick ~~ 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: line breaks in cfmail
Are you developing on a Mac by any chance? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 1:43 PM To: CF-Talk Subject: RE: line breaks in cfmail I have the same problem. Spent some time trying to fix this (what I will call a bug until someone tells me other wise) bug. Found no reason why it would only have problems sometimes. Seems like it only does it when you have a var and the line break then text. I found a work around by adding a #chr(13)# for the line break. What version of CF are you running. My guess this that this problem has been solved with the latest update to 4.5. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 12:25 PM To: CF-Talk Subject: Re: line breaks in cfmail Are you using HTML format? If you are you need to put in the breaks physically. If you are not then it should break automatically on the new lines. - Original Message - From: "Rick Lamb" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 04, 2001 9:22 AM Subject: line breaks in cfmail > Hey all, > > I have this ongoing problem with line breaks not being respecting when > formatting my email bodies using the cfmail tag. For example something like > this: > > > > Email Address: #form.email# > Business Name: #form.businessname# > > > Is showing up like this when sent: > > Email Address: #form.email# Business Name: #form.businessname# > > > Any suggestions? Thx! > > Rick > > > ~~ 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: line breaks in cfmail
Correct. I ran into a problem with a mail server being maintained by a system admin at a sister company. Under certain conditions, his qmail server would strip CR/LFs into bare LFs. At which point, qmail would then reject the mail because it contained bare LFs, when in fact, bare LFs are legal in the body of the message, just not in the headers. As a workaround, you have to start qmail with a switch that tells it to accept messages with bare LFs. Of course, that was almost a year ago now. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: lsellers [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 12:34 AM To: CF-Talk Subject: RE: line breaks in cfmail > Also, Some mail servers like qmail have a nasty habit of strip CR/LF pairs > into bare LFs. At which point, the client you are using may not be savvy Evil, considering that's illegal under every RFC I've read. :) --min ~~ 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: Slightly OT
Allaire is US centric, from their technical support offerings to their lack of Unicode support. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 5:16 AM To: CF-Talk Subject: RE: Slightly OT That's actually a very interesting point to bring up It seems that almost all european countries uses php/asp whereas over here the market has room for all of the scripting languages is it the price for a license that scares companies in europe ?? Allan Pichler Machine Dreams Inc. -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 2:07 AM To: CF-Talk Subject: RE: Slightly OT Do UUnet have a CF hosting service? Jason, any ISP that allows dedicated servers (if thats what you require) will host CF. The only problem you may come across is in the use of RDS which some ISP's do not allow. Another problem is trying to find a shared server with CF support in the UK because I can't help thinking that CF just hasn't had the same impact this side of the atlantic. -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: 05 January 2001 10:05 To: CF-Talk Subject: RE: Slightly OT UUNET, there not cheap but their support is good, sites are fast. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: vrijdag 5 januari 2001 11:00 To: CF-Talk Subject: Slightly OT Hi All, Can anyone suggest an ISP (Perferably in the UK) that can host Cold fusion sites. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ 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: Those Pesky Pound Signs
You have to double them up or use the Chr() function. The pound sign always has to be escaped in a CFML page. The only times you don't have to worry about it is when your reading it from a file or a field in a database (i.e. some external source that is not evaluated as CFML). Anyway, to answer your question, here's a few examples. ex: ", "", "ALL")> ex: ", "", "ALL")> Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 2:52 PM To: CF-Talk Subject: Those Pesky Pound Signs OK, I've got a bunch of HTML I've got to parse through and create a new page of CFML/HTML that will then be fed into a CF app that creates a series of new HTML pages. Basically, I'm taking a plain HTML calendar and converting it to something that I can then have CF convert it into code with different colored table cells based on the color scheme of the page it will go on. As you know, if you need to use pound signs within a CFOUTPUT, you need to escape it, thusly: bgcolor=##FFCCFF So I tried this REPLACE string: ", "", "ALL")#"> But those CF wants to keep trying to interpret those pound signs around the BGCOLOR. I thought since they're in quotes, as a string, they wouldn't be read by the CF engine, but that doesn't seem to be the case. (the ###BGColor# gives me in the end, #FFCCFF in my final app). How do I get CF to read those pound signs as a simple string within my replace function? I've tried DE, HTMLEditFormat, etc. I've tried a bunch of other things ... basically every hairball idea I could pull out of my head. Nothing works. Any suggestions? ~~ 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: Slightly OT
ColdFusion 6 will by virtue of it's complete rewrite in Java which supports Unicode. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 10:23 AM To: CF-Talk Subject: Re: Slightly OT I believe either CF 5.0 or CF 6.0 are supposed to have full Unicode support. Both are supposed to be released during 2001. Dave - Original Message - From: "Benjamin S. Rogers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 05, 2001 10:09 AM Subject: RE: Slightly OT Allaire is US centric, from their technical support offerings to their lack of Unicode support. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 5:16 AM To: CF-Talk Subject: RE: Slightly OT That's actually a very interesting point to bring up It seems that almost all european countries uses php/asp whereas over here the market has room for all of the scripting languages is it the price for a license that scares companies in europe ?? Allan Pichler Machine Dreams Inc. -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 2:07 AM To: CF-Talk Subject: RE: Slightly OT Do UUnet have a CF hosting service? Jason, any ISP that allows dedicated servers (if thats what you require) will host CF. The only problem you may come across is in the use of RDS which some ISP's do not allow. Another problem is trying to find a shared server with CF support in the UK because I can't help thinking that CF just hasn't had the same impact this side of the atlantic. -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: 05 January 2001 10:05 To: CF-Talk Subject: RE: Slightly OT UUNET, there not cheap but their support is good, sites are fast. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: vrijdag 5 januari 2001 11:00 To: CF-Talk Subject: Slightly OT Hi All, Can anyone suggest an ISP (Perferably in the UK) that can host Cold fusion sites. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ 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: Slightly OT
Team Allaire is great, but corporations and other large installations need something a little more tangible. They want someone's name on a contract. :) Thankfully, I've never needed to contact Allaire support except by e-mail off of their site and as I've always worked in the United States with other North American based companies, these two items in particular have not been an issue for me or the companies I work for. However, the original question was why hasn't ColdFusion been largely adopted overseas, particularly in Europe. I believe these two items are of great concern to larger companies outside the United States. For the experiences of a team of developers working outside the United States on a larger project, have a look at the following article: http://webdevelopersjournal.com/software/coldfusion_problems.html Keep in mind this pertains to ColdFusion 3 and the infamous Sun Solaris port of ColdFusion prior to the platform independent code base developed for ColdFusion 4.5. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 10:21 AM To: CF-Talk Subject: Re: Slightly OT > Allaire is US centric, from their technical support offerings to their lack > of Unicode support. they are moving to unicode (i will be the 1st to admit slowly) & team allaire members are (were) strewn across all kinds of timezones to provide some support around the clock. ~~ 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: datasource question
The hostname is actually the datasource name. This is usually chosen by the hosting company so you will need to contact them and ask them what the datasource name is. You will also want to check and verify that you are using username and password. In any case when you've figured it out, your CFQUERY tag will look something like this: Some ColdFusion hosts will set it up in a manner that you will not need to provide the username/password in each of your CFQUERY tags. This is dependent on the ColdFusion host so you should check with them to see if this is the case. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 07, 2001 12:29 AM To: CF-Talk Subject: datasource question I am new to coldfusion and have my site internetcraftfair.com that doesn't have coldfusion on the server. The sister of my server has coldfusion and has been kind enough to set me up a temporary location so I can code some pages for possible employment. Well I have coded the page and sent it up to the sister server but I am not sure how to point it to access my database on my site's server. I have been using perl to connect to my database on my site with DBI and I make a database string that I send to the server in a variable. I have tried to form a database type of string with the CFSET functions setting the username, password, and hostname. I am not sure of the syntax of it though or if I am suppose to use my site "internetcraftfair.com" as the host or the server "topchoice.com". To access my database on my server through telenet my root folder on internetcraftfair.com is client/home/internetcraftfair and then I type in mysql to access the database and send my username and password in to access it. should this be internetcraftfair.com or do I need to specify my root directory ? do I use commas or colons in this string? I am having a hard time accessing the temp folder on the web and hope to hear back from radiant in the morning so I can view my code on the web. I would appreciate any help on this you can suggest. Thanks-- Shelly Hill http://www.internetcraftfair.com "All our dreams can come true - if we have the courage to pursue them" -Walt Disney ~~ 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: Slightly OT: CF in Europe
And what makes Java less proprietary than C++? Last I heard, Sun pulled it from the standards committee. Suggesting that Java would be opened up, was one maneuver in Sun's marketing campaign to regain market share lost to Open Source alternatives to their products: http://www.wired.com/news/topstories/0,1287,19413,00.html In fact, if the language that your application server was written in had anything to do with the "openness" of the application server, being written in C++ would make ColdFusion far more open. But, of course, the language the server is written in has little to nothing to do with the openness of the server itself. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:59 AM To: CF-Talk Subject: RE: Slightly OT: CF in Europe Well this is a completely subjective view but my perception is that CF is considered quite a hot technology here in the UK. I don't know, but I believe the relative strength of CF versus ASP is stronger in the US than in Europe because a lot of people in the US started building web apps before ASP came out or was usable. By the time the UK got started, ASP was a viable option, and no-one ever got fired for buying Microsoft products, as they used to say of IBM. Allaire's reputation for quality doesn't seem to be perfect, but then neither is Microsoft's. Maybe PHP is popular in Europe because it was invented here & is largely developed here. But I think decent-sized organisations here tend to steer clear of open source - Apache being something of an exception. They don't trust it. They also like standards. I think that's CF's weakest point from a marketing point of view is that it's seen as a proprietary, closed solution. I believe CF's move to Java will be a big help in this respect. I worked for one company that moved from PHP to Java because they saw Java as a standard. When they find out how complicated Java systems can be, maybe they'll be in the market for a rapid web app development tool based on the Java platform Nick -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 7:05 PM To: CF-Talk Subject: Slightly OT: CF in Europe Even though we just touched the subject in another thread i'd like to start a new one where we "air" our thoughts on the future of CF in Europe since it seems like CF is a "failure" so far over there! The reason being that i'm probably moving back to Europe soon and i would really hate to switch over to ASP/PHP. Allan Pichler Machine Dreams Inc. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Query confusion - CF not recognising query name
It looks like your code has been greatly excerpted. There is no chance that you are setting the variable getPeopleInfo equal to some simple value and overwriting the query somewhere between the query and the loop? Is the name of the query dynamic? Sorry for the questions, but it seems very unlikely that ColdFusion would behave this way. Any additional information would be useful. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 1:49 PM To: CF-Talk Subject: Query confusion - CF not recognising query name I've got some code running which SHOULD work, but isn't, and is confusing the hell out of me Here's the code; select ID from #variables.peopleTable# (nolock) where ID in (#variables.IDList#) and #PreserveSingleQuotes(variables.whereList)# order by #form.OrderBy# Here's the error; An error occurred while evaluating the expression: variables.IDCount=getPeopleInfo.RecordCount Error near line 527, column 8. Error resolving parameter GETPEOPLEINFO.RECORDCOUNT ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. I've tried putting a CFLoop straight after the query and it comes back that the query doesn't exist - but I know it does (obviously) It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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 vs. Lotus Domino App Server
> BLOB? That's a new acronym for me. http://whatis.techtarget.com/WhatIs_Search_Results_Exact/1,282033,,00.html?q uery=blob Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ 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: Storing images in SQL
It's probably pretty clear to most people what is going on when just a reference to the image (/directory/name.img) is stored in the database so I'll just discuss what additional overhead is incurred when the entire image is stored in the database. When you store the actual image in the database, the request from the client for the image that would normally get handled relatively speedily and efficiently by the Web server and file system (after all that is what they are designed for) is actually passed off to ColdFusion. This ties up one additional thread on the ColdFusion server for each image being processed. You only get so many threads: usually 5 times the number of processors. If you had a single CPU server, you could tie up all the available threads with one page that had five images on it. ColdFusion then makes a query to the database which is usually on a different server. This takes network resources, from the NICs to the bandwidth utilized to transfer the query and return the image data. If the database is not on a separate server (which is not generally a good idea because, among other things, you are tying up CPU cycles on your Web server) then you still incur the overhead of processing the request, finding the data in the database and passing this back the ColdFusion application server all via ODBC, OLE etc. On the database's end of things, RDBMSs usually store BLOB (Binary Large Object) data relatively poorly since most RDBMSs store information in 2k extents and 8k pages. What in effect happens is the RDBMS stores the image elsewhere in the database and places a pointer where you would logically expect the image data. This is also true for the TEXT datatype. When the RDBMS goes to return the data, it has to "hunt" the image in a separate spot. In any case, you've added quite a bit more overhead to the Web server, the database server, and the network. You've also increase the amount of time it takes to process the request, making you site appear slower to outside users. Some users may have special requirements that necessitate storing the images in the database, but, in most situations, the gain is little to nothing. There are a lot of other smaller issues, such as the way ColdFusion handles binary data and how that data is transferred between the database server and the ColdFusion application server, but hopefully the above description will give you a general idea of why developers always caution against storing image data directly in the database. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:40 PM To: CF-Talk Subject: RE: Storing images in SQL Larry, I've asked this question before also. And got similar responses as yours which is appreciated. But is there any way you could tell us (a number of people have asked this question) why it's slower and messier. I'm sure for somebody that knows the details on what it takes to do this can logically agree with you (and others who have said the same) and I too would like to be one of those well informed people that come to the same conclusion for the same reasons. Could you or anyone else familiar with the techniques required for this please elaborate on this so I can say something other than "it's a bad idea because that's what somebody said." Thanks, Rick -Original Message- From: Larry C. Lyons [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 3:28 PM To: CF-Talk Subject: Re: Storing images in SQL Michael, In a nutshell don't. Its far faster, easier and a lot less messy to store the images's name and then dynamically construct the path information. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Michael Buffington wrote: > > Does anyone have any experience storing images in SQL 7.0, and retrieving > them in CF? > > Any tips would help! > > Michael Buffington ~~ 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: CFFILE Delete then WRITE issue....
Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""<[EMAIL PROTECTED]> Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 > >OK. I am having a problem here. I am able to DELETE a file with CFFILE >without a problem, but when I try to almost immediately WRITE the same file >back it tells me there is an issue with the file "Error: The file could not >be accessed." Has anyone encountered this before? When I check on the >server for the file, what once was a 500k file, is now only 500 bytes, but >when I try to open it there it tells me that the "file could not be found." >But it exists. And then I have to wait a while to get the OS to release >it. I check it 24 hours later (because I am working on other things too, >and I so sleep some), and it works fine. I think this is an issue if >someone tries to OPEN the file instead of SAVING it. So the second >question is is there a way to force someone to DOWNLOAD the file instead of >opening it? > >Also, when I browse that directory in CF Studio, the file name has a RED >DOT to the left, and I have never seen this before. > >Any help would be MOST appreciated. > >Vance Duke >Cold Fusion Application Developer >i2 Technologies >(469) 357-4729 > > > > ~~ 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: CFFILE Delete then WRITE issue....
Actually, the feature you are referring to does not have anything to do with the operating system but rather the Web server. IIS creates handles to files for fast references. When you delete a file, you actually delete the file (contrary to what Philip has suggested). The handle, however, is left open. A separate process called the cache scavenger routinely goes through and checks to see which files have been deleted. At this point the handle to the file is deleted and the file "appears" to be deleted from the file system. Although the frequency with which the cache scavenger checks file handles can be adjusted, the performance benefits from this method are great, so it is not recommended that you alter this setting. This is probably why it is hidden in the registry. One side note, the cache scavenger is set by default for something like every 60 seconds. You should not see the file for more than 60 seconds unless someone has already played with this setting. Now, as to the original question, is IIS indeed the Web server in question? If so, is IIS touching the file in-between the write and delete operations? This would invoke the caching mechanism discussed above. If this is the case, there is not to much you can do except name the files uniquely. The CreateUUID() function would probably be overkill: you could probably get away with the RandRange() function if you are deleting the file immediately. If the Web server is something other than IIS or IIS is not touching the file in-between the write and delete operations, then the problem is elsewhere. Are you always enclosing the CFFILE tag in an exclusive lock using the CFLOCK tag? Not doing this would cause a whole host of issues, but I wouldn't really expect the ones you've described. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:12 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue NT has this wonderful habit of not dealing with requests immediately - it can mean that when you try to write a file it messes up and needs a slight delay Pain, but it's lovely M$ software! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 09 January 2001 16:53 > To: CF-Talk > Subject: CFFILE Delete then WRITE issue > > > > OK. I am having a problem here. I am able to DELETE a file with CFFILE > without a problem, but when I try to almost immediately WRITE the > same file > back it tells me there is an issue with the file "Error: The file > could not > be accessed." Has anyone encountered this before? When I check on the > server for the file, what once was a 500k file, is now only 500 bytes, but > when I try to open it there it tells me that the "file could not > be found." > But it exists. And then I have to wait a while to get the OS to release > it. I check it 24 hours later (because I am working on other things too, > and I so sleep some), and it works fine. I think this is an issue if > someone tries to OPEN the file instead of SAVING it. So the second > question is is there a way to force someone to DOWNLOAD the file > instead of > opening it? > > Also, when I browse that directory in CF Studio, the file name has a RED > DOT to the left, and I have never seen this before. > > Any help would be MOST appreciated. > > Vance Duke > Cold Fusion Application Developer > i2 Technologies > (469) 357-4729 > > > > ~~ 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: CFFILE Delete then WRITE issue....
See my last post for the technical explanations. If I'm guessing correctly, you are running an NT server with IIS? On the first page of your application you create a file that the user can then download? With some subsequent page request, you then delete the file? However, the file still appears to be in the folder tree and a new one with the same name cannot be written for some period of time. If this is the case, then it should not make any difference whether or not the user is "opening" or "saving" the file. What your probably experiencing is just the coincidental timing of your requests and the cache scavenger. I would recommend naming the files uniquely and running your own separate scheduled task that deletes files nightly that are older than so many hours. If this is not the case, then you really need to give us a better idea of what OS, Web server, version of ColdFusion, etc. you are running, as well as the logic behind the application. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:43 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue This is great help and I appreciate all this feedback. Is there an answer to my second question... I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? This would also help me. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:24 AM Please respond to cf-talk Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""<[EMAIL PROTECTED]> Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 > >OK. I am having a problem here. I am able to DELETE a file with CFFILE >without a problem, but when I try to almost immediately WRITE the same file >back it tells me there is an issue with the file "Error: The file could not >be accessed." Has anyone encountered this before? When I check on the >server for the file, what once was a 500k file, is now only 500 bytes, but >when I try to open it there it tells me that the "file could not be found." >But it exists. And then I have to wait a while to get the OS to release >it. I check it 24 hours later (because I am working on other things too, >and I so sleep some), and it works fine. I think this is an issue if >someone tries to OPEN the file instead of SAVING it. So the second >question is is there a way to force someone to DOWNLOAD the file instead of >opening it? > >Also, when I browse that directory in CF Studio, the file name has a RED >DOT to the left, and I have never seen this before. > >Any help would be MOST appreciated. > >Vance Duke >Cold Fusion Application Developer >i2 Technologies >(469) 357-4729 > > > > ~~ 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_Activedit alternatives??
Here is an excerpt from one of my posts last month. There's probably quite a few other useful discussions on this topic in the list archives already. I would like to add ezEdit (http://www.siteobjects.com) to this list of utilities. It is distributed in the form of a custom tag. This tag works like most of the rest. It is free and Open Source. It lacks (and will probably always lack) features like the spell checker found in a few others because of the licensing fees associated with the spell checking databases and such. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Most of the solutions out there (especially the ColdFusion ones) are all based on the MSHTML editor. Information developing applications using this component can be found here: http://msdn.microsoft.com/workshop/browser/overview/editing.asp Here's a list of the most popular ones that I've seen around. I know there are a couple people from some of these companies on this list who will probably want to interject on behalf of their company. However, we just researched this fairly extensively. This is a combination of our opinions from evaluating the products and information gathered from the sales people. Please take it for what it is worth: HTMLEdit This is not a ColdFusion solution but I would be remiss not to mention it since it is such a quick and easy solution that probably meets many peoples' needs. http://javaboutique.internet.com/HTMLEdit/ Pros: Simple and Open Source. Cross-platform and cross-browser. Cons: Very, very few features (i.e. only includes basic HTML editing). HTMLAREA http://www.iautomated.com/ Pros: Free (Lite) Version. Cross Platform. Cons: Interface needs some work (i.e. bulky and clumsy); missing some of the features. Pay version is not particularly cheap. Not cross-browser (IE only). ActiveEdit http://www.cfdev.com/ Pros: Cross-platform and Inexpensive. Integration with some other products from the same company like ActiveScan. Cons: Interface needs a little work (i.e. a little clumsy and can't be embedded into a page) and it's missing a couple features (e.g. dictionary), most of which are coming out in the next version. It is not cross-browser (IE only). eWebEdit http://www.ektron.com/ Pros: Nice interface with all the features. Cross-browser and Spectra-ready. Cons: Really (really) high price tag (Although according to their sales rep they haven't figured out their pricing yet so this may change). Not cross-platform (Windows only). Hope this helps. -Original Message- From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:58 AM To: CF-Talk Subject: CF_Activedit alternatives?? Hi all! I´ve been using the CF_Activeedit custom tag for some time now but i´ll like to know about other similar tags i could use as well. I´ve found out that it doesn´t work properly with one of our Mac machines for some reason (??). Does anybody know of any other tag that also allows text edition (even if it´s only basic edition functionality)? TIA ! Paco Montes Spain on Line ~~ 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: CFFILE Delete then WRITE issue....
> Sorry I did not elaborate before. NT 4.0 SP 5, CF 4.0, IIS 4.0. We guessed correctly. :) > The Application is Deleting a file if it exists and then writes the file > FRESH. Then gives the user a link to the CSV file. After that, the user > can download it, save it, or click another link to regenerate the file. It > seems to be happening when the user has OPENed the file and then decides to > generate another file that this error occurs. Again, I don't see why there would be a difference between opening and saving the file. Both those operations occur on the client side, not the server side. > Like I said before, I can then delete the file when they decide to generate > another file, but when I try to WRITE the new file, within seconds of the > first being deleted, that is when I run into what appears to be a file > header of a 500 bytes and it will not let me write it, access denied. The 500 byte file that you see is a placeholder of sorts. It exists for up to 30 seconds (the default ObjectCacheTTL). Unfortunately, you will have to adjust your logic to get this application working properly under IIS. Although I like the concept (and for the most part, the implementation) of the cache scavenger, it does add a couple steps to application design in situations such as these. What I would do is the following: 1) Create a directory that holds all the CSV files and only CSV files. 2) When the user requests the page that creates the CSV file, CFDIRECTORY the CSV directory and delete anything older than 1 hour or so. 3) Create your new CSV file with a unique name (either the CreateUUID() function or the RandRange() functions should work fine). Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 "Benjamin S. Rogers" To: CF-Talk <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:57 AM Please respond to cf-talk See my last post for the technical explanations. If I'm guessing correctly, you are running an NT server with IIS? On the first page of your application you create a file that the user can then download? With some subsequent page request, you then delete the file? However, the file still appears to be in the folder tree and a new one with the same name cannot be written for some period of time. If this is the case, then it should not make any difference whether or not the user is "opening" or "saving" the file. What your probably experiencing is just the coincidental timing of your requests and the cache scavenger. I would recommend naming the files uniquely and running your own separate scheduled task that deletes files nightly that are older than so many hours. If this is not the case, then you really need to give us a better idea of what OS, Web server, version of ColdFusion, etc. you are running, as well as the logic behind the application. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:43 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue This is great help and I appreciate all this feedback. Is there an answer to my second question... I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? This would also help me. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:24 AM Please respond to cf-talk Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write
RE: CF_Activedit alternatives??
It looks like they have since restructured their site so I've sent a copy of the applet to Duane off list. If anyone else needs this, let me know. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:43 PM To: CF-Talk Subject: RE: CF_Activedit alternatives?? >HTMLEdit > This is not a ColdFusion solution but I would be remiss not to mention it > since it is such a quick and easy solution that probably meets > many peoples' > needs. > http://javaboutique.internet.com/HTMLEdit/ > Pros: Simple and Open Source. Cross-platform and cross-browser. > Cons: Very, very few features (i.e. only includes basic HTML editing). Does anyone still have a copy or a link to this? The above link doesn't work. I have a project where I could use this. Thanks, Duane Boudreau CFExperts ~~ 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: CFFILE Delete then WRITE issue....
> I see the merit to these suggestions. But, unfortunately this only works > around the problem and does not fix it. > The files are remaining for what looks like about 1 to 2 hours. Then someone has already been playing in the registry? Take a look at what the following key is set to: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\InetInfo\Parameters\Obj ectCacheTTL Here's what Micorsoft has to say about the ObjectCacheTTL: "This changes the frequency with which the cache scavenger runs. If your content fits in memory and is largely static, you may even disable the scavenger by setting it to 0x. A high ObjectCacheTTL works best for sites with a small number of "popular" files. If the number of frequently requested files is large, a high ObjectCacheTTL may not help. Setting this entry high tells IIS to try to keep unused files open longer. This is useful if you expect these files to be reused within the TTL period. If you do not expect the files to be reused often, or the system appears low on resources, use a lower ObjectCacheTTL to conserve resources. You can also use OpenFileInCache to limit the number of files IIS will keep open." > There is CSV directory already and all it holds are the 2 CSV's that can be > created. The problem with giving them unique names, is that then we would > need to educate the user community on how to import that CSV since the > program they have is looking for a specific name. Therefore we were trying > to keep it the same name that the application will be looking for. Is it necessary to delete the file then? Can you just overwrite it? This is probably the simplest solution of all. I sort of got distracted in the whole IIS caching thing and forgot to ask whether or not your are able to simply overwrite the file and whether or not this method works for you? > Again, these are great suggestions, but I want to know if this can be > fixed. This is the nature of the beast. Besides all the various work arounds and alternative methods I've thrown out, I don't know of a way to disable all caching performed by the Web server. Perhaps Microsoft's Knowledge Base or Deja News would provide better answers to these questions. > Is there a way to FORCE download and not give an option to OPEN? Again, No, and I do not see how this could affect a file on the server since it is a client side action. > Vance Duke > Cold Fusion Application Developer > i2 Technologies > (469) 357-4729 Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 "Benjamin S. Rogers" To: CF-Talk <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 12:54 PM Please respond to cf-talk > Sorry I did not elaborate before. NT 4.0 SP 5, CF 4.0, IIS 4.0. We guessed correctly. :) > The Application is Deleting a file if it exists and then writes the file > FRESH. Then gives the user a link to the CSV file. After that, the user > can download it, save it, or click another link to regenerate the file. It > seems to be happening when the user has OPENed the file and then decides to > generate another file that this error occurs. Again, I don't see why there would be a difference between opening and saving the file. Both those operations occur on the client side, not the server side. > Like I said before, I can then delete the file when they decide to generate > another file, but when I try to WRITE the new file, within seconds of the > first being deleted, that is when I run into what appears to be a file > header of a 500 bytes and it will not let me write it, access denied. The 500 byte file that you see is a placeholder of sorts. It exists for up to 30 seconds (the default ObjectCacheTTL). Unfortunately, you will have to adjust your logic to get this application working properly under IIS. Although I like the concept (and for the most part, the implementation) of the cache scavenger, it does add a couple steps to application design in situations such as these. What I would do is the following: 1) Create a directory that holds all the CSV files and only CSV files. 2) When the user requests the page that creates the CSV file, CFDIRECTORY the CSV directory and delete anything older than 1 hour or so. 3) Create your new CSV file with a unique name (either the CreateUUID() function or the RandRange() functions should work fine). Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 "Benjamin S. Rogers" To: CF-Talk <
RE: CF_Activedit alternatives??
> That may be true but considering that there are few number of people that > will actually be doing the editing and they only have to download the > plug-in once, its not that bad. When you edit a second time it's blazing > fast. The benefits far outweigh the time to download. It just requires > instilling some confidence and security to the client on your part. Usually > what I do is sit down at the client's computer and show them what happens > while explaining this is only done once. After it's loaded I let the client > sit down and let them start playing with it and their 'wonderment' and > excitement quickly replace any fears of the initial download. -Sold- Give > it a try with them and see if that helps. Some developers work in environments and with companies that are far too large and distributed to sit down and coddle all of the clients/employees. For me, the biggest issue with eWebEdit is the pricing model or lack there of. We inquired with them several times about purchasing many licenses but their fees were fairly exorbitant and, though they informed us they were undergoing a pricing change, we never received that information. In the mean time, several cheaper (free) alternatives have shown up. eWebEdit still has an advantage as far as the Spectra integration goes, but then the new Spectra has fixed the problems and functionality of it's own WYSIWYG HTML editor. What does eWebEdit offer that the ActiveEdit doesn't? Of course, we've actually decided to go with ezEdit because all we really cared about (besides the HTML Editor) was the custom tag and source code availability. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 > Sincerely, > > Rob Sherman > Allaire Certified Developer & Instructor > CFDude, Inc. http://www.cfdude.com > (310) 543-1622 (310) 543-0512 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SESSION Timing out WAY before it's supposed to.
> > >sessionmanagement="Yes" > >setclientcookies="Yes" > >sessiontimeout="#CreateTimeSpan(0,12,00,0)#"> > > Joshua, > > Remove the double-quotes from the sessiontimeout parameter. That's burned me > more than once. :) (And make that double-zero a single zero.) There is nothing wrong with double quotes. That is the "proper" way to code ColdFusion. The following code is not preferable because Allaire may drop or change support for this syntax: In any case, right now they both mean the same thing so this is not the problem. What is the maximum session timeout for the server? This is set in the ColdFusion Administrator. I believe the default is 20 minutes. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SESSION Timing out WAY before it's supposed to.
> What is the maximum session timeout for the server? Heh, just read the entire original message. :P The double zero looks suspicious. Have you tried that as a single zero yet? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 6:03 PM To: CF-Talk Subject: RE: SESSION Timing out WAY before it's supposed to. > > >sessionmanagement="Yes" > >setclientcookies="Yes" > >sessiontimeout="#CreateTimeSpan(0,12,00,0)#"> > > Joshua, > > Remove the double-quotes from the sessiontimeout parameter. That's burned me > more than once. :) (And make that double-zero a single zero.) There is nothing wrong with double quotes. That is the "proper" way to code ColdFusion. The following code is not preferable because Allaire may drop or change support for this syntax: In any case, right now they both mean the same thing so this is not the problem. What is the maximum session timeout for the server? This is set in the ColdFusion Administrator. I believe the default is 20 minutes. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ 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: Complex Database System
Here are some reviews of a few relative technologies: http://www.zdnet.com/enterprise/stories/linux/0,12249,2646052,00.html http://www.zdnet.com/eweek/stories/general/0,11011,2646051,00.html Here are a few product comparisons between ColdFusion and ASP. Keep in mind that they are both biased towards ColdFusion. Ironically, the latter was written by a developer who now codes in Zope. http://www.houseoffusion.com/hof/body/asp.cfm http://www.swynk.com/friends/murphy/ironic_isnt_it.asp Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:11 AM To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ 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: Web Based SQL Manager
My, how quickly you were able to gleam the full realm of possibilities for this product without having seen it. Luckily, I didn't immediately assume Clint's intentions were evil and thought of at least one viable use for such a product. If your network sits behind NAT, rather than exposing our SQL Server to the outside world so that developers have access to it via Enterprise Manager, you could create a Web based Enterprise Manager on one of your already exposed Web servers. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 11:22 AM To: CF-Talk Subject: RE: Web Based SQL Manager The only practical use I see for this is to mess around with SQL without having a client license (and software). I'd like to see it though -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 9:26 AM To: CF-Talk Subject: Web Based SQL Manager Would any of you be interested in a web based SQL Server7 Manager(its free)? ~~ 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: Web Based SQL Manager
I think you missed the point. The point is to keep the box out of site of the Internet. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 6:26 PM To: CF-Talk Subject: Re: Web Based SQL Manager - Original Message - From: "Benjamin S. Rogers" <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 7:05 PM > If your network sits behind NAT, rather than exposing our SQL Server to the > outside world so that developers have access to it via Enterprise Manager, > you could create a Web based Enterprise Manager on one of your already > exposed Web servers. Of course, if you have Windows 2000 Server or above, you would use the provided terminal services, which give you total admin control (by way of a virtual admin session) over the entire server as if you were actually right there at the keyboard - and with the full force of Win2K security. Adrian Cooper. ~~ 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: Version Control
I don't believe there is a Windows version of the CVS server. There is a Windows client, but it has to talk to a *nix server. I wouldn't expect them to develop one either "due to issues with the suitability of Windows as a server operating system." That said, CVS is also not the most intuitive application, but I've yet to use one that I did consider intuitive. Though CVS is run on most of the largest open source development projects with great success and *nix programmers seem to love it, I wouldn't want to have to teach it to HTML and programmers and designers. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 7:59 AM To: CF-Talk Subject: RE: Version Control Hey Bjorn. CVS is good. You can use it across platform too to my knowledge. There is a windows version and a linux version. - LEGAL DISCLAIMER -- This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please return it to the sender and destroy the message and/or copies in your possession. The views or opinions expressed in this email are that of the individual and not necessarily those of A.B.C (Systems and Development) Limited or any of it's subsidiaries. -Original Message- From: Bjørn Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 January 2001 12:41 To: CF-Talk Subject: Version Control We could really need some Version Control software here at work, and I have found 2 products CS-RCS - http://www.componentsoftware.com/csrcs/addons/allaire.htm and CVS - http://www.cvshome.org/docs/index.html Does anyone know which is the best, or maybe even know a whole 3rd product that is even better ? Bjorn Jensen - Professional Nerd and coder ~~ 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: Version Control
I assume by your choices that you are looking at free products only? If not, you may want to consider Visual Source Safe. You can get this with a purchase of the developer edition of Microsoft Office 2000. And though I haven't used Starbase's product offering, I have heard good things about it. It is quite expensive, however, if you run it as a client/server application. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Bjørn Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 7:41 AM To: CF-Talk Subject: Version Control We could really need some Version Control software here at work, and I have found 2 products CS-RCS - http://www.componentsoftware.com/csrcs/addons/allaire.htm and CVS - http://www.cvshome.org/docs/index.html Does anyone know which is the best, or maybe even know a whole 3rd product that is even better ? Bjorn Jensen - Professional Nerd and coder ~~ 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: cfx_cybercash is gone???
It was renamed CFX_ONCR_Cybercash a couple years ago: http://www.cfxoncrcybercash.com/ The company's site is at http://www.oncr.com. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Christopher Porter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 1:52 PM To: CF-Talk Subject: cfx_cybercash is gone??? hey everyone.. i cant seem to find allaire's cfx_cybercash tag (the free one) in the tag gallery? anyone have it or know where i can get it? thnx -chris ~~ 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: Slightly OT: CSS Help Needed!
> I'm trying to design drop-down menus using CSS. If I > knew exactly where the menus were to appear, it would > be easy using absolute positioning and the visibility > property. There are a lot of really good canned scripts out there. One of those will probably do everything your looking to do. Don't underestimate the amount of time you will spend debugging DHTML in the different browsers. > Unfortunately, the menus must be placed relative to a > table. The table is centered on the page, and it's > width isn't always the same. The menus must be aligned > with this table. When I use relative positioning, the > menu appears in the right place, but it is positioned > inline with the rest of the page. Rather than > overlapping with the elements below it, it simply > pushes them lower and makes room for itself. That is how relative positioning works. It appears logically in the context of where it is coded. Fixed positioning would take the menus out of the context in which they are coded and make the menus relative to the corner of the browser. However, this is not exactly what you are looking to do. You will want to make a layer within your table that is positioned relatively. This layer should be where you want the menus to appear. Within this layer, you will create separate layers for each of your menus and give them an absolute position. Declaring the position as absolute has a similar effect to fixed, however the element is positioned relative to the top left corner of the next layer up. In the absence of another layer, they will appear positioned against the top left corner of the browser window. > I can't seem to get the menu to float "above" the > picture below it. I tried the z-index property to no > avail. You need to declare absolute or fixed positioning to take the menu out of the logical context in which the page was coded. > For a sample of my problem (and a stunning picture of > some cable tv stuff), visit > http://it.wm.edu/network/csshelp.htm. Couldn't get to the page. > Please let me know if this is possible! Definitely possible. Have a look around the Internet and you will see that there are many people doing this. > Thanks! No problem. :) Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 ~~ 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: cfx_cybercash is gone???
My apologies, I did not mean to mislead anyone. If I remember correctly, I think ONCR did rename their tag from CFX_CyberCash to CFX_ONCR_CyberCash awhile back. I didn't know Allaire had one as well. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 2:13 PM To: CF-Talk Subject: RE: cfx_cybercash is gone??? Benjamin, That is actually a different tag. The ONCR tag is by far superior to the one Allaire wrote (CFX_CyberCash), but the Allaire tag's price is right, free. We use the ONCR tag with no problems. However, we used the free tag for all of our initial development. Unforetunately, all I have anymore is the DLL, none of the documentation. Sorry. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 16, 2001 12:39 > To: CF-Talk > Subject: RE: cfx_cybercash is gone??? > > > It was renamed CFX_ONCR_Cybercash a couple years ago: > > http://www.cfxoncrcybercash.com/ > > The company's site is at http://www.oncr.com. > > Benjamin S. Rogers > Web Developer, c4.net > Voice: (508) 240-0051 > Fax: (508) 240-0057 > > -Original Message- > From: Christopher Porter [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 15, 2001 1:52 PM > To: CF-Talk > Subject: cfx_cybercash is gone??? > > > hey everyone.. i cant seem to find allaire's cfx_cybercash tag (the free > one) in the tag gallery? anyone have it or know where i can get it? > > thnx > -chris > ~~ 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: Adam, you got to be kidding?
> how can you develop assuming that scripting is ON? It's my experience that most developers assume this as well. Most developers also take the time to ensure that scripting degrades gracefully in non-scripting browsers when it is convenient. The problem is that some applications/interfaces require scripting. > if 2% of your customers have scripting disabled (just to use your numbers > for a mo'), that's 2% of the people who WON'T be coming back to your site to > buy something. that's like refusing to put in handicapped access ramps, > because hey, only a small portion of the population is disabled, and i don't > care if they can't get into my store. Calm down there Chris. :) Comparing non-scripting browsers to people with handicaps is a little extreme. For the most part, people choose to disable scripting in their browsers. They also choose to change Web site colors and font sizes as well as whether or not to display images. These things can't be helped, nor should they be. This doesn't stop most of us from using images in pages. We, as developers, have to make conscious decisions to use images, scripting, etc. when certain users might not be able to view this information because they have elected to turn it off or because they have a real handicap that requires they use a browser with alternative renderings or input methods. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 8:15 AM To: CF-Talk Subject: Adam, you got to be kidding? You actually develop with the mindset that a user might not have scripting enabled? Ouch! My guess would be that at a minimum, 98% of all users have scripting enabled. So, you would forfeit the capability of client-side data validation, client-side DOM manipulation, etc.? You would add unneeded round trips to your server to accomplish scripting, validation, etc.? So 98% of your users will pay the Performance price for the 2% of your users? Not to mention the extra load on your server and the wasted bandwidth. Not a good idea ... Please! Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_Grid error
It appears that your ISP has not set up a virtual mapping for the CFIDE directory on your domain. This is necessary. Otherwise, your client will not be able to download the java applets necessary to view the tree. Here is a knowledge base article that explains the issue further: http://www.allaire.com/Handlers/index.cfm?ID=11904&Method=Full Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Jack Ince [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 11:01 AM To: CF-Talk Subject: CF_Grid error Hi This is my first posting, and I really do need help. I am using a CF_Grid for my client to input data. It works on my machine and the ISP's machines, but not on the clients. The client has all java enabled etc. tks ** java.io.FileNotFoundException: www.odd-lot.com:80//CFIDE/classes/allaire/controls/cfGridFormApp let.class java.lang.ClassNotFoundException: allaire.controls.cfGridFormApplet at com/ms/vm/loader/URLClassLoader.loadClass at com/ms/vm/loader/URLClassLoader.loadClass at com/ms/applet/AppletPanel.processSentEvent at com/ms/applet/AppletPanel.processSentEvent at com/ms/applet/AppletPanel.run at java/lang/Thread.run Microsoft (R) VM for Java (tm), 4.0 Release 4.79.0.2424 == ~~ 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: Single Quotes in SQL HELP PLEASE!
> you can use PreserveSingleQuoutes(#var#) Actually, the preserve single quotes function should only be used when you are writing whole the SQL expression (rather than just data values). If you do this, you must take special care to escape all single quotes in your single quoted value strings. >> ok, I want to enter this character into a SQL table. ' >> >> but i get an error. how do I make it enter ' into the database? Escaping characters in SQL is much like escaping characters in ColdFusion. You double up the character you need to escape. In this case, you would want to escape the quoted single quote. >> INSERT INTO MyTABLE(Stuff) >> VALUES = ''' The following should work: INSERT INTO MyTABLE(Stuff) VALUES = '''' Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 ~~ 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: Single Quotes in SQL HELP PLEASE!
Ooops! I didn't read your query thoroughly enough. I just glanced at it and escaped the single quote. My apologies. This is what you'll want to do: INSERT INTO MyTABLE ( Stuff ) VALUES ( '''' ) Sorry about that. I'll have to pay more attention next time. :) Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 ~~ 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: Cold Fusion Forums
Again, this defeats the purpose of buying a canned product as oposed to coding it yourself: you pay too much for the license, you lose the upgrade path, and you end up doing all the work by hand. I have yet to find a Forum application that fits these and many other requirements. Many seem to lack a "multi-threaded" veiw. FuseTalk, for example doesn't seem to have a multi-threaded view. All responses on a certain subject appear in the order they were posted with no hint as too which message is being directly replied to. This behavior is more like a mailing list than a forum. Here's what my recent research into ColdFusion based forums has produced: ColdFusion Boards - http://www.cfboards.com/ Price: $595 Server License with Source Code; $395 Server License Pros: Fusebox; Threaded discussions Cons: One man operation; Thread view only appears in a JavaScript pop-up window 4um - http://www.4um.nl Price: $695 with Source Code; $495 Pros: Threaded discussions; Integrated chat; Familiar Windows interface; Price Cons: One man operation; Framed and rigid design will not integrate into sites FuseTalk - http://www.e-zonemedia.com/ Price: $1999 Single Server License with Source Code; $999 Single Server License Pros: Feature rich; Popular; Good design Cons: Only single-threaded discussions; Price; Design is a little too GUI and probably won't fit into site designs without substantial customization; Each forum requires its own database (new version will address this); Requires ColdFusion 4.5.1 CF Forum 2000 - http://www.cfcode.com/ Price: $500 Single Server License with Source Code; $995 with Source Code Pros: Good, Clean Design that will fit into most sites without much customization Cons: One man operation; Only single-threaded discussions; OrbForum - http://www.orbwave.com/ Price: $79.95 Pros: Multi-Threaded discussions; Clean/Light Design that will fit into most sites without much customization Cons: Lacking in many features; not a very robust security model; lacks a single-threaded view of discussions; Server license? Simple Message Board - http://www.simplemessageboard.com/ Price: Free? Pros: Price; Clean Design that will fit into most sites without much customization Cons: One man operation; Still in pre-release stages Allaire Forums - http://www.forumspot.org/ Price: Free Pros: Popular; Open source development; Clean/Light Design that will fit into most sites without much customization; Multi-threaded discussions Cons: Difficult to setup (previous versions); overly complicated code base; no single-threaded discussions; performance issues?; Lacks a single-threaded view of discussions Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Paul's Mail [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 1:14 PM To: CF-Talk Subject: RE: Cold Fusion Forums You can purchase the oprn code version and do just about anything with it you like. Paul Burgess > -----Original Message- > From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 29, 2001 6:45 PM > To: CF-Talk > Subject: RE: Cold Fusion Forums > > > The FuseTalk forums always seen to look the same. Is it > customizable at all? > Do you have any examples of a FuseTalk forum that doesn't look like a > FuseTalk forum, preferably an example of one that is integrated > cleanly into > the design of a site? > > Benjamin S. Rogers > Web Developer, c4.net > Voice: (508) 240-0051 > Fax: (508) 240-0057 > > -Original Message- > From: Angél Stewart [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 29, 2001 12:30 PM > To: CF-Talk > Subject: RE: Cold Fusion Forums > > > FUSETALK!!!FUSETALK!!!FUSETTAAALLKK!! > > Its the best! Totally the best! :) > The things this board can do..its amazing! Any feature you could want..you > got it! > > There are avatar pics, private messaging, realtime Chat functions! > You can hook the registration for the database out to a secondary > datastore..an existing user database in other words.. > > its got everything! I am totally totally pleased with this thing :) > www.carigamer.com/forum > > I can't wait for when we start advertising and throw our next > tournaments to > see the feedback from the users :) > > -Gel > www.carigamer.com > Island Gaming At Its Best!(tm) > "The Surgeon General Advises That Playing Violent Video Games Is > NOT Harmful > To Your Health"-Surgeon General's Report 2001. > > > - Original Message - > From: "S R" <[EMAIL PROTECTED]> > > > Hi Everyone, > > > > Can anyone recommend a good software package either from Allaire or > someone > > else that can be used for web forums, sort of like this cf-talk forum? > > > > Thank You
RE: Cold Fusion Forums
Thanks. I had yet to find one that could switch between views so easilly. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 3:58 PM To: CF-Talk Subject: RE: Cold Fusion Forums > I have yet to find a Forum application that fits these and many other > requirements. Many seem to lack a "multi-threaded" veiw. FuseTalk, for > example doesn't seem to have a multi-threaded view. All responses on a > certain subject appear in the order they were posted with no hint as too > which message is being directly replied to. This behavior is more like a > mailing list than a forum. (Here I go again. ;p) SMB has the option of viewing all threads in a tree-view or in a thread-view. For example: Like this: http://www.simplemessageboard.com/demo/thread.cfm?TID=1030&Expand=NO Or Like this: http://www.simplemessageboard.com/demo/thread.cfm?TID=1030 > Simple Message Board - http://www.simplemessageboard.com/ > Price: Free? Yes. Free. GNU Public License. > Pros: Price; Clean Design that will fit into most sites without much > customization Thanks you. ;p > Cons: One man operation; Still in pre-release stages True enough. The current release is functional except for the lack of some adminstration function. I've gotten some help on both a version that runs on CFExpress as well as changes for MySQL... (Linux hooray!) Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion ~~ 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: Cold Fusion Forums
Not to discourage you from starting an open source project, but there are already several in the works. Allaire Forums was open sourced and can be found at http://www.forumspot.org. There is also Simple Message Board, which can be found at http://www.simplemessageboard.com/. You may want to investigate these products and consider throwing your effort at one of these products instead of starting a new one. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Chris Straight [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 2:17 PM To: CF-Talk Subject: RE: Cold Fusion Forums >From what I understand People are looking for a feature rich forum system that is cheap and customizable. What about an Open Source Project. I am very willing to contribute my time and effort as well as code that I have been working on to create a free to use and modify Forum System. It seems to be needed. I want to see how many people would be interested in working on such a thing? Chris Straight Web Developer University of Oregon Bookstore, inc. http://www.uobookstore.com/ (541) 434-3274 -Original Message- From: Erika L Walker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 1:23 PM To: CF-Talk Subject: RE: Cold Fusion Forums (she hesitates to post to this boardfear of igniting the flames of the forum gods.) What about the bare-bones-bboard found on allaire.com/developer ? I know it's not exactly feature rich, but as far as a simple threaded messageboard is concerned, I've been able to integrate it fairly well for a couple of different clients, massaging the look and feel as I see fit. You have to add your own login capability if you need it, but it does send emails to the person posting the message if they choose to receive notification. It's small, open-source, and free! There is always the option of writing it yourselfand webmonkey gives you a tutorial on how if you need itof course there's always that time issue thing :-) Cheers, (did she get away unscathed) Erika AIM: WebErika5 Yahoo: WebErika MSN: WebErika AskMe.com Expert: WebErika Erika L. Walker Vice President RUWebby, LLC 201-370-4272 (c) 973-244-9120 (o) 153 Rutgers Lane Parsippany, NJ 07054 Website Design/Programming Database Integration Allaire Partner - ColdFusion -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 3:58 PM To: CF-Talk Subject: RE: Cold Fusion Forums > I have yet to find a Forum application that fits these and many other > requirements. Many seem to lack a "multi-threaded" veiw. FuseTalk, for > example doesn't seem to have a multi-threaded view. All responses on a > certain subject appear in the order they were posted with no hint as too > which message is being directly replied to. This behavior is more like a > mailing list than a forum. (Here I go again. ;p) SMB has the option of viewing all threads in a tree-view or in a thread-view. For example: Like this: http://www.simplemessageboard.com/demo/thread.cfm?TID=1030&Expand=NO Or Like this: http://www.simplemessageboard.com/demo/thread.cfm?TID=1030 > Simple Message Board - http://www.simplemessageboard.com/ > Price: Free? Yes. Free. GNU Public License. > Pros: Price; Clean Design that will fit into most sites without much > customization Thanks you. ;p > Cons: One man operation; Still in pre-release stages True enough. The current release is functional except for the lack of some adminstration function. I've gotten some help on both a version that runs on CFExpress as well as changes for MySQL... (Linux hooray!) Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion ~~ 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: Cold Fusion Forums
> Full, complete and total customisation in ADDITION to an easy upgrade path, > isn't possible. Of course it is! It is called separation of content and design, which in tandem with extensibility, meets all these requirements. In all practical senses, it is available in many of the applications we already use. AbleCommerce, despite any other faults or short comings, is a good example of this. The last time I looked at the product, the user could chose the look and design of the site using a web based wizard. The wizard creates several display templates unique to that instance of the store. The display templates constitute the design and layout of the store. There are only a few of them, and they can be stored anywhere. They can also be customized to your hearts content without affecting the store engine. The engine can be upgraded without replacing the affecting the display files. > Once you start to mess with the source code it stops being Fusetalk or > Ultimate Bulletin Board and it becomes YOUR messageboard. With all do respect to the developers on those projects, that's because those products are lacking in this respect, which is why we are having this dialog. > That said, I still think that Fusetalk is the best message board system I > have seen for Coldfusion, or any other application server/scripting > language, whether you want to use it 'out the box', or as a base to build > your own. I think it is the most respectable product of the bunch, but it is a very rigid application. It is certainly not a one-size fits all application, and unfortunately, it doesn't seem to fit us. :) We are an ISP/ASP/Design shop: we would prefer an application that can address all the aspects of our business. The next version should address some of FuseTalk's shortcomings on the ISP/ASP side of things. Hopefully, they will also address some of the concerns we've been discussing. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 *humph* *folds arms and nods firmly* . . ;-) hee hee hee -Gel www.carigamer.com Island Gaming At Its Best!(tm), -Original Message- From: cassady [mailto:[EMAIL PROTECTED]] Customization is the most important part look and function. (1) I use a forum system for Spank! Youth Culture Online, and there is no way that most available forums systems out there can be customized to meet the target demographic: 14 to 24. Look, feel, texture, graphics, flow, readability (or lack there of!) is all-important. I have some background in layout and typography and flow for a site has to work. (2) Customization of code: I needed to tie in the users to a whole bunch of tracking and publishing stats and permission. Also, were working on incorporating Short Messaging into the forums, assignable graphics, et. All. While youre not specifying functionality any changes or additions will have an influence on the layout and GUI. So again if you begin to deviate from the package, than you need to be able to rip the interface apart. (3)While I am totally biased (I built Spank!s forums from the ground up, and am rewriting them again) there really is nothing better than total customization of the GUI, which usually means ripping most of the any packaged system code apart. Stephen R. Cassady [EMAIL PROTECTED] ~~ 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: Cold Fusion Forums
As you've said, Fuseboxing the site is a good way to break out queries, making it easier to develop and maintain support for multiple RDBMSs. It is also a good way to break out display files. Once that has been done, groups of display files can be made into "themes" and applied fairly easily to a site to change the look and feel without having to go to the code. Though we don't develop in Fusebox, we do follow most of the same basic ideas and much of our application design looks Fusebox like. We find that we're generally more comfortable working on Fuseboxed source code than non-Fuseboxed code. That said, most of the non-fuseboxed code we've seen has been without an overriding structure or design principle. Personally, I think Fusebox is an approachable and easily understood methodology. However, even if you do not choose to use Fusebox, I'm encouraged to see that you are approaching these problems from several different angles and addressing them accordingly. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 31, 2001 9:10 PM To: CF-Talk Subject: Re: Cold Fusion Forums > Tony did you consult your current user base before making this move? And if > people don't want to use fusebox will you still have the older codebase > available for download? Not before, and I honestly wasn't sure that I was going to release it in fusebox, but I felt that I'd try the "method" and see how it worked with SMB. I figured I'd end up with two versions, not that I want that though. As it stands now, if you want see the fusebox version in its current state, it's at http://www.simplemessageboard.com/fusebox/ and it uses the same database as the existing demo forum. I just finished 90% of the rewriting links (and corresponding cfcase index structure), used the cf_bodycontent method for header and footer and started moving a couple queries to cfinclude. The latter will be helpful for the MySQL version. If I have to maintain two versions, it won't really be that hard. My code is pretty self-contained as it is (ie: one page per task) and is in neat chunks that I can move easily... But I've received 2 comments that said "don't do it" and 1 that said "do it"... So, I don't know. If I complete the fusebox version, I'll probably have it available as additional version, rather than a replacement. I'm going to focus on finishing the language part - that's so much more a pain... Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ 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: Moreover News Feed
A scheduled task queries MoreOver once an hour (or when the page below first loads) and deserializes the WDDX feed into a query that is stored in the application scope. Anyway, the actual display is nothing terribly interesting. We just use the extra content to liven up the site a bit. http://www.foodcount.com/Index.cfm?Method=Nutrition Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Vance Duke [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 1:38 PM To: CF-Talk Subject: Moreover News Feed I assume there are some people here using the Moreover.com News feed. I was wondering if someone might like to send me links to their site so I might see how you implemented it. I am not much on the "look and feel" side and was looking to get some ideas. Thanks in advance, Vance Duke Sr. CF Programmer ~~ 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: Moreover News Feed
The service we are discussing is offered free of charge by MoreOver.com. They provide categorically organized news feeds, updated by hand by their own staff members. The news feeds are provided in several different formats, one of which is WDDX. Because MoreOver is only providing bibliographic information about the articles, they do not need to charge any royalty fees. They have in turn provided this service free of charge to developers. MoreOver has many other services that it does charge for, including supplying the news content to several high profile sites such as AltaVista. In any case, the MoreOver is a good quick and dirty way to add more content to a site free of charge. It is really a good deal all around. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 3:06 PM To: CF-Talk Subject: Moreover News Feed Okay, maybe I live under a rock or something, but I gotta ask. What exactly *is* the moreover news feed? Is it a news service that lets you use that cfhttp tag and pull news stuff from their site? Does it cost money? How does it work? It seems really cool on your site, and I'm curious as to how this all works... Jeff Small on 4/9/01 2:33 PM, Benjamin S. Rogers at [EMAIL PROTECTED] wrote: > A scheduled task queries MoreOver once an hour (or when the page below first > loads) and deserializes the WDDX feed into a query that is stored in the > application scope. > > Anyway, the actual display is nothing terribly interesting. We just use the > extra content to liven up the site a bit. > > http://www.foodcount.com/Index.cfm?Method=Nutrition > > Benjamin S. Rogers > Web Developer, c4.net > Voice: (508) 240-0051 > Fax: (508) 240-0057 > > -Original Message- > From: Vance Duke [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 09, 2001 1:38 PM > To: CF-Talk > Subject: Moreover News Feed > > > > I assume there are some people here using the Moreover.com News feed. I was > wondering if someone might like to send me links to their site so I might > see how you implemented it. I am not much on the "look and feel" side and > was looking to get some ideas. > > Thanks in advance, > Vance Duke > Sr. CF Programmer > ~~ 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: Moreover News Feed
Next time, you may want to avoid off topic post and spare the developer the public criticism by sending a message directly to the developer, the company hosting the site, or to the contact address listed on the site. In any case, I'll pass on your observation to the appropriate FoodCount.com staff member. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 3:45 PM To: CF-Talk Subject: Re: Moreover News Feed Not to be picky, but there's a blatant typo on your site. On the "My Diet" page, under "Add Your Foods" you've got "locate" spelled "loate". (BTW - nobody's worse than me at making typos) Dave - Original Message - From: "Benjamin S. Rogers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 09, 2001 2:33 PM Subject: RE: Moreover News Feed > A scheduled task queries MoreOver once an hour (or when the page below first > loads) and deserializes the WDDX feed into a query that is stored in the > application scope. > > Anyway, the actual display is nothing terribly interesting. We just use the > extra content to liven up the site a bit. > > http://www.foodcount.com/Index.cfm?Method=Nutrition > > Benjamin S. Rogers > Web Developer, c4.net > Voice: (508) 240-0051 > Fax: (508) 240-0057 > > -Original Message- > From: Vance Duke [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 09, 2001 1:38 PM > To: CF-Talk > Subject: Moreover News Feed > > > > I assume there are some people here using the Moreover.com News feed. I was > wondering if someone might like to send me links to their site so I might > see how you implemented it. I am not much on the "look and feel" side and > was looking to get some ideas. > > Thanks in advance, > Vance Duke > Sr. CF Programmer > ~~ 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
Movie Show Time Feed (was: RE: Moreover News Feed)
I don't suppose anyone has found a service similar to Moreover or iSyndicate that feeds national movie show times and other pertinent information about movies (e.g. reviews, theater locations, etc.)? Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 ~~ 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