Search Again: Re: Complex SQL queries allowed? From: Paul Farber Date: Friday, November 1, 2002 Time: 4:55:56 pm 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. Can't the java SQL plugin pop up a box or something??? At 07:45 PM 10/31/2002 -0800, you wrote: >Customer Care wrote: > > > Running 3.0.7 and setting up SQL server events I see that I can go to > > Scripts->Auto Server Create and create the username/password every time (ie > > the SQL event is triggered even though the account is already in the db). > > > > Can the SQL query for a specific even include include a SELECT statment to > > check if the <Login> exists and fail the command if it does? > > > > Shouldn't OG be able to query the db for Login before it triggers another > > create event? > >You can run multiple statements, but a failed SELECT statement wouldn't fail >the following statements. > >Why not make the login a unique key within your SQL database, then if you >try to insert a matching one it would fail and if you have it setup to >notify you of the failure, it will email whoever you tell it to email about >it. > > - 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