Re: CF Job Market
Software development technology changes too fast for people to rest their laurels and not keep up. That's why I always recommend looking at the past 3 years experience on a candidate's resume since anything after that for the most part may not be helpful to me or the intended client. If by anything after that you mean anything before that, then you may be missing rather a lot. It's well over 20 years since I first started doing relational database design, SQL, UNIX, TCP/IP, systems analysis, object-oriented programming, agile project management, test-driven development, automated builds and version control. HTTP and HTML have been around for well over a decade. None of these things are remotely new. The most complicated and important component of any system - the human being - is also quite an old design. What are the seismic changes that have taken place in software development over the last three years that have made those technologies pale into insignificance? From a web development point of view, the biggest recent innovation that I can think of is ASP.NET's event model, which is so contrived that it *deserves* to be met with hesitation and disdain - and that's at least 6 or 7 years old. Nick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4121 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: OT-ish: JSP equivalent for application.cfc?
Pete Does JSP have an analogue to the application.cfc file? No, at least not a standard analogue (some JSP containers like JRun have/had a non-standard thing called global.jsa.) You can initialise simple global variables using web.xml. Any other tips for a CF guy teaching himself JSP? I'm using Apache Tomcat. Take a look at tag libraries (taglibs), Struts and Hibernate. A JSP app written using taglibs looks remarkably like a CF application - not surprisingly, since taglibs were invented by people from Allaire, I believe. Nick ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287512 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query speed diference
Jay Which of these two methods would be faster? - Method 1 - cfquery SELECT * FROM table WHERE someID = #someVar# /cfquery cfif query.recordCount IS 1 cfqueryUPDATE table.../cfquery cfelse cfqueryINSERT INTO table.../cfquery /cfif - Method 2 - cfquery DELETE FROM table WHERE someID = #someVar# /cfquery cfqueryINSERT INTO table.../cfquery You can achieve an improvement by either: - changing your logic so that you know whether to do an update or insert without needing to check the record ID against the database; or - whichever of the 2 methods you use, combining the 2 SQL statements into one stored procedure or at least one CFQUERY. Nick ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Difficulty with forms and dynamically named variables
Hugh I'm trying to create a query based form which reads it's elements from a database table, then populates itself. Each input element would have be dynamically named via the DB query. Creating the form isn't so bad, but handling the insert query the other side is becoming a headache. I can't figure out how to recreate the dynamic names of the form variables and extract their data for insertion into the DB. Unless you need to insert records relating to checkboxes that aren't checked, you can just iterate over the Form structure and see what field names you've got there. Nick ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with Simple SQL Insert
Aaron Here is the error message: Query Error: Data truncation: Out of range value adjusted for column 'ordernumber' at row 1 Here is the SQL statement: INSERT INTO orders(ordernumber, tax, shipping, total) VALUES(558972266568040,0.0,4.75,24.7) In my database (MySQL 5) I have the following fields in my orders table: id (int 11) ordernumber (int 75) tax (double) shipping (double) total (double) I'm surprise MySQL let you define a column as int 75. No normal computer can store an integer with 75 significant digits. You might have meant to use DECIMAL - but actually I think a character type would probably be more appropriate. Nick ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reading CSV files with the ODBC text driver
Hello everyone, long time time since I was here. I'm trying to read a CSV file with CFQUERY using the ODBC text driver as described at http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv. I get this error: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'C:\test\testfile.csv'. Make sure the object exists and that you spell its name and the path name correctly. It doesn't matter where I put the file, I always get this error. Windows XP, CFMX 7.0.2, MDAC 2.8, Jet 4.0 Service Pack 8. Any ideas? Thanks Nick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading CSV files with the ODBC text driver
Have you tried using CFHTTP? It can also return a CSV/Text file as a query. Thanks for the suggestion Matthew. I was hoping to get the CFQUERY approach working because presumably it's the most efficient, and I may have a lot of data to process. Nick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading CSV files with the ODBC text driver
Mark Is the file unlocked and does the driver have permissions to access it? It should be unlocked - it's been uploaded by a CFFILE just before the CFQUERY is run. As regards whether the driver has permissions to access it - CF certainly has, but I don't know about the driver itself, if that's a separate issue - how do I tell? Thanks Nick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading CSV files with the ODBC text driver
Dave Actually, if you uploaded it in the same request as the CFQUERY, it is probably locked by CF, so you won't be able to use it through ODBC (which runs as a separate process). It's not the same request, but a subsequent request in the same session - do you think it would still be locked by CF? Is there a way I can see for myself if the file is locked and by what process? Thanks Nick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading CSV files with the ODBC text driver
Ryan I'm surprised you would get a file not found error if the file was there but locked? Are you 100% sure the file exists at C:\test\testfile.csv ? Yes, 110%. Nick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Low-tech asychronous call to ColdFusion
I am aware (somewhat!) of the asynchronous Web services capability with CFCs in ColdFusion. What would listers recommend if I simply want to call a ColdFusion action page asynchronously. The asychronous call is a one-way trip and does not require data back to the caller. The really simple solution is to create a JavaScript Image object and set its src attribute to the URL of the action page. The user has no sure way of knowing that the request even got to the server, let alone whether there was a processing error. But it works. Nick ~| 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/cf_lists/message.cfm/forumid:4/messageid:246850 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using SQL profiler with cfqueryparam
This is not an SP per se, it is just how SQL handles these dynamic SQL strings. Upon further research this is a SP. sp_prepare() and sp_execute() are system stored procedures which respectively prepare and execute the SQL. The SQL code from your cfquery does not become a stored procedure, it's just a batch of SQL. When you use cfqueryparam, SQL server uses this execution model (aka prepared statements). I haven't checked this, but presumably if you're seeing the call to sp_execute(), you should be seeing the sp_prepare() as well, which will let you make the link between SQL code and parameter values. Nick ~| 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/cf_lists/message.cfm/forumid:4/messageid:246910 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query help
The results are great but in some instances a country will appear twice, with two different count values, I want the country to appear once with the total count of both results. select COUNTRY, sum(NB_PROFILES) from (your entire select statement here) group by COUNTRY should do it? Nick ~| 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/cf_lists/message.cfm/forumid:4/messageid:246503 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query help
Martin Thanks for the reply. Yeah I just came up with the same myself as a Q of Qs. I tried it in the original union query, which would be the ideal solution for me having it all in the same query, but Oracle throws me an inconsistent data types error?? Can SUM be used in a union on oracle? I don't see why there should be a problem with the SUM. Maybe the data type inconsistency is between cl.COU_LIB and newgide.country_iso.cis_lib? Nick ~| 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/cf_lists/message.cfm/forumid:4/messageid:246508 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select * in SQL
Heres a real world scenario I've come across: Code throughout the app is using data returned from a query that has select *, and pulls data from more than one table. Someone adds a column to one of the tables in the query that has the same name as a column in another of the tables in the query. CF now returns a query with 2 columns named the same and your data is funked up all over the site because using query.columnname is referencing the wrong column. Some people disagree with this, but I recommend using a naming convention that makes this impossible. In other words, one where the table name can be inferred from the column name. Nick ~| 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/cf_lists/message.cfm/forumid:4/messageid:246130 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jfreechart
Anyone use CF with jfreechart? I'm trying to create a MeterPlot, but it's coming up blank. Yes, but we don't use MeterPlot. I'd RTFM if there was a better FM :) I know what you mean. Have you tried the forum? I've always managed to get answers there. http://www.jfree.org/phpBB2/viewforum.php?f=3 Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245642 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: XML storage of metadata in database fields
We have an application that allows users to specify (at initial setup time) to specify what kind of metadata they want to enter when they work with digital media within the application. For example, one user may want to upload a bunch of Word doc files and then enter a set of metadata (say Title, Description, Source, Location, etc.). Another user may want to enter a combination of images, docs and movie files and then enter a different set of metadata (say Title, Description, Period, Style, Location, Dates, Sequence, etc.) If we go the traditional database route, this would involve lots of dynamically named fields which I envision as really messy. We think that storing these individual metadata sets as XML data (keyed to ID fields in the db) would be the way to go. Does anybody have any experience/thoughts on this approach? I think the key question is, what are you going to use the metadata for? If you are going to want to use metadata fields for searching/sorting/analysis, I would go with the traditional database route. This is what we do in our CMS. A little complicated maybe - you need a lot of tables to get a really flexible solution - but not messy. If the metadata of each set of objects is of interest only as a sort of guide to that set of objects in isolation once retrieved from the repository, and particularly since you mention Sequence, then your idea is a bit reminiscent of a manifest file that you attach to objects in an object packaging scheme like IMS Content Packaging, which is a desperately complicated e-learning interoperability standard but you might be interested in some of the concepts: http://www.imsproject.org/content/packaging/cpinfo10.html http://www.imsproject.org/metadata/mdbest01.html Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245054 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Documentation
How do you guys go about technical documentation, how do you write docs that tell other people (not necessarily technical, but project participants) how your code works, what the rules are, what the re-use potential is, how the UI works etc. What tools do you use for the job? Word? Visio? Wiki? How do you tackle it and when? Before writing your code? After? For us, the exact set of documentation deliverables is very project-dependent and is thrashed out at a high level at project initiation time and then in more details at the beginning of each project stage. It depends on the complexity of the job, the customer's expectations and the development method used for the project, but in general you need to have documentation tasks in all three places - beginning, middle and end. You need to document the functional and non-functional (performance etc) requirements up front or the project will fail. You need to document what you're doing at each stage in order to have a managed process (imo this is true even if you're doing agile development). And you need to document what you've done at the end, or the documentation will not reflect reality. We do still use Word/PDF for those documents where a simple, visible version control scheme is critical. We store everything in our web-based project support environment as a central reference point. Being basically a CMS, besides storing files it allows you to create more free-form web-based documentation as you go along, whether as traditional pages or blog/wiki/forum/helpfile entries. It also creates interactive diagrams. We use a lot of diagrams because they are information-rich and (some) customers can understand (some of) them. We use all sorts of diagramming techniques, both from UML and older toolsets. The only thing I would caution against is creating too many detailed how-to documents with embedded screenshots - they become a real pain when you want to change things. An up-to-date Captivate demo is much more likely to be correct and consistent. However, sometimes customers want things on paper. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242893 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Is anyone out there using any kind of generic database management scripts...something that could be plugged in to a homegrown CMS to provide easy management of those other tables that must be dealt with? Basically something where you can define a schema, and it will produce the pages/forms to browse, edit, add, delete, etc. I've got one that I've been using for years which is kludgy and limited, but gets the job done...I was thinking about writing a new one, but I wanted to see what is out there first. When you say, define a schema do you mean you want the tool to build the database for you as well? Or do you want a tool that you can point at an existing database that will examine its schema and give you a forms interface to it? Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: datatypes, calculations and DB experts
I have recently found a bizarre situation where numbers are not calculating correctly when the values are stored in FLOAT data types. This is not just a database-related issue - it's found in computer systems in general. Floating point numbers are by definition approximations. This often surprises people. As you suggested, the DECIMAL type is provided by many DBMS to get around exactly this problem. DECIMAL numbers are not approximations. They take up much more space to represent very large or very small numbers and aren't directly supported in hardware, so they are less efficient. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240732 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Does coldFusion just need a servlet engine
Tomcat J2ee server is indeed a true j2ee server and not just a servlet container. To run CF you need the J2EE version. Tomcat is a servlet container. It is a true J2EE server to the extent that it supports parts of the J2EE specification such as servlets and JSPs, but it is not an EJB server. You can run ColdFusion on top of Tomcat. You don't need EJBs for ColdFusion. The only thing I can think of that Tomcat wouldn't support natively is event gateways, which require a JMS server. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239222 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ASP.Net book for CF programmer
It is not clear from what I've read on ASP.Net if their canned form controls are actually necessary or not. No, they're not necessary, but as you say, you would never guess that from most of the stuff written about ASP.NET. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get String Byte Size
Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. The number of bytes occupied in the application's memory by the Java String object is probably not the same as the number of bytes occupied by the same string in the HTTP response. I could be wrong on some points below but I'm sure others will correct me if so (Paul?) As I understand it, a Java program such as CF always stores characters internally using UCS-2 encoding, i.e. 2 bytes per character. In addition, the String object will include 20 or 30 extra bytes for storing the length of the string etc. I believe that CF's default behaviour is to encode HTTP responses using UTF-8 encoding, i.e. 1 byte per character if you're only using ASCII characters, and of course the extra bytes used by the String object won't be there either. So let's say your string is Rob. - In CF the Len() function gives you 3. - The size of the Java object - even if you could work it out, which is next to impossible in Java - would be 6 + the extra bytes, maybe 40 or more. - But in the HTTP response it would probably be 3. So, if I've understood your question correctly and it's the HTTP response you're interested in, just using Len() in CF will give you the best answer. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238125 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Evaluate vs ?
Is there a time when evaluate should be used? If you want to dynamically build an unpredictable string which contains logic, rather than just variable names, then afaik you can only invoke the logic using Evaluate(). But then again, that's not something that people need to do very often. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238024 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Evaluate vs ?
Last year you gave $#lsnumberformat(lastyear, 9.99)# to support our work. This year we hope you'll give $#lsnumberformat(lastyear*2, 9.99)#. My mailer routine uses evaluate against the string to parse out those values, then it is sent out via cfmail inside a loop. If Evaluate() isn't recommended, is there a better way to do this? Typically this type of mailing might go out to 10 or 12 thousand emails at once. You mean you create a textual email template for each new mailing which includes some raw CFML for the mail-merge fields? That seems a pretty good case for using Evaluate() to me. Unless it's giving you bad performance problems - if so, I guess you would be forced to restructure your system so that your email template is no longer data, but a compiled CFML template. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238029 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: connecting to an ftp site using CF?
So then I try with just the domain: ftp://tgftp.nws.noaa.gov And get the same error. Then I tried copying the code directly from the MM docs and I get the same error. We're running CFMX 6.1 on a *nix server. Is there something I'm doing wrong? Take out the ftp://; Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237515 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Looks like hard to find data modelers in the CF community
Looks like it is hard to find data modelers in the CF community. Well, one here, but... First, what exactly are the characteristics that you want to test? Functionality, usability, performance...? For the purposes of this test, why does it matter if it's the type of data model you describe, or even a good data model? Or is it more of a demonstration that you want to set up? Isn't populating the data going to be a bigger problem than designing the data model? Second, I would say the best data model is the one that best matches the enterprise rules encapsulating a particular set of requirements. So no-one can say which off-the-shelf one is best for you without knowing your enterprise rules. I've never used an off-the-shelf data model and I can't imagine how you'd evaluate one properly - you'd have to study it to see if it matched your requirements, but presumably the vendor wouldn't let you do that. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237194 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Looks like hard to find data modelers in the CF community
I don't think anyone mentioned an off-the-shelf data model. That's what the OP was asking for, in fact. The original thread was called CF interacting with Teradata Server: There is an application that is built entirely in Coldfusion for doing ETL (Extraction Transformation and Loading) of data from one database into another. Now, in order to test this tool on a real time project, there is an unrelated issue that is taking time. We need to design the database in Teradata and then use this tool to map data from SQL Server tables into Teradata tables. In order to create the database design, I have been asked to find out the best Logical Data Models there are in the industry. The company is willing to pay money to purchase those models. We are looking for retail LDM samples in general and coupon business related in particular. I do not know how to do the research and find the best commercial LDM out there. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237199 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verity operators are great - but what are they in Arabic/french/german/chinese???
When you search a collection in a language other than English, you must translate operators such as AND and OR into the language of the collection. Where do we find these operators? Does anyone have an exhaustive list they would like to share? Google for localized query language Some of the documents suggest you can use English operators by using #AND instead of AND etc - I haven't tried it. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237076 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamically creating fields
I have been searching for a method (and here is where I am stumped at the terminology to search for!) to dynamically add properties to some record. snip Any pointers? This must be a problem that has been addressed a number of times Yes, certainly have addressed it a number of times. With a relational database the only options afaik are: 1. change the underlying structure 2. have a (huge) table containing the attribute values of each entity separately, with a lookup table of attributes 3. have a finite number of extra user-definable columns in each table (custom field 1, custom field 2 etc) We use 2 in our CMS. I refer to this as soft metadata but I don't know what anyone else calls it. It's the only solution that's generic enough for our purposes, because we provide an object-oriented data model with a kind of multiple inheritance. The performance implications need an awful lot of attention though. If solution 1 is an option, I'd consider it very carefully. Some software packages use option 3 rather successfully but it's basically a kludge, isn't it. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231076 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SeeFusion versus FusionReactor [was: Monitoring JRun Memory Usage]
How does it compare to SeeFusion? U might want to have a look at fusion reactor. I haven't used either of them yet - if anyone has used both, it would be great to hear what you think. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230216 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Monitoring JRun Memory Usage
Russ U might want to have a look at fusion reactor. Have you used this does it do what it says? It looks fantastic. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230167 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: UML programs?
Have you tried ArgoUML? There is also an Eclipse plugin, EclipseUML, though I haven't tried it. What do you mean by database uml diagrams and full program diagrams? Nick sorry for the somewhat off topic post, but does anyone know of or can recommend a good free (hopefully open source) uml program? We specifically need the ability to do database uml diagrams, but also full program diagrams is needed as well. I have looked at and tried several but they all seem to be lacking. And visio is a little too pricey. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: UML programs?
Try either ArgoUML or Poseidon - they're closely related. No little icons like that though, at least not in ArgoUML. Nick No, havent tried argoUML yet. I looked at eclipseUML, but when I downloaded it, it had the entire eclipse program along with it, not just the plugin, and I wasn't sure which plugin was the right one. All I mean by the database diagrams is that it have icons or pictures or representations (not sure what you call it) for different database types, like booleans, varchars, numerics, etc. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226806 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: iTEXT
Lol, interesting. I guess it's not mentioned anywhere that iTEXT ships with CFMX7 then. Which is a tad lame. I gues sthat effectively means it would be easy to write a better cfdocument tag. Not too easy to do the FlashPaper part! But if you wanted to produce RTF for example, then yes. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216320 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: iTEXT
Russ I have been asked to install iText on a shared server, but it seems that it could potentially be unsafe to do so as I would imagine iText has the ability to read/file files anywhere on the server seeing as java components are not affected by a security sandbox. I don't think iText itself does any file access. If your customers aren't allowed to use CFOBJECT or CreateObject, then they won't be able to do much with it. If they are, then they will have access to the java.io classes anyway. It's those classes that do the actual file reading writing - iText just adds functionality which understands how certain types of files are structured. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216214 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: iTEXT
Russ Are there any docs anywhere for installing it on CF, can't see anything on the site You just need to get hold of the jar file and drop it in somewhere on the Java classpath. Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: list reverse function
does anyone have a listreverse udf kicking around or know of one? http://cflib.org/udf.cfm?ID=51 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211727 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
XML from a XSD
someone knows a CFX or Custom Tag to create a XML structure from a XSD? How could you do that, given that there can be all sorts of optionality and alternatives built in to a schema? Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfchart not working on new server
We have recently had three CF7/IIS2003 servers set up for us at a third party hosting company. These are brand new installs on brand new machines. All is well except that cfchart is not working for us. It works fine for us on our local CF7/IIS2003 machine. We've been unable to spot the difference between the setups. Have they got the same graphics card? We once had a weird problem with charts not working - on the original version of CFMX I think - which we eventually traced to the graphics card. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Statistical Functions and Boxplots
I have a client who wants some data represented by boxplots. I've been unable to find software for CF which will automatically calculate and graph the required information (upper quartile, lower quartile, median) from raw data passed, so I need to find a way of performing these calculations myself and pass them to the graph software. We have a customer that we calculate quartiles for (CF6.1, SS2K) and in that application we draw line graphs and bar charts using jFreeChart, which I believe can do boxplots although we don't currently use that part of it. Worth a look if you don't mind doing Java. Quartiles are not what you said. In colloquial use they are what Jochem said, but our customer says a) it is one value, not a set of values b) the algorithm used by Excel is wrong As you know, the customer is always right. We do it their way, with some CF and SQL which is rather slow but not very complicated. Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209107 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Database error
I'm getting this error, whenever I'm trying to update the database, I'm using CFMX 7, this is my query UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = 'M' WHERE Person.Objectno = 2005 Are you using backtick characters around blopez5955 instead of single quote characters? Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206886 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: built-in server in ColdFusion MX?
What is the built-in server in standalone ColdFusion MX? Is it JRun 4? I asked someone and they said no but the I used the variable server.coldfusion.appserver, it displays JRun 4. So can you tell me whether the built-in server is the same as the appServer? It's not the same, no - at least, it depends on the context. When people refer to the built-in server, they generally mean the HTTP server, aka web server, that is built in to JRun. CFMX exists in a JRun environment, which includes JRun's built-in web server. You can configure JRun to connect to either the built-in web server or to connect to an external web server such as Apache or IIS. So if you're using CFMX, you are always using the built-in *application server* or servlet container, JRun, and you *may* be using the built-in *web server* or HTTP server, which unfortunately has no name afaik except for the built-in server. Just to make things more confusing, within JRun you can have several different named configurations running, each of which is referred to as yes, a server. CFMX is one such server (the cfusion server within JRun). And then of course all this software runs on a host computer, which is generally referred to as a Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198811 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (OO) UI in CFCs
Someone I work with uses CFCs for UI. For instance, something he did is make a CFC that runs a query and returns a recordset. He then passes the recordset to a UI CFC and it formats the results in a datagrid fashion. We do something similar. We have a set of report-building CFCs where you can populate paragraphs of text and arrays of data, then choose to (re-)display the report as HTML, RTF, PDF or CSV, with the arrays shown as tables or charts. Some kind of object-oriented approach is ideal for this. I can't see any sense in the assertion that you shouldn't use CFCs for UI. Why on earth not? In fact, in my experience the object-oriented approach is more useful for UI than it is for business data processing - although of course this is far more true when you're programming an interactive stateful environment (ActionScript, JavaScript etc). Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: jrun.dll on J2EE
Thanks again Dave. OK. In general, you shouldn't need to have two different enterprise applications within the same JRun server instance. Each one can be deployed within its own server. The CF EAR can handle JSP and servlet requests if you want to run a Java web app within the same server instance. Yes, that's what I thought. When you installed CFMX, how exactly did you do it? Did you install it onto an existing JRun server? If your existing JRun server was already configured to work with IIS, it won't automatically handle CF requests - there's a little check box within the web server configuration tool that you'd need to check when you define the connection. Onto an existing JRun install, but I don't remember at what point the cfusion *server* was created. Maybe I missed an uninstall step and it was already hanging around from when I had CF6.1 on the same machine. Yes, I remember the check box and I did check it, but... at this stage I think it will be best if I uninstall everything start again from scratch. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196714 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: jrun.dll on J2EE
In that case, you might want to try using a different user agent, to see the raw error message returned by the server. If you can get into the CF Administrator, you might also enable robust exception information. It's an HTTP status 503. Here's the IIS log #Fields: c-ip cs-username s-sitename s-ip s-port cs-method cs-uri-stem cs-uri-query sc-status sc-win32-status sc-bytes cs-bytes time-taken cs-version cs-host cs(User-Agent) 127.0.0.1 - W3SVC1 127.0.0.1 80 GET /x.cfm - 503 0 0 400 610 HTTP/1.1 127.0.0.1 Mozilla/5.0+(Windows;+U;+Windows+NT+5.1;+en-US;+rv:1.7.5)+Gecko/20041107+Fir efox/1.0 127.0.0.1 - W3SVC1 127.0.0.1 80 GET /x.cfm - 503 0 0 482 0 HTTP/1.1 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1)+Opera+7.20++[en] 127.0.0.1 - W3SVC1 127.0.0.1 80 GET /x.cfm - 503 0 0 229 0 HTTP/1.1 127.0.0.1 amaya/8.1b+libwww/5.4.0 127.0.0.1 - W3SVC1 127.0.0.1 80 GET /x.cfm - 503 0 0 265 0 HTTP/1.0 127.0.0.1 Mozilla/4.7+[en-gb]+(WinNT;+I) 127.0.0.1 - W3SVC1 127.0.0.1 80 GET /x.cfm - 503 0 0 194 0 HTTP/1.0 127.0.0.1 Lynx/2.8.3rel.1+libwww-FM/2.14FM 127.0.0.1 - W3SVC1 127.0.0.1 80 GET /x.cfm - 503 0 0 101 0 HTTP/1.0 127.0.0.1 Wget/1.8.1 All those different browsers return variants on the same theme: nothing whatsoever, empty document, unexpected network error etc. Robust debugging is on (as I said, CF is fine with the builtin web server so I can use the administrator) but since nothing is getting back to the browser, that makes no difference. It occurred to me that the reason why JSPs are working and CFM aren't is probably connected with the fact that they are being handled by different Enterprise Applications within the server. So IIS is pointing all the requests at the cfusion server, but within that the JSPs are being handled by default-ear and CFMs are supposed to be handled by Macromedia ColdFusion MX, i.e. cfusion-ear. I've been trying to figure out where this division of responsibilities is configured. I see that in cfusion/cfusion-ear/cfusion-war/WEB-INF the web.xml file contains servlet-mappings for .cfm, .cfc and .cfml, and the same in j2ee-web.xml (what is this file for?). Whereas the web.xml in cfusion/default-ear/default-war/WEB-INF contains no servlet mappings at all. However, further up, at the server level, in cfusion/SERVER-INF, there is a servlet mapping for .jsp. I don't know enough about JRun to know how these files will be used - but could there be something wrong here? Should I even have 2 different Enterprise Applications within the cfusion server? Thanks Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: jrun.dll on J2EE
The file version of my jrun.dll is 4.0.3.19147. It's not working for .cfm files (.jsp files seem OK) on IIS5.1/JRun4/CFMX7. Can anyone tell me if this is the correct version for CF7? I guess maybe not, since it was created by the wsconfig tool which is part of JRun4 which pre-dates CF7. If not, where in the CF7 J2EE download - or elsewhere - can I find the new one? Judging from the info Steven Erat sent Mike Kear, the dlls have not changed so I don't understand why JRun can't handle CFM requests from IIS. I'm going to repeat my original post on this with a few extra details in case anyone knows (Steven?) : IIS 5.1 on Windows XP Pro. CF running in J2EE mode on top of JRun4. Befor installing CF7 I decided to re-install JRun. That went fine. I downloaded the J2EE version of CF 7 installed the cfusion server in JRun. That's also fine. I can run CF apps and JSPs/servlets via the JRun web server with no problem. Also, IIS is serving HTML, ASP and Perl with no problems. Now, to connect CF up to IIS. I ran the JRun Web Server Config Tool and connected the cfusion server to the web site in IIS. I see in IIS that the JRunScripts virtual dir has been created and the jrun.dll has appeared, and the mappings for jsp, cfm, cfc etc have been created. Now when I hit a .jsp page that's located under wwwroot, it works. So IIS is obviously managing to hold *some* kind of conversation with the cfusion server via jrun.dll. However, when I try to hit a .cfm page that's located under wwwroot I get Cannot find server or DNS error. Or sometimes, it just hangs. Why would JSPs work but CFMs not? My wsconfig log file looks like this 2005-02-23 14:31:34 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Extension - Sep 2 2004 07:21:07 2005-02-23 14:31:34 jrISAPI[init:1220] JRun ISAPI Extension DLL Attaching 2005-02-23 14:31:34 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Filter - Sep 2 2004 07:21:09 2005-02-23 14:31:35 jrISAPI[init:1220] JRun ISAPI Extension DLL Detaching (FreeLibrary) 2005-02-23 14:31:39 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Extension - Sep 2 2004 07:21:07 2005-02-23 14:31:39 jrISAPI[init:1220] JRun ISAPI Extension DLL Attaching 2005-02-23 14:31:39 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Filter - Sep 2 2004 07:21:09 2005-02-23 14:33:51 jrISAPI[filter:1220] jrSend failed[2216]: 10054 Connection reset by peer 2005-02-23 14:42:08 jrISAPI[filter:1220] jrSend failed[2216]: 10054 Connection reset by peer 2005-02-23 14:57:54 jrISAPI[filter:1220] jrRecv failed[2216]: 10053 Connection aborted My jrun.ini file looks like this verbose=false scriptpath=/JRunScripts/jrun.dll serverstore=C:/JRun4/lib/wsconfig/2/jrunserver.store bootstrap=127.0.0.1:51002 apialloc=false ssl=false ignoresuffixmap=true #errorurl=optionally redirect to this URL on errors #proxyretryinterval=number of seconds to wait before trying to reconnect to unreachable clustered server #connecttimeout=number of seconds to wait on a socket connect to a jrun server #recvtimeout=number of seconds to wait on a socket receive to a jrun server #sendtimeout=number of seconds to wait on a socket send to a jrun server 51002 is the correct proxy port for the cfusion server. My wsconfig.properties file is: #JRun/ColdFusion MX Web Server Configuration File #Wed Feb 23 14:31:34 GMT 2005 2=IIS,1,true, 2.srv=localhost,cfusion 2.cfmx=true,null My jrunserver.store file just contains proxyservers= Any ideas? Thanks Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: jrun.dll on J2EE
However, when I try to hit a .cfm page that's located under wwwroot I get Cannot find server or DNS error. Or sometimes, it just hangs. I'm not sure what problem you're running into, but in any case you'll want to disable friendly HTTP error messages in Internet Explorer to see more information. Thanks Dave. But they are disabled already, in fact. Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [cfaussie] Re: Problems installing CFMX 7
I have a similar problem, though I arrived at it a different way. IIS 5 on Windows XP. CF running in J2EE mode on top of JRun4. Befor installing CF7 I decided to re-install JRun. That went fine. I downloaded the J2EE version of CF 7 installed the cfusion server in JRun. That's also fine. I can run CF apps and JSPs/servlets via the JRun web server with no problem. Also, IIS is serving HTML, ASP and Perl with no problems. Now, to connect CF up to IIS. I ran the JRun Web Server Config Tool and connected the cfusion server to All web sites in IIS. I see in IIS that the JRunScripts virtual dir has been created and the jrun.dll has appeared, and the mappings for cfm, cfc etc have been created. However, when I try to hit a .cfm page that's located under wwwroot I get Cannot find server or DNS error. Or sometimes, it just hangs. What am I missing? Thanks Nick - Original Message - From: Sean Corfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 23, 2005 7:35 AM Subject: Re: [cfaussie] Re: Problems installing CFMX 7 Mike, I wish I could offer some help here... I can only suggest that you apply for the position of Macromedia ColdFusion Installation QA since you seem capable of breaking our installers in every possible way... :) I'll send parts of this thread to the installer guys here and see if they can help you off-list... Sean On Wed, 23 Feb 2005 07:13:19 +1100, Mike Kear [EMAIL PROTECTED] wrote: Thanks Michael, I did both of those things, and they apparently did what they're supposed to, because there were no error messages, but then what? I still can't get the administrator to work, because it still wants to download the index.cfm file rather than run it. If i run the jrun web server configuration tool, it still doesn't enable the OK button, still can't find any Jrun. If I try to manually configure the IIS5.1 because apparently the installAnywhere routine doesnt want to, I can't even add the .cfm file extension to the configuration of the default site, because there is no .exe file to add to the dialog box. I still say there ought to be some information at macromedia.com to help people for whom things dont go perfectly. Like me. I think that's far more important than explaining what happens when it's a perfect installation for people who never need to see it. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196065 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [cfaussie] Re: Problems installing CFMX 7
Mike No I haven't. Why? Wouldn't that mean IIS wouldnt be running and therefore my non-CF sites woudlnt work? No, you can run IIS and JRun's builtin server simultaneously on different ports. JRun will automatically choose a port that's free. However, using the builtin server isn't really very satisfactory if you want a local dev or staging copy of a site which is deployed on IIS in production - which is why I too am trying to get IIS connected to CF. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196072 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfdocument formats
What happened to the idea of cfdocument supporting RTF? Clearly it didn't make it into this release - can anyone say if it'll be in a future one? Thanks Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: isCreditCard() and Mastercards?
Has anyone noticed that the isCreditCard fuction from cflib.org (http://www.cflib.org/udf.cfm?ID=49) doesn't work with Mastercards? Guess I need to double-check its validation routines. It did work for Mastercard when I wrote it, but that was during the CF5 beta, so maybe their format has changed? I must admit I haven't used it for years. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193846 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: isCreditCard() and Mastercards?
If anyone is interested, I wrote a validation function based on the LUHN formula to validate card numbers. I may be wrong but I think this is exactly what the first part of IsCreditCard() does. Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193867 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
Getting the following error from my ocde below, any ideas folks? What does your XML look like? Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
Is it best to leave Coldfusion alone when it comes to dealing with XSLT and XML ? No, you can do this very neatly in CFMX using the XmlTransform() function. Also, the xml2query suggestion was a good one if you want to minimise lines of code. However, if efficiency is an issue and the XML is very simple and predictable, it may be worth writing your own lightweight parser to translate straight from XML to CSV without any intermediate steps. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT:: How would I re-write this SQL query???
This should be pretty easy for one of you SQL gurus out there... That depends on what you want to achieve! SELECT * FROM ORDERS WHERE SUM(SubTotal + Shipping) = #FORM.TotalCharge# Maybe you mean SELECT * FROM ORDERS WHERE SubTotal + Shipping = #FORM.TotalCharge# ? Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191802 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX ODBC/JDBC Drivers
comparative testing of these aspects as well as performance, or do you know of any such testing that's been done? nope. are you volunteering? Well... we'll start by trying it out in a couple of apps if we find out anything interesting will post it. Thanks Nick ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX ODBC/JDBC Drivers
Paul pretty much everybody knows better than ms when it comes to JDBC sql server. ms's JDBC driver originally came from datadirect hasn't really progressed that far. and my own testing is exactly the opposite of your findings, ms's JDBC driver was the 3rd slowest i tested: #1 jTDS http://jtds.sourceforge.net/ #2 datadirect #3 ms JDBC As well as performance, other aspects to a DB driver are stability functionality (like support for SQL syntax the JDBC spec). Did you do any comparative testing of these aspects as well as performance, or do you know of any such testing that's been done? We're thinking of trying out jTDS but I'm wondering whether the speed comes at a price if so, what the tradeoff is. I've read what they say about jTDS on sourceforge and of course it sounds great, but any kind of independent corroboration would be nice, particularly from people who've used it in a CF context. Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191657 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: software lifecycle/project management tool/process recommendations
Can anybody recommend any good resources on tried and true definitions of the process? That is where we are stuck at. Our organization lacks the experience of large software design so we have no real process. But we are getting more and more of it. I've been tasked with learning how this is done, and presenting it. But I have little idea where to start. A couple of classic books to get you started - McConnell - Code Complete (very practical - don't let the MS imprint put you off) Pressman - Software Engineering: a Practitioner's Approach (a bit more theoretical but gives you all the background) There are a lot of methodologies out there that will give you a cookbook-type approach. I would divide these roughly into older waterfall style methods like SSADM, Information Engineering, CASE*Method, and newer iterative things like RUP (Rational Unified Process, from the same stable as UML), DSDM, XP. Common sense is probably your most useful guide though. Good luck Nick ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191516 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. ERwin and Embarcadero could both be considered industry standard. We use a home-grown web app - Flash diagramming tool on the front end, integrates with our CMS at the back, generates MySQL, SQL Server, Oracle databases. Couldn't live without it. Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190719 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: XML Variable Issue
If I run the following code... cfoutput#Config.SiteConfig.SiteSections.UserManager#/cfoutput The expected result... True Is output to the browser, however the following code samples... cfif Config.SiteConfig.SiteSections.UserManager cfif Config.SiteConfig.SiteSections.UserManager IS TRUE cfif Config.SiteConfig.SiteSections.UserManager IS TRUE All fail. Anyone any idea what I am doing wrong? The XML file contains the line UserManagerTrue/UserManager How about cfif Config.SiteConfig.SiteSections.UserManager is True Nick ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190742 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
And I have a hard time trusting anything that goes from diagram to DB FOR you, mostly because I've never seen anything auto-generated by anything that auto-generates that was really as well-done as it could have been. What type of shortcomings do you have in mind? Nick ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Extra query info
Here's a conceptual question. Lets say you have a query with multiple rows in it. There is a few calculations that will take place between items in a row to get some additional values per row (i.e. a discount price, etc.). One way of doing this is when outputting the query, you send the specific data to a CFC (It's used in multiple places) and get out a structure. This means that a 20 row query has 20 calls to the CFC. Another way of doing it is to pass the whole query to a CFC which will then loop over the query, do the calculations and then place the results into new columns within the query. The first has a single loop but multiple CFC calls while the second has 2 loops (inside the CFC and out) but a single CFC call. Which do you prefer? Do you see a problem with either approach? If the query data came straight from a database rather than being a QoQ or something , then I would prefer to do all the calculations in the original SELECT statement, maybe in a stored procedure - is that an option? Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question for Java people on this list: Converting a CF app to JS P
Mario Does anyone know if this can be done with the SWITCh statement in JSP. Can switch be used on strings --- I have been told yes and no by different people No, afaik the switch statement in Java needs a simple scalar type such as int or char. I suggest you use if...else if. Nick ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188926 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question for Java people on this list: Converting a CF app to JS P
It seems to be kind of poor not to be able to use switch on a string. If I use the dept number say (0305) instead of the name would this work or would Java freak on the 0 (zero). Our database treats these fields as varchar since the zero in front has meaning to the accounting people. Yes, it's a pain. The department number would work except that you are right, Java would take the initial 0 to mean it's an octal number. Nick ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188930 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RSS feed with a node like this itms:artist
I'm trying to parse an RSS feed and I'm at a loss as to what to do with data in this format. CF pukes when it hits the colon The name would be like rss.channel.item.itms:artist.xmltext Is the namespace for itms defined in the document's root element? Like for example rdf:RDF xmlns:itms=http It may be that the RSS is broken you need to modify it (insert the namespace in the right place) before parsing it. Nick ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RSS feed with a node like this itms:artist
John For the most part it validates. The lines that don't pass muster are date elements. Here's the link in case anyone wants to take a look. Thanks a lot. http://ax.phobos.apple.com.edgesuite.net/WebObjects/MZStore.woa/wpa/MRSS/topsongs/sf=143441/limit=15/rss.xml?partnerId=30LS_PARAM=http%3A%2F%2Fclick.linksynergy.com%2Ffs-bin%2Fstat%3Fid%3DnmYGzu6hxgs%26offerid%3D78941%26type%3D3%26subid%3D0%26tmpid%3D1826%26RD_PARM1%3D There's not much wrong with that. I did an xmlParse() and CFDUMP of it without any problems. I guess you just need to tweak the way your CF code accesses the struct elements representing the XML nodes which have a colon in their name. By using square brackets rather than dots, maybe? Nick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187973 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OO Coding Relational Databases
1: I think they call it brute force, where data access is in the business objects themselves (queries right in the classes). This is generally frowned upon. It's correct to say that many OO-pattern-bandwagon-jumpers frown on this. IMO it's also correct to say that for the majority ofapplications this is in fact an appropriate mechanism, unless your app is specifically targeting multiple physical storage platforms. The latter case is what the DAO pattern is actually for. Don't be persuaded that because an OO pattern sounds clever, it's actually appropriate for what you're trying to do. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Caching CFC's
Does someone now ways to do some CFC caching? Storing CFCs, including instance data, in the Session scope certainly seems to work for me - I imagine Application would be the same. I do it very simply like this: cfif not isDefined(Session.cfcInstanceName) cfobject component=cfcName name=Session.cfcInstanceName !--- invoke all the methods that set up the persistent data --- /cfif cfinvoke component=#Session.cfcInstanceName# ... Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Array cell name as dynamic left-hand-side of an assignment
This works (assignment to an explicitly named array cell): cfset ary = ArrayNew(3) cfset ary[1][1][1] = 99 This works (assignment to a dynamically referenced scalar variable): cfset scl = scalar cfset #scl# = 99 This (assignment to a dynamically referenced array cell) throws an error: cfset ary = ArrayNew(3) cfset tst = ary[1][1][1] cfset #tst# = 99 It says: The string ary[1][1][1] is not a valid ColdFusion variable name. Well, clearly that's incorrect, because it works in the first example. I guess array cells are a special case. I'm trying to find a way of assigning values to arbitrary cells in an array with an arbitrary number of dimensions. Is there a way round this or should I just store the data in nested structs instead? TIA Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML Question
What am I missing when trying to access the pattern node? cfdump. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Coldfusion Web Image Editor
The types of functions you are describing need not be client based. You could do this by just selecting an area of an image (a fairly easy dhtml or flash function), then submitting the results to the server with the imagename, function and select area. Yes, this is exactly what we do. We have a DHTML front end which allows you to select an area of the image, which talks to a JSP back end which uses java classes to do the heavy lifting. Works beautifully - gives the server a lot of work though. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Process Modeling Tool
I am looking for a tool/software so that I can create graphical respresentation of processes.I guess something like Visio. If you're looking for something on the desktop, SmartDraw works for me. If you want something to integrate into a web app, there are 2 possibilities worth mentioning: - If you only want to auto-create a static diagram from something that's in a database already, SVG is ideal. The only problem is that people need an SVG-enabled browser to see it. - If you want something interactive, this can also be done with SVG, but Flash is a more suitable tool. We've got something like this in our CMS - we built a generic diagram editor that can create any type of diagram so long as it consists of shapes joined by straight lines with various types of connector shapes, and we use it in the CMS for several purposes - describing workflow processes, designing relational data models, and visualising semantic networks (metadata vocabularies). I like it so much I use it instead of SmartDraw for a lot of things now. Example of a workflow diagram here: http://www.devoil.biz/workflow.jpg Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: keyword 'Where' error
Is there a problem with this Insert? I get an Incorrect syntax near the keyword 'Where' error. You can't have a where clause on an insert statement. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Process Modeling Tool
You bulit this in Flash? Yes. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Project Management System in CF
D'oh!*project* management, not *content* management.My bad. Does anyone know of good project management system written in CF or maybe JSP. I could write my own but I just do not have the time as usually. Funnily enough we have a project management system built into our content management system. (JSP-based, works with SQL Server or MySQL, we have run it successfully in a CF environment). We also have a simple bug tracking/ help desk module (CF) and we're currently working on integrating them, along with a test management module. The main feature of the project management part is a Flash-based interactive Gantt chart which reads writes to/from *either* the main CMS database (which stores details of teams and team members) *or* an XML file so that you can use it independently of the CMS if you want. This also has a team diary view, but there are no other reporting features yet. Screenshots of the Gantt chart that I happen to be working on right now here: http://www.devoil.biz/taskList.jpg http://www.devoil.biz/groupsList.jpg Mail me offlist if this looks helpful. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: blackstone talk at CFUN
1) didn't Netscape have a flaver of _javascript_ that supported push technology -- called LiveScript? You're thinking of LiveConnect, but that was simply an interface for client-side communication between JS and applets. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Stress testing tools - OpenSTA vs JMeter
Does anyone have a view on which of these is a better tool for stress testing a Java-based web app on a remote Linux server and/or on local Windows dev boxes? And why? Or is there a better free tool (eg MS WAS)? What I'd like to achieve is an integrated approach where we can generate HTTP requests on the client(s), and record the statuses and timings of the responses, but also somehow record/analyse what's happening inside the server (Apache, MySQL, JVM, JRun etc) at the same time. Or would it be more sensible to use different tools for these two jobs - finding problems vs investigating them? I'm looking to standardize on something for ongoing use as part of a development process, so I guess another important thing is the features for recording/storing/sharing reasonably complex scenario information. We're also considering moving to Eclipse/Ant/JUnit - any synergies there would be great, which seems to point towards JMeter...but OpenSTA appears a more finished application? Thanks Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Create Links Symlinks with CFMX/Java
Is it possible to create a file system link or symlink with CFMX/Java? The built-in java.io package doesn't provide any way to do this, because it's a 'nix-specific thing. Can be done in Perl though. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - help in SQL query
i'm looking for any help to do this query works fine SELECT `groups`.`groupsDescr`, `roles`.`roles_Agroup`, `roles`.`rolesDescr`, COUNT(`roles`.`rolesDescr`) AS TOTAL FROM `roles` INNER JOIN `groups_roles` ON (`roles`.`rolesID` = `groups_roles`.`fkrolesID`) INNER JOIN `groups` ON (`groups_roles`.`fkgroupsID` = `groups`.`groupsID`) GROUP BY `roles`.`rolesDescr` WHERE COUNT(`roles`.`rolesDescr`) GT 5 Using MySQL give me an error. how to do that? All those backticks give me a headache probably MySQL too. GT isn't SQL, it's CFML. Most importantly, you need to GROUP BY the columns that *aren't* referenced in aggregate functions (eg COUNT), not the ones that are. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Intranet/Hosting Toolkit
anybody heard of the Intranet/Hosting Toolkit for Coldfusion ? Yes. A lot of people have used Lewis' tags over the years. Have you tried mailing him? His address is on the site. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web stats software
Can Awstats be used on a Shared server where I do not have access to install application but to FTP files? I think as long as there's a Perl interpreter installed and you have a cgi-bin and your log files are in the right format you'll be OK. You can definitely update the stats over the web as well as viewing them. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFX_ConsoleCommand and CFX_Execute
Based on your signature Kev, is Sky Active etc running on CF? If Kev won't comment, then I'd better not either. But this is what Jeremy Allaire says: http://www.meetthemakers.com/conversations/allaire/2/ (second-last paragraph) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Help...
Jeff I guess I am having an off day with SQL. I think technically this should work but I get a syntax error UPDATE Account a SET a.last_update = (SELECT TOP 1 h.tranDate FROM History h WHERE a.Account_Number = h.Account_Number ORDER BY h.tranDate DESC) I would think this is likely to give an error because there's no reason syntactically why the subselect should return a single value - that 1 could be any other number. How about something like UPDATE Account a SET a.last_update = (SELECT max(h.tranDate) FROM History h WHERE a.Account_Number = h.Account_Number) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Coldfusion and XML
Dave I think I need to send an XML feed back to a client from the server, the client machine is a touch screen that will remotely make a call to, I think, a file on our webserver that will run a query on the database and return the results - which I believe have to be in the form of an XML Feed. Not stupid or wrong but certainly possible - the touch screen can contain a link to a ColdFusion template which generates an XML document. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: xslt beginners guide?
Anybody recommend any good forums for XSL/XSLT beginners? Books and all recommendations welcome. I have a Wrox book by Michael Kay, who knows a thing or two about XSLT. There used to be a related forum on wrox.com which Michael was on, so you could always get an answer if your question was interesting enough. Not sure if it's still there. I wouldn't say the book makes XSLT exactly easy to understand, but I think that's because XSLT just isn't very easy to understand ;-) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: onClick Nightmare!
Hello everybody. Thebelow code works, however when I don't know how to put the same code in the windows.open. Put it in a function script language=_javascript_ function openPopup(number, otherNumber) { x = window.open(...); } /script ... > Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MS SQL [ when to use the money datatype ]
You should use numeric or decimal. Both are exact numeric types which allows you to specify the precision. The main reason not to use money is that it is not completely standardized, i.e. there is no money type in the JDBC spec. Also, depending on your requirements, using numeric and a separate column to store the currency is more flexible when working with multiple currencies. Dan didn't say it was an issue for him, but it may also be worth pointing out that not all currencies have two decimal places. In one multicurrency (banking) system in the past I stored all money amounts as integers (number of pennies) and scaled as appropriate. Painful though. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL grouped query help
Now, I want to select only the latest article from each issue in a single query. Any ideas how I would do this? Kind of sneaky, but something like this will do it (substitute the relevant type conversion string concatenation functions for your DBMS) SELECTarticleIssueId, articleTitle, articleDate FROMmyArticles WHERE convert(char(16), articleIssueID) + '_' + convert(char(16), articleID) IN (SELECT convert(char(16), articleIssueID)+ '_' + convert(char(16), MAX(articleid)) FROM myArticles GROUP BY articleIssueID) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Javascript documents?
Does anyone know of a simple visual representation of _javascript_ objects, properties, methods, etc. in a simple table view? Mozilla Firefox DOM Inspector (in the custom install Developer Tools) Or of course, ahem, Visual Interdev ;-) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Is this possible in HTML?
Do a google search on 'Server Side Includes'.You should get a wealth of information on it. Or from a client-side perspective, there are many possibilities with object, script (in conjunction with document.write) and iframe. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: #url#
I imagine isDefined() works by using try/catch internaly Since all the variable scopes are structs, I guess it just looks for the key in the relevant struct(s). Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Server Table Design Question
Just to play devil's advocate and also enjoy the unusual experience of disagreeing with Dave - your proposed approach of adding a surrogate key is our standard way of doing things. Even when the table is a simple intersection table consisting of nothing but 2 foreign keys, we always make the primary key an IDENTITY/autoincrement field. We never use a compound key as the primary key (though of course we use them as secondary keys). Why? Because it maximizes the amount of our code (including our automated ER-modelling-to-schema-generation app) that can work exactly the same way for different tables and even different applications. In conjunction with rigid standards for table column naming, it adds up to more productivity in the long run. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can someone recommend a good web development browser?
Mozilla Firefox. Check out the extensions. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
My companies live hosting server was recently upgraded to Coldfusion MX6.1 .. and the latest MDAC / Jet Drivers have been updated also. The problem is that all coldfusion sites on the server using access db's stop working every 2 days or so (more often if traffic is high).. the only way to get it running again is to restart the whole server. We certainly have this problem too, I just don't know the solution. Does anyone else? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Jochem Have you tried the unicode driver? Any particular reason why this might help? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Improving stored procedure
BackOrder NOT LIKE '%HR%'could be causing you problems even if that field is indexed, because you're not looking at the beginning of the field. Is there anothere way of doing it? For the title fields also, have you considered full text indexing? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Jochem It doesn't use the ODBC workaround. People have also reported dramatic speed improvements with large datasets using this driver. OK, very interesting, thanks. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Improving stored procedure
Just curious, cause I don't know Sql Server... In oracle, those null checks on URL and BackOrder would also cause problems because they would negate any indexes on those fields.Is that the case in Sql Server? I don't think they would make the index unusable, but obviously IS NULL and IS NOT NULL aren't going to narrow things down much. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 'bug'? Easy to crash CFMAIL.
The proper way to do this is to perform the syntax check yourself, and only call CFMAIL if necessary.If anything, CFMX should be kind enough to add a new function isValidEmail() since most webapps do it pretty often. Does cflib count? http://www.cflib.org/udf.cfm?ID=216 Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]