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] => )
a little simple example:
PROCEDURE:
CREATE PROCEDURE PRINT_XML_DATA AS SELECT 'data' as col1 FOR XML RAW GO
executing this procdure form SQL Query Analyzer gives: XML_xxxxxxxx-xxxx-xxxx--xxxx(whaever) <row col1="data"/>
<?php
include "../msdb_conn.php";
/*
$stmt_page=mssql_init(" PRINT_XML_DATA");
$execute_stmt=mssql_execute($stmt_page);
*/
// I can execute this way too but whit same result !!!!
$query=mssql_query("exec PRINT_XML_DATA"); echo mssql_num_rows($query);
/* while ($row = mssql_fetch_array($query)) { print_r($row); } */ // I can execute this way too but whit same result !!!!
do {
while ($row = mssql_fetch_array($query)) {
print_r($row);
}} while (mssql_next_result($query)); ?>
and result is: Array ( [0] => [XML_F52E2B61-18A1-11d1-B105-00805F49916B] => )
this is freetds.log : (procedure actualy name : GET_RESUME_AS_XML1)
Starting log file for FreeTDS 0.62.4 on 2004-09-14 14:43:40 with debug level 99. iconv to convert client-side data to the "ISO-8859-1" character set 14:43:40.395475 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE" 14:43:40.395572 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE" 14:43:40.395630 Connecting to 192.168.0.2 port 1433, TDS 7.0. 14:43:40.396046 tds_put_string converting 8 bytes of "carredas" 14:43:40.396135 tds_put_string wrote 16 bytes 14:43:40.396169 tds_put_string converting 2 bytes of "sa" 14:43:40.396205 tds_put_string wrote 4 bytes 14:43:40.396238 tds_put_string converting 7 bytes of "PHP 4.0" 14:43:40.396273 tds_put_string wrote 14 bytes 14:43:40.396303 tds_put_string converting 11 bytes of "192.168.0.2" 14:43:40.396338 tds_put_string wrote 22 bytes 14:43:40.396368 tds_put_string converting 10 bytes of "DB-Library" 14:43:40.396403 tds_put_string wrote 20 bytes 14:43:40.396432 tds_put_string converting 10 bytes of "us_english" 14:43:40.396467 tds_put_string wrote 20 bytes 14:43:40.396496 tds_put_string wrote 0 bytes 14:43:40.396590 tds_process_login_tokens() Received header @ 14:43:40.397330 0000 04 01 01 9a 00 3f 01 00- |.....?..|
Received packet @ 14:43:40.397428 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 17 00-02 0a 75 00 73 00 5f 00 |3....... ..u.s._.| 0090 65 00 6e 00 67 00 6c 00-69 00 73 00 68 00 00 ab |e.n.g.l. i.s.h...| 00a0 68 00 47 16 00 00 01 00-27 00 43 00 68 00 61 00 |h.G..... '.C.h.a.| 00b0 6e 00 67 00 65 00 64 00-20 00 6c 00 61 00 6e 00 |n.g.e.d. .l.a.n.| 00c0 67 00 75 00 61 00 67 00-65 00 20 00 73 00 65 00 |g.u.a.g. e. .s.e.| 00d0 74 00 74 00 69 00 6e 00-67 00 20 00 74 00 6f 00 |t.t.i.n. g. .t.o.| 00e0 20 00 75 00 73 00 5f 00-65 00 6e 00 67 00 6c 00 | .u.s._. e.n.g.l.| 00f0 69 00 73 00 68 00 2e 00-07 57 00 49 00 4e 00 32 |i.s.h... .W.I.N.2| 0100 00 30 00 30 00 33 00 00-00 00 e3 0f 00 03 05 69 |.0.0.3.. .......i| 0110 00 73 00 6f 00 5f 00 31-00 01 00 00 e3 0b 00 05 |.s.o._.1 ........| 0120 04 31 00 30 00 33 00 33-00 00 e3 0f 00 06 06 31 |.1.0.3.3 .......1| 0130 00 39 00 36 00 36 00 30-00 39 00 00 ad 36 00 01 |.9.6.6.0 .9...6..| 0140 07 00 00 00 16 4d 00 69-00 63 00 72 00 6f 00 73 |.....M.i .c.r.o.s| 0150 00 6f 00 66 00 74 00 20-00 53 00 51 00 4c 00 20 |.o.f.t. .S.Q.L. | 0160 00 53 00 65 00 72 00 76-00 65 00 72 00 00 00 00 |.S.e.r.v .e.r....| 0170 00 08 00 02 f8 e3 11 00-04 03 35 00 31 00 32 00 |........ ..5.1.2.| 0180 04 34 00 30 00 39 00 36-00 fd 00 00 00 00 00 00 |.4.0.9.6 ........| 0190 00 00 - |..|
14:43:40.398056 looking for login token, got e3(ENVCHANGE) 14:43:40.398090 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. 14:43:40.398199 looking for login token, got ab(INFO) 14:43:40.398234 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. 14:43:40.398351 looking for login token, got e3(ENVCHANGE) 14:43:40.398389 tds_process_default_tokens() marker is e3(ENVCHANGE) tds_get_string: reading 20 from wire to give 10 to client. 14:43:40.398456 looking for login token, got ab(INFO) 14:43:40.398489 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. 14:43:40.398595 looking for login token, got e3(ENVCHANGE) 14:43:40.398631 tds_process_default_tokens() marker is e3(ENVCHANGE) tds_get_string: reading 10 from wire to give 5 to client. tds_get_string: reading 2 from wire to give 1 to client. 14:43:40.398794 looking for login token, got e3(ENVCHANGE) 14:43:40.398834 tds_process_default_tokens() marker is e3(ENVCHANGE) tds_get_string: reading 8 from wire to give 4 to client. 14:43:40.398900 looking for login token, got e3(ENVCHANGE) 14:43:40.398933 tds_process_default_tokens() marker is e3(ENVCHANGE) tds_get_string: reading 12 from wire to give 6 to client. 14:43:40.398999 looking for login token, got ad(LOGINACK) tds_get_string: reading 44 from wire to give 22 to client. 14:43:40.399066 looking for login token, got e3(ENVCHANGE) 14:43:40.399097 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. 14:43:40.399191 looking for login token, got fd(DONE) 14:43:40.399222 tds_process_default_tokens() marker is fd(DONE) 14:43:40.399257 tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 14:43:40.399305 tds_process_end() state set to TDS_IDLE 14:43:40.399336 leaving tds_process_login_tokens() returning 1 14:43:40.399381 tds_put_string converting 19 bytes of "set textsize 65535 " 14:43:40.399418 tds_put_string wrote 38 bytes Sending packet @ 14:43:40.399454 0000 01 01 00 2e 00 00 01 00-73 00 65 00 74 00 20 00 |........ s.e.t. .| 0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.| 0020 20 00 36 00 35 00 35 00-33 00 35 00 20 00 | .6.5.5. 3.5. .|
Received header @ 14:43:40.399903 0000 04 01 00 11 00 3f 01 00- |.....?..|
Received packet @ 14:43:40.399995 0000 fd 00 00 be 00 00 00 00-00 |........ .|
14:43:40.400040 processing result tokens. marker is fd(DONE) 14:43:40.400078 tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 14:43:40.400128 tds_process_end() state set to TDS_IDLE 14:43:40.400162 tds_process_result_tokens() state is COMPLETED 14:43:40.400256 dbuse() 14:43:40.400304 dbcmd() bufsz = 0 14:43:40.400333 in dbsqlexec() 14:43:40.400355 in dbsqlsend() 14:43:40.400384 tds_put_string converting 9 bytes of "use SPJOB" 14:43:40.400424 tds_put_string wrote 18 bytes Sending packet @ 14:43:40.400458 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.|
14:43:40.400583 in dbsqlok() Received header @ 14:43:40.400962
0000 04 01 00 92 00 3f 01 00- |.....?..|
Received packet @ 14:43:40.401045 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 fd 00 00 e2 00 00 00-00 00 |........ ..|
14:43:40.401265 dbsqlok() marker is e3 14:43:40.401296 processing result tokens. marker is e3(ENVCHANGE) 14:43:40.401333 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. 14:43:40.401441 processing result tokens. marker is ab(INFO) 14:43:40.401478 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. 14:43:40.401590 processing result tokens. marker is fd(DONE) 14:43:40.401632 tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 14:43:40.401680 tds_process_end() state set to TDS_IDLE 14:43:40.401737 dbsqlok() end status was success 14:43:40.401772 dbresults() 14:43:40.401793 dbresults_r() 14:43:40.401812 tds_process_result_tokens() state is COMPLETED 14:43:40.401842 leaving dbresults() returning 1 14:43:40.401871 tds_process_row_tokens() state is COMPLETED 14:43:40.401950 dbcmd() bufsz = 10 14:43:40.401989 in dbfreebuf() 14:43:40.402020 in dbsqlexec() 14:43:40.402045 in dbsqlsend() 14:43:40.402074 tds_put_string converting 23 bytes of "exec GET_RESUME_AS_XML1" 14:43:40.402118 tds_put_string wrote 46 bytes Sending packet @ 14:43:40.402154 0000 01 01 00 36 00 00 01 00-65 00 78 00 65 00 63 00 |...6.... e.x.e.c.| 0010 20 00 47 00 45 00 54 00-5f 00 52 00 45 00 53 00 | .G.E.T. _.R.E.S.| 0020 55 00 4d 00 45 00 5f 00-41 00 53 00 5f 00 58 00 |U.M.E._. A.S._.X.| 0030 4d 00 4c 00 31 00 - |M.L.1.|
14:43:40.402332 in dbsqlok() Received header @ 14:43:40.402756
0000 04 01 00 c2 00 3f 01 00- |.....?..|
Received packet @ 14:43:40.402848 0000 81 01 00 00 00 01 00 63-fe ff 00 00 01 00 78 00 |.......c ......x.| 0010 28 58 00 4d 00 4c 00 5f-00 46 00 35 00 32 00 45 |(X.M.L._ .F.5.2.E| 0020 00 32 00 42 00 36 00 31-00 2d 00 31 00 38 00 41 |.2.B.6.1 .-.1.8.A| 0030 00 31 00 2d 00 31 00 31-00 64 00 31 00 2d 00 42 |.1.-.1.1 .d.1.-.B| 0040 00 31 00 30 00 35 00 2d-00 30 00 30 00 38 00 30 |.1.0.5.- .0.0.8.0| 0050 00 35 00 46 00 34 00 39-00 39 00 31 00 36 00 42 |.5.F.4.9 .9.1.6.B| 0060 00 d1 10 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........| 0070 00 00 00 00 00 00 00 00-00 00 00 24 00 00 00 3c |........ ...$...<| 0080 00 72 00 6f 00 77 00 20-00 63 00 6f 00 6c 00 31 |.r.o.w. .c.o.l.1| 0090 00 3d 00 22 00 64 00 61-00 74 00 61 00 22 00 2f |.=.".d.a .t.a."./| 00a0 00 3e 00 ff 11 00 c1 00-01 00 00 00 79 00 00 00 |.>...... ....y...| 00b0 00 fe 00 00 e0 00 01 00-00 00 |........ ..|
14:43:40.403148 dbsqlok() marker is 81
14:43:40.403178 dbsqlok() found result token
14:43:40.403210 dbresults()
14:43:40.403232 dbresults_r()
14:43:40.403254 processing result tokens. marker is 81(TDS7_RESULT)
14:43:40.403314 adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 65534
Client charset: ISO-8859-1
Client column_size: 32767
tds_get_string: reading 2 from wire to give 1 to client.
tds_get_string: reading 80 from wire to give 40 to client.
14:43:40.403442 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 = 32767 (65534 on server)
14:43:40.403516 dbresults_r() result_type = 4049 retcode = 1
14:43:40.403555 processing result tokens. marker is d1(ROW)
14:43:40.403593 dbresults_r() result_type = 4040 retcode = 1
14:43:40.403625 leaving dbresults() returning 1
14:43:40.403655 dbnextrow()
14:43:40.403681 processing row tokens. marker is d1(ROW)
14:43:40.403715 processing row. column is 0 varint size = 4
14:43:40.403752 processing row. column size is 36 14:43:40.403784 clearing column 0 NULL bit
14:43:40.403823 leaving dbnextrow() returning -1
14:43:40.403873 dbdatlen() type = 35
14:43:40.403902 leaving dbdatlen() returning 18
14:43:40.403930 dbdatlen() type = 35
14:43:40.403956 leaving dbdatlen() returning 18
14:43:40.403991 dbnextrow()
14:43:40.404014 processing row tokens. marker is ff(DONEINPROC)
14:43:40.404049 tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
14:43:40.404099 rows_affected = 1
14:43:40.404131 leaving dbnextrow() returning -2
14:43:40.404339 dbresults()
14:43:40.404396 dbresults_r()
14:43:40.404425 processing result tokens. marker is 79(RETURNSTATUS)
14:43:40.404463 dbresults_r() result_type = 4043 retcode = 1
14:43:40.404497 processing result tokens. marker is fe(DONEPROC)
14:43:40.404534 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
14:43:40.404585 tds_process_end() state set to TDS_IDLE
14:43:40.404618 dbresults_r() result_type = 4053 retcode = 1
14:43:40.404652 tds_process_result_tokens() state is COMPLETED
14:43:40.404713 leaving dbresults() returning 2
14:43:40.405075 in dbfreebuf()
I can't find a way to get contents of this row. Can some one to tell me or to suggest me how i can do this thing. And where is the problem in PHP or in FreeTDS or in me:) ???
Thanks Bozhan
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
