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

Rachel rachel at bidchance.com
Tue Apr 22 06:11:50 EDT 2008


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




More information about the FreeTDS mailing list