Jump to content
  • 0

invalid column name?



I am using swagger, and performing get , for records,
in the q.where (where clause) field, if i put


(156 is row number)

(code looks like  this)

and execute, the resposne is 200 with, 

  "Result": [
"PK_ID": 156,
      "created_by": "",
      "last_modified_by": "",
      "submitted_by": "",
      "patient_id": "mySpecABCD"

however, i want to do where patient_id = mySpecABCD

i change the q.where to




i receive error stating

 "Code": "SqlServerError",
  "Message": "Invalid column name 'mySpecABCD'

i add additional quotations 

 "Code": "SqlServerError",
  "Message": "Invalid column name ''mySpecABCD''

what am i doing wrong?

Edited by aaronthesoftwaremechanic
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...