Skip to Content.
Sympa Menu

freetds - Re: TDS protocol documentation addition

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: TDS protocol documentation addition
  • Date: Wed, 23 Jan 2002 18:01:15 -0500 (EST)


All checked in.

Brian

On Wed, 23 Jan 2002, Chris Eleveld wrote:

> possible update for TDS documentation on website:
>
> under TDS 4.6:
> Order By (0xA9 169)
> from:
> INT16 variable
> +--------+---------+
> | length | magic |
> +--------+---------+
>
> length Length of packet
> magic ?
>
> to:
> INT16 variable (1 byte per col)
> +--------+---------+
> | length | orders |
> +--------+---------+
>
> length Length of packet(and number of cols)
> orders one byte per order by indicating the
> column # in the output matching the
> order from Column Info and Column
> Names
> and data in following Row Data items.
> A 0 indicates the column is not in the
> resulting rows.
>
> an example:
> select first_name, last_name, number from employee
> order by salary, number
> assuming the columns are returned in the order
> queried:
> first_name then last_name, then number. we would have:
> ----------------
> | 2 | 0 | 3 |
> ----------------
> where length = 2 then the orders evaluate:
> 0 for salary, meaning there is no salary data returned
> 3 for number, meaning the 3rd data item corresponding
> to a column is the number
>
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page