Re: [Phpgroupware-developers] compatibility between all databases

[Michael Dean]

The queries should be rewritten so the values are represented properly
by type.  All you are doing at this point is "fixing" the query by doing
type checking against the field list, which is more processing than
should be spent preparing a query for execution.

While your fix works, it shouldn't be needed :)

On Fri, 2002-03-29 at 08:36, address@hidden wrote:
> > >insert into phpgw accounts
> > >(account lid, account type, account pwd,
> > >account firstname, account lastname, account status,
> > >account expires) values
> > >('Default','g','438bf90a818801ad1fc0982c343ef11b',
> > >'Default','Group','A','-1')
> > 
> > should that '-1' really be a string value?
> >
> 
> It seems to be a int.
> Check phpgwapi/setup/tables_current.inc.php (line 67 for
> me): it is an int, precision=4.
> 
> Is that a bug?
-- 
Michael L. Dean
Double Choco Latte - http://dcl.sourceforge.net/
GNU Enterprise     - http://www.gnuenterprise.org/