thid query How to use OR

[tenvick]

I want to run sql like this \"select * form Stick where StickID=1 or ParentID=1\"

How Can I do this in EasyObject?

Stick obj = new Stick();
obj.Where.StickID.Value = StickID;
obj.Where.ParentID.Value = StickID;
obj.Query.Load();

[mgnoonan]

Easy enough!

Code: Select all

Stick obj = new Stick();
obj.Where.StickID.Value = StickID;
obj.Where.ParentID.Value = StickID;
obj.Query.Load(\"OR\");

[tenvick]

thanks mgnoonan .
but I got a real problem.
I want to run sql \"select * from news where keyword like '&key1&' or keyword like '%key2%' or keyword like '%key3%' ... \"

how can I do ?

I write like this

CateNewsView obj = new CateNewsView();
foreach (string key in keywords)
{
if (key != string.Empty)
{
obj.Where.KeyWords.Value = \"%\" + key + \"%\";
obj.Where.KeyWords.Operator = NCI.EasyObjects.WhereParameter.Operand.Like;
obj.Where.KeyWords.Conjunction = NCI.EasyObjects.WhereParameter.Conj.Or;

}
}

obj.Query.Load();
return obj.DefaultView;
but it doesnt right .it only one KeyWords

[dnparsons]

It's been a while since I've looked at EasyObjects (or DOOdads, for that matter), but if you need to use the same column more than once in a Where condition, I think you'll need to use a TearOff.

http://www.mygenerationsoftware.com/php ... .php?t=107

[tenvick]

can you give me a example?