grndeveloper wrote:

>Hello everybody,
>
>I am bulding a unix shell script which does several database
>connections to return or modify some data.
>
>To do this I use the isql comand.
>
>Since now I have had no problems in returning the value a table field
>assigning it to a shell variable, in the following way:
>
>VAR=$(/opt/firebird/bin/isql $PATHDB -user $DBUSER -password
>$DBPASSWORD -i my_select.sql)
>
>Is there a nicer way of doing this?
>
>If I have to return more tan one field, in the same query, I have to
>"look into" the variable and it gets more complex.
>
>Is it possible to assign a value in isql, and use it in the shell
>script, in an easier way?
>
>Thanks in advance.
>
>
>
>

Hi !

I know it's not you have asked for, but, what about if you make your
scripts in PHP ?

You will have far better control over it

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.2 - Release Date: 14/06/2005