[PHP-DB] Firebird return wrong value

Dear List! i have a strange problem. I have a Firebird database (dialect 3). Firebird server: 2.0.6 I create a table, and insert a row like that: CREATE TABLE PRICE (   ID INTEGER NOT NULL,   NAME VARCHAR(10),   COST NUMERIC(15, 2)); INSERT INTO PRICE (ID, NAME, COST) VALUES (2, 'my price2',

Re: [PHP-DB] Firebird return wrong value

vbe...@mail.com wrote: result: Array ( [0] = Array ( [COST] = -0.00 ) ) As a starting point ... can you look at the database using Flamerobin and check what it shows has been stored. I don't see anything wrong with what you have done except that 'cost' should perhaps be -1.0, so once we know

Re: [PHP-DB] Firebird return wrong value

On Fri, Jan 18, 2013 at 12:49 PM, vbe...@mail.com wrote: Dear List! i have a strange problem. I have a Firebird database (dialect 3). Firebird server: 2.0.6 I create a table, and insert a row like that: CREATE TABLE PRICE ( ID INTEGER NOT NULL, NAME VARCHAR(10), COST NUMERIC(15,

Re: [PHP-DB] Firebird return wrong value

INSERT INTO PRICE (ID, NAME, COST) You should not use double quotes around column names. Try to use backtick operator instead: INSERT INTO `PRICE` (`ID`, `NAME`, `COST`) Don't know if that solves the problem, but it's atleast good practice. Second, do you really need firebird database?

Re: [PHP-DB] Firebird return wrong value

Matijn Woudt wrote: Dear List! i have a strange problem. I have a Firebird database (dialect 3). Firebird server: 2.0.6 I create a table, and insert a row like that: CREATE TABLE PRICE ( ID INTEGER NOT NULL, NAME VARCHAR(10), COST NUMERIC(15, 2)); INSERT INTO PRICE (ID, NAME, COST)

Re: [PHP-DB] Firebird return wrong value

Berko Bubu wrote: INSERT INTO PRICE (ID, NAME, COST) You should not use double quotes around column names. Try to use backtick operator instead: INSERT INTO `PRICE` (`ID`, `NAME`, `COST`) Don't know if that solves the problem, but it's atleast good practice. Second, do you really need

[PHP-DB] firebird - equivalent of stristr() in Stored Procedure.

hi Guys, I'm using Firebird 1.5 with PHP5. I have a problem where by I am trying to do the equivelant of: $a = 'A'; $b = 'AG'; if (stristr($b, $a)) { // do something. } Inside a Stored procedure, where $a and $b are both input variables to the stored

Re: [PHP-DB] firebird - equivalent of stristr() in Stored Procedure.

Jochem Maas wrote: hi Guys, hope somebody can give me a clue :-), well about 5 mins after I posted I managed to find a solution thanks to a man named Ivan Prenosil (who by all accounts knows where his firebird towel is ;-) http://www.volny.cz/iprenosil/interbase/ip_ib_code_string.htm (the

[PHP-DB] Firebird and PHP

Hello, Is possible work with Firebird ? and how? Thanks and advance!! Mario Lacunza Lima-Peru -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Firebird

It looks like firebird database is on its way to replace of mysql... its totaly free (commersial open source) use but it isn't any php functions for that so we must use ODBC ... Dose anyone knows if PHP developpers have any plans to make som e firebird functions? :) -- PHP Database Mailing

Re: [PHP-DB] Firebird

_ - Original Message - From: Alireza Balouch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 12:25 PM Subject: [PHP-DB] Firebird It looks like firebird database is on its way to replace of mysql... E???!!!??? How would you back

RE: [PHP-DB] Firebird

I don't think sorumor has it IBM is buying MySQL. Mark -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 6:38 AM To: DB list PHP; Alireza Balouch Subject: Re: [PHP-DB] Firebird _ - Original Message

[PHP-DB] Firebird support

Hi, There are any plan about support for direct access to Firebird SQL DBMS? The interbase dll driver include in php 4.x work fine with Firebird 1.5? Thank in advance. -- Maxi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Firebird under Windows 2000

Hi!: I don't know if anybody tried PHP with Firebird, but I've got a really curious problem. I've installed PHP 4.3.3 and work with Firebird 1.5 RC6 and MS - IIS without any problems, but suddenly, and with no other advice or error messages than the ring of a bell my PHP pages stop to work. I

Re: [PHP-DB] Firebird PHP Module (Repost)

Julian Mesa [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I can compile doing 2 modifications, but doesn't work. I've had 2 modifications to compile interbase module of php: 1)in ibase.h add #define ISC_FAR 2) Before configure export LIBS=-lstdc++ -lcrypt -lcrypto configure

[PHP-DB] Firebird driver

Is there a plan to have a Firebird driver ? Firebird is no longer the same as Interbase, it will have it's own libraries when the 1.5 version will be release (there is an 1.5 beta version now) Thanks -- Philippe Makowski Firebird serveur SQL open-source en français http://firebird-fr.eu.org Ma