Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • I do not know much about MySQL databases and absolute nothing about the Client you use on your Arduino. So my hints are only wild guesses ;-): You did not end the SQL statement with a semicolon. Normally that's not a problem because the client lib does it for you, but this client could be an exception. You define a cursor cur you never use. Perhaps the client lib can only handle one active cursor. You select only one field "Value" but iterate over a list of fields. This is not a problem if the field "Value" exists. Perhaps you could try: "SELECT * FROM Peceras.Parameters;" Commented Mar 16, 2020 at 12:16
  • Thanks Peter, for your response, I have tried your seggestions and I get the same output sadly. The database is just one table with 3 columns and Value is one. I am unsure and thinking it might be to slow to obtain the data when doing the command? out of ideas Commented Mar 17, 2020 at 0:24
  • Sorry I did not realize that you used the Serial interface for the normal Serial to USB comunication and also for the connection to the WIFI shield. That will not work. The program defines a Serial1 that you can use to connect to the Shield, but you have to connect the TX and RX pins of the shield with the pins D2 and D3 of the Arduino with wires. (It's been described in the instructables you linked to) I added an answer, For me it's easier to write code than to write text. ;-) I also did not realize that you close the cursor in the for loop again and again, but you opened it just once. Commented Mar 17, 2020 at 12:03