diff options
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> |