Re: Row level security requirements, can I still use MySQL?

Hi, I think Peter's suggesting you implement that security model in your application, rather than in the database server. Apart from probably not supporting such a security model, it's easier to audit user activity if you are controlling the security model. Cheers, Luke Venediger.

Re: Select with an IF statements

Hi Rhino, I don't think that answer solves the problem. I do use a programming language, and doing a query like this means I can make use of the database engine and not add overhead to my application. Cheers, Luke Venediger. On Wed, 27 Oct 2004 17:26:56 -0400, Rhino <[EMAIL PROTECTED

Re: Select with an IF statements

Thanks Paul! Luke Venediger. On Wed, 27 Oct 2004 16:17:51 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 22:58 +0200 10/27/04, Luke Venediger wrote: > >Hi, > > > >I'm trying to do the following: > > > >SELECT > > IF((ProductSta

Select with an IF statements

ilable". However, if the product name doesn't work the query doesn't return any rows. I would like it to return "Not Available" if the product isn't found. Is there a better way to do this? Thanks, Luke Venediger. -- Get Firefox Browser! Reclaim the web

Re: **[SPAM]** Conditional statement: IF

Hi, Apologies, yes I have RTFM, and should've clarified my question. I actually need to do something more like this: IF(@SomeValue = 1) BEGIN THEN SELECT "Data" as Column1, "MoreData" as Column2 ELSE SELECT "SomeValue is not = 1" as E

Re: Conditional statement: IF

statements with code checks in-between, where I would rather only execute one query. Cheers, Luke Venediger. On Fri, 22 Oct 2004 18:49:54 +0200, Anders Karlsson <[EMAIL PROTECTED]> wrote: > I don't know why you want to do this, but looking at your sybtax, it > seems like y

Conditional statement: IF

m getting syntax errors). I'm using MySQL 4.0.18. Any help would be greatly appreciated. Thanks, Luke Venediger. -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Raiserror in MySQL? Raising a user exception in a script

Hi Paul, Thanks for the information. Is there an alternative? Are there plans to add this in the future? Cheers, Luke Venediger. On Thu, 21 Oct 2004 08:46:04 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 15:29 +0200 10/21/04, Luke Venediger wrote: > >Hi, > > >

Raiserror in MySQL? Raising a user exception in a script

Hi, I'm trying to raise an error in a MySql query, in the same way that would be done in an MSSQL script: RAISERROR('My error message', 16, -1) Is there a way to do this in MySQL? Thanks, Luke Venediger. -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ --