Search Again: Re: Complex SQL queries allowed? From: Paul Farber Date: Saturday, November 2, 2002 Time: 3:06:46 pm In the real world this is what happens: Customer signs up Account creation fails (for whatever reason) support/billing person on phone sounds like an idiot becuase OG says everything is OK (or worse customer on phone thinks we are idiots for not getting it right the first time). ANOTHER person has to get involved to fix the problem or at least look into it (as the operator will have not idea what the SQL failed e-mail means anyway). So now there are two people involved, a customer on the phone and OG telling everyone that it worked. A Better Solution(tm) would be: Customer signs up Account creation fails BUT A BOX POPS UP SAYING IT FAILED. Before the customer has a chance to call in we fix the problem and the customer is happy and we look like billing and Internet GODS. Unless you audit your OG and radius/e-mail/ftp servers monthly I can garuntee that you have 1. dead accounts 2 accounts that are active but not being billed or 3 accounts that are not active but being billed (ie additional e-mail accounts, ftp space, domains). OG simply has to be able to return error codes to the operator when things fail. At 05:39 PM 11/1/2002 -0800, you wrote: >Customer Care wrote: > > > Because OG should have the ability to pop up a dialog box telling the > > operator that the operation failed IMMEDIATLY. > > > > E-mailing errors is the dumbest thing I've ever heard.... error > > notification is the weakest part of OG. > >You would rather have a dialog talking about a failed SQL Statement pop up >to an entry-level employee rather than someone that could actually do >something about it? > > > > Can't the java SQL plugin pop up a box or something??? > >Nope. > > - Shawn > >------------------------------- >Shawn D. Hogan >President, Digital Point Solutions >http://www.digitalpoint.com >(858) 452-3696 > > >--------------------------------------------------- >To subscribe, unsubscribe or to search list archive >please visit http://www.optigold.com/lists/isp.html >--------------------------------------------------- Customer Care Farber Technology Get FREE Internet! Sign up a friend and receive 1 free month of Internet access! For more information, go to http://www.f-tech.net/freeinternet.html --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: Complex SQL queries allowed? by Paul Farber on Oct 31, 2002 at 7:39:04 pm Re: Complex SQL queries allowed? by Shawn Hogan on Oct 31, 2002 at 7:45:55 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 1, 2002 at 4:55:56 pm Re: Complex SQL queries allowed? by Matthew Bailey on Nov 1, 2002 at 5:04:46 pm Re: Complex SQL queries allowed? by Fernando Huerta =?iso-8859-1?Q?Zu=F1iga?= on Nov 1, 2002 at 5:26:32 pm Re: Complex SQL queries allowed? by Shawn Hogan on Nov 1, 2002 at 5:40:15 pm Re: Complex SQL queries allowed? by Shawn Hogan on Nov 1, 2002 at 5:41:28 pm Re: Complex SQL queries allowed? by Michael J. Colvin on Nov 1, 2002 at 5:57:40 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 2, 2002 at 3:06:46 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 2, 2002 at 3:09:40 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 2, 2002 at 3:14:00 pm Re: Complex SQL queries allowed? by Tim Atcheson on Nov 2, 2002 at 3:51:48 pm Re: Complex SQL queries allowed? by Shawn Hogan on Nov 2, 2002 at 5:13:56 pm Re: Complex SQL queries allowed? by Matthew Bailey on Nov 2, 2002 at 7:26:32 pm Re: Complex SQL queries allowed? by Tim Atcheson on Nov 3, 2002 at 11:27:54 am Re: Complex SQL queries allowed? by InterCape on Nov 3, 2002 at 7:45:54 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 5, 2002 at 4:36:48 pm