Hi,
does anyone know how to get the Structure of a table using SQL.
(ex.: SELECT ?RELATION_SOURCE?, RDB$RELATION_NAME FROM RDB$RELATIONS)
Isn't there any table containing the CREATE STATEMENT for a table?
Maybe I have to use another command?
Please help !
Thx,
DiZEM
--
GMX ProMail (250 MB
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Interbase: How to get table structure via SQL ?
Hi,
does anyone know how to get the Structure of a table using SQL.
(ex.: SELECT ?RELATION_SOURCE?, RDB$RELATION_NAME FROM RDB$RELATIONS)
Isn't there any table containing the CREATE STATEMENT
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: [PHP-DB] Interbase: How to get table
Hi,
...table structure without PEAR ?
Is it possible to accomplish this by a sql-statement or do I really HAVE TO
install this xtension (PEAR) ?
Cuz I've already written a few scripts containing many function calls (self
written classes, too). I read the PEAR extension organizes everything
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 not. SHOW TABLE is a regular
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 the php
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 not.
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 function
Hi
I am new to using PHP with Interbase.
If I want to issue a query, I use:
$sth = ibase_query ($dbh, $sqlstmt);
I am assuming this issues the query to the database, and commits at the same
time? Do I need to release anything after having done this, or does it take
care of that by itself?
Hello,
I have been using php --with-interbase for some time
and I enjoy using php scripts to everything so I did
some small scripts to use as a datapump to the interbase.
My scripts relay on the fact that I can have two
simultaneos connections to the different databases
in order to pump data from
Hello everybody,
Some days ago I've posted a question about interbase locking. I've solved
the problem after searching at interbase developers network and php manuals.
Let me drop some line about my experiences...
Deadlock is when two (or more) transactions want update or delete a field
in the
Hello,
I've an interbase locking question. Sometime i got interbase deadlock from
php scripts at updates and at inserts. I'm using simple ibase_query, and as
i've
read the manual of the interbase, it should handle the locking with the
default transaction
WAIT option. Is it enoug to using
(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] Interbase BLOB
Hi all,
I have a file I need to insert into a blob in a interbase table. Code as
follows:
$filehandle = fopen($file, r);
$blob_id = ibase_blob_import($filehandle);
$qry = INSERT INTO BPFATTACHMENTS ;
$qry = $qry . (BPFATTACHMENTNO, BPF, ATTACHMENTTYPE, FILENAME,
FILESIZE,
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,
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, I've
With Interbase functions I have to make 2 select.
SELECT count(*).. to count valid record
and
SELECT * .. to extract the records
There is a simple solutions to have unique Select ?
I use Pgsql too but here I Have the pg_numrows variable.
Someone sau to me:
just make the SELECT * .. to extract
Hi,
is there a way to treat the output of ibase_blob_echo?
I want to do some str_replace with its content before displaying it.
thank you,
yves
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To
just want to here comments from you guys. i will be doing a shopping cart and i'm
still looking for the best database which i could use aside from Oracle.i'm still
thingking which is better. interbase or postgres?
Hi i have a problem printing a lob field containing an image.
The database i use is Interbase 6.0
I have a blob/lob field with a gif image inside an i like to print this image on the
web.
Can you help me?
Bye Alessandro
With Interbase functions I have to make 2 select.
SELECT count(*).. to count valid record
and
SELECT * .. to extract the records
There is a simple solutions to have unique Select ?
I use Pgsql too but here I Have the pg_numrows variable.
Someone sau to me:
just make the SELECT * .. to extract
This is my page to extract image (from blob) in a interbase table.
I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ;
?php
//BLOB2JPG
$conn = ibase_connect($host,$user,$pass,$charset,$buffers,$dialect,$rules)
$set = ibase_query(SELECT IMAGE from products where (id_product =
Hello,
is it possible with InterBase to fire a select statement against an empty
table witout getting in trouble.
if the table X looks like this:
id - integer
dummy - varchar
and if I do now a select like
select * from x where id='$id';
I will get the error
Warning: InterBase:
Od: "Sergey Larionov" [EMAIL PROTECTED]
Temat: [PHP-DB] InterBase
"Warning: InterBase: arithmetic exception, numeric overflow, or string
truncation Cannot transliterate character between character sets in
/home/larionov/public_html/base.php on line 6"
How I can tur
Warning: InterBase: arithmetic exception, numeric overflow, or string
truncation Cannot transliterate character between character sets in
/home/larionov/public_html/base.php on line 6
How I can turn off tranliteration?
····
Sergey Larionov-[EMAIL PROTECTED],
With Interbase functions I have to make 2 select.
SELECT count(*).. to count valid record
and
SELECT * .. to extract the records
There is a simple solutions to have unique Select ?
I use Pgsql too but here I Have the pg_numrows variable.
--
PHP Database Mailing List (http://www.php.net/)
This is my page to extract image (as blob) in a interbase table.
I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ;
but i don't see the image
?php
//BLOB2JPG
// in = id_product
$host = 10.10.0.200:/home/interbase/WEB02/WEBG02;
$user = TEST_USER;
$pass = PassUser;
$charset=;
Od: "Jordan" [EMAIL PROTECTED]
Temat: [PHP-DB] Interbase/PHP/Apache implimentation
So my question is this: Can DBMS support be enabled using the
extension=php_interbase.dll directive
in the php.ini file (as opposed to MySQL, where support is built in) ONLY
while i
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 NULL, that is
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
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 or
I have many problem to view image stored like blob in interbase6.
Is impossible. I Use ibase_blob_echo().
my php is 4.0.5
Hi,
I want to insert data in to a blob. So I followed the steps in de docs, but
when I try to execute this script in the IBConsole:
begin declare section;
based on test.v1 document;
based on test.v1.segment BlobV1Buffer;
based on test.state CA;
unsigned short BlobV1Len;
Od: "Xanir" [EMAIL PROTECTED]
Temat: [PHP-DB] Interbase BLOB Insertion Problem
begin declare section;
based on test.v1 document;
based on test.v1.segment BlobV1Buffer;
based on test.state CA;
unsigned short BlobV1Len;
end declare section;
This is DSQL
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
:[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 working.
Why does
I followed the documentation on interbase. I have the following code:
?php
$rowcount = 0;$dbh = ibase_connect ($host, $username, $password);
$stmt = 'SELECT * FROM contact';
$sth = ibase_query ($dbh, $stmt);
while ($row = ibase_fetch_object ($sth)) {
print
On Sunday 29 April 2001 19:00, GMansky wrote:
I followed the documentation on interbase. I have the following code:
?php
$rowcount = 0;$dbh = ibase_connect ($host, $username, $password);
$stmt = 'SELECT * FROM contact';
$sth = ibase_query ($dbh, $stmt);
while ($row =
Hi,
I tried to connect to remote Interbase server. There is a result below:
Warning: InterBase: Unable to complete network request to host
"192.168.1.10". Failed to locate host machine. Undefined service
gds_db/tcp. in ...
File services on remote Interbase server contains:
gds_db
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 request
Od: "Bart A. Verbeek" [EMAIL PROTECTED]
Temat: [PHP-DB] ? interbase ?
1. Can interbase be installed and run on every Unix-type (BSD)?
I've taken a look on the borland site but they only speak of Linux and
windows.
Official Borland builds run only on Win32 and Linux. There a
Hello,
I'm internet-databasing for over a year now and only used MySQL up untill
now.
Last week I spoke with a guy that was interested in running Interbase on a
Unix-webserver,
so I've got a couple of questions...
1. Can interbase be installed and run on every Unix-type (BSD)?
I've taken a
How can I manage DATE fieldtype in PHP4 with Interbase?
The problem is that i manage DATEs in format DDMM (spain) but Interbase
manage it in MMDD format; so queries expected data in that format while
i need it in other format.
%
if(isset($action))
{
I have Interbase working on my client's WIN 2K platform with IIS as well
as on mine; however, I do not have any experience with Linux/Apache
(other than Apache running in DOS on my notebook for "on-the-road"
programming). The client would now like to move over to a more stable
environment:
Hi !
I have following problem when connecting to Interbase:
When trying to establish a persistent connection using
'ibase_pconnect()', a new connection is created each time. The database
connection remains open, but it will not be re-used later. So I have
loads of database connections and a
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:
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:
$db=ibase_connect('D:\Program
I am getting this error, but I don't know what the reason is for this
error. can somebody help me out?
Warning: InterBase: Unable to complete network request to host
"localhost". Failed to establish a connection. Connection refused in
/home/httpd/html/test/php-test/ibconnect.php on line 12
Can't
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
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.. really
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.
Hi,
I use Interbase 6.01 in a Linux system and i want use php for my server side
language for accessing the Interbase database.
When i start to use php for accessing database i seen that i can't move my
row pointer (cursor) into a quey after i use ibase_query() function. Only
traverse one row at
Hello!
I have just installed the Interbase 6.01 on a debian server. I compiled
he php with:
"/configure --with-mysql=/usr/local/mysql --with-apache=../apache_1.3.14
--enable-track
-vars --with-interbase=/opt/interbase"
but I get this error message:
"Fatal error: Call to undefined function:
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 process
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 process
Od: "Mike" [EMAIL PROTECTED]
Temat: Re: [PHP-DB] Interbase and PHP support.
The BLOB functionality in the PHP interface is unstable.
The process running the blob function crashes when trying to insert a
blob ID into a table.
That is a pretty large flakiness.
There was
56 matches
Mail list logo
