3 edited tags
| link
2 deleted 3 characters in body
source | link

My sqlite database has columns which consist of TEXT objects containing spaces. I'm new to both emacs and programming, and while I want to use emacsql for reasons, it's crucial that I can select on string objects containing spaces.

e.g. (emacsql db [:select * :from table1 :where (= name "John Q Doe-Deer")])(emacsql db [:select * :from table1 :where (= name "John Q Doe-Deer")]) doesn't work, and neither does 'John\ Q\ Doe-Deer: they both returned nil even though an analogous query works in command-line sqlite. What am I missing?

My sqlite database has columns which consist of TEXT objects containing spaces. I'm new to both emacs and programming, and while I want to use emacsql for reasons, it's crucial that I can select on string objects containing spaces.

e.g. (emacsql db [:select * :from table1 :where (= name "John Q Doe-Deer")]) doesn't work, and neither does 'John\ Q\ Doe-Deer: they both returned nil even though an analogous query works in command-line sqlite. What am I missing?

My sqlite database has columns which consist of TEXT objects containing spaces. I'm new to both emacs and programming, and while I want to use emacsql for reasons, it's crucial that I can select on string objects containing spaces.

e.g. (emacsql db [:select * :from table1 :where (= name "John Q Doe-Deer")]) doesn't work, and neither does 'John\ Q\ Doe-Deer: they both returned nil even though an analogous query works in command-line sqlite. What am I missing?

1
source | link

Emacsql string query with space

My sqlite database has columns which consist of TEXT objects containing spaces. I'm new to both emacs and programming, and while I want to use emacsql for reasons, it's crucial that I can select on string objects containing spaces.

e.g. (emacsql db [:select * :from table1 :where (= name "John Q Doe-Deer")]) doesn't work, and neither does 'John\ Q\ Doe-Deer: they both returned nil even though an analogous query works in command-line sqlite. What am I missing?