Re: file.encoding not being set
i've forgotten, what OS? on linux there was a core java issue (sun said it This is on windows server 2003 unless there's another JDK install that the cf's using i don't know what else to suggest except posting this issue to the core java i18n forums: http://forum.java.sun.com/forum. jspa?forumID=16 I will give that a try - thank you very much for your help :) S ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
file.encoding not being set
Hi There, I have a problem with the file.encoding in my jvm config, on one server(installed in UK) the locale etc is en_GB and the file.encoding is cp1252. On a machine we have in Moscow(originally installed in Russian locale) I have managed to change the java default locale to be en_GB but the locale is stubbornly staying at cp1251. We believe this may be having an effect on some of the number formatting etc but can't get it to change to even test that hypothesis. The setting I have tried in the jvm config is: -Dfile.encoding=cp1252 but it still says in the settings summary that it's using cp1252 Any help much appreciated. Cheers Simon ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: file.encoding not being set
Sim locale) I have managed to change the java default locale to be en_GB but the locale is stubbornly staying at cp1251. We believe this may be having an cp1251 is a windows codepage (encoding), not a locale. effect on some of the number formatting etc but can't get it to change to it shouldn't. locale is locale that's what should be controlling locale resources. encoding is another issue. which is giving you trouble? if locale you can try forcing the jvm to a locale via: -Duser.language=en -Duser.region=GB what you have already should do the trick for file encoding. I have done this already and it appeared in coldfusion correctly but the file.encoding still remains at 1251. you can peek at the server default locale via getLocale(). Default locale is en and still no joy i guess you should also check if the apps on the russian server setting the locale server wide? It does set the locale but to en even test that hypothesis. The setting I have tried in the jvm config is: -Dfile.encoding=cp1252 but it still says in the settings summary that it's using cp1252 ? you mean 1251? did you stop/restart the server? Apologies - it should have said that the settings summary is staying as cp1251. The services and server have been restarted a number of times. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Subversion... CF's built-in webserver ... Can I do this?
On Thursday 10 May 2007, [EMAIL PROTECTED] wrote: commit the file to prod when I commit the dev file. This allows me to save and test away on dev and once I have the working version, I can then commit and send it to prod in one stroke. Same as us. We're setup to allow anonymous checkout, but require login to commit. This means we can checkout a branch/tag to the production servers, but discourages you from making changes there. We have an ssh server running on the production server and scripts which a developer/pm must run to upload a site. This gives us an audit trail and also the ability for developers to work on the code and commit it at their leisure without worrying that all changes go straight to the live site. The dev server is not backed up so the policy for all developers is to commit into the repository as often as they are able - we save a ton of backup space in this manner. Cheers S ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with cf executing stored procedures
All, I hope you can help us with a problem we are experiencing with execution of stored procedures from coldfusion pages. Stored procedures are running very slowly only when executed from cf pages, when they're run in the SQL 2000 query analyser they run in sometimes less than a second but when run from coldfusion they can take upwards of 60-80seconds seconds (which seems ridiculous). The timer in the debugging states that the sp has taken 10ms to run but when we put a time round it we get a time of the 60-80 seconds. I am wondering if there is something I have missed in the cf administrator or a hot fix I have missed or something wrong with my SQL setup which is causing this huge delay? CF version is 7.0.2.142559 SQL is Sql server 2000 All advice appreciated Cheers S ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
jrun and clustering
All, i have been looking at http://www.macromedia.com/devnet/coldfusion/j2ee/articles/endtoend.html and followed the instructions there about creating the cluster/cd instances etc and am still getting this message whenever I view a cfm page. headtitleJRun Servlet Error/title/headh1500 There is no web application configured to service your request/h1body There is no web application configured to service your request/body I am using cfmx7 trial edition for j2ee with jrun4 dev edition (latest versions) My httpd.conf section for cfm looks like this: LoadModule jrun_module /opt/jrun4/lib/wsconfig/1/mod_jrun.so IfModule mod_jrun.c JRunConfig Verbose false JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore /opt/jrun4/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap 10.0.13.9:51003 #JRunConfig Errorurl optionally redirect to this URL on errors AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc /IfModule I would guess that the bootstrap line is pointing to the wrong place as 51003 is the port number for the 3rd instance of cfmx7 but I am very confused by it tbh. Any kind souls out there would like to help me out? Cheers Simon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238804 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Oracle Error
All, Has anyone ever experienced this error: [Oracle][ODBC][Ora]ORA-12163: TNS:connect descriptor is too long I am working with CF5 on windows using Oracle 8i drivers connecting to a 9i database - the error happens intermittently and I am having trouble replicating it for the client. I am seeing some things in the application.log which are causing some concern ie %20%20VALUE%20%20 but I am unclear as to why this would be causing an error when sending data. Any advice much appreciated Cheers Simon ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210455 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfgrid on cfmx7
Hi There, I have come across something using cfgrid on a new install of cfmx7 which I currently evaluating. I have performed a clean install of cfmx7 on win2k server which resulted in a /cfide virtual directory being created in IIS, in this directory were all the directories normally associated (ie administrator etc). I firstly attempted to create a cfide directory and then create a virtual directory called classes pointing to the dir in c:inetpub but this resulted in no data being passed from the form to the action page. I then attempted to restrict access to every folder except classes using IP filtering but again no data was submitted from the form. I do not want my cfadministrator dir available from anywhere except localhost and would therefore see this as a bug - can anyone else verify/advise me on this? Cheers Simon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfgrid on cfmx7
Jon, Thanks - I will give this a try tomorrow, I think it would make sense to not require all those directories to be present in every site that requires a cfgrid though? S On 04/05/05, Jon Gunnip [EMAIL PROTECTED] wrote: Simon, I have cfgrid working on CF7 with IIS. I have done an IP restriction to localhost for all directories except classes and scripts. Perhaps you need to open up the scripts directory too? Jon On 5/4/05, Simon Whittaker [EMAIL PROTECTED] wrote: Hi There, I have come across something using cfgrid on a new install of cfmx7 which I currently evaluating. I have performed a clean install of cfmx7 on win2k server which resulted in a /cfide virtual directory being created in IIS, in this directory were all the directories normally associated (ie administrator etc). I firstly attempted to create a cfide directory and then create a virtual directory called classes pointing to the dir in c:inetpub but this resulted in no data being passed from the form to the action page. I then attempted to restrict access to every folder except classes using IP filtering but again no data was submitted from the form. I do not want my cfadministrator dir available from anywhere except localhost and would therefore see this as a bug - can anyone else verify/advise me on this? Cheers Simon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205615 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfgrid problems
Hi All, I am having problems with cfgrid/cfform under CFMX 6.1 with latest updater applied and cfgrid hotfix applied. THe problem is that I am getting the form returned from the cfgrid has no elements in it and fieldnames with leading underscore. Has anyone else experienced this problem and found a solution to it? I have tested this using both my mac and my windows machine and the problem is the same with both. Appreciate any help Cheers Simon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Corrupt form data:premature ending
I am still experiencing the below - anyone have any experience of it at all? Happens everytime a form is submitted. Simon On Mon, 6 Dec 2004 09:45:12 +, Simon Whittaker [EMAIL PROTECTED] wrote: Error Occurred While Processing Request Corrupt form data: premature ending Please try the following: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address Referrer http://the.url.com/folder/pagename.cfm?ID=1491ID2=128ID3=390ID4=1234ID5=0091843212 Date/Time 06-Dec-04 09:41 AM Stack Trace (click to expand) java.io.IOException: Corrupt form data: premature ending at com.oreilly.servlet.multipart.MultipartParser.init(MultipartParser.java:166) at com.oreilly.servlet.multipart.MultipartParser.init(MultipartParser.java:94) at coldfusion.filter.FormScope.fillMultipart(FormScope.java:98) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:343) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Corrupt form data:premature ending
Attachments not allowed...stick it in the message ;-) ooops :) Error Occurred While Processing Request Corrupt form data: premature ending Please try the following: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address Referrer http://the.url.com/folder/pagename.cfm?ID=1491ID2=128ID3=390ID4=1234ID5=0091843212 Date/Time 06-Dec-04 09:41 AM Stack Trace (click to expand) java.io.IOException: Corrupt form data: premature ending at com.oreilly.servlet.multipart.MultipartParser.init(MultipartParser.java:166) at com.oreilly.servlet.multipart.MultipartParser.init(MultipartParser.java:94) at coldfusion.filter.FormScope.fillMultipart(FormScope.java:98) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:343) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Corrupt form data:premature ending
All, Anyone seen the attached error before? Google not being as helpful as I want it to be. CFMX 6.1 Win2k professional All updates etc cheers Simon ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cleaning up
Hi All, I have a page with lots of different queries being performed - essentially linking up multiple different databases. I have recently started to get an error like this: java.lang.OutOfMemoryError Essentially a select query is performed followed by various bits of processing and validation followed by some insert queries.Is it possible to release the memory of the query after it has been used or is this already being done? If it is being done already would it be of use to me to increase the size of the JVM memory generation size as the link below? http://www.macromedia.com/support/coldfusion/ts/documents/java_lang_outofmemory.htm Also, could I consider breaking up the huge page into smaller pages and including/linking to them? TIA Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Windows groups
All, If I am authenticating a user with Windows Authentication in IIS - I know that I can get the user name with the cgi.remote_user variable but is there any way for me to find out what windows groups the user is a member of? Have been reading about cflogin - anyone any experiences with this and windows authentication? TIA Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cftreeitem Duplicate Parent Name Problem
I have had loads of problems with cftree - including client issues with incorrect java versions etc etc We replaced any cftrees we had with cf_treecontrol from: http://www.cftagstore.com/tags/cftreecontrol.cfm It costs $40 but is well worth it. Cheers Simon On Wed, 21 Jul 2004 10:25:39 -0400, Mike Nimer [EMAIL PROTECTED] wrote: The problem is CFTREE now builds the tree based on what you say using the parent attribute, not the position of the child tags. And unfortunately with that change we can't guess which Projects parent you meant. But there is a solution, there is a display attribute you can use. What you need is to define unique value/parent combo's but use the display attribute so they render with the same name in the tree. Also there is a hotfix available for cftree/cfform, if you haven't already you should install that as well. It has some other fixes for cfform (alerts in order, etc..) cftree name=test1 cftreeitem value=2003 cftreeitem value=2003Projects display=Projects parent=2003 cftreeitem value=2003 Project 1 parent=2003Projects cftreeitem value=2003 Project 2 parent=2003Projects cftreeitem value=2004 cftreeitem value=2004Projects display=Projects parent=2004 cftreeitem value=2004 Project 1 parent=2004Projects cftreeitem value=2004 Project 2 parent=2004Projects /cftree hth, nimer _ From: Michael Schlei [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 6:09 PM To: CF-Talk Subject: cftreeitem Duplicate Parent Name Problem I recently upgraded Coldfusion from 6.0 to 6.1 (was forced to do so after upgrading the server to Windows Server 2003).Now, I'm having problems with cftreeitems being put in the wrong place in the cftree control.The following code shows an example of the problem: cftree .. cftreeitem value=2003 cftreeitem value=Projects parent=2003 cftreeitem value=2003 Project 1 parent=Projects cftreeitem value=2003 Project 2 parent=Projects cftreeitem value=2004 cftreeitem value=Projects parent=2004 cftreeitem value=2004 Project 1 parent=Projects cftreeitem value=2004 Project 2 parent=Projects /cftree In 6.0, this code worked perfectly and placed the 2004 projects in the Projects folder under 2004.But in 6.1, this no longer works - the 2004 projects are placed in the projects folder under 2003 - Coldfusion cannot properly handle the duplicate parent name in different sections of the tree. I would hope that there is a fix for this, as the cftree control is of no use to me the way it is now.By the way, I have already installed the following hotfix from Macromedia, which has done nothing to solve this problem: http://www.macromedia.com/support/coldfusion/ts/documents/cfform_hotfix.htm .Any assistance would be much appreciated.Thank you for your time. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf mx and oracle 8i
On Tue, 20 Jul 2004 09:51:37 +0200, Steff [EMAIL PROTECTED] wrote: Hello I have a request like insert into toolbox (idtoolbox,label,descr,language,idlinktype,idsource,creatingdate,updatingdat e,publish,delstatus,orderby) values (2,'services et catgories','','FR',0,0,to_date('2004-07-19 00:00:00.0', 'dd/mm/'),to_date('2004-07-19 00:00:00.0', 'dd/mm/'),1,0,) snip I obtain this error Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string snip I may be wrong but try taking out the time string from the date and also ensuring that the format of the date matches ie: to_date('19/07/2004', 'dd/mm/') HTH Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf mx and oracle 8i
Steff, You need to use to_date as this is used by Oracle to convert your date from a string into the correct format. Have you tried the re-ordering I suggested? to_date('19/07/2004', 'dd/mm/') Cheers Simon On Tue, 20 Jul 2004 10:20:05 +0200, Steff [EMAIL PROTECTED] wrote: I try and I obtain ORA-00932: inconsistent datatypes Can you help me? thanks steff -Message d'origine- De : Micha Schopman [mailto:[EMAIL PROTECTED] Envoy : Tuesday, July 20, 2004 10:06 AM : CF-Talk Objet : RE: cf mx and oracle 8i Try using createODBCDateTime() to specify a dateobject, instead of to_date() Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf mx and oracle 8i
On Tue, 20 Jul 2004 10:32:35 +0200, Steff [EMAIL PROTECTED] wrote: I think where is the problem, I get date values with a query. The table valueis like 19-JUL-04. Coldfusion gives me a date like '2004-07-19 00:00:00.0' to_date can't convert. So I should certainly before insert query, modify the date to obtain the right format. That is right - try something like the following: to_date('#dateformat(date_from_query,DD/MM/)#','DD/MM/') Should work okay for you Cheers Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Errors 232s Long running requests, and lots more stuff
Tracy, Did you find a resolution for this issue? Am seeing it on a cf5 server which I need to get sorted. Cheers Simon I can't seem to find the answer to these contstant errors/warnings in the log file of cf 5... It seems all throughout the day, I'm seeing NT error 232 A long-running request returned. The unresponsive thread count is down to 0. A request exceeded the timeout. The unresponsive thread count is up to 1. !!CFTrace::logThread(1116) has no entry for thread 1116 Can anyone clue me in on where I need to start looking ? One thing, I'm concerned about is the group that wrote this application used session variables continously and didn't use any locking whatsoever.. If this a possibility of the problems ? .. Could it be timing out talking to the database server ? Thanks ! - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Urgent help needed Please.....
On Tue, 20 Jul 2004 17:21:17 -0400, Sangeeta Karmokar [EMAIL PROTECTED] wrote: Hi, I am new to CF. we have backend as MySql and I am trying to inser into a database created in SQL using this query: cfquery name=add datasource=newmembers INSERT INTO members (name,email) VALUES ('#name#','#email#') But it is not adding to the database, the submit is just going to the query page and we can see all these codes in browsers... If I understand correctly you are able to view the raw cf code in your browser - is that correct? If so, then coldfusion is not parsing the code before handing it over tothe webserver. 1st things first - is the page called something.cfm? If not, change it to a cfm extension and then try again.If not - what web server are you using and on which platform. Also, you forgot to close your cfquery tag up there - could that be a simpler answer? Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: server hang - cfexectask.cfm
Adam, Did you ever work out what was going on with this? Have been experiencing something similar. Cheers Simon I've been trying to hunt down a bug over the last week or so without much luck. The CF service is hanging at least once a week on our CF5/win2k server, and I believe it has to do with some code in one of our scheduled tasks, or the scheduled task system itself (not sure why cfexectask.cfm is the first unresponsive thread in our logs). Sometimes the CF service restarts itself, as seen in the log file below, and sometimes I have to restart the CF service manually. If somebodycould send me to a resource on proper task scheduling, best practices, what to avoid - that would be great. Warning,3680,04/06/03,05:27:00,,A request exceeded the timeout. The unresponsive thread count is up to 1. [C:\CFusion\Scripts\cfexectask.cfm] Error,3680,04/06/03,05:27:00,, !!CFTrace::logThread(5644) has no entry for thread 5644 Warning,3680,04/06/03,05:27:30,,A request exceeded the timeout. The unresponsive thread count is up to 2. [D:\Web_Sites\ITC\scheduledTasksSecure\index.cfm] Error,3680,04/06/03,05:27:30,, !!CFTrace::logThread(4976) has no entry for thread 4976 Warning,3680,04/06/03,05:31:00,,A request exceeded the timeout. The unresponsive thread count is up to 3. [C:\CFusion\Scripts\cfexectask.cfm] Error,3680,04/06/03,05:31:00,, !!CFTrace::logThread(3688) has no entry for thread 3688 Warning,3680,04/06/03,05:46:00,,A request exceeded the timeout. The unresponsive thread count is up to 4. [C:\CFusion\Scripts\cfexectask.cfm] Error,3680,04/06/03,05:46:00,, !!CFTrace::logThread(2212) has no entry for thread 2212 Fatal,3680,04/06/03,05:46:30,,Unresponsive thread threshold reached. Restarting service. Information,332,04/06/03,05:46:32,,The ColdFusion Application Server started. Warning,1884,04/06/03,05:55:20,,Template: , Ran: 501 seconds. Adam. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfmail
Am I right in concluding that CFMX6.1 Standard edition does not include the cfmail functionality? According to the feature matrix it would appear to be missing. www.macromedia.com/software/coldfusion/whitepapers/pdf/6_1/cfmx61_feature_comparison_matrix.pdf Cheers Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmail
John, That makes more sense. Cheers Simon On Mon, 19 Jul 2004 11:12:07 -0400, Burns, John D [EMAIL PROTECTED] wrote: CFMAIL works in CFMX 6.1 Standard.That grid lists it as High Performance Email Delivery which I believe allows you to send a lot more email at once (faster) in Enterprise than Standard. John Burns -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 11:02 AM To: CF-Talk Subject: cfmail Am I right in concluding that CFMX6.1 Standard edition does not include the cfmail functionality? According to the feature matrix it would appear to be missing. www.macromedia.com/software/coldfusion/whitepapers/pdf/6_1/cfmx61_featur e_comparison_matrix.pdf Cheers Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfschedules....
Hi there, We have a problem with cfschedule that is proving very annoying now. We created a task to be run on the 1st of every month called newsmail. We noticed that the task was being run at odd times so decided to do further investigation - the task was deleted and then yesterday morning we noticed that the newsmail had been run again. We checked the logs and found the following: Information,jrpp-599,07/30/03,11:25:37,,[NewsMail] Activating2 on Wed Jul 30 11:25:37 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 Information,jrpp-599,07/30/03,11:26:57,,[NewsMail] Activating2 on Wed Jul 30 11:26:57 BST 2003 To run on :Tue Aug 26 07:00:00 BST 2003 This task was deleted and is now activating itself and setting it to run on 'Tue Aug 26 07:00:00 BST 2003'. Anyone had any similar fun with cfschedules or any sensible suggestions for getting round it? Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why can't COM just work in CFMX?
webguy wrote: if it works in ASP but not in CFMX it might be a permissions issue. snip we are having similar problems with ChartFX and CFMX - get an Instantiating COM object error after updater 3 . All permissions seem to be in place but with no joy, again it works in ASP but not CFMX - if you get a fix to these COM problems we would be very grateful if you would post them. Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Downloading data
would cf_html2excel be of any use to you? we use it and from what I understand it does what you're asking Cheers Simon Jerry Johnson wrote: Are you looking for the data file to appear in the browser window, or are you looking for the client to save the data file to his/her local drive, and then execute the macros locally? Jerry Johnson [EMAIL PROTECTED] 06/12/03 08:12PM Hello All, I'd appreciate it if someone code point me to some coding examples for downloading datafiles from CF. Like Cassidy, I'd like to provide my customer with data in an Excel format. I believe I can develop some Excel macros that will insert a datafile (.txt, VFP, etc.) into Excel if the datafile is available. If I can facilitate the user downloading the datafile, they can execute Excel and the macros (VBAcode) will insert the data in the Excel spreadsheet automatically. TIA. Paige ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: numbers too big
Are you not having problems with the 0's being knocked off the front of the phone numbers - I have had to store them as varchars before HTH Simon Michael Tangorre wrote: I have some really large number ranges that I need to store in a SQL Server 2K DB. The numbers are of the following size: range start 00 range end 99 That was one generic example. Basically the number represents a phone number range and I have a range for each country in the world that has telephone service. What would be the best way to store it these ranges so that I can run a query that says, select country name where #phoneNumber# is within the range. I tried inporting the values in as bigints.. no dice, by the way this info is coming in from an excel sheet. Thanks, Michael Tangorre ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Oracle CF5
Hi all, I have a bit of a problem I wouldn't mind some help with - We are using CF5 and Oracle 8i(8.1.7.0.0) (using Native drivers) and our application is running REALLY slowly. We have tuned the queries as much as we see possible and cached wherever possible although the neature of the beast makes caching a bit of a pipe-dream. I have been doing some debugging and found that the first query of the page is taking a very long time: getnews (Records=3, Time=2359ms) SQL = SELECT news_id, headline FROMnews WHERE show = 1 ORDER BY newsdate desc These are not big records and the query is very fast if I perform it through SQLPLUS or TOAD (Oracle gui devlopment tool) - the rest of the queries on the page are then performed in regular time. A tnsping of the box produces: Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=*REMOVEDHOSTNAME*)(PORT=1521)) OK (40 msec) so the connection to the oracle instance itself seems to be a reasonable time. Does anyone have any ideas that could help us out as it is starting to cause problems Many Thanks Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
Re: Should be easy :)
say that temp is your variable cfset temp = Replace(temp,.,) Cheers Simon - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 12:14 PM Subject: Should be easy :) This should be an easy one. How do I remove the first fullstop/period in a string ? TIA Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Should be easy :)
cfset temp = Replace(temp,.,,ONE) Cheers Simon - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 12:21 PM Subject: Re: Should be easy :) Will that not replace ALL periods ? I just want the first... On 20/2/03 12:17, Simon Whittaker [EMAIL PROTECTED] wrote: say that temp is your variable cfset temp = Replace(temp,.,) Cheers Simon - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 12:14 PM Subject: Should be easy :) This should be an easy one. How do I remove the first fullstop/period in a string ? TIA Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfsearch and score
All, Does anyone know how exactly the score is determined in a cfsearch? We have looked through the docs but there is not enough elaboration. Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: who on here did the death clock?
At least radio 1 in the uk are honest about their list http://www.bbc.co.uk/radio1/chart/playlist/alist.shtml Simon - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 2:21 PM Subject: RE: who on here did the death clock? These consultants are usually called Indies and our paid by the record labels, as much as $1000 per spin in major markets. The indie goes up to a radio station and says I'll give you X amount in promotional dollars if you'll sign an exclusive contract with me. Whenever you see a radio station offering some promotion, such as a free trip to England to see a band, usually an Indie donated it to the record station. Whenever a song is added tot he playlist, the indie bills a record company. The only thing I can say in addition to Scott's words is that my understanding is that DJs no longer have any say in playlists, it all goes through a programming manager and the programming manager gets everything from the Indie (consultant). It is a completely legal loop-hole to the payola laws. The consultant is independent of both the radio station and the record company. At 08:55 AM 2/6/2003 -0500, you wrote: Off topic I used to work for a radio station, and the way the DJ's normally get their playlists is through a consultant. The consultant makes a list of songs in 3 groups; high medium, or low rotation (they are termed differently consultant to consultant, but you get the idea). From there, the DJ only plays those songs. And if the consultant recommends playing a certain song, then the DJ does just that... These consultants go to conferences hang-out with the singers (the one consultant I met has hung out with Garth Brooks, Faith Hill, Shania Twain others, just to name a few, on multiple occasions), as well as the label execs. As far as plugging in the playlists, once the DJ gets the list from the consultant, they create a playlist, much like you do in Winamp, and it fires along, cross-fading commercials or other songs into it using multiple sound cards. Sorry, I know more than I want to about the radio industry Scott -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 9:03 AM To: CF-Talk Subject: Re: who on here did the death clock? Off topic here, but Clear Channel owns a significant portion of the radio stations... Payola does exist. Most playlists are piped in (I'm not sure how) to computers which play them. The DJs have no control. I've heard that the three biggest radio stations in Connecticut are three computers sitting side by side in a room. At 08:28 AM 2/6/2003 -0500, you wrote: lol, guess its the competition thing! like when you hear a song on one station then switch to another 5 minutes later and its on and its always some really off the wall song. makes u scratch your nads and wonder if competition really exists! haha ok, no sleep hasn't made me any funnier today Dave -- .::. - - Original Message - From: Critz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 8:13 AM Subject: Re: who on here did the death clock? oi Dave!! ha. they must get their ideas from same place, because radio station in Raleigh was going on about it this morning as well. Critz Thursday, February 6, 2003, 1:18:10 AM, you wrote: DL awee, that's right, I knew I had seen it somewhere. DL was just funny, I was driving today and one of the local Louisville radio DL stations was talking about it today, was quite amusing. DL they were quite intrigued with it, lol DL Dave DL -- .::. - DL - Original Message - DL From: Pablo Varando [EMAIL PROTECTED] DL To: CF-Talk [EMAIL PROTECTED] DL Sent: Thursday, February 06, 2003 1:09 AM DL Subject: Re: who on here did the death clock? That would be Raymond Camden :) Pablo - Original Message - From: Dave Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 11:56 PM Subject: who on here did the death clock? i know someone here did the death clock anyone know who it is? Dave -- .::. - DL ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:
perhaps OT process not being closed
Hi there, I am using cfx_ShellExec to run htmldoc to create pdf reports on the fly. It all works very well - however I have noticed that the htmldoc.exe process is left running after the pdf has been created - in fact there were 30 instances running when I came in this morning which had to be killed manually. Anyone have any ideas as to why this may be happening or how I can cure it, is it a cf problem or not? I have noticed that I am also having this problem with some excel reports that we create (excel.exe is left running in the background). We are using CFMX on Win2k Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
multi-lingual translations
Hi there, Does anyone know if anything (Custom tag etc) exists whereby it would be possible to translate text into other languages on the fly. Ie coming from a database and being translated before it appears on the page? Think it might be a long shot but worth a try. If not this, would anyone have any other ideas about how this might be achieved? Cheers Simon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: The Myth of Bugs (Was Huge Ungainly thread of Doom)
Hi there, Just wanted to add my 2c to this issue - We recently installed a version of cfmx on a completely clean server - the server itself runs fine but the amount of trouble we have had trying to get our previous applications to run under CFMX is mind boggling. I am sure that CFMX is as good as you describe it - of course there will be issues, there always are with new/updated products BUT it is my belief that these products should have backwards compatability, ie sites that run under CF5 should also run under CFMX which is just doesn't seem to be the case at present, I know that unfortunately there will be a lot of redevelopment to make some of our more complex apps run under CFMX. Cheers Simon - Original Message - From: Jesse Noller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:48 PM Subject: The Myth of Bugs (Was Huge Ungainly thread of Doom) All- Funny, I should stop sleeping. I wanted to take a moment to address something that is bothering me a great deal. Out of the huge thread yesterday, there came a lot of realizations that Macromedia is currently examining internally, misconceptions if you will about the way MM communicates things. Make no mistake, these issues are being discussed, as Sean and Vernon have both mentioned. However, one of the things that bothered me the most was the fact several people basically said: OH NOES! CFMX is poop! I won't buy/run it until all of these horrible bugs are fixed. This is what I refer too as the Myth of Bugs. I think something many people are forgetting is the scenario of a mailing list, or the forums. This is the scenario that discourses the fact that mainly the only people who will post to forums, and mailing lists in a typical day are those who have issues. Now, if I read cf-talk on $RAND day, I could safely assume that CFMX was crippled, a lame-duck to the market. Does this assumption make it true? No. It bothers me to hear people say that they will not even try CFMX out because there are so many show stopping issues. I would beg the argument that this is far, very far, from the truth. Those of you dropping CFMX or completely ignoring it because of the debates/issues raised on CF-Talk and the Forums would be better served if you actually downloaded and ran your application yourself, instead of taking the word of the mailing lists and forums. CFMX, as has been stated before, was the *most* tested version of ColdFusion *ever* put on market, I can't make this clear enough. I would imagine that some of the show stopper issues that are being raised have either been addresses, will be address, or are simply environmental. I would also state that the only people who raise the CFMX is Poop flag are those who have hit a bug, or other issue, which is show stopping to *them*. Remember, hundreds of people download CFMX daily (we have the numbers that show this) and run it without issue. *of COURSE* those people who run into any type of problem are immediately going to identify that problem as a show stopper and post to the mailing lists and the forums screaming as loud as they can to hopefully either find a solution or get Macromedia to help them for free. I can only stress that those of you reading these lists and the forums take everything you see with a grain of salt. Not everyone is running into these issues, everyone is not throwing CFMX out the window. We have *many* customers running CFMX in production, under load, daily, fine. If you install CFMX, and you run it, and you find an issue, I cannot stress enough that you contact support *immediately* to get that issue addressed ASAP. I will not admit that the ColdFusion team (myself included) shipped Poop. I will not admit to having wasted nearly two years of my life, I know this is *not* the case. I personally believe that the firestorms shown on this list, and the forums, are not the rule, but rather the exception to the rule. Please, try it out *for yourselves* before passing judgment. Sorry for ranting, it bothers me. A lot. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development No concept man forms is valid unless he integrates it without contradiction into the sum of his knowledge. - Ayn Rand ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
HTML2excel
Hi there, I have been using Peter Stolz's CF_HTML2EXCEL tag on CF 4.5 with great success - however on an upgrade on one of our dev boxes I am getting an error like the following: Error occured while connected to the Excel object! Error Details: An exception occurred when executing a Com method. The Error Occurred in PATH\CustomTags\HTML2Excel.cfm: line 168 Called from PATH\excelreport.cfm: line 374 Called from PATH\excelreport.cfm: line 2164 166 : objExcel.Quit(); 167 : /CFSCRIPT 168 : CFABORT SHOWERROR=FONT COLOR='RED'Error occured while connected to the Excel object!/FONTBRError Details: #CFCATCH.MESSAGE# 169 : /CFCATCH 170 :/CFTRY !--And at the bottom of the page --- Exceptions 12:31:36.036 - Object Exception - in PATH\CustomTags\HTML2Excel.cfm : line 147 An exception occurred when executing a Com method. 12:31:36.036 - Expression Exception - in PATH\CustomTags\HTML2Excel.cfm : line 168 Error occured while connected to the Excel object!Error Details: An exception occurred when executing a Com method. I understand that there are some COM problems in MX but would appreciate any ideas about this. I have tried to contact Mr Stolz directly but have not been able to get through to his email address. Cheers Simon __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML2excel
sorry - should have said upgrade to CFMX DOH!!! Simon - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:34 PM Subject: HTML2excel Hi there, I have been using Peter Stolz's CF_HTML2EXCEL tag on CF 4.5 with great success - however on an upgrade on one of our dev boxes I am getting an error like the following: Error occured while connected to the Excel object! Error Details: An exception occurred when executing a Com method. The Error Occurred in PATH\CustomTags\HTML2Excel.cfm: line 168 Called from PATH\excelreport.cfm: line 374 Called from PATH\excelreport.cfm: line 2164 166 : objExcel.Quit(); 167 : /CFSCRIPT 168 : CFABORT SHOWERROR=FONT COLOR='RED'Error occured while connected to the Excel object!/FONTBRError Details: #CFCATCH.MESSAGE# 169 : /CFCATCH 170 :/CFTRY !--And at the bottom of the page --- Exceptions 12:31:36.036 - Object Exception - in PATH\CustomTags\HTML2Excel.cfm : line 147 An exception occurred when executing a Com method. 12:31:36.036 - Expression Exception - in PATH\CustomTags\HTML2Excel.cfm : line 168 Error occured while connected to the Excel object!Error Details: An exception occurred when executing a Com method. I understand that there are some COM problems in MX but would appreciate any ideas about this. I have tried to contact Mr Stolz directly but have not been able to get through to his email address. Cheers Simon __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: scrolling tables
like this style=z-index : auto; or have I got completely the wrong idea? Simon - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 1:05 PM Subject: RE: scrolling tables Set a z-index in the style property on the table, tr, or td and then that part will scroll. Joshua Tipton -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:59 PM To: CF-Talk Subject: RE: scrolling tables I've seen this done with iframe but I'm not sure if its the best solution. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, 31 May 2002 12:23 PM To: CF-Talk Subject: OT: scrolling tables oi CF-Talk,!! somewherepossibly on the msdn site I've seen an example where table headers are stationary, but the cells are scrollable. anybody else seen this.or know where some Xamples are? thanks -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fw: cfml - asp
- Original Message - From: Simon Whittaker [EMAIL PROTECTED] Sent: Friday, May 31, 2002 3:41 PM Subject: cfml - asp I am trying to get pass dynamic CFML data from a cfm page to a ASP page? Any ideas - custom tags etc? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fw: CFMX etc etc .....
Was just reading forta.com - am I to understand that the new version of dreamweaver is in fact the new code editing environment for CF and that studio MX will not be released? Cheers Simon __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
checking security updates
Hello there, Someone posted a url a few weeks ago which helped a sysadmin check what patches etc were installed on a win 2k machine and what was still needed. I have lost the address - any clues? Cheers Simon __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Opinions/Experience with Webex?
they are very good - have used them numerous times. only drawback is cost. HTH Simon - Original Message - From: Gieseman, Athelene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 2:57 PM Subject: RE: Opinions/Experience with Webex? I've used Webex quite a bit to receive support from one of our vendors. It works very well for us. I've also been looking at using it to provide services to our clients. It's been very reliable when we've used it. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 1:21 PM To: CF-Talk Subject: Opinions/Experience with Webex? Anyone here have any experience with Webex http://www.webex.com that you could share? Or alternatives in the online meeting realm? Webex appears to suit our needs but would appreciate any feedback pro or con that anyone could share. Primary use will be for remotely training personnel on several CF-based web applications. Thanks, Ken __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: hosting
What about www.biznet-hosting.com - 2nd runner up in cfdj awards - 30 days free and well worth a go HTH Simon - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 08, 2002 5:26 AM Subject: RE: hosting I know, I was just stating that they do now support it and they advertise it. Thanks Jeff, I was not trying to cause trouble. ;) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 11:18 PM To: CF-Talk Subject: RE: hosting Just to clarify, I never said that they didn't support that. I just said that they never set it up for me. I heard a lot of I'm sorry, I forgot, I'll do it right away before I gave up altogether. At 11:01 PM 4/7/2002 -0500, you wrote: They do now as I have a client that has 2 domains pointing to one site. Clint -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 10:52 PM To: CF-Talk Subject: RE: hosting Since there seems to be a running thread here, I'll throw in my 2 cents. Atswebnet runs a great shop and they are the cheapest ISP that I have found (for a single site). You do get what you pay for, though. There isn't (or wasn't) a phone number that you could call them at. They were fairly responsive, but it was not immediate response that many will need. They also lacked some meticulousness. ( The year I had a site with them they never set up the domain alias--I.E. two domains pointing to the same site--despite constant requests ) I use cfdynamics now. They rock. I also like cfxhosting. They have a great staff and some clients use them. At 10:25 PM 4/7/2002 -0500, you wrote: In that case all you have to do is contact them and ask, they will work with you. Clint -Original Message- From: James [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 10:13 PM To: CF-Talk Subject: RE: hosting atswebnet seem pretty cheap.. I always wonder about hosting that only allows 1 Access DSN etc. I like to do a bit of testing on my server so at any time i usually have about 10 DSN's running. At 10:04 PM 4/7/2002 -0500, you wrote: I should actually say that they have the best price period. -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 9:56 PM To: CF-Talk Subject: RE: hosting I am using www.atswebnet.com for my clients. They have the best price if you need SQL Server for your projects. Clint Tredway -Original Message- From: James [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 9:42 PM To: CF-Talk Subject: Re: hosting Hi Heidi, All depends on what you need... If you need cheap and easy shared hosting then www.crystaltech.com is probably a good start, I use them for some small sites I run with Access, never had a problem and they have pretty competitive options and features. Plan 1 @ USD$19.95, you can't go wrong. If you need something with a bit more punch then you should look at someone like www.cfxhosting.com. I have heard some good things about www.dwsgroup.com although I haven't used them before. I guess it comes down to the old saying: You get what you pay for cheers James. At 09:31 AM 4/7/2002 -0700, you wrote: didn't get an replies about web-x.net and i sent them and email and they never replied - doesn't portray a good image so i've looked for another hosting company and have come up with burst.net...anybody got any reviews? Thanks, = Heidi Belal www.code-corner.com ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF doing strange things with dates
why not use cf_cal, not sure about cross browser compatability but it is worth checking it out. you can then make the text box read only to ensure that the user cannot edit the date that is inserted. Is available in the developers gallery at macromedia.com HTH Simon - Original Message - From: Tristram Charnley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 2:14 PM Subject: Re: CF doing strange things with dates Stephen I'd already figured out the list items thing but thanks anyway. I had considered using select boxes but there are quite a few date fields on the form and it would be a bit clunky. It occurred to me that the TwoSelectsRelated tag could also be a good way to ensure correct dates were being passed. Tristram - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 1:50 PM Subject: Re: CF doing strange things with dates Tristram, You're right about all the hashes/pound signs, but the 3 refers to the item in the list rather than the list delimiter i.e.. the year. cfset realdate = createdate(listgetat(userdate,3,-),listgetat(userdate,2,-),listgetat(use rdate,1,-)) Should do the trick. Also you might want to look at the Locale functions to ensure that CF handles your dates correctly. Generally I tend to make sure that users are entering valid dates, by giving them 3 drop downs, one for day, month and year and checking that they haven't entered anything daft like the 31 Feb and make sure that the year is restricted to sensible values (i.e.. Credit Card expiry date has to be in the future) Hope that helps Regards Stephen - Original Message - From: Tristram Charnley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 1:06 PM Subject: Re: CF doing strange things with dates Umm. There are only 2 delimiters in the list and I don't think you need all the # signs Tris - Original Message - From: Jille Floridor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 12:42 PM Subject: RE: CF doing strange things with dates It's probably not the most correct solution, but I use something like this to vaildate European dates: cftry #createdate(#listgetat(#userdate#,3,-)#,#listgetat(#userdate#,2,-)#, #listgetat(#userdate#,1,-)#)# cfcatch blablabla... /ctry There are probably more efficient ways to do this, but this works fine for me. Hope it helps. Jille -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: woensdag 3 april 2002 13:37 To: CF-Talk Subject: CF doing strange things with dates I want users to enter dates in forms using European format dates (dd/mm/yy). But CF is converting dates on or before the 12th of the month to the US format - {d '2002-12-04'} while dates after the 12th are being formatted as European - {d '2002-04-13'} This happens with both CreateODBCDate and CFQUERYPARAM. Unless I'm missing something this makes Eurodate validation pretty pointless... Any suggestions? Tristram Charnley --- [EMAIL PROTECTED] Allaire Certified ColdFusion Developer __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML comments and tag completion
why not se a keyboard shortcut for your cf comment (mine is ctrl shift m) you can change them in the customize box. You won't need to type the comment anymore HTH Simon - Original Message - From: Jeff Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 2:31 PM Subject: HTML comments and tag completion All, Can anyone tell me how to disable the CF Studio tag completion for HTML comments? !-- Every time I try to type in a CF comment ( !--- ) it closes it with a -- before I enter the third -. And although Studio color codes the comment as if it had been closed correctly, CF Server treats the rest of the page like a CF comment. When I check out the Tag Completion section of the Settings in Studio, !-- and !--- are not listed. Any ideas anyone? I don't want to turn off tag completion entirely, just disable it for the !--- and !-- tags. Please CC: [EMAIL PROTECTED] in your response, as I am subscribed to the digest version of this list. Thanks in advance! v/r, Jeff Brown http://www.secret-plans.com/ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
max length of query string and Acive edit
Hello there, I am using Active Edit to create a page - a couple of these have grown to be massive pages. Unfortunately I am now losing the bottom section of the big pages. I have checked in our SQL server 7 dbase and the data type is set to ntext which I believe can hold 2GB of data. Is there a maximum length that Coldfusion can handle being passed to it or should I be looking for another error. (CF 4.5 on NT4). Cheers Simon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle Help
hi there, I have been working on this all day and am still getting errors - I can connect using sqlplus in solaris without problems but cannot connect through cfadministrator - I tried a page to sdee if it would work even though it was failaing connectivity but with no joy. Error code is below: ORA-12154: TNS:could not resolve service name I am not sure what this means but I presume that it is at least seeing Oracle (therefore it is setup correctly). I hope someone can help Cheers Simon - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 12:25 PM Subject: Re: Oracle Help Dumb question, but, are you sure you have the username and password correct in CFAdministrator. Also, do you have something like Oracle DBA Studio or Enterprise Manager that you can connect with? If so, the problem is with your CF Administrator settings. If not, then check the TNSNames.ora file. Also, are you trying to use ODBC or the Native Drivers. If you are using ODBC, be sure and use the Microsoft ODBC for Oracle drivers. Dave - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 11:47 PM Subject: Re: Oracle Help On my CF5/Win2k machine with Oracle 8.0.5 client, my CF administrator says not verified - but the datasource works just fine... I need some help with Oracle - I am not able to connect to my oracle dbase from within cf administrator - it simply gives the not verified message. The trouble is I am not entirely sure what the host string is supposed to look like in the input box - is it dbasename/username@hostname or nothing like the above? I hope someone can help with this. Cheers Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle Help
Hello there, I need some help with Oracle - I am not able to connect to my oracle dbase from within cf administrator - it simply gives the not verified message. The trouble is I am not entirely sure what the host string is supposed to look like in the input box - is it dbasename/username@hostname or nothing like the above? I hope someone can help with this. Cheers Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and Acitve edit
Hello there, Is it possible to use cf tags within active edit - I would like to be able to declare a variable within my application page (ie full path to file/image) which is then output into the page in the normal way. I hope you can help Simon ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Acitve edit
Gary, Cheers for the reply - I should have explained myself more clearly - what I am after is to be able to use it within the template ie. for images , instead of having a full path http://www.mysite.com/images/image.jpg I could do this: cfset pathtoimages = http://www.mysite.com/images; And within the output of the page would be this. #pathtoimages#/image.jpg I hope I have made myself clearer. I guess what I am trying to ask is whether the pages that are creatdd in active edit are run through the CFML parser or straight through the web server to the browser Cheers Simon - Original Message - From: Gary Kraeger [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 1:55 PM Subject: Re: CF and Acitve edit Sure you can here is the code This is in my application.cfm cfset application.imgurl = 'http://activemail.netdesign1.com/customers' cfset application.imgpath = 'd:\activemail.netdesign1.com\www\web\customers' Then I pull the session.directory when they log in so every customer has a different directory cf_activedit name=template width=700 height=500 tabview=1 inc=../activedit/inc/ upload=1 imageurl=#application.imgurl#/#session.directory# imagepath=#application.imgpath#\#session.directory# toolbar=cut,copy,paste,|,redo,undo,|,font,bold,italic,underline,|,outdent,i ndent,|,justifyleft,justifycenter,justifyright,bullets,|,table,image,hyperli nk,|,find,help,spellcheck,specialchars,||,quickformat,quickfontsize,quickfon t, cfoutput#data.template#/cfoutput/cf_activedit Gary CFDEV.com http://www.cfdev.com - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 7:12 AM Subject: CF and Acitve edit Hello there, Is it possible to use cf tags within active edit - I would like to be able to declare a variable within my application page (ie full path to file/image) which is then output into the page in the normal way. I hope you can help Simon ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Acitve edit
Thanks everyone - I'll see what I can come up with Cheers Simon - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 2:17 PM Subject: Re: CF and Acitve edit Unfortunately not. Activedit writes fully qualified domain names and paths to images etc. inserted into the body text. If you want to change these later, then you'll have to do a search and replace for the image paths in the body text. Regards Stephen - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 2:00 PM Subject: Re: CF and Acitve edit Gary, Cheers for the reply - I should have explained myself more clearly - what I am after is to be able to use it within the template ie. for images , instead of having a full path http://www.mysite.com/images/image.jpg I could do this: cfset pathtoimages = http://www.mysite.com/images; And within the output of the page would be this. #pathtoimages#/image.jpg I hope I have made myself clearer. I guess what I am trying to ask is whether the pages that are creatdd in active edit are run through the CFML parser or straight through the web server to the browser Cheers Simon - Original Message - From: Gary Kraeger [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 1:55 PM Subject: Re: CF and Acitve edit Sure you can here is the code This is in my application.cfm cfset application.imgurl = 'http://activemail.netdesign1.com/customers' cfset application.imgpath = 'd:\activemail.netdesign1.com\www\web\customers' Then I pull the session.directory when they log in so every customer has a different directory cf_activedit name=template width=700 height=500 tabview=1 inc=../activedit/inc/ upload=1 imageurl=#application.imgurl#/#session.directory# imagepath=#application.imgpath#\#session.directory# toolbar=cut,copy,paste,|,redo,undo,|,font,bold,italic,underline,|,outdent,i ndent,|,justifyleft,justifycenter,justifyright,bullets,|,table,image,hyperli nk,|,find,help,spellcheck,specialchars,||,quickformat,quickfontsize,quickfon t, cfoutput#data.template#/cfoutput/cf_activedit Gary CFDEV.com http://www.cfdev.com - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 7:12 AM Subject: CF and Acitve edit Hello there, Is it possible to use cf tags within active edit - I would like to be able to declare a variable within my application page (ie full path to file/image) which is then output into the page in the normal way. I hope you can help Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Acitve edit
Thats exactly right - I have a site which has 2 different urls but which have to be identical (bizarre I know, don't ask!). I would like to be able to globally set the file path and the url in the application page. Is it even possible? Cheers simon - Original Message - From: Gary Kraeger [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 2:43 PM Subject: Re: CF and Acitve edit Simon: So what your saying is you don't want AE to do the full path you want to do that on the front end. gary cfdev.com - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 9:00 AM Subject: Re: CF and Acitve edit Gary, Cheers for the reply - I should have explained myself more clearly - what I am after is to be able to use it within the template ie. for images , instead of having a full path http://www.mysite.com/images/image.jpg I could do this: cfset pathtoimages = http://www.mysite.com/images; And within the output of the page would be this. #pathtoimages#/image.jpg I hope I have made myself clearer. I guess what I am trying to ask is whether the pages that are creatdd in active edit are run through the CFML parser or straight through the web server to the browser Cheers Simon - Original Message - From: Gary Kraeger [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 1:55 PM Subject: Re: CF and Acitve edit Sure you can here is the code This is in my application.cfm cfset application.imgurl = 'http://activemail.netdesign1.com/customers' cfset application.imgpath = 'd:\activemail.netdesign1.com\www\web\customers' Then I pull the session.directory when they log in so every customer has a different directory cf_activedit name=template width=700 height=500 tabview=1 inc=../activedit/inc/ upload=1 imageurl=#application.imgurl#/#session.directory# imagepath=#application.imgpath#\#session.directory# toolbar=cut,copy,paste,|,redo,undo,|,font,bold,italic,underline,|,outdent,i ndent,|,justifyleft,justifycenter,justifyright,bullets,|,table,image,hyperli nk,|,find,help,spellcheck,specialchars,||,quickformat,quickfontsize,quickfon t, cfoutput#data.template#/cfoutput/cf_activedit Gary CFDEV.com http://www.cfdev.com - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 26, 2001 7:12 AM Subject: CF and Acitve edit Hello there, Is it possible to use cf tags within active edit - I would like to be able to declare a variable within my application page (ie full path to file/image) which is then output into the page in the normal way. I hope you can help Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle and CF
hello there, I am having some trouble connecting ColdFusion to an Oracle Datasource on a different machine. It seems that we may be missing a driver somewhere along the line but am not exactly sure what to do next - does anyone have any advice? Also, what are the major differences between Oracle and MSSQL server 7. Will I need to make any coding changes or should everything be okay. And one final thing, how difficult is it to link into Oracle from SQL? Some Basic Questions I know but Oracle is not my strong point. I hope you can help Best Regards Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfflush equivalent
Hello there, Does anyone know of a cfflush equivalent (eg custom tag)which would work within CF4.5. I have a very large page which cannot be cached as it is an action page which changes continuously. What I would like to be able to do is spit information out as it is processed instead of waiting for the page to finish processing. Many Thanks Simon ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Last Updated Date
Cheers Howard and John, Unfortunately the option of having a seperate column or even a seperate table is not really availablt - is there anyway of obtaining the last modified date of a dbase or even any file? Cheers Simon - Original Message - From: John Paitel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 01, 2001 6:28 PM Subject: RE: Last Updated Date You can create a column in your table called DATE_MODIFIED and update that with the current date each time the row is updated, then retrieve that date when displaying that record. I believe he wanted to see if it was possible without using another field. John Is it possible (without a seperate field/table) to obtain a last updated date/time for an Access 2000 or SQL database and then display it on a page? It would also be brilliant to obtain a last updated date/time for a paticular record but I realise that this is less likely. I hope you can help, Cheers Simon ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Last Updated Date
Thanks for your help - unfortunately - I am getting the following error when I try the code - do I have to change anything in CfAdministrator? Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'sysobjects'. Make sure it exists and that its name is spelled correctly. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:54). Date/Time: 10/02/01 13:43:51 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; poing!; Poing! Guest) Remote Address: 62.190.52.254 Cheers Simon - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 1:05 PM Subject: RE: Last Updated Date select refdate from sysobjects where name = 'TABLE NAME' Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 4:08 AM To: CF-Talk Subject: Re: Last Updated Date Cheers Howard and John, Unfortunately the option of having a seperate column or even a seperate table is not really availablt - is there anyway of obtaining the last modified date of a dbase or even any file? Cheers Simon - Original Message - From: John Paitel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 01, 2001 6:28 PM Subject: RE: Last Updated Date You can create a column in your table called DATE_MODIFIED and update that with the current date each time the row is updated, then retrieve that date when displaying that record. I believe he wanted to see if it was possible without using another field. John Is it possible (without a seperate field/table) to obtain a last updated date/time for an Access 2000 or SQL database and then display it on a page? It would also be brilliant to obtain a last updated date/time for a paticular record but I realise that this is less likely. I hope you can help, Cheers Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Last Updated Date
Hello There, Is it possible (without a seperate field/table) to obtain a last updated date/time for an Access 2000 or SQL database and then display it on a page? It would also be brilliant to obtain a last updated date/time for a paticular record but I realise that this is less likely. I hope you can help, Cheers Simon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: CF + Generator
I am under the impression that you can use CF pages to create dynamic flash pages with Generator. Does anyone know more details about this or have examples that I could look through? Cheers Simon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: creating excel file in the REQUESTED format
Hi there, I have used HTML2Excel which I got from http://www.coldfusionnet.com - works very well and is easy to setup. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. Cheers Simon - Original Message - From: BEN MORRIS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 5:02 PM Subject: Re: creating excel file in the REQUESTED format My experience w/ option 2: don't do it. I made a tag myself that looped through query.fieldnames and it was extremely slow. It worked fine with a few hundred records, but getting into 1500 records pretty much rendered it useless, I got memory errors and it took forever to process. Even doing a simple loop with hard coded field names takes upwards of 60 seconds to make a csv with 7000 records (about 20 fields of contact/membership information). The execution time is acceptable for files with 1500 or so records in my case. If anyone knows of a better way to make CSV, I am all ears... maybe a CFX tag would execute faster. My instinct is to make a scheduled task to create all of the csv files I might need (over 1000 files), but I am afraid that would take too long to execute too. - Ben Morris Critter [EMAIL PROTECTED] 08/29/01 11:25AM Hello Deanna, Option 1. there is a tag in the gallery that will output to a csv file, it has some errors in it, so those will need to be fixedbut other than that it works ok. Option 2. you could just loop thru the data, output the query.fieldnames, then loop thru the recordset and build your file.and push it with cfcontent if you want Option 1 - most of the work done for you.. Option 2 - opposite of option 1. -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Wednesday, August 29, 2001, 11:26:12 AM, you wrote: DS Hi Folks, DS I have a query that pulls data on various items for about 72 counties, DS quarterly for the last five years. I'm creating a downloadable excel file, DS and the client has requested that the data be presented like so: DS INDICATOR COUNTYNAME1, COUNTYNAME2, COUNTYNAME3 DS fs1 (date)valuevalue DS value DS fs1 (anotherdate)valuevalue DS value DS I think I must be braindead today, cause I can't figure out how in the heck DS I would get the data to layout like this without doing lots and lots of DS hardcoding. Here's the query that pulls all the data, if that's any help. DS cfquery name=getfs password=#pword# username=#uname# datasource=#dsn# DS SELECT f.item, c.name AS county, d.total, d.datecollected DS FROM flpweb.cfs_foodstampdata d, flpweb.cfs_foodstamp f, flpweb.cfs_county c DS WHERE c.countyid = d.countyid DS AND d.foodstampid = f.foodstampid DS ORDER BY c.name, f.item, d.datecollected DS /cfquery DS Deanna Schneider DS Interactive Media Developer DS [EMAIL PROTECTED] DS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: creating excel file in the REQUESTED format
Hello Again, Have just been told to have another look at th esite I mentioned in my email and it is no longer a custom tag download page - but have a look anyway, its quite amusing. Instead go to the devcenter and search for HTML2Excel or try this one http://devex.allaire.com/developer/gallery/info.cfm?ID=82442819-BA47-11D4-83 E400508B94F85Amethod=Full Cheers Simon - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 5:15 PM Subject: Re: creating excel file in the REQUESTED format Hi there, I have used HTML2Excel which I got from http://www.coldfusionnet.com - works very well and is easy to setup. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. Cheers Simon - Original Message - From: BEN MORRIS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 5:02 PM Subject: Re: creating excel file in the REQUESTED format My experience w/ option 2: don't do it. I made a tag myself that looped through query.fieldnames and it was extremely slow. It worked fine with a few hundred records, but getting into 1500 records pretty much rendered it useless, I got memory errors and it took forever to process. Even doing a simple loop with hard coded field names takes upwards of 60 seconds to make a csv with 7000 records (about 20 fields of contact/membership information). The execution time is acceptable for files with 1500 or so records in my case. If anyone knows of a better way to make CSV, I am all ears... maybe a CFX tag would execute faster. My instinct is to make a scheduled task to create all of the csv files I might need (over 1000 files), but I am afraid that would take too long to execute too. - Ben Morris Critter [EMAIL PROTECTED] 08/29/01 11:25AM Hello Deanna, Option 1. there is a tag in the gallery that will output to a csv file, it has some errors in it, so those will need to be fixedbut other than that it works ok. Option 2. you could just loop thru the data, output the query.fieldnames, then loop thru the recordset and build your file.and push it with cfcontent if you want Option 1 - most of the work done for you.. Option 2 - opposite of option 1. -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Wednesday, August 29, 2001, 11:26:12 AM, you wrote: DS Hi Folks, DS I have a query that pulls data on various items for about 72 counties, DS quarterly for the last five years. I'm creating a downloadable excel file, DS and the client has requested that the data be presented like so: DS INDICATOR COUNTYNAME1, COUNTYNAME2, COUNTYNAME3 DS fs1 (date)valuevalue DS value DS fs1 (anotherdate)valuevalue DS value DS I think I must be braindead today, cause I can't figure out how in the heck DS I would get the data to layout like this without doing lots and lots of DS hardcoding. Here's the query that pulls all the data, if that's any help. DS cfquery name=getfs password=#pword# username=#uname# datasource=#dsn# DS SELECT f.item, c.name AS county, d.total, d.datecollected DS FROM flpweb.cfs_foodstampdata d, flpweb.cfs_foodstamp f, flpweb.cfs_county c DS WHERE c.countyid = d.countyid DS AND d.foodstampid = f.foodstampid DS ORDER BY c.name, f.item, d.datecollected DS /cfquery DS Deanna Schneider DS Interactive Media Developer DS [EMAIL PROTECTED] DS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFML-PDF
I would like to convert a CFML template to a PDF file on the fly - this includes images. Does anyone have any tips on how to acheive this? Cheers Simon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm an idiot...
From the FAQ at FAQ: http://www.thenetprofits.co.uk/coldfusion/faq I've forgotten the ColdFusion Administrator password. What can I do? Run regedit and go to to HKLM\Software\Allaire\ColdFusion\CurrentVersion\Server Change UseAdminPassword from 1 to 0. This will allow you to get into your ColdFusion Administrator without being asked for a password. Remember to turn on password protection from the Administrator once you get in and change the password. Cheers Simon -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: 07 August 2001 15:41 To: CF-Talk Subject: I'm an idiot... Say, hypothetically, I had lost the password to the Cold Fusion Administrator for cf4.5 on my win2k machine. Anybody have any ideas where, *hypothetically* I might find the password in the registry or something? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CodeCharge editor - anybody have experience with this?
I have used it briefly - It is a very good tool for creating quite complex projects as a beginner although anything out of the ordinary poses a problem. It is also very useful for converting projects (created in codecharge) into another language (ie PHP-CFML). In my recollection It is difficult, if at all possible, to access the code until after the project is finished and even then it is maybe less than perfect. All in all a good tool for the beginner but it ends up easier coding it yourself if you know cfml. Cheers Simon -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED]] Sent: 06 August 2001 14:58 To: CF-Talk Subject: CodeCharge editor - anybody have experience with this? Just wondering if anyone on this list has tried this editor and, if so, what your experiences have been with it. http://www.codecharge.com/index2.html Regards, Stephen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail - caveats?
hi there, The FAQ at http://www.thenetprofits.co.uk/coldfusion/faq/#answer189 has details all about the limitations of CFMail. I have copied it below for you. The highest throughput you can get is 400 emails per minute, based on the fact that the CF server spools 100 every 15 seconds to the mail server. That's if you increase the spool setting from the default of 60 seconds from the Administrator. Also, there is a 65,535 message limit, based on the spool file naming convention. It appears that the files stored in the Spool directory are named using a hex naming convention of .cfmail to .cfmail. When we recently sent more mails than the spool directory can handle (65535) the page crashed. Cheers Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 05 August 2001 01:53 To: CF-Talk Subject: Re: CFMail - caveats? Try CFX_iiPOP3 http://iistore.infranet.com ~.net³ - Original Message - From: Mike Amburn [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 18:15 Subject: CFMail - caveats? i've read several suggestions not to use CFMAIL for sending a lot of mail. so, exactly what can and can't CFMAIL handle? is there a general load limit that should be understood? are there any limitations (size of the mail, number of addresses, etc)? who's got a 411 on CFMAIL? =) -mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists