Jo, i detta fall är det onödigt att använda getrows.
Trådstart#1
strSQL = "SELECT username, epost, presentation FROM userr WHERE userID=" & userID
Set RecSet = Connect.Execute(strSQL)
IF NOT RecSet.EOF THEN
arrRecords = RecSet.GetRows
End If
RecSet.Close
Set RecSet = Nothing
Connect.Close
Set Connect = Nothing
username = arrRecords(0,0)
epost = Server.HTMLEncode(arrRecords(1,0))
presentation = arrRecords(2,0)
Eller
strSQL = "SELECT username, epost, presentation FROM userr WHERE userID=" & userID
Set RecSet = Connect.Execute(strSQL)
IF NOT RecSet.EOF THEN
username = RecSet("username")
epost = RecSet("epost")
presentation= RecSet("presentation")
End If
RecSet.Close
Set RecSet = Nothing
Connect.Close
Set Connect = Nothing
Getrow tar väl mer prestanda eller?
