Re: Need RegEx help for unknown/odd characters.
How about making sure the charset is set properly. I have seen this kind of thing when not setting to UTF-8. This can be a problem either on the ingesting, or when the feed is written. On Fri, May 17, 2013 at 2:25 PM, Che Vilnonis ch...@asitv.com wrote: Nathan, the problem is that within the feed itself, the characters don't have accents. When output to a browser, they funky chars display on screen with odd geometric shapes like an upright rectangle. They're like odd ascii chars that I have only seen a few time before. In the end, I can't insert them into the MySQL db. Ché -Original Message- How about deAccent() ? http://cflib.org/udf/deAccent On Wed, May 15, 2013 at 9:20 AM, Che Vilnonis ch...@asitv.com wrote: Good morning. Occasionally when parsing a RSS feed, I get RSS data I cannot parse. Click for screenshot below (text highlighted in green). In this example, Montreal should return Montréal but does not. What regex could I use to remove or replace such odd characters? http://www.asitv.com/images/_funkychar.jpg ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with CFFTP LISTDIR
Some firewalls will not provide system info, which is requested by listdir to properly output the results from the listdir command. You can typically see a more verbose message for this in the FTP log. It will usually say something like sysinfo X unrecognized, etc. If you run into this, there is really no way around it with CFFTP that I have found. I ended up leveraging the jakarta commons library directly to get timestamp info off of file instead. Cheers, Kris On Fri, May 17, 2013 at 4:06 PM, Rick Root rick.r...@gmail.com wrote: I'm just dumping the cfcatch. On Fri, May 17, 2013 at 9:34 AM, John M Bliss bliss.j...@gmail.com wrote: What are you dumping to see the 215? It appears that FTP code 215 is, NAME system type. Where NAME is an official system name from the registry kept by IANA. Whatever that means. http://en.wikipedia.org/wiki/List_of_FTP_server_return_codes On Mon, May 13, 2013 at 1:07 PM, Rick Root rick.r...@gmail.com wrote: I have a scheduled job that runs once a week to retrieve a file from a server. The file may or may not exist so I run a LISTDIR operation. This worked fine until we upgraded to CF 10, and now it fails with Error 215. I can't find any useful information on the internet about error 215, neither from generic FTP error code sites nor specific documentation for the remote FTP Server (which appears to be Smart FTP version 1.0). I am able to run cfftp getCurrentDir ... but I can't list the directory cfftp action=LISTDIR name=files connection=ncoaftp directory=. I've tried about everything I can for the directory attribute (it used to just be blank... but I've also tried the actual directory name from the getCurrentDir output as well, along with . and none of it works.. all results are the same, Error 215. Anybody got any ideas what might be going on here? We are running CF 10 with all patches on Windows Server 2008 R2 x64 Thanks. Rick -- *The beatings will continue until morale improves.* ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Apache / X-Forwarded-For / CF
You can reference that as cgi.http_x_forwarded_for -- and it will come back blank if not there, and with a list of IPs otherwise. So I supposed you could do something in your onrequest that if it exists replaces cgi.remote_addr -- but that's not going to help you if it returns multiple IPs. (We usually see 2 IPs in the list). Also note: the IPs returned could well be another proxy. It is still not a definitive end-point resolver. Cheers, Kris On Wed, Aug 1, 2012 at 5:11 PM, Matthew Gersting mgerst...@gmail.comwrote: [snip] We're running our CF servers (using JRun and Apache) behind a load balancer, and as such the IP address that comes through the apps in CGI.REMOTE_ADDR is always the IP of the load balancer. Now, I'm familiar that the standard procedure for this seems to be having the proxy (or, in this case load balancer) add a header - X-FORWARDED-FOR. We've accomplished that. The question then is how to reliably use this value in both the scenario when it's defined (coming from the LB) and when it's not (when, say, I'm hitting a box directly via IP). In other threads on CF-Talk I've seen this come up and one solution was the same I came up with (basically an if IsDefined etc). That's all well and good, but my question is this: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFAdmin - Managing Individual User Logins
On my local Standard developer edition, the ColdFusion Archive does not provide the option to include user logins in the archive. Is this something that is only provided for enterprise? Cheers, Kris On Thu, Apr 26, 2012 at 11:04 AM, Russ Michaels wrote: You can use use the ColdFusion Archive to export the settings from one server and import them to the other servers. or you could give this a go, which I think also allows you to sync your settings between multiple servers, http://www.merlinmanager.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Somewhat OT....Making us look bad...For the adobe engineers on the list..
Wow. That's pretty tough. I didn't know that was required when installing 64-bit version of CF. -KJ On Fri, Apr 27, 2012 at 2:40 PM, Eric Roberts ow...@threeravensconsulting.com wrote: Why doesn't support seem to know to tell a customer, when they are installing CF9 standard on a 64 bit box that they need to go into the IIS application pool setting and enable 32 bit apps? I am doing a gig for a client that could get CF( installed and that was all it was). That should have been a quick fix. While i glad for the business, I just think this makes us as a community look bad when Adobe's support is that incompetent. I have a stack of emails going back and forth about an inch thick and not one mentioned. My client got a CF app dumped in their lap and they didn't have any CF resources. Sorry for the rant, but since I know we have some Adobe folks here...I thought this would be as good as a spot as any. This is a HUGE company that could potentially get impressed by CF and create a lot of CF jobs. I won't name them, but i can tell you that probably everyone on this list has consumed their products...some on a regular basis. This is how companies get turned off of products. This could have been a big win on Adobe's part. Way to drop the ball. Some days I think Adobe purposely tries to sabotage their own product. Adobe folks...feel free to pass this on to the appropriate people. back to your regularly scheduled topics... Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFAdmin - Managing Individual User Logins
Hi all, I've been trying to find the right way to manage multiple individual user logins to CFAdmin across multi-instance CF9.01, and across multiple servers. Although the user accounts are stored in the neo-security.xml file, the passwords are hashed, and I would suspect that the hash is different on different machines. Also, simply editing the neo-security.xml doesn't change the setting in CFAdmin from single user to multiple individual users. If it was just one server that we have to administrate this way, I wouldn't worry about it. But we've got many, and I'd rather not go through the labor to set this up on each one manually. Any advice? Cheers, Kris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ExactTarget SOAP API
The program architect assigned to our account sent me a bunch of samples for various calls - this helped a lot, but they are, of course, far from complete, documented, or anything approaching obvious on which to use. There are a lot of soap packet examples in the wiki, and if you trace objects/attributes (also in the wiki), you can usually figure out what else to add. In one case where I couldn't get a specific attribute to work, I called support - and they helped figure it out within 30 minutes (needed to be in a different method call). Cheers, Kris On Mon, Apr 25, 2011 at 11:51 AM, Svetlin Roussev svetlin.rous...@fuelinteractive.com wrote: You best chance is to use 3sixty from ExactTarget and use their .NET examples and using Charles to see what exactly is send so you can create your CF calls. Good Luck On Mon, Apr 18, 2011 at 10:22 AM, Steve Reich coldfusionst...@gmail.comwrote: Does anyone have any experience with CF and ExactTarget's SOAP API. We have been using the XML flavor, but want to switch to the more robust SOAP API. Unfortunately, their documentation is pretty unorganized and I can't find any sample code on the web. I can't be the first one doing this. Anyone? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IE8 Form Submit button not being passed
I've seen this problem and long ago (over 8 years ago) read documentation on it too. Can't find it now, but the issue typically affects forms that have a single field and a submit button, that are submitted using the enter key instead of clicking the submit -- only in IE. If you add a second visible field to the form, you should see the problem magically disappear. Cheers, Kris ---orig post-- I am testing my application on an IE8 system running Win 7 and CF 9. I do not know if any of these are relevant but the problem does not occur on Firefox or Chrome. Essentially, IE is not passing the FORM.Submit to my post-back form processor. It passes everything else, including Submit.X and Y!! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
DSN Connection String - failover faster/better?
Hi all, We're using SQL Server mirroring w/ SQL Server 2k8, and have setup for automatic failover in the connection string attribute (Other JDBC type). The one thing that is a bit of pain is that the CF instances have to get a failure message back from the DSN before actually failing over -- e.g., the first caller will get an error message; the 2nd caller will get success. This is because the datasource maintains connection (which we want for resource and performance reasons of course). Has any one come across something that we could add to this connection string that would automatically failover when unreachable? jdbc:macromedia:sqlserver://mydb.mydomain.com:1433 ;databaseName=mydbname;SelectMethod=direct;sendStringParamatersAsUnicode=false;MaxPooledStatements=1000;AlternateServers=( myaltdb.mydomain.com:1433) Cheers, Kris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: DSN Connection String - failover faster/better?
Hi Brian, I mistyped -- we are running 2k8 in 2k5 compatibility mode. I took the advice of my sysadmin who is also a certified MSSQL guy (and a really smart one too). With Mirroring you can specify the failover partner in the connection string. You have a primary, and a secondary. When the primary fails, the secondary becomes the primary, and when the failed server comes back online, it becomes secondary. This is all transparent (as far as I know, and based on what I've been told and read). I really don't know how a DB cluster would better suit our needs. The failover is plenty fast actually -- it's just that I'd like to have it so that CF doesn't have to return a connection failure to the caller before failing over. Naturally it needs to see the failure, but I'd hope there'd be something in the connection that would re-try once if it were configured for mirror w/ failover partner? We're running a 12-instance CF Cluster, and it returns a failed connection for each instance. Given a user Joe, and a not so busy application, let's say that Joe logs on, and hits an instance. The primary has failed, so Joe gets an error. Being a persistent guy, Joe then reloads the page, where he hits another instance, and gets another error. And so on, and so on. Luckily, we're talking more than 1 server, with LB w/ sticky session in front of the cluster. So Joe will only get this a maximum of 4 times. But this same scenario would have to happen on each of the instances across the cluster. And I'd rather not have the error return to Joe (or any user) in the first place. Cheers, Kris On Wed, Jan 26, 2011 at 6:32 PM, Brian Cain bcc9...@gmail.com wrote: Hi Kris, I don't really have a suggestion for your issue, but I was wondering what factored in to your decision to use mirroring instead of a DB cluster. I use a 2 node database cluster running MSSQL 2K5 and can drop the primary node and see my system recover (including running CF requests) in less than 30 seconds. I am not a database expert, but love the setup I have now. Thanks, Brian Cain ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01
Hi Dave, That's what I'm saying -- I'm normalizing the case -- I'm explicitly setting the image name to lcase(imagepathname) in the cfimage tag. If however -- and this was definitely an edge case happening in testing -- there is an image already at that path with the same name except for case, cfimage will not change the filename to the explicit lcase version specified in the tag. Certainly, I wish I always had control over how and when platform decisions were made. Unfortunately, that's not real world. I am, however, very aware that there is the potential for this image-stor to be moved at some point in the future -- if we were to move to a CDN, for instance. The CDN we use for other applications is definitely on a case-sensitive OS, so there you have the scenario that concerns me. I've got the issue taken care of, in that there will not be any upper-case filenames in the image-stor to start. But it was a problem I ran into, and thought I'd get the feedback on what the behavior _should_ be, rather than what it is. Cheers, Kris On Tue, Jan 18, 2011 at 11:35 AM, Dave Watts dwa...@figleaf.com wrote: The issue was not whether the overwrite was happening -- it definitely was -- the new image was written. There was no ftp involved -- this was all cffile from a form post. What I noted was that the original file -- the one being overwritten (with the same name, but different case), did not use the explicit case specified in the cfimage tag. Added interesting note is that the file is being resized as well. While this isn't really an issue for us on a windows server, if we were to ever move this image storage to, say, a linux server, this would be a problem, in that what we've stored in the DB as the filename would not match the filename on disk. We're expecting a lower-case image name since that's what we're passing to cfimage, so that's what we're storing in the DB. Well, Windows isn't going to change its behavior just for you. So, you might need to take additional steps to deal with this. On the other hand, if you just ran it on Linux (or other OSs with case-sensitive filesystems) in the first place, you wouldn't have encountered the problem, right? The only time you should encounter a problem is if you start running it on Windows, then need to migrate it and its existing data to Linux. So it seems to me that you can either (a) add functionality to the application to normalize cases just for Windows, or (b) create a normalization process for migration purposes. I'd go with (b) I think. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Permanent Redirect (301)???
Another thing you might want to look at -- not a redirect resolution at all -- but is setting up a canonical tag. This is so that if you have the site serving from both www.whatever.com and whatever.com, and you don't really care about which one the user uses, Google will index them as if they have the same domain. You decide which one in the canonical tag. Cheers, Kris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01
The issue was not whether the overwrite was happening -- it definitely was -- the new image was written. There was no ftp involved -- this was all cffile from a form post. What I noted was that the original file -- the one being overwritten (with the same name, but different case), did not use the explicit case specified in the cfimage tag. Added interesting note is that the file is being resized as well. While this isn't really an issue for us on a windows server, if we were to ever move this image storage to, say, a linux server, this would be a problem, in that what we've stored in the DB as the filename would not match the filename on disk. We're expecting a lower-case image name since that's what we're passing to cfimage, so that's what we're storing in the DB. Cheers, Kris One of us apparently misunderstood the OP's issue. :-) I thought he said that the file was being renamed, as opposed to overwritten. You are stating that it is indeed being overwritten. I'm not sure which the case is, but as Robert pointed out, it might be a file lock issue. shrug No, it's not a file lock issue. In Windows, when you overwrite a file, it doesn't matter what case you specified - the filesystem performs a case-insensitive match, and overwrites whatever's there. If you want different behavior, you need a case-sensitive filesystem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone know anything about this new ColdFusion conference?
I think it's the first time this conference has been run. I've signed up. Just need to make my lodging and plane reservations. And yeah, it's for-real -- the organizers are well-respected in the community and are focused on the open-source arena, and that's what this conference is about. Cheers, Kris Ever since CFUnited closed up shop, I've been looking around for an affordable substitute. I'm local in the Northern Virginia area, so I saved on lodging and travel. I saw something on Sean Corfield's blog about this new conference in Dallas and, while I'd have to pay travel and lodging, the conference is apparently only $30?!?!?! They have a pretty funny video: http://blog.opencfsummit.org/ Just wondering what folks thought about it. The schedule seems to have a lot of substance. And hard to argue with $30. But then again, $30?!?! Is is for real? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIMAGE - case sensitivity on filename - CF9 vs CF9.01
Figured out what the issue was here (was not related to difference in version). There was a file with the same name (but uppercase) already in the directory. The code specified to overwrite on name conflict. This environment is windows, so I guess CFImage doesn't actually rename the file on overwrite. Should this be the expected behavior? Just curious what others think. Cheers, Kris Wondering if anyone has run into this with CFImage under CF9. I'm writing a file on my local developer version 9.0. I am explicitly writing the filename as lower-case doing a resize operation. In development environment, enterprise version 9.0.1, the file is always written with uppercase filename (the extension is lowercase though.) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFIMAGE - case sensitivity on filename - CF9 vs CF9.01
Hi all, Wondering if anyone has run into this with CFImage under CF9. I'm writing a file on my local developer version 9.0. I am explicitly writing the filename as lower-case doing a resize operation. In development environment, enterprise version 9.0.1, the file is always written with uppercase filename (the extension is lowercase though.) Same code-base on both systems. Can't find anything via google, or in the bug DB. Cheers, Kris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SerializeJSON return different between CF8 and CF9
Hi folks, Was reworking a function today to use serializejson instead of building the json myself. Love this functionality. Unfortunately, I've run into a snag when I pushed this over to a CF8 box where it must run. The double-quotes on elements in the JSON returned are escaped when run from the CF8 box, but are not escaped (the desired format) when run from CF9. I checked hotfixes, and updated the CF8 box to chf4, which includes the functionality for returnformat=json. CF9 Format: {COLUMNS:[CREATE_DT,ID,CMS_ID,NAME],DATA:[[December, 30 2010 19:16:31,32,KJ301220101413,null],[December, 30 2010 18:33:45,31,KJ301220101413,null]]} CF8 Format: {\COLUMNS\:[\CREATE_DT\,\ID\,\CMS_ID\,\NAME\],\DATA\:[[\December, 30 2010 19:16:31\,32,\KJ301220101413\,null],[\December, 30 2010 18:33:45\,31,\KJ301220101413\,null]]} Anyone have any experience with this? Know the fix? Cheers, Kris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SerializeJSON return different between CF8 and CF9
Okay, finally figured this out: To make this work in CF8 (w/ chf4 applied), I had to change the returnformat to plain, rather than json. Otherwise it escaped all the quotes used to construct the JSON. This does not happen in CF9. Searched and searched for this on the web to no avail - hopefully this will save someone else some time. Cheers, Kris Was reworking a function today to use serializejson instead of building the json myself. Love this functionality. Unfortunately, I've run into a snag when I pushed this over to a CF8 box where it must run. The double-quotes on elements in the JSON returned are escaped when run from the CF8 box, but are not escaped (the desired format) when run from CF9. I checked hotfixes, and updated the CF8 box to chf4, which includes the functionality for returnformat=json. CF9 Format: {COLUMNS:[CREATE_DT,ID,CMS_ID,NAME],DATA:[[December, 30 2010 19:16:31,32,KJ301220101413,null],[December, 30 2010 18:33:45,31,KJ301220101413,null]]} CF8 Format: {\COLUMNS\:[\CREATE_DT\,\ID\,\CMS_ID\,\NAME\],\DATA\:[[\December, 30 2010 19:16:31\,32,\KJ301220101413\,null],[\December, 30 2010 18:33:45\,31,\KJ301220101413\,null]]} ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SerializeJSON return different between CF8 and CF9
Doh! Yes, exactly what I'm doing. Here's the weird thing though - works fine in CF9. Perfect. In CF8 it simply escapes all the quotes in the JSON string itself. Strange behavior? Or just an incompatibility? I honestly didn't understand that returnformat=json was actually serializing the json. I thought it was killing the wddx formatting. Thanks for the education! Cheers, Kris On Thu, Dec 30, 2010 at 9:37 PM, Raymond Camden rcam...@gmail.com wrote: Dumb question. But you are doing something like this: cfreturn serializejson(data) but _also_ adding returnFormat=json? If so - you are double serializing the JSON. On Thu, Dec 30, 2010 at 8:09 PM, Kris Jones kris.jon...@verizon.net wrote: Okay, finally figured this out: To make this work in CF8 (w/ chf4 applied), I had to change the returnformat to plain, rather than json. Otherwise it escaped all the quotes used to construct the JSON. This does not happen in CF9. Searched and searched for this on the web to no avail - hopefully this will save someone else some time. Cheers, Kris Was reworking a function today to use serializejson instead of building the json myself. Love this functionality. Unfortunately, I've run into a snag when I pushed this over to a CF8 box where it must run. The double-quotes on elements in the JSON returned are escaped when run from the CF8 box, but are not escaped (the desired format) when run from CF9. I checked hotfixes, and updated the CF8 box to chf4, which includes the functionality for returnformat=json. CF9 Format: {COLUMNS:[CREATE_DT,ID,CMS_ID,NAME],DATA:[[December, 30 2010 19:16:31,32,KJ301220101413,null],[December, 30 2010 18:33:45,31,KJ301220101413,null]]} CF8 Format: {\COLUMNS\:[\CREATE_DT\,\ID\,\CMS_ID\,\NAME\],\DATA\:[[\December, 30 2010 19:16:31\,32,\KJ301220101413\,null],[\December, 30 2010 18:33:45\,31,\KJ301220101413\,null]]} ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Looking for the right SMTP server
We've been using SmarterMail since iMIS kind of disappeared. Not bad, but we're having problems with it choking somewhere between 58k-140k messages. Pretty easy to trace individual messages through their logs, and search utilities in the console. We also have mailenable in use, and it has been rock solid. Doesn't have the ease of search for tracing that SmarterMail does. All that said, we're looking at moving to a 3rd-party service due to the difficulty in managing the large amount of messages we send -- can be several hundred thousand a day depending on the news day. Cheers, Kris Thanks, but I'm not looking for a hosted service, but for a true server software. ~| 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:337669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
It's not elegant, but I've found that throwing an error on the datasource works for releasing them. Try a query against the dsn for a table that doesn't exist. Cheers, Kris Try deleting the .ldb file. On Wed, Sep 15, 2010 at 8:58 AM, Mike Kear afpwebwo...@gmail.com wrote: I have to make an Access database containing updated data from my SQLServer database, which can be downloaded by my users by FTP. I can make the Access database a coldfusion datasource, and fill it up with the data I want, but I need to release it from the lock ColdFusion puts on it. Does anyone have a technique for releasing that lock nowdays? (I'm using CF9 Enter ~| 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:337210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output newest one item from each category
Take a look at the CROSS APPLY operator in T-SQL. It is designed to do this. Cheers, Kris On Sat, Jul 31, 2010 at 10:41 AM, Les Mizzell lesm...@bellsouth.net wrote: Scott Brady wrote: There's probably a way to do it just in the query (using subqueries perhaps), but here's one option: It's not that easy! Change your query to this: Select catg, nltitle, nldate from newsletters order by catg, nldate DESC Then, for your output: cfoutput query=yourQuery group=catg #yourQuery.nldate# #yourQuery.catg# #yourQuery.nltitle#br / /cfoutput Your query returns the below (I've removed the grouping) nldate catg nltitle 6/23/2010 bob another bob found! 6/23/2010 cars new nissan models 6/28/2010 grants something title 6/28/2010 grants another title 6/25/2010 grants more grant stuff 6/27/2010 news yes a title 6/27/2010 news good news today 6/23/2010 news tom just died 6/24/2010 toys new hotwheels Adding grouping give us: 6/23/2010 bob another bob found! 6/23/2010 cars new nissan models 6/28/2010 grants something title 6/27/2010 news yes a title 6/24/2010 toys new hotwheels The order is now wrong - needs to be date newest to oldest. When you sort by catg, nldate - the categories are date sorted, but not the full list. What I need is: 6/28/2010 grants something title 6/27/2010 news yes a title 6/24/2010 toys new hotwheels 6/23/2010 bob another bob found! 6/23/2010 cars new nissan models See the problem? __ Information from ESET NOD32 Antivirus, version of virus signature database 5328 (20100731) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.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:335910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How Many CFCs is too many CFCs
Andrew, Can you elaborate on the problems you've seen loading Application scoped objects into the request scope? We're having some problem with this as well, re: garbage-collection. Is there any documentation you can point me at for this issue? What alternative do you recommend? Just always calling the shared-scope object directly, instead of referencing the request scoped object? For what it's worth, the request scoped object would just be a pointer to the App-scoped object. So on request end, the pointer should be set null, and should be garbage-collectable, right? Cheers, Kris On Tue, Jul 13, 2010 at 3:22 PM, Andrew Clarke s...@clarke.ca wrote: I took a quick read through your email and couldn't find anything inherently wrong with the design IMHO. Having 60 objects in the application scope I presume is analogous to saying you have 60 singletons. Let's say you have 10 simultaneous requests at any given point. It's better to have 60 object instances than 600 which is what you'd get if you put them in the request scope or somewhere else. I also don't see any real issue to having 60 lightweight objects vs. 20 where each one is 3x as large. They aren't going to multiply as the server loads up. Using application-scoped objects means that you will need to be very sure you are scoping all your variables correctly to avoid bugs. Also, be sure you're not adding persistent objects like session or application objects into any other objects like your request object. I've had JVM GC issues when I've done that as it seems that the request objects aren't garbage-collected properly as they contain objects in the session or application scope. Make sure your variables are scoped properly, make sure you're not mixing your persistent and non-persistent scopes together (like copying application.foo into request.bar.foo) and you should be fine. - Andrew. ~| 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:335344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How Many CFCs is too many CFCs
One reason I ask is that I've done quite a bit of work on trying to resolve this exact issue in an application we're working now. I did find a couple of relevant posts, that appear to address the issue. We're still having some problems with other code, but fixing the missing output attribute problem seemed to resolve a good deal of the problems we were having. http://www.bytestopshere.com/post.cfm/must-read-coldspring-bug-memory-leak http://blog.maestropublishing.com/fixing-a-mysterious-memory-leak-on-coldfusion We also ran through with varscoper, and found one place in particular where a non-var scoped variable was hurting us big time. But I think pointing to a var scoping issue as a memory leak would be a rare occasion -- more likely just a big problem with incorrect data. I'm really curious what other folks have experienced as regards the hard-bind issue. I know many are using frameworks that would experience this issue, so I can't imagine it has gone unnoticed. Cheers, Kris On Wed, Jul 14, 2010 at 10:52 AM, Andrew Clarke s...@clarke.ca wrote: I don't recall 100% what the problem was, but I'll tell you what I remember. I built www.knappfast.com a few years ago using ColdBox ColdSpring. If you look at the site, bear in mind that I have nothing to do with the look feel, and that it was started in 2007 ;-) For various reasons, it just went live last month. Anyway, there were some singleton objects, and some other objects. There were some instances where I tried to put a singleton into other objects. For example, I'd have, say, a cart. Each user would have his/her own cart, but there would only need to be one cart DAO. So I put the cart DAO in as cart.DAO so I could do something like cart.DAO.save(). I'm simplifying things a bit but you get the idea. CartDAO was probably saved as a singleton in ColdSpring. I also have some very large objects that can store a LOT of data. There are some processes that pull tens of thousands of products, so if a bunch of those aren't released, you'll see memory climb very rapidly and then not get released. The issue was that if CartDAO was saved in the application or session scope, the cart object wouldn't GC properly as it had a handle on an application-scoped object. I tried a few things, including: 1. Changing JVM arguments to allow a larger max memory size (-XX:MaxPermSize=768m). While this certainly helped, it really only helped to delay the problem rather than to eliminate it. 2. Using structCopy(). However, structCopy() only copies the topmost part of a structure (or object) by value and copies everything else by reference. Therefore this didn't resolve the problem. 3. Using duplicate(). IIRC this helped in development on CF9 but when I went to deploy on CF7 I found out that you can't use duplicate() on objects, only generic structures. 4. Ripping out ColdBox and ColdSpring. I wrote my own very lightweight replacement framework that only does the things I need it to do. This helped a lot as I now have fewer black boxes in my code, and things run a lot faster and consume less memory. 5. I also tried explicitly calling garbage collection at the end of every request: var obj = createObject(java,java.lang.System); obj.gc(); obj.runFinalization(); This certainly adds a bit of overhead to every page request and I wouldn't recommend this specific approach to a high-volume site, but it tends to bring down memory usage more quickly than waiting for Java to GC. However, it doesn't resolve the core problem if garbage collection isn't releasing the memory anyway. 6. Finally, I ended up realizing what the problem was and stopped using session and application singletons. I now create a per-request singleton object that gets destroyed along with the rest of the request. It's not a high-volume site and this was a better solution than re-architecting everything to allow session or application-based singletons. I'm sure there are others on here who have done a better job of avoiding, identifying, and/or resolving this issue, but these are the steps I went through. - Andrew. On 2010-07-14, at 06:42, Kris Jones wrote: Andrew, Can you elaborate on the problems you've seen loading Application scoped objects into the request scope? We're having some problem with this as well, re: garbage-collection. Is there any documentation you can point me at for this issue? What alternative do you recommend? Just always calling the shared-scope object directly, instead of referencing the request scoped object? For what it's worth, the request scoped object would just be a pointer to the App-scoped object. So on request end, the pointer should be set null, and should be garbage-collectable, right? Cheers, Kris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe
JVM args, GC issues, performance tuning - CF9, Win2k8
Hi all, We've been running into some issues while testing a new deployment. Servers are CF9 (hf1) on Win2k8 64-bit. Also seeing same problems on developer machines running Win7 64-bit, and WinXP (32-bit). We're seeing the problem on both CF9 Standard as well as CF9 Enterprise. We're having trouble getting the GC to maintain a happy state, service climbs and climbs, and eventually kacks the server. Wondering if any of the following suggestions for GC settings etc., still apply for CF9. http://www.coldfusionmuse.com/index.cfm/2005/10/28/jvm.gc http://www.petefreitag.com/articles/gctuning/ Did find this, which shows his solution, but no good discussion about setup based on server config: http://forums.adobe.com/thread/642057?tstart=0 And this one discusses 64-bit implementation, but again, no real guidelines for how to tune. http://groups.google.com/group/cfaussie/browse_thread/thread/3932bce486621abe/8b37ea8cbe0384b6?pli=1 And on GC itself: http://www.softwaresecretweapons.com/jspwiki/thelastjavagarbagecollectionguideyouwilleverneed Are there other resources that detail JVM args, GC settings, versions, etc., as relates to CF9? Is it advisable to change the GC type? CF9 ships with 6.0_14, which doesn't exhibit the class loader bug. We are seeing some mem lost when passing very large strings between objects. This is resolved if we package the strings inside of structs (pass by ref vs. pass by val), or write the process old-school. But, honestly, is that a solution? We've implemented a check for var scoping errors across the board, and have made sure that the output attribute on every function definition is there and set to either true or false (not left blank, or undefined). Thoughts? Or is time to give up, punch the clock and retire? Cheers, Kris ~| 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:335271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JVM args, GC issues, performance tuning - CF9, Win2k8
It's as default as it gets. No changes from initial install at all: An enterprise server CF9 hf1: java.args=-server -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch -Dcoldfusion.rootDir={application.home}/ -Djava.security.policy={application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/coldfusion.policy -Djava.security.auth.policy={application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/neo_jaas.policy A standard server CF9 hf1: java.args=-server -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch -Dcoldfusion.rootDir={application.home}/../ -Djava.security.policy={application.home}/../lib/coldfusion.policy -Djava.security.auth.policy={application.home}/../lib/neo_jaas.policy -Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars,{application.home}/../wwwroot/WEB-INF/flex/jars -Dcoldfusion.libPath={application.home}/../lib Cheers, Kris On Mon, Jul 12, 2010 at 5:16 PM, Wil Genovese jugg...@trunkful.com wrote: Please post your JVM config line from jvm.config I can most likely give you the pointers you need once I see your existing config arguments. We've been running into some issues while testing a new deployment. Servers are CF9 (hf1) on Win2k8 64-bit. Also seeing same problems on developer machines running Win7 64-bit, and WinXP (32-bit). We're seeing the problem on both CF9 Standard as well as CF9 Enterprise. We're having trouble getting the GC to maintain a happy state, service climbs and climbs, and eventually kacks the server. Wondering if any of the following suggestions for GC settings etc., still apply for CF9. http://www.coldfusionmuse.com/index.cfm/2005/10/28/jvm.gc http://www.petefreitag.com/articles/gctuning/ Did find this, which shows his solution, but no good discussion about setup based on server config: http://forums.adobe.com/thread/642057?tstart=0 And this one discusses 64-bit implementation, but again, no real guidelines for how to tune. http://groups.google.com/group/cfaussie/browse_thread/thread/3932bce486621abe/8b37ea8cbe0384b6?pli=1 And on GC itself: http://www.softwaresecretweapons.com/jspwiki/thelastjavagarbagecollectionguideyouwilleverneed Are there other resources that detail JVM args, GC settings, versions, etc., as relates to CF9? Is it advisable to change the GC type? CF9 ships with 6.0_14, which doesn't exhibit the class loader bug. We are seeing some mem lost when passing very large strings between objects. This is resolved if we package the strings inside of structs (pass by ref vs. pass by val), or write the process old-school. But, honestly, is that a solution? We've implemented a check for var scoping errors across the board, and have made sure that the output attribute on every function definition is there and set to either true or false (not left blank, or undefined). ~| 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:335276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Facebook Connect and coldfusion
Sorry guys, I'm happy to post something, I'm just completely underwater with work ramping up for a launch. I hope to have time to scrub-up some code to post this weekend. Cheers, Kris On Thu, Jul 1, 2010 at 2:28 PM, Dustin Wardlow dustinward...@gmail.com wrote: Hello, Kris I can understand how you would not want to post much on this forum for everyone to use, but do you know of anywhere that might be a good source of info on this specific topic... I am afraid Jeff is not the only one struggling with this, lol My Best, Dustin Jeff, very sorry to be out of the loop. (But this did give me a chuckle.) Just been underwater with work. I'll send you something on Monday. Cheers, Kris ~| 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:335030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Facebook Connect and coldfusion
Jeff, very sorry to be out of the loop. (But this did give me a chuckle.) Just been underwater with work. I'll send you something on Monday. Cheers, Kris On Wed, Jun 23, 2010 at 6:36 PM, Jeff Gladnick jeff.gladn...@gmail.com wrote: Oh christ, i had submission errors and it wasn't coming up, and I assumed the form submittal failed outright.. whoops. Reading between the lines, I think Jeff might want you to share some code :) On Wed, Jun 23, 2010 at 10:47 AM, Jeff Gladnick jeff.gladn...@gmail.comwrote: ~| 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:334865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF on IIS and 405 error
Developing on localhost -- XP, or Win7. Dev, Stage, Production are all Win2008 Servers. Cheers, Kris On Mon, Jun 21, 2010 at 9:46 AM, Matthew Small chestypul...@beachbum.net wrote: Are you using Windows XP or 2000 as the webserver? If so, then this applies. http://support.microsoft.com/kb/216493 Thanks Bobby, Just tried that, same result. ~| 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:334742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Facebook Connect and coldfusion
We're using FBConnect for a site in development now. It works fine, no problem. Except when FB does something stupid and breaks the API. Which happens every couple of weeks. Cheers, Kris ~| 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:334745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF on IIS and 405 error
I know this isn't CF-specific, but was wondering if anyone has a way around this. Trying to avoid specifying the script name in the form action, and IIS isn't happy about that when using method=post. Works fine with get. index.cfm is declared as default document for the directory. From what I've read this is a long-standing issue with IIS (no script name in form action, method=post, default document is not called). Form looks something like this: cfoutput form id=searchLocation name=searchLocation method=post action=?#cgi.query_string# input type=text name=currentLocation id=currentLocation value=#someexistingvalue# / input type=hidden name=webaction value=anothervalue / button class=rounded rounded-locGo/button /form /cfoutput Want to pass querystring with the action. Removing the method avoids the 405 error, but really don't want to use GET method. Cheers, Kris ~| 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:334665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF on IIS and 405 error
Thanks Bobby, Just tried that, same result. Cheers, Kris On Sun, Jun 20, 2010 at 4:59 PM, Bobby Hartsfield bo...@acoderslife.com wrote: Have you tried: /?#cgi.query_string# I know this isn't CF-specific, but was wondering if anyone has a way around this. Trying to avoid specifying the script name in the form action, and IIS isn't happy about that when using method=post. Works fine with get. index.cfm is declared as default document for the directory. From what I've read this is a long-standing issue with IIS (no script name in form action, method=post, default document is not called). Form looks something like this: cfoutput form id=searchLocation name=searchLocation method=post action=?#cgi.query_string# input type=text name=currentLocation id=currentLocation value=#someexistingvalue# / input type=hidden name=webaction value=anothervalue / button class=rounded rounded-locGo/button /form /cfoutput Want to pass querystring with the action. Removing the method avoids the 405 error, but really don't want to use GET method. Cheers, Kris ~| 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:334667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Different Extension from cfm
Hi all, Wondering if anyone has changed the file extension to which ColdFusion engine is associated. A client of mine is asking for this, and I'm not seeing any big problem with it myself. Wondered what road-blocks, gotchas, etc., are out there that I'm just not thinking of right now. The client is running on Win 2k8 on IIS, CF9 enterprise. -KJ ~| 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:334545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Different Extension from cfm
Thanks Dave, I do know that it can done -- pretty easily. Just looking for the gotchas. The hint about not mapping static file extensions is appreciated. In fact, just such an extension was requested, and I recommended against it. But... Cheers, Kris On Mon, Jun 14, 2010 at 7:05 PM, Dave Watts dwa...@figleaf.com wrote: Wondering if anyone has changed the file extension to which ColdFusion engine is associated. A client of mine is asking for this, and I'm not seeing any big problem with it myself. Wondered what road-blocks, gotchas, etc., are out there that I'm just not thinking of right now. The client is running on Win 2k8 on IIS, CF9 enterprise. Yes. People have occasionally done this as long as CF has existed. But it doesn't really buy you anything, so I'd generally recommend against it. It's time and effort spent for no actual value. And specifically, you don't want to map static file extensions (.html/.htm) to CF, as that will make CF do more work if you have actual static pages. You can do this by configuring CF and your web server. CF is configured using /WEB-INF/web.xml if I recall correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.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:334547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Different Extension from cfm
Client is interested in obscuring that it's CF. They know that it's not fool-proof by any means. They don't have anything against CF, obviously. If they were running a php site, they'd want to obscure that too. Cheers, Kris On Mon, Jun 14, 2010 at 8:03 PM, Bryan Stevenson br...@electricedgesystems.com wrote: On Mon, 2010-06-14 at 19:17 -0400, Dave Watts wrote: I've never seen any compelling justification for doing this. I've seen a client use it to password protect HTM/HTML files using the benefits of good old application.cfm (being that it runs before any CF file is run or those extensions mapped to be run via CFmeaning you can use standard CF built security for non-CF files). Not Earth shattering stuff by any stretch, but a valid use beyond vanity ;-) ~| 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:334554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx help
How about something like this: cfset arFound = refindnocase(Age:([^\r\n|\r|\n]*)[\r\n|\r|\n],thestring,1,true) / cfoutput#mid(thestring,arFound[pos][1],arFound[len][1])#/cfoutput Cheers, Kris ~| 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:334365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx help
Rather, that would be, if you don't want the label of the field: cfoutput#mid(thestring,arFound[pos][2],arFound[len][2])#/cfoutput Cheers, Kris On Tue, Jun 8, 2010 at 11:43 AM, Kris Jones kris.jon...@verizon.net wrote: How about something like this: cfset arFound = refindnocase(Age:([^\r\n|\r|\n]*)[\r\n|\r|\n],thestring,1,true) / cfoutput#mid(thestring,arFound[pos][1],arFound[len][1])#/cfoutput ~| 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:334366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing ColdFusion 9 search services, after the fact.
You've probably already done this, but is the solr setting in CFAdmin pointing to the correct path? If you are running a multi-instance/enterprise, you'll probably need to change the default path that's set there. We installed solr after-the-fact (did not install any CF search service), by downloading the solr installer from Adobe (see standalone installers here: http://www.adobe.com/support/coldfusion/downloads.html). Somewhere -- can't recall where -- I read about the default solr location path needing to be tweaked if running enterprise. Cheers, Kris On 5/28/2010 10:53 AM, Dave Watts wrote: There are all kinds of reasons why services won't run. I would check the logs in /jrun4/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/solr/logs. ~| 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:334123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 local scope gotcha
My experience has always been that inside a cfloop on a query, you must specify the scope. Inside a cfoutput on query you do not need to specify the scope. Cheers, Kris I believe this behavior is as expected, however it breaks our code that worked in CF 8. Similar issues have been discussed here and maybe even raised on the bug tracker, but I didn't see an example quite like this, so I wanted to share. Basically, when in a function (where local scope is automatically created) and looping over a query or a list, you may reference a column name or the list index without adding a scope. For example, myQuery has a column named key. cfloop query=arguments.myQuery cfset local.key = key /cfloop On the first iteration through the loop, the variable local.key does not exist. The column key is found in the query, and now local.key equals that value; say it is 1. On the next loop iteration, CF sees that local.key indeed does exist and never looks to the query for the column key. The scope hierarchy looks in LOCAL before it looks to the query we are looping over. So each subsequent assignment of local.key will equal 1. There are several fairly simple workarounds: don't use the same variable name for the local scope; scope the right side of the assignment; etc. The point is you will need to watch out for this on legacy code if you're upgrading to ColdFusion 9. I don't think this should be filed as a bug, although the current scope hierarchy could be debated. That is why I'm posting here and on my blog which also has sample code for download: http://www.mattjanell.com/index.cfm?event=showEntryentryId=B5EBBF4F-0C02-AEAF-607ECCAD91A37089 ~| 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:333875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL 2k8 Datasources on CF9 64-bit on Win7
We're experiencing some strange behavior in CFAdmin setting up a datasource to a SQL 2k8 server. Datasource sets up fine on 32 bit machine. And we've had 2 64-bit Win7 instances able to setup the DSN successfully as well. But this one system just won't cooperate. It throws: Connection verification failed for data source: dbnamehere java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database dbnamehere requested by the login. The login failed. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database dbnamehere requested by the login. The login failed. We found a post that suggested that the JRE needed to be upgraded or switched to the full JDK (it was already the JDK) for multi-language support. We looked into that. Still no success. What fixed the immediate issue: Copied the neo-datasources.xml from another system. The datasources work fine. But we still can't create new datasources to SQL 2k8 servers. Thoughts? Cheers, Kris ~| 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:333876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFEclipse on Mac with Subclipse -- unstable?
Subclipse doesn't have an auto-detector that I know of. That would suggest that you have a subclipse client version that is compatible with SVN 1.5.6? That may not be the correct version. My svn his hosted on projectLocker and can't find what version they're using, so I have a support request in to verify it. It's connecting with a connecto for SVN 1.5.6, which I assume it auto-detected (?). Scott ~| 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:333299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFEclipse on Mac with Subclipse -- unstable?
Oh, and here is a link to the old Tigris site for downloads: http://subclipse.tigris.org/servlets/ProjectProcess?pageID=p4wYuA This link shows all the various client update site archives. Saved me when I had to link against Subversion 1.4.2: http://subclipse.tigris.org/servlets/ProjectDocumentList?folderID=2240expandFolder=2240folderID=0 Cheers, Kris Subclipse doesn't have an auto-detector that I know of. That would suggest that you have a subclipse client version that is compatible with SVN 1.5.6? That may not be the correct version. My svn his hosted on projectLocker and can't find what version they're using, so I have a support request in to verify it. It's connecting with a connecto for SVN 1.5.6, which I assume it auto-detected (?). Scott ~| 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:00 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFEclipse on Mac with Subclipse -- unstable?
Scott, SVN doesn't care what the extension on a file is. Doesn't matter at all. You do need to be aware of what version of the subversion server you are running, and make sure the client you are using is targeted for that version. For instance, if you are running a 1.4.x SVN server, you cannot reliably run a client (whether it's subversive, subclipse, tortoise, etc) that is targeted for 1.6.x only. Some clients are cross-compatible. Our mac designers use either the command line, or Versions. Versions is cross-compatible with 1.4, 1.5, 1.6, but it does have limitations in what it can do as a client. Cheers, Kris Well, I've switched to subversive and continue to have problems. It's not a specific file -- but, it's possible it's only with CFCs. I don't know for sure, I've been working mainly in CFCs, but the problem might have occurred in CFM files, as well. I'll try to pay more attention. Since it's not subclipse in particular, I guess it could be one of the following: 1) the SVN libraries the SVN plugins use [I think they're the same, but not sure] -- I have installed the latest SVN stuff from collab.net 2) the cfeclipse plugin 3) the version of java on my machine that cfeclipse is running. Scott ~| 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:333279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 64-bit fails requiring reinstall
FYI, we found the issue with this: After a third developer did an install with the exact same result, running diff on configuration files against a clean install showed the problem. Each developer had previously been running CF8. Created a .car file of their settings. Uninstalled CF8, rebooted. Installed CF9 64-bit developer, rebooted. Restored .car file. System ran fine until services got restarted at some point -- either through a reboot or simply restarting the services for some other purpose. jvm.config as well as numerous other settings files showed essential paths pointing to \Coldfusion8 rather than \Coldfusion9. Fixing these paths resolved the problem. The same installation process was followed for 32-bit installations on XP machines. These workstations had no problem, and showed no path problems in jvm.config or other files. Cheers, Kris On Thu, Apr 15, 2010 at 11:28 AM, Kris Jones wrote: We'll be running on Windows Server 2008 in production (and dev stage environments). But we do need to get this issue resolved for our developers local machines as well. On Thu, Apr 15, 2010 at 11:22 AM, Dave Watts wrote: Incidentally, CF9 32-bit has been running flawlessly, but we want to be running 64-bit in production so need to have this resolved. But you're not going to be using Windows 7 in production, right? Could you try running it in a VM with your production OS (Windows Server 2008?) I realize that's kind of a pain, but we've been running CF 9 64-bit on Windows Server 2008 with no problems. ~| 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:332967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 64-bit fails requiring reinstall
Anyone having this problem? We've got 2 developers on Windows 7, with CF9 64-bit installed (not multi-instance), who have each had CF server kack on them after a day of working in it. The service stops (sometimes in the middle of the night when no one is working). In one case this was after a Windows update ran. The system log shows: The ColdFusion 9 Application Server service terminated with service-specific error The system cannot find the file specified. (We suspect a rights issue on this?) The CF log suggests that jvm.config is corrupt. Incidentally, CF9 32-bit has been running flawlessly, but we want to be running 64-bit in production so need to have this resolved. Any and all suggestions are appreciated. Cheers, Kris ~| 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:332906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ReCaptcha service changes!
We also got this message. Verified that our DNS was routing correctly. Appreciate the note on CF caching the connection info. Guess we'll have to cycle the instances in that cluster... Cheers, Kris We're using cfReCaptcha and got the following message. Anyone else receive this email? I didn't get the e-mail, but error reporting on the server was sending me connection errors to reCAPTCHA for a few hours a few days ago. It corrected itself eventually though. ~| 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:332379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Preventing Link-Builders
Thanks for this Hugo. Taking a look at it. Do wonder if we'd end-up doing way more insertions into the system than positive resolutions though. Once I'm back in the office tomorrow, I'll do some checks on the addresses I've already inactivated. Cheers, Kris On Mon, Feb 15, 2010 at 4:54 AM, Hugo Ahlenius hugo.ahlen...@nordpil.comwrote: Kris Jones wrote on 2010-02-12: We've got a very busy legacy home-grown forum that since late August 2009 or so has been getting hit heavily by the Link-Building industry. Posting requires membership, which requires a captcha to be entered, and a confirmation email link to be clicked. Everyday, I search and invalidate hundreds of link-building memberships (the ones I can find). Interestingly, none of the links ever get posted -- we're using akismet, which does a pretty good job of stopping these. Kris - try http://www.stopforumspam.com/apis and look up the e-mail + ip in that database. And report any spammers that are not in that database already, to contribute to the anti-spam community! Cheers, Hugo -- Hugo Ahlenius - Hugo AhleniusE-Mail: hugo.ahlenius(at)nordpil.com Phone:+46 75 7575284 Nordpil Fax: +46 8 6747020 http://nordpil.com Mobile: +46 733 467111 Skype: callto:hugo.ahlenius vCard:http://nordpil.com/hugoahlenius.vcf - ~| 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:330744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Preventing Link-Builders
Sorry, this is a bit OT, but we're using CF for the site, so thought I'd see what other CF folks are doing about it. We've got a very busy legacy home-grown forum that since late August 2009 or so has been getting hit heavily by the Link-Building industry. Posting requires membership, which requires a captcha to be entered, and a confirmation email link to be clicked. Everyday, I search and invalidate hundreds of link-building memberships (the ones I can find). Interestingly, none of the links ever get posted -- we're using akismet, which does a pretty good job of stopping these. But, time is money, and hunting these suckers down (not to mention the ones I don't find out of oh, 700+ new memberships a day), plus just their presence in our database (more records == more processing time) is not a good thing. What are folks doing about this kind of abuse? And, can someone educate me on why the link-builders keep creating accounts when it's obvious their posts aren't getting published? I can tell from the data I'm seeing that it's the same people/scripts day after day. I'm at a loss. -KJ ~| 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:330649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Preventing Link-Builders
Yeah, this is what is so astounding. Most of the emails are yahoo.comaddresses, but we're seeing an increase in gmail.com addresses as well. And we do require unique email address for membership. Figure it has to be manual to some extent. Cheers, Kris On Fri, Feb 12, 2010 at 11:33 AM, Phillip Vector vec...@mostdeadlygame.comwrote: So... Let me make sure I understand. They pass the Captcha and they also click the link in the email? That's some serious scripting. The reCaptcha stopped all spam to my site. If they are clicking on the email links as well, that's pretty advanced.. On Fri, Feb 12, 2010 at 8:27 AM, Kris Jones kris.jon...@verizon.net wrote: Sorry, this is a bit OT, but we're using CF for the site, so thought I'd see what other CF folks are doing about it. We've got a very busy legacy home-grown forum that since late August 2009 or so has been getting hit heavily by the Link-Building industry. Posting requires membership, which requires a captcha to be entered, and a confirmation email link to be clicked. Everyday, I search and invalidate hundreds of link-building memberships (the ones I can find). Interestingly, none of the links ever get posted -- we're using akismet, which does a pretty good job of stopping these. But, time is money, and hunting these suckers down (not to mention the ones I don't find out of oh, 700+ new memberships a day), plus just their presence in our database (more records == more processing time) is not a good thing. What are folks doing about this kind of abuse? And, can someone educate me on why the link-builders keep creating accounts when it's obvious their posts aren't getting published? I can tell from the data I'm seeing that it's the same people/scripts day after day. I'm at a loss. -KJ ~| 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:330651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Preventing Link-Builders
By Link-Builders, spam, call it what you will. I mean stuff like (and I can only hope this post doesn't get halted by HOF) chiropractic ads, weight reducing, timeshare investments, cooking dvds, sports equipment, food preparation equipment, you name it. I will start taking a look at the logs more carefully. It will required a concerted effort -- the site is very busy. Cheers, Kris On Fri, Feb 12, 2010 at 11:54 AM, Mike Chabot mcha...@gmail.com wrote: Look in your Web server logs to see exactly what path someone takes in order to do those posts. First verify that they are going through your security mechanism, instead of bypassing it entirely. It could be that your site has a security vulnerability that is being exploited. You might also be able to determine whether it is a robot or a human by analyzing the logs. If it is the same people every day, you could ban them based on their IP address. You should also distinguish between the SEO industry and spammers. My guess is that these are spammers, which isn't the same industry as SEO. When you say link builder do you mean spam ads, or do you mean something else? -Mike Chabot On Fri, Feb 12, 2010 at 11:33 AM, Phillip Vector vec...@mostdeadlygame.com wrote: So... Let me make sure I understand. They pass the Captcha and they also click the link in the email? That's some serious scripting. The reCaptcha stopped all spam to my site. If they are clicking on the email links as well, that's pretty advanced.. On Fri, Feb 12, 2010 at 8:27 AM, Kris Jones kris.jon...@verizon.net wrote: Sorry, this is a bit OT, but we're using CF for the site, so thought I'd see what other CF folks are doing about it. We've got a very busy legacy home-grown forum that since late August 2009 or so has been getting hit heavily by the Link-Building industry. Posting requires membership, which requires a captcha to be entered, and a confirmation email link to be clicked. Everyday, I search and invalidate hundreds of link-building memberships (the ones I can find). Interestingly, none of the links ever get posted -- we're using akismet, which does a pretty good job of stopping these. But, time is money, and hunting these suckers down (not to mention the ones I don't find out of oh, 700+ new memberships a day), plus just their presence in our database (more records == more processing time) is not a good thing. What are folks doing about this kind of abuse? And, can someone educate me on why the link-builders keep creating accounts when it's obvious their posts aren't getting published? I can tell from the data I'm seeing that it's the same people/scripts day after day. I'm at a loss. -KJ ~| 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:330656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Preventing Link-Builders
Not even suggesting it can't be done. Of course it can be done, and with fairly basic skills. However, I can tell, from at least 2 of the most egregious offenders, that they are getting links inserted (with success) on other sites. So it's not just our site. And yeah, many of the IPs (that aren't spoofed) are eastern european in origin, or resolve to the Philippines. Would still like to stop this in it's tracks. Thoughts? Cheers, Kris On Fri, Feb 12, 2010 at 11:39 AM, Peter Boughton bought...@gmail.comwrote: If they are clicking on the email links as well, that's pretty advanced.. No its not. It's simple. A small challenge for a general purpose one, but trivial if you're targeting a specific site/application. If you know how to use cfpop, rematch and cfhttp, you can throw an email validation link clicker together in mere minutes. For beating captchas, it depends on how complex they are: a lot of them can be beaten by OCR, and the rest can be beaten by cheap labour in eastern europe/russian/etc. ~| 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:330658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Preventing Link-Builders
We're using akismet now, which IS stopping the actual spam / link post from getting entered. I'm extremely dubious about IP-blocking, particularly given that most of the offenders change IPs frequently, or spoof IPs. We also have seen bad accounts come through with IPs that are generic comcast, cox, verizon IP ranges. We don't want to be IP-banning willy-nilly. But I like the idea of checking for mouse movement and keyboard entry, along with hidden field for culling out automated membership accounts. Maybe it'll help. Cheers, Kris On Fri, Feb 12, 2010 at 12:13 PM, Chad Gray cg...@careyweb.com wrote: I donât think you mentioned using CFFormProtect, but it is another layer that I have used. http://cfformprotect.riaforge.org/ -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Friday, February 12, 2010 12:08 PM To: cf-talk Subject: Re: SOT: Preventing Link-Builders Not even suggesting it can't be done. Of course it can be done, and with fairly basic skills. However, I can tell, from at least 2 of the most egregious offenders, that they are getting links inserted (with success) on other sites. So it's not just our site. And yeah, many of the IPs (that aren't spoofed) are eastern european in origin, or resolve to the Philippines. Would still like to stop this in it's tracks. Thoughts? Cheers, Kris ~| 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:330660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Email blast product to replace iMS
Our server is still running, but the product has a memory leak that generally requires post service restart about once every day or two. We send out over 100-200k emails a day (all are opt-in). Cheers, Kris On Wed, Jan 27, 2010 at 8:21 PM, Brook Davies cft...@logiforms.com wrote: Hi Kris, I am in the same boat. Coolfusion/infusion seems to have just disappeared. Its too bad cause I love there mailserver. I wish they would release it open source or sell the company/product or something. They seem to have just gone out of business (but the website is still up), without so much as a whisper... Are your IMS mail servers still running/working? Brook -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: January-25-10 12:24 PM To: cf-talk Subject: Email blast product to replace iMS What are folks using for blasting hundreds of thousands of emails a day? We've been using iMS, but the product needs attention and the company/support is unreachable (website is nonfunctional). We need to be able to integrate w/ ColdFusion. Speed is an essential requirement. Cheers, Kris ~| 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:330226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Email blast product to replace iMS
What are folks using for blasting hundreds of thousands of emails a day? We've been using iMS, but the product needs attention and the company/support is unreachable (website is nonfunctional). We need to be able to integrate w/ ColdFusion. Speed is an essential requirement. Cheers, Kris ~| 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:330126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Row/Table Locks and SQL Server
Does your procedure specify rowlocks, nolocks, etc? Without that you may be at the mercy of the client (or driver in this case) Cheers, Kris Following the bulk insert of a fairly complex xml document, I run a stored procedure which parses through the document passing the values into relational tables. This part is all done in SQL, inside the stored procedure. Platform: Windows Server 2008 64bit SQL Server 2008 Coldfusion 8 If I do this from the query analyzer, it executes instantly, parses the document happily and moves on, with row locks on the database never more than 50 or so: exec myProcedure @id=somevalue, blah other variables However, if I call the following code in coldfusion, I end up with potentially _thousands_ of row locks on the table, and the database becomes unusable within seconds: cfstoredproc procedure=myProcedure datasource=#application.maindsn# cfprocparam type=in value=#somevalue# cfsqltype=cf_SQL_INTEGER ... blah blah other parameters /cfstoredproc That wasn't working out, so I tried this instead, so that I had isolated the _exact_ same code as from query analyzer: cfquery datasource=#application.maindsn# exec myProcedure @id=somevalue, blah other variables /cfquery The result this way is even worse. This leads me to think there may be some extra locking being forced by the jdbc driver, or I'm just doing something really wrong. I am not wrapping this in cftransaction at this point. Has anyone encountered anything like this? ~| 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:328284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfprocparam - null setting
The former: It ignores anything passed to it, and sets the value to null. Note, however, that whatever you are passing to the procparam must still validate; e.g., a variable in the value attribute must exist: cfprocparam value=#mygreatvariable# null=#not isdefined('mygreatvariable)# Will throw a CF error. Cheers, Kris I have a question about cfprocparam. If I use the nulll option, does it ignore anything passed to it and set the value to null or Does it set a null value when nothing is passed to it. I have a stored procedure that chokes on an integer value when either zero or an empty string is passed. My other option is to pass an exec statement through cfquery and try to use the settable null parameter or cfquery param. ~| 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:327236 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 8.01 Server Error IO server on server communication
This problem is not just an RDS issue. I've seen this on new installs of CF8, with RDS enabled, and cannot get the browse to work. Simply typing the path to the item works (in my case this was a DSN setup thing). Suspect this may be related to JVM version. For instance, on my localhost @ work, 1.6.0_04 it works fine. At home, 1.6.0_13 (I think), it does not work. Cheers, Kris This error is related to RDS not being enabled on server, apparently can't browse without RDS. Question answered. Thanks I'm encountered this problem when click on the browse buttom, how can I fix this problem? ~| 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:326645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Deadlock with Multi-Server CF Config?
It's less a CF issue, and more about a traffic and simultaneous reads/writes. Make good use of WITH NOLOCK on database reads where you can. It's not always a single record that is locking. Depending on how your tables are indexed and a variety of other factors, a page (SQL page) could be locked, or the whole table could be locked -- just for a read. Also, the users shouldn't be seeing that error at all, right? (site-wide error handler...) Cheers, Kris This is less about getting a specific answer and more about just finding out how to diagnose the problem. Client has an ColdFusion application in a multi-server instance behind a hardware load balancer. The ColdFusion server are on separate machines but talk to the same MS-SQL db. Within the last few days users have started to see ColdFusion errors saying that: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 102) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Any clues what this might be in regards to? How do I go about trying to track this down? And does this have anything to do with the multi-server setup or is it just a more vanilla problem with an update occurring slowly with the server? ~| 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:326542 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: DSN across VPN with virtual IP
Mark, Thanks for the suggestions. I had just emailed them last night about the other 2 services, and am prepping a test file to check on reading/writing just as you suggest. Glad to see I'm thinking down the right path on this one. I'll also send the suggestion on the hosts file entry. Never would have thought of it. Thanks much. Cheers, Kris I would take the time to create a test script and try to access ANY file on the share (like a text file). You must use the unc path formatted correctly (\\servername\sharename\path\filename.mbd). One other thing that is often forgotten is that the ODBC system in MX is a separate service. CF actually interfaces with the ColdFusion 8 ODBC Server service and the ColdFusion 8 ODBC Agent service. Each of these will need to be running as a registered user as well. Networking is even more tricky. I usually add a HOSTS file entry for the servername that points to the VPN IP address (routing can be tricky). Otherwise it may not be able to resolve the server name or it may resolve it using some other means and give you the real instead of the vpn address. Keep in mind that this VPN connection must be available to all users and not just a connection dialed by a user (i.e. logging in and connecting) - it needs to be running at a lower level than the desktop and stay connected. To test from the CF user context you can use cfexecute to ping the IP. If it doesn't resolve that is likely your issue. ~| 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:326449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help: DSN across VPN with virtual IP
Hi all, I'm trying to help a client work out an interim fix for a security issue. They need to move the administrative interface for some CF applications off of their public-facing website. The applications store some sensitive data that require there be no public interface available. The interim solution is to move the administrative interfaces onto a web-server inside their firewall, create a VPN from this box to the external public-facing web-server, and connect to the databases using the VPN tunnel. The databases in question are SQL Server or Access. They've got the VPN functional (using virtual IP configuration), and have mapped a drive through to the directory where the Access DBs reside. Unfortunately, they're getting an error trying to create the DSN on the internal ws. The servers are Windows servers. Using either the drive-letter of the mapped path, or a UNC addressing scheme, the error received is: Connection verification failed for data source:[datasourcename] java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. They also tried using the Access Unicode driver, and get a slightly different error, but essentially the same: Connection verification failed for data source:[datasourcename] com.inzoom.adojni.ComException: Not a valid file name. The root cause was that: com.inzoom.adojni.ComException: Not a valid file name. in Microsoft JET Database Engine code=0 Type=1 They have checked the user the CF services are running under, have logged in as that user and verified that it has access to the share and the files therein. Also, CF can successfully create Access DSNs on the local server without problem. Any suggestions would be most appreciated. Cheers, Kris ~| 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:326446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Encrypt/Decrypt error
If the form.password contains characters that the encryption seed will cause to result in a string that contains a space or plus-sign, you will have trouble with the CFMX_COMPAT mode. Suggest going with a different mode. Cheers, Kris I'm on CF7. Here's my code: (in Application.cfc) cfset request.seed = wPznEZnrpWToMHNR8HcDQ== cfset request.algorithm = CFMX_COMPAT cfset request.encoding = UU (encrypt) encrypt(FORM.password,request.seed,request.algorithm,request.encoding) (decrypt) decrypt(FORM.password,request.seed,request.algorithm,request.encoding) This is my error: There has been an error while trying to encrypt or decrypt your input string: The input and output encodings are not same. ~| 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:325015 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 CF8 vulnerability
Is it only me, or does this patch solution look pretty bad? merge the cfide folder Ack! Cheers, Kris A hotfix was just released for this: http://www.adobe.com/support/security/bulletins/apsb09-09.html ~| 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:324354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Special Characters (�) Showing Up
It's a character out of range for the encoding you're using on the page. Note, that you need to do more than just specify the encoding. You also need to actually write the document with that encoding. Here are a couple of links that have been helpful to me in the past. Ben Nadel blogged about cleaning high-ascii values. I found some comments on this article particularly enlightening -- see eric: http://www.bennadel.com/blog/1155-Cleaning-High-Ascii-Values-For-Web-Safeness-In-ColdFusion.htm From the W3C: http://www.w3.org/International/O-charset http://www.w3.org/International/tutorials/tutorial-char-enc/#Slide0270 Check the settings in your code editor to make sure you are saving your files with the correct charset. If you are writing your pages from CF to a static page, don't forget to use the CFFILE charset attribute. This was the issue that bit me. Cheers, Kris Does anyone know why these special characters would be showing up in output (�)?  If you can't see it, it looks like a black diamond with a question mark at its center.  The same character is even in the browser source.  But, no such character is in our code. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scheduler Log reports Interrupt Task and job stops running
It's been a long time since I've seen that, but I believe the 1899 timestamps are interpretation of a NULL timestamp by CF (from SQL Server data). Cheers, Kris I have no idea where those 1899 timestamps are coming from. We have a scheduled task that is fairly critical (it helps generate significant revenue for our company), so we get alerts if it hasn't run within a certain time frame. However, we had the job stop yesterday and the scheduler log reports: Interrupt task job name scheduled at {ts '2009-04-09 00:00:00'} {ts '1899-12-30 00:00:00'} null {ts '1899-12-30 23:59:00'} [where I replaced the job name -- those 1899 time stamps are actually in the log]. I haven't been able to find a reference to this, either on the web or on Adobe's site. Has anyone encountered this issue before (or know what it means)? This process is running on ColdFusion 8 Enterprise on IIS (Windows 200 ~| 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:322988 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 Date format question
Using cfsqltype=cf_sql_timestamp will definitely solve that problem. I expect you're just trying to give an example, but if all you're trying to do is move values from one table to another, you can do this en-mass with SQL: cfquery name=putdate datasource=whatever insert into table2(date_field2) select date_field1 from table1 /cfquery Cheers, Kris I have an issue inserting date and time together into a database table from coldfusion. Right now, I am using cfquery to get records from a particular table, in which one of the field is date, and its value in the database is something like 2/14/2007 9:10:12 AM. I am performing insert operation into another table which has to insert this date field into the column of new table. I am doing currently as follow: cfquery name=getDate datasource= maxrows=1 select date_field from table /cfquery cfif getDate.recordcount is not 0 cfquery name=insertDate datasource= insert into table2 (date_field1) values (cfqueryparam cfsqltype=cf_sql_date value=#getDate.date_field#) /cfquery /cfif The problem with this is only the date is getting inserted but not the time. How to format ~| 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:322384 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Page Encoding inside CFC?
Thanks much -- this is exactly what I needed. I don't know why, but I had only tried putting it above the cfcomponent tag. Cheers, Kris We are using encoding declarations in cfcs just after cfcomponent tag and everything works fine: cfcomponent output=no cfprocessingdirective pageencoding=utf-8 cfset setEncoding(URL, utf-8) cfset setEncoding(Form, utf-8) Bilgehan I've got a function that replaces accented characters with english-type characters -- this is for file naming and such. It works fine until I put the function in a component. On a plain ole .cfm page, it works great as long as the cfprocessingdirective for pageencoding=utf-8. Without the directive, it works fine on text typed directly into the template, but text returned from a database call is not replaced correctly. In the .cfc, I'm unsure how to force the encoding. I'm running CF7. Any advice is greatly appreciated. ~| 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:321213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Page Encoding inside CFC?
I've got a function that replaces accented characters with english-type characters -- this is for file naming and such. It works fine until I put the function in a component. On a plain ole .cfm page, it works great as long as the cfprocessingdirective for pageencoding=utf-8. Without the directive, it works fine on text typed directly into the template, but text returned from a database call is not replaced correctly. In the .cfc, I'm unsure how to force the encoding. I'm running CF7. Any advice is greatly appreciated. Cheers, Kris ~| 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:321199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yet another web services question
Whenever I've had to call a .NET web-service, where any of the arguments are complex, I've always had to construct the SOAP envelope manually. In the end, this took less time than trying to call it directly -- and failing, and failing, and failing. Cheers, Kris This isn't my web service: it's a third-party thing that was implemented in .NET. I haven't seen the source, but I strongly suspect that it's declared as taking an XmlNode for that third parameter. (Like the proxy method that .NET generates.) Worse comes to worst, I suppose I can build the (very simple) SOAP envelope myself, and use CFHTTP, but I *really* don't want to do that if I can avoid it. ~| 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:320474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Infusion mail server from Coolfusion
We're running iMS, and are not experiencing any problems. Their site appears to be up. http://www.coolfusion.com/products/ims/ -KJ The Infusion mail server from Coolfusion uses a phone home license enforcement scheme - which is now a problem since their authentication server has gone 404 (as the whole company seems to be doing). Being unaware of that problem, we attempted to move Infusion to a new server (which required uninstalling it on the old server). Now we can't get it to install and authorize on either the new or old server. We have some code that is specifically dependent on the Infusion server. Does anyone know of a workaround to keep this server alive until we can code an alternative using another ser ~| 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:320406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Infusion mail server from Coolfusion
You might want to try this: http://www.coolfusion.com/support/ Take a look at their Moving A Software License Between Machines form. -KJ ~| 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:320407 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 give...anything inherently wrong with this code that would cause this error?
This validates by calling the cfc directly. Haven't actually called the function, but I think this would work: cfcomponent cffunction name=fnProcessForm displayname=fnProcessForm hint=Processes Submitted Form output=false access=remote returnType=struct cfargument name = dsn type = string required = yes cfset var valueStruct = structNew() cfset valueStruct.key1 = somevalue / cfset valueStruct.key2 = someothervalue / cfreturn valueStruct / /cffunction /cfcomponent Take a look at: the array references you have in there -- cfset arrFiles_200 = [] / doesn't look okay to me. Also, check the way you are calling the function. THat may actually be the issue. Cheers, Kris ~| 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:320186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Max Simultaneous Requests - in a vertical cluster
Thanks Barney Wil. Our application performs under extreme load 24/7. Interacts with a database that is highly volatile (lots of inserts), with tables/views containing millions of rows. Currently, the instances are set to the default of 25 (2 of the stacks are set to 28 per instance). I don't know how/when these values were determined, but we're looking at it now, and want to understand how changing these _could_ affect performance, either negatively or positively. Cheers, Kris Exactly what Barney said. It's app and hardware specific. On our servers we run one CF8 instance per server and we're set to handle up to 100 simultaneous requests. Once in a while we hit that limit. That's a starting point, and needs to be tuned for your specific application, so it's kind of irrelevant how good of an estimate it is. I'd say each instance gets (4 * CPUs / instances) to start with, and then do your tuning from there. And make sure if your instances are sharing hardware resources that you're loading all the instances that share the hardware when you test or you'll skew your results. That last app I tuned like this we settled on 20 concurrent requests. We ran one instance per physical machine, and each machine had a single CPU. About 6 month later we updated the application, retuned, and optimized to 8 concurrent requests. Then we started doing secure media delivery and jacked it way up to 50 concurrent requests. So it's REALLY application specific. I've read in various places that the recommended starting point for determining the Max Simultaneous Requests (MSR) value is 3-4 per CPU. But I'm not seeing how this works in a vertical cluster. Say I have a box with 4 CPUs, and 4 instances on that box. How would that suss- out? Do you set each instance to use only it's share of the MSR, or a full MSR? What about a box where the CPUs don't evenly match the number of instances? 4 CPUs, 3 instances, as an example. Does this m ~| 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:320140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Max Simultaneous Requests - in a vertical cluster
I've read in various places that the recommended starting point for determining the Max Simultaneous Requests (MSR) value is 3-4 per CPU. But I'm not seeing how this works in a vertical cluster. Say I have a box with 4 CPUs, and 4 instances on that box. How would that suss-out? Do you set each instance to use only it's share of the MSR, or a full MSR? What about a box where the CPUs don't evenly match the number of instances? 4 CPUs, 3 instances, as an example. Does this matter? Cheers, Kris ~| 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:320119 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) Setting IIS 6 Content-Type HTTP header
cfcontent type=text/html; charset=[whatever charset you want] / FYI: the above must appear in the first 1024 bytes of the response. Cheers, Kris From: Dave Watts: CF sets the content type for documents generated by CF. Otherwise, IIS sets the content type. Ok, that's the impression that I got. Where can it be set? cfcontent type=text/html; charset=iso-8859-1 / ~| 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:319191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Issues encountered while migrating of coldfusion code from CF7 to CF8
Yes, there are. You should check the change notes on Adobe. And, from my experience, specifically, there are problems with dbvarname attribute in cfstoredproc calls. If you are using dbvarname, it must be included on all cfprocparam arguments to the cfstoredproc call. AND, the value must exactly match the actual procedure parameter name accurately. The real pisser on this is that dbvarname does not work. They pulled it from the release at the last minute. Unfortunately, the error-handling for it did not get pulled. When we migrated, we simply removed dbvarname from all of our cfstoredproc calls. There are also a couple of functions that must not have a function call as its first parameter. Can't remember exactly what function they were, but it was listed in the known-issues change notes found on Adobe's website. Cheers, Kris Are there any specific concerns related to the CF CODE while migrating from CF7 to CF8. ~| 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:318681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Character encoding problem
We recently experienced problems along these lines (not having to do with jQuery, but getting the charset to stick). Notes to our team are for UTF-8, but I suppose you could choose whatever character encoding you need. I also found excellent information on a blog post by Ben Nadel (link below) -- particularly discussion in the comments. The charset must be specified in the documents header. Also the document itself must be written in the same encoding. Having both of these things specified correctly allows the user's browser to automatically determine the character set to use when displaying a page. The document itself must have the character set specified. For HTML: meta http-equiv=Content-Type content=text/html;charset=utf-8 For XML: ?xml version=1.0 encoding=UTF-8 ? must be the very first thing in the file. That means no whitespace before it, including CR, LF, or BOM. The document must be written in UTF-8: In ColdFusion, you must include cfprocessingdirective pageencoding=utf-8 in the first 1024 bytes of each template; will cause CF and all of CF's string functions to correctly handle high-ascii characters. Further, if you are writing the file using the ColdFusion tag CFFILE, make sure you specify the encoding with the attribute charset=utf-8. If you are writing the file using Dreamweaver or some other text-editor, make sure the editor is writing the file as UTF-8. Helpful Links Ben Nadel's function for cleaning high-ascii characters. Most interesting is discussion in the comments of this blog post, particularly posts from Eric: http://www.bennadel.com/blog/1155-Cleaning-High-Ascii-Values-For-Web-Safeness-In-ColdFusion.htm W3C: http://www.w3.org/International/O-charset http://www.w3.org/International/tutorials/tutorial-char-enc/#Slide0270 it won't matter on cf5 The problem is when using Javascript files with text encoded in iso-8859 in it. If they are included in UTF-8 HTML, they become uncompatible. If one need to keep an application compatible for both CF 5 and CFMX, better stick with ISO. ~| 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:318316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error CFUPDATE using formfields parameter
Would probably help if you could post some abbreviated code. Make sure the attribute is set as formfields (note it's plural). If the attribute is formfield (singular), it will be ignored, and will attempt to update with whatever it finds in the form collection. Note that the table's primary key must be included in the formfields list, and must be passed in the form collection (it can be hidden). Cheers, Kris Error CFUPDATE using formfields parameter. I have a CFM page for sending a form with 7 input type fields. The action page update a table with 3 columns by CFUPDATE. CFMX 8.0.1 send me next error: The NAMEORG fieldname cannot be found in the ait table The form field NAMEORG is in the FORM, but it is not in the table, nor in CFUPDATE formfield parameter. Sorry, let me clarify, the fieldname NAMEORG is not part of the database, i sent by submit in FORM for other operations, but CFUPDATE is trying to use it as a formfield parameter ~| 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:318106 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 upgrade question
As for your datasource connections, take an archive in CFAdministrator prior to uninstalling CF7. You can then reimport this after CF8 is installed. You could probably install CF8 from the full developer edition installer available at Adobe, then enter your license keys? Not sure if it will require/accept the multiple license keys you'd have though -- your CF7 key, and the CF8 upgrade key. Probably someone here has direct experience with this. Having trouble getting to houseoffusion.com to look at specific archives, so have quick and specific question if I could trouble y'all: Purchased upgrade from ColdFusion 7 to 8, Standard Edition - XP Pro IIS web server. Is it possible/advisable to uninstall 7 and then do clean, full install of 8 from upgrade disk? Understand that datasource connections, etc., will need to be re-done. ~| 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:317875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CGI.Server_Name -- showing as IP of client?
I never saw Bobby's response quoted below, but yes, I'm sure the app is NOT running at the IP that's coming through in the cgi.server_name variable. Attempting to access those IPs in the browser fails (server not found or server 500 errors, depends on the IP). I'm not really trying to get the server_name from the cgi structure. I know which servers our application is running on. My question has to do with whether I can simply presume these requests are hack/spam attempts, or whether there are legitimate situations where this would happen, e.g., cgi.server_name == cgi.remote_addr Interestingly, I just came upon this post from Ray Camden, which shows just how ridiculously trivial it is to spoof cgi.server_name: http://www.coldfusionjedi.com/index.cfm/2008/6/5/Use-cgiservername-Be-careful Cheers, Kris Write the error message in order to know more about it. You can get the server name using several CGIs variables: CGI.SERVER_NAME=iswebmx.lv.cfemex.com CGI.HTTP_HOST=iswebmx.lv.cfemex.com CGI.HTTP_REFERER=http://iswebmx.lv.cfemex.com/ you can use list function in order to pick server name from http_referer too. if you enable debuggin monitore in your ColdFusion Administrator to your IP you will see all this information in CFMs you invoke i hope it helps you... greetings Is it possible that your app is indeed running on the server at that IP address? Have you tried to access the IP in a browser? .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com I know the cgi structure can be spoofed, and admit to my ignorance as far as that goes. We've been getting some error messages showing cgi.Server_Name fulfilled with the caller's IP address. So here is my question: How would this happen? In what cases does the CGI.server_name variable get fulfilled with something other than the server_name (either IP or domain) CF is running on? Is this a browser-specific thing? Or is it really only an indication of a hack attempt? ~| 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:317735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: anybody see this before?
isthere would be a variable reference to a query object with that name. recordcount is an attribute of a query object. isthere.recordcount would evaluate to a numeric of 0 or greater. If 0, it would evaluate in a boolean to false. Otherwise it would evaluate as true. No mystery here. Or am I just missing something? On Fri, Jan 9, 2009 at 2:48 PM, mark m...@mdprofinish.com wrote: Working with some old code and found this.can't seem to find a reference via adobe.com or google or books. Is it old or am I just missing something. It does work. cfif isthere.recordcount Seems a clean way to check.does anyone use this? Mark ~| 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:317664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CGI.Server_Name -- showing as IP of client?
I know the cgi structure can be spoofed, and admit to my ignorance as far as that goes. We've been getting some error messages showing cgi.Server_Name fulfilled with the caller's IP address. So here is my question: How would this happen? In what cases does the CGI.server_name variable get fulfilled with something other than the server_name (either IP or domain) CF is running on? Is this a browser-specific thing? Or is it really only an indication of a hack attempt? Thanks, Kris ~| 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:317535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Official ColdFusion IDE announced
When people ask me about changing over to CFEclipse, I say, You'll love it and never want to use [insert other IDE name here] again. But you'll hate it for at first -- probably about a week. I agree that it takes a commitment to using it -- I forced myself to not use another editor for a week. I'm so glad I did. I love CFEclipse. -KJ Personally, I too was daunted by Eclipse at first glance. I loaded it up, got the intro screen, and thought to myself: Okay what now? It was unfamiliar, and I didn't know how to use it at all, let alone productively or, god forbid, comfortably. It took me roughly a week to figure out how to use it productively (get CFEclipse installed, find out how to edit my files, etc), and quite a while after that to get to the point of being comfortable with it. It's price and it's platform independence were major driving factors for me, and kept me motivated to learn how to use it. If you don't have those or other motivators, I can see why some folks don't get past the point of the confusing interface. ~| 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:315712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFHTTP call in CFC, returning content fails
I've got a function in a cfc, that is doing a soap request via CFHTTP. I've enabled output on the function, and can dump the CFHTTP.filecontent successfully after the cfhttp call. I then return that result from the function. However, in the calling cfm template, the return variable on the function is coming up not defined. So, I see the dump from inside the function, then an error that Variable XXX is undefined. Been fooling around with this for too long. Have tried moving logic from function into CFM page, and I'm having different issues with the results -- like being unable to do any xmlsearch calls on the results at all, although I can reference individual node values with dot notation. Anybody got an idea what I'm missing here? I'm using similar structure on other calls, and can't see the problem. Thanks, Kris --- CFM template has: cfinvoke component=#oComp# method=myfunc returvariable=xxx cfinvokeargument name=arga value=somevalue / cfinvokeargument name=argb value=someothervalue / /cfinvoke cfdump var=#xxx#cfabort / CFC Function looks something like: cffunction name=myfunc access=public returntype=any output=true cfargument name=arga type=string required=yes cfargument name=argb type=string required=yes cfset var myresult = / cfset var mypacket = / cfsavecontent variable=nfws_soappacket cfoutput .[soap description here] /cfoutput /cfsavecontent cfhttp url=someaddress method=POST param param /cfhttp cfset myresult = xmlParse(cfhttp.FileContent) / cfdump var=#myresult# / cfreturn myresult / /cffunction --- ~| 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:312128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP call in CFC, returning content fails
Sorry, the function contents had stupid typo (I never have been good at obscuring/genericizing my actual code before posting). Here is what I meant to write: --- CFM template has: cfinvoke component=#oComp# method=myfunc returvariable=xxx cfinvokeargument name=arga value=somevalue / cfinvokeargument name=argb value=someothervalue / /cfinvoke cfdump var=#xxx#cfabort / CFC Function looks something like: cffunction name=myfunc access=public returntype=any output=true cfargument name=arga type=string required=yes cfargument name=argb type=string required=yes cfset var myresult = / cfset var mypacket = / cfsavecontent variable=mypacket cfoutput .[soap description here] /cfoutput /cfsavecontent cfhttp url=someaddress method=POST param param /cfhttp cfset myresult = xmlParse(cfhttp.FileContent) / cfdump var=#myresult# / cfreturn myresult / /cffunction --- ~| 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:312129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maybe OT: Content Disappears when .cfm call, shows when .html
I've had that same experience attempting xmlParse -- the trim was absolutely necessary. This was just a plain 'ol XHMTL document. Not strict XML. I believe according to the standard, XML isn't allowed to have any white space before the doctype. This is the first I'd heard of a browser refusing to render it though. Actually IIRC, the XML standard does not care about white space, nothing else is allowed before the doctype, but whitespace is ok. I.E. on the other hand has a different opinion. Well that's what I'd remembered reading... and at the time I was trying to figure out why a particular XmlParse(variable) wasn't working... turned out XmlParse(trim(variable)) was the fix, because the parser was choking on white space before the document root element (there wasn't a doc type in that particular packet). And since then I've always been sure to trim() before using XmlParse because of that. This is the first time I can recal anyone disagreeing about the white space, although I would personally have loved for the standard to insist that the parser be able to handle white space there. ~| 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:311975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Maybe OT: Content Disappears when .cfm call, shows when .html
This doesn't make any sense to me at all, so toss it out to the list. We've got a site in development, that is giving us fits. A specific page, when viewed in Safari (mac and win), will not show div contents of a specific class when surfed to as a .cfm file. If you view source the content is there. Save source as an .html file and surf to that, the content shows fine. The page behaves perfectly in FF2 (mac, win), IE7, IE6, Opera 9.27 (win). The html/css validates fine, and the page renders in standards compliant mode. Of note: tons of whitespace prior to the doctype declaration (we're all used to seeing this in CF-generated content, I imagine). Thoughts? Suggestions? Cheers, Kris ~| 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:311926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maybe OT: Content Disappears when .cfm call, shows when .html
Yup. Happening for more than one developer too. We've got a site in development, that is giving us fits. A specific page, when viewed in Safari (mac and win), will not show div contents of a specific class when surfed to as a .cfm file. If you view source the content is there. Save source as an .html file and surf to that, the content shows fine. Have you flushed your browser cache? ~| 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:311930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maybe OT: Content Disappears when .cfm call, shows when .html
OMG. This fixes it. What's that all about anyway? Put a cfcontent reset=true right before the doctype on the same line and see what happens. ~| 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:311932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maybe OT: Content Disappears when .cfm call, shows when .html
Funny, in this instance, IE played nice. Just Safari gave us a problem. I've seen other cases where Safari is a bit more sensitive to character-encoding type of things, but don't know that this was the issue this time. I'm guessing that there was something other than true white-space in that thar white-space, but at this point, it's fixed. Thanks everyone for the help Cheers, Kris Actually IIRC, the XML standard does not care about white space, nothing else is allowed before the doctype, but whitespace is ok. I.E. on the other hand has a different opinion. ~| 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:311949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP! SQL Injection Attack!
We handled this attack last month (it never did get through), and starting Tuesday night received about 20 thousands instances (not an exaggeration). Slowing down now for us, but, heh, it's early. ~| 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:310353 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! SQL Injection Attack!
I'd like to know how I can stop the requests from ever hitting the web-server. Can anyone point me at a resource for a firewall solution? I've seen some isapi filter solutions, but they all seem to just clean the querystring and then forward the request on -- so it's still hitting CF. I'd really like to stop it before we get to the web-server at all (let alone the CF application server). Cheers, Kris ~| 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:310356 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) URL Hack Attempt Leaves Me Scractching My Head
I have a client who reluctantly upgraded to CF5 from CF4.0 last year (yes, that would be 2007) because an sysadmin _accidentally_ upgraded, and they couldn't find the original 4.0 disks. While they'd like to upgrade to CF7 or CF8, the cost of migrating the many, many apps they have is cost prohibitive for them. So, there ya go. There are plenty of companies out there still running 4.0, and I'd guess, even earlier versions. Goodness sakes-- cfqueryparam has been around since ColdFusion 4.5.1. How far back does she need to support? :) ~| 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:309828 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) URL Hack Attempt Leaves Me Scractching My Head...
This attack has nothing to do with elevation of privilege. It simply tacks on a SQL procedure to a query existing on the page already. This procedure then runs through the tables/columns in the database appending text the end of content in varchar fields. The text appended varies, but what I've seen is a javascript file call, that would run when the affected content was displayed in a browser. I can't see how that security patch would have anything to do with it. (Please enlighten me if I'm wrong.) Can someone confirm that having applied the Microsoft patch(es) mentioned on http://www.microsoft.com/technet/security/bulletin/MS08-040.mspx is sufficient to protect against attacks like these? ~| 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:309437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
We're getting hit hard today with this. They're failing, because we use cfqueryparam and cfprocparam. But it is quite annoying. -KJ ~| 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:309351 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) URL Hack Attempt Leaves Me Scractching My Head...
It'll show in your logs of course. We also have error reports that dump the error info and certain collections and mail it to the dev team. -KJ We're getting hit hard today with this. /rss.cfm? Is is just rss.cfm? I haven't looked at our logs yet. Where did you see this. The server log files? ~| 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:309361 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) URL Hack Attempt Leaves Me Scractching My Head...
I can confirm that many templates in our site are being hit. And they are not commonly named. -KJ For me, all attempts are focusing on rss.cfm. Another post said they saw sitemap.cfm being hit. Can anyone confirm any other templates that are being hit? Perhaps only 'commonly named' templates are being hit? ~| 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:309393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
As a rule I use cfqueryparam. And generally try to stick to stored procedures, and use cfstoredproc/cfprocparam. However, I am now working with an app that uses cached queries regularly, and is still on CF7. You cannot use cfqueryparam with a cached query in CF7. What are the alternatives? -KJ Bottom line: ***always*** use cfqueryparam. Period. There are no acceptable exceptions to the rule. ~| 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:309414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Login failed for user 'sa'
The password changed? Check the DSN in CFAdmin... On Mon, Jul 14, 2008 at 11:50 AM, Orlini, Robert [EMAIL PROTECTED] wrote: Some of our CF programs are generating this SQL error. [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa' Any ideas pls? ~| 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:309071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SAS 70 Type II dedicated server hosting
I believe HostMySite.com is SAS70 compliant. Try them. Ok, I have a dedicated server through CFDynamics right now and the need to have a SAS 70 Type II certification at my host has come up. I have been trying to find out for a week now if they have that and my guess is that since they don't seem to know what I am talking about that they don't have it. So... Does anyone know of a good place to have a dedicated server hosted at? It would be running CF8, needs to also have a visual studio.net development environment, and will have access to a sql server. I saw hostmysite.com has that certification and they seem to have gotten good reviews. Anyone with any relevant experience in that area? ~| 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:308479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best CF editor?
This is an eclipse problem (not cfeclipse problem). I found that the incredibly ridiculous, unworkable slowness on files approaching 1000 lines (or more) happens when your cursor is next to an open or closed angle bracket . Simply typing a space after the will suddenly get the keypress response back up to a workable speed. Unfortunately, that hoses-up any tag insight you were hoping for. I sometimes need to go into CF files og 4000+ lines and when I do, Eclipse becomes sluggy to an extend that makes working almost impossible. ~| 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:306236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4