Re: Accessing Filezilla Server on a EC2 Windows 2008 Server
Did you make sure that the applied AWS Security Group allows for FTP? A Security Group acts like a firewall and it's separate from your Windows firewall. Regards, Stefan On 6 Jan 2011, at 00:28, Richard Steele wrote: I've successfully installed Filezilla server and it connects to our EC2 Windows 2008 Server 127.0.0.1. However, Our public ip address assigned by Amazon's elastic ip , works for the website, but not for ftp. I've added Filezilla to the Windows Firewall exception list. Not sure what else to try. Thanks in advance. ~| 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:340495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFC binding to multiple cfselects
Anyone have any idea on this Thanks ~| 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:340496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFHTTP ad DNS servers that do not return error status codes
there is nothing you can do about that as it is a feature of some DNS servers that they will redirect to a url if the domain does not exist or is disabled. You will need to do 2 tests. 1. test if the url returns a response 2. if yes then test if the url returns the expected response Russ On Thu, Jan 6, 2011 at 2:28 AM, Rob Barthle r...@barthle.com wrote: I'm running into a problem with CFHTTP. I like to use it on some projects to verify a URL before allowing it to be used. The problem I have is that on my local development environment, my DNS servers (Buckeye Express) don't return failure codes if an invalid URL is tested. My DNS instead forwards the request to a BEX web page that has a few ads and links and a search. Think of it like what openDNS does. Is there anything I can do to start getting validations working? If I have CFHTTP checking a site I want to know if I get anything other than a 200 OK return. I could just post the code to production, which is not on BEX servers and works like I want it to, but I really detest the idea of coding and unit testing in a production environment. ~| 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:340497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the best way to investigate a Jrun.exe spike?
if u have cf enterprise then you have a built in server monitor that you can use. You can also try www.fusion-reactor.com here are a number of article son the subject http://www.google.co.uk/search?q=jrun+performance+monitoringie=utf-8oe=utf-8aq=trls=org.mozilla:en-GB:officialclient=firefox-a Russ On Wed, Jan 5, 2011 at 11:34 PM, Dan Baughman dan.baugh...@gmail.comwrote: Use cfstart to run coldfusion command line, and then do stack dumps using ctrl-pausebreak when it spikes. There is an adobe tech note on how to do that. In addition to that, Process Monitor from Mark Russinovich is also very good ( and free). On Wed, Jan 5, 2011 at 4:31 PM, Philip Kaplan pkap...@gmail.com wrote: Occasionally Jrun spikes on my Windows CF9 box. This causes the server to die until I restart ColdFusion. The site receives moderate traffic..some spikes but nothing huge. Ancient question, but what's the best way to investigate this? Thanks ~| 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:340498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) passing URL parameters
Most probably a caching issue, the 404 page is cached in the browser or an intermediate proxy. -- Mack ~| 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:340499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
I don't think the SEO-unfriendliness of running everything through index.cfm has been an issue for a very long time. They used to have an issue with indexing query strings / dynamic URLs, but not any more. Maybe some of the smaller ones still do, but the major ones definitely do not. Really, if they did, Google wouldn't really even work. :) On Wed, Jan 5, 2011 at 11:09 AM, Russ Michaels r...@michaels.me.uk wrote: I can certainly see the advantage in NOT routing everything through index.cfm, it is more SEO friendly without having to use URL rewriting etc, plus I would expect the pages to be more editable. This is one annoying thing with frameworks in general, if you are not using a CMS then editing content can be a real pain as you can't just pop the page open in Dreamweaver and edit the layout as it won't display properly due to the missing formatting and CSS which is in another file. And congrats for coming up with a name that does not have cf cold fusion or fuse in the the name :-) Russ -- - Scott Brady http://www.scottbrady.net/ ~| 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:340500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 On Thu, Jan 6, 2011 at 6:39 AM, Scott Brady dsbr...@gmail.com wrote: I don't think the SEO-unfriendliness of running everything through index.cfm has been an issue for a very long time. They used to have an issue with indexing query strings / dynamic URLs, but not any more. Maybe some of the smaller ones still do, but the major ones definitely do not. Really, if they did, Google wouldn't really even work. :) On Wed, Jan 5, 2011 at 11:09 AM, Russ Michaels r...@michaels.me.uk wrote: I can certainly see the advantage in NOT routing everything through index.cfm, it is more SEO friendly without having to use URL rewriting etc, plus I would expect the pages to be more editable. This is one annoying thing with frameworks in general, if you are not using a CMS then editing content can be a real pain as you can't just pop the page open in Dreamweaver and edit the layout as it won't display properly due to the missing formatting and CSS which is in another file. And congrats for coming up with a name that does not have cf cold fusion or fuse in the the name :-) Russ -- - Scott Brady http://www.scottbrady.net/ ~| 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:340501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
AutoSave function?
Let me start by saying I have to do this using CFMX 7. (CFMX 8 and 9 is not
an option right now).
I have a form with MANY TEXTAREA elements. Once a user decides to update the
text within any of the fields,
I want to fire off an autosave type function for the single item.
So far it is working well in using JS and HTTP.OPEN request and the actual
TEXT is part of the URL scope.
ex: http.open('get','/autosave.cfm?id=1000comment=this is my comment that I
want to save. This should be on the next line.');
It works very well BUT I lose the actual formatting of TEXT. It basically
becomes a single line as:
this is my comment that I want to save. This should be on the next line.
instead of:
this is my comment that I want to save.
This should be on the next line.
Items I have looked at are: using the JS escape() and unescape() functions
to populate the URL variable since it is built via JS.
I tried naming the main window such as: myWin and using JS on the
autosave.cfm file to obtain the value of the textarea field such as:
window.myWin.getElementById('mytxtfield').value and set that to a hidden
form field then do a dynamic form submission in thought that
I could maintain the formatting of the original text. But in this instance,
it indicates that window.myWin is not an object or is null.
I have verified that the window is being named as myWin (and spelled
correctly and used the same upper/lower case).
In lieu of just popping up a window with the textarea for the given field
and then saving it to the DB, then running a JS function to copy
the new text back to the parent window, is there another option to do inline
autosaves within CFMX 7?
Hopefully that made some sense as I can ramble at times.
~|
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:340502
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Beta Tester Wanted for new CF (MVC) Framework
It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 I realize that is a common belief, but I have never seen any compelling evidence to back up the claim. If there's a statement from someone at Google (Matt Cutts most likely) which says that I'm certainly open to be more accepting and less skeptical when I hear that argument brought up. I agree that the former is more readable to a user (who reads URLs anyway?) but I've yet to see actual evidence that it impacts rankings. If there's an article I missed I'm certainly open to references. -Justin ~| 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:340503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: AutoSave function?
I have a form with MANY TEXTAREA elements. Once a user decides to update the text within any of the fields, I want to fire off an autosave type function for the single item. You might try serializing the textarea value into a JSON object and posting that in the background to your autosave engine via form POST rather than a GET operation. You could also use something like jQuery to do an ajax-style call instead of a direct URL call (i.e. so you don't have to pass the data on the URL). The downside is that CF7 doesn't have the JSON functions built-in to parse it back out, but it shouldn't be too difficult to parse manually since the format should always be the same. -Justin ~| 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:340504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Beta Tester Wanted for new CF (MVC) Framework
Justin, I used to be in your camp but I've reversed course. I now believe that having a semantic url actually does matter - as opposed to simply url params. I'm basing this on working with a couple of brialliant SEO guys on a very high traffic ecommerce site where they have captured and maintained their ranking (not just through url rewriting of course :) -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Thursday, January 06, 2011 8:24 AM To: cf-talk Subject: RE: Beta Tester Wanted for new CF (MVC) Framework It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 I realize that is a common belief, but I have never seen any compelling evidence to back up the claim. If there's a statement from someone at Google (Matt Cutts most likely) which says that I'm certainly open to be more accepting and less skeptical when I hear that argument brought up. I agree that the former is more readable to a user (who reads URLs anyway?) but I've yet to see actual evidence that it impacts rankings. If there's an article I missed I'm certainly open to references. -Justin ~| 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:340505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFQuery to mdb
But why does it need to be a full Access database? Providing a delimited file users could import is simpler and more flexible. As it could be imported into both Excel and Access. I asked the same question... It's political and we's IT people don't not know what were talkin bout... One of the groups we are providing the data to developed their system with an old Access Database... Not only do I have to provide it in Access I have to make sure the each table has the fields in the same order, the same data types and even if the column name is in CAPS I have to do so to... For the record I took over the project... Rick ~| 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:340506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFQuery to mdb
Thanks! Looks like I am kind of on the right track... I will read up on this link... Rick -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, January 05, 2011 9:23 PM To: cf-talk Subject: RE: CFQuery to mdb You can seed a database with the schema then access it through passthrough file syntax... .a single prepared temp DB could do the trick. Basically you have a dummy access DSN setup, then you copy your prepped access file to a temp location, load it with data using the passthrough method, and then allow the user to download it (I usually zip it first). Here's a link to a post on the passthrough method. http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx While I agree with you about a CSV file in many cases, Leigh, sometimes this is useful for exactly the reasons you are suggesting - that extra access stuff allows you to create form interfaces, premade queries etc - enhancing off line data mining for the user. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, January 05, 2011 7:17 PM To: cf-talk Subject: Re: CFQuery to mdb just seems like more than I need to do. I do not think so. It is not like exporting html/excel. An Access database consists of more than just the data itself (system tables, etcetera). So I am not sure there is a simpler way. Maybe using ms sql's export tools .. But why does it need to be a full Access database? Providing a delimited file users could import is simpler and more flexible. As it could be imported into both Excel and Access. ~| 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:340507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Beta Tester Wanted for new CF (MVC) Framework
I don't think google care about querystrings. I say this because I have achieved the top 3 spot for many years now for coldfusion hosting and don't use any SEO friendly URL's at all, it is all index.cfm?querystrings Russ -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: 06 January 2011 14:51 To: cf-talk Subject: RE: Beta Tester Wanted for new CF (MVC) Framework Justin, I used to be in your camp but I've reversed course. I now believe that having a semantic url actually does matter - as opposed to simply url params. I'm basing this on working with a couple of brialliant SEO guys on a very high traffic ecommerce site where they have captured and maintained their ranking (not just through url rewriting of course :) -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Thursday, January 06, 2011 8:24 AM To: cf-talk Subject: RE: Beta Tester Wanted for new CF (MVC) Framework It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 I realize that is a common belief, but I have never seen any compelling evidence to back up the claim. If there's a statement from someone at Google (Matt Cutts most likely) which says that I'm certainly open to be more accepting and less skeptical when I hear that argument brought up. I agree that the former is more readable to a user (who reads URLs anyway?) but I've yet to see actual evidence that it impacts rankings. If there's an article I missed I'm certainly open to references. -Justin ~| 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:340508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Accessing a cached query in one function from another...
Hi, all... I'm trying to gain some extra speed on some complex queries and am venturing into my first cached-query experience. What I'm trying to do is run an initial cfc function that caches all needed data for subsequent queries. After the cached query is created, I want to access that data in other cfc functions. I've been trying to return a query variable from the first function, say myCachedQuery, and then refer to that query data in a separate function by using myCachedQuery(). However, I get variable 'myCachedQuery' is undefined... A complicating factor is that I'm calling the subsequent functions via jQuery ajax functionality. The ajax calls have been working fine before I started with the cached query bit. I've search online and tried some solutions, but nothing is working. Do I need to send the cached query back through the ajax call into the second function to have access to the cached query data? Any guidance is appreciated! (And pointing me to up-to-date blogs, etc., dealing with this is welcome, too!) Thanks! Rick ~| 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:340509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFHTTP ad DNS servers that do not return error status codes
I'm running into a problem with CFHTTP. I like to use it on some projects to verify a URL before allowing it to be used. The problem I have is that on my local development environment, my DNS servers (Buckeye Express) don't return failure codes if an invalid URL is tested. My DNS instead forwards the request to a BEX web page that has a few ads and links and a search. Think of it like what openDNS does. Is there anything I can do to start getting validations working? If I have CFHTTP checking a site I want to know if I get anything other than a 200 OK return. I could just post the code to production, which is not on BEX servers and works like I want it to, but I really detest the idea of coding and unit testing in a production environment. This isn't a problem with CFHTTP. This is a problem with your DNS. Your DNS is broken. The best solution is not to use broken DNS servers. Within your local development environment, you can switch to non-broken DNS servers, such as Google's public DNS (8.8.8.8, 8.8.4.4). If your concern is how to handle broken DNS servers within your code, you could conceivably look for a specific value in the HTTP response you get in the event of a failure, but that would only work against one specific broken DNS environment. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing Specific CF8 Instances
You can access the administrator for a particular instance using the internal JRun webserver port. If you want to get to your apps on a particular instance you'll have to manipulate cookies (assuming you're using sticky sessions) so that the session ID starts with the the correct prefix for the instance you want. Being able to access the administrator in that manner implies that you've enabled the JRun built-in web server, of course. But if you've done that, you can use this to get to the apps on that instance as well, as long as both the built-in web server and the real web server use the same web root. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
I'm trying to gain some extra speed on some complex queries and am venturing into my first cached-query experience. Wouldn't a cachedWithin attribute on the query in question be sufficient to speed things up? Notwithstanding that, when you cache a query in one method of a CFC and want to access it from other parts of your application, you'll need to store that query object in a scope where the other parts of the app can access it (such as the application scope or the request scope). Currently you run all those queries and they're getting stored in a scope local to that method, then when the method exits they are destroyed and other parts of the code will not see them (hence the not defined error). -Justin ~| 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:340512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing a cached query in one function from another...
I'm trying to gain some extra speed on some complex queries and am venturing into my first cached-query experience. What I'm trying to do is run an initial cfc function that caches all needed data for subsequent queries. After the cached query is created, I want to access that data in other cfc functions. I've been trying to return a query variable from the first function, say myCachedQuery, and then refer to that query data in a separate function by using myCachedQuery(). However, I get variable 'myCachedQuery' is undefined... How exactly are you caching the query? Code might be useful here. If you're caching a query as a variable, you're either caching it within one of the persistent scopes (session, application, server) or as a member variable of a component. Otherwise, you're not really caching it at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFQuery to mdb
Rick Eidson wrote: It's political and we's IT people don't not know what were talkin bout... Oh. One of those deals. (How familiar ;-) Well it looks like Mark has you on the right path. Mark wrote: While I agree with you about a CSV file in many cases, Leigh, sometimes this is useful for exactly the reasons you are suggesting - that extra access stuff allows you to create form interfaces, premade queries etc - enhancing off line data mining for the user. True enough. I just figured I would ask, in case a simpler method would meet the requirements. -Leigh ~| 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:340514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
I don't think the SEO-unfriendliness of running everything through index.cfm has been an issue for a very long time. They used to have an issue with indexing query strings / dynamic URLs, but not any more. Maybe some of the smaller ones still do, but the major ones definitely do not. Really, if they did, Google wouldn't really even work. :) Simple, self-describing URLs have a higher page rank than complex, non-obvious URLs. If you're trying to show up on the first page of results, good URLs do make a difference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| 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:340515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 I would be a bit surprised if that's true. Both URLs contain obvious, easily-read data. Google is full of smart people who are good at categorization. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
Thanks, Justin... The fact that the caching is local to the method is the part that I was failing to understand...just my ignorance about how caching works. Rick -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Thursday, January 06, 2011 12:02 PM To: cf-talk Subject: RE: Accessing a cached query in one function from another... I'm trying to gain some extra speed on some complex queries and am venturing into my first cached-query experience. Wouldn't a cachedWithin attribute on the query in question be sufficient to speed things up? Notwithstanding that, when you cache a query in one method of a CFC and want to access it from other parts of your application, you'll need to store that query object in a scope where the other parts of the app can access it (such as the application scope or the request scope). Currently you run all those queries and they're getting stored in a scope local to that method, then when the method exits they are destroyed and other parts of the code will not see them (hence the not defined error). -Justin ~| 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:340517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
Thanks for the reply, Dave... I haven't made use of a persistent scope to this point. I thought, perhaps, that just using: cfquery name =queryName datasource=dsn cachedWithin = #createTimeSpan(0,1,0,0)# in the opening tag made the query data persistent without utilizing a persistent scope. As I mentioned to Justin, just my ignorance about how caching works. While waiting for some responses, I did find a blog on Ben Nadel's site that utilizes a remote proxy to handle AJAX requests, but I see that even in that code, Ben uses the application scope. I'm going to create a test case with simpler code to work out this process. Between the CF and jQuery, the actual app code is rather involved and I was trying to avoid asking folks to parse through all of it. A test case will be simpler to present. I'll set one up based on the feedback so far and see how far I get, then post some code. Take-away from feedback so far: Cached queries must be stored in a persistent scope to be accessible between individual, un-related (no parent-child relationship) cfc functions. Would that be correct? Thanks! Rick -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, January 06, 2011 12:02 PM To: cf-talk Subject: Re: Accessing a cached query in one function from another... I'm trying to gain some extra speed on some complex queries and am venturing into my first cached-query experience. What I'm trying to do is run an initial cfc function that caches all needed data for subsequent queries. After the cached query is created, I want to access that data in other cfc functions. I've been trying to return a query variable from the first function, say myCachedQuery, and then refer to that query data in a separate function by using myCachedQuery(). However, I get variable 'myCachedQuery' is undefined... How exactly are you caching the query? Code might be useful here. If you're caching a query as a variable, you're either caching it within one of the persistent scopes (session, application, server) or as a member variable of a component. Otherwise, you're not really caching it at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing a cached query in one function from another...
I haven't made use of a persistent scope to this point. I thought, perhaps, that just using: cfquery name =queryName datasource=dsn cachedWithin = #createTimeSpan(0,1,0,0)# in the opening tag made the query data persistent without utilizing a persistent scope. As I mentioned to Justin, just my ignorance about how caching works. It does make the query data persistent. However, it doesn't create a persistent variable that you can directly access. This will simply pull data from CF's memory rather than the database the next time you run the same query (with the same SQL and tag attributes) within the next hour. In this case, you'd simply rerun the function that calls the query as if you hadn't run it before. The advantage of this sort of caching is that you don't have to put anything in your code to take advantage of it (other than the CACHEDWITHIN attribute). If you want to get a variable that you can reference directly without rerunning the CFQUERY, you need to store the query in a variable that will be available from wherever you want to reference it. In this case, you'd get rid of the CACHEDWITHIN attribute and just store the query itself in the appropriate scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Strange errors when running CF from command line and running Flash Forms.
Hi all, Recently I started running ColdFusion from the command line so I can see any errors/exceptions/etc live. While I was running a page that has a flash form in it, the following errors came up on the screen: 01/06 11:55:04 [jrpp-0] ERROR internal error: expected to get a state from key [//http://*REDACTED*/181282.mxml.cfswf] 01/06 11:55:08 [jrpp-0] ERROR internal error: expected to get a state from key [//http://*REDACTED*/CFIDE/scripts/cfform.swc.cfswf] 01/06 12:22:03 [jrpp-4] ERROR internal error: expected to get a state from key [//http://*REDACTED*/385919644.mxml.cfswf] 01/06 12:26:32 [jrpp-4] ERROR internal error: expected to get a state from key [//http://*REDACTED*/580813472.mxml.cfswf] I hit the same page three times (which accounts for the different numbers before .mxml.cfswf). The pages don't error at all. I just really don't like ERROR messages in my logs/on my screen, so I'm interested in what these might mean. I have googled the errors using [jrpp-0] ERROR internal error: expected to get a state from key and [jrpp-4] ERROR internal error: expected to get a state from key, but have found nothing that relates. Any one seen this before and know how to fix it? Thanks, Steve ~| 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:340520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
Ok, that makes sense... So, to be able to run a master query that would essentially be an in-memory stand-in for the data on the database, and be able to run *various* types of queries on that data, rather than the exact same query, I would need to put the master query into a persistent scope. Right? Or, perhaps, to be able to run *various* queries on the master query, I would need utilized a query-of-query setup with master query stored in memory? I guess at this point, I'm uncertain of the difference between utilizing a cachedWithin query as opposed to a query-of-query... Rick -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, January 06, 2011 12:40 PM To: cf-talk Subject: Re: Accessing a cached query in one function from another... I haven't made use of a persistent scope to this point. I thought, perhaps, that just using: cfquery name =queryName datasource=dsn cachedWithin = #createTimeSpan(0,1,0,0)# in the opening tag made the query data persistent without utilizing a persistent scope. As I mentioned to Justin, just my ignorance about how caching works. It does make the query data persistent. However, it doesn't create a persistent variable that you can directly access. This will simply pull data from CF's memory rather than the database the next time you run the same query (with the same SQL and tag attributes) within the next hour. In this case, you'd simply rerun the function that calls the query as if you hadn't run it before. The advantage of this sort of caching is that you don't have to put anything in your code to take advantage of it (other than the CACHEDWITHIN attribute). If you want to get a variable that you can reference directly without rerunning the CFQUERY, you need to store the query in a variable that will be available from wherever you want to reference it. In this case, you'd get rid of the CACHEDWITHIN attribute and just store the query itself in the appropriate scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Array/List questions
Hi All-
I am trying to build a list with following values:
cfset list = {name:'col1', index:'col1', sorttype:'string'},{name:'col2',
index:'col2', sorttype:'string'},{name:'col3', index:'col3',
sorttype:'string'}
So the above list has 3 values with each value enclosed within the brackets.
When i convert it into array, am getting back 18 values as it is counting each
attribute in the value. How can I make it to consider them as 3 values?
~|
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:340522
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
I guess at this point, I'm uncertain of the difference between utilizing a cachedWithin query as opposed to a query-of-query... The cachedWithin attribute will cause the CF engine to store the query results in memory for the specified amount of time, even across page loads. When you run that exact same query again within the time period, CF will pull the results from memory instead of going and asking the database for it again. In your situation you may be best off using cachedWithin on the various queries and leave it at that. Pulling a large data set and then running query-of-query against it on each page load probably won't help all that much, but caching the individual result sets for those smaller queries should help speed things up for you. -Justin ~| 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:340523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Array/List questions
listtoarray(list,},{) I believe will work.
On Thu, Jan 6, 2011 at 1:01 PM, fun and learning funandlrnn...@gmail.comwrote:
Hi All-
I am trying to build a list with following values:
cfset list = {name:'col1', index:'col1', sorttype:'string'},{name:'col2',
index:'col2', sorttype:'string'},{name:'col3', index:'col3',
sorttype:'string'}
So the above list has 3 values with each value enclosed within the
brackets. When i convert it into array, am getting back 18 values as it is
counting each attribute in the value. How can I make it to consider them as
3 values?
~|
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:340524
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Strange errors when running CF from command line and running Flash Forms.
While I was running a page that has a flash form in it, the following errors came up on the screen: 01/06 11:55:04 [jrpp-0] ERROR internal error: expected to get a state from key [//http://*REDACTED*/181282.mxml.cfswf] 01/06 11:55:08 [jrpp-0] ERROR internal error: expected to get a state from key [//http://*REDACTED*/CFIDE/scripts/cfform.swc.cfswf] 01/06 12:22:03 [jrpp-4] ERROR internal error: expected to get a state from key [//http://*REDACTED*/385919644.mxml.cfswf] 01/06 12:26:32 [jrpp-4] ERROR internal error: expected to get a state from key [//http://*REDACTED*/580813472.mxml.cfswf] I hit the same page three times (which accounts for the different numbers before .mxml.cfswf). The pages don't error at all. I just really don't like ERROR messages in my logs/on my screen, so I'm interested in what these might mean. I have googled the errors using [jrpp-0] ERROR internal error: expected to get a state from key and [jrpp-4] ERROR internal error: expected to get a state from key, but have found nothing that relates. The [jrpp-0] bit isn't relevant for your search, as it just designates the specific JRun thread. The error itself is an artifact of how CF caches output internally, and can be safely disregarded. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion Array/List questions
So the above list has 3 values with each value enclosed
within the brackets.
ColdFusion doesn't know that and is seeing ALL of the commas as list
delimiters. You'll need to change the delimiter to something else and then
break it apart:
cfset list = {x,x,x},{x,x,x},{x,x,x} /
cfset list = replace(list, },{, }#chr(255){ /
cfset theArray = listToArray(list, chr(255)) /
What we're doing here is changing the desired delimited (between the closing
and opening brackets) to some other unused character (ascii 255 in this
case) and then using that as the delimiter for the break, ignoring the
commas entirely.
-Justin
~|
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:340526
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Strange errors when running CF from command line and running Flash Forms.
Thank you. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, January 06, 2011 1:18 PM To: cf-talk Subject: Re: Strange errors when running CF from command line and running Flash Forms. The [jrpp-0] bit isn't relevant for your search, as it just designates the specific JRun thread. The error itself is an artifact of how CF caches output internally, and can be safely disregarded. 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/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing a cached query in one function from another...
So, to be able to run a master query that would essentially be an in-memory stand-in for the data on the database, and be able to run *various* types of queries on that data, rather than the exact same query, I would need to put the master query into a persistent scope. Right? Yes, although I'm not sure you really want to do that. Query of query functionality is fairly slow, so I wouldn't turn to that as a performance enhancement. Or, perhaps, to be able to run *various* queries on the master query, I would need utilized a query-of-query setup with master query stored in memory? I'm not sure how this differs from your previous statement. Everything that you can get to is stored in memory. Persistent scopes are in memory, cached queries using CACHEDWITHIN/CACHEDAFTER are in memory. Even variables local to a page, request or even a function are stored in memory - the only question is, how long are they stored? I guess at this point, I'm uncertain of the difference between utilizing a cachedWithin query as opposed to a query-of-query... CACHEDWITHIN and CACHEDAFTER let you store a query in memory so that the next time the same CFQUERY tag is run, CF can just provide the data directly rather than going to the database to get it. Again, though, it doesn't create a variable that you can access programmatically. The advantage of this approach is that you can just add caching attributes to your CFQUERY tags without making other code changes, and that can improve the speed of your application significantly. If you want to store a query in a variable that you can access, you simply put the query in the appropriate scope. Then, you can reference that variable however you like. Query of query functionality allows you to reference a query variable as if it were a database table. The query variable has to exist first, which either means you've run a query within that request or you have one stored in another scope somewhere. Query of query isn't intended to improve performance as much as to give you another way to manipulate data. It doesn't matter where that data comes from, though - it could come from a query cached using caching attributes as long as you have that query in the same page, or it could come from a query you've stored in a persistent scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Array/List questions
So the above list has 3 values with each value enclosed
within the brackets.
ColdFusion doesn't know that and is seeing ALL of the commas as list
delimiters. You'll need to change the delimiter to something else and then
break it apart:
cfset list = {x,x,x},{x,x,x},{x,x,x} /
cfset list = replace(list, },{, }#chr(255){ /
cfset theArray = listToArray(list, chr(255)) /
What we're doing here is changing the desired delimited (between the closing
and opening brackets) to some other unused character (ascii 255 in this
case) and then using that as the delimiter for the break, ignoring the
commas entirely.
-Justin
Thanks for replying. I get other problem now. The above list is converted as
below:
cfset list = {name:'col1', index:'col1',
sorttype:'string'},{name:'col2', index:'col2',
sorttype:'string'},{name:'col3', index:'col3', sorttype:'string'}
Each name:value is getting surrounded by double quotes. How to ignore these?
~|
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:340529
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
Not using some form of caching or q-o-q puts me right back to the performance problem I'm trying to solve. I've got a query that uses a variable, mysqlOffset, to determine results delivered based on pagination. That creates an almost endless amount of queries involved based on pages and search parameters. In other words, the query and its results are constantly changing. So, it's not practical to create every conceivable result set and cache them all. I've got the DB thoroughly indexed and have had good results with less complicated implementations not involving my particular pagination scheme, but now I'm taking a performance hit that I was trying to reduce. -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Thursday, January 06, 2011 1:15 PM To: cf-talk Subject: RE: Accessing a cached query in one function from another... I guess at this point, I'm uncertain of the difference between utilizing a cachedWithin query as opposed to a query-of-query... The cachedWithin attribute will cause the CF engine to store the query results in memory for the specified amount of time, even across page loads. When you run that exact same query again within the time period, CF will pull the results from memory instead of going and asking the database for it again. In your situation you may be best off using cachedWithin on the various queries and leave it at that. Pulling a large data set and then running query-of-query against it on each page load probably won't help all that much, but caching the individual result sets for those smaller queries should help speed things up for you. -Justin ~| 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:340530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
Bummer...I think. If QoQ doesn't provide a performance improvement over database access, then I'm back to where I started. Thanks for the explanation! -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, January 06, 2011 1:25 PM To: cf-talk Subject: Re: Accessing a cached query in one function from another... So, to be able to run a master query that would essentially be an in-memory stand-in for the data on the database, and be able to run *various* types of queries on that data, rather than the exact same query, I would need to put the master query into a persistent scope. Right? Yes, although I'm not sure you really want to do that. Query of query functionality is fairly slow, so I wouldn't turn to that as a performance enhancement. Or, perhaps, to be able to run *various* queries on the master query, I would need utilized a query-of-query setup with master query stored in memory? I'm not sure how this differs from your previous statement. Everything that you can get to is stored in memory. Persistent scopes are in memory, cached queries using CACHEDWITHIN/CACHEDAFTER are in memory. Even variables local to a page, request or even a function are stored in memory - the only question is, how long are they stored? I guess at this point, I'm uncertain of the difference between utilizing a cachedWithin query as opposed to a query-of-query... CACHEDWITHIN and CACHEDAFTER let you store a query in memory so that the next time the same CFQUERY tag is run, CF can just provide the data directly rather than going to the database to get it. Again, though, it doesn't create a variable that you can access programmatically. The advantage of this approach is that you can just add caching attributes to your CFQUERY tags without making other code changes, and that can improve the speed of your application significantly. If you want to store a query in a variable that you can access, you simply put the query in the appropriate scope. Then, you can reference that variable however you like. Query of query functionality allows you to reference a query variable as if it were a database table. The query variable has to exist first, which either means you've run a query within that request or you have one stored in another scope somewhere. Query of query isn't intended to improve performance as much as to give you another way to manipulate data. It doesn't matter where that data comes from, though - it could come from a query cached using caching attributes as long as you have that query in the same page, or it could come from a query you've stored in a persistent scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing a cached query in one function from another...
If QoQ doesn't provide a performance improvement over database access, then I'm back to where I started. It can, in some situations. It can also provide a decrease in performance, in other situations. You might need to do some testing to see how well it works for you. Query of query uses an embedded SQL engine within CF. This SQL engine can't take advantage of all the functionality within a real SQL engine, like you have in a database server (indexes, etc). On the other hand, it's working against data in memory rather than having to fetch data from the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
Sorry for the piggyback off of this thread, but I am thinking of running the free micro instance for a year thing to test out a project I am working on (nothing in production :D). I don't have much experience in running a server like this, so I am wondering if it is even feasible to run CF9, LCDS and mySQL on a micro instance? Or would I need to upgrade to one of the larger ones? Josh Dura On 1/4/2011 4:43 PM, Richard Steele wrote: Ok, great. I've got my Windows Server Instance up and running! Now I'm downloading the CF8 Developer's Edition. Can I install both CF8 and CF9 Developer's Edition? Our current production server is CF8, but would like to test our code in CF9 before upgrading. ~| 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:340533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
Sorry for the piggyback off of this thread, but I am thinking of running the free micro instance for a year thing to test out a project I am working on (nothing in production :D). I don't have much experience in running a server like this, so I am wondering if it is even feasible to run CF9, LCDS and mySQL on a micro instance? Or would I need to upgrade to one of the larger ones? Memory would be a bit tight for all that, but if you're just going to be hitting it yourself it might work. You'll need to limit CF's memory usage. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
I'm running a low traffic MySQL install on a micro instance. Works very well. But I think you are pushing things in terms of memory with LCDS and CF as well. Worth a try though. Or you could use MySQL on a separate instance, but then again MySQL is your smallest issue I think :-) The great thing is you could try it (I hope you're planning on using *nix for this as Windows will eat even more resources) and if it does not work detach the EBS volume and use a small instance. You do not have to decide up front what instance type you want, you can start with one and then upgrade/downgrade. Stefan On 6 Jan 2011, at 19:31, Josh Dura wrote: Sorry for the piggyback off of this thread, but I am thinking of running the free micro instance for a year thing to test out a project I am working on (nothing in production :D). I don't have much experience in running a server like this, so I am wondering if it is even feasible to run CF9, LCDS and mySQL on a micro instance? Or would I need to upgrade to one of the larger ones? Josh Dura ~| 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:340535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Amazon EC2 Windows 2008 Coldfusion Server
In case you didn't know there is a Windows 2008 core edition available these days which has all the GUI stuff removed and is basically like linux in that you use powershell to control everything. Much smaller footprint and resource usage. Russ -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: 06 January 2011 19:39 To: cf-talk Subject: Re: Amazon EC2 Windows 2008 Coldfusion Server I'm running a low traffic MySQL install on a micro instance. Works very well. But I think you are pushing things in terms of memory with LCDS and CF as well. Worth a try though. Or you could use MySQL on a separate instance, but then again MySQL is your smallest issue I think :-) The great thing is you could try it (I hope you're planning on using *nix for this as Windows will eat even more resources) and if it does not work detach the EBS volume and use a small instance. You do not have to decide up front what instance type you want, you can start with one and then upgrade/downgrade. Stefan On 6 Jan 2011, at 19:31, Josh Dura wrote: Sorry for the piggyback off of this thread, but I am thinking of running the free micro instance for a year thing to test out a project I am working on (nothing in production :D). I don't have much experience in running a server like this, so I am wondering if it is even feasible to run CF9, LCDS and mySQL on a micro instance? Or would I need to upgrade to one of the larger ones? Josh Dura ~| 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:340536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
Yeah, that's what I figured. I'll give it a shot since its free for the first year for the micro instance and hope for the best. Thanks for the detailed responses all :) Josh On 1/6/2011 1:39 PM, Stefan Richter wrote: I'm running a low traffic MySQL install on a micro instance. Works very well. But I think you are pushing things in terms of memory with LCDS and CF as well. Worth a try though. Or you could use MySQL on a separate instance, but then again MySQL is your smallest issue I think :-) The great thing is you could try it (I hope you're planning on using *nix for this as Windows will eat even more resources) and if it does not work detach the EBS volume and use a small instance. You do not have to decide up front what instance type you want, you can start with one and then upgrade/downgrade. Stefan On 6 Jan 2011, at 19:31, Josh Dura wrote: Sorry for the piggyback off of this thread, but I am thinking of running the free micro instance for a year thing to test out a project I am working on (nothing in production :D). I don't have much experience in running a server like this, so I am wondering if it is even feasible to run CF9, LCDS and mySQL on a micro instance? Or would I need to upgrade to one of the larger ones? Josh Dura ~| 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:340537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Accessing a cached query in one function from another...
Thanks for the explanation. It seems that I've put us through this discussion for nothing. (Well, except for my education!) Something was causing my queries to take about 36 seconds for the longest ones. I attributed that to the complexity of the queries. However, now those same queries are taking only about 500ms, with other queries returning fewer records as quick as 40ms. I have no clue what was causing the slowdown. I've kept an eye on MySQL server, as sometimes during this process, a bad query would cause it to continue to process, even after I killed the page request. No problems with that during these slowdowns. But now all queries are reasonably quick. Thanks for the input, Dave, and everyone else! I did learn quite a few things! Rick -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, January 06, 2011 1:53 PM To: cf-talk Subject: Re: Accessing a cached query in one function from another... If QoQ doesn't provide a performance improvement over database access, then I'm back to where I started. It can, in some situations. It can also provide a decrease in performance, in other situations. You might need to do some testing to see how well it works for you. Query of query uses an embedded SQL engine within CF. This SQL engine can't take advantage of all the functionality within a real SQL engine, like you have in a database server (indexes, etc). On the other hand, it's working against data in memory rather than having to fetch data from the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
In case you didn't know there is a Windows 2008 core edition available these days which has all the GUI stuff removed and is basically like linux in that you use powershell to control everything. Much smaller footprint and resource usage. I don't think that's available on EC2. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Well it was an example case. Most url vars aren't as easy to read as my fake example. It would probably be more like mysite.com?id=1345238 On Thu, Jan 6, 2011 at 12:09 PM, Dave Watts dwa...@figleaf.com wrote: It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 I would be a bit surprised if that's true. Both URLs contain obvious, easily-read data. Google is full of smart people who are good at categorization. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Amazon EC2 Windows 2008 Coldfusion Server
Has anybody got the Amazon AWS EC2 API working with CF? I have not been able to get past the authentication part. I tried reworking the authentication bit from this project (http://awsconsole.riaforge.org/) but can I keep getting the error The provided security credentials are not valid. That project uses the older version of amazons API and amazon says: If you are currently using signature version 1: Version 1 is deprecated, and you should move to signature version 2 as soon as possible. For information about the deprecation schedule and the differences between signature version 2 and version 1, go to Making Secure Requests to Amazon Web Services. The docs for creating the signature are here: http://docs.amazonwebservices.com/AWSEC2/2010-11-15/DeveloperGuide/index.htm l?using-query-api.html I can't get past this part.. Anyone got this working? Brook -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: January-06-11 11:56 AM To: cf-talk Subject: Re: Amazon EC2 Windows 2008 Coldfusion Server In case you didn't know there is a Windows 2008 core edition available these days which has all the GUI stuff removed and is basically like linux in that you use powershell to control everything. Much smaller footprint and resource usage. I don't think that's available on EC2. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 I would be a bit surprised if that's true. Both URLs contain obvious, easily-read data. Google is full of smart people who are good at categorization. Well it was an example case. Most url vars aren't as easy to read as my fake example. It would probably be more like mysite.com?id=1345238 Those are two different examples, and would presumably have two different outcomes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
On Thu, Jan 6, 2011 at 4:58 AM, Michael Grant mgr...@modus.bz wrote: It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 Very likely but most frameworks support basic SES URLs anyway like this: mysite.com/index.cfm/cat/cars/maker/bmw/style/x3 That works 'out of the box' with ColdBox and FW/1 at least (and probably Fusebox, I can't remember). I suspect MG and M2 can handle something like this with perhaps only a small extension. And I strongly suspect cfWheels supports this too. If you have a routes package (like ColdBox and, I think, cfWheels?), you could easily support: mysite.com/index.cfm/cars/bmw/x3 again, out of the box. If you want to eliminate /index.cfm, that's trivial with Apache (and reasonably easy with an IIS rewrite module). So there's nothing inherent about front controller frameworks that make them worse for SEO ranking. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:340543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Yes they are. However I believe my original point (minus my supporting argument) is still valid. Well structured urls are better than url vars. Or at least that's what I've always known to be true. And when it comes to SEO mojo why risk it? On Thu, Jan 6, 2011 at 5:03 PM, Dave Watts dwa...@figleaf.com wrote: It's not an issue in that Google can't crawl you. It's an issue in that Google will rank this: mysite.com/Cars/BMW/X3 Higher than this: mysite.com?cat=carsmaker=bmwstyle=x3 I would be a bit surprised if that's true. Both URLs contain obvious, easily-read data. Google is full of smart people who are good at categorization. Well it was an example case. Most url vars aren't as easy to read as my fake example. It would probably be more like mysite.com?id=1345238 Those are two different examples, and would presumably have two different outcomes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Yes they are. However I believe my original point (minus my supporting argument) is still valid. Well structured urls are better than url vars. Or at least that's what I've always known to be true. And when it comes to SEO mojo why risk it? URL parameters, by themselves, don't prevent a URL from being well-structured. And you clearly don't know that to be true (otherwise, the phrase why risk it would make no sense). And there are specific, admittedly minor, costs to URL rewriting. And finally, there's no such thing as SEO mojo. This is a fraud perpetrated by people who want to treat SEO as a black art, and position themselves as adepts at that art. In almost all respects, search engines reward the application of common sense. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Know it to be true? Nobody knows it except the people at Google. Why risk someone's hunch that's it isn't true? At best what do you gain if you're right? Save a few hours dev time? And at worst? You lose search engine rank which can have disastrous effects on a company. To me it's not worth the risk just to prove the SEO guys wrong. Even if you take SEO right out of it, easy to read url's are nicer to look at, easier to remember and just plain make sense. And if you think there's no such thing as SEO mojo I think you're been sipping one too many chi teas. On Thu, Jan 6, 2011 at 5:54 PM, Dave Watts dwa...@figleaf.com wrote: Yes they are. However I believe my original point (minus my supporting argument) is still valid. Well structured urls are better than url vars. Or at least that's what I've always known to be true. And when it comes to SEO mojo why risk it? URL parameters, by themselves, don't prevent a URL from being well-structured. And you clearly don't know that to be true (otherwise, the phrase why risk it would make no sense). And there are specific, admittedly minor, costs to URL rewriting. And finally, there's no such thing as SEO mojo. This is a fraud perpetrated by people who want to treat SEO as a black art, and position themselves as adepts at that art. In almost all respects, search engines reward the application of common sense. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:340546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Detecting Mobile user agent - what methods work best?
I have to convert a client site to enable phone users to use the site and I was wondering what is the best method to detect the mobile user agent and switch the css sheet? As far as i have seen, there are a few ways to do this - which is best? (or maybe the way to put it is 'least bad') [A] a link at the top of the normal page, linking to a mobile version of the page. (yuk) [B] javascript detection (but there are thousands of mobile devices to detect. YUK ) [C] Use CSS @media handheld (but many cell phones don't support the handheld media type ) [D] server side detection using CGI.User_Agent (but there are so many user agents to detect) [E] screen resolution detection (but is that reliable?) Are there any other ways to do this? How do the rest of you handle serving pages to both computer screens and mobile device screens?? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:340547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Detecting Mobile user agent - what methods work best?
BrowserHawk is a really nice commercial solution for this one, and has built-in CF support. http://www.cyscape.com/ --- Ben -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Thursday, January 06, 2011 6:49 PM To: cf-talk Subject: Detecting Mobile user agent - what methods work best? I have to convert a client site to enable phone users to use the site and I was wondering what is the best method to detect the mobile user agent and switch the css sheet? As far as i have seen, there are a few ways to do this - which is best? (or maybe the way to put it is 'least bad') [A] a link at the top of the normal page, linking to a mobile version of the page. (yuk) [B] javascript detection (but there are thousands of mobile devices to detect. YUK ) [C] Use CSS @media handheld (but many cell phones don't support the handheld media type ) [D] server side detection using CGI.User_Agent (but there are so many user agents to detect) [E] screen resolution detection (but is that reliable?) Are there any other ways to do this? How do the rest of you handle serving pages to both computer screens and mobile device screens?? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:340548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Detecting Mobile user agent - what methods work best?
WURFL is probably the best I have seen, and open source. I prefer this over any form of JavaScript alternative any day. http://wurfl.sourceforge.net/ Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Ben Forta [mailto:b...@forta.com] Sent: Friday, 7 January 2011 11:02 AM To: cf-talk Subject: RE: Detecting Mobile user agent - what methods work best? BrowserHawk is a really nice commercial solution for this one, and has built-in CF support. http://www.cyscape.com/ --- Ben -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Thursday, January 06, 2011 6:49 PM To: cf-talk Subject: Detecting Mobile user agent - what methods work best? I have to convert a client site to enable phone users to use the site and I was wondering what is the best method to detect the mobile user agent and switch the css sheet? As far as i have seen, there are a few ways to do this - which is best? (or maybe the way to put it is 'least bad') [A] a link at the top of the normal page, linking to a mobile version of the page. (yuk) [B] javascript detection (but there are thousands of mobile devices to detect. YUK ) [C] Use CSS @media handheld (but many cell phones don't support the handheld media type ) [D] server side detection using CGI.User_Agent (but there are so many user agents to detect) [E] screen resolution detection (but is that reliable?) Are there any other ways to do this? How do the rest of you handle serving pages to both computer screens and mobile device screens?? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~~ ~~~| 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:340548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| 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:340549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
Know it to be true? Nobody knows it except the people at Google. Why risk someone's hunch that's it isn't true? At best what do you gain if you're right? Save a few hours dev time? And at worst? You lose search engine rank which can have disastrous effects on a company. To me it's not worth the risk just to prove the SEO guys wrong. Well, this is kind of silly. If you're worried about losing search engine rank, you have to continue doing whatever you've been doing - existing URLs have rank that new URLs won't. Even if you were doing URLs badly, you wouldn't want to simply switch to a better way of doing them as you'd lose the rank you've already achieved unless you're willing to support the old URLs as well. But in any case, you might want to subscribe to Matt Cutts' RSS feed - he covers a lot of this stuff pretty well, and he's at Google. He's discussed URL parameters' safety in searches before, although I didn't bother to Google it today. And if you think there's no such thing as SEO mojo I think you're been sipping one too many chi teas. SEO mojo is a way for charlatans to make money. There are some well-known, documented facts for SEO (not in any specific order): - content, - logical structure, - unique, readable titles, - readable URLs, - page rank from quality links to your content, - anything that might cause duplicated content (failure to use redirects or canonical URLs with multiple domains, etc) But whenever anybody starts talking about mojo, without being able to point to clearly definable factors ... well, I call that something else. And I'm exposed to SEO stuff fairly frequently. My company relies on SEO for its training business. When you search for: coldfusion training flash training google search appliance training sencha training html 5 training (although not for html5 training - not sure how we'll deal with that yet!) you'll notice we're in the top 10 results. Even if you take SEO right out of it, easy to read url's are nicer to look at, easier to remember and just plain make sense. Sure, I recommend that to clients all the time. Cool URIs don't change http://www.w3.org/Provider/Style/URI But that's a different discussion. If you're going to say that people should use good URLs for unrelated reasons, you don't have to back that up with true facts about SEO that aren't actually true. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
So you're reacting to the word mojo? You seem to have a personal axe to grind here. Did you get taken by an SEO guy selling snake oil? On Thu, Jan 6, 2011 at 7:22 PM, Dave Watts dwa...@figleaf.com wrote: Know it to be true? Nobody knows it except the people at Google. Why risk someone's hunch that's it isn't true? At best what do you gain if you're right? Save a few hours dev time? And at worst? You lose search engine rank which can have disastrous effects on a company. To me it's not worth the risk just to prove the SEO guys wrong. Well, this is kind of silly. If you're worried about losing search engine rank, you have to continue doing whatever you've been doing - existing URLs have rank that new URLs won't. Even if you were doing URLs badly, you wouldn't want to simply switch to a better way of doing them as you'd lose the rank you've already achieved unless you're willing to support the old URLs as well. But in any case, you might want to subscribe to Matt Cutts' RSS feed - he covers a lot of this stuff pretty well, and he's at Google. He's discussed URL parameters' safety in searches before, although I didn't bother to Google it today. And if you think there's no such thing as SEO mojo I think you're been sipping one too many chi teas. SEO mojo is a way for charlatans to make money. There are some well-known, documented facts for SEO (not in any specific order): - content, - logical structure, - unique, readable titles, - readable URLs, - page rank from quality links to your content, - anything that might cause duplicated content (failure to use redirects or canonical URLs with multiple domains, etc) But whenever anybody starts talking about mojo, without being able to point to clearly definable factors ... well, I call that something else. And I'm exposed to SEO stuff fairly frequently. My company relies on SEO for its training business. When you search for: coldfusion training flash training google search appliance training sencha training html 5 training (although not for html5 training - not sure how we'll deal with that yet!) you'll notice we're in the top 10 results. Even if you take SEO right out of it, easy to read url's are nicer to look at, easier to remember and just plain make sense. Sure, I recommend that to clients all the time. Cool URIs don't change http://www.w3.org/Provider/Style/URI But that's a different discussion. If you're going to say that people should use good URLs for unrelated reasons, you don't have to back that up with true facts about SEO that aren't actually true. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Beta Tester Wanted for new CF (MVC) Framework
I really don't think Dave has any Axe to grind, they are after all just true facts he has stated,perhaps he may have gone a bit OTT in calling SEO experts snake oil salesmen though. Every field has its experts, so an SEO expert is really no different than a CSS expert or a user interface expert, that is simply their trade. But like any trade there are cowboys who profess to be experts when they are not. If you are one of those that doesn't know much about SEO then it may seem like some kind of MOJO, but really it isn't. I doubt it would take more than 1 hours research to pickup the basics.But to be fair to learn all the tricks of all the search engines would take some time, but I doubt that many people care about anything beyond yahoo, Google and Bing these days, As Dave said, a bit of common sense goes a long way with this stuff, and like him I have several sites in the top 10 with very little effort. Russ On Fri, Jan 7, 2011 at 12:29 AM, Michael Grant mgr...@modus.bz wrote: So you're reacting to the word mojo? You seem to have a personal axe to grind here. Did you get taken by an SEO guy selling snake oil? On Thu, Jan 6, 2011 at 7:22 PM, Dave Watts dwa...@figleaf.com wrote: Know it to be true? Nobody knows it except the people at Google. Why risk someone's hunch that's it isn't true? At best what do you gain if you're right? Save a few hours dev time? And at worst? You lose search engine rank which can have disastrous effects on a company. To me it's not worth the risk just to prove the SEO guys wrong. Well, this is kind of silly. If you're worried about losing search engine rank, you have to continue doing whatever you've been doing - existing URLs have rank that new URLs won't. Even if you were doing URLs badly, you wouldn't want to simply switch to a better way of doing them as you'd lose the rank you've already achieved unless you're willing to support the old URLs as well. But in any case, you might want to subscribe to Matt Cutts' RSS feed - he covers a lot of this stuff pretty well, and he's at Google. He's discussed URL parameters' safety in searches before, although I didn't bother to Google it today. And if you think there's no such thing as SEO mojo I think you're been sipping one too many chi teas. SEO mojo is a way for charlatans to make money. There are some well-known, documented facts for SEO (not in any specific order): - content, - logical structure, - unique, readable titles, - readable URLs, - page rank from quality links to your content, - anything that might cause duplicated content (failure to use redirects or canonical URLs with multiple domains, etc) But whenever anybody starts talking about mojo, without being able to point to clearly definable factors ... well, I call that something else. And I'm exposed to SEO stuff fairly frequently. My company relies on SEO for its training business. When you search for: coldfusion training flash training google search appliance training sencha training html 5 training (although not for html5 training - not sure how we'll deal with that yet!) you'll notice we're in the top 10 results. Even if you take SEO right out of it, easy to read url's are nicer to look at, easier to remember and just plain make sense. Sure, I recommend that to clients all the time. Cool URIs don't change http://www.w3.org/Provider/Style/URI But that's a different discussion. If you're going to say that people should use good URLs for unrelated reasons, you don't have to back that up with true facts about SEO that aren't actually true. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:340552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Beta Tester Wanted for new CF (MVC) Framework
Mike, you sure you want to go head to head with DW? Seems risky :) Plus I think he's an Old Milwaukee guy (chi tea? Ouch!) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Thursday, January 06, 2011 5:24 PM To: cf-talk Subject: Re: Beta Tester Wanted for new CF (MVC) Framework Know it to be true? Nobody knows it except the people at Google. Why risk someone's hunch that's it isn't true? At best what do you gain if you're right? Save a few hours dev time? And at worst? You lose search engine rank which can have disastrous effects on a company. To me it's not worth the risk just to prove the SEO guys wrong. Even if you take SEO right out of it, easy to read url's are nicer to look at, easier to remember and just plain make sense. And if you think there's no such thing as SEO mojo I think you're been sipping one too many chi teas. ~| 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:340553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Detecting Mobile user agent - what methods work best?
We us a combination of A and B at least A gives folks the option you know. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Thursday, January 06, 2011 5:49 PM To: cf-talk Subject: Detecting Mobile user agent - what methods work best? I have to convert a client site to enable phone users to use the site and I was wondering what is the best method to detect the mobile user agent and switch the css sheet? As far as i have seen, there are a few ways to do this - which is best? (or maybe the way to put it is 'least bad') [A] a link at the top of the normal page, linking to a mobile version of the page. (yuk) [B] javascript detection (but there are thousands of mobile devices to detect. YUK ) [C] Use CSS @media handheld (but many cell phones don't support the handheld media type ) [D] server side detection using CGI.User_Agent (but there are so many user agents to detect) [E] screen resolution detection (but is that reliable?) Are there any other ways to do this? How do the rest of you handle serving pages to both computer screens and mobile device screens?? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:340554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Apache Permission Error - extension cannot load, apache cannot start
Hi All, Happy New year to all, I hope that you all had a great break. We are putting together a Centos 64 bit linux, CF8 multiserver web server, and having some issues getting the default 'cfusion' CF instance running. We are installing 64bit ColdFusion 8 in MultiServer Mode on a Centos 5.5 64bit machine, with apache 2.2.3 and have run into an issue with apache permissions. We are currently experiencing permission issues on the CF Apache extension and it is preventing Apache from starting. The following is the error being shown on the console, and weâve also listed the permissions dump for the files we believe are affected: [r...@red5m01-web03 bin]# service httpd start Starting httpd: httpd: Syntax error on line 873 of /etc/httpd/conf/httpd.conf: Cannot load /opt/jrun4/lib/wsconfig/1/mod_jrun22.so into server: /opt/jrun4/lib/wsconfig/1/mod_jrun22.so: cannot open shared object file: Permission denied [r...@red5m01-web03 bin]# ls -Z /opt/jrun4/lib/wsconfig/1/mod_jrun22.so -rwxr-xr-x root root system_u:object_r:initrc_exec_t /opt/jrun4/lib/wsconfig/1/mod_jrun22.so [r...@red5m01-web03 bin]# ls -Z /usr/sbin/apachectl -rwxr-xr-x root root system_u:object_r:initrc_exec_t /usr/sbin/apachectl It seems that the mod_jrun22.so file has the necessary permissions. The following is the /etc/httpd/conf/httpd.conf lines the error is referring to: 872 # JRun Settings 873 LoadModule jrun_module /opt/jrun4/lib/wsconfig/1/mod_jrun22.so 874 IfModule mod_jrun22.c 875 JRunConfig Verbose false 876 JRunConfig Apialloc false 877 JRunConfig Ignoresuffixmap false 878 JRunConfig Serverstore /opt/jrun4/lib/wsconfig/1/jrunserver.store 879 JRunConfig Bootstrap 127.0.0.1:51020 880 #JRunConfig Errorurl url optionally redirect to this URL on errors 881 #JRunConfig ProxyRetryInterval 600 number of seconds to wait before trying to reconnect to unreachable clustered server 882 #JRunConfig ConnectTimeout 15 number of seconds to wait on a socket connect to a jrun server 883 #JRunConfig RecvTimeout 300 number of seconds to wait on a socket receive to a jrun server 884 #JRunConfig SendTimeout 15 number of seconds to wait on a socket send to a jrun server 885 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf 886 /IfModule We believe that all files are in the correct locations. Can anyone provide any suggestions on what might be wrong, and where? Thanks in advance. -- Duncan I Loxton duncan.lox...@gmail.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:340555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Apache Permission Error - extension cannot load, apache cannot start
Is selinux enabled ? Is there something in /var/log/audit/audit.log about the error ? -- Mack ~| 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:340556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
