Search Again: Complex SQL queries allowed? From: Paul Farber Date: Thursday, October 31, 2002 Time: 7:39:04 pm 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? 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