Link to home
Start Free TrialLog in
Avatar of jtran007
jtran007

asked on

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
Avatar of theGhost_k8
theGhost_k8
Flag of India image

Debug code and print the actual query whats getting executed.
Seems like its not getting required parameters.
What error its giving?
Avatar of jtran007
jtran007

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of jtran007
jtran007

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial