Re: Shell Scripting SQLite
Re: Shell Scripting SQLite
- Subject: Re: Shell Scripting SQLite
- From: Bruce Robertson <email@hidden>
- Date: Fri, 30 May 2008 10:58:26 -0700
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.
But what is pbpaste doing? It still seems like you ought to be able to write
the data from a variable instead of from pbpaste.
Set Variable [ $$out; Value:"echo '" & Substitute(text::Text; "'"; "\"")
&"'|pbcopy|pbpaste|sqlite3 /newfm.db" ]
Set Variable [ $$result; Value:zippShell_PerformShellCommand( $$out ) ]
_______________________________________________
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