[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.