怎么不能提出数值型变量？,糟了....帮帮我！！..........

[jiangshan72]

<%
Dim conn,rs,SQLstring,showblank,shownull,whatever,count,thisfield
Dim tempdata

SQLstring = "SELECT clpz,czmc,dhhm,xj FROM tb_hz where dhhm like '68578772'"

showblank = " "
shownull = "空"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Mode = 1
conn.Open "RYLF"
'Set rs = conn.Execute(SQLstring)
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open SQLstring, conn, 1,1
count = rs.recordcount
IF rs.eof THEN
Response.Write "no this recorde"
END IF
FOR each whatever in rs.fields
Response.Write whatever.name & "   "
NEXT
Response.Write "<BR>"
DO UNTIL rs.eof
FOR each whatever in rs.fields
thisfield = whatever.value
IF isnull(thisfield) THEN
thisfield = shownull
END IF
IF trim(thisfield) = "" THEN
thisfield = showblank
END IF
Response.Write thisfield & "   "
NEXT
Response.Write "<BR>"
rs.Movenext
LOOP



rs.Close
Set rs = nothing
conn.Close
Set conn = nothing
Response.Write "符合条件的记录共有" & count & "条。"
Response.End
%>

用的DB2数据库
当在SELECT 中有数值型变量xj时，返回查找到的记录条数count=0(实际上不为0);
若没有数值型变量xj时，则为正常返回值。
为什么？谢谢

[citybird888]

可能是你用的数据库对recordcount属性支持不够好，oracle也是这样，可以用“select count(*)...”得到纪录的条数

[fengchu2]

用select *

[awaysrain]

DB2也有这样的问题吗
oracle里用to_char()函数转换一下就行，DB2里也应该有类似的函数

要不试试改改游标类型看看行不