Re: [PHP] Informix - ifx_num_rows
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
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
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
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]