[freetds] MSSQL "FOR XML AUTO" php

Bozhan Boiadzhiev edmon at oohaa.net
Mon Sep 13 14:16:12 EDT 2004


Hello i have such problem
Executing this script
php code:
<?php
session_start();
include "../msdb_conn.php";


    $stmt_page=mssql_init("GET_RESUME_AS_XML");
    mssql_bind($stmt_page,"RETVAL",$returnval,SQLVARCHAR);

    $execute_stmt=mssql_execute($stmt_page);



echo mssql_num_rows($execute_stmt);
 do {
       while ($row = mssql_fetch_array($execute_stmt)) {
           print_r($row);
       }
   } while (mssql_next_result($execute_stmt));
?>

i have this log
freetds.log:

Starting log file for FreeTDS 0.62.4
	on 2004-09-13 21:13:23 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "ISO-8859-1" character set
21:13:23.147321 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
21:13:23.147476 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
21:13:23.147602 Connecting to 192.168.0.2 port 1433, TDS 8.0.
21:13:23.148371 tds_put_string converting 8 bytes of "carredas"
21:13:23.148535 tds_put_string wrote 16 bytes
21:13:23.148594 tds_put_string converting 2 bytes of "sa"
21:13:23.148642 tds_put_string wrote 4 bytes
21:13:23.148725 tds_put_string converting 7 bytes of "PHP 4.0"
21:13:23.148787 tds_put_string wrote 14 bytes
21:13:23.148828 tds_put_string converting 11 bytes of "192.168.0.2"
21:13:23.148873 tds_put_string wrote 22 bytes
21:13:23.148915 tds_put_string converting 10 bytes of "DB-Library"
21:13:23.148961 tds_put_string wrote 20 bytes
21:13:23.149003 tds_put_string converting 10 bytes of "us_english"
21:13:23.149049 tds_put_string wrote 20 bytes
21:13:23.149092 tds_put_string wrote 0 bytes
21:13:23.149300 tds_process_login_tokens()
Received header @ 21:13:23.150005
0000 04 01 01 73 00 38 01 00-                        |...s.8..|


Received packet @ 21:13:23.150166
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 64 |..m.a.s. t.e.r..d|
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 07 57 00 49 00-4e 00 32 00 30 00 30 00 |....W.I. N.2.0.0.|
0080 33 00 00 00 00 e3 08 00-07 05 09 04 d0 00 34 00 |3....... ......4.|
0090 e3 17 00 02 0a 75 00 73-00 5f 00 65 00 6e 00 67 |.....u.s ._.e.n.g|
00a0 00 6c 00 69 00 73 00 68-00 00 ab 68 00 47 16 00 |.l.i.s.h ...h.G..|
00b0 00 01 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
00c0 00 64 00 20 00 6c 00 61-00 6e 00 67 00 75 00 61 |.d. .l.a .n.g.u.a|
00d0 00 67 00 65 00 20 00 73-00 65 00 74 00 74 00 69 |.g.e. .s .e.t.t.i|
00e0 00 6e 00 67 00 20 00 74-00 6f 00 20 00 75 00 73 |.n.g. .t .o. .u.s|
00f0 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|
0100 00 2e 00 07 57 00 49 00-4e 00 32 00 30 00 30 00 |....W.I. N.2.0.0.|
0110 33 00 00 00 00 ad 36 00-01 71 00 00 01 16 4d 00 |3.....6. .q....M.|
0120 69 00 63 00 72 00 6f 00-73 00 6f 00 66 00 74 00 |i.c.r.o. s.o.f.t.|
0130 20 00 53 00 51 00 4c 00-20 00 53 00 65 00 72 00 | .S.Q.L.  .S.e.r.|
0140 76 00 65 00 72 00 00 00-00 00 08 00 02 f8 e3 11 |v.e.r... ........|
0150 00 04 03 35 00 31 00 32-00 04 34 00 30 00 39 00 |...5.1.2 ..4.0.9.|
0160 36 00 fd 00 00 00 00 00-00 00 00                |6....... ...|


