OleDbCommand cmdpic = new OleDbCommand
("select * from sub_category where id_s="
+ Request.QueryString["id_s"]
+"or"+"order by sub_id desc", concars);
it shows error
what is the correct command
views:
36answers:
3
A:
Hi,
OleDbCommand cmdpic = new OleDbCommand
("select * from sub_category where id_s="
+ Request.QueryString["id_s"]
+" or "+"order by sub_id desc", concars);
I believe you forgot spaces in the "Or"
And providing the error message is of course very helpful :)
Edit: It appears you should remove the OR indeed.
Trefex
2010-07-07 13:14:01
"select * from sub_category where id_s=" + Request.QueryString["id_s"] + "or" + "order by sub_id desc"its not working please give me correct command
azeem
2010-07-07 13:22:49
i am success to do it "select * from sub_category where id_s=" + Request.QueryString["id_s"] + " order by sub_id desc
azeem
2010-07-07 13:32:16
Yep, removing the OR does the trick.
Trefex
2010-07-07 14:37:11
A:
Request.QueryString["id_s"]
+"or"+"order by sub_id desc"
You have no spaces in there. Try this:
OleDbCommand cmdpic = new OleDbCommand
("select * from sub_category where id_s="
+ Request.QueryString["id_s"]
+" or "+"order by sub_id desc", concars);
fire.eagle
2010-07-07 13:14:23
it shows error Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'id_s=10ororder by sub_id desc'.Source Error:
azeem
2010-07-07 13:20:37
Are you sure you subbed in the command at the bottom of what I wrote? That error message still shows the query as having no spaces in it.
fire.eagle
2010-07-07 13:27:25
+2
A:
Actually, I think the real error was putting in the OR in the first place. The missing spaces would have caused a problem, but that was invalid syntax anyway -- select x from y where a=b or order by z is not valid in any SQL I have heard of.
MJB
2010-07-07 13:36:44