RE: [PHP-DB] Interbase: How to get table structure via SQL ?

2004-02-18 Thread Hutchins, Richard
Sorry...just re-read the subject and realized you're using Interbase. Need coffee. ;) > -Original Message- > From: Hutchins, Richard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 18, 2004 8:24 AM > To: 'DiZEM PGC'; [EMAIL PROTECTED] > Subject: RE:

RE: [PHP-DB] Interbase: How to get table structure via SQL ?

2004-02-18 Thread Hutchins, Richard
If you're using MySQL, you can use the DESCRIBE tablename command. There's a pretty straightforward (and easy to find) section on the DESCRIBE command in the MySQL documentation. > -Original Message- > From: DiZEM PGC [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 18, 2004 8:11 AM

Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread George Georgeus
Thank very much for your help. :o) That's what I need. Ge0rge --- Alexey Trunyov <[EMAIL PROTECTED]> wrote: > George Georgeus wrote: > > Hello, > > I do not know how to get the list of tables in an > > Interbase databse. When I tried to use the sql > command > > "SHOW TABLE;" in the php funct

Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread Alexey Trunyov
George Georgeus wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command "SHOW TABLE;" in the php function "ibase_query();" I got "Dynamic SQL Error SQL error code = -104 Token unknown - line 1,...". Select commands work well but this n

Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread George Patterson
I haven't used Interbase but could it be "show tables;". Just a thought... On Fri, 10 Oct 2003 09:34:49 +0100 (BST) George Georgeus <[EMAIL PROTECTED]> wrote: > Hello, > I do not know how to get the list of tables in an > Interbase databse. When I tried to use the sql command > "SHOW TABLE;" in

RE: [PHP-DB] Interbase BLOB problem

2002-10-30 Thread David Russell
ld Optimus (Pty) Ltd Tel: +2711 444-7250 Fax: +2711 444-7256 e-mail: [EMAIL PROTECTED] web: www.BarloworldOptimus.com -Original Message- From: Peter Beckman [mailto:beckman@;purplecow.com] Sent: 29 October 2002 05:47 PM To: David Russell Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] In

Re: [PHP-DB] Interbase BLOB problem

2002-10-29 Thread Peter Beckman
Your SQL query doesn't need that semicolon at the end of the query -- lose it. I never used ibase, so here's what I found from the PHP Manual page for ibase_query: Using BLOB Insert BLOB: /* create blob */ $blob_id = ibase_blob_create(); /* fill blob */ ibase_blob_add($blob_id, $var_datablob);

Re: [PHP-DB] Interbase transaction question

2001-08-24 Thread Yves Glodt
On Friday 24 August 2001 16:55, Balak, Frank wrote: > yves, > > Start the transaction with ibase_trans() before you call > ibase_execute. > > As to how is it possible, I don't really know for sure. I would > presume it has to do with how Interbase handles transactions. > > Frank Frank, thank you,

Re: [PHP-DB] Interbase: how can I insert null values with placeholders?

2001-07-07 Thread Kiss Marton
> > So I guess I'm saying that in the code if you change the $asinteger > assignment to: > > $asinteger = "NULL"; /* notice the quotes */ > > it may work. This would make the $asinteger PHP variable a string, but > since the SQL would either like to have a numeric value there or the > keyword NUL

Re: [PHP-DB] Interbase: how can I insert null values with placeholders?

2001-07-06 Thread Doug Semig
Hi KM-- The general format for the INSERT goes something like this: INSERT INTO anytable (columnname) VALUES (NULL); You technically do not need the newlines ("\n") in your $stmt. So I guess I'm saying that in the code if you change the $asinteger assignment to: $asinteger = "NULL"; /* notice

Re: [PHP-DB] Interbase Problem

2001-06-26 Thread Niel Zeeman
Hi We are running Firebird 0.94 SS on RedHat 7.1 Compaq Server Hope this rings a bell?? Niel ""Jorge Alvarez"" <[EMAIL PROTECTED]> wrote in message 9h90ja$1a8$[EMAIL PROTECTED]">news:9h90ja$1a8$[EMAIL PROTECTED]... > What OS is running in the InterBase machine? Are you running IB Classic o

Re: [PHP-DB] Interbase Problem

2001-06-26 Thread Jorge Alvarez
What OS is running in the InterBase machine? Are you running IB Classic or SuperServer? I haven't seen this error but have read about it a few times, in those cases the machine was running Windows NT and IB SS. -Jorge ""Niel Zeeman"" <[EMAIL PROTECTED]> escribió en el mensaje 9h76jh$ik6$[EMAIL P

