Re: CFLog4j
Qasim, I am getting this with my app log4j:ERROR The class org.apache.log4j.Appender was loaded by log4j:ERROR [EMAIL PROTECTED] whereas object of type log4j:ERROR org.apache.log4j.RollingFileAppender was loaded by [ [EMAIL PROTECTED] log4j:ERROR Could not instantiate appender named myAppen. And I don'r know how PropertyConfigurator could know about Category unless they both share a common object. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is anyone minding the store at Adobe?
Reckon the best thing you can do is email them direct not via web form (or contact someone direct). They will undoubtedly have problems with integrating two massive sites. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Daniel Lancelot To: CF-Talk Sent: Mon Sep 18 22:52:43 2006 Subject: Re: Is anyone minding the store at Adobe? I tried to submit a problem using the email support app - which resulted in Page doess not exist error meesage after clicking send mail On 9/18/06, Tim Claremont [EMAIL PROTECTED] wrote: I have been trying to reach the CF tech support forums on Adobe.com. I get an error message saying, essentially, insufficient disk space. How does this happen in today's day and age of server monitoring, etc, etc. ??? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cross-server CFC/WS implementation.
On Monday 18 September 2006 17:04, Peter Boughton wrote:
Do you have a simple* example of a ColdSpring XML config?
(*but not too simple)
The ColdSpring config includes the following, which creates a user manager
that needs access to the database (via Reactor) and a logger:
bean id=userManager class=com.halliwells.CFCs.userManagerImpl
property name=reactorGateway
ref bean=coldspringReactorGateway/
/property
property name=logger
ref bean=logger/
/property
/bean
The user service looks a bit like:
cffunction name=getUserList access=remote output=false
cfset super.init()
cfreturn queryToArrayOfVO(
application.beanFactory.getBean('userManager').getDepartmentList(),'com.halliwells.CFCs.vo.DepartmentVO')
/cffunction
super.init() just takes care of making sure ColdSpring is started up.
--
Tom Chiverton
Helping to autoschediastically network proactive functionalities
This email is sent for and on behalf of Halliwells LLP.
Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at St
James's Court Brown Street Manchester M2 2JF. A list of members is available
for inspection at the registered office. Any reference to a partner in relation
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law
Society.
CONFIDENTIALITY
This email is intended only for the use of the addressee named above and may be
confidential or legally privileged. If you are not the addressee you must not
read it and must not use any information contained in nor copy it nor inform
any person other than Halliwells LLP or the addressee of its existence or
contents. If you have received this email in error please delete it and notify
Halliwells LLP IT Department on 0870 365 8008.
For more information about Halliwells LLP visit www.halliwells.com.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253484
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Session.UrlToken on form post in CF7
Awesome. Have I said recently how much I love this list? On 9/19/06, Ashwin Mathew [EMAIL PROTECTED] wrote: James - Rupesh blogged about this very issue recently: http://coldfused.blogspot.com/2006/09/handling-j2ee-session-with-cookies _12.html -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 7:17 AM To: CF-Talk Subject: Session.UrlToken on form post in CF7 We've just updated to CF7 on our dev server. Code that worked on CF6.1 is now breaking. On a form post, to a different subdomain, I am passing the session.urltoken in the action URL to ensure we get the right session (it's the same server, just a different subdomain). The jsessionid ends up being incorrect on the other page and we get the wrong session. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX 6.1 and FC5?
Has anyone tried installing ColdFusion MX 6.1 on FC5? I tried installing one, and got past the installation procedures, but when I tried running CFMX 6.1, I got troubles already. It was looking for a certain libc.so.5 (or was it libcrypto.so.5) and libssl.so.5, both found on FC4. I am thinking now that installing MX 6.1 on FC5 is just not possible. But since Fedora has been all about freedom and infinity, I presume I just need to tweak the libso files found in my /lib directory. What do you think? Have I left out anything in the installation? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253486 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Use CFMX with SAP
tanguyr thanks. I tried the POJO link but got an 404 (page not found). I know about the concept of consuming and publishing webservices from CFMX. But how do I find which services are offered by the owner of my particular SAP inplementation? Simply calling uddi.sap.com (the public uddi directory for SAP) gives me a 404. I need a few webservices to get/send data from /to SAP, do something with the return code etc. Where can I find which ones to use? Marc Hi, I'm working on an application that gets and sends data to/from a SAP back end. We use the SAP Java Connector (JCO) architecture to expose SAP RFCs as methods in a stateless EJB, and call these from within cf (cfmx running in weblogic). You *should* be able to get most of the benefit w/out having to use EJB (our architecture is a couple of years old, but it works so we don't change it) by just writing some POJOs and deploying them in a jar in your cfserver's /lib directory and then using them via createObject or cfobject calls from within your CF code. More information about JCO is available here: http://help.sap. com/saphelp_nw04/helpdata/en/6f/1bd5c6a85b11d6b28500508b5d5211/content. htm Regs, /t marc -- wrote: Hello, I want to make a timesheet application for a company that stores al its HR (human resource) data in SAP. Currently employees fill in their timesheetdata in an Excel spreadsheet and email it to the company. The timesheet then is being validated by a Perl script and if OK sent by ftp to SAP. If not OK employees call back to manually correct the sheet. This is tedious and error prone process since it depends on many intermediate steps (validation scripts running, ftp connection up etc etc). When any of these fails the whole chain fails and often timesheetdata is not sent. Having an online timesheetmodule connected directly to SAP should makes things easier: the employee fills in the sheet (a form) and submits the timesheet to SAP. SAP validates the timesheetdata using it's validationrules and generates error messages if something's wrong. The idea is to have these error messages sent back to the client in response to the submit and have him/her correct the timesheet if needed. Since I am a CFMX programmer and not SAP knowledgeable I wonder if anyone on this list has experience with connecting CFMX to SAP. I'd like to get some tips please! -- View this message in context: http://www.nabble. com/Use-CFMX-with-SAP-tf2291598.html#a6367670 Sent from the Cold Fusion - Technical mailing list archive at Nabble. com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253487 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use CFMX with SAP
Marc, Check the link again, and watch out for wrapping - it should take you to a page entitled SAP Java Connector (SAP Library - Development Manual). Secondly, this is *not* a webservice approach, it's a straight call an ABAP function from java solution (in your case - it can also be used to develop call java from ABAP functionality). You will need to consult with a SAP developer at work to get details on the function to call, parameters to pass, etc. etc. There's a overview diagram of the architecture in use here: http://help.sap.com/saphelp_nw04/helpdata/en/8b/91222fa9e611d6b28f00508b6b8a93/content.htm Regs, /t marc -- wrote: tanguyr thanks. I tried the POJO link but got an 404 (page not found). I know about the concept of consuming and publishing webservices from CFMX. But how do I find which services are offered by the owner of my particular SAP inplementation? Simply calling uddi.sap.com (the public uddi directory for SAP) gives me a 404. I need a few webservices to get/send data from /to SAP, do something with the return code etc. Where can I find which ones to use? Marc -- View this message in context: http://www.nabble.com/Use-CFMX-with-SAP-tf2291598.html#a6386326 Sent from the Cold Fusion - Technical mailing list archive at Nabble.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
It might possibly have been an option before the money was spent, but I'm not a fan of doubling up on costs. I'd rather try to fix or get a fix for what I've already spent money to buy. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:19 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Tom, Dan, Since you're both running Windows 2003 and SQL Server, is BlueDragon.NET an option to consider? http://www.newatlanta.com/products/bluedragon/index.cfm Vince Bonfanti New Atlanta Communications, LLC Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ?
XMLValidate() and ENTITY declarations
Does anyone know whether XMLValidate() handles declared entities correctly? I have what I think is a proper use and yet it's being returned as invalid with the following error: The attribute type is required in the declaration of attribute dialog for element icon. The DTD includes: !ENTITY % perms (READ|WRITE|ADMIN) snip ... !ATTLIST icon class CDATA #REQUIRED src CDATA #REQUIRED state (NORMAL|EXPANDED) #IMPLIED label CDATA #IMPLIED group CDATA #IMPLIED module CDATA #IMPLIED perms %perms; #IMPLIED parentperms %perms; #IMPLIED checkmodCDATA #IMPLIED priorityCDATA #IMPLIED description CDATA #IMPLIED Am I applying it wrong or is CF not handling it properly? If I replace %perms; with (READ|WRITE|ADMIN) it works exactly as expected. TIA. -- Rob Wilkerson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253490 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Viaklix
On 9/18/06, Jesse Kuhn [EMAIL PROTECTED] wrote: I am looking to use viaklix as well. Has anyone done this successfully yet... their developers guide only supports asp development. I am putting together my first shopping cart and am new to CF so if anyone has been able to get viaklix to work within a coldfusion site and has any recommendations, examples or can point me in the right direction I would really appreciate it. If the other postings don't work let me know. I've used it successfully in two applications. Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253491 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
You're right, so I looked around at the rest of our servers. They're all Win2k3/ CF7 and none have SQL Server. RAM usage for the jrun service seems to hover between 85,500K and about 188,000K. All but one of those has traffic which is really quite heavy in relation to the one trouble machine. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:21 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash 55,144K is rather low for jrun - on my dev box its around 50,000k when server starts then it goes to about 80,000k after few hours of development. That is with one developer working on few sites max, TK -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 5:06 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MySQL Front
Chad, Thanks for that link - this looks really good. I'm a Mac user and I've struggled to find something to use which runs on OS X *AND* that I like *AND* works with more than just MySQL or SQL Server... This looks like it was made just for me. I'm downloading it now to check it out. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:09 PM To: CF-Talk Subject: Re: MySQL Front Chad Gray wrote: I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? I'll throw out my vote for Aqua Data Studio, which also will manage SQL Server, Oracle, etc. For me, it's nice having one tool for both MySQL and MS-SQL. It is free for personal and educational use, $149 for commercial. http://www.aquafold.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253493 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Passing ColdFusion Arrays By Reference
Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE performance gains and is just all around wicked sweet! http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S WEEET.htm ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
The latest Macromedia drivers for cfmx are version 3.5 and available here: http://www.adobe.com/go/42dcb10a. Also, Microsoft has a new JDBC driver of their own. It might be worth testing with it to see if there is a change in behavior. http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7Cdisplaylang=en. Clearly if it is a driver specific issue, you would not expect to see it with all drivers. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Passing ColdFusion Arrays By Reference
Hasn't this always been possible? Didn't you wrap a structure around the array? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 13:34 To: CF-Talk Subject: Passing ColdFusion Arrays By Reference Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE performance gains and is just all around wicked sweet! http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S WEEET.htm Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253496 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Front
for us so far the mysql administrator (free download from mysql) seems solid and does everything we need. for add hoc queries I use sqlexplorer which is an eclipse plugin. you could also use the RDS plugin for eclipse. On 9/18/06, Matt Robertson [EMAIL PROTECTED] wrote: A conditional vote for SQLYog. They have a scheduler that is phenomenal -- once you fight with it to make it work -- for backing up databases automatically. Also its ability to alter tables is laid out way better than Navicat IIRC. The down side of SQLYog is a 'feature' in the thing that lets it alias text to perform automated actions. The strings it uses are all uncommon but the text 'default' is reserved... if you have a field that just contains the text 'default' SQLYog will corrupt it if you touch the record. I think I impressed upon them how outrageously stupid this was and they promised to make the feature optional, but so far a version has come and gone that doesn't fix the problem. -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253497 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Passing ColdFusion Arrays By Reference
No, I am NOT wrapping a structure around an array. I am making a pass-by-reference VERSION of an array. If you wrap something in a structure. Then you need to grab it out of a structure when referencing it: cfset objStructure[ array ] = ArrayNew( 1 )/ !--- Update it. --- cfset ArrayAppend( objStructure[ array ], test ) / See, if you go the structure route, you have to always reference via the structure. That is LAME. I am talking about altering the way arrays seem to function. Pass the array ITSELF by reference. No structures, no nesting, no nothing... Pure sexyness. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 8:39 AM To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference Hasn't this always been possible? Didn't you wrap a structure around the array? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 13:34 To: CF-Talk Subject: Passing ColdFusion Arrays By Reference Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE performance gains and is just all around wicked sweet! http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S WEEET.htm . Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Passing ColdFusion Arrays By Reference
Lol...do you have to comment any references to it as Pure sexyness. ? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 14:10 To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference No, I am NOT wrapping a structure around an array. I am making a pass-by-reference VERSION of an array. If you wrap something in a structure. Then you need to grab it out of a structure when referencing it: cfset objStructure[ array ] = ArrayNew( 1 )/ !--- Update it. --- cfset ArrayAppend( objStructure[ array ], test ) / See, if you go the structure route, you have to always reference via the structure. That is LAME. I am talking about altering the way arrays seem to function. Pass the array ITSELF by reference. No structures, no nesting, no nothing... Pure sexyness. Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 8:39 AM To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference Hasn't this always been possible? Didn't you wrap a structure around the array? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 13:34 To: CF-Talk Subject: Passing ColdFusion Arrays By Reference Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE performance gains and is just all around wicked sweet! http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S WEEET.htm .. Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLog4j
Dan, Do you have another property file which has this appender 'myAppen' in it? Thanks, Qasim On 9/19/06, Dan Plesse [EMAIL PROTECTED] wrote: Qasim, I am getting this with my app log4j:ERROR The class org.apache.log4j.Appender was loaded by log4j:ERROR [EMAIL PROTECTED] whereas object of type log4j:ERROR org.apache.log4j.RollingFileAppender was loaded by [ [EMAIL PROTECTED] log4j:ERROR Could not instantiate appender named myAppen. And I don'r know how PropertyConfigurator could know about Category unless they both share a common object. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253502 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Front
On 9/19/06, Michael Traher [EMAIL PROTECTED] wrote: for us so far the mysql administrator (free download from mysql) seems solid and does everything we need. Try resorting table column. Casey ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253503 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLog4j
Qasim, Just an FYI, I added this to the open-source list ( http://www.remotesynthesis.com/cfopensourcelist) and highlighted in in this weeks open source update at - http://www.remotesynthesis.com/blog/index.cfm/2006/9/18/ColdFusion-OpenSource-Update--September-18 -- - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Front
I hadn't tried that before - you're right no way to do in GUI however you can call the command line from the gui and do alter table tablename modify column columntype after othercol; thats what us tough guys do :-) On 9/19/06, Casey Dougall [EMAIL PROTECTED] wrote: On 9/19/06, Michael Traher [EMAIL PROTECTED] wrote: for us so far the mysql administrator (free download from mysql) seems solid and does everything we need. Try resorting table column. Casey ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253506 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: scrolling table
Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze panes you can make the header row with the column descriptions stay on the page, but you can scroll down into the data. I am trying to use DIVs with tables inside and CSS overflow:scroll; turned on, but getting the header row/table to be the same width and spacing as the data is proving to be difficult. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL Front
Hi there all A couple of products that are available and seem OK - DBQwikEdit from www.thedevshop.com http://www.thedevshop.com/ . And also DBTools from http://www.dbtools.com.br http://www.dbtools.com.br/ These are tools I use regularly. There is one more that I know of Toad for MySQL - not sure of a link for this one but you should be able to google it if required. Regards Pete -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 19 September 2006 10:33 PM To: CF-Talk Subject: RE: MySQL Front Chad, Thanks for that link - this looks really good. I'm a Mac user and I've struggled to find something to use which runs on OS X *AND* that I like *AND* works with more than just MySQL or SQL Server... This looks like it was made just for me. I'm downloading it now to check it out. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:09 PM To: CF-Talk Subject: Re: MySQL Front Chad Gray wrote: I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? I'll throw out my vote for Aqua Data Studio, which also will manage SQL Server, Oracle, etc. For me, it's nice having one tool for both MySQL and MS-SQL. It is free for personal and educational use, $149 for commercial. http://www.aquafold.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Passing ColdFusion Arrays By Reference
On 9/19/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Lol...do you have to comment any references to it as Pure sexyness.? You don't *have* to, but it's strongly encouraged. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253500 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Timeout requests after XX seconds . . .
I'm confused. If the 'Timeout requests after XX seconds' setting in CFAdmin is set to 60 seconds and a request (for us almost always a database request) takes longer than 60 seconds I get a message in the CF logs that 'The unresponsive thread count is up to X.' When the request completes I get a message that 'The unresponsive thread count is down to X.' and another message that the offending template ran x seconds. I thought the purpose of the time out setting in CFAdmin was to free up the offending thread once the time out limit had been reached. But the log file message implies that the thread is kept open until the request returns from the database at which time it is then terminated and freed up. Is this maybe two types of time outs - CF processing time outs vs. database request time outs? And what I describe above is CF practicing good database request housekeeping? Does it make sense that 1) if a thread is kept open until the request returns from the database, even if that request goes beyond the time out setting in CFAdmin, and 2) if the CF processing on the returned answer set is at most a couple of seconds, it would make sense to not time out these database requests? Running CF5 . . . :( Thanks! George ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Passing ColdFusion Arrays By Reference
Sometimes I find it makes the code run faster ;) ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 9:18 AM To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference Lol...do you have to comment any references to it as Pure sexyness. ? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 14:10 To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference No, I am NOT wrapping a structure around an array. I am making a pass-by-reference VERSION of an array. If you wrap something in a structure. Then you need to grab it out of a structure when referencing it: cfset objStructure[ array ] = ArrayNew( 1 )/ !--- Update it. --- cfset ArrayAppend( objStructure[ array ], test ) / See, if you go the structure route, you have to always reference via the structure. That is LAME. I am talking about altering the way arrays seem to function. Pass the array ITSELF by reference. No structures, no nesting, no nothing... Pure sexyness. . Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 8:39 AM To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference Hasn't this always been possible? Didn't you wrap a structure around the array? -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 13:34 To: CF-Talk Subject: Passing ColdFusion Arrays By Reference Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE performance gains and is just all around wicked sweet! http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S WEEET.htm ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Timeout requests after XX seconds . . .
George, While I have no info on this... I am fairly certain that I have read that the timeout for the page is different than the timeout for a CFQuery tag, hence the issue you are having. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:26 AM To: CF-Talk Subject: Timeout requests after XX seconds . . . I'm confused. If the 'Timeout requests after XX seconds' setting in CFAdmin is set to 60 seconds and a request (for us almost always a database request) takes longer than 60 seconds I get a message in the CF logs that 'The unresponsive thread count is up to X.' When the request completes I get a message that 'The unresponsive thread count is down to X.' and another message that the offending template ran x seconds. I thought the purpose of the time out setting in CFAdmin was to free up the offending thread once the time out limit had been reached. But the log file message implies that the thread is kept open until the request returns from the database at which time it is then terminated and freed up. Is this maybe two types of time outs - CF processing time outs vs. database request time outs? And what I describe above is CF practicing good database request housekeeping? Does it make sense that 1) if a thread is kept open until the request returns from the database, even if that request goes beyond the time out setting in CFAdmin, and 2) if the CF processing on the returned answer set is at most a couple of seconds, it would make sense to not time out these database requests? Running CF5 . . . :( Thanks! George ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX 6.1 and FC5?
On Tuesday 19 September 2006 09:38, Jerky San Pedro wrote: Has anyone tried installing ColdFusion MX 6.1 on FC5? I tried installing one, and got past the installation procedures, but when I tried running CFMX 6.1, I got troubles already. It was looking for a certain libc.so.5 (or was it libcrypto.so.5) and libssl.so.5, both found on FC4. Have you tried tracking these down (via rpmfind.net or something) ? They may live in a compat-* package you don't have installed. -- Tom Chiverton Helping to revolutionarily harvest innovative mindshares This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Front
alter table tablename modify column columntype after othercol; Yeah why don't I just go back to Informix and dbaccess, oh the good ol days of CRT ;-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253510 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: scrolling table
Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze panes you can make the header row with the column descriptions stay on the page, but you can scroll down into the data. I am trying to use DIVs with tables inside and CSS overflow:scroll; turned on, but getting the header row/table to be the same width and spacing as the data is proving to be difficult. Try this one: http://kryogenix.org/code/browser/sorttable/ Its about the best one I've run across so far, and the simplest to implement. You include the javascript library, give the table an id and a class (i.e., class = sortable), and that's it. You click on the table headers and they sort the table rows by that column, ascending or descending. hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253512 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: scrolling table
Chad Gray wrote: Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze panes you can make the header row with the column descriptions stay on the page, but you can scroll down into the data. I am trying to use DIVs with tables inside and CSS overflow:scroll; turned on, but getting the header row/table to be the same width and spacing as the data is proving to be difficult. There is a good resource here for CSS styled tables, which includes at least one fixed header example... http://icant.co.uk/csstablegallery/index.php?css=43#r43 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253513 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Passing ColdFusion Arrays By Reference
I just run the following test: cfset javaArray = CreateObject(java, java.util.ArrayList).Init()/ cfset regArray = arrayNew(1) cfset arrayResize(regArray,10) !--- cfset arrayResize(javaArray,10) --- cftimer label=Test Java Array type=outline cfloop index=m from=1 to=10 step=1 cfset javaArray[m] = m /cfloop /cftimer cftimer label=Test ColdFusion Array type=outline cfloop index=k from=1 to=10 step=1 cfset regArray[k] = k /cfloop /cftimer And a) CF array runs faster due to the benefits of the resize (otherwise the run time is similar) b) your version of the array is not supported by the resize, so your array is not 100% like regular CF array with additional benefit of passing by reference. One would now have to check a lot more about your array version to figure out what it supports and what it doesn't support. TK http://www.tomkitta.com -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 9:26 AM To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference Sometimes I find it makes the code run faster ;) Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFMX 6.1 and FC5?
Please confirm the name of the missing library. I believe it may be libc.so.6 not .5. Using the rpm command it can be determined which package should have installed a file. Try rpm --query --redhatprovides filename (ref 1). On a RHEL4 system, /lib/libc.so.6 is installed by the glibc-2.3.4 package, same as CentOS. I don't have my FC5 installation in front of me, but I believe it has a newer glibc version. Checking Fedora package list I see it has 2.4-11 (ref 2), and it does appear that 2.4-11 should have installed libc.so.6 (ref 3). You may want to confirm the missing library name, confirm the package which should have installed the library, and then install that package. On the topic of distributions, if you must run a distro which is unsupported by Red Hat and unsupported by ColdFusion, then I would recommend CentOS rather than Fedora. Even Red Hat will tell you this. CentOS is a legal clone of Red Hat Enterprise Linux so Cent shares the same stability, reliability, and security as RHEL (ref 4). Fedora on the other hand is a bleeding edge distribution with the most bells and whistles and features which have not necessarily been tested to the extent that RHEL is tested. Since ColdFusion is supported for use on RHEL4, while you cannot open a support ticket with Adobe for support of CF on Cent, you can assume that CF will install and run the same, whereas results with Fedora will be in question. For the last 2 months I have been using ColdFusion MX 7 on CentOS (among other OSes), and have been very satisfied. -Steven Erat Adobe ColdFusion QA Refs *1 http://fedora.redhat.com/docs/drafts/rpm-guide-en/ch-command-reference.h tml *2 http://fedoranews.org/cms/node/1617 *3 http://rpmfind.net//linux/RPM/fedora/updates/5/x86_64/glibc-2.4-11.i386. html *4 http://linuxplanet.com/linuxplanet/reviews/5823/1/ -Original Message- From: Jerky San Pedro [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 4:38 AM To: CF-Talk Subject: CFMX 6.1 and FC5? Has anyone tried installing ColdFusion MX 6.1 on FC5? I tried installing one, and got past the installation procedures, but when I tried running CFMX 6.1, I got troubles already. It was looking for a certain libc.so.5 (or was it libcrypto.so.5) and libssl.so.5, both found on FC4. I am thinking now that installing MX 6.1 on FC5 is just not possible. But since Fedora has been all about freedom and infinity, I presume I just need to tweak the libso files found in my /lib directory. What do you think? Have I left out anything in the installation? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253515 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Passing ColdFusion Arrays By Reference
Hi Ben, i was quite astonished when I read that CF passes arrays as clones. Railo for instance does not. So Arrays (which are not simple values) are much faster than in MX. And Structures are up to 20 times faster then with MX. But you allways have to live with the fact that a passed variable can be changed inside a function. Gert Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Ben Nadel schrieb: Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE performance gains and is just all around wicked sweet! http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S WEEET.htm ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253516 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Passing ColdFusion Arrays By Reference
Tom, Excellent catch. I did not think to test the ArrayResize() method. Hmmm, that may hinder the use a lot, for the very reason you are saying. I don't want people to have to test for type. Dang! ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:44 AM To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference I just run the following test: cfset javaArray = CreateObject(java, java.util.ArrayList).Init()/ cfset regArray = arrayNew(1) cfset arrayResize(regArray,10) !--- cfset arrayResize(javaArray,10) --- cftimer label=Test Java Array type=outline cfloop index=m from=1 to=10 step=1 cfset javaArray[m] = m /cfloop /cftimer cftimer label=Test ColdFusion Array type=outline cfloop index=k from=1 to=10 step=1 cfset regArray[k] = k /cfloop /cftimer And a) CF array runs faster due to the benefits of the resize (otherwise the run time is similar) b) your version of the array is not supported by the resize, so your array is not 100% like regular CF array with additional benefit of passing by reference. One would now have to check a lot more about your array version to figure out what it supports and what it doesn't support. TK http://www.tomkitta.com -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 9:26 AM To: CF-Talk Subject: RE: Passing ColdFusion Arrays By Reference Sometimes I find it makes the code run faster ;) . Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Timeout requests after XX seconds . . .
This has been a common topic over the years. Per the general CFAdmin timeout setting, ColdFusion will not timeout a request while the request is waiting to receive all the data. The general ColdFusion timeout governs most everything else. However, SQL Server and Oracle drivers should support a database timeout, so the CFQUERY timeout attribute should work for those dbs. The Restart After X Unresponsive Requests setting was implemented as a (ugly) workaround for accumulating database requests that have run long and initiated a bottleneck and queuing. The setting assumes that if you have X number of requests all waiting for long database requests (or other long events), that the database might be down. On the assumption that the application may continue to be otherwise usuable, the setting will cause ColdFusion to restart, killing all the hung requests (and any queued requests too), and perhaps when ColdFusion comes back up the database problem may have been resolved and the queuing (may or) may not occur again. -Steven Erat -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:26 AM To: CF-Talk Subject: Timeout requests after XX seconds . . . I'm confused. If the 'Timeout requests after XX seconds' setting in CFAdmin is set to 60 seconds and a request (for us almost always a database request) takes longer than 60 seconds I get a message in the CF logs that 'The unresponsive thread count is up to X.' When the request completes I get a message that 'The unresponsive thread count is down to X.' and another message that the offending template ran x seconds. I thought the purpose of the time out setting in CFAdmin was to free up the offending thread once the time out limit had been reached. But the log file message implies that the thread is kept open until the request returns from the database at which time it is then terminated and freed up. Is this maybe two types of time outs - CF processing time outs vs. database request time outs? And what I describe above is CF practicing good database request housekeeping? Does it make sense that 1) if a thread is kept open until the request returns from the database, even if that request goes beyond the time out setting in CFAdmin, and 2) if the CF processing on the returned answer set is at most a couple of seconds, it would make sense to not time out these database requests? Running CF5 . . . :( Thanks! George ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253518 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Ken, I certainly understand your position. But there are other issues to consider when calculating costs. For example, earlier this year HealthGrades (www.healthgrades.com) was suffering from similar performance and reliability issues. Then they replaced 14 CFMX7 servers with 4 BlueDragon.NET servers (same hardware). The hardware savings of 10 servers helped offset the cost of the Bluedragon.NET software; while more difficult to measure, they've also experienced operational savings due to the increased reliability of their servers. Let me know if you'd like to take this discussion offline, or have someone call you with more info. Regards, Vince Bonfanti New Atlanta Communications, LLC It might possibly have been an option before the money was spent, but I'm not a fan of doubling up on costs. I'd rather try to fix or get a fix for what I've already spent money to buy. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:19 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Tom, Dan, Since you're both running Windows 2003 and SQL Server, is BlueDragon.NET an option to consider? http://www.newatlanta.com/products/bluedragon/index.cfm Vince Bonfanti New Atlanta Communications, LLC ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: scrolling table
Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Try this one: http://kryogenix.org/code/browser/sorttable/ Its about the best one I've run across so far, and the simplest to implement. You include the javascript library, give the table an id and a class (i.e., class = sortable), and that's it. You click on the table headers and they sort the table rows by that column, ascending or descending. Sorry about that, I misread the subject. I think I need more coffee this morning. larry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: scrolling table
Couldn't see if Jim's link had a solution on it, so here's one that definitely is: http://www.imaputz.com/cssStuff/bigFourVersion.html Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze panes you can make the header row with the column descriptions stay on the page, but you can scroll down into the data. I am trying to use DIVs with tables inside and CSS overflow:scroll; turned on, but getting the header row/table to be the same width and spacing as the data is proving to be difficult. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: scrolling table
Peter Boughton wrote: Couldn't see if Jim's link had a solution on it, so here's one that definitely is: The scrolling one was called Grayed Out, which is the one I linked to (for examples, that site just reloads the same table and applies the current style). Sorry, should have pointed that out. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Ken, I had the same problem with almost exactly the same setup. Since I didn't know it was a known issue, I installed Fusion Reactor to see if I could diagnose the problem after looking through the IIS and Coldfusion logs with no result. While I was in the Fusion Reactor admin, I enabled the Crash Protection options (http://www.fusion-reactor.com/featureFocus-crashProtection.html). Since doing so, the crashes have stopped and server uptime has been 100% for over a month now (with the exception of one Windows update and CF hotfix which was applied). A side benefit is that the server is running faster on all fronts. My setup has Coldfusion and Windows running on the C partition and all other programs and sites running on a larger E partition. One other thing which I did, which seems to have helped, is to disable the C partition for pagefile usage and max the pagefile usage on the secondary partition. Good Luck, Jon C. We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Re: OT: scrolling table
This is my favorite: http://webfx.eae.net/dhtml/collist/columnlist.html -static headers -sortable -draggable columns It's called a ColumnList, but don't let that confuse you. It's a very nice table/grid. It works well in Firefox and IE. Terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: scrolling table
Ah, I see. Still doesn't hurt to have two options. :) Peter Boughton wrote: Couldn't see if Jim's link had a solution on it, so here's one that definitely is: The scrolling one was called Grayed Out, which is the one I linked to (for examples, that site just reloads the same table and applies the current style). Sorry, should have pointed that out. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253525 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
duplicate name output
I have a form and recording the info in a database. The functionality works great, even send confirmation email. The issue I am having is the output page duplicates same names. My output page basically says Thank you #form_name# Your email has be sent to #to_name Etc. If the from_name is duplicated in the database the output is Thank you jane jane jane My Code: cfinclude template=Common.cfm cfset FileName=Send_Confirmation.cfm cfquery datasource=tellafriend name=confirm SELECT from_name from tellafriend_log WHERE log_id = log_id /cfquery html head titleTellAFriend/title /head body background=images/bg.jpg Your Message Was Sent.cfoutput query=confirm#confirm.from_name#/cfoutput/font/p table trtd valign=top align=centercfinclude template=Send_Confirmation_Confirmation_Show.cfm/td/tr /table /body /html Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: duplicate name output
It looks like your query is returning multiple records and then your cfoutput is looping through the query, so for each record it is displaying the from_name. You can either change the query to Select DISTINCT from_name (which should return 1 record) OR you can change your cfoutput to just cfoutput and omit the query part and it will just display the first record's from_name. Steve LaBadie wrote: I have a form and recording the info in a database. The functionality works great, even send confirmation email. The issue I am having is the output page duplicates same names. My output page basically says Thank you #form_name# Your email has be sent to #to_name Etc. If the from_name is duplicated in the database the output is Thank you jane jane jane My Code: cfinclude template=Common.cfm cfset FileName=Send_Confirmation.cfm cfquery datasource=tellafriend name=confirm SELECT from_name from tellafriend_log WHERE log_id = log_id /cfquery html head titleTellAFriend/title /head body background=images/bg.jpg Your Message Was Sent.cfoutput query=confirm#confirm.from_name#/cfoutput/font/p table trtd valign=top align=centercfinclude template=Send_Confirmation_Confirmation_Show.cfm/td/tr /table /body /html Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: duplicate name output
Sounds like you do not have a unique primary key, or you are not using it in your select. You may have 100 Janes in your database, but if you want to get this particular Jane's info, you need to select her by the primary key of that table. Just a guess... ~Brad -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 12:10 PM To: CF-Talk Subject: duplicate name output I have a form and recording the info in a database. The functionality works great, even send confirmation email. The issue I am having is the output page duplicates same names. My output page basically says Thank you #form_name# Your email has be sent to #to_name Etc. If the from_name is duplicated in the database the output is Thank you jane jane jane My Code: cfinclude template=Common.cfm cfset FileName=Send_Confirmation.cfm cfquery datasource=tellafriend name=confirm SELECT from_name from tellafriend_log WHERE log_id = log_id /cfquery html head titleTellAFriend/title /head body background=images/bg.jpg Your Message Was Sent.cfoutput query=confirm#confirm.from_name#/cfoutput/font/p table trtd valign=top align=centercfinclude template=Send_Confirmation_Confirmation_Show.cfm/td/tr /table /body /html Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
need some help with event gateways
I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Thanks -- Phil ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some help with event gateways
What issues are you having? I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Thanks -- Phil ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some help with event gateways
On 9/19/06, Michael Dinowitz [EMAIL PROTECTED] wrote: What issues are you having? I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Hi Phil, Jeff Peters recently published an article in the CFDJ specifically on the directory watcher. Perhaps this might help: http://coldfusion.sys-con.com/read/264734.htm Regards, Dave. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
I wonder if this issue has to do with Microsoft undermining Java (again) only this time its with the JDBC driver? I would switch up the driver and start over and see if the problem comes back. If this is a fix please tell everyone about it. Thanks Dan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFchart format=flash and DHTML
I'm working on a proof of concept page that displays 16 charts using the cfchart format=flash tag. This works just fine, their simple charts and they display fine if I display them all at once. But to add a bit of control to this, I created a bit of DHTML code that allows the user to see the charts one by one by selecting from a list of links. This works nicely for a bit, then fails. Apparently every time I show a div that was hidden, the flash object is going back to the server for its data. After a certain amount of time, this data is no longer available and I get the Image Expired, Please refresh the page to view the image error. I understand why this is happening, but is there any way that I can work around this issue. I'm hoping for some way to maintain the images or to always refresh them during the DHTML hide show magic. But nothing suitable has come to mind yet. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLog4j
Qasim,
Your code works, so I tested this outside the view of the CFC's and
inside a two liner and I don't get an error mesage
but strange [] - output in my log file. Do you know why?
cfset PropertyConfigurator = createObject(java,
org.apache.log4j.PropertyConfigurator
).configure('C:\CFusionMX7\wwwroot\cflog4j.properties')
cfset logger = createObject(java, org.apache.log4j.Category
).getInstance('myco.foo') /
cfset logger.info(Hello World) /
coldfusion-out.log keeps printing this
09/19 15:07:34 [] -
09/19 15:10:37 [] -
09/19 15:11:14 [] -
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253534
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Branch target offset too large for short?
Anyone seen this before? Im simply working with a CFC that has worked fine, until some changes ive just added, but nothing too crazy just some cfset statements, and some cfparams were added to it. thanks! tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253535 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Branch target offset too large for short?
See if this helps... http://www.easycfm.com/forums/viewmessages.cfm?Forum=12Topic=9444 Thanks, Matt -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 2:51 PM To: CF-Talk Subject: Branch target offset too large for short? Anyone seen this before? Im simply working with a CFC that has worked fine, until some changes ive just added, but nothing too crazy just some cfset statements, and some cfparams were added to it. thanks! tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: need some help with event gateways
I took the examples I've found and made a cfc that watches a directory for changes. I then tried to start my new gateway and it fails. I looked in the logs and I cant find any real error message. Just that it tried to start it. I tried to start the ones that came with MX7 and those fail to start too. Could this be a permissions issue? On 9/19/06, Michael Dinowitz [EMAIL PROTECTED] wrote: What issues are you having? I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Thanks -- Phil ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253537 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Branch target offset too large for short?
Do you have any cftransaction tags? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253538 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Branch target offset too large for short?
not a single on in the ENTIRE cfc. i already tried google :) but thanks! any other ideas? i mean, literally i added maybe 30 lines to it... and they were pairs of these: cfparam name = session.eventStruct.switchOne default=0 and then this... cfset session.eventStruct.switchOne = session.eventStruct.switchOne + 1 and thats it... maybe 15 pairs. h... a perplexed tony awaits your ideas! :) thanks. tw On 9/19/06, Alan Rother [EMAIL PROTECTED] wrote: Do you have any cftransaction tags? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253539 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 check the status of a checkbox in a array
I am creating an array of records in a single query.
I want the user to be able to select the records the wish to update, input the
new values for each record they with to update, then update.
I have my form which diplayes the infomation with the folloing checkbox. There
may be one record for one customers and five records for another.
If I check all of the checkboxes it works fine, If I don't I get this error.
This information is going into a holding database to be verified befor the
update takes place. That is the reason I am useing insert statments instead of
update statments.
Element fld_bussPurpChange_2 is undefined in a Java object of type class
coldfusion.filter.FormScope referenced as
Here is my code
Form.
cfinput type=checkbox
name=fld_bussPurpChange_#oracle_cust_bussPurp.currentrow# value=Yes /
Action.
cfloop from=1 to=#form.bussPurpRecords# index=ii
cfset variables.fld_bussPurpChange = form[fld_bussPurpChange_ii]/
cfset variables.SITE_USE_ID = form[fld_SITE_USE_ID_ii]/
cfset variables.SITE_USE_CODE = form[fld_SITE_USE_CODE_ii]/
cfset variables.LOCATION = form[fld_LOCATION_ii]/
cfset variables.TAX_REFERENCE = form[fld_TAX_REFERENCE_ii]/
cfset variables.TAX_CODE = form[fld_TAX_CODE_ii]/
cfset variables.PRIMARY_SALESREP_ID = form[fld_PRIMARY_SALESREP_ii]/
cfset variables.SHIP_PARTIAL = form[fld_SHIP_PARTIAL_ii]/
cfset variables.FREIGHT_TERM = form[fld_FREIGHT_TERM_ii]/
cfset variables.PRICE_LIST_ID = form[fld_PRICE_LIST_ID_ii]/
cfset variables.WAREHOUSE_ID = form[fld_WAREHOUSE_ID_ii]/
cfif variables.fld_bussPurpChange EQ Yes
!--- Update this product with the new id ---
cfquery name=insertSiteUseinfo datasource=cust_profile
INSERT INTO AR_RA_SITE_USES_ALL
(SITE_USE_ID,
FORM_REQUEST_ID,
NEW_OLD,
SITE_USE_CODE,
ADDRESS_ID,
LOCATION,
TAX_REFERENCE,
TAX_CODE,
PRIMARY_SALESREP_ID,
SHIP_PARTIAL,
FREIGHT_TERM,
PRICE_LIST_ID,
WAREHOUSE_ID)
VALUES
('#(variables.SITE_USE_ID)#',
'#(getRequestNo.New_req_num)+1#',
'New',
'#(variables.SITE_USE_CODE)#',
'#form.fld_ADDRESS_ID#',
'#(variables.LOCATION)#',
'#(variables.TAX_REFERENCE)#',
'#(variables.TAX_CODE)#',
'#(variables.PRIMARY_SALESREP_ID)#',
'#(variables.SHIP_PARTIAL)#',
'#(variables.FREIGHT_TERM)#',
'#(variables.PRICE_LIST_ID)#',
'#(variables.WAREHOUSE_ID)#')
/cfquery
/cfif
/cfloop
Thank you,
Keith
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some help with event gateways
One of the problems with gateways is that they operate in a different 'space' than a standard CF application and if an error is thrown, the site wide error handler does not handle it. What I do is have a separate gateway directory with my gateways in it (actually gateway stubs) along with an application.cfc. The onError method will send me an email dump of any error the gateway may have. CFFUNCTION name=onError returntype=void output=0 CFARGUMENT name=exception CFARGUMENT name=eventname CFMAIL to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Error (#CGI.HTTP_Host#): Gateway Services type=HTML CFDUMP var=#exception# label=exceptionbr CFDUMP var=#variables# label=variablesbr CFDUMP var=#cgi# label=cgibr CFDUMP var=#application# label=applicationbr /CFMAIL /CFFUNCTION This works VERY well for me and should get you right to the problem, which is probably a CFC issue. I took the examples I've found and made a cfc that watches a directory for changes. I then tried to start my new gateway and it fails. I looked in the logs and I cant find any real error message. Just that it tried to start it. I tried to start the ones that came with MX7 and those fail to start too. Could this be a permissions issue? On 9/19/06, Michael Dinowitz [EMAIL PROTECTED] wrote: What issues are you having? I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Thanks -- Phil ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253541 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 check the status of a checkbox in a array
If a checkbox is not checked, it doesn't exist in the form scope when
submitted, so you'll need to handle that, e.g.
cfif isDefined('form.myCheckbox')
use the checkbox
cfelse
Something else
/cfif
Note that this is different behavior from most other fields, where even
if it has no value, the field still exists in the form scope with a
blank value. With checkboxes, if there is no check, there is no field.
-Original Message-
From: Web Master [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 19, 2006 3:56 PM
To: CF-Talk
Subject: How to check the status of a checkbox in a array
I am creating an array of records in a single query.
I want the user to be able to select the records the wish to update,
input
the new values for each record they with to update, then update.
I have my form which diplayes the infomation with the folloing
checkbox.
There may be one record for one customers and five records for
another.
If I check all of the checkboxes it works fine, If I don't I get this
error.
This information is going into a holding database to be verified befor
the
update takes place. That is the reason I am useing insert statments
instead of update statments.
Element fld_bussPurpChange_2 is undefined in a Java object of type
class
coldfusion.filter.FormScope referenced as
Here is my code
Form.
cfinput type=checkbox
name=fld_bussPurpChange_#oracle_cust_bussPurp.currentrow#
value=Yes /
Action.
cfloop from=1 to=#form.bussPurpRecords# index=ii
cfset variables.fld_bussPurpChange =
form[fld_bussPurpChange_ii]/
cfset variables.SITE_USE_ID = form[fld_SITE_USE_ID_ii]/
cfset variables.SITE_USE_CODE = form[fld_SITE_USE_CODE_ii]/
cfset variables.LOCATION = form[fld_LOCATION_ii]/
cfset variables.TAX_REFERENCE = form[fld_TAX_REFERENCE_ii]/
cfset variables.TAX_CODE = form[fld_TAX_CODE_ii]/
cfset variables.PRIMARY_SALESREP_ID =
form[fld_PRIMARY_SALESREP_ii]/
cfset variables.SHIP_PARTIAL = form[fld_SHIP_PARTIAL_ii]/
cfset variables.FREIGHT_TERM = form[fld_FREIGHT_TERM_ii]/
cfset variables.PRICE_LIST_ID = form[fld_PRICE_LIST_ID_ii]/
cfset variables.WAREHOUSE_ID = form[fld_WAREHOUSE_ID_ii]/
cfif variables.fld_bussPurpChange EQ Yes
!--- Update this product with the new id ---
cfquery name=insertSiteUseinfo datasource=cust_profile
INSERT INTO AR_RA_SITE_USES_ALL
(SITE_USE_ID,
FORM_REQUEST_ID,
NEW_OLD,
SITE_USE_CODE,
ADDRESS_ID,
LOCATION,
TAX_REFERENCE,
TAX_CODE,
PRIMARY_SALESREP_ID,
SHIP_PARTIAL,
FREIGHT_TERM,
PRICE_LIST_ID,
WAREHOUSE_ID)
VALUES
('#(variables.SITE_USE_ID)#',
'#(getRequestNo.New_req_num)+1#',
'New',
'#(variables.SITE_USE_CODE)#',
'#form.fld_ADDRESS_ID#',
'#(variables.LOCATION)#',
'#(variables.TAX_REFERENCE)#',
'#(variables.TAX_CODE)#',
'#(variables.PRIMARY_SALESREP_ID)#',
'#(variables.SHIP_PARTIAL)#',
'#(variables.FREIGHT_TERM)#',
'#(variables.PRICE_LIST_ID)#',
'#(variables.WAREHOUSE_ID)#')
/cfquery
/cfif
/cfloop
Thank you,
Keith
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253542
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 check the status of a checkbox in a array
cfparam the checkboxes. Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: need some help with event gateways
Thanks Michael. I got it working now and ready to have some fun. WooWho! On 9/19/06, Michael Dinowitz [EMAIL PROTECTED] wrote: One of the problems with gateways is that they operate in a different 'space' than a standard CF application and if an error is thrown, the site wide error handler does not handle it. What I do is have a separate gateway directory with my gateways in it (actually gateway stubs) along with an application.cfc. The onError method will send me an email dump of any error the gateway may have. CFFUNCTION name=onError returntype=void output=0 CFARGUMENT name=exception CFARGUMENT name=eventname CFMAIL to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Error (#CGI.HTTP_Host#): Gateway Services type=HTML CFDUMP var=#exception# label=exceptionbr CFDUMP var=#variables# label=variablesbr CFDUMP var=#cgi# label=cgibr CFDUMP var=#application# label=applicationbr /CFMAIL /CFFUNCTION This works VERY well for me and should get you right to the problem, which is probably a CFC issue. I took the examples I've found and made a cfc that watches a directory for changes. I then tried to start my new gateway and it fails. I looked in the logs and I cant find any real error message. Just that it tried to start it. I tried to start the ones that came with MX7 and those fail to start too. Could this be a permissions issue? On 9/19/06, Michael Dinowitz [EMAIL PROTECTED] wrote: What issues are you having? I'm trying to do a basic directory watcher but I'm not having much luck. Can some one point me to a good tutorial for this? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFMX 7 - Oracle CLOB / cfstoredproc
I have been messing with this issue all day - searched around without much success. Here's the issue, we are on Oracle 10g R2. We upgraded our JDBC driver to 3.5. I am now trying to get the following test code to work (test.xml is a simple xml file): ** cffile action=Read file=C:\testing\Test.xml variable=variables.myXMLInput cfstoredproc procedure=TESTCLOB datasource=MYDNS cfprocparam cfsqltype=CF_SQL_CLOB type=In value=#variables.myXMLInput# cfprocparam cfsqltype=CF_SQL_CLOB type=Out variable=variables.myXMLOutput /cfstoredproc cfoutput#variables.myXMLOutput#/cfoutput ** The stored procedure is just copying the value passed in into the output variable. I've tested the procedure through PL/SQL developer and it works fine. The output of the above test code is this: [EMAIL PROTECTED] I realize what this is - the default ToString of a Java object - the address changes every time I refresh. The question is, how do I get to the value of the CLOB from this variable? I've tried to do a CFDUMP of the variable, but it actually causes CF to crash. Through debugging I can see the input was handled correctly - just can't get to the output. Any help would be appreciated. Regards, MG ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduled Tasks Not Running
Hello, having the same problem, and have changed the FILE security in IIS and still no luck... can you confirm what you did? I have: right click on 'test.cfm'in IIS, choose Properties click FILE SECURITY tab click Authentication and access Control EDIT button ??Leave enable anonymous access checked? (ive even set that to use my administrators account, with password -- with no luck) Uncheck Integrated Windows authentication Check basic authentication No luck, I get a CONNECTION FAILURE in the log file I create when task runs. Help! That did it!!! I changed the permission on the FILE itself, not the directory, and the task is now running as desired. Thanks SO MUCH for the lead. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253546 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use CFMX with SAP
marc -- wrote: Having an online timesheetmodule connected directly to SAP should makes things easier: the employee fills in the sheet (a form) and submits the timesheet to SAP. SAP validates the timesheetdata using it's validationrules and generates error messages if something's wrong. The idea is to have these error messages sent back to the client in response to the submit and have him/her correct the timesheet if needed. Since I am a CFMX programmer and not SAP knowledgeable I wonder if anyone on this list has experience with connecting CFMX to SAP. I am currently working on a CFMX - SAP project. What we did is totally isolate the regular CF cluster from SAP by placing a broker with message queue in between. Whenever something needs to go into SAP the regular CF calls an Event Gateway and then just sets the status to processing. The Event Gateway forwards the message through a web-service to a Java application running on another cluster. That Java application will also queue the message. I have been told that that Java appplication will eventually connect to SAP through a chain of .dlls, but that is all done by the SAP integrator. What we get back from it through a web-service is a status code. That status code goes back to the original workflow and the processing can continue on the CF side. This may be a bit overengineered, but not much. The bottom line is that interfacing with SAP is not easy. I will echo tanguyr: consult with a SAP developer. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
a bit OT...people counters and CF
anyone work with people counters from ProdCo before? Wondering if we can right our own stuff to nab the data from them. -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
trouble with permissions IISCSS
I am finishing up a project for Alpha presentation tomorrow on a client's server. Today, I FTP'ed all the files up to their server, but I am having trouble with my css files. My .cfm files are showing up fine, but all my layout files are not being processed, which throws off my whole presentation layer. I am getting the 401.3 error when I try to access them directly. In googling around, I think that I have a security access problem, but I am not anywhere near an IIS guy, so I'm not sure what I should change. Also, I don't want to tick off the IT guys who are running the server... Not sure even where to start. Any suggestions? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Use CFMX with SAP
I built a Flex front end schedule tool in my company to get them off that 1980's Excel solution. Used Java on the back side. Coupled with the below...bamm! With the new Flex 2, could even proxy through CFCs to Java Pojos or go direct with WebServices. DK On 9/18/06, tanguyr [EMAIL PROTECTED] wrote: Hi, I'm working on an application that gets and sends data to/from a SAP back end. We use the SAP Java Connector (JCO) architecture to expose SAP RFCs as methods in a stateless EJB, and call these from within cf (cfmx running in weblogic). You *should* be able to get most of the benefit w/out having to use EJB (our architecture is a couple of years old, but it works so we don't change it) by just writing some POJOs and deploying them in a jar in your cfserver's /lib directory and then using them via createObject or cfobject calls from within your CF code. More information about JCO is available here: http://help.sap.com/saphelp_nw04/helpdata/en/6f/1bd5c6a85b11d6b28500508b5d5211/content.htm Regs, /t marc -- wrote: Hello, I want to make a timesheet application for a company that stores al its HR (human resource) data in SAP. Currently employees fill in their timesheetdata in an Excel spreadsheet and email it to the company. The timesheet then is being validated by a Perl script and if OK sent by ftp to SAP. If not OK employees call back to manually correct the sheet. This is tedious and error prone process since it depends on many intermediate steps (validation scripts running, ftp connection up etc etc). When any of these fails the whole chain fails and often timesheetdata is not sent. Having an online timesheetmodule connected directly to SAP should makes things easier: the employee fills in the sheet (a form) and submits the timesheet to SAP. SAP validates the timesheetdata using it's validationrules and generates error messages if something's wrong. The idea is to have these error messages sent back to the client in response to the submit and have him/her correct the timesheet if needed. Since I am a CFMX programmer and not SAP knowledgeable I wonder if anyone on this list has experience with connecting CFMX to SAP. I'd like to get some tips please! -- View this message in context: http://www.nabble.com/Use-CFMX-with-SAP-tf2291598.html#a6367670 Sent from the Cold Fusion - Technical mailing list archive at Nabble.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Passing ColdFusion Arrays By Reference
Ben - See my comment on making your Collections syncronised - its something i hope you haven't overlooked. Mark On 9/20/06, Gert Franz [EMAIL PROTECTED] wrote: Hi Ben, i was quite astonished when I read that CF passes arrays as clones. Railo for instance does not. So Arrays (which are not simple values) are much faster than in MX. And Structures are up to 20 times faster then with MX. But you allways have to live with the fact that a passed variable can be changed inside a function. Gert Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Ben Nadel schrieb: Hey all, I was fooling around with some code last night and found a way to pass ColdFusion arrays by reference, and NOT by value. I am just very excited about this and though maybe you all would like to know about it to. From some prelim testing, it looks like passing by reference has HUGE performance gains and is just all around wicked sweet! http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S WEEET.htm ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfe aptana
does anyone know if cfe will work in aptana? I would just try it but everytime i add a non compatible plugin to eclipse is seems to take a big shit and i gotta start over. And I really like a lot of the features in Aptana, especially the css support, way better than myeclipse. tia dave ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfe aptana
n/m, i went ahead and tried it and it does work and the ftp actually kinda works too :) personally, i like this ide better so far. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX 6.1 and FC5?
Thanks, Tom and Steven. Steven, it is really so.5 that my CFMX 6.1 is looking for. I've read the tip on checking which rpm provides which on some other forum, and the libs I need comes from the openssl package. The openssql-9.7f which comes with FC4 has the so.5 libs, the openssl that comes with FC5 does not have the so.5, it has so.6 and so.4 but no so.5s whatsoever. FC5 does not have the openssl-9.7f. Does anyone here have successfully ran CFMX 6.1 on FC5? I am inferring that CFMX 7 can install on FC5, but not CFMX 6.1, the same way that a Postgres installer for FC4 won't install on FC5. I read from somewhere that I need to make an so.5 link that points to some other so's. I haven't tried, though. I am not very familiar with the library files. Thanks anyways. Please confirm the name of the missing library. I believe it may be libc.so.6 not .5. Using the rpm command it can be determined which package should have installed a file. Try rpm --query --redhatprovides filename (ref 1). On a RHEL4 system, /lib/libc.so.6 is installed by the glibc-2.3.4 package, same as CentOS. I don't have my FC5 installation in front of me, but I believe it has a newer glibc version. Checking Fedora package list I see it has 2.4-11 (ref 2), and it does appear that 2.4-11 should have installed libc.so.6 (ref 3). You may want to confirm the missing library name, confirm the package which should have installed the library, and then install that package. On the topic of distributions, if you must run a distro which is unsupported by Red Hat and unsupported by ColdFusion, then I would recommend CentOS rather than Fedora. Even Red Hat will tell you this. CentOS is a legal clone of Red Hat Enterprise Linux so Cent shares the same stability, reliability, and security as RHEL (ref 4). Fedora on the other hand is a bleeding edge distribution with the most bells and whistles and features which have not necessarily been tested to the extent that RHEL is tested. Since ColdFusion is supported for use on RHEL4, while you cannot open a support ticket with Adobe for support of CF on Cent, you can assume that CF will install and run the same, whereas results with Fedora will be in question. For the last 2 months I have been using ColdFusion MX 7 on CentOS (among other OSes), and have been very satisfied. -Steven Erat Adobe ColdFusion QA Refs *1 http://fedora.redhat.com/docs/drafts/rpm-guide-en/ch-command-reference.h tml *2 http://fedoranews.org/cms/node/1617 *3 http://rpmfind.net//linux/RPM/fedora/updates/5/x86_64/glibc-2.4-11.i386. html *4 http://linuxplanet.com/linuxplanet/reviews/5823/1/ What do you think? Have I left out anything in the installation? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfe aptana
Maybe it was the Aptana version I had installed, but I experienced bad memory leaks with it. After Aptana install Eclipse would run away with my resources requiring a fresh boot at least once a day, often more. I uninstalled Aptana, and the problem disappeared. Cheers, Kris n/m, i went ahead and tried it and it does work and the ftp actually kinda works too :) personally, i like this ide better so far. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253555 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDEVCON - UK coldFusion developer conference
Yes finally a UK ColdFusion developer conference (well a mini one at least), which will be taking place In November this year.. For more information please visit www.cfdevcon.com. -- Russ Michaels CFDeveloper - ColdFusion Developer Community www.cfdeveloper.co.uk ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253556 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 get these query results
So I have 2 tables. Example data and desire results below. EventID, EventName 1 | TestEventOne 2 | TestEventTwo EventID | EventDates 1 | 9/10/2006 1 | 9/20/2006 2 | 9/15/2006 !--- Desired results --- TestEventOne 9/20/2006 9/10/2006 TestEventTwo 9/15/2006 So basically I want to order by date, but group by the EventID. Ordering by date breaks the ability to group by EventID. I know I could do this by running a query as I do the output (even a QofQ), but was hoping to somehow get the results back in a way to output in this manner. Ideas are much appreciated. -- Matt Williams It's the question that drives us. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253557 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 get these query results
Select * from Table1 Inner join Table2 on table1.EventId = table2.eventId You might need a left or right outer join though Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 2:35 PM To: CF-Talk Subject: How to get these query results So I have 2 tables. Example data and desire results below. EventID, EventName 1 | TestEventOne 2 | TestEventTwo EventID | EventDates 1 | 9/10/2006 1 | 9/20/2006 2 | 9/15/2006 !--- Desired results --- TestEventOne 9/20/2006 9/10/2006 TestEventTwo 9/15/2006 So basically I want to order by date, but group by the EventID. Ordering by date breaks the ability to group by EventID. I know I could do this by running a query as I do the output (even a QofQ), but was hoping to somehow get the results back in a way to output in this manner. Ideas are much appreciated. -- Matt Williams It's the question that drives us. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253558 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 get these query results
Oops Sorry then you can cfoutput query=QueryName group=EventId Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253559 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 get these query results
cfquery name=your_query SELECT * FROMdates_table, events_table WHERE dates_table.EventID = events_table.EventID /cfquery cfoutput query=your_query group=EventID #EventName#br cfoutput group=EventDate #EventDate#br /cfoutput br br /cfoutput HTH(?) -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 9:35 PM To: CF-Talk Subject: How to get these query results So I have 2 tables. Example data and desire results below. EventID, EventName 1 | TestEventOne 2 | TestEventTwo EventID | EventDates 1 | 9/10/2006 1 | 9/20/2006 2 | 9/15/2006 !--- Desired results --- TestEventOne 9/20/2006 9/10/2006 TestEventTwo 9/15/2006 So basically I want to order by date, but group by the EventID. Ordering by date breaks the ability to group by EventID. I know I could do this by running a query as I do the output (even a QofQ), but was hoping to somehow get the results back in a way to output in this manner. Ideas are much appreciated. -- Matt Williams It's the question that drives us. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253560 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 get these query results
Michael, You really need to learn inner joins, sorry but that is bad sql code without it. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 2:55 PM To: CF-Talk Subject: RE: How to get these query results cfquery name=your_query SELECT * FROMdates_table, events_table WHERE dates_table.EventID = events_table.EventID /cfquery cfoutput query=your_query group=EventID #EventName#br cfoutput group=EventDate #EventDate#br /cfoutput br br /cfoutput HTH(?) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253561 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 get these query results
Andrew, The sql with cfoutput I sent Matt would do what he needed, as he stated- period. I know how to do inner/outer joins, but wont do it just for the sake of doing it. But thanks for your good advise. Michael -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:03 PM To: CF-Talk Subject: RE: How to get these query results Michael, You really need to learn inner joins, sorry but that is bad sql code without it. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 2:55 PM To: CF-Talk Subject: RE: How to get these query results cfquery name=your_query SELECT* FROM dates_table, events_table WHERE dates_table.EventID = events_table.EventID /cfquery cfoutput query=your_query group=EventID #EventName#br cfoutput group=EventDate #EventDate#br /cfoutput br br /cfoutput HTH(?) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253562 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 get these query results
That's ok, but for anyone else reading this. Although the sql is ok, it does end up being translated at the SQL server level with an inner join anyway. And in this case a left outer join might be better, because the results might not be what you would normally expect. Just for the newbies reading this thread. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:14 PM To: CF-Talk Subject: RE: How to get these query results Andrew, The sql with cfoutput I sent Matt would do what he needed, as he stated- period. I know how to do inner/outer joins, but wont do it just for the sake of doing it. But thanks for your good advise. Michael ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: trouble with permissions IISCSS
Write them in a CFM file and then it should be OK... so you will have something like this: link href=mycss.cfm type=text/css rel=stylesheet and in the mycss.cfm you have your styles and everything else... or you use style tags in your topmost cfm file. It's just a workaround until you can reach your IIS guys... Gert Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Crow T. Robot schrieb: I am finishing up a project for Alpha presentation tomorrow on a client's server. Today, I FTP'ed all the files up to their server, but I am having trouble with my css files. My .cfm files are showing up fine, but all my layout files are not being processed, which throws off my whole presentation layer. I am getting the 401.3 error when I try to access them directly. In googling around, I think that I have a security access problem, but I am not anywhere near an IIS guy, so I'm not sure what I should change. Also, I don't want to tick off the IT guys who are running the server... Not sure even where to start. Any suggestions? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253564 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 get these query results
And in this case a left outer join might be better, because the results might not be what you would normally expect. Andrew, pls explain what you meant by might not be what you normally expect? by a simple SELECT * query with a simple cfoutput grouping. And how using joins for this purpose will prevent any unexpected results as you stated. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:21 PM To: CF-Talk Subject: RE: How to get these query results That's ok, but for anyone else reading this. Although the sql is ok, it does end up being translated at the SQL server level with an inner join anyway. And in this case a left outer join might be better, because the results might not be what you would normally expect. Just for the newbies reading this thread. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253565 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 get these query results
Btw, Andrew, can you also send your idea on how it should be done on the SQL query with joins, but this time include your CF tags to output the results? I truly want to see how much better it is from a simple select with a simple cfoutput grouping. Thanks. -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:33 PM To: CF-Talk Subject: RE: How to get these query results And in this case a left outer join might be better, because the results might not be what you would normally expect. Andrew, pls explain what you meant by might not be what you normally expect? by a simple SELECT * query with a simple cfoutput grouping. And how using joins for this purpose will prevent any unexpected results as you stated. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:21 PM To: CF-Talk Subject: RE: How to get these query results That's ok, but for anyone else reading this. Although the sql is ok, it does end up being translated at the SQL server level with an inner join anyway. And in this case a left outer join might be better, because the results might not be what you would normally expect. Just for the newbies reading this thread. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfe aptana
on windows or mac? i've had it on all day in osx with nothing but smooth sailing, even with 3 browsers, mail, yahoo, aim, photoshop, illustrator, transmit, navicat, textedit, imageviewer itunes, eclise, flash 8 dw8 open Maybe it was the Aptana version I had installed, but I experienced bad memory leaks with it. After Aptana install Eclipse would run away with my resources requiring a fresh boot at least once a day, often more. I uninstalled Aptana, and the problem disappeared. Cheers, Kris ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253567 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 get these query results
Michael, I was under the impression you know what inner and outer joins are? But lets take your SQL Code. SELECT * FROMdates_table, events_table WHERE dates_table.EventID = events_table.EventID This is how the database will see that code SELECT * FROM events_table INNER JOIN Dates_table ON dates_table.eventId = events_table.EventId As for explaining, I think it is ok to make the assumption you know what inner/outer joins are:-) But it seems you don't know what a left or right outer join is then? So with your example it gets translated to a normal inner join, and you have no control. So this is preaching bad sql code in my opinion. Sorry this is way of the topic now, my only point was that when giving example SQL code it is best to give it properly in the first place, and to say won't do it for the sake of doing it is crap, because what you wrote is what I would say is bad practice. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:33 PM To: CF-Talk Subject: RE: How to get these query results And in this case a left outer join might be better, because the results might not be what you would normally expect. Andrew, pls explain what you meant by might not be what you normally expect? by a simple SELECT * query with a simple cfoutput grouping. And how using joins for this purpose will prevent any unexpected results as you stated. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253568 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 get these query results
Michael, You still use the cfoutput as I sent through before in another message, just that your sql query is preaching bad standards that's all:-) Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:39 PM To: CF-Talk Subject: RE: How to get these query results Btw, Andrew, can you also send your idea on how it should be done on the SQL query with joins, but this time include your CF tags to output the results? I truly want to see how much better it is from a simple select with a simple cfoutput grouping. Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfe aptana
Hmm, have you tried using cfeclipse with the aptana plugin? Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253571 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX 7 - Oracle CLOB / cfstoredproc
Did you check whether Oracle executes the storedproc? You could use the monitorin tool for that while cfm executes. what happens if you call the function directly inside a cfquery tag and dump the result? Just try to fill a variable without . notation eg myXMLOutput. After that, i have no ideas... :-) good luck Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Mike Garner schrieb: I have been messing with this issue all day - searched around without much success. Here's the issue, we are on Oracle 10g R2. We upgraded our JDBC driver to 3.5. I am now trying to get the following test code to work (test.xml is a simple xml file): ** cffile action=Read file=C:\testing\Test.xml variable=variables.myXMLInput cfstoredproc procedure=TESTCLOB datasource=MYDNS cfprocparam cfsqltype=CF_SQL_CLOB type=In value=#variables.myXMLInput# cfprocparam cfsqltype=CF_SQL_CLOB type=Out variable=variables.myXMLOutput /cfstoredproc cfoutput#variables.myXMLOutput#/cfoutput ** The stored procedure is just copying the value passed in into the output variable. I've tested the procedure through PL/SQL developer and it works fine. The output of the above test code is this: [EMAIL PROTECTED] I realize what this is - the default ToString of a Java object - the address changes every time I refresh. The question is, how do I get to the value of the CLOB from this variable? I've tried to do a CFDUMP of the variable, but it actually causes CF to crash. Through debugging I can see the input was handled correctly - just can't get to the output. Any help would be appreciated. Regards, MG ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253570 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 get these query results
AMEN! -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 12:48 AM To: CF-Talk Subject: RE: How to get these query results Michael, I was under the impression you know what inner and outer joins are? But lets take your SQL Code. SELECT * FROMdates_table, events_table WHERE dates_table.EventID = events_table.EventID This is how the database will see that code SELECT * FROM events_table INNER JOIN Dates_table ON dates_table.eventId = events_table.EventId As for explaining, I think it is ok to make the assumption you know what inner/outer joins are:-) But it seems you don't know what a left or right outer join is then? So with your example it gets translated to a normal inner join, and you have no control. So this is preaching bad sql code in my opinion. Sorry this is way of the topic now, my only point was that when giving example SQL code it is best to give it properly in the first place, and to say won't do it for the sake of doing it is crap, because what you wrote is what I would say is bad practice. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:33 PM To: CF-Talk Subject: RE: How to get these query results And in this case a left outer join might be better, because the results might not be what you would normally expect. Andrew, pls explain what you meant by might not be what you normally expect? by a simple SELECT * query with a simple cfoutput grouping. And how using joins for this purpose will prevent any unexpected results as you stated. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Awesome ColdFusion Developer needed in Auckland or Christchurch, New Zealand!
ProActive Software Ltd ( www.proactivesoftware.com ) is a fast growing global, innovative web-based software provider. It has developed a project and time-tracking solution that services thousands of users globally. PAS is looking for the right person, with the right attitude and skill set to join its rapidly growing company. ProActive Software is looking for an experienced ColdFusion programmer to join its Development Team, to help with enhancing and maintaining the companyâs web-based product â Proworkflow, as well as custom development of this product, and other solutions. In addition, this position administers MS SQL Server databases and IIS. This position works closely with senior management on high-level projects and requires someone who can self-manage and prioritize multiple projects. We are an innovative virtual team and therefore this vacancy is open to applicants from any location, however Auckland based applicants will be preferred. Requirements: - Strong Cold Fusion development experience (at least 4 years) - At least 4 years experience in SQL with strong Transact SQL or PL/SQL experience - Minimum of 2 years experience working with relational databases - creating, managing, normalizing databases - IIS administration experience a must - Excellent problem solving skills Desired Skills/Experience: - Experience with Java / Javascript a plus - Experience with AJAX a plus - Windows 2000 System Administration skills a plus - Experience in graphics design, Flash a plus If you have a passion for high level application development and you believe your skills and attitude would suit ProActive Software please send your CV and any URL's linking to recent work to [EMAIL PROTECTED] . Regards, Julian Stone, Director www.ProWorkflow.com ProActive Software Ltd ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3140 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Sr. ColdFusion Developer NYC
JOB PURPOSE/OBJECTIVE: Web application development / programming for the Reis.com ecommerce portal and customer applications. ESSENTIAL DUTIES AND RESPONSIBLITIES: You will work in small to mid-size teams with other project managers to develop Web-based, mission-critical applications using predominately ColdFusion MX, Python, Zope, Linux, Oracle and HTML for the Reis.com ecommerce portal and customer applications. You will be involved in the entire and ongoing development lifecycle of projects including participation in discussions on design specifications, providing input on IT solutions, troubleshooting application issues, documenting detailed specifications, and ensuring the ongoing maintenance of all applications. QUALIFICATION REQUIREMENTS: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and abilities required: ⢠Minimum of 5 years experience in software application development. ⢠Minimum of 5 years experience with ColdFusion required. ⢠Minimum of 5 years experience in Oracle 8i or other DBMS specifically database integration with ColdFusion. ⢠Broad knowledge of the system development lifecycle and proven ability to adhere to project management deadlines. ⢠Demonstrated ability to develop software test strategies, troubleshoot software issues, and recommend viable solutions. ⢠Demonstrated ability to work effectively both individually and in cross-functional teams, including excellent ability to work effectively with internal clients and external service providers. ⢠Strong written and oral communication skills, including strong technical documentation ability. ⢠Internet-based application development or distributed object architectures preferred. At least 5 years experience with Internet technologies and significant additional application development experience in client-server environments preferred. PREFERRED: ⢠Minimum 5+ years experience in Linux knowledge ⢠Minimum 5+ years experience in client server background (in VB 6, Java or similar) ⢠Minimum 5+ years experience in object-oriented design and analysis. ⢠Python experience preferable. ⢠Other: Linux, Apache, GIS mapping. EDUCATION AND EXPERIENCE: ⢠Minimum Education Requirement: Bachelors degree in computers or engineering field. Please send your resume to [EMAIL PROTECTED] ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3141 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: Not a jobs list
Thank you Michael for informing us. Shiva -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 8:23 AM To: CF-Jobs-Talk Subject: Not a jobs list The CF-Jobs-Talk list is for discussion about jobs, the job market and related concepts. This is NOT a jobs list, which is the CF-Jobs list. I'll be removing all jobs that have been posted to this list so if you want your job seen, I'd repost it to CF-Jobs as soon as you can. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3143 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
