[Bayonne-devel] How to fetch SQL results

[Johan Jacobsson]

Hi!

I finally managed to get the ODBC driver to work for MySQL and can execute DB 
queries from within my bayonne scripts, but I have no luck when I try using 
sql.fetch (bayonne2-2.3.2 ccscript3-1.1.6)

use odbc database=MySQLODBC

program main
        array %rows count=50
        string %name
        string %newscript

        echo %sql.driver

        echo %session.dialed

        sql "select prod from ddi_prod where ddi = %session.dialed limit 1" 
results=&rows

        echo "Rows: %sql.rows"

        foreach %row %rows
                sql.fetch %newscript
        loop

        echo %newscript



The error message I get is:

dtmf_say.scr(21): sql.fetch: command does not use member options


I know I'm not using sql.fetch correctly, but I can't find any documentation 
about the correct way or figure out anything from the sourcecode.

Regards,
Johan