Yes, you are right.  The only thing I can think of is that the driver is not
updating the data length from the SQLBindCol to let DBD::ODBC the data
length has changed (from the trace file).

If the data length is SQL_NULL_DATA, then DBD::ODBC makes sure the field is
set to undef, otherwise, it used the data retrieved (pushed) to DBD::ODBC,
since I'm using SQLBindCol.  That may be different than what isql
does...since Nick already commented that it's using SQLGetData...DBD::ODBC
only uses SQLGetData in rare circumstances.

I'd check on your versions of FreeTDS and unixODBC...

Regards,

Jeff

> -----Original Message-----
> From: Dave Thorn [mailto:davet@;fysh.org]
> Sent: Tuesday, October 22, 2002 12:16 PM
> To: Jeff Urlwin
> Cc: [EMAIL PROTECTED]
> Subject: Re: :ODBC bug?
>
>
> On Tue, Oct 22, 2002 at 12:11:43PM -0400, Jeff Urlwin wrote:
> > Right, but I only see one row in the message, per query.
> Shouldn't there be
> > two?
>
> I think you're mis-parsing it.  The DURATION and PERFORMER bits are in
> different rows to each other.
>
> > | DURATION            |
> > |
> > | PERFORMER           | RICHARD G. MITCHELL
>
> two rows.  I took the liberty of selecting less fields than with the
> previous queries to try and make it slightly more readable, sorry,
> should have mentioned that, hoped it'd show in the output.
>
> > | PERFORMER           | RICHARD G. MITCHELL
> > |
> > | DURATION            |
>
> two rows (other query)
>
> --
> dave thorn | [EMAIL PROTECTED]
>


Reply via email to