Re: [PHP-DB] PHP4 / WinNT 4 / Oracle 7.3 via ODBC

2001-01-22 Thread R Maier
hi Carlos, looks like ORACLE_HOME and/or LD_LIBRARY_PATH are not set correct during execution. 1. afer setting the variables with putenv check if they are really set with phpinfo(INFO_ENVIRONMENT); 2. if they are still not set correct (what might be the problem, export them in your apache startsc

[PHP-DB] Oracle 7.3 - skipping TNS resolution?

2001-01-22 Thread John Coonrod
Maybe the problems many of us are having relate to the slowness of TNS resolution. My TNSping on my maching takes 18 seconds. Could there be a timeout in php? When I use pure java drivers in jsp, I'm able to skip TNS and use the ip number or hostname directly for the host. Is this possible in

[PHP-DB] PHP4 + interbase 6 : UPDATE or INSERT has no effect

2001-01-22 Thread nicolas
I can't write into IB6 database from PHP4 with the folling code. I have no error but table1 is not updated. (SELECT queries run fine) The problem is the same with INSERT. I haven't try DELETE yet. Regards Nicolas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EM

AW: [PHP-DB] PHP4 + interbase 6 : UPDATE or INSERT has no effect

2001-01-22 Thread Michael Rudel
Hi Nicolas, ... don't you need a COMMIT on IB6-DB ??? Hope this helps. Greetinx, Mike (Germany) -Ursprüngliche Nachricht- Von: nicolas [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 22. Januar 2001 14:39 An: [EMAIL PROTECTED] Betreff: [PHP-DB] PHP4 + interbase 6 : UPDATE or INSERT has

Re: [PHP-DB] Child tables in MySQL

2001-01-22 Thread JJeffman
I think "Preferences" may be a child table which has all users preferences : Preference PREFERENCE (integer unsigned not null primary key auto_increment) SUBJECT (char(20) not null) USERCHOICE (set {"choice1","choice2",..."choiceN"} not null) USERID (foreign key, use the definition f

Re: [PHP-DB] where to get php-mssql70.dll

2001-01-22 Thread Nathan Crause
Assumably you downloaded a "Windows Install" executable to install PHP - I found that this distribution does not have that file (I had the same problem as you're having when I first installed PHP4). Once you've installed PHP using that installation, you still need to download the Windows ZIP file.

Re: [PHP-DB] php MSSQL problem

2001-01-22 Thread Nathan Crause
What is the problem you're having? Are you trying to change setting in the PHP.INI file and they are not reflecting in the scripts or is PHP returning some other sort of error saying it could not locate PHP.INI? ""Robert"" <[EMAIL PROTECTED]> wrote in message 000c01c080c1$960de3b0$d5245ed1@tech2

Re: AW: [PHP-DB] PHP4 + interbase 6 : UPDATE or INSERT has no effect

2001-01-22 Thread nicolas
> > ... don't you need a COMMIT on IB6-DB ??? > Great : I did try but I must have make a mistake : it's fine now with $trans = ibase_trans(); ibase_query ($c, $sql); ibase_commit( $trans); regards Nicolas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROT

Re: [PHP-DB] Problem width SQL on PHP4

2001-01-22 Thread Nathan Crause
Aside from enabling PHP_MSSQL70.DLL extensions in the PHP.INI file, you need to HAVE this file. If you installed PHP from the "Windows Install", then you probably don't have this file. You need to download the PHP ZIP file, which DOES contain the extension DLL's. ""Sebastian A. Davicco"" <[EMAIL

[PHP-DB] Problem with mysql_fecth_array if I have multi-connections

2001-01-22 Thread Mage
Hello! I'm new here, nut let me ask a question... One of my project were must go to another server, and I got a trouble with mysql functions. I try to write a short code to explain it. This script works well on my computer, windows 98 se, php 4.0.3. Also works on debian a server, php 4.

[PHP-DB] Near-duplicate a row ?

2001-01-22 Thread Sigurd Magnusson
Whats the easiest way to duplicate a row, specifiying only a new primary number? Is the easiest way: 1. "SELECT * where primarykey=oldnum" 2. roll through the fields, getting current fields and values 3. "INSERT where primarykey=newnum" ... etc? Or is there an SQL statement to achieve this ?

Re: [PHP-DB] Near-duplicate a row ?

2001-01-22 Thread Toby Butzon
> Or are you going to riducule, saying 'what the hell do you need near-duplicate rows for'? :P what the hell do you need near-duplicate rows for? ;) Actually, I think it can be done with the subselect as you suggested in recent versions of mySQL (actually I'm not sure it's actually out yet...).

[PHP-DB] confirm subscribe to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] To confirm that you would like [EMAIL PROTECTED] added to the php-db mailing list, please send an empty reply to this address: [EMAIL PROTECT

[PHP-DB] confirm subscribe to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] To confirm that you would like [EMAIL PROTECTED] added to the php-db mailing list, please send an empty reply to this address: [EMAIL PROTECT

[PHP-DB] WELCOME to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] Acknowledgment: I have added the address [EMAIL PROTECTED] to the php-db mailing list. Welcome to [EMAIL PROTECTED]! Please save this message s

[PHP-DB] WELCOME to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] Acknowledgment: I have added the address [EMAIL PROTECTED] to the php-db mailing list. Welcome to [EMAIL PROTECTED]! Please save this message s

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] Getting dates.

