Apache 2.0.40 - CFMX and Virtual Hosts
Hi all. Just wondering: I've been fighting with using virtual hosts and CFMX for a week or so now and I simply cannot get it to work. No matter what I do, my Apache/CF combo will only serve CF templates from the first document root (C:\CFusionMX\wwwroot). I have modified jrun.xml to set the cacheRealPath to false (according to http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179 http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179Method=Full Method=Full) and CF will still only serve documents out of the main document root. I give up. I keep hearing about people that have it working fine. What's the trick? Mike Wallick * Web Application Developer * mailto:mike_wallick;securecomputing.com [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ http://www.securecomputing.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFXImage not CFX_Image
I'd be interested in that tag too. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 12:42 PM To: CF-Talk Subject: CFXImage not CFX_Image Hey All, Well I have discovered the other image tag CFXImage (not to be confused with CFX_Image). I got my hands on version 1.6.6.3, but I need the current version (1.6.6.6 I think) which has a security fix to stop users from potentially gaining access to ALL files on the partition that it resides on. The current version should come from www.gafware.com, but it was down yesterday and today!! So if anybody has a current version, please pass it along offlist. BTW Does anybody have experience with both tags? Any comments would be great. Thanks in advance Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cffile Replacement
Hey all. Anyone have any tricks to using cffile to upload files when the cf server is running as nobody (solaris)? My host has cffile enabled, but the cf process runs as nobody so it can't write to my web root. Is there any way around this? Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cffile Replacement
Unfortunately, that's not an option. I don't have any control over the server. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: CF-Talk Subject: RE: Cffile Replacement Assign a group to the directory and give it write permissions. Then add the user nobody to the group. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:15 AM To: CF-Talk Subject: Cffile Replacement Hey all. Anyone have any tricks to using cffile to upload files when the cf server is running as nobody (solaris)? My host has cffile enabled, but the cf process runs as nobody so it can't write to my web root. Is there any way around this? Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cffile Replacement
It'd be nice if cfimpersonate worked under unix, instead of just windows. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:37 PM To: CF-Talk Subject: RE: Cffile Replacement Well then there is no hope. It doesn't matter if you use cffile, some CFX, or some Java object; all of them will execute as the user nobody. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:35 AM To: CF-Talk Subject: RE: Cffile Replacement Unfortunately, that's not an option. I don't have any control over the server. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: CF-Talk Subject: RE: Cffile Replacement Assign a group to the directory and give it write permissions. Then add the user nobody to the group. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:15 AM To: CF-Talk Subject: Cffile Replacement Hey all. Anyone have any tricks to using cffile to upload files when the cf server is running as nobody (solaris)? My host has cffile enabled, but the cf process runs as nobody so it can't write to my web root. Is there any way around this? Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cffile Replacement
You mean have the directory permissions set to 777 (everyone can write)? -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:43 PM To: CF-Talk Subject: RE: Cffile Replacement Open the directory to the Nobody user. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:37 PM To: CF-Talk Subject: RE: Cffile Replacement Well then there is no hope. It doesn't matter if you use cffile, some CFX, or some Java object; all of them will execute as the user nobody. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:35 AM To: CF-Talk Subject: RE: Cffile Replacement Unfortunately, that's not an option. I don't have any control over the server. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: CF-Talk Subject: RE: Cffile Replacement Assign a group to the directory and give it write permissions. Then add the user nobody to the group. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:15 AM To: CF-Talk Subject: Cffile Replacement Hey all. Anyone have any tricks to using cffile to upload files when the cf server is running as nobody (solaris)? My host has cffile enabled, but the cf process runs as nobody so it can't write to my web root. Is there any way around this? Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick Help...
Just do a #ListLast(cgi.script_name, /)# to get the file name. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:54 PM To: CF-Talk Subject: Re: Quick Help... cgi.script_name -- problem is, it contains more than just the .cfm name On Wed, 24 Jul 2002, Kris Pilles wrote: Can someone quick tell me how to grab just the page name from the browser... For example I want to set pagename = index.cfm How do I get the index.cfm CGI. ? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 2:41 PM To: CF-Talk Subject: Re: JRun.exe is kicking our server's arse... Question...I am using CF5 and I have 2 jrun.exe when I view my running processes, is this normal? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Mike Byers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 11:37 AM Subject: RE: JRun.exe is kicking our server's arse... Have you ever tried it on a clean machine? Many things get left behind and a clean install does not always ensure success. Upgrades are notorious for this because no one can predict what other applications do to the dll's. Anyway, food 4 thought. Mike -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:19 PM To: CF-Talk Subject: RE: JRun.exe is kicking our server's arse... I have had several versions of CFMX on my machine. However, I always do a clean install. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 11:16 AM To: CF-Talk Subject: RE: JRun.exe is kicking our server's arse... Just out of curiosity, but did you ever have another version of CFMX on the machine (i.e. trial, beta, rc?) Or where these machines w/a clean install? -Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:51 PM To: CF-Talk Subject: RE: JRun.exe is kicking our server's arse... I had the same problem uninstalled cfmx and reinstalled problem resolved. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:45 PM To: CF-Talk Subject: RE: JRun.exe is kicking our server's arse... I have seen this too, but couldn't track down the problem. A reinstall of CFMX fixed it thoug. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:45 AM To: CF-Talk Subject: JRun.exe is kicking our server's arse... About every couple of minutes now, CFMX is dieing a slow and miserable death on our development server until we reboot (Jrun.exe is taking up 99% of the processes.) I'm not posting to slam Macromedia about releasing a buggy product or anything, but this isn't so good for our productivity. Has anyone else been experiencing this? Howabout any solutions? (That would be real nice!) We're in the process of ordering a new server, but currently we are running 350 PIII, 768 MB Ram, IIS, etc.. Our apps ran fine for couple of weeks, but now they are just hurting... Tyler Silcox email | [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: jsp questions/Good JSP/CF host
I use cqhost.com. I don't use their JSP server, but it is available if you want. They also have CF 5, PHP 4.x, Chilisoft ASP, mySQL, etc. I've been very happy with them so far. Mike -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:21 AM To: CF-Talk Subject: OT: jsp questions/Good JSP/CF host Hi, I've been sent several jsp pages by an entity that would like for us to use the pages to interface with their remote server via xml. However, it appears that our cf host does not support jsp.* I suppose I have to ask the age-old question, but with a twist: can anyone recommend a good cf host that also supports jsp? * I am assuming our current server does not support jsp because When I run the pages, the following errors occur: - though the html is visible, the jsp variables do not show. - I get a 405 Method not Allowed error when I post a form. Do I have alternatives other than to switch hosts and/or recreate the pages in cfm? The latter would be a good way to learn how to work intimately with xml but unfortunately this was due yesterday :-) Thanks in advance, Andrew __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 403 handler and CF code
I don't know about 403's, but for my custom 404's I specify a URL for the error page, rather than a file (i.e. /index.cfm?fuseaction=home.404 as opposed to dsp_404.cfm). Know what I mean? Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Dimo Michailov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:05 AM To: CF-Talk Subject: 403 handler and CF code I have been trying to create a 403 error handler (that is when someone tries to hit a secure site without the HTTPS) and place some Cold Fusion code inside. I setup the 403 handler in IIS to point to a CFM template that displays the current template and recommends dynamically the correct link. However, when I test it, the CF code does not run and instead is displayed inside the webpage. Any ideas what is happening? Is IIS unable to run CFM code in 403 (or 404) handlers? Thanks, Dimo __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing a list to a Stored Procedure
Send each element of the list as it's own cfprocparam. Like this: cfstoredproc procedure=procedure datasource=#dsn1# returncode=No debug=No cfloop index=this list=#list# cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#this# /cfloop /cfstoredproc That will send the values to the stored proc as (value1,value2,valueN). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:17 AM To: CF-Talk Subject: Passing a list to a Stored Procedure Sorry for the somewhat OT Post, but this is one of my better resources for CF I have I was wondering if anybody had any code snippets for passing a list to a SQL Server 2000 stored procedure. I have the CF front-end working fine but when I send the list (61755,61754) to the stored procedure I get no results, when I pass a singe variable (61755), I get the results that I am looking for. Here is my stored procedure: CREATE PROCEDURE MasterAssignments @ClientList nvarchar (4000) AS SELECT Assignments.dbnum, Master.prim_name, Master.prim_ssn, SUM(Assignments.currbal) AS TotalBalance FROM Assignments INNER JOIN Master ON Master.dbnum = Assignments.dbnum WHERE Assignments.clnt IN (@clientList) GROUP BY Assignments.dbnum, Master.prim_name, Master.prim_ssn ORDER BY Master.prim_name GO Any suggestions or leads would be very helpful, I have been working on this problem for a couple of days know Thanks Jason Larson [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing a list to a Stored Procedure
Make sure the length of the list you're passing is the same as or less than the number of parameters the stored proc expects. Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:26 AM To: CF-Talk Subject: RE: Passing a list to a Stored Procedure When I try that I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function MasterAssignments has too many arguments specified. Great idea though, I will continue to work on it. Jason -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:23 AM To: CF-Talk Subject: RE: Passing a list to a Stored Procedure Send each element of the list as it's own cfprocparam. Like this: cfstoredproc procedure=procedure datasource=#dsn1# returncode=No debug=No cfloop index=this list=#list# cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#this# /cfloop /cfstoredproc That will send the values to the stored proc as (value1,value2,valueN). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:17 AM To: CF-Talk Subject: Passing a list to a Stored Procedure Sorry for the somewhat OT Post, but this is one of my better resources for CF I have I was wondering if anybody had any code snippets for passing a list to a SQL Server 2000 stored procedure. I have the CF front-end working fine but when I send the list (61755,61754) to the stored procedure I get no results, when I pass a singe variable (61755), I get the results that I am looking for. Here is my stored procedure: CREATE PROCEDURE MasterAssignments @ClientList nvarchar (4000) AS SELECT Assignments.dbnum, Master.prim_name, Master.prim_ssn, SUM(Assignments.currbal) AS TotalBalance FROM Assignments INNER JOIN Master ON Master.dbnum = Assignments.dbnum WHERE Assignments.clnt IN (@clientList) GROUP BY Assignments.dbnum, Master.prim_name, Master.prim_ssn ORDER BY Master.prim_name GO Any suggestions or leads would be very helpful, I have been working on this problem for a couple of days know Thanks Jason Larson [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing a list to a Stored Procedure
Oh...I see. Skip the loop thing for a minute. Normally, when you are executing a SP in the query analyzer, you specify parameters like (param1,param2) with commas being the separator. In this case, your parameter contains commas so try this: cfstoredproc procedure=procedure datasource=#dsn1# cfprocparam type=In cfsqltype=CF_SQL_VARCHAR maxlength=4000 dbvarname=@varname value=33,10 cfprocresult name=foo resultset=1 /cfstoredproc Note that I am passing a varchar value (CF_SQL_VARCHAR) not an integer. -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:38 AM To: CF-Talk Subject: RE: Passing a list to a Stored Procedure I am not to sure what you mean, This is my first time working with SP's. The SP is expecting one variable, a list @ClientList, but the list could contain 1 element or many more. MY SP is at the bottem of this post Thanks Jason -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:31 AM To: CF-Talk Subject: RE: Passing a list to a Stored Procedure Make sure the length of the list you're passing is the same as or less than the number of parameters the stored proc expects. Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:26 AM To: CF-Talk Subject: RE: Passing a list to a Stored Procedure When I try that I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function MasterAssignments has too many arguments specified. Great idea though, I will continue to work on it. Jason -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:23 AM To: CF-Talk Subject: RE: Passing a list to a Stored Procedure Send each element of the list as it's own cfprocparam. Like this: cfstoredproc procedure=procedure datasource=#dsn1# returncode=No debug=No cfloop index=this list=#list# cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#this# /cfloop /cfstoredproc That will send the values to the stored proc as (value1,value2,valueN). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:17 AM To: CF-Talk Subject: Passing a list to a Stored Procedure Sorry for the somewhat OT Post, but this is one of my better resources for CF I have I was wondering if anybody had any code snippets for passing a list to a SQL Server 2000 stored procedure. I have the CF front-end working fine but when I send the list (61755,61754) to the stored procedure I get no results, when I pass a singe variable (61755), I get the results that I am looking for. Here is my stored procedure: CREATE PROCEDURE MasterAssignments @ClientList nvarchar (4000) AS SELECT Assignments.dbnum, Master.prim_name, Master.prim_ssn, SUM(Assignments.currbal) AS TotalBalance FROM Assignments INNER JOIN Master ON Master.dbnum = Assignments.dbnum WHERE Assignments.clnt IN (@clientList) GROUP BY Assignments.dbnum, Master.prim_name, Master.prim_ssn ORDER BY Master.prim_name GO Any suggestions or leads would be very helpful, I have been working on this problem for a couple of days know Thanks Jason Larson [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing a list to a Stored Procedure
DOH! Of course. Put single quotes inside the IN() clause.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 11:22 AM
To: CF-Talk
Subject: RE: Passing a list to a Stored Procedure
Mike,
I think that I have this thing figured out. This SP seems to work fine.
CREATE PROCEDURE MasterAssignments (
@ClientList nVarchar(4000))
AS
BEGIN
EXEC ('
SELECT Assignments.dbnum, Master.prim_name, Master.prim_ssn,
SUM(Assignments.currbal) AS TotalBalance
FROM Assignments INNER JOIN Master ON Master.dbnum =
Assignments.dbnum
WHERE Assignments.clnt IN (' + @ClientList + ')
GROUP BY Assignments.dbnum, Master.prim_name, Master.prim_ssn ORDER BY
Master.prim_name
')
END
GO
Thanks for your help mike
Jason
-Original Message-
From: Wallick, Mike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 9:17 AM
To: CF-Talk
Subject: RE: Passing a list to a Stored Procedure
Oh...I see. Skip the loop thing for a minute.
Normally, when you are executing a SP in the query analyzer, you specify
parameters like (param1,param2) with commas being the separator. In this
case, your parameter contains commas so try this:
cfstoredproc procedure=procedure datasource=#dsn1#
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR maxlength=4000
dbvarname=@varname value=33,10
cfprocresult name=foo resultset=1
/cfstoredproc
Note that I am passing a varchar value (CF_SQL_VARCHAR) not an integer.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:38 AM
To: CF-Talk
Subject: RE: Passing a list to a Stored Procedure
I am not to sure what you mean, This is my first time working with SP's. The
SP is expecting one variable, a list @ClientList, but the list could contain
1 element or many more. MY SP is at the bottem of this post
Thanks
Jason
-Original Message-
From: Wallick, Mike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 8:31 AM
To: CF-Talk
Subject: RE: Passing a list to a Stored Procedure
Make sure the length of the list you're passing is the same as or less than
the number of parameters the stored proc expects.
Mike Wallick
* Web Application Developer
* [EMAIL PROTECTED]
* 651.628.5377
* http://www.securecomputing.com/
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:26 AM
To: CF-Talk
Subject: RE: Passing a list to a Stored Procedure
When I try that I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function
MasterAssignments has too many arguments specified.
Great idea though, I will continue to work on it.
Jason
-Original Message-
From: Wallick, Mike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 8:23 AM
To: CF-Talk
Subject: RE: Passing a list to a Stored Procedure
Send each element of the list as it's own cfprocparam. Like this:
cfstoredproc procedure=procedure datasource=#dsn1# returncode=No
debug=No
cfloop index=this list=#list#
cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#this#
/cfloop
/cfstoredproc
That will send the values to the stored proc as (value1,value2,valueN).
Mike Wallick
* Web Application Developer
* [EMAIL PROTECTED]
* 651.628.5377
* http://www.securecomputing.com/
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:17 AM
To: CF-Talk
Subject: Passing a list to a Stored Procedure
Sorry for the somewhat OT Post, but this is one of my better resources for
CF I have
I was wondering if anybody had any code snippets for passing a list to a SQL
Server 2000 stored procedure. I have the CF front-end working fine but when
I send the list (61755,61754) to the stored procedure I get no results, when
I pass a singe variable (61755), I get the results that I am looking for.
Here is my stored procedure:
CREATE PROCEDURE MasterAssignments
@ClientList nvarchar (4000)
AS
SELECT Assignments.dbnum, Master.prim_name, Master.prim_ssn,
SUM(Assignments.currbal) AS TotalBalance
FROM Assignments INNER JOIN Master ON Master.dbnum =
Assignments.dbnum
WHERE Assignments.clnt IN (@clientList)
GROUP BY Assignments.dbnum, Master.prim_name, Master.prim_ssn ORDER BY
Master.prim_name GO
Any suggestions or leads would be very helpful, I have been working on this
problem for a couple of days know
Thanks
Jason Larson
[EMAIL PROTECTED]
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfif... not working properly?
Try cfif ListFindNoCase(URLDecode(dir),\data, \) Note the \ at the end of the function call. This tells the function to delimit the list on a \. In your code cfif ListFindNoCase(URLDecode(dir),\data), since you aren't specifying a delimter, it defaults to a , which when using C:\temp\test\data\123\ is a one element list. Get it? Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 12:55 PM To: CF-Talk Subject: cfif... not working properly? Hi, In this example the results from my #URLDecode(dir)# is C:\temp\test\data\123\ I'm trying to check is the directory data exists in the variable and if so, do something else. The syntax below is not working properly. What am I doing wrong? cfif ListFindNoCase(URLDecode(dir),\data) h5You are in the data directory/h5 cfelse h5You are somewhere else/h5 /cfif __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What does this mean?
I am setting a client variable with a random number ( RandRange(0, 9) ) and I get this: CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321 What the hell does that mean? Mike Wallick * Web Application Developer * mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ http://www.securecomputing.com/ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Design Rates
Hey all. I'm about to dive into the world of freelancing and I was wondering - Where might I get a good idea of what to charge for my services? I was thinking that there would be separate costs for design (just how the page looks, not what it does) and actual programming tasks (site management, news board, forums, etc). I don't even know where to begin. Any advice would be great. Thanks. Mike Wallick * Web Application Developer * mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ http://www.securecomputing.com/ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: if value exists, show it
Personally, I use the ValueOrSpace() UDF from http://www.cflib.org. cfif Len(variable) is one I use quite often as well. I use ValueOrSpace() when say, populating a table from a db query, and Len(variable) when I'm deciding to do one thing or another with processing (like form processing). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: trey [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:08 PM To: CF-Talk Subject: if value exists, show it I simply want to test to see if a variable has a value (eg text has been returned from a query) and if so, show it. There seem to be a few options -- cfif isdefined(#variable#) #variable# /cfif or cfif len(#variable#) GT 0 #variable# /cfif or cfif #variable# IS #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Memory problems
I think in the cfusion\bin directory there is a batch file provided that sets up your scheduler to restart cf services at 2am (or so). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:10 PM To: CF-Talk Subject: RE: Memory problems That's a known Feature Schedule a task that restarts all the cold fusion services in the middle of the night using the command line net stop and net start commands. It's documented in the knowledge base somewhere deep in there, but it's pretty simple to get a batch file built to restart the cold fusion services... -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:04 AM To: CF-Talk Subject: Memory problems We've been having problems lately with our server running out of memory. I've gone over everything looking for unlocked session variables and cfx tags. We've increased the amount of RAM on the server. But still we're having problems, which seem manifest themselves first in errors generated by cfx tags and then in loss of connection to the database (Access). Does anyone have any advice on how to proceed to find out the cause of the problem? Somewhere I heard that ColdFusion server doesn't release memory once it uses it--that it holds on to it just in case. Is this true? -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Memory problems
Cycle.bat sets up the scheduler. Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 1:43 PM To: CF-Talk Subject: Re: Memory problems So, the consensus is Access is the problem! I wonder if the memory problems have gotten worse in the past couple of months because of the growing size of the database? I think in the cfusion\bin directory there is a batch file provided that sets up your scheduler to restart cf services at 2am (or so). So running Cycle.bat sets up the scheduler? Or do I need to schedule Cycle.bat to be run? I guess conversion to MySQL is now on the top of the pile after vacation. -- Owen We've been having problems lately with our server running out of memory. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RegExp Help
Hey all. I'm trying to cook up a regexp to search a block of text for links. What I'm looking for is something like: a href=path with spaces/file with spaces.htm I want to read the block of text and replace spaces with %20 so links won't break. I know, I know, links shouldn't have spaces in them, but this is something I inherited and changing all the links and filenames associated with them is not an option (there are thousands of links/files). I've tried this: cfset content=REReplaceNoCase(content, 'a href=(.*)', 'a href=#URLEncodedFormat(\1)#', all) and this: cfset content=REReplaceNoCase(content, 'a href=(.*)', 'a href=#Replace(\1, , %20))#', all) and those don't work. Can I not use CFML functions on a regexp subexpression (\1) ? I'm not exactly an expert on regexps, so any help would be greatly appreciated. Mike Wallick Web Application Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 651.628.5377 http://www.securecomputing.com http://www.securecomputing.com/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Wishlist
Oh, man! That would be great. -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 11:42 AM To: CF-Talk Subject: CF Wishlist Ok, Have carefully considered what I want from CF, the most striking feature I want to see is... Stop treating empty list items as null. That is a list of 3,5,,,3,2,2 should have a length of 7, instead of 5. Doing this would nearly eliminate the need for any field names like name=cost_#i#, since HTML sends back 3,5,,,3,2,2 for duplicate text fields named cost anyways. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX C++ API Documentation/Tutorials
Anyone know where I can get an API reference for building C++ CFX tags? The docs that come with CF server/studio are less than helpful. Mike Wallick Web Application Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 651.628.5377 http://www.securecomputing.com http://www.securecomputing.com/ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom Error Templates
Hey all. I'm using cferror to define a custom request error template and I'm having some strange issues: Naturally, I want the error page to look like the rest of the site (I like consistency). So I made the error template with the same colors, style stuff, etc. as the rest of the site. Here's the problem: Intermittently, the error page ignores any CFML tags, variables, etc. that I placed in it. The only variables that evaluate consistently are the #error.# variables. When I view the source, I can see some CFML code. What gives? Can't I use CFML in an error template? Mike Wallick Web Application Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 651.628.5377 http://www.securecomputing.com http://www.securecomputing.com/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom Error Templates
Then why does it work sometimes? I found that the CFML in my error template works fine, unless the error is a Request Timed Out error. Mike -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:24 PM To: CF-Talk Subject: RE: Custom Error Templates No, you can't. What happens if you have an error in the error page? - Matt -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 3:13 PM To: CF-Talk Subject: Custom Error Templates Hey all. I'm using cferror to define a custom request error template and I'm having some strange issues: Naturally, I want the error page to look like the rest of the site (I like consistency). So I made the error template with the same colors, style stuff, etc. as the rest of the site. Here's the problem: Intermittently, the error page ignores any CFML tags, variables, etc. that I placed in it. The only variables that evaluate consistently are the #error.# variables. When I view the source, I can see some CFML code. What gives? Can't I use CFML in an error template? Mike Wallick Web Application Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 651.628.5377 http://www.securecomputing.com http://www.securecomputing.com/ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom Tags as cfmodule
On my web host, I don't have a Custom Tags directory (at least I don't think so). My question is, is there a way to use a custom tag that requires an end tag (cf_tag/cf_tag) as a cfmodule? Mike Wallick Web Application Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 651.628.5377 http://www.securecomputing.com http://www.securecomputing.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom Tags as cfmodule
Schweet! Thanks guys. Mike -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 1:32 PM To: CF-Talk Subject: RE: Custom Tags as cfmodule Yes, this: cf_ray/cf_ray is the same as cfmodule template=tags/ray.cfm/cfmodule === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 2:20 PM To: CF-Talk Subject: Custom Tags as cfmodule On my web host, I don't have a Custom Tags directory (at least I don't think so). My question is, is there a way to use a custom tag that requires an end tag (cf_tag/cf_tag) as a cfmodule? Mike Wallick Web Application Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 651.628.5377 http://www.securecomputing.com http://www.securecomputing.com/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Complex List Delimiter
Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex List Delimiter
No, actually I mean the text string [pagebreak]. I'm not talking ASCII characters. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:48 PM To: CF-Talk Subject: RE: Complex List Delimiter when you say pagebreak, are you talking about a new line? if so it would ce defined as #chr(13)##chr(10)#. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:54 AM To: CF-Talk Subject: Complex List Delimiter Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RegExp Help
Anyone Have a RegExp to get all content between the BODY tags? I found a UDF that parses out the title, but I'm trying to modify it to parse out the body instead, but I'm not having much luck. Any help would be greatly appreciated. mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RegExp Help
You rock! That does exactly what I need it to do. Thanks Jerry Mike -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 1:13 PM To: CF-Talk Subject: Re: RegExp Help cfset BodyContent=reReplaceNoCase(fileContent,.*BODY[^]*(.*)/BODY.*,\1) (or something like that) Jerry Johnson [EMAIL PROTECTED] 03/20/02 01:10PM Anyone Have a RegExp to get all content between the BODY tags? I found a UDF that parses out the title, but I'm trying to modify it to parse out the body instead, but I'm not having much luck. Any help would be greatly appreciated. mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help! Problem registering serial number for cf 5.0 on HP/UX
Make sure you have the case right. On Solaris at least, the serial number is case-sensitive. Mike -Original Message- From: Smith, Don , , WHS/PSD [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 9:58 AM To: CF-Talk Subject: Help! Problem registering serial number for cf 5.0 on HP/UX I am not a Unix admin, that said, I was helping the Unix admin install CF over here. We went through the installation procedure, and typed in our serial number. No matter how many times it was entered, it came up invalid. I have installed CF successfully under windows dozens, if not hundreds, of times. Macromedia told us on the phone to just enter it in CF Admin. Checking the serial number in the admin showed that it's not installed. I can't find any place in CF Admin to enter in the serial number. I might edit the registry if it was on windows, but it's not. So any tips, tricks or help? Thanks, __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCONTENT and IE
Hey everyone. I have a quick question... I was looking at the mime examples from http://www.figleaf.com/demo/mimetest on how to force a download dialog for a file using cfheader and cfcontent and it works great in Netscape. However, in IE (5 or 6) it sometimes works and sometimes it crashes the browser. Anyone heard of this? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCONTENT and IE
No idea as to why? -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:09 PM To: CF-Talk Subject: RE: CFCONTENT and IE I had problems with IE that way, but it was trying to stream mp3 files using cfcontent. Sometimes it worked, sometimes it would freeze up the browser or just illegal op all together. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:42 PM To: CF-Talk Subject: CFCONTENT and IE Hey everyone. I have a quick question... I was looking at the mime examples from http://www.figleaf.com/demo/mimetest on how to force a download dialog for a file using cfheader and cfcontent and it works great in Netscape. However, in IE (5 or 6) it sometimes works and sometimes it crashes the browser. Anyone heard of this? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need something like the MSWC.BrowserType object
I like cf_AEBrowser myself. It's free, and it gives you all kinds of info on the user's browser. (watch for wrapping) http://devex.macromedia.com/developer/gallery/info.cfm?ID=32B3985F-4BA 3-11D4 -AA9A00508B94F380method=Full Mike -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 8:42 AM To: CF-Talk Subject: Re: Need something like the MSWC.BrowserType object There's a number of custom tags available, like cf_browser (all they do is parse the cgi.user_agent) - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 14, 2002 6:49 PM Subject: Need something like the MSWC.BrowserType object Hmm, it looks like I can't use the MSWC.BrowserType object in CF. Is there anything out there that's FREE that can get me the browser build (this is an IE specific app)? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Resources for COM objects esp MS Word
http://www.cfcomet.com - great ColdFusion - COM site. -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 10:04 AM To: CF-Talk Subject: Resources for COM objects esp MS Word Anyone know of any good web/print resources for using COM objects? We need to automatically launch Word and format data on our server for a client. TIA, Doug Jordon __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Web-based WYSIWYG content editor
ActivEdit from http://www.cfdev.com. It's licensed per web server and it's _very_ cool. Only works in IE is the only problem (not a problem here though, most of our content owners use IE anyway). I think it's about $100(US) for the encrypted version w/out a spellchecker, and about $175(US) for the encrypted version with a Java spell checker (very cool). Mike -Original Message- From: Michel Gallant [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 7:52 AM To: CF-Talk Subject: Web-based WYSIWYG content editor I'm looking for opinions on Web-based WYSIWYG editors for content management. I'm looking for something with lite lisencing (not per-user) __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