RE: [PHP-DB] interbase (?) field contents does not show

2001-05-03 Thread Larry Rivera
From: GMansky [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 10:40 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] interbase (?) field contents does not show Meir, Thanks for the response. I believe I tried it with caps but did not get any message. Anyway, I tried it again, and it's now

Re: [PHP-DB] interbase (?) field contents does not show

2001-05-03 Thread GMansky
Meir, Thanks for the response. I believe I tried it with caps but did not get any message. Anyway, I tried it again, and it's now working. Why does $row->LASTNAME give me a result on an ibase_fetch_object() and not on ibase_fetch_row()? Thanks, George -- PHP Database Mailing List (http:/

Re: [PHP-DB] interbase (?) field contents does not show

2001-04-29 Thread Meir kriheli
On Sunday 29 April 2001 19:00, GMansky wrote: > I followed the documentation on interbase. I have the following code: > > $rowcount = 0;$dbh = ibase_connect ($host, $username, $password); > $stmt = 'SELECT * FROM contact'; > $sth = ibase_query ($dbh, $stmt); > while ($row = i

Re: [PHP-DB] interbase

2001-04-24 Thread Theo de Jong
Can you get to the Database / Interbase server using an interbase client, like Ibconsole? man <[EMAIL PROTECTED]> schrieb in im Newsbeitrag: [EMAIL PROTECTED] > Hi, > > I tried to connect to remote Interbase server. There is a result below: > > Warning: InterBase: Unable to complete network req

RE: [PHP-DB] Interbase/Apache/Linux

2001-03-23 Thread Cal Evans
Todd, I don't believe that there is an all-in-one compile that you can install, but you can certainly install Interbase, Apache and PHP on Linux and compile them yourself and make them work. Alternately, I'm sure there are 100 or so people on this list whom you could hire to get it up and running

Re: [PHP-DB] Interbase

2001-03-11 Thread Meir kriheli
On Thursday 08 March 2001 23:05, you wrote: > I am trying to connect to local Interbase server, folowing exactly PHP > online documentation. But I always get a warning: > "InterBase: unavailable database in d:\program files\apache > group\apache\htdocs\\tabulka.php on line 22" > > my script is: >

Re: [PHP-DB] Interbase

2001-03-08 Thread Martin Meca
And which database will I open, using this? First prameter in ibase_connect should be database file name, I think. Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list adminis

RE: [PHP-DB] Interbase

2001-03-08 Thread Angerer, Chad
if you are running a local webserver, why not just use $db=ibase_connect('localhost' , user, pass); ? Chad -Original Message- From: Martin Meca [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 3:06 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Interbase I am trying to connect to

Re: [PHP-DB] Interbase + PHP Error

2001-03-01 Thread Meir kriheli
On Thursday 01 March 2001 16:19, W. Yuen wrote: Hi Wicky To start with, never store the database file under your http document root, it is a big security risk. Can you connect to the databse with isql, using the same connection string ? If so, examine the log file to see what's going on (inte

Re: [PHP-DB] Interbase + PHP

2001-02-26 Thread Meir kriheli
On Monday 26 February 2001 04:08, Duky wrote: > I am using a Unix/Linux server. How can I recompile my php to use > interbase?? Where can I find that, to recompile? what do I need to > recompile and what do I have to include into that file? I am new to > this. so if somebody can help me out.. real

Re: [PHP-DB] Interbase + PHP

2001-02-25 Thread Duky
my own OS is win98. Duky wrote: > > I am using a Unix/Linux server. How can I recompile my php to use > interbase?? Where can I find that, to recompile? what do I need to > recompile and what do I have to include into that file? I am new to > this. so if somebody can help me out.. really thanks.

Re: [PHP-DB] Interbase and PHP support.

2001-01-22 Thread Mike
On Thu, 5 Oct 2000, Johan Hanson wrote: > On Wed, 04 Oct 2000, Giovanni Tummarello wrote: > > Hello all, > > i am about to start a large project that has some heavy requirements and are > > evaluating the use of Interbase. > > The BLOB functionality in the PHP interface is unstable. > The pr

Re: [PHP-DB] Interbase and PHP support.

2001-01-22 Thread Mike
On Thu, 5 Oct 2000, Johan Hanson wrote: > On Wed, 04 Oct 2000, Giovanni Tummarello wrote: > > Hello all, > > i am about to start a large project that has some heavy requirements and are > > evaluating the use of Interbase. > > The BLOB functionality in the PHP interface is unstable. > The pr