Nulls get converted to 0 problem

Hi,

I have this very strange problem that I cannot figure out.

I am in the process of converting a Coldfusion MX application from SQL
Server to PostgreSQL 7.3.2 running on SuSE Linux 8.2.
Since Coldfusion has no support for real null, when a select returns a
null value, the value of the Coldfusion variable is set to "", even if
it a numeric value like int.

For example, the following query should display nothing in the
item_category column:

select * from item_catalog where item_category is null

With SQl Server 7, this works as expected, but with PostgreSQL, the
value Coldfusion is setting the integer variables to is 0 (zero) and
not "" as it should. This of course is a big problem. I checked with
other people using the combination of PostgreSQL and Coldfusion and
they cannot reproduce it. This makes me think that there may be a
problem with my database as created.

Now the interesting thing is that if I use another tool to examine the
results, they do display null in this column.

At this point I pretty much lost. Any idea what may the problem be?

Thanks,
Avi
--
Avi Schwartz
avi(at)CFFtechnologies(dot)com