meteor-mssql icon indicating copy to clipboard operation
meteor-mssql copied to clipboard

Using bad column names

Open DanceParty opened this issue 9 years ago • 0 comments

Maybe this is more of a general JavaScript question, I am not sure?

Regardless, I have a column named 'Property Status' and 'Application ID' and I am getting an error when I run the query due to the spaces I assume (syntax related error).

This is the query: "update Property set Property Status=@status where Application ID=@applicationId"

Is there anyway around this?

Thanks!

edit: I have tried using the ${variable_name} syntax but this did not solve the problem.

DanceParty avatar Oct 14 '16 00:10 DanceParty