diff options
author | gennyble <gen@nyble.dev> | 2024-12-17 08:56:16 -0600 |
---|---|---|
committer | gennyble <gen@nyble.dev> | 2024-12-17 08:56:16 -0600 |
commit | 7ad63700224f7278c2264cb2312bc795323625a5 (patch) | |
tree | 1fb585db10e14086374528d90c9310d72f7c5682 /served/words/debugging-my-sql-query.html | |
parent | 88c79031efd681aaf96c2148de52221baadc1fb7 (diff) | |
download | ∞-7ad63700224f7278c2264cb2312bc795323625a5.tar.gz ∞-7ad63700224f7278c2264cb2312bc795323625a5.zip |
with misses in html
Diffstat (limited to 'served/words/debugging-my-sql-query.html')
-rw-r--r-- | served/words/debugging-my-sql-query.html | 11 |
1 files changed, 8 insertions, 3 deletions
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 <i>(not great probably, the mutex, but)</i>. 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. -<pre><code>SELECT creation_date, state, game, result FROM awoo;</code></pre> +<pre><code>SELECT creation_date, state, game, result +FROM awoo;</code></pre> <pre><code>Some("no such table: awoo")</code></pre> @@ -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 -<pre><code>SELECT creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2</code></pre> +<pre><code>SELECT creation_date, state, game, result +FROM double_dodge +WHERE player_id = ?1 AND state = ?2</code></pre> those are all columns that exist, even if sqlite does not believe me. oh, i'm not selecting <code>player_id</code>. that's probably not good. -<pre><code>SELECT player_id, creation_date, state, game, result FROM double_dodge WHERE player_id = ?1 AND state = ?2;</code></pre> +<pre><code>SELECT player_id, creation_date, state, game, result +FROM double_dodge +WHERE player_id = ?1 AND state = ?2;</code></pre> <b><i>success :)</i></b> |