Re: GetList parameters are getting messed up

[Joel]

when are you getting this error? during setup?

can you send me the @link. i'll take a look. tks

On Jul 30, 4:35 pm, "russell.sto...@gmail.com"
<russell.sto...@gmail.com> wrote:
> Greetings.
>
> I am getting the error "Warning: mysql_fetch_assoc(): supplied
> argument is not a valid MySQL result resource..." which I have traced
> to an incorrect "$this->pog_query" query within my object's
> "GetList()" function.
>
> The array that I am passing to this function is:
>
>              Array ( [0] => paid [1] => = [2] => T )
>
> This is correct.  However, when it reaches this section of "GetList":
>
>                 $this->pog_query .= " order by ".$sortBy." ".($ascending ? "asc" :
> "desc")." $sqlLimit";
>                 $thisObjectName = get_class($this);
>                 $cursor = Database::Reader($this->pog_query, $connection);
>                 while ($row = Database::Read($cursor))
>
> The value of "$this->pog_query" is:
>             select * from `szf_isd` where p = T
>
> I have no idea why "paid" is being truncated to p.
>
> BTW, field "paid" is of tyhpe enum('T','F')--does that have anything
> to do with it?
>
> TIA.
>
> Russ