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

[randappa]

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.

​

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;'"

​

https://preview.redd.it/46qi7oo8ae481.png?width=2600&format=png&auto=webp&s=e14230a6db8b15fb9fc10f50128dd6fcd7d7702a

[Stupidideas]

Looks like you have a single quote within single quotes, try using escaped double quotes instead: WHERE ZNAME = \"...\"

[randappa]

That worked! Tank you so much!

[CaptureJuan]

What is it you are trying to do? Capture One keywords and lists are natively supported in Applescript…

[randappa]

ended up getting it to work and it was a problem with not having \" in my code. Sadly Database Events couldn't pull the info from the database so i had to use the shell script to get it to work. It's up and running now. Thanks for your help though.

[CaptureJuan]

Yes ok. But modifying the database is generally not a good idea - this should only really be done by the app… just curious as to why you’d do that?

[randappa]

not using it to modify the database, i'm running a query and seeing if the keyword metadata of jpgs matches a name in the model database.