Skip to Content.
Sympa Menu

freetds - TDS protocol documentation addition

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Chris Eleveld <ihermit2 AT yahoo.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: TDS protocol documentation addition
  • Date: Wed, 23 Jan 2002 11:24:35 -0800 (PST)


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/




Archive powered by MHonArc 2.6.24.

Top of Page