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 firebi
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, "
> > 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
On Fri, Jan 18, 2013 at 12:49 PM, 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));
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 kno
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',
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 sto
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
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
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 Me
_
- 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...
Ehh
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 Lis
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
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 tri
"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"
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 c
16 matches
Mail list logo