From 7ad63700224f7278c2264cb2312bc795323625a5 Mon Sep 17 00:00:00 2001 From: gennyble Date: Tue, 17 Dec 2024 08:56:16 -0600 Subject: with misses in html --- served/words/debugging-my-sql-query.html | 11 ++++++++--- 1 file changed, 8 insertions(+), 3 deletions(-) (limited to 'served/words/debugging-my-sql-query.html') diff --git a/served/words/debugging-my-sql-query.html b/served/words/debugging-my-sql-query.html index e9f5643..dde57cd 100644 --- a/served/words/debugging-my-sql-query.html +++ b/served/words/debugging-my-sql-query.html @@ -58,7 +58,8 @@ held my database connection (not great probably, the mutex, but). does it just say that if it doesn't think the table is real? surely the table is real. we have so much evidence it is. i changed the table name. -
SELECT creation_date, state, game, result FROM awoo;
+
SELECT creation_date, state, game, result
+FROM awoo;
Some("no such table: awoo")
@@ -68,12 +69,16 @@ i tried removing my where clause. aha! it ran. what's wrong with my where clause? let's look at it again -
SELECT creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2
+
SELECT creation_date, state, game, result
+FROM double_dodge
+WHERE player_id = ?1 AND state = ?2
those are all columns that exist, even if sqlite does not believe me. oh, i'm not selecting player_id. that's probably not good. -
SELECT player_id, creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2;
+
SELECT player_id, creation_date, state, game, result
+FROM double_dodge
+WHERE player_id = ?1 AND state = ?2;
success :) -- cgit 1.4.1-3-g733a5