asp里面?
直接用adodb.recordset 来取值啊
dim strjdj
sql="select sgj from 表名 where......"
dim conn as new adodb.connection
dim rs as new adodb.recordset
conn.open "连接字串"
rs.open sql,conn,1,1
strjdj=rs("sgj")
rs.close
set rs=nothing
直接用adodb.recordset 来取值啊
dim strjdj
sql="select sgj from 表名 where......"
dim conn as new adodb.connection
dim rs as new adodb.recordset
conn.open "连接字串"
rs.open sql,conn,1,1
strjdj=rs("sgj")
rs.close
set rs=nothing
我把刚才strfdj=rs("sgj")取出来如何将它和另一个变量相乘!
即strfje=strfdj*strfjs
这样的写法不对!请问该如何处理两个变量相乘!?
declare strjdj numric(9,2)
select strjdj=sgj from 表名 where......"2
转换类型后再乘