regarding shell scripts and database function.

[creeds]

hello,
i have a problem regarding following scenario,
------------------
#!/bin/sh
read $no

output=$(/usr/local/pgsql/bin/psql -d hrcurrency -t -c "select fn_deleteradno( no)")

echo $output

-----------------
My problem is how to pass the value read from the console to the function
fn_deleteradno( no)

if i straight away give the number by hard coring it in the function, it works fine.

[gpraghuram]

hello,
i have a problem regarding following scenario,
------------------
#!/bin/sh
read $no

output=$(/usr/local/pgsql/bin/psql -d hrcurrency -t -c "select fn_deleteradno( no)")

echo $output

-----------------
My problem is how to pass the value read from the console to the function
fn_deleteradno( no)

if i straight away give the number by hard coring it in the function, it works fine.

output=$(/usr/local/pgsql/bin/psql -d hrcurrency -t -c "select fn_deleteradno( $no)")

You have to use $var to get the value

raghuram