Re: Avoiding SQL deadlocks
Check out the articles here: http://stackoverflow.com/questions/661908/sql-server-deadlocks-between-select-update-or-multiple-selects and here: http://blogs.msdn.com/b/bartd/archive/2006/09/25/770928.aspx to troubleshoot and fix different deadlock scenarios. Paul Cormier WebmasteryMadeSimple.com ~| 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:334480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (OT) Best windows subversion server
Another vote for Unfuddle here. I was going to recommend it, but I was beaten to the punch. Works great, nice ticketing, bug tracking, notes, etc features as well. It's not expensive either. Also, given that it's hosted, you have offsite backups. Used in conjunction with TortoiseSVN, it makes for a nice, smooth system. Paul Cormier WebmasteryMadeSimple.com ~| 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:328283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF, IE6 & Ext JS Oh My!
>So, Ext.isReady is like $("document").ready() in jQuery ... good to know >if I ever play around with Ext. It's a convention in jQuery to wrap all >those sorts of functions in a ready() call for just this reason: > >$("document").ready().function { >doMyStuffNowThatWeAreDoneLoading(); >} Actually, Ext.isReady doesn't have anything to do with whether or not your components are rendered or not. It is a boolean property not to be confused with the on.Ready event. ExtJS has very granular and specific event triggers, so using setTimeout and reading Ext.isReady isn't the most elegant solution. If you want to start interacting with ExtJS directly, I suggest you download and install the latest version (3.0.x) who's syntax has changed somewhat from v1.x. It's also the version that ships with CF9. You'll find you'll be doing a lot more event-driven programming (e.g. on.Render do this). Lastly, keep in mind that the IE6 Javascript engine is orders of magnitude slower than what you have in contemporary browsers, so some of the flickering and jumping around you see when ExtJS is doing its layouts may be unavoidable. To help you get started, you can view a presentation I did at CFinNC a few weeks ago titled: "Building RIAs Using ExtJS 3 and ColdFusion" http://www.slideshare.net/paulcormier/building-rias-using-extjs-3-and-coldfusion Once you get over the initial (moderately steep) learning curve, you'll find using the Ext widgets directly rather than the CF Tags to be quite flexible. Paul Cormier webmasterymadesimple.com ~| 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:327853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: javascript and coldfusion
I concur with Judah's comments on Ext JS and JQuery. ExtJS for largish web apps, JQuery for enhancing a site. I've just posted a presentation I made last weekend titled "Building RIAs using ExtJS 3 and ColdFusion" which you may find useful. http://www.slideshare.net/paulcormier/building-rias-using-extjs-3-and-coldfusion Paul Cormier WinCorp Software, Inc. ~| 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:327454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Encrypt and Insert quotation mark issue
A couple of issues. Firstly, CFMX 7 introduced the "encoding" attribute to the encrypt function. For example, if you use "hex" encoding, then the string returned will always be made up of 0-9A-F. Secondly, the default CFMX_COMPAT algorithm you are using (by default) isn't all that secure. I suggest using a stronger algorithm. Lastly, if your systems get compromised to the point where encrypted passwords in your database are obtained, it's likely that your .cfm source file can also be accessed, which is where your encryption "key" is visible as plain text, thus allowing for quick and easy decryption of all the stored passwords. (BTW 0 isn't a very good key. It's not even a string. CF will interpet that as '0'.) One way to avoid this source file vulnerability is to use the password itself as the key and storing the resulting value. Then when testing a submitted password, simply repeat encrypting the provided password using itself as the key and "compare()" the resulting string stored in the database. The biggest problem with this system is that you can't retrieve a forgotten password, you can only reset it, but at least your passwords will be much more secure. Also, I'm assuming that your passwords aren't trying to protect information that's stored unencrypted in other database fields. If the encrypted password field is compromised, then you should assume that any database field can be compromised. Paul Cormier WinCorp Software, Inc. ~| 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:327273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't get 301 permanent redirect to work properly
>Here's my actual page: http://www.wildasia.net/rt/ OK, I believe one of two things may be happening: 1. Is there a web proxy somewhere in the chain? If possible, try it again from a web browser right on the server. 2. Your IIS install/ColdFusion connector is hosed. Not only do I get a 302 redirect from your link, but the page it redirects to, main.cfm doesn't render in the browser, instead I get prompted to download the source file (which it does, yikes!). That looks like an IIS problem. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't get 301 permanent redirect to work properly
I just confirmed that the following code did correctly return "HTTP/1.x 301 Moved permanently" under CF8. Sorry no CF5 available to test: http://www.besthomepro.com/";> Try removing the . 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317605 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
>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:310205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLAYOUTAREA - Attaching an ONRESIZE event
Any ideas? I need to run some Javascript whenever the "center" cflayoutarea's size changes. This might be from: a) The browser window being resized b) An adjoining splitter is moved c) An adjoining sliding panel is collapsed It seems I should be able to attach an event to that center DIV. The window.resize event appears to fire only before the cflayout DIVs are redrawn, and not after, which is no help at all. 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 Install Wizard Not Seeing IIS running on Windows 2000
I have a Windows 2000 Server running IIS just fine. Plain HTML Files are served without any problems. I am trying to install CF8 Dev, but when I get to the step "Select webservers and/or website to configure for use with ColdFusion, the list is empty under "Webservers/WebSites" even though two IIS sites (different IPs) are running. "Next" is disabled unless I select "Built-in web server" which I don't want to do. Any ideas why the CF8 install wizard doesn't see my IIS server/websites? 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Install Wizard Not Seeing IIS running on Windows 2000
I have a Windows 2000 Server running IIS just fine. Plain HTML Files are served without any problems. I am trying to install CF8 Dev, but when I get to the step "Select webservers and/or website to configure for use with ColdFusion, the list is empty under "Webservers/WebSites" even though two IIS sites (different IPs) are running. "Next" is disabled unless I select "Built-in web server" which I don't want to do. Any ideas why the CF8 install wizard doesn't see my IIS server/websites? 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Zip Code Locator
ZipCodes aren't geographic areas, they are postal service delivery routes. Some of them have really wacky layouts and boundaries. In some places, a building has it's own zipcode. I also recommend you geocode each address, then do the distance math between lat-lons. Google it and you'll find several formulas. There are several address geocoders to use on the cheap, but you get what you pay for (daily limits, unresolved addresses, etc.) If you have some budget, check out www.proxix.com. Paul C ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need Help with mixed text and unencoded binary data
I am receiving a data feed that has multiple JPG images in a single file separated by text boundaries, that looks something like this: --simple boundary Content-ID:363130 Object-ID:1 Description: Content-Type:image/jpeg ÿØÿà +JFIF [MORE UNENCODED BINARY DATA] --simple boundary Content-ID:363130 Object-ID:2 Description: Content-Type:image/jpeg ÿØÿà +JFIF [MORE UNENCODED BINARY DATA] --simple boundary-- The accompanying HTTP Response header looks like: HTTP/1.1 200 OK Date: Thu, 26 Jul 2007 15:11:18 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET (04) X-AspNet-Version: 1.1.4322 MIME-Version: 1.0 RETS-Version: RETS/1.5 Transfer-Encoding: chunked Cache-Control: private Content-Type: multipart/parallel; boundary="simple boundary"; charset=utf-8 As you can see, there is no Content-Length data whatsoever. So, you Java ByteArray jockeys out there, what's the most efficient way to parse out the binary data and save it to JPG files? It needs to be efficient, as there could be tens of thousands of those per day. Regards, Paul Cormier ~| 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=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Digest Authentication woes
> Can you show the recording and your code? Did you record your attempts > > to run it from CF with a packetsniffer or proxy? > > Jochem I did not yet try the packetsniffer/proxy monitoring to see exactly what the CF Server is sending. Recording of successful FireFox session (credentials obfuscated): -- http://rets15.raprets.com:6103/Itech/ITEC/Login.aspx GET /Itech/ITEC/Login.aspx HTTP/1.1 Host: rets15.raprets.com:6103 User-Agent: XX Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 300 Connection: keep-alive RETS-Version: RETS/1.5 HTTP/1.x 401 Unauthorized. Not Authenticated Date: Tue, 17 Apr 2007 15:32:03 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET (05) X-AspNet-Version: 1.1.4322 WWW-Authenticate: Digest realm="ITEC", nonce="3b856a69cb9ecaeac324f9d0f1be9fd3", opaque="ea3056551e956d2f363f9e8f520a1755", qop="auth" RETS-Version: RETS/1.5 Transfer-Encoding: chunked Cache-Control: private Content-Type: text/xml -- http://rets15.raprets.com:6103/Itech/ITEC/Login.aspx GET /Itech/ITEC/Login.aspx HTTP/1.1 Host: rets15.raprets.com:6103 User-Agent: XX Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 300 Connection: keep-alive RETS-Version: RETS/1.5 Authorization: Digest username="", realm="ITEC", nonce="3b856a69cb9ecaeac324f9d0f1be9fd3", uri="/Itech/ITEC/Login.aspx", response="c3b0d5f6d805da44dce16c5aa25bb09e", opaque="ea3056551e956d2f363f9e8f520a1755", qop=auth, nc=0001, cnonce="15579d4174a47e3c" HTTP/1.x 200 OK Date: Tue, 17 Apr 2007 15:34:02 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET (05) X-AspNet-Version: 1.1.4322 Set-Cookie: RETS-Session-ID=90ff78ab95444124bc43cf0eac9bfd72; path=/ RETS-Version: RETS/1.5 Transfer-Encoding: chunked Cache-Control: private Content-Type: text/xml; charset=utf-8 -- ColdFusion Code Fragment: http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> http://www.w3.org/1999/xhtml";> RETS 1.5 Digest Auth Test http://rets15.raprets.com:6103/Itech/ITEC/Login.aspx"; method="get" > Initial Request Response Generated Authorization Header Authorization: #TheAuthorization# http://rets15.raprets.com:6103/Itech/ITEC/Login.aspx"; method="POST"> Authorization Response ~| 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:277567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Digest Authentication woes
Does anyone have any success stories performing CF Server to remote HTTP Server Digest Authentication? I know it's not natively supported by the tag. I also know the server I'm trying to connect to works and that I have proper credentials, as I can connect using a web browser. I even recorded all the communications exchanged during that session using FireFox's "Live Headers" & "Modify Headers" add-on and duplicated the exchange exactly with & s, but I keep getting "401 Bad Request. Response did not match." I was pretty careful duplicating the exchange as described in RFC 2617 "HTTP Authentication: Basic and Digest Access Authentication" I couldn't get the CFX_HTTP5 custom tag to work either even though it does support Digest Authentication natively. Any help/insight/experience/code would be appreciated. Paul ~| 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:277418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft Mappoint Working on CFMX 7 Standalone
>Hey Paul, > >I will get my working example packed up and on the web for your to >download. > > >Eric Eric, will you have that ready soon by any chance? Regards, Paul ~| 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:274398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Microsoft Mappoint Working on CFMX 7 Standalone
>WOW what a week!! I never thought I would be diving into java headfirst. I >was able to get a map rendered via Microsoft Mappoint .NET webservice. If >anyone is interested let me know and I will put up what I have. > >I am now working on adding functionality (I was just happy to get an example >to run) but I have all the classes and stubs generated with CFMX 7.0.2 > >-- >~Eric Yes Eric! I've been struggling with the code fragments I found for MX 6.1. I'd love to get your classes, stubs and instructions to set up the system, as well as a few basic examples of some calls. Paul ~| 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:273228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4