Peppe Polpo wrote:

> Data is passed to the second form, where it is massaged and used to
> build a SQL script, then the script is executed.
>
> The script is called script.sql and its current containt is
>
> set term !! ;
> select * from autoshift(1,'2004-3-1','2004-3-31',1) !!
> commit !!
> set term ; !!
>
> The script should be launched by a second shell script. The script is
> called start.sh and its containt is
>
> /opt/interbase/bin/isql e -u "SYSDBA" -p "masterkey" -
> i "/root/test/script.sql" /root/test/auto.gdb

One question: Why don't you simply use php's extenstion for Firebird
(InterBase) and just call the SP directly without messing with the shell
scripts?

--
Milan Babuskov
http://fbexport.sourceforge.net