[Sqlrelay-discussion] phppeardb returning only 100 rows

[Felipe C. - P. <fel...@te...>]

Hello,

Can anyone help me on this issue?

I am using sqlrelay-0.39.4 and postgresql 8.3.1.

When I run this code from phppeardb, it only returns me 100 rows:

$query = "SELECT id, name FROM ct_contest ORDER BY name ASC;";
        $db->setFetchMode(DB_FETCHMODE_ASSOC);
        $result = $db->query($query);
                while ($line = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
                 print ("\t<option value=\"$line[id]\" 
$selected>$line[name]</option>\n");
                print "$line[name]\n";
        }
        $result->free();

###########################################################

However, if I run it on sqlrsh:
        Rows Returned   : 293
        Fields Returned : 586
        System time     : 0

###########################################################


print_r($result); says:

DB_result Object
(
    [autofree] => 
    [dbh] => DB_sqlrelay Object
        (
            [connection] => Resource id #14
            [identity] => 
            [bindformat] => 
            [phptype] => sqlrelay
            [dbsyntax] => sqlrelay
            [autocommit] => 
            [fetchmode] => 2
            [affectedrows] => 0
            [prepare_types] => Array
                (
                )

            [is_select] => Array
                (
                )

            [features] => Array
                (
                    [prepare] => 1
                    [pconnect] => 1
                    [transactions] => 1
                    [limit] => emulate
                )

            [fetchmode_object_class] => stdClass
            [was_connected] => 
            [last_query] => 
            [options] => Array
                (
                    [result_buffering] => 500
                    [persistent] => 
                    [ssl] => 
                    [debug] => 0
                    [seqname_format] => %s_seq
                    [autofree] => 
                    [portability] => 0
                    [optimize] => performance
                )

            [last_parameters] => Array
                (
                )

            [prepare_tokens] => Array
                (
                )

            [prepared_queries] => Array
                (
                )

            [_last_query_manip] => 
            [_next_query_manip] => 
            [_debug] => 
            [_default_error_mode] => 
            [_default_error_options] => 
            [_default_error_handler] => 
            [_error_class] => DB_Error
            [_expected_errors] => Array
                (
                )

            [dsn] => Array
                (
                    [phptype] => sqlrelay
                    [dbsyntax] => sqlrelay
                    [username] => postgres
                    [password] => password
                    [protocol] => unix
                    [hostspec] => 
                    [port] => 9000
                    [socket] => /tmp/clx_db.socket
                    [database] => clx_db
                )

        )

    [fetchmode] => 2
    [fetchmode_object_class] => stdClass
    [limit_count] => 
    [limit_from] => 
    [parameters] => Array
        (
        )

    [query] => 
    [result] => DB_sqlrelay_cursor Object
        (
            [cursor] => Resource id #18
            [connection] => Resource id #14
            [rownum] => 100
            [rownun] => 0
        )

    [row_counter] => 
    [statement] => 



Thank you,

Felipe