litenoob wrote:
--
#/bin/sh
ROW_ID=`sqlite3 test.db <<END
insert into t values(1,2);
select last_insert_rowid() from t limit 1;
END
`
echo ROW_ID=$ROW_ID
--
^ that worked perfectly. Thank you Nikola!
FYI, the last part of the select is superfluous. You can simply do this:
insert into t values(1,2);
select last_insert_rowid();
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
