由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
DotNet版 - rsArray 为啥写不全?
相关主题
foxpro and c#Now I've 20 left
[转载] SQL StandardHttpWebRequest小程序
Problem connecting to SQL Server用ACT testing的问题
问个sql问题ASP.Net比ASP倒底好多少?
Win 8 Pro上怎么enable .Net Framework 3.5?WebClient for multi-connections?
nhibernate, ado.net比stored procedure执行数据库操作快吗?how to list all opened sockets?
问一个linq to sql编程问题 (转载)大侠们帮帮忙---网络连接问题, 在线等!
20 Google Wave invitations leftHow to tell if a connection is http or https?
相关话题的讨论汇总
话题: rsarray话题: strq话题: set话题: sql话题: join
进入DotNet版参与讨论
1 (共1页)
m*******n
发帖数: 370
1
请高人帮我看看,同样的一段code,如果database连Access, rsArray里可以正常写入所有的
fields,但是如果连SQL server就只能写入NomID和Categories.Description,其他都为
空.我把strQ对应的select语句放到SQl server里去run,结果也是对的,每个field都显示
了,但为什么没有能够被读到里rsArray呢? rsArray = objRS.GetRows()为什么没能读
全?
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS.ActiveConnection = Connection
strQ = "SELECT NominationDetailsCurrent.NomID, Title, OrderNo, Letter,
CategoryName, Categories.Description, Categories.Weight " & _
"FROM (NominationDetailsCurrent LEFT JOIN NominationCategories
ON NominationCategories.NomID = NominationDetailsCurrent.NomID) LEFT
JOIN Categories ON NominationCategories.CategoryID =
Categories.CategoryID " & _
"ORDER BY Categories.Weight, OrderNo "
Response.Write( " The strQ is: " & strQ & "
")
objRS.Open strQ
If Not objRS.EOF Then
rsArray = objRS.GetRows()

End If
For Each item In rsArray
Response.Write(item & "
")
Next
1 (共1页)
进入DotNet版参与讨论
相关主题
How to tell if a connection is http or https?Win 8 Pro上怎么enable .Net Framework 3.5?
[合集] How to tell if a connection is http or https?nhibernate, ado.net比stored procedure执行数据库操作快吗?
How to read SSL Socket stream?问一个linq to sql编程问题 (转载)
Connecting to TWS with c# sample20 Google Wave invitations left
foxpro and c#Now I've 20 left
[转载] SQL StandardHttpWebRequest小程序
Problem connecting to SQL Server用ACT testing的问题
问个sql问题ASP.Net比ASP倒底好多少?
相关话题的讨论汇总
话题: rsarray话题: strq话题: set话题: sql话题: join