coldfusion 9 - script for search tags
Within CF9, is there a script equivalent for the search tags - cfcollection, cfindex, cfsearch? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Forums using CFCs?
Lol... Sorry, I didn't mean to start a debate on whether-or-not Galleon is CFC based (I never stated it wasn't). Yes, it is CFC-based (or cfD, or CFQ, with moo.cfc integration :) ) - what I was really looking for is options. It seems that your two choices for a coldfusion forum are CFMBB and Galleon - I've looked at both and to reiterate they aren't really what we're looking for. Basically I'm looking for a very simple CFC-based forum - I don't need nor want RSS, bbtext, attachments, etc but I do want something that has threads, replies, and scrubs input. Does anyone know of other forums for Coldfusion? think he was saying the others did not have the feature set he was looking for. that is why I posted my question!! because in reality his request does not really say much about what he is looking for except it should be simple and cfc based. and yes Galleon is CFC based. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Forums using CFCs?
Great list, thanks Raymond! As a quick FYI, RIAForge is having issues today. I've had to restart it a few times and won't have time to really dig until tonight. So, if it is down, say a few quick prayers and reload in 10 minutes. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Forums using CFCs?
I know I'm kicking a dead dog asking about forums, but I need current information so please bear with me. :) I'm currently working on a project where a forum is desired, and I'm hoping someone has developed something that we can use rather than reinventing the forum yet again :). This forum should be very simple - allow posts, reply to post, and some moderation/administration tools. It is important that whatever we use is heavily CFC-based - our framework is entirely OOP/CFC based and a series of CFMs would be very out-of-place. We have looked at Galleon and CFBB, and they're just not what we're looking for. Any suggestions would be appreciated! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336131 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) International countries and states/provinces/administrative div. database
For the life of me I cannot find a complete international Countries/States database... The best I have found is the GeoDataSource World Cities database, but I'm having a hard time feeling comfortable with assuming a SELECT DISTINCT state,country would return a match for EVERY state,country in the world; also I'm missing abbreviation data from this database. Anyone have a good source for this data? P.S. I'm using the term 'state' loosely here - please assume I'm referring to the provinces, administrative divisions, etc of the world. Thanks in advance! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) International countries and states/provinces/administrative div. database
What about the UN list? http://unstats.un. org/unsd/methods/m49/m49alpha.htm Thanks for the reply Roger. This does help with the country side of the data, do you know of a list like this for the states within a country (with abbreviations)? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CSS editor for eclipse galileo?
Hi everyone, does anyone have any recommendations for a CSS editor for eclipse galileo? I used to use aptana, but it just does WAAAY more than i need it to, and it seems to get in the way of CFEclipse at times (for example, when I have aptana cfeclipse installed i can no longer drag drop text). I'm okay with firing up an external editor if there's a good free one available. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
documenting code
I'm looking to document our codebase. I'd like to use the documentation format that Java uses (http://java.sun.com/javase/6/docs/api/), Coldbox uses (http://www.coldboxframework.com/api/), and others... First off - what's the name of that documentation format? Secondly - I know someone has put together a CF tool for this already; can someone remind me what it's called? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldbox - mxunit testing database interaction
I'm just starting to get into Coldbox and I'm encountering some confusion as to how to *really* test my models and database interaction. So I have the following handler function which is fired upon form submission: cffunction name=editAction cfargument name=event type=any cfscript var rc = arguments.event.getCollection(); var demoModelObj = getModel('demoModel'); demoModelObj.editUserObj(rc); runEvent('demoApp.list'); /cfscript /cffunction ... which calls the following model function: cffunction name=editUserObj cfargument name=rc type=struct required=true hint=request collection / cfscript if (structKeyExists(rc,'userID')) { instance.usersObj.load(rc.userID); instance.usersObj.setAll(rc); instance.usersObj.save(); } /cfscript /cffunction This all works fine and dandy (at least for a 'hello world' coldbox application - I know this code is lacking in a number of places). So now I'm trying to set up a mxunit test to test the behaviors of the handler, but I'm coming to a blank when I try to come up with an assertion for this... I could bundle the whole test up in a cftransaction, and rollback when I'm done - I get that, but the problem is I don't see how to test this w/o writing twice as much code within the test. Take the following beginning of a unit test: cffunction name=testEditAction cfargument name=event type=any cfscript var event = ; var rc = ''; // set up fake form submission rc.userID = 1; rc.userName='testUser'; rc.password = 'testPass'; rc.departmentID_fk = 1; event = execute(demoApp.edit); rc = event.getCollection(); debug(rc); // what to do here? /cfscript /cffunction ... what kind of assertions can I make at the 'what to do here?' line? Is there an easy way to get at instance.usersObj from the model's method, or do I have to have my model return it (seems wrong to have the model return just to allow for debugging)? Am I totally missing the short-bus here? Any insight would be greatly appreciated! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldbox - mxunit testing database interaction
Thanks for the response Matt. I'll repost this there. In the meantime for anyone else viewing this thread, what I'm struggling with is finding out if the save occurred successfully. Maybe the answer is that I should be unit testing the model directly and ignoring this test within the handler's unit tests. Here's what I'm thinking this unit test should look like (partial pseudo-code): cffunction name=testEditAction cfargument name=event type=any cfscript var event = ; var rc = ''; var testObj = ''; // set up fake form submission rc.userID = 1; rc.userName='testUser'; rc.password = 'testPass'; rc.departmentID_fk = 1; event = execute(demoApp.edit); rc = event.getCollection(); debug(rc); testObj = createObject('component','path.to.users'); testObj.load(rc.userID); assertEquals(testObj.get('username'),rc.username,'usernames are not equal.'); assertEquals(testObj.get('password'),rc.password,'passwords are not equal.'); /cfscript /cffunction ... but you can see how this is a MUCH bigger function than what I'm actually trying to test. If I used this approach in a more complex scenario, I could see it taking twice as long to write the test than it did to write the functionality I'm trying to test... Seems like a losing battle - I'm hoping I'm missing something? Thanks! Jake, I would highly recommend posting this question to the ColdBox and/or MXUnit groups (links below). You are almost guaranteed to get a much greater response from those than you will from CF-Talk. /0.02 I would offer a suggestion, but I'm honestly not exactly sure what you're trying to do, or specifically, what you're struggling with. But that might be just because I a) don't use any of the built-in model stuff, and b) don't really write controller unit tests. I write extensive tests on my model itself, but typically just browser test the controllers. HTH ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Regex - count of matches
I'm looking to get a count of the number of times a regex match can be found in a string. The best I can come up with is arrayLen(reMatch('expr','string')) which does work, but it seems like this approach is doing more work than it really needs to (I don't care about what the regex matched, I just want to know how many times a match was found). Anyone know of a more elegant solution to this? Thanks in advance! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
coldfusion framework - i forget the name...
I remember reading about a coldfusion framework out there - I quote framework because it was really more of a methodology. It was like 2 or 3 CFCs that laid out a fundamental OOP MVC framework, and I believe it was written by one of the fusebox authors if I remember right. I've tried googling, but I don't know enough about what I'm looking for to actually find it (keep hitting TONS of mach-ii, model-glue, fusebox, coldspring pages). Does anyone know what I'm talking about? :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: coldfusion framework - i forget the name...
Yes! Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Fun with images
I'm currently doing a project for a photographer, and I know most of this has been done before... Can someone point me towards some good slideshow/photo gallery resources using coldfusion? An image resizing tool would also be nice (I know cfimage can resize, etc - I'm more looking for client tools). Thanks in advance! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 Dedicated server recommendations
I'm looking for a fairly low-end CF 8 dedicated server setup. I've been running with a VPS for a while and I'm starting to outgrow it. CF8, MS-SQL, prolly don't need more than 40 GB disk, 2 GB RAM. If anyone has any suggestions I'd appreciate it! -- Jake ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RETS Implementation
I too would be interested in seeing your CFC. Is it available for download somewhere? Curious if anyone has done a RETS implementation with ColdFusion to download MLS listings? I have a CFC encapsulating all the necessary functions to interface to RETS v1.5. I've also built it around CFX_HTTP5 which is much faster and more robust than the CFHTTP tag. Paul Cormier ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: RETS Implementation
As far as what I have done with the data, it isn't the best solution but it works... The biggest problem I encountered is a 1 minute page processing limit at HostMySite, so what I have done is wrote a script to go out and grab the data and write it out to a file, then I import it chunk by chunk (scheduled task that runs every 30 mins) until i have imported the entire file. I then go out and grab a new file. This process takes about a day with the RETS server I am hitting, and with the RETS queries I'm using (which result in about a 50,000 record recordset). In general, the biggest hurdle I encountered was handling the HTTP authentication via Coldfusion (which i believe is why CFX_HTTP5 was used for the CFC solution). After that, it was just a matter of playing around with parameters until I got the result i wanted. -- Jake I have a CFC encapsulating all the necessary functions to interface to RETS v1.5. I've also built it around CFX_HTTP5 which is much faster and more robust than the CFHTTP tag. What does it do with the data once downloaded? Is this code available in some form? -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: RETS Implementation
I have. See me off-list or reply to this posting if you have troubles getting at my email address. - Jake Pilgrim Curious if anyone has done a RETS implementation with ColdFusion to download MLS listings? We're in the process of updating our data import from an older system and would prefer something that can just go get the RETS data and images and throw it into SQL for us. The route we're going down right now has us using an outside tool to download the data to text, then parsing and importing to SQL through ColdFusion. I'd prefer to have it all in one step without having to deal with manually creating tables and figuring out the field types. I know RETS has meta-data that already has all this info, but the download utility just spits out a pipe-delimited text file without any of that meta-data so it's slow going. Any ideas? -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DNS solutions
I'm looking to set up a new colocated server. I know I can run my own DNS server, and my provider is willing to set up a secondary nameserver for me on a separate box, but basically both boxes are going to be across the room from each other - I'd like some geographic dispersion (the proverbial 'what if the bomb dropped?' solution). What are other people using? Is it worth my dime to grab up a do-nothing VPS for replication purposes, or are there some cost effective DNS hosting providers out there? Jake Pilgrim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DNS solutions
Plausible solution i know, but in my case it just isn't practical. Some of my clients like to keep their registrar accounts in their control (then tend to forget the password on mission critical launch days). The current situation is probably 1000 domains strewn across 50 or so registrars - I'd much rather have a centralized DNS solution that's outside of the registrar (then just tell my clients to update their DNS servers accordingly). I don't want to chase down registrar logins when, say a redundant mail server goes into place. I just use wherever the domain is bought... (gododdy). Also rackspace. Never had an issue with either. Russ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I am looking for some good tutorials or examples for learning OOP
I recently gave a presentation on this at my local CFUG. Here are my presentation files: http://www.colderfusion.com/presentations.cfm -- look at Sept 2007 It's a real nice breakdown of the various techniques used in CF OOP programming. It's not a definitive CF OOP resource, but it should at least get you started down the right track. It starts with a simple CFC which many of us have seen before and it morphs this CFC into something truly object-oriented and reusable over a series of 5 steps. It should be much more understandable than the Transfer documentation. :) Jake Pilgrim Hi all, I am looking for some good tutorials, or example apps (open source projects) on using Object Oriented Programming. I have read several good ones, and I am starting to grasp the concept. But the tutorials I read (cfoop.org among others) only discussed a object that has no connection to other objects. What I am looking for is a good example on using objects that holds data across several db tables. For instance, I have a company table that holds a companytypeID. I have a table companytype, with an ID and a description. How can I create an object that shows not only the companytypeID but holds another object with the companytype data? And how does it work when I want to assing multiple contacts to a company. How do I add this to my company object? Anybody know where I can find sample code or good tutorials? Any help would be greatly appreciated. Kind regards, Erik-Jan Jaquet Toomba ~| 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:293162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfx_payflowpro
I have a presentation with a installation guide for CFX_payflowpro - the one provided with the custom tag does not work when followed exactly. http://www.colderfusion.com/presentations.cfm -- Dec '06 I believe there's some authorize.net stuff in there also - what you're looking for is the PDF that is included in this zip. Jake Pilgrim Sean, Thanks for the response. I just took a look and here is the java version diff current 1.6.0_03 mx6 1.6.0_02 ~| 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:292264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
WebDav + SVN + Dreamweaver
I'm trying to get SVN autoversioning (webDav) configured for use with dreamweaver (in this case, dreamweaver 8). It seems like it's working, but I can't publish new files. Also, I'm not seeing file revisions when I post new files. Admittedly, I'm new to SVN so this could easily be a user issue. Here's a rundown of of my software versions/configuration: Apache 2.0.59 (it's only purpose in life is to provide webDav access) SVN 1.4.3 Windows XP (will eventually move to Windows 2003 server when in production) Client: Dreamweaver 8 - remote server as a webDav connection Besides switching the default port to 8080 (to prevent conflicts with IIS on 80), here are the changes I made to httpd.conf LoadModule dav_module modules/mod_dav.so LoadModule dav_fs_module modules/mod_dav_fs.so LoadModule dav_svn_module C:/Program Files/Subversion/bin/mod_dav_svn.so LoadModule authz_svn_module C:/Program Files/Subversion/bin/mod_authz_svn.so DocumentRoot C:/webDav Directory C:/webDav DavLockDB C:/Program Files/Apache Group/Apache2/var/DavLock Location / Dav svn AuthType Basic AuthName DAV AuthUserFile C:/Program Files/Apache Group/Apache2/var/user.passwd require valid-user ForceType text/plain SVNPath c:/svnRepos /Location I created a new repository (C:\svnRepos) using Tortoise SVN. I then imported the files which I wish to keep under version control (c:\webDav). I then did the necessary password work to create an account for the basic authentication. Dreamweaver says it connects successfully to my remote server. When I push out a file that already exists, it doesn't bark at me. However when I look in my c:\webDav folder, the changes are not there. I tried doing an SVN Update (via Tortoise SVN) on c:\webDav, but the changes were still not visible. I also tried checking out a new working copy (c:\webDav2) and that did not contain the changes either. The other issue is that I cannot add a new file - I created test2.html in my local view in dreamwaver, tried to push it out, and I received an access denied. the file may not exist or there may be a permission issue. I haven't tried any clients besides dreamweaver because this really won't be useful to us if it doesn't work in dreamweaver. Has anyone experienced this before? Is this a dreamweaver issue? Did I take a wrong turn somewhere in my setup/configuration? Is there a way to resolve this? Thanks in advance! Jake ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd database behavior: duplicate key error
Yes, you could use CFtransaction for this type of isolation, but this can also cause problems that you wouldn't see with cflock. Cftransaction isoloation='serializabile' for example will give you an exclusive lock to all tables within the transaction (most restrictive level of isloation). Depending on what you're doing, this can be desirable or problematic as this can easily cause database deadlocks which are almost always highly frustrating to the end user, and are usually equally frustrating to debug. Cflock will not (directly) cause database deadlocks, but can be problematic if you have a large number of requests that are going to be using the cflock'ed code as a lock will wait (until timeout) for the locked resource to be released. So potential database lock error vs potential cflock timeout error - the choice is yours. :) ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd database behavior: duplicate key error
If this is true - wrap the code in a named lock: cflock name=aUniqueLockName type=exclusive your SQL here /cflock A named lock ensures that only one thread at a time will be allowed to run the code within the cflock tag. CFTransaction will not give you this same level of isolation. Jake Pilgrim You probably have a race condition, where two people execute the code at the same time, and the order goes like this: A - delete B - delete A - insert B - insert In this case, you'd expect the fourth statement (the second insert) to throw the dupe key exception. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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:288117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RETS Real Estate amp; Coldfusion
Did you ever figure this beast of a webservice out? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287600 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RETS Real Estate amp;amp; Coldfusion
Hah, ok apparently you can't just reply to ancient threads... I'm trying to do a search with RETS. I am able to login and pull metadata, just unable to search. Anyone have ANY experience with this feed, coldfusion or otherwise? ~| 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:287602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF7 to CF8 upgrade or interoperability issues?
CF shouldn't be caching these files... I would suspect that the caching issue lies within your browser or your webserver (IIS). However, if clicking 'clear template cache' is resolving your issue, just set the maximum number of cached templates to 0. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RETS
Does anyone have some experience with connecting to the RETS real estate data feeds? I would just like to do a basic search using coldfusion. Jake ~| 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:287145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Parameter 1 of function IsDefined must be a syntactically valid variable name?
This should work for you: structKeyExists(base.dataSets.user.dataElements.firstName.assertions[1],'assertId') Jake Pilgrim ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF7 - admin debugging settings
We've been playing around with the CF admin settings quite a bit lately on our development server, and we have made some interesting observations. As many of you already know, 'report execution times' is an application killer in any heavily CFC based framework - we have had this setting turned off for some time. However, we have also noticed that when we run processes that take several minutes (10+ - we have a number of data mover processes which run for quite some time), the RAM usage seems to steadily increase when we have debugging enabled. When we disable debugging, you can see each iteration of our loop show up in memory (mem usage goes up about 2MB and drops back down 2MB every few seconds) but when debugging is disabled it never seems to free up the entire 2MB so the RAM usage steadily increases. 1) Anyone know what is causing this with relation to the debugging settings. We would love to be able to leave debugging on if possible, but obviously system performance is more important. 2) When Coldfusion finally hits the heap size limit for RAM usage, it pretty much gives up - I'm assuming this is because it is trying to run a Full Garbage Collection while we're stuffing more data into RAM, and it just never actually completes the GC process. Can anyone recommend a GC for this type of processing? Are there other settings that we could tweak so that when we do hit the memory threshold, we're not 'dead in the water' until we give CF a restart? Any other thoughts would be greatly appreciated! Jake Pilgrim ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 - admin amp; debugging settings
We're running these large processes on our development server (to avoid burdening our production server) which is why we would like to leave debugging on. I understand that having debugging enabled in a production environment is a no-no - I guess I'm looking for a way to 'soften the blow' when having debugging enabled. If I can't actually change anything, I'm still curious as to why this happens. ~| 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:286406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data Validation Resources
Let's assume the following form: form name=myForm method=post input type=hidden name=validate_config value= firstname^First Name^yes^string| lastname^Last Name^yes^string| email^Email^yes^email input type=text name=myField / input type=submit name=Send value=send / /form Type this in your address bar: javascript:document.forms['myForm'].validate_config.value = ''; Poof goes the validation (yes, you can run javascript from the address bar). If you're in firefox and it pops you to [object], just hit the back button - it happened. Jake Pilgrim ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Just spooling
I have experienced this before as well... Restarting coldfusion resolved the issue for me, but obviously that isn't a fix nor an ideal workaround. If someone else can shine some light on this issue I would be very interested to find out what's going on 'under the hood'. Jake Pilgrim ~| 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:285340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT/FYI: SmarterMail utility
Most of the smarterTools products expose a Webservice API which you can connect to fairly easily. See: http://help.smartertools.com/SmarterMail/v4/ (change the last dir to match your version number) Help for System Admins - Additional Topics - Automation with Web Services ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC defining vars
Gualtiero hit the nail on the head - it allows you to define a variable (or a variable scope aka struct) who only exists for the duration of the function's processing. 'What scope is it in?' - it's in the same scope as if you omitted the 'var' keyword. cfset myVar = 'purple' / cfset var myVar = 'purple' / In both cases, your variable would be in the 'variables' scope. One trick that many developers like to use is to declare a variable scope for your functions: cffunction name=myFunction cfset var local = structNew() / cfset local.val1 = 'blue' / cfset local.val2 = 'red' / cfreturn local.val1 ' ' local.val2 / /cffunction Crappy example, but hopefully it illustrates the point. By setting var local = structNew(), you effectively create a variable scope that only lives for the duration of the function. Jake Pilgrim ~| 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:284811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Convert a mapping to a full path
expandPath('/external') Jake Pilgrim Hi, Is it possible to take a CFMX mapping (say /external to c:/datafiles/word/external) and use this in the cfile action=read file=fullPath tag? The mapping should be converted to a full path but since CFMX already knows this, it should be possible right? Thanks ~| 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:284750 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
PGP...
So how does a person go about decrypting PGP via Coldfusion? Jake ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FTPS
I too would still be interested in finding any code which gracefully handles FTPS transactions. The current solution I'm looking at would require me to write a BAT file for every transaction I wish to perform... ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTPS
The file transaction I'm looking to do is a communication with a bank - I have no control over the file server in place on their end. It is an FTPS fileserver, not an SFTP fileserver and I need to be able to access it programmatically. If there's an existing Java object that I can wrap, that'll work just fine. I'm not about to go pay $1399 for Jscape's Java object when it isn't even a complete solution... ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HELP Please - Using Coldfusion to Import delimited txt files.
The performance of cffile action=read and cfloop list=file, delim=end of line chars is terribly poor... Furthermore (as you have found out), there's usually a lot of trial and error getting this to work. Assuming you have a well-formatted delimited text file, the best approach is to use CFHTTP: cfhttp url=http://www.domain.com/urltotextfile/file.txt; name=data columns=field1,field2,field3 firstrowasheaders=false delimiter=| textQualifier= / OR if your first row does contain column headers: cfhttp url=http://www.domain.com/urltotextfile/file.txt; name=data firstrowasheaders=true delimiter=| textQualifier= / Both will result in a query object named 'data'. Jake Pilgrim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to print directly from coldfusion code
My personal approach would be to use the print.exe executable found on windows machines via the cfexecute tag. Print.exe syntax: PRINT [/D:device] [[drive:][path]filename[...]] So something like this should work: cfdirectory action=list directory=c:\printDir\ name=myDir / cfoutput query=myDir cfexecute name=c:\windows\system32\print.exe arguments=/D:\\networkPrinter c:\printDir\#myDir.name# timeout=5 / /cfoutput Jake Pilgrim ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FTPS
Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC doesn't seem to work. I would prefer a CFC/custom tag based solution, but I am able to run cfexecute so a command line solution could potentially work. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Good SSL Provider
I'm a fan of GeoTrust. Yes, you do tend to pay the piper when going with them but it's a name that people recognize and they provide 'reissue insurance' which I know I have personally cashed in on at least a dozen times. 'A name that people recognize': If you purchase an SSL cert through GeoTrust, they allow you to display their geotrust security symbol graphic on your site. As you probably already know, there are many people who are paranoid about submitting their credit card number to ANY site. By putting some sort of security symbol on your site, you provide a (false) sense of security that your customers will appreciate. If they actually recognize the company that is being displayed in the security symbol, even better. 'reissue insurance': Basically it ensures that if you mess up the installation or blow up your server, you can get another SSL cert without having to pay for it. Say you generate the request file, send it to GeoTrust, and they issue you a certificate. You then pull a bonehead move and delete the site from IIS or spill your beer on the server and it snaps, crackles, and pops. Once you get things set up again, the cert that GeoTrust sent you will no longer work because it will no longer match up with the request file. With reissue insurance, you simply create a new request file and go through the reissue process - they will send you a new cert using the new request file. If you want to go with a vendor other than GeoTrust, I personally would make sure that the vendor provided this sort of insurance since the times that you cash in on it are typically stressful enough :). Jake Pilgrim ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: payflow (link|pro)
There is a CFX tag which you can install for PayFlowPro, however it is a Java CFX tag and the instructions they provide for installation do not work if you follow them line for line. Fortunately, I have written an installation guide which actually works: http://www.colderfusion.com/presentations.cfm --Scroll down to December 2006 The zip available for download there includes the CFX install files, a revised installation guide, and a txt file with some handy links. Jake Pilgrim ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Make Number Negative
0 minus your number works too. To ensure a negative number, use abs(): cfset var1 = 0 - abs(numVar) / Jake ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large CSV File
A number of excellent database-based solutions have already been posted (and a database solution is probably preferred), but don't overlook CFHTTP. CFHTTP is actually quite good at parsing a CSV and spooling it into a CFQUERY. Depending on exactly what you want to do with your data, this may be a good solution. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfabort triggering onError function in Application.cfc
An abort is an exception that is caught by the onError event handler. Whether this is a bug or a desired effect is debatable, but this does in fact happen. However it is easy enough to catch: cffunction name=onError returntype=void cfargument name=Exception required=true/ cfargument name=EventName type=String required=true/ cfif arguments.exception.rootCause NEQ coldfusion.runtime.AbortException ... do error handling /cfif /cffunction Voila! Jake Pilgrim Since I implemented the onError function in my Application.cfc the cfabort seems to be triggering it. Is this normal? if so how do I work around this? I'm fairly certain cfabort doesn't trigger onError; at least I haven't seen that before. You might have another error around the cfabort tag that is causing onError to be triggered. If you're in a dev environment, you could comment out onError and cfabort for the moment and see exactly what error is being generated. -- Josh ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: quick file publisher for CFEclipse
I'm finally taking the plunge to CFEclipse. So far I am liking it quite a bit, but with one catch - I'm not finding a quick way to publish files. I have a mapped network drive to our development server and our production server. In Dreamweaver I was able to set up the development server drive as my 'workspace' and the production server drive as the remote server - this allowed me to upload files by simply clicking 'put'. I have seen the export feature and it does perform the same task, but there are quite a few steps to this that I would prefer not to have to take. Anyone know of a good plugin for this? Jake ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280487 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Custom 404 For Single IIS Site
The CF administrator will only let you set up 1 page to handle CFM 404s for the entire server, which introduces an issue if you are hosting multiple sites and wanted to use a 404 handler for each. To get around that, I have done something like this in the past: Missing Template Handler: /mappedPath/404controller.cfc 404controller.cfc cfif CGI.server_name CONTAINS houseoffusion.com cflocation url=http://www.houseoffusion.com/404.cfm; addtoken=no / cfelseif CGI.server_name CONTAINS mysite.com cflocation url=http://www.mysite.com/404.cfm; addtoken=no / cfelse cflocation url=/mappedPath/404default.cfc / /cfif with 404default.cfc being something very generic. Of course you can pretty this up with a switch statement, DB call, or whatever else you would like (I tried to keep the example simple). Jake Pilgrim On 6/6/07, C. Hatton Humphrey [EMAIL PROTECTED] wrote: Make sure is a it Message Type = URL type error handler and not a file based. Then it's /error.cfm from the root of the website for the URL Also this will not handle missing .cfm pages unless you set that in coldfusion administrator. Missing Template Handler ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC Typeof()
You don't want to do that in Coldfusion - it is unnecessary and is actually a performance hit as well. Read up on 'duck typing' - Sean Corfield has a nice powerpoint that outlines this concept. You have to remember that Coldfusion does not enforce strict typing; Coldfusion is not Java!! The basic idea is that if you pass in a value (be it a string, query, object, whatever) and it works within your code, it is of the correct type (if it walks like a duck, quacks like a duck, it's a duck!). If you pass in a numeric value to a function that is expecting a string, it's going to work. If you pass in an object with properties x, y, and z to a function expecting an object with properties x, y, and z it's going to work. If you were to restrict your function to only accept objects with a type of cfc.exampleObj, you are unnecessarily restricting the possible input of your function as well as creating a performance loss by making your function check the object's type in the first place! As defined by Wikipedia - http://en.wikipedia.org/wiki/Duck_typing Jake Pilgrim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 sample databases and HostMySite free hosting
MS SQL express - it's free, and it works. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The CF Dissenters Have Been Smacked Down
:) Although I do agree - PHP is definitely on the way out. Ever since they addressed their memory leak issue (related to the - operator) by just implementing an error for code that would cause the memory leak condition, I have seen PHP's support steadily decline... I mean come on... If your code had a condition that resulted in a memory leak, wouldn't you correct the issue instead of saying well then don't do that? Now we just need to silence those Ruby ASP fanboys! ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279652 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Server connecting to MySQL v5
I know this isn't the most elegant solution, but it works. You can use the mySQL v3.x driver that comes built into cf administrator if you apply one quick fix to your mySQL user account: SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); More on this can be found here: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Essentially this 'fix' changes your password to use the old shorter password hashing algorithm used back with mySQL 3.x. Less secure, yes, but this is really the only major compatibility issue you'll encounter with using this driver. Jake Pilgrim ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Load Testing
I'm just wondering, what do you use for load testing your applications? Thanks! Jake ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New developer vs. Veteran developer
Honestly, the value of a veteran developer can rarely be quantified. Veteran can mean a variety of things and all of the prior comments suggest this - a developer with 2 years of experience might be as good as a developer with 8 years of experience. This means that years of experience is a very rough indicator of developing talent. I would label a veteran developer as a developer who has been placed in at least 3 different work environments and has performed a variety of different tasks with relation to the development platform in question (in this case, Coldfusion). Someone who has been working on the same intranet application for company x for the last 8 years probably won't know squat about ecommerce. Someone who has been at a web development shop for the last 8 years will probably have a broad range of application experience, but may not know squat about internal users (the folks you can trust with about 30% of everything who may or may not know enough to be dangerous). Now with my definition of veteran, your new developer won't catch up to the veteran until they have been placed in a few different job roles. Now a new developer may learn how to program absolutely superb code in their first year (highly unlikely), but without a broad range of experience this first year developer will still make mistakes that a veteran developer wouldn't (i.e. hackable application holes, poor data integrity, etc). So in short: years of experience doesn't indicate expertise, and while a new programmer may be able to be as productive as a seasoned veteran in a very short period of time, they are not going to have as strong of a background when it comes to resolving errors and maintaining application integrity. Jake Pilgrim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL - need auto increment back to 0...
In the past I have just deleted the column and recreated it, which effectively sets the autoincrement back to 0. However there are definitely a few downfalls of this approach (broken relationships and not straightforward when done programatically) - I'll be interested in finding if anyone has a better solution for this. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: get code prior to commit
As previously mentioned, cfsavecontent is a good approach. Another alternative is the onRequest method within Application.cfc. You'll have to do a little reading on this function, but the basic idea is that the end result of your page request is delivered by onRequest. If onRequest doesn't return anything (or output anything), your user will not receive any conent. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Online WYSIWYG Editors
If you haven't given the FCK editor a look for some time, it's worth looking at again. The latest versions are highly improved over previous versions and has been my editor of choice for my last few projects that have demanded this capability. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File Upload CFC
Usually I end up passing the form field name that contains the file to my CFC so that i can perform the cffile action=upload within my CFC. Beyond that, it's very similar to handling the file via procedural programming. Jake Pilgrim ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Which Framework do you use... (if any)
This answer is hard to answer because I really feel it's strongly based on your development style. Are you an old CF 5 developer that's just getting into the MX arena (or maybe you're still not there)? - Fusebox is a wonderful framework for these folks. Are you an OOP junkie? - Mach-II might be your answer. Are you a developer who heavily relies on CFCs but doesn't really care for the OOP approach? - model-glue might be your answer. Now the real cool thing out there in the coldfusion development architecture world are ORMs - the front runners here are Transfer and Reactor. In my experience recently, Transfer is knocking the socks off of Reactor and has been a much more active open source project than Reactor. However, both work extremely well. If you haven't used an ORM yet, you definitely need to try one out :). For those of you not in the know, ORM stands for object role modeling (fancy term, whatever) - the basic idea is that you tell the ORM a few little details about your database tables (what's the table name, what's the PK, what's the relation between your tables) which is typically done in XML. From there, it creates all of your select, insert, update, delete functionality (Commonly called CRUD operations) for you :). Any developer who has done a fair sized project will know that these functions take a good third of your development time - when this gets taken care of for you it is HUGE. So to answer your question, choosing a framework really depends on development style and in many cases choosing multiple frameworks may make a winning combination. Please note that the term frameworks is being used very loosely here - Fusebox and Model glue basically have the same use; transfer and reactor basically have the same use. A winning combination may be model glue and reactor (and coldspring for the model-glue unity setup) or fusebox and transfer. Get your nose out there, and give these frameworks a try! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Printing Checks
One word - CFReport. Go get the CF Report Builder (I believe its still free) and create a report which fits the format of your checks, then just load and execute it with the CFreport tag. There is tons of documentation out there for CFReport so I'm not going to go too far into the details, but you'll probably find that this is what you are looking for. You can render your reports as a PDF, which will probably address your printing issue. Jake Pilgrim ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFCs that extend CFCs - want to cfinclude a function
I have a CFC that extends another CFC, and I want to overwrite a function in the base CFC using a cfinclude. Take the following example: subset.cfc: cfcomponent extends=cfcs.base cfinclude template=functions.cfm / /cfcomponent base.cfc: cfcomponent cffunction name=doStuff cfset returnVal = 1 / cfreturn returnVal / /cffunction /cfcomponent functions.cfm: cffunction name=doStuff cfset returnVal = 2 / cfreturn returnVal / /cffunction Now if i paste the contents of function.cfm to where the cfinclude is the functions.cfm version of doStuff() overwrites the base version of doStuff() (good), but when i extract it into a separate file and use the cfinclude, it does not overwrite doStuff() (bad). Anyone know of a good workaround for this? Thanks! Jake Pilgrim ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do I set this variable, then...
AJAX ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: making a page use cfdocument or not
Ian keyed in on the solution here. In short - you can't have a condition around just the CFDOCUMENT starting and ending tags; the condition needs to wrap the entire code block. From what I experienced CFdocument seems to always run whether it is wrapped in a condition or not(seems to execute during pre-processing, like evaluate()), then if there is a condition that isn't met it will discard the CFdocument results. Now the end tag doesn't seem to follow these same rules (which you noticed with your error) - it behaves just like any other CF tag. CFdocument in general is a bit flakey, but once you get it working it's an extremely useful and powerful tag. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vista versions - what's really needed for CF development?
Ok, sounds like I want Business edition if i want a full version of IIS. Now is the Windows Media Center piece worth upgrading from business to ultimate for? I'm going to have the Adobe Creative Suite installed and I'm not really the type of person who is looking to document their whole life story in a series of video clips, slideshows, etc. What are your thoughts on windows media center? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help totaling something up
I don't see any nested loops in the code below. So the simple answer here is to just declare some variables outside of the loop to manage the sums. As long as the variable is outside the loop, you'll be set: cfset answervalueTotal = 0 / cfset totalforthisquestionTotal = 0 / cfset answerpercentageTotal = 0 / cfoutput cfset answervalueTotal = answervalueTotal + answervalue / cfset totalforthisquestionTotal = totalforthisquestionTotal + totalforthisquestion / cfset answerpercentageTotal = answerpercentageTotal + answerpercentage / table style=float:left; width:50px; text-align:center; font-size:11px; border:1px solid ##CC; margin:5px; vertical-align:top; background-color:##F7F7F7; tr td style=border: 1px solid ##CC;#answervalue#/td /tr tr td style=border: 1px solid ##CC;strong#totalforthisquestion#/strong/td /tr tr td style=border: 1px solid ##CC;strong#NumberFormat(answerpercentage, __ )#%/strong/td /tr /table /cfoutput !--- display sums --- cfoutput #answervalueTotal#br / #totalforthisquestionTotal#br / #answerpercentageTotal#br / !--- and just for fun, we'll display the average percentage too --- cfset averageAnswerPercentage = answerpercentageTotal / yourQuery.recordcount / #averageAnswerPercentage# /cfoutput ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Vista versions - what's really needed for CF development?
I'm looking to get a new laptop and I'm just wondering - what version of Vista does a Coldfusion developer really want/need? For example I remember from the XP days that the folks who picked up Windows XP Home Edition didn't have IIS, which really can be a pain to workaround. There were also some nice to have's that really made XP Professional a winner for the CF developer. Now I got this little pamphlet from Target about the different editions and it looks like Vista Business ed. (when compared to Ultimate) pretty much has the works minus Windows Media Center and some drive encryption tool which I could care less about. Is media center worth having (in which case, is Home Premium a better option)? It seems like the Business ed. has some networking tools that might come in handy - are they? What aren't they telling me? :) Thanks! Jake Pilgrim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is this thing on?
The answer: A circle is equal to a square and a piece of pie. just in case someone was looking for something psuedo-meaningful in this thread :). ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274534 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: US/Canada Dropdown?
There aren't that many Canadian provinces - why not just add them? Straight from Wikipedia (I'm pretty sure you don't have to cross-reference this one): The current provinces are Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island, Quebec, and Saskatchewan. The three territories are Northwest Territories, Nunavut, and Yukon. Thanks! Jake Pilgrim Does anyone by chance have a tag that allows both US (states) and Canada (Providences) to be shown in a select box. I have one but only for the US. Other searches (via Google) turns up just the US. Thanks! ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (Resend) Application.cfc and cflocation
coldfusion.runtime.AbortException suggests the execution of a CFABORT tag somewhere. I'm guessing you forgot about a CFABORT tag during development - probably on your include page. Now in our shop, we occasionally throw cfaborts for valid reasons (like a user trying to access a protected area). So in our onError function, we pitch these errors right out the window: cfif structkeyexists(arguments.exception,'rootCause') and arguments.exception.rootCause.Type EQ coldfusion.runtime.AbortException cfreturn / /cfif Hope that helps... Jake Pilgrim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cold fusion certification
http://www.forta.com/books/0321330110/ -- scroll to the bottom, there's a pretty good series of practice tests there. I should warn that these were developed for the CF MX6 test. I don't think any of the answers would have changed between MX6 7, but the last time i took these there was quite a bit of content missing that was introduced in MX7. If you are looking to become certifiable ahem... certified, then you really do need to study everything. Some areas of focus should be error catching (what is the order of precedence? application.cfc onError, cfError, try/catch), queries (do you know what the blockfactor attribute does?), and webservices (what do you need to do to make a cfc function a webservice?). Hope that helps... Jake Pilgrim ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: _Debugging?
To add a little overkill to this thread, I like to do something similar to the following (please note this code is very trimmed down): --- in application.cfc: cffunction name=onRequestEnd cfparam name=URL.debug default=false / cfsetting showdebugoutput=#URL.debug# / /cffunction Then you can show debug output whenever you want by specifying http://myURL.com?debug=true -- this is especially helpful when using AJAX or other HTTP calls where the debug output may pollute your result set. Jake Pilgrim ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: _Debugging?
Yes, it still requires debugging to be turned on at the server level but that shouldn't be a concern here. On your development server, enable debugging; on your production server, disable debugging. This code isn't going to add or subtract any overhead in either scenario. Jake Pilgrim Doesn't this still require debug to be on at the server level and behind the scenes means every request is still getting it, which can add overhead. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Jake Pilgrim To: CF-Talk Sent: Mon Mar 19 15:41:43 2007 Subject: Re: _Debugging? To add a little overkill to this thread, I like to do something similar to the following (please note this code is very trimmed down): --- in application.cfc: cffunction name=onRequestEnd cfparam name=URL.debug default=false / cfsetting showdebugoutput=#URL.debug# / /cffunction Then you can show debug output whenever you want by specifying http://myURL.com?debug=true -- this is especially helpful when using AJAX or other HTTP calls where the debug output may pollute your result set. Jake Pilgrim ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion / Open Source CRM
Does anyone know of a coldfusion CRM out there? Ideally I would like a open source, Coldfusion CRM. It doesn't have to be all that fancy (I'm not looking for a SalesForce replacement) - even if it was just a contacts database it would be better than what I have now :). Thanks for your feedback in advance! Jake ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: input vs cfinput
I've encountered that before too. Yes, you scratch your head, maybe even shout out a why the hell did they do that?, but in the end - no, plain HTML inputs don't seem to conflict with CFFORM inputs. You of course can't leverage the extended attributes of a cfinput, but it's not going to throw any errors either. Now you're of course going to run into issues with cfform format=flash, but it didn't sound like you were using that. Jake Pilgrim ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: populate a javascript var with cfoutput?
Generic way of doing this would be: cfoutput query=qry_getaddresses cfset arrayIndex = qry_getAddresses.recordcount - 1 / addresses[#arrayIndex#] = '#name#, #address#, #city#, #state#'; /cfoutput ya it clutters up your display page code, but it works. It also makes debugging any javascript syntax issues (i.e. name = o'connor - the extra ') a breeze :). Jake Pilgrim I need to dynamically populate addresses as shown below: script type=text/javascript var addresses = new Array(Redwood City, CA, Palo Alto, CA, Santa Clara, CA, San Jose, CA, Sunnyvale, CA, Mountain View, CA, Milpitas,CA); /script I've been trying to use listappend but keep running into the issue of the quotes as delimiters above. cfset addresses = cfoutput query=qry_getaddresses cfset addresses = listappend(addresses, #name#, #address#, #city#, #state#) /cfoutput Am I missing the boat entirely on this? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Smart Names implementation
I guess I was thinking of something a bit more relational (2 tables: [id,name] [id,sameAsID]), but your example would do the trick :). However I could see this becoming an additional bottleneck in our system. We often have tables with tens or hundreds of thousands of records, and there are a number of checks that already are ran on each record to determine if a duplicate entry has been entered - we have seen this process take the bulk of a day with a large enough database. General overview: To initialize a project, a list of clients (people) is dumped into our database (usually from a spreadsheet). As the project goes on, we may add more entries to the database, delete entries (which is actually just an inactive flag), and modify entries to correct addresses, phone numbers, etc. There are a number of places that we may receive these updates from (phone, mail, etc) so there is a good chance that duplicates will be entered. While the system tries to eliminate duplicates on entry, it isn't able to catch all duplicates. Now that I think about it, maybe I'm looking at the wrong approach... There's always the potential for type-o's and I would like to catch those too (Robert vs Roebrt) -- obviously this would be beyond the capabilities of a smart name search (unless i started entering in potential type-o's into the smart names database - ick). Has anyone else dealt with this type of scenario? Thanks! Jake I've done something similar with part numbers. The hard part isn't doing lookups -- one table, three columns (id, name1, name2), two subselects -- the hard part is populating that table. I'm happy to show you how to do the lookup, but do you have a plan for populating the table? --Ben Doom Jake Pilgrim wrote: Has anyone implemented smart names (i.e. a search for Bob would match Bobby or Robert) functionality in Coldfusion? Anyone have any examples I can view? Thanks! Jake Pilgrim ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Smart Names implementation
Has anyone implemented smart names (i.e. a search for Bob would match Bobby or Robert) functionality in Coldfusion? Anyone have any examples I can view? Thanks! Jake Pilgrim ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: why is my cfmx reporting the wrong time?
Have you checked the simple things? Like the system time, system timezone, etc? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: test if method exists
How about this? Straight out of the CF manual: h3IsCustomFunction Example/h3 cfscript function realUDF() { return 1; } /cfscript cfset X = 1 !--- Example that fails existence test --- cfif IsDefined(Foo) AND IsCustomFunction(Foo) Foo is a UDF.br /cfif !--- Example that passes existence test but fails IsCustomFunction --- cfif IsDefined(X) AND IsCustomFunction(X) X is a UDF.br /cfif !--- Example that passes both tests--- cfif IsDefined(realUDF) AND IsCustomFunction(realUDF) realUDF is a function.br /cfif Jake Pilgrim ~| 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:269892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfchart woes - vertical labels like 3.70333333
I have ran into this before... Here's the fix I used: cfchart gridlines=11 scaleFrom=0 scaleTo=100 /cfchart This will display a graph with each gridLine representing 10. The trick here is that scaleTo / (gridlines + 1) should equal an integer value. You add one to the gridlines value for the baseline (0) gridlline. Does that make sense? Hope that helps. ~| 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:269506 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web based HTML Editor recommendations please
Here's what I have used in the past, with feedback: FCK Editor - The best product I have found thus far. Prior versions were less than remarkable, but their latest versions are excellent! Very customizable, very cross-platform compatible, and does not require any additional plugins (Java, Flash, etc). Plus - it's free :). soEditor - This is an *ok* product. It doesn't do anything that the FCK editor doesn't do. It comes with a price tag, and it's code sweeper function is less than perfect. I used this for a number of clients in the past and I have had to go into the code generated by this editor numerous times to fix various layout issues from poor code nesting. Ektron eWebWP - Purely flash based. Poor functionality, and poor integration. Doesn't offer any code clean-up features. ActivEdit - Decent product, but licensing is a pain in the ass. It is able to run in DHTML or Java mode, but I would recommend forcing Java mode. Doesn't offer any code clean-up features. Now when I say code clean-up features - specifically I'm referring to the ability to paste content from outside applications (most notably - MS Word). FCK Editor will clean up word garbage on-the-fly. soEditor will clean up word garbage after clicking code sweeper or by pasting using the special paste from word button. Ektron and ActivEdit just leave word's garbage in the code... And that's my 2 cents. Jake ~| 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:269545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web based HTML Editor recommendations please
Yes - support is non-existent with the soEditor. Now about a year or more ago, I received an email that said that they were releasing a new version of the soEditor. The email even included a link to a page which seemed to be an incomplete purchase page (just missing the buy link). Shortly thereafter this page was taken down. I tried to follow up by asking when/how could I purchase the new version - to this day I have yet to receive a response. ~| 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:269553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF MX Access DSN w/o ODBC Service
Once upon a time, I seem to remember hearing that you could use OLEDB to connect to access: cfquery dbtype=oledb ... /cfquery However, I've never tried that :). If it works out, let me know. ~| 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:269405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4