Re: Determining gender....when good info is available
100% kludge, but it works: http://barneyb.com/r/guess_sex.cfm Source is below the HR, and there's a Groovy in a comment. Slightly different semantics, but same general idea. Neither one handles all the edge cases properly. cheers, barneyb On Wed, Mar 25, 2009 at 10:11 PM, Doug Smidt wrote: > > This isn't so much a "gender-specific" question as it is a parsing question. > I need to figure out the gender of the person from some bio information. > Here's an example: > > "Tracy Smith is our finest pole-vaulter. He has set many team records, and > his personal best is 19' 8". Tracy's other hobbies are race cars and reading > about the migration of polar bears, but his real passion is fly fishing. His > eight year old daughter also loves fishing, and she always catches the big > ones!" > > A short example, but one that fits the bill. It's unlikely the sentence > about his daughter will be in there, but it's something I would like to be > prepared for. Using keywords such as "his", "him", "he", "Mr.", etc., what > would be the best way to parse this out and keep a running total of the > number of "male" and "female" keywords that hit and return a "Mr." or "Mrs." > based on the one with the highest total. > > I realize this isn't 100%, and I'd rather not get into a debate about the > not-so-foolproof nature of this and instead focus on the most efficient way > to parse this data and make a best-guess effort at getting the right one. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
Enterprise doesn't offer perf increase, cf8 runs noticeably on 64 bit than cf7. Enterprise only offers cluster management. On 3/25/09, Ben Mueller wrote: > > Apologies if this has been asked and answered countless times, but... > > We're about to upgrade our infrastructure from CF7 to 8, and are trying to > determine if the Enterprise edition is worth the cost. We've heard (mostly > from our hosting company) that CF8 Enterprise running on a 64-bit server > offers a serious performance boost over CF8 standard, but I haven't really > been able to find any other sources that line up cost vs. performance in any > meaningful way. We'd of course like to run Enterprise, but our business > guys are likely to balk at the cost unless we have some good ammunition. > > Our current production environment is 2 web boxes running Windows2003, IIS > and CF7 Standard. Glancing at the features of Enterprise over Standard, > it's probably the case that we only really care about server monitoring and > maybe high-volume email--aside from speed improvements. > > Another wrinkle is that we're going to move to a virtual server environment > (specifically, Hosting.com's "Cloud 9" service, which runs on top of VMWare, > and just sounds really cool). If anybody has any words of wisdom about that > kind of environment (e.g. "it's production-ready" or "run screaming now"), > it would be appreciated. > > Thanks in advance, > Ben > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320980 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Determining gender....when good info is available
This isn't so much a "gender-specific" question as it is a parsing question. I need to figure out the gender of the person from some bio information. Here's an example: "Tracy Smith is our finest pole-vaulter. He has set many team records, and his personal best is 19' 8". Tracy's other hobbies are race cars and reading about the migration of polar bears, but his real passion is fly fishing. His eight year old daughter also loves fishing, and she always catches the big ones!" A short example, but one that fits the bill. It's unlikely the sentence about his daughter will be in there, but it's something I would like to be prepared for. Using keywords such as "his", "him", "he", "Mr.", etc., what would be the best way to parse this out and keep a running total of the number of "male" and "female" keywords that hit and return a "Mr." or "Mrs." based on the one with the highest total. I realize this isn't 100%, and I'd rather not get into a debate about the not-so-foolproof nature of this and instead focus on the most efficient way to parse this data and make a best-guess effort at getting the right one. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320979 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) W32.Virut.W
Michael Dinowitz wrote: > The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a > way to remove this virus remotely on a windows 2000 machine? I can't boot it > into safe mode so that's not an option. > Thanks > We have used TrendMicro's Housecall successfully on some virii or check the other online ones: http://www.precisesecurity.com/antivirus/online-scan.htm -- Yours, Kym Kovan mbcomms.net.au ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320978 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) W32.Virut.W
Michael I think the online virus scanner by Eset can do that. -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 2009-03-25 22:55 To: cf-talk Subject: (OT) W32.Virut.W The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a way to remove this virus remotely on a windows 2000 machine? I can't boot it into safe mode so that's not an option. Thanks -- Michael Dinowitz (http://www.linkedin.com/in/mdinowitz) President: House of Fusion(http://www.houseoffusion.com) Publisher: Fusion Authority(http://www.fusionauthority.com) Adobe Community Expert / Advanced Certified ColdFusion Professional Si, soy el senor "chico malo" para todos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(OT) W32.Virut.W
The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a way to remove this virus remotely on a windows 2000 machine? I can't boot it into safe mode so that's not an option. Thanks -- Michael Dinowitz (http://www.linkedin.com/in/mdinowitz) President: House of Fusion(http://www.houseoffusion.com) Publisher: Fusion Authority(http://www.fusionauthority.com) Adobe Community Expert / Advanced Certified ColdFusion Professional Si, soy el senor "chico malo" para todos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
Enterprise will become more important for you if you move to VM servers. CF8 standard is licensed per VM server (or per 2 CPUs, whichever is greater). This adds up very quickly. By comparison, Enterprise is licensed only by the count of CPUs and the physical server count. For example let's say you want 10 VM servers; 5 out of each of two boxes with 2 CPUs in each box. Two copies of CF Enterprise will cover this. For Standard, you'll need 10. All covered in section 3.1: http://www.adobe.com/products/eulas/pdfs/AdobeColdFusion8.0.1_Combined_11-06-2007.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/26 Ben Mueller : > > Apologies if this has been asked and answered countless times, but... > > We're about to upgrade our infrastructure from CF7 to 8, and are trying to > determine if the Enterprise edition is worth the cost. We've heard (mostly > from our hosting company) that CF8 Enterprise running on a 64-bit server > offers a serious performance boost over CF8 standard, but I haven't really > been able to find any other sources that line up cost vs. performance in any > meaningful way. We'd of course like to run Enterprise, but our business guys > are likely to balk at the cost unless we have some good ammunition. > > Our current production environment is 2 web boxes running Windows2003, IIS > and CF7 Standard. Glancing at the features of Enterprise over Standard, it's > probably the case that we only really care about server monitoring and maybe > high-volume email--aside from speed improvements. > > Another wrinkle is that we're going to move to a virtual server environment > (specifically, Hosting.com's "Cloud 9" service, which runs on top of VMWare, > and just sounds really cool). If anybody has any words of wisdom about that > kind of environment (e.g. "it's production-ready" or "run screaming now"), it > would be appreciated. > > Thanks in advance, > Ben > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320975 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 do you get motivated at work?
>> If you're bored with an aspect of coding, try to automate it or abstract it away so you don't have to write the same things over and over again. +1 for that. If you are writing the same things over and over it is definitely time to automate or abstract the process for creating these items. If you find the exact same instance of code in a site or sites. EX:: file upload, login forms and validation, menu items, queries, etc. it would serve you well to abstract these into functions or custom tags. I am also assuming that you are talking about writing code for talking to databases. Perhaps wrongly. If not... There are tons of code generators and tools for abstracting your database and creating crud code (transfer, reactor, Data faucet, Illudium, Squidhead, CF Gen, ICEGen etc etc.) . And if those don't do what you want cfdbinfo makes it ridiculously easy write your own code generator. With all the tools out there, there is absolutely no reason for CFers be be writting forms, list pages, queries or CFCs by hand for basic CRUD functions. G! On Sat, Mar 21, 2009 at 8:22 PM, Justin Scott wrote: > > > My way of keeping motivated is to make money while I > > code. Money is a big motivator. It keeps one happy and > > motivated to take the next step. > > For me, the money itself isn't the motivator, but what it allows me to do. > My coding pays for things like flight training and other fun stuff to do. > > From the original post, it sounds as though the poster is getting bored > doing the same type of things all the time. Maybe the approach just needs > to change. If you're bored with an aspect of coding, try to automate it or > abstract it away so you don't have to write the same things over and over > again. There is always room for improvement, and I find that when these > ruts come up, time is ripe to start looking for places to improve upon. > > > -Justin Scott > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Fwd: public call for speakers...cf.O
Hi all, You might have already heard that cf.Objective() is coming to the Pacific region and that we're going to hold cf.Objective(ANZ) in Melbourne, AU later this year (12 & 13 November 2009). At this stage we're opening the public call for speakers. If you're interested in coming over to Melbourne and present on a topic that goes along nicely with the "ColdFusion Enterprise Development" scheme cf.Objective() has become successful in the US, we'd like to hear from you. Topics we're looking for fit into (but are not limited to) the following major categories: Architecture and Design: OOP, Design Patterns, Frameworks, Modeling, Refactoring Legacy Apps, Persistence etc. RIA: LC DS and CF, Ajax/Flex with CF, BlazeDS and CF etc. Process and Methodology: Agile Development, SOA, Managing large CF architectures, Debugging and Metrics etc. Integration and Testing: CF and Java, Build and Deployment processes, Server tuning, Unit Testing etc. Please let us know by April, 24 2009 if you're interested in coming to Melbourne to present at cf.Objective(ANZ). A short blurb about yourself and one or multiple topics you'd be interested in presenting on would be very appreciated. Please send all topic submissions to speak...@cfobjective.com.au . cf.Objective(ANZ) will provide speaker accommodation for the night of the 12th to the 13th of November 2009 at the conference venue (Renaissance Hotel in Melbourne). At this stage we unfortunately can't provide any further financial assistance with travel cost or other expenses. We look forward to hearing from you! cf.Objective(ANZ) Steering Group ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF & Facebook
Hi Michael, Sorry, I don't check house of fusion often. Based upon what you described, I would say that you can have your users create a profile on your web site. In this profile, you will have a field that would allow users to give you/your company permission to post video on their profiles (instead of granting permission on a per video basis). As long as this field is set to true, you would use XFBML to call fb:serverfbml to upload video clips to the users' profiles. Monte > Hi Monte, > > I've tried responding via email a couple times, but it didn't seem to > take (very odd), so now I'm trying through the website. > > Facebook Connect is closer to what I need, but I was hoping for > something seamless for our users (who are *ahem*, mostly less than > computer savvy). I was reading up on Connect, and it looks like I > still need to have authorization from the user to upload video to > their account. Is there a way to do this with my CF templates? > Basically, setup your Facebook account here CF page, with > username/password and authorization to upload video to your account? > > I know that iPhoto does this, but is this a case of Apple telling > Facebook that they want to do this because we're Apple? > > YouTube was simple compared to this... > > Thanks Again! > > Michael > > > Hi Michael, > > > > I have done five Facebook apps using ColdFusion and there are 3 > others > > in the works right now. > > > > In addition to the "traditional" Facebook application, Facebook now > > > has the Facebook Connect option. What Facebook Connect allows you to > > > do is for you to allow your users to log on using their Facebook > user > > name and password. As a result, you can also access their Facebook > > > profiles/information. You can view the details of Facebook Connect > on > > http://wiki.developers.facebook.com/index.php/Facebook_Connect > > > > That said, you can keep the video files on your company site. At the > > > same time, you incorporate the Facebook Connect option on your > company > > site too. If anyone logs on using their Facebook credentials, you > can > > provide an option for them to authorize your company to post the > video > > files on their own profiles. This way, you are not creating a > Facebook > > application but you get the job done. Is this the solution that you > > > are looking for? > > > > Best Regards, > > Monte > > > > >Ok, here's the issue I present to the gurus on this list. > > > > > >I know absolutely nothing about Facebook, I just created an account > > > >recently. The only thing I've found out is what an amazing time > > sucking > > >application it is. > > > > > >But, my company (i.e. sales weenies who convinced the CEO) > determined > > > > >that we must upload our video files (.mp4s to be precise) to > Facebook. > > > > >Both to our own company page, and if one of our users enters their > > > >username and password, to their page as well. > > > > > >Is there an easy way to do this? I've already looked through the > > >ColdFusion & Facebook Dev site by Gavin Vincent, and it looks like > > > way > > >more than I need. And the documentation on Facebook keeps stating > > that I > > >need to create an app, but from my (admittedly) very limited > > >understanding of Facebook apps, is that the other user would have > to > > > > >"approve" of my app to gain access to their page to upload the > video. > > > > >We really need this to be as simple as possible for our users, i.e. > > > all > > >they have to do is enter their Facebook login info and my code will > > > do > > >the rest. > > > > > >If I have to build a full-blown app, I will, but I was hoping > > somebody > > >on this list has done this before and can at least point me in the > > > right > > >direction. > > > > > >Thanks in Advance! > > > > > >Michael ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320972 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF & Facebook
Hi Michael, Sorry, I don't check house of fusion often. Based upon what you described, I would say that you can have your users create a profile on your web site. In this profile, you will have a field that would allow users to give you/your company permission to post video on their profiles (instead of granting permission on a per video basis). As long as this field is set to true, you would use XFBML to call fb:serverfbml to upload video clips to the users' profiles. Monte > Hi Monte, > > I've tried responding via email a couple times, but it didn't seem to > take (very odd), so now I'm trying through the website. > > Facebook Connect is closer to what I need, but I was hoping for > something seamless for our users (who are *ahem*, mostly less than > computer savvy). I was reading up on Connect, and it looks like I > still need to have authorization from the user to upload video to > their account. Is there a way to do this with my CF templates? > Basically, setup your Facebook account here CF page, with > username/password and authorization to upload video to your account? > > I know that iPhoto does this, but is this a case of Apple telling > Facebook that they want to do this because we're Apple? > > YouTube was simple compared to this... > > Thanks Again! > > Michael > > > Hi Michael, > > > > I have done five Facebook apps using ColdFusion and there are 3 > others > > in the works right now. > > > > In addition to the "traditional" Facebook application, Facebook now > > > has the Facebook Connect option. What Facebook Connect allows you to > > > do is for you to allow your users to log on using their Facebook > user > > name and password. As a result, you can also access their Facebook > > > profiles/information. You can view the details of Facebook Connect > on > > http://wiki.developers.facebook.com/index.php/Facebook_Connect > > > > That said, you can keep the video files on your company site. At the > > > same time, you incorporate the Facebook Connect option on your > company > > site too. If anyone logs on using their Facebook credentials, you > can > > provide an option for them to authorize your company to post the > video > > files on their own profiles. This way, you are not creating a > Facebook > > application but you get the job done. Is this the solution that you > > > are looking for? > > > > Best Regards, > > Monte > > > > >Ok, here's the issue I present to the gurus on this list. > > > > > >I know absolutely nothing about Facebook, I just created an account > > > >recently. The only thing I've found out is what an amazing time > > sucking > > >application it is. > > > > > >But, my company (i.e. sales weenies who convinced the CEO) > determined > > > > >that we must upload our video files (.mp4s to be precise) to > Facebook. > > > > >Both to our own company page, and if one of our users enters their > > > >username and password, to their page as well. > > > > > >Is there an easy way to do this? I've already looked through the > > >ColdFusion & Facebook Dev site by Gavin Vincent, and it looks like > > > way > > >more than I need. And the documentation on Facebook keeps stating > > that I > > >need to create an app, but from my (admittedly) very limited > > >understanding of Facebook apps, is that the other user would have > to > > > > >"approve" of my app to gain access to their page to upload the > video. > > > > >We really need this to be as simple as possible for our users, i.e. > > > all > > >they have to do is enter their Facebook login info and my code will > > > do > > >the rest. > > > > > >If I have to build a full-blown app, I will, but I was hoping > > somebody > > >on this list has done this before and can at least point me in the > > > right > > >direction. > > > > > >Thanks in Advance! > > > > > >Michael ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
Ben, There are no JET drivers... You can still access excel in other ways :) -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ben Mueller [mailto:bmuel...@gmail.com] Sent: Wednesday, March 25, 2009 2:12 PM To: cf-talk Subject: Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment? Thanks for the reply. So it's really the case that there's no way to access an Excel doc via the 64-bit edition? That could be a bit of a stumbling block. >The ability to run 64 bit is sometimes worth the cost... More to do >with hardware than CF :) For one thing you can run a huge heap on 64x >- there is no more 1.5 gig limitation on the JVM heap size. That's very >important for some applications that have reached their limit. You can >also use cfthread and fine tune the threading for other processes that used to be limited... > >We had a plan for a 2 LB server solution for a customer with a couple >million visitors a day. We moved them to a single 64 bit server >(connected to a 64 bit MSSQL server) and they haven't had a single >timed out response yet. We are moving at a leisurely pace to get the >other server in the LB since there are no longer any performance issues. > >Just remember, you can't run Jet (Access or Excel) on 64 bit. If you >are using Access or the jet driver to hit excel etc then you should reconsider. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TimeFormat
Perfect Scott, Thanks Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu slaba...@po-box.esu.edu -Original Message- From: Scott Stroz [mailto:boyz...@gmail.com] Sent: Wednesday, March 25, 2009 3:54 PM To: cf-talk Subject: Re: TimeFormat Try - Steve LaBadie ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TimeFormat
Try - On Wed, Mar 25, 2009 at 3:34 PM, Steve LaBadie wrote: > > I have an XML file that is generating a time span of 7:00 AM - 7:00 PM. > Is there a way to print this to the screen? For my current code to work > I have to physically remove the trailing time stamp. > > > > > > > > #time# > > > > Steve LaBadie, Web Manager > > East Stroudsburg University > > 200 Prospect St. > > East Stroudsburg, Pa 18301 > > 570-422-3999 > > http://www.esu.edu > > slaba...@po-box.esu.edu > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320968 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: delete directory when user navigates away from site
Cool I will give it a try. Thanks for the pointer to docs. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TimeFormat
I have an XML file that is generating a time span of 7:00 AM - 7:00 PM. Is there a way to print this to the screen? For my current code to work I have to physically remove the trailing time stamp. #time# Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu slaba...@po-box.esu.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: delete directory when user navigates away from site
> Subject: delete directory when user navigates away from site > Any thoughts on how to do this? I am not that familiar with > advanced session capabilities. See the osSessionEnd() method of Application.cfc. Adobe docs here: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=AppEvents_ 01.html Select method summary, then onSessionEnd() for details. -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple Record Queries and CFCs
Well you've run into the big problem with using ColdFusion and objects. The object instantiation speed in ColdFusion is unacceptably slow, when you get up into a large number of objects. The best solution to this problem that I've found is the IBO (iterating business object). Essentially, rather than instantiating a large number of objects, you create a single object which has a struct of arrays to contain the query data. It takes a while to wrap your head around it, but it's well worth the effort. For more information do a search for Peter Bell ColdFusion IBO. He's the one that came up with the idea when he ran into the same problem. -- Josh -Original Message- From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] Sent: Wednesday, March 25, 2009 12:56 PM To: cf-talk Subject: Multiple Record Queries and CFCs I have been trying to write my applications using the 3 tiered method of development, presentation layer, business logic layer and data access layer. I am having trouble coming up with an efficient method of displaying information returned in a query that has multiple records. Correct me if I'm wrong, but shouldn't all data be placed into an object based on a component so that the business logic can massage the data and return valid inforamtion based on business rules. If I am correct that that means that I should create an object for every record of the query before I display the data. Doing this slows down my web pages by 100-200% going from fractions of a second to around 20 seconds for a query that returns 100 records. All of the examples that I have come across on the web run the query in the data application layer and then in the presentation layer, loop over the query and output the data straight from the query (i.e. #qEmployees.firstName#). The problem I have with outputting the data straight from the query is that I will have to have business logic in 2 places. In the business logic component and the data access component. How are you (anyone who would like to reply) handling this scenario and keeping the integrity of the business logic? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Record Queries and CFCs
Brad, Thanks for the quick reply! This is kind of difficult to search for on Google and I have found nothing. Up until now, I have been creating an object outside of the loop and then setting the data to the object inside the loop. At the end of each iteration, I call a Reset() function. My components have 2 stuctures as proerties, Variables.default and Variables.instance. I set the Variables.default keys in the "Constructor", code at the top of the component, and then I set all of the Variables.instance keys to the corresponding key values from Variables.default. The Reset() function sets all of the Variables.instance keys back to the corresponding key values from Variables.default. This method is faster than instantiating everytime, but it is still slower than desired. I will check out the links you sent and see what I can find. Thanks again. -Donnie > Welcome to the Object Instantiation Penalty. :) > ColdFusion is much slower at object creation than Java or C++ when > you > are dealing with thousands of object. > http://www.codersrevolution.com/index. > cfm/2008/9/22/ColdFusions-Object-Instantiation-Penalty-How-Bad-Is-It > > This got better in CF8 and is supposed to get better in CF9. In the > mean > time, look into a CF-specific design pattern called IBO or Iterating > Business Object. > It is a single object that contains a result set and gives you > programattic access to the data on each row via getters and setters. > > http://www.pbell.com/index. cfm/2007> /6/20/IBO-20--Return-of-the-Iterating-Business-Object-Now-on-RIAForge > http://ibo.riaforge.org/ > > It is not without it's own problems, but it directly addresses your > problem. > > ~Brad > > Original Message > Subject: Multiple Record Queries and CFCs > From: Donnie Carvajal > Date: Wed, March 25, 2009 2:55 pm > To: cf-talk > > > I have been trying to write my applications using the 3 tiered method > of > development, presentation layer, business logic layer and data access > layer. I am having trouble coming up with an efficient method of > displaying information returned in a query that has multiple records. > Correct me if I'm wrong, but shouldn't all data be placed into an > object > based on a component so that the business logic can massage the data > and > return valid inforamtion based on business rules. If I am correct > that > that means that I should create an object for every record of the > query > before I display the data. Doing this slows down my web pages by > 100-200% going from fractions of a second to around 20 seconds for a > query that returns 100 records. All of the examples that I have come > across on the web run the query in the data application layer and > then > in the presentation layer, loop over the query and output the data > straight from the query (i.e. #qEmployees.firstName#). The problem I > have with outputting the data straight from the query is that I will > have to have business logic in 2 places. In the business logic > component > and the data access component. > > How are you (anyone who would like to reply) handling this scenario > and > keeping the integrity of the business logic? > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: delete directory when user navigates away from site
Are you using Application.cfc? You can use on SessionEnd to do your dirty work. Paul Giesenhagen QuillDesign http://www.quilldesign.com -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Wednesday, March 25, 2009 3:01 PM To: cf-talk Subject: delete directory when user navigates away from site Any thoughts on how to do this? I am not that familiar with advanced session capabilities. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
The number in the item checkbox would the primary key of the item in the items table, if you always have this of items then that is the simplest solution, your both over complicating, not the arbitrary order they appear on the page. You would join to the items table based on the order number, but your where cause would select based on the item's primary keys, not the order numbers. thus the order number would be contained in the result query as it is now. Your trying to have coldfusion do too much work that SQL could more simply do. Also ANSI style outter joins are deprecated and would be better be avoided. I stand by my original suggestion. On Wed, Mar 25, 2009 at 10:40 AM, Azadi Saryev wrote: > > use with GROUP attribute. details are in the cfml reference - > check it out as it is very particular syntax requiring nested > tags: > > > #columns_you_do_NOT_want_repeated# > > #columns_you_need_repeated_for_each_column-name# > > #maybe_other_columns_you_do_NOT_want_repeated_below_repeated_output# > > > you can also nest multiple tags with different GROUP > attributes, too. > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > > Jason Congerton wrote: > > Hi > > > > Thank you for your replies, you are correct Azadi, I can not just have > check boxes with the same name. > > > > I have resolved my issue in the following way, > > > > I removed the group attribute from my initial form output which returned > one row for each order item I added an orderitem_id#currentrow# hidden > field, created two lists, one for orderid and one for the orderitems id, and > used the IN operator on my query. > > > > Which now returns the desired results! > > > > I have one slight problem with the initial display, its a little messy. > Lets say the customer has ordered three items, now that I have removed the > grouping(so I can get at individual items) the customer name is returned 3 > times as well, can I use some conditions to stop this, or be able to group > color the rows for the particular customer. > > > > Jason > > > > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Record Queries and CFCs
I like to use an 'iterating business object', or IBO. At its most basic, the component has the cfquery object as a property, as well as a pointer to the current row. It has methods for looping the query, ie. next(), previous(), first(), last(), etc. These I put in a base IBO component. It also has business logic methods that apply to the current row, and these I put in the individual IBOs that extend the base. The IBO takes a Data Access Object (DAO) as an argument in it's constructor and I standardize my DAO methods so this can be done generically (but can be tweaked if neccessary). It is basically bean and gateway in one - without all the wasteage. An example useage might look like: myTableIbo.load( myPkId ); // here the ibo would call its DAO's load method and set the resultant query as its query property, ready to be iterated #myTableIbo.getSomeColumn()# I actually prefer to just use plain queries in my display pages and have a getQuery() method in the IBO for releasing the query for display - but using the IBO in the display page doesn't bother me either. Dominic 2009/3/25 Donnie Carvajal : > > I have been trying to write my applications using the 3 tiered method of > development, presentation layer, business logic layer and data access layer. > I am having trouble coming up with an efficient method of displaying > information returned in a query that has multiple records. Correct me if I'm > wrong, but shouldn't all data be placed into an object based on a component > so that the business logic can massage the data and return valid inforamtion > based on business rules. If I am correct that that means that I should > create an object for every record of the query before I display the data. > Doing this slows down my web pages by 100-200% going from fractions of a > second to around 20 seconds for a query that returns 100 records. All of the > examples that I have come across on the web run the query in the data > application layer and then in the presentation layer, loop over the query and > output the data straight from the query (i.e. #qEmployees.firstName#). The > problem I have with outputting the data straight from the query is that I > will have to have business logic in 2 places. In the business logic > component and the data access component. > > How are you (anyone who would like to reply) handling this scenario and > keeping the integrity of the business logic? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple Record Queries and CFCs
Welcome to the Object Instantiation Penalty. :) ColdFusion is much slower at object creation than Java or C++ when you are dealing with thousands of object. http://www.codersrevolution.com/index.cfm/2008/9/22/ColdFusions-Object-Instantiation-Penalty-How-Bad-Is-It This got better in CF8 and is supposed to get better in CF9. In the mean time, look into a CF-specific design pattern called IBO or Iterating Business Object. It is a single object that contains a result set and gives you programattic access to the data on each row via getters and setters. http://www.pbell.com/index.cfm/2007/6/20/IBO-20--Return-of-the-Iterating-Business-Object-Now-on-RIAForge http://ibo.riaforge.org/ It is not without it's own problems, but it directly addresses your problem. ~Brad Original Message Subject: Multiple Record Queries and CFCs From: Donnie Carvajal Date: Wed, March 25, 2009 2:55 pm To: cf-talk I have been trying to write my applications using the 3 tiered method of development, presentation layer, business logic layer and data access layer. I am having trouble coming up with an efficient method of displaying information returned in a query that has multiple records. Correct me if I'm wrong, but shouldn't all data be placed into an object based on a component so that the business logic can massage the data and return valid inforamtion based on business rules. If I am correct that that means that I should create an object for every record of the query before I display the data. Doing this slows down my web pages by 100-200% going from fractions of a second to around 20 seconds for a query that returns 100 records. All of the examples that I have come across on the web run the query in the data application layer and then in the presentation layer, loop over the query and output the data straight from the query (i.e. #qEmployees.firstName#). The problem I have with outputting the data straight from the query is that I will have to have business logic in 2 places. In the business logic component and the data access component. How are you (anyone who would like to reply) handling this scenario and keeping the integrity of the business logic? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
For me, one of the big advantages to having enterprise is the lack of throttling on tags like cfdocument, cfthread, cfexchange, cfreport, and event gateways. If your app doesn't have any heavy use of the throttled features it might not be a big deal but if PDF generation for example is a huge feature and will be used a lot it might be a requirement to go with Enterprise so your requests won't get backed up under load. ~Brad Original Message Subject: CF8 Enterprise worth the cost? Any experience with it in a virtual environment? From: Ben Mueller Date: Wed, March 25, 2009 1:49 pm To: cf-talk Apologies if this has been asked and answered countless times, but... We're about to upgrade our infrastructure from CF7 to 8, and are trying to determine if the Enterprise edition is worth the cost. We've heard (mostly from our hosting company) that CF8 Enterprise running on a 64-bit server offers a serious performance boost over CF8 standard, but I haven't really been able to find any other sources that line up cost vs. performance in any meaningful way. We'd of course like to run Enterprise, but our business guys are likely to balk at the cost unless we have some good ammunition. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
delete directory when user navigates away from site
Any thoughts on how to do this? I am not that familiar with advanced session capabilities. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Multiple Record Queries and CFCs
I have been trying to write my applications using the 3 tiered method of development, presentation layer, business logic layer and data access layer. I am having trouble coming up with an efficient method of displaying information returned in a query that has multiple records. Correct me if I'm wrong, but shouldn't all data be placed into an object based on a component so that the business logic can massage the data and return valid inforamtion based on business rules. If I am correct that that means that I should create an object for every record of the query before I display the data. Doing this slows down my web pages by 100-200% going from fractions of a second to around 20 seconds for a query that returns 100 records. All of the examples that I have come across on the web run the query in the data application layer and then in the presentation layer, loop over the query and output the data straight from the query (i.e. #qEmployees.firstName#). The problem I have with outputting the data straight from the query is that I will have to have business logic in 2 places. In the business logic component and the data access component. How are you (anyone who would like to reply) handling this scenario and keeping the integrity of the business logic? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: html in database
Phillip Vector wrote: > Can't you Evaluate it instead? Works for me. Evaluate will handle embedded variables, but will not handle embedded CFML. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
Ben Mueller wrote: > Apologies if this has been asked and answered countless times, but... > For *us* its worth the cost for the Oracle driver and the ability to create multiple ColdFusion instances, the 64 bit came in third. But if one is not using Oracle, then this order would not make sense. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: html in database
On Wed, Mar 25, 2009 at 2:23 PM, Phillip Vector wrote: > > Can't you Evaluate it instead? Works for me. > Stored in (WelcomeLetter.HTML) ~ Dear #Customer.FirstName# Welcome to #APPLICATION.WebsiteName# ~ #evaluate(de(WelcomeLetter.HTML))# Not sure if it would work with a cfinclude, I'm thinking it would though. Outside of the performance issue, you need to be 100% confident that you know what is saved in this column. I mean 1000% sure. I do this from time to time but paste it into the DB directly, no administration interface for it so I know what's in there. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
>>>So it's really the case that there's no way to access an Excel doc via the 64-bit edition? To clarify, you can't acccess Excel using the Jet driver, as a datasource. If you need to read/write/create an excel doc, you still can you'll just need to use some other tool. Like POI ( http://www.bennadel.com/projects/poi-utility.htm) or any of the third party tools available. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: html in database
Can't you Evaluate it instead? Works for me. On 3/25/09, Gert Franz wrote: > > Chad, > > yes that's normally the way to do it. > > You have to do something like this: > > output="#yourDatabaseCFMLContent#"> > > > In Railo you can create a RAM mapping that points to the server's ram. Let's > call it /ram > > Then you do the exact same like above: > output="#yourDatabaseCFMLContent#"> > > > The problem is that with writing something to the disk you always hurt > performance. That's why the "ramdisk" or let's say the virtual file system > in memory is much faster than writing it out. As far as I know CF9 will > support this as well, just as Railo does. > > Greetings from Switzerland > Gert Franz > Railo Technologies GmbH > gert.fr...@railo.ch > www.railo.ch > > Join our Mailing List > german: http://de.groups.yahoo.com/group/railo/ > english: http://groups.google.com/group/railo > linked in:http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 > Bug tracker: http://jira.jboss.org/jira/browse/RAILO > Railo Blog: http://www.railo-technologies.com/blog > > -Ursprüngliche Nachricht- > Von: Chad Gray [mailto:cg...@careyweb.com] > Gesendet: Mittwoch, 25. März 2009 17:13 > An: cf-talk > Betreff: RE: html in database > > > So save it as a file with cffile then cfinclude it? > > > >> -Original Message- >> From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] >> Sent: Wednesday, March 25, 2009 11:33 AM >> To: cf-talk >> Subject: Re: html in database >> >> >> On Wednesday 25 Mar 2009, Chad Gray wrote: >> > How do I insert a or any CF programming into the HTML when >> it >> > is pulled out of the database for display on the page? >> >> In Adobe ColdFusion, you have to write it to the desk then cfinclude it. >> Railo and OpenBD have a render() method, iirc. >> >> -- >> Tom Chiverton >> Helping to vitalistically improve products as part of the IT team of the >> year, '09 and '08 >> >> >> >> 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 >> 3EB. A list of members is available for inspection at the registered >> office together with a list of those non members who are referred to as >> partners. We use the word "partner" to refer to a member of the LLP, or >> an employee or consultant with equivalent standing and qualifications. >> Regulated by the Solicitors Regulation Authority. >> >> 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 2500. >> >> For more information about Halliwells LLP visit www.halliwells.co >> >> > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
Thanks for the reply. So it's really the case that there's no way to access an Excel doc via the 64-bit edition? That could be a bit of a stumbling block. >The ability to run 64 bit is sometimes worth the cost... More to do with >hardware than CF :) For one thing you can run a huge heap on 64x - there is >no more 1.5 gig limitation on the JVM heap size. That's very important for >some applications that have reached their limit. You can also use cfthread >and fine tune the threading for other processes that used to be limited... > >We had a plan for a 2 LB server solution for a customer with a couple >million visitors a day. We moved them to a single 64 bit server (connected >to a 64 bit MSSQL server) and they haven't had a single timed out response >yet. We are moving at a leisurely pace to get the other server in the LB >since there are no longer any performance issues. > >Just remember, you can't run Jet (Access or Excel) on 64 bit. If you are >using Access or the jet driver to hit excel etc then you should reconsider. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
The ability to run 64 bit is sometimes worth the cost... More to do with hardware than CF :) For one thing you can run a huge heap on 64x - there is no more 1.5 gig limitation on the JVM heap size. That's very important for some applications that have reached their limit. You can also use cfthread and fine tune the threading for other processes that used to be limited... We had a plan for a 2 LB server solution for a customer with a couple million visitors a day. We moved them to a single 64 bit server (connected to a 64 bit MSSQL server) and they haven't had a single timed out response yet. We are moving at a leisurely pace to get the other server in the LB since there are no longer any performance issues. Just remember, you can't run Jet (Access or Excel) on 64 bit. If you are using Access or the jet driver to hit excel etc then you should reconsider. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ben Mueller [mailto:bmuel...@gmail.com] Sent: Wednesday, March 25, 2009 1:50 PM To: cf-talk Subject: CF8 Enterprise worth the cost? Any experience with it in a virtual environment? Apologies if this has been asked and answered countless times, but... We're about to upgrade our infrastructure from CF7 to 8, and are trying to determine if the Enterprise edition is worth the cost. We've heard (mostly from our hosting company) that CF8 Enterprise running on a 64-bit server offers a serious performance boost over CF8 standard, but I haven't really been able to find any other sources that line up cost vs. performance in any meaningful way. We'd of course like to run Enterprise, but our business guys are likely to balk at the cost unless we have some good ammunition. Our current production environment is 2 web boxes running Windows2003, IIS and CF7 Standard. Glancing at the features of Enterprise over Standard, it's probably the case that we only really care about server monitoring and maybe high-volume email--aside from speed improvements. Another wrinkle is that we're going to move to a virtual server environment (specifically, Hosting.com's "Cloud 9" service, which runs on top of VMWare, and just sounds really cool). If anybody has any words of wisdom about that kind of environment (e.g. "it's production-ready" or "run screaming now"), it would be appreciated. Thanks in advance, Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: scopes
It never hurts to ask. Thank you all for your time. seems simple but I am not sure if it sets the default form structure to refer to url structure or it creates a variables.form wihch refers to url. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Enterprise worth the cost? Any experience with it in a virtual environment?
Apologies if this has been asked and answered countless times, but... We're about to upgrade our infrastructure from CF7 to 8, and are trying to determine if the Enterprise edition is worth the cost. We've heard (mostly from our hosting company) that CF8 Enterprise running on a 64-bit server offers a serious performance boost over CF8 standard, but I haven't really been able to find any other sources that line up cost vs. performance in any meaningful way. We'd of course like to run Enterprise, but our business guys are likely to balk at the cost unless we have some good ammunition. Our current production environment is 2 web boxes running Windows2003, IIS and CF7 Standard. Glancing at the features of Enterprise over Standard, it's probably the case that we only really care about server monitoring and maybe high-volume email--aside from speed improvements. Another wrinkle is that we're going to move to a virtual server environment (specifically, Hosting.com's "Cloud 9" service, which runs on top of VMWare, and just sounds really cool). If anybody has any words of wisdom about that kind of environment (e.g. "it's production-ready" or "run screaming now"), it would be appreciated. Thanks in advance, Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
AW: html in database
Chad, yes that's normally the way to do it. You have to do something like this: In Railo you can create a RAM mapping that points to the server's ram. Let's call it /ram Then you do the exact same like above: The problem is that with writing something to the disk you always hurt performance. That's why the "ramdisk" or let's say the virtual file system in memory is much faster than writing it out. As far as I know CF9 will support this as well, just as Railo does. Greetings from Switzerland Gert Franz Railo Technologies GmbH gert.fr...@railo.ch www.railo.ch Join our Mailing List german: http://de.groups.yahoo.com/group/railo/ english:http://groups.google.com/group/railo linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 Bug tracker:http://jira.jboss.org/jira/browse/RAILO Railo Blog: http://www.railo-technologies.com/blog -Ursprüngliche Nachricht- Von: Chad Gray [mailto:cg...@careyweb.com] Gesendet: Mittwoch, 25. März 2009 17:13 An: cf-talk Betreff: RE: html in database So save it as a file with cffile then cfinclude it? > -Original Message- > From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] > Sent: Wednesday, March 25, 2009 11:33 AM > To: cf-talk > Subject: Re: html in database > > > On Wednesday 25 Mar 2009, Chad Gray wrote: > > How do I insert a or any CF programming into the HTML when > it > > is pulled out of the database for display on the page? > > In Adobe ColdFusion, you have to write it to the desk then cfinclude it. > Railo and OpenBD have a render() method, iirc. > > -- > Tom Chiverton > Helping to vitalistically improve products as part of the IT team of the > year, '09 and '08 > > > > 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 > 3EB. A list of members is available for inspection at the registered > office together with a list of those non members who are referred to as > partners. We use the word "partner" to refer to a member of the LLP, or > an employee or consultant with equivalent standing and qualifications. > Regulated by the Solicitors Regulation Authority. > > 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 2500. > > For more information about Halliwells LLP visit www.halliwells.co > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320946 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 server - Order totals by month, even without month data
I too would recommend creating a temp table with a record for every date you want represented in your graph. Instead of unioning it though, I usually left outer join from it to my data with an isnull on any number columns so they show up 0 for months where there was no data. ~Brad Original Message Subject: Re: SQL server - Order totals by month, even without month data From: Greg Morphis Date: Wed, March 25, 2009 7:26 am To: cf-talk Create a dummy table with the information for the current year and preform a UNION to your existing data On Wed, Mar 25, 2009 at 6:26 AM, Will Tomlinson wrote: > > I have your typical tblorders. I'm trying to query it to get order totals by > month, and I'm outputting them in > > All goes fine, except in 2009. We have no order data for April-December of > course, so the query returns just three rows (Jan, Feb, March). > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Delivery Report
use with GROUP attribute. details are in the cfml reference - check it out as it is very particular syntax requiring nested tags: #columns_you_do_NOT_want_repeated# #columns_you_need_repeated_for_each_column-name# #maybe_other_columns_you_do_NOT_want_repeated_below_repeated_output# you can also nest multiple tags with different GROUP attributes, too. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: > Hi > > Thank you for your replies, you are correct Azadi, I can not just have check > boxes with the same name. > > I have resolved my issue in the following way, > > I removed the group attribute from my initial form output which returned one > row for each order item I added an orderitem_id#currentrow# hidden field, > created two lists, one for orderid and one for the orderitems id, and used > the IN operator on my query. > > Which now returns the desired results! > > I have one slight problem with the initial display, its a little messy. Lets > say the customer has ordered three items, now that I have removed the > grouping(so I can get at individual items) the customer name is returned 3 > times as well, can I use some conditions to stop this, or be able to group > color the rows for the particular customer. > > Jason > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: scopes
If I ever need to do this, I just use: You don't need to duplicate the Struct, as you're not going to have any problems with the original URL data changing throughout the lifetime of the page. Seb On 25 Mar 2009, at 16:17, Adrian Lynch wrote: > > I'm not sure if you're saying it works or doesn't work. If it > doesn't, try > FORM.putAll(URL) or StructAppend(FORM, URL) to get the URL vars into > the > FORM scope. > > Adrian > >> -Original Message- >> From: Brian Dumbledore [mailto:psteja2...@yahoo.com] >> Sent: 25 March 2009 16:31 >> To: cf-talk >> Subject: scopes >> >> >> ok I was trying something and did this: >> >> >> >> >> >> And then I go about the rest as if the request came from a form >> post (I >> use form dot notation everywhere afterwards). >> >> When I did a it doesn't recognize the form scope, >> but this works >> >> >> >> But every where else in the code it works fine (recorgnizes all form >> dot names that were originally sent as url parameters) >> So is cf not supposed to handle the dump 'logically'? Can someone >> please reason this behavior? >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
Hi Thank you for your replies, you are correct Azadi, I can not just have check boxes with the same name. I have resolved my issue in the following way, I removed the group attribute from my initial form output which returned one row for each order item I added an orderitem_id#currentrow# hidden field, created two lists, one for orderid and one for the orderitems id, and used the IN operator on my query. Which now returns the desired results! I have one slight problem with the initial display, its a little messy. Lets say the customer has ordered three items, now that I have removed the grouping(so I can get at individual items) the customer name is returned 3 times as well, can I use some conditions to stop this, or be able to group color the rows for the particular customer. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320942 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 server - Order totals by month, even without month data
Create a dummy table with the information for the current year and preform a UNION to your existing data On Wed, Mar 25, 2009 at 6:26 AM, Will Tomlinson wrote: > > I have your typical tblorders. I'm trying to query it to get order totals by > month, and I'm outputting them in > > All goes fine, except in 2009. We have no order data for April-December of > course, so the query returns just three rows (Jan, Feb, March). > > I need it to return all 12 months, with 0 for the months with no orders > (April-Dec) > > I've played with this query and can't get anything to work for me. Any ideas? > > Thanks! > > Will > > select year(orderdate) as orderYear, > month(orderdate) as monthOrdered, > sum(ordertotal) as totalOrders, > dateName(month, orderdate) as monthName > from tblorders > where orderpaid = 1 > and year(orderdate) = 2009 > group by year(orderdate), > month(orderdate), > dateName(month, orderdate) > order by year(orderdate) asc, > month(orderdate) asc > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: scopes
I'm not sure if you're saying it works or doesn't work. If it doesn't, try FORM.putAll(URL) or StructAppend(FORM, URL) to get the URL vars into the FORM scope. Adrian > -Original Message- > From: Brian Dumbledore [mailto:psteja2...@yahoo.com] > Sent: 25 March 2009 16:31 > To: cf-talk > Subject: scopes > > > ok I was trying something and did this: > > > > > > And then I go about the rest as if the request came from a form post (I > use form dot notation everywhere afterwards). > > When I did a it doesn't recognize the form scope, > but this works > > > > But every where else in the code it works fine (recorgnizes all form > dot names that were originally sent as url parameters) > So is cf not supposed to handle the dump 'logically'? Can someone > please reason this behavior? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHeader - appending date to xls file name
> value="filename=ResolveIT_List#Now()#.xls"> > > > > #FirstName# > #LastName# > #Email# > #Address1# > #City# > #State# > #Zip# > > > > value="filename=MyFiles#DateFormat(TheDate, > 'mm-dd-yy')#.xls"> First, you can't embed one CFML tag within another. If an attribute value of a CFML tag contains an expression wrapped in hashes, it will automatically output to the string used for the attribute value. Bad: Good: Second, you can't specify multiple Content-Distribution headers within the same document. I'm not sure if that's what you're doing, but you do have two of them in your code sample. 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 inf ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: html in database
So save it as a file with cffile then cfinclude it? > -Original Message- > From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] > Sent: Wednesday, March 25, 2009 11:33 AM > To: cf-talk > Subject: Re: html in database > > > On Wednesday 25 Mar 2009, Chad Gray wrote: > > How do I insert a or any CF programming into the HTML when > it > > is pulled out of the database for display on the page? > > In Adobe ColdFusion, you have to write it to the desk then cfinclude it. > Railo and OpenBD have a render() method, iirc. > > -- > Tom Chiverton > Helping to vitalistically improve products as part of the IT team of the > year, '09 and '08 > > > > 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 > 3EB. A list of members is available for inspection at the registered > office together with a list of those non members who are referred to as > partners. We use the word "partner" to refer to a member of the LLP, or > an employee or consultant with equivalent standing and qualifications. > Regulated by the Solicitors Regulation Authority. > > 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 2500. > > For more information about Halliwells LLP visit www.halliwells.co > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320938 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Flash Form issue
> Hey Dave after I posted that I mapped a virtual directory in IIS which worked > for a single > page website I had for testing. > > Once I placed the flash form in a framework (each page is included in the > index.cfm) I get > the blank look. > > No errors or js errors of any kind just blank. Do you have this at a public URL? It's difficult to speculate further. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: scopes
oh yes, structAppend, of course! forgot about that one... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Aaron Rouse wrote: > Just use the StructAppend() function, a lot less code. > > > May or may not want that over write flag set to false, just depends on the > situation/goals. > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Solved:---- CFHeader - appending date to xls file name
Thanks all solved! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: scopes
Got you. So I guess in the above scenario, when I do a form dot, it resolves to variables dot form dot but if there is no dot (if I am accessing the whole structure), it doesn't try it in the variables scope. I did a #structkeylist(form)# and it came back as blank. Thanks for your time ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320934 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) about Vista - sql server 2005 express etc.
Thank you all for your bits on Vista. FYI, to those who have to deal with sql server 2005 express, a few days ago, XP SP3 had a serious problem with installing this sql server package due to the MSXML6.0 SP2 bugs. Don >Windows_NT > >I'm running Vista Home Premium > >Jake Churchill >CF Webtools >11204 Davenport, Ste. 100 >Omaha, NE 68154 >http://www.cfwebtools.com >402-408-3733 x103 > > > >Azadi Saryev wrote: >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: scopes
Just use the StructAppend() function, a lot less code. May or may not want that over write flag set to false, just depends on the situation/goals. On Wed, Mar 25, 2009 at 11:01 AM, Azadi Saryev wrote: > > all your "form dot names" are evaluated by cf as variables.form.somename > 'form' is a reserved scope name in cf. it is noted in cf reference > manual that one should NOT use built-in cf scope names as variable > names. when you do, you can never be sure what you get in the end... > like in your case, cf creates a variable named 'form' in the variables > scope - it has no relation to the built-in form scope (thus you get an > empty form dump). > > what you should use instead is: > > > > > > > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > > Brian Dumbledore wrote: > > ok I was trying something and did this: > > > > > > > > > > > > And then I go about the rest as if the request came from a form post (I > use form dot notation everywhere afterwards). > > > > When I did a it doesn't recognize the form scope, but > this works > > > > > > > > But every where else in the code it works fine (recorgnizes all form dot > names that were originally sent as url parameters) > > So is cf not supposed to handle the dump 'logically'? Can someone please > reason this behavior? > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHeader - appending date to xls file name
I want to add the DATE to my file name in cfheader but it did not work. Any suggestions SELECT * FROM blasts ORDER BY memberid #FirstName# #LastName# #Email# #Address1# #City# #State# #Zip# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: scopes
all your "form dot names" are evaluated by cf as variables.form.somename 'form' is a reserved scope name in cf. it is noted in cf reference manual that one should NOT use built-in cf scope names as variable names. when you do, you can never be sure what you get in the end... like in your case, cf creates a variable named 'form' in the variables scope - it has no relation to the built-in form scope (thus you get an empty form dump). what you should use instead is: Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Brian Dumbledore wrote: > ok I was trying something and did this: > > > > > > And then I go about the rest as if the request came from a form post (I use > form dot notation everywhere afterwards). > > When I did a it doesn't recognize the form scope, but > this works > > > > But every where else in the code it works fine (recorgnizes all form dot > names that were originally sent as url parameters) > So is cf not supposed to handle the dump 'logically'? Can someone please > reason this behavior? > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP with Stored Procedure
No, it's not right. As the documentation on the tag states, if you don't
specify a "result" attribute, the result is contained in "cfstoredproc".
On Wed, Mar 25, 2009 at 10:42 AM, Priya Koya wrote:
>
> I have a query and looping the results of a query. I want to display the
> names from the cfdocexamples when the user enters the first letters of their
> Names. I am using Ajax here...and the query is
> returntype="query">
> returntype="array">
>
>
>
>
>SELECT FirstName
>FROM Employees
>where UCase(FirstName) LIKE Ucase('%#ARGUMENTS.Name_First#%')
>
>
>
>
>
>
>
>
>
>
> And now I wrote a stored procedure for this query and when I execute the
> same code I am getting an error at the cfloop and the code is ..
>
> returntype="array">
>
> cfsqltype="CF_SQL_VARCHAR" value='%#ARGUMENTS.Name_First#%' type="in">
> name="FirstName" >
>
>
>
>
>
>
>
>
> What do I need to use at the place of query in cfloop .. I am using
> stored Procedure name ...? Is it not right.
>
> Thanks,
> Priya
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320929
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
scopes
ok I was trying something and did this: And then I go about the rest as if the request came from a form post (I use form dot notation everywhere afterwards). When I did a it doesn't recognize the form scope, but this works But every where else in the code it works fine (recorgnizes all form dot names that were originally sent as url parameters) So is cf not supposed to handle the dump 'logically'? Can someone please reason this behavior? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320928 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 server - Order totals by month, even without month data
when i had to do a similar thing, this is how i did it: your query returns monthName and totalOrders columns. create a structure from your query with Month as key and Total as value: create a list of month names in the format returned by your query: create a new query you will use for your chart: loop over the mthslist list and populate the new query with month name and either 0 or your query's totalOrders value from the structure you created before: now you have a 'chartqry' query with all 12 months you can use for your chart. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Will Tomlinson wrote: > I have your typical tblorders. I'm trying to query it to get order totals by > month, and I'm outputting them in > > All goes fine, except in 2009. We have no order data for April-December of > course, so the query returns just three rows (Jan, Feb, March). > > I need it to return all 12 months, with 0 for the months with no orders > (April-Dec) > > I've played with this query and can't get anything to work for me. Any ideas? > > Thanks! > > Will > > select year(orderdate) as orderYear, > month(orderdate) as monthOrdered, > sum(ordertotal) as totalOrders, > dateName(month, orderdate) as monthName > from tblorders > where orderpaid = 1 > and year(orderdate) = 2009 > group by year(orderdate), > month(orderdate), > dateName(month, orderdate) > order by year(orderdate) asc, > month(orderdate) asc > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Delivery Report
hmm... the way i read the op, i thought items belongs to different orders... if so, then naming all checkboxes "items" will make it impossible to distinguish which order a particular items belongs to: is this item 1 in order 1 or in order 1876768788? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dan Baughman wrote: > have all the check boxes be named the same thing. > > > > > > if all three boxes are check you will get a comma separated list in the > form variable. > > e.g. with all 3 checked you'd get form.items = '1,2,3' then you just alter > your query with an in statement > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: html in database
On Wednesday 25 Mar 2009, Chad Gray wrote: > How do I insert a or any CF programming into the HTML when it > is pulled out of the database for display on the page? In Adobe ColdFusion, you have to write it to the desk then cfinclude it. Railo and OpenBD have a render() method, iirc. -- Tom Chiverton Helping to vitalistically improve products as part of the IT team of the year, '09 and '08 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. 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 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320925 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 server - Order totals by month, even without month data
posted a reply hours ago, but it still hasn't showed up... reposting... when i had to do a similar thing, this is how i did it: your query returns monthName and totalOrders columns. create a structure from your query with Month as key and Total as value: create a list of month names in the format returned by your query: create a new query you will use for your chart: loop over the mthslist list and populate the new query with month name and either 0 or your query's totalOrders value from the structure you created before: now you have a 'chartqry' query with all 12 months you can use for your chart. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
have all the check boxes be named the same thing. if all three boxes are check you will get a comma separated list in the form variable. e.g. with all 3 checked you'd get form.items = '1,2,3' then you just alter your query with an in statement ... where item_id in (, wrote: > > maybe i am not fully understanding your requirements, but... > if you give order item checkboxes names like > cb_#this_order_id#_#this_item_id#, then when your form submits it will > post only checked boxes, so you will have form fields like cb_1_1, > cb_1_2, cb_3_4, ... - you can then loop over form.fieldnames, and if > current fieldname starts with "cb_", extract the order_id and item_id > from the filedname and... do whatever you need with them! (i.e. add them > to a list/array you can then use to query your db to get necessary data > for your report...) > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > > Jason Congerton wrote: > > Hi > > > > I am trying to create a delivery report for my website, the report is > generated from the following tables > > > > ca_customers, ca_order_summary and ca_orderitems (please see query below) > > > > ca_customer >> holds the customer information (one record) > > > > ca_order_summary >> holds the order summary information (one record) > > > > ca_order_items >> contains the order items (multiple records) > > > > > > > > SELECT c.*, os.*, oi.* > > FROM (ca_customers c INNER JOIN ca_order_summary os ON c.ca_cust_id = > os.ca_ordersum_cust_id) INNER JOIN ca_order_items oi ON os.ca_ordersum_id = > oi.ca_orderitems_sum_id > > WHERE 0=0 > > AND os.ca_ordersum_archived = value="no"> > > AND os.ca_ordersum_invoiced = value="yes"> > > AND os.ca_ordersum_delivered = value="no"> > > AND c.ca_cust_web_id = cfsqltype="cf_sql_integer" value="#form.webID#"> > > ORDER BY ca_ordersum_id DESC > > > > (please note .* used for example) > > > > I would like to produce a dynamic form which displays the orders one by > one and also list the order items individually and have a check box next to > the order items, > > so the user can decide which items from the order are included in a > delivery report. > > > > > > Order #1: Contains 5 items P1,P2,P3,P4,P5 The user would only like P3 to > be included within the report. > > > > I have handled dynamic forms before and have used the following format > for my check boxes, and order summary id > > > > value="#ca_ordersum_id#"> > > value="#get_orders.recordCount#"> > > id="output#currentrow#" value="yes" /> > > > > > > And use this type of code to create a list of id's to pass to a query, > however this obviously just gets the ordersum id which will still include > items I do not want. I can't be very far from what I need, just need a > little help tweaking it. > > > > Would I be better to build a 2d array i.e. order ID, product id if so > could someone point me in the right direction with creating the array and > accessing the array in the subsequent query to be produced. > > > > > > > from="1" > > to="#val(form.resCount)#"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > I hope this explains what I am trying to do, it does in my head anyway:-) > > > > Kind Regards > > > > Jason > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error when Clustering CF Instances
I get the following error while trying to add an instance to a cluster: No MBean is registered on server under the ObjectName *:*. Also, trying to get to the administration server for this particular instance results int he following HTTP 500 error: There is no web application configured to service your request I've checked as many logs as possible and cannot find anything in either the cfusion instance logs, the particular instance in question's logs, or general JRun log files. This is under a default ColdFusion 8 Enterprise Multi-server 64 bit installation on RHEL5 and there are 5 other instances already running on the installation. I get this error when adding any more instances. Any thoughts/directions on where to go from here would be appreciated. Thanks, Phil ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320922 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 server - Order totals by month, even without month data
There are 2 ways that come to mind right off the bat. 1. Create another table that has each month in it. Do an outer join that allows the other table to return 0 for the months where you have no records in your original table 2. Inspect the query in CF for missing months. If there are any missing months, then create a new query using QueryNew to hold the old query, plus the new rows of months that have a 0 in them. William -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Wednesday, March 25, 2009 4:26 AM To: cf-talk Subject: SQL server - Order totals by month, even without month data I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0 for the months with no orders (April-Dec) I've played with this query and can't get anything to work for me. Any ideas? Thanks! Will select year(orderdate) as orderYear, month(orderdate) as monthOrdered, sum(ordertotal) as totalOrders, dateName(month, orderdate) as monthName from tblorders where orderpaid = 1 and year(orderdate) = 2009 group by year(orderdate), month(orderdate), dateName(month, orderdate) order by year(orderdate) asc, month(orderdate) asc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
html in database
I am doing a CMS type system and letting users edit pages with FCKeditor then storing the page HTML into a database field. I would like to make the menu system database drive and not statically created in FCKeditor. The menu system is inside of the area that FCKeditor is making. How do I insert a or any CF programming into the HTML when it is pulled out of the database for display on the page? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320920 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 do you get motivated at work?
>> My way of keeping motivated is to make money while I >> code. Money is a big motivator. It keeps one happy and >> motivated to take the next step. > >For me, the money itself isn't the motivator, but what it allows me to do. >My coding pays for things like flight training and other fun stuff to do. > yea..as long as i have a paying job, i can afford parts and track time for my car hehe. it also pays for the beer and wine and bratwursts. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help with a concept
Thanks Peter I'll try these out ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLOOP with Stored Procedure
I have a query and looping the results of a query. I want to display the names
from the cfdocexamples when the user enters the first letters of their Names. I
am using Ajax here...and the query is
SELECT FirstName
FROM Employees
where UCase(FirstName) LIKE Ucase('%#ARGUMENTS.Name_First#%')
And now I wrote a stored procedure for this query and when I execute the same
code I am getting an error at the cfloop and the code is ..
What do I need to use at the place of query in cfloop .. I am using stored
Procedure name ...? Is it not right.
Thanks,
Priya
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320917
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 server - Order totals by month, even without month data
The only way to get data into a query is to have data in a table. So there are a couple of options. 1. Create a months table that has 12 records 2. Create a temp table with 12 records You may also need to create a years table as well. Then your query would be something like SELECT year, month, SUM(total) FROM (SELECT * FROM Years CROSS JOIN Months) AS Months LEFT OUTER JOIN tblOrders ON Month(orderDate) = month GROUP BY year, month ORDER BY year, month The cross join will give you a record in your query for every year that you would like to account for and every month of that year. You can of course add any other criteria you would like to the WHERE clause. > I have your typical tblorders. I'm trying to query it to get order > totals by month, and I'm outputting them in > > All goes fine, except in 2009. We have no order data for > April-December of course, so the query returns just three rows (Jan, > Feb, March). > > I need it to return all 12 months, with 0 for the months with no > orders (April-Dec) > > I've played with this query and can't get anything to work for me. Any > ideas? > > Thanks! > > Will > > select year(orderdate) as orderYear, > month(orderdate) as monthOrdered, > sum(ordertotal) as totalOrders, > dateName(month, orderdate) as monthName > from tblorders > where orderpaid = 1 > and year(orderdate) = 2009 > group by year(orderdate), > month(orderdate), > dateName(month, orderdate) > order by year(orderdate) asc, > month(orderdate) asc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help with a concept
Can I add a set time to this. Like first day of the week at 12:00 AM? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help with a concept
> Or better still, just go straight from the date... > > to="#parseDateTime(Now())#" step="7"> > > > ... > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help with a concept
wow that's perfect thanks! so will it increment to the next week everytime? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320913 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 server - Order totals by month, even without month data
Hello Will, I'd advise building yourself a calendar table, these are always a useful facility in any application where you're going to be doing report generation, I've attached the SQL script which creates and populates your calendar table, this basically creates a record for each date in a range and breaks into different date parts, then for your query below we select the dates from the calendar table, ensuring we get a record for each group, be it day, month, year etc and then we'll LEFT OUTER JOIN the order table on that date, this ensures we get a row for every date in the range and it'll just return NULL for the months where orders don't exist. SQL CREATE Script: http://pastebin.com/m57ba4578 SQL INERT Script: http://pastebin.com/m65d6ee0f That script will create a table and insert records for the next 10 years, change the dates on the insert script to suit your own requirements. The script for your main query would then look something like this: http://pastebin.com/m1e234813 I have no way of testing that script, its working off the info you gave, if it doesn't work then let me know your table structure and some example data and we'll bash something together. Hope that helps you on your way. Rob -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: 25 March 2009 11:26 To: cf-talk Subject: SQL server - Order totals by month, even without month data I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0 for the months with no orders (April-Dec) I've played with this query and can't get anything to work for me. Any ideas? Thanks! Will select year(orderdate) as orderYear, month(orderdate) as monthOrdered, sum(ordertotal) as totalOrders, dateName(month, orderdate) as monthName from tblorders where orderpaid = 1 and year(orderdate) = 2009 group by year(orderdate), month(orderdate), dateName(month, orderdate) order by year(orderdate) asc, month(orderdate) asc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
maybe i am not fully understanding your requirements, but... if you give order item checkboxes names like cb_#this_order_id#_#this_item_id#, then when your form submits it will post only checked boxes, so you will have form fields like cb_1_1, cb_1_2, cb_3_4, ... - you can then loop over form.fieldnames, and if current fieldname starts with "cb_", extract the order_id and item_id from the filedname and... do whatever you need with them! (i.e. add them to a list/array you can then use to query your db to get necessary data for your report...) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: > Hi > > I am trying to create a delivery report for my website, the report is > generated from the following tables > > ca_customers, ca_order_summary and ca_orderitems (please see query below) > > ca_customer >> holds the customer information (one record) > > ca_order_summary >> holds the order summary information (one record) > > ca_order_items >> contains the order items (multiple records) > > > > SELECT c.*, os.*, oi.* > FROM (ca_customers c INNER JOIN ca_order_summary os ON c.ca_cust_id = > os.ca_ordersum_cust_id) INNER JOIN ca_order_items oi ON os.ca_ordersum_id = > oi.ca_orderitems_sum_id > WHERE 0=0 > AND os.ca_ordersum_archived = > AND os.ca_ordersum_invoiced = value="yes"> > AND os.ca_ordersum_delivered = value="no"> > AND c.ca_cust_web_id = cfsqltype="cf_sql_integer" value="#form.webID#"> > ORDER BY ca_ordersum_id DESC > > (please note .* used for example) > > I would like to produce a dynamic form which displays the orders one by one > and also list the order items individually and have a check box next to the > order items, > so the user can decide which items from the order are included in a delivery > report. > > > Order #1: Contains 5 items P1,P2,P3,P4,P5 The user would only like P3 to be > included within the report. > > I have handled dynamic forms before and have used the following format for my > check boxes, and order summary id > > value="#ca_ordersum_id#"> > value="#get_orders.recordCount#"> > id="output#currentrow#" value="yes" /> > > > And use this type of code to create a list of id's to pass to a query, > however this obviously just gets the ordersum id which will still include > items I do not want. I can't be very far from what I need, just need a little > help tweaking it. > > Would I be better to build a 2d array i.e. order ID, product id if so could > someone point me in the right direction with creating the array and accessing > the array in the subsequent query to be produced. > > > from="1" > to="#val(form.resCount)#"> > > > > > > > > > > > > > > I hope this explains what I am trying to do, it does in my head anyway:-) > > Kind Regards > > Jason > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: httponly
I realise now that the CFLOCATION is not server side although it does still seem to be the best solution. If your entire site can be SSL then you can set jsessionid cookies to be secure in the jrun-web.xml - this sets the secure attribute but not the httponly which would still be off until the second request of a session. On Tue, Mar 24, 2009 at 12:59 PM, Michael Traher wrote: > We are failing our security scan because of unsecured cookies. > We already use jsessionID. > > setClientCookies = false > > So we are going to implement the solution of setting the cookies via > CFHEADER where we can set httponly in all cases, and secure if the request > is over SSL. > > That is all fine and dandy, except that the very first request for a > session ignores the CFHEADER; the jsessionid cookie is not secure and not > httponly until the second request, when this is corrected - so there is > still a window for the exploit. > > Have other folks found this? > > My solution is to have a cflocation in onSessionStart to create an > artificial second request server side, however it seems rather clunky. > > Just wondering if anyone has a better solution? > > -- > Mike T > Blog http://www.socialpoints.com/ > -- Mike T Blog http://www.socialpoints.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320910 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 server - Order totals by month, even without month data
Create a calendar table. Load it with dates from 1900-2100. Each record relates to a single day. You can join to this table in many ways. Here is an example of one of my records... date 1900-01-01 00:00:00.000 dayOfWeek 2 dayOfWeekName Monday day 1 dayLeadingZero 01 month 1 monthLeadingZero 01 year 1900 yearMonthDay 19000101 yearMonth 190001 dayOfYear 1 dayOfYearLeadingZero 001 fiscalYear 1900 isWeekday 1 quarter 1 fiscalQuarter 3 Thanks, Mike -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Wednesday, March 25, 2009 6:26 AM To: cf-talk Subject: SQL server - Order totals by month, even without month data I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0 for the months with no orders (April-Dec) I've played with this query and can't get anything to work for me. Any ideas? Thanks! Will select year(orderdate) as orderYear, month(orderdate) as monthOrdered, sum(ordertotal) as totalOrders, dateName(month, orderdate) as monthName from tblorders where orderpaid = 1 and year(orderdate) = 2009 group by year(orderdate), month(orderdate), dateName(month, orderdate) order by year(orderdate) asc, month(orderdate) asc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320909 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 server - Order totals by month, even without month data
Also, since you are using SQL, you can use a CTE to dynamically generate a date range as a temp table, so to speak. I prefer a regular table as I mentioned in my last reply, however. Thanks, Mike -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Wednesday, March 25, 2009 6:26 AM To: cf-talk Subject: SQL server - Order totals by month, even without month data I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0 for the months with no orders (April-Dec) I've played with this query and can't get anything to work for me. Any ideas? Thanks! Will select year(orderdate) as orderYear, month(orderdate) as monthOrdered, sum(ordertotal) as totalOrders, dateName(month, orderdate) as monthName from tblorders where orderpaid = 1 and year(orderdate) = 2009 group by year(orderdate), month(orderdate), dateName(month, orderdate) order by year(orderdate) asc, month(orderdate) asc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Delivery Report
Hi I am trying to create a delivery report for my website, the report is generated from the following tables ca_customers, ca_order_summary and ca_orderitems (please see query below) ca_customer >> holds the customer information (one record) ca_order_summary >> holds the order summary information (one record) ca_order_items >> contains the order items (multiple records) SELECT c.*, os.*, oi.* FROM (ca_customers c INNER JOIN ca_order_summary os ON c.ca_cust_id = os.ca_ordersum_cust_id) INNER JOIN ca_order_items oi ON os.ca_ordersum_id = oi.ca_orderitems_sum_id WHERE 0=0 AND os.ca_ordersum_archived = AND os.ca_ordersum_invoiced = AND os.ca_ordersum_delivered = AND c.ca_cust_web_id = ORDER BY ca_ordersum_id DESC (please note .* used for example) I would like to produce a dynamic form which displays the orders one by one and also list the order items individually and have a check box next to the order items, so the user can decide which items from the order are included in a delivery report. Order #1: Contains 5 items P1,P2,P3,P4,P5 The user would only like P3 to be included within the report. I have handled dynamic forms before and have used the following format for my check boxes, and order summary id And use this type of code to create a list of id's to pass to a query, however this obviously just gets the ordersum id which will still include items I do not want. I can't be very far from what I need, just need a little help tweaking it. Would I be better to build a 2d array i.e. order ID, product id if so could someone point me in the right direction with creating the array and accessing the array in the subsequent query to be produced. I hope this explains what I am trying to do, it does in my head anyway:-) Kind Regards Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL server - Order totals by month, even without month data
I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0 for the months with no orders (April-Dec) I've played with this query and can't get anything to work for me. Any ideas? Thanks! Will select year(orderdate) as orderYear, month(orderdate) as monthOrdered, sum(ordertotal) as totalOrders, dateName(month, orderdate) as monthName from tblorders where orderpaid = 1 and year(orderdate) = 2009 group by year(orderdate), month(orderdate), dateName(month, orderdate) order by year(orderdate) asc, month(orderdate) asc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