21:13:23.150658 looking for login token, got  e3(ENVCHANGE)
21:13:23.150697 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 12 from wire to give 6 to client.
21:13:23.150981 looking for login token, got  ab(INFO)
21:13:23.151034 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 74 from wire to give 37 to client.
tds_get_string: reading 14 from wire to give 7 to client.
21:13:23.151297 looking for login token, got  e3(ENVCHANGE)
21:13:23.151359 tds_process_default_tokens() marker is e3(ENVCHANGE)
21:13:23.153423 tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
21:13:23.153503 looking for login token, got  e3(ENVCHANGE)
21:13:23.153542 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
21:13:23.153616 looking for login token, got  ab(INFO)
21:13:23.153661 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 14 from wire to give 7 to client.
21:13:23.153811 looking for login token, got  ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
21:13:23.153902 looking for login token, got  e3(ENVCHANGE)
21:13:23.153947 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 6 from wire to give 3 to client.
tds_get_string: reading 8 from wire to give 4 to client.
21:13:23.154051 looking for login token, got  fd(DONE)
21:13:23.154097 tds_process_default_tokens() marker is fd(DONE)
21:13:23.154141 tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
21:13:23.154190 tds_process_end() state set to TDS_IDLE
21:13:23.154230 leaving tds_process_login_tokens() returning 1
21:13:23.154587 dbuse()
21:13:23.154736 dbcmd() bufsz = 0
21:13:23.154825 in dbsqlexec()
21:13:23.154921 in dbsqlsend()
21:13:23.155157 tds_put_string converting 9 bytes of "use SPJOB"
21:13:23.155225 tds_put_string wrote 18 bytes
Sending packet @ 21:13:23.155275
0000 01 01 00 1a 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|
0010 53 00 50 00 4a 00 4f 00-42 00                   |S.P.J.O. B.|


21:13:23.155469 in dbsqlok() 
Received header @ 21:13:23.155811
0000 04 01 00 9d 00 38 01 00-                        |.....8..|


Received packet @ 21:13:23.155908
0000 e3 19 00 01 05 53 00 50-00 4a 00 4f 00 42 00 06 |.....S.P .J.O.B..|
0010 6d 00 61 00 73 00 74 00-65 00 72 00 ab 62 00 45 |m.a.s.t. e.r..b.E|
0020 16 00 00 01 00 24 00 43-00 68 00 61 00 6e 00 67 |.....$.C .h.a.n.g|
0030 00 65 00 64 00 20 00 64-00 61 00 74 00 61 00 62 |.e.d. .d .a.t.a.b|
0040 00 61 00 73 00 65 00 20-00 63 00 6f 00 6e 00 74 |.a.s.e.  .c.o.n.t|
0050 00 65 00 78 00 74 00 20-00 74 00 6f 00 20 00 27 |.e.x.t.  .t.o. .'|
0060 00 53 00 50 00 4a 00 4f-00 42 00 27 00 2e 00 07 |.S.P.J.O .B.'....|
0070 57 00 49 00 4e 00 32 00-30 00 30 00 33 00 00 01 |W.I.N.2. 0.0.3...|
0080 00 e3 08 00 07 05 09 04-d0 00 34 00 fd 00 00 e2 |........ ..4.....|
0090 00 00 00 00 00         -                        |.....|


21:13:23.156178 dbsqlok() marker is e3
21:13:23.156261 processing result tokens.  marker is  e3(ENVCHANGE)
21:13:23.156317 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 10 from wire to give 5 to client.
tds_get_string: reading 12 from wire to give 6 to client.
21:13:23.156435 processing result tokens.  marker is  ab(INFO)
21:13:23.156484 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 72 from wire to give 36 to client.
tds_get_string: reading 14 from wire to give 7 to client.
21:13:23.156609 processing result tokens.  marker is  e3(ENVCHANGE)
21:13:23.156661 tds_process_default_tokens() marker is e3(ENVCHANGE)
21:13:23.156711 processing result tokens.  marker is  fd(DONE)
21:13:23.156751 tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
21:13:23.156801 tds_process_end() state set to TDS_IDLE
21:13:23.156848 dbsqlok() end status was success
21:13:23.156923 dbresults()
21:13:23.156993 dbresults_r()
21:13:23.157030 tds_process_result_tokens() state is COMPLETED
21:13:23.157066 leaving dbresults() returning 1
21:13:23.157165 tds_process_row_tokens() state is COMPLETED
21:13:23.157328 dbrpcinit() added rpcname "GET_RESUME_AS_XML"
21:13:23.157584 dbrpcsend()
Sending packet @ 21:13:23.157716
0000 03 01 00 2e 00 00 01 00-11 00 47 00 45 00 54 00 |........ ..G.E.T.|
0010 5f 00 52 00 45 00 53 00-55 00 4d 00 45 00 5f 00 |_.R.E.S. U.M.E._.|
0020 41 00 53 00 5f 00 58 00-4d 00 4c 00 00 00       |A.S._.X. M.L...|


21:13:23.157946 in dbsqlok() 
Received header @ 21:13:23.160816
0000 04 00 02 00 00 38 01 00-                        |.....8..|


