Re: [PHP-DB] Informix and PHP

2004-05-22 Thread Martin Marques
El Vie 21 May 2004 14:48, D. Sandmann escribió: Any help would be appreciated on this. I have already asked this question on the regular PHP and Informix news groups and have not had any luck. Maybe one of you can resolve my problem. I have had this problem in the past on another machine and

[PHP-DB] Informix and PHP

2004-05-21 Thread D. Sandmann
Any help would be appreciated on this. I have already asked this question on the regular PHP and Informix news groups and have not had any luck. Maybe one of you can resolve my problem. I have had this problem in the past on another machine and fixed it by setting the environment variables for

Re: [PHP-DB] Informix - help!

2003-12-15 Thread Martin Marques
El Dom 14 Dic 2003 19:00, Daniel Crespo escribió: I have red hat linux with Apache web server and PHP. I want to connect, using PHP, to an Informix Database remotely. What is all I have to do on my side? Thanks a lot Install informix client libraries where php will go and compile using

[PHP-DB] Informix - help!

2003-12-14 Thread Daniel Crespo
I have red hat linux with Apache web server and PHP. I want to connect, using PHP, to an Informix Database remotely. What is all I have to do on my side? Thanks a lot -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Informix function

2003-11-21 Thread Juan Ringhetti
Hi, I have a problem with PHP ifx_num_rows function. Once is executed after a ifx_query function it always returns 0 value (even the ifx_query return a couple of rows). I know that is a PHP bug (I have a php4.1.1 version), but, how can I do to solve this bug in a standard way? Without use select

[PHP-DB] informix error

2003-11-19 Thread Adam Williams
Hi, I was wondering if anyone has seen this informix error before. It has me stumped. Searching on google didn't reveal anything. Running my query in informix returns the proper results, so I'm not sure what the problem is. Warning: ifx_fetch_row(): 4 is not a valid Informix Result resource

Re: [PHP-DB] informix error

2003-11-19 Thread jeffrey_n_Dyke
cc: Subject: [PHP-DB] informix error 11/19/2003 01:01

[PHP-DB] Informix 9.20 ifx_query SQLCODE=-410

2003-10-10 Thread Tomá¹ Tominec
Hi, I have Informix 9.2 on Solaris and IIS on XP professional. when I run SQL statement, $conn_id = ifx_connect ([EMAIL PROTECTED], name, pwd); $qry = SELECT a,b FROM c ; if (! $conn_id) { printf(Cannot connect to the DB SERVER.); } $res = ifx_query($qry,$conn_id); I will get error:

[PHP-DB] INFORMIX PROBLEM

2003-08-27 Thread Luigi Vellucci
Hi I'm trying to compile php 4.1.2 from the source RPM in RedHat 7.3 but I wasn't succesfully. Please does anybody know what it means the following error: *** Warning: Linking the shared library libphp4.la against the non-libtool *** objects /opt/informix/lib/esql/checkapi.o is not portable!

Re: [PHP-DB] INFORMIX PROBLEM

2003-08-27 Thread Martin Marques
El Mié 27 Ago 2003 16:01, Luigi Vellucci escribió: Hi I'm trying to compile php 4.1.2 from the source RPM in RedHat 7.3 but I wasn't succesfully. Please does anybody know what it means the following error: *** Warning: Linking the shared library libphp4.la against the non-libtool *** objects

[PHP-DB] INFORMIX (URGENT)

2003-08-18 Thread Davi José Faria Costa
Hello Everybody, I wait that somebody can help me, therefore already I depleted my possibilities. I need to develop a site in PHP with access to the Data base Informix. The such of the data base alone functions with NTFS (W2k, WNT). I installed the W2K Advanced Server in my house... and

[PHP-DB] Informix varchar nonprintable characters

2003-07-16 Thread Agusti Fita
Hello: We have developed a project that runs over several database engines with de ADODB php library. At this moment it's runing over MySQL, MSSQL Server and Informix through the Linux Informix Client SDK ODBC driver. We need to store non-printable characters into varchar fields (ASCII code

[PHP-DB] Informix

2003-01-14 Thread Foong
Hello, Does any one know how to connect to Informix database on a Different server?? I have searched on google, php.net but couldn't get a details guide on what to set. the ifx_connect() does not give me an option to pass in the database server ip. Do I need to set it somewhere else?? Foong

[PHP-DB] Informix

2002-10-09 Thread Simon Taylor
Does anyone know of a good infrmix list I am in a fix.. Thanks _ Simon Taylor AfriTol (Pty) Ltd. ? [EMAIL PROTECTED] Å+27 12 361 3303 ext 257 Å+27 72 471 1833 Æ+27 12 365 3810 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Informix ifx_close

