phpwebsite-developers

[Phpwebsite-developers] MySQL-NULL-Problem

[Franz S. <fra...@ch...>]

Hi all!

I found a problem concerning checking for NULL using sqlSelect (e.g.
sqlSelect("my_table","my_column",NULL)).

This won't work in MySQL, because the SQL code that is generated looks
like "SELECT * FROM my_table WHERE my_column=NULL".
Sadly, MySQL needs something like "SELECT * FROM my_table WHERE
my_column is null".

I have already coded a workaround for this, but I don't know if other
database systems may insist on the upper expression.

If this works on all SQL-databases, it would be an honour to me to send
you a patch for the Database.php file.

Regards
	Franz
		Schanovsky

--
Austria: high Mountains, Mozart, NO KANGAROOS.

Re: [Phpwebsite-developers] MySQL-NULL-Problem

[Steven L. <st...@tu...>]

Franz,

  Please do send in your patch, actually add it to the patch list on
sourceforge here
https://sourceforge.net/tracker/?func=add&group_id=15539&atid=315539

we typically do our sql queries in all caps so 'IS NULL' would be
appropriate.

ex. "SELECT * FROM my_table WHERE my_column IS NULL".

Steven

On Thu, 2003-09-04 at 04:00, Franz Schanovsky wrote:
> Hi all!
> 
> I found a problem concerning checking for NULL using sqlSelect (e.g.
> sqlSelect("my_table","my_column",NULL)).
> 
> This won't work in MySQL, because the SQL code that is generated looks
> like "SELECT * FROM my_table WHERE my_column=NULL".
> Sadly, MySQL needs something like "SELECT * FROM my_table WHERE
> my_column is null".
> 
> I have already coded a workaround for this, but I don't know if other
> database systems may insist on the upper expression.
> 
> If this works on all SQL-databases, it would be an honour to me to send
> you a patch for the Database.php file.
> 
> Regards
> 	Franz
> 		Schanovsky
> 
> --
> Austria: high Mountains, Mozart, NO KANGAROOS.
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
-- 
Steven Levin
Electronic Student Services
Appalachian State University
URL: http://phpwebsite.appstate.edu
Email: steven at tux dot appstate dot edu