Timeline for Arduino MySQL Connector Issues with Select only
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 15, 2020 at 10:03 | history | bumped | Community Bot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 17, 2020 at 10:01 | history | bumped | Community Bot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 17, 2020 at 12:03 | comment | added | Peter Paul Kiefer |
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.
|
|
| Mar 17, 2020 at 12:02 | answer | added | Peter Paul Kiefer | timeline score: 1 | |
| Mar 17, 2020 at 0:24 | comment | added | Francis Manuel Astley Richmond | 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 | |
| Mar 16, 2020 at 12:16 | comment | added | Peter Paul Kiefer |
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;"
|
|
| Mar 16, 2020 at 2:30 | review | First posts | |||
| Mar 16, 2020 at 4:13 | |||||
| Mar 16, 2020 at 2:29 | history | asked | Francis Manuel Astley Richmond | CC BY-SA 4.0 |