Parameterized SQL statement: Difference between revisions
Content added Content deleted
mNo edit summary |
|||
| Line 344: | Line 344: | ||
name = "Smith, Steve" |
name = "Smith, Steve" |
||
jerseys = Dict("Smith, Steve" => |
jerseys = Dict("Smith, Steve" => 99) |
||
BOOL(tf) = if(tf) "TRUE" else "FALSE" end |
BOOL(tf) = if(tf) "TRUE" else "FALSE" end |
||
| Line 356: | Line 356: | ||
jerseynum integer)") |
jerseynum integer)") |
||
SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James', 9, 'FALSE', |
SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James', 9, 'FALSE', 99)"); |
||
SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?"; |
SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?"; |
||
| Line 369: | Line 369: | ||
│ Row │ id │ name │ score │ active │ jerseynum │ |
│ Row │ id │ name │ score │ active │ jerseynum │ |
||
├─────┼────┼────────────────┼───────┼────────┼───────────┤ |
├─────┼────┼────────────────┼───────┼────────┼───────────┤ |
||
│ 1 │ 1 │ "Smith, Steve" │ 42 │ "TRUE" │ |
│ 1 │ 1 │ "Smith, Steve" │ 42 │ "TRUE" │ 99 │ |
||
</pre> |
</pre> |
||