From: | Avi Schwartz <avi(at)CFFtechnologies(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Nulls get converted to 0 problem |
Date: | 2003-06-04 15:26:22 |
Message-ID: | E5E1A06A-96A0-11D7-AFDF-000393AE5044@CFFtechnologies.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Gardner | 2003-06-04 15:30:29 | Re: newbie sql question... |
Previous Message | Don Isgitt | 2003-06-04 13:30:31 | Newsgroup Mail server down? |