 |
eupher
Apprentice
Joined: 18 Jan 2001
Posts: 116
Location: USA
|
 Posted: Sat Apr 23, 2011 12:40 am
inserting null values in sqlite
|
This is probably a stupid question... but I'm having trouble figuring out how to specify null values when editing a row in sqlite...
| Code: |
#SQLDB myDB
$query = "SELECT * FROM MyTable"
$row = %sql(myDB,$query)
$row.Item("shouldBeNull") = ######## |
What do I put here to get a null value in that field? I've tried NULL, null, "NULL", "null", 'NULL', and 'null' and all of them give me a string.
I'm running cmud 3.34
Thanks! |
|
|
|
|
Daern
Sorcerer
Joined: 15 Apr 2011
Posts: 809
|
Posted: Sat Apr 23, 2011 12:52 am
|
Try %null.
|
|
|
|
|
eupher
Apprentice
Joined: 18 Jan 2001
Posts: 116
Location: USA
|
Posted: Sat Apr 23, 2011 12:58 am
|
Figured. I'm stupid. That worked. Thanks again. 
|
|
|
|
|
|
|
|