2002-07-24 Thread Martins Junkers
I have following script: ? $db=ifx_connect(db,uid,pwd); $result=ifx_query(begin work,$db); $result=ifx_query(insert into m_test1 (i) values('1');, $db); $result=ifx_query(select * from m_test1;, $db); while($row=ifx_fetch_row($result)) { echo($row['i']); } $result=ifx_query(rollback

[PHP-DB] informix stored procedures exception handling

2002-06-04 Thread Andrey V. Glukhov
I am moving to php-4.2.1 now and still looking for explanation how to use exeption handling in informix stored procedures. As I've wrote a year ago here, when I trying to execute the following php code: ? $connid=ifx_connect(basename,username,password ); $q=execute procedure test();

RE: [PHP-DB] Informix + PHP any gotcha's to watch out for?

2001-10-23 Thread Mark Roedel
-Original Message- From: davemacgb [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 12:12 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Informix + PHP any gotcha's to watch out for? I've only used MySQL via PHP until now, does anyone know of any gotchas that I should

[PHP-DB] Informix + PHP any gotcha's to watch out for?

2001-10-22 Thread davemacgb
I've been asked to create a B2B web site for on-line ordering. The customer's software runs on SCO OpenServer 5 (UNIX) unfortunately the run-time environment for the software is limited to either its own proprietary database, Informix or Oracle. This means that switch to another database like

[PHP-DB] Informix - ifx_num_rows

2001-08-22 Thread Leila
Hi all, I have Php 4.0.6 on Linux with Informix Dynamic Server 7.31.UD1. I try to use the function ifx_num_rows after afx_query and the value returned is always 0, but i can see the result with ifx_fetch_row. Does Anyone know if there is a bug with this function ifx_num_rows ? Thanks in

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Paul Burney
on 6/21/01 2:23 PM, wflow at [EMAIL PROTECTED] wrote: What I want to do is create another query from some of the data from another one. The question is how do I take the data I get back from my first query and put that into variables so I can build my second query. The example I have in mind

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Paul Gardiner
: Thursday, June 21, 2001 10:23 PM Subject: Re: [PHP-DB] Informix Question (Still need help,please) Chris, Thanks for the advice, of course I already did rtfm and the ifx_fetch_rows entry did not really help me. It, in fact does NOT return an enumerated array, as the top line of the page states

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Christian Haul
On 21.Jun.2001 -- 02:22 PM, William Flow wrote: Chris, Thanks for the advice, of course I already did rtfm and the ifx_fetch_rows entry did not really help me. It, in fact does NOT return an enumerated array, as the top line of the page states. It ONLY returns an associative array.

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Christian Haul
On 21.Jun.2001 -- 02:22 PM, William Flow wrote: Chris, Thanks for the advice, of course I already did rtfm and the ifx_fetch_rows entry did not really help me. It, in fact does NOT return an enumerated array, as the top line of the page states. It ONLY returns an associative array.

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Dan Fitzpatrick
B, Do your first query, then run this (for one record returned). while($row = ifx_fetch_row($query_result_id)) { for(reset($row); $fieldname=key($row); next($row)) { $$fieldname = $row[$fieldname]; } } Do your second query. The while statement

RE: [PHP-DB] Informix question

2001-06-22 Thread Mark Roedel
-Original Message- From: Bård Farstad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 11:45 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Informix question I'm writing an application which uses the PHP interface to informix. I'm having trouble with newlines in char

Re: [PHP-DB] Informix question

2001-06-21 Thread Christian Haul
Bård Farstad [EMAIL PROTECTED] wrote: Hi all, I'm writing an application which uses the PHP interface to informix. I'm having trouble with newlines in char/varchar or lvarchar fields. How can I store newlines (\n) to an informix database without using blobs? You need to escape newlines or

Re: [PHP-DB] Informix Question how to put data from query into variables

2001-06-21 Thread Christian Haul
wflow [EMAIL PROTECTED] wrote: Hi All, What I want to do is create another query from some of the data from another one. The question is how do I take the data I get back from my first query and put that into variables so I can build my second query. The example I have in mind is: I a do

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-21 Thread wflow
Chris, Thanks for the advice, of course I already did rtfm and the ifx_fetch_rows entry did not really help me. It, in fact does NOT return an enumerated array, as the top line of the page states. It ONLY returns an associative array. If there was an ifx_fetch_array like the one for MySQL, I

[PHP-DB] Informix Question how to put data from query into variables

2001-06-20 Thread wflow
Hi All, What I want to do is create another query from some of the data from another one. The question is how do I take the data I get back from my first query and put that into variables so I can build my second query. The example I have in mind is: I a do a select

[PHP-DB] Informix blobs problem -609 / core dump

2001-06-19 Thread Christian Haul
Hi. When trying to insert anything into a BLOB column in informix I get a -609 error back (invalid use of TEXT/BYTE host variable), no matter what parameters used when ifx_create_blob'ing. Inserting into TEXT columns does work OK. When trying to read anything from a TEXT or BLOB column, php

[PHP-DB] Informix question

2001-06-19 Thread Bård Farstad
Hi all, I'm writing an application which uses the PHP interface to informix. I'm having trouble with newlines in char/varchar or lvarchar fields. How can I store newlines (\n) to an informix database without using blobs? I'm using: -- Bård Farstad Systems developer ez.no | developer.ez.no |

[PHP-DB] Informix user wierdness

2001-03-31 Thread Graeme Merrall
This is more an Informix question rather than a PHP question but I hope someone can help I've installed the Linux-SE version and CSDK of Informix from informix.com and installation has gone fine including createing the demo DB. I can also start 'dbaccess' and browse/query the tables so the

[PHP-DB] informix client sdk for linux

2001-03-14 Thread Marios Moutzouris
Hello Anybody know where i can get hold of this. Informix site at www.informix.com/evaluate..has for every OS other than Linux Thanks Marios -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] informix: inserting long chars via php3

2001-02-12 Thread Udo Oehmig
hi, we work with php 3.0.14 and try to insert texts into char(500) fields in an informix 7.2 database. but, there is always the following error: "Warning: Prepare fails (E [SQLSTATE=IX 000 SQLCODE=-280]) in db.inc.php3 on line 21" that error code -280 means: "A qouted string exceeds 256 bytes"