RE: Version Control
I assume by your choices that you are looking at free products only? If not, you may want to consider Visual Source Safe. You can get this with a purchase of the developer edition of Microsoft Office 2000. And though I haven't used Starbase's product offering, I have heard good things about it. It is quite expensive, however, if you run it as a client/server application. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Bjørn Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 7:41 AM To: CF-Talk Subject: Version Control We could really need some Version Control software here at work, and I have found 2 products CS-RCS - http://www.componentsoftware.com/csrcs/addons/allaire.htm and CVS - http://www.cvshome.org/docs/index.html Does anyone know which is the best, or maybe even know a whole 3rd product that is even better ? Bjorn Jensen - Professional Nerd and coder ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Web Based SQL Manager
I think you missed the point. The point is to keep the box out of site of the Internet. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 6:26 PM To: CF-Talk Subject: Re: Web Based SQL Manager - Original Message - From: "Benjamin S. Rogers" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 7:05 PM If your network sits behind NAT, rather than exposing our SQL Server to the outside world so that developers have access to it via Enterprise Manager, you could create a Web based Enterprise Manager on one of your already exposed Web servers. Of course, if you have Windows 2000 Server or above, you would use the provided terminal services, which give you total admin control (by way of a virtual admin session) over the entire server as if you were actually right there at the keyboard - and with the full force of Win2K security. Adrian Cooper. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Web Based SQL Manager
My, how quickly you were able to gleam the full realm of possibilities for this product without having seen it. Luckily, I didn't immediately assume Clint's intentions were evil and thought of at least one viable use for such a product. If your network sits behind NAT, rather than exposing our SQL Server to the outside world so that developers have access to it via Enterprise Manager, you could create a Web based Enterprise Manager on one of your already exposed Web servers. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 11:22 AM To: CF-Talk Subject: RE: Web Based SQL Manager The only practical use I see for this is to mess around with SQL without having a client license (and software). I'd like to see it though -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 9:26 AM To: CF-Talk Subject: Web Based SQL Manager Would any of you be interested in a web based SQL Server7 Manager(its free)? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex Database System
Here are some reviews of a few relative technologies: http://www.zdnet.com/enterprise/stories/linux/0,12249,2646052,00.html http://www.zdnet.com/eweek/stories/general/0,11011,2646051,00.html Here are a few product comparisons between ColdFusion and ASP. Keep in mind that they are both biased towards ColdFusion. Ironically, the latter was written by a developer who now codes in Zope. http://www.houseoffusion.com/hof/body/asp.cfm http://www.swynk.com/friends/murphy/ironic_isnt_it.asp Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:11 AM To: CF-Talk Subject: Complex Database System Hi everyone, I wanted to know if anyone in the forum has developed a hard core interactive database system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does anyone know if there are any examples on the web. I have seen allot of ColdFusion sites but none of the ColdFusion sites are utilizing complex data structures. I am trying to convince upper management to use ColdFusion has the front end verses Active Server Pages for a SQL SERVER 7.0 database system used by all levels of management has a finance tool. Please advise...and if there are examples on the web please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Delete then WRITE issue....
Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""[EMAIL PROTECTED] Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Delete then WRITE issue....
Actually, the feature you are referring to does not have anything to do with the operating system but rather the Web server. IIS creates handles to files for fast references. When you delete a file, you actually delete the file (contrary to what Philip has suggested). The handle, however, is left open. A separate process called the cache scavenger routinely goes through and checks to see which files have been deleted. At this point the handle to the file is deleted and the file "appears" to be deleted from the file system. Although the frequency with which the cache scavenger checks file handles can be adjusted, the performance benefits from this method are great, so it is not recommended that you alter this setting. This is probably why it is hidden in the registry. One side note, the cache scavenger is set by default for something like every 60 seconds. You should not see the file for more than 60 seconds unless someone has already played with this setting. Now, as to the original question, is IIS indeed the Web server in question? If so, is IIS touching the file in-between the write and delete operations? This would invoke the caching mechanism discussed above. If this is the case, there is not to much you can do except name the files uniquely. The CreateUUID() function would probably be overkill: you could probably get away with the RandRange() function if you are deleting the file immediately. If the Web server is something other than IIS or IIS is not touching the file in-between the write and delete operations, then the problem is elsewhere. Are you always enclosing the CFFILE tag in an exclusive lock using the CFLOCK tag? Not doing this would cause a whole host of issues, but I wouldn't really expect the ones you've described. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:12 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue NT has this wonderful habit of not dealing with requests immediately - it can mean that when you try to write a file it messes up and needs a slight delay Pain, but it's lovely M$ software! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 16:53 To: CF-Talk Subject: CFFILE Delete then WRITE issue OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Delete then WRITE issue....
See my last post for the technical explanations.
If I'm guessing correctly, you are running an NT server with IIS? On the
first page of your application you create a file that the user can then
download? With some subsequent page request, you then delete the file?
However, the file still appears to be in the folder tree and a new one with
the same name cannot be written for some period of time.
If this is the case, then it should not make any difference whether or not
the user is "opening" or "saving" the file. What your probably experiencing
is just the coincidental timing of your requests and the cache scavenger. I
would recommend naming the files uniquely and running your own separate
scheduled task that deletes files nightly that are older than so many hours.
If this is not the case, then you really need to give us a better idea of
what OS, Web server, version of ColdFusion, etc. you are running, as well as
the logic behind the application.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 12:43 PM
To: CF-Talk
Subject: RE: CFFILE Delete then WRITE issue
This is great help and I appreciate all this feedback.
Is there an answer to my second question... I think this is an issue if
someone tries to OPEN the file instead of SAVING it. So the second
question is is there a way to force someone to DOWNLOAD the file instead of
opening it?
This would also help me.
Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729
"Benjamin S.
Rogers" To: CF-Talk
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: RE: CFFILE Delete then
WRITE issue
01/09/01
11:24 AM
Please
respond to
cf-talk
Keep in mind that though this eliminates most problems, the issue will
still persist. The best way to solve the problem is to use the CFLOCK tag.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 12:09 PM
To: CF-Talk
Subject: Re:CFFILE Delete then WRITE issue
You are encountering file locking errors. The write is trying to begin
before the delete has released it's lock on the file. When writing and
deleting, I always rename the file first, then delete the renamed file.
Same for the write. Write to a temp file, then once the write is complete,
rename that to it's proper name.
Chris
--
Original Message
From: ""[EMAIL PROTECTED]
Subject: CFFILE Delete then WRITE issue
Date: Tue, 09 Jan 2001 10:53:23 -0600
OK. I am having a problem here. I am able to DELETE a file with CFFILE
without a problem, but when I try to almost immediately WRITE the same
file
back it tells me there is an issue with the file "Error: The file could
not
be accessed." Has anyone encountered this before? When I check on the
server for the file, what once was a 500k file, is now only 500 bytes, but
when I try to open it there it tells me that the "file could not be
found."
But it exists. And then I have to wait a while to get the OS to release
it. I check it 24 hours later (because I am working on other things too,
and I so sleep some), and it works fine. I think this is an issue if
someone tries to OPEN the file instead of SAVING it. So the second
question is is there a way to force someone to DOWNLOAD the file instead
of
opening it?
Also, when I browse that directory in CF Studio, the file name has a RED
DOT to the left, and I have never seen this before.
Any help would be MOST appreciated.
Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_Activedit alternatives??
Here is an excerpt from one of my posts last month. There's probably quite a few other useful discussions on this topic in the list archives already. I would like to add ezEdit (http://www.siteobjects.com) to this list of utilities. It is distributed in the form of a custom tag. This tag works like most of the rest. It is free and Open Source. It lacks (and will probably always lack) features like the spell checker found in a few others because of the licensing fees associated with the spell checking databases and such. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 excerpt Most of the solutions out there (especially the ColdFusion ones) are all based on the MSHTML editor. Information developing applications using this component can be found here: http://msdn.microsoft.com/workshop/browser/overview/editing.asp Here's a list of the most popular ones that I've seen around. I know there are a couple people from some of these companies on this list who will probably want to interject on behalf of their company. However, we just researched this fairly extensively. This is a combination of our opinions from evaluating the products and information gathered from the sales people. Please take it for what it is worth: HTMLEdit This is not a ColdFusion solution but I would be remiss not to mention it since it is such a quick and easy solution that probably meets many peoples' needs. http://javaboutique.internet.com/HTMLEdit/ Pros: Simple and Open Source. Cross-platform and cross-browser. Cons: Very, very few features (i.e. only includes basic HTML editing). HTMLAREA http://www.iautomated.com/ Pros: Free (Lite) Version. Cross Platform. Cons: Interface needs some work (i.e. bulky and clumsy); missing some of the features. Pay version is not particularly cheap. Not cross-browser (IE only). ActiveEdit http://www.cfdev.com/ Pros: Cross-platform and Inexpensive. Integration with some other products from the same company like ActiveScan. Cons: Interface needs a little work (i.e. a little clumsy and can't be embedded into a page) and it's missing a couple features (e.g. dictionary), most of which are coming out in the next version. It is not cross-browser (IE only). eWebEdit http://www.ektron.com/ Pros: Nice interface with all the features. Cross-browser and Spectra-ready. Cons: Really (really) high price tag (Although according to their sales rep they haven't figured out their pricing yet so this may change). Not cross-platform (Windows only). Hope this helps. /excerpt -Original Message- From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:58 AM To: CF-Talk Subject: CF_Activedit alternatives?? Hi all! I´ve been using the CF_Activeedit custom tag for some time now but i´ll like to know about other similar tags i could use as well. I´ve found out that it doesn´t work properly with one of our Mac machines for some reason (??). Does anybody know of any other tag that also allows text edition (even if it´s only basic edition functionality)? TIA ! Paco Montes Spain on Line ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE Delete then WRITE issue....
Sorry I did not elaborate before. NT 4.0 SP 5, CF 4.0, IIS 4.0.
We guessed correctly. :)
The Application is Deleting a file if it exists and then writes the file
FRESH. Then gives the user a link to the CSV file. After that, the user
can download it, save it, or click another link to regenerate the file.
It
seems to be happening when the user has OPENed the file and then decides
to
generate another file that this error occurs.
Again, I don't see why there would be a difference between opening and
saving the file. Both those operations occur on the client side, not the
server side.
Like I said before, I can then delete the file when they decide to
generate
another file, but when I try to WRITE the new file, within seconds of the
first being deleted, that is when I run into what appears to be a file
header of a 500 bytes and it will not let me write it, access denied.
The 500 byte file that you see is a placeholder of sorts. It exists for up
to 30 seconds (the default ObjectCacheTTL).
Unfortunately, you will have to adjust your logic to get this application
working properly under IIS. Although I like the concept (and for the most
part, the implementation) of the cache scavenger, it does add a couple steps
to application design in situations such as these.
What I would do is the following:
1) Create a directory that holds all the CSV files and only CSV files.
2) When the user requests the page that creates the CSV file, CFDIRECTORY
the CSV directory and delete anything older than 1 hour or so.
3) Create your new CSV file with a unique name (either the CreateUUID()
function or the RandRange() functions should work fine).
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
"Benjamin S.
Rogers" To: CF-Talk
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: RE: CFFILE Delete then
WRITE issue
01/09/01
11:57 AM
Please
respond to
cf-talk
See my last post for the technical explanations.
If I'm guessing correctly, you are running an NT server with IIS? On the
first page of your application you create a file that the user can then
download? With some subsequent page request, you then delete the file?
However, the file still appears to be in the folder tree and a new one with
the same name cannot be written for some period of time.
If this is the case, then it should not make any difference whether or not
the user is "opening" or "saving" the file. What your probably experiencing
is just the coincidental timing of your requests and the cache scavenger. I
would recommend naming the files uniquely and running your own separate
scheduled task that deletes files nightly that are older than so many
hours.
If this is not the case, then you really need to give us a better idea of
what OS, Web server, version of ColdFusion, etc. you are running, as well
as
the logic behind the application.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 12:43 PM
To: CF-Talk
Subject: RE: CFFILE Delete then WRITE issue
This is great help and I appreciate all this feedback.
Is there an answer to my second question... I think this is an issue if
someone tries to OPEN the file instead of SAVING it. So the second
question is is there a way to force someone to DOWNLOAD the file instead of
opening it?
This would also help me.
Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729
"Benjamin S.
Rogers" To: CF-Talk
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: RE: CFFILE Delete
then
WRITE issue
01/09/01
11:24 AM
Please
respond to
cf-talk
Keep in mind that though this eliminates most problems, the issue will
still persist. The best way to solve the problem is to use the CFLOCK tag.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 12:09 PM
To: CF-Talk
Subject: Re:CFFILE Delete then WRITE issue
You are encountering file locking errors. The write is trying to begin
before the delete has released it's lock on the file. When writing and
deleting, I always rename the file first, then delete the renamed file.
Same for the write. Write to a temp file, then once the write is complete,
rename that to it's proper name.
Chris
RE: CFFILE Delete then WRITE issue....
I see the merit to these suggestions. But, unfortunately this only works
around the problem and does not fix it.
The files are remaining for what looks like about 1 to 2 hours.
Then someone has already been playing in the registry? Take a look at what
the following key is set to:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\InetInfo\Parameters\Obj
ectCacheTTL
Here's what Micorsoft has to say about the ObjectCacheTTL:
"This changes the frequency with which the cache scavenger runs. If your
content fits in memory and is largely static, you may even disable the
scavenger by setting it to 0x.
A high ObjectCacheTTL works best for sites with a small number of "popular"
files. If the number of frequently requested files is large, a high
ObjectCacheTTL may not help. Setting this entry high tells IIS to try to
keep unused files open longer. This is useful if you expect these files to
be reused within the TTL period. If you do not expect the files to be reused
often, or the system appears low on resources, use a lower ObjectCacheTTL to
conserve resources. You can also use OpenFileInCache to limit the number of
files IIS will keep open."
There is CSV directory already and all it holds are the 2 CSV's that can
be
created. The problem with giving them unique names, is that then we would
need to educate the user community on how to import that CSV since the
program they have is looking for a specific name. Therefore we were
trying
to keep it the same name that the application will be looking for.
Is it necessary to delete the file then? Can you just overwrite it? This is
probably the simplest solution of all. I sort of got distracted in the whole
IIS caching thing and forgot to ask whether or not your are able to simply
overwrite the file and whether or not this method works for you?
Again, these are great suggestions, but I want to know if this can be
fixed.
This is the nature of the beast. Besides all the various work arounds and
alternative methods I've thrown out, I don't know of a way to disable all
caching performed by the Web server. Perhaps Microsoft's Knowledge Base or
Deja News would provide better answers to these questions.
Is there a way to FORCE download and not give an option to OPEN?
Again, No, and I do not see how this could affect a file on the server since
it is a client side action.
Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
"Benjamin S.
Rogers" To: CF-Talk
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: RE: CFFILE Delete then
WRITE issue
01/09/01
12:54 PM
Please
respond to
cf-talk
Sorry I did not elaborate before. NT 4.0 SP 5, CF 4.0, IIS 4.0.
We guessed correctly. :)
The Application is Deleting a file if it exists and then writes the file
FRESH. Then gives the user a link to the CSV file. After that, the user
can download it, save it, or click another link to regenerate the file.
It
seems to be happening when the user has OPENed the file and then decides
to
generate another file that this error occurs.
Again, I don't see why there would be a difference between opening and
saving the file. Both those operations occur on the client side, not the
server side.
Like I said before, I can then delete the file when they decide to
generate
another file, but when I try to WRITE the new file, within seconds of the
first being deleted, that is when I run into what appears to be a file
header of a 500 bytes and it will not let me write it, access denied.
The 500 byte file that you see is a placeholder of sorts. It exists for up
to 30 seconds (the default ObjectCacheTTL).
Unfortunately, you will have to adjust your logic to get this application
working properly under IIS. Although I like the concept (and for the most
part, the implementation) of the cache scavenger, it does add a couple
steps
to application design in situations such as these.
What I would do is the following:
1) Create a directory that holds all the CSV files and only CSV files.
2) When the user requests the page that creates the CSV file, CFDIRECTORY
the CSV directory and delete anything older than 1 hour or so.
3) Create your new CSV file with a unique name (either the CreateUUID()
function or the RandRange() functions should work fine).
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
"Benjamin S.
Rogers" To: CF-Talk
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: RE: CFFILE Delete
then
WRIT
RE: CF_Activedit alternatives??
That may be true but considering that there are few number of people that will actually be doing the editing and they only have to download the plug-in once, its not that bad. When you edit a second time it's blazing fast. The benefits far outweigh the time to download. It just requires instilling some confidence and security to the client on your part. Usually what I do is sit down at the client's computer and show them what happens while explaining this is only done once. After it's loaded I let the client sit down and let them start playing with it and their 'wonderment' and excitement quickly replace any fears of the initial download. -Sold- Give it a try with them and see if that helps. Some developers work in environments and with companies that are far too large and distributed to sit down and coddle all of the clients/employees. For me, the biggest issue with eWebEdit is the pricing model or lack there of. We inquired with them several times about purchasing many licenses but their fees were fairly exorbitant and, though they informed us they were undergoing a pricing change, we never received that information. In the mean time, several cheaper (free) alternatives have shown up. eWebEdit still has an advantage as far as the Spectra integration goes, but then the new Spectra has fixed the problems and functionality of it's own WYSIWYG HTML editor. What does eWebEdit offer that the ActiveEdit doesn't? Of course, we've actually decided to go with ezEdit because all we really cared about (besides the HTML Editor) was the custom tag and source code availability. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Sincerely, Rob Sherman Allaire Certified Developer Instructor CFDude, Inc. http://www.cfdude.com CF_Office (310) 543-1622 CF_Fax (310) 543-0512 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SESSION Timing out WAY before it's supposed to.
CFAPPLICATION name="TRR_ADMIN" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout="#CreateTimeSpan(0,12,00,0)#" Joshua, Remove the double-quotes from the sessiontimeout parameter. That's burned me more than once. :) (And make that double-zero a single zero.) There is nothing wrong with double quotes. That is the "proper" way to code ColdFusion. The following code is not preferable because Allaire may drop or change support for this syntax: CFAPPLICATION name="TRR_ADMIN" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout=#CreateTimeSpan(0,12,0,0)# In any case, right now they both mean the same thing so this is not the problem. What is the maximum session timeout for the server? This is set in the ColdFusion Administrator. I believe the default is 20 minutes. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SESSION Timing out WAY before it's supposed to.
What is the maximum session timeout for the server? Heh, just read the entire original message. :P The double zero looks suspicious. Have you tried that as a single zero yet? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 6:03 PM To: CF-Talk Subject: RE: SESSION Timing out WAY before it's supposed to. CFAPPLICATION name="TRR_ADMIN" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout="#CreateTimeSpan(0,12,00,0)#" Joshua, Remove the double-quotes from the sessiontimeout parameter. That's burned me more than once. :) (And make that double-zero a single zero.) There is nothing wrong with double quotes. That is the "proper" way to code ColdFusion. The following code is not preferable because Allaire may drop or change support for this syntax: CFAPPLICATION name="TRR_ADMIN" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout=#CreateTimeSpan(0,12,0,0)# In any case, right now they both mean the same thing so this is not the problem. What is the maximum session timeout for the server? This is set in the ColdFusion Administrator. I believe the default is 20 minutes. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datasource question
The hostname is actually the datasource name. This is usually chosen by the hosting company so you will need to contact them and ask them what the datasource name is. You will also want to check and verify that you are using username and password. In any case when you've figured it out, your CFQUERY tag will look something like this: cfset Username="MyUsername" cfset Password="PaSsw0rD" cfset Datasource="MyDatasourceName" cfquery name="members" datasource"#Datasource#" username="#Username#" password="#Password#" /cfquery Some ColdFusion hosts will set it up in a manner that you will not need to provide the username/password in each of your CFQUERY tags. This is dependent on the ColdFusion host so you should check with them to see if this is the case. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 07, 2001 12:29 AM To: CF-Talk Subject: datasource question I am new to coldfusion and have my site internetcraftfair.com that doesn't have coldfusion on the server. The sister of my server has coldfusion and has been kind enough to set me up a temporary location so I can code some pages for possible employment. Well I have coded the page and sent it up to the sister server but I am not sure how to point it to access my database on my site's server. I have been using perl to connect to my database on my site with DBI and I make a database string that I send to the server in a variable. I have tried to form a database type of string with the CFSET functions setting the username, password, and hostname. I am not sure of the syntax of it though or if I am suppose to use my site "internetcraftfair.com" as the host or the server "topchoice.com". To access my database on my server through telenet my root folder on internetcraftfair.com is client/home/internetcraftfair and then I type in mysql to access the database and send my username and password in to access it. cfset username="name" cfset password="password" cfset hostname="???" should this be internetcraftfair.com or do I need to specify my root directory ? cfquery name="members" datasource" #hostname#,internetcraftfair,#name#,#password#" do I use commas or colons in this string? I am having a hard time accessing the temp folder on the web and hope to hear back from radiant in the morning so I can view my code on the web. I would appreciate any help on this you can suggest. Thanks-- Shelly Hill http://www.internetcraftfair.com "All our dreams can come true - if we have the courage to pursue them" -Walt Disney ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
And what makes Java less proprietary than C++? Last I heard, Sun pulled it from the standards committee. Suggesting that Java would be opened up, was one maneuver in Sun's marketing campaign to regain market share lost to Open Source alternatives to their products: http://www.wired.com/news/topstories/0,1287,19413,00.html In fact, if the language that your application server was written in had anything to do with the "openness" of the application server, being written in C++ would make ColdFusion far more open. But, of course, the language the server is written in has little to nothing to do with the openness of the server itself. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:59 AM To: CF-Talk Subject: RE: Slightly OT: CF in Europe Well this is a completely subjective view but my perception is that CF is considered quite a hot technology here in the UK. I don't know, but I believe the relative strength of CF versus ASP is stronger in the US than in Europe because a lot of people in the US started building web apps before ASP came out or was usable. By the time the UK got started, ASP was a viable option, and no-one ever got fired for buying Microsoft products, as they used to say of IBM. Allaire's reputation for quality doesn't seem to be perfect, but then neither is Microsoft's. Maybe PHP is popular in Europe because it was invented here is largely developed here. But I think decent-sized organisations here tend to steer clear of open source - Apache being something of an exception. They don't trust it. They also like standards. I think that's CF's weakest point from a marketing point of view is that it's seen as a proprietary, closed solution. I believe CF's move to Java will be a big help in this respect. I worked for one company that moved from PHP to Java because they saw Java as a standard. When they find out how complicated Java systems can be, maybe they'll be in the market for a rapid web app development tool based on the Java platform Nick -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 7:05 PM To: CF-Talk Subject: Slightly OT: CF in Europe Even though we just touched the subject in another thread i'd like to start a new one where we "air" our thoughts on the future of CF in Europe since it seems like CF is a "failure" so far over there! The reason being that i'm probably moving back to Europe soon and i would really hate to switch over to ASP/PHP. Allan Pichler Machine Dreams Inc. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query confusion - CF not recognising query name
It looks like your code has been greatly excerpted. There is no chance that you are setting the variable getPeopleInfo equal to some simple value and overwriting the query somewhere between the query and the loop? Is the name of the query dynamic? Sorry for the questions, but it seems very unlikely that ColdFusion would behave this way. Any additional information would be useful. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 1:49 PM To: CF-Talk Subject: Query confusion - CF not recognising query name I've got some code running which SHOULD work, but isn't, and is confusing the hell out of me Here's the code; cfquery name="getPeopleInfo" datasource="People" blockfactor=100 select ID from #variables.peopleTable# (nolock) where ID in (#variables.IDList#) and #PreserveSingleQuotes(variables.whereList)# order by #form.OrderBy# /cfquery cfset variables.IDCount=getPeopleInfo.RecordCount Here's the error; An error occurred while evaluating the expression: variables.IDCount=getPeopleInfo.RecordCount Error near line 527, column 8. Error resolving parameter GETPEOPLEINFO.RECORDCOUNT ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. I've tried putting a CFLoop straight after the query and it comes back that the query doesn't exist - but I know it does (obviously) It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF vs. Lotus Domino App Server
BLOB? That's a new acronym for me. http://whatis.techtarget.com/WhatIs_Search_Results_Exact/1,282033,,00.html?q uery=blob Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing images in SQL
It's probably pretty clear to most people what is going on when just a reference to the image (/directory/name.img) is stored in the database so I'll just discuss what additional overhead is incurred when the entire image is stored in the database. When you store the actual image in the database, the request from the client for the image that would normally get handled relatively speedily and efficiently by the Web server and file system (after all that is what they are designed for) is actually passed off to ColdFusion. This ties up one additional thread on the ColdFusion server for each image being processed. You only get so many threads: usually 5 times the number of processors. If you had a single CPU server, you could tie up all the available threads with one page that had five images on it. ColdFusion then makes a query to the database which is usually on a different server. This takes network resources, from the NICs to the bandwidth utilized to transfer the query and return the image data. If the database is not on a separate server (which is not generally a good idea because, among other things, you are tying up CPU cycles on your Web server) then you still incur the overhead of processing the request, finding the data in the database and passing this back the ColdFusion application server all via ODBC, OLE etc. On the database's end of things, RDBMSs usually store BLOB (Binary Large Object) data relatively poorly since most RDBMSs store information in 2k extents and 8k pages. What in effect happens is the RDBMS stores the image elsewhere in the database and places a pointer where you would logically expect the image data. This is also true for the TEXT datatype. When the RDBMS goes to return the data, it has to "hunt" the image in a separate spot. In any case, you've added quite a bit more overhead to the Web server, the database server, and the network. You've also increase the amount of time it takes to process the request, making you site appear slower to outside users. Some users may have special requirements that necessitate storing the images in the database, but, in most situations, the gain is little to nothing. There are a lot of other smaller issues, such as the way ColdFusion handles binary data and how that data is transferred between the database server and the ColdFusion application server, but hopefully the above description will give you a general idea of why developers always caution against storing image data directly in the database. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:40 PM To: CF-Talk Subject: RE: Storing images in SQL Larry, I've asked this question before also. And got similar responses as yours which is appreciated. But is there any way you could tell us (a number of people have asked this question) why it's slower and messier. I'm sure for somebody that knows the details on what it takes to do this can logically agree with you (and others who have said the same) and I too would like to be one of those well informed people that come to the same conclusion for the same reasons. Could you or anyone else familiar with the techniques required for this please elaborate on this so I can say something other than "it's a bad idea because that's what somebody said." Thanks, Rick -Original Message- From: Larry C. Lyons [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 3:28 PM To: CF-Talk Subject: Re: Storing images in SQL Michael, In a nutshell don't. Its far faster, easier and a lot less messy to store the images's name and then dynamically construct the path information. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Michael Buffington wrote: Does anyone have any experience storing images in SQL 7.0, and retrieving them in CF? Any tips would help! Michael Buffington ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: line breaks in cfmail
Correct. I ran into a problem with a mail server being maintained by a system admin at a sister company. Under certain conditions, his qmail server would strip CR/LFs into bare LFs. At which point, qmail would then reject the mail because it contained bare LFs, when in fact, bare LFs are legal in the body of the message, just not in the headers. As a workaround, you have to start qmail with a switch that tells it to accept messages with bare LFs. Of course, that was almost a year ago now. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: lsellers [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 12:34 AM To: CF-Talk Subject: RE: line breaks in cfmail Also, Some mail servers like qmail have a nasty habit of strip CR/LF pairs into bare LFs. At which point, the client you are using may not be savvy Evil, considering that's illegal under every RFC I've read. :) --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT
Allaire is US centric, from their technical support offerings to their lack of Unicode support. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 5:16 AM To: CF-Talk Subject: RE: Slightly OT That's actually a very interesting point to bring up It seems that almost all european countries uses php/asp whereas over here the market has room for all of the scripting languages is it the price for a license that scares companies in europe ?? Allan Pichler Machine Dreams Inc. -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 2:07 AM To: CF-Talk Subject: RE: Slightly OT Do UUnet have a CF hosting service? Jason, any ISP that allows dedicated servers (if thats what you require) will host CF. The only problem you may come across is in the use of RDS which some ISP's do not allow. Another problem is trying to find a shared server with CF support in the UK because I can't help thinking that CF just hasn't had the same impact this side of the atlantic. -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: 05 January 2001 10:05 To: CF-Talk Subject: RE: Slightly OT UUNET, there not cheap but their support is good, sites are fast. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: vrijdag 5 januari 2001 11:00 To: CF-Talk Subject: Slightly OT Hi All, Can anyone suggest an ISP (Perferably in the UK) that can host Cold fusion sites. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Those Pesky Pound Signs
You have to double them up or use the Chr() function. The pound sign always has to be escaped in a CFML page. The only times you don't have to worry about it is when your reading it from a file or a field in a database (i.e. some external source that is not evaluated as CFML). Anyway, to answer your question, here's a few examples. ex: cfset Attributes.Calendar = Replace(form.calendar, "tr", "tr bgcolor=##bgcolor## align=center", "ALL") ex: cfset Attributes.Calendar = Replace(form.calendar, "tr", "tr bgcolor=#Chr(35)##Chr(35)##Chr(35)#bgcolor#Chr(35)# align=center", "ALL") Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 2:52 PM To: CF-Talk Subject: Those Pesky Pound Signs OK, I've got a bunch of HTML I've got to parse through and create a new page of CFML/HTML that will then be fed into a CF app that creates a series of new HTML pages. Basically, I'm taking a plain HTML calendar and converting it to something that I can then have CF convert it into code with different colored table cells based on the color scheme of the page it will go on. As you know, if you need to use pound signs within a CFOUTPUT, you need to escape it, thusly: cfoutputbgcolor=##FFCCFF /cfoutput So I tried this REPLACE string: cfset attributes.calendar="#Replace(form.calendar, "tr", "tr bgcolor=###bgcolor# align=center", "ALL")#" But those CF wants to keep trying to interpret those pound signs around the BGCOLOR. I thought since they're in quotes, as a string, they wouldn't be read by the CF engine, but that doesn't seem to be the case. (the ###BGColor# gives me in the end, #FFCCFF in my final app). How do I get CF to read those pound signs as a simple string within my replace function? I've tried DE, HTMLEditFormat, etc. I've tried a bunch of other things ... basically every hairball idea I could pull out of my head. Nothing works. Any suggestions? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT
ColdFusion 6 will by virtue of it's complete rewrite in Java which supports Unicode. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 10:23 AM To: CF-Talk Subject: Re: Slightly OT I believe either CF 5.0 or CF 6.0 are supposed to have full Unicode support. Both are supposed to be released during 2001. Dave - Original Message - From: "Benjamin S. Rogers" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 05, 2001 10:09 AM Subject: RE: Slightly OT Allaire is US centric, from their technical support offerings to their lack of Unicode support. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 5:16 AM To: CF-Talk Subject: RE: Slightly OT That's actually a very interesting point to bring up It seems that almost all european countries uses php/asp whereas over here the market has room for all of the scripting languages is it the price for a license that scares companies in europe ?? Allan Pichler Machine Dreams Inc. -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 2:07 AM To: CF-Talk Subject: RE: Slightly OT Do UUnet have a CF hosting service? Jason, any ISP that allows dedicated servers (if thats what you require) will host CF. The only problem you may come across is in the use of RDS which some ISP's do not allow. Another problem is trying to find a shared server with CF support in the UK because I can't help thinking that CF just hasn't had the same impact this side of the atlantic. -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: 05 January 2001 10:05 To: CF-Talk Subject: RE: Slightly OT UUNET, there not cheap but their support is good, sites are fast. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: vrijdag 5 januari 2001 11:00 To: CF-Talk Subject: Slightly OT Hi All, Can anyone suggest an ISP (Perferably in the UK) that can host Cold fusion sites. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: line breaks in cfmail
What platform are you developing on (e.g. Mac, Windows, Unix, etc.). Is the ColdFusion Server on Windows or Unix? What mail server is ColdFusion relaying mail off of? What mail clients are having difficulty displaying the mail properly? Perhaps the client you are developing on is only placing carriage returns or line feeds at the end of each line and the OS expects both or the opposite. Also, Some mail servers like qmail have a nasty habit of strip CR/LF pairs into bare LFs. At which point, the client you are using may not be savvy enough to render the page correctly (like the difference between opening up a document created on a Unix system using Edit as opposed to an early version of notepad). There could be quite a few possible explanations for this. To troubleshoot, you may want to try relaying mail off a different mail server and viewing the mail from a different client. If neither of these fixes the problem, you could try the following code: cfmail Email Address: #form.email##Chr(13)##Chr(10)#Business Name: #form.businessname# /cfmail That will place a CR/LF pair at the end of the e-mail address. If this fixes the problem, then you may want to switch your IDE (or switch the way your IDE handles end of line ASCII characters). If your still having problems, please post back the answers to some of these questions as well as the results of these test. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 10:23 AM To: CF-Talk Subject: line breaks in cfmail Hey all, I have this ongoing problem with line breaks not being respecting when formatting my email bodies using the cfmail tag. For example something like this: cfmail Email Address: #form.email# Business Name: #form.businessname# /cfmail Is showing up like this when sent: Email Address: #form.email# Business Name: #form.businessname# Any suggestions? Thx! Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Request VS Application scope
The reason why locking is visible to the developer is because it is much more efficient if the person writing the code, who knows how the application should work, decides where to lock and more importantly what type of lock to use. If the ColdFusion server had to decide whether to use a ReadOnly or Exclusive lock, there would be enormous performance degradation. It is much more efficient if the programmer tells the server which type of lock to use. It's the same thing as telling the server which scope a variable is in, instead of having the CF Server go through the variable scope hierarchy. This is incorrect. ColdFusion should handle all locking internally except transactional locking. I have yet to see a reason (aside from developer laziness) that an exclusive lock should not occur when a session variable is being written or a read lock should occur when a session variable is being read. A much better analogy is that of the RDBMSs we all know and love. In those environments, locking is handled by the application. If the developer needs to combine a series of commands into a single lock (a.k.a. a transaction), then that option is available to the developer. Unlocked commands can cause dirty data at best and system instability at worst. I don't see why this would be the default behavior of ColdFusion as opposed to locking all commands except where the developer chooses to override this to ensure transactional integrity. I've argued this point before, both on this list and elsewhere. I maintain that the issues with CFLOCK are the result of asking a single threaded application server to behave as a multithreaded application server. Rather than rewrite the portions of the ColdFusion server that did not behave properly in a multithreaded environment, they have shuffled off this responsibility to ColdFusion developers. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: SNMP Tag?]
Easier said than done. :) We recently played with MRTG and some of the
extensions that are part of the distribution.
It was easy enough to get MRTG up and running: we had it monitoring the
throughput on one of our Cisco routers and dumping the data to the RRDTool.
However, we wanted to monitor bandwidth utilization by IP address using
Cisco's IP Accounting. We never did get that working properly. This despite
the fact that several MRTG extensions (hacks) distributed with MRTG that
supposedly handle this.
I think this is because the current incarnation of MRTG (even using the
RRDTool) is not very extensible. However, I think this is mostly due to
complexity of SNMP itself (yeah, I know what the acronym stands for :). It
didn't help that we have no good Perl programmers on staff.
To make a long story short, if you are not very knowledgeable about SNMP and
don't have a terrible amount of time to devote to it, I wouldn't try to
adapt MRTG to whatever you are going to do. If you don't know Perl, skip it
all together.
I am interested in Lewis Sellers' CFX_TCPClient. I wonder if one couldn't
write an SNMP wrapper in the form of a CFML tag. Of course, a fairly good
working knowledge of SNMP would still be required.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 29, 2000 12:31 PM
To: CF-Talk
Subject: Re: [RE: SNMP Tag?]
http://www.mrtg.org
[EMAIL PROTECTED] (lsellers) wrote:
Is anyone aware of a CF tag that can communicate with an SNMP enabled
service? I really just need basic read-only capability for device
monitoring, such as reading traffic throughput from a router or switch, or
retrieving performance metrics from some other services.
Well, assuming they are set up for tcp, you can use TCPClient.
http://www.intrafoundation.com/freeware.html
If know of a couple people that have used the original cfx version to chat
with their cisco routers from cf (sh line, etc).
There's a brand new version I wrote last month that's a c++ com object as
well. Much nicer to use. (The Second Edition).
No specific SNMP, etc examples though but routers are usually telnetable
something like:
CFOBJECT
ACTION=CREATE
NAME=obj
CLASS=Intrafoundation.TCPClient
cfset c=obj.Open("router.allaire.com,"23")
CFINCLUDE TEMPLATE="obj.mod.cfm"
CFIF c IS "1"
cfset obj.timeout=3.0
cfset obj.SendRN("tcpclient")
cfset page=obj.Recv()
cfoutputpre#HTMLCodeFormat(page)#/pre/cfoutputbr
cfset obj.SendRN("sh line")
cfset page=obj.Recv()
cfoutputpre#HTMLCodeFormat(page)#/pre/cfoutputbr
CFINCLUDE TEMPLATE="obj.mod.cfm"
cfset obj.Close()
/CFIF
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MOD math function?
cfif 40 MOD 4 !--- Has remainder - evaluates to some --- positive numeric value (a.k.a. TRUE) --- cfelse !--- Does not have a remainder - evaluates --- to 0 (a.k.a. FALSE) --- /cfif -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 2:27 PM To: CF-Talk Subject: MOD math function? Maybe I should have paid attention in math, but here is my problem. I have 2 numbers, for example 40 and 4. All I need to do is find out if (40 / 4) has a remainder. For some reason, (40 MOD 4) does not seem to be working. jon ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox
Amen to that, i have been using fusebox for a while now, and my opinion is that it is another layer of stuff on top of what you already have to do. When you get down to it, any methodology is just "another layer of stuff." Fundamentally, however, a methodology is an attempt to superimpose an order or structure to code. Although it would be nice if a methodology decreased the amount of work a single developer had to perform to code a given application, a methodology usually has some loftier goals such as synchronizing disparate developers on the same team, quality assurance, code documentation, etc. It's been my experience that the larger the project, the better Fusebox is at accomplishing these goals. If, however, you are simply adding a guest book to a relatively static site, then Fusebox would add quite a bit of overhead and development time while gaining the developer very little, short term or long. I think i would p[ersonally tone down the fusebox methodology myself, it needs to be alot less complicated to trully be a catch all solution. Many people, myself included, have adopted pieces of the Fusebox methodology. How much you adopt, if any at all, is up to you. When the fuse breaks its maddening, and is just another layer to run through to fix stuff. Debugging a Fusebox application takes a little getting use to (like an hour :), but I prefer it to other attempts I've seen which try and make the best use of code through reuse. A Fusebox application has one entry point and one exit point. All the developer has to do is trace the path of the FuseAction. The only time I really run into problems is when I have several included query templates in a row and I get a cryptic ODBC error message and a ColdFusion "Problem occurred in tag CFQUERY at or around line 1" Then it takes the extra step of aborting processing of the page a couple times to determine which query is in error. And i don't buy the whole makes it easier to bring in other programmers, because almost all of them will have to learn fusebox and the particular way its used where they are working. I don't think you're being asked to buy anything. :) We require that our programmers be familiar with Fusebox and to be able to code in a manner similar to Fusebox. The same was true at the last place I worked where I was head of production. This is, of course, not a requirement to getting hired, nor do we code all our applications in this methodology. But we have found that it works very well on larger projects with several different specialized developers and teams working on dedicated tasks. With many a notable exception, most programmers/designers/DBAs I've met and worked with seem to like the style, which is always a bonus. But of course, this is a highly subjective generalization. :) I still like the idea of a methodology, im just not sold on fusebox As someone already noted, it is not necessary to like or "buy" fusebox, but it is necessary to choose a methodology. Even if your methodology changes from project to project (and hopefully it will evolve), routinely dealing with reoccurring problems in the same manner and being able to expedite the daily chores of programming is essential. In regards to Fusebox, it doesn't hurt that some very talented and experienced ColdFusion programmers have tackled these issues already. That, to me, is one of the greatest benefits of Fusebox. Although we don't need many aspects of the Fusebox standard, they already exist and are freely available for us to implement when and if we do need them. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Transactions
Correct. Kind of cool, isn't it. :) Actually, it's all done on the SQL side. CFTRANSACTION is just a way of wrapping it all up with ColdFusion logic and processing. If you want to know more about what is actually going on, or you would prefer a pure SQL solution, have a look at the BEGIN|COMMIT TRANS[ACTION] statements. However, I'd recommend just using the CFTRANSACTION statement because it works very well and is extremely easy to implement. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 26, 2000 11:44 AM To: CF-Talk Subject: CF Transactions If you wrap a CF transaction around two CFQUERY's, one being an INSERT and the NEXT being an UPDATE, if there is an error in the UPDATE, will it actually roll back the INSERT? Thanks, Scott ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re: The +.htr bug strikes again
Mike, This may be one of the most ignorant statements I've seen posted to a list in awhile. I use the word "ignorant," first, because of the ill-conceived attack on Dave Watts, who has been contributing to this list (and the ColdFusion community at large) for some time. Although I'm sure Dave doesn't care, I would think an apology is in order. Second, I believe your statement was bred of ignorance if you think the destructive behavior of solitary script kiddies executing precompiled executables against distant servers is necessarily predisposed to becoming the skilled programmers that you would like to work with: a good part of what it takes to be on a team is trust and good natured comradery, things the script kiddies are more times than not lacking. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 26, 2000 1:26 PM To: CF-Talk Subject: re: Re: The +.htr bug strikes again I for one appreciate the heads up, not everyone considers people on this list to be script kiddies !! we are all developers here and we don't need mr Watts to baby sit us. on the topic of script kiddies, there is another side to that, there is the annoying older internet worker who looks at everything like a lawyer and put disclaimers on everything and want to protect us from ourselves. Gimme the script kiddies anyday, script kiddies grow up to be internet workers and innovators, annoying legally minded (old )programmers are just plain dull ** Original Subject: Re: The +.htr bug strikes again ** Original Sender: "Kevin Schmidt" [EMAIL PROTECTED] ** Original Date: Fri, 22 Dec 2000 14:21:39 -0500 ** Original Message follows... Ok. I can see that my piece of information, that I intended to be totally harmless, has caused quite a stir. From now on I will keep my mouth shut. The only reason I let people on the list know is because the site uses CF and there had been alot of discussion on the topic over the past few day. Several people didn't even know the bug existed. I told the sites administrators about the problem and I don't know if they have fixed it yet or not. Maybe they don't care or maybe they do. There have been other sites metioned in this thread that have the same problem. People disclosed the information to warn consumers of the problem and to choose someone else to provide the service that the said company provided because the company hadn't fixed the issue. Some people on the list don't think mentioning these types of issues is a problem, others do. I am stepping of my soapbox now. If anyone has questions about the +.htr issue i'll be happy to entertain them. There have also been numerous posts with URL's to the patch posted to the list. Happy Holiday's Kevin Schmidt, Web Technology Manager Allaire Certified Cold Fusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com - Original Message -From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 22, 2000 12:04 PM Subject: RE: The +.htr bug strikes again There are two sides to this issue. 1. Releasing bug/vulnerability information to the public will release hoards of script kiddies to cause havoc and dismay instantaniously without recourse. 2. Releasing bug/vulnerability information will cause industry leaders like Microsoft and respectively Allaire to act on the information sooner than later. I can see both sides of the fence but would lean to alerting the public to the problem. Security by obscurity is not a good policy to live by. While I agree with this as far as product vendors are concerned, that's not what's going on here. It's one thing to release general information about vulnerabilities in MS products to the public (although even within the security community, there's quite a bit of debate over whether and how this should be done - should the vendor be notified privately first, how long between vendor notification and public release, etc.). It's another thing to release specific information about who hasn't patched their installations of vendor products, which is what's going on here - "so-and-so is vulnerable to the .htr bug". This doesn't have any place within either side of the issue that you're talking about, and is pretty irresponsible in my opinion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.c
RE: Fusebox
Although Fusebox is probably the most popular (and best documented) publicly available methodology for coding ColdFusion, there are several other (arguably better) methods available. Two of these include CFObjects (http://www.cfobjects.com/) and SmartObjects (http://www.smart-objects.com/). There are also some other methodologies which very in degree of structure: Black Box (http://www.black-box.org/) relies on a single tag to tie together disparate ColdFusion templates. On the other side of the spectrum, Switch_Box (http://www.switch-box.org/) is a fairly complex methodology that requires setting up special extensions on the ColdFusion Server. Some developers, who feel constrained working in a methodology, prefer working in a framework. A couple examples of ColdFusion frameworks include iiFramework (http://www.iiframework.com/) and even Spectra (http://www.allaire.com). However, both of these are commercial software. Actually, I can't think of a public or open source ColdFusion framework off the top of my head...something for the community to think about at any rate. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 4:47 AM To: CF-Talk Subject: RE: Fusebox Jeff, You keep on going on about other methodologies. Which particular other methodologies using CF are publicly available? You keep mentioning all these other methodologies, but can we at least compare them to Fusebox? Fusebox is probably one of the best methodologies (if not the only public methodology) available for a ColdFusion developer. The book also covers a number of fundemental design elements that any CF'er should understand. EVEN if they don't do Fusebox. Adam -Original Message- From: Jeffry Houser [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:47 PM To: CF-Talk Subject:Re: Fusebox "Warrick, Mark" wrote: The fusebox methodology has many benefits, and I really don't think it adds any time to the development cycle. In fact, I'm pretty sure it helps speed up development. Well, that has nothing to do w/ Fusebox. Any programming methodology will offer this benefit. The key is having one in place and sticking to it. One of the greatest advantages of the style is that you can modularize you code, and in doing so, you can assign pieces of your application to various developers without worrying about them stepping on each other's toes. See above. This is not unique to fusebox. Another advantage is that certain companies (such as mine) require it. So if you don't do it, you're not going to get a job with certain companies. If you are not a consultant, that is complete hogwash, I think. Especially with today's job market. Fusebox (or whatever methodology the company uses) should be more than willing to train on the methodology. If you already know the language (What company doesn't have enough trouble finding people who know the language?), learning the coding practices should be easy enough. I did one job, where the first thing they did was sit me down and outline the coding practices. It took about a half hour sitting down with the lead developer. I took notes, and then followed them. No problems. Lastly, it's very simple to follow the programming flow of a fusebox app. When something goes wrong, you simply search for the fuseaction in the index file and then you'll see right away all the templates in a single handy block that could be involved with the problem. As I said previously, any methodology worth its salt should offer this. If I don't know fusebox, then your app isn't going to be any easier to follow than some other unknown methodology. (It probably will be easier to follow than random coding, though) -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anonymous access failure in IIS NT4
Heh, it would seem that permissions are not set correctly as you are able to connect to the Web site using an account with administrator permissions. Perhaps you meant to say that the permissions were set as per the recommendations you've received so far? If that is the case, then you may want to double check what account IIS is in fact using. Are you running Web sites in their own memory space or not? Are these ColdFusion sites, HTML, etc.? Do your security logs tell you anything? Any additionally information would be helpful. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:50 PM To: CF-Talk Subject: RE: Anonymous access failure in IIS NT4 All permissions are set correctly. I still have the same problem though. Microsofts knowledge base isnt much use either. This is threatening to kill my weekend at this point :( Emmet -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 12:13 PM To: CF-Talk Subject: RE: Anonymous access failure in IIS NT4 If you are running Web sites in their own memory space, then the IWAM account for the machine (either in the domain SAM if your Web server is a domain control or on the local machine's SAM otherwise) needs read access to the Web site directories. If the Web sites are running in shared memory space, then the IUSR account needs read access. You may want to make sure that the SYSTEM account (or whatever account you run ColdFusion under) has at least read to the directories if these are ColdFusion sites. Judging by your description of the problem, however, this is probably not the problem. The only other accounts that should have permissions to files in the Web site directories are, of course, the administrative account, and those users who need special permissions for FTP, password protected web sites, etc. Do not give the Guest account or the Everyone group access. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:37 AM To: CF-Talk Subject: OT: Anonymous access failure in IIS NT4 I have a really screwed up problem. For some reason anyonymous access to all the sites on one of our servers has stopped and cannot be viewed on the net. Everything looks fine in IIS. If i switch anonymous access to an administrator account everything all the websites can be viewed, however FTP access for all users is still not working. Im running IIS 4 with service pack 6. Anyone experience a problem like this before? Emmet ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping Cart
The company I worked for used AbleCommerce 2x for some time. In general, we liked the product as it had most of the features clients want as well as some fairly easy to customize "wizards." We purchased the open source license with the 1 year subscription but the folks over at Able seemed to get sidetracked with their auction product and didn't release a major upgrade to AbleCommerce for over a year. They did, however, release many minor upgrades and the tech support staff was fantastic. The open source license was helpful in a few cases, however, the code base was immense (600+ templates), undocumented, and real spaghetti code. In addition, the databases tables were not as normalized as we would have liked. For the most part, it was better to leave the source code alone. The administration interface was not something you could turn over to the client. It was unintuitive and buggy (e.g. windows would pop open in the wrong frame, ask for a login every time a link was clicked, etc.). That was the biggest point of contention, actually, since we were looking to turn the maintenance of the site over to the client. Although AbleCommerce is billed as a consumer end product, it really takes a ColdFusion programmer with at least a rudimentary skill set to install and maintain AbleCommerce. It looks like the new version has been updated some. This one only runs on ColdFusion 4+, which is probably a good thing: much of the old code base could have been simplified just by bringing it up to speed with the latest versions of ColdFusion. Unfortunately, it looks like the price has increased (or rather doesn't decrease with the number of stores purchased). It's still affordable, but there are quite a few other canned ColdFusion (and not ColdFusion for that matter) shopping carts out there for much less money. If your boss has already chosen AbleCommerce, though, I wouldn't worry too much. Just try and stay out of the source as much as possible, and make use the AbleCommerce support staff. They're a good bunch. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Eric Homa [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 12:14 PM To: CF-Talk Subject: Re: Shopping Cart Looks like the boss wants to try Able Commerce. Anyone have any good or bad experiences with it? Any undocumented features (bugs) that I should know about? Thanks, Eric Homa compudigital.com -Original Message- From: Warrick, Mark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, December 19, 2000 2:34 PM Subject: RE: Shopping Cart AbleCommerce is a nice out-of-the-box solution. (http://www.ablecommerce.com) - It requires no ColdFusion knowledge to maintain. I haven't tried this one, but it's cheaper than AbleCommerce: http://www.cartease.com/ If you want to "roll your own" you might try this tutorial: http://hotwired.lycos.com/webmonkey/99/49/index4a.html?tw=programming I'm sure there's more. These just came off the top of my head. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Eric Homa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 9:44 AM To: CF-Talk Subject: Shopping Cart Can anyone recommend a shopping cart that is written in CF that can be integrated into our own code? Any shopping cart experiences, good and bad, would be welcome information. Thanks, Eric Homa compudigital.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape 6 out UGH!!!!
In case it helps anyone, this is the resource that I used to make my stuff work in N6 as well as the other two: Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mail Servers
Steve, The only way to prevent entry into the ORBS database is to restrict relay to your local network, either by IP address or by blocking the port, or to perform some sort of authentication such as SMTP AUTH or POP before SMTP. Do not think for one minute that your mail server is secure because it checks the validity of the account specified in the RCPTTO command. Most relay checkers, including those used by ORBS, check for this vulnerability. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: [OT] Mail Servers
Someone else on this list recommended VOPMail and I was simply pointing out that VOPMail has a known problem with RBL's that you might want to watch out for. As to why Vircom leaves that spam hole open, is probably a topic for off this list. Steve, Again, filtering by the RCPTO command is itself a whole. That is why Vircom has not pursued it. To everyone else, my apologies for perpetuating an off topic discussion, but inaccurate information like this can leave servers open, making relay possible. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Mail Servers
If a host receives 1,000,000 e-mails from a single host in a day, can't it be flagged as suspicious activity and rerouted to a temp account or dumped? Many mail servers are capable of this or some similar behavior. For instance, as you probably guessed by watching this thread :), our shop uses VOPmail (among other mail servers). VOPmail has a feature that forces the server to wait a period time in between each message over a certain number of legitimate or illegitimate messages from a single source. The delay is nice because it doesn't touch the mail and tie up resources on the VOPmail server. Instead, it places the burden on the sender (ostensibly the offending relay mail server). Although this is a nice feature for decreasing the amount of mail that accumulates through a dictionary attack, this is not good relay protection because it only take one piece to get through and get reported to the ORBS database. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 At 10:18 PM 11/13/00 -0500, you wrote: Our spam protection is basically not allowing any messages originating outside our network to be delivered to any domain not hosted on that VOPMail machine That spam protection won't help you if a spammer uses a dictionary list to send email. The most common type of spam right now is a dictionary attack on domains you host, not relaying to hosts you don't. meaning they will send hundreds of thousands of messages addressed like this [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] And so on. One host I know routinely gets upwards of a million emails a day addressed like this. This is the greatest single threat to ISP's today. Most servers can't handle this. - Steve -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 5:15 PM To: CF-Talk Subject: Re: Mail Servers Interesting. I'll see if we can contact Sylvain and get something done about that if it really is a confirmed spam hole. Our spam protection is basically not allowing any messages originating outside our network to be delivered to any domain not hosted on that VOPMail machine. Since this is configured by IP address, the "from" address really isn't an issue in our configuration. -Justin Scott - Original Message - From: "Steve Pierce" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 1:14 PM Subject: RE: Mail Servers Vopmail still has a problem with from lines of just a name and no domain. Vopmail assumes the sender must be from the default domain and the server and then will let it relay. That is a definite no-no. Thus it is very hard to get VOPMail off the spam block lists. Vircom has been aware of the problem for some time, yet they have been unwilling to do anything about it. I too have strongly recommended Vircom's VOPMail in the past. But this recent discovery of a spam hole and lack of a fix from Vircom over a known spam hole makes me question my past recommendations. - Steve -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 2:10 PM To: CF-Talk Subject: Re: Mail Servers Having problems with SMTP and hops. What mail server(s) does anyone recommend to work well with CF 4.5. Thanks for your time. I prefer VOPMail from Vircom myself. It handles just about whatever you can throw at it very well, and has full database integration built in so you can manage all your mailboxes via ODBC if you want. ___ Justin Scott :: [Staff Developer] http://www.annex.com -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PRO
RE: Mail Servers
Vopmail still has a problem with from lines of just a name and no domain. Vopmail assumes the sender must be from the default domain and the server and then will let it relay. That is a definite no-no. Thus it is very hard to get VOPMail off the spam block lists. Oddly enough, this just went through the VOPmail list. Indeed, VOPmail does not check the actual account, only the domain. This is not a bug but by design as checking the existence of the actual account is next to worthless since almost all domains have a postmaster account. Even if the domain does not have a postmaster account, a DNS lookup should reveal one or more accounts. Vircom has been aware of the problem for some time, yet they have been unwilling to do anything about it. Actually, they've been busy working on features that will actually have some benefit, such as preventing spam without disrupting service. I too have strongly recommended Vircom's VOPMail in the past. But this recent discovery of a spam hole and lack of a fix from Vircom over a known spam hole makes me question my past recommendations. Actually, even the RBLs call VOPmail a "Best of Breed" product when it comes to anti-relay/anti-spam functionality: http://maps.vix.com/tsi/ar-fix.html#vopmail Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: mail server
I second this one. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 3:05 PM To: CF-Talk Subject: Re: mail server Check out VOPMail at www.vircom.com. Great product with great support and a good user community. The unlimited license runs about $750. Jim - Original Message - From: "Brad Roberts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 30, 2000 12:55 PM Subject: OT: mail server We are getting ready to set up our server and need a mail server package. Anyone have suggestions? Running Win2k, 733mhz, 512meg ram. Would like to stay under $1000 with unlimited email accounts. Thanks, Brad Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: .htaccess for IIS?
Nothing built in. AuthentiX by Flicks (http://www.flicks.com) is probably your best bet. It's a COM object so you can talk to it with CFOBJECT. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 5:11 AM To: CF-Talk Subject: OT: .htaccess for IIS? I realize this may be off-topic, but I'm looking for a way to manage directory access on IIS with a CFM application. The rub is that the web pages to be protected themselves will be asp and/or standard html (Frontpage Extensions of all things!), so I can't simply plonk an application.cfm in there to keep everything in check. We've made a small application to do the same on Linux, but there it's relatively easy since you can create htaccess files. Is there an equivalent thing for IIS? Or failing that, is there a simple way to add/modify/delete directory access in IIS? We're talking a database of possibly hundreds of people who each need their individual passwords, and *no* way to use ColdFusion for the serving end of things. Michel Vuijlsteke Netpoint NV Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Cybercash or Authorizenet
I haven't run CyberCash in the past few years and I've heard that they've made some substantial improvements to the application and the underlying architecture, but we had some serious problems with the application on the server side. It was an incredible resource hog, prone to frequent crashes. When we used AuthorizeNet for the first few times, we couldn't believe how easy it was and how much more quickly transactions seemed to process. Of course, that was all a couple years ago. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 9:13 AM To: CF-Talk Subject: Cybercash or Authorizenet These are my 2 choices what are the good and what are the bad? Robert Everland III Web Developer Dixon Ticonderoga Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HTML Editor
Most of the solutions out there (especially the ColdFusion ones) are all based on the MSHTML editor. Information developing applications using this component can be found here: http://msdn.microsoft.com/workshop/browser/overview/editing.asp Here's a list of the most popular ones that I've seen around. I know there are a couple people from some of these companies on this list who will probably want to interject on behalf of their company. However, we just researched this fairly extensively. This is a combination of our opinions from evaluating the products and information gathered from the sales people. Please take it for what it is worth: HTMLEdit This is not a ColdFusion solution but I would be remiss not to mention it since it is such a quick and easy solution that probably meets many peoples' needs. http://javaboutique.internet.com/HTMLEdit/ Pros: Simple and Open Source. Cross-platform and cross-browser. Cons: Very, very few features (i.e. only includes basic HTML editing). HTMLAREA http://www.iautomated.com/ Pros: Free (Lite) Version. Cross Platform. Cons: Interface needs some work (i.e. bulky and clumsy); missing some of the features. Pay version is not particularly cheap. Not cross-browser (IE only). ActiveEdit http://www.cfdev.com/ Pros: Cross-platform and Inexpensive. Integration with some other products from the same company like ActiveScan. Cons: Interface needs a little work (i.e. a little clumsy and can't be embedded into a page) and it's missing a couple features (e.g. dictionary), most of which are coming out in the next version. It is not cross-browser (IE only). eWebEdit http://www.ektron.com/ Pros: Nice interface with all the features. Cross-browser and Spectra-ready. Cons: Really (really) high price tag (Although according to their sales rep they haven't figured out their pricing yet so this may change). Not cross-platform (Windows only). Hope this helps. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Deepak Agarwal [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 11:50 AM To: CF-Talk Subject: HTML Editor This is a multi-part message in MIME format. --=_NextPart_000_0013_01C0400C.0B8318A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can anyone suggest me a good HTML Editor tag, that can be used in cfm = templates/Spectra. Thanks in advance. Deepak 703.633.4257 --=_NextPart_000_0013_01C0400C.0B8318A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArialCan anyone suggest me a good HTML Editor tag, = that can be=20 used in cfm templates/Spectra./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialThanks in advance./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialDeepak/FONT/DIV DIVFONT face=3DArial703.633.4257/FONT/DIV/BODY/HTML --=_NextPart_000_0013_01C0400C.0B8318A0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF 5.0 Bug Vote is Now Open!
Wow, relax, man. How long have you been programming? Better yet, how long have you been programming in ColdFusion? How many times have you referenced a Session variable or called CFFILE without using CFLOCK? How many times have you neglected to not used CFLOCK around transaction sensitive queries? Better yet, do you really expect us to believe that you look at the ColdFusion error logs on every one of your servers every morning and fix every single error that caused that message even if you can't reproduce the error and don't know what might have caused it? My guess would be you do your best to fix the errors that are reported to you and that you can verify and that how much time you spend trying to verify an error is determined by how easy it is to reproduce, the number of users reporting the error, and whether or not one of those users happens to also be the client. Am I far off? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 7:48 PM To: CF-Talk Subject: Re: CF 5.0 "Bug Vote" is Now Open! If you have known bugs in CF 4.x (well, not *if*), why would you knowingly release the next major revision without correcting them Are you stating that unless someone "votes" to remove a bug, we can expect to see it perpetuated in the next release? Do bug fixes have that low of a priority at Allaire? Jim - Original Message - From: "Damon Cooper" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, October 24, 2000 4:42 PM Subject: CF 5.0 "Bug Vote" is Now Open! Register your bug for the Most Wanted list that will be targeted for inclusion in CF 5.0! Email mailto:[EMAIL PROTECTED]?subject=CF%5.0%20Bug%Vote to vote your CF Bugs in! (Bug Reporter #'s required, please). If you don't have a Bug Reporter #, you can enter and create one using the Bug Reporter at http://beta.allaire.com/bugreport/beta_bugtrack.cfm If you aren't signed up on the Beta site, NEW Beta customers can sign up at http://beta.allaire.com/bart. Regards, Damon Cooper CF Release Manager Allaire Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Moreover.com Categories List via WDDX
You need to CFHTTP the feed your after. Don't grab the WDDX version but the ColdFusion WDDX version. They've created a separate feed to "overcome a bug in ColdFusion." I'm not exactly sure to what they're referring, but oh well. Here's some code from a site I'm working on right now site. I had to condense it a little since I actually store the news feed in the Application scope and only refresh the query every hour. Hope this helps. By the way, a custom tag was recently added to the Allaire Tag Gallery for just this purpose. It probably simplifies the code substantially. cfhttp url="http://p.moreover.com/cgi-local/page?index_health+cf" method="GET" resolveurl="false" /cfhttp cfwddx action="WDDX2CFML" input="#CFHTTP.FileContent#" output="qry_GetHealthNews" h1Health News/h1 div style="margin-left:25px;" cfoutput query="qry_GetHealthNews" div style="margin-left:25px; width:300px;" p div style="font-weight:bold;"a href="#URL#"#Headline_Text#/a/div div class="SmSans"a href="#Document_URL#"#Source#/a - #DateFormat(Harvest_Time, " d ")#/div /p /div /cfoutput /div -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 10, 2000 9:40 AM To: CF-Talk Subject: Moreover.com Categories List via WDDX Good Morning, Is anyone out there grabbing the list of categories from Moreover.com using WDDX? I have been grabbing individual headlines using it, but their example page of using CF for grabbing the categories is blank. If you are doing this (grabbing the complete category list via WDDX), would you be willing to share the code? Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: TO ALL: Request for ColdFusion SP2 Input - locking
Amen. Automatic locking should be the default. After all, this is how a good RDBMS works (and a good application server for that matter). If the developer wants to override the default locking mechanism to ensure transactional integrity, then that tool should be available to the them. But don't shuffle the entire burden of locking off onto the developer because you're asking a single threaded application server to behave as a multi-threaded one. That's inexcusable. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:34 PM To: CF-Talk Subject: Re: TO ALL: Request for ColdFusion SP2 Input - locking It is probably too big a change for just a service pack - but maybe keep it in mind for the next point release: I would like to request an option to automatically lock variables. I read the "best practices" paper on the allaire site that explains why you don't have it - but you have to understand our point of view. I (and I am sure everyone else on this list) have thousands of templates that I started writing with Cold Fusion 2.0, that work perfectly. There isn't time to look at every template that I ever wrote, and add the locking code for it, so it is just sitting on the server, probably causing the server to become unstable. I would gladly give up a little performance to have automatic locking, to gain stability. I would set it up so that you can turn it on | off in the cfapplication tag on a project by project basis, so for apps where it is important for consistency issues or perfomance issues, I can do it manually, or if the app is on a shared server - we can be sure to have the right setting, not having to rely on the isp to decide which setting is best. I would have it default to automatic locking unless explicited selected not to have it. thanks Al Musella, DPM Musella Foundation i know one of the items that makes me very uncomfortable is the apparent code incompatibility on the locking issues. i.e. code written for CF server 4.5.1 locking doesn't easily work on 4.0 and vice versa.. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: O'Reilly Website
There are some sample .vbs utilities that are installed by default into the \winnt\system32\inetsrv\adminsamples\ directory. The command line utility mkw3site.vbs will do this. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 11:19 AM To: CF-Talk Subject: RE: O'Reilly Website Know of anything like this that runs on IIS ??? Joshua Miller Web Site Development Eagle Technologies Group Business Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Aaron Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 10:50 AM To: CF-Talk Subject: RE: O'Reilly Website Will, Check out: http://shiloh.shanje.com/utils/adddomain/ This util allows the web server admin to add domains from the command line. This util could also be used as part of a larger script to fully automate the setup of new clients. This util works with WebSite Pro 2 and might work with WebSite Pro 1.1, but this util has never been tested with WebSite Pro 1.1. Aaron -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 3:17 AM To: CF-Talk Subject: O'Reilly Website Hi, My latest task given to me by my Boss is a little complicated (for me, anyhow). I've got to Automate the entry of Domains onto the server via a nice Web Interface - at the moment we are using O'Reilly's Website Professional version 2.4. I presume, although I don't *know* for certain, that this is a cfregistry thing. If anyone has done this, or something similar, any tips or hints would be much appreciated. Cheers all Will -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox)
I believe he means "High-Level" in the programming sense (e.g. abstraction). In which case, FrontPage is about as high-level as you can get. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: RE: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox) I'm sorry, but since when was Front Page or any other WYSIWYG editor considered a "high-level" development tool? And by the way - I can code a site in the Fusebox style faster than you can code it straight any day of the week. And I know the other Fusebox coders would say the same. Don't I sound annoying right now? I'm playing. But I'm serious as well. :) -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 6:16 AM To: '[EMAIL PROTECTED]' Subject: RE: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox) I personally think it has major advantages when there is more than one of you working on a site. It's also extremely good when Client requirements are 'vague'. You can do very quick 'surgery' to code and affect changes faster. Because Fusebox breaks a page down into various files (minimum of 7(app_globals, app_locals, app_layout, dsp_header,dsp_footer,application, and index.cfm) and more likely to be at least 8 (the action), you cannot really use the high level web development tools (i.e. NetObject Fusion, Dreamweaver or say even Frontpage) effectively. You end up using Homesite or CF Studio or some other html editor. Adam -- From: David E. Crawford[SMTP:[EMAIL PROTECTED]] Sent: 19 September 2000 14:00 To: [EMAIL PROTECTED] Subject:RE: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox) This is a multi-part message in MIME format. --=_NextPart_000_0176_01C02239.952D0610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Re: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox) Yes, I believe there are people who don't like Fusebox. For various reasons. If you like it, use it; if you don't like it, don't use it. Not every CF developer will use it, and it isn't likely to be adopted as the "ALLAIRE STANDARD". It is a development methodology, not a silver bullet. There are people who have developed applications that are fusebox-like, but have branched out in other directions as well. If you choose to use it, and stick to the standard, it will help your development and maintainability. That does not mean however, that another methodology would not work for you as well. Beauty is in the eye of the beholder. I wonder how many people remember when the idea of Fusebox first came up on this list, almost 3 years ago? Or attended the first Fusebox gathering at the Users forum in Ft. Collins in 1998? I personally have grown to like Fusebox more over time, than I did when it was first suggested. But, I don't use it for all of my development. DC -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 10:48 To: [EMAIL PROTECTED] Subject: Re: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox) - Original Message - From: "Mark Adams" [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Tuesday, September 19, 2000 2:26 AM Subject: Re: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox) fusebox.org read read read :o) Is there *anyone* who doesn't like Fusebox!? Certainly seems that way.. Will -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_0176_01C02239.952D0610 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLERe: [CF-Talk] RE: Ben Forta, I call on thee (was: = What is Fusebox)/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3D
RE: Web servers
We switched servers as well, but they were comparable. We had about 250 Web sites on a box running WebSite Pro. All the Web sites were running ColdFusion in some form or another; most had static content as well. 10 to 20 had SSL certs. We switched to a box running IIS and saw "tremendous" performance gains. The switch was an interim solution: we've since redistribute the sites to many servers as they are too highly trafficked to all be on a single server. Like I said before, I can't back that up with stats. We were not expecting a performance gain. This was about a year and a half ago. I can't even tell you what the server config was. But I can tell you that quickly became a believer in IIS. If you need some stats, here's the ZDNet tests someone else mentioned: http://www.zdnet.com/pcmag/stories/firstlooks/0,6763,305867,00.html Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:31 AM To: [EMAIL PROTECTED] Subject: RE: Web servers On 9/7/00, Steve Pierce penned: IIS is a great product and you can't beat the price. But if you need carrier class reliability and scalability and can use CF instead of ASP 3, Website is a pretty good solution. OK, thanks. Everything you said is about what I've heard. Of course, I heard most of it from you. LOL I was just concerned that Benjamin said he saw a "tremendous performance gain" switching from WS to IIS. I'm still wondering why. I do know that I've got a lowly 512 K connection with about 70 static sites and about 20 CF sites and the CF sites are "at least" twice as fast under WS on mine as they were under IIS on Intermedia. Of course, that would probably change if I put hundreds of CF sites on the server, which I won't do. The static sites aren't noticeably slower either. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Web servers
Are there any advantages in running Website over the native IIS5 with CF/Win2K? Oh great, now you did it. This thread won't die for a week or two. :) I've run both (and Apache for that matter). IIS can't handle as many domains on a single server as WebSite. This has to do with the intigration of IIS into NT, specifically in regards to security. As always, integration has its pros and cons. WebSite seems to handle pure CGI apps much better than IIS. However, (and this comes from personal experience and therefore cannot be verified by statistics :P) ISAPI seems to be faster and more powerful than WSAPI. For this matter, and the fact that I don't run that many domains on a single server, I only run ColdFusion sites on IIS. In fact, I saw a tremendous performance gain switching my ColdFusion sites from WebSite to IIS to the extent that competitors were asking what we had done to our service to speed it up. :) There are some other things to think about as well. If you may need to support ASP pages, you'll definitely want to go with IIS. Another consideration is SSL keys. An SSL key can be moved from one server to another as long as they are running the same Web server. This would suggest that you go with the product with a greater user base (both now and in the future). This would be an argument in favor of IIS which holds 20% of the market as oposed to WebSite which holds .5% of the market. Of course, the natural extension to this argument is to use Apache (60%). :) From a managability standpoint, IIS has more anoying little habits like the naming the logs directory "W3SVC#." Although I'm not a big fan of the MMC (the app framework from which you manage IIS) the interface from which WebSite is managed is horendous. One of the best arguments in IIS's favor is that it is free (with the purchase of the operating system of course). But, as far as support goes, you're on your own. You've got the mailing lists, the news groups, a couple books, and the MSKB. If you fork out the cash for WebSite, you have what I consider to be the best tech support in the industry. Sorry about the long winded answer. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Application in ASP [OT]
global.asa -Original Message- From: Marc Garrett [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 6:17 PM To: [EMAIL PROTECTED] Subject: Re: Application in ASP [OT] Global.asa Does anyone know if ASP has an application.cfm equivalent? Thanks, Geoff B -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Dynamic Dropdowns From Queries?
Just came across this: http://www.nsnd.com/CFTIPS_e-ZINE/00025/00025.cfm Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 2:57 PM To: [EMAIL PROTECTED] Subject: RE: Dynamic Dropdowns From Queries? You may want to try running one big massive query that retrieves all the data and relationships that you will want/need to display on a single page. Serialize the record set into WDDX packets in JavaScript, and use the WDDX JavaScript functions provide by Allaire to get the information out of the WDDX packets and populate the drop downs accordingly. You can write the content of the drop down dynamically with JavaScript. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Gina Shillitani [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 1:44 PM To: '[EMAIL PROTECTED]' Subject: Dynamic Dropdowns From Queries? I want to create dynamic dropdown boxes where the second box changes based on the selection of the first box, but using CFQUERY to fill the contents of both boxes... for example, the first select box contains the results of QUERY1, and based on what they select from that box, I want to fill the second box with a query using a where clause that uses the selection from the first box. Example: The first dropdown is filled with the results of a query like "SELECT ClientName FROM Clients". Then if user chooses Client A from the first dropdown, I want to run a query like "SELECT Offices FROM Clients WHERE ClientName = 'Client A'" and use the results of that query to fill the second dropdown. All of the JavaScript dynamic dropdown things I've found have the values hardcoded into them. Is there a way to do this, with or without JavaScript? Also, I am using the Fusebox methodology on this site. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What I want in CF (was: Learning ASP)
I agree to a certain extent, however, I do not feel that Allaire's efforts are best spent developing an XML parser for ColdFusion. In my opinion, too much work needs to be done to the existing code base and functionality. Perhaps the best of both worlds would be if Allaire picked one parser (say Xerces) and redistributed that with the server. I think I'd rather have Allaire point the developers in a direction rather than reinventing the wheel. In any case, it is what it is. There are plenty of solid XML parsers out there that can be incorporated into ColdFusion apps. I would just pick the one that claims 100% compatibility and let everyone else worry about making theirs work with yours. Now, all that said, I wouldn't mind seeing a native XML parser built into ColdFusion if they fixed everything else first. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 4:25 PM To: [EMAIL PROTECTED] Subject: RE: What I want in CF (was: Learning ASP) MSXML.DLL, right? This will work on NT but, doesn't help *NIX users. I feel that an XML parser would be beneficial enough that it should be included in CF. Right now only a portion of the developer base can make use of MSXML.DLL. There's the OS issue and the fact that the developers need open access to CFOBJECT. These two things will limit a lot of developers, especially those in remotely hosted environments. Also, MSXML, while steadily improving, is NOT 100% W3C XML 1.0 compliant. Version 3.0 Beta, the most recent, is approx. 95-97% compliant so things look good but, it still has some issues to resolve relating to non-existent or malformed unused entities, attribute-value normalization, end-of-line handling, and reporting validity constraints when running in non-validating mode. Ok, so MSXML isn't 100 compliant, so what? Well, if I use MSXML and you use Xerces (Apache Project's XML parser) we may come up with different results. I'd rather have everyone using one parser that is 90% compliant than 10 parsers, each of which produces slightly different results. Steve -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 10:16 AM To: [EMAIL PROTECTED] Subject: RE: What I want in CF (was: Learning ASP) XML parser. Enough to check well-formedness with the option to validate against a DTD. It doesn't have to "execute" the XML. If you are on NT, what about the XML Parser that comes with Internet Explorer? Many people have been using this successfully from within ColdFusion Apps. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IIS Locking Files
I guess I don't understand exactly what you're getting at. I wasn't suggesting this was something other than an issue with the way IIS handles file locking and caching. The folks who designed WebCam32 built a work around into the WebCam32 software for the file locking issue. It reduces the frequency of the problem to approximately 1/1000. Another solution may be to have the image source call a ColdFusion template that reads and returns the image using the CFCONTENT tag. You should be able to establish an exclusive lock by placing the CFLOCK around this. This may produce access denied errors from WebCam32. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Friday, September 01, 2000 8:40 AM To: [EMAIL PROTECTED] Subject: RE: IIS "Locking" Files WebCAM isn't the problem. It is IIS. WebCAM is uploading a temporary file and then renaming to the "default" name. The problem is that the CF page that I am using to display the images is looking for the "default" name. The browser access via CF is what is causing the lock to be placed on the system. The webcams in question will be in a display booth at a trade show, and I will not have the ability to take advantage of the "push" feature. FTP is the way I need to go. Dave -----Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 18:37 To: [EMAIL PROTECTED] Subject: RE: IIS "Locking" Files What the folks who designed the WebCam32 software intended was for the app to upload the file with a temporary name and then rename the file. This avoids the locking issue in most cases. This works, however, I'd recommend their JavaPushCam applet. This can be customized to suit your needs fairly well and degrades gracefully on slower connections. It also precludes the necessity of having to reload the entire page. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 1:23 PM To: Jim McAtee; [EMAIL PROTECTED] Subject: RE: IIS "Locking" Files This is a multi-part message in MIME format. --=_NextPart_000_0052_01C01370.1F8B9480 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Re: IIS "Locking" FilesWell, I would, except that I am using the FTP client builtin to WebCAM32 and it is not as flexible. I don't want to write a complete application around this. DC -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 16:43 To: [EMAIL PROTECTED] Cc: David E. Crawford Subject: Re: IIS "Locking" Files Dave, You might also try a different approach to naming the uploaded files. If possible, have your webcam upload the images with a unique filename. For example, instead of uploading as "thispic.jpg", append a timestamp, as in "thispic1405.jpg". Your CF template that displays the image could do a CFDIRECTORY using a filter of "thispic*.jpg", sort by date (descending), and then select the latest image. Clean out the directory as needed. Definitely a bit more work, but you wouldn't have to disable anything in IIS. Jim -Original Message- From: David E. Crawford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, August 31, 2000 6:42 AM Subject: IIS "Locking" Files A while back there was some discussion of a registry hack which would allow the disabling of the "lock" that IIS places on files during "read" operations. I understand that it may have a bearing on performance, however, I am in a situation where I am ftp'ng webcam images into a directory, which are then "called" via CFM template. Unfortunately the browser access to the files appears to be placing an exclusive lock on the file, which means the FTP process is failing. Does anyone recall the technique used to defeat this "feature" of IIS? Dave --- David E. Crawford Director, Internet Development Yale Security Group, Inc. www.yalesecurity.com --=_NextPart_000_0052_01C01370.1F8B9480 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLERe: IIS "Locking" Files/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD BODY DIVFONT color=3D#ff face=3DArial size=3D2SPAN = class=3D155282217-31082000Well,=20 I would, except that I am using the FTP client builtin to WebCAM32 and = i
RE: cflocking.. new allaire article
The argument against automatic locking sounds like an excuse to me. I've never understood why they didn't perform automatic locking. Although I understand the example, I feel it should be up to the user to override the automatic locking for transactional processing/integrity as this is the exception and not the rule. After all, isn't this the way SQL functions? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 In case someone here isn't subscribed to FusionAuthority News Alert: "Jim Schley, Premier Support, Allaire Corp., has come forth with this very important explanation of some of the best practices involved with locking shared variables. If you don't follow these practices, folks, you may run into some unforeseen pitfalls." http://www.allaire.com/handlers/index.cfm?ID=17318Method=Full --- --- To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/fusebox or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IIS Locking Files
I don't know of a registry setting to completly disable object caching from within IIS, but the following keys may be appropriate/useful. HKLM\System\CurrentControlSet\Services\InetInfo\Parameters\ObjectCacheTTL HKLM\System\CurrentControlSet\Services\InetInfo\Parameters\OpenFileInCache HKLM\System\CurrentControlSet\Services\InetInfo\Parameters\MemoryCacheSize For information, search TechNet for these keys. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 8:42 AM To: CF-Talk Subject: IIS "Locking" Files A while back there was some discussion of a registry hack which would allow the disabling of the "lock" that IIS places on files during "read" operations. I understand that it may have a bearing on performance, however, I am in a situation where I am ftp'ng webcam images into a directory, which are then "called" via CFM template. Unfortunately the browser access to the files appears to be placing an exclusive lock on the file, which means the FTP process is failing. Does anyone recall the technique used to defeat this "feature" of IIS? Dave --- David E. Crawford Director, Internet Development Yale Security Group, Inc. www.yalesecurity.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What I want in CF (was: Learning ASP)
XML parser. Enough to check well-formedness with the option to validate against a DTD. It doesn't have to "execute" the XML. If you are on NT, what about the XML Parser that comes with Internet Explorer? Many people have been using this successfully from within ColdFusion Apps. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: UNC Path's for CFFILE Uploads
Does the account System have the necessary privileges, both to the share and to the directory/file in question? -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 11:11 AM To: [EMAIL PROTECTED] Subject: UNC Path's for CFFILE Uploads CF Gives some rather ambigious errors when you try this. GRIPE REASON="AmbigiousError" The directory either does not exist or is not accessible by the ColdFusion service. /GRIPE Anyhow, has anyone done this, I have tried URLEncodedFormatting my path I have tinkered with permissions to ensure they were not a problem Full access by all (real erhm.. secure) but for testing it works. Tried several different names and as many combinations of these as I can think of none of them working to any avail. I have a Machine foo on drive Z called tmp that shares folder bar Share tmp is accessed by going to \\foo\tmp Using the Absolute path works fine Z:\bar\junk\images Uploads images in the expected manner. UNC Pathnames somehow do not work.. I am getting a feeling they dont work. Anyone else know about tihs one? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IIS Locking Files
What the folks who designed the WebCam32 software intended was for the app to upload the file with a temporary name and then rename the file. This avoids the locking issue in most cases. This works, however, I'd recommend their JavaPushCam applet. This can be customized to suit your needs fairly well and degrades gracefully on slower connections. It also precludes the necessity of having to reload the entire page. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 1:23 PM To: Jim McAtee; [EMAIL PROTECTED] Subject: RE: IIS "Locking" Files This is a multi-part message in MIME format. --=_NextPart_000_0052_01C01370.1F8B9480 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Re: IIS "Locking" FilesWell, I would, except that I am using the FTP client builtin to WebCAM32 and it is not as flexible. I don't want to write a complete application around this. DC -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 16:43 To: [EMAIL PROTECTED] Cc: David E. Crawford Subject: Re: IIS "Locking" Files Dave, You might also try a different approach to naming the uploaded files. If possible, have your webcam upload the images with a unique filename. For example, instead of uploading as "thispic.jpg", append a timestamp, as in "thispic1405.jpg". Your CF template that displays the image could do a CFDIRECTORY using a filter of "thispic*.jpg", sort by date (descending), and then select the latest image. Clean out the directory as needed. Definitely a bit more work, but you wouldn't have to disable anything in IIS. Jim -Original Message- From: David E. Crawford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, August 31, 2000 6:42 AM Subject: IIS "Locking" Files A while back there was some discussion of a registry hack which would allow the disabling of the "lock" that IIS places on files during "read" operations. I understand that it may have a bearing on performance, however, I am in a situation where I am ftp'ng webcam images into a directory, which are then "called" via CFM template. Unfortunately the browser access to the files appears to be placing an exclusive lock on the file, which means the FTP process is failing. Does anyone recall the technique used to defeat this "feature" of IIS? Dave --- David E. Crawford Director, Internet Development Yale Security Group, Inc. www.yalesecurity.com --=_NextPart_000_0052_01C01370.1F8B9480 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLERe: IIS "Locking" Files/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD BODY DIVFONT color=3D#ff face=3DArial size=3D2SPAN = class=3D155282217-31082000Well,=20 I would, except that I am using the FTP client builtin to WebCAM32 and = it is not=20 as flexible.nbsp; I don't want to write a complete application around=20 this./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D155282217-31082000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D155282217-31082000DC/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D155282217-31082000/SPAN/FONTnbsp;/DIV BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px" DIV align=3Dleft class=3DOutlookMessageHeader dir=3DltrFONT = face=3DTahoma=20 size=3D2-Original Message-BRBFrom:/B Jim McAtee=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Thursday, August 31, = 2000=20 16:43BRBTo:/B [EMAIL PROTECTED]BRBCc:/B David E.=20 CrawfordBRBSubject:/B Re: IIS "Locking" = FilesBRBR/DIV/FONT PFONT size=3D2Dave,/FONT /P PFONT size=3D2You might also try a different approach to naming = the uploaded=20 files./FONT BRFONT size=3D2If possible, have your webcam upload = the images=20 with a unique filename./FONT BRFONT size=3D2For example, instead = of=20 uploading as "thispic.jpg", append a timestamp,/FONT BRFONT = size=3D2as in=20 "thispic1405.jpg".nbsp; Your CF template that displays the image = could/FONT=20 BRFONT size=3D2do a CFDIRECTORY using a filter of "thispic*.jpg", = sort by=20 date/FONT BRFONT size=3D2(descending), and then select the = latest=20 image.nbsp; Clean out the directory/FONT BRFONT size=3D2as = needed.nbsp;=20 Definitely a bit more work, but you wouldn't have to disable/FONT = BRFONT=20 size=3D2a
RE: Dynamic Dropdowns From Queries?
You may want to try running one big massive query that retrieves all the data and relationships that you will want/need to display on a single page. Serialize the record set into WDDX packets in JavaScript, and use the WDDX JavaScript functions provide by Allaire to get the information out of the WDDX packets and populate the drop downs accordingly. You can write the content of the drop down dynamically with JavaScript. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Gina Shillitani [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 1:44 PM To: '[EMAIL PROTECTED]' Subject: Dynamic Dropdowns From Queries? I want to create dynamic dropdown boxes where the second box changes based on the selection of the first box, but using CFQUERY to fill the contents of both boxes... for example, the first select box contains the results of QUERY1, and based on what they select from that box, I want to fill the second box with a query using a where clause that uses the selection from the first box. Example: The first dropdown is filled with the results of a query like "SELECT ClientName FROM Clients". Then if user chooses Client A from the first dropdown, I want to run a query like "SELECT Offices FROM Clients WHERE ClientName = 'Client A'" and use the results of that query to fill the second dropdown. All of the JavaScript dynamic dropdown things I've found have the values hardcoded into them. Is there a way to do this, with or without JavaScript? Also, I am using the Fusebox methodology on this site. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Sequal sp?
SQL - Structured Query Language http://www.whatis.com/WhatIs_Definition_Page/0,4152,214230,00.html Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Monday, August 28, 2000 2:18 PM To: [EMAIL PROTECTED] Subject: Sequal sp? What is meant by a "sequal" server/database? Im spelling it like it sounds :) Thanks Chad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Parsing Email
There is a mail server which uses ColdFusion templates to handle mail, logins, etc. I believe it is called the inFusion Mail Server. Ostensibly, you could customize these templates to suit your needs. Usually, however, this is done with "Mailbox Agents," executables that are run when a mail server receives a piece of e-mail for a specific user or group of users. If an agent alone won't suffice (you really need a ColdFusion template executed), another solution would be to write an agent in C (or even in VBS or JS if your mail server is on NT) and have that call the ColdFusion template. This method incurs quite a bit of overhead as we're talking about multiple servers, the network, the Web Server, etc. There may be other options depending on what exactly you're trying to do. If you post some more information, we may be able to help you out a little more. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jacob McKee [mailto:[EMAIL PROTECTED]] Sent: Monday, August 28, 2000 1:46 PM To: '[EMAIL PROTECTED]' Subject: Parsing Email Does anyone know how to take an email that is sent to someone and have CF parse it/check for string and then perform some action? Thanks! jake J a c o bM c K e e Senior Development Manager - Mobile Solutions Group Vectrix Tel: 214.890.1801 8800 N. Central Expressway Suite 800 Dallas, Texas 75231 USA E: [EMAIL PROTECTED] W: http://www.vectrix.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Mail Servers?
For NT solutions, we've used VOPmail by Vircom with great success. http://www.vircom.com -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 9:59 AM To: '[EMAIL PROTECTED]' Subject: Mail Servers? Are there any GOOD yet not too expensive mail servers out there? We currently have exchange no matter what we do we cant get CF to work with exchange as long as Relaying is shut down. So we wanted to install another mail server for CF that can bypass exchange. Meaning we dont want a mail server, like some, that still POINTS to another mail server. We want a mail server that can send out SMTP mail on it's own, i dont care about receiving mail. Any recommendations? Kelly Stay current with what's happening on AirportNet. Subscribe to our Announcement list today: http://www.airportnet.org/email.htm --- Kelly Matthews Internet Development Coordinator AAAE 703.578.2509 [EMAIL PROTECTED] http://www.airportnet.org --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Fuzzy Logic Searches in SQL
We've sort of been looking for a reason to upgrade to SQL Server 7.0. I've used Verity before. I did not know, however, that Verity took care of stemming and sound matching. Good to know. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 21, 2000 5:39 PM To: [EMAIL PROTECTED] Subject: Re: Fuzzy Logic Searches in SQL CONTAINS Predicate is exactly what you are looking for. However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new feature full-text searching/indexing was added. In which I think CONTAIN relies on? Any hope of upgrading to 7.0? Or possibly using Verity search capability? Bill Willow Gold http://www.willowgold.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Fuzzy Logic Searches in SQL
Is anyone familiar with or has attempted fuzzy logic SQL searches. By this, I mean anything from similar sounds, misspellings, typos, stemming, etc. We're attempting this in SQL Server 6.5 Transact-SQL but have not made it to far. Any references (e.g. sites or books) that detail the process would be great. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stuck at the NT Login box
If the drive is NTFS, you can stick it in another computer running NT. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 19, 2000 5:29 PM To: [EMAIL PROTECTED] Subject: RE: Stuck at the NT Login box If you happened to format the root NT drive, normally C:, with the FAT or FAT32 file systems then you can use a DOS/Win9x boot diskette to access the drive. If it's formatted using NTFS then you'll probably need to use ERD Commander Pro by Winternals, http://winternals.com/ Regards, Steve -Original Message- From: Philippe Varichon [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 19, 2000 5:11 PM To: [EMAIL PROTECTED] Subject: OT: Stuck at the NT Login box My NT server (SP6) was working until I tried without success to update a Logitech driver for a wireless mouse (NT compatible). When I rebooted I could get to the login box but I could not enter a username because I got the following error message from the Service Control Manager: 'At least one service or driver failed during service startup. Use event viewer to examine the event log for details.' The OK button on this message cannot be pressed and the 'Begin Logon' box cannot be accessed in the backrground. I tried to boot with the 'Last Known Good Configuration' but it does not work because I updated a driver not added one. The repair disk did not help. Anyone knows if there is a way around this? And if not how can I reclaim the data on my HD? ( I have only a partial Back up...) Thank you a million in advance Philippe Varichon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stuck at the NT Login box
Have you tried plugging a PS2 mouse into the box and booting in safe mode? That should get you in, at which point you should be able to "update" the drivers for the Logitech mouse with the older version. Now, I have to ask in order to satisfy my own curiosity, are you running a cordless, Logitech mouse on a server? Logitech mice (and cordless mice in general) are very definitely bad mojo. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Philippe Varichon [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 19, 2000 5:11 PM To: [EMAIL PROTECTED] Subject: OT: Stuck at the NT Login box My NT server (SP6) was working until I tried without success to update a Logitech driver for a wireless mouse (NT compatible). When I rebooted I could get to the login box but I could not enter a username because I got the following error message from the Service Control Manager: 'At least one service or driver failed during service startup. Use event viewer to examine the event log for details.' The OK button on this message cannot be pressed and the 'Begin Logon' box cannot be accessed in the backrground. I tried to boot with the 'Last Known Good Configuration' but it does not work because I updated a driver not added one. The repair disk did not help. Anyone knows if there is a way around this? And if not how can I reclaim the data on my HD? ( I have only a partial Back up...) Thank you a million in advance Philippe Varichon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF's Redheaded Stepchild
Not sure what you mean by "Redheaded Stepchild". It just looks to me like they're realizing that e-biz is a lot harder to deal with than just having people walk into a store and carry out there goods. Toys 'R Us' issues specifically dealt w/ their architecture and order fulfillment. I believe what he means is that, while Allaire is trying desperately to prove to the world that ColdFusions can scale, the largest Web site to date programmed in ColdFusion has been a horrific failure. I'm not arguing that ColdFusion can't scale, or even that ColdFusion had anything to do with the problems that have plagued the site, but nonetheless, ToysRUs.com has not been the marketing gold mine on which Allaire was banking. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Airport Code Database
Just to warn you, it seems to only cover the largest (International?) airports. -Original Message- From: Scott J. Brader [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 12:24 PM To: [EMAIL PROTECTED] Subject: RE: Airport Code Database That was exactly what I was looking for. Thanks! Scott Brader USAV Group 5485 South Westridge Drive PO Box 510620 New Berlin, WI 53151-0620 Phone: 262.814.2000 Fax: 262.814.2006 Amateurs Practice Until They Get It Right, Experts Practice Until They Can't Get It Wrong Any opinions expressed herein are mine and are not representative of USAV Communications Group. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 11:26 To: [EMAIL PROTECTED] Subject: Re: Airport Code Database In a message dated 08/17/2000 12:20:11 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: I have an application that requires that I offer a listing of airports and their associated codes. Does anyone have a tag or know of a source for the data so I can build my own tag? Yahoo has a page of cities codes for domestic airports. Didn't see one for international but don't know if you need that or not. It's in straight HTML so you could cut paste whatever you need. http://help.yahoo.com/help/maps/maps-13.html Hope this helps is not too simple. :-) Oriole -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HELP: SQL Server Problems!
If I remember correctly, you'll want to call up the SQL Server 7 CD. If it doesn't autorun, then you'll have to find the executable that the autorun is trying to launch. Run the installation (choose a "Custom" install if that is an option) and you'll receive a few options with check boxes. Uncheck the SQL Server option and leave the SQL Server client tools option checked. There's a couple other options there as well, but I can't remember what they are and whether or not you'll need them to run the tools. Hope this helps. I'm sorry I can't be more specific, but I don't have the CD in front of me right now. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 8:21 AM To: Cf-Talk Subject: HELP: SQL Server Problems! I am trying to find out where the Enterprise Manager and Query Analyzer is for SQL Server. The company at the moment uses PC Anywhere to log in to the machine and then work from there, but I want to be able to write SP's from here. We have the SQL Servr 7 disks, but I can't find where on those it is. HELP Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: VERY SAD (was CFGRID onvalidate=???)
How about.. http://www.dansteinman.com/dynduo/ For one such API :) And another: http://www.siteexperts.com/dhtmllib/page1.asp Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: VERY SAD (was CFGRID onvalidate=???)
Duane, We've used cftree and cfgrid in several relatively simple applications and haven't run into any problems. When you say "unstable," what do you mean? Is there something we should be watching for? What I think of when I hear "unstable" is, I imagine, probably not what you meant. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 2:37 PM To: [EMAIL PROTECTED] Subject: RE: VERY SAD (was CFGRID onvalidate="???") Very sad to understand that list is swiftly rush down. Only one year ago you was able to find answer for any of your questions here. But things are changed. Very sad to understand that Allaire Corporation's product evangelist uses this list only for advertises and unable to explain how his child works. Wednesday, August 09, 2000, 3:22:11 PM, you wrote: Alex cf-talk, Alex Can somebody help me? I have difficulties trying to validate user's Alex input in cfgrid. In fact I can't understand how I can validate 15 Alex columns with 15 validation rules. Alex Can somebody help me? You are probably not getting answers for this because VERY few people use Allaire's applets. They are highly unstable and because of that most users shy away from usage. Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: VERY SAD (was CFGRID onvalidate=???)
We haven't tried the applets since early 4.01 so they may have been improved since. Heh, we haven't upgraded to 4.5 yet. Well, it's good to know other's have experienced problems. Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Monitoring Telnet Connections
I'm not sure exactly what you're after. Your Telnet daemon should provide this capability and I don't believe the one that comes on the Res Kit does. A truly exceptional Telnet daemon is that put out by Pragma Systems http://www.pragmasys.com/. The feature list is complete and I've used their telnet daemon for a couple years on many production servers and have had no problems. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Richard Ramos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 12:26 PM To: [EMAIL PROTECTED] Subject: OT: Monitoring Telnet Connections Anyone know how you can track connections to telnet services in an NT Server? Thanks in advance. Richard Ramos [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Monitoring Telnet Connections
Jeremy, The point is not whether you have a use for Telnet on NT or even if remote administration via Telnet is generally superior to GUI based applications, but whether you know of a way to monitor telnet connections. Obviously, Richard has a use: now he's looking for a solution. In any case, telnet is a perfectly legitimate way to administer Internet servers (and servers in general). Telnet daemons that support secure connections are available for NT, but if someone has access to your server with execute permissions, "sniffing out passwords" is usually the least of your worries and certainly not the source of your problem. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:07 PM To: [EMAIL PROTECTED] Subject: RE: Monitoring Telnet Connections Well.. speaking from the Unix word the netstat command with the proper arguments shows you everything that is connected to your system.. So really its not necessarily overkill to observe what / who is connected to your system. Telnet is always on port 23, so anything connected to your system on port 23 should tell you who is using telnet. So look for something that monitors all of the TCP/IP connections on the machine.. Real typical stuff, I have had the need to use anything like it for NT but it should be readily available. Now that said, TELNET IS EVIL!!! It is one of the most insecure ways to administer a system and Anyone who has ever used plain ole telnet to administer a live internet server should be shot ;-) Use SSL, because its very simple to sniff out passwords in plain telnet.. its all clear text. There are some telnet daemons (in the Unix world) that do password encryption already but.. I doubt for NT.. Then there is SSL which uses a secure socket 100% encrypted session to access the machine, which means sniffing is then out of the question. I don't really see much of a point to using.. telnet on NT since most people want to charge you money etc, for telnet services on NT4, and it should come with W2K I played around with their Crude Telnet daemon that used NTLM for Authentication.. somewhat secure.. (*cough cough*) All of this is Free if the box is a *nix box.. you can download binaries/ compile from source for the ultra paranoid SSL daemons from free. That said.. you can also get at... http://sourceware.cygnus.com most typical GNU utilities including GCC there, which will allow you to compile SSL, for windows so you can have secure sockets. If security is a concern its really worth investigating. Now all that said, what is the purpsoe of having the Telnet for NT? there is a great Free (GPL'd) administration utility available for NT located at.. http://www.uk.research.att.com/vnc/ Think.. PC Anywhere, and you can also use SSL with that to totally encrypt the entire session however it already does some more secure than plain text authentication so you may or may not care, also it would take someone sniffing a lot of time with a network dump and a hex editor to figure out what you were doing since the VNC protocol *is* plain text but it would take a lot of knowledge to really make any sense out of the data :) Anyways.. that is my 2 cents and then some ;) Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Angil Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 2:41 PM To: [EMAIL PROTECTED] Subject: Re: Monitoring Telnet Connections Hmm...you could install something like Black Ice which monitors connections to and from you're machine. It's a personal firewall utility. I think its overkill though, you should just buy a new Telnet Daemon, but I don't know which would be cheaper for you. -Gel - Original Message ----- From: Benjamin S. Rogers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 08, 2000 2:39 Gil Subject: RE: Monitoring Telnet Connections I'm not sure exactly what you're after. Your Telnet daemon should provide this capability and I don't believe the one that comes on the Res Kit does. A truly exceptional Telnet daemon is that put out by Pragma Systems http://www.pragmasys.com/. The feature list is complete and I've used their telnet daemon for a couple years on many production servers and have had no problems. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Richard Ramos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 12:26 PM To: [EMAIL PROTECTED] Subject: OT: Monitoring Telnet Connections Anyone know how you can track connections to telnet services in an NT Server? Thanks in advance. Richard Ramos [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe
RE: Monitoring Telnet Connections
Excellent. That's probably the best suggestion yet as it doesn't require Richard to purchase a new telnet daemon. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:53 PM To: [EMAIL PROTECTED] Subject: RE: Monitoring Telnet Connections That was more of a rant.. less of something directed towards him. Anywhu.. if it is an NT machine at a command prompt just type "netstat /?" and you can see a list of options. Netstat will do exactly what you want.. I guess I should have been more specific in pointing out netstat is available for NT ;-D "netstat -a" and it shows everything connected to a particular machine.. Hope thats useful Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message----- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:37 PM To: [EMAIL PROTECTED] Subject: RE: Monitoring Telnet Connections Jeremy, The point is not whether you have a use for Telnet on NT or even if remote administration via Telnet is generally superior to GUI based applications, but whether you know of a way to monitor telnet connections. Obviously, Richard has a use: now he's looking for a solution. In any case, telnet is a perfectly legitimate way to administer Internet servers (and servers in general). Telnet daemons that support secure connections are available for NT, but if someone has access to your server with execute permissions, "sniffing out passwords" is usually the least of your worries and certainly not the source of your problem. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:07 PM To: [EMAIL PROTECTED] Subject: RE: Monitoring Telnet Connections Well.. speaking from the Unix word the netstat command with the proper arguments shows you everything that is connected to your system.. So really its not necessarily overkill to observe what / who is connected to your system. Telnet is always on port 23, so anything connected to your system on port 23 should tell you who is using telnet. So look for something that monitors all of the TCP/IP connections on the machine.. Real typical stuff, I have had the need to use anything like it for NT but it should be readily available. Now that said, TELNET IS EVIL!!! It is one of the most insecure ways to administer a system and Anyone who has ever used plain ole telnet to administer a live internet server should be shot ;-) Use SSL, because its very simple to sniff out passwords in plain telnet.. its all clear text. There are some telnet daemons (in the Unix world) that do password encryption already but.. I doubt for NT.. Then there is SSL which uses a secure socket 100% encrypted session to access the machine, which means sniffing is then out of the question. I don't really see much of a point to using.. telnet on NT since most people want to charge you money etc, for telnet services on NT4, and it should come with W2K I played around with their Crude Telnet daemon that used NTLM for Authentication.. somewhat secure.. (*cough cough*) All of this is Free if the box is a *nix box.. you can download binaries/ compile from source for the ultra paranoid SSL daemons from free. That said.. you can also get at... http://sourceware.cygnus.com most typical GNU utilities including GCC there, which will allow you to compile SSL, for windows so you can have secure sockets. If security is a concern its really worth investigating. Now all that said, what is the purpsoe of having the Telnet for NT? there is a great Free (GPL'd) administration utility available for NT located at.. http://www.uk.research.att.com/vnc/ Think.. PC Anywhere, and you can also use SSL with that to totally encrypt the entire session however it already does some more secure than plain text authentication so you may or may not care, also it would take someone sniffing a lot of time with a network dump and a hex editor to figure out what you were doing since the VNC protocol *is* plain text but it would take a lot of knowledge to really make any sense out of the data :) Anyways.. that is my 2 cents and then some ;) Jeremy Allen [EMAIL PROTECTED] [Insert cool title here] -Original Message- From: Angil Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 2:41 PM To: [EMAIL PROTECTED] Subject: Re: Monitoring Telnet Connections Hmm...you could install something like Black Ice which monitors connections to and from you're machine. It's a personal firewall utility. I think its overkill though, you should just buy a new Telnet Daemon, but I don't know which would be cheaper for you. -Gel - Original Message - From: Benjamin S. Rogers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August
Setting a Cookie and Redirecting the Browser
Has anyone come up with a plausible way of setting a cookie and redirecting the browser from within a ColdFusion 4.01 template using HTTP headers (as opposed to META tag redirects)? Specifically, we're trying to redirect an image call from the browser. The image fails to load when it comes upon a HTTP "Refresh" header, and the "Location" header seems to negate the setting of the cookie. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Setting a Cookie and Redirecting the Browser
We can't use a META refresh because the template is being called from an image source. The ColdFusion template makes a few decisions and redirects to the appropriate image. -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:31 PM To: [EMAIL PROTECTED] Subject: RE: Setting a Cookie and Redirecting the Browser Any reason why you don't want to use a META tag refresh to redirect? That's what I always use when I need the cookie to be set. CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:18 PM To: [EMAIL PROTECTED] Subject: Setting a Cookie and Redirecting the Browser Has anyone come up with a plausible way of setting a cookie and redirecting the browser from within a ColdFusion 4.01 template using HTTP headers (as opposed to META tag redirects)? Specifically, we're trying to redirect an image call from the browser. The image fails to load when it comes upon a HTTP "Refresh" header, and the "Location" header seems to negate the setting of the cookie. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Setting a Cookie and Redirecting the Browser
Were you able to do this with binary data (a.k.a an image)? We'd prefer not to place the burden of the transaction on ColdFusion, but if it works, then it's a solution. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Hinojosa, Robert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 5:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Setting a Cookie and Redirecting the Browser Just a thought... You could CFHTTP the content of the desired forwarded page so that the cookie can set. I have done this once, a long time ago, and I remember it working. Hope this helps, Robert Hinojosa WebDeveloper 512.912.3775 [EMAIL PROTECTED] -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:48 PM To: [EMAIL PROTECTED] Subject: RE: Setting a Cookie and Redirecting the Browser Again, we can't use a META refresh. See either of my earlier posts for an explanation as to why this solution will not work for us. FYI: Adding the HTTP header "Refresh" with the cfheader works well instead of the META refresh if you'd rather not have a page displayed at all. We found that even with a time of 0 that the META refresh was still noticeable because of connection and page rendering lags. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Brandon Behrens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:34 PM To: [EMAIL PROTECTED] Subject: RE: Setting a Cookie and Redirecting the Browser Been there, done that. I wound up using a meta tag to refresh the page with a time of 0. That was the only way I could get it to work. Brandon Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com -Original Message----- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:18 PM To: [EMAIL PROTECTED] Subject: Setting a Cookie and Redirecting the Browser Has anyone come up with a plausible way of setting a cookie and redirecting the browser from within a ColdFusion 4.01 template using HTTP headers (as opposed to META tag redirects)? Specifically, we're trying to redirect an image call from the browser. The image fails to load when it comes upon a HTTP "Refresh" header, and the "Location" header seems to negate the setting of the cookie. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [SNMP/MRTG Through ColdFusion]
CF 4.01/NT 4.0 and Cisco Routers. That's pretty much what I was asking, whether or not someone had written a front end for MRTG or, better yet, a fully functional app in ColdFusion. We'd prefer not to run Perl if at all possible, but if necessary, we'll put up a separate server for MRTG running Active Perl, at which point, we probably wouldn't even bother with the ColdFusion front end. It would be nice, however, to integrate MRTG or a similar app into everything else we're doing, especially if it involved one less server with one less application on running on it. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 9:07 PM To: [EMAIL PROTECTED] Subject: Re: [SNMP/MRTG Through ColdFusion] what version of CF are you using? what OS? what are you trying to accomplish? you could write a front end to the mrtg.cfg file but i am not sure if thats what your asking. "Benjamin S. Rogers" [EMAIL PROTECTED] wrote: Has anyone developed a tag/applet that talks SNMP? Better yet has anyone developed a ColdFusion app similar to MRTG (or even a ColdFusion MRTG wrapper)? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarÿstsbodyÿsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Upgrading SQL 6.5 - 7.0?
All in all, it was one of the smoothest upgrades (of that relative magnitude) I've ever done. We upgraded about 20 or so databases of varying size and complexity. The only issues we ran into were the fault of bad programming on the developer's part. Some badly designed SQL Queries quit running after the upgrade. On the average, each query took only a moment to fix. For instance, the SQL Server 7 syntax validator seems to be a little more judicious about what it will let pass: SQL Server 6.5 only seems to check whether or not a character, word or phrase is allowed but not necessarily the syntax in which it is used (e.g. stray semi-colons). The only other issue we had was also the fault of bad programming on the developer's side. Some of our developers got into the bad habit of using some reserved words. If I remember correctly, SQL Server prefixed an underscore to column names named after a word that SQL Server 7 put into use (e.g. "Date"). Where we got hit the hardest was with a table that was named "Logins." I don't believe "Logins" was on the reserved list, but SQL Server 7 adds several more system tables to each database, one of which is called "Logins." In this instance, the data simply did not transfer. We had to import the data separately into a table of a different name, change a few foreign key constraints, and change the SQL queries that used the table. None of which was terribly difficult. Anyway, everything you need to perform the upgrade should be on the SQL Server 7 CD ROM. After the upgrade, you'll just have to test your sites and monitor the ColdFusion error logs to determine what errors are occurring because of the upgrade. The SQL Server upgrade utility will notify you upon completion if any data fails to transfer from SQL Server for whatever reason. I believe it pipes it out to a text file, if I remember correctly. In any case, go for it. In our collective opinion, SQL Server 7 is a vastly superior product. In our situation it solved far more problems than it caused. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:59 PM To: [EMAIL PROTECTED] Subject: Upgrading SQL 6.5 - 7.0? Hi Has anyone on list overseen a project to upgrade a CF site's SQL backend from v6.5 to 7.0? I've been asked to quote a price for this project ... and haven't a clue what this entails (I'm familiar with SQL 7, but not 6.5) Any advice/related experience would be greatly appreciated. * john * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SNMP/MRTG Through ColdFusion
Has anyone developed a tag/applet that talks SNMP? Better yet has anyone developed a ColdFusion app similar to MRTG (or even a ColdFusion MRTG wrapper)? Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Mimicing the CFHeader StatusCode and StatusText in ColdFusion 4.0
Is there any way to achieve the functionality of the CFHeader StatusCode and StatusText attributes in ColdFusion 4.01? We're looking to issue a HTTP Status-Code 302 or 305 to the browser, but there doesn't seem to be a way to accomplish this in ColdFusion 4.01. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: appropriate SQL 7 licensing for CF website
SQL Server w/ as many client licenses as servers/workstations will be connecting to it (including the server SQL Server is running on) and the Internet Connector License (about $3000). -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 6:05 PM To: [EMAIL PROTECTED] Subject: OT: appropriate SQL 7 licensing for CF website Hi All, I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. I need to know which version of sql 7 I should purchase for unlimited internet connections/not developer connections I seem to recall that it's different than the true UNLIMITED client version which retails for something like $30K ... is there something cheaper than that -- what do most people do for their web sites?? THX! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: appropriate SQL 7 licensing for CF website
It sounds like the only thing that changed is that the server on which SQL Server is installed now needs its own special license, a "Server License." The CALs for workstations and ancillary servers are still necessary, as well as the Internet Connector for Internet users. Could they make this stuff any more complicated? Oh well, I guess it's still not as convoluted as the Oracle licensing scheme. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 9:30 AM To: [EMAIL PROTECTED] Subject: Re: appropriate SQL 7 licensing for CF website FYI new pricing model from microsoft http://www.microsoft.com/sql/productinfo/pricing.htm ~Justin - Original Message ----- From: "Benjamin S. Rogers" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 2:20 PM Subject: RE: appropriate SQL 7 licensing for CF website SQL Server w/ as many client licenses as servers/workstations will be connecting to it (including the server SQL Server is running on) and the Internet Connector License (about $3000). -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 6:05 PM To: [EMAIL PROTECTED] Subject: OT: appropriate SQL 7 licensing for CF website Hi All, I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. I need to know which version of sql 7 I should purchase for unlimited internet connections/not developer connections I seem to recall that it's different than the true UNLIMITED client version which retails for something like $30K ... is there something cheaper than that -- what do most people do for their web sites?? THX! -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: appropriate SQL 7 licensing for CF website
One thing to note when pricing these products is that Microsoft's site only lists the suggested retail price. I just saw a site that listed the Internet Connector for $1500. SQL Server itself (and its CAL packs) didn't have quite the same price reduction. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 11:17 AM To: [EMAIL PROTECTED] Subject: RE: appropriate SQL 7 licensing for CF website To run SQL Server legally on the internet, you NEED the Internet Connection License - this is not a cheap thing. Nope. Not so. You only need as many CALs as you have simultaneous connections. Of course, if you have a lot of connections, the Internet Connector is less expensive than CALs. True, but since SQL Server and a 25 user license costs $3,999 and SQL Server (with 5 user) costs $1,399 plus internet one costs $2,999 (total cost of $4,398), then you'd have to NEVER have over (roughly) 27 concurrent users on-line, in which case, you're VERY light on load, so is SQL Server really necessary? Since Access 2000 handles light loads quite easily (better than Access 97 anyways), then with that load level, you could use that and save yourself thousands of dollars Put it this way, we have one fair load site, and it hits about 30-40 concurrent quite often - as soon as you break the amount of users you've bought, then you're breaking the agreement (and therefore the law), even if it's only for a fraction of a second, it's still breaking your client level. Here's the funny thing with their licensing; SQL Server 5 Client $1,399 20 Client Licenses $2,369 Total £3,768 SQL Server 25 Client $3,999 WHY is the separate license version over $200 cheaper, and how stupid would you have to be to buy the more expensive one? (that took me 5 seconds of math to save me $231 - unless you get paid more than that, then it's worth buying separates!) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Rackmount Monitor/Keyboard/Mouse Switches
My apologies for the off topic post, but I rarely receive responses off the CF-Community list. Anyway, on to the question. What's everyone using for rack mount monitor/keyboard/mouse switches? We're a little dissatisfied with our current solution. We're looking for a piece of hardware that: 1. Requires absolutely no software loaded on the server. 2. Can support (preferably) up to 16 servers with a single unit. 3. Supports true hardware emulation (not a scenario in which the switch has to be turned to a server when it boots so that the server picks up the keyboard and mouse) Any suggestions would be greatly appreciated. Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Functions in Cold Fusion
Hmm...a very interesting proposition. How about the following:
ArrayFind()
ArrayFindNoCase()
ArrayContains()
ArrayContainsNoCase()
In regards to your requirements, I imagine the ColdFusion function
ArrayToList() could be used in conjunction with the respective list
functions to "mimic" the functionality of the aforementioned functions.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 1:10 PM
To: [EMAIL PROTECTED]
Subject: Re: Functions in Cold Fusion
OK, I need some community input here. For my article on custom functions,
I've written one for IsEmail and IsPhone. Can people send me a few others to
'add in'. I'd like the article to have a few pre-built functions that can be
used right off the bat. The only limits are that they must be built using
functions in CF. No tags. For example, IsPhone uses this code:
REFindNoCase('([0-9]{3}[-_. /]?)?[0-9]{3}[-_. /]?[0-9]{4}', number)
- Original Message -
From: "Michael Dinowitz" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 01, 2000 12:42 PM
Subject: Re: Functions in Cold Fusion
I'm currently writing an article for the next Fusion Authority (out in the
next day) on how to write and use custom functions in CF. This is not
using
modules or any CF tags but is actually using function calls. It's a bit of
a
hack and can look ugly in places, but it works. The result is that I can
have something like IsValidEmail(email) and it'll return a value that says
yes or no.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: what is better varchar or char
I was told that char is better than varchar. Is this right? I am going to have fields that are set to be either 25 50 100 or 150 characters long. Is there a reason any of these fields should be char or varchar? I have always used varchar but I would like to know what is best. As in most things, "Better" is a relative judgment. The primary difference is that CHAR fields are right padded with spaces which can make them difficult to work with if your data is not all of the same size (say an SKU that is always a certain number of characters in length). VARCHAR fields store variable length character data without padding the data with white space. In my experience, the data stored in VARCHAR fields is easier to work with because I find I'm using the TRIM() function often with CHAR fields to eliminate the excess spaces. One other key difference in terms of functionality is that the CHAR data type does not allow null values. If you create a field in a table as CHAR with nulls allowed, SQL Server will just create that field as VARCHAR and you'll never know the difference except if you expect the data to be padded. Since the CHAR data type has less overhead associated with it, it is slightly faster than the VARCHAR data type. However, this is very minimal performance gain, one that is completely negated if you find yourself using the TRIM() function on the ColdFusion side. Feel free to respond directly to me since it is OT ;-) Actually, I think this is pretty right on. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: $1,000 servers (was: High-Powered Scaling)
Where I used to work, the decision to use Dell something of a company policy. I prefer to purchase, build and maintain "clone" machines for the following reasons: 1) %50 to %75 cost savings for the same or better system. 2) Dell uses proprietary RAM and charges at least 3x the going rate. 3) Dell puts unrealistic (and in my mind, unnecessary) restrictions on the amount of RAM you can put in a box, killing the one true upgrade path left in modern computers. 4) Dell short-changes the consumer on DIMM slots: you have to throw out memory to add more. 5) Dell uses proprietary motherboards with onboard video (and sound in the case of their desktops). 6) Dell's warrantee/replacement policy is great if something breaks on a week day between the hours of 5 and 9: otherwise, you're screwed. Although their phone support is fine (minus the hours on hold with Mozart's 5th), they've never walked into my office to fix anything: I end up doing all the work anyway. The only time a member of their tech support staff has told me something I didn't already know, it was because Dell was using a proprietary setup (RAID card, Motherboard, Video Card, etc.) that I couldn't find information about anywhere else. As far as the applications they load on servers before you get them, you can keep them. The fact that they would even preload so many computer crashing applications of questionable usefulness onto a server is absolutely ridiculous. I made a practice of reinstalling NT on Dell's immediately after I took them out of the box. I find this greatly increases the OS life expectancy and reduces the crash frequency. Now, I don't mean to pick on Dell in particular, but their name was mentioned, and I happen to have quite a bit of experience with their servers, desktops and support. All in all, Dell is in my mind, the best of the brand name products, both for servers and for the desktops. And, to give the Devil his due, I really appreciated their online driver library: I found it very comprehensive, accurate and up-to-date. I'll stop ranting now. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 The facts, in my case, are that the 15 percent that I might pay for Dell over SAG (I couldn't find telenet) is worth it to me, because, over the past five years, Dell has really stood by their machines. I have purchased about 50 Dells and speced hundreds. We have had a DOA machine, which was replaced the next day and we have had machines fail in the last month of warrantee, but the service has been great. The phone support is also great, but the best thing, from my perspective, are the setup and configuration utilities and instructions which ship with the machines. These save hours on machines with complex setups and greatly simplify management. A few years ago we were buying (on the NT side) a mix of IBM, HP, Compaq and Dell. We whittled it down to just Compaq and Dell and, now, we are buying Dells almost exclusively. SAG, BTW, charges about the same price for RAM as Dell At 11:51 AM 7/27/2000 -0700, you wrote: --- snip --- The savings comes down to the fact that if you build your own, or preferably hook up with a company like telenet, you won't pay for the name "Dell", which adds about 20% to the price tag. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call a javascript button
This will close the current window. However, if JavaScript did not create the window, the client will receive a JavaScript prompt. I've added a button which can be used to redirect the window to another page without submitting the form. This is only supported in newer browsers (4+). You may just want to embed another form for this if you want to support older browsers. form action="Some.cfm" method="post" input type="text" input type="submit" value="Save" input type="button" value="Close" onClick="window.close()" input type="button" value="Cancel" onClick="window.location='SomeOtherPage.cfm'" /form Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call a javascript button
This is only supported in newer browsers (4+) I should explain my statement a little better. The JavaScript function "close()" and property "location" are almost universally supported by any client that supports JavaScript. It's the HTML INPUT element of type "button" that is only really supported in 4+ generation browsers. Sorry if I confused you. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to call a javascript button
Are you saying you can nested forms? No, at least not from my experience. I meant that for backwards compatibility, you would have to make use of multiple forms in the page. Something like: form action="Some.cfm" method="post" input type="text" input type="submit" value="Save" /form form action="" method="get" input type="submit" value="Close" onClick="window.close()" /form form action="SomeOtherPage.cfm" method="get" input type="submit" value="Cancel" /form To the end user it would appear like a single form since the only input elements displayed by the second to forms are submit buttons. Since the form buttons are of the type "Submit" rather than "Button," they are backwards compatible. The down side to this method is that you may have to create some invalid nesting structures to try and lose the white space created by the various form tags, a particularly egregious design/display issue in the various browsers. Since most of my forms are tabled for layout purposes, I usually nest the form tags in table tags, much to the horror of the W3C, I imagine. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF on WebsitePro - Frequent hangs
We used to run CF (4.01) on WebSite and the only time we ran into problems was when ColdFusion driven apps would have to make calls through a slow network. Specifically, we were making calls from a high traffic Web site across the Internet to a database server. The clients were connected via SSL and the SSL threads would pile up until the pool ran out. We increased the size of the pool and that seemed to fix the problem. I'd call O'Reilly's tech support. They have the best tech support staff that I've ever dealt with. Tell them what your problem is and any weird situations/work a rounds in place, and they'll tell you what you need to get back up and running. They won't laugh at you if you're doing something stupid: well, at least they didn't laugh at us. :) Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Reed Powell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 25, 2000 10:48 AM To: [EMAIL PROTECTED] Subject: CF on WebsitePro - Frequent hangs Hello everyone - we're running CF on Website Pro on our production box, and see frequent hangs of the CF service(s). It's not uncommon for them to hang a couple of times a day. We ended up putting in a workstation that keeps an eye on the production box, and restarts the CF services if they don't respond. Do others see this behavior, either with Website or other webservers (such as IIS)? tia, -reed -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Books
What makes a SQL book good is subjective: it depends on what you want to do with SQL, which vendor's SQL implementation you are using, and what skill level you are at. Despite the fact that SQL is a "standard," you'll want to get yourself a book that discusses your vendor specific flavor of SQL (e.g. Microsoft, Oracle, Sybase, mySQL). We use Microsoft SQL Server almost exclusively so my choices are biased in that direction. Unfortunately, I haven't read any decent database administration books (vendor specific or otherwise), but I do have a few recommendations on the programming side: Beginners: The Practical SQL Handbook : Using Structured Query Language I believe this one is written by a bunch of ex-Sybase employees, but it is pretty universal. Advanced: Transact-SQL Programming by O'Reilly Covers Sybase and Microsoft SQL Server Both are excellent books. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ODBC/SQL Server Errors
We're experiencing a fairly difficult to troubleshoot SQL issue using ColdFusion 4.01/SQL Server 6.5 (w/ whatever the latest service pack is). Almost all UPDATE and INSERT statements started generating "37000 (Syntax error or access violation)" messages when executing queries involving VARCHAR fields, though not INTEGER IDENTITY fields. In other words, if I add a row with a mess of NULL values, the query executes. When I copy and paste the SQL statements into Enterprise Manager, it spits out: Msg 7134, Level 16, State 2 Command has been aborted. The ODBC error is too general to be of any use; the SQL Server error barely appears in the MSKB, and when it does, it's only in inapplicable situations that seem to have been solved by some early service pack. I've stopped and started the services, booted, and run all appropriate DBCC commands against the database. As far as I know, nothing has changed (famous last words). In fact, I was sitting at my workstation by the servers on Saturday surfing the site the server in question when errors first started appearing. I've already spent my weekend on this one. If anybody can spare my week, it would be greatly appreciated. Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ODBC/SQL Server Errors
I just wanted to post an update to the issue I posted earlier (below) in case someone else runs into this problem in the future. After having tried every other possible outlet, I created a temp database, transferred the data from the old database into the temp database, recreated the old database, and transferred the data back. This seems to have fixed the problem. Apparently, the database had become corrupt, and SQL Server didn't realize it. I still don't know what caused the problem, but at least I know how to fix it. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 24, 2000 9:53 AM To: [EMAIL PROTECTED] Subject: ODBC/SQL Server Errors We're experiencing a fairly difficult to troubleshoot SQL issue using ColdFusion 4.01/SQL Server 6.5 (w/ whatever the latest service pack is). Almost all UPDATE and INSERT statements started generating "37000 (Syntax error or access violation)" messages when executing queries involving VARCHAR fields, though not INTEGER IDENTITY fields. In other words, if I add a row with a mess of NULL values, the query executes. When I copy and paste the SQL statements into Enterprise Manager, it spits out: Msg 7134, Level 16, State 2 Command has been aborted. The ODBC error is too general to be of any use; the SQL Server error barely appears in the MSKB, and when it does, it's only in inapplicable situations that seem to have been solved by some early service pack. I've stopped and started the services, booted, and run all appropriate DBCC commands against the database. As far as I know, nothing has changed (famous last words). In fact, I was sitting at my workstation by the servers on Saturday surfing the site the server in question when errors first started appearing. I've already spent my weekend on this one. If anybody can spare my week, it would be greatly appreciated. Thanks. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: mail transfer agents
I've had to research this problem in the past. In the company for which I used to work, we had three different server admins in three different offices, each running a different MTA (VOPmail on NT, SendMail on Linux, and qMail on Linux). We ran into problems with qMail accepting mail from our VOPmail server. After much research (and heated arguments), we found some posts in the qMail news groups in regards to the manner in which qMail handles (or doesn't handle) Bare LFs (ASCII Line Feed characters without corresponding ASCII Carriage Returns). Although, according to the standards, Bare LFs are not allowed within message headers or at the end of the message, Bare LFs (and any other ASCII character for that matter) are allowed within the body of the message itself. qMail, though arguably the most standards compliant MTA around, has (had) a couple bugs in the code which both stripped LF/CR pairs, replacing them with Bare LFs, and refused to accept any message with a Bare LF, even if the Bare LF(s) occurred within the body of the message. The former is a particularly egregious bug as it actually changes the content of the message aside from merely appending headers. The second, occurring under specific circumstances, is what caused the problem Ian mentioned. For this reason, most qMail admins run qMail with a switch (which I forget off hand) which tells qMail to ignore all Bare LFs. The switch's original purpose was to make qMail backwards compatible with older MTAs (such as SendMail) which have historically ignored Bare LFs, allowing major companies to develop e-mail clients which never use LF/CR pairs. If you're experiencing one of these problems, and the latest version of qMail doesn't fix them, I found posts in the news groups which identified the offending piece of source code and discussed the best way to change the code so that the server could be recompiled without the bugs. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Judah McAuley [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 7:47 PM To: [EMAIL PROTECTED] Subject: Re: OT: mail transfer agents At 04:27 PM 7/14/2000 -0700, you wrote: Watch out when using cfmail on solaris (and more than likely linux as well) when sending via a qmail SMTP server. I recently found that the messages wouldn't go out because of bare linefeeds. CF would return the messages to the coldfusion/mail/undelivr folder. The workaround was to save the entire template with the cfmail tag in "dos" format (Studio was saving in unix format...The unix2dos program was useful) Then the qmail server will accept the message. Very annoying, but the mail does seem to be going out now! So far I have not run across this problem with sendmail. Ian I haven't had that problem with qmail under linux. I can send a message using cfmail (on an NT box) through qmail as an smtp server running on a Linux box. No issues. Judah -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What are you using instead of IDENTITY...Part II
The true test of a key, is to think of a situation where you are asked to extract a subset of data (ie. set of master with all related details) into a new database with an identical structure. The test is met if you are able to perform the transition and maintain all relationships. On this score IDENTITY fails. Not to argue just for the sake of arguing, but yesterday I just moved most of the data in one database to another with a slightly different structure (including a slightly different degree of normalization). The tables in the previous database all contained IDENTITY fields with a couple minor exceptions. Although I understand the theory behind the arguments against IDENTITY fields, I maintain that real world applications do not support the theory in most situations. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: What are you using instead of IDENTITY?
For awhile I tried to avoid using IDENTITY columns in the name of theoretical "best practices." However, it seemed to cause quite a few problems in regards to data storage (whatever ended up as the primary key was invariably larger and more cumbersome than an integer field) and terribly difficult to update (e.g. foreign key constraints needed to be dropped before updating data in the primary key field and recreated afterwards). In addition, the abstraction of the PRIMARY KEY from the data works towards normalizing (not "normalizing" in the sense of relational data but in the lay sense) database design, layout and implementation. On the other hand, avoiding IDENTITY columns didn't fix any practical problems. For these reasons, I've reversed my position and include IDENTITY columns on most tables that require a primary key. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting ahold of milliseconds?
Checkout the GetTickCount() function in ColdFusion 4+. -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 2:18 PM To: '[EMAIL PROTECTED]' Subject: Getting ahold of milliseconds? Anyone out there in ColdFusionLand know of a way to grab ahold of milliseconds as far as putting a value into a variable? The debug info is great, but we're trying to measure performance throughout a page. It's easy enough to do timestamps using "Now()" and compare the results as you go, but one can only get seconds out of this method. --Scott -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
