Re: Stop View Source 2
Correct. Can we let this drop now? I think the point has been driven into the ground: you can't stop people from inspecting anything that is rendered or processed in the browser. Let's move on, because somehow this thread just won't die even though the point was made in the first reply. On 10/19/07, Richard White [EMAIL PROTECTED] wrote: thanks again for your replies. so i am judging by your responses that no one really does anything to protect their code as it is pointless? if someone wants to get it they will! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion hosting recomendation ?
Hi there. We've had a very good experience with CF Dynamics. Their support is very strong and their knowledge of CF hosting is extremely good since it is their focus. I don't know much about their international speeds, but you may want to check in with them and find out. Best, Nick . .. Nick Gleason | CitySoft, Inc. | http://www.citysoft.com Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. . .. -Original Message- From: NUGROHO NOTO [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 12:53 AM To: CF-Talk Subject: Coldfusion hosting recomendation ? I have a dedicated server with hosting.com (cfxhosting.com) Before.. my server was in Louisville.. 5 months ago they moved my server to Irvine (CA). and since then, the connection from Japan is becoming very slow at certain times. traceroute shows : 819ms. They say... NOTHING they can do... it is router problem outside their network. Hmm... sadly... I have to find better location hosting. Anybody can recommend a VERY GOOD Coldfusion Dedicated Hosting ? - preferably in Japan (I had tried searching.. cannot find... anybody knows ?) - Or.. in USA with a VERY good support..(can help install CF8, MsSQL 2005 workgroup) - Fast connection and GOOD support is more important than budget. Thanks. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Stop View Source
Ermm, how about taking a screen shot and sending the user a jpeg! Everybody's happy :OD -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 19 October 2007 16:44 To: CF-Talk Subject: Re: Stop View Source Nothing, repeat, nothing, you do can stop someone from viewing the HTML source of a web page in the browser. The browser HAS to get the HTML in order to render it. And if the browser has it, the user can look at it. On 10/19/07, Richard White [EMAIL PROTECTED] wrote: Hi, I remember reading something that said in ColdFusion we can stop people from viewing the page source code. I would appreciate any help as to whether this is this possible and how we would go about doing it Thanks Richard ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Stop View Source 2
Ok thanks to everyone for helping me understand this Richard ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DEATH to HOMESITE
Rick If you want to get started with CFEclipse, take a look into Mark Drew MAX presentation about CFEclipse that I just posted on my blog. http://www.onflexwithcf.org/index.cfm/2007/10/20/Using-Eclipse-for-ColdFusion-Development--Videos -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DEATH to HOMESITE
I was going to say the same thing. This issue isn't really a case of Homesite vs. Eclipse, it's about always, always, always using source control. Always. On 10/19/07, Paul Vernon [EMAIL PROTECTED] wrote: F*cking HomeSite+ wiped out my file on the server (AGAIN). I do a file write, it hangs, and I have to kill HomeSite. When I start homesite again, guess what, the file is gone from the server. Source control, Source control, Source control or to put it more concisely, SVN, SVN, SVN! There are some great Subversion plugins for CFEclipse :-) Subclipse is the one I believe most of the CFEclipse users use... Paul ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DEATH to HOMESITE
This is very true Brian, I agree whole heartedly, However, in the past I've always found subversion a total pain in the arse to setup and configure, it's just very confusing. My guess is that this stems from the fact that it was seemingly developed with Linux in mind, with command lines and compiling binaries, if they made it a little more intuitive to people (I suspect a large number of new developers will opt for windows OS as its 'what they know'), instead of the linuxy style methods they've used, I'm sure it would be more widely adopted by less experienced developers. It reminds me of the same reason why so many people pick up the bad habit of developing using access databases, it's simply because to a beginner developer they seem more accessible than a proper DBMS, As a novice developer trying to figure out installation and configuration of MySQL or SQL Server is quite confusing, especially when you have to setup management studio or phpMyAdmin, whereas the concept of a single file which can be easily created in a nice desktop based GUI is very simple to grasp, so most novice developers will start with access, especially considering all that functionality comes 'out of the box' with m$ office. I completely agree that source control through a proper SVN approach will pay dividends, but it's just one of those concepts that isn't A) Publicised to people properly, if you mention subversion to most amateur developers they would stare blankly back at you, however, ftp is very familiar. And. B) Accessible and simple enough to implement, even with these 'one touch' style solutions that subversion released for windows users. They're just my thoughts, Another quick gripe is with some of the guides and support documents I've read in the past, they're always typical Linux user style blog posts and forum remarks, showing a total lack of sympathy toward new and learning developers, making wide sweeping statements like 'and then simply update your system environment variables, and you're done!'... amateur users won't have a clue what you're on about, even someone whom is reasonably experienced with Linux development finds that stuff confusing. Heh, man I'm in a tired and grouchy mood today, can you tell? Lol Sorry for the rantish post chaps, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 20 October 2007 15:43 To: CF-Talk Subject: Re: DEATH to HOMESITE I was going to say the same thing. This issue isn't really a case of Homesite vs. Eclipse, it's about always, always, always using source control. Always. On 10/19/07, Paul Vernon [EMAIL PROTECTED] wrote: F*cking HomeSite+ wiped out my file on the server (AGAIN). I do a file write, it hangs, and I have to kill HomeSite. When I start homesite again, guess what, the file is gone from the server. Source control, Source control, Source control or to put it more concisely, SVN, SVN, SVN! There are some great Subversion plugins for CFEclipse :-) Subclipse is the one I believe most of the CFEclipse users use... Paul ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help with MySQL Query
Hi there I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query. Thanks in advance for feedback SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime, CompanyNames.CompanyName, GateKeeperRecs.RegoNo, GKeeperNames.GKeeperName, AuditorNames.AuditorName, GateKeeperRecs.NetWeight, (visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry + visaudactweight.Cardboard_CompactedWet + visaudactweight.Cardboard_LooseDry+ visaudactweight.Cardboard_LooseWet + visaudactweight.Cardboard_Waxed + visaudactweight.Clay + visaudactweight.CleanFill + visaudactweight.Concrete+ visaudactweight.Food_Kitchen + visaudactweight.Garbags + visaudactweight.Glass + visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn + visaudactweight.Leather_TextilesMatt + visaudactweight.Leather_TextilesCar + visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous + visaudactweight.Paper + visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard + visaudactweight.PlasterBoard + visaudactweight.Polystyrene + visaudactweight.Rocks_Bricks + visaudactweight.Rubble + visaudactweight.Soil+ visaudactweight.Tyres_Rubber + visaudactweight.Vegetation_Garden + visaudactweight.Wood_Timber + visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing + visaudactweight.Wood_Furniture + visaudactweight.Other_CD + visaudactweight.Other_CI + visaudactweight.Hazardous) AS MatTotal, ((MatTotal - GateKeeperRecs.NetWeight)/GateKeeperRecs.NetWeight)*100 as PercentDiff FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs, GKeeperNames WHERE (visaudactweight.SiteID = Sites.SiteID) ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DEATH to HOMESITE
If you happen to be on Windows, setting up Subversion is as simple as clicking one button: http://svn1clicksetup.tigris.org/ :-) On 10/20/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: This is very true Brian, I agree whole heartedly, However, in the past I've always found subversion a total pain in the arse to setup and configure, it's just very confusing. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DEATH to HOMESITE
D'oh, answered before I saw your note about the one click installers. I agree that learning to use version control is a bit of a hurdle initially. However, I'd say that it is something that you simply HAVE to learn. Anyone who isn't using it should simply accept that need to do this (even if it's just because everyone else is doing it, because in this case everyone else is right). The benefits to doing so, and the risks of not doing so, are simply irrefutable. And, honestly, it's really not that difficult to get going with it. As for docs, I used http://svnbook.red-bean.com/ early on. But with the built-in SVN tools for Eclipse and Windows/OSX, pulling and committing to the repository is really pretty straightforward (right click commit. done!) On 10/20/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: A) Publicised to people properly, if you mention subversion to most amateur developers they would stare blankly back at you, however, ftp is very familiar. And. B) Accessible and simple enough to implement, even with these 'one touch' style solutions that subversion released for windows users. They're just my thoughts, Another quick gripe is with some of the guides and support documents I've read in the past, they're always typical Linux user style blog posts and forum remarks, showing a total lack of sympathy toward new and learning developers, making wide sweeping statements like 'and then simply update your system environment variables, and you're done!'... amateur users won't have a clue what you're on about, even someone whom is reasonably experienced with Linux development finds that stuff confusing. Heh, man I'm in a tired and grouchy mood today, can you tell? Lol Sorry for the rantish post chaps, Rob ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DEATH to HOMESITE
Source control is ones best friend but depending on the environments you work in, it can be a task to try and get it up and running. Most of the places I do work for they do not run any form(or a form worth mentioning) of source control on their servers. Some of the places they have the laptops that are provided to do the coding on, locked down to the point where you could not just make it act like some sort of stand alone server so it does all the things you wish the servers out of your control could do. On 10/19/07, Paul Vernon [EMAIL PROTECTED] wrote: F*cking HomeSite+ wiped out my file on the server (AGAIN). I do a file write, it hangs, and I have to kill HomeSite. When I start homesite again, guess what, the file is gone from the server. Source control, Source control, Source control or to put it more concisely, SVN, SVN, SVN! There are some great Subversion plugins for CFEclipse :-) Subclipse is the one I believe most of the CFEclipse users use... Paul ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
mysql query
Hi there I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query. Thanks in advance for feedback SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime, CompanyNames.CompanyName, GateKeeperRecs.RegoNo, GKeeperNames.GKeeperName, AuditorNames.AuditorName , GateKeeperRecs.NetWeight, (visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry + visaudactweight.Cardboard_CompactedWet + visaudactweight.Cardboard_LooseDry + visaudactweight.Cardboard_LooseWet + visaudactweight.Cardboard_Waxed + visaudactweight.Clay + visaudactweight.CleanFill + visaudactweight.Concrete + visaudactweight.Food_Kitchen + visaudactweight.Garbags + visaudactweight.Glass + visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn + visaudactweight.Leather_TextilesMatt + visaudactweight.Leather_TextilesCar + visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous + visaudactweight.Paper + visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard + visaudactweight.PlasterBoard + visaudactweight.Polystyrene + visaudactweight.Rocks_Bricks + visaudactweight.Rubble + visaudactweight.Soil + visaudactweight.Tyres_Rubber + visaudactweight.Vegetation_Garden + visaudactweight.Wood_Timber + visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing + visaudactweight.Wood_Furniture + visaudactweight.Other_CD + visaudactweight.Other_CI + visaudactweight.Hazardous) AS MatTotal, ((MatTotal - GateKeeperRecs.NetWeight )/GateKeeperRecs.NetWeight)*100 as PercentDiff FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs, GKeeperNames WHERE (visaudactweight.SiteID = Sites.SiteID) ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Stop View Source
Richard, here is everything you need to know about protecting client-side code and images: http://www.digitalmidget.com/help/noclick/index.php :-) -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with MySQL Query
Peter Tanswell wrote: I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query. You can not use a column alias you define in the select list as a base column to some other calculated column in that same select list, i.e.: SELECT A + B AS C, C / D AS E Instead, use: SELECT A + B AS C, (A + B) / D AS E or: SELECT C, C / D AS E FROM ( SELECT A + B AS C, D .. ) Jochem ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291666 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with MySQL Query
Hi there I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query. What do you mean by does not work with mySQL It might be your concatenations. Will ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion 8 Adminapi Datasource problem
Hmm, I was hoping I'd see something simple. I'd suggest logging a bug report (www.adobe.com/go/wish). Sorry I couldn't help. On 10/19/07, John Elkins [EMAIL PROTECTED] wrote: Care to show the code? Care to show the code? -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with MySQL Query
Peter, The reason it's not working is not because of the alias, but because you are trying to use the alias in the SELECT clause. MySQL only allows you to reference aliases in the GROUP BY, ORDER BY, or HAVING clauses. (http://dev.mysql.com/doc/refman/5.0/en/problems-with- alias.html) You'll need to re-write the full equation used to create the alias and add parenthesis as necessary. One other big note on this query: You didn't include all of the WHERE clause joins for the tables in your provided SQL, but you should really perform your table JOINs in the FROM clause (i.e. INNER JOIN Sites ON visaudactweight.SiteID = Sites.SiteID). You will see performance improvements on query execution inversely proportional to the number of records in your tables by doing this - up to 80-85%. HTH, Jon On Oct 20, 2007, at 11:56 AM, Peter Tanswell wrote: Hi there I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query. Thanks in advance for feedback SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime, CompanyNames.CompanyName, GateKeeperRecs.RegoNo, GKeeperNames.GKeeperName, AuditorNames.AuditorName, GateKeeperRecs.NetWeight, (visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry + visaudactweight.Cardboard_CompactedWet + visaudactweight.Cardboard_LooseDry+ visaudactweight.Cardboard_LooseWet + visaudactweight.Cardboard_Waxed + visaudactweight.Clay + visaudactweight.CleanFill + visaudactweight.Concrete+ visaudactweight.Food_Kitchen + visaudactweight.Garbags + visaudactweight.Glass + visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn + visaudactweight.Leather_TextilesMatt + visaudactweight.Leather_TextilesCar + visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous + visaudactweight.Paper + visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard + visaudactweight.PlasterBoard + visaudactweight.Polystyrene + visaudactweight.Rocks_Bricks + visaudactweight.Rubble + visaudactweight.Soil+ visaudactweight.Tyres_Rubber + visaudactweight.Vegetation_Garden + visaudactweight.Wood_Timber + visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing + visaudactweight.Wood_Furniture + visaudactweight.Other_CD + visaudactweight.Other_CI + visaudactweight.Hazardous) AS MatTotal, ((MatTotal - GateKeeperRecs.NetWeight)/GateKeeperRecs.NetWeight)*100 as PercentDiff FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs, GKeeperNames WHERE (visaudactweight.SiteID = Sites.SiteID) ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Stop View Source 2
Let's move on, because somehow this thread just won't die Right. It's time to start a new one. How about coldFusion dying? ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mysql query
Well unless there is more to the where clause that you didn't paste, all those extra parentheses are going to cause an error, in addition to the fact that you're not joining any of the other tables. On 10/20/07, Toby King [EMAIL PROTECTED] wrote: Hi there I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query. Thanks in advance for feedback SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime, CompanyNames.CompanyName, GateKeeperRecs.RegoNo, GKeeperNames.GKeeperName, AuditorNames.AuditorName , GateKeeperRecs.NetWeight, (visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry + visaudactweight.Cardboard_CompactedWet + visaudactweight.Cardboard_LooseDry + visaudactweight.Cardboard_LooseWet + visaudactweight.Cardboard_Waxed + visaudactweight.Clay + visaudactweight.CleanFill + visaudactweight.Concrete + visaudactweight.Food_Kitchen + visaudactweight.Garbags + visaudactweight.Glass + visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn + visaudactweight.Leather_TextilesMatt + visaudactweight.Leather_TextilesCar+ visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous + visaudactweight.Paper + visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard + visaudactweight.PlasterBoard + visaudactweight.Polystyrene + visaudactweight.Rocks_Bricks + visaudactweight.Rubble + visaudactweight.Soil + visaudactweight.Tyres_Rubber + visaudactweight.Vegetation_Garden + visaudactweight.Wood_Timber + visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing + visaudactweight.Wood_Furniture + visaudactweight.Other_CD + visaudactweight.Other_CI + visaudactweight.Hazardous) AS MatTotal, ((MatTotal - GateKeeperRecs.NetWeight)/GateKeeperRecs.NetWeight)*100 as PercentDiff FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs, GKeeperNames WHERE (visaudactweight.SiteID = Sites.SiteID) ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion hosting recomendation ?
Hi there. We've had a very good experience with CF Dynamics. Their support is very strong and their knowledge of CF hosting is extremely good since it is their focus. I don't know much about their international speeds, but you may want to check in with them and find out. Best, Nick . Nick Gleason | CitySoft, Inc. | http://www.citysoft.com Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. . I second that recommendation. I've been with CFDynamics for several years now and have been quite impressed with their support and service. regards, larry ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help with MySQL Query
You can not use a column alias you define in the select list as a base column to some other calculated column in that same select list, i.e.: True. SELECT A + B AS C, C / D AS E I have to say I'm surprised Access actually _does_ allow you to do that. I'd never tried it before now because most db's I've used don't allow it. Go figure. Janet ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best technology
Reactor is perfect for that...reactor is used in model-glue to handle CRUD ops...I assume it can be used on it's own as well... Eric -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 12:20 PM To: CF-Talk Subject: SOT: Best technology I am looking for the best technology to take some of my old web pages that basically do CRUD on database tables and updating them to have a better interface. Basically try to get away from page submissions. I am thinking Flex, but does Spry have ways or sending/receiving data as it is changed so I can update the database table? It might be easier to take my existing CF pages and make them use Spry then to redevelop them in Flex. The backend to do the data CRUD will be a CFC of some sort. I just have not had much time to play with these new languages and hope someone can give me some suggestions. Thanks, Chad ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291674 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What can PHP do that CF can't?
Qbasic was the IBM version... -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 2:52 PM To: CF-Talk Subject: RE: What can PHP do that CF can't? BASIC? ( I guess today it is called QBASIC) Lasso? -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 12:22 PM To: CF-Talk Subject: Re: What can PHP do that CF can't? never learned perl? T-SQL? nope. Unary and dereferencing in C? These are operators, not included in the variable name. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DEATH to HOMESITE
Yeah...until he gets the error that stops the interface from loading...hehehe Eric -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 5:14 PM To: CF-Talk Subject: Re: DEATH to HOMESITE richard, meet cfeclipse. cfeclipse, meet richard. this is going to be the start of a beautiful relationship. On 10/19/07, Richard Colman [EMAIL PROTECTED] wrote: F*cking HomeSite+ wiped out my file on the server (AGAIN). I do a file write, it hangs, and I have to kill HomeSite. When I start homesite again, guess what, the file is gone from the server. What a piece of crap. Rick Colman ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: Rails vs CF.... :)
Folks, I checked the archives -- maybe I missed this on the list the first time around. http://www.railsenvy.com/2007/10/3/ruby-on-rails-vs-coldfusion FWIW, these guys have several funny comparisons between Ruby on Rails and X (9 I believe). -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What can PHP do that CF can't?
Can we please get this worthless thread moved to CFCommunity, Michael? Please? Chris On 10/20/07, Eric Roberts [EMAIL PROTECTED] wrote: Qbasic was the IBM version... -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 2:52 PM To: CF-Talk Subject: RE: What can PHP do that CF can't? BASIC? ( I guess today it is called QBASIC) Lasso? -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 12:22 PM To: CF-Talk Subject: Re: What can PHP do that CF can't? never learned perl? T-SQL? nope. Unary and dereferencing in C? These are operators, not included in the variable name. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Rails vs CF.... :)
Lol, that's really funny. Thanks John Paul. I am curious as to the size of the RoR base (adoption/implementation). I checked the Top100 RoR Users list http://rails100.pbwiki.com/ but it only lists 74- and 4 of them are 37Signals/David Hansson's products (no surprise there). Most on the list are names only hard core geeks and web developers will recognize. I mean, I haven't really seen an RoR site the size of BofA, or as heavy-trafficed site as mySpace. Maybe Basecamp- but its still not a mySpace. Having an evangelist driven campaign like RailsEnvy, is like having cfwack's Ben and Ray create videos dispelling the Death of CF. That's going to be a pretty long series since its been dying for a long time now- and will be in a state of dying even longer, I think. Now that's going to be pretty funny.. at least to us. Have a nice weekend y'all. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 11:06 AM To: CF-Talk Subject: SOT: Rails vs CF :) Folks, I checked the archives -- maybe I missed this on the list the first time around. http://www.railsenvy.com/2007/10/3/ruby-on-rails-vs-coldfusion FWIW, these guys have several funny comparisons between Ruby on Rails and X (9 I believe). -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mysql query
ah yes there were a few extra lines AND (visaudactweight.AuditorID = AuditorNames.AuditorID)) AND (visaudactweight.CompanyID = CompanyNames.CompanyID)) AND (visaudactweight.GKprRecID = GateKeeperRecs.GKprRecID)) AND (GateKeeperRecs.GKeeperID = GKeeperNames.GKeeperID)) but its the AS MATTOTAL which is causing the problem On 10/21/07, Brian Kotek [EMAIL PROTECTED] wrote: Well unless there is more to the where clause that you didn't paste, all those extra parentheses are going to cause an error, in addition to the fact that you're not joining any of the other tables. On 10/20/07, Toby King [EMAIL PROTECTED] wrote: Hi there I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query. Thanks in advance for feedback SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime , CompanyNames.CompanyName, GateKeeperRecs.RegoNo, GKeeperNames.GKeeperName, AuditorNames.AuditorName , GateKeeperRecs.NetWeight, (visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry + visaudactweight.Cardboard_CompactedWet + visaudactweight.Cardboard_LooseDry + visaudactweight.Cardboard_LooseWet+ visaudactweight.Cardboard_Waxed + visaudactweight.Clay + visaudactweight.CleanFill + visaudactweight.Concrete + visaudactweight.Food_Kitchen + visaudactweight.Garbags + visaudactweight.Glass + visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn+ visaudactweight.Leather_TextilesMatt + visaudactweight.Leather_TextilesCar+ visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous + visaudactweight.Paper + visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard + visaudactweight.PlasterBoard + visaudactweight.Polystyrene + visaudactweight.Rocks_Bricks + visaudactweight.Rubble + visaudactweight.Soil + visaudactweight.Tyres_Rubber + visaudactweight.Vegetation_Garden + visaudactweight.Wood_Timber + visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing + visaudactweight.Wood_Furniture + visaudactweight.Other_CD + visaudactweight.Other_CI + visaudactweight.Hazardous) AS MatTotal, ((MatTotal - GateKeeperRecs.NetWeight)/GateKeeperRecs.NetWeight)*100 as PercentDiff FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs, GKeeperNames WHERE (visaudactweight.SiteID = Sites.SiteID) ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DEATH to HOMESITE
It can be confusing. Fortunately other's have gone before you on this road. http://www.trajiklyhip.com/blog/index.cfm/2007/3/12/Configuring-a-Development-Environment-with-Apache-Subversion-TortoiseSVN-and-Subclipse Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com The best way to predict the future is to help create it Robert Rawlins - Think Blue wrote: This is very true Brian, I agree whole heartedly, However, in the past I've always found subversion a total pain in the arse to setup and configure, it's just very confusing. My guess is that this stems from the fact that it was seemingly developed with Linux in mind, with command lines and compiling binaries, if they made it a little more intuitive to people (I suspect a large number of new developers will opt for windows OS as its 'what they know'), instead of the linuxy style methods they've used, I'm sure it would be more widely adopted by less experienced developers. It reminds me of the same reason why so many people pick up the bad habit of developing using access databases, it's simply because to a beginner developer they seem more accessible than a proper DBMS, As a novice developer trying to figure out installation and configuration of MySQL or SQL Server is quite confusing, especially when you have to setup management studio or phpMyAdmin, whereas the concept of a single file which can be easily created in a nice desktop based GUI is very simple to grasp, so most novice developers will start with access, especially considering all that functionality comes 'out of the box' with m$ office. I completely agree that source control through a proper SVN approach will pay dividends, but it's just one of those concepts that isn't A) Publicised to people properly, if you mention subversion to most amateur developers they would stare blankly back at you, however, ftp is very familiar. And. B) Accessible and simple enough to implement, even with these 'one touch' style solutions that subversion released for windows users. They're just my thoughts, Another quick gripe is with some of the guides and support documents I've read in the past, they're always typical Linux user style blog posts and forum remarks, showing a total lack of sympathy toward new and learning developers, making wide sweeping statements like 'and then simply update your system environment variables, and you're done!'... amateur users won't have a clue what you're on about, even someone whom is reasonably experienced with Linux development finds that stuff confusing. Heh, man I'm in a tired and grouchy mood today, can you tell? Lol Sorry for the rantish post chaps, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 20 October 2007 15:43 To: CF-Talk Subject: Re: DEATH to HOMESITE I was going to say the same thing. This issue isn't really a case of Homesite vs. Eclipse, it's about always, always, always using source control. Always. On 10/19/07, Paul Vernon [EMAIL PROTECTED] wrote: F*cking HomeSite+ wiped out my file on the server (AGAIN). I do a file write, it hangs, and I have to kill HomeSite. When I start homesite again, guess what, the file is gone from the server. Source control, Source control, Source control or to put it more concisely, SVN, SVN, SVN! There are some great Subversion plugins for CFEclipse :-) Subclipse is the one I believe most of the CFEclipse users use... Paul ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DEATH to HOMESITE
Death to HomeSite+? You may have gotten your wish. I got a copy of the web CS3 suite with Dreamweaver and could not find a copy of HomeSite+. It had come bundled with previous versions of Dreamweaver. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best technology
Model-Glue has an option to use any ORM that has an adapter available to provide scaffolding. Right now there are two, Reactor and Transfer. But yes, both Reactor and Transfer began life outside of Model-Glue, and both work fine with any framework (or none). That said, the original poster didn't seem to be asking about ORM, but about how to change his interface to use AJAX instead of individual page requests. On 10/20/07, Eric Roberts [EMAIL PROTECTED] wrote: Reactor is perfect for that...reactor is used in model-glue to handle CRUD ops...I assume it can be used on it's own as well... Eric -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 12:20 PM To: CF-Talk Subject: SOT: Best technology I am looking for the best technology to take some of my old web pages that basically do CRUD on database tables and updating them to have a better interface. Basically try to get away from page submissions. I am thinking Flex, but does Spry have ways or sending/receiving data as it is changed so I can update the database table? It might be easier to take my existing CF pages and make them use Spry then to redevelop them in Flex. The backend to do the data CRUD will be a CFC of some sort. I just have not had much time to play with these new languages and hope someone can give me some suggestions. Thanks, Chad ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What can PHP do that CF can't?
Can we please get this worthless thread moved to CFCommunity, Michael? Please? Chris Worthless to who? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Which query would be better?
MySQL 5. Which would be the better choice for a report table. I'm concerned and want the query to run as fast as possible because there could end up being millions of records in it. I could add the number of fields I need (not worried about the flattening of this table and lack of normalization). Instructor1, instructor2, 3, 4, etc. Then query like this: AND (e2.instructor1id = cfqueryparam value=#ARGUMENTS.instructor# OR e2.instructor2id = cfqueryparam value=#ARGUMENTS.instructor# OR e2.instructor3id = cfqueryparam value=#ARGUMENTS.instructor# ) OR ... I could easily create a list of values, then use the IN keyword: AND someotherfield IN (cfqueryparam value=#ARGUMENTS.somevaluelist# list=yes) Thanks, Will ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Which query would be better?
I have no scientific evidence to back me up, but I would use the second list method in the query. I would think that the optimizers would handle a list better than multiple ORs. Also, it's easier to read. If you have control over the structure of the database, you may be better off changing the structure from having multiple columns (instructor1id, instructor2id, etc), to a separate table for instructor enrollments. Typically, a course management system would have the following tables: Courses --- course id course name Users - user id user name Enrollment -- course id user id role M!ke -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 9:31 PM To: CF-Talk Subject: Which query would be better? MySQL 5. Which would be the better choice for a report table. I'm concerned and want the query to run as fast as possible because there could end up being millions of records in it. I could add the number of fields I need (not worried about the flattening of this table and lack of normalization). Instructor1, instructor2, 3, 4, etc. Then query like this: AND (e2.instructor1id = cfqueryparam value=#ARGUMENTS.instructor# OR e2.instructor2id = cfqueryparam value=#ARGUMENTS.instructor# OR e2.instructor3id = cfqueryparam value=#ARGUMENTS.instructor# ) OR ... I could easily create a list of values, then use the IN keyword: AND someotherfield IN (cfqueryparam value=#ARGUMENTS.somevaluelist# list=yes) Thanks, Will ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291686 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion hosting recomendation ?
Thanks Guys... Yes... I have heard several same good recommendations for cfdynamics. will ask and test their speed from japan. One thing I want to make sure... If I am going to build a dedicated machine, ...should I still try to find a coldfusion hosting ? ...or... any windows support hosting will do fine (in this case, I have to install / manage all coldfusion related setting). I am asking this.. because several years ago... a hosting company in Japan (windows based) they refused my inquiry because they did not support coldfusion. Hmm... I wonder... why did they refuse ? ..since I have my own dedicated server, my own coldfusion web server.. etc. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfimage generating a color pallette from an image
I need to generate a color pallate for a user to select the correct HEX color to match a color used in an image. can CFimage pull the colors from an image? If not, does anyone have a suggestion. Thanks Matt Friedman ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DEATH to HOMESITE
I've started using a subversion vmware appliance in the free vmware player. Best of both worlds there. On 10/20/07, Cutter (CF Related) [EMAIL PROTECTED] wrote: It can be confusing. Fortunately other's have gone before you on this road. http://www.trajiklyhip.com/blog/index.cfm/2007/3/12/Configuring-a-Development-Environment-with-Apache-Subversion-TortoiseSVN-and-Subclipse Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com The best way to predict the future is to help create it Robert Rawlins - Think Blue wrote: This is very true Brian, I agree whole heartedly, However, in the past I've always found subversion a total pain in the arse to setup and configure, it's just very confusing. My guess is that this stems from the fact that it was seemingly developed with Linux in mind, with command lines and compiling binaries, if they made it a little more intuitive to people (I suspect a large number of new developers will opt for windows OS as its 'what they know'), instead of the linuxy style methods they've used, I'm sure it would be more widely adopted by less experienced developers. It reminds me of the same reason why so many people pick up the bad habit of developing using access databases, it's simply because to a beginner developer they seem more accessible than a proper DBMS, As a novice developer trying to figure out installation and configuration of MySQL or SQL Server is quite confusing, especially when you have to setup management studio or phpMyAdmin, whereas the concept of a single file which can be easily created in a nice desktop based GUI is very simple to grasp, so most novice developers will start with access, especially considering all that functionality comes 'out of the box' with m$ office. I completely agree that source control through a proper SVN approach will pay dividends, but it's just one of those concepts that isn't A) Publicised to people properly, if you mention subversion to most amateur developers they would stare blankly back at you, however, ftp is very familiar. And. B) Accessible and simple enough to implement, even with these 'one touch' style solutions that subversion released for windows users. They're just my thoughts, Another quick gripe is with some of the guides and support documents I've read in the past, they're always typical Linux user style blog posts and forum remarks, showing a total lack of sympathy toward new and learning developers, making wide sweeping statements like 'and then simply update your system environment variables, and you're done!'... amateur users won't have a clue what you're on about, even someone whom is reasonably experienced with Linux development finds that stuff confusing. Heh, man I'm in a tired and grouchy mood today, can you tell? Lol Sorry for the rantish post chaps, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 20 October 2007 15:43 To: CF-Talk Subject: Re: DEATH to HOMESITE I was going to say the same thing. This issue isn't really a case of Homesite vs. Eclipse, it's about always, always, always using source control. Always. On 10/19/07, Paul Vernon [EMAIL PROTECTED] wrote: F*cking HomeSite+ wiped out my file on the server (AGAIN). I do a file write, it hangs, and I have to kill HomeSite. When I start homesite again, guess what, the file is gone from the server. Source control, Source control, Source control or to put it more concisely, SVN, SVN, SVN! There are some great Subversion plugins for CFEclipse :-) Subclipse is the one I believe most of the CFEclipse users use... Paul ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion hosting recomendation ?
NUGROHO NOTO wrote: Thanks Guys... Yes... I have heard several same good recommendations for cfdynamics. i'll also echo the recommendations for cfdynamics. they are so reliable i sometimes forget exactly who we're hosting with ;-) One thing I want to make sure... If I am going to build a dedicated machine, ...should I still try to find a coldfusion hosting ? ...or... any windows support hosting will do fine (in this case, I have to install / manage all coldfusion related setting). while you might find more cheaper plain windows hosts, having somebody who knows coldfusion certainly won't hurt. I am asking this.. because several years ago... a hosting company in Japan (windows based) they refused my inquiry because they did not support coldfusion. Hmm... I wonder... why did they refuse ? ..since I have my own dedicated server, my own coldfusion web server.. etc. because never say never, while you think you'll never need any help w/cf on the dedicated box i bet they're experience is different. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DEATH to HOMESITE
Which subversion appliance are you using? Rick -Original Message- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 10:39 PM To: CF-Talk Subject: Re: DEATH to HOMESITE I've started using a subversion vmware appliance in the free vmware player. Best of both worlds there. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion hosting recomendation ?
Thanks. I will try to contact cfdynamic.com regarding moving database etc... which I feel a bit scary how to do this. also... this database moving will involving Paul (for unicode translation) So... any personal name recommendation I should contact ? I need someone who can explain to me in an EASY to understand language. (I am not a server admin... so... never do like this before) ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DEATH to HOMESITE
This one. http://www.young-technologies.com/Software/Subversion-Virtual-Machine/ On 10/20/07, Rick Faircloth [EMAIL PROTECTED] wrote: Which subversion appliance are you using? Rick -Original Message- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 10:39 PM To: CF-Talk Subject: Re: DEATH to HOMESITE I've started using a subversion vmware appliance in the free vmware player. Best of both worlds there. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion hosting recomendation ?
NUGROHO NOTO wrote: Thanks. I will try to contact cfdynamic.com regarding moving database etc... which I feel a bit scary how to do this. if you have books-on-line installed, have a look at the Copying Databases to Other Servers section. as you can see there are a bunch of ways to handle this, but mainly: - live server-to-server (bcp, DTS, replication, etc.) - dead backup-restore i'd recommend the dead method which you can easily test with your current remote production sql server your local dev one. do a full backup of your production db, copy it local, then try restoring it on your dev box. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4