I can insert i did it even with data i got with %digits,
with a little different script i got %sql.cols and %sql.rows, but i
never got the data of the sql
here is the script
^dtmf
collect count=4 ignore="*#ABCD" var=>.msg timeout=$timeout
case .msg.len = 0
restart
case .msg.len < 4
play playrec2 %% invalid
restart
endcase
sql.query {select count(*) from planes}
slog %sql.error
read table=#sql %col1
slog "tengo :" %col1 "registros por aca"
slog "query result: " %sql.cols " columns and " %sql.rows "
rows" %id
restart .retry="0"
here is the log...............
Nov 22 22:02:44 localhost bayonne: Configuration reloaded
Nov 22 22:02:57 localhost bayonne: dialogic/0: mi_script: hola, playrec
Nov 22 22:02:57 localhost bayonne: dialogic/0: mi_script: hola, soy luis
Nov 22 22:03:00 localhost bayonne: dialogic/0: mi_script: none
Nov 22 22:03:00 localhost bayonne: script: mi_script.bs(46): col1
undefined
Nov 22 22:03:00 localhost bayonne: dialogic/0: mi_script: query result:
columns and rowsnshaar-000-0041a28c40
Nov 22 22:03:01 localhost bayonne: dialogic/0: mi_script: hola, playrec
Nov 22 22:03:01 localhost bayonne: dialogic/0: mi_script: hola, soy luis
Nov 22 22:03:04 localhost bayonne: dialogic/0: mi_script: none
Nov 22 22:03:04 localhost bayonne: script: mi_script.bs(46): col1
undefined
Nov 22 22:03:04 localhost bayonne: dialogic/0: mi_script: query result:
columns and rowsnshaar-000-0041a28c40
Nov 22 22:03:04 localhost bayonne: dialogic/0: mi_script: hola, playrec
Nov 22 22:03:04 localhost bayonne: dialogic/0: mi_script: hola, soy luis
**************************************************
I have D/41H, RedHat 8.0 postgres 7.2.2,
_______________________________________________
Bayonne-devel mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/bayonne-devel