problem with sql query..

Question

0.00/5 (No votes)

See more:

this query works fine for me..

tring query = "Select * from Products where ProductID in ('" + Request.QueryString["ID"].ToString().Substring(1) +"') AND UnitCost < 5000";

but when i amend it to add some more information. the query doesnot works well. whats the problem with fallowing query

tring query = "Select * from Products where ProductID in ('" + Request.QueryString["ID"].ToString().Substring(1) +"') AND UnitCost < 5000 or ProductID in ('" + Request.QueryString["ID"].ToString().Substring(1) +"') AND UnitCost  5000 and 10000 ";

Posted 28-Dec-11 9:49am

codegeekalpha

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2011-12-28T09:52:00

Solution 1

Most likely you have missed parenthesis and the BETWEEN keyword. Try something like:

C#

string query = "Select * from Products where (ProductID in ('" + Request.QueryString["ID"].ToString().Substring(1) +"') AND UnitCost < 5000) or (ProductID in ('" + Request.QueryString["ID"].ToString().Substring(1) +"') AND UnitCost BETWEEN 5000 and 10000)";

Posted 28-Dec-11 9:52am

Wendelius

Comments

Espen Harlinn 28-Dec-11 16:37pm

5'ed!

Wendelius 28-Dec-11 16:56pm

Thank you Espen :)

theanil 28-Dec-11 17:18pm

5+

Wendelius 28-Dec-11 17:33pm

Thank you theanil :)

problem with sql query..

1 solution

Solution 1

Add your solution here

Preview 0

problem with sql query..

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us