[Bayonne-devel] postgres i cant select

[Luis MIedzinski]

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,