The ‘correct’ and best method to parse list got from MySql database is this:
As MySql returns csv table text so you can not directly get its length.You have to parse first in list to get length.
1 Like
The problem is here:
Date got from MySql is CSV Table text so you will have to convert it to list using list from CSV Table text block and then you can use length of list block.
1 Like
But this error was showing when i run querry
you get that error after the result has been returned…
unfortunately you did not provide a complete screenshot of the relevant blocks…
see again the answer from @vknow360
Taifun
2 Likes
I set my block like this.after set my block as @vknow360 then error was not showing. But the querry isn’t running.
can you elaborate on this?
are you saying you click onto Button1 to run the query but you do not get a result?
how many records are in the table?
you might want to display the value returned from the database in a label as test…
Taifun
Yes,you are absolutely right