I'm trying to output the results of a query as a csv file using mongoexport. The query runs fine, here's a sample of the output:

> db.discussions.find({},

{subject:1,number_of_comments:1}

)

{ "_id" : ObjectId("4d094991516bcb9029000002"), "number_of_comments" : 1, "subject" : "APH10132614" } { "_id" : ObjectId("4d094992516bcb9029000004"), "number_of_comments" : 5, "subject" : "APH10112880" } { "_id" : ObjectId("4d094992516bcb9029000006"), "number_of_comments" : 1, "subject" : "APH10067253" } { "_id" : ObjectId("4d094992516bcb9029000008"), "number_of_comments" : 0, "subject" : "APH10042670" } { "_id" : ObjectId("4d094992516bcb902900000a"), "number_of_comments" : 25, "subject" : "APH10042299" }

I figured this would be an easy one to output as csv since it's already in that sort of format, but this is what happens when I attempt to in mongoexport:

[911]galloway@host1 ~/mongodb-linux-x86_64-2.0.6/bin> ./mongoexport -d sellers-ph-production_190512 -c discussions -q '

{subject:1,number_of_comments:1}

' -f _id,subject,number_of_comments --csv >startable3.csv
connected to: 127.0.0.1
exported 0 records
[912]galloway@host1 ~/mongodb-linux-x86_64-2.0.6/bin>

My best guess is that I'm missing some sort of syntax when writing the query portion here, but I haven't seen many examples of this so I don't know what is wrong. Any advice is appreciated!