Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQLRowCount problem with freeTDS+unixODBC+PHP with MSSQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Roger "Pe�a" Escobio <orkcu AT yahoo.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQLRowCount problem with freeTDS+unixODBC+PHP with MSSQL
  • Date: Fri, 16 Dec 2005 13:34:19 -0800 (PST)

as soon as I sent the messages I had another question
about this topic:

--- "Lowden, James K" <LowdenJK AT bernstein.com> wrote:

> > From: Roger "Pe�a" Escobio
> > Sent: Friday, December 16, 2005 3:44 PM
> >
> > I can't retrive the correct RowCount after a
> 'select' query, nor
> > do I can call another query, but if I run across
> all the result
> > (either with odbc_fetch_row() of odbc_result_all()
> ) I can get the
> > _right_ RowCount and execute another SQL query
>
> http://www.freetds.org/faq.html#pending
>
> These issues are both related to the fact that the
> rows are transmitted as the server fetches them.
> Until the last row is fetched, the rowcount is not
> known.
>
> > another problem is that the "row pointer", the one
> that allow to
> > retrive a particular row from the result, do not
> work at all :-(

if you are right, why the same PHP application run ok,
without any complain, in a Windows plataform ? with
other ODBC driver (I have to check which one)
php still should re-use the same connection, is it?
so my no-knowledge say that it have to do with the
driver also

another question that I have is why I can retrive an
specific row from the result of a query? the 2nd
argument of the function odbc_fetch_row() do work at
all :-(
bool odbc_fetch_row ( resource result_id [, int
row_number] )

is this a problem with freetds or an up-layer
(unixODBC, php) problem?

thanks

roger



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com




Archive powered by MHonArc 2.6.24.

Top of Page