freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Problem retrieveing results from a query withan IMAGE field
- From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Problem retrieveing results from a query withan IMAGE field
- Date: Thu, 5 Jun 2008 15:29:05 +0200
>
> Il giorno mer, 04/06/2008 alle 15.05 -0300, Daniel A. Veiga
> ha scritto:
> > This is the TDSDUMP log generated for the same program I sent the
> > unixODBC log file for. I hope it helps ...
> >
> > Daniel
> >
>
> it helps, it helps :)
>
> The code which cause the problem is in _SQLFetch
>
>
> /* TODO change when we code cursors support... */
> /* stop looping, forward cursor support only one row */
> num_rows = 1;
>
> well.. this tell to stop processing rows if an unbinded
> column is found.
> This is done to allow getting results using SQLGetData
> however we send a
> cursor fetch for 20 rows so in this case we have still to read 19 rows
> when SQLFetchScroll returns :(
>
> Well... for forward only cursors this is correct for perhaps
> for cursors
> is not... I think the correct processing should be fetch all
> 20 rows or
> request only a row (I think the last is the most probable)...
> I'll have
> to test.
>
commenting num_rows = 1 line seems to fix the problem. Under ODBC 2
SQLFetch returns only a row and does not take into account fetched_ptr,
array_size and status_ptr.
freddy77
-
[freetds] Problem retrieveing results from a query with an IMAGE field,
Daniel A. Veiga, 06/02/2008
- Re: [freetds] Problem retrieveing results from a query with an IMAGEfield, ZIGLIO, Frediano, VF-IT, 06/03/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
James K. Lowden, 06/04/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
Daniel A. Veiga, 06/04/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
Frediano Ziglio, 06/04/2008
- Re: [freetds] Problem retrieveing results from a query withan IMAGE field, ZIGLIO, Frediano, VF-IT, 06/05/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
Daniel A. Veiga, 06/09/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
ZIGLIO, Frediano, VF-IT, 06/10/2008
- Re: [freetds] Problem retrieveing results from a query with an IMAGE field, Daniel A. Veiga, 06/11/2008
-
[freetds] Problem retrieveing results from bottom to top,
Daniel A. Veiga, 06/11/2008
- Re: [freetds] Problem retrieveing results from bottom to top, James K. Lowden, 06/11/2008
- Re: [freetds] Problem retrieveing results from bottom to top, Daniel A. Veiga, 06/12/2008
- Re: [freetds] Problem retrieveing results from bottom to top, ZIGLIO, Frediano, VF-IT, 06/12/2008
- Re: [freetds] Problem retrieveing results from bottom to top, James K. Lowden, 06/13/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
ZIGLIO, Frediano, VF-IT, 06/10/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
Frediano Ziglio, 06/04/2008
-
Re: [freetds] Problem retrieveing results from a query with an IMAGE field,
Daniel A. Veiga, 06/04/2008
Archive powered by MHonArc 2.6.24.