SQL error and not paginating

<i><b>Originally posted by : nudge (office@place-1.com)</b></i><br />hi all<br /><br />can someone please have a look here.<br /><br />http://www.immobilien-suche.at/search.asp<br /><br />the sql string all works on the first page, but as soon as i go to page 2, it throws an SQL error.<br /><br />if i take out the SQL string and simply:<br /><br />strSQL = "SELECT * FROM Properties"<br /><br />then it work fine.<br /><br />any help really appreciated.<br /><br />nudge