Server behavior for paging throws error - bug
I have a page I'm trying to put paging onto.
When I apply the server behaviour, and load the page it comes back with SQL error.
The original code for the page is
<?php
$rsFeatured = new WA_MySQLi_RS("rsFeatured",$web_catalogues_i,9);
$rsFeatured->setQuery("SELECT view_availablestockall.catAltText, view_availablestockall.catMenuLabel, view_availablestockall.catIcon, view_availablestockall.catDiscPrice, view_availablestockall.catDollarDisc, catRetailPrice, view_availablestockall.catItemDescShort, view_availablestockall.itemAvailable,view_availablestockall.catItemPrice, view_availablestockall.CatItemNameURL FROM view_availablestockall WHERE view_availablestockall.StkCatalogueID=? AND view_availablestockall.catMenuVisible<>0 AND view_availablestockall.itemAvailable='true' AND view_availablestockall.catFeatured<>0");
$rsFeatured->bindParam("i", "".$_SESSION['catID'] ."", "-1"); //paramCatID
$rsFeatured->execute();
?>
after applying the behavior the code is altered to the following, note the change from i and ? to int and %s changing it back to i and ? solves the problem
<?php
$rsFeatured = new WA_MySQLi_RS("rsFeatured",$web_catalogues_i,9);
$rsFeatured->setQuery("SELECT view_availablestockall.catAltText, view_availablestockall.catMenuLabel, view_availablestockall.catIcon, view_availablestockall.catDiscPrice, view_availablestockall.catDollarDisc, catRetailPrice, view_availablestockall.catItemDescShort, view_availablestockall.itemAvailable,view_availablestockall.catItemPrice, view_availablestockall.CatItemNameURL FROM view_availablestockall WHERE view_availablestockall.StkCatalogueID=%s AND view_availablestockall.catMenuVisible<>0 AND view_availablestockall.itemAvailable='true' AND view_availablestockall.catFeatured<>0");
$rsFeatured->bindParam("int", "".$_SESSION['catID'] ."", "-1"); //paramCatID
$rsFeatured->execute();
?>