hello all,
has anyone managed to compile DBI on AIX 5.2 with IBM xlc compiler? i
tried and it breaks like this:
...
xlc -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-I/usr/local/include -q32 -D_LARGE_FILES -qlonglong -O2
-DVERSION=\1.42\ -DXS_VERSION=\1.42\
Hi,
i have a problem using MySQL (4.0.18) (together) with the current Bugzilla release.
I think, that during installation of modules some configuration went wrong
resulting in the error i now have to deal with:
Output of Bugzillas checksetup.pl:
...
Precompiling templates ...
DBI
I'm not sure what your particular problem is, but I went to google and
searched for Can't connect to local MySQL server through socket and
found lots of info. Forgive me for questioning the obvious, but are you
sure MySQL is running?
Hardy Merrill
[EMAIL PROTECTED] 04/29/04 09:57AM
Hi,
i
This does not work in Oracle. A NULL value is the absence of value and cannot be
compared to anything (including NULL).
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Chuck Fox [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 3:01 PM
To:
Hmmm,
So column != column when the column contains a null. How very unusual.
I would have assumed that null = null, but there I go assuming things
again.
So why does this work ?
create table foo( i int, c char(10) null )
go
insert foo values( 1, null )
insert foo values( 2, 2 )
go
select *
This doesn't look like Oracle.
In Oracle:
create table foo (i int, c char(10) null);
SQL desc foo
Name Null?Type
- ---
I NUMBER(38)
C
Try to add nvl function to both side of equal in the where clause.
eg. where nvl(column, '~') = nvl(?, '~')
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 5:32 PM
To: Chuck Fox
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Selecting a