2001-01-22 Thread Mike
Addressed to: Mattias Hedman <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from Mattias Hedman <[EMAIL PROTECTED]> Thu, 12 Oct 2000 09:43:09 +0200 > > Hello all! I have a problem... I need to fetch data out of a mySQL > database. The Data should be between 2 specific da

Re: [PHP-DB] SQL conditional UPDATE

2001-01-22 Thread Mike
Addressed to: "Derek Paterson" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "Derek Paterson" <[EMAIL PROTECTED]> Thu, 12 Oct 2000 14:46:51 +0100 > > Is there any way within one SQL query to Update to different values > dependant on conditions. I've guessed at subq

[PHP-DB] Request for Confirmation [automatic reply]

2001-01-22 Thread Mike
Hi, This is an automatic reply to an email you sent to the PHP Group. Please verify your email address by simply replying to this email. Your email address will then be stored so that future emails will be accepted instantly. Address to be registered: [EMAIL PROTECTED] This is a simple form o

[PHP-DB] confirm subscribe to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] To confirm that you would like [EMAIL PROTECTED] added to the php-db mailing list, please send an empty reply to this address: [EMAIL PROTECT

[PHP-DB] confirm subscribe to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] To confirm that you would like [EMAIL PROTECTED] added to the php-db mailing list, please send an empty reply to this address: [EMAIL PROTECT

[PHP-DB] WELCOME to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] Acknowledgment: I have added the address [EMAIL PROTECTED] to the php-db mailing list. Welcome to [EMAIL PROTECTED]! Please save this message s

[PHP-DB] WELCOME to php-db@lists.php.net

2001-01-22 Thread Mike
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] Acknowledgment: I have added the address [EMAIL PROTECTED] to the php-db mailing list. Welcome to [EMAIL PROTECTED]! Please save this message s

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] Getting dates.

2001-01-22 Thread Mike
Addressed to: Mattias Hedman <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from Mattias Hedman <[EMAIL PROTECTED]> Thu, 12 Oct 2000 09:43:09 +0200 > > Hello all! I have a problem... I need to fetch data out of a mySQL > database. The Data should be between 2 specific da

Re: [PHP-DB] SQL conditional UPDATE

2001-01-22 Thread Mike
Addressed to: "Derek Paterson" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "Derek Paterson" <[EMAIL PROTECTED]> Thu, 12 Oct 2000 14:46:51 +0100 > > Is there any way within one SQL query to Update to different values > dependant on conditions. I've guessed at subq

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: ezmlm responseezmlm-send: fatal: message already has a Mailing-List header (may

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

RE: [PHP-DB] failure notice

2001-01-22 Thread Andrew Hill
Mike, Just a hunch, but lots of garbage emails are getting posted to the list ... I wonder if everything in your PHP-DB folder is going to come back out :) Regards, Andrew > -Original Message- > From: Mike [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 22, 2001 4:58 PM > To: [EMAIL

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: ezmlm responseezmlm-send: fatal: message already has a Mailing-List header (may

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm subscribe to [EMAIL PROTECTED]: fatal: message already has a Mailing-L

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm subscribe to [EMAIL PROTECTED]: fatal: message already has a Mailing-L

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: WELCOME to [EMAIL PROTECTED]: fatal: message already has a Mailing-List header

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: WELCOME to [EMAIL PROTECTED]: fatal: message already has a Mailing-List header

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: GOODBYE from [EMAIL PROTECTED]: fatal: message already has a Mailing-List head

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: GOODBYE from [EMAIL PROTECTED]: fatal: message already has a Mailing-List head

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

[PHP-DB] failure notice

2001-01-22 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: confirm unsubscribe from [EMAIL PROTECTED]: fatal: message already has a Maili

Re: [PHP-DB] failure notice

2001-01-22 Thread Darryl Friesen
One hates to be rude, but can someone reach over and slap Mike. Or remove him from the list until he sorts out the mail problems. - Darryl -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

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

2001-01-22 Thread Jarek Zgoda
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 one q

[PHP-DB] odbc_columns()

2001-01-22 Thread szii
Yo ho hoodbc_columns() on DB2! Now, it returns a resource ID, as expected but you cannot call odbc_fetch_row() on it or it'll segfault. Hmm.. I filled out a report on this, since I cracked open the php_odbc.c file and verified that all the data's coming back from DB2, and that the bindcols(