 |  |
Customer Care wrote:
Re: Complex SQL queries allowed?
From: Shawn Hogan
Date: Thursday, October 31, 2002
Time: 7:45:55 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?
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
---------------------------------------------------
Messages In This Thread:
Return to Digital Point Solutions' Home Page
| home | |
| products | |
| services | |
| support | |
| email lists |
| optigold isp | |
| optigold isp news | |
| home inspection | |
| inspectrix | |
| java companion | |
| oracle | |
| quickdns pro | |
| search engine | |
| veterinary |
| tips | |
| employees | |
| free tools | |
| portfolio | |
| jobs | |
| contact |
888/4-DPOINTSupport:
858/452-3696