I have a SQLite database and i’m using sqlite3 npm module to make it, i have two tables with one column for each one, it’s “userId” and im using them for whitelist/blacklist operations on my project.
When i just use the “SELECT” clause with “*” in the table (like “SELECT * from whitelist) i get the row im searching for, it contains a string with a number that i’m using like an identifier, i’m not using a number datatype because its a big number and its easier for me to not worry about the max safe integer in javascript(I didn’t tried it anyways, but why should i?).
But when i just use the “WHERE” clause to check if a user is on the whitelist (“SELECT * FROM whitelist WHERE userId = “1150608803411275786”;”) I JUST DONT GET ANY ROW AND I DONT KNOW WHY
Inside the code
https://pasteboard.co/QasjZHg7TcN4.png
Using SQLite3 editor
https://pasteboard.co/XjWzgvQyUSUc.png
Same but with WHERE clause
https://pasteboard.co/QvHqjNQC0W26.png
Same but without “”
https://pasteboard.co/pfaCj5WsNUsl.png
I tried it with ” too, i dont know what im doing wrong
Tried with different concatenations like “”, ” or even without them, the data that i’m trying to get exists on the database and i don’t know what to do
Whity is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.