Re: [PHP] Informix - ifx_num_rows

2001-08-24 Thread Leila

Thanks for all that answered my question.
I wanted this function because i use Postgres too in the same project , i
will use informix or postgres , so
the logic in my implementation was based on postgres functions...
But if to Informix it doesn't work ... I will do of another way.
Leila
Martín marqués [EMAIL PROTECTED] escreveu nas notícias de
mensagem:[EMAIL PROTECTED]
 On Jue 23 Ago 2001 21:21, Chris Fry wrote:
  This function does not work reliably with most databases, not just
  Informix. Caused me a lot of problems as I have a number of pages where
I'd
  like to display a No records found message.

 I normally have a count(*) query to know how much records belong to the
query
 (especially when I use LIMIT and that stuff).

 With Informix, you'll have to use sqlca.sqlerrd[0..5]. One of the elements
of
 the array is the amount of records.

  Just have to do it the hard way.
 
  I think there's a disclaimer in the docs about this being unreliable.

 It once was on the informix docs, but not anymore. The source may have
 changed.


 Saludos... :-)

 P.D.: No problems with pg_num_rows() :-)

 --
 Porqué usar una base de datos relacional cualquiera,
 si podés usar PostgreSQL?
 -
 Martín Marqués  |[EMAIL PROTECTED]
 Programador, Administrador, DBA |   Centro de Telematica
Universidad Nacional
 del Litoral
 -



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Informix - ifx_num_rows

2001-08-23 Thread Martín Marqués

On Jue 23 Ago 2001 16:50, you wrote:
 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 ?

From the php informix manual:

int ifx_num_rows (int result_id)
 Gives the number of rows fetched so far for a query with result_id after a 
ifx_query() or ifx_do() query. 

Saludos... :-)

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-
Martín Marqués  |[EMAIL PROTECTED]
Programador, Administrador, DBA |   Centro de Telematica
   Universidad Nacional
del Litoral
-

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Informix - ifx_num_rows

2001-08-23 Thread Chris Fry

This function does not work reliably with most databases, not just Informix.
Caused me a lot of problems as I have a number of pages where I'd like to
display a No records found message.

Just have to do it the hard way.

I think there's a disclaimer in the docs about this being unreliable.

Chris

Martín Marqués wrote:

 On Jue 23 Ago 2001 16:50, you wrote:
  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 ?

 From the php informix manual:

 int ifx_num_rows (int result_id)
  Gives the number of rows fetched so far for a query with result_id after a
 ifx_query() or ifx_do() query.

 Saludos... :-)

 --
 Porqué usar una base de datos relacional cualquiera,
 si podés usar PostgreSQL?
 -
 Martín Marqués  |[EMAIL PROTECTED]
 Programador, Administrador, DBA |   Centro de Telematica
Universidad Nacional
 del Litoral
 -

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]

--

Chris Fry
Quillsoft Pty Ltd
Specialists in Secure Internet Services and E-Commerce Solutions
10 Gray Street
Kogarah
NSW  2217
Australia

Phone: +61 2 9553 1691
Fax: +61 2 9553 1692
Mobile: 0419 414 323
eMail: [EMAIL PROTECTED]
http://www.quillsoft.com.au

You can download our Public CA Certificate from:-
https://ca.secureanywhere.com/htdocs/cacert.crt

**

This information contains confidential information intended only for
the use of the authorised recipient.  If you are not an authorised
recipient of this e-mail, please contact Quillsoft Pty Ltd by return
e-mail.
In this case, you should not read, print, re-transmit, store or act
in reliance on this e-mail or any attachments, and should destroy all
copies of them.
This e-mail and any attachments may also contain copyright material
belonging to Quillsoft Pty Ltd.
The views expressed in this e-mail or attachments are the views of
the author and not the views of Quillsoft Pty Ltd.
You should only deal with the material contained in this e-mail if
you are authorised to do so.

This notice should not be removed.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Informix - ifx_num_rows

2001-08-23 Thread Martín Marqués

On Jue 23 Ago 2001 21:21, Chris Fry wrote:
 This function does not work reliably with most databases, not just
 Informix. Caused me a lot of problems as I have a number of pages where I'd
 like to display a No records found message.

I normally have a count(*) query to know how much records belong to the query 
(especially when I use LIMIT and that stuff).

With Informix, you'll have to use sqlca.sqlerrd[0..5]. One of the elements of 
the array is the amount of records.

 Just have to do it the hard way.

 I think there's a disclaimer in the docs about this being unreliable.

It once was on the informix docs, but not anymore. The source may have 
changed.


Saludos... :-)

P.D.: No problems with pg_num_rows() :-)

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-
Martín Marqués  |[EMAIL PROTECTED]
Programador, Administrador, DBA |   Centro de Telematica
   Universidad Nacional
del Litoral
-

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]