如何从asp中获取sql的值 [英] how to get value from sql in asp
本文介绍了如何从asp中获取sql的值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在asp页面中获取此查询的价值,
以及条件....
set rsInven = server.CreateObject( adodb.recordset)
rsInven。打开 从crmconfig中选择GivenToCust,其中module ='SPARES USED',cn
解决方案
这里有一个例子:
Dim GivenToCust
Dim GivenToCust_cmd
Dim GivenToCust_numRows
设置GivenToCust_cmd = Server.CreateObject(ADODB.Command)
GivenToCust_cmd.ActiveConnection = Conn
GivenToCust_cmd.CommandText =从crmconfig中选择GivenToCust,其中module ='SPARES USED'
GivenToCust_cmd.Prepared = true
设置GivenToCust = GivenToCust_cmd.Execute
Dim arrGivenToCust
arrGiv enToCust = GivenToCust.GetRows()
dim i
response.write< table>
对于i = 0到ubound(arrGivenToCust,2)
response.write< tr>
response.write(< td>+ trim(i + 1))
response.write(< table>< tbody>< tr>< td>+ trim (arrGivenToCust(0,i)))
next
response.write< / td>< / tr>< / tbody>< / table>< / td>< / TR>< / tbody的>< /表>< / TD>< / TR>< /表>
how will get value from this query in asp page,
and if condition ....
set rsInven=server.CreateObject("adodb.recordset")
rsInven.Open "select GivenToCust from crmconfig where module='SPARES USED'",cn
解决方案
here is one example :
Dim GivenToCust Dim GivenToCust_cmd Dim GivenToCust_numRows Set GivenToCust_cmd = Server.CreateObject("ADODB.Command") GivenToCust_cmd.ActiveConnection = Conn GivenToCust_cmd.CommandText = "select GivenToCust from crmconfig where module='SPARES USED'" GivenToCust_cmd.Prepared = true Set GivenToCust = GivenToCust_cmd.Execute Dim arrGivenToCust arrGivenToCust = GivenToCust.GetRows() dim i response.write "<table>" For i = 0 to ubound(arrGivenToCust , 2) response.write "<tr>" response.write("<td>" + trim(i+1)) response.write("<table><tbody><tr><td>" + trim(arrGivenToCust (0,i))) next response.write "</td></tr></tbody></table></td></tr></tbody></table></td></tr></table>"
这篇关于如何从asp中获取sql的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文