如何从asp中获取sql的值 [英] how to get value from sql in asp

问题描述

如何在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屋！