Can anyone suggest why the below results in 'Error: near line 1: near "INSERT": syntax error'? read -p "Other notes: " WINE_NOTES_other_notes if [[ -z "$WINE_NOTES_other_notes" ]]; then WINE_NOTES_other_notes=null fi sqlite3 $DB_FILE << EOF BEGIN TRANSACTION INSERT INTO wines VALUES (null, '$WINE_date', '$WINE_format', '$WINE_type', '$WINE_vineyard', '$WINE_year', '$WINE_region', '$WINE_name', '$WINE_grape1', '$WINE_grape2', '$WINE_grape3') INSERT INTO wine_notes VALUES (null, LAST_INSERT

Can anyone suggest why the below results in 'Error: near line 1: near "INSERT": syntax error'?

read -p "Other notes: " WINENOTESother_notes
if [[ -z "$WINENOTESother_notes" ]]; then
WINENOTESothernotes=null
fi
sqlite3 $DBFILE << EOF
BEGIN TRANSACTION
INSERT INTO wines VALUES (null, '$WINEdate', '$WINEformat', '$WINEtype', '$WINEvineyard', '$WINEyear', '$WINEregion', '$WINEname', '$WINEgrape1', '$WINEgrape2', '$WINEgrape3')
INSERT INTO winenotes VALUES (null, LASTINSERT_ROWID(), '$WINENOTESnotes_date', '$WINENOTESnose', '$WINENOTEStaste', '$WINENOTESratingof10', '$WINENOTESrating_justification', '$WINENOTESother_notes')
COMMIT TRANSACTION;
EOF
fi

2016-10-16T17:29:35Z