Re: [Bayonne-devel] postgres i cant select

[David Sugar]

Since it looks like your using the testing branch, you have to use 
something like:

sql.fetch %col1

rather than

read table=#sql %col1


Luis MIedzinski wrote:
> 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