I have been working with the mysql tutorial and have the communication and database side working fine (it's great) however I am really struggling to work with the data that is received from the Web.GotText 'response content'
I've been meesing with every combination of list block to transform the data into something i can select with an index system (or any way of navigating the table data)
One of the first jobs was to populate a listpicker but have the element name made up of a few columns from the database like job number, site number, location so that would be displayed in the lp elements. (picture attached) the picture is almost what i was aiming for but i wanted to join some text strings in between the data for a prefix e.g. "Location: " [data] "- " "Job No" [data] etc
I cannot find a way of breaking out the response to do this.
I hope that doesn't sound too messy.