 |  |
Shawn hate to tell you most radius databases use a number as a key.
Re: Complex SQL queries allowed?
From: Matthew Bailey
Date: Friday, November 1, 2002
Time: 5:04:46 pm
Anyway I just delete then add it back everytime it might happen..
Atleast that is how we solved the problem the other night.. But I was
thinking there needs to be an exit if a select finds the answer..
--Matt
----- Original Message -----
From: "Customer Care" <billing@f-tech.net>
To: "Optigold ISP List" <isp-list@optigold.com>
Sent: Friday, November 01, 2002 8:02 PM
Subject: Re: [Optigold ISP] Complex SQL queries allowed?
> 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
> ---------------------------------------------------
>
---------------------------------------------------
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