Re: One call for two pages?
How about having the top frame submit to itself and use javascript to submit to the bottom frame? Something like: cfif isDefined(FORM.formSubmit) script language=javascript !-- function submitForm() { myForm.target=otherFrame; myForm.action=other_action.cfm; myForm.submit(); } -- /script /cfif Sharon - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 6:20 PM Subject: Re: One call for two pages? How about having the top frame submit to itself. All processing is done normally and in the end query is set to a session variable with a unique name. After that you add 1 javascript function using cfhtmlhead. The function looks something like: function reloadBottom() { top.frames[1].location = 'blahblah.cfm?fromcache=#uniquename#'; } On the resulting request you just grab the query from the session scope based on the unique name. If it is large don't forget to delete the session variable afterwards. The problem with that is two-fold. First, I'm in a clustered environment, so I can't use session variables. Second, I am receiving a 15K WDDX packet back from a Python server that I am de-serializing. So setting the packet to a client variable isn't reasonable either. The resulting variable would be huge and a burden on the CF server because it would inherently be retrieved on every CF call within the application. Also, as a rule of thumb, I always have my forms submit to themselves. This allows me to have self-contained forms which are easy to re-use and maintain. Regards, Dave. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session Vars and cfquery - cflock where?
Generally speaking, you don't want to put a lock around a process that might take awhile. It slows everything down. Copy the variable to local or request scope before using. cflock scope=SESSION type=readonly timeout=10 cfset REQUEST.myVar = SESSION.myVar /cflock Sharon - Original Message - From: Brunt, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 2:07 PM Subject: Session Vars and cfquery - cflock where? When using a session variable in a cfquery where should the cflocks be? Around the whole cfquery or just around the line calling the session var? Mike Brunt Sempra Energy 213.244.5226 An elephant is a mouse with an operating system. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: textarea and cffile
SiteObjects' SOEditor2.x will also do the job quite nicely. They have a freeware version as well. We use it extensively for our intranet CMS. Cheers, Jeff Garza -Original Message- From: Gilbert Midonnet To: CF-Talk Sent: 3/15/02 10:12 PM Subject: textarea and cffile I would like to be able to have users in an intranet submit text for others to see via formtextarea/form and then usecffile to create a file. The problem comes when users want to cut-and-paste from articles or from word docs (which, I'm told, they do). The resulting file doesn't have any of the paragraph breaks. I use wrap=physical in the textarea and #ParagraphFormat(Form.content)# ParagraphFormat works well if people go back into the text and add paragraph breaks. However this is not acceptable to the users. Is there anything else to use besides HTMLCodeFormat, HTMLEditFormat and ParagraphFormat? TIA P.S. Now, of course, I'm greedy. In addition to keeping paragraph breaks I would love it if the formatting b could be kept too. hehehehe --- This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: One call for two pages?
How about having the top frame submit to itself and use javascript to submit to the bottom frame? Something like: cfif isDefined(FORM.formSubmit) script language=javascript !-- function submitForm() { myForm.target=otherFrame; myForm.action=other_action.cfm; myForm.submit(); } -- /script /cfif I see what you're saying, but that's not what I'm trying to solve. I know how to get one frame to submit another frame -- that's easy. Essentially this comes down to trying to force one CF Server call's results to be available for a second page. It doesn't have anything to do (as far as I can figure out) with JavaScript. This is a huge WDDX packet, so storing it in a hidden field in one frame is not feasible either. Thanks though, Dave. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Advice and opinion on client who has a problem paying bills
Hi All, I realize this is off topic but I could use some advice from everyone on this list. I have a client that is very stingy when it comes to paying bills. Ive already had one incident with her and that resulted in her getting out of paying the majority of the bill but this time I fear when she gets her next invoice, Ill have more trouble with her. The thing she likes to do is call me up and tell me theres a problem with the site and of course since Im just being the nice guy (the kiss of death I know) I can just pull the site code up and see if I can find the problem. Now the latest incident was a case of the links page not working correctly, I told her it would take an hour to track down and fix and she put up quite a fuss when I told her that she would be charged for this. (She tried to argue her way out of paying) In the end I went ahead and fixed the problem and I sent her a confirmation email before the work was started as well. She never replied to that confirmation email even though I asked her too. So now Im wondering what are my options. I know Im going to have trouble collecting from her, I mean theres more to their next invoice than this links page and she is well aware of my rates. I dont exactly have the funds to take her to small claims court either. The only option I have come up with is this. I can change the administrative status on her account to Disabled instead of Enabled but I think I run into a problem there because they already paid for the web site last year. These are all new changes and problems. I figure if I go this route then the BS will end and at least I will get my money. (She doesnt have FTP access) Any ideas are most welcome, Im not exactly in a position to just dump her as client but Im getting sick and tired of being taken for a ride. -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advice and opinion on client who has a problem paying bills
Mark, Lay down soem ground rules or services guidelines. Politely explain your situation to her, and if she is not in favor of working together to make things go more smoothly, let her go.. unless she is making you tons of money, I doubt its worth the hassle. There are lots of people on the net who need sites, just takes a little looking around. I am a college senior and have been doing contract work on the side for about 3 years now. I always write up an agreement for them to comply with in terms of rates, changes, updates, modifications, etc... and when questions arise I just point to that. Im sure it is not 100% legally binding but at least expectations are out in the open. Hope that helps. Mike -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 1:13 PM To: CF-Talk Subject: OT: Advice and opinion on client who has a problem paying bills Hi All, I realize this is off topic but I could use some advice from everyone on this list. I have a client that is very stingy when it comes to paying bills. I've already had one incident with her and that resulted in her getting out of paying the majority of the bill but this time I fear when she gets her next invoice, I'll have more trouble with her. The thing she likes to do is call me up and tell me there's a problem with the site and of course since I'm just being the nice guy (the kiss of death I know) I can just pull the site code up and see if I can find the problem. Now the latest incident was a case of the links page not working correctly, I told her it would take an hour to track down and fix and she put up quite a fuss when I told her that she would be charged for this. (She tried to argue her way out of paying) In the end I went ahead and fixed the problem and I sent her a confirmation email before the work was started as well. She never replied to that confirmation email even though I asked her too. So now I'm wondering what are my options. I know I'm going to have trouble collecting from her, I mean there's more to their next invoice than this links page and she is well aware of my rates. I don't exactly have the funds to take her to small claims court either. The only option I have come up with is this. I can change the administrative status on her account to Disabled instead of Enabled but I think I run into a problem there because they already paid for the web site last year. These are all new changes and problems. I figure if I go this route then the BS will end and at least I will get my money. (She doesn't have FTP access) Any ideas are most welcome, I'm not exactly in a position to just dump her as client but I'm getting sick and tired of being taken for a ride. -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Advice and opinion on client who has a problem paying bills
Lay down the law if you can, if not chalk it up to a learning experience. Get them in a contract. No one client should make up more than 20% of incoming money...for situations just like this. Besides, if you don't handle the site, she is going to need someone else right? Chances are that either she will get sticker shock, or come runnning back when some yahoo fubars the site. jon Mark Smeets wrote: Hi All, I realize this is off topic but I could use some advice from everyone on this list. I have a client that is very stingy when it comes to paying bills. I?ve already had one incident with her and that resulted in her getting out of paying the majority of the bill but this time I fear when she gets her next invoice, I?ll have more trouble with her. The thing she likes to do is call me up and tell me there?s a problem with the site and of course since I?m just being the nice guy (the kiss of death I know) I can just pull the site code up and see if I can find the problem. Now the latest incident was a case of the links page not working correctly, I told her it would take an hour to track down and fix and she put up quite a fuss when I told her that she would be charged for this. (She tried to argue her way out of paying) In the end I went ahead and fixed the problem and I sent her a confirmation email before the work was started as well. She never replied to that confirmation email even though I asked her too. So now I?m wondering what are my options. I know I?m going to have trouble collecting from her, I mean there?s more to their next invoice than this links page and she is well aware of my rates. I don?t exactly have the funds to take her to small claims court either. The only option I have come up with is this. I can change the administrative status on her account to ?Disabled? instead of ?Enabled? but I think I run into a problem there because they already paid for the web site last year. These are all new changes and problems. I figure if I go this route then the BS will end and at least I will get my money. (She doesn?t have FTP access) Any ideas are most welcome, I?m not exactly in a position to just dump her as client but I?m getting sick and tired of being taken for a ride. -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Advice and opinion on client who has a problem paying bills
Ditto to Jon's comments. However, I would add the following: You have a situation where there is an established expectation - and you are the point guy. Not to mention you have been a nice guy for her in the past. For that to change you need a starting point. I would sit down with her and express my concern about outstanding issues and ask her to outline any remaining issues. Then fix those issues she brings up and accept whatever fee you are able to collect from her. Then you have a starting point. The next time she comes to you with a link or something she doesn't like say ...well you know Alice, that's really a new issue. After all we did a review and took care of all outstanding issues for the site. Let me review this new problem and get back to you with an estimate of how much it will cost - ok? That way there is no misunderstanding. As a side note, I learned early on that a client must be thoroughly informed that every change or modification must be documented and an estimate agreed upon. This should be done before the first project is even begun. Additionally, if a client ties you up with maintenance or web mastering type work, ask them to enter into a binding maintenance agreement. I have 2 clients on such agreements. I charge them each a set amount and for that amount they get up 5 hours of maintenance programming. The ratio is at a discount to my normal hourly rate - so if they feel they need it, they are getting a bargain. But whether they use the 5 hours or not - they still get that line item on their statement (or an invoice). my 2 cents. Mark -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 12:39 PM To: CF-Talk Subject: Re: OT: Advice and opinion on client who has a problem paying bills Lay down the law if you can, if not chalk it up to a learning experience. Get them in a contract. No one client should make up more than 20% of incoming money...for situations just like this. Besides, if you don't handle the site, she is going to need someone else right? Chances are that either she will get sticker shock, or come runnning back when some yahoo fubars the site. jon Mark Smeets wrote: Hi All, I realize this is off topic but I could use some advice from everyone on this list. I have a client that is very stingy when it comes to paying bills. I?ve already had one incident with her and that resulted in her getting out of paying the majority of the bill but this time I fear when she gets her next invoice, I?ll have more trouble with her. The thing she likes to do is call me up and tell me there?s a problem with the site and of course since I?m just being the nice guy (the kiss of death I know) I can just pull the site code up and see if I can find the problem. Now the latest incident was a case of the links page not working correctly, I told her it would take an hour to track down and fix and she put up quite a fuss when I told her that she would be charged for this. (She tried to argue her way out of paying) In the end I went ahead and fixed the problem and I sent her a confirmation email before the work was started as well. She never replied to that confirmation email even though I asked her too. So now I?m wondering what are my options. I know I?m going to have trouble collecting from her, I mean there?s more to their next invoice than this links page and she is well aware of my rates. I don?t exactly have the funds to take her to small claims court either. The only option I have come up with is this. I can change the administrative status on her account to ?Disabled? instead of ?Enabled? but I think I run into a problem there because they already paid for the web site last year. These are all new changes and problems. I figure if I go this route then the BS will end and at least I will get my money. (She doesn?t have FTP access) Any ideas are most welcome, I?m not exactly in a position to just dump her as client but I?m getting sick and tired of being taken for a ride. -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Advice and opinion on client who has a problem paying bills
Consider the following: A man walks into a restaurant for breakfast. After carefully reviewing the menu, he orders a stack of 3 hot pancakes, 2 hot eggs over-easy, side of hot hashbrowns, and cold orange juice. He then proceeds to read the morning newspaper. His breakfast is served to him 15 minutes later. The breakfast he receives is a stack of 3 hot pancakes, 2 hot eggs over-easy, hot hashbrowns, and cold orange juice. He decides to finish reading the newspaper before breakfast. When he gets around to eating, he has a stack of 3 lukewarm pancakes, 2 cold eggs over-easy, side of cool hashbrowns, and room temperature orange juice. He eats the breakfast. At the cashier, he complains and argues that he should not pay his bill. The cashier calls to the restaurant manager, who notices the order time on his ticket is 60 minutes ago. Does he excuse this bill or not? After all, the breakfast was served as specified. That time had passed and the environment altered the food is of no fault to the owner. Now it seems you have two choices, a) Don't charge this person for the fix (assuming that you did not write poor code to begin with), and just be the nice guy. In which case, the scenario is likely to repeat itself over and over until the relationship reaches its inevitable end in resentment and bad feelings... b) Charge her for the modifications. You don't have a choice in however, is how she responds. People will feel how they want to feel, and sometimes even make critical decisions based on those feelings. You just need to let them deal with that. I would be making my business choices based on principals, not feelings. This is not to say that I wouldn't occasionally drop in a token freebie for a good client, but that I wouldn't do it for one that was not paying enough or otherwise make it worth my while. For future reference, I would start making sure that anything you do is pre-approved. That is, you have a written agreement for any fix, addition, or modification that details the cost (that she must pay). It all comes down to this Document, Document, Document, Document Dave PS. You CAN pick your customers :) - Original Message - From: Mark Smeets [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 10:13 AM Subject: OT: Advice and opinion on client who has a problem paying bills Hi All, I realize this is off topic but I could use some advice from everyone on this list. I have a client that is very stingy when it comes to paying bills. I've already had one incident with her and that resulted in her getting out of paying the majority of the bill but this time I fear when she gets her next invoice, I'll have more trouble with her. The thing she likes to do is call me up and tell me there's a problem with the site and of course since I'm just being the nice guy (the kiss of death I know) I can just pull the site code up and see if I can find the problem. Now the latest incident was a case of the links page not working correctly, I told her it would take an hour to track down and fix and she put up quite a fuss when I told her that she would be charged for this. (She tried to argue her way out of paying) In the end I went ahead and fixed the problem and I sent her a confirmation email before the work was started as well. She never replied to that confirmation email even though I asked her too. So now I'm wondering what are my options. I know I'm going to have trouble collecting from her, I mean there's more to their next invoice than this links page and she is well aware of my rates. I don't exactly have the funds to take her to small claims court either. The only option I have come up with is this. I can change the administrative status on her account to Disabled instead of Enabled but I think I run into a problem there because they already paid for the web site last year. These are all new changes and problems. I figure if I go this route then the BS will end and at least I will get my money. (She doesn't have FTP access) Any ideas are most welcome, I'm not exactly in a position to just dump her as client but I'm getting sick and tired of being taken for a ride. -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:
UDF question
Can I reference a query from within a UDF? I'm building a new shopping cart that has the items and quantities in a session query (session.basket) and I want to total the number of items that are currently in the query from a UDF. The query has a quantity field and I want the UDF to be something like: function BasketItemCount { var totitems=0; for (i = 1; i lte session.basket.recordcount; i = i + 1) { !--- add the item quantity to the totitems here --- } return totitems; } Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UDF question
Try something like this... function BasketItemCount() { var totitems=0; for (i = 1; i lte session.basket.recordcount; i = i + 1) { totItems = totItems + session.basket.itemQty[i]; } return totitems; } Keith Meade [EMAIL PROTECTED] - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 2:53 PM Subject: UDF question Can I reference a query from within a UDF? I'm building a new shopping cart that has the items and quantities in a session query __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfqueryparam problem
I'm trying to perfom the following: cfquery name=Get_email datasource=users dbtype=odbc SELECT TOP 1 User_Name FROM Users WHERE User_Email='cfqueryparam value=#Form.User_Email#' /cfquery while outputting cfoutput query=Get_email#User_Name#/cfoutput I'm receiving this: ? (MSSQL 2K). when I replace the cfqueryparam with: [EMAIL PROTECTED], I see the right answer. Is there a known issue or something I misunderstood on string w/ cfqueryparam? Thanks. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UDF question
Thanks for the reply. I wound up using: function BasketItemCount() { var totitems=0; var currentRow = 1; for (; currentRow lte session.basket.RecordCount; currentRow = currentRow + 1) { totitems = totitems + session.basket[Quantity][currentRow]; } return totitems; } Regards, Howie - Original Message - From: junkMail [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 4:29 PM Subject: Re: UDF question Try something like this... function BasketItemCount() { var totitems=0; for (i = 1; i lte session.basket.recordcount; i = i + 1) { totItems = totItems + session.basket.itemQty[i]; } return totitems; } Keith Meade [EMAIL PROTECTED] - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 2:53 PM Subject: UDF question Can I reference a query from within a UDF? I'm building a new shopping cart that has the items and quantities in a session query __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Advice and opinion on client who has a problem paying bills
David, That's a great analogy! I'm going to save it. But of course the client being discussed will not understand how that analogy relates to her present situation. She'll be deaf to its meaning and will have totally forgotten that she said this feature was not important and that scenario doesn't really apply to what we want when the project was originally quoted, even if it is right there in front of her in writing. This is just a tough thing to deal with. It's not just a web development business disease. These negotiations go on in every business. It's really difficult to lose a customer and deal with the negative comments that will propagate, but if one customer is consuming a great deal of your business resources, you risk losing a greater number of customers. Ask yourself if you made a mistake when reviewing the project. Then do the right thing for you, your customer and all of your other customers. Then get ready to live with your decision. Greg Alton CFDev Consider the following: A man walks into a restaurant for breakfast. After carefully reviewing the menu, he orders a stack of 3 hot pancakes, 2 hot eggs over-easy, side of hot hashbrowns, and cold orange juice. He then proceeds to read the morning newspaper. His breakfast is served to him 15 minutes later. The breakfast he receives is a stack of 3 hot pancakes, 2 hot eggs over-easy, hot hashbrowns, and cold orange juice. He decides to finish reading the newspaper before breakfast. When he gets around to eating, he has a stack of 3 lukewarm pancakes, 2 cold eggs over-easy, side of cool hashbrowns, and room temperature orange juice. He eats the breakfast. At the cashier, he complains and argues that he should not pay his bill. The cashier calls to the restaurant manager, who notices the order time on his ticket is 60 minutes ago. Does he excuse this bill or not? After all, the breakfast was served as specified. That time had passed and the environment altered the food is of no fault to the owner. Now it seems you have two choices, a) Don't charge this person for the fix (assuming that you did not write poor code to begin with), and just be the nice guy. In which case, the scenario is likely to repeat itself over and over until the relationship reaches its inevitable end in resentment and bad feelings... b) Charge her for the modifications. You don't have a choice in however, is how she responds. People will feel how they want to feel, and sometimes even make critical decisions based on those feelings. You just need to let them deal with that. I would be making my business choices based on principals, not feelings. This is not to say that I wouldn't occasionally drop in a token freebie for a good client, but that I wouldn't do it for one that was not paying enough or otherwise make it worth my while. For future reference, I would start making sure that anything you do is pre-approved. That is, you have a written agreement for any fix, addition, or modification that details the cost (that she must pay). It all comes down to this Document, Document, Document, Document Dave PS. You CAN pick your customers :) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfqueryparam problem
I'm trying to perfom the following: cfquery name=Get_email datasource=users dbtype=odbc SELECT TOP 1 User_Name FROM Users WHERE User_Email='cfqueryparam value=#Form.User_Email#' /cfquery while outputting cfoutput query=Get_email#User_Name#/cfoutput I'm receiving this: ? (MSSQL 2K). when I replace the cfqueryparam with: [EMAIL PROTECTED], I see the right answer. Is there a known issue or something I misunderstood on string w/ cfqueryparam? Thanks. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfqueryparam problem
I'm trying to perfom the following: cfquery name=Get_email datasource=users dbtype=odbc SELECT TOP 1 User_Name FROM Users WHERE User_Email='cfqueryparam value=#Form.User_Email#' /cfquery while outputting cfoutput query=Get_email#User_Name#/cfoutput I'm receiving this: ? (MSSQL 2K). when I replace the cfqueryparam with: [EMAIL PROTECTED], I see the right answer. Is there a known issue or something I misunderstood on string w/ cfqueryparam? Have you tried using the CFSQLTYPE attribute? If you leave it off, the default is CF_SQL_CHAR, which is probably not the type of field the email column is in your database. SQL Server may be having an issue with that. cfqueryparam value=#Form.User_Email# cfsqltype=CF_SQL_VARCHAR I use CFQUERYPARAM for almost everything and I haven't had many issues at all. There are some quirks with lists and dates, but that's not your problem here. So I would say no, there is no known issue. Regards, Dave. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfqueryparam problem
Jason Davis wrote: I'm trying to perfom the following: cfquery name=Get_email datasource=users dbtype=odbc SELECT TOP 1 User_Name FROM Users WHERE User_Email='cfqueryparam value=#Form.User_Email#' /cfquery while outputting cfoutput query=Get_email#User_Name#/cfoutput I'm receiving this: ? (MSSQL 2K). when I replace the cfqueryparam with: [EMAIL PROTECTED], I see the right answer. Is there a known issue or something I misunderstood on string w/ cfqueryparam? Loose the quotes and use a cf_sql_type: WHERE User_Email = cfqueryparam value=#Form.User_Email# cfsqltype=cf_sql_varchar Jochem __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfqueryparam problem
Jochem, This indeed solved the problem! Thanks!! And I took Dave's advice and put some maxlength and type verification too. can't harm :) Thank you all!! Spread the buzz, use cfqueryparam, it's cool! - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 11:44 PM Subject: Re: cfqueryparam problem Jason Davis wrote: I'm trying to perfom the following: cfquery name=Get_email datasource=users dbtype=odbc SELECT TOP 1 User_Name FROM Users WHERE User_Email='cfqueryparam value=#Form.User_Email#' /cfquery while outputting cfoutput query=Get_email#User_Name#/cfoutput I'm receiving this: ? (MSSQL 2K). when I replace the cfqueryparam with: [EMAIL PROTECTED], I see the right answer. Is there a known issue or something I misunderstood on string w/ cfqueryparam? Loose the quotes and use a cf_sql_type: WHERE User_Email = cfqueryparam value=#Form.User_Email# cfsqltype=cf_sql_varchar Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Advice and opinion on client who has a problem paying bills
...have the user/owner test it and then sign off ... and boviously they would do that if it's part of the original contract... laszlo LANCASTER, STEVEN M. (JSC-OL) (BAR) wrote: One of the things I have done in the past is when I have completed work. I have the user/owner test it and then sign off that the work was completed. They can not come back and say this or that does not work. I have their signature stating that it does. Most people won't argue with themselves. So if you put that in front of them they tend to back off and pay the extra to get it fixed. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 12:13 PM To: CF-Talk Subject: OT: Advice and opinion on client who has a problem paying bills Hi All, I realize this is off topic but I could use some advice from everyone on this list. I have a client that is very stingy when it comes to paying bills. I've already had one incident with her and that resulted in her getting out of paying the majority of the bill but this time I fear when she gets her next invoice, I'll have more trouble with her. The thing she likes to do is call me up and tell me there's a problem with the site and of course since I'm just being the nice guy (the kiss of death I know) I can just pull the site code up and see if I can find the problem. Now the latest incident was a case of the links page not working correctly, I told her it would take an hour to track down and fix and she put up quite a fuss when I told her that she would be charged for this. (She tried to argue her way out of paying) In the end I went ahead and fixed the problem and I sent her a confirmation email before the work was started as well. She never replied to that confirmation email even though I asked her too. So now I'm wondering what are my options. I know I'm going to have trouble collecting from her, I mean there's more to their next invoice than this links page and she is well aware of my rates. I don't exactly have the funds to take her to small claims court either. The only option I have come up with is this. I can change the administrative status on her account to Disabled instead of Enabled but I think I run into a problem there because they already paid for the web site last year. These are all new changes and problems. I figure if I go this route then the BS will end and at least I will get my money. (She doesn't have FTP access) Any ideas are most welcome, I'm not exactly in a position to just dump her as client but I'm getting sick and tired of being taken for a ride. -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: handled timeouts crashing server?
CF 4.5, Solaris 8, Oracle 8.1.7 w/native drivers, 5 threads max., restart if 4 threads are unresponsive. In the log files I've reviewed there are never more than 2 unresponsive threads. The unresponsive thread count increases and decreases as the threads timeout and later return. I don't know about database query timeouts - I'll have to look into that. Anybody know if Oracle does that? Yes, I've reviewed the Allaire/MM document(s). The odd thing is that everything *appears* to be working fine, but the server is still restarting itself for no apparent reason, and crashing/freezing then needing a manual restart. thanks, Chris Norloff -- Original Message -- from: Jochem van Dieten [EMAIL PROTECTED] Chris Norloff wrote: I've got a system with a lot of timeouts during queries. These timeouts are handled and logged. We're having CFserver crashes/freezes with no correlated errors, except for a bunch of timeouts (like 10 in the previous 6 hours). What CF version? What OS? What database? At how many unresponsive threads do you restart? What is the maximum number of threads? Does your database support query timeouts and do you use them? Anybody have timeouts that are handled still crash/freeze the server? Did you check ColdFusion Timeouts and Unresponsive Requests? http://www.macromedia.com/v1/Handlers/index.cfm?ID=21641Method=Full Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JS/CF Screen Resolution
nevermind. foudn soem JS to do it. Thanks, Mike -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 11:16 PM To: CF-Talk Subject: JS/CF Screen Resolution Is there a way to detect a site visitors screen resolution? Michael T. Tangorre == Alfred University Webteam Manager AIM: CrazyFlash4 Phone: 607-426-9277 == __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Advice and opinion on client who has a problem paying bills
[EMAIL PROTECTED] just for discussions like this. and At 10:13 AM 3/16/2002 -0800, you wrote: So now I'm wondering what are my options. I know I'm going to have trouble collecting from her, I mean there's more to their next invoice than this links page and she is well aware of my rates. I don't exactly have the funds to take her to small claims court either. For the record, in Connecticut, you can sue in small claims for up to ~$3500 ( It varies from state to state). The charge for filing ( last I remember ) is about $30. I've never had to do this, though. It will cost you more to be out of the office for that day than it will to sue in small claims court. If you have your documentation ( and story ) solid you should have no trouble going to small claims court with a lawyer. ( However, achieving a judgement against someone and collecting are two different things ) If you sue someone, don't expect any future work out of them. If you hire a lawyer to send nasty official sounding letters you might get paid without going to court, however I also wouldn't expect any future work from them. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Guru?
Is there a SQL guru we can ask a question of that is so shameful we cannot bring ourselves to post. :-) Can you hit us offlist, unless y'all want a chuckle. We have a big query we cannot seem to get to work in one simple SQL statement, but three cf queries and some looping. Its quite sad and the worst piece of crap we have written in years, but we are too tired to get a grip. Thanks in advance! Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists