sql
sql
ojs
sql
ojs
sql
ojs
ojs
ojs
ojs
ojs
ojs
sql
ojs
ojs
ojs
ojs
ojs
ojs
Comments (2)
George Tang
Sep 19, 2023How would you do this with the SQL IN operator to select multiple nationalities?
... WHERE artists.Nationality IN (${selectNationality}) ...
observable seems to surround javascript strings with quotes when converting to sql, and it does the same thing for lists, but then the query doesn't work, because lists have a sequence of quotes, and I've been tinkering with it, but haven't gotten it to work.
On another note, are you aware of any forum for observableHQ to escalate questions?
Paul Buffa
Sep 19, 2023Hey George,
You could pass in an array, like how this notebook handles it, for doing multiple values at once: https://observablehq.com/@observablehq/mix-queries-and-arrays-into-sql?collection=@observablehq/observable-tips-and-tricks
And yes! There is a forum that is a great spot to ask these sorts of questions. https://talk.observablehq.com/