PATH_INFO missing in CF 11
Has anyone run into and issue with IIS7.5 CF11 Update 3 with a dump of cgi missing the path_info? I have 2 4 servers all showing the same behavior... Anyone seen this? I know it was an issue in early CF 10 but not 11. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
PATH_INFO missing in CF 11
Has anyone noticed that cgi.PATH_INFO is missing in CF 11. We are working to upgrade from 9 to 11 and use PATH_INFO in various places.. Is this a known issue? Any ideas on how to remedy it? thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf11 and Tomcat Datasources
Is possible to configure a data-source in Tomcat and have it visible to the CF11 instance? If so how? I have tried following the Tomcat doc but continue to run into this error: DAOException: Naming Exception while looking up DataSource Connection mydb: Name [mydb] is not bound in this Context. Unable to find [mydb]. Anyone know how to do this? Thank you in advance! You could try this and call the necessary methods such as password ,username, etc. cfset obj = CreateObject(java, org.apache.tomcat.jdbc.pool.DataSourceProxy) cfdump var = #obj# Yes but how do I add the datasource at the Tomcat level first? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf11 and Tomcat Datasources
Is possible to configure a data-source in Tomcat and have it visible to the CF11 instance? If so how? I have tried following the Tomcat doc but continue to run into this error: DAOException: Naming Exception while looking up DataSource Connection mydb: Name [mydb] is not bound in this Context. Unable to find [mydb]. Anyone know how to do this? Thank you in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMX 10 cluster question
Yes there would be a load balancer in front. Alex Sent from my Verizon Wireless 4G LTE Smartphone Original message From: Carl Meyer ca...@tassweb.com.au Date: 11/04/2013 11:39 PM (GMT-05:00) To: cf-talk cf-talk@houseoffusion.com Subject: Re: CFMX 10 cluster question Hi Alex, That all makes sense. What tho about users browsing to IIS, will they URL to one or the other or both somehow via a load balancer? Regards, Carl. - On BOX1 connect IIS to the local cluster - On BOX2 connect IIS to the local cluster Does this sound correct? Is there anything I overlooked? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFMX 10 cluster question
I am finally getting ready to jump on the CFMX10 cluster bandwagon. However, I have a question to which I think I know the answer but figured I would check here. In my sandbox setup I have 2 IIs 7.5 servers with CFM 10 installed and 1 CFMX instance defined on each server. To make clustering really work I think I need to do the following: - On BOX1 remote register BOX2's CFMX instance - On BOX2 remote register BOX1's CFMX instance - On BOX1 create a cluster with both the local cfmx instance and the remote registered instance from BOX2 - On BOX2 create a cluster with both the local cfmx instance and the remote registered instance from BOX1 - On BOX1 connect IIS to the local cluster - On BOX2 connect IIS to the local cluster Does this sound correct? Is there anything I overlooked? Thanks! - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Question about session management
Just a quick follow up If I set the sessiontimeout=5 (not using the createtimespan function) Is that 5 days? - Alex -Original Message- From: DeMarco, Alex [mailto:alex.dema...@suny.edu] Sent: Thursday, July 18, 2013 8:31 PM To: cf-talk Subject: Re: Question about session management Ahh okay thank you! - Alex Original message From: Dave Watts dwa...@figleaf.com Date: 07/18/2013 8:29 PM (GMT-05:00) To: cf-talk cf-talk@houseoffusion.com Subject: Re: Question about session management If I have a path: /inetpub/myapp In /myapp I have an application .cfm in it has a application name of MYAPPNAME with a sessiontimeout of 30 minutes But in /inetpub/myapp/login I have another application.cfm with an application name of MYAPPNAME with a sessiontimeout of 30 minutes Will CFMX create 2 sessions per visitor? No, because both directories' Application.cfm files contain the same application name. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Question about session management
I am a bit out of practice with regards to session management. If I have a path: /inetpub/myapp In /myapp I have an application .cfm in it has a application name of MYAPPNAME with a sessiontimeout of 30 minutes But in /inetpub/myapp/login I have another application.cfm with an application name of MYAPPNAME with a sessiontimeout of 30 minutes Will CFMX create 2 sessions per visitor? (I hope I explained this correctly) Thanks for the help. [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebookhttp://www.facebook.com/generationsuny - Twitterhttp://www.twitter.com/generationsuny - YouTubehttp://www.youtube.com/generationsuny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question about session management
Ahh okay thank you! - Alex Original message From: Dave Watts dwa...@figleaf.com Date: 07/18/2013 8:29 PM (GMT-05:00) To: cf-talk cf-talk@houseoffusion.com Subject: Re: Question about session management If I have a path: /inetpub/myapp In /myapp I have an application .cfm in it has a application name of MYAPPNAME with a sessiontimeout of 30 minutes But in /inetpub/myapp/login I have another application.cfm with an application name of MYAPPNAME with a sessiontimeout of 30 minutes Will CFMX create 2 sessions per visitor? No, because both directories' Application.cfm files contain the same application name. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Validation Query Question
I have a question regarding Validation Query: The CF 9 online help says this about the Validation Query: Called when a connection from the pool is reused. This can slow query response time because an additional query is generated. You should specify this just before restarting the database to verify all connections, but remove the validation query after restarting the database to avoid any performance loss. If you are pointing to an Oracle RAC Cluster containing 2 nodes and want to ensure that the RAC node the connection is currently bound to is viable doesn't it make sense to leave the validation query in place? (select 1 from dual;) regardless of the small performance hit I would rather prefer that my connection is viable. What is everyone's opinion on this? Thank you in advance. [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebookhttp://www.facebook.com/generationsuny - Twitterhttp://www.twitter.com/generationsuny - YouTubehttp://www.youtube.com/generationsuny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Clear out webservices?
Is there any way to automatically clear out the webservices listed in the CF Admin every time the instance restarts? [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebookhttp://www.facebook.com/generationsuny - Twitterhttp://www.twitter.com/generationsuny - YouTubehttp://www.youtube.com/generationsuny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to deal with outbound http calls
Good Morning, I have a web app that at times can make many outbound http calls. For example I have a page that collects various rss feeds from other sites and then parses them and finally displays them all on one page for the user. I have a few questions.: Is there a limit to the number of outbound http calls CFMX 9 can make? Is there a way I can see the total number of outbound http calls going on? It would seem to me that this is a poor design under load conditions. Is there a better way to fetch off site content? Thanks! [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebookhttp://www.facebook.com/generationsuny - Twitterhttp://www.twitter.com/generationsuny - YouTubehttp://www.youtube.com/generationsuny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to deal with outbound http calls
Yes this is happening real time. Unfortunately I cannot make code changes only advise those who can. Thanks for all the comments! - Alex -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Sunday, November 18, 2012 4:43 PM To: cf-talk Subject: Re: How to deal with outbound http calls On Sun, Nov 18, 2012 at 7:48 AM, DeMarco, Alex alex.dema...@suny.eduwrote: I have a web app that at times can make many outbound http calls. For example I have a page that collects various rss feeds from other sites and then parses them and finally displays them all on one page for the user. I have a few questions.: Is there a limit to the number of outbound http calls CFMX 9 can make? Assuming you aren't in a cluster, some creative use of CFLOCK would do the trick. If you aren't familiar with CFLOCK, check the documentation. You could also reduce the number of threads as Russ suggests, however I would recommend putting some code in place to do something when that max is reached or else you're just creating a new problem from the old one. Is there a way I can see the total number of outbound http calls going on? Outside of CF there would be a number of network monitoring tools you could use for this. You could also do some creative application or session scope monitoring of start and stop counts for certain activities. It would seem to me that this is a poor design under load conditions. Is there a better way to fetch off site content? Are you doing it in realtime when a user's requests a page? Yes, that is poor design. Try loading the content using a background process of some sort (ie: scheduled task) and then staging it all in a table. That way when the user requests the page you aren't triggering a bunch of CFHTTP calls. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Another wierd set of errors
) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doAfterBody(ModuleTag.java:352) at cfTemplateNotFoundException2ecfm1529355848.runPage(D:\JRun4\servers\swis\cfusion.ear\cfusion.war\WEB-INF\exception\coldfusion\runtime\TemplateNotFoundException.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ExceptionFilter.runBuiltInHandler(ExceptionFilter.java:552) at coldfusion.filter.ExceptionFilter.handleException(ExceptionFilter.java:329) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:84) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) 11/18 13:55:23 metrics Web threads (busy/total): 0/45 Sessions: 454 Total Memory=1013184 Free=692749 11/18 13:56:23 metrics Web threads (busy/total): 0/45 Sessions: 428 Total Memory=1013824 Free=636685 11/18 13:57:23 metrics Web threads (busy/total): 0/45 Sessions: 434 Total Memory=1006528 Free=541946 11/18 13:58:23 metrics Web threads (busy/total): 0/45 Sessions: 424 Total Memory=1010176 Free=624022 11/18 13:59:23 metrics Web threads (busy/total): 0/45 Sessions: 420 Total Memory=1008448 Free=635953 11/18 14:00:23 metrics Web threads (busy/total): 0/7 Sessions: 408 Total Memory=1010048 Free=625564 11/18 14:01:23 metrics Web threads (busy/total): 0/5 Sessions: 401 Total Memory=1010048 Free=603398 11/18 14:02:23 metrics Web threads (busy/total): 0/5 Sessions: 389 Total Memory=1013504 Free=673673 11/18 14:03:23 metrics Web threads (busy/total): 1/5 Sessions: 379 Total Memory=1014592 Free=708086 11/18 14:04:23 metrics Web threads (busy/total): 0/5 Sessions: 378 Total Memory=1015296 Free=696575 [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebookhttp://www.facebook.com/generationsuny - Twitterhttp://www.twitter.com/generationsuny - YouTubehttp://www.youtube.com/generationsuny ~| Order the Adobe
iis7.5 connector question
Hello All, I was reviewing this page: http://blogs.adobe.com/cfdoc/tag/coldfusion-9 Specifically the section about increasing worker threads.. My question is that I have using IIS7.5 (no iis6 compat mode installed) yet my connector files are all jrun_iis6_wildcard I dropped all my connections and redid them and they are still jrun_ii6 .. is this correct?? Everything seems to work I am just concerned that it is wrong... Thanks! [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebookhttp://www.facebook.com/generationsuny - Twitterhttp://www.twitter.com/generationsuny - YouTubehttp://www.youtube.com/generationsuny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: iis7.5 connector question
Ok phew.. thanks! -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, November 16, 2012 7:53 PM To: cf-talk Subject: Re: iis7.5 connector question It is the correct connector, for some Bizzare reason Adobe never changed the filename to jrun_IIS7_wildcard, which clearly does cause some confusion. On Sat, Nov 17, 2012 at 12:42 AM, DeMarco, Alex alex.dema...@suny.eduwrote: Hello All, I was reviewing this page: http://blogs.adobe.com/cfdoc/tag/coldfusion-9 Specifically the section about increasing worker threads.. My question is that I have using IIS7.5 (no iis6 compat mode installed) yet my connector files are all jrun_iis6_wildcard I dropped all my connections and redid them and they are still jrun_ii6 .. is this correct?? Everything seems to work I am just concerned that it is wrong... Thanks! [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebook http://www.facebook.com/generationsuny - Twitter http://www.twitter.com/generationsuny - YouTube http://www.youtube.com/generationsuny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Disable Jrun isapi mapping on Virt directory
We have an IIS 7.5 with both CFMX 9 and Weblogic AppServer plugin. When I call www.myurl.com/myappvirtualdirectory/somefile.jsp the Jrun Server is trying to process the requset instead of letting WebLogic do it. ANyone know how on a virtual directoy level to stop Jrun from processing requests? In II6 is was easy I can't figure it out in 7.5 thanks in advance. - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Disable Jrun isapi mapping on Virt directory
Thanks for the quick reply... Is it as simple and just going in and pointing to jrun_iis.dll for all the entries that use the wildcard one? - Alex -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, October 18, 2012 9:20 AM To: cf-talk Subject: Re: Disable Jrun isapi mapping on Virt directory what you need to do is remove the ColdFusion WILDCARD handler, as this is what is processing your jsp pages and overriding your weblogic JSP handler. just use a standard handler for .cfm pages On Thu, Oct 18, 2012 at 2:14 PM, Alex DeMarco alex.dema...@suny.edu wrote: We have an IIS 7.5 with both CFMX 9 and Weblogic AppServer plugin. When I call www.myurl.com/myappvirtualdirectory/somefile.jsp the Jrun Server is trying to process the requset instead of letting WebLogic do it. ANyone know how on a virtual directoy level to stop Jrun from processing requests? In II6 is was easy I can't figure it out in 7.5 thanks in advance. - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Disable Jrun isapi mapping on Virt directory
Understood! Thanks! -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, October 18, 2012 9:36 AM To: cf-talk Subject: Re: Disable Jrun isapi mapping on Virt directory no you need to actually remove the WILDCARD handler completely otherwise this will still process JSP pages. If you are using a bog standard install, then you will have 2 type sof handlers setup. the wildcard handler, which points to jrun_iis6_wildcard.dll, this processes every single request to see if it is a CF or JSP file and if so passes it off to coldfusion. This is most likley your problem. DELETE this one from the site in question. And you also probably a bunch of regular handlers for each file extension which point to jrun_iis6.dll jrun_iis6.dll don't even work and have not worked on any server I have setup for years, so no idea why they even get created, So just edit the regular handlers and set them to use jrun_iis6_wildcard.dll If they don't exist already then just create one for each extension you need CF to process. Presumably you have already mapped the .jsp handler to weblogic. On Thu, Oct 18, 2012 at 2:27 PM, DeMarco, Alex alex.dema...@suny.eduwrote: Thanks for the quick reply... Is it as simple and just going in and pointing to jrun_iis.dll for all the entries that use the wildcard one? - Alex -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, October 18, 2012 9:20 AM To: cf-talk Subject: Re: Disable Jrun isapi mapping on Virt directory what you need to do is remove the ColdFusion WILDCARD handler, as this is what is processing your jsp pages and overriding your weblogic JSP handler. just use a standard handler for .cfm pages On Thu, Oct 18, 2012 at 2:14 PM, Alex DeMarco alex.dema...@suny.edu wrote: We have an IIS 7.5 with both CFMX 9 and Weblogic AppServer plugin. When I call www.myurl.com/myappvirtualdirectory/somefile.jsp the Jrun Server is trying to process the requset instead of letting WebLogic do it. ANyone know how on a virtual directoy level to stop Jrun from processing requests? In II6 is was easy I can't figure it out in 7.5 thanks in advance. - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue with decrypt in CFMX 9.01
I had an old app running on CFMX 9 32bit on Win 2003, We recently started testing it on CFMX 9.01 (fully patched) Windows 2008 r2 64bit. We are getting this error: An error occurred while trying to encrypt or decrypt your input string: The input and output encodings are not same.. I do understand what the error means however, I do not understand why it is happening with all things relatively equal between the old and new server. Does CFMX 9.01 handle encryption of cookies differently than 9 did? Here is the snippet that is failing: CFSET UserInfo = Decrypt(Cookie.pwdEncryptedID, Attributes.ENCRYPTKEY) Any ideas or suggestions are appreciated. Thanks! - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
problem with ajax on cflayout form submission
Hi everybody have this cflayout name=tabtest type=tab cflayoutarea name=tab1 title=Data SJ source=tab1.cfm /cflayoutarea cflayoutarea name=tab2 title=Dati Personali source=personshowTab2.cfm !--- cfinclude template=personshowTab2.cfm --- /cflayoutarea cflayoutarea name=tab3 title=Storia in SJ cfinclude template=personshowTab3.cfm /cflayoutarea ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with ajax on cflayout form submission
Yes steve sorry my question here is on the cflayoutarea2 tab 2 is a form that submits on an action page after it executes it goes back to the calling form from the tab but doesn't show the the updated form.. just blank even if I use the javascript below after the action query script type=text/javascript ColdFusion.Layout.hideTab('tabtest', 'tab2'); ColdFusion.Layout.showTab('tabtest', 'tab2'); ColdFusion.Layout.selectTab('tabtest', 'tab2'); /script Alex, Did you intend to include more here? Not seeing a question First peek, there's no closing cflayout tag, your 3rd tab should use the 'source' attribute, like your others, for consistency, and it appears that your code formatting is way off. Something like: cflayout name=tabtest type=tab cflayoutarea name=tab1 title=Data SJ source=tab1.cfm/cflayoutarea cflayoutarea name=tab2 title=Dati Personali source=personshowTab2.cfm/cflayoutarea cflayoutarea name=tab3 title=Storia in SJ source=personshowTab3.cfm/cflayoutarea /cflayout Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 9/6/2012 6:01 AM, alex poyaoan wrote: Hi everybody have this cflayout name=tabtest type=tab cflayoutarea name=tab1 title=Data SJ source=tab1.cfm /cflayoutarea cflayoutarea name=tab2 title=Dati Personali source=personshowTab2.cfm !--- cfinclude template=personshowTab2.cfm --- /cflayoutarea cflayoutarea name=tab3 title=Storia in SJ cfinclude template=personshowTab3.cfm /cflayoutarea ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 on Win2k8R2 64bit no more connectivity
What version of windows? Standard Is this a hosted server? No in house server(s), dedicated Both of our web servers are behind a F5BigIP device and then behind a set of ASA 5540s What type of internet connectivity? Multiple T-1's No Cpu or mem spike when the issue is occurring. When the issue is happening I can rdp in but can't get to anything outside of the box, telnet, ping, web, ssh. Unfortunately I've had to fall back to our older IIS 6 boxes so I do not have a current netstat to show you. There were a lot of TIME_WAIT's When the issue was happening and I run this netstat -n | find : /c the number hits around 3000, but fluctuates. It's like connections are not being released fast enough. This is my first usage of 2k8 with IIS7.5 is there tweaking to the IP stack that is need for iis 7.5? Thanks for replying.. - Alex -Original Message- From: Byron Mann [mailto:byronos...@gmail.com] Sent: Wednesday, July 25, 2012 8:38 AM To: cf-talk Subject: Re: CF9 on Win2k8R2 64bit no more connectivity What version of windows? Standard, web, enterpsirse? Is this a hosted server? Dedicated, VM? Any issues with servers one the same switch? Is there an outbound firewall? If so, what brand /model? What type of internet connectivity? And yes, if you can post the netstat results that will help. Also a tracert from the server as well during this event. I take it if you can login and do stuff on the server this isn't a cpu issue. Byron Mann Lead Engineer and Architect Hostmysite.com On Jul 24, 2012 4:54 PM, Alex DeMarco alex.dema...@suny.edu wrote: Has anyone ever run into an issue where their server consumes all tcpip connections? Basically, when our server ramps up during the day cfmx is no longer to make any out bound connections to our database our mailserver. If I open IE on the box I can't get an external webpage to come up. THe only way I can solve the issue is to reboot the box. Is this ringing any bells for anyone? Thanks in advance - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 on Win2k8R2 64bit no more connectivity
I working to create a load test on the server to try and reproduce the issue. I have 6 of them all exhibit the same issue. I am pretty certain they are not compromised. I already had an established RDP connectoin when the issue was going on, but will test that if I can reproduce the issue. Getting a repoduceable scenario is key.. I'll post again once I get that to happen. There are 2 nic's both bound to the same network. thanks for the feedback - Alex From: Byron Mann [mailto:byronos...@gmail.com] Sent: Wed 7/25/2012 5:58 PM To: cf-talk Subject: Re: CF9 on Win2k8R2 64bit no more connectivity A tracert to an external IP is going to tell you where things are stopping. 3000 connections doesn't really sound all that high. Even with ones lingering. But I would ask do you know what those 300 connections are? Any possibility the machine is compromised, and something like a bot is saturating the network connection. The most strange part is you can RDP while this is occurring. If limitations are being hit then I doubt you'd be able to RDP in. Is there more than one NIC? If you are RDP'ing via an internal NIC, which by-passes the firewall and an external NIC exists, then I can see you being able to RDP in, but not get out on through an external NIC if it's being saturated somehow, or the firewall is hitting a session limit. ~Byron On Wed, Jul 25, 2012 at 11:09 AM, DeMarco, Alex alex.dema...@suny.edu wrote: What version of windows? Standard Is this a hosted server? No in house server(s), dedicated Both of our web servers are behind a F5BigIP device and then behind a set of ASA 5540s What type of internet connectivity? Multiple T-1's No Cpu or mem spike when the issue is occurring. When the issue is happening I can rdp in but can't get to anything outside of the box, telnet, ping, web, ssh. Unfortunately I've had to fall back to our older IIS 6 boxes so I do not have a current netstat to show you. There were a lot of TIME_WAIT's When the issue was happening and I run this netstat -n | find : /c the number hits around 3000, but fluctuates. It's like connections are not being released fast enough. This is my first usage of 2k8 with IIS7.5 is there tweaking to the IP stack that is need for iis 7.5? Thanks for replying.. - Alex -Original Message- From: Byron Mann [mailto:byronos...@gmail.com] Sent: Wednesday, July 25, 2012 8:38 AM To: cf-talk Subject: Re: CF9 on Win2k8R2 64bit no more connectivity What version of windows? Standard, web, enterpsirse? Is this a hosted server? Dedicated, VM? Any issues with servers one the same switch? Is there an outbound firewall? If so, what brand /model? What type of internet connectivity? And yes, if you can post the netstat results that will help. Also a tracert from the server as well during this event. I take it if you can login and do stuff on the server this isn't a cpu issue. Byron Mann Lead Engineer and Architect Hostmysite.com On Jul 24, 2012 4:54 PM, Alex DeMarco alex.dema...@suny.edu wrote: Has anyone ever run into an issue where their server consumes all tcpip connections? Basically, when our server ramps up during the day cfmx is no longer to make any out bound connections to our database our mailserver. If I open IE on the box I can't get an external webpage to come up. THe only way I can solve the issue is to reboot the box. Is this ringing any bells for anyone? Thanks in advance - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351999 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 on Win2k8R2 64bit no more connectivity
Has anyone ever run into an issue where their server consumes all tcpip connections? Basically, when our server ramps up during the day cfmx is no longer to make any out bound connections to our database our mailserver. If I open IE on the box I can't get an external webpage to come up. THe only way I can solve the issue is to reboot the box. Is this ringing any bells for anyone? Thanks in advance - Alex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351978 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Help with CF file upload display
I'm using CF 9 and have multi-file uploading working. What I need help with is a help desk type page that will display the filenames with links to the files that are uploaded with the form that a user submits. When I view an admin page, I need to see the email form results with a list of the files uploaded and links to where they are. Any ideas on how I can get an admin page to display only the files associated with each form submission? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Strange, strange CFC Error: Null Pointer
I've experienced this error after upgrading MySQL from 4 to 5 I've put together this small article on how to temporarily fix it until a hot fix is released from Adobe: http://www.thebluepipe.com/Developer/tutorials/coldfusion/coldfusion-m ysql-5-fix ing-the-system-has-attempted.html hope it helps d I am getting the strangest CFC error on the code below (and all cfc's I have on this site). They work in development but not in production. Any ideas what is going on? ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: other companies and developers to watch out for
Hello, Bull_hit. I have been working with Adam (Colony One) for more than 5 years. He is tough on negotiations, but once agreement is in place and as long as one follows his part of the agreement, Adam will follow his part. I don't know anything about other guys you list here, as I didn't work with them, but I suspect that (as in Adam's case) God made them to crucify you. Wednesday, February 2, 2011, 2:07:44 AM, you wrote: man I ve accepted the fact that I will not probably get another job man from this list so you know what who cares. man So i might as well empty the closet on all those who I think man have done a lot of damage to our career field. man companies and developers to watch out for man mediaspa - for whatever reason if you get on their bad side watch out man colony1 - i ve added mr. adams company because he made an man attempt at trying to crucify me in apublic arena. i man tried apologizing to no avail. i have also worked for adam in man the past. i always thought we parted ways on a good note. guess man i was wrong. talk about grudges. man topofmind - this is an atlanta company that asked to interview man twice then said we change our minds even though they told me they man were going to hire me. heck i tried apologizing too even though they wronged me. oh well. man elliot kayne - another gentleman that said he would hire me then man backed out. wish you guys would make up your mind. by the way man he runs onlinecorp.com and quickcart.com. watch out he will string you along too. man superwarehouse.com - rand will talk to you but wont return your man emails once hes made up his mind. man ken fergurson - wow . an oldie but goodie. even had a few man people asked about him. hope you didnt ruin your career either. man maureen with a gmail address - another attempt at crucifying me. man seems like a double standard here. you tell me i am disturbing man you but you call me out in public too. man I do want to thank the gentleman at Adobe who will remain man nameless for the free copy of cfbuilder. Alas it wasn't meant to man be. I do think there are more good people than bad, but the bad do leave an odor. man So anyone who may have a question regarding the above I will man give my perspective. I know i also hear from some of you but I man dont really care because lets face i wont get a job from here and man to be honest i dont think i want one. man Mike Firth man ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4432 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
problem on inserting null when option value is selected
Hi Everybody have this situation where I have a cfselect listed below with an added OPTION to display Please select province and a the list of provinces generated from a query which displays on the dropdown using the attribute QueryPosition=below. On the selected attribute the real value from the database should show from the query getdetails using #GetDetails.ProvID# which is ok. The problem now is when a value from the GetProvinces query is select all would be fine but when the added option with a blank value is select it stores the string Please select province on the database. How could I insert a null value when that is selected? CFSELECT NAME=TransProv Label=Transferred province QueryPosition=below query=GetProvinces value=ProvID display=provname selected=#GetDetails.ProvID# option value=Please select province/option /CFSELECT this is the action query to update the table cfquery name=UpdateSoc datasource=socs UPDATE Soc SET TransProv='#form.TransProv#' WHERE ID=100 /cfquery Thanks for any help alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / Hi I tried both your solutions but this time it inserts the quotes which is the value of the option and not a null value. Is there something wrong with my code? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332630 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Yes I tried it a couple of times but it still inserts the quotes. I tried a workaround which worked fine.. I inserted a value=1 to the blank option of the cfselect and did a cfif on the update query the code is listed below CFSELECT NAME=TransProv Label=Transferred province QueryPosition=below query=GetProvinces value=ProvID display=provname selected=#GetDetails.ProvID# option value=1Please select province/option /CFSELECT and here is the UPDATE QUERY. cfquery name=UpdateSoc datasource=socs UPDATE Soc SET TransProv=cfif (form.TransProv)neq 1'#form.TransProv#'cfelseNULL/cfif WHERE ID=100 /cfquery Thanks all for your help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfselect display problem
Thanks that did the trick!!! cfselect has SELECTED attribute - give it a variable that holds the value that should be selected. i.e. if you had selectedGroupID var that held the current GroupID value, you would use: cfselect ... selected=#selectedGroupID# for a multi-select you can provide a comma-delimited list of values that should be pre-selected. Azadi On 01/04/2010 16:46, alex poyaoan wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfselect display problem
Hi Everybody... Have this situation wherein I have to display lsit from a query on a cfselect on enter mode which is OK with the cfselect listed below, but should display the real value of the GroupID from the database on edit mode cfselect query=getAll display=name value=GroupID /cfselect thanks for any help alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Interesting dir listed in error output.
This is coming from CFMX 9.. at cfsavecontent2ecfm1472308084.runPage(E:\cf9_final\cfusion\wwwroot\WEB-IN F\cftags\savecontent.cfm:11) Our CFMX 9 is a prod build, we never had this on an E:\ drive... Strange.. - Alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
problem with a condition cfif in a cfquery
HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with a condition cfif in a cfquery
Got it I just forgot placing quotes on the (emailaddr1) on the cfif statement and now it works... thanks anyway HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with a condition cfif in a cfquery
HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with a condition cfif in a cfquery
THANKS DAVE THAT SOLVED IT!!! Alex, You can't use a CF condition within your SQL that you want to evaluate each record in the query. For that, you'd need to use an SQL condition. You could use CF conditions inside your cfquery only to evaluate the 'text' of the query (like to decide WHICH SQL statement to use for example based on values that exist apart from your data). You can use a 'isnull' function to solve this (this is a DATABASE function, not a CF function, and is, therefore, DB dependent). I'm not sure which DB you are using, but for SQL Server it's isnull. For Oracle it's NVL. cfquery name=recipients datasource=labels SELECT isNull(emailaddr1,emailaddr2) as emailaddr ... /cfquery This says, if emailaddr1 has a value, then return it as 'emailaddr', but if it is null, then return the value in emailaddr as 'emailaddr'. If emailaddr2 is also null, then 'emailaddr2' will be null. If you want another default value such as 'N/A', then you would just wrap it all with another function like this: SELECT isNull(isNull(emailaddr1,emailaddr2),'N/A') as emailaddr Hope this helps! Dave Phillips HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
adding ip address to email body
Is there any way to get the cfmail tag to automatically include the submittors IP address? I realize if can be done programaticaly within the cfmail tag, but was looking for server based solution. Can the tag be hacked to include the ipaddress? This would be for CFMX 8 and 9. - Alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329025 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfinvoke vs creatobject
I'm having a heck of a time trying to figure this out. The code below works great when I use createObject, but it doesn't when I use cfinvoke. The reason I want to use cfinvoke is that it takes a while for it to return the data, and I can set a timeout on the cfinvoke (and I can't when I use createObject). When I use the CFInvoke, I get the Web service operation runXS with parameters... error. Any ideas? !--- Set WSDL Location --- cfset wsdlUrl = http://examplecom/sample.wsdl; !--- Set Parameters --- cfset selectArray = arrayNew(1) cfset selectArray[1] = '01/01/09' cfset selectArray[2] = '02/01/09' cfset selectArray[3] = 'EXAMPLE' cfset argsXS = structNew() cfscript argsXS.method = 'SELECT'; argsXS.data = selectArray; argsXS.version = ''; argsXS.result = ''; /cfscript cfset selectDTO = structNew() cfscript selectDTO.args = argsXS; selectDTO.connString = ; selectDTO.userName = ; selectDTO.password = ; /cfscript !--- Method #1: Works Great! --- cfset myWS = createObject(webservice, #wsdlUrl#) cfset selectResponse = myWS.runXS( selectDTO ) !--- Method #2: Doesn't Work :-( --- cfinvoke method=runXS returnvariable=selectResponse argumentcollection=#selectDTO# webservice=#wsdlUrl# /cfinvoke Thanks! Alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with the output
Hi all am using cfmx7 and got a problem with the output of an ntext field.. On the database all of the data is there but on my cfoutput even on a cfdump it truncates the output.. the lenght of the data is 32223 characters with spaces... is there a limit on the cfoutput of ntext fields? thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with the output
Thanks a lot Dave that got my outputs going... Hi all am using cfmx7 and got a problem with the output of an ntext field.. On the database all of the data is there but on my cfoutput even on a cfdump it truncates the output.. the lenght of the data is 32223 characters with spaces... is there a limit on the cfoutput of ntext fields? You must configure your datasource to allow the selection of the entire CLOB/BLOB field. Read the documentation to learn the details: http://livedocs.adobe. com/coldfusion/8/htmldocs/datasources_ADV_MJS_11.html#1278307 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
creating variables from a query problem
HI everybody,, Am stucked... I have a query with 9 rows. I need to store every row into a different distinct variable. my query is listed below cfquery name=getcs datasource=#datasource# SELECT COUNT(s.id) AS cscount FROMSociety s WHERE s.gr='cs' group by s.asst /cfquery cfoutput query=getcs startrow=1 maxrows=1 cfset row1=cscount /cfoutput cfoutput query=getcs startrow=2 maxrows=2 cfset row2=cscpimt /cfquery etc row9 I have to repeat the above code 9 times which is equivalent to the rows of my query...Is there a way of not doing this?.. thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: creating variables from a query problem
Thanks will do that then I need to store every row into a different distinct variable. You probably don't, and should instead be using an array. MyValues = ListToArray( ValueList( MyQuery.ColumnName ) ) Then you can do MyValues[1] to MyValues[9] to get at the variables. If you *really* need to create individual variables, you can then do: cfloop index=i from=1 to=#ArrayLen(MyValues)# cfset Variables['MyVariable#i#'] = MyValues[i] / /cfloop But don't do that - use the array. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem when modifying dates
Hi everybody.. Have a problem when i modify a date on a cfinput cfinput NAME=DateEnd TYPE=TEXT Value=#DateFormat(Getall.DateEnd, dd/mm/)# validate=eurodate width=150 I have a validate eurodate.. example I have a date that i should modify 20/01/2009 to 10/01/2009 (january 10, 2009) when i input it in the database and if the day is 12 and below it flips the day and month so it becomes 01/10/2009 (October 1, 2009) is there a way that it would stay as a eurodate? thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem when modifying dates
I tried it and it works fine but is it possible to type only the mmdd without dashes? On Thu, May 28, 2009 at 12:23 PM, alex poyaoan ap.cli...@tiscali.it wrote: cfinput NAME=DateEnd TYPE=TEXT Value=#DateFormat(Getall.DateEnd, dd/mm/)# validate=eurodate width=150 always insert dates in the following format... -mm-dd ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfmail validation
HI everybody am using cfmail with the code below.. my problem is with the query that get's all email addresses. If an email address is valid it goes if at one point emailaddress is not valid it gives an error. is there a way with my code to test valid email addresses or better then if there is a way that i could check which emails just went thru or not? CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=NO CFMAIL QUERY=GetList SERVER=cbox.cbox.org SUBJECT=subject FROM=press service i...@info.org TO=#Trim(Name)# #Trim(Fname)# #Trim(emailaddr)# TYPE=HTML cfinclude template=pubSSMailDesign.cfm /CFMAIL /CFPROCESSINGDIRECTIVE thanks for any help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmail validation
thanks will try this out... isValid(email, emailaddr) will tell you if it's a correctly formed email address, but not if it actually exists. This udf will check that a mailbox exists. Haven't tried it myself yet: http://cflib.org/udf/verifyEmail HI everybody am using cfmail with the code below.. my problem is with the query that get's all email addresses. If an email address is valid it goes if at one point emailaddress is not valid it gives an error. is there a way with my code to test valid email addresses or better then if there is a way that i could check which emails just went thru or not? CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=NO CFMAILQUERY=GetList SERVER=cbox.cbox.org SUBJECT=subject FROM=press service i...@info.org TO=#Trim(Name)# #Trim(Fname)# #Trim(emailaddr)# TYPE=HTML cfinclude template=pubSSMailDesign.cfm /CFMAIL /CFPROCESSINGDIRECTIVE thanks for any help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
inserting datetime
HI everybody have this problem and could't get over it.. I have a flash form that insert date on an mssql 2000 db the format that is on the db field is dd/mm/... I display the date on a form and it displays right without doing anything and press ok on the form it flips the day and month ex 01/02/2009 (feb 1 2009) now is 02/01/2009 the insert statementi is CREATEODBCDATE(FIELDNAME) AND THE UPDATE IS THE SAME.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: inserting datetime
thanks will try this... When you use CreateODBCDate and pass in a string it will first try to convert it to a date using the US format of mm/dd/, and only if that fails will it try the rest-of-the-world format of dd/mm/. The same goes for some of the other CF date functions. So 12/13/2009 and 13/12/2009 will both get converted to 13th Dec 2009. :| IMO, the safest way to deal with dates coming in as strings (e.g. from forms etc) is to convert them to CF dateobjects using CreateDate as soon as you can using something like the following, though the error handling would obviously do something more friendly than just abort. cftry cfset myDateObject = CreateDate(ListGetAt(form.dateString, 3, '/'), ListGetAt(form.date, 2, '/'), ListGetAt(form.date, 1, '/')) cfoutput#myDateObject#/cfoutput cfcatch cfabort showerror=i couldn't make a date out of form.date... /cfcatch /cftry Assuming that the datatype of your dB column is DATETIME, you'll want to do something similar when displaying the date you pull out of the database, this time using DateFormat(yourDate, 'dd/mm/'). (N.B. DateFormat should be used to display a date object in a particular format, and not to try to create a date object from a string in a particular format...) As Peter mentioned, where possible it is preferable to use mmm is any dates you display to the end user as this removes any ambiguity between dd/mm vs. mm/dd: everyone understands Jan 2 2009 and 2 Jan 2009. Cheers Bert ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Spry Collapsible panels
I'm hoping someone has an easy answer for this: Two options: 1) Put the new Spry.Widget.CollapsiblePanel() call inside the loop. One call for each panel 2) Use this custom tag: http://www.massimocorner.com/coldfusion/custom_tag/sprycollapsible.zip Massimo Foti, web-programmer for hire Tools for ColdFusion, JavaScript and Dreamweaver: http://www.massimocorner.com Massimo, Option 1 worked. cfloop index=oIDX from=1 to=#ArrayLen(ObjArray)# step=1 div id=CollapsiblePanelcfoutput#index#/cfoutput class=CollapsiblePanel div class=CollapsiblePanelContent content /div /div script type=text/javascript !-- var CollapsiblePanelcfoutput#index#/cfoutput = new Spry.Widget.CollapsiblePanel(CollapsiblePanelcfoutput#index#/cfoutput, {contentIsOpen:false}); //-- /script /cfloop Next time I will try your custom tag. Thanks for the help! Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to fire off onBlur event for CFTEXTAREA
CFTEXTAREA is great in CF8, but there seems to be a bug that the richtext editor will not react to onBlur events. For a regular textarea it works fine. Can anyone figure out a workaround for this? I just have a form with the 1 CFTEXTAREA field and want to submit it onBlur. -Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to fire off onBlur event for CFTEXTAREA
Brad, this code snippet works great by itself. However, as an additional level of complexity, I need to run that from a cfdiv which no longer fires off the OnBlur. There is a parent file called div.cfm which creates the cfdiv and binds to the file that contains your solution. cfdiv bind=url:fckrte.cfm?section=1 bindonload=true style=margin-top:10px; Any idea what needs to be changed so OnBlur will still work in this setup? CF 8's rich text area uses the FCKEditor. A little digging in their docs shows you how to do this. You must attach the event after the editor loads like so: cfform format=HTML name=test cftextarea name=myfield richtext=Yes/cftextarea /cfform script LANGUAGE=JavaScript TYPE=text/javascript function FCKeditor_OnComplete(editorInstance) { editorInstance.Events.AttachEvent( 'OnBlur', handleOnBlur ) ; } function handleOnBlur(editorInstance) { alert(editorInstance.Name + ' has blurred!'); } /script ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to fire off onBlur event for CFTEXTAREA
I got it to work by moving the javascript code to the parent file (div.cfm) right after the cfdiv. Thank you very much for finding this solution. -Alex Brad, this code snippet works great by itself. However, as an additional level of complexity, I need to run that from a cfdiv which no longer fires off the OnBlur. There is a parent file called div.cfm which creates the cfdiv and binds to the file that contains your solution. cfdiv bind=url:fckrte.cfm?section=1 bindonload=true style=margin-top:10px; Any idea what needs to be changed so OnBlur will still work in this setup? CF 8's rich text area uses the FCKEditor. A little digging in their docs shows you how to do this. You must attach the event after the editor loads like so: cfform format=HTML name=test cftextarea name=myfield richtext=Yes/cftextarea /cfform script LANGUAGE=JavaScript TYPE=text/javascript function FCKeditor_OnComplete(editorInstance) { editorInstance.Events.AttachEvent( 'OnBlur', handleOnBlur ) ; } function handleOnBlur(editorInstance) { alert(editorInstance.Name + ' has blurred!'); } /script ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple Spry Collapsible panels
Hi, I'm hoping someone has an easy answer for this: In looping through a query I want to set up collapsible regions div id=CollapsiblePanelcfoutput#loop-counter#/cfoutput class=CollapsiblePanel div class=CollapsiblePanelTab goalcell tabindex=0 emExpand/Collapse Goal/em /div div class=CollapsiblePanelContentcontent/div so far so good, the problem is in initialing the regions: Spry insert the following static script, and I need it dynamic script type=text/javascript !-- var CollapsiblePanel1 = new Spry.Widget.CollapsiblePanel(CollapsiblePanel1); var CollapsiblePanel2 = new Spry.Widget.CollapsiblePanel(CollapsiblePanel2); var CollapsiblePanelx = new Spry.Widget.CollapsiblePanel(CollapsiblePanelx); //-- /script The question is how can i loop through the init script myquery.recordcount times calling: var CollapsiblePanel[loop-counter] = new Spry.Widget.CollapsiblePanel(CollapsiblePanel[loop-counter]); many TIAs, Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem to diplay results horizontally
hi everybody I have this code and it works fine except that i want the results of year to display horizontally couldn't figure out how toit grouped on the title CFOUTPUT query=GetAll group=title #GetAll.title# cfoutput ul li #year# /li /ul /cfoutput /cfoutput with this the results would be title1 2001 2002 2003 etc. I want the result to be title 2001 2002 2003 etc and on the 8th year it would break thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem to diplay results horizontally
ok thanks will try that correction it's not default to block.. it's list-item... the element li display property is defaulted to block, try setting up some css, change the inline property of the li element to inline. I'm no css guru but that might get your started ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem to diplay results horizontally
Yes thanks got it and working fine with display: inline; Try this Always works for me .ul{ margin: 0; padding: 0; cursor: default; list-style-type: none; display: inline; } .li{ display: table-cell; position: relative; padding: 2px 6px; display:inline; } Thanks! Robert Bailey 210.748.2363 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
uploading file on a different server using cffile
HI everybody Is there a way of uploading file on a different server other than what i'm using.. if i try to upload it locally with a cffile it works but my plan is uploading it to another one because of space problems.. thanks for any help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with sum of resuts of two queries
HI everybody just wondering if there is a way i could sum the results of two queries and display it inside of cfoutput.. the queries are below CFQUERY NAME=total1 datasource=db1 SELECT COUNT(id1) AS Expr1 FROMtable2 /CFQUERY CFQUERY NAME=total2 datasource=db1 SELECT COUNT(id1) AS Expr1 FROMtable1 /CFQUERY like cfoutput #total1.expr1#+#total2.expr2# /cfoutput but the above doesn't work thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with sum of resuts of two queries
thanks all for the quick reply it worked HI everybody just wondering if there is a way i could sum the results of two queries and display it inside of cfoutput.. the queries are below CFQUERY NAME=total1 datasource=db1 SELECT COUNT(id1) AS Expr1 FROM table2 /CFQUERY CFQUERY NAME=total2 datasource=db1 SELECT COUNT(id1) AS Expr1 FROM table1 /CFQUERY like cfoutput #total1.expr1#+#total2.expr2# /cfoutput but the above doesn't work thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgridcolumn
I have a cfgrid bound to a cfc. It'll have one (and only one) editable column, ActiveStateID, which will be a select box on each row. My attempt to do this includes: cfgrid selectmode=edit format=html [snip] cfgridcolumn name=ActiveStateID header=State select=yes display=yes values=1,2,3 valuesdisplay=Active,Enabled,Paused [snip] /cfgrid The problem is that this gives me an ActiveStateID column containing the integer values of the foreign key (1, 2, or 3) instead of select boxes with Active, Enabled, and Paused and the correct option selected. I found this: http://cfsilence.com/blog/client/index. cfm/2006/6/12/CFGRID-Cell-Renderer--ComboBox-Select but that only works for Flash forms/grids. Ideas...? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgridcolumn
The fix came from Adobe: http://kb.adobe.com/selfservice/viewContent.do?externalId=kb403597sliceId=2 Hotfix for CF8.01 - Knowledgebase article 403597 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable do you store the event's end month or full date or duration in the db, too? what are the fields? how about events that start in one year and end in the next??? post your db table structure (with data types and explanations of what data is stored in the filed if not clear from filed name). Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem displaying event if it ends on the succeeding month
HI below is the structure of the db table and yes also instances from one year to the other columnnamedatatype allownulls EventID int Unchecked StartDate datetime Checked EndDate datetime Checked EventInfo nvarchar(255) Checked Type int Checked do you store the event's end month or full date or duration in the db, too? what are the fields? how about events that start in one year and end in the next??? post your db table structure (with data types and explanations of what data is stored in the filed if not clear from filed name). Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem displaying event if it ends on the succeeding month
hi Sorry for that and for the post that are doubled it seemed to me that it's not posting because it took a while to see it so i resent it again many times... anyway the startyear and eventmonthstart comes from a cfset i declared before the query which takes the datepart(, startdate) and datepart(m, Startdate) so the query would be this if it would go right cfquery name=GetEvents datasource=sql1 SELECT * FROM GetEvents WHERE datepart(, StartDate) = #form.YearChosen# AND Datepart(m, StartDate) = #form.MonthChosen# ORDER By StartDate /cfquery thanks again alex and i do not see any StartYear or EventMonthStart columns in there... the columns in the query you originally posted? where are they coming from? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
IT IS MSSQL 2000 what's your db? ms sql? mysql? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with cfif conditions on dates
Thanks so much that did it .. It's just so simple but i've complicated myself from my original code.. again thanks all you need for your desired output is: cfquery ... ... /cfquery cfoutput query=getevents #StartDate#cfif startdate neq enddate - #EndDate#/cfif /cfoutput however, keep in mind that if your startdate and enddate db fields also include TIME part, your stratdate will not be equal to enddate even if date parts are same... you will need to use your db's date/time functions to select only the DATE part of these fields and compare/output those. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with cfif conditions on dates
HI everybody have this problem with this query.. CFQUERY NAME=GetEvents DATASOURCE=events SELECT c.startdate, c.endDate FROM CalendarEvents c /CFQUERY cfoutput cfif #getevents.StartDate# eq #getevents.EndDate# cfset EndDate= cfset hyphen= cfelse cfset EndDate=#getevents.enddate# cfset hyphen=- /cfif /cfoutput cfoutput query=getevents #StartDate# #hyphen# #EndDate# /cfoutput With the conditional statement cfif if the startdate = enddate i need only to see the startdate without the hyphen otherwise it gives me both dates with the hyphen .. my code above doesn't work ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem displaying event if it ends on the succeeding month
HI everybody Got this situation that i need to display events depending on the month selection form.month it works fine when the event duration is within the month but i also need to display the duration enddate would be going over the following month or more... below is my code... cfquery name=GetEvents datasource=sql1 SELECT * FROM GetEvents WHERE StartYear = #form.YearChosen# AND EventMonthStart = #form.MonthChosen# ORDER By StartDate /cfquery cfoutput query=GetEvents #startdate# - #enddate# - #description# /cfquery result would be: this taking into consideration that the selection form.yearchosen = 2008 and form.monthchosen = january which has a value of 1 01/01/2008 - 01/10/2008 - meeting 1 01/05/2008 - 02/10/2008 - conference 01/20/2008 - 03/10/2008 - class the problem arises when the selection would be: if form.yearchosen = 2008 form.monthchosen = february value 2 the second record and the third record would still appear on the result which is still ongoing in february. 01/05/2008 - 02/10/2008 - conference 01/20/2008 - 03/10/2008 - class etc. couldn't figure out how to deal with it. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgridcolumn
I am having the exact same problem. I populate the GRID from a query, but on the select box columns, if a value is already selected, I do not get the drop down of all the possible values, only the value selected. cfgridcolumn name=misc_cd header=Misc Cd select=true values=#valuelist(getMiscExpenseItems.misc_cd)# valuesdisplay=#valuelist(getMiscExpenseItems.misc_desc)# It appears the query is overriding the values/valuesdisplay option. Any ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
10gRac database returning odd time
When using a regular 10g (non tac) database the query returns this: 2005-06-23 13:18:27.0 However, under 10gRac (using the most current jdbc driver) returns this {ts '2005-06-23 00:00:00'} for the same data. Anyone know why? - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 10gRac database returning odd time
Yeah, I thought it was the driver as well. However, I updated to correct version and get the same results. - Alex Different drivers maybe? Does it matter? What does DateFormat and the other CF date functions give for them both? I'd guess (a bid guess too) that CF treats them both the same. Adrian Building a DB of errors at cferror.org When using a regular 10g (non tac) database the query returns this: 2005-06-23 13:18:27.0 However, under 10gRac (using the most current jdbc driver) returns this {ts '2005-06-23 00:00:00'} for the same data. Anyone know why? - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Unresponsive server
Hello All, We have a production CFMX server with approx 20 oracle datasources(all coming from the same server, yes I know single point of failure). Anyways, whenever our DB server crashes here's what happens: 10/01 19:37:09 metrics Web threads (busy/total): 0/1 Sessions: 3848 Total Memory=468992 Free=280550 10/01 19:38:09 metrics Web threads (busy/total): 0/3 Sessions: 3833 Total Memory=468992 Free=254816 10/01 19:39:09 metrics Web threads (busy/total): 25/40 Sessions: 3827 Total Memory=469824 Free=273703 10/01 19:40:09 metrics Web threads (busy/total): 25/100 Sessions: 3805 Total Memory=469888 Free=240330 10/01 19:41:09 metrics Web threads (busy/total): 25/156 Sessions: 3785 Total Memory=469312 Free=240488 10/01 19:42:09 metrics Web threads (busy/total): 25/219 Sessions: 3757 Total Memory=469504 Free=247857 10/01 19:43:09 metrics Web threads (busy/total): 25/256 Sessions: 3737 Total Memory=466624 Free=268661 10/01 19:44:09 metrics Web threads (busy/total): 25/256 Sessions: 3712 Total Memory=466624 Free=246657 The CFMX server grinds to a halt and nothing works until the db comes back up. Many of the cfm pages we have are static. I am assuming CFMX is holding onto to all the datasource dependant threads and not releasing them. What can I do to help the server weather the outage better? (second db yes I know). Any feedback/ideas would be appreciated. - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Installation of CF 8 (developer edition) is not working
if you're using Vista and IIS, make sure IIS6 Management Compatibility options are checked in under windows features. i was getting 500 error until i installed additional IIS components under Vista. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: can't enable debug output in coldfusion 8
got it working... i've re-registered ips in CF Admin. also i realized that 'localhost' does not work for debugging on a local machine... thanks for replies guys! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
can't enable debug output in coldfusion 8
already re-installed CF8 and can't find any solution... i'm simply trying to enable debug output in CF admin and nothing happens when i check Enable Robust Exception Information setting. Request Debugging is not working as well. (?cfdebug) BTW, running CF8 on Vista32/IIS7 anyone else having similar problems? thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
help on persistent variable on 3 cfm templates
HI everybody. have this problem which I couldn't seem to solve.. I have three templates. I have to declare a variable that would persist in these three templates. On the index page is a url variable that is passed to magazine.cfm and from the magazine.cfm to magarticles.cfm.. this after the action page it comes back to magazine.cfm.. but it gives me an error which is that url.magazineid is undefined... index.cfm magazine.cfm?magazineid=#UrlEncodedFormat(getall.magazineid)# magazine.cfm magarticles.cfm thanks for any help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on persistent variable on 3 cfm templates
Are you using Firefox? I suggest you do go and d'load that and install it. Then grab yourself a copy of fireBug and install that into firefox. The best thing about this plugin, that information can be seen or not going through the URL and can be debugged if your code is wrong or not. Because you will see what is being passed in the URL? Also you do not say which version of Coldfusion you are using, but if you are using Coldfusion 8 then I suggest reading a bit more on line debugging, and you can debug your code that way. Not using Coldfusion 8, then I suggest looking at fusionDebug as a good addition to your Eclipse (oh did Iask that) anyway there are some great tools for this at your disposal. I suggest maybe looking into one or more of these. Now for your problem, you could do a cfdump var=#URL# and then abort the page to see if the values are going across, and that you are indeed passing them via the url. However, if it was me. And you don't indicate any more than the vars not being there in the URL. But I would be maybe looking at what framework your using, none then double check your links. but I would be looking at what information these other pages need to share? Could it be stored in the application scope (available to all the application) or could it be held in the session. Eitherway, it could be a case that you could repull this info at anytime without passing it back and forth. But this is something you will need to look at when it comes to sharing the data from one page to the next. I hope I haven't confused you too much, but the tools I mentioned with firefox are invaluable to you and debugging passing of URL / Rest and other information from client to server. Plus you get all the added benefits of modifying your css and html and JS, huge benefit to use. But as I said, if you look at what you are passing around. Then you could decide what scope to hold that info in, or not. And decide whether or not you need to rehit the database or not. Plenty of options open to you, if you dig deeper into your requirement. Hi Andrew Thanks for your advise will be trying what you said.. And to clarify things more.. yes i'm using firefox so will try firebug... also am using coldfusion mx7... Well the url variable coming from the index.cfm template is going thru magazine.cfm page. my problem is when i add a magazine article on magazinearticle.cfm on the action page I HAVE THE cflocation url=magazine.cfm so it gets me back to that page and naturally the url which was passed earlier is gone already so it gives an error url undefined I tried a session variable with it but couldn't go thru.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on persistent variable on 3 cfm templates
thanks got it thru but i created a session variable this time from the url and struct clear it everytime the same user edits or adds new magazine articles I don't know it it is a good idea using session variable for these three pages... Why can't you just add the URL variable to the CFLOCATION...? ie. cflocation url=magazine.cfm?variable=#id# or whatever Thanks for your advise will be trying what you said.. And to clarify things more.. yes i'm using firefox so will try firebug... also am using coldfusion mx7... Well the url variable coming from the index.cfm template is going thru magazine.cfm page. my problem is when i add a magazine article on magazinearticle.cfm on the action page I HAVE THE cflocation url=magazine.cfm so it gets me back to that page and naturally the url which was passed earlier is gone already so it gives an error url undefined I tried a session variable with it but couldn't go thru.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Jrun Memory Usage Problem: could fileexists() be the culprit?
We had a similiar issue. Let me preface by saying I have not read this entire thread so if the info I give is redundant.. sorry. Anyways, we had a similiar issue. Code that worked fine under CFMX 7 would cause Jrun cfmx 8 to suck down memory until it crashed. We narrowed it down to a piece of code that read in a large xml documented, parsed it, and then displayed it on the screen. Hit it once after the server would start and it would take 200 megs, hit it quickly a couple times and it would jump to 800 meg(max jvm memsize was 1.2g), do it a couple more times and the instance would crash. I was able to catch the ear of an Adobe support engineer and we have solved my problem. First, I upgraded to the lastest JVM 1.6_06 also, scaled down the memory quite a lot. Here is my jvm.config: java.home=d:/jdk1.6.0_06 java.args=-server -Xmx512m -Xms256m -XX:MaxPermSize=178m -Dsun.io.useCanonCaches=false -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -XX:+UseParallelGC This has totally solved my problem our servers have been running great ever since. Plus 1.6 is much faster. Hope this helps. - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Jrun Memory Usage Problem: could fileexists() be the culprit?
CF8 ships with JDK 1.6 Version 1.6_06 isn't supported by CF8; 1.6_04 is the latest version showing in the support matrix. Regardless, 1.6_06 still suffers the classloader issue (which isn't fixed until 1.6u10 and that's still in beta). On Fri, Jun 13, 2008 at 9:01 AM, Alex DeMarco [EMAIL PROTECTED] wrote: Plus 1.6 is much faster. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ I'll just clarify by saying that upgrading to 1.6_06 was Adobe's recommendation. We deploy CFMX as an ear to a Jrun instance. Since I made the changes I mentioned we have not had any issues. - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Application.cfc variables
Hi everyone! Can somebody explain me why assigning a value to This.Blah inside Application.cfc doesn't affect Application struct itself. Doesn't Application.cfc represent an application scope? if so, why assigning this.name inside cfc affects Application. and one more related question: do I need to explicitly use Application scoping inside Application.cfc? Any info is very appreciated. Thanks in advance, Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recommendations for a Knowledgebase written in CFML?
Not quite. I was looking for a CFML version of something similar to www.kbpublisher.com Thanks! I also experienced a bit of slowness when the search was Loading However, the reason for this reply is I did see Context-based Help tag on RiaForge. Does this do what you want? Cheers, Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jun 5, 2008, at 12:26 AM, Alex Sherwood wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Recommendations for a Knowledgebase written in CFML?
Greetings, I've searched high and low and have yet to find a knowledgebase application written in CFML. Project Management/Time Entry apps seem to be plenty - KB apps, not so much! Places I've searched: Google upteen ways, Charlie Aerhart, Adobe.com Developer Forums, etc. If anyone has experience with a pre-built KB app. written in CFML, it would be greatly appreciated. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Recommendations for a Knowledgebase written in CFML?
Try perhaps riaforge.com? Quoting Alex Sherwood [EMAIL PROTECTED]: Greetings, I've searched high and low and have yet to find a knowledgebase application written in CFML. The search function is broken at riaforge.com. I browsed all CF projects, though, and did not find one. The best I've seen on the net is www.kbpublisher.com, but it's PHP. ;-( Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Recommendations for a Knowledgebase written in CFML?
What was broken with the search? On Wed, Jun 4, 2008 at 10:17 PM, Alex Sherwood [EMAIL PROTECTED] wrote: Looks to be working now. Was stuck in the Loading.. state, but appears OK now. No KB found, though! Any recommendations on a CFML-based KB?! Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Jrun Alteratives
We have been having serious thoughts of getting off of Jrun and into some other App Server (possible Oracle). However given the way we use IIS it's looking to be a very difficult migration. Has anyone migrated off of Jrun? Any tips? I deployed cfmx8 under Oracle 10g 10.1.3 howeveer none of our code worked since it must reside under the applications dir within the 10g instance(we have d:\inetpub\yadda\yadda). Any pointers on migrating would be appreciated. Thanks! - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflocation problem
thanks to all the inputs will try which is best ... Hi everybody need help on this I have this code on an action template CFQUERY NAME=AddHL datasource=db INSERT into table1(listID, secondID, emailID) VALUES('#Form.ListID#','#Form.secondID#','#form.emailID#' ) /cfquery CFLOCATION URL='Form2.cfm' I need to go back to the previous form with the value of form.id which comes from the calling template. Is there a way to insert that value in the cflocation url? I tried it but it gives me an error wHAT i WANT TO DI IS cflocation url='form2.cfm?id='form.id thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cflocation problem
Hi everybody need help on this I have this code on an action template CFQUERY NAME=AddHL datasource=db INSERT into table1(listID, secondID, emailID) VALUES('#Form.ListID#','#Form.secondID#','#form.emailID#' ) /cfquery CFLOCATION URL='Form2.cfm' I need to go back to the previous form with the value of form.id which comes from the calling template. Is there a way to insert that value in the cflocation url? I tried it but it gives me an error wHAT i WANT TO DI IS cflocation url='form2.cfm?id='form.id thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with passing variables to action template
Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with passing variables to action template
Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4