Yeah, if you dump the file to a .read-able file then his idea is
simpler and easier. The approach I described is probably better
suited to situations where you need to .import a file, because in that
case the file is raw data rather than SQL statements.
-T
On Wed, Dec 3, 2008 at 12:41 AM, Jerry Krinock <[EMAIL PROTECTED]> wrote:
>
> On 2008 Dec, 02, at 21:19, Thomas Briggs wrote:
>
>> Try removing the semi-colon at the end of the .read statement. The
>> semi-colon is the query terminator, but because dot-commands aren't
>> queries they don't require the semi. As such the .read command in
>> twoLiner.sh is either seeing a third (and invalid) argument or an
>> invalid file name ("placesDump.txt ;").
>
> Ah that works. Although I haven't tried Kishor's idea, that should
> obviously work too.
>
> Thanks all,
>
> Jerry
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
