Subject | RE: [firebird-php] BIGINT & PHP |
---|---|
Author | Alan McDonald |
Post date | 2004-04-17T19:25:41Z |
It was when I used something like
$sql = sprintf('INSERT INTO SOMETABLE (BINGINT_FIELD) VALUES (%d)',
$bigint_value);
The %d represents an integer in the sprintf-syntax and so 2147483647 was
inserted if $bigint_value was a bigger number. Replacing %d with %s
solved the problem.
There is no problem with fetching BIGINT values from a table because the
ibase_fetch_xxx() functions returning them as strings.
Lutz
--
web based Firebird and InterBase administration: http://ibwebadmin.sf.net
OK great - thanks
Alan
[Non-text portions of this message have been removed]
$sql = sprintf('INSERT INTO SOMETABLE (BINGINT_FIELD) VALUES (%d)',
$bigint_value);
The %d represents an integer in the sprintf-syntax and so 2147483647 was
inserted if $bigint_value was a bigger number. Replacing %d with %s
solved the problem.
There is no problem with fetching BIGINT values from a table because the
ibase_fetch_xxx() functions returning them as strings.
Lutz
--
web based Firebird and InterBase administration: http://ibwebadmin.sf.net
OK great - thanks
Alan
[Non-text portions of this message have been removed]