在线求一SQL语句，关于数据类型转换方面得

[yq_net]

sqlCount="select id,name from class where id='Cstr(myid)'"

id 是字符串型得，myid是整形得，

语句该怎么写，我这么写错在哪儿

[btlyeo]

sqlCount="select id,name from class where id= cast(myid as int)"

[clare2003]

sqlCount="select id,name from class where cast(id as varchar(5))='myid''
或者
sqlCount="select id,name from class where convert(varchar(5),id)='myid''

[浙外]

sqlCount="select id,name from class where id='"&Cstr(myid)&"'"

[浙外]

错就错在如果你把变量写到单引号里变量也变常量的了。建议你以后用response.write sqlcount的方式把内容输出，然后再看错在哪里。这样方便多了

[浙外]

开始扫荡未结贴，BS以下不结贴的行为………………

[jingxiaoping]

顶楼上，同BS。

[leohuang]

sqlCount="select id,name from class where id='" & myid & "'"

[king5281273]

楼上的最好

[z109876543210]

sqlCount="select id,name from class where id='" & myid & "'"