Canvas query: COUNT of field

in canvas, I am using query as:

SELECT COUNT("My Field Name") FROM "index*"

It shows error when there is space in "My Field Name".
Any idea how the space should be handled?

I thought wrapping it in single or double quotes is how. Are you putting the double quotes up there to point attention to the field name or you actually using them in the query?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.