• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Shell Scripting SQLite
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: Shell Scripting SQLite
      • From: "Mark J. Reed" <email@hidden>
References: 
 >Re: Shell Scripting SQLite (From: BareFeet <email@hidden>)

  • Prev by Date: Excel Cell Format Question
  • Next by Date: Re: Shell Scripting Sqlite
  • Previous by thread: Re: Shell Scripting SQLite
  • Next by thread: Re: Shell Scripting SQLite
  • Index(es):
    • Date
    • Thread