I'm new to shell scripting and trying my hand with nested if statements, and it seems to work fine until I try to test for an input of filename, then I get "line 40: syntax error near unexpected token `fi'"

I just can't see what's different between having 2 ifs and when I add the 3rd. Any help would be appreciated.

-----------------------code----------------
#/bin/sh
set -v on
set -x on

echo "What content file are you going to run?"
read file
echo "What expiration date? Enter in 01-APR-09 format."
read expired


if [ "$file" = "" ]; then

echo "Need a filename to process."

else

for asset in ${list[@]}; do
list=( `cat $file`)
result1=( `sqlplus -S user/pass@db1 << EOF
set pages 0 echo off verify off feedback off
select package_name from package where package_id = (select substr(path, -20) from content where file_name = '$asset');
exit
EOF`)

if [ "$result1" = "" ]; then

echo $asset
else

result2=( `sqlplus -S use/pass@db2 << EOF
set pages 0 echo off verify off feedback off
select expiration_date from offering where package_name='$result1' and expiration_date > '$expired';
exit
EOF`)
if [ "$result2" = "" ]; then

echo $asset
fi
fi
fi
done

When coding indentation is your friend, I think your last fi and done need to be swapped thus:

                EOF`)

I've just ordered your book Mr. Johnson, look forward to reading it.

Are you saying the:
should be:
?

Also if sqlplus does not like white space at the beginning of its commands then the lines after the "<<EOF" and before the terminating "EOF" should not be indented, but not sure about whether sqlplus would object to white space or not!

EOF`)

EOF
`)