Sqlite and fields with a space int them

Getting Started Newbie Questions
#1

I am trying to load values from a table in a SQLite database but one of the fields (zip code) has a space in it.  How can I access that field?

Normally, I would do temp = row.fieldname but row.field name won’t work.  I know in SQL you would just wrap that in brackeys [field name] but how do you do it in corona?

Thanks!

#2

I think you may need quotes around it:   sometable[“some field”]

Rob

#3

I think you may need quotes around it:   sometable[“some field”]

Rob