Hello James,
the SQL statement is not the problem. I over tested it several times and im sure it is bringing everyting.
When I do a count, giving a where clause ='value' it brings me the result 5. when I do a select * it brings me the 5 rows.
running the same statement in react, it brings me 4 rows.
while I was wrinting, i was thinking I never took out the ORDER BY from the react code and never used it on my tests in mysql.
I dont think that's it, but I'll give an shot...
This looks like you're executing 2 different queries. The first is retrieving a list of something and the other is returning the same user multiple times for some reason.
Can you share your queries? I bet you anything there is either middleware causing the issue or the query is just wrong.
What is the SQL statement you’re running and how are you executing it?
Hello James,
the SQL statement is not the problem. I over tested it several times and im sure it is bringing everyting.
When I do a count, giving a where clause ='value' it brings me the result 5. when I do a select * it brings me the 5 rows.
running the same statement in react, it brings me 4 rows.
while I was wrinting, i was thinking I never took out the ORDER BY from the react code and never used it on my tests in mysql.
I dont think that's it, but I'll give an shot...
any other considerations I might be missing?
Thanks!
If it’s not the sql then it’s your Code, not react. Send the snippet you’re using.
This looks like you're executing 2 different queries. The first is retrieving a list of something and the other is returning the same user multiple times for some reason.
Can you share your queries? I bet you anything there is either middleware causing the issue or the query is just wrong.
Honesty not sure what’s happening here, have you got your project in a GitHub repo perhaps with a link to the files you run this in?
James, I found out.
It was on a LIMIT at the final:
Working: LIMIT ${pagina}, 50;
,callback);;not working: LIMIT ${pagina} ,50;
I did removed the LIMIT from not working portion and now is doing what's it supposed to do..
Thanks for your help!