E\Scenario Management\ahk_sceptre>i3.png
C:\jon\svn\SCEPTRE\trunk\SCEPTRE\Scenario Management\ahk_sceptre>
- Original Message -
> From: Keith Medcalf
> To: Jonathan Leslie ; General Discussion of SQLite
> Database
> Cc:
> Sent: Wednesday, December 3, 2014 8:27 PM
&
On Wed, Dec 3, 2014 at 8:36 PM, Jonathan Leslie
wrote:
> no such function writefile. do I have to update my sqlite3
>
>
The writefile() function is built into recent sqlite3.exe command-line
shells. Very recent once, at least.
If you are not using a recent command-line shell, then you can
;> To: Jonathan Leslie ; General Discussion of
> SQLite Database
>> Cc:
>> Sent: Wednesday, December 3, 2014 8:27 PM
>> Subject: Re: [sqlite] trying to store a file as a blob. caught on syntax...
>>
>>
>> select writefile(name, contents) from fi
ere name='image2.png';
Error: no such function: writefile
sqlite>
- Original Message -
> From: Keith Medcalf
> To: Jonathan Leslie ; General Discussion of SQLite
> Database
> Cc:
> Sent: Wednesday, December 3, 2014 8:27 PM
> Subject: Re: [sqlite] try
ginal Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of Jonathan Leslie
>Sent: Wednesday, 3 December, 2014 18:20
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] trying to store a file
>
> From: Clemens Ladisch
>To: sqlite-users@sqlite.org
>Sent: Wednesday, December 3, 2014 1:00 PM
>Subject: Re: [sqlite] trying to store a file as a blob. caught on syntax...
>
>
>Jonathan Leslie wrote:
>> I'm at a cmd.exe p
Jonathan Leslie wrote:
> I'm at a cmd.exe prompt.
>
> sqlite> INSERT INTO Files (name,contents) VALUES ('tsql.lis',X"$(od -A n -t
> x1 tsql.lis|tr -d '\r\n\t ')");
> Error: near ""$(od -A n -t x1 tsql.lis|tr -d '\r\n\t ')"": syntax error
>
> I'm trying to store the file tsql.lis as a blob, and od.
I'm on a window 7 x64 machine, at a cmd.exe prompt. This is what I tried:
C:\jone>sqlite3 test2.db3SQLite version 3.8.5 2014-06-04 14:06:34Enter ".help"
for usage hints.sqlite> CREATE TABLE Files (name TEXT PRIMARY KEY,contents
BLOB);sqlite> INSERT INTO Files (name,contents) VALUES ('tsql.lis
8 matches
Mail list logo