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...
A simple man. I like to build cool things, work with nice people and help others where I can. Currently I'm an engineering manager for a fintech startup and historically a serial founder & freelancer.
Location
München, Deutschland 🇩🇪
Education
The Open University
Work
Engineering Manager @ Deutsche Fintech Solutions GmbH
A simple man. I like to build cool things, work with nice people and help others where I can. Currently I'm an engineering manager for a fintech startup and historically a serial founder & freelancer.
Location
München, Deutschland 🇩🇪
Education
The Open University
Work
Engineering Manager @ Deutsche Fintech Solutions GmbH
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.
A simple man. I like to build cool things, work with nice people and help others where I can. Currently I'm an engineering manager for a fintech startup and historically a serial founder & freelancer.
Location
München, Deutschland 🇩🇪
Education
The Open University
Work
Engineering Manager @ Deutsche Fintech Solutions GmbH
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!