[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-developers] Patches for PostgreSQL??
From: |
Chris Weiss |
Subject: |
Re: [Phpgroupware-developers] Patches for PostgreSQL?? |
Date: |
Fri, 21 Nov 2003 14:03:11 +0000 |
I'm not sure about the pg status, but in the plain ol' SQL '' != NULL. Seems
to me that pg doing somehting wrong, if you save '' it should not be null in
the table, it should be an empty string.
Dani Oderbolz (address@hidden) wrote:
>
> Hi guys,
> I am a bit confused about the status of a PostgreSQL specific bug.
> I got my PHPGroupware Installation 2 weeks ago from CVS.
> When I used it, I got many "pg-atoi: Zero length string" errors.
> I have written a path (more of a workaround) for it,
> but now, somebody in the Postgres group told me that you already fixes
> this stuff??
>
> Here is my patch:
> In phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php
> in the function query ($Query_String, $line = '', $file = '')
> I do this before submitting the Query:
>
> $Query_String = str_replace("''","NULL",$Query_String);
>
> But I really think that we should clean up the functions which
> gernerate queries like
> SELECT * FROM table WHERE id=''
>
> Does anybody know about the real status of this?
>
> Regards,
> Dani
>
>
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>
- [Phpgroupware-developers] Patches for PostgreSQL??, Dani Oderbolz, 2003/11/21
- RE: [Phpgroupware-developers] Patches for PostgreSQL??, Kai Hofmann, 2003/11/21
- Re: [Phpgroupware-developers] Patches for PostgreSQL??,
Chris Weiss <=
- Re: [Phpgroupware-developers] Patches for PostgreSQL??, Chris Weiss, 2003/11/21
- Re: [Phpgroupware-developers] Patches for PostgreSQL??, Brian Johnson, 2003/11/21
- Re: [Phpgroupware-developers] Patches for PostgreSQL??, Chris Weiss, 2003/11/21
- Re: [Phpgroupware-developers] Patches for PostgreSQL??, Brian Johnson, 2003/11/25
- Re: [Phpgroupware-developers] Patches for PostgreSQL??, Dave Hall, 2003/11/25
- RE: [Phpgroupware-developers] Patches for PostgreSQL??, Dirk Schaller, 2003/11/26
- RE: [Phpgroupware-developers] Patches for PostgreSQL??, Dirk Schaller, 2003/11/26