Re: CFMX application/session error
Post the rest from the log ? Allright, here goes. 04/12 13:56:13 error Exception occurred invoking custom error page /WEB-INF/exception/java/lang/Exception.cfm java.lang.IllegalArgumentException: err.io.short_read at coldfusion.filter.FormScope.parsePostData(Unknown Source) at coldfusion.filter.FormScope.fillForm(Unknown Source) at coldfusion.filter.FusionContext.SymTab_initForRequest(Unknown Source) at coldfusion.filter.GlobalsFilter.initializeSymbolTableAndPageContextForRequest(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:414) at jrun.servlet.JRunRequestDispatcher.include(JRunRequestDispatcher.java:348) at jrun.servlet.JRunResponse.sendErrorPage(JRunResponse.java:660) at jrun.servlet.JRunResponse.sendError(JRunResponse.java:505) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:272) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) 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) 04/12 13:56:13 error java.lang.NullPointerException at coldfusion.runtime.NeoPageContext.searchScopes(Unknown Source) at coldfusion.runtime.NeoPageContext.SymTab_findSimpleName(Unknown Source) at coldfusion.runtime.NeoPageContext.SymTab_getMapFromSimpleValidName(Unknown Source) at coldfusion.runtime.NeoPageContext.SymTab_setValidatedSplitNameInString(Unknown Source) at coldfusion.runtime.NeoPageContext.SymTab_setValidatedDottedName(Unknown Source) at coldfusion.runtime.NeoPageContext.setValidatedAttribute(Unknown Source) at coldfusion.runtime.NeoPageContext.setAttribute(Unknown Source) at coldfusion.runtime.CookieHelper.Store(Unknown Source) at coldfusion.runtime.ClientScopeServiceImpl.PersistClientVariables(Unknown Source) at coldfusion.runtime.ClientScope.commitChanges(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) 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) -- I found this line in the default-err.log. 04/12 13:56:13 error Exception occurred invoking custom error page /WEB-INF/exception/java/lang/Exception.cfm java.lang.IllegalArgumentException: err.io.short_read which in turn is followed by a bunch of info that really don't make any sense for me, I'm sad to say. Post the rest from the log ? WG ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Known MX bug or have I found one? URL.threadID in CFLOCATION
I'm in the unenviable position of trying to get the forum system from www.stickshiftsolutions.com to work on MX. (It's for my brother's racing site, www.grapeaperacing.com). I'm not pleased with it (many bugs, some outright omissions and really poor, I think, code). However the thing that I just struggled with doesn't seem to be the fault of the author. There's a CFLOCATION formatted as: cflocation url=thread.cfm?tID=#Form.threadID#forumID=#URL.forumID#confID=#url.co nfID# addtoken=No Which results in something like: http://www.grapeaperacing.com/GrapeApeRacing/OpenForums/thread.cfm?threa dId=165forumID=21confID=1 The weird thing is that this link produces a completely blank page - as if the browser was never given a response (you can't éven view source - it's just nothing). I tried passing the parameter with no variables (just copy/paste the actual URL) and this completely fails in the same way. However if you remove the threadID parameter the Cflocation works (you get an error, but at least you get something!) Add it in, blank page, remove it - error page (correct). Again this was even with a hardcoded value and even if the parameter was alone on the line. It happens only with a CFLOCATION. Now for the fun part. Take ANY CFLOCATION and add threadID=1 (or any number) to it and it seems to have the same behavior. I've tried this on the two MX servers that I have and both showed the same behavior. It doesn't exhibit the behavior on 4.5. Is this old news? By the way. What I did to fix this was change the param to TID and add the following line of code in the page: cfif IsDefined(URL.TID)cfset URL.threadID = URL.TID/cfif Not pretty but it works and means that I don't have rewrite any more of this app. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Known MX bug or have I found one? URL.threadID in CFLOCATION
On Thursday, Dec 5, 2002, at 00:17 US/Pacific, Jim Davis wrote: http://www.grapeaperacing.com/GrapeApeRacing/OpenForums/ thread.cfm?threa dId=165forumID=21confID=1 The weird thing is that this link produces a completely blank page - as if the browser was never given a response (you can't Èven view source - it's just nothing). I tried this URL and it works just fine (Mac IE 5.2.2). Identical behavior with tID= instead of threadId= Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Known MX bug or have I found one? URL.threadID in CFLOCATION
Thanks for the test. The pasted threadID link worked some of the time, but the tID should always work (thats the fix). But put the threadID in any CFLOCATION on an MX server and (I hope!) you'll see what I mean. Jim Davis -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:28 AM To: CF-Talk Subject: Re: Known MX bug or have I found one? URL.threadID in CFLOCATION On Thursday, Dec 5, 2002, at 00:17 US/Pacific, Jim Davis wrote: http://www.grapeaperacing.com/GrapeApeRacing/OpenForums/ thread.cfm?threa dId=165forumID=21confID=1 The weird thing is that this link produces a completely blank page - as if the browser was never given a response (you can't Èven view source - it's just nothing). I tried this URL and it works just fine (Mac IE 5.2.2). Identical behavior with tID= instead of threadId= Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| 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
Re: Please help me achieve this with CF and Coldfusion please
Hi Bob Thanks that would be great if you could show me an example if I could see an example. Was your code generated from your database table like the one at webtricks? The three related selects I have used and although very good, I would rather use this approach as only one table can be used where in the three selects related related you need 3 tables to populate each select. Also you get a lot of unnecessary JavaScript in the final code as you may not be using all of the features. - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and Secondary Breed (select 3). Let me know if you're interested in that type of code. --- Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Lists vs. Arrays vs. Structures
isn't structkeyexists better than structfindvalue? as our jedi friend says, after not evalutating, cflocking I think that's his next biggest tip It's better if you just want to know if the value exists. I need to know where it exists. my experience is that structures are always *way* faster than lists or arrays.. basically because structures are key indexed Do you have any code to show this? I'm not seeing *way* faster. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: On the whole, unless you see a need to, I'd stick with using lists in CFMX. I have heard of people who have seen some major slowdowns due to lists and I'd love to hear the specifics. Anything that changes a long list (or string for that matter) is slow. It is really related to changes, all the search functions are fast. Jochem ~| 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
Re: Prevent include from caching?
Matt Kornguth wrote: Is it possible to prevent an included template from caching without preventing the parent template from caching? If you are talking client side caching: no, they are one request. Server side you can do anything you want. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Lists vs. Arrays vs. Structures
Thanks for the note. I'll test list sorting and the like next. Michael Dinowitz wrote: On the whole, unless you see a need to, I'd stick with using lists in CFMX. I have heard of people who have seen some major slowdowns due to lists and I'd love to hear the specifics. Anything that changes a long list (or string for that matter) is slow. It is really related to changes, all the search functions are fast. Jochem ~| 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
Is Cold Fusion REALLY multi threaded?
Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 --
RE: Is Cold Fusion REALLY multi threaded?
Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 10:15 To: CF-Talk Subject: Is Cold Fusion REALLY multi threaded? Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Is Cold Fusion REALLY multi threaded?
Stephen Richards wrote: For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? For the datasource, what do you have for Limit simultaneous connections and what is your CF setting for simultaneous requests? Jochem ~| 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
Re: Flash MX mailing list
flashcfm.com was before devmx.com and a good source - same guys I believe. Probably so far the most dedicated to coldfusion and flash - not many others out there that address coldfusion specifically - jay miller Stacy Young wrote: http://www.devmx.com http://www.devmx.com is a good place to start... -Original Message- From: Steve Drucker [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Wednesday, December 04, 2002 11:27 AM To: CF-Talk Subject: RE: Flash MX mailing list The closest equivalent would be FLASHCODERS and/or FLASHNEWBIES available at http://chattyfig.figleaf.com http://chattyfig.figleaf.com Regards, Steve Drucker CEO Fig Leaf Software w. www.figleaf.com http://www.figleaf.com p. (877) FIG-LEAF -Original Message- From: S. Isaac Dealey [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Friday, November 08, 2002 10:54 AM To: CF-Talk Subject: OT: Flash MX mailing list Does anybody know of a Flash equivalent of the cf-talk list? Isaac Dealey Certified Advanced ColdFusion 5 Developer new epoch www.turnkey.to http://www.turnkey.to 954-776-0046 ~| 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
RE: Lists vs. Arrays vs. Structures
isn't structkeyexists better than structfindvalue? as our jedi friend says, after not evalutating, cflocking I think that's his next biggest tip It's better if you just want to know if the value exists. I need to know where it exists. Michael is correct here. StructFindValue allows you to search into inside an arbitrarily deep structure and find a value. It and it's cousin, StructFindKey, or functions that are pretty powerful, but I almost never see anyone use. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: init and destroy
While the methods you mention are page specific, I think you can accomplish what you want by using Application variables. Ie: (and this is non-locked mx code) cfif not isDefined(application.foo) cfset application.foo = Bantha Fodder /cfif However - there is no way to catch the expiration of the application scope, and as I said, what you want is page specific, and this value is application wide. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:21 PM To: CF-Talk Subject: init and destroy All JSP pages (or the servlets they compile into) have a jspInit() and a jspDestroy() function. jspInit() is guaranteed to only run once, so it's a nice place to put code that you do not want executed with every request, and jspDestroy() is called when the servlet engine is shut down just before the object is garbage collected. Does anyone know how to override jspInit() and jspDestroy() in ColdFusion MX, or how to accomplish the same thing another way? If there is no native way, I will probably write a cf_init custom tag. Thanks, Cantrell ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Verity size constraint?
Check the archives for post about indexing database queries with Verity. A couple people have run into some sort of nebulous limitation with it where it will not index past a certain amount of records. Sometimes this limit is 5,000sometimes its 10,000it fluctuates. In short, there's something wrong with Verity on CF. Someone from this list has a tech support ticket open on the problem, but I don't believe they've gotten a response yet. -Gel -Original Message- From: Jennifer Perkins [mailto:[EMAIL PROTECTED]] Verity is really pissing me off. Does anyone know if there's some kind of size limit on verity collections? Obviously it can't be bigger than the size available on the server, but other than that, is there some sort of constraint? It's making me crazy. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
MX Server installs and Microsoft Security Toolkits
Microsoft provides a whole bunch of Security Toolkits to help lock down a server. For example there is the Microsoft Baseline Security Analyzer. Some of these tools blindly goes in and locks down a bunch of stuff that you are not aware of. Has anyone had problems running CFMX after applying security patches to Windows servers running IIS? As for anything involving security, it is a matter of degree. How much can you lock down a box before CFMX stops working? If anyone has any white papers or other documentation on this subject, it would be appreciated. I noticed in the Security Section of the Macromedia that the white papers that still have the Allaire Logo stamped on them with dates such as 2001. Hope Macromedia is a little more serious about security than this. It does not help the CF cause. Dave Adams CFUG Ottawa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MX Server installs and Microsoft Security Toolkits
No, as I *never* use the out of the box lockdown tools, I will always follow the manual instructions... sorry, -Original Message- From: David Adams [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 13:51 To: CF-Talk Subject: MX Server installs and Microsoft Security Toolkits Microsoft provides a whole bunch of Security Toolkits to help lock down a server. For example there is the Microsoft Baseline Security Analyzer. Some of these tools blindly goes in and locks down a bunch of stuff that you are not aware of. Has anyone had problems running CFMX after applying security patches to Windows servers running IIS? As for anything involving security, it is a matter of degree. How much can you lock down a box before CFMX stops working? If anyone has any white papers or other documentation on this subject, it would be appreciated. I noticed in the Security Section of the Macromedia that the white papers that still have the Allaire Logo stamped on them with dates such as 2001. Hope Macromedia is a little more serious about security than this. It does not help the CF cause. Dave Adams CFUG Ottawa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Please help me achieve this with CF and Javascrip please
Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and Secondary Breed (select 3). Let me know if you're interested in that type of code. --- Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Please help me achieve this with CF and Javascrip please
It really shouldn't be difficult at all... what problems are you running into? have you got some semi-working code at all? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 14:08 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and Secondary Breed (select 3). Let me know if you're interested in that type of code. --- Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Is Cold Fusion REALLY multi Threaded?
Date: Thu, 05 Dec 2002 11:41:28 +0100 From: Jochem van Dieten [EMAIL PROTECTED] Subject: Re: Is Cold Fusion REALLY multi threaded? Message-ID: [EMAIL PROTECTED] Stephen Richards wrote: For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? For the datasource, what do you have for Limit simultaneous connections and what is your CF setting for simultaneous requests? Jochem Limit connections is not checked, however the value is 0. SR
Follow-up on the one-site for many businesses discussion
Not sure I'm totally understanding problem, but sounds like you may be trying to use some settings that apply to all the *sites*, such as for a parent business. Since you are defining application as unique to each site, don't think you can mix parent and child in application variables. In this dynamically-set application, all is tied to the BusinessID. To accomplish what I think you're trying to do, I'd suggest you include your *common* variables as part of the application. In a similar situation, I do the followinig: 1. Have a script on application.cfm to get the appropriate BusinessID. 2. Run a series of queries and/or other routines to set up an application structure for site settings. This can include some portions that are global (will be same for all sites under this parent app) and some/most that will be unique to the called site. (I've not done this, but guess you could have a couple levels: application.stSettings.Global and application.stSettings.Specific, such as application.stSettings.Global.InfoEmail; application.stSettings.Specific.BusEmail) (I even cache some of the larger queries so the routine is faster the few times it is needed.) 3. In application.cfm, if the application.stSettings exists and is a structure, duplicate the application.stSettings into request scope. If not, run the earlier #2 routine and duplicate to request scope. 4. All the queries in establishing the settings structure most likely will only be run once. After that, since the application structure does exist, what is run with each page call--I think--is just the duplication of that app structure to request. 5. Note: need a method that will rerun the template that sets the application structure anytime you change any of the global or site-specific information, so that app structure is always current. 6. Now all your settings variables are available on any page, called through the request.stSettings sturcture. For info on how this site works, contact #request.stSettings.Global.InfoEmail# Contact MyBusiness at #request.stSettings.Specific.BusEmail# I've tried to extrapolate what I've done in something similar to what I think you're trying to do. Don't know that all is totally correct, but should get you on a workable road. As with most such things, there are probably several ways to accomplish the goal. I guess you could have two structures: one that is for the global stuff and one for the unique, but the global would still have to be tied to the specific site application. application/request.stGlobSets and application/request.stSpecificSets. Then on output you just call whichever applies. Seems though that makes sense just to make them all part of one settings structure. Hope this helps Keith ~| 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
RE: Is Cold Fusion REALLY multi threaded?
Date: Thu, 5 Dec 2002 10:25:39 - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Subject: RE: Is Cold Fusion REALLY multi threaded? Message-ID: AFDBA0DE939BD41195290008C7A448A96234EE@RECCSDEXC2 Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil Good spec: dual P3 1.2 GHz processeor, 1 GByte RAM, loads of RAID disk - Stephen Richards 020 7903 3226 --
Re: MX Server installs and Microsoft Security Toolkits
David Adams wrote: I noticed in the Security Section of the Macromedia that the white papers that still have the Allaire Logo stamped on them with dates such as 2001. Hope Macromedia is a little more serious about security than this. It does not help the CF cause. Security is a matter of mindset and procedures. Neither has changed with the arrival of CF MX. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Is Cold Fusion REALLY multi Threaded?
Stephen Richards wrote: Limit connections is not checked, however the value is 0. OK, next step is to check the number of database connections you actually have. Easiest is if you are only using one datasource on that particular server, just run a netstat and check the number of TCP connections to port 5423. Else, start working from the database side, use the standard tools to determine the number of backends and their status. Alsomake sure you are not running with a default transaction level of serializable, which would make all transactions run pretty much after eachother. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
cfmx and FORM file oddity
I am using something relative to the following code: form action=blahblahblah.cfm method=post enctype=multipart/form-data input type=File name=uploadedFileNamebr input type=Submit value=Upload Now /form During the process, I am attempting to catch the variable uploadedFileName, but instead of getting a file name like myfilename.zip or whatever, I get something like: R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1 6991.tmp Being that neotmp16991.tmp is not the file name and is really something like myfilename.zip, how do I get that actual file name as opposed to what is seen above. -//- Jaye Morris - Multimedia Developer -//- [EMAIL PROTECTED] - www.navtrak.net -//- [EMAIL PROTECTED] - www.jayezero.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Please help me achieve this with CF and Javascrip please
Which situation do you want? 1) Select A choice affects Select B choices Select B choice affects Select C choices (C depends on B depends on A) Or 2) Select A choice affects Select B choices and Select A choice affects Select C choices as well (C and B both depend on A) Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:08 AM To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and Secondary Breed (select 3). Let me know if you're interested in that type of code. --- Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: cfmx and FORM file oddity
How are you getting this ? R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1 6991.tmp This looks like the tmp file created before cffile action=upload Show us your blahblahblah.cfm template WG ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFX_Image - Quality of images not good when rotating
Man, this is the never-ending, and ever-recurring, thread...but I have to try and ask a summarizing question, because after all these posts and replies I still don't have a solution to my personal problems. The perfect tag/function I'm looking for needs to be able to: 1) Get dimensions from an image (Height, Width, Size, etc.) 2) Be able to resize a GIF or JPEG with (almost) the same quality as PhotoShop 3) Plug and play ability with no need to configure anything in CF Administrator (So a Java JAR would probably be best) 4) Adding text or a watermark would be icing on the cake, but not necessary And that's about it. The closest I'm come is ImageJ (http://rsb.info.nih.gov/ij/) using some of www.benorama.com implementations along with some edits. I can just place the JAR file in the same directory and access it there, but the quality on JPEGs is not so good. This really should be a feature of *Macromedia's* ColdFusion already, I've been pleading for the latest two versions now- Tyler Silcox email | [EMAIL PROTECTED] website | www.gslsolutions.com - Original Message - From: jon roig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 12:06 AM Subject: RE: CFX_Image - Quality of images not good when rotating Kind of interesting -- somebody sat down and wrote a custom tag to manipulate imagemagick. http://www.alagad.com/index.cfm/name-mtinfo -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 7:27 PM To: CF-Talk Subject: Re: CFX_Image - Quality of images not good when rotating Awesome idea...one slight problem, where's the link to download it? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: isn't structkeyexists better than structfindvalue? as our jedi friend says, after not evalutating, cflocking I think that's his next biggest tip It's better if you just want to know if the value exists. I need to know where it exists. my experience is that structures are always *way* faster than lists or arrays.. basically because structures are key indexed Do you have any code to show this? I'm not seeing *way* faster. ok, it depends on what we are talking about, I would usually use a single depth structure, ie kinda of denormalising the data structure... to provide an indexing function, that returns references, know what i mean? structfindvalue isn't going to be using hashing in cf is it? ie a full table scan... my approach is only to work via struct keys, as they are hash indexed anyway, throw some of your code up and we can explore the ideas... z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Please help me achieve this with CF and Javascrip please
Hi I think you will find it is more difficult then you may think... I am using the sample code from webtricks.com. Their default is two selects - what I need to find out is where to add javascript and coldfusion to build arrays for the third select box This is the actual code for two selects, need to find out how to build in the extra logic to get three selects working on the same approach as below? This is where I am having trouble and would appreciate some help please script language = JavaScript !-- // For each state, create an array to hold the area codes. // Each state array will be identified by the two-character state abbreviation cfoutput query=GetStates group=State // Create the array StateArray#StateCode# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 StateArray#StateCode#[#i#] = #AreaCode#; /cfoutput /cfoutput // Function to populate the area codes for the state selected function PopulateAreaCode() { // Only process the function if the first item is not selected. if (document.StateForm.StateCode.selectedIndex != 0) { // Find the state abbreviation var ThisState = document.StateForm.StateCode[document.StateForm.StateCode.selectedIndex].val ue; // Set the length of the arecode drop down equal to the length of the state's array document.StateForm.AreaCode.length = eval(StateArray + ThisState + .length); // Put 'Select' as the first option in the area code drop-down document.StateForm.AreaCode[0].value = ; document.StateForm.AreaCode[0].text = Select; document.StateForm.AreaCode[0].selected = true; // Loop through the state's array and populate the area code drop down. for (i=1; ieval(StateArray + ThisState + .length); i++) { document.StateForm.AreaCode[i].value = eval(StateArray + ThisState + [i]); document.StateForm.AreaCode[i].text = eval(StateArray + ThisState + [i]); } } } //-- /script - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 2:08 PM Subject: RE: Please help me achieve this with CF and Javascrip please It really shouldn't be difficult at all... what problems are you running into? have you got some semi-working code at all? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 14:08 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and Secondary Breed (select 3). Let me know if you're interested in that type of code. --- Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Please help me achieve this with CF and Javascrip please
I posted a link to the Three Selects Related tag. It does the same thing that you are looking for. Perhaps you might try downloading it and reading through the code of the tag to find the answer to your question. Hatton Ian Vaughan wrote: Hi I think you will find it is more difficult then you may think... I am using the sample code from webtricks.com. Their default is two selects - what I need to find out is where to add javascript and coldfusion to build arrays for the third select box This is the actual code for two selects, need to find out how to build in the extra logic to get three selects working on the same approach as below? This is where I am having trouble and would appreciate some help please script language = JavaScript !-- // For each state, create an array to hold the area codes. // Each state array will be identified by the two-character state abbreviation cfoutput query=GetStates group=State // Create the array StateArray#StateCode# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 StateArray#StateCode#[#i#] = #AreaCode#; /cfoutput /cfoutput // Function to populate the area codes for the state selected function PopulateAreaCode() { // Only process the function if the first item is not selected. if (document.StateForm.StateCode.selectedIndex != 0) { // Find the state abbreviation var ThisState = document.StateForm.StateCode[document.StateForm.StateCode.selectedIndex].val ue; // Set the length of the arecode drop down equal to the length of the state's array document.StateForm.AreaCode.length = eval(StateArray + ThisState + .length); // Put 'Select' as the first option in the area code drop-down document.StateForm.AreaCode[0].value = ; document.StateForm.AreaCode[0].text = Select; document.StateForm.AreaCode[0].selected = true; // Loop through the state's array and populate the area code drop down. for (i=1; ieval(StateArray + ThisState + .length); i++) { document.StateForm.AreaCode[i].value = eval(StateArray + ThisState + [i]); document.StateForm.AreaCode[i].text = eval(StateArray + ThisState + [i]); } } } //-- /script - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 2:08 PM Subject: RE: Please help me achieve this with CF and Javascrip please It really shouldn't be difficult at all... what problems are you running into? have you got some semi-working code at all? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 14:08 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and Secondary Breed (select 3). Let me know if you're interested in that type of code. --- Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Please help me achieve this with CF and Javascrip please
Look here http://www.happyhacker.com/Code.cfm?Cat=CFSubCat=2_3Slcts#StartHere WebGuy -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 15:15 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Hi I think you will find it is more difficult then you may think... I am using the sample code from webtricks.com. Their default is two selects - what I need to find out is where to add javascript and coldfusion to build arrays for the third select box This is the actual code for two selects, need to find out how to build in the extra logic to get three selects working on the same approach as below? This is where I am having trouble and would appreciate some help please script language = JavaScript !-- // For each state, create an array to hold the area codes. // Each state array will be identified by the two-character state abbreviation cfoutput query=GetStates group=State // Create the array StateArray#StateCode# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 StateArray#StateCode#[#i#] = #AreaCode#; /cfoutput /cfoutput // Function to populate the area codes for the state selected function PopulateAreaCode() { // Only process the function if the first item is not selected. if (document.StateForm.StateCode.selectedIndex != 0) { // Find the state abbreviation var ThisState = document.StateForm.StateCode[document.StateForm.StateCode.selected Index].val ue; // Set the length of the arecode drop down equal to the length of the state's array document.StateForm.AreaCode.length = eval(StateArray + ThisState + .length); // Put 'Select' as the first option in the area code drop-down document.StateForm.AreaCode[0].value = ; document.StateForm.AreaCode[0].text = Select; document.StateForm.AreaCode[0].selected = true; // Loop through the state's array and populate the area code drop down. for (i=1; ieval(StateArray + ThisState + .length); i++) { document.StateForm.AreaCode[i].value = eval(StateArray + ThisState + [i]); document.StateForm.AreaCode[i].text = eval(StateArray + ThisState + [i]); } } } //-- /script - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 2:08 PM Subject: RE: Please help me achieve this with CF and Javascrip please It really shouldn't be difficult at all... what problems are you running into? have you got some semi-working code at all? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 14:08 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and Secondary Breed (select 3). Let me know if you're interested in that type of code. --- Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Is Cold Fusion REALLY multi threaded?
Another thing to check, in Select queries are you using the Blockfactor = x (x being a number between 1 and 100). Using Blockfactor causes CF to bring back blocks of results. Mike Brunt - CTO Webapper Services LLC Blog - http://www.webapper.net Downey CA Office 562.243.6255 AIM webappermb Web Application Specialists -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:26 AM To: CF-Talk Subject: RE: Is Cold Fusion REALLY multi threaded? Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 10:15 To: CF-Talk Subject: Is Cold Fusion REALLY multi threaded? Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ~| 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
RE: cfmx and FORM file oddity
You might want to try something like this instead: !---Code in the upload form--- form enctype=multipart/form-data action=upload_action.cfm method=post File to upload: input type=file name=uploadfile size=40 input type=submit name=Upload value=Upload /form !--- code in the action form--- cffile action=upload filefield=UploadFile destination=d:\temp\ nameconflict=unique File uploaded successfully: Filename on client: cfoutput#cffile.clientfile#/cfoutputbr Filename on server: cfoutput#cffile.serverfile#/cfoutputbr File Size: cfoutput#cffile.filesize#/cfoutputbr !--- move file to another folder --- cffile action=move source=D:\temp\#cffile.serverfile# destination=d:\junk\#cffile.serverfile# br File successfully moved to D:\Junk\cfoutput#cffile.serverfile#/cfoutput Peter Bagnato -Original Message- From: Jaye Morris - jayeZERO.com [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:48 AM To: CF-Talk Subject: cfmx and FORM file oddity I am using something relative to the following code: form action=blahblahblah.cfm method=post enctype=multipart/form-data input type=File name=uploadedFileNamebr input type=Submit value=Upload Now /form During the process, I am attempting to catch the variable uploadedFileName, but instead of getting a file name like myfilename.zip or whatever, I get something like: R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1 6991.tmp Being that neotmp16991.tmp is not the file name and is really something like myfilename.zip, how do I get that actual file name as opposed to what is seen above. -//- Jaye Morris - Multimedia Developer -//- [EMAIL PROTECTED] - www.navtrak.net -//- [EMAIL PROTECTED] - www.jayezero.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: cfmx and FORM file oddity
The variable you want to call is actually #File.ServerFile# This is the default name assigned by CF to any just uploaded file. There's also a host of other available attributes. Check the docs for more info. hth, ~Val - Original Message - From: Jaye Morris - jayeZERO.com [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 9:47 AM Subject: cfmx and FORM file oddity I am using something relative to the following code: form action=blahblahblah.cfm method=post enctype=multipart/form-data input type=File name=uploadedFileNamebr input type=Submit value=Upload Now /form During the process, I am attempting to catch the variable uploadedFileName, but instead of getting a file name like myfilename.zip or whatever, I get something like: R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1 6991.tmp Being that neotmp16991.tmp is not the file name and is really something like myfilename.zip, how do I get that actual file name as opposed to what is seen above. -//- Jaye Morris - Multimedia Developer -//- [EMAIL PROTECTED] - www.navtrak.net -//- [EMAIL PROTECTED] - www.jayezero.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Please help me achieve this with CF and Javascrip please
I have used the three select related tag and agreed it works quite well, nate has done a good job. However there is a lot of code bloat with that tag i.e. there is a lot of javascript product that you do not use, and the control you have over the page is not as great as if the webtricks version had 3 selects as you can see exactly what is going on. Also with the three selects tag you need 3 seperate tables to speicfy each select value, where as the other approach will let you get away with 1 table which is what I have to work with. - Original Message - From: Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:28 PM Subject: Re: Please help me achieve this with CF and Javascrip please I posted a link to the Three Selects Related tag. It does the same thing that you are looking for. Perhaps you might try downloading it and reading through the code of the tag to find the answer to your question. Hatton Ian Vaughan wrote: Hi I think you will find it is more difficult then you may think... I am using the sample code from webtricks.com. Their default is two selects - what I need to find out is where to add javascript and coldfusion to build arrays for the third select box This is the actual code for two selects, need to find out how to build in the extra logic to get three selects working on the same approach as below? This is where I am having trouble and would appreciate some help please script language = JavaScript !-- // For each state, create an array to hold the area codes. // Each state array will be identified by the two-character state abbreviation cfoutput query=GetStates group=State // Create the array StateArray#StateCode# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 StateArray#StateCode#[#i#] = #AreaCode#; /cfoutput /cfoutput // Function to populate the area codes for the state selected function PopulateAreaCode() { // Only process the function if the first item is not selected. if (document.StateForm.StateCode.selectedIndex != 0) { // Find the state abbreviation var ThisState = document.StateForm.StateCode[document.StateForm.StateCode.selectedIndex].va l ue; // Set the length of the arecode drop down equal to the length of the state's array document.StateForm.AreaCode.length = eval(StateArray + ThisState + .length); // Put 'Select' as the first option in the area code drop-down document.StateForm.AreaCode[0].value = ; document.StateForm.AreaCode[0].text = Select; document.StateForm.AreaCode[0].selected = true; // Loop through the state's array and populate the area code drop down. for (i=1; ieval(StateArray + ThisState + .length); i++) { document.StateForm.AreaCode[i].value = eval(StateArray + ThisState + [i]); document.StateForm.AreaCode[i].text = eval(StateArray + ThisState + [i]); } } } //-- /script - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 2:08 PM Subject: RE: Please help me achieve this with CF and Javascrip please It really shouldn't be difficult at all... what problems are you running into? have you got some semi-working code at all? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 14:08 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below. Nate Weiss has a custom tag called Three Related Selects or something similar on the MM Exchange. Re the script you posted, I've used that one to create a modified version of three related selects. In my case, I needed both selects 2 and 3 (populated with the same values) to change when select 1 was chosen. In my case select 3 wasn't controlled by select 2 but was also controlled by select 1. The situation was that user chooses Animal Type (select 1) and then selects Primary Breed (select 2) and
RE: Is Coldfusion REALLY multi threaded?
OK, next step is to check the number of database connections you actually have. Easiest is if you are only using one datasource on that particular server, just run a netstat and check the number of TCP connections to port 5423. Else, start working from the database side, use the standard tools to determine the number of backends and their status. Alsomake sure you are not running with a default transaction level of serializable, which would make all transactions run pretty much after eachother. We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. Not running with serializable transaction level. - Stephen Richards 020 7903 3226 --
Re: Please help me achieve this with CF and Javascrip please
I was more suggesting that you could learn from the code in the ThreeSelects tag and apply it to what you have now. I initially looked at slimming the code down and then decided it would be good to go stock. I also have a small amount of HTML to put between the selects for my use. As for the driving query, you don't need three separate tables. You need better SQL in your select for the query. What's the query that you're using for driving your selects? Hatton Ian Vaughan wrote: I have used the three select related tag and agreed it works quite well, nate has done a good job. However there is a lot of code bloat with that tag i.e. there is a lot of javascript product that you do not use, and the control you have over the page is not as great as if the webtricks version had 3 selects as you can see exactly what is going on. Also with the three selects tag you need 3 seperate tables to speicfy each select value, where as the other approach will let you get away with 1 table which is what I have to work with. - Original Message - From: Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:28 PM Subject: Re: Please help me achieve this with CF and Javascrip please I posted a link to the Three Selects Related tag. It does the same thing that you are looking for. Perhaps you might try downloading it and reading through the code of the tag to find the answer to your question. Hatton Ian Vaughan wrote: Hi I think you will find it is more difficult then you may think... I am using the sample code from webtricks.com. Their default is two selects - what I need to find out is where to add javascript and coldfusion to build arrays for the third select box This is the actual code for two selects, need to find out how to build in the extra logic to get three selects working on the same approach as below? This is where I am having trouble and would appreciate some help please script language = JavaScript !-- // For each state, create an array to hold the area codes. // Each state array will be identified by the two-character state abbreviation cfoutput query=GetStates group=State // Create the array StateArray#StateCode# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 StateArray#StateCode#[#i#] = #AreaCode#; /cfoutput /cfoutput // Function to populate the area codes for the state selected function PopulateAreaCode() { // Only process the function if the first item is not selected. if (document.StateForm.StateCode.selectedIndex != 0) { // Find the state abbreviation var ThisState = document.StateForm.StateCode[document.StateForm.StateCode.selectedIndex].va l ue; // Set the length of the arecode drop down equal to the length of the state's array document.StateForm.AreaCode.length = eval(StateArray + ThisState + .length); // Put 'Select' as the first option in the area code drop-down document.StateForm.AreaCode[0].value = ; document.StateForm.AreaCode[0].text = Select; document.StateForm.AreaCode[0].selected = true; // Loop through the state's array and populate the area code drop down. for (i=1; ieval(StateArray + ThisState + .length); i++) { document.StateForm.AreaCode[i].value = eval(StateArray + ThisState + [i]); document.StateForm.AreaCode[i].text = eval(StateArray + ThisState + [i]); } } } //-- /script - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 2:08 PM Subject: RE: Please help me achieve this with CF and Javascrip please It really shouldn't be difficult at all... what problems are you running into? have you got some semi-working code at all? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 14:08 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced professional coldfusion and javascript developers on the list - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:23 PM Subject: Re: Please help me achieve this with CF and Coldfusion please I am using a piece of code for 2 related selects shown below. I would like to add a third select field and have this generated dynamically from a database using Coldfusion like the other two selects shown below.
RE: MX Hosting
Rob, I have had a couple CFMX sites with www.hostmysite.com for almost a year now and it's been a wonderful experience so far, and fairly cheap Are you using shared hosting? if so, that is odd, as when I inquired about their CFMX hosting I was told they did not allow cfobject (presumably createObject as well) and that (their) CFMX was unstable in a shared hosting environment. -Craig ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Is Coldfusion REALLY multi threaded?
Stephen Richards wrote: We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want to get somebody to look at that query, since 2 minutes is rather long. Jochem ~| 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
Re: Personaliztion with Coldfusion ?
Hi I have just been trying what you suggested, and it works but not 100% as of yet. If the login is successfull I set a session variable in the login check page cfset session.security = #Security.Division# 'the division variable is from the itadmin table' and contains teama, teamb values. Then in the actual linkdisplay page I use the following query CFQUERY name=list datasource=intranetv8 SELECT * FROM itlinks WHERE linkarea='#URL.area#' AND security='#session.security#' OR security = 'all' /CFQUERY However this is not working, I am not getting any error messages, just I cant see the link I have just added even though I should as my security field in my itlinks table is the same as my session variable from the varaiable I set up from my login information when I logged in. Cant really see why this is occuring? - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 3:12 PM Subject: Re: Personaliztion with Coldfusion ? On your login page you'd set the session variable. If the login is successful. cfset session.views = #queryName.Division# Then you'd use the following on the page that displays the documents CFQUERY name=docs datasource=intranetv8 SELECT docid, doctitle, docsummary, docpath, docView_type FROM itdocs WHERE category2='#URL.category2#' AND views='#session.views#' OR views = 'all' /CFQUERY Any of the big dogs please correct me if I'm wrong ;) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 12/3/2002 10:00:03 AM I am still using Coldfusion 4.5, so CFMX is not a practical solution in the short term. So from what has been suggested. Yes I have a field called views in the documents (itdocs) table. When they add the document through a html form there is a select box field with 3 options the user has to select option value=teamaAvailable to Team A/option option value=teambAvailable to Team B/option option value=allAvailable to Everybody/option The value they select populates the views field in the documents (itdocs) table. When you state you can set up a session variable. Where would this value come from? In the user table holding their profile information there is a field called division. This contains either Teama or Teamb for each user. So could this be used? And is the above the most efficient way of creating as Ben Forta calls it Explicit Personalization ?? or are there better more elegant approaches of achieving the above? Because the same (i.e. who is able to view the content) would have to be done for when a user adds a record to the download table or a news article. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Fw: Is Coldfusion REALLY multi threaded?
- Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? Stephen Richards wrote: We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want to get somebody to look at that query, since 2 minutes is rather long. how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. - Stephen Richards 020 7903 3226 --
RE: CFX_Image - Quality of images not good when rotating
Agreed. It's in PHP. You can do all kinds of cool manipulations in either the GD or ImageMagick libraries without any funny business. -- jon -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:53 AM To: CF-Talk Subject: Re: CFX_Image - Quality of images not good when rotating Man, this is the never-ending, and ever-recurring, thread...but I have to try and ask a summarizing question, because after all these posts and replies I still don't have a solution to my personal problems. The perfect tag/function I'm looking for needs to be able to: 1) Get dimensions from an image (Height, Width, Size, etc.) 2) Be able to resize a GIF or JPEG with (almost) the same quality as PhotoShop 3) Plug and play ability with no need to configure anything in CF Administrator (So a Java JAR would probably be best) 4) Adding text or a watermark would be icing on the cake, but not necessary And that's about it. The closest I'm come is ImageJ (http://rsb.info.nih.gov/ij/) using some of www.benorama.com implementations along with some edits. I can just place the JAR file in the same directory and access it there, but the quality on JPEGs is not so good. This really should be a feature of *Macromedia's* ColdFusion already, I've been pleading for the latest two versions now- Tyler Silcox email | [EMAIL PROTECTED] website | www.gslsolutions.com - Original Message - From: jon roig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 12:06 AM Subject: RE: CFX_Image - Quality of images not good when rotating Kind of interesting -- somebody sat down and wrote a custom tag to manipulate imagemagick. http://www.alagad.com/index.cfm/name-mtinfo -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 7:27 PM To: CF-Talk Subject: Re: CFX_Image - Quality of images not good when rotating Awesome idea...one slight problem, where's the link to download it? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Is Coldfusion REALLY multi threaded?
It might not Be CF thats causing the problem, its most likley the DB thats escalating the Lock to a full table lock and thus preventing other users from running the queries until the table is free. Also try moving the DB onto another server, as we had a simular problem, with ingres and moving the CF app to a new server solved the problem. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 16:23 To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? Stephen Richards wrote: We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want to get somebody to look at that query, since 2 minutes is rather long. how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Fw: Is Coldfusion REALLY multi threaded?
Stephen Richards wrote: - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? And how many of them are idle? how do I tell which ones are active? top Yep, I agree with you about the query, and we're taking action on that Send me the EXPLAIN ANALYZE output together with table metrics and I will have a look. Jochem ~| 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.
Using CfQuery
I am trying to do a cfquery without setting up a DSN on the CF Admin. I am using CF 5. I pasted the code that I am using below. It works fine in most instances however, when using a query that uses the CreateODBCDateTime I get an error: Malformed GUID. in query expression. I am using Access 97 and 2000. This query works fine when I set up the DSN in the Admin. This is my code: CFQUERY NAME=qryGetUserName DATASOURCE=#strConn# providerdsn=#strConn# dbtype=OLEDB provider=Microsoft.Jet.OLEDB.4.0 username=Admin password= ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Cfpop
Hey Is there any way of returning the size of a message using cfpop? Also is there any way of returning whether the email has an attachment using the GetHeaderOnly action ? Using the getall action seems over kill for a simple is there an attachment or not query... 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
deadlock errors
Hey, been getting the page of DOOM on our development server over the last couple of weeks, I am properly locking all queries and stored proc calls but still it creeps in, averaging 2 a day. error desc: [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #20) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Our devserver is connected to the same SQL server as our Production server, I know, I know but budget is an issue here, which is getting a lot of transactions / INSERT / per day averaging 44,100 transactions, this is excluding GET transactions, thses transactions a set to get bigger also, which makes me think of Clustering SQL server, has anyone done this? The reason for clustering SQL and not CF is because about 2 thirds of these are done by Exchange, I know there is things that should be looked into at SQL server side, currently looking at this, but, any direct advice on this matter would be appreciated, Respectfully, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Is Coldfusion REALLY multi threaded?
..with regards to the long query...we have an app that has several queries that run quite long, a couple in the 3 or 4 minute range. These do not bring my CF server to a halt at all. We average almost 200 users per hour on busy days on this box. Have a look at all your CFAdmin settings. You may need to raise the 'limit simultaneous requests'. We have it set to 40 for a four proc machine. I have found through research and experience that if your app is very DB intense, raising this helps. Also look at lowering the 'restart at x unresponsive requests' We have it set at 5. Also make sure you have 'timeout requests after x seconds' checked and set reasonably. note that my experiences are with winblows boxen. on Linux boxen, this may very. Doug -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:23 AM To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? Stephen Richards wrote: We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want to get somebody to look at that query, since 2 minutes is rather long. how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Switch in MX
CFSwitch expression=URL.SORT CFCase Value=1 ST.st_trdate/cfcase CFCase Value=1D ST.st_trdate DESC/cfcase /CFSwitch IN CF5.0 it is OK but in MX it probably takes 1D as 1.0 so gives error saying DUPLICATE CASE VALUES. How can I sort this thing out now. Regards Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Fw: Is Cold Fusion REALLY multi threaded?
Yes, I agree with you, we are denormalizing like mad and retuning the database, and am confident that we will get the two minute query down to something more manageable. yes, the CPU maxes out at 99.9% while the query is executing. However, that doesn't alter the fact, that if the query is executed from a CF page, then all other CF activity comes to a halt; if it is executed from the db client command line, then other CF activity (includeing Db accesses) work just dandy. - Stephen Richards 020 7903 3226 -- - Original Message - From: S V [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:11 PM Subject: Re: Is Cold Fusion REALLY multi threaded? I know that you may have already done this, but check the tables thems selves. Are they properly tuned, Indexes, If there are multi joins, maybe they need to be denormalized. On the CF query get a limited number of rows , instead og XXX million rows. Is the CPU peaked on this page??? = = = Original message = = = Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
Re: Switch in MX
CFSwitch expression=URL.SORT CFCase Value=1 ST.st_trdate/cfcase CFCase Value=1D ST.st_trdate DESC/cfcase /CFSwitch IN CF5.0 it is OK but in MX it probably takes 1D as 1.0 so gives error saying DUPLICATE CASE VALUES. How can I sort this thing out now. If that's the case, then it's a bug and it should be reported, however, I think you need # symbols around your url.sort variable. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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
Fw: Is Cold Fusion REALLY multi threaded?
That is interesting. However, I wonder just what effect it will have in this case, because the long page is executing a SERIES of 6 long queries (it is producing a page of stats), and all CF activity stops until all six queries have been executed. If the blockfactor was going to release the CF server to work on something else for a while, you would also expect a change from one query to another, no? I'll try it and let you know. - Stephen Richards 020 7903 3226 -- - Original Message - From: Mike Brunt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:37 PM Subject: RE: Is Cold Fusion REALLY multi threaded? Another thing to check, in Select queries are you using the Blockfactor = x (x being a number between 1 and 100). Using Blockfactor causes CF to bring back blocks of results. Mike Brunt - CTO Webapper Services LLC Blog - http://www.webapper.net Downey CA Office 562.243.6255 AIM webappermb Web Application Specialists -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:26 AM To: CF-Talk Subject: RE: Is Cold Fusion REALLY multi threaded? Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 10:15 To: CF-Talk Subject: Is Cold Fusion REALLY multi threaded? Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line For the record, the applicable CF Admin settings ara: - Single Threading: not checked - Variable Scope Lock settings: all set to no automatic checking or locking Is there anything else I need to set? Environment: Op Sys: linux Red Hat Linux 2.4.2 CF v5.0 Unix ODBC Postgres 7.2.3 database - Stephen Richards 020 7903 3226 -- ~| 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
RE: Switch in MX
Wasn't that addressed in the CFMX updater? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:22 AM To: CF-Talk Subject: Switch in MX CFSwitch expression=URL.SORT CFCase Value=1 ST.st_trdate/cfcase CFCase Value=1D ST.st_trdate DESC/cfcase /CFSwitch IN CF5.0 it is OK but in MX it probably takes 1D as 1.0 so gives error saying DUPLICATE CASE VALUES. How can I sort this thing out now. Regards Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Fw: Is Coldfusion REALLY multi threaded?
How your's works is how I would have expected. At the moment , limit simultaneous requests is not ticked - perhaps I should and set it to 40. I'll try it and let you know. - Stephen Richards 020 7903 3226 -- - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:42 PM Subject: RE: Is Coldfusion REALLY multi threaded? ..with regards to the long query...we have an app that has several queries that run quite long, a couple in the 3 or 4 minute range. These do not bring my CF server to a halt at all. We average almost 200 users per hour on busy days on this box. Have a look at all your CFAdmin settings. You may need to raise the 'limit simultaneous requests'. We have it set to 40 for a four proc machine. I have found through research and experience that if your app is very DB intense, raising this helps. Also look at lowering the 'restart at x unresponsive requests' We have it set at 5. Also make sure you have 'timeout requests after x seconds' checked and set reasonably. note that my experiences are with winblows boxen. on Linux boxen, this may very. Doug -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:23 AM To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? Stephen Richards wrote: We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want to get somebody to look at that query, since 2 minutes is rather long. how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Switch in MX
That's true, it is -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 17:37 To: CF-Talk Subject: RE: Switch in MX Wasn't that addressed in the CFMX updater? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:22 AM To: CF-Talk Subject: Switch in MX CFSwitch expression=URL.SORT CFCase Value=1 ST.st_trdate/cfcase CFCase Value=1D ST.st_trdate DESC/cfcase /CFSwitch IN CF5.0 it is OK but in MX it probably takes 1D as 1.0 so gives error saying DUPLICATE CASE VALUES. How can I sort this thing out now. Regards Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Is Coldfusion REALLY multi threaded?
Hi Stephen, 40 is an awfully high setting for Limit Simultaneous Requests, we typically recommend you set that to 3-7 * per CPU, with 7 being on the high side. Regards, Christine Lawson Macromedia -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:30 PM To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? How your's works is how I would have expected. At the moment , limit simultaneous requests is not ticked - perhaps I should and set it to 40. I'll try it and let you know. - Stephen Richards 020 7903 3226 -- - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:42 PM Subject: RE: Is Coldfusion REALLY multi threaded? ..with regards to the long query...we have an app that has several queries that run quite long, a couple in the 3 or 4 minute range. These do not bring my CF server to a halt at all. We average almost 200 users per hour on busy days on this box. Have a look at all your CFAdmin settings. You may need to raise the 'limit simultaneous requests'. We have it set to 40 for a four proc machine. I have found through research and experience that if your app is very DB intense, raising this helps. Also look at lowering the 'restart at x unresponsive requests' We have it set at 5. Also make sure you have 'timeout requests after x seconds' checked and set reasonably. note that my experiences are with winblows boxen. on Linux boxen, this may very. Doug -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:23 AM To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? Stephen Richards wrote: We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want to get somebody to look at that query, since 2 minutes is rather long. how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. - Stephen Richards 020 7903 3226 -- ~| 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
Re: deadlock errors
This has nothing to do with CF, so locking your queries and sp calls won't help you. The deadlocks are probably occuring because a user is trying to read at the same time someone else is trying to write, or vice versa, or two people are trying to write to the same record at the same time, etc, etc. If you're really lazy, use SET TRANSACTION ISOLATION LEVEL SERIALIZABLE in your sp calls, etc. This entails a performance hit however. I'd recommend a redesign to minimize deadlocks. - Original Message - From: John McCosker [EMAIL PROTECTED] Date: Thursday, December 5, 2002 10:03 am Subject: deadlock errors Hey, been getting the page of DOOM on our development server over the last couple of weeks, I am properly locking all queries and stored proc calls but still it creeps in, averaging 2 a day. error desc: [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #20) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Our devserver is connected to the same SQL server as our Production server, I know, I know but budget is an issue here, which is getting a lot of transactions / INSERT / per day averaging 44,100 transactions, this is excluding GET transactions, thses transactions a set to get bigger also, which makes me think of Clustering SQL server, has anyone done this? The reason for clustering SQL and not CF is because about 2 thirds of these are done by Exchange, I know there is things that should be looked into at SQL server side, currently looking at this, but, any direct advice on this matter would be appreciated, Respectfully, j ~| 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
CF Connection = License Used?
Can anybody tell me how CF's use of a database connection works as far as license compliance is concerned? Say if a client has 10 licenses and CF is set to allow 10 Limit Simultaneous Requests, is it possible to gobble up all the licenses and lock other users out? I don't really understand this aspect of CF but I've always set my Simultaneous Connections low (usually 2) just in case. But I don't want a client hollering because our CF app ate all his licenses. Does anybody know how this works? Thanks, Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Fw: Is Coldfusion REALLY multi threaded?
I don't know if this is what you were looking for, but here it is: The thing is, I know there is plenty I can do to make these queries run faster - it is just a general question: why does CF just hang for all the other users when this query is executed from a CF page, and not when executed from the db itself? thanks, by the way, for your suggestions so far. You sound as though you have experience of CF with Postgres on a Lunux box? SR EXPLAIN ANALYZE SELECT count(*) as count, ROUND(sum(order_value(h.orderid))/100.0,2) as value FROM statusstats3 h INNER JOIN orders o ON (o.orderid = h.orderid) WHERE h.time::date BETWEEN '2002-10-01' AND '2002-10-31' AND h.tostatus = 'sales_approved' AND o.status != 'order_cancelled' AND o.existing = false NOTICE: QUERY PLAN: Aggregate (cost=5459.05..5459.05 rows=1 width=8) (actual time=52296.17..52296.17 rows=1 loops=1) - Nested Loop (cost=5453.01..5459.04 rows=1 width=8) (actual time=39563.71..39704.95 rows=571 loops=1) - Subquery Scan h (cost=5453.01..5453.02 rows=1 width=36) (actual time=39563.47..39574.80 rows=742 loops=1) - Unique (cost=5453.01..5453.02 rows=1 width=36) (actual time=39563.46..39570.71 rows=742 loops=1) - Sort (cost=5453.01..5453.01 rows=1 width=36) (actual time=39563.46..39565.25 rows=849 loops=1) - Seq Scan on orderhistory (cost=0.00..5453.00 rows=1 width=36) (actual time=9998.10..39559.34 rows=849 loops=1) - Index Scan using orders_pkey on orders o (cost=0.00..6.01 rows=1 width=4) (actual time=0.15..0.16 rows=1 loops=742) Total runtime: 52296.58 msec messina=# select count(*) from orders; count --- 4914 (1 row) messina=# select count(*) from orderatoms; count --- 9222 (1 row) messina=# select count(*) from statusstats3; count --- 21452 (1 row) Statusstats3 is a view of the orderhistory table, hence the reference to orderhistory in the explain above. messina=# messina=# \d statusstats3 View statusstats3 Column |Type | Modifiers --+-+--- orderid | integer | tostatus | character varying | time | timestamp without time zone | View definition: SELECT DISTINCT orderhistory.orderid, get_status((orderhistory.changes)::varchar) AS tostatus, min_status_time(orderhistory.orderid, get_status((orderhistory.changes)::varchar)) AS time FROM orderhistory WHERE ((orderhistory.tablename = 'orders'::varchar) AND (orderhistory.changes ~~ '%ST:%,%'::text)) ORDER BY orderhistory.orderid, get_status((orderhistory.changes)::varchar), min_status_time(orderhistory.orderid, get_status((orderhistory.changes)::varchar)); messina=# \d orderhistory Table orderhistory Column |Type | Modifiers ---+-+-- - tablename | character varying(32) | not null orderid | integer | not null time | timestamp without time zone | not null default now() who | character varying(32) | not null default current_user() action| character(1)| not null changes | text| Indexes: orderhistory_key Check constraints: orderhistory_action (((action = 'I'::bpchar) OR (action = 'U'::bpchar)) OR (action = 'D'::bpchar)) - Stephen Richards 020 7903 3226 -- - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:50 PM Subject: Re: Fw: Is Coldfusion REALLY multi threaded? Stephen Richards wrote: - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? And how many of them are idle? how do I tell which ones are active? top Yep, I agree with you about the query, and we're taking action on that Send me the EXPLAIN ANALYZE output together with table metrics and I will have a look. Jochem ~| 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.
Fw: Is Coldfusion REALLY multi threaded?
moving the CF server onto another box was indeed the next line of attack, until I saw that if the query was executed from outstide CF, then other users, invluding CF users couls access the DB fine. It's definitely not table locks unless the DB puts the lock on when the query comes from CF, and not when it comes from a client. SR - Stephen Richards 020 7903 3226 -- - Original Message - From: Jason Lees (National Express) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:50 PM Subject: RE: Is Coldfusion REALLY multi threaded? It might not Be CF thats causing the problem, its most likley the DB thats escalating the Lock to a full table lock and thus preventing other users from running the queries until the table is free. Also try moving the DB onto another server, as we had a simular problem, with ingres and moving the CF app to a new server solved the problem. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 16:23 To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? Stephen Richards wrote: We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want to get somebody to look at that query, since 2 minutes is rather long. how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Switch in MX
Yeah, you are right. Its been addressed. Thanks -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 17:32 To: CF-Talk Subject: Re: Switch in MX CFSwitch expression=URL.SORT CFCase Value=1 ST.st_trdate/cfcase CFCase Value=1D ST.st_trdate DESC/cfcase /CFSwitch IN CF5.0 it is OK but in MX it probably takes 1D as 1.0 so gives error saying DUPLICATE CASE VALUES. How can I sort this thing out now. If that's the case, then it's a bug and it should be reported, however, I think you need # symbols around your url.sort variable. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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
Need 2 elegant Queries
This is classic me. I've promised myself into a corner and demoed something hard coded without thinking about how to construct an elegant query to feed it in production-mode via a database. Query 1. 5 separate ads that run for a week each and rotate each Monday morning. I need to run ad 1 for a week, then ad 2 for a week, ad 5 for a week, and then recycle to ad 1 for a week again. These are actually meal menus that progress forward a week with each cycle. Query 2. I need to feed a scroller with this week information from a db with the table columns itemdate, itemdetail. I've thought of some kluges (particularly for number 2, which has resulted in some truly epic, Byzantine queries), but I'd like something elegant. Any ideas? Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Is Cold Fusion REALLY multi threaded?
Subject: Is Cold Fusion REALLY multi threaded? Yes, it really is. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. If, however, I execute the same query from the database client, it still takes the same amount of time to return the result set, but has no discernable effect on the response times of the coldfusion users. This suggests to me that CF only executes one DB query at a time - please tell me I'm wrong. This also explains why our system response times are so lame when there are more than about 20 people on line. This may be a problem with your specific database drivers. I'm not especially familiar with PostgreSQL, but I've seen similar things in the (relatively distant) past with Oracle ODBC drivers - they were essentially single-threaded, so all queries were queued - which, as you've discovered, is very bad for performance! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFMX/SQL Error
I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Is Coldfusion REALLY multi threaded?
At the moment, limit simultaneous requests is not ticked - perhaps I should and set it to 40. I'll try it and let you know. Setting it to forty would probably not be an especially good idea - that's an extremely high value. CF is designed to take advantage of queuing requests - some number get simultaneously processed and the rest go into a queue, and are serviced when free threads are available for them. This is supposed to be faster than simply processing all the requests at once (at least in Windows) and it's been my experience that it is, in fact, faster. As Christine Lawson noted, the recommended number is somewhere around 3-7 threads per processor. I'd add the caveat that to find the optimal number, load testing is required, and that you can see significant performance differences between the optimal number and the others. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
SQL Database Decimal problem
Hi, 1. Field data type is defined as Decimal 2. Insert/Update from form 1.234 3. Look in database - value written is 1. It's getting truncated Suggestions? Thanks... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Strange characters appearing in emails?
This may not be cfmail, but the issue is hard to diagnose, so I'm wondering if anyone else has seen this before I start digging. Using MX, I am seeing to the string   appended to one line in one particular html email. Here is where it gets strange though. When I look at the email in the cfmail spool folder, the characters are not there. When I open up the message in the mail servers outbound queue, the characters are not there, however if I open the email up in IE from the queue, the characters are there, but they are not in the source. When the actual mail gets to the end user, the string is in the source! I think this is the weirdest bug I have ever had the displeasure of battling...anyone have any clue what might be going on? -- jon mailto:[EMAIL PROTECTED] ~| 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
Re: SQL Database Decimal problem
Set the scale to something other than 0. -- jon mailto:[EMAIL PROTECTED] Thursday, December 5, 2002, 1:20:44 PM, you wrote: LM Hi, LM 1. Field data type is defined as Decimal LM 2. Insert/Update from form 1.234 LM 3. Look in database - value written is 1. LM It's getting truncated LM Suggestions? LM Thanks... LM ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Exchange Address List
Is it possible to get the usernames and email address from a local Exchange server using CF? thanks, Luis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Need 2 elegant Queries
One possible solution is to convert the current date to a julian date, mod 5 and that is your week number. Al Query 1. 5 separate ads that run for a week each and rotate each Monday morning. I need to run ad 1 for a week, then ad 2 for a week, ad 5 for a week, and then recycle to ad 1 for a week again. These are actually meal menus that progress forward a week with each cycle. Query 2. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: SQL Database Decimal problem
Creating a Decimal data column types take two arguments: precision and scale. Check to make sure that you have declared your column properly... More.. CREATE TABLE FOO( myDecimal DECIMAL(5,4); ) Would generate a column that stores data like so 1.2345 From the SQL SERVER Books OnLine: p (precision) Specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38. The default precision is 18. s (scale) Specifies the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p. Scale can be specified only if precision is specified. The default scale is 0; therefore, 0 = s = p. Maximum storage sizes vary, based on the precision. HTH, Jeff Garza - Original Message - From: Les Mizzell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 11:20 AM Subject: SQL Database Decimal problem Hi, 1. Field data type is defined as Decimal 2. Insert/Update from form 1.234 3. Look in database - value written is 1. It's getting truncated Suggestions? Thanks... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Need 2 elegant Queries
oops.. messed that up. something like: julian date / 7 mod 5 I think will do it.. At 01:37 PM 12/5/2002, you wrote: One possible solution is to convert the current date to a julian date, mod 5 and that is your week number. Al ~| 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
RE: Is Coldfusion REALLY multi threaded?
Fully agree with you there Dave, like yourselves at Fig Leaf we are often involved in load-testing big web apps and that setting should be nowhere near 40 unless this is 6 processor box. You are totally right the actual number per processor is determined by the results of controlled and monitored load testing. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 10:35 AM To: CF-Talk Subject: RE: Is Coldfusion REALLY multi threaded? At the moment, limit simultaneous requests is not ticked - perhaps I should and set it to 40. I'll try it and let you know. Setting it to forty would probably not be an especially good idea - that's an extremely high value. CF is designed to take advantage of queuing requests - some number get simultaneously processed and the rest go into a queue, and are serviced when free threads are available for them. This is supposed to be faster than simply processing all the requests at once (at least in Windows) and it's been my experience that it is, in fact, faster. As Christine Lawson noted, the recommended number is somewhere around 3-7 threads per processor. I'd add the caveat that to find the optimal number, load testing is required, and that you can see significant performance differences between the optimal number and the others. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Need 2 elegant Queries
Have a table with the fields, ItemID, AdBeginDate, AdEndDate, ItemDetail, AdDate (if needed) Then just write a query to check what todays date is and what Ad/item should be displayed depending on where todays date falls within the AdBeginDate and AdEndDate. Just be sure to that add dates do not overlap. This was you can map out however many ads you want into the future and potentially you could have a user admin screen where they can change their ad whenever they want and for however long they want. If it so happens more than one ad will run in a week you will just have to change your logic a little. This might not be the best approach if you know your only going to have 5 items no more no less and for 1 week periods infinitely, however, the approach I offer allows for flexibility and can put the ad maintenance in the users hands. CC Kennerly, Rick H CIV To: CF-Talk [EMAIL PROTECTED] RHKennerly cc: @rroads.med.nSubject: Need 2 elegant Queries avy.mil 12/05/02 07:36 AM Please respond to cf-talk This is classic me. I've promised myself into a corner and demoed something hard coded without thinking about how to construct an elegant query to feed it in production-mode via a database. Query 1. 5 separate ads that run for a week each and rotate each Monday morning. I need to run ad 1 for a week, then ad 2 for a week, ad 5 for a week, and then recycle to ad 1 for a week again. These are actually meal menus that progress forward a week with each cycle. Query 2. I need to feed a scroller with this week information from a db with the table columns itemdate, itemdetail. I've thought of some kluges (particularly for number 2, which has resulted in some truly epic, Byzantine queries), but I'd like something elegant. Any ideas? Rick ~| 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
Re: Is Coldfusion REALLY multi threaded?
Checking the Limit Simultaneous Requsts box, and setting it to 10 certainly has no effect. One connection doing the query, everyone else just stuck. Interestingly, they make the connection to the database (I can see them attempting to log in, which they do as a different user), but they get no response from the login script until the query has finished. It's sounding more and more like an ODBC issue - Stephen Richards 020 7903 3226 -- - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 6:35 PM Subject: RE: Is Coldfusion REALLY multi threaded? At the moment, limit simultaneous requests is not ticked - perhaps I should and set it to 40. I'll try it and let you know. Setting it to forty would probably not be an especially good idea - that's an extremely high value. CF is designed to take advantage of queuing requests - some number get simultaneously processed and the rest go into a queue, and are serviced when free threads are available for them. This is supposed to be faster than simply processing all the requests at once (at least in Windows) and it's been my experience that it is, in fact, faster. As Christine Lawson noted, the recommended number is somewhere around 3-7 threads per processor. I'd add the caveat that to find the optimal number, load testing is required, and that you can see significant performance differences between the optimal number and the others. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: MX Server installs and Microsoft Security Toolkits
Microsoft provides a whole bunch of Security Toolkits to help lock down a server. For example there is the Microsoft Baseline Security Analyzer. Some of these tools blindly goes in and locks down a bunch of stuff that you are not aware of. You should be very reluctant to make blind changes with regard to security. If you want to administer a server, you need to understand the security ramifications of the default settings, and of the changes made to secure the server. Server administration is not a trivial matter. Has anyone had problems running CFMX after applying security patches to Windows servers running IIS? A common problem with CFMX, or any other application server, occurs when the URLScan tool is installed. This tool is an input filter for IIS, and may prevent .cfm requests from being handled correctly, or may prevent URL variables from being received by CF. Another problem may occur with the IIS Lockdown tool, which can remove all ISAPI extension mappings from IIS. ISAPI extension mappings that are set up by default in IIS are often vulnerable to exploits, and if you're not using them, you should remove them (which is true of anything on a server, actually). However, if you remove the ISAPI extension mapping for CF, IIS won't be able to process CF pages. As for anything involving security, it is a matter of degree. How much can you lock down a box before CFMX stops working? Exactly the right amount. What kind of answer were you expecting for this question? If anyone has any white papers or other documentation on this subject, it would be appreciated. I noticed in the Security Section of the Macromedia that the white papers that still have the Allaire Logo stamped on them with dates such as 2001. Hope Macromedia is a little more serious about security than this. It does not help the CF cause. As Jochem noted, very little has changed as far as CF is concerned, with regards to security. Most security issues that you face when running a CF server have little or nothing to do with CF, but rather with the security of the server itself, and of the other services running on that server (particularly IIS). The freshness of the logos doesn't make the information more or less valid. The only major items that are specific to CFMX, really, concern the sandbox security model introduced in CFMX, which is pretty easy to figure out and to use, and which is covered in the CFMX documentation, I think. There's plenty of documentation out there on all these topics, also. Unfortunately, it's not all in one place, really; CF information is provided by Macromedia, IIS information by Microsoft, general web application security information by others, and so on. Fig Leaf Software offers a one-day seminar on securing CF servers running Windows, if you're interested in that. Information is available at http://training.figleaf.com/. There are plenty of books and online references available, also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: MX Server installs and Microsoft Security Toolkits
Hear Here. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:07 AM To: CF-Talk Subject: RE: MX Server installs and (the key to your security issues)=Microsoft Security Toolkits Microsoft provides a whole bunch of Security Toolkits to help lock down a server=(fear that). For example there is the Microsoft Baseline Security Analyzer. Some of these tools blindly goes in and locks down a bunch of stuff that you are not aware of. You should be very reluctant to make blind changes with regard to security information by others, and so on. Fig Leaf Software offers a one-day seminar on securing CF servers running Windows, if you're interested in that. Information is available at http://training.figleaf.com/. There are plenty of books and online references available, also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| 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
CSS Print Styles
Has anyone had any experience using CSS print styles to 'neatly' print out a catalog of products? Usually 2 rows of 5 products consisting of an image(100x100) and product number/description. Any good examples available to build on? Thx, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MX Server installs and Microsoft Security Toolkits
Hey Dave, Do you have any more info on URL scan specify about preventing URL variables from being received by CF? Is this only the case for extremely long URLs or URLs that contain odd ASCII? I am just about to deploy two new servers next week and I would hate to have a problem with not being able to pass vars via url when we move the site on to the new servers. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 1:07 PM To: CF-Talk Subject: RE: MX Server installs and Microsoft Security Toolkits Microsoft provides a whole bunch of Security Toolkits to help lock down a server. For example there is the Microsoft Baseline Security Analyzer. Some of these tools blindly goes in and locks down a bunch of stuff that you are not aware of. You should be very reluctant to make blind changes with regard to security. If you want to administer a server, you need to understand the security ramifications of the default settings, and of the changes made to secure the server. Server administration is not a trivial matter. Has anyone had problems running CFMX after applying security patches to Windows servers running IIS? A common problem with CFMX, or any other application server, occurs when the URLScan tool is installed. This tool is an input filter for IIS, and may prevent .cfm requests from being handled correctly, or may prevent URL variables from being received by CF. Another problem may occur with the IIS Lockdown tool, which can remove all ISAPI extension mappings from IIS. ISAPI extension mappings that are set up by default in IIS are often vulnerable to exploits, and if you're not using them, you should remove them (which is true of anything on a server, actually). However, if you remove the ISAPI extension mapping for CF, IIS won't be able to process CF pages. As for anything involving security, it is a matter of degree. How much can you lock down a box before CFMX stops working? Exactly the right amount. What kind of answer were you expecting for this question? If anyone has any white papers or other documentation on this subject, it would be appreciated. I noticed in the Security Section of the Macromedia that the white papers that still have the Allaire Logo stamped on them with dates such as 2001. Hope Macromedia is a little more serious about security than this. It does not help the CF cause. As Jochem noted, very little has changed as far as CF is concerned, with regards to security. Most security issues that you face when running a CF server have little or nothing to do with CF, but rather with the security of the server itself, and of the other services running on that server (particularly IIS). The freshness of the logos doesn't make the information more or less valid. The only major items that are specific to CFMX, really, concern the sandbox security model introduced in CFMX, which is pretty easy to figure out and to use, and which is covered in the CFMX documentation, I think. There's plenty of documentation out there on all these topics, also. Unfortunately, it's not all in one place, really; CF information is provided by Macromedia, IIS information by Microsoft, general web application security information by others, and so on. Fig Leaf Software offers a one-day seminar on securing CF servers running Windows, if you're interested in that. Information is available at http://training.figleaf.com/. There are plenty of books and online references available, also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: MX Hosting
http://www.dmv.com (Delmarva Online) currently has 2 CFMX Servers (Linux) with either SQL or mySQL support. Cutter Robert Bailey wrote: This is a multi-part message in MIME format. --=_NextPart_000_0065_01C29BAD.12311810 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I need to move a client over to MX and wondering if anyone knows of any good companies that offer MX hosting that they have had good experiences with. Rob --=_NextPart_000_0065_01C29BAD.12311810 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable html xmlns:o=3Durn:schemas-microsoft-com:office:office = xmlns:w=3Durn:schemas-microsoft-com:office:word = xmlns=3Dhttp://www.w3.org/TR/REC-html40; head META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; = charset=3Dus-ascii meta name=3DProgId content=3DWord.Document meta name=3DGenerator content=3DMicrosoft Word 10 meta name=3DOriginator content=3DMicrosoft Word 10 link rel=3DFile-List href=3Dcid:[EMAIL PROTECTED]; !--[if gte mso 9]xml o:OfficeDocumentSettings o:DoNotRelyOnCSS/ /o:OfficeDocumentSettings /xml![endif]--!--[if gte mso 9]xml w:WordDocument w:SpellingStateClean/w:SpellingState w:GrammarStateClean/w:GrammarState w:DocumentKindDocumentEmail/w:DocumentKind w:EnvelopeVis/ w:Compatibility w:BreakWrappedTables/ w:SnapToGridInCell/ w:WrapTextWithPunct/ w:UseAsianBreakRules/ /w:Compatibility w:BrowserLevelMicrosoftInternetExplorer4/w:BrowserLevel /w:WordDocument /xml![endif]-- style !-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Times New Roman; mso-fareast-font-family:Times New Roman;} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.EmailStyle17 {mso-style-type:personal-compose; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -- /style !--[if gte mso 10] style /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:Times New Roman;} /style ![endif]-- /head body lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in' div class=3DSection1 p class=3DMsoNormalfont size=3D2 face=3DArialspan = style=3D'font-size:10.0pt; font-family:Arial'I need to move a client over to MX and wondering if = anyone knows of any good companies that offer MX hosting that they have had = good experiences with. o:p/o:p/span/font/p p class=3DMsoNormalfont size=3D2 face=3DArialspan = style=3D'font-size:10.0pt; font-family:Arial'o:pnbsp;/o:p/span/font/p p class=3DMsoNormalfont size=3D2 face=3DArialspan = style=3D'font-size:10.0pt; font-family:Arial'Robo:p/o:p/span/font/p /div /body /html --=_NextPart_000_0065_01C29BAD.12311810-- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: SQL Database Decimal problem
Check the scale and precision? CC Les Mizzell lesmizz To: CF-Talk [EMAIL PROTECTED] @bellsouth.necc: t Subject: SQL Database Decimal problem 12/05/02 12:20 PM Please respond to cf-talk Hi, 1. Field data type is defined as Decimal 2. Insert/Update from form 1.234 3. Look in database - value written is 1. It's getting truncated Suggestions? Thanks... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Need 2 elegant Queries
- Original Message - From: Kennerly, Rick H CIV [EMAIL PROTECTED] 5 separate ads that run for a week each and rotate each Monday morning. I need to run ad 1 for a week, then ad 2 for a week, ad 5 for a week, and then recycle to ad 1 for a week again. These are actually meal menus that progress forward a week with each cycle. On a site I've just done, I rotate stuff like this: - Is application.stuff.timestamp undefined or older than a week (or however long)? - If yes, grab stuff that's not been used (indicated with Boolean 'used' field). - If nothing returned, clear all 'used' flags and try again. - Query this query to get one item randomly. - Flag it as used. - Store info about the item in application.stuff (structure). - Set application.stuff.timestamp to Now(). This should be a pretty flexible system. HTH, Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFMX CFFORM page gets truncated
I found two posts at the Macromedias forums with the same problem (no solution) A page that works/displays fine on CF 5.0 gets truncated about halfway through the CFFORM. Replace the CFFORM with the humble HTML equivelant and the problem goes away. Leave the CFFORM and turn on MX Debugging and again no trouble. I looked through the code and although not optimal I didn't see anything obvious (like missing quotes, table tags etc). I don't remember seeing this issue pop through these lists either. Any ideas? Has this happened to anyone else? (CF MX, IIS, Win2k) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: cfmx and FORM file oddity part II
Thanks Val. That worked like a champ. I much appreciate it. -//- Jaye Morris - Multimedia Developer -//- [EMAIL PROTECTED] - www.navtrak.net -//- [EMAIL PROTECTED] - www.jayezero.com +++ Date: Thu, 5 Dec 2002 10:50:39 -0500 From: Valerie L. Criswell [EMAIL PROTECTED] Subject: Re: cfmx and FORM file oddity Message-ID: 001f01c29c76$0f80d2d0$[EMAIL PROTECTED] The variable you want to call is actually #File.ServerFile# This is the default name assigned by CF to any just uploaded file. There's also a host of other available attributes. Check the docs for more info. hth, ~Val - Original Message - From: Jaye Morris - jayeZERO.com [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 9:47 AM Subject: cfmx and FORM file oddity I am using something relative to the following code: form action=blahblahblah.cfm method=post enctype=multipart/form-data input type=File name=uploadedFileNamebr input type=Submit value=Upload Now /form During the process, I am attempting to catch the variable uploadedFileName, but instead of getting a file name like myfilename.zip or whatever, I get something like: R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotm p1 6991.tmp Being that neotmp16991.tmp is not the file name and is really something like myfilename.zip, how do I get that actual file name as opposed to what is seen above. -//- Jaye Morris - Multimedia Developer -//- [EMAIL PROTECTED] - www.navtrak.net -//- [EMAIL PROTECTED] - www.jayezero.com
RE: Exchange Address List
It should be. I did it long ago but can't find the code now... However I used this article at CFCOMET.com to get me started: http://www.cfcomet.com/Exchange_Server/index.cfm?ArticleID=F6CAD377-4023 -4EB0-8C52340ED1DF4263 That actually might be exactly what you need (just all recipients) - the key is CFLDAP. Jim Davis -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 1:34 PM To: CF-Talk Subject: Exchange Address List Is it possible to get the usernames and email address from a local Exchange server using CF? thanks, Luis ~| 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
Anybody up for a non-descript CFMX error?
-Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:32 PM To: CF-Talk Subject: CFMX/SQL Error I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Anybody up for a non-descript CFMX error?
does the first query work? can you do a dump of the first and see correct results? also, what datatype is the column team? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:14 PM To: CF-Talk Subject: Anybody up for a non-descript CFMX error? -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:32 PM To: CF-Talk Subject: CFMX/SQL Error I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| 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
Re: Anybody up for a non-descript CFMX error?
How much description do you want? I bet the problem is with this query: cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery Is users.reviewCurrent a bit field? Or a text field? If it is a bit field use 1 or 0. If it is a text field use 'true' At 02:13 PM 12/5/2002 -0600, you wrote: -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:32 PM To: CF-Talk Subject: CFMX/SQL Error I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| 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
RE: Anybody up for a non-descript CFMX error?
A dump of the first query produces the desired results. The datatype of team in a varChar(30) string. I have taken both queries into Query Analyzer, put the first inside of the second, and the correct results come out. It does not appear that there is anything wrong with the queries, at least from SQL Servers view. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:17 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? does the first query work? can you do a dump of the first and see correct results? also, what datatype is the column team? .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:14 PM To: CF-Talk Subject: Anybody up for a non-descript CFMX error? -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:32 PM To: CF-Talk Subject: CFMX/SQL Error I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Is Coldfusion REALLY multi threaded?
Jason Lees (National Express) wrote: It might not Be CF thats causing the problem, its most likley the DB thats escalating the Lock to a full table lock and thus preventing other users from running the queries until the table is free. Pretty much the only way to get a full table lock in PostgreSQL is to use a LOCK TABLE statement for PostgreSQL uses MVCC (a.k.a. better than row locking). Quite unlikely. Also try moving the DB onto another server, as we had a simular problem, with ingres and moving the CF app to a new server solved the problem. I am more thinking of a unixODBC issue (admittedly, I never was a fan of it). If you have plans to move to CF MX you might want to test if the concurrency is better with JDBC. Jochem ~| 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
SOT: Ending tasks with CF
Is there anyway to end a process or task running on a Win2k machine with CF? Possibly a call to something with cfexecute? Thanks, Scott ~| 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
RE: Anybody up for a non-descript CFMX error?
reviewCurrent is a bit field. I change the query to use 1 instead of true. The same error occurs. As I mentioned on the previous message, I can put both queries (separate or nested) into Query Analyzer and they both work. It does not seem like an SQL error, but the CFMX error is not real clear. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:17 PM To: CF-Talk Subject: Re: Anybody up for a non-descript CFMX error? How much description do you want? I bet the problem is with this query: cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery Is users.reviewCurrent a bit field? Or a text field? If it is a bit field use 1 or 0. If it is a text field use 'true' At 02:13 PM 12/5/2002 -0600, you wrote: -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:32 PM To: CF-Talk Subject: CFMX/SQL Error I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Anybody up for a non-descript CFMX error?
WHERE users.reviewCurrent = true I wonder if cfmx is choking on this line, have you put true in single quotes ? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:25 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? A dump of the first query produces the desired results. The datatype of team in a varChar(30) string. I have taken both queries into Query Analyzer, put the first inside of the second, and the correct results come out. It does not appear that there is anything wrong with the queries, at least from SQL Servers view. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:17 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? does the first query work? can you do a dump of the first and see correct results? also, what datatype is the column team? tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:14 PM To: CF-Talk Subject: Anybody up for a non-descript CFMX error? -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:32 PM To: CF-Talk Subject: CFMX/SQL Error I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: SOT: Ending tasks with CF
Scott Mulholland wrote: Is there anyway to end a process or task running on a Win2k machine with CF? Possibly a call to something with cfexecute? use kill.exe from the Windows 2000 Resource Kit. Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: MX Hosting
Delaware.net can give you your own CFMX server for what some companies charge for shared hosting. Craig Thomas wrote: Rob, I have had a couple CFMX sites with www.hostmysite.com for almost a year now and it's been a wonderful experience so far, and fairly cheap Are you using shared hosting? if so, that is odd, as when I inquired about their CFMX hosting I was told they did not allow cfobject (presumably createObject as well) and that (their) CFMX was unstable in a shared hosting environment. -Craig ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: MX Hosting
Delaware.net can give you your own CFMX server for what some companies charge for shared hosting. Funny how all three references are in the Delaware area. :) Craig Thomas wrote: Rob, I have had a couple CFMX sites with www.hostmysite.com for almost a year now and it's been a wonderful experience so far, and fairly cheap Are you using shared hosting? if so, that is odd, as when I inquired about their CFMX hosting I was told they did not allow cfobject (presumably createObject as well) and that (their) CFMX was unstable in a shared hosting environment. -Craig ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Anybody up for a non-descript CFMX error?
Are you using the ODBC Bridge or the other drivers? At 02:27 PM 12/5/2002 -0600, you wrote: reviewCurrent is a bit field. I change the query to use 1 instead of true. The same error occurs. As I mentioned on the previous message, I can put both queries (separate or nested) into Query Analyzer and they both work. It does not seem like an SQL error, but the CFMX error is not real clear. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:17 PM To: CF-Talk Subject: Re: Anybody up for a non-descript CFMX error? How much description do you want? I bet the problem is with this query: cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery Is users.reviewCurrent a bit field? Or a text field? If it is a bit field use 1 or 0. If it is a text field use 'true' At 02:13 PM 12/5/2002 -0600, you wrote: -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:32 PM To: CF-Talk Subject: CFMX/SQL Error I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way that it was designed. -- Error line number indicates closing /cfquery tag on second query -- - CFMX / SQL Code - cfquery name=summaryInfo datasource=#request.dsn# SELECT systems.systemName, users.userID, users.name AS userName, users.team, users.approval, users.comments FROM systems INNER JOIN users ON systems.ownerID = users.userID WHERE users.reviewCurrent = true GROUP BY users.team, users.userID, users.name, systems.systemName, users.approval, users.comments ORDER BY users.team, users.name, systems.systemName /cfquery cfquery name=userList dbtype=query SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: MX Hosting
Is that all that DMV has?Wow, that is surprising. They are a bigger company than us and we have more servers than that. Delaware.net can give you your own CFMX server for what some companies charge for shared hosting. E-mail me off-list for info. Funny how all three references are in the Delaware area. :) Cutter (CF_Talk) wrote: http://www.dmv.com (Delmarva Online) currently has 2 CFMX Servers (Linux) with either SQL or mySQL support. Cutter Robert Bailey wrote: ~| 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.