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. On Thu, 18

Select with an IF statements

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. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

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((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus FROM

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] wrote

Conditional statement: IF

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: Conditional statement: IF

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 you come from a Sybase or SQL Server environment

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 Error END IF Thanks, Luke Venediger. On Fri

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/ -- MySQL General

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, I'm trying to raise an error