the first parameter in the array is PageNumber, but it is not used in the query... am I missing something?

btw, what is the method for?

thank you
Federico

--
from trunk\mojoPortal.Data.MySql\dbPortal.cs: 

public static IDataReader SiteUser_GetUserListPage(
int siteID,
int pageNumber,
int pageSize,
string userNameBeginsWith)
{
StringBuilder sqlCommand = new StringBuilder();
int pageLowerBound = (pageSize * pageNumber) - pageSize;
int totalRows
= SiteUser_Count(siteID, userNameBeginsWith);

sqlCommand.Append("SET @TotalRows = "
+ totalRows.ToString(CultureInfo.InvariantCulture) + ";");
sqlCommand.Append("SET @TotalPages = CEILING(@TotalRows / ?PageSize) ;");

sqlCommand.Append("SELECT u.*, ");
sqlCommand.Append("@TotalPages As TotalPages ");
sqlCommand.Append("FROM mp_Users u ");

sqlCommand.Append("WHERE u.ProfileApproved = 1 ");
sqlCommand.Append("AND u.SiteID = ?SiteID = 1 ");

if (userNameBeginsWith.Length > 0)
{
sqlCommand.Append(" AND u.Name LIKE ?UserNameBeginsWith ");
}

sqlCommand.Append(" ORDER BY u.Name ");
sqlCommand.Append("LIMIT " + pageLowerBound.ToString(CultureInfo.InvariantCulture) + ", ?PageSize ; ");

MySqlParameter[] arParams = new MySqlParameter[4];

arParams[0] = new MySqlParameter("?PageNumber", MySqlDbType.Int32);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = pageNumber;

arParams[1] = new MySqlParameter("?PageSize", MySqlDbType.Int32);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = pageSize;

arParams[2] = new MySqlParameter("?UserNameBeginsWith", MySqlDbType.VarChar, 50);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = userNameBeginsWith + "%";

arParams[3] = new MySqlParameter("?SiteID", MySqlDbType.Int32);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = siteID;

return MySqlHelper.ExecuteReader(
GetConnectionString(),
sqlCommand.ToString(),
arParams);

}