title: SELECT is not working as expected
body: <p>If I remove <code>LIMIT "&amp;PageStart&amp;" , "&amp;PageEnd&amp;"</code> the query below works fine. I get all the data from the database. But it don't work with <code>LIMIT</code> and these two parameters. What am I doing wrong?</p>
  
  <pre><code>Dim Conn,strSQL,objRec
  Set Conn = Server.Createobject("ADODB.Connection")
  Conn.Open "Driver={SQL Server}; Server=Localhost; Database=book-it-fifa;"
  strSQL = "select distinct buchung_id, von, bis, abteilung, veranstalter, THEMA, THEMA_ENABLED " &amp; _
      "  from RESERVIERUNGRAUM r  " &amp; _
      "      ,BUCHUNG b  " &amp; _
      " where r.BUCHUNG_ID = b.ID " &amp; _
      "   and von &gt;= convert(date, getdate(), 4) " &amp; _
      "   and von &lt; convert(date, dateadd(day,1, GETDATE()), 4) " &amp; _
      "   and BIS &gt;= getdate() " &amp; _
      "   and STORNO is null  " 
  Set objRec = Server.CreateObject("ADODB.Recordset")
  objRec.Open strSQL, Conn, 1,3
  
  If objRec.EOF Then
      Response.write (" Not found record.")   
  Else
  
  '**** Paging/Pagination Calculator ***'
  Dim PageLen,PageNo,TotalRecord,TotalPage,intID
  Dim PageStart,PageEnd
  PageLen = 2 
  PageNo = Request.QueryString("Page")
  if PageNo = "" Then PageNo = 1
  TotalRecord = UBound(objRec.GetRows,2)+1
  PageStart = ((PageLen*PageNo)-PageLen)
  PageEnd = PageLen
  If TotalRecord &lt;= PageLen Then
      TotalPage =1
  ElseIf (TotalRecord Mod PageLen = 0) Then
      TotalPage =(TotalRecord/PageLen)
  Else
      TotalPage =(TotalRecord/PageLen)+1
      TotalPage = Cint(TotalPage)
  End If
  
  '*** Close Object and Open New RecordSet ***'
  objRec.Close()
  strSQL = strSQL &amp; "ORDER BY von, bis ASC LIMIT "&amp;PageStart&amp;" , "&amp;PageEnd&amp;" "
  objRec.Open strSQL, Conn, 1,3
  </code></pre>