Re: Shell Scripting SQLite
Re: Shell Scripting SQLite
- Subject: Re: Shell Scripting SQLite
- From: "Mark J. Reed" <email@hidden>
- Date: Fri, 30 May 2008 15:02:39 -0400
On Fri, May 30, 2008 at 1:58 PM, Bruce Robertson <email@hidden> wrote:
> The following works to take a sql statement stored in a text field, convert
> the single quotes to double quotes, get it into the clipboard and use
pbpaste to send it to sqlite3.
> Set Variable [ $$out; Value:"echo '" & Substitute(text::Text; "'"; "\"")
> &"'|pbcopy|pbpaste|sqlite3 /newfm.db" ]
?!? Ok, pbcopy generates no output and pbpaste takes no input, so the
pipe does nothing. I think you mean this:
echo blah | pbcopy
pbpaste | sqlite3
But pbcopy and pbpaste are doing nothing for you there. You can do
echo blah | sqlite3
directly. That's nothing special - that's just feeding the contents of
an AS variable as standard input to sqlite3. If that's all you want,
then I don't know what you've been talking about.
--
Mark J. Reed <email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden