RE: BLACKSTONE: Software Development Times Article
Like all things CF, it's more accessible to people who aren't Java experts. Writing an event gateway requires knowledge of Java therefore yours is not a valid argument. Declaring that it's not a valid argument does not make it so. As many people have already stated, there will be several built in gateways. ColdFusion developers will be able to start using these from day one with no knowledge of Java. I've only had the past week or two to think of ways to utilize gateways. The gateways that have already been announced sound like they will suffice for the uses I've been able to come up with. However, I'm sure that, as new possibilities occur to me, I may find I need other gateways. At which point, I'm sure I'll be able to download or purchase gateways from third parties. If all else fails, I can hire a Java programmer to write the gateway and then program to it from within ColdFusion. None of these options require any knowledge of Java on my part. Granted, the third option, hiring a Java programmer, doesn't offer ColdFusion developers much more than what is capable today. Nevertheless, the gateway architecture will provide a de facto standard for integrating gateways with ColdFusion. I think that alone is a good thing because it gives developers, writers and teachers something to focus on and simplifies the language for discussing gateways and their use from within ColdFusion. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
You are missing the context of the thread though. Maybe I am. I don't think so, but it's always possible. :) This thread has been very long, and, as most mailing list conversations go, it's covered quite a bit of territory. The original statement was as follows. Which itself was a reply to previous message. As you can see, the poster suggested that a new gateway could be written, so yes it does indeed require knowledge of Java. Since this particular use can is not made easier by CF and requires knowledge of Java then the argument that CF makes it easier is not valid. I disagree. I'm sure ColdFusion (the platform) will provide an infrastructure which makes developing gateways relatively easy. Further, as I stated in my previous post, I think it provides ColdFusion developers, gateway developers, and the ColdFusion community with a common interface and language for describing it. Now, as to your argument as a whole, I don't think it's a mistake to say you've spent a good deal of your time in this thread arguing that ColdFusion gateways offer very little. You've argued that very few applications built in ColdFusion will have a use for gateways because very few J2EE applications utilize JMS. Though I agree that a small percentage of applications will use them, I think most developers will use gateways in their applications at some point. By way of example, a relatively small percentage of my applications use COM interoperability, Web services, or even the cfdirectory tag. Nevertheless, I find those features indispensable. You've also stated that you don't believe the built in gateways will be enough: What is the likelihood of the built-in gateways doing everything you need? In my previous message, I stated that I think the gateways already announced sound like they'll suffice for most of what I've already dreamed up. I hope to be proven wrong because that means I will have found new uses for gateways. :) All in all, you've been arguing that you can already build gateway-like interfaces which invoke ColdFusion pages (ostensibly using Java or another lower level language to detect the event and invoke a ColdFusion page via HTTP?). For these reasons, you've implied (strongly) that gateways are a waste of Macromedia's resources. Do you still think I'm missing the context? -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: foreach?
Not exactly. You can do a foreach style loop over a structure, but even then
you are limited to looping over the key names rather than their values:
cfloop collection=#myStruct# item=myKey
cfoutput#myStruct[myKey]#/cfoutput
/cfloop
Or...
cfscript
for (myKey in myStruct) {
writeOutput(myStruct[myKey]);
}
/cfscript
There's no similar syntax for looping over the elements of an array. You're
limited to a for loop with arrays.
Ben Rogers
http://www.c4.net
v.508.240.0051
f.508.240.0057
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 11:58 AM
To: CF-Talk
Subject: foreach?
Is there any way to do a foreach-type loop in CFML?
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
Nothing endures but change. - Heraclitus
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: VMWare was Re: Best choice for ColdFusion Studio IDE...
In The Art of Unix Programming, you get an interesting history on WHY various OS's are the way they are It's also horribly misinformed. Though ESR seems to know a good deal about Unix, his knowledge of other operating system seems to be very shallow. In particular, some of the statements he makes about BeOS and Windows, the two operating systems I probably know most about, are really off. I made it about 3/4 of the way through the book and had to give up. He degenerates from interesting Unix history and theory to mud slinging random attacks against Windows and self-aggrandizement. I started the book hoping to learn something. Besides some interesting historical tidbits -- mostly provided by other contributors -- the book offers very little. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- SQL backup question
You need to wrap the active portion of the log file to the beginning of the log. To do this, you have to issue a bunch of dummy queries. This page explains a bit more: http://www.tek-tips.com/gfaqs.cfm/pid/183/fid/345 Here's a script: http://www.bstconsultants.com/tsug/Dec99/REDUCING_THE_SIZE_OF_THE_LOG_FILE.h tm You may have to run the script many times depending on how big the log file is and how far the active portion is from end of the log file. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 10:00 AM To: CF-Talk Subject: OT- SQL backup question I back up my transaction log with the following script. How come after the script runs (successfully), the .LDF file is still large and not smaller? I thought when you backed up the file it is completely truncated thus freeing up space? BACKUP LOG AVPhoneLookup TO DISK= 'g:\avbkp\avp_trans.bak' WITH INIT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Microsoft acknowledges CF!
They also only talked about the general functionality of CF. There are so many built in functions in CF that I think we all take for granted because they've been in there so long. Things like manipulating lists, queries, dates, display formatting. The list of CF's *real development benefits, IMHO, is huge. But these things are never discussed in comparisons with other languages. When comparing CF to classic ASP, this was true. However, the .Net framework provides a much richer environment. You're no longer limited so a small number of VBScript or JScript functions. To a certain extent, you can achieve this in CF with Java. However, CF's Java support is relatively shallow. Additionally, it requires knowing a second, much more complicated language. In contrast, VB, Jscript, and C# are all first class .Net languages. You can utilize just about anything in the .Net framework. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
What do you mean by shallow support? There's a good deal of Java that simply can't be used directly from within CF. A lack of support for null values is a big reason. There's also a good deal that requires workarounds or hacks. It's certainly possible to use a lot of Java from within CF, but it requires 1) knowing a second language and 2) knowing Java well enough to be able to workaround the implementation details. In contrast, Visual Basic, Jscript and C# are all first class .Net languages. This means that they can treat anything in the .Net Framework as a native object (with a few exceptions). So, a VB programmer doesn't have to learn a new language to implement something in the .Net Framework. Honestly I almost never used Java in CF since CF has almost everything I ever needed. I agree for the most part. I can program most Web sites completely in ColdFusion, and in most cases that is perfectly reasonable. However, for example, there are many times where it would be preferable to use a data type other than a struct or an array. I can now create my own data types using CFCs, but that's not nearly as nice as having every common (and some not so common) data types pre-built for me. My point isn't that I can't do most of what I need to in ColdFusion. It's just that the old arguments no longer apply. It used to be the case that ColdFusion offered an environment that was much richer than other competing platforms such as ASP. I do not believe this to be the case anymore. I believe ColdFusion is on par with most other platforms and that it offers most of the functionality that I need to develop most Web applications without resorting to coding COM objects or Java classes, or purchasing third party components. As a side note, the biggest notable exception from my perspective is image manipulation. I'd love some native image tags. I'm hoping that the jimg tag off the resource kit makes it into the next release of ColdFusion. Once should also look at what is needed, not what can be done. Sure C#.Net offers a lot, but you only really need a fraction of that for the web. I only need a fraction for any given Web site, yes. However, I need different pieces for different Web sites. In some Web sites, image manipulation is a big deal. In others, COM interoperability is important. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX cfcontent
Try attachment instead of inline in your cfheader tag. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 From: Mickael [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 11:34 AM To: CF-Talk Subject: Re: CFMX cfcontent Hi Dave, Let's say my browser where I do not have the option to open XLS in my browser selected. What happens is that I get the cfm template as the filename in the save as dialogue box. I noticed in your examples that you added foo to the Query string. My query string contains the file name which is a date that I append to the a base filename. My client has files that are called MMDDProcessing_Report yet they only want to see the filename in the save as box as processing_report.xls like so template.cfm?filedetails=#filedetails# Then my act page has the following cfheader name=content-disposition value=inline;filename=Processing_Report.xls cfcontent type=application/unknown file=c:\inetpub\DailyDownload\#variables.file_details#Processing_Report.xls When the dialoge box comes up, what I get is the my cfm template with my url string. Any ideas Mike - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, April 16, 2004 11:09 AM Subject: RE: CFMX cfcontent I have never been able to get CFCONTENT to consistently force a download of a file, let's say an excel file to the user. I have actually spent the whole morning looking for a PHP or _javascript_ replacement for this. I am on a Shared hosting environment but have found CFCONTENT unreliable on CFMX. Do you find it reliable? If yes what is your secret :) You can't force a download of a file - that's up to the user (and his or her browser). You might try running these samples on your server and see how they work for you: http://www.figleaf.com/demo/mimetest/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: RE: What is a Factory?
I don't know of any official definition of a Manager, but here's my definition. It's not so much a definition as an explanation of how I end up with classes that have Manager in their name. :) I start with a class that has grown far too large and unwieldy. I take methods which I've subconsciously grouped together in the class or named in a similar fashion, and refactor them into another class which ends in the word Manager (the name is completely arbitrary but it sounds good). Once I have them broken out, I try to decide if they look like any pattern I've read about or seen before. If so, I change the name and refactor accordingly. Otherwise, I stop there. For (a grossly simplified) example, I had a request object that was the entry point for handling every browser request to the Web site. It was in charge of determining the event and the view and invoking the appropriate event handler and/or display. As you can imagine, this grew over time. I eventually moved everything having to do with events to an EventManager and everything having to do with views to a...well, you get the point. I usually resort to a manager when a set of related tasks become so large that they begin to over burden an object. I refactor such tasks into a class which takes over the responsibility of handling those tasks. The purpose and intent of the original class is much more obvious when I'm done, which always a good thing. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 4:17 PM To: CF-Talk Subject: Re: RE: What is a Factory? Like Barney mentioned, class names may be local conventions without recognized standard practices. With that said, the Gang of Four defines a Factory Method's intent as Define an interface for creating an object, but let subclasses decide which class to instantiate. Factory Method lets a class defer instantiation to subclasses. (Design Patterns, p. 107) The UML diagram on the page Kwang referenced is the one from Design Patterns. As for a Manager--beats me! I've not seen any standardized definition of a pattern or practice called Manager. As Dave so rightly put it, a Manager manages. ;) - Jeff On 26 Feb 2004 at 13:48, Kwang Suh wrote: Factories exist so that the developer doesn't need to worry about what object they're creating (doing Foo foo = new Foo() is considered very bad practice by some members of the OO community). This way, one can change the factory to produce different objects within an object hierarchy. Take a look here: http://www.dofactory.com/Patterns/PatternFactory.aspx Personally, this is one of the more useful design patterns out there, but I've seen it misused (I once saw a system that used a factory object to create... factory objects). - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] Date: Thursday, February 26, 2004 1:30 pm Subject: RE: What is a Factory? Heh... that sounds to me like the functionality described for Manager objects. Or at least without more information about a specific scenario, the way I think I'd be liable to design that sort of thing would place this functionality in a Manager rather than a Factory. Thanks Mosh Isaac: A lot of times, a Factory is used to not only create but also to manage the creation of objects. For example, in a situation where you want to support database connection pooling, you would use a Factory to manage the creation an/or reuse of connections. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [EMAIL PROTECTED] Sent: Thursday, February 26, 2004 3:00 PM To: CF-Talk Subject: Re: What is a Factory? Boy that seems like a useless abstraction... The factory that is ... the Manager I understand, but it seems like if you wanted a new something to put into a manager, you'd just use newThing = new Something(blah,blah) instead of having a separate factory object to create them. Is there some other reason for it that I'm not aware of? On Thu, 2004-02-26 at 11:17, Troy Simpson wrote: All, I noticed that some application user the terms Factory and Manager in the Class/Object Names. Like AppFactory, AppManager, and EventManager in Mach-II 1. What is the general definition of a Factory? 2. What is the general definition of a Manager? In a very basic way (from a java stand point) a factory produces and a manager manages so you'd tend to see stuff like Thing thing = Factory.createInstance() not Manager.createInstance() Manager.add(thing) not Factory.add(thing) Pretty much just what you think it does :) -- Rob [EMAIL PROTECTED]
RE: OT: windows mailing list
This is just my experience, but it seems rather hard to get anyone who works with windows to help on a newsgroup. They want you to buy a book or get MCS-idontrealyknowwhatsup-E certified. You'll find people that will help, but not to the same degree as in the open source world - where people just want to help for helps sake - it more of a whats in it for me ($$) kind of thing in windows land. I've just had the opposite experience. We're porting an application from ASP/Windows to SUNWAS/Linux. We bought RedHat Enterprise Linux. We had a pretty hard time installing it as it turns out almost none of the hardware that we commonly use is supported (SATA, IDE RAID, etc.). That's our fault for not investigating it first. However, we were using commodity hardware so we really didn't expect there to be an issue. Getting all the relevant services up and running (the SUNWAS, FTP, etc.) was a nightmare, mostly because of obscure configuration settings. Sites like the VSFTPD seem less concerned with documentation and examples and more concerned with attacking the security history of other FTP daemons. We had always been used to searching the news groups and the Web for solutions to our problems. We rarely have to resort to calling tech support. However, Web searches generally produced nothing but MAN pages, which are more like hints than actual manuals. They generally assume that you already know how to do something but need to be reminded of a switch. There also seems to be some unspoken rule that a MAN page should not include any mention of syntax or a working example. News group searches were down right frustrating. Attempts to figure out how to set up the SUNWAS as a service on RedHat produced one argument after the next. Most were flame wars between RedHat and Debian users (ostensibly), arguing over which distribution's utility for managing services is better. In the end, RedHat Linux was pretty much installed via trial and error. I was able to set up SUNWAS as a service by copying other service scripts and changing them until I found a magic combination that seemed to work. Most of my Linux experience was that way. I found very little help on the Web or in the news groups. We spent much more time on the phone with RedHat than any other vendor. I'm sure there are good resources out there. I'm also sure that, after spending years working in a largely Windows world, I'll need to learn the vocabulary of a new operating system. After all, it's difficult to search for a solution if you're using the wrong words to describe your problem. Nevertheless, this first attempt was a pretty disappointing experience. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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: OO Design
A native data type like a ColdFusion structure or array will be much faster than a component. Additionally, in writing your own component, you will introduce complexity and, as a result, more opportunity for bugs. So, in general, I'd say use a native data type unless you specifically need a feature that the native data type doesn't support. For instance, if you needed to reference objects using a key, but the order is also important, you might want to create your own data type as ColdFusion structures return keys unordered. However, if you did that, you'd be limiting yourself to the methods and properties you write yourself. In other words, you can't just run all of the built in structure and array functions on your component (though you could potentially use them from within your component). Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 9:28 AM To: CF-Talk Subject: SOT: OO Design Hi Folks, I'm trying to get my head around OO design for CF and I have a ton of questions, of course. I'll try to keep them limited, as they're sort of off-topic (though not entirely, because whatever I have to design I have to build in CF). Here's my first basic question: When you're designing an object that includes a multiple has-a type relationship, do you typically build the objects such that their is an intermediate collection type object? For example, I'm working on a project management system. It involves tasks. Tasks can have 0 to many consumables associated with them. Do I have one object Task and one object Consumable with the consumable object having both a getOne(consumableID) and a getAll(taskID) method? Or, do I have an intermediate ConsumableList object that takes a taskID and gets all the consumables associated with that task by calling a method in the Consumable object. Does that make sense? Thanks. -Deanna - Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: VB Functions -- Coldfusion?
Left() = Left() Mid() = Mid() IsNumeric() = IsNumeric() Note that the IsNumeric() function is quite different between the two languages. VBScript only cares if the value contains characters which can appear in a number, including scientific notation. ColdFusion seems to check to see whether or not the string can be cast as a number. In my opinion, the ColdFusion function is much more useful as VBScript will consider ($4,e,,,d,.2.3) to be a numeric value. I've never run into a situation where ColdFusion returned true from IsNumeric() but then failed to use the value as a number. CInt() = Val() CStr() = toString() ToString() isn't exactly the same as I understand it. CStr() is used in VBScript to convert simple values to a string. ColdFusion does this automatically. Though VBScript supposedly does this as well, it seems to be less reliable (possibly because of default properties on objects and such), hence the need for CStr(). On the other hand, the ToString() function in ColdFusion is generally used to convert complex objects (e.g. XML structures) to strings and control encoding. IsUpper() = not sure about this one off hand Someone has already posted a UDF for this so I won't elaborate. I'll just note that all ColdFusion comparisons are text insensitive by default. In the case of functions, it's usually the case that the function has an equivalent NoCase function for case insensitive operations. For example: InStr() = Find() or FindNoCase() Left() = Left() Another thing to watch out for is one based indexes. VBScript sometimes uses 0 based indexes (arrays), sometimes one based (strings). ColdFusion pretty much exclusively uses one based indexes. Instead of checking for -1, you'll need to check for 0 just about everywhere. And, when manipulating strings, don't overlook the list functions in ColdFusion. Another important note is that, though ColdFusion doesn't have an option explicit, its behavior isn't exactly like VBScript without the option explicit. In other words, VBScript sans-option-explicit will allow you to use a variable that hasn't been dimensioned _or_ set. ColdFusion does not require you to dimension a variable, but it does require you to set it to something before trying to use it. I used to program almost exclusively in ColdFusion. Now, one job has me programming almost exclusively in ASP. I use VBScript because of it's support for classes. The built in property getters and setters are really nice. VBScript classes tend to have a lot less overhead than ColdFusion components so I can use them in places where I wouldn't use ColdFusion components. That said, I generally find that ColdFusion is less idiosyncratic (is it a 0 or 1 based index this time?), more predictable (i.e. in its conversion between datatypes), and just generally easier to use. When something does go wrong, error messages tend to be a bit more informative, and, when in doubt, CFDump it to see what you've got. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Well, performance is relative. However, it is a solution which overcomes
a lack of native support for an IP data type and addresses Dave's
requirement that everything must happen in the query itself.
As I said, this bit of code was excerpted and adapted from a DNSBL we
run. We found that this chunk of code, when executing it against 150,000
records, was too slow to be used in real time DNS requests. The DNS
requests would take about 5 seconds, which meant that our SMTP banner
would take just as long to appear. There is actually a good deal more
going on, but that's the gist of it.
Our solution was to convert the query to a view. A scheduled task runs
every 15 minutes and populates a table from the view. Now, DNS requests
take milliseconds and the SMTP banner appears almost immediately.
So, for us, performance was an issue, but we did not have similar
requirements to Dave.
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 4:35 AM
To: CF-Talk
Subject: Re: Sorting IP Addresses
That sounds like it could perform poorly, would it?
- Calvin
- Original Message -
From: Benjamin S. Rogers
To: CF-Talk
Sent: Thursday, October 16, 2003 4:38 PM
Subject: RE: Sorting IP Addresses
that doesn't work perfectly.
166.141.22.4
166.141.22.40
166.141.22.41
166.141.22.47
166.141.22.48
166.141.22.5
Sorry about that. I forgot to convert the substrings to integers. Try
this:
SELECT *
FROM SourceIPSpamCount
ORDER BY
CONVERT(INT, SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, SUBSTRING(SourceIP, CHARINDEX('.', SourceIP) +
1,CHARINDEX('.', SourceIP, CHARINDEX('.', SourceIP) + 1) -
CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1, CHARINDEX('.', REVERSE(SourceIP),
CHARINDEX('.',
REVERSE(SourceIP)) + 1) - CHARINDEX('.', REVERSE(SourceIP)) - 1))),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), 1, CHARINDEX('.',
REVERSE(SourceIP)) - 1)))
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Sorting IP Addresses
Sorry about that. I was busy yesterday, but I saw a question that I thought I could provide one possible answer too so I rattle it off a couple of e-mails without looking back at the thread. And I didn't take offense to Jochem's quip: my apologies to Jochem if it seemed that way. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 4:45 PM To: CF-Talk Subject: RE: Sorting IP Addresses not for me :) im not the one lookin, it was , david delbridge. and don't mind jochem, I think that's just his brand of humor. although not very funny sometimes, its just jochem, and we deal. he is a db wizard. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 4:33 PM To: CF-Talk Subject: RE: Sorting IP Addresses Sure. I would use: SELECT* FROM SourceIPSpamCount ORDER BYSourceIP But I don't use MS SQL Server ;-) I'm afraid that comment was lost on me? If you could give me a bit more information, perhaps I could come up with an equivalent in SQL Server for Tony. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Somebody wrote IP, network and MAC data types for PostgreSQL, And how far along are they in porting that to Windows? :) including support for the big seven operators. So I could just use the IP datatype for SourceIP and everything would work automagically: That's pretty handy. Out of curiosity, does it also include functions for selecting individual octets? If not, how about user defined functions? That would make it useful for what we're doing. Since it is my understanding that you can't write your own operators in MS SQL Server, I doubt this is going to fly. I don't know of a SQL Server equivalent functionality wise. Perhaps Yukon with C# will address this, though a multi-thousand dollar upgrade for an IP datatype would just be silly. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Stripped this out of a DNSBL we run (the DNSBL actually reverses the
order of octets in an IP address). This code should work, though I
imagine there's a prettier way to do it.
SELECT *
FROM SourceIPSpamCount
ORDER BY
SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1),
SUBSTRING(SourceIP, CHARINDEX('.', SourceIP) + 1,CHARINDEX('.',
SourceIP, CHARINDEX('.', SourceIP) + 1) - CHARINDEX('.', SourceIP) - 1),
REVERSE(SUBSTRING(REVERSE(SourceIP), CHARINDEX('.', REVERSE(SourceIP))
+ 1, CHARINDEX('.', REVERSE(SourceIP), CHARINDEX('.', REVERSE(SourceIP))
+ 1) - CHARINDEX('.', REVERSE(SourceIP)) - 1)),
REVERSE(SUBSTRING(REVERSE(SourceIP), 1, CHARINDEX('.',
REVERSE(SourceIP)) - 1))
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
-Original Message-
From: David Delbridge [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:06 PM
To: CF-Talk
Subject: Sorting IP Addresses
Hi all,
I have some lengthy tables filled with IP addresses.Given that the IP
addresses are contained in a single text field (and not four individual
octet fields), what would be the SIMPLEST way to sort those IPs in a SQL
query?
For example, 'SELECT IP FROM IP_TABLE ORDER BY IP' produces the
following sort order:
123.123.123.10
123.123.123.11
123.123.123.2
123.123.123.20
123.123.123.21
123.123.123.3
But, of course, the desired results would instead be:
123.123.123.2
123.123.123.3
123.123.123.10
123.123.123.11
123.123.123.20
123.123.123.21
Any help is greatly appreciated.
Dave
--
David M. Delbridge
Circa 3000
ColdFusion Hosting
http://www.circa3k.com
775-832-2445
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Sorting IP Addresses
Sure. I would use: SELECT* FROM SourceIPSpamCount ORDER BYSourceIP But I don't use MS SQL Server ;-) I'm afraid that comment was lost on me? If you could give me a bit more information, perhaps I could come up with an equivalent in SQL Server for Tony. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
that doesn't work perfectly.
166.141.22.4
166.141.22.40
166.141.22.41
166.141.22.47
166.141.22.48
166.141.22.5
Sorry about that. I forgot to convert the substrings to integers. Try
this:
SELECT *
FROM SourceIPSpamCount
ORDER BY
CONVERT(INT, SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, SUBSTRING(SourceIP, CHARINDEX('.', SourceIP) +
1,CHARINDEX('.', SourceIP, CHARINDEX('.', SourceIP) + 1) -
CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1, CHARINDEX('.', REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1) - CHARINDEX('.', REVERSE(SourceIP)) - 1))),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), 1, CHARINDEX('.',
REVERSE(SourceIP)) - 1)))
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFDump stopped working (along w/ cftrace)
There are some issues with both the HTML and the style sheets used with CFDump (don't know about CFTrace but I assume it's the same story). In short, they are incompatible with several different DTDs. You can experiment with different DTDs or, as I do, just remove the DTD declaration from the DOCTYPE tag, which will place many modern browsers (Internet Explorer, Mozilla) in compatibility or quirky mode. Of course, the rendering of the rest of your page may change, so you may want to make the inclusion of the DTD dependent on a debug parameter. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:21 AM To: CF-Talk Subject: CFDump stopped working (along w/ cftrace) All of a sudden cfdump stopped displaying formatting for me, anybody else having this problem? Basically the text is all still there, but I lost my precious tables and color-coding like so: cfdumpinited TRUE somestruct struct YOMAMMY blah blah YOPAPPY [empty string] YOSISTERTOO [empty string] I've checked on multiple machines/browsers, and it's the same.I also checked the dump tag in the CF tags directory, and it's still encoded, which hopefully means it's not corrupted. And I can't live/code without my borders and color-coded arrays, and structures, and objects, and cookies, and... Tyler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC-based GPL web HTML editor
Win IE5.5 required = unusable. ... by about 5% users... Even less, last time I looked. And then divide that by all of the various browsers used on the Mac (Safari, several different Gecko based browsers, Internet Explorer, Opera, etc.). To further complicate things, we can't just install a Mac OS onto an old x86 box for testing purposes (or, even better, use Virtual PC). Instead, we would have to invest a substantial amount of money into a machine we have no intention of using for anything else. In the end, we try to design our sites to be as standards compliant as possible, try to make them degrade as gracefully as possible in older browsers (Netscape 4, Internet Explorer 4, etc.), and hope for the best everywhere else. Of course, the first two are often mutually exclusive. In which case, standards be damned, we're going to make our customers' sites look as good as possible in as many browsers as we reasonably can. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CFC-based GPL web HTML editor
There are Mac emulators. There is also a web site (which I can't recall the name of atm) that will take a screenshot of your app using a variety of O/S and browsers, and email them all back to you. Yes, NetMechanic does this. However, these are costs we'd have to pass off to the customer (both the third party fees and our time). In reality, most customers only care that the site looks good on their computer. We try to ensure that the site looks good on the vast majority of the computers on the Internet. We try and design the site so as not to preclude other browser/OS combinations. However, most customers do not care to pay us to test on the others. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFC-based GPL web HTML editor
You can get an old iMac on Ebay for less than $200: Again, which combinations of OS and browsers will that iMac support? As you said, if we spend more, we can get an OS X box. However, we would have to buy both to get the majority of the combinations. Or, perhaps we could buy an OS X box, Virtual PC for the Mac and all the various OS licenses. That's still much more than $200, and I'd have to shove yet another box under my desk or make room for it on one of the racks -- but of course they don't rack mount. And, to be honest, we simply don't have anyone on staff familiar with either OS X or legacy Mac OSes. I wouldn't even know how to put the thing on the network. I'm sure I could figure it out, but designing Web sites which are compatible for the Mac is simply not a priority. It's not something our customers are willing to pay us for. So, we do what we do and hope for the best. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFC-based GPL web HTML editor
So are you saying that 35-74 million users aren't worth your time? There are plenty of Javascript and Flash based WYSIWYGs. Even if you're numbers had some basis in reality, that's not what I'm saying. I'm saying that our customers are not willing to pay us to develop specifically for Macintosh browsers. It's a simple business decision. Our average proposal is about 15 pages long, and it explains browser support in depth about half way through. So far, no one has opted to pay us more to ensure compatibility on the Mac. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFC-based GPL web HTML editor
It shouldn't take any of your development time to see that making use of something that only works with a specific version of IE on Windows isn't going to work for everyone. Just spend your time working on stuff that is known to work for everyone. I don't think anyone is saying that they would purposefully break a site or use code that they new didn't work in one of various browser on the Mac. Of course, we try to avoid that where ever possible. However, every browser/OS combination has its own set of bugs and idiosyncrasies. For instance, it's my understanding that Internet Explorer on the Mac renders text at 96 dpi instead of the system 72 dpi. So, though I might use nothing but the paragraph tag, I can't possibly foresee what the site will look like. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CFC-based GPL web HTML editor
I don't charge extra because I consider it part of my job. Well, all other things being equal, my base price is going to be lower than yours. I assure you, my customers are more concerned about price than whether or not the site functions properly in one of several different browsers on one of a couple different Operating Systems on the Mac. I consider addressing my customers' concerns my entire job. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFC-based GPL web HTML editor
I have given it a look and I believe that using a Java front-end through either an Applet or Java Web Start is the only way to create a good cross-platform HTML editor. Therefore, nothing in your project is useful in that regard. I would think a better approach would be to use the tools native to each browser and provide a standard ColdFusion interface: http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/msht ml/mshtml_editing_node_entry.asp http://www.mozilla.org/catalog/libraries/editor/ That way, instead of rolling your own very limited, non-native Java editor, you could provide a feature rich, seamless experience for each browser. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CFC-based GPL web HTML editor
First, if you wrap your editor around native functionality then the capabilities and behavior of the editor will vary by platform, which is certainly no good. Why? It seems like most of the editors already support a very common set of features. Most users are not going to be impressed that a Java editor functions the same way on all platforms. I'm sure a Mac user would prefer the editor to function like a native application/widget. I know part of the reason I dislike Macromedia applications is that they do not feel or function like Windows applications. I pretty sure I'm note alone on this. Second, why would a Java solution be limited in any way as compared to a native solution? Because, instead of writing a relatively simple interface for each different platform, you'd have to write, test, debug, etc. all the functionality yourself. Unless I'm completely off base, I think it would take much more time to write a feature rich, cross platform HTML editor. I'd much rather just leverage the work done by other individuals. I don't have any desire to reinvent the wheel. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CFC-based GPL web HTML editor
Actually, no. Mac IE stopped at 5.2.3 - it did not reach 5.5. The version numbers are not comparable cross-platform. Just as an example, Internet Explorer 6 for the PC uses the Mac Internet Explorer rendering engine. This, of course, does not mean that Mac Internet Explorer 5.x is equivalent to the PC Internet Explorer version 6.x (which did come out later). However, they are a much closer pedigree than the 5.x versions as far as HTML rendering goes. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: (Admin) List upgrades
Most(*) mail clients auto-hyperlink things that look like http://blah.blah.blah - you don't need HTML for that. Yes, but most e-mail clients also have a problem with long URLs. HTML e-mail would solve that problem. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: (Admin) List upgrades
Can anyone direct me to an email list that uses HTML over text? Actually, I just checked, and just about every other mailing list I belong to allows HTML formatting. This includes our mail server vendor, several SQL Server mailing lists, and even Netcraft. The only exception is a SourceForge mailing list. This is not to say that everyone on those lists uses HTML formatting. Most people don't. However, many do, and for the most part is unobtrusive. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: (Admin) List upgrades
I don't know about you but That seems like an aweful lot of work just to emphasize a word, not to mention wasting a line. I suppose you don't see any *emphasis* in this line either then? If not, try a real email client. Jochem, I didn't get the point you were making. Most HTML generated by email clients is invalid. Most of it uses inappropriate methods. Sending email with font=-3 just because that looks nice on your system makes it illegible on my system. Well, Jochem, if text is illegible on your system at that size, then hold down control and scroll up. If that doesn't work, then get yourself a real Web browser. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: (Admin) List upgrades
Yes, but most e-mail clients also have a problem with long URLs. HTML e-mail would solve that problem. What stops you from using an email client that does not have that problem? Well, seeing as how I've written e-mail clients, I can't possibly imagine one that doesn't. Most mail clients which send mail break the line at around line 80. Outlook 2002 tries to sense these breaks and remove them, but it isn't very good at it. If you can suggest an e-mail client that guesses correctly every time, I'd be impressed. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: (Admin) List upgrades
Well, Jochem, if text is illegible on your system at that size, then hold down control and scroll up. Control + actually. I was speaking of the of the mouse wheel on a Windows system in Internet Explorer, the normal behavior or which is scrolling. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: (Admin) List upgrades
Not to mention http://blahblah.com/myblahpage.cfm takes a lot more visible space than _my link_ Which is nice, it allows people to see where they are going. I agree. Unfortunately, when Outlook displays an HTML e-mail it doesn't honor the Internet Explorer status bar. So, I can't tell what I'm about to click. Nevertheless, this would seem to be a client specific issue, not necessarily a problem with HTML formatted e-mail altogether. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: (Admin) List upgrades
I tested Outlook for 1 day and I discovered the following problems: charset problems (not specified in the headers) attachment problems (fictional attachments appear when using begin ) IMAP problems (no server config autodetection) NNTP problems (timeout on connections too short) Sounds like you tested Outlook Express (because Outlook does not have an news reader)? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: (Admin) List upgrades
Outlook 2002 tries to sense these breaks and remove them, but it isn't very good at it. If you can suggest an e-mail client that guesses correctly every time, I'd be impressed. What is there to guess? There either are spaces or not. Most e-mail clients break at around 80 characters regardless of whether or not there is a space. Surely you've seen messages where a long (80+) URL was broken two or more lines? I whole heartedly agree that they shouldn't, but that's the way it is (I believe mostly because of legacy UNIX clients that don't wrap). Outlook tries to sense an artificial break and remove it before rendering the message. However, it guesses incorrectly almost as often as it guesses correctly. Which e-mail client do you use, and how does it handle such lines? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Debugging ColdFusion (was: DWMX 2004 - Whats new for us?
But those versions were effectively interpreters, not compilers and the debugging mechanism was built into the interpreter. And it sounds like people complained that it never really worked very well? Yes, but we held out hope that things would get better, not worse. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF 6.1 upgrade causes sitewide 500 error!! Pain!
Same thing happened on my workstation yesterday. I had to uninstall everything and reinstall from scratch to get it working. That was, of course, before I read this thread. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Dustin Snell [Unisyn Software] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 1:20 AM To: CF-Talk Subject: Re: CF 6.1 upgrade causes sitewide 500 error!! Pain! Dear Mr./Mrs Cooper, Since you asked I would be happy to reiterate the problem. (sorry if this is a little long but I wanted you to have all the details clearly) STEP BY STEP: 1) I started the install and followed the instructions to shut down all Cold Fusion and IIS services (although the installer should do this for me IMHO). 2) Installer completes successfully. The installer did not tell me there was a problem -- everything went fine. It simply told me to go to the CF Admin page to finish the setup. I tried to go to the admin page via the recommended URL and I got an HTTP 500 error (Internal Server Error). Attempted to access other sites on my server - same error 500. Panic ensues. 3) Breathing heavily now, I looked at the services applet and noticed that the ODBC Services were not started. Tried to start them, they failed and stopped immediately (in other words, they could not be started). 4) To re-iterate **I cannot access the next step of the install (which is to access the admin page) because every site on the whole server (including admin) is getting a 500 error**. 5) Attempted reboot. Still get the 500 error on every site. Cursing fits begin. 6) Check event log and see that there is a GPF occurring in a exe from a Cold fusion folder (I figure this is probably why the ODBC services won't start - which *MIGHT* be the reason all my sites are getting a 500 error)... the error in the event log is: Reporting queued error: faulting application swagent.exe, version 1.93.0.0, faulting module unknown, version 0.0.0.0, fault address 0x. At this point I call Macromedia - they tell me I will pay $500 to get some help with this. I say no. I write the awesome experts at houseoffusion list and within minutes am instructed to do a search for all INI files containing c:\Program Files\Merant and change it to c:\CfusionMX\db. I make this change, attempt to start the ODBC Services... magic! they start. I smile. Next step, I try to access my sites. Still get the 500 error. Reboot... still get the 500 error. I whimper. Another reply on houseoffusion advises me to retry running the IIS connector batch file. I do so and suddenly the world is right again. Everything works! MY BEST GUESS ON WHAT HAPPENED: During the install maybe the IIS Connector batch file failed for some reason but did not notify the installation of the failure. It may have failed because of this Marant path and when it was changed it could run again. Just a guess. ENVIRONMENT: Windows 2003 Server (latest updates applied) IIS6 Multiple sites on one server SQL Server 2000 SP3 installed on same server (yea yea I know) ASP.NET Enabled (not currently used however) Upgrading from Coldfusion MX 6.0 with latest updates applied. INSTALLER LOG SUMMARY: Install Begin: Tue Aug 05 15:52:46 PDT 2003 Install End: Tue Aug 05 15:57:06 PDT 2003 Created with Zero G's InstallAnywhere 5.0.7 Enterprise Build 1680 Summary --- Installation: Successful. 56 SUCCESSES 0 WARNINGS 0 NONFATAL ERRORS 0 FATAL ERRORS Coldfusion seems to be running fine for now. Speed seems faster which is great! I sincerely hope this helps. -Dustin Snell Unisyn Software, LLC - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 6:29 PM Subject: CF 6.1 upgrade causes sitewide 500 error!! Pain! Let me re-iterate what seems to have happened here: 1) The Installer encountered a problem of some kind. It should have then told you this and what to do next. This caused the error when you tried to get to the websites. 2) The Config Wizard needs to be run after the Installer successfully completes. It normally kicks this off automatically at the end and finishes ODBC service setup. It automatically makes the corrections Michael described to the INI files. However, you didn't get this far because of #1. For #1, the Installer shold have described what went wrong and told you what to do. There should also be a log file in your install directory. This prevented you from getting 2) Now if only Macromedia could stop hurting me with their upgrades :-) Dustin Snell Unisyn Software, LLC [EMAIL PROTECTED] - Original Message - From: Chris Kief [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 5:14 PM Subject: RE: CF 6.1 upgrade causes sitewide 500 error!! Pain! The migration wizard manages the installation of the ODBC services. There should be no need to change files like you're suggesting
RE: How can I ORDER BY RANDOM ?
This will generally order them according to the clustered index or the order in which they were added. Either way, it's not random. I would expect to see the same results every time. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 5:12 PM To: CF-Talk Subject: Re: How can I ORDER BY RANDOM ? Remove the CompanyName field from the ORDER BY clause. Then the results will be ordered by ClassOfService onlyunless I'm missing your point ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tom Forbes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 2:05 PM Subject: How can I ORDER BY RANDOM ? Dear CF'ers: I have searched my CF books for a clue, but am unable to find an example of what I am trying to do. I need to modify the below query so that my results are still ordered by ClassOfService (a number between 1 and 4) - BUT, the CompanyName needs to be displayed in a RANDOM ORDER each time the query is run, rather than its current alphabetical order. This will give all companies that participate an even advantage of being selected rather than those that begin with the first letters of the alphabet. Can someone please point me in the right direction? I have studied the CF RANDOM tag but can't figure out how to apply it. CFQUERY NAME=GetAllCompaniesWithMiniSites DATASOURCE=MedMallDs DBTYPE=ODBC SELECT * FROM CompanyTbl WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes' ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName /CFQUERY Thanks very much!! Tom Forbes *** Tom Forbes, Forbes Consulting, Inc. TEL: 407-772-3427 FAX: 407-772-3428 Visit www.medmatrix.com for Medical Equipment Web Sites! E-Mail Subscription at www.medmatrix.com/mail_list.htm *** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I ORDER BY RANDOM ?
A quick search produced this list of articles: http://www.sqlteam.com/FilterTopics.asp?TopicID=135 Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tom Forbes [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 5:06 PM To: CF-Talk Subject: How can I ORDER BY RANDOM ? Dear CF'ers: I have searched my CF books for a clue, but am unable to find an example of what I am trying to do. I need to modify the below query so that my results are still ordered by ClassOfService (a number between 1 and 4) - BUT, the CompanyName needs to be displayed in a RANDOM ORDER each time the query is run, rather than its current alphabetical order. This will give all companies that participate an even advantage of being selected rather than those that begin with the first letters of the alphabet. Can someone please point me in the right direction? I have studied the CF RANDOM tag but can't figure out how to apply it. CFQUERY NAME=GetAllCompaniesWithMiniSites DATASOURCE=MedMallDs DBTYPE=ODBC SELECT * FROM CompanyTbl WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes' ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName /CFQUERY Thanks very much!! Tom Forbes *** Tom Forbes, Forbes Consulting, Inc. TEL: 407-772-3427 FAX: 407-772-3428 Visit www.medmatrix.com for Medical Equipment Web Sites! E-Mail Subscription at www.medmatrix.com/mail_list.htm *** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCs - any way to reload other than cycle CF service?
Depends. If you are talking about using CFCs as Web services, then you have to manually refresh these, though you don't have to do it by cycling the service. Use the following function: cffunction name=refreshWebService hint=Forces ColdFusion to refresh all Web services. access=public returnType=void output=no cfargument name=webService default= type=string hint=Name of the web service you'd like to refresh. If left blank, the function refreshes all Web services. cfset var factory = createObject(java, coldfusion.server.ServiceFactory) cfset var xmlRpc = factory.getXMLRPCService() cfset var webServices = xmlRpc.mappings cfset var mapping = cfif isEmpty(arguments.webService) cfloop collection=#webServices# item=mapping cfset xmlRpc.refreshWebService(mapping) /cfloop cfelse cfset xmlRpc.refreshWebService(arguments.webService) /cfif /cffunction If, however, you are calling CFCs locally, then ColdFusion /should/ refresh these automatically. The exception, of course, is if you have turned on the Trusted Cache option in the administrator. That said, I've run into quite a few problems with ColdFusion MX and caching (not as in CFCACHE, but refusing to generate new class files for updated templates). Unfortunately, I haven't been able to track down the source of the problem. Nevertheless, every time it happens, I have to delete the appropriate class files and cycle the service. Anyway, the problems I've run into are not consistent, which makes me think you are referring to the fact that ColdFusion MX does not automatically refresh Web services. Either that, or you have Trusted Cache turned on. But if you turned that on, you'd probably know it, and wouldn't be posting to the mailing list. :) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED] Sent: Sunday, March 09, 2003 1:39 PM To: CF-Talk Subject: CFCs - any way to reload other than cycle CF service? It's really bugging me to have to restart CFMX every time I make a trivial little change to the component I'm developing. Is there another way to get the server to recognize the changes I've made to the CFC? Willy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New MM.com
One thing I noticed is that about 90 KB of the initial load is XML/CSS/JS/HTML. I bet that if HTTP compression were enabled for the larger files the bandwidth use for the initial load would drop below quite a bit. I've always avoided HTML compression because of bugs in various browsers (such as IE handing the compressed data off to plugins such as Flash instead of the uncompressed data). Is this no longer the case? Are people using HTML compression in production environments successfully? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Apache on Win2k - WAS: win 2000 professional for web server?
I use serv-U for my FTP accounts. In IIS it seems to require a unique port number for each FTP account Umm, only if you configure it that way. :) If each FTP site has it's own IP address there is no reason that they can't all use the same port. Even if you run all your FTP sites on the same IP address, all you have to do is create virtual directories with the same name as the user name and IIS will automatically throw the user into the appropriate directory. Perhaps I misunderstood you? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFILE and carriage returns
It will also cover you one most things Internet related. Most RFCs that I've seen, especially those dealing with mail, require cr/lf value pairs. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 12:35 PM To: CF-Talk Subject: RE: CFFILE and carriage returns Mac OS9 and less uses #chr(13)# Mac OSX, Unix and Linux use #chr(10)# Windows uses #chr(13)##chr(10)# Using the windows line ending will absolutely cover all the bases, but I've yet to run into a program (excepting notepad) that doesn't understand line breaks from other systems. barneyb -Original Message- From: David Collie (itndac) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:24 AM To: CF-Talk Subject: RE: CFFILE and carriage returns I always use 'Chr(13) Chr(10)' (believing that covers me for Mac and Windows) is that correct? If not what should you use? -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 17:11 To: CF-Talk Subject: RE: CFFILE and carriage returns use chr(13) in orderInfo for a new line. w -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 17:01 To: CF-Talk Subject: CFFILE and carriage returns I am trying to write files using CFFILE and I would like to have carriage returns in the file to make it look something like below: Workshop Registration Information startDate: blah endDate: blah workshopID: blah title: blah ... Right now, I am creating a variable called orderInfo and writing that to the file. The problem is that my file ends up with everything on one long line and looks something like below: Workshop Registration Information startDate: blah endDate: blah workshopID: blah title: blah ... Anyone know how to solve this? Any suggestions would be really appreciated. --Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web Disservices
I feel compelled to note, however, that EJSE's Web service is not very reliable. We integrated it into our homepage some time ago, and I personally monitor the ColdFusion error logs so I get to see how often it generates errors. Actually, having said that, the service has only failed twice out of 20 attempts today. It's a banner day! Anyway, we call the service hourly, caching results, storing them both in WDDX on the drive and in the application scope. When the application is loaded (the ColdFusion service is restarted, the Web server is booted, etc.), the application loads the data from the WDDX file back into the application scope. All requests pull the data from the application scope. Using this method, the uptime of the weather service doesn't have to be great: it just needs to be up more than it's down. I've learned to set my expectations low when dealing with Web services, especially the free ones. :) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 5:58 PM To: CF-Talk Subject: Re: Web Disservices On Sunday, Feb 9, 2003, at 20:54 US/Pacific, danielEthan wrote: The web services I'm trying to consume are all weather related: cfinvoke webservice = http://www.ejse.com/WeatherService/Service.asmx?wsdl; method = GetWeatherInfo zipCode = 65641 returnvariable = Weather Works just fine: Weather for location: Castro Valley, CA Temp: 64°F Feels like: Forecast: Fair Visibility: Unlimited Pressure: 30.00 inches and falling DewPoint: 32°F UVIndex: 3 Low Humidity: 30% Wind: From the East at 12 mph Reported at: Hayward, CA Last updated: Monday, February 10, 2003, at 1:54 PM Pacific Standard Time (Monday, 4:54 PM EST). Here's my code: cfinvoke webservice = http://www.ejse.com/WeatherService/Service.asmx?wsdl; method = GetWeatherInfo zipCode = 94546 returnvariable = Weather Weather for location: #Weather.getLocation()#br Temp: #Weather.getTemprature()# Feels like: #Weather.getFeelsLike()#br Forecast: #Weather.getForecast()# Visibility: #Weather.getVisibility()#br Pressure: #Weather.getPressure()# DewPoint: #Weather.getDewPoint()#br UVIndex: #Weather.getUVIndex()# Humidity: #Weather.getHumidity()#br Wind: #Weather.getWind()#br Reported at: #Weather.getReportedAt()# Last updated: #Weather.getLastUpdated()#br Note that you get back a Java object and have to call methods on it to extract the data. You can find this out - as I did - by calling cfdump on the returned variable. It's a bit cold in Eagle Rock, isn't it? 43F? Brr... Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim/iChat: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.macromedia.com/go/arch_blog ColdFusion MX and JRun 4 now available for Mac OS X! http://www.macromedia.com/go/cfmxosx ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why are my clients having so many login problems all of a sudden?
Now they can log in and see the site management options, but when they click on a link to go that area, the system kicks them back to the login page. Sounds like the Internet Explorer 6 cookie bug. Its been such a common occurrence for us over the past year we actually published a page on our site that we could just direct people to when they report the problem: http://www.c4.net/Index.cfm?Method=Support.FAQ.IE6Privacy In short, Internet Explorer inexplicably stops accepting cookies for certain sites now and again. Users who d log into a site daily without problems for a year will all the sudden experience the problems you've described. The only foolproof work around we've found is to have user add our site to their list of trusted sites, which apparently bypasses whatever causes the problem. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
File Not Found Error
Hello, We're testing ColdFusion MX and it seems it performs a bit differently than earlier versions of ColdFusion in regards to non-existent files. Specifically, in earlier versions of ColdFusion, if we unchecked the Check that file exists option in the IIS application extension mapping for .cfm pages, then we could trap requests for non-existent .cfm pages in the Application.cfm. This no longer seems to be the case with ColdFusion MX. ColdFusion MX throws a generic File not found error when requesting non-existent files. In other words, ColdFusion MX doesn't run the Application.cfm before throwing the error as prior versions of ColdFusion do. I've tried editing the web.xml file and adding the following servlet mapping: servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*/url-pattern /servlet-mapping That seems to work for those folks using search engine safe URLs, but it didn't work in our case. We even went so far as to boot the server and delete all the class files after making the change. Nada. Anyway, if we're missing something, or anybody has any ideas, we'd appreciate it. We've poured over the configuration files, news groups and forums, and every bit of documentation we can find and haven't come across anything. Thanks. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Log Viewer
I believe one of the ColdFusion MX updaters makes it available again: http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote s_mx_updater.html ID: 46600 The Log Viewer was not available in the ColdFusion MX Administrator in Professional Edition. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 11:00 AM To: CF-Talk Subject: CFMX Log Viewer Has anyone written a appliation.log viewer for MX and would be willing to share? Other wise I will have to write one. Those of us with Professional don't get it built in any more. Thanks, Justin Hansen -- Uhlig Communications Systems Engineer -- [EMAIL PROTECTED] 913-754-4273 Office 816-695-4045 Mobile -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Protecting scope of cffunction variables
Use the var keyword when declaring your variables. Unfortunately, you have to place all of your var declarations at the top of the function, after the cfargument tags but before any other CFML. !--- this function is included via cfinclude from another page --- cffunction name=add_two_numbers cfargument name=first required=true cfargument name=second required=true cfset var sum=arguments.first + arguments.second cfreturn sum /cffunction Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Jon Gunnip [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 9:57 AM To: CF-Talk Subject: Protecting scope of cffunction variables Hello, I am writing UDF's on MX using cffunction, and I would like to know what the best way to create local variables for use inside my functions that will not interfere with variables in the caller's scope. Right now, I have to make sure that my variable names are unique inside and outside function definitions. This is quite burdensome, making it difficult to easily name variables inside of functions to ensure I am not overwriting variables in the callers scope. It is also difficult for people to use my functions, since beside knowing my function name, its arguments, and what it returns, they must also know what variables I am using for internal function processing to ensure that their variables are not overwritten. Here is a basic example: !--- page function.cfm --- !--- this function is included via cfinclude from another page --- cffunction name=add_two_numbers cfargument name=first required=true cfargument name=second required=true cfset sum=arguments.first + arguments.second cfreturn sum /cffunction !--- page that uses the function --- cfinclude template=functions.cfm !--- using sum to track addition of numbers --- cfset sum=12 !--- sum is now 12 --- cfset result=add_two_numbers(1, 2) !--- sum is now 3 (changed in function), when I want it to be 12 --- cfset sum=sum + result !--- sum is now 6, when I want it to be 15 --- I looked in the MM documentation, but I could not find an appropriate answer to this question. Thanks! Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multihomed Hosts and ColdFusion MX
How about just relying on the default / mapping to c:\inetpub\wwwroot\ . Then you just refer to each site as /mysite/ where mysite is the folder name. It's effectively the same as setting up a mapping as far as I can see. That's what we do anyway. You're saying that we should point the / logical mapping to the root directory of all the virtual servers? I don't think that will work because we use domain names for directory names. Assume we have all our sites in a directory c:\websites and the logical mapping points to that directory. Beneath that directory we have the a directory domain.com which is a virtually hosted domain name. The customer would use something like this to invoke a component: domain.com.packageDirectory.component Unless I'm missing something, ColdFusion is going to replace the . with \, append a .cfc, and prepend the mapping path to arrive at the following string: c:\websites\domain\com\packageDirecotry\component.cfc The path is really: c:\websites\domain.com\packageDirecotry\component.cfc Besides, using domain.com is counter to the standard Java practice of using com.domain. We can rename all of the customer directories, if that's what it takes, but I was hoping that there was a real solution to this problem, something simple that I was overlooking, or a bug fix in the works, because there certainly does seem to be a problem here. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multihomed Hosts and ColdFusion MX
I'm currently testing ColdFusion MX for possible deployment in a Windows 2000/IIS shared hosting environment. I've followed the instructions in the release notes as well as those found in the following tech notes: ColdFusion MX: ColdFusion Server (on multihomed servers) displays wrong page: http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179Method=Full ColdFusion MX: Recommended configuration of multihomed Microsoft IIS web servers http://www.macromedia.com/v1/Handlers/index.cfm?ID=23390Method=Full Following the advice on the following page, I created logical mappings to each of the test domains on the server: http://blog.web-rat.com/archives/05.html#05 As a result, most things seem to be working fine. With the logical mapping, I can properly reference CFCs as components. However, when attempting to invoke those same CFCs as Web services, I get AxisFault errors: Could not find the template domainMapping.packageDirectory.componentName. The actual error message goes on for pages, so I have left that out. At first, I was a little confused as to why ColdFusion was trying to invoke the Web service using the logical mapping. This post in the news groups seems to explain this: http://groups.google.com/groups?selm=asl4gi%24p3k%241%40forums.macromedi a.com This also explains why the behavior is different when invoking methods by typing them into the query string of the browser (which works) and invoking them with the cfinvoke tag, cfobject tag or createObject() function (none of which work). However, ColdFusion is able to generate a WSDL file. Regardless, none of this explains why I'm getting the error. The only way I can eliminate the error is to delete the individual domain mappings and change the logical mapping / so that it points at one of the Web site's root directories. That site then works properly. However, for obvious reasons, that only works for a single domain. Any help, clarifications, or suggestions would be greatly appreciated. We have customers asking for ColdFusion MX, but until I can get everything working properly, I don't feel comfortable deploying it. Thanks. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: BlueDragon J2EE on OSX - Working !!!
I've read each of your posts several times and I still can't fathom what you're trying to say. You seem to be arguing that by being less expensive, New Atlanta opens themselves up to a greater degree of piracy? This seems to fly in the face of common sense, so either my interpretation is incorrect or I just don't understand your logic. As for your tone, well, I would expect better from a Macromedia employee. Statements like it's a pretty simple question just sound demeaning. You referred to his post, which was completely in context to the thread, as an ad. Even if it is an ad, and I don't believe so, might you have taken the higher road instead of taking a pot shot at a competitor? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: John Dowdell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 4:52 PM To: CF-Talk Subject: Re: BlueDragon J2EE on OSX - Working !!! At 10:41 AM 1/9/3, [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: At 3:48 PM 1/8/3, John Dowdell wrote: At 6:39 PM 1/7/3, Vince Bonfanti wrote: JRun 4 + CFMX = $900/CPU + $3400/CPU = $4300/CPU Tomcat + BlueDragon = Free + $1000/server = $1000/server Hmm... how do you respond to people who point out that they can get if for free on a warez site...? I've read this several times, and I'm still trying to understand your point. It's a pretty simple question. I'll rephrase it. If you reduce your equation to initial cost, such as with that ad you posted there, then how do you logically deal with people who find ways to reduce your prices still further? Do you use that it's illegal line, the might-makes-right argument Rob mentioned? Or might you point out how it's valuable to compensate the people who actually create a technology, how this is an investment in future work? Or do you perhaps have some other way to deal with parasites like that...? jd John Dowdell, Macromedia Developer Support, San Francisco (Best to reply on-list, to avoid my mighty spam filters!) Technotes: http://www.macromedia.com/support/search/ Column: http://www.macromedia.com/desdev/jd_forum/ Technical daily diary: http://jdmx.blogspot.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC - Var vs. This
The this scope is limited to CFCs and allows you to provide properties which can be read and updated by the calling page and by the CFC itself. Though you can use them at any time, they really come into play when the calling page uses the createObject() function to create an instance of your CFC (as opposed to executing a method with the cfinvoke tag). As such, the properties are specific to that instance of the CFC. Variables declared with the var statement, on the other hand, are limited not just to the function, but the specific function call. They are not accessible to, nor can they conflict with variables in the calling page. That way, your function can't overwrite variables in your calling page. Similarly, if the function calls itself recursively, you won't run into conflicts as long as you declare your variables with the var statement. In general, always use var unless you have a specific reason not to as you will end up with less odd or inexplicable behavior. I've always found it odd that scripting languages like ColdFusion and JavaScript don't make the default behavior the most restrictive. In my mind, you should have to go through extra work to expose a value (i.e. by using the caller scope in custom tags or the this scope in CFCs), not the other way around. I also find it odd that ColdFusion forces developers to place the var statements at the beginning of the function. Besides the fact that it seems decidedly un-ColdFusion-like to have such seemingly arbitrary restrictions, you end up with variables that are declared no where near where they actually get used. It just makes code harder to read by my way of thinking. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 4:41 PM To: CF-Talk Subject: RE: CFC - Var vs. This Right. But what's the difference outside of syntax. Would I want to use one over the other? Why would I want to use var over this inside a CF is this is much more flexible? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 4:14 PM To: CF-Talk Subject: RE: CFC - Var vs. This The two are very different. this is the public variable scope for a CFC instance. var is a keyword used to declare local function variables. this can be used anywhere inside a CFC. var can only be used immediately proceeding a function declaration or argument specification of a function declaration. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 4:07 PM To: CF-Talk Subject: CFC - Var vs. This Alright, So Christian says to declare all of your private CFC variables at the top of the function like so cfset var value = 1. Hal Helms recommends using cfset this.value = 1. Both obviously work, but I'm wondering what the pros and cons are if any. Off the top of my head, it would seem that 'this' is more functional, as it acts like any other scope and can be dumped. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: CFMX and Java
With sofware giants like IBM/Oracle/Sun/Bea pushing Java and J2EE...Just guess.. the open platform is going to win. Java as the open platform? Java is a platform supported by multiple vendors, yes, but I don't believe this qualifies it as open (despite what Sun's marketing department might say). C# and the CLI, on the other hand, have been ratified by the ECMA. Whether or not that's a good thing is up for debate, but I think it does exhibit a greater degree of openness. Have you read articles of Microsoft Windows.Net and what corporations think about their pricing..? I think you're mixing up workstation and productivity software licensing with server licensing. While quite a few are upset about the former, IBM/Oracle/Sun/Bea compete in the latter. If we're comparing Oracle's licensing to Microsoft's, well, I'll take Microsoft's any day of the week. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:21 AM To: CF-Talk Subject: Re: RE: CFMX and Java I am not quite as optimistic about the future of Java Interesting and funny!. I happen to do a little internet shopping around Christmas and New year. About 75% of the GOOD Clothing/accessories/home decor websites were JSP and am pretty sure they are in some fashion J2EE compliant.. and scaled very well inspite of all the traffic(especially ppl shopping for good prices and stuff) I hope you know that CFMX is just a J2EE Application deployed on JRun and quite interesting enough on IBM websphere. With sofware giants like IBM/Oracle/Sun/Bea pushing Java and J2EE...Just guess.. the open platform is going to win. Have you read articles of Microsoft Windows.Net and what corporations think about their pricing..? I really think Linux/Lindows/Open Platform and Java will take off and in this economy of corporate cutbacks.. corporations are actively looking for cheaper solutions/software. As for CFMX and Java... i think for heavy duty applications.. CFMX will be suitable for Presentation Tier and Java will be used for all the heavy duty middle tier processing.. btw (we are not talking about a comment form). Joe ---Original Message--- From: Cary Gordon [EMAIL PROTECTED] Sent: 01/03/03 12:12 PM To: CF-Talk [EMAIL PROTECTED] Subject: RE: Mr.Corfield: MX and beans I am not quite as optimistic about the future of Java as you are. It might be around, in the sense that the once and future coolest language in the world, APL, is still around... At 11:38 AM 1/3/2003 -0500, you wrote: Personally, I'd write everything in beans if given the opportunity. Not to knock CF or NEthing, but I like the idea of my code being server independent. You can use the same beans on your expensive CFMX box, or on a freeware J2ee, or any other java apps for that matter. It really is one of the best architectures for code reuse. (IMHO) Thinking of some of the archaic systems we have at our university, we would have saved hundreds of thousands on updating them, had we been able to use the exact same code. I can't say for certain if CF will be around in 25 years, but I feel pretty confident that java will. It's just kind of crazy to think that my code will last that long. As it's usually cycled out due to technology changes, not logic. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division Cary Gordon The Cherry Hill Company ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: ODBC Date Question
Just using IsDate() does not work very well. IsDate() will accept a lot of dates that ODBC won't (usually typos such as 3 of 5 digit years). I would also perform a range check in ColdFusion on any date submitted and return an appropriate error to the user. To give you an example, for every form field that accepts a date, I end up with at least 25 lines of validation code and exception handling. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 9:47 AM To: CF-Talk Subject: Re: ODBC Date Question How do you validate the input dates with isdate()? Never used it before... Julia Richard Meredith-Hardy [EMAIL PROTECTED] wrote:A few notes: - is 'File' a reserved word? - I have to say a a European I HATE date formats like mm/dd/ or dd/mm/ for the simple reason that there are too many ways to misunderstand them - when I ask people to put a date in a single field I ask them to use dd mmm which is completely unambiguous and is perfectly understood by createodbcdate() - are you sure the actual values of the dates in your new DB are what you think they are after the transformation? - validate the input dates before the query with isdate() Julia Green wrote: This I am sure is a beginning question...so one of you experts can help me... I have a client Gilway lighting, whose form, gilwaydb.cfm submits an ODBC date to an Access table whose dates I converted all to Date/Time(shot over to SQL Server) in the format mm/dd/, the table is called tblfile4d Now the problem, my client wants me to do a form where you put a Beginning and Ending Date, Beginning Date: Ending Date: Type the dates in the following format: 10/13/2001. Be sure to type a beginning and ending date. [input] and to find the files that go with these dates, but for instance, if I enter 5/6/01 or 5/6/2001 and 12/6/01, it returns the 02 dates, all between 5/6/2002 and 12/6/2002. So remember tblfile4d has date format for Clock for all the dates now. It is called gilsrch.cfm posts to gildate2.cfm with this relevant code: SELECT count(t.File) as file3, t.Clock, g.File, t.File FROM tblfile4d t, gilway12 g WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND #CreateODBCDate(Form.Clock2)# AND t.File=g.File GROUP BY g.File, t.File, t.Clock ORDER BY file3 DESC SELECT count(File) AS file2 FROM tblfile4d WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND #CreateODBCDate(Form.Clock2)# SELECT count(t.File) as file4 FROM tblfile4d t, gilway12 g WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND #CreateODBCDate(Form.Clock2)# AND t.File=g.File Why is it doing this I can give you the links... http://www.cheshiregroup.com/gilway/gilwaydb.cfm http://www.cheshiregroup.com/gilway/gilsrch.cfm Can someone help me with this? Why does it return other years? Please cc me at [EMAIL PROTECTED] if you can Julia Green Julia Computer Consulting Web Design @ Reasonable Prices Email: [EMAIL PROTECTED] www.juliagreen.com Phone: 617-926-3413 Cell: 617-596-6003 Fax: 1-617-812-8148 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: SOT: CFDEV.com
You do not appear to accept American Express (pretty strange for a US based company). You mean there's someone who still does, who doesn't mind the horrible rates that American Express inflicts on the merchant? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: ColdFusion practical limits
2000 simultaneous transactions Maybe I'm missing something, but it used to be that Allaire recommended (as a general rule) limiting the simultaneous transactions to 4 x the number of CPUs. Of course, that goes back to ColdFusion 4 and early Pentium IIs, and there were lots of other variables to take into consideration. Nevertheless, even if that number has grown to, say, 20 for your average Web server, and you have dual processor boxes (still the best bang for the buck?), that would be 50 servers. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 1:12 PM To: CF-Talk Subject: ColdFusion practical limits I need to provide a big client with the practical limits of ColdFusion 5 running on a Windows 2000 server. The clients wants to know that the server and the associated MS SQL Server can handle 2000 simultaneous transactions. Are there any published stats that would help? Would I need to lod balance several servers to support this? Thanks in advance... Regards, Howie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: ColdFusion practical limits
Drop the typical page time to 50ms (easier said than done), and you've got a lot more simultaneous connections. I've always used the term simultaneous in this context to mean executing at the same time, not executing within the same second or, as Dave suggested, pooled but not currently executing. Which is the correct definition in this sense? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: (Admin) New spam code
Because this mail server is configured correctly, and it won't allow relaying of mail coming from outside of it's network, I can't use it with my cable modem connection as an outgoing mail server Has your hosting company not heard of SMTP Auth or POP Before SMTP? Or, is your cable company simply blocking outbound port 25? Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Shorter urls?
If you put a .cfm on the end, you can handle the request in the Application.cfm page. If you are using IIS, you have to tell it not to check to make sure the page exists. This is a setting specific to the application mapping. Or, you can use an ISAPI extension (IIS) or mod_rewrite (Apache) to rewrite the URL before it even gets to ColdFusion. There's a free one for IIS called ISAPI_Rewrite (http://www.isapirewrite.com). Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 1:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: How to remove URL references from printed pages
Have a look at Mead Company's ScriptX. They have a free, lite version. It only runs in Internet Explorer, however, but it works very well. You can even control it with JavaScript. Very cool. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Rick Faircloth [mailto:Rick;GoLibertyOnline.com] Sent: Friday, October 25, 2002 8:34 AM To: CF-Talk Subject: How to remove URL references from printed pages Hello all. I'm printing some report directly from browser pages and would like to be able to get rid of the info that appears at the top and bottom of each page automatically when the pages are printed...such as the URL at the bottom. How would I do that? Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Urgent : GURU Required: Excel vs COM in CFMX
Macromedia breaks COM support in ColdFusion, and now COM is dead? Sounds like spin to me: rather than fix it, we'll just declare it dead and deride the use of it. Don't get me wrong, I know you don't work for Macromedia, and I know COM is something less than ideal. However, it works well for much of what we do, and sometimes it is the only way to get the job done. I'd really like to see Macromedia fix COM support in ColdFusion than have presenters haranguing the death of COM at Devcon. COM is years away from being dead in any practical sense. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Steve Drucker [mailto:sdrucker;figleaf.com] Sent: Thursday, October 24, 2002 10:39 AM To: CF-Talk Subject: RE: Urgent : GURU Required: Excel vs COM in CFMX Yeah, the problem is that you're using COM to connect to Excel. As has been previously mentioned several times on various boards, COM is dead. Microsoft has abandoned COM, ColdFusion MX doesn't support COM particularly well due to its new architecture, and invoking Excel as a COM object on the server isn't even supported by Microsoft under ASP: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257757ID=kb;en -us; Q257757FR=1 So, just say no to COM. I'm actually lecturing about this topic at Devcon in a few days. Your viable options are as follows: 1) Simple data can be sent to Excel as delimited fields 2) More complex data can be represented as HTML or XML and loaded directly into Excel (especially Excel 10/XP) 3) Use the Office XP web control to embed MS-excel functionality in your web pages (assuming the end user owns a license of XP) 4) Use Excel's web query features, or use CF to create a web query file 5) Create a web service in CFMX that is accessible to Excel as a web client Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: Daryl Fullerton [mailto:Daryl.Fullerton;biznet-solutions.com] Sent: Thursday, October 24, 2002 7:52 AM To: CF-Talk Subject: Urgent : GURU Required: Excel vs COM in CFMX Folks / Guru's Hi, Wonder if there are any CFMX / Excel COM gurus out there that could help. Much appreciated if anyone knows what is causing the below or can recommend a fix. Cheers D ColdFusion Usergroup Ireland Manager E: [EMAIL PROTECTED] W: http://www.cfug.ie -Original Message- From: Eric Zumot Sent: 24 October 2002 11:46 To: CF-Talk Subject: Excel vs COM in CFMX I have been facing big difficulties in using COM Objects to access Excel, (Platform Win2000, Office2000, CFMX). When the same code was on CF5.0 it worked perfectly without any problems. In the beginning, COM Objects couldn't connect to Excel, after doing several installations of Office2000, it connected successfully. The main problem started happening afterwards, which is accessing the Excel COM Object properties (The main error occurs whenever it tries saving the file). In brief, below are the main steps of I did so far; 1- I followed all the instructions recommended in Macromedia's article (http://www.macromedia.com/v1/Handlers/index.cfm?ID=22922Method=Full) Followed the steps, and still the same error, no joy. 2- I changed the permissions of ColdFusion in the services Applets as recommended in cfcomet.com (http://www.cfcomet.com/other/index.cfm?ArticleID=32381637-0922-41CA-BBE 305C2D66A7025#22) Restarted the services and the server and still the same error. 3- Downloaded and installed the Updater (http://dynamic.macromedia.com/bin/MM/software/trial/hwswrec.jsp?product =cfmx_updater) after showing installation was successful, I restarted the services and the whole server again. I kept getting the same error, except for one trial that was successful, afterwards it returned back to the same problem. Eric (Sael) Zumot, Senior Programmer, BizNet Solutions, 133-137 Lisburn Road, Belfast, Northern Ireland BT09 7AG T:++44 (028) 90223224 F:++44 (028) 90223223 E:[EMAIL PROTECTED] W:http://www.bizNet-solutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: BlueDragon (was RE: How is CFMX J2EE implemented?)
I'm all for added functionality/tags/functions, but I also understand the concerns. I would think, however, that Macromedia implementing a tag called cfforward which did not function exactly as New Atlanta's would be just as big of a problem for New Atlanta as for their customers, whether they are developing for both environments or migrating from one to another. A way to minimize the problem would be for New Atlanta to use a different namespace (so to speak) for their tags. I'm not talking something as complicated as XML namespaces, but simply using a different naming scheme, such as bdforward. Ostensibly, ColdFusion would ignore these tags when validating/processing a page so their presence in the page would not immediately generate an error. As for the possibility that Macromedia would adopt these new tags, I won't hold my breath. They may implement the functionality, but I doubt it would take the same form. There's simply no reason for Macromedia to architect CFML around the alternative implementations of third parties, and they've shown no interest -- at least not that I'm aware of -- of standardizing CFML. In fact, if history is any guide, it would behoove them to do just the opposite, take the Microsoft approach (DRDOS and OS2) and break compatibility wherever possible. I personally doubt they will do this, however. There position in the CF market is secure. There's no need to resort to such tactics. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 9:36 AM To: CF-Talk Subject: RE: BlueDragon (was RE: How is CFMX J2EE implemented?) | -Original Message- | From: Ken Wilson [mailto:[EMAIL PROTECTED]] | Not exactly. Custom tags can be easily copied to another server. That | can't be said for something that is integrated into the server itself. | So any app that relies on that functionality breaks if it | gets moved to | another variation of CF Server. Well, a lot of customtags depend on platform-specific out-side executable (windows/linux only), COM-objects, or platform-bound CFX tags. Using CF 4.5 on Solaris (or linux I guess), you get very aware of this -- when you hunt around for customtags you have to look carefully! /h. ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX - I've never seen anything so unstable in my life
Nothing changed on the SQL Server, correct? No one checked the Boost SQL Server priority on Windows NT checkbox or changed any SMP settings? Is ColdFusion the only thing that talks to SQL? Don't rule out coincidence. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:22 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Sean, Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:02 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 11:21 US/Pacific, Ben Densmore wrote: I have posted this a couple of times on MM's forums and in here but no real solution. I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Sounds like the database is dropping the connection. What's your: - OS / patch level - Database / patch level - Is the DB on a separate machine? - Which driver are you using specifically? - How often do you see this? - Does it seem to be connected to any other network issues? - Are there other errors in the CF logs? Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 fax: (415) 865-3113 -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX: cfcontent/deletefile/IE - bug?
I believe the behavior of the CFMail tag was changed so that it no longer immediately embeds the attachment, but rather, waits until it sends the message. This probably doesn't directly relate to Marcello's problem. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 5:17 PM To: CF-Talk Subject: RE: CFMX: cfcontent/deletefile/IE - bug? I ran into a similar problem...I was sending an email with CFMAIL with a file as an attachment...then deleting the file afterwards...worked fine in CF5 but in CFMX it deletes the file before sending the email with attachment so I get the same error you mentioned... Stace -Original Message- From: Marcello Frutig [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 4:17 PM To: CF-Talk Subject: CFMX: cfcontent/deletefile/IE - bug? Hello, I've seen today the following problem using CFMX (internal web server; updater installed; Win2k)... When accessing a page containing cfcontent type=application/pdf deletefile=yes file=c:\test.pdf the pdf file does not appear on the browser (IE6) and this message is written to application.log: Error,web-10,10/07/02,15:47:10,,The cause of this output exception was that: java.io.FileNotFoundException: C:\CFusionMX\wwwroot\pdf\test.pdf (The system cannot find the file specified). The specific sequence of files included or processed is: C:\CFusionMX\wwwroot\pdf\pdf.cfm When I change deletefile=yes to deletefile=no everything runs as expected. Any idea? Thanks, Marcello. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFMX issues
Are you sure #1 isn't the Internet Explorer 6 cookie/privacy bug? http://www.c4.net/Index.cfm?Method=Support.FAQ.IE6Privacy Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Brook [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:03 PM To: CF-Talk Subject: CFMX issues We've been running CFMX now in production for about a month without any major issues. There are a couple of things however that our user base has begun to report on multiple occasions and things we have noticed ourselfs. I am wondering if any one else has these issues with CFMX / win2K: 1. Mysterious loss of client variable data. This happens once in a blue moon. But, it does happen and it does not appear to have anything to do with the site code because it happens in completely random locations and at random times. Our site uses a client variable authentication scheme and we have several clients reporting that they get kicked back to the log in screen sometimes. We have also seen this in our tests but it is very rare. 2. Clicking a link will start a page to load but it will never actually load. The browser continues to load the page for what seems like forever. I'm not sure if it ever actually times out, but it may as well. Clicking the link again always loads the page right away. This happens fairly regularly. The server is not under much load and their are only between 1-3 CF threads running when this happens. Brook Davies ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Fastest way to convert a csv file to cf array/query?
Won't be extremely fast, but I have a set of custom tags written in CFML for reading a CSV formatted file into a ColdFusion query object. Let me know (off list) if you'd like a copy. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 3:42 PM To: CF-Talk Subject: Fastest way to convert a csv file to cf array/query? Using MX anyone have any ideas on a really fast way to convert a large (200-500k) cvs file into a CF complex data type like a query or array? Barry Manilow,Dr. Sholz,[EMAIL PROTECTED] -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Header info displaying on site?
I've run into this problem before. I believe, in my case, it occurred when using the cfhtmlhead tag and the cflocation tag in tandem. If I looked at the source of the page that was the target of the redirection, I'd see the content set by the cfhtmlhead tag above the HTTP headers of the page. If I remember correctly, the work around was to use the cfheader tag to set the temporary redirect in place of the cflocation tag. Actually, I think I issued a refresh rather than a HTTP temporary redirect. Not sure why though. It's all a bit hazy. :P HTTP refresh: cfheader name=Refresh value=0; URL=http://www.domain.com/page.cfm; Or, you might just try a HTTP temporary redirect: cfheader name=location value=http://www.domain.com/page.cfm; cfheader statuscode=302 statustext=Document Temporarily Moved Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:49 AM To: CF-Talk Subject: Header info displaying on site? Hi all, I've got an app that's suddenly showing what looks like http header information at the top of every page on the site: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 03 Oct 2002 13:46:25 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Set-Cookie: CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272002%2D10%2D03+06%3A46%3A2 5%27 %7D%23TIMECREATED%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27%7D%23; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFID=2150; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=47991225; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Any idea what might be causing this? Thanks, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Deleting Compiled Java
The class and java files are located in the following directory: \CFusionMX\wwwroot\WEB-INF\cfclasses\ After deleting them, you'll have to restart the ColdFusion service. As for why you can't flush the classes from within the administration interface, I don't know. It would seem like a good idea to me. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 10:22 AM To: CF-Talk Subject: Deleting Compiled Java How do I do this and why can't I purge all the compiled java through the MX admin interface? Adam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Switching to CFMX
Secondly, this is exactly the sort of issue that makes me very nervous of Fusebox. It tries hard to hide complexity from programmers but this shows just how much code it's really hiding and just how much machinery lurks behind the framework. This is the exact same argument that gets made against ColdFusion. I'm sure those early Word Perfect assembly programmers said the same thing about programmers writing word processing programs in languages like C and *gasp* VisualBasic. Of course, this isn't really FB's fault: Of course this isn't really (C's|C++'s|Java's|VisualBasic's|ColdFusion's) fault. :) 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: Switching to CFMX
* Does cfinclude copy the contents of every included file then compile - regardless of the switch statement? I believe includes still happen dynamically. You can verify this by deleting all the files in the following directory: \CFusionMX\wwwroot\WEB-INF\cfclasses Restart the ColdFusion service and make a request to your page. It should only create class files for the files that were needed to complete the request. BTW, I just checked and my developer version behaves this way. * Does the compiled cfm make a whole class, is it only a method in some master class, or is everything stuck into a single method? is there a way to force other methods, like how cfcase only runs the necessary code? It appears that each ColdFusion page (*.cfm), ColdFusion component (*.cfc) and function gets its own class file. For a look at what's going on behind the scenes, edit the web.xml file in the following directory: \CFusionMX\wwwroot\WEB-INF\ Change the coldfusion.compiler.saveJava parameter to true. This will create .java source files for each of the classes. You may be able to get a better idea of what is going on from there. Again, you'll probably have to restart the ColdFusion service. This seems like a serious problem with CFMX for a large application using fusebox so I hope someone has experienced this and has a elegant workaround. I haven't run into any problems specific to porting Fusebox style applications to ColdFusion MX, except the fact that the first request is always interminably slow. I don't have any in production, However. I've only ported several such applications to a Developer Version of ColdFusion MX for testing purposes. 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: Switching to CFMX
Good to know. That explains why I haven't run into it as I tend to nest
fuses (I don't actually use Fusebox but something akin to it). I try to
keep individual switch statements to between 5 and 10 case statements
with no more than 20. Gets to hard to read otherwise.
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 5:45 PM
To: CF-Talk
Subject: RE: Switching to CFMX
Thanks Benjamin,
I appreciate your response, and I'll check out the xml file - that's a
great
tip.
You will run into this when doing large files or working on a large
application
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3threa
did=
385775
The index file I am dealing with is 2500 with a huge case statement
that
includes / module calls a lot of files.
here is the problem:
when you write
cftag
cfswitch
cfcasebalrg/cfcase
/cfswitch
...
/cftag
that gets created into
public class whatever{
= public whatever(){
switch(barg){
case blarg:
}
...
= }
}
The parts marked between = can be no greater than 64k. One has no way
of
knowing how large that is when writing a cfm page because the
instruction
swapping is hidden from the programmer. It seems to happen at about 1500
or
so lines.
The 64k limit is a Java limitation.
The *only* work around I found is to break the large file into smaller
files
(in my case index0.cfm, index1.cfm, index2.cfm, etc), and have a master
index with a fuse action list that include the proper index file.
cfswitch switch=attributes.fuseaction
cfcase value=listall,showone,dosomething,doanotherthing
delimiters=,
cfinclude template=index0.cfm
/cfcase
cfcase value=update,delete,dothis,dothat delimiters=,
cfinclude template=index1.cfm
/cfcase
...
/cfswitch
It adds a whole layer of abstraction, but seems to work. Again this only
happen when doing really large files and the (evil) errors MX gives are
the
following (for the next poor sap searching the archives):
(class: cfindex12ecfm1447028664, method: _factor1 signature:
(Ljavax/servlet/jsp/tagext/Tag;)Ljava/lang/Object;) Illegal target of
jump
or branch
ColdFusion cannot determine the line of the template that caused this
error. This is often caused by an error in the exception handling
subsystem.
OR
Code of a method longer than 65535 bytes
Thanks again
Rob
-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 2:12 PM
To: CF-Talk
Subject: RE: Switching to CFMX
* Does cfinclude copy the contents of every included file
then compile - regardless of the switch statement?
I believe includes still happen dynamically. You can verify this by
deleting all the files in the following directory:
\CFusionMX\wwwroot\WEB-INF\cfclasses
Restart the ColdFusion service and make a request to your page. It
should only create class files for the files that were needed to
complete the request.
BTW, I just checked and my developer version behaves this way.
* Does the compiled cfm make a whole class, is it only a
method in some master class, or is everything stuck into a
single method? is there a way to force other methods, like
how cfcase only runs the necessary code?
It appears that each ColdFusion page (*.cfm), ColdFusion component
(*.cfc) and function gets its own class file. For a look at what's going
on behind the scenes, edit the web.xml file in the following directory:
\CFusionMX\wwwroot\WEB-INF\
Change the coldfusion.compiler.saveJava parameter to true. This will
create .java source files for each of the classes. You may be able to
get a better idea of what is going on from there. Again, you'll probably
have to restart the ColdFusion service.
This seems like a serious problem with CFMX for a large
application using fusebox so I hope someone has experienced
this and has a elegant workaround.
I haven't run into any problems specific to porting Fusebox style
applications to ColdFusion MX, except the fact that the first request is
always interminably slow. I don't have any in production, However. I've
only ported several such applications to a Developer Version of
ColdFusion MX for testing purposes.
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: WDDX to XML
I think you're missing the point of storing the name in an attribute rather the tag name itself. First, the tag is not pulling double duty by describing both the type of data and the data's identity. Second, and more important on a practical level, by placing the variable name in an attribute, you avoid naming conflicts with XML itself. For instance, I don't believe XML allows you to include a number at the beginning of your tag or spaces within it. However, most languages will allow this in some form or another. Specifically, ColdFusion will allow you to name a struct key just about anything. By placing the name in an attribute, you avoid such conflicts. So, though many people working with XML take the easy way out, it is not necessarily the better way, and it is certainly not the standard. Unless you have a real reason to switch, you're probably safer with WDDX or mimicking the structure of WDDX as much as possible as quite a bit of time and energy went into designing it. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 3:45 PM To: CF-Talk Subject: Re: WDDX to XML I want to return to data in true XML not WDDX. For instance I do not want: wddxPacket version='1.0'header/datastruct I would like standard XML naming Instead of: var name='AIRPORTNAME' I would like AIRPORTNAME - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:30 PM Subject: RE: WDDX to XML wddx is xml ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 3:31 PM To: CF-Talk Subject: WDDX to XML What is the best way to move data from WDDX to XML? __ 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: CFMX: how to deal with type java.util.Hashtable$Enumerator
Outlook XP does not treat it as a single, clickable link. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:48 AM To: CF-Talk Subject: Re: CFMX: how to deal with type java.util.Hashtable$Enumerator Yes it still wraps (i didn't say that it wouldn't wrap), but the email client (at least most do) treats it as a single, contiguous, double-clickable URL. Dick On Wednesday, September 11, 2002, at 08:21 AM, Tangorre, Michael wrote: it still wrapped in your email. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:17 AM To: CF-Talk Subject: Re: CFMX: how to deal with type java.util.Hashtable$Enumerator A while ago, someone posted this hint: If you send a URL in an email, you can avoid it being broken into segments by line-wrapping. Just include the URL within and characters , for example: http://java.sun.com/j2se/1.4/docs/api/java/util/ Enumeration.html#method_summary. Most email clients will treat the information within and as on continuous double-clickable, string. Don't use parenthesis (or any other characters), as they get included with the URL! Try it, it works-- and makes life easier for the recipients. HTH Dick On Wednesday, September 11, 2002, at 07:51 AM, Jann VanOver wrote: Try nextElement(). See http://java.sun.com/j2se/1.4/docs/api/java/util/ Enumeration.html#method_summ ary (That is a long URL and may need to be stuck back together before being used) On 9/10/02 9:27 AM, Marcello Frutig [EMAIL PROTECTED] wrote: Hello! I'm calling a Java method in CFMX that is returning an object of type java.util.Hashtable$Enumerator. How could I deal with this object in CFML in order to get the elements/values? I've tried to use the methods next(), etc. without success. Thanks, Marcello Frutig. -- Astrolabio __ 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: Big problem- session vars not saved in IE6 on CF5
There seems to be a bug the Internet Explorer 6 privacy settings. Despite significantly lax restrictions, we have had a lot of problems with IE 6 users and sites that use cookies to track sessions. In troubleshooting the issue, we've attempted to add P3P privacy policies to our sites. We have tried altering the domain attribute on the cookies. We tried just about everything we could think of. The only workaround that we've found is to have the client add the site to their list of allowed sites (In the Web Sites section of the Privacy tab). This fixes the problem in every instance we've encountered. This is reasonably good work around for Intranet/Extranet sites. Obviously, however, it is not so good for public Internet sites. So far, we've left these sites broken and simply pointed our fingers at Microsoft. So, if someone has a true fix, please share it. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 5:32 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 And you know what - I'm debugging an app that used to work but doesn't anymore since the other day! Darn M$ Jb. -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: 29 August 2002 02:23 To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 I had the exact same problem this week when I upgraded my ie6 with the newest M$ patches. I have a form, which sends a login page to a script. Because the login page uses a submit button, the cookies for CFID and CFTOKEN would normally be set there. After processing, the login script cflocations the person to a new page. The funny thing is that I am not using CFLocation, but the Fusebox CF_Location tag which was not cookie problematic. The app works fine on Opera, Netscape 4.x and 6.2 as well as on IE 6. The application was definitely losing cookies, I cfdumped all session variables and http_cookie changed each time. My ultimate solution was to pass (during the first CF_Location only), the CFID and CFTOKEN on the URL. After that I don't pass them and the application works fine. I checked all my settings in IE 6 and they were all accepting cookies. Very weird. Any other better solutions (or even better rational explanations for the problem) would be much appreciated. Sandy Clark -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:14 PM To: CF-Talk Subject: Re: Big problem- session vars not saved in IE6 on CF5 Hi Don, I am having a big problem with an old standard login system. This is the most simple login system I know and have used it for years. It consists of: Login form page Login action page Main page Session variables tracking who is logged in The user enters in their login acct, the action page compares it against the db, then sets some session variables and uses cflocation to forward them to a new page or back to the login page if they fail. The application page checks for the session variable to see if they're logged in and uses cflocation to send them back to the login page if the var doesn't exist. I am slightly surprised that this has ever worked if I understand it correctly. Session and Client variables normally use cookies to control themselves, if not you have to use CFID and CFToken in your URLs. cflocation has a proviso that if you use it then any cookies set in the page before the cflocation tag will _not_ actually get sent to the browser under normal circumstances. This means that if you have a cflocation in your initial entry then your session may not well be set up properly. -- Yours, Kym __ 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: Missing form fields - anyone experienced this error ?
I had a form on the Grand Canyon NPS site that used to get hundreds of submissions a day. Periodically, like once every couple weeks, we'd get a complaint from a user that the form didn't work. The user explained that they filled out the form and tried to submit it only to receive an error. I'd see the error in the ColdFusion logs. Form fields that absolutely should have been submitted (such as hidden form fields) simply weren't submitting. We spent quite a few hours trying to debug it. We even rewrote the form from scratch twice, breaking it down in to smaller and smaller multipart forms. We added JavaScript checks, server side checks, and everything else we could think of. Still, the form fields would not get submitted. You're probably hoping that we came across a solution and that I'm now about to share that solution. Unfortunately, that is not the case. We simply gave up. We blamed it on a thousand different things, everything from AOL's proxy servers, to browser caching, to corporate firewalls. The truth is we never figured it out. Looking back, the only regret I have is that I spent so much time trying to fix a problem that I had no control over. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Vishal Narayan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 6:31 AM To: CF-Talk Subject: Missing form fields - anyone experienced this error ? Has anyone else experienced these missing form data errors ? These are not due to improper bookmarking, or due to browser having JavaScript disabled. The form field exists, but on submittting, is somehow not available to the next page. These occur randomly, and therefore cannot be a coding issue. We are getting these errors more frequently when the traffic is higher. This seems to imply some problem with session management, either with CF Server or IIS. We are using CF 4.5 SP2 on Win 2K Server, with IIS 5 and SQL 2000 DB. Has anyone experienced similar problems with their websites ? Vishal. __ 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: Big problem- session vars not saved in IE6 on CF5
As I noted, we did try adding a P3P policy, created using the IBM P3P Policy Editor. However, that did not fix the problem. We even tried setting the privacy settings to their most lax state. That did not fix the problem either. The only workaround to this bug that we've found is to add the site to the listed of allowed sites, which seems to bypass the whole privacy engine. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 11:05 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 This has come up a few times in discussion. I think we really need a good solution for the p3p policy and cold fusion, as I feel this is the root of the problem. P3p enforcement might be adopted by other(all) browers down the line, so it would probably be a good idea to get it solved now. I wonder if we could come up with a generic p3p policy document that people could incorporate into their site to allow the cookies we need for our CF apps? Funny thing is, asp.net apps have absolutely no problem placing their cookies. Who woulda guessed? Here's a good thread about the issue: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3threa did= 230279highlight_key=ykeyword1=cookieskeyword2=p3p Anyone know of a good tutorial to get p3p implemented? I really don't want to know the ins and outs, just get around the default ie6 settings... I guess that was what I was alluding to above. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 9:44 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 There seems to be a bug the Internet Explorer 6 privacy settings. Despite significantly lax restrictions, we have had a lot of problems with IE 6 users and sites that use cookies to track sessions. In troubleshooting the issue, we've attempted to add P3P privacy policies to our sites. We have tried altering the domain attribute on the cookies. We tried just about everything we could think of. The only workaround that we've found is to have the client add the site to their list of allowed sites (In the Web Sites section of the Privacy tab). This fixes the problem in every instance we've encountered. This is reasonably good work around for Intranet/Extranet sites. Obviously, however, it is not so good for public Internet sites. So far, we've left these sites broken and simply pointed our fingers at Microsoft. So, if someone has a true fix, please share it. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 5:32 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 And you know what - I'm debugging an app that used to work but doesn't anymore since the other day! Darn M$ Jb. -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: 29 August 2002 02:23 To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 I had the exact same problem this week when I upgraded my ie6 with the newest M$ patches. I have a form, which sends a login page to a script. Because the login page uses a submit button, the cookies for CFID and CFTOKEN would normally be set there. After processing, the login script cflocations the person to a new page. The funny thing is that I am not using CFLocation, but the Fusebox CF_Location tag which was not cookie problematic. The app works fine on Opera, Netscape 4.x and 6.2 as well as on IE 6. The application was definitely losing cookies, I cfdumped all session variables and http_cookie changed each time. My ultimate solution was to pass (during the first CF_Location only), the CFID and CFTOKEN on the URL. After that I don't pass them and the application works fine. I checked all my settings in IE 6 and they were all accepting cookies. Very weird. Any other better solutions (or even better rational explanations for the problem) would be much appreciated. Sandy Clark -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:14 PM To: CF-Talk Subject: Re: Big problem- session vars not saved in IE6 on CF5 Hi Don, I am having a big problem with an old standard login system. This is the most simple login system I know and have used it for years. It consists of: Login form page Login action page Main page Session variables tracking who is logged in The user enters in their login acct, the action page compares it against the db, then sets some session variables and uses cflocation to forward them to a new page or back to the login page
RE: Big problem- session vars not saved in IE6 on CF5
To be honest, I do not know. However, I believe it has something to do with corrupted cookie files. In which case, you are more likely to see it in sites that people revisit frequently. That has been our experience, at least. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 11:37 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 Ok, so why does this only effect some people. I have 20ish sites that use sessions on my server and they have no problems that I have had reported to me. But, a client's server seems to have this problem. MB -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 10:22 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 As I noted, we did try adding a P3P policy, created using the IBM P3P Policy Editor. However, that did not fix the problem. We even tried setting the privacy settings to their most lax state. That did not fix the problem either. The only workaround to this bug that we've found is to add the site to the listed of allowed sites, which seems to bypass the whole privacy engine. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 11:05 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 This has come up a few times in discussion. I think we really need a good solution for the p3p policy and cold fusion, as I feel this is the root of the problem. P3p enforcement might be adopted by other(all) browers down the line, so it would probably be a good idea to get it solved now. I wonder if we could come up with a generic p3p policy document that people could incorporate into their site to allow the cookies we need for our CF apps? Funny thing is, asp.net apps have absolutely no problem placing their cookies. Who woulda guessed? Here's a good thread about the issue: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3threa did= 230279highlight_key=ykeyword1=cookieskeyword2=p3p Anyone know of a good tutorial to get p3p implemented? I really don't want to know the ins and outs, just get around the default ie6 settings... I guess that was what I was alluding to above. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 9:44 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 There seems to be a bug the Internet Explorer 6 privacy settings. Despite significantly lax restrictions, we have had a lot of problems with IE 6 users and sites that use cookies to track sessions. In troubleshooting the issue, we've attempted to add P3P privacy policies to our sites. We have tried altering the domain attribute on the cookies. We tried just about everything we could think of. The only workaround that we've found is to have the client add the site to their list of allowed sites (In the Web Sites section of the Privacy tab). This fixes the problem in every instance we've encountered. This is reasonably good work around for Intranet/Extranet sites. Obviously, however, it is not so good for public Internet sites. So far, we've left these sites broken and simply pointed our fingers at Microsoft. So, if someone has a true fix, please share it. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 5:32 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 And you know what - I'm debugging an app that used to work but doesn't anymore since the other day! Darn M$ Jb. -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: 29 August 2002 02:23 To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 I had the exact same problem this week when I upgraded my ie6 with the newest M$ patches. I have a form, which sends a login page to a script. Because the login page uses a submit button, the cookies for CFID and CFTOKEN would normally be set there. After processing, the login script cflocations the person to a new page. The funny thing is that I am not using CFLocation, but the Fusebox CF_Location tag which was not cookie problematic. The app works fine on Opera, Netscape 4.x and 6.2 as well as on IE 6. The application was definitely losing cookies, I cfdumped all session variables and http_cookie changed each time. My ultimate solution was to pass (during the first CF_Location only), the CFID and CFTOKEN on the URL. After
RE: CF vs. ASP
Actually, if you were interested in making a fair comparison, it would look more like this: cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject= #Form.FirstName# #Form.LastName# has request more information. Please contact them at #Form.Phone#. #Form.FirstName# #Form.LastName# #Form.Addr1# #Form.Addr2# #Form.City# #Form.State# #Form.ZIP# #Form.Email# #Form.Phone# #Form.Comments# #Form.NoMkt# /cfmail It's still less lines and I like the way ColdFusion does it better, but that would be a more accurate comparison. Of course, the ASP method can be advantageous in a lot of situations. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 4:35 PM To: CF-Talk Subject: RE: CF vs. ASP CASE IN POINT TOO MANY LINES/CHARACTERS OF BS VBSHIT CODE Dim MyMail Dim MsgText Set MsgText = Request.Form(FirstName) + + Request.Form(LastName) + has requested more information. Set MsgText = MsgText + Please contact them at + Request.Form(Phone) Set MsgText = MsgText + VBCrLf Set MsgText = MsgText + Request.Form(FirstName) + VBCrLf Set MsgText = MsgText + Request.Form(LastName) + VBCrLf Set MsgText = MsgText + Request.Form(Addr1) + VBCrLf Set MsgText = MsgText + Request.Form(Addr2) + VBCrLf Set MsgText = MsgText + Request.Form(City) + VBCrLf Set MsgText = MsgText + Request.Form(State) + VBCrLf Set MsgText = MsgText + Request.Form(ZIP) + VBCrLf Set MsgText = MsgText + Request.Form(Email) + VBCrLf Set MsgText = MsgText + Request.Form(Phone) + VBCrLf Set MsgText = MsgText + Request.Form(Comments) + VBCrLf Set MsgText = MsgText + Request.Form(NoMkt) + VBCrLf Set MyMail = CreateObject(CDONTS.NewMail) MyMail.From = [EMAIL PROTECTED] MyMail.To = [EMAIL PROTECTED] MyMail.Subject = Information Request MyMail.BodyFormat = 1 'plain text MyMail.MailFormat = 1 'plain text MyMail.Body = MsgText MyMail.Send Set MyMail = Nothing !END CASE IN POINT! Compared to this.. cfmail to= from= server= subject=some stuff here./cfmail there is no comparison, the only thing we need to do with asp is Port it to CFML so that our clients get what they deserve! .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Perez, Jimmy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 4:11 PM To: CF-Talk Subject: RE: CF vs. ASP As long as the price is right... :) Thanks -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 2:56 PM To: CF-Talk Subject: Re: CF vs. ASP Use the right tool for the job. And if you have to ask if you should keep all your eggs in one basket then I have a bridge I'd like to sell you. On Mon, 26 Aug 2002, Perez, Jimmy wrote: Hello all, I am a CF certified developer (missed advanced by three points) but am thinking of expanding my horizons/marketability. I have started getting up to speed in ASP/VBScript but the question keeps coming up: should I even spend any time doing this or should I just concentrate on CF? The more e-mails I read in this list, the more I realize how powerful CF is, but should I keep all my eggs in one basket so to speak? Any good advice? TIA Jimmy __ 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: [SOT] Server Hard Drives
If you want to know more, go to www.storagereview.com and have a look around. StorageReview.com? You mean the site which has perpetually listed the ATA-100 Western Digital SE drives in the top 5 for just about every performance test for the past 6 months. :) 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: [SOT] Server Hard Drives
One comment was that SCSI interface to hard drives is better than ATA IDE interface. Why? Such statements need qualifications. In the most generic terms, SCSI RAID solutions generally provide higher performance. It comes as at a cost, however. IDE RAID solutions are much cheaper (both the controllers and the drives) while providing much more disk space. With the 3Ware RAID cards, for example, you can be fully redundancy with terabytes of data for very little money (relatively speaking of course). Some IDE drives, such as the Western Digital SE's, are on par performance wise with a lot of the high end SCSI drivers. Of course, this varies from test to test. In general, IDE drives suffer when it comes to access times, though this has more to do with the size of the drives (i.e. amount of data stored on the drives) than with any limitation inherent in IDE drives. Others said that they would not consider hardware for a server unless it had RAID. Why? I can't speak for anyone else, but IDE RAID is so cheap that we use it just about everywhere. About to perform a major upgrade? Unplug a drive and you have an instant way to get back to where you started. Bad drive? No problem. Just replace it. In most cases, you can sync up the drives while the system's serving up web pages. In my mind, the question is when would you not use RAID? Maybe a gaming machine. Even then, it takes me a minimum of a day to install a system, drivers, patches, software etc. Afterwards, I usually spend the next week installing the software I forgot about, customizing the OS, etc. You can have a RAID system for as little as an extra $250. I think my time is worth that. :) I can see the desirability of RAID, but: Is RAID necessary for an Application Sever, like JRun? Is RAID necessary for an Web application Sever, like CFMX? Is RAID necessary for an Web Sever, like Apache? Is RAID necessary for a Database Server, like MS-SQL? No, no, no, no, and no, but I will never run any of those systems without RAID for the reasons mentioned above. Do all of the above have the ability of deploying on or taking advantage of a RAID? Yes. The RAID we're talking about happens at the hardware level. As a result, the question really is, Does my operating system support RAID? The answer to this question is vendor specific. Do RAIDs normally go in the same box as the server(s) or they just a separate rack-mount component? If separate, how do RAIDs interconnect with the other rack-mount boxes? A RAID controller (IDE or SCSI) is *generally* a PCI card that you place in the system in question. The drives are connected to and managed by the RAID controller. Finally, what would be the configuration of a good, reliable Web Hosting environment that included all the above servers and RAID, look like? Though not infinite, there are quite a few possible configurations. I would say, though, that RAID is the easiest and cheapest way (regardless of whether it is IDE or SCSI) to provide a level of redundancy in a hosting environment. It doesn't address interruptions in Internet connectivity, power irregularities, or a thousand other problems that can occur, but it protects a computer from the most common failure that I've witnessed, a bad hard drive. After all, your drives are the only mechanical components in a modern computer. Your data flies around at 7,200 to 15,000 revolutions per minute on ball bearings. Hard drives constitute, without a doubt, the most antiquated technology in any hosting environment. If nothing else, it just makes me feel better to know that they have to fail two times over before I start losing data and time. :) 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: ColdFusion Mail Server
as bad as not wrapping your outgoing mail. Are there really that many antiquated e-mail clients and gateways out there still? 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: cfimage
We call the command line image editor, ImageMagick, using CFExecute. It isn't exactly the most elegant solution, and you won't be able to run it on a lot of hosts, but it is cheap. :) http://www.imagemagick.org Here's an example. This call fills a rectangular area of an image and then crops the image: cfexecute name=C:\ImageMagick\mogrify.exe arguments=-fill ##FFF -draw rectangle 181,46 268,138 -crop 200 -quality 100 c:\Image.jpg timeout=10 /cfexecute Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: JLH All Turbo [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 11:56 AM To: CF-Talk Subject: cfimage What do you folks use to allow users to upload an image and have cf process it into a thumbnail and a fullsize version and compress it? thanks, jacob. __ 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: Using THIS scope in CFCs
the only comment I have is that if you are using components to build object modeled applications, you shouldn't be including files from cfcs. I don't know what the original poster is using includes for, but I think there are some really valid reasons to include files into a CFC. Unfortunately, there are some really monumental problems with CFCs that make including files problematic (i.e. the argument scope isn't available or the fact that CFReturn is silently ignored in an included file). The reason I originally started experimenting with including files into CFCs is that, if I included all of the actual logic of a function, it kept both the CFC file and function files short and sweet. Additionally, since ColdFusion supports dynamic includes, I reasoned that if I was working on one function and had a syntax error in my code, it would not cause other functions of the same CFC to throw an error. Now, that said, I don't think CFIncludes are a great choice for code reuse, at least not in an environment that supports custom tags, CFModule calls, CFCs, etc. Nevertheless, I think there are several valid reasons for using the CFInclude tag within CFCs. However, current CFC bugs make it necessary to implement inelegant workarounds. 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: 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: 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: 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:
script language=JavaScript
function sendPrinter() {
if( window.print ) {
window.print();
}
}
/script
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: Macromedia Folks: What are you thinking?
If so, then could you drop a note to the developers about why you'd find this advantageous, and why you it disadvantageous to create a local site, please? Heh, heh, heh. I don't know your background, John, but this kind of sounds kind of like the coder vs. designer argument recast. More to the point, it sounds like the kind of thing developers familiar with Allaire products feared from the start. I don't mean to pick on Macromedia or Dreamweaver. You folks do incredible things, but consider the following. Personally, I think the whole site model is interesting but cumbersome for much of what I do. Since version 2.5, I've come to use HomeSite to edit all kinds of files, many of which have nothing to do with Web sites (mail server SIEVE scripts, batch files, Windows Scripting Host files, etc.). I've only played with Dreamweaver MX for a couple hours, but it seemed like the file manager interfaces have been completely eliminated (or, rather not included). To open a directory of scripts or edit a non-Web file on one of the servers, I had to first create a random Web project. Then, I could navigate to the file through the Desktop tree. However, in addition to the extra steps it takes to get to a file on a mapped drive, the steps are somewhat irrelevant. Why should I have to select a Web site project to edit a SIEVE script on the mail server? Now, I realize Dreamweaver is built around the Web and that it wasn't intended to edit non-Web files (nor was HomeSite, I imagine), but this serves as example of how the Dreamweaver interface forces the developer into a certain role, one coders might find constraining. Where HomeSite had a unassuming interface, I found that Dreamweaver MX makes certain assumptions about my intentions. Consequently, the interface intrudes into the programming process, getting in the way. All that said, it isn't really important whether or not Dreamweaver allows me to do everything I want my editor to do: there are plenty of mature editing environments out there which I can use in tandem with Dreamweaver or exclusively if need be. I just bring this up because the attitude is a little disconcerting: treating something as simple and fundamental to the HomeSite experience as file browsing as a feature which needs justification just doesn't fly. Anyway, I'll relent now. :) 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: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
You generally see this error any time you lose a connection to the SQL Server. We see it every time we boot a SQL Server, which fortunately isn't that often. However, it also appeared when a particular query using ADO tied the SQL Server up in knots, preventing it from responding to requests from ColdFusion templates. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 12:31 AM To: CF-Talk Subject: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite Has anyone any experience with this error ? It started happening periodically a couple of weeks ago. Hit refresh, and the page usually comes up. No info on microsoft or macromedia's site. Four sites turn up on google that evidently have had the same problem. - Tracy -- Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ 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: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
Actually, it was a problem specific to ADO. We switched the site to ODBC and the problem went away. Queries stayed the same. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 10:42 AM To: CF-Talk Subject: RE: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite Sounds like someone may have an overworked server. -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 10:20 AM To: CF-Talk Subject: RE: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite You generally see this error any time you lose a connection to the SQL Server. We see it every time we boot a SQL Server, which fortunately isn't that often. However, it also appeared when a particular query using ADO tied the SQL Server up in knots, preventing it from responding to requests from ColdFusion templates. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 12:31 AM To: CF-Talk Subject: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite Has anyone any experience with this error ? It started happening periodically a couple of weeks ago. Hit refresh, and the page usually comes up. No info on microsoft or macromedia's site. Four sites turn up on google that evidently have had the same problem. - Tracy -- Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: options for image resizing tags
For simple resizing, have a look at the cfx_Image tag mentioned in another response. If you need anything more than that, have a look at ImageMagick (http://www.imagemagick.org). It is free and extremely powerful. The downside is you have to invoke ImageMagick from the command line using the CFEXECUTE tag. You'll probably find more hosts willing to install a custom tag than who've enabled the CFEXECUTE tag. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 8:53 AM To: CF-Talk Subject: Re: options for image resizing tags - Original Message - From: Craig Thomas [EMAIL PROTECTED] http://www.cfdev.com/products/productdetail.cfm?id=6 Thanks, this is the one (free) tag I'd found already. 500KB seems a bit hefty - is this usual for this sort of tag? Still caught in whether to build site using a CFX tag, not knowing whether shared hosting usually allows CFX tags. Have scanned a few places, some seem to allow it. How much would I be limiting my hosting options by building with CFX tags? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do you change this number 70.0500 to 70.05?
Errr...u, I didn't read your message in its entirety. Fields of a certain type will always store a precision length even after using the ROUND function. Try this instead: SELECT CONVERT(NUMERIC(8,2), TheField) AS TheField FROM MyTable That will only give you six digits to the left of the decimal point. Increase the 8 to something higher for more. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 6:22 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? How do you round it off? Multiply the number b7 100, round it off, and then divide by 100. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:22 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Thanks for your help. Only thing is a list of about 1000 clients is merged into the Activ Mail tag, and so each record has to be formatted within the query itself because Active Mail only takes lists from the query, not from CFPARAM or CFSET. The emails go out only to clients who's accounts are past due, but again the email tag uses variables only coming directly from within a query. Also, the database is managed by another company and they may be averse to changing the field type to decimal with a scale of 2, although I'm going to try that as the first option. Is there anyway to perhaps format fields with a function directly in the queries? Regards, Pardeep. - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 12:59 PM Subject: RE: How do you change this number 70.0500 to 70.05? try making the field decimal with a scale of 2. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:08 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do you change this number 70.0500 to 70.05?
Multiply the number b7 100, round it off, and then divide by 100. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:22 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Thanks for your help. Only thing is a list of about 1000 clients is merged into the Activ Mail tag, and so each record has to be formatted within the query itself because Active Mail only takes lists from the query, not from CFPARAM or CFSET. The emails go out only to clients who's accounts are past due, but again the email tag uses variables only coming directly from within a query. Also, the database is managed by another company and they may be averse to changing the field type to decimal with a scale of 2, although I'm going to try that as the first option. Is there anyway to perhaps format fields with a function directly in the queries? Regards, Pardeep. - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 12:59 PM Subject: RE: How do you change this number 70.0500 to 70.05? try making the field decimal with a scale of 2. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:08 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. __ 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: UDF question
The question is - do you want CF to automatically handle everything for you at the sacrifice of speed? Raymond, My first question to you is is there ever a reason not to lock access to Session or Application scoped variables? Personally I can't think of one, much less one in which the sacrifice of speed would come into play. My second question is isn't it true that, assuming all other things being equal, any algorithm or function coded in binary, compiled language is going to perform better than one written in a markup language and executed in JIT or even an interpreted language executed in a virtual machine? Now, assuming the answer to both of these questions is yes, I can only believe that, in addition to being more stable in environments where developers don't lock religiously, ColdFusion would actually perform faster in any environment where developers properly lock all access to shared scope variables. It would be very difficult to make a system smart enough to know Hey, I could use one lock around this particular block of code. Therefore, we would be stuck with the slower alternative. What you neglect to mention is that when you lock access to a session variable, you lock access to all session variables, causing other, potential more common and severe performance problems, especially in regards to the Application scope. In the DBMS realm, these are called hotspots, and though you generally don't see a performance difference on most systems, a database that implements such a locking scheme usually fails under a heavy load. Personally, I'd rather just do the work. It can't be that hard to cflock, or duplicate to the request scope. Did anyone say it was hard? It isn't hard to write your own Java servlets or roll your own HTTP server in C++. However, the entire reason for ColdFusion existence, its point of being and single greatest justification for the cost is that it saves development time. Coding three lines of code to every one reference to a shared scope, inventing workarounds (i.e. synchronizing all the data to the Request scope or storing serialized session data in client variables) is not my idea of RAD. In fact, I would say it is the exact opposite. God, what would writing SQL be like if I had to manually lock access to each record before issuing a query? Better yet, people snubbed their nose at MySQL because it didn't have row level locking but that is, in essence, how ColdFusion behaves: lock the whole scope instead of the variable being modified. MySQL has seen the light. Hopefully Macromedia will one of these days. 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: resendundeliverablemail4.cfm and lastModified
Ran into the same problem. I have a modified version we use. It examines the message's date header. The rest of the code is the same. If you'd like a copy of the full tag, e-mail me off list. In the meantime, I think all that changed was the CFIF statement around line 227. Substituting this code should work: cfset DateHeaderPosition = FindNoCase(#Chr(13)##Chr(10)#Date:, xFile) cfset DateStartPosition = DateHeaderPosition + 5 cfset DateEndPosition = FindNoCase(#Chr(13)##Chr(10)#, xFile, DateStartPosition) cfset MessageDate = Mid(xFile, DateStartPosition, DateEndPosition - DateStartPosition) cfset MessageDate = ParseDateTime(MessageDate, POP) CFIF DateDiff(y, MessageDate, Now()) GT LocalDateTrigger Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Phil Cruz [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 5:37 PM To: CF-Talk Subject: resendundeliverablemail4.cfm and lastModified I'm using the resendundeliverablemail4.cfm tag to handle undelivered mail. It is moving mail to the spool fine. However, it has the function to check the lastModified date of the email and if it's greater than a certain value it will email the administrator and move the mail to a failed folder. This is not working because the lastModified date of the file is being apparently being set to the date/time the file was moved to the undelivered folder (instead of the date/time the mail was sent/created) and so the failure threshold is never reached. I'm usin CF5. Anybody get the failure notification to work with this tag? Can CF be set to not change the lastModified date when moving to the undelivered folder? -Phil 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFABORT vs CFEXIT in CFCATCH TAG
Whats the best way to stop the execution of a page after a error has been caught using CFCATCH. Can I put a CFABORT or CFEXIT tag within the CFCATCH? Thanks in advance for any advice. It depends on what you want to do. If you want to end the request unconditionally, then I recommend using CFABORT. If, however, you are within an included file or a custom tag and you merely want to exit that template but continue on with the rest of the request, then use the CFEXIT tag with the appropriate Method attribute. Both tags will work within a CFCATCH tag. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia.com
If I recall, ColdFusion support for .Net did not include running on the CLR but support for things like .Net services. Perhaps interoperability would be a more accurate word to describe Macromedia's proposed support for .Net. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 11:50 AM To: CF-Talk Subject: RE: Macromedia.com MM could support .NET with a CFML language module that conforms to MS CLS - and make it commercially avaialable - right? -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 6:05 AM To: CF-Talk Subject: Re: Macromedia.com This definitely needs to be updated for a comparison with .NET (particularly ASP.NET). I think the comparisons that are out there compare CF 4.0 to ASP 2, which is horribly out of date (should compare CF 5.0 to ASP 3 and ASP.NET) Of course, I know this may go against the current bandwagon of saying we will support .NET that everyone and their dog seems to do nowadays - I think .NET is a solid platform, but I want to see true alternatives (On a side note - I've heard that MM will support .NET - how on earth can you be a true J2EE engine but still have support for the .NET CLR?) - Original Message - From: Earl, George [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 7:39 AM Subject: RE: Macromedia.com Sorry if this is a duplicate post, I never saw it hit the list . . . Jeremy, I'd like to see a really nice section at the re-built site that answers the CF vs. ASP and who's using CF type questions that we all get asked so often. When I get these kinds of questions, or when someone asks me to explain why I think we should go with CF instead of a competing product, I'd like to be able to go right to Macromedia and pull up a few pages with all the ammunition I need to support my recommendation. It should be front and center off the main page where I can't miss it. It should be built using the very tools I am recommending and it should showcase what can be done with those tools. In addition to the other stuff, I'd also like to see included in these pages a list of sites, companies and organizations that are using CF, with particular emphasis on large organizations (it's interesting how much credibility CF gains when people hear who's already using it). I know some of this stuff is already there, or at least it was at the Allaire site, but it isn't the easiest thing to find and it is scattered around. I think pulling it together in one place, making it very visible, and keeping it up to date would pay big dividends. George [EMAIL PROTECTED] -Original Message- From: Jeremy Allaire [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 16:08 To: CF-Talk Subject: Macromedia.com Hi- ... snipped ... We're also taking the coming months to re-build the site from scratch on our next releases of ColdFusion, Flash and Dreamweaver. We'd love your feedback on features for the site. Thanks, _ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation . $99/Month . Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
