FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Hi David,

The variable you have bound the numeric/decimal column to. 
How is that declared ? 
If you have told ct_bind that you are binding to a numeric type host
variable (which you have) then that variable must be declared as a
CS_NUMERIC type.
a CS_NUMERIC is not a string. It's a binary datatype.

If you want to print out or see the ersulting data as a string
representation of the number, you should bind it to a char type host
variable.
Then cs_convert will convert the output to a string.

Bill


> -----Original Message-----
> From: David Nsengiyumva [SMTP:davidn AT finsolutions.co.za]
> Sent: 05 December 2003 08:07
> To:   freetds AT lists.ibiblio.org
> Subject:      [freetds] Retrieving Numbers and Dates
> 
> Hi Champs,
> 
> I am trying to execute a Query that supposed to retrieve numbers and
> dates.
> When I retirve strings It works fine but When I do Numbers or Dates then I
> get empty strings....
> 
> the 'cs_convert' function goes to the is statement 'src_type == desttype'
> then the switch statement 'switch (desttype)' goes to 'SYBNUMERIC' and
> 'SYBDECIMAL' cases and since
> scr_len > destlen then the function returns CS_FAIL.
> 
> I've hardcoded the src_len (which is basically just 'srcfmt->maxlength')
> to
> be, say, 50. I did it in the '_ct_bind_data' function. Instead of
> 'destfmt.maxlength = curcol->column_bindlen;' I do
> 'destfmt.maxlength = 50'.
> 
> Then if I do that, in the 'cs_convert' function, the 'SYBNUMERIC' and
> 'SYBDECIMAL' cases in the switch statement, the 'emcpy(dest, srcdata,
> src_len);' copies an empty string.
> 
> What's can be wrong???? What can I do???
> 
> My log file looks like this:
> 
> Starting log file with debug level 99.
> 2003-12-05 09:54:02 iconv library not employed, relying on ISO-8859-1
> compatibility
> 2003-12-05 09:54:02 Connecting addr 10.0.3.73 port 1433 with TDS version
> 7.0
> 2003-12-05 09:54:03 inside tds_process_login_tokens()
> Received header @ 2003-12-05 09:54:03
> 0000  04 01 01 b0 00 45 01 00                            |.....E..|
> 
> 
> Received packet @ 2003-12-05 09:54:03
> 0000  e3 1b 00 01 06 6d 00 61  00 73 00 74 00 65 00 72   |.....m.a
> .s.t.e.r|
> 0010  00 06 6d 00 61 00 73 00  74 00 65 00 72 00 ab 6e   |..m.a.s.
> t.e.r..n|
> 0020  00 45 16 00 00 02 00 25  00 43 00 68 00 61 00 6e   |.E.....%
> .C.h.a.n|
> 0030  00 67 00 65 00 64 00 20  00 64 00 61 00 74 00 61   |.g.e.d.
> .d.a.t.a|
> 0040  00 62 00 61 00 73 00 65  00 20 00 63 00 6f 00 6e   |.b.a.s.e .
> .c.o.n|
> 0050  00 74 00 65 00 78 00 74  00 20 00 74 00 6f 00 20   |.t.e.x.t . .t.o.
> |
> 0060  00 27 00 6d 00 61 00 73  00 74 00 65 00 72 00 27   |.'.m.a.s
> .t.e.r.'|
> 0070  00 2e 00 0c 46 00 49 00  4e 00 53 00 4f 00 4c 00   |....F.I.
> N.S.O.L.|
> 0080  53 00 51 00 4c 00 44 00  45 00 56 00 00 00 00 e3   |S.Q.L.D.
> E.V.....|
> 0090  17 00 02 0a 75 00 73 00  5f 00 65 00 6e 00 67 00   |....u.s.
> _.e.n.g.|
> 00a0  6c 00 69 00 73 00 68 00  00 ab 72 00 47 16 00 00   |l.i.s.h.
> ..r.G...|
> 00b0  01 00 27 00 43 00 68 00  61 00 6e 00 67 00 65 00   |..'.C.h.
> a.n.g.e.|
> 00c0  64 00 20 00 6c 00 61 00  6e 00 67 00 75 00 61 00   |d. .l.a.
> n.g.u.a.|
> 00d0  67 00 65 00 20 00 73 00  65 00 74 00 74 00 69 00   |g.e. .s.
> e.t.t.i.|
> 00e0  6e 00 67 00 20 00 74 00  6f 00 20 00 75 00 73 00   |n.g. .t. o.
> .u.s.|
> 00f0  5f 00 65 00 6e 00 67 00  6c 00 69 00 73 00 68 00   |_.e.n.g.
> l.i.s.h.|
> 0100  2e 00 0c 46 00 49 00 4e  00 53 00 4f 00 4c 00 53   |...F.I.N
> .S.O.L.S|
> 0110  00 51 00 4c 00 44 00 45  00 56 00 00 00 00 e3 0f   |.Q.L.D.E
> .V......|
> 0120  00 03 05 69 00 73 00 6f  00 5f 00 31 00 01 00 00   |...i.s.o
> ._.1....|
> 0130  e3 0b 00 05 04 31 00 30  00 33 00 33 00 00 e3 0f   |.....1.0
> .3.3....|
> 0140  00 06 06 31 00 39 00 36  00 36 00 30 00 39 00 00   |...1.9.6
> .6.0.9..|
> 0150  ad 36 00 01 07 00 00 00  16 4d 00 69 00 63 00 72   |.6......
> .M.i.c.r|
> 0160  00 6f 00 73 00 6f 00 66  00 74 00 20 00 53 00 51   |.o.s.o.f .t.
> .S.Q|
> 0170  00 4c 00 20 00 53 00 65  00 72 00 76 00 65 00 72   |.L. .S.e
> .r.v.e.r|
> 0180  00 00 00 00 00 08 00 02  f8 e3 13 00 04 04 34 00   |........
> ......4.|
> 0190  30 00 39 00 36 00 04 34  00 30 00 39 00 36 00 fd   |0.9.6..4
> .0.9.6..|
> 01a0  00 00 00 00 00 00 00 00                            |........|
> 
> 
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is
> e3(ENVCHANGE)
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is ab(INFO)
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is
> e3(ENVCHANGE)
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is ab(INFO)
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is
> e3(ENVCHANGE)
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is
> e3(ENVCHANGE)
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is
> e3(ENVCHANGE)
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is
> e3(ENVCHANGE)
> 2003-12-05 09:54:03 increasing block size from 4096 to 4096
> 2003-12-05 09:54:03 inside tds_process_default_tokens() marker is fd(DONE)
> 2003-12-05 09:54:03 inside tds_process_end() more_results = 0,
> was_cancelled
> = 0
> 2003-12-05 09:54:03 inside tds_process_default_tokens() setting state to
> COMPLETED
> Sending packet @ 2003-12-05 09:54:03
> 0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |..."....
> s.e.l.e.|
> 0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@.
> @.s.p.i.|
> 0020  64 00                                              |d.|
> 
> 
> Received header @ 2003-12-05 09:54:03
> 0000  04 01 00 1d 00 45 01 00                            |.....E..|
> 
> 
> Received packet @ 2003-12-05 09:54:03
> 0000  81 01 00 00 00 00 00 34  00 d1 45 00 fd 10 00 c1   |.......4
> ..E.....|
> 0010  00 01 00 00 00                                     |.....|
> 
> 
> 2003-12-05 09:54:03 processing result tokens.  marker is  81(TDS7_RESULT)
> 2003-12-05 09:54:03 tds7_get_data_info:1083:
>       type = 52 (smallint)
>       column_varint_size = 0
>       colname =
>       colnamelen = 0
> 2003-12-05 09:54:03 processing row tokens.  marker is  d1(ROW)
> 2003-12-05 09:54:03 processing row.  column is 0 varint size = 0
> 2003-12-05 09:54:03 processing row.  column size is 2
> 2003-12-05 09:54:03 clearing column 0 NULL bit
> 2003-12-05 09:54:03 processing row tokens.  marker is  fd(DONE)
> 2003-12-05 09:54:03 inside tds_process_end() more_results = 0,
> was_cancelled
> = 0
> 2003-12-05 09:54:03 inside tds_process_result_tokens() state is COMPLETED
> 2003-12-05 09:54:03 leaving tds_process_login_tokens() returning 1
> 2003-12-05 09:54:03 leaving ct_connect() returning 1
> 2003-12-05 09:54:03 inside ct_cmd_alloc()
> 2003-12-05 09:54:04 inside ct_command()
> 2003-12-05 09:54:04 inside ct_send()
> Sending packet @ 2003-12-05 09:54:04
> 0000  01 01 00 2a 00 00 01 00  75 00 73 00 65 00 20 00   |...*.... u.s.e.
> .|
> 0010  71 00 75 00 61 00 6e 00  74 00 5f 00 62 00 61 00   |q.u.a.n.
> t._.b.a.|
> 0020  73 00 65 00 5f 00 76 00  33 00                     |s.e._.v. 3.|
> 
> 
> 2003-12-05 09:54:04 ct_send() succeeded
> 2003-12-05 09:54:04 inside ct_results()
> Received header @ 2003-12-05 09:54:04
> 0000  04 01 00 bc 00 45 01 00                            |.....E..|
> 
> 
> Received packet @ 2003-12-05 09:54:04
> 0000  e3 29 00 01 0d 71 00 75  00 61 00 6e 00 74 00 5f   |.)...q.u
> .a.n.t._|
> 0010  00 62 00 61 00 73 00 65  00 5f 00 76 00 33 00 06   |.b.a.s.e
> ._.v.3..|
> 0020  6d 00 61 00 73 00 74 00  65 00 72 00 ab 7c 00 45   |m.a.s.t.
> e.r..|.E|
> 0030  16 00 00 01 00 2c 00 43  00 68 00 61 00 6e 00 67   |.....,.C
> .h.a.n.g|
> 0040  00 65 00 64 00 20 00 64  00 61 00 74 00 61 00 62   |.e.d. .d
> .a.t.a.b|
> 0050  00 61 00 73 00 65 00 20  00 63 00 6f 00 6e 00 74   |.a.s.e.
> .c.o.n.t|
> 0060  00 65 00 78 00 74 00 20  00 74 00 6f 00 20 00 27   |.e.x.t.  .t.o.
> .'|
> 0070  00 71 00 75 00 61 00 6e  00 74 00 5f 00 62 00 61   |.q.u.a.n
> .t._.b.a|
> 0080  00 73 00 65 00 5f 00 76  00 33 00 27 00 2e 00 0c   |.s.e._.v
> .3.'....|
> 0090  46 00 49 00 4e 00 53 00  4f 00 4c 00 53 00 51 00   |F.I.N.S.
> O.L.S.Q.|
> 00a0  4c 00 44 00 45 00 56 00  00 01 00 fd 00 00 e2 00   |L.D.E.V.
> ........|
> 00b0  00 00 00 00                                        |....|
> 
> 
> 2003-12-05 09:54:04 processing result tokens.  marker is  e3(ENVCHANGE)
> 2003-12-05 09:54:04 inside tds_process_default_tokens() marker is
> e3(ENVCHANGE)
> 2003-12-05 09:54:04 processing result tokens.  marker is  ab(INFO)
> 2003-12-05 09:54:04 inside tds_process_default_tokens() marker is ab(INFO)
> 2003-12-05 09:54:04 processing result tokens.  marker is  fd(DONE)
> 2003-12-05 09:54:04 inside tds_process_end() more_results = 0,
> was_cancelled
> = 0
> 2003-12-05 09:54:04 inside ct_results() process_result_tokens returned 1
> (type 4047)
> 2003-12-05 09:54:04 inside ct_results()
> 2003-12-05 09:54:04 inside tds_process_result_tokens() state is COMPLETED
> 2003-12-05 09:54:04 inside ct_results() process_result_tokens returned 2
> (type 4046)
> 2003-12-05 09:54:06 inside ct_command()
> 2003-12-05 09:54:06 inside ct_send()
> Sending packet @ 2003-12-05 09:54:06
> 0000  01 01 01 c2 00 00 01 00  53 00 45 00 4c 00 45 00   |........
> S.E.L.E.|
> 0010  43 00 54 00 20 00 63 00  2e 00 6e 00 61 00 6d 00   |C.T. .c.
> ..n.a.m.|
> 0020  65 00 20 00 27 00 70 00  61 00 72 00 61 00 6d 00   |e. .'.p.
> a.r.a.m.|
> 0030  65 00 74 00 65 00 72 00  5f 00 6e 00 61 00 6d 00   |e.t.e.r.
> _.n.a.m.|
> 0040  65 00 27 00 2c 00 20 00  74 00 2e 00 6e 00 61 00   |e.'.,. .
> t...n.a.|
> 0050  6d 00 65 00 20 00 27 00  70 00 61 00 72 00 61 00   |m.e. .'.
> p.a.r.a.|
> 0060  6d 00 65 00 74 00 65 00  72 00 5f 00 74 00 79 00   |m.e.t.e.
> r._.t.y.|
> 0070  70 00 65 00 27 00 20 00  46 00 52 00 4f 00 4d 00   |p.e.'. .
> F.R.O.M.|
> 0080  20 00 73 00 79 00 73 00  6f 00 62 00 6a 00 65 00   | .s.y.s.
> o.b.j.e.|
> 0090  63 00 74 00 73 00 20 00  6f 00 20 00 49 00 4e 00   |c.t.s. . o.
> .I.N.|
> 00a0  4e 00 45 00 52 00 20 00  4a 00 4f 00 49 00 4e 00   |N.E.R. .
> J.O.I.N.|
> 00b0  20 00 73 00 79 00 73 00  63 00 6f 00 6c 00 75 00   | .s.y.s.
> c.o.l.u.|
> 00c0  6d 00 6e 00 73 00 20 00  63 00 20 00 4f 00 4e 00   |m.n.s. . c.
> .O.N.|
> 00d0  20 00 28 00 6f 00 2e 00  69 00 64 00 20 00 3d 00   | .(.o... i.d.
> .=.|
> 00e0  20 00 63 00 2e 00 69 00  64 00 29 00 20 00 49 00   | .c...i. d.).
> .I.|
> 00f0  4e 00 4e 00 45 00 52 00  20 00 4a 00 4f 00 49 00   |N.N.E.R.
> .J.O.I.|
> 0100  4e 00 20 00 73 00 79 00  73 00 74 00 79 00 70 00   |N. .s.y.
> s.t.y.p.|
> 0110  65 00 73 00 20 00 74 00  20 00 4f 00 4e 00 20 00   |e.s. .t.  .O.N.
> .|
> 0120  28 00 63 00 2e 00 78 00  74 00 79 00 70 00 65 00   |(.c...x.
> t.y.p.e.|
> 0130  20 00 3d 00 20 00 74 00  2e 00 78 00 74 00 79 00   | .=. .t.
> ..x.t.y.|
> 0140  70 00 65 00 29 00 20 00  57 00 48 00 45 00 52 00   |p.e.). .
> W.H.E.R.|
> 0150  45 00 20 00 6f 00 2e 00  6e 00 61 00 6d 00 65 00   |E. .o...
> n.a.m.e.|
> 0160  20 00 3d 00 20 00 27 00  61 00 70 00 5f 00 73 00   | .=. .'.
> a.p._.s.|
> 0170  65 00 6c 00 5f 00 65 00  71 00 75 00 69 00 74 00   |e.l._.e.
> q.u.i.t.|
> 0180  79 00 5f 00 6d 00 65 00  74 00 61 00 5f 00 64 00   |y._.m.e.
> t.a._.d.|
> 0190  61 00 74 00 61 00 27 00  20 00 4f 00 52 00 44 00   |a.t.a.'.
> .O.R.D.|
> 01a0  45 00 52 00 20 00 42 00  59 00 20 00 63 00 2e 00   |E.R. .B. Y.
> .c...|
> 01b0  63 00 6f 00 6c 00 6f 00  72 00 64 00 65 00 72 00   |c.o.l.o.
> r.d.e.r.|
> 01c0  3b 00                                              |;.|
> 
> 
> 2003-12-05 09:54:06 ct_send() succeeded
> 2003-12-05 09:54:06 inside ct_results()
> Received header @ 2003-12-05 09:54:06
> 0000  04 01 00 8c 00 45 01 00                            |.....E..|
> 
> 
> Received packet @ 2003-12-05 09:54:06
> 0000  81 02 00 00 01 08 00 e7  00 01 0e 70 00 61 00 72   |........
> ...p.a.r|
> 0010  00 61 00 6d 00 65 00 74  00 65 00 72 00 5f 00 6e   |.a.m.e.t
> .e.r._.n|
> 0020  00 61 00 6d 00 65 00 00  01 08 00 e7 00 01 0e 70   |.a.m.e..
> .......p|
> 0030  00 61 00 72 00 61 00 6d  00 65 00 74 00 65 00 72   |.a.r.a.m
> .e.t.e.r|
> 0040  00 5f 00 74 00 79 00 70  00 65 00 a9 02 00 00 00   |._.t.y.p
> .e......|
> 0050  d1 18 00 40 00 70 00 5f  00 65 00 71 00 75 00 69   |...@.p._
> .e.q.u.i|
> 0060  00 74 00 79 00 5f 00 69  00 64 00 0e 00 6e 00 75   |.t.y._.i
> .d...n.u|
> 0070  00 6d 00 65 00 72 00 69  00 63 00 fd 10 00 c1 00   |.m.e.r.i
> .c......|
> 0080  01 00 00 00                                        |....|
> 
> 
> 2003-12-05 09:54:06 processing result tokens.  marker is  81(TDS7_RESULT)
> 2003-12-05 09:54:06 tds7_get_data_info:1083:
>       type = 39 (varchar)
>       column_varint_size = 2
>       colname = parameter_name
>       colnamelen = 14
> 2003-12-05 09:54:06 tds7_get_data_info:1083:
>       type = 39 (varchar)
>       column_varint_size = 2
>       colname = parameter_type
>       colnamelen = 14
> 2003-12-05 09:54:06 inside ct_results() process_result_tokens returned 1
> (type 4049)
> 2003-12-05 09:54:06 processing result tokens.  marker is  a9(ORDERBY)
> 2003-12-05 09:54:06 inside tds_process_default_tokens() marker is
> a9(ORDERBY)
> eating token 169
> 2003-12-05 09:54:06 processing result tokens.  marker is  d1(ROW)
> 2003-12-05 09:54:06 inside ct_results() process_result_tokens returned 1
> (type 4040)
> 2003-12-05 09:54:06 inside ct_res_info()
> 2003-12-05 09:54:06 ct_res_info(): Number of columns is 2
> 2003-12-05 09:54:07 inside ct_describe()
> 2003-12-05 09:54:07 inside _ct_get_client_type(type 39, size 256)
> 2003-12-05 09:54:07 inside ct_describe() datafmt->datatype = 1 server type
> 39
> 2003-12-05 09:54:08 inside ct_bind()
> 2003-12-05 09:54:08 inside ct_bind() item = 1 datafmt->datatype = 1
> 2003-12-05 09:54:08 inside ct_describe()
> 2003-12-05 09:54:08 inside _ct_get_client_type(type 39, size 256)
> 2003-12-05 09:54:08 inside ct_describe() datafmt->datatype = 1 server type
> 39
> 2003-12-05 09:54:09 inside ct_bind()
> 2003-12-05 09:54:09 inside ct_bind() item = 2 datafmt->datatype = 1
> 2003-12-05 09:54:09 inside ct_fetch()
> 2003-12-05 09:54:09 processing row tokens.  marker is  d1(ROW)
> 2003-12-05 09:54:09 processing row.  column is 0 varint size = 2
> 2003-12-05 09:54:09 processing row.  column size is 24
> 2003-12-05 09:54:09 clearing column 0 NULL bit
> 2003-12-05 09:54:09 processing row.  column is 1 varint size = 2
> 2003-12-05 09:54:09 processing row.  column size is 14
> 2003-12-05 09:54:09 clearing column 1 NULL bit
> 2003-12-05 09:54:09 inside ct_fetch() process_row_tokens returned 1
> 2003-12-05 09:54:09 inside _ct_bind_data()
> 2003-12-05 09:54:09 inside _ct_get_server_type(1)
> 2003-12-05 09:54:09 inside _ct_get_client_type(type 39, size 256)
> 2003-12-05 09:54:09 inside _ct_bind_data() setting source length for 0 =
> 12
> destlen = 256
> 2003-12-05 09:54:10 inside cs_convert()
> 2003-12-05 09:54:10 inside _ct_get_server_type(1)
> 2003-12-05 09:54:10 inside _ct_get_server_type(1)
> 2003-12-05 09:54:10 inside cs_convert() srctype = 47 (12) desttype = 47
> (256)
> 2003-12-05 09:54:10 inside cs_convert() srctype = desttype
> 2003-12-05 09:54:10 inside cs_convert() desttype = character
> 2003-12-05 09:54:10 inside _ct_bind_data() length binding len = 13
> 2003-12-05 09:54:10 inside _ct_get_server_type(1)
> 2003-12-05 09:54:10 inside _ct_get_client_type(type 39, size 256)
> 2003-12-05 09:54:10 inside _ct_bind_data() setting source length for 1 = 7
> destlen = 256
> 2003-12-05 09:54:11 inside cs_convert()
> 2003-12-05 09:54:11 inside _ct_get_server_type(1)
> 2003-12-05 09:54:11 inside _ct_get_server_type(1)
> 2003-12-05 09:54:11 inside cs_convert() srctype = 47 (7) desttype = 47
> (256)
> 2003-12-05 09:54:11 inside cs_convert() srctype = desttype
> 2003-12-05 09:54:11 inside cs_convert() desttype = character
> 2003-12-05 09:54:11 inside _ct_bind_data() length binding len = 8
> 2003-12-05 09:54:12 inside ct_describe()
> 2003-12-05 09:54:12 inside _ct_get_client_type(type 39, size 256)
> 2003-12-05 09:54:12 inside ct_describe() datafmt->datatype = 1 server type
> 39
> 2003-12-05 09:54:12 inside ct_bind()
> 2003-12-05 09:54:12 inside ct_bind() item = 1 datafmt->datatype = 1
> 2003-12-05 09:54:13 inside ct_describe()
> 2003-12-05 09:54:13 inside _ct_get_client_type(type 39, size 256)
> 2003-12-05 09:54:13 inside ct_describe() datafmt->datatype = 1 server type
> 39
> 2003-12-05 09:54:13 inside ct_bind()
> 2003-12-05 09:54:13 inside ct_bind() item = 2 datafmt->datatype = 1
> 2003-12-05 09:54:13 inside ct_fetch()
> 2003-12-05 09:54:13 inside ct_results()
> 2003-12-05 09:54:13 processing result tokens.  marker is  fd(DONE)
> 2003-12-05 09:54:13 inside tds_process_end() more_results = 0,
> was_cancelled
> = 0
> 2003-12-05 09:54:13 inside ct_results() process_result_tokens returned 1
> (type 4046)
> 2003-12-05 09:54:13 inside ct_results()
> 2003-12-05 09:54:13 inside tds_process_result_tokens() state is COMPLETED
> 2003-12-05 09:54:13 inside ct_results() process_result_tokens returned 2
> (type 4046)
> 2003-12-05 09:54:15 inside ct_command()
> 2003-12-05 09:54:15 inside ct_send()
> Sending packet @ 2003-12-05 09:54:15
> 0000  01 01 00 62 00 00 01 00  65 00 78 00 65 00 63 00   |...b....
> e.x.e.c.|
> 0010  20 00 61 00 70 00 5f 00  73 00 65 00 6c 00 5f 00   | .a.p._.
> s.e.l._.|
> 0020  65 00 71 00 75 00 69 00  74 00 79 00 5f 00 6d 00   |e.q.u.i.
> t.y._.m.|
> 0030  65 00 74 00 61 00 5f 00  64 00 61 00 74 00 61 00   |e.t.a._.
> d.a.t.a.|
> 0040  20 00 40 00 70 00 5f 00  65 00 71 00 75 00 69 00   | .@.p._.
> e.q.u.i.|
> 0050  74 00 79 00 5f 00 69 00  64 00 3d 00 31 00 30 00   |t.y._.i.
> d.=.1.0.|
> 0060  3b 00                                              |;.|
> 
> 
> 2003-12-05 09:54:15 ct_send() succeeded
> 2003-12-05 09:54:16 inside ct_results()
> Received header @ 2003-12-05 09:54:16
> 0000  04 01 01 fe 00 45 01 00                            |.....E..|
> 
> 
> Received packet @ 2003-12-05 09:54:16
> 0000  81 03 00 00 00 10 00 6c  11 0a 00 0e 65 00 71 00   |.......l
> ....e.q.|
> 0010  75 00 69 00 74 00 79 00  5f 00 74 00 79 00 70 00   |u.i.t.y.
> _.t.y.p.|
> 0020  65 00 5f 00 69 00 64 00  00 00 08 00 6c 11 0a 00   |e._.i.d.
> ....l...|
> 0030  09 66 00 61 00 63 00 74  00 6f 00 72 00 5f 00 69   |.f.a.c.t
> .o.r._.i|
> 0040  00 64 00 00 00 08 00 6c  11 0a 00 15 65 00 6e 00   |.d.....l
> ....e.n.|
> 0050  74 00 69 00 74 00 79 00  5f 00 73 00 65 00 72 00   |t.i.t.y.
> _.s.e.r.|
> 0060  69 00 65 00 73 00 5f 00  74 00 79 00 70 00 65 00   |i.e.s._.
> t.y.p.e.|
> 0070  5f 00 69 00 64 00 d1 05  01 02 00 00 00 05 01 02   |_.i.d...
> ........|
> 0080  00 00 00 05 01 02 00 00  00 d1 05 01 02 00 00 00   |........
> ........|
> 0090  05 01 03 00 00 00 05 01  02 00 00 00 d1 05 01 02   |........
> ........|
> 00a0  00 00 00 05 01 04 00 00  00 05 01 02 00 00 00 d1   |........
> ........|
> 00b0  05 01 02 00 00 00 05 01  05 00 00 00 05 01 02 00   |........
> ........|
> 00c0  00 00 d1 05 01 02 00 00  00 05 01 06 00 00 00 05   |........
> ........|
> 00d0  01 02 00 00 00 d1 05 01  02 00 00 00 05 01 07 00   |........
> ........|
> 00e0  00 00 05 01 02 00 00 00  d1 05 01 02 00 00 00 05   |........
> ........|
> 00f0  01 08 00 00 00 05 01 02  00 00 00 d1 05 01 02 00   |........
> ........|
> 0100  00 00 05 01 09 00 00 00  05 01 02 00 00 00 d1 05   |........
> ........|
> 0110  01 02 00 00 00 05 01 0a  00 00 00 05 01 02 00 00   |........
> ........|
> 0120  00 d1 05 01 02 00 00 00  05 01 0b 00 00 00 05 01   |........
> ........|
> 0130  02 00 00 00 d1 05 01 02  00 00 00 05 01 11 00 00   |........
> ........|
> 0140  00 05 01 03 00 00 00 d1  05 01 02 00 00 00 05 01   |........
> ........|
> 0150  12 00 00 00 05 01 03 00  00 00 d1 05 01 02 00 00   |........
> ........|
> 0160  00 05 01 13 00 00 00 05  01 03 00 00 00 d1 05 01   |........
> ........|
> 0170  02 00 00 00 05 01 14 00  00 00 05 01 03 00 00 00   |........
> ........|
> 0180  d1 05 01 02 00 00 00 05  01 17 00 00 00 05 01 03   |........
> ........|
> 0190  00 00 00 d1 05 01 02 00  00 00 05 01 18 00 00 00   |........
> ........|
> 01a0  05 01 03 00 00 00 d1 05  01 02 00 00 00 05 01 19   |........
> ........|
> 01b0  00 00 00 05 01 05 00 00  00 d1 05 01 02 00 00 00   |........
> ........|
> 01c0  05 01 1a 00 00 00 05 01  04 00 00 00 d1 05 01 02   |........
> ........|
> 01d0  00 00 00 05 01 1b 00 00  00 05 01 02 00 00 00 ff   |........
> ........|
> 01e0  11 00 c1 00 13 00 00 00  79 00 00 00 00 fe 00 00   |........
> y.......|
> 01f0  e0 00 13 00 00 00                                  |......|
> 
> 
> 2003-12-05 09:54:16 processing result tokens.  marker is  81(TDS7_RESULT)
> 2003-12-05 09:54:16 tds7_get_data_info:1083:
>       type = 108 (numeric)
>       column_varint_size = 1
>       colname = equity_type_id
>       colnamelen = 14
> 2003-12-05 09:54:16 tds7_get_data_info:1083:
>       type = 108 (numeric)
>       column_varint_size = 1
>       colname = factor_id
>       colnamelen = 9
> 2003-12-05 09:54:16 tds7_get_data_info:1083:
>       type = 108 (numeric)
>       column_varint_size = 1
>       colname = entity_series_type_id
>       colnamelen = 21
> 2003-12-05 09:54:16 inside ct_results() process_result_tokens returned 1
> (type 4049)
> 2003-12-05 09:54:16 processing result tokens.  marker is  d1(ROW)
> 2003-12-05 09:54:16 inside ct_results() process_result_tokens returned 1
> (type 4040)
> 2003-12-05 09:54:16 inside ct_res_info()
> 2003-12-05 09:54:16 ct_res_info(): Number of columns is 3
> 2003-12-05 09:54:18 inside ct_describe()
> 2003-12-05 09:54:18 inside _ct_get_client_type(type 108, size 17)
> 2003-12-05 09:54:18 inside ct_describe() datafmt->datatype = 7 server type
> 108
> 2003-12-05 09:54:19 inside ct_bind()
> 2003-12-05 09:54:19 inside ct_bind() item = 1 datafmt->datatype = 7
> 2003-12-05 09:54:20 inside ct_describe()
> 2003-12-05 09:54:20 inside _ct_get_client_type(type 108, size 17)
> 2003-12-05 09:54:20 inside ct_describe() datafmt->datatype = 7 server type
> 108
> 2003-12-05 09:54:20 inside ct_bind()
> 2003-12-05 09:54:20 inside ct_bind() item = 2 datafmt->datatype = 7
> 2003-12-05 09:54:21 inside ct_describe()
> 2003-12-05 09:54:21 inside _ct_get_client_type(type 108, size 17)
> 2003-12-05 09:54:21 inside ct_describe() datafmt->datatype = 7 server type
> 108
> 2003-12-05 09:54:22 inside ct_bind()
> 2003-12-05 09:54:22 inside ct_bind() item = 3 datafmt->datatype = 7
> 2003-12-05 09:54:22 inside ct_fetch()
> 2003-12-05 09:54:22 processing row tokens.  marker is  d1(ROW)
> 2003-12-05 09:54:22 processing row.  column is 0 varint size = 1
> 2003-12-05 09:54:22 processing row.  column size is 5
> 2003-12-05 09:54:22 clearing column 0 NULL bit
> 2003-12-05 09:54:22 swapping numeric data...
> 2003-12-05 09:54:22 processing row.  column is 1 varint size = 1
> 2003-12-05 09:54:22 processing row.  column size is 5
> 2003-12-05 09:54:22 clearing column 1 NULL bit
> 2003-12-05 09:54:22 swapping numeric data...
> 2003-12-05 09:54:22 processing row.  column is 2 varint size = 1
> 2003-12-05 09:54:22 processing row.  column size is 5
> 2003-12-05 09:54:22 clearing column 2 NULL bit
> 2003-12-05 09:54:22 swapping numeric data...
> 2003-12-05 09:54:22 inside ct_fetch() process_row_tokens returned 1
> 2003-12-05 09:54:23 inside _ct_bind_data()
> 2003-12-05 09:54:23 inside _ct_get_server_type(7)
> 2003-12-05 09:54:23 inside _ct_get_client_type(type 108, size 17)
> 2003-12-05 09:54:23 inside _ct_bind_data() setting source length for 0 =
> 35
> destlen = 17
> 2003-12-05 09:54:25 inside cs_convert()
> 2003-12-05 09:54:26 inside _ct_get_server_type(7)
> 2003-12-05 09:54:26 inside _ct_get_server_type(7)
> 2003-12-05 09:54:27 inside cs_convert() srctype = 108 (35) desttype = 108
> (17)
> 2003-12-05 09:54:30 inside cs_convert() srctype = desttype
> 2003-12-05 09:54:45 inside _ct_bind_data() length binding len = 17
> 2003-12-05 09:54:45 inside _ct_get_server_type(7)
> 2003-12-05 09:54:45 inside _ct_get_client_type(type 108, size 17)
> 2003-12-05 09:54:45 inside _ct_bind_data() setting source length for 1 =
> 35
> destlen = 17
> 
> Thanx a lot
> 
> David
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds