avatar
rsArray 为啥写不全?# DotNet - 窗口里的风景
b*1
1
http://www.urbanartantiques.com/2009/vermeer-milkmaid-metropolitan-museum-art/
There are Dutch painters, and then there is Vermeer. Metropolitan Museum of
Art is always crowded on weekend days, but in the galleries of the special
exhibition featuring Vermeer's Milkmaid, I wish I could be seven feet tall
to have an unobstructed view. Like a British unconsciously standing up when
overhearing the word of Queen, visitors oohed and aahed. They were not to
vote or judge or to reconcile their mundane
avatar
m*n
2
请高人帮我看看,同样的一段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
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。