Received packet @ 21:13:23.160920
0000 81 01 00 00 00 01 00 63-00 10 00 00 09 04 d0 00 |.......c ........|
0010 34 01 00 78 00 28 58 00-4d 00 4c 00 5f 00 46 00 |4..x.(X. M.L._.F.|
0020 35 00 32 00 45 00 32 00-42 00 36 00 31 00 2d 00 |5.2.E.2. B.6.1.-.|
0030 31 00 38 00 41 00 31 00-2d 00 31 00 31 00 64 00 |1.8.A.1. -.1.1.d.|
0040 31 00 2d 00 42 00 31 00-30 00 35 00 2d 00 30 00 |1.-.B.1. 0.5.-.0.|
0050 30 00 38 00 30 00 35 00-46 00 34 00 39 00 39 00 |0.8.0.5. F.4.9.9.|
0060 31 00 36 00 42 00 d1 10-00 00 00 00 00 00 00 00 |1.6.B... ........|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 4c 0a 00 00 3c 00 72 00-6f 00 6f 00 74 00 20 00 |L...<.r. o.o.t. .|
0090 69 00 64 00 3d 00 22 00-31 00 22 00 3e 00 3c 00 |i.d.=.". 1.".>.<.|
00a0 71 00 75 00 65 00 73 00-74 00 69 00 6f 00 6e 00 |q.u.e.s. t.i.o.n.|
00b0 5f 00 67 00 72 00 6f 00-75 00 70 00 20 00 51 00 |_.g.r.o. u.p. .Q.|
00c0 75 00 65 00 73 00 74 00-69 00 6f 00 6e 00 47 00 |u.e.s.t. i.o.n.G.|
00d0 72 00 6f 00 75 00 70 00-49 00 44 00 3d 00 22 00 |r.o.u.p. I.D.=.".|
00e0 31 00 22 00 20 00 47 00-72 00 6f 00 75 00 70 00 |1.". .G. r.o.u.p.|
00f0 4e 00 61 00 6d 00 65 00-3d 00 22 00 4f 00 66 00 |N.a.m.e. =.".O.f.|
0100 66 00 65 00 72 00 22 00-20 00 52 00 65 00 71 00 |f.e.r.".  .R.e.q.|
0110 75 00 69 00 72 00 65 00-64 00 3d 00 22 00 31 00 |u.i.r.e. d.=.".1.|
0120 22 00 2f 00 3e 00 3c 00-71 00 75 00 65 00 73 00 |"./.>.<. q.u.e.s.|
0130 74 00 69 00 6f 00 6e 00-5f 00 67 00 72 00 6f 00 |t.i.o.n. _.g.r.o.|
0140 75 00 70 00 20 00 51 00-75 00 65 00 73 00 74 00 |u.p. .Q. u.e.s.t.|
0150 69 00 6f 00 6e 00 47 00-72 00 6f 00 75 00 70 00 |i.o.n.G. r.o.u.p.|
0160 49 00 44 00 3d 00 22 00-32 00 22 00 20 00 47 00 |I.D.=.". 2.". .G.|
0170 72 00 6f 00 75 00 70 00-4e 00 61 00 6d 00 65 00 |r.o.u.p. N.a.m.e.|
0180 3d 00 22 00 48 00 65 00-61 00 64 00 6c 00 69 00 |=.".H.e. a.d.l.i.|
0190 6e 00 65 00 20 00 26 00-61 00 6d 00 70 00 3b 00 |n.e. .&. a.m.p.;.|
01a0 20 00 4f 00 62 00 6a 00-65 00 63 00 74 00 69 00 | .O.b.j. e.c.t.i.|
01b0 76 00 65 00 22 00 20 00-52 00 65 00 71 00 75 00 |v.e.". . R.e.q.u.|
01c0 69 00 72 00 65 00 64 00-3d 00 22 00 31 00 22 00 |i.r.e.d. =.".1.".|
01d0 2f 00 3e 00 3c 00 71 00-75 00 65 00 73 00 74 00 |/.>.<.q. u.e.s.t.|
01e0 69 00 6f 00 6e 00 5f 00-67 00 72 00 6f 00 75 00 |i.o.n._. g.r.o.u.|
01f0 70 00 20 00 51 00 75 00-                        |p. .Q.u.|


21:13:23.161744 dbsqlok() marker is 81
21:13:23.161790 dbsqlok() found result token
21:13:23.161872 dbresults()
21:13:23.161910 dbresults_r()
21:13:23.161938 processing result tokens.  marker is  81(TDS7_RESULT)
21:13:23.162117 adjust_character_column_size:
	Server charset: UCS-2LE
	Server column_size: 4096
	Client charset: ISO-8859-1
	Client column_size: 2048
tds_get_string: reading 2 from wire to give 1 to client.
tds_get_string: reading 80 from wire to give 40 to client.
21:13:23.162305 tds7_get_data_info:1451: 
	colname = XML_F52E2B61-18A1-11d1-B105-00805F49916B (40 bytes)
	type = 35 (text)
	server's type = 99 (UCS-2 text)
	column_varint_size = 4
	column_size = 2048 (4096 on server)
21:13:23.162467 dbresults_r() result_type = 4049 retcode = 1
21:13:23.162529 processing result tokens.  marker is  d1(ROW)
21:13:23.162574 dbresults_r() result_type = 4040 retcode = 1
21:13:23.162610 leaving dbresults() returning 1
21:13:23.162718 dbnextrow()
21:13:23.162768 processing row tokens.  marker is  d1(ROW)
21:13:23.162806 processing row.  column is 0 varint size = 4
21:13:23.162844 processing row.  column size is 2636 
21:13:23.162925 clearing column 0 NULL bit
Received header @ 21:13:23.163061
0000 04 00 02 00 00 38 02 00-                        |.....8..|


Received packet @ 21:13:23.163149
0000 65 00 73 00 74 00 69 00-6f 00 6e 00 47 00 72 00 |e.s.t.i. o.n.G.r.|
0010 6f 00 75 00 70 00 49 00-44 00 3d 00 22 00 33 00 |o.u.p.I. D.=.".3.|
0020 22 00 20 00 47 00 72 00-6f 00 75 00 70 00 4e 00 |". .G.r. o.u.p.N.|
0030 61 00 6d 00 65 00 3d 00-22 00 43 00 6f 00 6e 00 |a.m.e.=. ".C.o.n.|
0040 74 00 61 00 63 00 74 00-20 00 44 00 65 00 74 00 |t.a.c.t.  .D.e.t.|
0050 61 00 69 00 6c 00 73 00-22 00 20 00 52 00 65 00 |a.i.l.s. ". .R.e.|
0060 71 00 75 00 69 00 72 00-65 00 64 00 3d 00 22 00 |q.u.i.r. e.d.=.".|
0070 31 00 22 00 2f 00 3e 00-3c 00 71 00 75 00 65 00 |1."./.>. <.q.u.e.|
0080 73 00 74 00 69 00 6f 00-6e 00 5f 00 67 00 72 00 |s.t.i.o. n._.g.r.|
0090 6f 00 75 00 70 00 20 00-51 00 75 00 65 00 73 00 |o.u.p. . Q.u.e.s.|
00a0 74 00 69 00 6f 00 6e 00-47 00 72 00 6f 00 75 00 |t.i.o.n. G.r.o.u.|
00b0 70 00 49 00 44 00 3d 00-22 00 34 00 22 00 20 00 |p.I.D.=. ".4.". .|
00c0 47 00 72 00 6f 00 75 00-70 00 4e 00 61 00 6d 00 |G.r.o.u. p.N.a.m.|
00d0 65 00 3d 00 22 00 54 00-61 00 72 00 67 00 65 00 |e.=.".T. a.r.g.e.|
00e0 74 00 20 00 4a 00 6f 00-62 00 22 00 20 00 52 00 |t. .J.o. b.". .R.|
00f0 65 00 71 00 75 00 69 00-72 00 65 00 64 00 3d 00 |e.q.u.i. r.e.d.=.|
0100 22 00 31 00 22 00 2f 00-3e 00 3c 00 71 00 75 00 |".1."./. >.<.q.u.|
0110 65 00 73 00 74 00 69 00-6f 00 6e 00 5f 00 67 00 |e.s.t.i. o.n._.g.|
0120 72 00 6f 00 75 00 70 00-20 00 51 00 75 00 65 00 |r.o.u.p.  .Q.u.e.|
0130 73 00 74 00 69 00 6f 00-6e 00 47 00 72 00 6f 00 |s.t.i.o. n.G.r.o.|
0140 75 00 70 00 49 00 44 00-3d 00 22 00 35 00 22 00 |u.p.I.D. =.".5.".|
0150 20 00 47 00 72 00 6f 00-75 00 70 00 4e 00 61 00 | .G.r.o. u.p.N.a.|
0160 6d 00 65 00 3d 00 22 00-54 00 61 00 72 00 67 00 |m.e.=.". T.a.r.g.|
0170 65 00 74 00 20 00 43 00-6f 00 6d 00 70 00 61 00 |e.t. .C. o.m.p.a.|
0180 6e 00 79 00 22 00 20 00-52 00 65 00 71 00 75 00 |n.y.". . R.e.q.u.|
0190 69 00 72 00 65 00 64 00-3d 00 22 00 30 00 22 00 |i.r.e.d. =.".0.".|
01a0 2f 00 3e 00 3c 00 71 00-75 00 65 00 73 00 74 00 |/.>.<.q. u.e.s.t.|
01b0 69 00 6f 00 6e 00 5f 00-67 00 72 00 6f 00 75 00 |i.o.n._. g.r.o.u.|
01c0 70 00 20 00 51 00 75 00-65 00 73 00 74 00 69 00 |p. .Q.u. e.s.t.i.|
01d0 6f 00 6e 00 47 00 72 00-6f 00 75 00 70 00 49 00 |o.n.G.r. o.u.p.I.|
01e0 44 00 3d 00 22 00 36 00-22 00 20 00 47 00 72 00 |D.=.".6. ". .G.r.|
01f0 6f 00 75 00 70 00 4e 00-                        |o.u.p.N.|


Received header @ 21:13:23.163825
0000 04 00 02 00 00 38 03 00-                        |.....8..|


Received packet @ 21:13:23.163902
0000 61 00 6d 00 65 00 3d 00-22 00 54 00 61 00 72 00 |a.m.e.=. ".T.a.r.|
0010 67 00 65 00 74 00 20 00-4c 00 6f 00 63 00 61 00 |g.e.t. . L.o.c.a.|
0020 74 00 69 00 6f 00 6e 00-22 00 20 00 52 00 65 00 |t.i.o.n. ". .R.e.|
0030 71 00 75 00 69 00 72 00-65 00 64 00 3d 00 22 00 |q.u.i.r. e.d.=.".|
0040 31 00 22 00 2f 00 3e 00-3c 00 71 00 75 00 65 00 |1."./.>. <.q.u.e.|
0050 73 00 74 00 69 00 6f 00-6e 00 5f 00 67 00 72 00 |s.t.i.o. n._.g.r.|
0060 6f 00 75 00 70 00 20 00-51 00 75 00 65 00 73 00 |o.u.p. . Q.u.e.s.|
0070 74 00 69 00 6f 00 6e 00-47 00 72 00 6f 00 75 00 |t.i.o.n. G.r.o.u.|
0080 70 00 49 00 44 00 3d 00-22 00 37 00 22 00 20 00 |p.I.D.=. ".7.". .|
0090 47 00 72 00 6f 00 75 00-70 00 4e 00 61 00 6d 00 |G.r.o.u. p.N.a.m.|
00a0 65 00 3d 00 22 00 57 00-6f 00 72 00 6b 00 20 00 |e.=.".W. o.r.k. .|
00b0 53 00 74 00 61 00 74 00-75 00 73 00 22 00 20 00 |S.t.a.t. u.s.". .|
00c0 52 00 65 00 71 00 75 00-69 00 72 00 65 00 64 00 |R.e.q.u. i.r.e.d.|
00d0 3d 00 22 00 31 00 22 00-2f 00 3e 00 3c 00 71 00 |=.".1.". /.>.<.q.|
00e0 75 00 65 00 73 00 74 00-69 00 6f 00 6e 00 5f 00 |u.e.s.t. i.o.n._.|
00f0 67 00 72 00 6f 00 75 00-70 00 20 00 51 00 75 00 |g.r.o.u. p. .Q.u.|
0100 65 00 73 00 74 00 69 00-6f 00 6e 00 47 00 72 00 |e.s.t.i. o.n.G.r.|
0110 6f 00 75 00 70 00 49 00-44 00 3d 00 22 00 38 00 |o.u.p.I. D.=.".8.|
0120 22 00 20 00 47 00 72 00-6f 00 75 00 70 00 4e 00 |". .G.r. o.u.p.N.|
0130 61 00 6d 00 65 00 3d 00-22 00 57 00 6f 00 72 00 |a.m.e.=. ".W.o.r.|
0140 6b 00 20 00 45 00 78 00-70 00 65 00 72 00 69 00 |k. .E.x. p.e.r.i.|
0150 65 00 6e 00 63 00 65 00-22 00 20 00 52 00 65 00 |e.n.c.e. ". .R.e.|
0160 71 00 75 00 69 00 72 00-65 00 64 00 3d 00 22 00 |q.u.i.r. e.d.=.".|
0170 30 00 22 00 2f 00 3e 00-3c 00 71 00 75 00 65 00 |0."./.>. <.q.u.e.|
0180 73 00 74 00 69 00 6f 00-6e 00 5f 00 67 00 72 00 |s.t.i.o. n._.g.r.|
0190 6f 00 75 00 70 00 20 00-51 00 75 00 65 00 73 00 |o.u.p. . Q.u.e.s.|
01a0 74 00 69 00 6f 00 6e 00-47 00 72 00 6f 00 75 00 |t.i.o.n. G.r.o.u.|
01b0 70 00 49 00 44 00 3d 00-22 00 39 00 22 00 20 00 |p.I.D.=. ".9.". .|
01c0 47 00 72 00 6f 00 75 00-70 00 4e 00 61 00 6d 00 |G.r.o.u. p.N.a.m.|
01d0 65 00 3d 00 22 00 52 00-65 00 66 00 65 00 72 00 |e.=.".R. e.f.e.r.|
01e0 65 00 6e 00 63 00 65 00-73 00 22 00 20 00 52 00 |e.n.c.e. s.". .R.|
01f0 65 00 71 00 75 00 69 00-                        |e.q.u.i.|


Received header @ 21:13:23.164554
0000 04 00 02 00 00 38 04 00-                        |.....8..|


Received packet @ 21:13:23.164633
0000 72 00 65 00 64 00 3d 00-22 00 30 00 22 00 2f 00 |r.e.d.=. ".0."./.|
0010 3e 00 3c 00 71 00 75 00-65 00 73 00 74 00 69 00 |>.<.q.u. e.s.t.i.|
0020 6f 00 6e 00 5f 00 67 00-72 00 6f 00 75 00 70 00 |o.n._.g. r.o.u.p.|
0030 20 00 51 00 75 00 65 00-73 00 74 00 69 00 6f 00 | .Q.u.e. s.t.i.o.|
0040 6e 00 47 00 72 00 6f 00-75 00 70 00 49 00 44 00 |n.G.r.o. u.p.I.D.|
0050 3d 00 22 00 31 00 30 00-22 00 20 00 47 00 72 00 |=.".1.0. ". .G.r.|
0060 6f 00 75 00 70 00 4e 00-61 00 6d 00 65 00 3d 00 |o.u.p.N. a.m.e.=.|
0070 22 00 45 00 64 00 75 00-63 00 61 00 74 00 69 00 |".E.d.u. c.a.t.i.|
0080 6f 00 6e 00 22 00 20 00-52 00 65 00 71 00 75 00 |o.n.". . R.e.q.u.|
0090 69 00 72 00 65 00 64 00-3d 00 22 00 30 00 22 00 |i.r.e.d. =.".0.".|
00a0 2f 00 3e 00 3c 00 71 00-75 00 65 00 73 00 74 00 |/.>.<.q. u.e.s.t.|
00b0 69 00 6f 00 6e 00 5f 00-67 00 72 00 6f 00 75 00 |i.o.n._. g.r.o.u.|
00c0 70 00 20 00 51 00 75 00-65 00 73 00 74 00 69 00 |p. .Q.u. e.s.t.i.|
00d0 6f 00 6e 00 47 00 72 00-6f 00 75 00 70 00 49 00 |o.n.G.r. o.u.p.I.|
00e0 44 00 3d 00 22 00 31 00-31 00 22 00 20 00 47 00 |D.=.".1. 1.". .G.|
00f0 72 00 6f 00 75 00 70 00-4e 00 61 00 6d 00 65 00 |r.o.u.p. N.a.m.e.|
0100 3d 00 22 00 41 00 66 00-66 00 69 00 6c 00 69 00 |=.".A.f. f.i.l.i.|
0110 61 00 74 00 69 00 6f 00-6e 00 73 00 22 00 20 00 |a.t.i.o. n.s.". .|
0120 52 00 65 00 71 00 75 00-69 00 72 00 65 00 64 00 |R.e.q.u. i.r.e.d.|
0130 3d 00 22 00 30 00 22 00-2f 00 3e 00 3c 00 71 00 |=.".0.". /.>.<.q.|
0140 75 00 65 00 73 00 74 00-69 00 6f 00 6e 00 5f 00 |u.e.s.t. i.o.n._.|
0150 67 00 72 00 6f 00 75 00-70 00 20 00 51 00 75 00 |g.r.o.u. p. .Q.u.|
0160 65 00 73 00 74 00 69 00-6f 00 6e 00 47 00 72 00 |e.s.t.i. o.n.G.r.|
0170 6f 00 75 00 70 00 49 00-44 00 3d 00 22 00 31 00 |o.u.p.I. D.=.".1.|
0180 32 00 22 00 20 00 47 00-72 00 6f 00 75 00 70 00 |2.". .G. r.o.u.p.|
0190 4e 00 61 00 6d 00 65 00-3d 00 22 00 4c 00 61 00 |N.a.m.e. =.".L.a.|
01a0 6e 00 67 00 75 00 61 00-67 00 65 00 73 00 22 00 |n.g.u.a. g.e.s.".|
01b0 20 00 52 00 65 00 71 00-75 00 69 00 72 00 65 00 | .R.e.q. u.i.r.e.|
01c0 64 00 3d 00 22 00 30 00-22 00 2f 00 3e 00 3c 00 |d.=.".0. "./.>.<.|
01d0 71 00 75 00 65 00 73 00-74 00 69 00 6f 00 6e 00 |q.u.e.s. t.i.o.n.|
01e0 5f 00 67 00 72 00 6f 00-75 00 70 00 20 00 51 00 |_.g.r.o. u.p. .Q.|
01f0 75 00 65 00 73 00 74 00-                        |u.e.s.t.|


Received header @ 21:13:23.165302
0000 04 00 02 00 00 38 05 00-                        |.....8..|


Received packet @ 21:13:23.165381
0000 69 00 6f 00 6e 00 47 00-72 00 6f 00 75 00 70 00 |i.o.n.G. r.o.u.p.|
0010 49 00 44 00 3d 00 22 00-31 00 33 00 22 00 20 00 |I.D.=.". 1.3.". .|
0020 47 00 72 00 6f 00 75 00-70 00 4e 00 61 00 6d 00 |G.r.o.u. p.N.a.m.|
0030 65 00 3d 00 22 00 53 00-6b 00 69 00 6c 00 6c 00 |e.=.".S. k.i.l.l.|
0040 73 00 22 00 20 00 52 00-65 00 71 00 75 00 69 00 |s.". .R. e.q.u.i.|
0050 72 00 65 00 64 00 3d 00-22 00 30 00 22 00 2f 00 |r.e.d.=. ".0."./.|
0060 3e 00 3c 00 71 00 75 00-65 00 73 00 74 00 69 00 |>.<.q.u. e.s.t.i.|
0070 6f 00 6e 00 5f 00 67 00-72 00 6f 00 75 00 70 00 |o.n._.g. r.o.u.p.|
0080 20 00 51 00 75 00 65 00-73 00 74 00 69 00 6f 00 | .Q.u.e. s.t.i.o.|
0090 6e 00 47 00 72 00 6f 00-75 00 70 00 49 00 44 00 |n.G.r.o. u.p.I.D.|
00a0 3d 00 22 00 31 00 34 00-22 00 20 00 47 00 72 00 |=.".1.4. ". .G.r.|
00b0 6f 00 75 00 70 00 4e 00-61 00 6d 00 65 00 3d 00 |o.u.p.N. a.m.e.=.|
00c0 22 00 41 00 64 00 64 00-69 00 74 00 69 00 6f 00 |".A.d.d. i.t.i.o.|
00d0 6e 00 61 00 6c 00 20 00-49 00 6e 00 66 00 6f 00 |n.a.l. . I.n.f.o.|
00e0 72 00 6d 00 61 00 74 00-69 00 6f 00 6e 00 22 00 |r.m.a.t. i.o.n.".|
00f0 20 00 52 00 65 00 71 00-75 00 69 00 72 00 65 00 | .R.e.q. u.i.r.e.|
0100 64 00 3d 00 22 00 30 00-22 00 2f 00 3e 00 3c 00 |d.=.".0. "./.>.<.|
0110 71 00 75 00 65 00 73 00-74 00 69 00 6f 00 6e 00 |q.u.e.s. t.i.o.n.|
0120 5f 00 67 00 72 00 6f 00-75 00 70 00 20 00 51 00 |_.g.r.o. u.p. .Q.|
0130 75 00 65 00 73 00 74 00-69 00 6f 00 6e 00 47 00 |u.e.s.t. i.o.n.G.|
0140 72 00 6f 00 75 00 70 00-49 00 44 00 3d 00 22 00 |r.o.u.p. I.D.=.".|
0150 31 00 35 00 22 00 20 00-47 00 72 00 6f 00 75 00 |1.5.". . G.r.o.u.|
0160 70 00 4e 00 61 00 6d 00-65 00 3d 00 22 00 4a 00 |p.N.a.m. e.=.".J.|
0170 6f 00 62 00 44 00 65 00-73 00 63 00 72 00 69 00 |o.b.D.e. s.c.r.i.|
0180 70 00 74 00 69 00 6f 00-6e 00 22 00 20 00 52 00 |p.t.i.o. n.". .R.|
0190 65 00 71 00 75 00 69 00-72 00 65 00 64 00 3d 00 |e.q.u.i. r.e.d.=.|
01a0 22 00 31 00 22 00 2f 00-3e 00 3c 00 71 00 75 00 |".1."./. >.<.q.u.|
01b0 65 00 73 00 74 00 69 00-6f 00 6e 00 5f 00 67 00 |e.s.t.i. o.n._.g.|
01c0 72 00 6f 00 75 00 70 00-20 00 51 00 75 00 65 00 |r.o.u.p.  .Q.u.e.|
01d0 73 00 74 00 69 00 6f 00-6e 00 47 00 72 00 6f 00 |s.t.i.o. n.G.r.o.|
01e0 75 00 70 00 49 00 44 00-3d 00 22 00 31 00 36 00 |u.p.I.D. =.".1.6.|
01f0 22 00 20 00 47 00 72 00-                        |". .G.r.|


Received header @ 21:13:23.166058
0000 04 01 01 17 00 38 06 00-                        |.....8..|


Received packet @ 21:13:23.166141
0000 6f 00 75 00 70 00 4e 00-61 00 6d 00 65 00 3d 00 |o.u.p.N. a.m.e.=.|
0010 22 00 53 00 65 00 65 00-6b 00 65 00 72 00 20 00 |".S.e.e. k.e.r. .|
0020 52 00 65 00 71 00 75 00-69 00 72 00 65 00 6d 00 |R.e.q.u. i.r.e.m.|
0030 65 00 6e 00 74 00 73 00-22 00 20 00 52 00 65 00 |e.n.t.s. ". .R.e.|
0040 71 00 75 00 69 00 72 00-65 00 64 00 3d 00 22 00 |q.u.i.r. e.d.=.".|
0050 31 00 22 00 2f 00 3e 00-3c 00 71 00 75 00 65 00 |1."./.>. <.q.u.e.|
0060 73 00 74 00 69 00 6f 00-6e 00 5f 00 67 00 72 00 |s.t.i.o. n._.g.r.|
0070 6f 00 75 00 70 00 20 00-51 00 75 00 65 00 73 00 |o.u.p. . Q.u.e.s.|
0080 74 00 69 00 6f 00 6e 00-47 00 72 00 6f 00 75 00 |t.i.o.n. G.r.o.u.|
0090 70 00 49 00 44 00 3d 00-22 00 31 00 37 00 22 00 |p.I.D.=. ".1.7.".|
00a0 20 00 47 00 72 00 6f 00-75 00 70 00 4e 00 61 00 | .G.r.o. u.p.N.a.|
00b0 6d 00 65 00 3d 00 22 00-41 00 64 00 76 00 65 00 |m.e.=.". A.d.v.e.|
00c0 72 00 74 00 69 00 73 00-65 00 22 00 20 00 52 00 |r.t.i.s. e.". .R.|
00d0 65 00 71 00 75 00 69 00-72 00 65 00 64 00 3d 00 |e.q.u.i. r.e.d.=.|
00e0 22 00 31 00 22 00 2f 00-3e 00 3c 00 2f 00 72 00 |".1."./. >.<./.r.|
00f0 6f 00 6f 00 74 00 3e 00-ff 11 00 c1 00 11 00 00 |o.o.t.>. ........|
0100 00 79 00 00 00 00 fe 00-00 e0 00 11 00 00 00    |.y...... .......|


21:13:23.166504 leaving dbnextrow() returning -1
21:13:23.166783 dbdatlen() type = 35
21:13:23.166878 leaving dbdatlen() returning 1318
21:13:23.166972 dbdatlen() type = 35
21:13:23.167020 leaving dbdatlen() returning 1318
21:13:23.167153 dbnextrow()
21:13:23.167206 processing row tokens.  marker is  ff(DONEINPROC)
21:13:23.167245 tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
21:13:23.167296                  rows_affected = 17
21:13:23.167328 leaving dbnextrow() returning -2
21:13:23.167670 dbresults()
21:13:23.167736 dbresults_r()
21:13:23.167772 processing result tokens.  marker is  79(RETURNSTATUS)
21:13:23.167812 dbresults_r() result_type = 4043 retcode = 1
21:13:23.167848 processing result tokens.  marker is  fe(DONEPROC)
21:13:23.167892 tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
21:13:23.167943 tds_process_end() state set to TDS_IDLE
21:13:23.167982 dbresults_r() result_type = 4053 retcode = 1
21:13:23.168019 tds_process_result_tokens() state is COMPLETED
21:13:23.168060 leaving dbresults() returning 2
21:13:23.168960 in dbfreebuf()

but the only result is:
1Array ( [0] => [XML_F52E2B61-18A1-11d1-B105-00805F49916B] => )

I can't find a way to get contents of this row.
Can some one to tell me or to suggest me what i can do this thing.
And where is the problem in PHP or in FreeTDS ???

Thanks
Bozhan



More information about the FreeTDS mailing list