RE: Changes to Functionality in Microsoft Windows XP Service Pack 2
I thought it was going to be bad, but I've been using the sp2 since yesterday and it's not that bad, my on going reports can be found on my blog @ http://www.beynon.org.uk/blog Jb. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 22:36 To: CF-Talk Subject: SOT: Changes to Functionality in Microsoft Windows XP Service Pack 2 This document focuses on the changes in Windows XP Service Pack 2 and its implications for developers. Examples and details are provided for several of the technologies that are experiencing the biggest changes. Future versions of this document will cover all new and changed technologies. See: http://www.microsoft.com/downloads/details.aspx?FamilyID=7bd948d7-b791-40b6- 8364-685b84158c78displaylang=en Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important:This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege.If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament.If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL Aggergate
If the last post hasn't solved your problem and you're using MySQL version 4.0.2 or above, then try using the CAST() or CONVERT() function on the _expression_ that's failing. Usage I think you're looking for is: SELECT TL.T_id, CAST(MAX(dPosted) AS CHAR) as LastDaySeen You can find the MySQL manual page here: http://www.mysql.com/doc/en/Cast_Functions.html -- Oliver Tupman Key Systems Geotechnical [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Java Mailing List
Great forums at the Big Moose Saloon here: www.javaranch.com http://www.javaranch.com/ Regards, Andr -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 17:11 To: CF-Talk Subject: Re: Java Mailing List Does anyone have any recommendations in regards to a decent Java mailing list? I was not too impressed with the forums over at suns site. Not to generalize but the developers there seem to snub beginners, which is too bad since we all start somewhere. really? i found the new to java forums to be relatively helpful, ditto for the i18n forums (though i've really never seen anythig like the cf community). maybe something here: http://www.cafeaulait.org/mailinglists.html you might also post questions to the java cf forums. there are some sharp folks there. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date Errors in MX ?
Jochem Thanks that seems to work, how would the syntax change for updating database records ?? cfquery datasource=#Application.DSN# name=insert_query UPDATE healthnewsletters (healthid, publishdate, title, summary, author, newsletterbody) SET ( cfqueryparam cfsqltype=cf_sql_number value=#healthid#, cfqueryparam cfsqltype=cf_sql_date value=#publishdate#, cfqueryparam cfsqltype=cf_sql_varchar value=#title#, cfqueryparam cfsqltype=cf_sql_varchar value=#summary#, cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname# #Session.Lname#, cfqueryparam cfsqltype=cf_sql_clob value=#content#) /cfquery -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 15:29 To: CF-Talk Subject: Re: Date Errors in MX ? Ian Vaughan wrote: That is very true, and I have added the missing line cfqueryparam cfsqltype=cf_sql_number value=#id#, But did not make any difference to the error message it is still saying what is shown below.It is also worth looking at the SQL and you will see that no values have been passed just (param1), (param2) etc ??? That is the way it should look when using cfqueryparam. 53 :cfqueryparam cfsqltype=cf_sql_varchar value=#security#, 54 :cfif isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif, 55 :cfqueryparam cfsqltype=cf_sql_blob value=#content# 56 : /cfquery 57 : SQLINSERT INTO itarticle (id, articledate, articletitle, articlesummary, articleauthor, security, imgsrc, articlebody) VALUES ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , NULL, (param 7) You are missing a right parenthesis. Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date Errors in MX ?
cfquery datasource=#Application.DSN# name=insert_query UPDATE healthnewsletters SET publishdate = cfqueryparam cfsqltype=cf_sql_date value=#publishdate#, title = cfqueryparam cfsqltype=cf_sql_varchar value=#title#, summary = cfqueryparam cfsqltype=cf_sql_varchar value=#summary#, author = cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname# #Session.Lname#, newsletterbody = cfqueryparam cfsqltype=cf_sql_clob value=#content# WHERE healthid = cfqueryparam cfsqltype=cf_sql_number value=#healthid# /cfquery -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: dinsdag 23 december 2003 11:39 To: CF-Talk Subject: RE: Date Errors in MX ? Jochem Thanks that seems to work, how would the syntax change for updating database records ?? cfquery datasource=#Application.DSN# name=insert_query UPDATE healthnewsletters (healthid, publishdate, title, summary, author, newsletterbody) SET ( cfqueryparam cfsqltype=cf_sql_number value=#healthid#, cfqueryparam cfsqltype=cf_sql_date value=#publishdate#, cfqueryparam cfsqltype=cf_sql_varchar value=#title#, cfqueryparam cfsqltype=cf_sql_varchar value=#summary#, cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname# #Session.Lname#, cfqueryparam cfsqltype=cf_sql_clob value=#content#) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Error Handling
Dave Watts wrote: You can specify custom exception types, in which case you can catch them with custom exception handlers. I haven't tried this with the CFERROR tag specifically, but according to the documentation you can specify custom exception types for the CFERROR tag when using TYPE=EXCEPTION. I've just recently tried this, throwing a custom error of type LDAP and providing a custom template to handle LDAP-specific errors. Works great! -Deanna [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes to Functionality in Microsoft Windows XP Service Pack 2
Interesting that there was no mention of the Active Content/Eolas issue;I guess that change isn't in this update.Anyone have more details/confirmation? Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 3:50 AM To: CF-Talk Subject: RE: Changes to Functionality in Microsoft Windows XP Service Pack 2 I thought it was going to be bad, but I've been using the sp2 since yesterday and it's not that bad, my on going reports can be found on my blog @ http://www.beynon.org.uk/blog Jb. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error Handling
Deanna, I assume you did something like this cferror type=exception template=ErrorHandler.cfm exception=mycustom.exception cfthrow type=mycustom.exception errorcode=6 Is that correct?Are you doing multiple CFERRORS? Thanks Kevin -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 7:57 AM To: CF-Talk Subject: Re: Error Handling Dave Watts wrote: You can specify custom exception types, in which case you can catch them with custom exception handlers. I haven't tried this with the CFERROR tag specifically, but according to the documentation you can specify custom exception types for the CFERROR tag when using TYPE=EXCEPTION. I've just recently tried this, throwing a custom error of type LDAP and providing a custom template to handle LDAP-specific errors. Works great! -Deanna _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
survey applications
Hi list, who has got experience with Active Survey 2.0 from Activefeedback ( http://www.activefeedback.com/ ) ? I looked on their site, but the software has some features lacking and it is quite old. Anybody here recommending other survey software ? Uwe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes to Functionality in Microsoft Windows XP Service Pack 2
First thing I did after installing was hit the macromedia.com site, no problems there - it loaded as expected. -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: 23 December 2003 13:47 To: CF-Talk Subject: RE: Changes to Functionality in Microsoft Windows XP Service Pack 2 Interesting that there was no mention of the Active Content/Eolas issue;I guess that change isn't in this update.Anyone have more details/confirmation? Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 3:50 AM To: CF-Talk Subject: RE: Changes to Functionality in Microsoft Windows XP Service Pack 2 I thought it was going to be bad, but I've been using the sp2 since yesterday and it's not that bad, my on going reports can be found on my blog @ http://www.beynon.org.uk/blog Jb. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error Handling
I concur. Based on Dave and others advice on this list, I converted my application to use throws and catches to catch all User errors and throws and cferror to catch application and database errors. Using this technique significantly reduced my code and improved the readability of the remaining code. Andy -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 6:57 AM To: CF-Talk Subject: Re: Error Handling Dave Watts wrote: You can specify custom exception types, in which case you can catch them with custom exception handlers. I haven't tried this with the CFERROR tag specifically, but according to the documentation you can specify custom exception types for the CFERROR tag when using TYPE=EXCEPTION. I've just recently tried this, throwing a custom error of type LDAP and providing a custom template to handle LDAP-specific errors. Works great! -Deanna [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Error Handling
I'm doing multiple cferror tags. I was experimenting, so I didn't bother to make it into a variable structure to pass. So, it looks like so: cferror type=exception exception=ldap template=/ces/error_ldap.cfm mailto=[EMAIL PROTECTED] Here's an example of the throw tag: CFTHROW type=ldap MESSAGE=LDAP server down. DETAIL=It appears the the LDAP server is not up and running or cannot be connected to! Please try again or contact the system administrator for help. (Don't anyone jump on me for wording of the detail. It's not my wording. I KNOW my users don't know what an LDAP server is. :) ) Quite simple, but I would imagine you could use variables to determine which error template to call. -Deanna - Original Message - From: Kevin Marino [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 7:56 AM Subject: RE: Error Handling Deanna, I assume you did something like this cferror type=exception template=ErrorHandler.cfm exception=mycustom.exception cfthrow type=mycustom.exception errorcode=6 Is that correct?Are you doing multiple CFERRORS? Thanks Kevin -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 7:57 AM To: CF-Talk Subject: Re: Error Handling Dave Watts wrote: You can specify custom exception types, in which case you can catch them with custom exception handlers. I haven't tried this with the CFERROR tag specifically, but according to the documentation you can specify custom exception types for the CFERROR tag when using TYPE=EXCEPTION. I've just recently tried this, throwing a custom error of type LDAP and providing a custom template to handle LDAP-specific errors. Works great! -Deanna _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Scheduled Task question?
In MX 6.1 does a scheduled task have to exist in the CF Administrator for it to work. I was able to add them to the registry in 5 so they would not appear in the CF Administrator and get hosed up by developers poking around. Any ideas? I was thinking it was just an XML entry in 6.1 but was not sure where it was stored? Steve -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 9:24 AM To: CF-Talk Subject: RE: Date Errors in MX ? Jochem I have just changed the query to what is below and received the following error Error Occurred While Processing Request Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character The error occurred in F:\Websites\Intranet\itintranet\publishing\articleaction.cfm: line 54 52 : cfqueryparam cfsqltype=cf_sql_varchar value=#security#, 53 : cfif isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif, 54 :cfqueryparam cfsqltype=cf_sql_blob value=#content#; 55 : /cfquery 56 : cftransaction cfquery name=LOOKUP datasource=intranetv8 SELECT Max(id) NewID FROM itarticle /cfquery cfif lookup.newid is cfset id = 1 cfelse cfset id = lookup.newid + 1 /cfif !--- Insert contact into the contacts tabel in the tes8 Database --- cfset articledate = form.event_month / form.event_day / form.event_year cfset articledate = #CreateODBCDate(articledate)# cfset formatted_date = dateformat(articledate, MM/DD/) cfset content = REReplacenocase(content, /*font[^]*, , ALL) cfset content = REReplacenocase(content, /*span[^]*, , ALL) cfif form.uploadfile neq cffile action="" filefield=Form.UploadFile destination=F:\Websites\Intranet\itintranet\itnews\images\ nameconflict=OVERWRITE /cfif !--- Make sure that file is of correct type --- !--- Insert the story record --- cfquery datasource=#Application.DSN# name=insert_query INSERT INTO itarticle (id, articledate, articletitle, articlesummary, articleauthor, security, imgsrc, articlebody) VALUES ( cfqueryparam cfsqltype=cf_sql_date value=#articledate#, cfqueryparam cfsqltype=cf_sql_varchar value=#articletitle#, cfqueryparam cfsqltype=cf_sql_varchar value=#articlesummary#, cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname# #Session.Lname#, cfqueryparam cfsqltype=cf_sql_varchar value=#security#, cfif isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif, cfqueryparam cfsqltype=cf_sql_blob value=#content# /cfquery /cftransaction -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 12:08 To: CF-Talk Subject: RE: Date Errors in MX ? Ian Vaughan said: cftransaction It would be better to use a sequence for primary key generation. If you also use cfqueryparam your 3 query transaction reduces to 1 query. cfset storydate = CreateDate(form.event_year,form.event_month,form.event_day cfset content = REReplacenocase(content,/*(font|span)[^]*,,ALL) cfquery datasource=#Application.DSN# name=insert_query INSERT INTO itarticle ( articledate, articletitle, etc. itarticle ) VALUES ( cfqueryparam cfsqltype=cf_sql_date value=#storydate#, cfqueryparam cfsqltype=cf_sql_varchar value=#articletitle#, etc. cfqueryparam cfsqltype=cf_sql_clob value=#content# /cfquery Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error Handling
Thanks all for the answers. I believe I have a good grasp of the approach I need to take. Kevin -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:19 AM To: CF-Talk Subject: Re: Error Handling I'm doing multiple cferror tags. I was experimenting, so I didn't bother to make it into a variable structure to pass. So, it looks like so: cferror type=exception exception=ldap template=/ces/error_ldap.cfm mailto=[EMAIL PROTECTED] Here's an example of the throw tag: CFTHROW type=ldap MESSAGE=LDAP server down. DETAIL=It appears the the LDAP server is not up and running or cannot be connected to! Please try again or contact the system administrator for help. (Don't anyone jump on me for wording of the detail. It's not my wording. I KNOW my users don't know what an LDAP server is. :) ) Quite simple, but I would imagine you could use variables to determine which error template to call. -Deanna - Original Message - From: Kevin Marino [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 7:56 AM Subject: RE: Error Handling Deanna, I assume you did something like this cferror type=exception template=ErrorHandler.cfm exception=mycustom.exception cfthrow type=mycustom.exception errorcode=6 Is that correct?Are you doing multiple CFERRORS? Thanks Kevin -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 7:57 AM To: CF-Talk Subject: Re: Error Handling Dave Watts wrote: You can specify custom exception types, in which case you can catch them with custom exception handlers. I haven't tried this with the CFERROR tag specifically, but according to the documentation you can specify custom exception types for the CFERROR tag when using TYPE=EXCEPTION. I've just recently tried this, throwing a custom error of type LDAP and providing a custom template to handle LDAP-specific errors. Works great! -Deanna _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Strange Permission Errors
On a shared host someone is trying to use CFHTTP to grab an RSS feed.The error that they are getting is: The following is the internal exception message: access denied (java.net.SocketPermission HYPERLINK http://www.easycfm.com/ \nwww.easycfm.com resolve) The one thing that is known is that the host has restricted access to CFExecute and CFRegistry.All other tags are open. Anyone have any suggestions on this one? Thanks! Hatton --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Scheduled Task question?
I tried the following: Created the cron job in the cfide. Then I went to the CFusionMX/lib directory and looked at the neo-cron.xml file. Sure enough my entry was there. So I copied the entry in the neo-cron.xml, went back to the cfide and deleted the manual entry I made in the Scheduled Tasks setting. Sure enough it cleared out the neo-cron file. So I then pasted the earlier copied (old version with the entry) contents into neo-cron.xml. Just like it was when I created the entry through the cfide. Ok, all seemed well, the entry was gone in the CFIDE like I wantedbut when I went to refresh the CFIDE screen where the scheduled tasks appear it must do a manual sweep of the xml directories because it kept cleaning out the file contents in neo-cron.xml...any thoughts Steve -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:21 AM To: CF-Talk Subject: Scheduled Task question? In MX 6.1 does a scheduled task have to exist in the CF Administrator for it to work. I was able to add them to the registry in 5 so they would not appear in the CF Administrator and get hosed up by developers poking around. Any ideas? I was thinking it was just an XML entry in 6.1 but was not sure where it was stored? Steve -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 9:24 AM To: CF-Talk Subject: RE: Date Errors in MX ? Jochem I have just changed the query to what is below and received the following error Error Occurred While Processing Request Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character The error occurred in F:\Websites\Intranet\itintranet\publishing\articleaction.cfm: line 54 52 : cfqueryparam cfsqltype=cf_sql_varchar value=#security#, 53 : cfif isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif, 54 :cfqueryparam cfsqltype=cf_sql_blob value=#content#; 55 : /cfquery 56 : cftransaction cfquery name=LOOKUP datasource=intranetv8 SELECT Max(id) NewID FROM itarticle /cfquery cfif lookup.newid is cfset id = 1 cfelse cfset id = lookup.newid + 1 /cfif !--- Insert contact into the contacts tabel in the tes8 Database --- cfset articledate = form.event_month / form.event_day / form.event_year cfset articledate = #CreateODBCDate(articledate)# cfset formatted_date = dateformat(articledate, MM/DD/) cfset content = REReplacenocase(content, /*font[^]*, , ALL) cfset content = REReplacenocase(content, /*span[^]*, , ALL) cfif form.uploadfile neq cffile action="" filefield=Form.UploadFile destination=F:\Websites\Intranet\itintranet\itnews\images\ nameconflict=OVERWRITE /cfif !--- Make sure that file is of correct type --- !--- Insert the story record --- cfquery datasource=#Application.DSN# name=insert_query INSERT INTO itarticle (id, articledate, articletitle, articlesummary, articleauthor, security, imgsrc, articlebody) VALUES ( cfqueryparam cfsqltype=cf_sql_date value=#articledate#, cfqueryparam cfsqltype=cf_sql_varchar value=#articletitle#, cfqueryparam cfsqltype=cf_sql_varchar value=#articlesummary#, cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname# #Session.Lname#, cfqueryparam cfsqltype=cf_sql_varchar value=#security#, cfif isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif, cfqueryparam cfsqltype=cf_sql_blob value=#content# /cfquery /cftransaction -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 12:08 To: CF-Talk Subject: RE: Date Errors in MX ? Ian Vaughan said: cftransaction It would be better to use a sequence for primary key generation. If you also use cfqueryparam your 3 query transaction reduces to 1 query. cfset storydate = CreateDate(form.event_year,form.event_month,form.event_day cfset content = REReplacenocase(content,/*(font|span)[^]*,,ALL) cfquery datasource=#Application.DSN# name=insert_query INSERT INTO itarticle ( articledate, articletitle, etc. itarticle ) VALUES ( cfqueryparam cfsqltype=cf_sql_date value=#storydate#, cfqueryparam cfsqltype=cf_sql_varchar value=#articletitle#, etc. cfqueryparam cfsqltype=cf_sql_clob value=#content# /cfquery Jochem _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Data center hosting recommendation in NY/NJ
I need to spec out and host a rather high-end Windows server configuration supporting CF MX 6 and MS SQL 2000. I need a company that will help purchase the systems, license and host them in a secure datacenter requirements. I've been in conversations with Datapipe, but I'd like to explore a couple of alternatives as well. Thanks for any recommendations. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Data center hosting recommendation in NY/NJ
I have experienced Data Pipe and when compared to others out there, there service is not great. I'm a fan of Host My Site based mostly on their customer service and support. They are not always the cheapest, but their attention and customer support makes up for any price difference in my opinion. Mike PS--- Host My Site is in Delaware so you are pretty close :-) -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:55 AM To: CF-Talk Subject: Data center hosting recommendation in NY/NJ I need to spec out and host a rather high-end Windows server configuration supporting CF MX 6 and MS SQL 2000. I need a company that will help purchase the systems, license and host them in a secure datacenter requirements. I've been in conversations with Datapipe, but I'd like to explore a couple of alternatives as well. Thanks for any recommendations. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Data center hosting recommendation in NY/NJ
Try , http://www.edgewebhosting.net Best Support and Staff and capable of handling big clients. Ketan Patel -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:54 AM To: CF-Talk Subject: RE: Data center hosting recommendation in NY/NJ I have experienced Data Pipe and when compared to others out there, there service is not great. I'm a fan of Host My Site based mostly on their customer service and support. They are not always the cheapest, but their attention and customer support makes up for any price difference in my opinion. Mike PS--- Host My Site is in Delaware so you are pretty close :-) -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:55 AM To: CF-Talk Subject: Data center hosting recommendation in NY/NJ I need to spec out and host a rather high-end Windows server configuration supporting CF MX 6 and MS SQL 2000. I need a company that will help purchase the systems, license and host them in a secure datacenter requirements. I've been in conversations with Datapipe, but I'd like to explore a couple of alternatives as well. Thanks for any recommendations. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Error Handling - List of possible return values
Was wondering is there a list of coldfusion error types returned by #error.type# Ask because even though I designated the custom exception type of framework , I got back coldfusion.runtime.CfErrorWrapper Thanks Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Data center hosting recommendation in NY/NJ
I need to spec out and host a rather high-end Windows server configuration supporting CF MX 6 and MS SQL 2000. I need a company that will help purchase the systems, license and host them in a secure datacenter requirements. I've been in conversations with Datapipe, but I'd like to explore a couple of alternatives as well. Thanks for any recommendations. Try Media Temple. -Patti [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error Handling - List of possible return values
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/errors8.htm -Original Message- From: Kevin Marino [mailto:[EMAIL PROTECTED] Sent: dinsdag 23 december 2003 16:20 To: CF-Talk Subject: Error Handling - List of possible return values Was wondering is there a list of coldfusion error types returned by #error.type# Ask because even though I designated the custom exception type of framework , I got back coldfusion.runtime.CfErrorWrapper Thanks Kevin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Joining the dark side - using DWMX
As long as the settlement comes through from the class action lawsuit regarding ALLR stock. Dan -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 12:43 PM To: CF-Talk Subject: Re: Joining the dark side - using DWMX ALLAIRE FOREVER! - Original Message - From: Daniel Farmer To: CF-Talk Sent: Friday, December 19, 2003 12:38 PM Subject: Re: Joining the dark side - using DWMX ALLAIRE RULES - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, December 19, 2003 12:43 PM Subject: RE: Joining the dark side - using DWMX CFS5 Kicks DWMX ass anytime. It is faster and more stable. I don't care what hardware you are on - the bottom line is that CFS5 is faster than DWMX on any hardware. We're talking about a text editor, not a compiler. How fast does it have to be? On my laptop (which is hardly a blazing machine) Dreamweaver MX 2004 runs well enough that it doesn't slow me down any. In exchange, it gives me a usable design view, templates, an incredibly powerful search and replace interface, and all sorts of other stuff I find very helpful. There are plenty of things I don't like about Dreamweaver, but they're outweighed by the good things in my opinion. For that matter, there were plenty of things I didn't like about CF Studio - it's not like that was God's gift to text editing, either. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RE: Joining the dark side - using DWMX
Well, after using DWMX for some editing last day, I do have to say that the design view still needs some work.It still doesn't render properly for some things. - Original Message - From: Daniel O'Keefe [EMAIL PROTECTED] Date: Tuesday, December 23, 2003 8:52 am Subject: RE: Joining the dark side - using DWMX As long as the settlement comes through from the class action lawsuit regarding ALLR stock. Dan -Original Message- From: Daniel Farmer [EMAIL PROTECTED] Sent: Friday, December 19, 2003 12:43 PM To: CF-Talk Subject: Re: Joining the dark side - using DWMX ALLAIRE FOREVER! - Original Message - From: Daniel Farmer To: CF-Talk Sent: Friday, December 19, 2003 12:38 PM Subject: Re: Joining the dark side - using DWMX ALLAIRE RULES - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, December 19, 2003 12:43 PM Subject: RE: Joining the dark side - using DWMX CFS5 Kicks DWMX ass anytime. It is faster and more stable. I don't care what hardware you are on - the bottom line is that CFS5 is faster than DWMX on any hardware. We're talking about a text editor, not a compiler. How fast does it have to be? On my laptop (which is hardly a blazing machine) Dreamweaver MX 2004 runs well enough that it doesn't slow me down any. In exchange, it gives me a usable design view, templates, an incredibly powerful search and replace interface, and all sorts of other stuff I find very helpful. There are plenty of things I don't like about Dreamweaver, but they're outweighed by the good things in my opinion. For that matter, there were plenty of things I didn't like about CF Studio - it's not like that was God's gift to text editing, either. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Passing CFTHROW errorcode to CFERROR Template
It seems I can't pass a CFTHROW errorCode back to a CFERROR Template. I do not get an error just no value also type comes back as coldfusion.runtime.CfErrorWrapper The CFERROR is a site wide error handler so errorcodes could be different, but template is same. Outside of having rewrite using CFCATCH, is there a way I can get the information I need (errorcode). Thanks Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Strange Query Problem
I have a query that returns one character that is used for classing our customer. The query runs fine in query analyzer, but returns zero records when I try to run it from a ColdFusion page. Any ideas? CFQUERY name=Test datasource=#ds# DECLARE @cf_units int SET @cf_units = #fleetsizece# SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' /CFQUERY Here is the result set that I get. Test (Records=0, Time=16ms) SQL = DECLARE @cf_units int SET @cf_units = 4 SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 526-9838 Fax (701) 526-9839 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: RE: Joining the dark side - using DWMX
gotta chime in. Been using both HS+ and DWMX2004 for a while now (company has Devnet Subscriptions :) ) and they both have their strengths. DW is at is best when a project is setup. This does incur some load time issues but allows for tight integration of all the components. It pretty cool when you can see live data in the Design view. HS+ or any editor really is great when you have projects already in existence and need to edit an existing page. HS and other editors just load faster. DW has pretty good integration with SourceSafe and is simple to setup. DW only has a few minor annoyances that hopefully will be fixed. Title bar does not show full path of file currently editinge.g. it showsonly directory and file name ( thisdir/myfile.cfm)whereas abbr notation like ( D:/toplevel/.../thisdir/myfile.cfm) would be much more useful. Especially when you have files with same name opened but different servers. Sourcesafe performance is not good in general over slower VPN and the like. DW makes it even slower. Also we use a PERSONAL_DEV/DEV/QA/PROD environment structure it would be nice if there was one more way to PUT files in both a DEV QA environment not just one. Not a huge thing but would be nice. Yes DW hogs memory but that is why its good to have an editor for those moments when memory is precious. Though I run 768MB so always have at least 400MB free even with TOAD,Outlook,5-10 IEs, 2-4 Explorer, itunes,winamp, assorted other. I like DW it just requires rethinking of the development process which does take some getting used to, but once there is quite nice overall. End my 2 cents - Merry Xmas, Happy Holidays Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Hosting
Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have considered the co-location option, but I'm somewhat afraid of depending on a single server for all of that load.Thanks John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
I actually never heard about this. Who all is involved in the class? - Original Message - From: Daniel O'Keefe To: CF-Talk Sent: Tuesday, December 23, 2003 10:52 AM Subject: RE: Joining the dark side - using DWMX As long as the settlement comes through from the class action lawsuit regarding ALLR stock. Dan -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 12:43 PM To: CF-Talk Subject: Re: Joining the dark side - using DWMX ALLAIRE FOREVER! - Original Message - From: Daniel Farmer To: CF-Talk Sent: Friday, December 19, 2003 12:38 PM Subject: Re: Joining the dark side - using DWMX ALLAIRE RULES - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, December 19, 2003 12:43 PM Subject: RE: Joining the dark side - using DWMX CFS5 Kicks DWMX ass anytime. It is faster and more stable. I don't care what hardware you are on - the bottom line is that CFS5 is faster than DWMX on any hardware. We're talking about a text editor, not a compiler. How fast does it have to be? On my laptop (which is hardly a blazing machine) Dreamweaver MX 2004 runs well enough that it doesn't slow me down any. In exchange, it gives me a usable design view, templates, an incredibly powerful search and replace interface, and all sorts of other stuff I find very helpful. There are plenty of things I don't like about Dreamweaver, but they're outweighed by the good things in my opinion. For that matter, there were plenty of things I didn't like about CF Studio - it's not like that was God's gift to text editing, either. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Making a table background color shor up when you print
Alright...Someone is going to call me an idiot for this one :) I need to make a background color of a cell show up when you print the page on a color printer.I have tried using bgcolor, and using an image as the background color but they didn't work.Can anyone give me a hint? Thanks, Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Making a table background color shor up when you print
There are also the background style elements you could tryI beleive they are background and background-color...just check the style sheet editor in CF Studio or Homesite. That said...I'm not sure you can be 100% sure that the color will always printcould depend on browserprint drivers etc. Good Luck Merry Ho Ho Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: cf talk To: CF-Talk Sent: Tuesday, December 23, 2003 9:23 AM Subject: Making a table background color shor up when you print Alright...Someone is going to call me an idiot for this one :) I need to make a background color of a cell show up when you print the page on a color printer.I have tried using bgcolor, and using an image as the background color but they didn't work.Can anyone give me a hint? Thanks, Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Making a table background color shor up when you print
It's not in your code.You have to get into your browser settings, (I'm guessing you are using IE).You need to set the parameter that tells IE to print background colors.It's set by default not to do so to save ink. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: cf talk [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:24 AM To: CF-Talk Subject: Making a table background color shor up when you print Alright...Someone is going to call me an idiot for this one :) I need to make a background color of a cell show up when you print the page on a color printer.I have tried using bgcolor, and using an image as the background color but they didn't work.Can anyone give me a hint? Thanks, Brian _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Making a table background color shor up when you print
You will need to set print backgrounds in Internet OptionsAdvanced for IE for this to work.Its a browser setting not HTML - Original Message - From: cf talk To: CF-Talk Sent: Tuesday, December 23, 2003 12:23 PM Subject: Making a table background color shor up when you print Alright...Someone is going to call me an idiot for this one :) I need to make a background color of a cell show up when you print the page on a color printer.I have tried using bgcolor, and using an image as the background color but they didn't work.Can anyone give me a hint? Thanks, Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Hosting
John, We offer several of the requirements you are seeking, but do not offer windows or MSSQL. We do have an excellent reseller program with the best rates around. Our plans include unlimited bandwidth and lots of HD space. We can even set you up with Dedicated or VDS options. Check out our offerings here: http://exciteworks.com/host_matrix.cfm Good luck! See below: Burns, John wrote: The hosting must: - CFMX 6.1 yep - allow the use of ALL CF tags (no disabled tags) yep - windows server OS preferred nope - tape backups yep - company support for hardware and maybe some software issues what type of support do you need? - MS SQL server nope -- we use MySQL and PostgreSQL - POP/IMAP support yep [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Making a table background color shor up when you print
Thank you all...This was it.I guess you CAN learn something new everyday! Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Hosting
I think in order to meet all your requirements, a co-lo would be about your only option.Hard drive space is about the only thing you omitted from your specs. If you are seeking a clustered environment, get ready to spend some money. I don't know of a shared hosting environment that will allow ALL CF tags, if for no other reason security of the data for their other clients. But you might try the company listed at the footer of every message to this list. my .02 Doug - Original Message - From: Burns, John [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 10:42 AM Subject: CF Hosting | Ok, I know this has been asked multiple times, but I want to see if | anyone has a direction for me based on my specific needs... | | I need to find a hosting company that meets the following requirements. | This can be done through a shared hosting or dedicated server, but I'm | trying to find a reliable, low-cost solution for hosting approximately | 20 sites (growing in the near future).The hosting must: | | - CFMX 6.1 | - allow the use of ALL CF tags (no disabled tags) | - windows server OS preferred | - tape backups | - company support for hardware and maybe some software issues | - MS SQL server | - POP/IMAP support | | I think that covers it.If you have any suggestions, please let me | know.I have considered the co-location option, but I'm somewhat afraid | of depending on a single server for all of that load.Thanks | | John | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Data center hosting recommendation in NY/NJ
We use NetAccess -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:55 AM To: CF-Talk Subject: Data center hosting recommendation in NY/NJ I need to spec out and host a rather high-end Windows server configuration supporting CF MX 6 and MS SQL 2000. I need a company that will help purchase the systems, license and host them in a secure datacenter requirements. I've been in conversations with Datapipe, but I'd like to explore a couple of alternatives as well. Thanks for any recommendations. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting
What is the consensus on the use of custom tags/cfx tags with most CF hosts? Do most work with you? Will they review its use before implementing it? Any thoughts would be appreciated. ~Che -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 12:53 PM To: CF-Talk Subject: Re: CF Hosting I think in order to meet all your requirements, a co-lo would be about your only option.Hard drive space is about the only thing you omitted from your specs. If you are seeking a clustered environment, get ready to spend some money. I don't know of a shared hosting environment that will allow ALL CF tags, if for no other reason security of the data for their other clients. But you might try the company listed at the footer of every message to this list. my .02 Doug - Original Message - From: Burns, John [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 10:42 AM Subject: CF Hosting | Ok, I know this has been asked multiple times, but I want to see if | anyone has a direction for me based on my specific needs... | | I need to find a hosting company that meets the following requirements. | This can be done through a shared hosting or dedicated server, but I'm | trying to find a reliable, low-cost solution for hosting approximately | 20 sites (growing in the near future).The hosting must: | | - CFMX 6.1 | - allow the use of ALL CF tags (no disabled tags) | - windows server OS preferred | - tape backups | - company support for hardware and maybe some software issues | - MS SQL server | - POP/IMAP support | | I think that covers it.If you have any suggestions, please let me | know.I have considered the co-location option, but I'm somewhat afraid | of depending on a single server for all of that load.Thanks | | John | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Geo Locator
Hi folks, I need to lookup a set of ZIP/Postal codes that reside within X miles/km of an input ZIP/Postal code. Anyone know where I can get this kind of data? Maybe there's some sort of ISO dataset available? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Geo Locator
i saw some new tags in the MM exchange 4 this if not email me off list and i will send u some Hi folks, I need to lookup a set of ZIP/Postal codes that reside within X miles/km of an input ZIP/Postal code. Anyone know where I can get this kind of data? Maybe there's some sort of ISO dataset available? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Hosting
Try PowerSurge www.powersurge.net I'm not sure about tape backups and IMAP though... :) Just ask them. Rizal At 11:42 PM 12/23/2003, you wrote: Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have considered the co-location option, but I'm somewhat afraid of depending on a single server for all of that load.Thanks John -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting
Do you want to be a reseller of this space or are you the client here, John? We can handle nearly all of that, but we don't have a reseller program - its not in our business strategy.We'll work with you and be as flexible as anyone anywhere, but a reseller program is something we haven't built in yet.So it means the control panel you'll get is the end user control panel not a reseller's one. We have no disabled tags except CFREGISTRY but if you needed it, we could consider it.But no promises.We don't really want to expose everyone to risk of one person making a mistake using it. We will allow any CFX tags, but we want to install it for you and we want to see what it does first.If there's a risk to other clients we'll work to find another way of doing what you want, but so far we've never had to say to anyone 'Nope you can't do that (which was a regular occurrence when I started out hosting). Why do you need IMAP?Will POP3/SMTP do for what you need? Otherwise .. we have Win2K, SQL2000, CFMX6.1users get their own control panel to set up their email accounts etc themselves, set up databases, ftp sites etc. For fuller details see http://afpwebworks.com/index.cfm?fuseaction=DisplayDocument http://afpwebworks.com/index.cfm?fuseaction=DisplayDocumentDocumentID=4 DocumentID=4(NOTE:If you're comparing prices based on this, they are quoted here in Australian dollars including GST.We can bill in any currency if you use a credit card, and if you're not doing business in Australia, that takes 10% off the price because we don't have to charge you GST). As a guide, the prices shown on our page would be about 2/3 if expressedin US dollars for a non-Australian company at today's exchange rate). Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 3:43 AM To: CF-Talk Subject: CF Hosting Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have considered the co-location option, but I'm somewhat afraid of depending on a single server for all of that load.Thanks John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Hosting
I know we are able to accommodate CFX tags for the client. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 12:28 PM Subject: RE: CF Hosting | What is the consensus on the use of custom tags/cfx tags with most CF hosts? | Do most work with you? Will they review its use before implementing it? | | Any thoughts would be appreciated. | | ~Che |-Original Message- |From: Doug White [mailto:[EMAIL PROTECTED] |Sent: Tuesday, December 23, 2003 12:53 PM |To: CF-Talk |Subject: Re: CF Hosting | | |I think in order to meet all your requirements, a co-lo would be about | your only |option.Hard drive space is about the only thing you omitted from your | specs. |If you are seeking a clustered environment, get ready to spend some money. | |I don't know of a shared hosting environment that will allow ALL CF tags, | if for |no other reason security of the data for their other clients. | |But you might try the company listed at the footer of every message to | this |list. | |my .02 |Doug | |- Original Message - |From: Burns, John [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Tuesday, December 23, 2003 10:42 AM |Subject: CF Hosting | || Ok, I know this has been asked multiple times, but I want to see if || anyone has a direction for me based on my specific needs... || || I need to find a hosting company that meets the following requirements. || This can be done through a shared hosting or dedicated server, but I'm || trying to find a reliable, low-cost solution for hosting approximately || 20 sites (growing in the near future).The hosting must: || || - CFMX 6.1 || - allow the use of ALL CF tags (no disabled tags) || - windows server OS preferred || - tape backups || - company support for hardware and maybe some software issues || - MS SQL server || - POP/IMAP support || || I think that covers it.If you have any suggestions, please let me || know.I have considered the co-location option, but I'm somewhat afraid || of depending on a single server for all of that load.Thanks || || John || || | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting
Mike, I appreciate the contact.Here's the deal.I have a side business that I do (approximately 7 sites) and a friend has a business that handles approximately 7-10 sites.We're looking at a possible merger of our two businesses and some growth in the near future.We prefer windows servers (right now I use a linux host) and Microsoft SQL as the database server.Most hosting companies disable a bunch of CF tags for security purposes.The main ones that we need that aren't available with most places are: CFFILE, CFDIRECTORY, CFEXECUTE and CFCONTENT.We'd like to be able to have all of the sites be able to use commons sets of code (and ideally be able to get to all of the sites with one ftp login). We've considered doing a co-location or dedicated server but we're worried about server availability without doing some kind of clustering or something like that.Do you have clustered servers? Our goal is to get something that won't cost us an arm and a leg so we can offer it to our customers for a reasonable price and we need near-free-reign as far as coding goes so we can take advantage of some of the advanced features in CF.Let me know your responses and we'd be glad to consider your company.Thanks! John Burns -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:55 PM To: CF-Talk Subject: RE: CF Hosting Do you want to be a reseller of this space or are you the client here, John? We can handle nearly all of that, but we don't have a reseller program - its not in our business strategy.We'll work with you and be as flexible as anyone anywhere, but a reseller program is something we haven't built in yet.So it means the control panel you'll get is the end user control panel not a reseller's one. We have no disabled tags except CFREGISTRY but if you needed it, we could consider it.But no promises.We don't really want to expose everyone to risk of one person making a mistake using it. We will allow any CFX tags, but we want to install it for you and we want to see what it does first.If there's a risk to other clients we'll work to find another way of doing what you want, but so far we've never had to say to anyone 'Nope you can't do that (which was a regular occurrence when I started out hosting). Why do you need IMAP?Will POP3/SMTP do for what you need? Otherwise .. we have Win2K, SQL2000, CFMX6.1users get their own control panel to set up their email accounts etc themselves, set up databases, ftp sites etc. For fuller details see http://afpwebworks.com/index.cfm?fuseaction=DisplayDocument http://afpwebworks.com/index.cfm?fuseaction=DisplayDocumentDocumentID= 4 DocumentID=4(NOTE:If you're comparing prices based on this, they are quoted here in Australian dollars including GST.We can bill in any currency if you use a credit card, and if you're not doing business in Australia, that takes 10% off the price because we don't have to charge you GST). As a guide, the prices shown on our page would be about 2/3 if expressed in US dollars for a non-Australian company at today's exchange rate). Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 3:43 AM To: CF-Talk Subject: CF Hosting Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have considered the co-location option, but I'm somewhat afraid of depending on a single server for all of that load.Thanks John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Web services and cookies/session vars/etc
I'm buildiing a flash application with cold fusion web services. I have two components for this... one handles authentication to our DB2 mainframe, and the other handles all the data. In my flash app I have a number of list boxes that are populated with data. I don't want my web service to expose this data to unauthorized users, so I'm passing the username and password to the service each time, and each method re-authenticates the user. Unfortunately, this authentication process takes anywhere from 3-7 seconds ... each method invokes the authorization component, which in turn CFHTTPs a perl script which handles the authorization and returns success/failure and failure reason if applicable. This is not particularly desirable =) I know that accessing a CFC as a web service causes the application.cfm to run, but I don't think sessions or cookies are available. What I'd really like is for the user to be authenticated ONCE... I was thinking of having the authentication component create a unique key (like a UUID) and pass it back to the application, then have the application pass it back to the methods to retrieve the data.. the methods would then make sure the key was valid and current. It looks to me like the only way to do this would be to store it in a database (key, datecreated)... if I did this I would store the keys in a local database rather than the DB2 mainframe for speed... But... is there a better way? Thanks - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting installing CFX tags
A hosting company that doesn't consider adding CFX tags for a client doesn't really understand ColdFusion, and I'd wonder whether they're serious about supporting it. There are two main concerns with CFX tags - [A]are there likely to be any consequences for other clients of the misuse of this CFX tag?(for example heavy use of the processor, hogging the RAM perhaps, opening up security holes),and [B] since it's installed and available to anyone on the system,what if other clients start using the CFX tag?Will there be any consequences then? Copyright/licensing issues perhaps?Misuse or incorrect use leading to the sorts of problems described above. For the vast majority of CFX tags, these aren't issues and we'd just install them and let the client go ahead and use them.For some we'd want to take a little while and test them or verify the licensing etc. It also depends somewhat on the client.Some clients shouldn't really be allowed to walk the streets without a nanny holding their hands, others know what they're doing and you can leave them to their own devices. But in short, we'd consider any CFX tag (or CFC, mapping, DSN, or any other CFAdministrator settingtoo if it comes to that) and decide whether to do what's asked depending on the circumstances.If the answer has to be 'no', we'll try to find an alternative way to do what the client wants. The default answer is YES.(Unlike when I started hosting - my first sites were at SHANJE.COM where the default answer is NO!and the exception answer is YOU'D BE KIDDING! -NOT A CHANCE!) Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 5:29 AM To: CF-Talk Subject: RE: CF Hosting What is the consensus on the use of custom tags/cfx tags with most CF hosts? Do most work with you? Will they review its use before implementing it? Any thoughts would be appreciated. ~Che [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting installing CFX tags
What about utilizing java classes? How fast are you to take down the server when updating a class path? Or do all the classes go in one common folder? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:21 PM To: CF-Talk Subject: RE: CF Hosting installing CFX tags A hosting company that doesn't consider adding CFX tags for a client doesn't really understand ColdFusion, and I'd wonder whether they're serious about supporting it. There are two main concerns with CFX tags - [A]are there likely to be any consequences for other clients of the misuse of this CFX tag?(for example heavy use of the processor, hogging the RAM perhaps, opening up security holes),and [B] since it's installed and available to anyone on the system,what if other clients start using the CFX tag?Will there be any consequences then? Copyright/licensing issues perhaps?Misuse or incorrect use leading to the sorts of problems described above. For the vast majority of CFX tags, these aren't issues and we'd just install them and let the client go ahead and use them.For some we'd want to take a little while and test them or verify the licensing etc. It also depends somewhat on the client.Some clients shouldn't really be allowed to walk the streets without a nanny holding their hands, others know what they're doing and you can leave them to their own devices. But in short, we'd consider any CFX tag (or CFC, mapping, DSN, or any other CFAdministrator settingtoo if it comes to that) and decide whether to do what's asked depending on the circumstances.If the answer has to be 'no', we'll try to find an alternative way to do what the client wants. The default answer is YES.(Unlike when I started hosting - my first sites were at SHANJE.COM where the default answer is NO!and the exception answer is YOU'D BE KIDDING! -NOT A CHANCE!) Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 5:29 AM To: CF-Talk Subject: RE: CF Hosting What is the consensus on the use of custom tags/cfx tags with most CF hosts? Do most work with you? Will they review its use before implementing it? Any thoughts would be appreciated. ~Che _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web services and cookies/session vars/etc
You might try to ask this over at the FlashCoders list.I seem to recall someone over there doing something similar. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:18 PM To: CF-Talk Subject: Web services and cookies/session vars/etc I'm buildiing a flash application with cold fusion web services. I have two components for this... one handles authentication to our DB2 mainframe, and the other handles all the data. In my flash app I have a number of list boxes that are populated with data. I don't want my web service to expose this data to unauthorized users, so I'm passing the username and password to the service each time, and each method re-authenticates the user. Unfortunately, this authentication process takes anywhere from 3-7 seconds ... each method invokes the authorization component, which in turn CFHTTPs a perl script which handles the authorization and returns success/failure and failure reason if applicable. This is not particularly desirable =) I know that accessing a CFC as a web service causes the application.cfm to run, but I don't think sessions or cookies are available. What I'd really like is for the user to be authenticated ONCE... I was thinking of having the authentication component create a unique key (like a UUID) and pass it back to the application, then have the application pass it back to the methods to retrieve the data.. the methods would then make sure the key was valid and current. It looks to me like the only way to do this would be to store it in a database (key, datecreated)... if I did this I would store the keys in a local database rather than the DB2 mainframe for speed... But... is there a better way? Thanks - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Geo Locator
Stacy Young wrote: Hi folks, I need to lookup a set of ZIP/Postal codes that reside within X miles/km of an input ZIP/Postal code. Anyone know where I can get this kind of data? Maybe there's some sort of ISO dataset available? Thanks! Stace Look at Zip base http://www.cfdynamics.com/zipbase/ . There's also a tag around called ZipRad that's now free. Unfortunatley I cannot remember the url for that one. regards, larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting
John, We have something that may be up your alley. Check out our VPS plan. http://cfxhosting.com/StandardHosting/VPS/index.cfm For $189 you can host 10 domains with email access (IMAP and POP), 100MB of MS SQL space, access to any and all CFX tags, RDS access ,full ColdFusion administrator access, and access to Teminal server. This is a virtual dedicated server. Check out the link for more specs. We are also giving a 30 day trial if you wish to sign up. If you have questions, please feel free to contact me. Good luck in your search. Dan Phillips CFXHosting.com [EMAIL PROTECTED] -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:04 PM To: CF-Talk Subject: RE: CF Hosting Mike, I appreciate the contact.Here's the deal.I have a side business that I do (approximately 7 sites) and a friend has a business that handles approximately 7-10 sites.We're looking at a possible merger of our two businesses and some growth in the near future.We prefer windows servers (right now I use a linux host) and Microsoft SQL as the database server.Most hosting companies disable a bunch of CF tags for security purposes.The main ones that we need that aren't available with most places are: CFFILE, CFDIRECTORY, CFEXECUTE and CFCONTENT.We'd like to be able to have all of the sites be able to use commons sets of code (and ideally be able to get to all of the sites with one ftp login). We've considered doing a co-location or dedicated server but we're worried about server availability without doing some kind of clustering or something like that.Do you have clustered servers? Our goal is to get something that won't cost us an arm and a leg so we can offer it to our customers for a reasonable price and we need near-free-reign as far as coding goes so we can take advantage of some of the advanced features in CF.Let me know your responses and we'd be glad to consider your company.Thanks! John Burns -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:55 PM To: CF-Talk Subject: RE: CF Hosting Do you want to be a reseller of this space or are you the client here, John? We can handle nearly all of that, but we don't have a reseller program - its not in our business strategy.We'll work with you and be as flexible as anyone anywhere, but a reseller program is something we haven't built in yet.So it means the control panel you'll get is the end user control panel not a reseller's one. We have no disabled tags except CFREGISTRY but if you needed it, we could consider it.But no promises.We don't really want to expose everyone to risk of one person making a mistake using it. We will allow any CFX tags, but we want to install it for you and we want to see what it does first.If there's a risk to other clients we'll work to find another way of doing what you want, but so far we've never had to say to anyone 'Nope you can't do that (which was a regular occurrence when I started out hosting). Why do you need IMAP?Will POP3/SMTP do for what you need? Otherwise .. we have Win2K, SQL2000, CFMX6.1users get their own control panel to set up their email accounts etc themselves, set up databases, ftp sites etc. For fuller details see http://afpwebworks.com/index.cfm?fuseaction=DisplayDocument http://afpwebworks.com/index.cfm?fuseaction=DisplayDocumentDocumentID= 4 DocumentID=4(NOTE:If you're comparing prices based on this, they are quoted here in Australian dollars including GST.We can bill in any currency if you use a credit card, and if you're not doing business in Australia, that takes 10% off the price because we don't have to charge you GST). As a guide, the prices shown on our page would be about 2/3 if expressed in US dollars for a non-Australian company at today's exchange rate). Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 3:43 AM To: CF-Talk Subject: CF Hosting Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have considered the co-location option, but I'm somewhat afraid of depending on a single server for all of that load.Thanks John _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting installing CFX tags
Agreed. Especially with the security settings in CFMX, every hosting company should offer this. I think most hosts that don't offer this think you still have to configure sandboxing or just have no drive to learn CF. Dan Phillips CFXHosting.com [EMAIL PROTECTED] -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:21 PM To: CF-Talk Subject: RE: CF Hosting installing CFX tags A hosting company that doesn't consider adding CFX tags for a client doesn't really understand ColdFusion, and I'd wonder whether they're serious about supporting it. There are two main concerns with CFX tags - [A]are there likely to be any consequences for other clients of the misuse of this CFX tag?(for example heavy use of the processor, hogging the RAM perhaps, opening up security holes),and [B] since it's installed and available to anyone on the system,what if other clients start using the CFX tag?Will there be any consequences then? Copyright/licensing issues perhaps?Misuse or incorrect use leading to the sorts of problems described above. For the vast majority of CFX tags, these aren't issues and we'd just install them and let the client go ahead and use them.For some we'd want to take a little while and test them or verify the licensing etc. It also depends somewhat on the client.Some clients shouldn't really be allowed to walk the streets without a nanny holding their hands, others know what they're doing and you can leave them to their own devices. But in short, we'd consider any CFX tag (or CFC, mapping, DSN, or any other CFAdministrator settingtoo if it comes to that) and decide whether to do what's asked depending on the circumstances.If the answer has to be 'no', we'll try to find an alternative way to do what the client wants. The default answer is YES.(Unlike when I started hosting - my first sites were at SHANJE.COM where the default answer is NO!and the exception answer is YOU'D BE KIDDING! -NOT A CHANCE!) Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 5:29 AM To: CF-Talk Subject: RE: CF Hosting What is the consensus on the use of custom tags/cfx tags with most CF hosts? Do most work with you? Will they review its use before implementing it? Any thoughts would be appreciated. ~Che _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Hosting
Dan, Do you have a phone number that I could use to call and discuss this with you? I appreciate the help. John Burns -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:47 PM To: CF-Talk Subject: RE: CF Hosting John, We have something that may be up your alley. Check out our VPS plan. http://cfxhosting.com/StandardHosting/VPS/index.cfm For $189 you can host 10 domains with email access (IMAP and POP), 100MB of MS SQL space, access to any and all CFX tags, RDS access ,full ColdFusion administrator access, and access to Teminal server. This is a virtual dedicated server. Check out the link for more specs. We are also giving a 30 day trial if you wish to sign up. If you have questions, please feel free to contact me. Good luck in your search. Dan Phillips CFXHosting.com [EMAIL PROTECTED] -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:04 PM To: CF-Talk Subject: RE: CF Hosting Mike, I appreciate the contact.Here's the deal.I have a side business that I do (approximately 7 sites) and a friend has a business that handles approximately 7-10 sites.We're looking at a possible merger of our two businesses and some growth in the near future.We prefer windows servers (right now I use a linux host) and Microsoft SQL as the database server.Most hosting companies disable a bunch of CF tags for security purposes.The main ones that we need that aren't available with most places are: CFFILE, CFDIRECTORY, CFEXECUTE and CFCONTENT.We'd like to be able to have all of the sites be able to use commons sets of code (and ideally be able to get to all of the sites with one ftp login). We've considered doing a co-location or dedicated server but we're worried about server availability without doing some kind of clustering or something like that.Do you have clustered servers? Our goal is to get something that won't cost us an arm and a leg so we can offer it to our customers for a reasonable price and we need near-free-reign as far as coding goes so we can take advantage of some of the advanced features in CF.Let me know your responses and we'd be glad to consider your company.Thanks! John Burns -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:55 PM To: CF-Talk Subject: RE: CF Hosting Do you want to be a reseller of this space or are you the client here, John? We can handle nearly all of that, but we don't have a reseller program - its not in our business strategy.We'll work with you and be as flexible as anyone anywhere, but a reseller program is something we haven't built in yet.So it means the control panel you'll get is the end user control panel not a reseller's one. We have no disabled tags except CFREGISTRY but if you needed it, we could consider it.But no promises.We don't really want to expose everyone to risk of one person making a mistake using it. We will allow any CFX tags, but we want to install it for you and we want to see what it does first.If there's a risk to other clients we'll work to find another way of doing what you want, but so far we've never had to say to anyone 'Nope you can't do that (which was a regular occurrence when I started out hosting). Why do you need IMAP?Will POP3/SMTP do for what you need? Otherwise .. we have Win2K, SQL2000, CFMX6.1users get their own control panel to set up their email accounts etc themselves, set up databases, ftp sites etc. For fuller details see http://afpwebworks.com/index.cfm?fuseaction=DisplayDocument http://afpwebworks.com/index.cfm?fuseaction=DisplayDocumentDocumentID= 4 DocumentID=4(NOTE:If you're comparing prices based on this, they are quoted here in Australian dollars including GST.We can bill in any currency if you use a credit card, and if you're not doing business in Australia, that takes 10% off the price because we don't have to charge you GST). As a guide, the prices shown on our page would be about 2/3 if expressed in US dollars for a non-Australian company at today's exchange rate). Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 3:43 AM To: CF-Talk Subject: CF Hosting Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have
Re: CF Hosting
Hi John, From my perspective, your requirements seem to demand a dedicated server.As has already been stated, a shared server will not provide access to all CF tags.[Or, at least, SHOULDN'T.]A co-located server will typically not be managed, meaning that you are left entirely responsible for software maintenance, including backups. SalesHatOn Circa 3000 offers dedicated CF servers which appear to meet all of your requirementsand we've got a couple of P4 2Ghz Windows/MX boxes ready and waiting -- no setup time, fee or commitment.Give me a holler at 1-866-CIRCA3K if you'd like to discuss your requirements in greater detail.I'm happy to help. /SalesHatOn Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Burns, John wrote: Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have considered the co-location option, but I'm somewhat afraid of depending on a single server for all of that load.Thanks John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange Query Problem
cfset cf_units = #fleetsizece# CFQUERY name=Test datasource=#ds# SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' /CFQUERY From: Burcham, Steve [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Strange Query Problem Date: Tue, 23 Dec 2003 10:41:26 -0600 I have a query that returns one character that is used for classing our customer. The query runs fine in query analyzer, but returns zero records when I try to run it from a ColdFusion page. Any ideas? CFQUERY name=Test datasource=#ds# DECLARE @cf_units int SET @cf_units = #fleetsizece# SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' /CFQUERY Here is the result set that I get. Test (Records=0, Time=16ms) SQL = DECLARE @cf_units int SET @cf_units = 4 SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 526-9838 Fax (701) 526-9839 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange Query Problem
You sir are a genius!! Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 526-9838 Fax (701) 526-9839 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: MILAN MUSHRAN [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:08 PM To: CF-Talk Subject: RE: Strange Query Problem cfset cf_units = #fleetsizece# CFQUERY name=Test datasource=#ds# SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' /CFQUERY From: Burcham, Steve [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Strange Query Problem Date: Tue, 23 Dec 2003 10:41:26 -0600 I have a query that returns one character that is used for classing our customer. The query runs fine in query analyzer, but returns zero records when I try to run it from a ColdFusion page. Any ideas? CFQUERY name=Test datasource=#ds# DECLARE @cf_units int SET @cf_units = #fleetsizece# SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' /CFQUERY Here is the result set that I get. Test (Records=0, Time=16ms) SQL = DECLARE @cf_units int SET @cf_units = 4 SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 526-9838 Fax (701) 526-9839 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Hosting
With about 20 sites you may consider co-location. 2-3 servers can fit in a 1/8 cabinet for about 125CAD a month with 25Gb transfer free. You get full control of your servers which also comes with some small responsibilities. However, the added flexibility and virtually unlimited growth space as well as not so high price are, in my opinion, well worth it. TK - Original Message - From: Burns, John To: CF-Talk Sent: Tuesday, December 23, 2003 2:04 PM Subject: RE: CF Hosting Mike, I appreciate the contact.Here's the deal.I have a side business that I do (approximately 7 sites) and a friend has a business that handles approximately 7-10 sites.We're looking at a possible merger of our two businesses and some growth in the near future.We prefer windows servers (right now I use a linux host) and Microsoft SQL as the database server.Most hosting companies disable a bunch of CF tags for security purposes.The main ones that we need that aren't available with most places are: CFFILE, CFDIRECTORY, CFEXECUTE and CFCONTENT.We'd like to be able to have all of the sites be able to use commons sets of code (and ideally be able to get to all of the sites with one ftp login). We've considered doing a co-location or dedicated server but we're worried about server availability without doing some kind of clustering or something like that.Do you have clustered servers? Our goal is to get something that won't cost us an arm and a leg so we can offer it to our customers for a reasonable price and we need near-free-reign as far as coding goes so we can take advantage of some of the advanced features in CF.Let me know your responses and we'd be glad to consider your company.Thanks! John Burns -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:55 PM To: CF-Talk Subject: RE: CF Hosting Do you want to be a reseller of this space or are you the client here, John? We can handle nearly all of that, but we don't have a reseller program - its not in our business strategy.We'll work with you and be as flexible as anyone anywhere, but a reseller program is something we haven't built in yet.So it means the control panel you'll get is the end user control panel not a reseller's one. We have no disabled tags except CFREGISTRY but if you needed it, we could consider it.But no promises.We don't really want to expose everyone to risk of one person making a mistake using it. We will allow any CFX tags, but we want to install it for you and we want to see what it does first.If there's a risk to other clients we'll work to find another way of doing what you want, but so far we've never had to say to anyone 'Nope you can't do that (which was a regular occurrence when I started out hosting). Why do you need IMAP?Will POP3/SMTP do for what you need? Otherwise .. we have Win2K, SQL2000, CFMX6.1users get their own control panel to set up their email accounts etc themselves, set up databases, ftp sites etc. For fuller details see http://afpwebworks.com/index.cfm?fuseaction=DisplayDocument http://afpwebworks.com/index.cfm?fuseaction=DisplayDocumentDocumentID= 4 DocumentID=4(NOTE:If you're comparing prices based on this, they are quoted here in Australian dollars including GST.We can bill in any currency if you use a credit card, and if you're not doing business in Australia, that takes 10% off the price because we don't have to charge you GST). As a guide, the prices shown on our page would be about 2/3 if expressed in US dollars for a non-Australian company at today's exchange rate). Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 3:43 AM To: CF-Talk Subject: CF Hosting Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a hosting company that meets the following requirements. This can be done through a shared hosting or dedicated server, but I'm trying to find a reliable, low-cost solution for hosting approximately 20 sites (growing in the near future).The hosting must: - CFMX 6.1 - allow the use of ALL CF tags (no disabled tags) - windows server OS preferred - tape backups - company support for hardware and maybe some software issues - MS SQL server - POP/IMAP support I think that covers it.If you have any suggestions, please let me know.I have considered the co-location option, but I'm somewhat afraid of depending on a single server for all of that load.Thanks John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: Geo Locator
Thanks! Anyone used this one? ZipsInRadius, V1.0 Cold Fusion Componentthat will find zip codes with in a radius of a starting zip code. You pass in a starting zip code and a radius in miles and you get a list comma delimited list of zip codes whithin the radius. Requires set-up of a mssql or mysql database. Includes the component, usage instructions, installation instructions, and a cross-platform sql script. Not bad for $6 _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:45 PM To: CF-Talk Subject: Re: SOT: Geo Locator i saw some new tags in the MM exchange 4 this if not email me off list and i will send u some Hi folks, I need to lookup a set of ZIP/Postal codes that reside within X miles/km of an input ZIP/Postal code. Anyone know where I can get this kind of data? Maybe there's some sort of ISO dataset available? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Geo Locator
Here's an article w/ the SQL http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci523000,00.html Plenty of places to get the data -- the free one from US Census data mentioned in the article http://www.census.gov/geo/www/gazetteer/places.html plus many commercial sites -- just search for zipcode database in Google or other search engine and follow the links Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Stacy Young To: CF-Talk Sent: Tuesday, December 23, 2003 1:36 PM Subject: SOT: Geo Locator Hi folks, I need to lookup a set of ZIP/Postal codes that reside within X miles/km of an input ZIP/Postal code. Anyone know where I can get this kind of data? Maybe there's some sort of ISO dataset available? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
flusing the trusted cache
We just turned on the trusted cache in the cf administrator (CF5.0 on Solaris), and now I can't seem to flush it when small changes are made. The old pages still show. Anyone got any tricks for cleaning the trusted cache out? thanks in advance. _ walker fenton [EMAIL PROTECTED] 303.722.5473 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Turn that option off and restart CF. Trusted cache is not supposed to be used when you are making small changes, actually the whole point of it is to use it when there are no changes being made (until a next deployment). --- Ben -Original Message- From: walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 3:44 PM To: CF-Talk Subject: flusing the trusted cache We just turned on the trusted cache in the cf administrator (CF5.0 on Solaris), and now I can't seem to flush it when small changes are made. The old pages still show. Anyone got any tricks for cleaning the trusted cache out? thanks in advance. _ walker fenton [EMAIL PROTECTED] 303.722.5473 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Have to cycle the server.That's the point of the trusted cache, it never has to hit the filesystem except on startup. barneyb -Original Message- From: walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 12:44 PM To: CF-Talk Subject: flusing the trusted cache We just turned on the trusted cache in the cf administrator (CF5.0 on Solaris), and now I can't seem to flush it when small changes are made. The old pages still show. Anyone got any tricks for cleaning the trusted cache out? thanks in advance. _ walker fenton [EMAIL PROTECTED] 303.722.5473 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PostgreSQL and CFTRANSACTION
I have Postgresql 7.4 installed.Have a form and I'm trying to insert the form contents into several tables in the database. Whenever I wrap the queries with the cftransaction tags and I try to run this insert template, I get the following message: The root cause was that: java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:482) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:461) at org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(AbstractJdbc1Connection.java:957) at coldfusion.server.j2ee.sql.JRunConnection.setAutoCommit(JRunConnection.java:394) at coldfusion.server.j2ee.sql.JRunConnectionHandle.setAutoCommit(JRunConnectionHandle.java:91) at coldfusion.tagext.sql.TransactionTag.verifyDataSrc(TransactionTag.java:219) at coldfusion.tagext.sql.QueryTag.validate(QueryTag.java:297) at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:393) at cfcreateperson_rd2ecfm1695250311.runPage(/Applications/JRun4/servers/default/cfusion/knitlib/createperson_rd.cfm:59) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:24) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Yet, it works when I comment out the cftransaction tags.So, what does this error message mean?I'm using CFMX 6.1. Lola [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Have to cycle the server.That's the point of the trusted cache, it never has to hit the filesystem except on startup. Has this changed in CFMX? I know that with CF 5, it wasn't necessary to cycle the server. All you had to do was clear the trusted cache checkbox, run the page, then recheck the trusted cache checkbox. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Thanks for the quick response. That did the trick. -w At 01:50 PM 12/23/2003, you wrote: Turn that option off and restart CF. Trusted cache is not supposed to be used when you are making small changes, actually the whole point of it is to use it when there are no changes being made (until a next deployment). --- Ben -Original Message- From: walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 3:44 PM To: CF-Talk Subject: flusing the trusted cache We just turned on the trusted cache in the cf administrator (CF5.0 on Solaris), and now I can't seem to flush it when small changes are made. The old pages still show. Anyone got any tricks for cleaning the trusted cache out? thanks in advance. _ walker fenton [EMAIL PROTECTED] 303.722.5473 _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
You're right Dave, it says in the CF admin that it doesn't require restarting the server.So probably just have to ensure all the changed templates run while it's unchecked and then you can recheck it.Never bothered to read the text.; ) Cheers, barneyb -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:12 PM To: CF-Talk Subject: RE: flusing the trusted cache Have to cycle the server.That's the point of the trusted cache, it never has to hit the filesystem except on startup. Has this changed in CFMX? I know that with CF 5, it wasn't necessary to cycle the server. All you had to do was clear the trusted cache checkbox, run the page, then recheck the trusted cache checkbox. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Creating PDF
Hi there: I'd like to create a simple pdf on fly and save it in the server dir.. Any help ? Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
I was going to ask this a MAX but never got to.Is there anyway to send a command (java? or other ) to flush the trusted cache?If not can that be a new feature of black stone?I have several times that I would love to turn on trusted cache but, I can't reset the server to make updates. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:51 PM To: CF-Talk Subject: RE: flusing the trusted cache Have to cycle the server.That's the point of the trusted cache, it never has to hit the filesystem except on startup. barneyb -Original Message- From: walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 12:44 PM To: CF-Talk Subject: flusing the trusted cache We just turned on the trusted cache in the cf administrator (CF5.0 on Solaris), and now I can't seem to flush it when small changes are made. The old pages still show. Anyone got any tricks for cleaning the trusted cache out? thanks in advance. _ walker fenton [EMAIL PROTECTED] 303.722.5473 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PDF on Fly
I found article in www.sys-con.com about it with the title PDFs on the Fly But who know another ways? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL and CFTRANSACTION
Lola Lee wrote: I have Postgresql 7.4 installed.Have a form and I'm trying to insert the form contents into several tables in the database. Whenever I wrap the queries with the cftransaction tags and I try to run this insert template, I get the following message: The root cause was that: java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported Yet, it works when I comment out the cftransaction tags.So, what does this error message mean? It probably means you have an outdated JDBC driver: http://archives.postgresql.org/pgsql-jdbc/2003-11/msg00184.php Make sure you have at least the the 7.4 driver: http://jdbc.postgresql.org/download.html Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PDF on Fly
didn't read the article, but i'm using the itext library in java, its tons o' fun -seth -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:35 PM To: CF-Talk Subject: PDF on Fly I found article in www.sys-con.com about it with the title PDFs on the Fly But who know another ways? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PDF on Fly
Thanks Seth!! Colud u send me a little example? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 03:40 PM To: CF-Talk Subject: RE: PDF on Fly didn't read the article, but i'm using the itext library in java, its tons o' fun -seth -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:35 PM To: CF-Talk Subject: PDF on Fly I found article in www.sys-con.com about it with the title PDFs on the Fly But who know another ways? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flusing the trusted cache
Tip:Turn Trusted Cache off! That feature is not recommended. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:43 PM Subject: flusing the trusted cache | We just turned on the trusted cache in the cf administrator (CF5.0 on | Solaris), and now I can't seem to flush it when small changes are made. The | old pages still show. | | Anyone got any tricks for cleaning the trusted cache out? | | thanks in advance. | | | | | _ | walker fenton | [EMAIL PROTECTED] | 303.722.5473 | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PDF on Fly
Before you start looking at this, if you have a Windows server that you can install software on, look into htmldoc, would be much easier than this(at least I think so). So, take a look here and get the library: http://www.lowagie.com/iText/docs.html Here's some sample code in CF utilizing Java and iText, I stripped out a lot of code from this or it would have been much longer(needs cleaning as well), all this does is put an image into a pdf and saves it: CFPARAM NAME=attributes.save_as DEFAULT=#my_path#\mypdf_#createUUID()#.pdf cfquery name=query datasource=#app_datasource# username=#app_user# password=#app_passwd# SELECT * FROM mytable /cfquery cfscript pdfFile = createObject(java, java.io.FileOutputStream).init(attributes.save_as); PageSize = createObject(java, com.lowagie.text.PageSize).init(); document = createObject(java, com.lowagie.text.Document).init(PageSize.A4, 0, 0, 0, 0); PdfWriter = createObject(java, com.lowagie.text.pdf.PdfWriter); PdfWriter.getInstance(document, pdfFile); FontFactory = createObject(java, com.lowagie.text.FontFactory); Font = createObject(java, com.lowagie.text.Font); BaseFont = createObject(java, com.lowagie.text.pdf.BaseFont); helvetica = BaseFont.createFont(Helvetica, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); regular = Font.init(helvetica, 10, Font.NORMAL); bold = Font.init(helvetica, 10, Font.BOLD); bbold = Font.init(helvetica, 14, Font.BOLD); newfont = FontFactory.getFont(FontFactory.HELVETICA, javacast(int,10), javacast(int,5)); Paragraph = createObject(java, com.lowagie.text.Paragraph); Color = createObject(java, java.awt.Color); Image = createObject(java, com.lowagie.text.Image); Cell = createObject(java, com.lowagie.text.Cell); Element = createObject(java, com.lowagie.text.Element); document.open(); section1 = createObject(java, com.lowagie.text.Table).init(2); section1.setBorderWidth(0); section1.setBorder(0); section1.setSpacing(0); section1.setPadding(0); section1.setDefaultCellBorder(0); section1.setWidth(98); img = Image.getInstance(javacast(string,myimage)); img.setAlignment(2); newcell1 = Cell.init(img); newcell1.setColspan(2); section1.addCell(newcell1); document.add(section1); document.close(); /cfscript -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 5:52 PM To: CF-Talk Subject: RE: PDF on Fly Thanks Seth!! Colud u send me a little example? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 03:40 PM To: CF-Talk Subject: RE: PDF on Fly didn't read the article, but i'm using the itext library in java, its tons o' fun -seth -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:35 PM To: CF-Talk Subject: PDF on Fly I found article in www.sys-con.com about it with the title PDFs on the Fly But who know another ways? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: RE: PDF on Fly
Another suggestion.If you are not 100% locked into PDF's you might like to look at MacromediaFlashpaper.It is much quicker to load in a browser than PDF files. Kind Regards - Mike Brunt Original Message --- Before you start looking at this, if you have a Windows server that you can install software on, look into htmldoc, would be much easier than this(at least I think so). So, take a look here and get the library: http://www.lowagie.com/iText/docs.html Here's some sample code in CF utilizing Java and iText, I stripped out a lot of code from this or it would have been much longer(needs cleaning as well), all this does is put an image into a pdf and saves it: CFPARAM NAME=attributes.save_as DEFAULT=#my_path#\mypdf_#createUUID()#.pdf cfquery name=query datasource=#app_datasource# username=#app_user# password=#app_passwd# SELECT * FROM mytable /cfquery cfscript pdfFile = createObject(java, java.io.FileOutputStream).init(attributes.save_as); PageSize = createObject(java, com.lowagie.text.PageSize).init(); document = createObject(java, com.lowagie.text.Document).init(PageSize.A4, 0, 0, 0, 0); PdfWriter = createObject(java, com.lowagie.text.pdf.PdfWriter); PdfWriter.getInstance(document, pdfFile); FontFactory = createObject(java, com.lowagie.text.FontFactory); Font = createObject(java, com.lowagie.text.Font); BaseFont = createObject(java, com.lowagie.text.pdf.BaseFont); helvetica = BaseFont.createFont(Helvetica, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); regular = Font.init(helvetica, 10, Font.NORMAL); bold = Font.init(helvetica, 10, Font.BOLD); bbold = Font.init(helvetica, 14, Font.BOLD); newfont = FontFactory.getFont(FontFactory.HELVETICA, javacast(int,10), javacast(int,5)); Paragraph = createObject(java, com.lowagie.text.Paragraph); Color = createObject(java, java.awt.Color); Image = createObject(java, com.lowagie.text.Image); Cell = createObject(java, com.lowagie.text.Cell); Element = createObject(java, com.lowagie.text.Element); document.open(); section1 = createObject(java, com.lowagie.text.Table).init(2); section1.setBorderWidth(0); section1.setBorder(0); section1.setSpacing(0); section1.setPadding(0); section1.setDefaultCellBorder(0); section1.setWidth(98); img = Image.getInstance(javacast(string,myimage)); img.setAlignment(2); newcell1 = Cell.init(img); newcell1.setColspan(2); section1.addCell(newcell1); document.add(section1); document.close(); /cfscript -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 5:52 PM To: CF-Talk Subject: RE: PDF on Fly Thanks Seth!! Colud u send me a little example? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 03:40 PM To: CF-Talk Subject: RE: PDF on Fly didn't read the article, but i'm using the itext library in java, its tons o' fun -seth -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:35 PM To: CF-Talk Subject: PDF on Fly I found article in www.sys-con.com about it with the title PDFs on the Fly But who know another ways? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Not recommended by whom? From: Doug White [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:51 PM To: CF-Talk Subject: Re: flusing the trusted cache Tip: Turn Trusted Cache off! That feature is not recommended. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:43 PM Subject: flusing the trusted cache | We just turned on the trusted cache in the cf administrator (CF5.0 on | Solaris), and now I can't seem to flush it when small changes are made. The | old pages still show. | | Anyone got any tricks for cleaning the trusted cache out? | | thanks in advance. | | | | | _ | walker fenton | [EMAIL PROTECTED] | 303.722.5473 | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Capturing SQL Going to DB in CFMX
Long ago I remember someone posting a neat trick to capture SQL being executed on the DB (service factory I think)...In the event of an error you could log the actual SQL for analysis...I'm using bind variables so cfsavecontent method won't work... If anyone can point me in the right direction I'd be much obliged! Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PDF on Fly
Oh...Thanks Seth very interesting.. I'll try it. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 04:01 PM To: CF-Talk Subject: RE: PDF on Fly Before you start looking at this, if you have a Windows server that you can install software on, look into htmldoc, would be much easier than this(at least I think so). So, take a look here and get the library: http://www.lowagie.com/iText/docs.html Here's some sample code in CF utilizing Java and iText, I stripped out a lot of code from this or it would have been much longer(needs cleaning as well), all this does is put an image into a pdf and saves it: CFPARAM NAME=attributes.save_as DEFAULT=#my_path#\mypdf_#createUUID()#.pdf cfquery name=query datasource=#app_datasource# username=#app_user# password=#app_passwd# SELECT * FROM mytable /cfquery cfscript pdfFile = createObject(java, java.io.FileOutputStream).init(attributes.save_as); PageSize = createObject(java, com.lowagie.text.PageSize).init(); document = createObject(java, com.lowagie.text.Document).init(PageSize.A4, 0, 0, 0, 0); PdfWriter = createObject(java, com.lowagie.text.pdf.PdfWriter); PdfWriter.getInstance(document, pdfFile); FontFactory = createObject(java, com.lowagie.text.FontFactory); Font = createObject(java, com.lowagie.text.Font); BaseFont = createObject(java, com.lowagie.text.pdf.BaseFont); helvetica = BaseFont.createFont(Helvetica, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); regular = Font.init(helvetica, 10, Font.NORMAL); bold = Font.init(helvetica, 10, Font.BOLD); bbold = Font.init(helvetica, 14, Font.BOLD); newfont = FontFactory.getFont(FontFactory.HELVETICA, javacast(int,10), javacast(int,5)); Paragraph = createObject(java, com.lowagie.text.Paragraph); Color = createObject(java, java.awt.Color); Image = createObject(java, com.lowagie.text.Image); Cell = createObject(java, com.lowagie.text.Cell); Element = createObject(java, com.lowagie.text.Element); document.open(); section1 = createObject(java, com.lowagie.text.Table).init(2); section1.setBorderWidth(0); section1.setBorder(0); section1.setSpacing(0); section1.setPadding(0); section1.setDefaultCellBorder(0); section1.setWidth(98); img = Image.getInstance(javacast(string,myimage)); img.setAlignment(2); newcell1 = Cell.init(img); newcell1.setColspan(2); section1.addCell(newcell1); document.add(section1); document.close(); /cfscript -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 5:52 PM To: CF-Talk Subject: RE: PDF on Fly Thanks Seth!! Colud u send me a little example? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 03:40 PM To: CF-Talk Subject: RE: PDF on Fly didn't read the article, but i'm using the itext library in java, its tons o' fun -seth -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:35 PM To: CF-Talk Subject: PDF on Fly I found article in www.sys-con.com about it with the title PDFs on the Fly But who know another ways? Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
It's OK for production sites (single web site only) that do not change. It should NOT be turned on when developing. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: chris kief [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 9:09 AM To: CF-Talk Subject: RE: flusing the trusted cache Not recommended by whom? From: Doug White [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 1:51 PM To: CF-Talk Subject: Re: flusing the trusted cache Tip:Turn Trusted Cache off! That feature is not recommended. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:43 PM Subject: flusing the trusted cache | We just turned on the trusted cache in the cf administrator (CF5.0 on | Solaris), and now I can't seem to flush it when small changes are made. The | old pages still show. | | Anyone got any tricks for cleaning the trusted cache out? | | thanks in advance. | | | | | _ | walker fenton | [EMAIL PROTECTED] | 303.722.5473 | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flusing the trusted cache
I thought I may have heard that somewhere... do you have a url or something I could reference? thanks At 02:50 PM 12/23/2003, you wrote: Tip:Turn Trusted Cache off! That feature is not recommended. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfmhttp://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.comhttp://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:43 PM Subject: flusing the trusted cache | We just turned on the trusted cache in the cf administrator (CF5.0 on | Solaris), and now I can't seem to flush it when small changes are made. The | old pages still show. | | Anyone got any tricks for cleaning the trusted cache out? | | thanks in advance. | | | | | _ | walker fenton | [EMAIL PROTECTED] | 303.722.5473 | | | -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Merry Christmas and Happy New Year!
Well it is 10:32AM on Christmas Eve in Australia. All is quiet and I'm just waiting for a mate to finish work so I can nick off down to the NSW South Coast for a cuppla days. I'd just like to wish everyone on this list a Merry Christmas and a Happy CF New Year! Can't wait to see what MM do with their products next year! All the best! Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Tip: Turn Trusted Cache off! That feature is not recommended. I strongly recommend the opposite for production environments. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merry Christmas and Happy New Year!
and to you the same peter!!! we've only got a day or so left on here in the eastern usa, its that time for us :) cheers tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 6:41 PM To: CF-Talk Subject: Merry Christmas and Happy New Year! Well it is 10:32AM on Christmas Eve in Australia. All is quiet and I'm just waiting for a mate to finish work so I can nick off down to the NSW South Coast for a cuppla days. I'd just like to wish everyone on this list a Merry Christmas and a Happy CF New Year! Can't wait to see what MM do with their products next year! All the best! Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Capturing SQL Going to DB in CFMX
Long ago I remember someone posting a neat trick to capture SQL being executed on the DB (service factory I think)...In the event of an error you could log the actual SQL for analysis...I'm using bind variables so cfsavecontent method won't work... http://lists.evolt.org/archive/Week-of-Mon-20020826/121235.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Tip: Turn Trusted Cache off! That feature is not recommended. I strongly recommend the opposite for production environments. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 But only on a single site environment? Doesn't trusted cache cause hassles on servers with multiple sites? Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Capturing SQL Going to DB in CFMX
Exactly it...thanks Dave Stace _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 7:31 PM To: CF-Talk Subject: RE: Capturing SQL Going to DB in CFMX Long ago I remember someone posting a neat trick to capture SQL being executed on the DB (service factory I think)...In the event of an error you could log the actual SQL for analysis...I'm using bind variables so cfsavecontent method won't work... http://lists.evolt.org/archive/Week-of-Mon-20020826/121235.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
I agree with Dave. It has performance gains, but more importantly, it discourages tweaking on live boxes. --- Ben -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 7:19 PM To: CF-Talk Subject: RE: flusing the trusted cache Tip: Turn Trusted Cache off! That feature is not recommended. I strongly recommend the opposite for production environments. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Tip: Turn Trusted Cache off! That feature is not recommended. I strongly recommend the opposite for production environments. But only on a single site environment? Doesn't trusted cache cause hassles on servers with multiple sites? Not in a production environment - you can have as many virtual servers on your machines as you want. By production environment, I mean servers where you put finished builds of production applications, not servers where you do development and maintenance, as well as host production applications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Lots of web hosting companies use multihomed servers. That setting must be turned off for multihomed servers. I haven't seen a recommendation from MACR that multihomed servers shouldn't be used in a production environment. While it may be sensible for a major app to have its own server or cluster of servers, CF can be used for small sites too that don't need (and can't afford) an entire server to themselves. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 3:08 p.m. To: CF-Talk Subject: RE: flusing the trusted cache Tip: Turn Trusted Cache off! That feature is not recommended. I strongly recommend the opposite for production environments. But only on a single site environment? Doesn't trusted cache cause hassles on servers with multiple sites? Not in a production environment - you can have as many virtual servers on your machines as you want. By production environment, I mean servers where you put finished builds of production applications, not servers where you do development and maintenance, as well as host production applications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
Tip: Turn Trusted Cache off! That feature is not recommended. I strongly recommend the opposite for production environments. But only on a single site environment? Doesn't trusted cache cause hassles on servers with multiple sites? Not in a production environment - you can have as many virtual servers on your machines as you want. By production environment, I mean servers where you put finished builds of production applications, not servers where you do development and maintenance, as well as host production applications. Lots of web hosting companies use multihomed servers. That setting must be turned off for multihomed servers. I haven't seen a recommendation from MACR that multihomed servers shouldn't be used in a production environment. While it may be sensible for a major app to have its own server or cluster of servers, CF can be used for small sites too that don't need (and can't afford) an entire server to themselves. This has nothing to do with the number of virtual servers and everything to do with how often code changes on said servers. You can certainly use trusted cache with multiple virtual servers, as long as no one's changing code on any of them. I worked in an environment just last week with about three hundred virtual servers, in which trusted cache was used. Macromedia does recommend the separation of production, staging and development environments - it's explicitly mentioned in their courseware. Again, when I use the phrase production environment, I mean something pretty specific. Using separate J2EE server instances, it is possible to separate production applications from development ones to some degree. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
OK, I was thinking of the Cache real path setting not the trusted cache setting. Perhaps Peter is too. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 December 2003 4:43 p.m. To: CF-Talk Subject: RE: flusing the trusted cache Tip: Turn Trusted Cache off! That feature is not recommended. I strongly recommend the opposite for production environments. But only on a single site environment? Doesn't trusted cache cause hassles on servers with multiple sites? Not in a production environment - you can have as many virtual servers on your machines as you want. By production environment, I mean servers where you put finished builds of production applications, not servers where you do development and maintenance, as well as host production applications. Lots of web hosting companies use multihomed servers. That setting must be turned off for multihomed servers. I haven't seen a recommendation from MACR that multihomed servers shouldn't be used in a production environment. While it may be sensible for a major app to have its own server or cluster of servers, CF can be used for small sites too that don't need (and can't afford) an entire server to themselves. This has nothing to do with the number of virtual servers and everything to do with how often code changes on said servers. You can certainly use trusted cache with multiple virtual servers, as long as no one's changing code on any of them. I worked in an environment just last week with about three hundred virtual servers, in which trusted cache was used. Macromedia does recommend the separation of production, staging and development environments - it's explicitly mentioned in their courseware. Again, when I use the phrase production environment, I mean something pretty specific. Using separate J2EE server instances, it is possible to separate production applications from development ones to some degree. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flusing the trusted cache
walker wrote: We just turned on the trusted cache in the cf administrator (CF5.0 on Solaris), and now I can't seem to flush it when small changes are made. The old pages still show. Anyone got any tricks for cleaning the trusted cache out? You can programatically flush the cache without going to the admin turning on and turning off etc.. see: Flushing Trusted Cache (CF5 only) http://cfguru.daemon.com.au/archives/31.html -- geoff http://www.daemon.com.au/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]