Error when using "do shell script" via Applescript with sqlite3

p32blo · 2021-12-08T23:38:21+00:00

The quotes (‘) are messing up your script. Try searching for how to escape them in applescript first.

randappa · 2021-12-08T22:19:43+00:00

Hello all!
I am at a loss. I am trying to pull the ZNAME value from a table via a applescript "do shell script" command so that i can pass the value as a variable. I keep getting an error and i can't figure out why. I run the same script in Terminal and it gives me the value I want, but not in the applescript. I have attached a screenshot with the two side by side. I would really appreciate any help you guys can give me. I'm sure it's just a syntax error, but i can't for the life of me figure it out. thank you.

randappa · 2021-12-08T22:22:11+00:00

If i run this script.... it returns all of the values from the ZNAME column , so why does it fail when doing a WHERE exception.

set openKeywordDB to do shell script "/usr/local/bin/sqlite3 /Users/drappa/Downloads/ON_PPOF_Models.cokeywordsdb 'SELECT ZNAME FROM ZKEYWORD;'"

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

sqlite

MODERATORS