עזרה - בעיה ב-SQL
השגיאה היא בשורה האחרונה: error '80004005' Unspecified error
השגיאה היא בשורה האחרונה: error '80004005' Unspecified error
recPerPage=5 currPage=request("page") if currPage="" then currPage=1 sql="select * from messages where sourceId in (select top " & recPerPage & " sourceId from messages where levelId=0" if currPage>1 then sql= sql & " and sourceId not in (select top " & currPage*recPerPage-recPerPage & " sourceId from messages order by jumpId desc,position) " end if sql=sql & " order by jumpId desc,position) order by jumpId desc,position" set rs=conn.Execute(sql)