• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

mysql "select abc from mytable where item=abc order by sale desc limit 3

In the command line, I test this sql statement it is working.
but the same statement, somehow in my C# web page it is
not working.
I attache here my code
TextFile1.txt
0
jtran007
Asked:
jtran007
  • 2
1 Solution
 
K VDatabase ConsultantCommented:
Debug code and print the actual query whats getting executed.
Seems like its not getting required parameters.
What error its giving?
0
 
jtran007Author Commented:
I debug and check the statement .it's ok even I try on command line. its' working.
There is no error , but the query gives me more than 4 values (...limit 4) I expected.
0
 
jtran007Author Commented:
I found the error while i increment index twice . That's why I's skiiped data.
Thanks,
JT
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now