On Fri, 29 Jun 2001, Matteo Centenaro wrote:
> Hi all,
>
> I have to call a function implemented in Pl/Pgsql into a PostgreSQL
> database i try the syntax:
>
> set agg_query [pg_exec $db_elenco "Update campione_out set
> ultimo_accesso=$ora where prefisso=$pre and telefono=$tel"];
>
> where ora,pre e tel is variable set before the call.
>
> I also try to insert the escape char '\':
>
> set agg_query [pg_exec $db_elenco "Update campione_out set
> ultimo_accesso=\$ora where prefisso=\$pre and telefono=\tel"];
>
> but it doesn't work!!
>
> Has anybody any suggest?
Of what type are the columns `ultimo_accesso', `prefisso', and `telefono'?
You probably need to put the values into single-quotes if they are of some string type.
I.e.:
set agg_query [pg_exec $db_elenco "Update campione_out set \
ultimo_accesso='$ora' where prefisso='$pre' and telefono='$tel'"];
>
> I also seen that my vtcl dosen't support tkTable what can I do to change
> this?
>
> Thanks
HTH
Carsten
_______________________________________________
vtcl-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/vtcl-user
