freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] problem of list more than 1 result via freedts & php4 from sqlserver2k

From: "Rachel" <rachel AT bidchance.com>
To: <freetds AT lists.ibiblio.org>
Subject: [freetds] problem of list more than 1 result via freedts & php4 from sqlserver2k
Date: Tue, 22 Apr 2008 18:11:50 +0800

Dear All,

When I use this sql (sql1) : "SELECT top 1 id,userid,company FROM
users", my user.php can return result quickly,

but when I user this sql (sql2) :"SELECT top 20 id,userid,company FROM
users", I can't get result return,

then I check the freetds.log using " tail -f /tmp/freetds.log", I find when
executing sql2, It repeat logs below and long times no stop :

dblib.c:2141:dbconvert((nil), SYBDATETIME, 0xa0503e8, 8, SYBCHAR, 0xb0e8f2c,
28)

dblib.c:2283:dbconvert() calling tds_convert

dblib.c:2286:dbconvert() called tds_convert returned 26

dblib.c:2389:dbconvert() outputting 26 bytes character data destlen = 28

dblib.c:1948:dbnextrow(0xa057670)

dblib.c:1961:dbnextrow() dbresults_state = 2 (_DB_RES_RESULTSET_ROWS)

dblib.c:2030:leaving dbnextrow() returning BUF_FULL

dblib.c:6884:dblastrow(0xa057670)

dblib.c:2698:dbclrbuf(0xa057670, 0)

dblib.c:3032:dbdatlen(0xa057670, 1)

dblib.c:3040:dbdatlen() type = 56, len= 4

dblib.c:2741:dbcoltype(0xa057670, 1)

dblib.c:3060:dbdata(0xa057670, 1)

dblib.c:3032:dbdatlen(0xa057670, 2)

dblib.c:3040:dbdatlen() type = 39, len= 5

dblib.c:3060:dbdata(0xa057670, 2)

dblib.c:3032:dbdatlen(0xa057670, 2)

dblib.c:3040:dbdatlen() type = 39, len= 5

dblib.c:3060:dbdata(0xa057670, 2)

dblib.c:3032:dbdatlen(0xa057670, 3)

dblib.c:3040:dbdatlen() type = 39, len= 3

dblib.c:3060:dbdata(0xa057670, 3)

dblib.c:3032:dbdatlen(0xa057670, 3)

dblib.c:3040:dbdatlen() type = 39, len= 3

dblib.c:3060:dbdata(0xa057670, 3)

dblib.c:3032:dbdatlen(0xa057670, 4)

dblib.c:3040:dbdatlen() type = 39, len= 6

dblib.c:3060:dbdata(0xa057670, 4)

dblib.c:3032:dbdatlen(0xa057670, 4)

dblib.c:3040:dbdatlen() type = 39, len= 6

dblib.c:3060:dbdata(0xa057670, 4)

dblib.c:3032:dbdatlen(0xa057670, 5)

dblib.c:3040:dbdatlen() type = 47, len= 1

dblib.c:3060:dbdata(0xa057670, 5)

dblib.c:3032:dbdatlen(0xa057670, 5)

dblib.c:3040:dbdatlen() type = 47, len= 1

dblib.c:3060:dbdata(0xa057670, 5)

dblib.c:3032:dbdatlen(0xa057670, 6)

dblib.c:3040:dbdatlen() type = 39, len= 27

dblib.c:3060:dbdata(0xa057670, 6)

dblib.c:3032:dbdatlen(0xa057670, 6)

dblib.c:3040:dbdatlen() type = 39, len= 27

dblib.c:3060:dbdata(0xa057670, 6)

dblib.c:3032:dbdatlen(0xa057670, 7)

dblib.c:3040:dbdatlen() type = 39, len= 16

dblib.c:3060:dbdata(0xa057670, 7)

dblib.c:3032:dbdatlen(0xa057670, 7)

dblib.c:3040:dbdatlen() type = 39, len= 16

dblib.c:3060:dbdata(0xa057670, 7)

dblib.c:3032:dbdatlen(0xa057670, 8)

dblib.c:3040:dbdatlen() type = 111, len= 8

dblib.c:2741:dbcoltype(0xa057670, 8)

dblib.c:2722:dbwillconvert(61, 47)

convert.c:2845:tds_willconvert()

convert.c:2849:tds_willconvert() 61 47 1

dblib.c:3032:dbdatlen(0xa057670, 8)

dblib.c:3040:dbdatlen() type = 111, len= 8

dblib.c:2741:dbcoltype(0xa057670, 8)

dblib.c:3060:dbdata(0xa057670, 8)

dblib.c:2741:dbcoltype(0xa057670, 8)

can anyone help me ? Thanks very very very much!

Best Regards,

Rachel

[freetds] problem of list more than 1 result via freedts & php4 from sqlserver2k, Rachel, 04/22/2008