Works;
CrQuote ad_instproc getOneQuote {
    {-quotename:required}
    {-quoteauthor:required}
} {
    Get a random quote from the database
} {
    upvar 1 $quotename name
    upvar 1 $quoteauthor quote_author

    db_1row get_random_quote "select quote_author, name from xotcl_cr_ea_quotesx order by random() limit 1 "

    return
}

but changing
db_1row get_random_quote "select quote_author, name from xotcl_cr_ea_quotesx order by random() limit 1 "
to
db_1row get_random_quote {}

with the following xql

<?xml version="1.0"?>
<queryset>

    <fullquery name="get_random_quote">
        <querytext>
            select quote_author, name
            from  xotcl_cr_ea_quotesx
            order by random limit 1
        </querytext>
    </fullquery>

</queryset>

fails with statement not found.

Does ad_instproc interfere with the xql mechanism?

cheers
  Matthew