Re: Fusebox and .swf problem
On 4/1/07, John Beynon [EMAIL PROTECTED] wrote: just make sure you reference your swf relative to the root index.cfm - if your use httpwatch (http://www.httpwatch.com/) to show you what is being loaded and you'll see the problem immediately, Yeah, it's almost certainly a path issue - Fusebox display fuses are executed in the context of the application root, not the directory containing the fuse, so you need to take that into account. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion5 + output to excel but does not want to output in decimal format
Thanks a Million Sir It works like a bomb! You really saved me big time; I was struggling with this and another issue for days. I thought it was not possible. THANK YOU Regards, Ismail ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Just checking
And, yes, I'm back on cf-talk as part of my being more active in the community post-Adobe promise... WOOOoo! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT ISAPI Rewrite
Russ, Don't take it the wrong way but no one, as far as I have seen over the years has *ever* recommended or bashed one web server over another on such a blatant scale :-). It is not constructive to say that IIS is inferior and does not show good etiquette IMO - a bit like the PC v Mac debate I thought we all grew out of. I have used both Apache and IIS, and am completely agnostic when it comes to serving pages. Here are my thoughts on what I found (when working with ColdFusion). Out of the box install, there really is nothing to seperate them - on Windows at least. Both have a next, next finish process and Adobe do all the rest of the work with the web connector. IIS is without doubt easier to manage due it's GUI nature as you noted and I wouldn't choose a product based on that but it is a major factor. If you had to choose between Word Processing the way we used to over using Word or some other easier to use GUI based system you would choose the latter, anyone would, it's one of the reasons IIS is attractive and why it is usually the web server of choice for beginners etc. I never really found Apache hard to configure as like most on the list, I was and am familiar with config files. Most mods I worked with had installers so I was never really had to go out of the box to configure. It can be daunting with Apache when you need to start fiddling with the config by hand and I can see why someone would shy away from it back to IIS. If Apache had a GUI like this (I never found one when I was working on it) it would be great but not make it any better or superior.. I am not sure what you mean about managing / storing configuration files in Source Control, control log files or use authentication other than AD... All are certainly possibly and bread and butter stuff to IIS. From these comments, I would suggest it is you who goes down the research route and objectively look at IIS rather than letting your obvious prejudice get in the way. I did find Apache served pages faster than IIS during load testing etc. Also, if you want to use .NET, AFAIK the only supported route is to use IIS. My biggest point of note with using Apache was that if I used it daily I wouldn't want to use it with JRUn, I would want to use Tomcat, but last time I checked the latter was not suported by Adobe. I did dabble with getting Tomcat to talk to ColdFusion either via the APR within Tomcat and also via a mod connector to Apache, it was a nightmare, it worked but it wasn't easy. The last point of note was that nearly all of the stuff on Apache is based around non-Wndows platforms which can make it hard to debug. I am not saying there are no resources just that a Google displayed more non-Windows results so you can see why that is not attractive to the inquisitive web server searcher... Just my £0.02p This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Apr 02 05:46:57 2007 Subject: RE: OT ISAPI Rewrite Casey, I'm sorry you feel that way, but there are plenty advantages of Apache over IIS on a windows box. Most people here say that they choose not to use Apache because it's harder to configure, but my experience has been quite the opposite. Just because Pete decided to waste $99 per server on ISAPI rewrite, it doesn't mean that he can't see the light and start using Apache and all the power and flexibility that comes with it. If Apache is not an option for Pete, he can say so, but just because he's using IIS and has already bought ISAPI rewrite, doesn't necessarily mean that he has to stick with an inferior product. Before you make blanket statements like saying that there is no advantage of Apache over IIS on the windows box, I suggest you do you research. When this thread came up before, it was basically decided that both Apache and IIS are good servers on windows, and which one is has the advantage is really based on your needs. IIS is arguably slightly better for hosting ...NET applications as well as doing integrated authentication, while Apache is better when you want to have control of you configurations, keep the configuration files in source control, have control of your log files, ability to use a
Re: WDDX v.s. CF 7 XML functionality
On Friday 30 Mar 2007, Rick Root wrote: I'm currently working on a flex application where the user can set a variety of preferences. For example, a list of items to be automatically selected in a certain list control. OOI, why not use SharedObject() ? -- Tom Chiverton Helping to enormously industrialize cross-platform relationships on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PS3 :: to run CFMX8 better then windows vista..
On Friday 30 Mar 2007, Paul Ihrig wrote: happy April fools all... That was *yesterday*. April Fools in the internet doesn't work because you have no idea when the person will read you message. -- Tom Chiverton Helping to enthusiastically facilitate synergistic e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OUTCOME: Huge number of connections to the database server - what to do?
On Monday 02 Apr 2007, Mike Kear wrote: So that's the issue - if you're going to do database accesses in CFSCRIPT, then: [A] think again and do them in tags like everyone else, there's nothing wrong with that, and [B] if you really insist on doing them in CFSCRIPT, then make sure you close the connection. [C] if ever you are tempted to follow option B, do A instead. [D] Use CFFUNCTION to wrap around CFQUERY, and call the function from CFScript, rather than use the ServiceFactory - it'll even be supported and portable then. -- Tom Chiverton Helping to appropriately differentiate next-generation clusters on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FW: Using 404 error to automatically redirect...
Brett, Here is an example of how I do it: http://www.bennadel.com/blog/286-Handling-404-Errors-in-ColdFusion-via-I IS-Throwing-404-.htm [ OR http://www.bennadel.com/index.cfm?dax=blog:286.view ] Hope maybe that gives you some ideas. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adding ADT and ADL to classpath for Apollo app creation
On Sunday 01 Apr 2007, Andy Matthews wrote: to compiling it for package or even for testing, I get an error in the command line. I followed the directions on how to add the adt.jar file to the classpath but it still doesn't work. What error ? What O/S ? I guess this is the command line SDK, on Windows, so just add the full path of the 'bin' dir (incl. '/bin') to your PATH via the Control Panel's 'System' icon. 2) Could it be that I have the Apollo SDK files on my D drive while Java is obviously on C? I can't see it mattering. -- Tom Chiverton Helping to carefully orchestrate eye-catching convergence on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
iSeries point to ColdFusion server direction...
I hope someone can point me in the right direction or fill me in... Currently where I work we donât use ColdFusion but Iâm putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donât want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problems with Verity on Solaris 8 with CFMX 7
Hello, I'm struggeling with the exact same issue. Were you able to solve it? How? Thank you so much for your reply! We installed CFMX 7 to our development box on Monday. (It's a Solaris 8 machine with a previous install of cf 6.1 and Verity.) We have been working ever since to get Verity working and we are about to hit our deadline. We have installed every language pack we can find and we are still having issues with locales. The code is running on Windows with CFMX 7 and Verity just fine. But when we try to create indexes in a foreign language we get exceptions. Our current hurdle is that when we run this code: cfcollection action=CREATE path=/hiding/our/collection/path/ collection=partners_2_3 language=french followed by this code: cfindex type=custom collection=partners_2_3 language=french query=processed title=title key=contentid body=title,contentbody action=refresh custom2=urlpath We get this error on the CFIndex: Language mismatch for collection partners_2_3. The language you specified, english, does not match the collection language of french. Even though we specify French in the CFIndex tag, Verity receives that we specified English. We have 800 collections involving many different languages. We assume that this would fail for all languages, not just French, but we haven't taken out French to test this. Help! Thanks -- I must remember to honor the power of the off switch. Omi of Xiaolin Showdown Now blogging http://www.blivit.org/blog/index.cfm http://www.blivit.org/mr_urc/index.cfm ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Subversion questions
So we've been using Subversion to track changes to our web site applications for a few months now, and I don't think we're doing it right when I set up the subversion server originally, I set up a single repository which holds everything we want to maintain version control for... each web site is a subdirectory of the main repository. so on my computer, I have a working copy of the repository that looks like this: D:\work\ads\* (www.it.dev.duke.edu) D:\work\advanceweb\* (advanceweb.ads.duke.edu) D:\work\stockgifts\* (stockgifts.duke.edu) Additionally, all of my flex projects are stored in D:\work\flexProjects\* The problem here of course is that *ALL* of the flex project files are part of version control, including the project properties and such... which seems to make life difficult for having multiple developers working on the same flex application. So... what are the best practices for subversion use? Should I create a repository for each web site, and another for each flex project? What if I have multiple coldfusion applications residing on a given web site (for example, www.it.dev.duke.edu has *MANY* applications) Thanks... Rick -- CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! http://www.cfmbb.org ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Really weird encrypt problem/bug
I've always run into the same problem, especially with numbers. We usually had to Base64 encode the encrypted string and then URLEncode that for ultimate safety before passing it on to the next page or source application. -- Phil -Original Message- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Saturday, March 31, 2007 8:23 AM To: CF-Talk Subject: Re: Really weird encrypt problem/bug I've had issues with encrypt/decrypt when combined with URLEncodedFormat(). The issue always had to do with how strings got Decoded (not decrypted). If the encrypted value had a space in it (which I couldn't guarantee it wouldn't since we were using CF6.1), the space would be encoded as %20. When it was Decoded, it would become a + rather than a space, so the decrypting would do funky things very often resulting in null pointer errors! It doesn't sound like this is your issue, but it was a thorn in my side for several months while working on this CF6 application. Cheers, Kris On 3/30/07, Les Mizzell [EMAIL PROTECTED] wrote: Peter Boughton wrote: Odd. You can get one or two =s used by the CF encryption for padding encoded values to a certain length, so that might explain the character itself, but not really /why/ it's happening. What is in Request.encCode? It's a random string that's stored in another table to keep it unique for each record. It's a short string though - usually something like ac74rn23. Is it definitely constant between encrypt and decrypt? Yup I've tested 100 times, and the client has tested even more, and any combination of 5 numbers encrypts/decrypts correctly, as long as the last number isn't a 2. This is an older app and because of the legacy data I'm not in a position of changing the algorithm used at the moment. It's not super-sensitive information that would crash the world if it leaked or anything anyway. Nothing associated with credit cards or such. So, two current solutions!! 1. Tell the client that if it's a 4 digit number with a = tagged on the end, then that's a 2! (already implemented) 2. rereplace the = with a 2 after decrypt - heh... For the life of me, I see NO reason why/how this could be happening! It's a very odd thing indeed! ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Subversion questions
Rick, According to the best practices each project should have its own repository, now if in your case you have a main repository, you can have projects underneath but they must have there own trunk / branches / tags. Which I am not sure if you have, so if you need to switch to a particular version you can change branch from that project only, or if you need to check out you check out from that project. Hope that helps, but more info about this can be found on the subversion website. On 4/2/07, Rick Root [EMAIL PROTECTED] wrote: So we've been using Subversion to track changes to our web site applications for a few months now, and I don't think we're doing it right when I set up the subversion server originally, I set up a single repository which holds everything we want to maintain version control for... each web site is a subdirectory of the main repository. so on my computer, I have a working copy of the repository that looks like this: D:\work\ads\* (www.it.dev.duke.edu) D:\work\advanceweb\* (advanceweb.ads.duke.edu) D:\work\stockgifts\* (stockgifts.duke.edu) Additionally, all of my flex projects are stored in D:\work\flexProjects\* The problem here of course is that *ALL* of the flex project files are part of version control, including the project properties and such... which seems to make life difficult for having multiple developers working on the same flex application. So... what are the best practices for subversion use? Should I create a repository for each web site, and another for each flex project? What if I have multiple coldfusion applications residing on a given web site (for example, www.it.dev.duke.edu has *MANY* applications) Thanks... Rick -- CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! http://www.cfmbb.org ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Subversion questions
There are some standards (http://svnbook.red-bean.com/nightly/en/svn.branchmerge.maint.html) that people tend to adhere to, but the structure of your repositories is not the most important factor. The processes on how your developers use the repositories is. As long as you have a solid process that everyone adheres to, and it works for your layout, then there's nothing wrong with it. I create a single respository for every project, but I have also seen some companies that create more global respositories, like you do, that hold a certain collection of projects (intranet, internet, flash, etc). Also, as the article I linked explains, if you believe that your current system isn't flexible, or is causing problems, rearranging the respository structure is very easy. Steve Brownlee http://www.fusioncube.net -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 8:43 AM To: CF-Talk Subject: OT: Subversion questions So we've been using Subversion to track changes to our web site applications for a few months now, and I don't think we're doing it right when I set up the subversion server originally, I set up a single repository which holds everything we want to maintain version control for... each web site is a subdirectory of the main repository. so on my computer, I have a working copy of the repository that looks like this: D:\work\ads\* (www.it.dev.duke.edu) D:\work\advanceweb\* (advanceweb.ads.duke.edu) D:\work\stockgifts\* (stockgifts.duke.edu) Additionally, all of my flex projects are stored in D:\work\flexProjects\* The problem here of course is that *ALL* of the flex project files are part of version control, including the project properties and such... which seems to make life difficult for having multiple developers working on the same flex application. So... what are the best practices for subversion use? Should I create a repository for each web site, and another for each flex project? What if I have multiple coldfusion applications residing on a given web site (for example, www.it.dev.duke.edu has *MANY* applications) ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Subversion questions
It seems as though your repository structure is working well for you, it seems the only problem is the project properties. I'm assuming for your flex projects that you are using eclipse, which creates .project files. This can wreak havoc if people have the workstations set up differently and those files are managed by SVN. What you can do to get around this is to use svn:ignore when importing the project. HTH, Rich Kroll -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 8:43 AM To: CF-Talk Subject: OT: Subversion questions So we've been using Subversion to track changes to our web site applications for a few months now, and I don't think we're doing it right when I set up the subversion server originally, I set up a single repository which holds everything we want to maintain version control for... each web site is a subdirectory of the main repository. so on my computer, I have a working copy of the repository that looks like this: D:\work\ads\* (www.it.dev.duke.edu) D:\work\advanceweb\* (advanceweb.ads.duke.edu) D:\work\stockgifts\* (stockgifts.duke.edu) Additionally, all of my flex projects are stored in D:\work\flexProjects\* The problem here of course is that *ALL* of the flex project files are part of version control, including the project properties and such... which seems to make life difficult for having multiple developers working on the same flex application. So... what are the best practices for subversion use? Should I create a repository for each web site, and another for each flex project? What if I have multiple coldfusion applications residing on a given web site (for example, www.it.dev.duke.edu has *MANY* applications) Thanks... Rick -- CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! http://www.cfmbb.org ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Subversion questions
As the book says, there's no right way. They do their best to explain how it works and how others use it, and leave it to you to figure out what works best for you. If the different subdomains are truly separate, with separate developers, I'd be inclined to use different repositories. That way, version numbers would more accurately reflect the work performed. We're using SVN to manage a large code base, but it's all one application with different sub-sections. SVN works well enough for what we're doing, but the real trouble is deployment. What we're looking at doing is using Ant to manage deployment - we need to track the code going to cfusion/customtags, as well as Java classes in runtime/lib and other code outside the webroot. Couple that with dropping code onto dev, beta and production systems that have dissimilar filesystem layouts, and it's tricky. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 8:43 AM To: CF-Talk Subject: OT: Subversion questions So we've been using Subversion to track changes to our web site applications for a few months now, and I don't think we're doing it right when I set up the subversion server originally, I set up a single repository which holds everything we want to maintain version control for... each web site is a subdirectory of the main repository. so on my computer, I have a working copy of the repository that looks like this: D:\work\ads\* (www.it.dev.duke.edu) D:\work\advanceweb\* (advanceweb.ads.duke.edu) D:\work\stockgifts\* (stockgifts.duke.edu) Additionally, all of my flex projects are stored in D:\work\flexProjects\* The problem here of course is that *ALL* of the flex project files are part of version control, including the project properties and such... which seems to make life difficult for having multiple developers working on the same flex application. So... what are the best practices for subversion use? Should I create a repository for each web site, and another for each flex project? What if I have multiple coldfusion applications residing on a given web site (for example, www.it.dev.duke.edu has *MANY* applications) Thanks... Rick -- CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! http://www.cfmbb.org ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Subversion questions
On Monday 02 Apr 2007, Rick Root wrote: The problem here of course is that *ALL* of the flex project files are part of version control, including the project properties and such... which seems to make life difficult for having multiple developers working on the same flex application. So add them to svn:ignore then. So... what are the best practices for subversion use? Should I create a repository for each web site, and another for each flex project? Yes, I think it best to split out the Flex from the HTML/ColdFusion/PHP. We tend to have XXX-client and XXX-server projects for any given application, both just hung off the svnroot. Also, you've read: http://svnbook.red-bean.com/nightly/en/svn.branchmerge.using.html right ? What if I have multiple coldfusion applications residing on a given web site (for example, www.it.dev.duke.edu has *MANY* applications) I'd go with svnroot/customer/sitename/appname or svnroot/sitename/appname though if you sell the same app to many people, svnroot/appname might be better. -- Tom Chiverton Helping to adaptively harvest leading-edge developments on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Random Pick records from a 10k record table via SQL
Why isnt it? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:53 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Not sure how that works Russ, thats not very random? On 3/22/07, Russ [EMAIL PROTECTED] wrote: Not sure about mysql. In SQL server I would do something like this: Select top 20 * from table order by newId() Russ -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:25 AM To: CF-Talk Subject: How to Random Pick records from a 10k record table via SQL Hello All, I am wondering how to randomly pick any 20 records from a table of 10,000+ records, directly from a cfquery? Currently using mySQL. Any suggestions will be appreciated. Michael ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Just checking
It was my mail server. I had webmail set up to filter content into directories and apparently only the inbox will pop... neat -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Sunday, April 01, 2007 11:10 AM To: CF-Talk Subject: Just checking I havent seen any activity on the list in a few days. Just testing -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.24/741 - Release Date: 3/31/2007 8:54 PM ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Random Pick records from a 10k record table via SQL
You could get Max and Min ID's from your database, then get #randRange(minFromDB, maxFromDB)#? Chris -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:55 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL Why isn't it? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:53 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Not sure how that works Russ, thats not very random? On 3/22/07, Russ [EMAIL PROTECTED] wrote: Not sure about mysql. In SQL server I would do something like this: Select top 20 * from table order by newId() Russ -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:25 AM To: CF-Talk Subject: How to Random Pick records from a 10k record table via SQL Hello All, I am wondering how to randomly pick any 20 records from a table of 10,000+ records, directly from a cfquery? Currently using mySQL. Any suggestions will be appreciated. Michael ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to Random Pick records from a 10k record table via SQL
Just selecte top 20 like russ said and order by rand() instead of newId() -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:05 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL You could get Max and Min ID's from your database, then get #randRange(minFromDB, maxFromDB)#? Chris -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:55 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL Why isn't it? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:53 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Not sure how that works Russ, thats not very random? On 3/22/07, Russ [EMAIL PROTECTED] wrote: Not sure about mysql. In SQL server I would do something like this: Select top 20 * from table order by newId() Russ -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:25 AM To: CF-Talk Subject: How to Random Pick records from a 10k record table via SQL Hello All, I am wondering how to randomly pick any 20 records from a table of 10,000+ records, directly from a cfquery? Currently using mySQL. Any suggestions will be appreciated. Michael ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to Random Pick records from a 10k record table via SQL
Just selecte top 20 like russ said and order by rand() instead of newId() Correct me if I'm wrong, by all means, but selecting the top 20 from 10,000 records is about as far from random as you can be, isn't it? Won't you have to: 1. randomly select a record with some kind of rand() function of your choosing. (either your SQL or CF) 2. check to ensure that you haven't already selected that record 3. if duplicate entry, go back to 1 4. repeat until 20 records are selected 5. stop I mean, it's a little more complicated to *really* randomly select 20 records from 10,000, but it's certainly not hard with some kind of iteration over that process, right? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to Random Pick records from a 10k record table via SQL
when I use select top 20 ID, rand() as oID from table order by oID I get the 20 rows all with the same oID and basically all in a row; not so random. When I use newID instead, I get records from all over my 10k populated table. MsSQL 2005 -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 9:34 To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL Just selecte top 20 like russ said and order by rand() instead of newId() -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:05 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL You could get Max and Min ID's from your database, then get #randRange(minFromDB, maxFromDB)#? Chris -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:55 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL Why isn't it? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:53 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Not sure how that works Russ, thats not very random? On 3/22/07, Russ [EMAIL PROTECTED] wrote: Not sure about mysql. In SQL server I would do something like this: Select top 20 * from table order by newId() Russ -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:25 AM To: CF-Talk Subject: How to Random Pick records from a 10k record table via SQL Hello All, I am wondering how to randomly pick any 20 records from a table of 10,000+ records, directly from a cfquery? Currently using mySQL. Any suggestions will be appreciated. Michael ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Random Pick records from a 10k record table via SQL
What they are saying is basically adding a column to your query that will be a random string (rand or newid shown) and then order by this column and you should have a list created that is quite random in nature. (though rand() doesn't appear to work that well) fast and straight forward and you don't have to worry about doing iterations and not selecting the same row. never had a need like this so I have been playing with it myself. interesting. -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 9:45 To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Just selecte top 20 like russ said and order by rand() instead of newId() Correct me if I'm wrong, by all means, but selecting the top 20 from 10,000 records is about as far from random as you can be, isn't it? Won't you have to: 1. randomly select a record with some kind of rand() function of your choosing. (either your SQL or CF) 2. check to ensure that you haven't already selected that record 3. if duplicate entry, go back to 1 4. repeat until 20 records are selected 5. stop I mean, it's a little more complicated to *really* randomly select 20 records from 10,000, but it's certainly not hard with some kind of iteration over that process, right? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
maxlength on text area - how to approximate
Does anybody have a really good way to create the equal of maxlength on a text area? The server running site in question is only running CF 6 something, not 7, so cftextarea won't work... I've tried a couple of javascript ideas, and as long as you're typing input, it works. But, everything I tried so far will allow pasting more than the max set. I'm checking server side before the data insert, but the client wants to see something client side while the form is being filled out. Ideas? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to Random Pick records from a 10k record table via SQL
The newID() function generates a new identifier for the rows in the table. So when you order by newID(), it is ordering the records in the table by a new database generated and unique ID that will change with each query. The select top 20 is simply limiting the return to 20 records. It will not necessarily be the first 20 records in the table, rather the first 20 records with respect to the new identifier. Since the identifier will change each time, the 20 returned records will change each time. The merits if the randomness of the newID() function is debatable. But for all intents and purposes you will get random results. I'm pretty sure this is the preferred method of getting random records from a table in SQL Server. Steve -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:45 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Just selecte top 20 like russ said and order by rand() instead of newId() Correct me if I'm wrong, by all means, but selecting the top 20 from 10,000 records is about as far from random as you can be, isn't it? Won't you have to: 1. randomly select a record with some kind of rand() function of your choosing. (either your SQL or CF) 2. check to ensure that you haven't already selected that record 3. if duplicate entry, go back to 1 4. repeat until 20 records are selected 5. stop I mean, it's a little more complicated to *really* randomly select 20 records from 10,000, but it's certainly not hard with some kind of iteration over that process, right? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: maxlength on text area - how to approximate
I've tried a couple of javascript ideas, and as long as you're typing input, it works. But, everything I tried so far will allow pasting more than the max set. http://www.massimocorner.com/validator/samples/generic.htm This is part of a whole validation library: http://www.massimocorner.com/validator/index.htm Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to Random Pick records from a 10k record table via SQL
[snip] The merits if the randomness of the newID() function is debatable. But for all intents and purposes you will get random results. I'm pretty sure this is the preferred method of getting random records from a table in SQL Server. Hey that's pretty cool. I've never messed with newID() before... What other reasons would someone have for even messing with that function? I've never run across a reason in real life where I've needed something like that... ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: maxlength on text area - how to approximate
Do an additional check onsubmit. That way, even if they paste more than you want to allow, it will get caught client-side. --Ben Doom http://www.bendoom.com Les Mizzell wrote: Does anybody have a really good way to create the equal of maxlength on a text area? The server running site in question is only running CF 6 something, not 7, so cftextarea won't work... I've tried a couple of javascript ideas, and as long as you're typing input, it works. But, everything I tried so far will allow pasting more than the max set. I'm checking server side before the data insert, but the client wants to see something client side while the form is being filled out. Ideas? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: maxlength on text area - how to approximate
Can you do an onblur on the field and call a JS function to get the length? Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 Les Mizzell wrote: Does anybody have a really good way to create the equal of maxlength on a text area? The server running site in question is only running CF 6 something, not 7, so cftextarea won't work... I've tried a couple of javascript ideas, and as long as you're typing input, it works. But, everything I tried so far will allow pasting more than the max set. I'm checking server side before the data insert, but the client wants to see something client side while the form is being filled out. Ideas? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: maxlength on text area - how to approximate
script type=text/javascript !-- Begin function textCounter(field, countfield, maxlimit) { if (field.value.length maxlimit) // if too long...trim it! field.value = field.value.substring(0, maxlimit); // otherwise, update 'characters left' counter else countfield.value = maxlimit - field.value.length; } // End -- /script textarea name=gbmessage wrap=physical class=formveld rows=6 cols=42 onKeyDown=textCounter(this.form.gbmessage,this.form.remLen,300); onKeyUp=textCounter(this.form.gbmessage,this.form.remLen,300);/texta rea Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 11:59 AM To: CF-Talk Subject: maxlength on text area - how to approximate Does anybody have a really good way to create the equal of maxlength on a text area? The server running site in question is only running CF 6 something, not 7, so cftextarea won't work... I've tried a couple of javascript ideas, and as long as you're typing input, it works. But, everything I tried so far will allow pasting more than the max set. I'm checking server side before the data insert, but the client wants to see something client side while the form is being filled out. Ideas? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT ISAPI Rewrite
Neil, It can be daunting with Apache when you need to start fiddling with the config by hand and I can see why someone would shy away from it back to IIS. If Apache had a GUI like this (I never found one when I was working on it) it would be great but not make it any better or superior.. Apache has several GUI editors most notably Webmin and ApacheConf. I have never found a need for one however, as the configuration files are well commented, and the online help is pretty easy to use. I am not sure what you mean about managing / storing configuration files in Source Control, control log files or use authentication other than AD... All are certainly possibly and bread and butter stuff to IIS. From these comments, I would suggest it is you who goes down the research route and objectively look at IIS rather than letting your obvious prejudice get in the way. If you want to back up IIS configuration, you need to use a special program to back it up, while with Apache you can just back up the configuration folder with any backup software you choose. With Apache, you can store your configuration files in subversion, and easily replicate your configuration throughout the enterprise, while with IIS, even if this is possible, it will surely require some expensive MS or third party solution. You can't really control log files as far as I know in IIS. Yes, you can pick the folder where you will store all the log files for all your sites, and you can pick the general formats and some of the fields, but you can't choose the exact folder and the file name of the log files, or when they will be rotated. Personally I prefer having my log files be c:\logs\sitename.com\sitename-ddmm.log, instead of being c:\logs\W3SVC1258012117\exddmmyy.log. There are also other things that IIS can't do out of the box. URL rewriting is a huge thing. Mod_rewrite is free, and well supported, while with IIS, you have to go with third party solutions. Apache also supports wildcards in many places out of the box, while with IIS, you can't even do simple things like *.domain.com to offer custom subdomains, because IIS (even version 7) doesn't support wildcards in hostheaders. The only way to do this is to dedicate an IP to the virtual server, which IMHO is overkill. I did find Apache served pages faster than IIS during load testing etc. I haven't tested this with recent versions of IIS, but in the past we've also found Apache to be faster. Also, if you want to use .NET, AFAIK the only supported route is to use IIS. Mod_mono allows you to run .NET pages on many different platforms including windows and linux. Mod_aspdotnet is another third party module that runs ..NET apps albeit on windows only. My biggest point of note with using Apache was that if I used it daily I wouldn't want to use it with JRUn, I would want to use Tomcat, but last time I checked the latter was not suported by Adobe. I did dabble with getting Tomcat to talk to ColdFusion either via the APR within Tomcat and also via a mod connector to Apache, it was a nightmare, it worked but it wasn't easy. We use it with JRUN, but you can use it with any other server by using proxying, even if a connector is not available. You can, for example, use proxying instead of mod_jrun and use the internal JRUN webserver. The last point of note was that nearly all of the stuff on Apache is based around non-Wndows platforms which can make it hard to debug. I am not saying there are no resources just that a Google displayed more non-Windows results so you can see why that is not attractive to the inquisitive web server searcher... It's true that Apache was originally written for Unix/Linux, but with version 2.0, it has been rewritten to be totally OS agnostic. I find it easier to debug, as you can just open up the error log, or run the apache binary in a command prompt to see what the problem is. Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: maxlength on text area - how to approximate
function checkLength(textarea) { var maxLength = 10; if (textarea.innerHTML.length maxLength) { textarea.innerHTML = textarea.innerHTML.substring(0, maxLength); } } Do that onkeydown and onblur and it should be good enough? Does anybody have a really good way to create the equal of maxlength on a text area? The server running site in question is only running CF 6 something, not 7, so cftextarea won't work... I've tried a couple of javascript ideas, and as long as you're typing input, it works. But, everything I tried so far will allow pasting more than the max set. I'm checking server side before the data insert, but the client wants to see something client side while the form is being filled out. Ideas? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
Again, this is where you need to do your research. Within IIS you can change not only the name of the log file (though it uses W3C Extended Log File Format), but also where it goes and how often it rotates etc. You can export and backup a metabase via right-click Backup / Restore Configuration...doesn't get any simpler than that and all out of the box. Mod_mono allows you to run .NET pages on many different platforms including windows and linux. Mod_aspdotnet is another third party module that runs ...NET apps albeit on windows only. I said, supported, these are not supported...by Microsoft. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 02 April 2007 16:26 To: CF-Talk Subject: RE: OT ISAPI Rewrite Neil, It can be daunting with Apache when you need to start fiddling with the config by hand and I can see why someone would shy away from it back to IIS. If Apache had a GUI like this (I never found one when I was working on it) it would be great but not make it any better or superior.. Apache has several GUI editors most notably Webmin and ApacheConf. I have never found a need for one however, as the configuration files are well commented, and the online help is pretty easy to use. I am not sure what you mean about managing / storing configuration files in Source Control, control log files or use authentication other than AD... All are certainly possibly and bread and butter stuff to IIS. From these comments, I would suggest it is you who goes down the research route and objectively look at IIS rather than letting your obvious prejudice get in the way. If you want to back up IIS configuration, you need to use a special program to back it up, while with Apache you can just back up the configuration folder with any backup software you choose. With Apache, you can store your configuration files in subversion, and easily replicate your configuration throughout the enterprise, while with IIS, even if this is possible, it will surely require some expensive MS or third party solution. You can't really control log files as far as I know in IIS. Yes, you can pick the folder where you will store all the log files for all your sites, and you can pick the general formats and some of the fields, but you can't choose the exact folder and the file name of the log files, or when they will be rotated. Personally I prefer having my log files be c:\logs\sitename.com\sitename-ddmm.log, instead of being c:\logs\W3SVC1258012117\exddmmyy.log. There are also other things that IIS can't do out of the box. URL rewriting is a huge thing. Mod_rewrite is free, and well supported, while with IIS, you have to go with third party solutions. Apache also supports wildcards in many places out of the box, while with IIS, you can't even do simple things like *.domain.com to offer custom subdomains, because IIS (even version 7) doesn't support wildcards in hostheaders. The only way to do this is to dedicate an IP to the virtual server, which IMHO is overkill. I did find Apache served pages faster than IIS during load testing etc. I haven't tested this with recent versions of IIS, but in the past we've also found Apache to be faster. Also, if you want to use .NET, AFAIK the only supported route is to use IIS. Mod_mono allows you to run .NET pages on many different platforms including windows and linux. Mod_aspdotnet is another third party module that runs ...NET apps albeit on windows only. My biggest point of note with using Apache was that if I used it daily I wouldn't want to use it with JRUn, I would want to use Tomcat, but last time I checked the latter was not suported by Adobe. I did dabble with getting Tomcat to talk to ColdFusion either via the APR within Tomcat and also via a mod connector to Apache, it was a nightmare, it worked but it wasn't easy. We use it with JRUN, but you can use it with any other server by using proxying, even if a connector is not available. You can, for example, use proxying instead of mod_jrun and use the internal JRUN webserver. The last point of note was that nearly all of the stuff on Apache is based around non-Wndows platforms which can make it hard to debug. I am not saying there are no resources just that a Google displayed more non-Windows results so you can see why that is not attractive to the inquisitive web server searcher... It's true that Apache was originally written for Unix/Linux, but with version 2.0, it has been rewritten to be totally OS agnostic. I find it easier to debug, as you can just open up the error log, or run the apache binary in a command prompt to see what the problem is. Russ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive:
Re: OT: Subversion questions
On 4/2/07, Tom Chiverton [EMAIL PROTECTED] wrote: What if I have multiple coldfusion applications residing on a given web site (for example, www.it.dev.duke.edu has *MANY* applications) I'd go with svnroot/customer/sitename/appname or svnroot/sitename/appname though if you sell the same app to many people, svnroot/appname might be better. Well, we're not so much a commercial shop... we develop applications internally for our own purposes. The tricky part is cases where applications share files for example, I have an include directory at my web root which contains images, css files, and a few cfm files that are used not only across various applications within the main web site, but across multiple web sites as well through the use of IIS virtual directories and coldfusion mappings. I've also gone back in forth between locating cfcs within the application architecture ( /tools/appname ) and within a shared components directory structure that is accessible to multiple web sites as well through coldfusion mappings. Right now, my working copy directory structure mimics my Inetpub folder on the server ... ie... E:\Inetpub\ads E:\Inetpub\stockgifts E:\Inetpub\giftrecords And my working copy is all in D:\work ... D:\work\ads, D:\work\stockgifts, etc. Maybe it would be a better idea to create a repository for individual applications and try to mimic the directory structure within those applications.. For example... let's say I have a simple staff directory application that resides in E:\Inetpub\ads\tools\directory Maybe I'd create a repository, and locate it at D:\work\directory And inside ... D:\work\directory\ads\tools\directory Where everything starting with ads would be relative to the Inetpub folder on the server... Rick -- CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! http://www.cfmbb.org ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: SQL Question
The following query is slow. I'd like to speed it up a bit. Any suggestions would be appreciated. SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F LEFT OUTER JOIN v_sae_jna_mr M ON F.recordthread = M.i_recordThread WHERE (M.i_recid IS NULL) Basically, the query is looking for items in one table that have not been marked in another table. I have done this before but don't ever remember it being this slow. I can probably figure this out on my own at some point, but the mental block I have now may take several days to work out. Thanks. J ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Question
Wold moving the M.i_recid IS NULL to the JOIN help? SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F LEFT OUTER JOIN v_sae_jna_mr M ON F.recordthread = M.i_recordThread AND M.i_recid IS NULL Adrian -Original Message- From: Jerry Barnes [mailto:[EMAIL PROTECTED] Sent: 02 April 2007 17:22 To: CF-Talk Subject: OT: SQL Question The following query is slow. I'd like to speed it up a bit. Any suggestions would be appreciated. SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F LEFT OUTER JOIN v_sae_jna_mr M ON F.recordthread = M.i_recordThread WHERE (M.i_recid IS NULL) Basically, the query is looking for items in one table that have not been marked in another table. I have done this before but don't ever remember it being this slow. I can probably figure this out on my own at some point, but the mental block I have now may take several days to work out. Thanks. J ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Question
How about something like this: SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F WHERE NOT EXISTS (SELECT 1 FROM v_sae_jna_mr WHERE recid=F.recordthread) Not sure it'll be much faster, but it's worth a try. Cheers, Kris The following query is slow. I'd like to speed it up a bit. Any suggestions would be appreciated. SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F LEFT OUTER JOIN v_sae_jna_mr M ON F.recordthread = M.i_recordThread WHERE (M.i_recid IS NULL) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Application.cfc and cflocation
Hi, I thought that the error triggered when using cflocation in Application.cfcwas fixed in version 7.01 I'm using 7,0,2,142559 and still have the problem. It was reintroduced in 7.02? do I need to apply a specific fix for it? Thank you Victor ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: SQL Question
whats not being asked is how big is the dataset, what type of hardware, how do you know its running slow? compared to what? I mean if you have a million records on a Pentium 2 with 128m of ram, your going to have less then average response time. also are the CF server and DB server on the same LAN? I think the sql statement you have is just about as straight forward as you are going to get. how long does a straight SELECT * FROM F INNER JOIN M taking?? -Original Message- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 11:43 To: CF-Talk Subject: Re: OT: SQL Question How about something like this: SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F WHERE NOT EXISTS (SELECT 1 FROM v_sae_jna_mr WHERE recid=F.recordthread) Not sure it'll be much faster, but it's worth a try. Cheers, Kris The following query is slow. I'd like to speed it up a bit. Any suggestions would be appreciated. SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F LEFT OUTER JOIN v_sae_jna_mr M ON F.recordthread = M.i_recordThread WHERE (M.i_recid IS NULL) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Question
On what engine? If this is MSSQL, try running the query tuning advisor. There maybe some updates to indexes or statistics that will speed it up. -Original Message- From: Jerry Barnes [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 12:22 PM To: CF-Talk Subject: OT: SQL Question The following query is slow. I'd like to speed it up a bit. Any suggestions would be appreciated. SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F LEFT OUTER JOIN v_sae_jna_mr M ON F.recordthread = M.i_recordThread WHERE (M.i_recid IS NULL) Basically, the query is looking for items in one table that have not been marked in another table. I have done this before but don't ever remember it being this slow. I can probably figure this out on my own at some point, but the mental block I have now may take several days to work out. Thanks. J ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Another Subversion Question
I use the ever present BlogCFC for a couple of blogs. Each blog has a little bit different layout, but that's about it. I'm trying to figure out how I could set up the Subversion repository and include Ray's subversion repository to be something like this: /trunk/(Ray's SVN - still updateable whenever Ray does an update) /local/(My tweaks to the actual cfc - mainly allowing for ldap authentication) /blog1/(a copy from local/client - with site customizations) /blog2/(same as above) /blogN+1/ I want to be able to update my /local/ copy of blogCFC whenever Ray does a security update, but I don't want to lose my changes. As with the individual blog site, whenever there's an update, I want to be able to roll these down to each site. Currently I'm using SVK, but it doesn't have the tool support of SVN such as tortoiseSVN, Subclipse, etc. Can subversion do something like this? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Question
Has the i_recid field in the v_sae_jna_mr table been indexed? If your table is very large, this could slow your performance. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
Again, this is where you need to do your research. Within IIS you can change not only the name of the log file (though it uses W3C Extended Log File Format), but also where it goes and how often it rotates etc. I can set the general folder where the log files for ALL of the virtual sites are stored in subfolders, but I do not see an option to set the name of the subfolder for my site, or the name of the file. I'm using IIS 6. Can you enlighten me on how to change these parameters? You can export and backup a metabase via right-click Backup / Restore Configuration...doesn't get any simpler than that and all out of the box. I'm sure you would love to backup the configuration every time you make a change. I prefer not having to do the extra step. Don't forget that to do anything even slightly advanced in IIS, you have to edit the metabase by hand (such as to enable compression), or edit the config files for third party modules such as ISAPI rewrite. Mod_mono allows you to run .NET pages on many different platforms including windows and linux. Mod_aspdotnet is another third party module that runs ...NET apps albeit on windows only. I said, supported, these are not supported...by Microsoft. How many times have you or anyone in your company actually received good support from Microsoft? In my experience, you will usually receive faster and better support on open source mailing lists. Plus there's always the option of running IIS and Apache side by side, and having them listen on different IPs, should you need IIS for some of the sites for some reason. Russ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Fax software
I just upgraded to windows 2003 server and found that I cannot install the print drivers for winfax. Does anyone know of a comparable product that supports 2k3 server? Thanks Doug ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL DatePart function not working in cfquery...
I am trying to use the DatePart() function as part of a normal SQL query using Access DB. The SQL statement is formatted correctly to extract a month from a date field in the DB, and the SQL tests fine in Access. However, it does not work in cfquery. I then realized that CF uses the same function as part of its own reserved function library. Looks and works pretty much the same as the SQL version, except the reference shows it primarily to format output of Date/Time and NOT used in SQL. I would like to use it to sort by month and year. How can I use this in a SQL statement without CF thinking that it owns the function? ...what am I missing here? Kevin ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL DatePart function not working in cfquery...
On 4/2/07, Kevin Bales [EMAIL PROTECTED] wrote: I am trying to use the DatePart() function as part of a normal SQL query using Access DB. The SQL statement is formatted correctly to extract a month from a date field in the DB, and the SQL tests fine in Access. However, it does not work in cfquery. I then realized that CF uses the same function as part of its own reserved function library. Looks and works pretty much the same as the SQL version, except the reference shows it primarily to format output of Date/Time and NOT used in SQL. I would like to use it to sort by month and year. How can I use this in a SQL statement without CF thinking that it owns the function? ...what am I missing here? if it's not in pound signs, CF won't think that it owns the function. can you paste the code you're using and specify how it does not work in cfquery? -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: maxlength on text area - how to approximate
http://www.massimocorner.com/validator/samples/generic.htm I've had great luck with the validator on regular HTML forms, but not much luck on a cfform ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Active X controls close browser
We have a site that uses ActiveX controls to create tabs for navigation purposes. About a year ago Microsoft made a change in IE 6 that causes IE to now close when this site is accessed. We've been able to get by using Windows Explorer to open the site but would like to rewrite things a bit to remove the Active X controls altogether so we could use IE again. The application uses MX 7. We've used the CFFORMGROUP tag but have run into a few snags with it. Anyone have any experience creating tabs in CF? If so, how did you create them? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Active X controls close browser
This is not CF, but regular DHTML. I used this in a site that just went live today: http://www.dynamicdrive.com/dynamicindex1/ddtabmenu.htm On 4/2/07, Tom Garber [EMAIL PROTECTED] wrote: We have a site that uses ActiveX controls to create tabs for navigation purposes. About a year ago Microsoft made a change in IE 6 that causes IE to now close when this site is accessed. We've been able to get by using Windows Explorer to open the site but would like to rewrite things a bit to remove the Active X controls altogether so we could use IE again. The application uses MX 7. We've used the CFFORMGROUP tag but have run into a few snags with it. Anyone have any experience creating tabs in CF? If so, how did you create them? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT ISAPI Rewrite
Well you can easily just create a logs/[sitename]/logfile structure in IIS and point each site to their corresponding log folder, we do it all the time. Why is it an extra step to do that backup process? Of which can be automated anyhow. We get very good support from Microsoft as and when we need thanks, we are a big customer of theirs :-) I am still yet to find a decent argument on why anyone should use Apache over IIS from your chosen arguments. True there is URL rewriting but then again, maybe you shouldn't need to do this if your website structures are friendly out of the box :-) This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Apr 02 18:10:35 2007 Subject: RE: OT ISAPI Rewrite Again, this is where you need to do your research. Within IIS you can change not only the name of the log file (though it uses W3C Extended Log File Format), but also where it goes and how often it rotates etc. I can set the general folder where the log files for ALL of the virtual sites are stored in subfolders, but I do not see an option to set the name of the subfolder for my site, or the name of the file. I'm using IIS 6. Can you enlighten me on how to change these parameters? You can export and backup a metabase via right-click Backup / Restore Configuration...doesn't get any simpler than that and all out of the box. I'm sure you would love to backup the configuration every time you make a change. I prefer not having to do the extra step. Don't forget that to do anything even slightly advanced in IIS, you have to edit the metabase by hand (such as to enable compression), or edit the config files for third party modules such as ISAPI rewrite. Mod_mono allows you to run .NET pages on many different platforms including windows and linux. Mod_aspdotnet is another third party module that runs ...NET apps albeit on windows only. I said, supported, these are not supported...by Microsoft. How many times have you or anyone in your company actually received good support from Microsoft? In my experience, you will usually receive faster and better support on open source mailing lists. Plus there's always the option of running IIS and Apache side by side, and having them listen on different IPs, should you need IIS for some of the sites for some reason. Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: maxlength on text area - how to approximate
http://www.massimocorner.com/validator/samples/generic.htm I've had great luck with the validator on regular HTML forms, but not much luck on a cfform Sure, cfform overwrite too many things, making harder to put other solutions in the mix. Massimo ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: SQL Question
Jerry Barnes wrote: The following query is slow. I'd like to speed it up a bit. Any suggestions would be appreciated. SELECT F.pid, F.acrostic, F.recid, F.recordthread, F.aed_onset, F.d_form FROM vfrm_sae F LEFT OUTER JOIN v_sae_jna_mr M ON F.recordthread = M.i_recordThread WHERE (M.i_recid IS NULL) How does the execution plan look? ISTM you want a mergejoin with vfrm_sae as the driving table and v_sae_jna_mr as the inner table. If your execution plan shows differently, make sure you have clustered indexes on recordthread and i_recordThread and try again. Jochem ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
Well you can easily just create a logs/[sitename]/logfile structure in IIS and point each site to their corresponding log folder, we do it all the time. I'm still not seeing how to do this. I guess I can theoretically point each website to an individual folder, but then it will still create something like W3SVCX\exyymmdd.log. You don't have any control over this part. You also don't have control on what time the log file rolls over. Sure most people prefer 12am, but what if your servers are in a different time zone and you want it to roll over 11pm or 1am? Why is it an extra step to do that backup process? Of which can be automated anyhow. It is an extra step, whether you automate it or not. With Apache, it's just plain text files, and you can back them up without worry. You can also create a folder with all the virtual site configurations and have them generated automatically by coldfusion. For example, you can have a folder named vsites and you can have files such as sitename.com.conf which just needs to contain something like this: VirtualHost *:80 ServerName *.example.com DocumentRoot c:/websites/example.com/ /VirtualHost You can specify other options such as per site logging, but nothing else needs to be specified. I have just create a virtual site which will host all the subdomains for example.com, including www.example.com and user1.example.com and site2.example.com, etc. Try doing same with IIS without dedicating an IP to the site. You can have a directive in the main configuration file to include all the config files in this directory. Include conf/vsites/*.conf Voila. Have cf generate the text file, and restart apache to refresh the config, and you have just create an easy way to automatically create virtual sites. I wonder how long it would take you to do the same thing with IIS? We get very good support from Microsoft as and when we need thanks, we are a big customer of theirs :-) I am still yet to find a decent argument on why anyone should use Apache over IIS from your chosen arguments. True there is URL rewriting but then again, maybe you shouldn't need to do this if your website structures are friendly out of the box :-) It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. Also lets say that someone else logs onto the box, and makes some configuration changes and breaks something. Do you know what they changed? Do you know how to fix it? Do you feel confident enough to restore from backup? With apache, you can keep the configuration in subversion, and know EXACTLY what was changed since last commit. You can revert the changes, roll back to a previous version, and all the other goodies that come with SVN. Apache is a developer's web server. It turns the web server into something you can write code for. I, for one, want to see all the configuration details of a particular site right in front of me, without having to flip through 20 different tabs. Russ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT ISAPI Rewrite
Please stop this. I don't care which is better. Nobody (based on an informal survey of 1) cares. I have a preference based 95% on ignorance, with which I am quite happy. I'm not going to spend the rest of my life learning every damn platform just so I can die knowing Russ was right. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 2:33 PM To: CF-Talk Subject: RE: OT ISAPI Rewrite Well you can easily just create a logs/[sitename]/logfile structure in IIS and point each site to their corresponding log folder, we do it all the time. I'm still not seeing how to do this. I guess I can theoretically point each website to an individual folder, but then it will still create something like W3SVCX\exyymmdd.log. You don't have any control over this part. You also don't have control on what time the log file rolls over. Sure most people prefer 12am, but what if your servers are in a different time zone and you want it to roll over 11pm or 1am? Why is it an extra step to do that backup process? Of which can be automated anyhow. It is an extra step, whether you automate it or not. With Apache, it's just plain text files, and you can back them up without worry. You can also create a folder with all the virtual site configurations and have them generated automatically by coldfusion. For example, you can have a folder named vsites and you can have files such as sitename.com.conf which just needs to contain something like this: VirtualHost *:80 ServerName *.example.com DocumentRoot c:/websites/example.com/ /VirtualHost You can specify other options such as per site logging, but nothing else needs to be specified. I have just create a virtual site which will host all the subdomains for example.com, including www.example.com and user1.example.com and site2.example.com, etc. Try doing same with IIS without dedicating an IP to the site. You can have a directive in the main configuration file to include all the config files in this directory. Include conf/vsites/*.conf Voila. Have cf generate the text file, and restart apache to refresh the config, and you have just create an easy way to automatically create virtual sites. I wonder how long it would take you to do the same thing with IIS? We get very good support from Microsoft as and when we need thanks, we are a big customer of theirs :-) I am still yet to find a decent argument on why anyone should use Apache over IIS from your chosen arguments. True there is URL rewriting but then again, maybe you shouldn't need to do this if your website structures are friendly out of the box :-) It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. Also lets say that someone else logs onto the box, and makes some configuration changes and breaks something. Do you know what they changed? Do you know how to fix it? Do you feel confident enough to restore from backup? With apache, you can keep the configuration in subversion, and know EXACTLY what was changed since last commit. You can revert the changes, roll back to a previous version, and all the other goodies that come with SVN. Apache is a developer's web server. It turns the web server into something you can write code for. I, for one, want to see all the configuration details of a particular site right in front of me, without having to flip through 20 different tabs. Russ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iSeries point to ColdFusion server direction...
I hope someone can point me in the right direction or fill me in... Currently where I work we donât use ColdFusion but Iâm putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donât want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iSeries point to ColdFusion server direction...
I found an article on Adobe's site talking about Distributed configuration but it was for version 5. Anyone have anything newer that they've seen and what I would need to do to the Apache on the iSeries to point correctly to ColdFusion on W2K3? Thanks. I hope someone can point me in the right direction or fill me in... Currently where I work we donât use ColdFusion but Iâm putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donât want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
Dave, This thread was already coming to a close, and your post did not add anything constructive. If you are too lazy to learn other platforms, that's your prerogative, and you're welcome to ignore this whole thread. That's how a mailing list works - if you're interested in the thread, you read it, if not, you skip it. Posting comments saying that you're not interested in a particular thread doesn't help anybody. Russ -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 4:43 PM To: CF-Talk Subject: RE: OT ISAPI Rewrite Please stop this. I don't care which is better. Nobody (based on an informal survey of 1) cares. I have a preference based 95% on ignorance, with which I am quite happy. I'm not going to spend the rest of my life learning every damn platform just so I can die knowing Russ was right. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 2:33 PM To: CF-Talk Subject: RE: OT ISAPI Rewrite Well you can easily just create a logs/[sitename]/logfile structure in IIS and point each site to their corresponding log folder, we do it all the time. I'm still not seeing how to do this. I guess I can theoretically point each website to an individual folder, but then it will still create something like W3SVCX\exyymmdd.log. You don't have any control over this part. You also don't have control on what time the log file rolls over. Sure most people prefer 12am, but what if your servers are in a different time zone and you want it to roll over 11pm or 1am? Why is it an extra step to do that backup process? Of which can be automated anyhow. It is an extra step, whether you automate it or not. With Apache, it's just plain text files, and you can back them up without worry. You can also create a folder with all the virtual site configurations and have them generated automatically by coldfusion. For example, you can have a folder named vsites and you can have files such as sitename.com.conf which just needs to contain something like this: VirtualHost *:80 ServerName *.example.com DocumentRoot c:/websites/example.com/ /VirtualHost You can specify other options such as per site logging, but nothing else needs to be specified. I have just create a virtual site which will host all the subdomains for example.com, including www.example.com and user1.example.com and site2.example.com, etc. Try doing same with IIS without dedicating an IP to the site. You can have a directive in the main configuration file to include all the config files in this directory. Include conf/vsites/*.conf Voila. Have cf generate the text file, and restart apache to refresh the config, and you have just create an easy way to automatically create virtual sites. I wonder how long it would take you to do the same thing with IIS? We get very good support from Microsoft as and when we need thanks, we are a big customer of theirs :-) I am still yet to find a decent argument on why anyone should use Apache over IIS from your chosen arguments. True there is URL rewriting but then again, maybe you shouldn't need to do this if your website structures are friendly out of the box :-) It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. Also lets say that someone else logs onto the box, and makes some configuration changes and breaks something. Do you know what they changed? Do you know how to fix it? Do you feel confident enough to restore from backup? With apache, you can keep the configuration in subversion, and know EXACTLY what was changed since last commit. You can revert the changes, roll back to a previous version, and all the other goodies that come with SVN. Apache is a developer's web server. It turns the web server into something you can write code for. I, for one, want to see all the configuration details of a particular site right in front of me, without having to flip through 20 different tabs. Russ ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: iSeries point to ColdFusion server direction...
Bob, I'm not familiar with the iSeries Apache Web server, but if you are using a standard apache web server, you would use the wsconfig program that gets installed with apache to connect to coldfusion. You can also manually copy over the mod_jrun22.so or mod_jrun2.so files and manually put in the configuration. Something like this: LoadModule jrun_module C:/JRun4/lib/wsconfig/mod_jrun22.so # JRun Settings IfModule mod_jrun22.c JRunConfig Verbose true JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore C:/JRun4/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap x.x.x.x:51002 #JRunConfig Errorurl optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 #JRunConfig ConnectTimeout 15 #JRunConfig RecvTimeout 300 #JRunConfig SendTimeout 15 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Hope this helps, Russ -Original Message- From: Bob Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 4:24 PM To: CF-Talk Subject: Re: iSeries point to ColdFusion server direction... I found an article on Adobe's site talking about Distributed configuration but it was for version 5. Anyone have anything newer that they've seen and what I would need to do to the Apache on the iSeries to point correctly to ColdFusion on W2K3? Thanks. I hope someone can point me in the right direction or fill me in... Currently where I work we donââ¬â¢t use ColdFusion but Iââ¬â¢m putting together a presentation as to why we should move to ColdFusion. My question is, how would one setup up an iSeries Apache Web server to use a Windows 2003 Server running ColdFusion for ColdFusion pages. We donââ¬â¢t want to change our main Web server from the iSeries we just want to point to the W2K3 server running ColdFusion when needed. Any info or direction would be appreciated. Thank you Bob ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274348 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Memory issues with new daylight savings update?
Hey all, lately, our server has been having some serious memory issues. We will get a lot of requests (which is normal) and the server can handle them... then, all of a sudden, it seems to choke and the requests start to queue up and the memory (monitoring in SeeFusion) maxes out and will not come down even when the requests die down. We cannot figure out what is going on as we have not done anything special lately. We thought maybe it was the JVM that was updated for the Daylight savings time. Has anyone noticed any memory issues after this update? Our JVM is 1.4.2_12 and we didn't have any of these problems until we upgraded the JVM using updater 7.02. Thanks! .. Ben Nadel Certified Advanced ColdFusion Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com http://www.nylontechnology.com/ ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT ISAPI Rewrite
LOL, my point in essence was that there is no right or wrong choice... , This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Dave Francis To: CF-Talk Sent: Mon Apr 02 21:42:39 2007 Subject: RE: OT ISAPI Rewrite Please stop this. I don't care which is better. Nobody (based on an informal survey of 1) cares. I have a preference based 95% on ignorance, with which I am quite happy. I'm not going to spend the rest of my life learning every damn platform just so I can die knowing Russ was right. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 2:33 PM To: CF-Talk Subject: RE: OT ISAPI Rewrite Well you can easily just create a logs/[sitename]/logfile structure in IIS and point each site to their corresponding log folder, we do it all the time. I'm still not seeing how to do this. I guess I can theoretically point each website to an individual folder, but then it will still create something like W3SVCX\exyymmdd.log. You don't have any control over this part. You also don't have control on what time the log file rolls over. Sure most people prefer 12am, but what if your servers are in a different time zone and you want it to roll over 11pm or 1am? Why is it an extra step to do that backup process? Of which can be automated anyhow. It is an extra step, whether you automate it or not. With Apache, it's just plain text files, and you can back them up without worry. You can also create a folder with all the virtual site configurations and have them generated automatically by coldfusion. For example, you can have a folder named vsites and you can have files such as sitename.com.conf which just needs to contain something like this: VirtualHost *:80 ServerName *.example.com DocumentRoot c:/websites/example.com/ /VirtualHost You can specify other options such as per site logging, but nothing else needs to be specified. I have just create a virtual site which will host all the subdomains for example.com, including www.example.com and user1.example.com and site2.example.com, etc. Try doing same with IIS without dedicating an IP to the site. You can have a directive in the main configuration file to include all the config files in this directory. Include conf/vsites/*.conf Voila. Have cf generate the text file, and restart apache to refresh the config, and you have just create an easy way to automatically create virtual sites. I wonder how long it would take you to do the same thing with IIS? We get very good support from Microsoft as and when we need thanks, we are a big customer of theirs :-) I am still yet to find a decent argument on why anyone should use Apache over IIS from your chosen arguments. True there is URL rewriting but then again, maybe you shouldn't need to do this if your website structures are friendly out of the box :-) It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. Also lets say that someone else logs onto the box, and makes some configuration changes and breaks something. Do you know what they changed? Do you know how to fix it? Do you feel confident enough to restore from backup? With apache, you can keep the configuration in subversion, and know EXACTLY what was changed since last commit. You can revert the changes, roll back to a previous version, and all the other goodies that come with SVN. Apache is a developer's web server. It turns the web server into something you can write code for. I, for one, want to see all the configuration details of a particular site right in front of me, without having to flip through 20 different tabs. Russ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Random Pick records from a 10k record table via SQL
Just try them please. :-) -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:45 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Just selecte top 20 like russ said and order by rand() instead of newId() Correct me if I'm wrong, by all means, but selecting the top 20 from 10,000 records is about as far from random as you can be, isn't it? Won't you have to: 1. randomly select a record with some kind of rand() function of your choosing. (either your SQL or CF) 2. check to ensure that you haven't already selected that record 3. if duplicate entry, go back to 1 4. repeat until 20 records are selected 5. stop I mean, it's a little more complicated to *really* randomly select 20 records from 10,000, but it's certainly not hard with some kind of iteration over that process, right? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Server side validation for checkboxes
I have a form with dynamic checkboxes and radio buttons. They output from my db tables that have tblanswersets (one) and tblanswers (many) I'm grouping some questions, then spitting out these items. It mostly works, except the checkboxes. Right now, my server side validation makes sure ANY group of checkboxes or radio buttons have at least one selection. When the form submits to itself, the values are saved and form items are pre-checked/selected if something's caught in the validation. But my checkboxes get caught if there isn't a selection. I've decided to add a field to tblanswersets - answersetrequired = yes/no I can output that somehow in my form inputs to setup some new validation routine. Thought you guys might have a good way to do this. I'll show you what I'm using now, maybe gimme some pointers/ideas on how to improve this? Thanks, Will !--- Get CORE questions for this eval--- cfquery datasource=#SESSION.DSN# name=getCoreQuestions SELECT tblquestionsets.questionsetid, tblquestionsets.questionsetname, tblquestions.questionid, tblquestions.answersetid, tblquestions.questionsetid, tblquestions.question, tblquestions.questioncatid, tblquestions.questionsortnum, tblquestioncats.questioncatid, tblquestioncats.questioncatname, tblanswersets.answersetid, tblanswersets.answersetname, tblanswersets.answersettypeid, tblanswersets.answersetrequired, tblanswersettypes.answersettypeid, tblanswersettypes.answersettypename, tblanswers.answerid, tblanswers.answername, tblanswers.answervalue, tblanswers.answersortnum, tblanswers.answersetid, tblquestionsets.questionsetdateadded FROM tblquestionsets, tblquestions, tblanswersets, tblanswersettypes, tblanswers, tblquestioncats WHERE tblquestionsets.questionsetID = tblquestions.questionsetID AND tblquestions.answersetID = tblAnswersets.answersetid AND tblanswersets.answersetid = tblanswers.answersetID !--- This will be dynamic in the future. Hard-coded for testing for now --- AND tblquestionsets.questionsetID = 1 !--- We need to just pull CORE questions in this query --- AND tblquestions.questioncatid = 1 AND tblanswersets.answersettypeid = tblanswersettypes.answersettypeid AND tblquestions.questioncatid = tblquestioncats.questioncatid ORDER BY tblquestions.questionsortnum, tblanswers.answersortnum /cfquery !--- Output CORE question query here --- cfoutput query=getCoreQuestions group=questionID cfset ctr = ctr + 1 tr class=background-hilite td align=center width=75 #ctr# /td td#question#/td td style=text-align:center;cfif VARIABLES[Q_question ctr flagged] EQ trueimg src=../images/warningsymbol.gif / /cfif /td td width=200 table align=center width=100% border=0 cellspacing=0 cellpadding=8 tr class=background-hilite !--- Output answers here --- cfoutput td align=center width=25%#answervalue# br / cfif VARIABLES[fieldvalue ctr] EQ #questionID#_#answerID# cfset buttonChecked = yes cfelse cfset buttonChecked = no /cfif cfinput name=Q_question#ctr# type=#answersettypename# value=#questionID#_#answerID# checked=#buttonChecked# / /td /cfoutput /tr /table /td /tr /cfoutput table width=100% border=0 cellspacing=0 cellpadding=5 summary=x tr class=background-hilite th colspan=6h2Additional Questions/h2/th /tr Then I param the formfields: !--- Param our formfields --- cfoutput query=getCoreQuestions group=questionID cfset selectedctr = selectedctr + 1 cfoutput cfparam name=FORM.Q_question#selectedctr# default= cfparam name=VARIABLES['Q_question' selectedCtr 'selected'] default=no cfparam name=VARIABLES['fieldvalue' selectedCtr] default= cfparam name=VARIABLES['Q_question' selectedCtr 'flagged'] default=false /cfoutput /cfoutput Here's where I setup an errorstruct !--- Start validating data --- cfset errorStruct = StructNew() cfloop from=1 to=#FORM.numQuestions# index=thisNum !--- If the value of this answer is blank, create an error --- cfif NOT Len(FORM[Q_question thisNum]) cfset errorStruct.errormessages[thisNum] = Please make a selection for question #thisNum# cfset VARIABLES[Q_question thisNum flagged] = true
Re: OT ISAPI Rewrite
You just don't get it do you... research... :-) This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Apr 02 20:33:11 2007 Subject: RE: OT ISAPI Rewrite Well you can easily just create a logs/[sitename]/logfile structure in IIS and point each site to their corresponding log folder, we do it all the time. I'm still not seeing how to do this. I guess I can theoretically point each website to an individual folder, but then it will still create something like W3SVCX\exyymmdd.log. You don't have any control over this part. You also don't have control on what time the log file rolls over. Sure most people prefer 12am, but what if your servers are in a different time zone and you want it to roll over 11pm or 1am? Why is it an extra step to do that backup process? Of which can be automated anyhow. It is an extra step, whether you automate it or not. With Apache, it's just plain text files, and you can back them up without worry. You can also create a folder with all the virtual site configurations and have them generated automatically by coldfusion. For example, you can have a folder named vsites and you can have files such as sitename.com.conf which just needs to contain something like this: VirtualHost *:80 ServerName *.example.com DocumentRoot c:/websites/example.com/ /VirtualHost You can specify other options such as per site logging, but nothing else needs to be specified. I have just create a virtual site which will host all the subdomains for example.com, including www.example.com and user1.example.com and site2.example.com, etc. Try doing same with IIS without dedicating an IP to the site. You can have a directive in the main configuration file to include all the config files in this directory. Include conf/vsites/*.conf Voila. Have cf generate the text file, and restart apache to refresh the config, and you have just create an easy way to automatically create virtual sites. I wonder how long it would take you to do the same thing with IIS? We get very good support from Microsoft as and when we need thanks, we are a big customer of theirs :-) I am still yet to find a decent argument on why anyone should use Apache over IIS from your chosen arguments. True there is URL rewriting but then again, maybe you shouldn't need to do this if your website structures are friendly out of the box :-) It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. Also lets say that someone else logs onto the box, and makes some configuration changes and breaks something. Do you know what they changed? Do you know how to fix it? Do you feel confident enough to restore from backup? With apache, you can keep the configuration in subversion, and know EXACTLY what was changed since last commit. You can revert the changes, roll back to a previous version, and all the other goodies that come with SVN. Apache is a developer's web server. It turns the web server into something you can write code for. I, for one, want to see all the configuration details of a particular site right in front of me, without having to flip through 20 different tabs. Russ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to Random Pick records from a 10k record table via SQL
We said to ORDER by the rand() or newID() functions (depending on the platform)... rand() for MySQL and newID() for SQL Server Select top 20 * field from table order by rand() Select top 20 * field from table order by newID() Try them. :-) -Original Message- From: Bader, Terrence C CTR MARMC, 231 [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:52 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL when I use select top 20 ID, rand() as oID from table order by oID I get the 20 rows all with the same oID and basically all in a row; not so random. When I use newID instead, I get records from all over my 10k populated table. MsSQL 2005 -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 9:34 To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL Just selecte top 20 like russ said and order by rand() instead of newId() -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:05 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL You could get Max and Min ID's from your database, then get #randRange(minFromDB, maxFromDB)#? Chris -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:55 AM To: CF-Talk Subject: RE: How to Random Pick records from a 10k record table via SQL Why isn't it? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:53 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Not sure how that works Russ, thats not very random? On 3/22/07, Russ [EMAIL PROTECTED] wrote: Not sure about mysql. In SQL server I would do something like this: Select top 20 * from table order by newId() Russ -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:25 AM To: CF-Talk Subject: How to Random Pick records from a 10k record table via SQL Hello All, I am wondering how to randomly pick any 20 records from a table of 10,000+ records, directly from a cfquery? Currently using mySQL. Any suggestions will be appreciated. Michael ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Random Pick records from a 10k record table via SQL
Correct me if I'm wrong, by all means, but selecting the top 20 from 10,000 records is about as far from random as you can be, isn't it? You are correct... that wouldnt be very random... hence ordering by the built in newID() or rand() functions :-) SQL Server = newID() MySQL = rand() Try them first this time :-) -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 10:45 AM To: CF-Talk Subject: Re: How to Random Pick records from a 10k record table via SQL Just selecte top 20 like russ said and order by rand() instead of newId() Correct me if I'm wrong, by all means, but selecting the top 20 from 10,000 records is about as far from random as you can be, isn't it? Won't you have to: 1. randomly select a record with some kind of rand() function of your choosing. (either your SQL or CF) 2. check to ensure that you haven't already selected that record 3. if duplicate entry, go back to 1 4. repeat until 20 records are selected 5. stop I mean, it's a little more complicated to *really* randomly select 20 records from 10,000, but it's certainly not hard with some kind of iteration over that process, right? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Anyone have quick help - how to refer to a dynamic named query?
I have code generating a dynamic named query, ie getCompanyTractorStats2 getCompanyTractorStats3 I have a CFC that generates a query result, and I assign dynamic names like this: !---// Loop from the 1st of the month to current and create per-day variables //--- cfloop from=1 to=#dateFormat(now(), DD)# index=curDay cftry !---// Call function to get tractor statistics //--- cfset getCompanyTractorStats#curDay# = cfc.getCompanyTractorStats(url.dsn, '#dateFormat(now(), MM)#/' curDay '/#dateFormat(now(), )#') / cfset getOwneropTractorStats#curDay# = cfc.getOwneropTractorStats(url.dsn, '#dateFormat(now(), MM)#/' curDay '/#dateFormat(now(), )#') / cfcatch type=any !--- Ignore errors, that means the file is missing //--- /cfcatch /cftry /cfloop I need to reference the values to specific queries below I am trying #getCompanyTractorStats[curDay].myCol# Trying all combinations of eval and DE, I am tearing my hair out, anyone help me here? Thanks a bunch! Chris Peterson ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anyone have quick help - how to refer to a dynamic named query?
These queries are defined in the Variables scope of the page (or the THIS scope if you are in a CFC): #VARIABLES[ getCompanyTractorStats#curDay# ].myCol# .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 5:01 PM To: CF-Talk Subject: Anyone have quick help - how to refer to a dynamic named query? I have code generating a dynamic named query, ie getCompanyTractorStats2 getCompanyTractorStats3 I have a CFC that generates a query result, and I assign dynamic names like this: !---// Loop from the 1st of the month to current and create per-day variables //--- cfloop from=1 to=#dateFormat(now(), DD)# index=curDay cftry !---// Call function to get tractor statistics //--- cfset getCompanyTractorStats#curDay# = cfc.getCompanyTractorStats(url.dsn, '#dateFormat(now(), MM)#/' curDay '/#dateFormat(now(), )#') / cfset getOwneropTractorStats#curDay# = cfc.getOwneropTractorStats(url.dsn, '#dateFormat(now(), MM)#/' curDay '/#dateFormat(now(), )#') / cfcatch type=any !--- Ignore errors, that means the file is missing //--- /cfcatch /cftry /cfloop I need to reference the values to specific queries below I am trying #getCompanyTractorStats[curDay].myCol# Trying all combinations of eval and DE, I am tearing my hair out, anyone help me here? Thanks a bunch! Chris Peterson ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
-Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Monday, April 02, 2007 4:47 PM To: CF-Talk Subject: Re: OT ISAPI Rewrite You just don't get it do you... research... :-) No, I don't get it. Research what? How to set up the log files the way I want them? I checked the help file, and it's of no use. Unless you're talking about the gimpy way of doing it by having each log file in a folder such as c:\logs\sitename.com\W3SVC. If you do know a better way to do this, as you claim that you do it all the time, why don't you enlighten us, instead of sending me on a wild goose chase? Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anyone have quick help - how to refer to a dynamic named query?
Woohoo, you are the man! That's exactly what I needed sir. Have a great evening! Chris Peterson -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 5:04 PM To: CF-Talk Subject: RE: Anyone have quick help - how to refer to a dynamic named query? These queries are defined in the Variables scope of the page (or the THIS scope if you are in a CFC): #VARIABLES[ getCompanyTractorStats#curDay# ].myCol# ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 5:01 PM To: CF-Talk Subject: Anyone have quick help - how to refer to a dynamic named query? I have code generating a dynamic named query, ie getCompanyTractorStats2 getCompanyTractorStats3 I have a CFC that generates a query result, and I assign dynamic names like this: !---// Loop from the 1st of the month to current and create per-day variables //--- cfloop from=1 to=#dateFormat(now(), DD)# index=curDay cftry !---// Call function to get tractor statistics //--- cfset getCompanyTractorStats#curDay# = cfc.getCompanyTractorStats(url.dsn, '#dateFormat(now(), MM)#/' curDay '/#dateFormat(now(), )#') / cfset getOwneropTractorStats#curDay# = cfc.getOwneropTractorStats(url.dsn, '#dateFormat(now(), MM)#/' curDay '/#dateFormat(now(), )#') / cfcatch type=any !--- Ignore errors, that means the file is missing //--- /cfcatch /cftry /cfloop I need to reference the values to specific queries below I am trying #getCompanyTractorStats[curDay].myCol# Trying all combinations of eval and DE, I am tearing my hair out, anyone help me here? Thanks a bunch! Chris Peterson ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL DatePart function not working in cfquery...
if it's not in pound signs, CF won't think that it owns the function. can you paste the code you're using and specify how it does not work in cfquery? -- Charlie Griefer My SQL looks like this SELECT * FROM items WHERE DatePart(,itemDate)='1933' - Kevin ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT ISAPI Rewrite
Damn those W3C guys for coming up with a common log format... You don't have to log to it mind you, you can use \sitename\mmddyy etc (or something along those lines) but in all reality, it's a log file and the only thing to care about my log file is my stats program which picks em up automatically. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Apr 02 22:04:02 2007 Subject: RE: OT ISAPI Rewrite -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Monday, April 02, 2007 4:47 PM To: CF-Talk Subject: Re: OT ISAPI Rewrite You just don't get it do you... research... :-) No, I don't get it. Research what? How to set up the log files the way I want them? I checked the help file, and it's of no use. Unless you're talking about the gimpy way of doing it by having each log file in a folder such as c:\logs\sitename.com\W3SVC. If you do know a better way to do this, as you claim that you do it all the time, why don't you enlighten us, instead of sending me on a wild goose chase? Russ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL DatePart function not working in cfquery...
On 4/2/07, Kevin Bales [EMAIL PROTECTED] wrote: if it's not in pound signs, CF won't think that it owns the function. can you paste the code you're using and specify how it does not work in cfquery? -- Charlie Griefer My SQL looks like this SELECT * FROM items WHERE DatePart(,itemDate)='1933' are you getting an error? no error but unexpected results in the query? my initial thought is to try without the single quotes around the value (1933). also, can you confirm that the itemDate column is a date datatype? -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Memory issues with new daylight savings update?
Well, as we all know.. 1.4.2_11 is the latest supported JVM I think? How do you mean updated it via the 7.0.2 update? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Ben Nadel To: CF-Talk Sent: Mon Apr 02 21:45:35 2007 Subject: Memory issues with new daylight savings update? Hey all, lately, our server has been having some serious memory issues. We will get a lot of requests (which is normal) and the server can handle them... then, all of a sudden, it seems to choke and the requests start to queue up and the memory (monitoring in SeeFusion) maxes out and will not come down even when the requests die down. We cannot figure out what is going on as we have not done anything special lately. We thought maybe it was the JVM that was updated for the Daylight savings time. Has anyone noticed any memory issues after this update? Our JVM is 1.4.2_12 and we didn't have any of these problems until we upgraded the JVM using updater 7.02. Thanks! ... Ben Nadel Certified Advanced ColdFusion Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com http://www.nylontechnology.com/ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT ISAPI Rewrite
-Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Monday, April 02, 2007 5:32 PM To: CF-Talk Subject: Re: OT ISAPI Rewrite Damn those W3C guys for coming up with a common log format... You don't have to log to it mind you, you can use \sitename\mmddyy etc (or something along those lines) but in all reality, it's a log file and the only thing to care about my log file is my stats program which picks em up automatically. But that's my point. AFAIK, you CAN'T use \sitename\mmddyy, you have to put it in a folder that's determined by siteId that IIS generates for the virtual site, such as W3SVCX. That's really annoying. Russ ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Memory issues with new daylight savings update?
Hmmm, I did not set up the server or install the patches (and do not understand the server stuff). I will run this by my manager see if he can make more sense of it. Thanks for you input. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 5:37 PM To: CF-Talk Subject: Re: Memory issues with new daylight savings update? Well, as we all know.. 1.4.2_11 is the latest supported JVM I think? How do you mean updated it via the 7.0.2 update? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another Subversion Question
You need a vendor branch. There's a section in the book about how to use them. It's not really any different from a normal branch, other than the fact that you don't write any code on the branch, you import it from the third party. cheers, barneyb On 4/2/07, Zaphod Beeblebrox [EMAIL PROTECTED] wrote: I use the ever present BlogCFC for a couple of blogs. Each blog has a little bit different layout, but that's about it. I'm trying to figure out how I could set up the Subversion repository and include Ray's subversion repository to be something like this: /trunk/(Ray's SVN - still updateable whenever Ray does an update) /local/(My tweaks to the actual cfc - mainly allowing for ldap authentication) /blog1/(a copy from local/client - with site customizations) /blog2/(same as above) /blogN+1/ I want to be able to update my /local/ copy of blogCFC whenever Ray does a security update, but I don't want to lose my changes. As with the individual blog site, whenever there's an update, I want to be able to roll these down to each site. Currently I'm using SVK, but it doesn't have the tool support of SVN such as tortoiseSVN, Subclipse, etc. Can subversion do something like this? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Active X controls close browser
This is not CF, but regular DHTML. I used this in a site that just went live today: http://www.dynamicdrive.com/dynamicindex1/ddtabmenu.htm On 4/2/07, Tom Garber [EMAIL PROTECTED] wrote: Thanks for the link. I will take a look at this and see if it will work for us. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT ISAPI Rewrite
It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. In what way exactly? What if you publish pages already in an SEO friendly way? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Apr 02 20:33:11 2007 Subject: RE: OT ISAPI Rewrite Well you can easily just create a logs/[sitename]/logfile structure in IIS and point each site to their corresponding log folder, we do it all the time. I'm still not seeing how to do this. I guess I can theoretically point each website to an individual folder, but then it will still create something like W3SVCX\exyymmdd.log. You don't have any control over this part. You also don't have control on what time the log file rolls over. Sure most people prefer 12am, but what if your servers are in a different time zone and you want it to roll over 11pm or 1am? Why is it an extra step to do that backup process? Of which can be automated anyhow. It is an extra step, whether you automate it or not. With Apache, it's just plain text files, and you can back them up without worry. You can also create a folder with all the virtual site configurations and have them generated automatically by coldfusion. For example, you can have a folder named vsites and you can have files such as sitename.com.conf which just needs to contain something like this: VirtualHost *:80 ServerName *.example.com DocumentRoot c:/websites/example.com/ /VirtualHost You can specify other options such as per site logging, but nothing else needs to be specified. I have just create a virtual site which will host all the subdomains for example.com, including www.example.com and user1.example.com and site2.example.com, etc. Try doing same with IIS without dedicating an IP to the site. You can have a directive in the main configuration file to include all the config files in this directory. Include conf/vsites/*.conf Voila. Have cf generate the text file, and restart apache to refresh the config, and you have just create an easy way to automatically create virtual sites. I wonder how long it would take you to do the same thing with IIS? We get very good support from Microsoft as and when we need thanks, we are a big customer of theirs :-) I am still yet to find a decent argument on why anyone should use Apache over IIS from your chosen arguments. True there is URL rewriting but then again, maybe you shouldn't need to do this if your website structures are friendly out of the box :-) It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. Also lets say that someone else logs onto the box, and makes some configuration changes and breaks something. Do you know what they changed? Do you know how to fix it? Do you feel confident enough to restore from backup? With apache, you can keep the configuration in subversion, and know EXACTLY what was changed since last commit. You can revert the changes, roll back to a previous version, and all the other goodies that come with SVN. Apache is a developer's web server. It turns the web server into something you can write code for. I, for one, want to see all the configuration details of a particular site right in front of me, without having to flip through 20 different tabs. Russ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. In what way exactly? What if you publish pages already in an SEO friendly way? I'm far from being an expert on SEO, but from what I remember from Michael Dinowitz's presentation http://www.sitename.com/Programming_ColdFusion_Book-1234.html will get higher google rankings then http://www.sitename.com/index.cfm?bookid=1234 or http://www.sitename.com/index.cfm/1234 or http://www.sitename.com/index.cfm/Programming_ColdFusion_Book and even http://www.sitename.com/Programming_ColdFusion_Book.cfm Russ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT ISAPI Rewrite
AFAIK the example and the latter are the same URL and will be treated as such. I can understand the others, I don't agree with them, which I why you should publish pages out like that straight off the bat, with no URL rewriting required. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Apr 02 23:08:53 2007 Subject: RE: OT ISAPI Rewrite It doesn't matter how good your website structures are, you need URL rewriting for SEO. It's also just a nice feature to have, and the possibilities with it are endless. In what way exactly? What if you publish pages already in an SEO friendly way? I'm far from being an expert on SEO, but from what I remember from Michael Dinowitz's presentation http://www.sitename.com/Programming_ColdFusion_Book-1234.html will get higher google rankings then http://www.sitename.com/index.cfm?bookid=1234 or http://www.sitename.com/index.cfm/1234 or http://www.sitename.com/index.cfm/Programming_ColdFusion_Book and even http://www.sitename.com/Programming_ColdFusion_Book.cfm Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WebService help...
Sorry for the late response I'm not sure what your telling me to do here. Is this a new page? Thanks, - Charles On Mar 28, 2007, at 2:43 PM, Robertson-Ravo, Neil (RX) wrote: cfset yourWebService = CreateObject(webservice,pathtowebservice/ cfset foo = yourWebService.getMessage(Charles)/ cfdump var=#foo# This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Charles Heizer To: CF-Talk Sent: Wed Mar 28 22:37:57 2007 Subject: WebService help... Hello, I'm really tyring to figure out how to use a simple web service in coldfusion. My WS (helloworld.cfc) cfcomponent cffunction name=getMessage access=remote returntype=string cfargument name=name type=string cfreturn Hello arguments.name ! /cffunction /cfcomponent What I'm trying to figure out is how do I call this in a web browser? And the last part is, I'm also trying to use RealBasic to get the result of this and I found a couple of comments that RB needs a SOAPAction header. How do I populate that in CFMX? Thanks, - Charles ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
I'm far from being an expert on SEO, but from what I remember from Michael Dinowitz's presentation http://www.sitename.com/Programming_ColdFusion_Book-1234.html will get higher google rankings then http://www.sitename.com/index.cfm?bookid=1234 or http://www.sitename.com/index.cfm/1234 or http://www.sitename.com/index.cfm/Programming_ColdFusion_Book and even http://www.sitename.com/Programming_ColdFusion_Book.cfm Actually, that's not correct. While Google doesn't publish their page rank algorithms, it's relatively common knowledge that Google doesn't favor static extensions (.html/.htm) over dynamic extensions any longer, all things being equal. So the last example would work just as well as the first. The next-to-last example will probably work just as well, too. But even if they did, you would be just as well served having CF process an otherwise static extension than to worry about URL rewriting. And, of course, you don't need your web server to do URL rewriting at all; you can do all that with Java if you like, and provide that functionality as part of your application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT ISAPI Rewrite
Robertson-Ravo, Neil (RX) wrote: AFAIK the example and the latter are the same URL and will be treated as such. I can understand the others, I don't agree with them, which I why you should publish pages out like that straight off the bat, with no URL rewriting required. For what its worth Neil, I like like url rewriting schemes over publishing with the same physical directory structure for one reason: the urls stay the same even if the underlying organization changes. If I move from model-glue to Farcry or a bespoke solution or what have you, I can keep the same urls and just change the way that they are rewritten to accomodate the underlying structure. This is also true of switching between application servers, like php to cf. Urls should be consistent, descriptive and (optimally) not change. I find that the best way to achieve that is to abstract them away from the underlying details and consider them to be descriptors of the content to be presented. Judah ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Webservices and RealBasic
Hello, Can anyone tell me if they have successfully used a Coldfusion webservice from RealBasic using a Soap request? I'm getting a XmlException. Thanks, - Charles Charles Heizer Systems Management Solutions Group Lawrence Livermore National Laboratory 7000 East Ave. L-285 Livermore, CA 94550 Phone: (925)422-0197 Fax:(925)422-2425 email: [EMAIL PROTECTED] ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: New instances as a Windows service
On 3/30/07, Dave W wrote: But you don't have to restart it after CF comes up, which apparently you do with IIS? No, I've had clients who had to ensure that Apache started after JRun. I'm sure there are set-ups like that, I was just curious as to if IIS /had/ do be restarted if it was fired up first. Since I've got a bunch of instances now, I just fire them up when needed- so I constantly forget and hit apache first, and then go duh, and start CF, and then hit F5. Just wondering what it's like for the heads out in IIS land... you never know when you'll be one of those heads, right? ;-) I like how with httpd* you can specify a page to show instead of the familiar JRun error or whatnot... can you do that with IIS too? *it's the connector that has the setting, really, so I'd think: yes... Yes, you can set that; the connector stores the information in a .properties file. Gracias again Dave, you are a champ- answering idle questions y todo. I appreciate it. * * * Did I mention I just paypal-ed you 1 million $ in small bills for the trouble? You should be seeing the transaction receipt real soon now... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ORM with convention over configuration?
On 4/1/07, Damien M wrote: With a site redesign you can do that. That's what I'm looking at myself. That's why I LOVE REACTOR, especially the field alias stuff.. It works either way. Sweet. Reactor for CF will do introspection, and I ain't fooling, you only need the XML stuff if you want things to be automagical+. I do think the comments about XML (DTD/verification/ubiquity/all that good stuff) make for some good reasons to use XML... I've been working on using one tool to bind them all. ERDs and everything. *cough* Sike (as in pee-eesss-why ki.) Any idea on the Reactor website, anyone? http://trac.reactorframework.com/reactor Is usually where I go if I forgot the repository URL. Was it down? H... Although I *did* hear that Doug was moth-balling Reactor to work on Transfer... ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PS3 :: to run CFMX8 better then windows vista..
On 4/2/07, Tom C wrote: On Friday 30 Mar 2007, Paul I wrote: happy April fools all... That was *yesterday*. Not according to my clock. April Fools in the internet doesn't work because you have no idea when the person will read you message. Surely you jest. I'm pretty sure the internet *invented* AFD... *sigh* Ok- guess I'll take a hop into the future, from my fake past... it's now the 2nd, where I am. Happy dude? ... Freaking fun killer... /me kicks the dirt [= ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Subversion questions
On 4/2/07, Rick R wrote: The tricky part is cases where applications share files for example, I have an include directory at my web root which contains images, css files, and a few cfm files that are used not only across various applications within the main web site, but across multiple web sites as well through the use of IIS virtual directories and coldfusion mappings. SVN:externals is FREAKING AWESOME. Just what the doctor ordered for those trickier situations... check it out... As for repositories for each project, the only thing to keep in mind is that the JavaHL interface cannot commit across repositories. The SVNkit interface doesn't have that limitation. Not much of a limitation, boils down to committing changes for each project, vs. all projects at once. As always, the PITA of linking or sharing components is that you gotta really test everything that uses that component whenever you make a change to it. It's harder to stage roll-outs when code is shared, and mapped, etc. It's a good recurring thread, that one about do all projects move along as you do, just the ones you're currently working on... pluses and minuses either way... but a HUGE incentive for unit testing, etc., if you DO go the route of we're all going! or if I'm going, I'm taking you all with me type deals... ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another Subversion Question
Crazily enough, I've got almost the exact same situation as yerzelf. SVN:externals. Love it. Live it. L-word it. Using patch files is quite awesomely nifty too... ** * Qs or Cs? Holla! :-P On 4/2/07, Zaphod B wrote: I use the ever present BlogCFC for a couple of blogs. Each blog has a little bit different layout, but that's about it. I'm trying to figure out how I could set up the Subversion repository and include Ray's subversion repository to be something like this: /trunk/(Ray's SVN - still updateable whenever Ray does an update) /local/(My tweaks to the actual cfc - mainly allowing for ldap authentication) /blog1/(a copy from local/client - with site customizations) /blog2/(same as above) /blogN+1/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT ISAPI Rewrite
-Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 7:44 PM To: CF-Talk Subject: RE: OT ISAPI Rewrite I'm far from being an expert on SEO, but from what I remember from Michael Dinowitz's presentation http://www.sitename.com/Programming_ColdFusion_Book-1234.html will get higher google rankings then http://www.sitename.com/index.cfm?bookid=1234 or http://www.sitename.com/index.cfm/1234 or http://www.sitename.com/index.cfm/Programming_ColdFusion_Book and even http://www.sitename.com/Programming_ColdFusion_Book.cfm Actually, that's not correct. While Google doesn't publish their page rank algorithms, it's relatively common knowledge that Google doesn't favor static extensions (.html/.htm) over dynamic extensions any longer, all things being equal. So the last example would work just as well as the first. The next-to-last example will probably work just as well, too. But even if they did, you would be just as well served having CF process an otherwise static extension than to worry about URL rewriting. And, of course, you don't need your web server to do URL rewriting at all; you can do all that with Java if you like, and provide that functionality as part of your application. Actually, according to Michael Dinowitz (and I'm not sure where he gets his facts from), static extensions have a slightly higher rank then dynamic ones. The argument against doing CF to do the URL rewriting is that Apache is faster, and you might want to do rewriting of static URL's where there's no need to involve CF at all. For example if I host many different sites off of a single webroot, I might want to have different favicon.ico, so I can set up a rewrite rule that maps it into each site's image folder based on the domain name. There is no need to involve CF in this process. Russ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Memory issues with new daylight savings update?
This wound up being the culprit (we think) http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=kb401239 We also rolled back to _11 as well. Thanks everyone. - j Jim Curran President Nylon Technology 350 7th Avenue, 10th Floor New York, NY 10001 212.691.1134 x11 direct 212.691.3477 fax [EMAIL PROTECTED] www.nylontechnology.com -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 5:50 PM To: CF-Talk Subject: RE: Memory issues with new daylight savings update? Hmmm, I did not set up the server or install the patches (and do not understand the server stuff). I will run this by my manager see if he can make more sense of it. Thanks for you input. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 5:37 PM To: CF-Talk Subject: Re: Memory issues with new daylight savings update? Well, as we all know.. 1.4.2_11 is the latest supported JVM I think? How do you mean updated it via the 7.0.2 update? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another Subversion Question
Hmmm...I was thinking svn:externals was more for your working copy. With SVK, I set up a mirror of Rays svn in my svn (svk calls it a depot). Then I tell it to sync to my /trunk . Then I tell it to copy from /trunk to /local. Now, whenever I want to make changes to it, I check out the local version, I can make all the changes that I want to and I can also update the trunk version from Ray's. At any point I can diff or smerge my version and Rays. On 4/2/07, Dinner [EMAIL PROTECTED] wrote: Crazily enough, I've got almost the exact same situation as yerzelf. SVN:externals. Love it. Live it. L-word it. Using patch files is quite awesomely nifty too... I need to get more acquainted with the other functionality beyond commit and update :) ** * Qs or Cs? Holla! :-P On 4/2/07, Zaphod B wrote: I use the ever present BlogCFC for a couple of blogs. Each blog has a little bit different layout, but that's about it. I'm trying to figure out how I could set up the Subversion repository and include Ray's subversion repository to be something like this: /trunk/(Ray's SVN - still updateable whenever Ray does an update) /local/(My tweaks to the actual cfc - mainly allowing for ldap authentication) /blog1/(a copy from local/client - with site customizations) /blog2/(same as above) /blogN+1/ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Question
Thanks for your replies. I didn't get a chance to play with anything this afternoon due to meetings. I'll try to implement something tommorrow and fill you all in on the results. The recordsets aren't that big. About 9k records in one table and 3k in the other. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another Subversion Question
Yeah, svn:externals is a working-copy concept that allows you to have your working copy split amongst several SVN destinations (and store that configuration in SVN itself for easy maintenance and reuse). It doesn't help you with local changes to the remote code (in fact, it prevents that arrangement, because changes to the remote code get committed to the remote repository). You're doing a vendor branch with SVK. The only difference is that you're using SVK to get the code into your SVN repository (in /trunk), rather than using a source drop from the external project (the usual route). There's no difference between the approaches past that step, so you're doing exactly the recommended thing. cheers, barneyb On 4/2/07, Zaphod Beeblebrox [EMAIL PROTECTED] wrote: Hmmm...I was thinking svn:externals was more for your working copy. With SVK, I set up a mirror of Rays svn in my svn (svk calls it a depot). Then I tell it to sync to my /trunk . Then I tell it to copy from /trunk to /local. Now, whenever I want to make changes to it, I check out the local version, I can make all the changes that I want to and I can also update the trunk version from Ray's. At any point I can diff or smerge my version and Rays. -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Logout vs just closing the browser
Ok - have an app with a logout page that destroys all client/session variables. No problem. Works great. BUT - what if somebody doesn't log out and just closes the browser? Is there any way to destroy everything when that happens? I've not found a definitive source of info on this anywhere yet still researching... Is there a good reference anywhere. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Logout vs just closing the browser
I believe you could use JavaScript's onUnload function to kick of an Ajax call. That should do the trick, but you'd want to do the ajax call synchronously so that the user doesn't get a pause as they go away (this can also cause errors in some browsers if you do it asynchronously). On 4/2/07, Les Mizzell [EMAIL PROTECTED] wrote: Ok - have an app with a logout page that destroys all client/session variables. No problem. Works great. BUT - what if somebody doesn't log out and just closes the browser? Is there any way to destroy everything when that happens? I've not found a definitive source of info on this anywhere yet still researching... Is there a good reference anywhere. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Subversion questions
On 4/2/07, Dinner [EMAIL PROTECTED] wrote: It's a good recurring thread, that one about do all projects move along as you do, just the ones you're currently working on... Until just recently, I was essentially the only person doing 99% of the web work in our department. One of my co-workers has backed me up, doing minor bug fixes while I was gone but he was focused on non-web projects, and recently released what we expect to be the final client server visual basic version of our end user reporting tool. And now we're both focused on building a flex and coldfusion implementation... I've been doing the front end and a little backend stuff... I kinda laid out the architecture of the application itself and how we'd handle running queries, file drops, etc... now he's working on the actual query building code.. taking in the huge mass of parameters and writing the conditional SQL for it. Of course, he's taking advantage of the Duke employee tuition discount and since he's smart, he got into Duke's weekend MBA program, from which he'll graduate in November. Then I'll be the only web guy again =) Rick -- CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! http://www.cfmbb.org ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT ISAPI Rewrite
Actually, according to Michael Dinowitz (and I'm not sure where he gets his facts from), static extensions have a slightly higher rank then dynamic ones. I am only sure where I get my facts from. My understanding, based on my own experience, is that this is not the case. My experience is backed by our own results with SEO. Among other things, Fig Leaf Software provides SEO services. Again, Google does not provide details about their page rank algorithms, and they change these algorithms pretty frequently. And again, in any case, if you want to achieve that outcome, you can just configure CF to process requests with .html in the URL pattern. The argument against doing CF to do the URL rewriting is that Apache is faster ... I am unwilling to waste my time in a pointless, inane argument with you about web servers, since when it comes to this subject you are, by any useful definition of the word, a troll. This is cf-talk, not web-server-talk. You seem to be drawn to every IIS configuration question like a moth to a flame. But that's your problem, not mine. Anyway, there are obvious arguments in favor of embedding that kind of functionality in an application: portability, easy programmatic modification, the ability to generate rewrite rules from a database query, etc, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4