[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Bayonne-devel] How to fetch SQL results
From: |
Johan Jacobsson |
Subject: |
[Bayonne-devel] How to fetch SQL results |
Date: |
Mon, 26 Feb 2007 16:25:26 +0100 |
User-agent: |
KMail/1.9.5 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Bayonne-devel] How to fetch SQL results,
Johan Jacobsson <=