We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 3647
    • 177 Posts
    Hi

    I have tried the basic Rowboat example, and I just get nothing - I must be missing something obvious but I can't work it out...

    This is the snippet call on the page:
    [[!Rowboat?
    &table=`modx_doodles`
    &tpl=`myDoodle`
    &limit=`10`
    &sortBy=`name`
    ]]

    Have create a chunk "myDoodle"
    <li id="doodle[[+id]]"><strong>[[+name]]</strong> - [[+description]]</li>

    I have a table called modx_doodles (and tried with other tables, still nothing

    Tried with debug=`1` and get the following in a table:

    Rowboat Debugging Information
    Table modx_doodles
    SQL Query SELECT * FROM `modx_doodles`
    ORDER BY `name` ASC
    LIMIT 10
    PDO Statement SELECT * FROM `modx_doodles`
    ORDER BY `name` ASC
    LIMIT 10
    Parameters

    array (
    )

    Total
    Messages
    Results are cached.
    Results

    Anyone have any suggestions, I'm not even sure I know what it does yet, I've never seen anything! [ed. note: bluespark last edited this post 13 years, 2 months ago.]
      • 4172
      • 5,888 Posts
      do you get anything, when you try this query with phpmyadmin?
      	SELECT * FROM `modx_doodles`
      ORDER BY `name` ASC
      LIMIT 10
        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!
        • 3647
        • 177 Posts
        Hi Bruno

        Thanks, you're right - table name wrong it is 'modx_revo_doodles'

        Duh!