JohnD Active Member Licensed User Longtime User Apr 7, 2014 #1 This question is based on the "Connecting to a MySQL Database Tutorial" - MySQL.bas tutorial project which connects to a DB. When I post json to a php page I get a strange trailing character in my value field. I am trying to send 1 parameter by way of JSON to the server for query processing. I included the project that I used - in JSON_Post.zip, along with the changes marked. Also included is countries_json.zip -> .php, in case you wanted to copy it to the server to test the problem. How do I get rid of this trailing character? Thanks in advance, JD. Attachments JSON_Post.zip JSON_Post.zip 9.5 KB · Views: 285 countries_json.zip countries_json.zip 669 bytes · Views: 270
This question is based on the "Connecting to a MySQL Database Tutorial" - MySQL.bas tutorial project which connects to a DB. When I post json to a php page I get a strange trailing character in my value field. I am trying to send 1 parameter by way of JSON to the server for query processing. I included the project that I used - in JSON_Post.zip, along with the changes marked. Also included is countries_json.zip -> .php, in case you wanted to copy it to the server to test the problem. How do I get rid of this trailing character? Thanks in advance, JD.
JohnD Active Member Licensed User Longtime User Apr 7, 2014 #2 Please delete above post. The error was in my SQL syntax. I single quoted 'id' ~> should be ~> id there was no strange character issue. Upvote 0
Please delete above post. The error was in my SQL syntax. I single quoted 'id' ~> should be ~> id there was no strange character issue.
