user("userID")
Frågan#1
I den här raden så klagar den på att den inte hittar UserID och username men de finns ju med i SQL-en
.Write "<a class=""menu"" href=""/view.asp?userID="& user("tblUsers.userID") &""">"& user("tblUsers.username") &"</a> <span class=""linkpresentation"">"& left(user("messageTime"),5) &" "& right(replace(user("messageDate"),"-",""),6) &"</span>" & vbCrLf
den hittar messageDate och messageTime
SQL-satsen
Set user=objConn.Execute("SELECT tblUsers_messagescroll.mCounter,tblUsers.userID, tblUsers.username, tblUsers.webblajv, tblUsers.picture, tblUsers_messagescroll.userID, tblUsers_messagescroll.mCounter,tblUsers_messagescroll.Visar, tblUsers_messagescroll.username, tblUsers_messagescroll.message, tblUsers_messagescroll.messageTime, tblUsers_messagescroll.messageDate "&_
"FROM tblUsers INNER JOIN tblUsers_messagescroll ON tblUsers.userID = tblUsers_messagescroll.userID where Visar=1 order by mCounter desc limit 12")