Add 'OR' with AddWhere?

[BD5]

Hi all, I wanted to make a search function where you can type a word in one field, now I use this:

query.AddWhere(CalendarItem.Columns.Description, Comparison.Like, "%" + SearchTextBox.Text + "%");
query.AddWhere(CalendarItem.Columns.Location, Comparison.Like, "%" + SearchTextBox.Text + "%");
 

But then the word has to be in Description AND in Location, but I was wondering, can I make it that the word can be in Description, Or in location, something like the following, but this isn't working!!!!!!

query.AddWhere(CalendarItem.Columns.Description, Comparison.Like, "%" + SearchTextBox.Text + "%" OR CalendarItem.Columns.Location, Comparison.Like, "%" + SearchTextBox.Text + "%");

->Is it also possible to sort this query on for instance 'Date'? (column in database)
I really have no idea how to do this..


Can somebody help me? thank you!

[BD5]

Anybody please? :)

///

[Plater]

I could not find anything on the AddWhere() function not the Comparison.Like in msdn.

Perhaps it would be more helpful if you explained what object-types you were using, since you never said.

Also, is this for a web-application or a windows application? it can make a big difference sometimes.

[BD5]

I could not find anything on the AddWhere() function not the Comparison.Like in msdn.

Perhaps it would be more helpful if you explained what object-types you were using, since you never said.

Also, is this for a web-application or a windows application? it can make a big difference sometimes.

Hi, thanks for your reply!

It is for a web application. About the object types, I am not sure what you mean (I am kind of a newb to ASP, but I am trying :)). If you mean string etc, well Description is of the type ntext, and the other colums the search should be going through are colums, all nvarchar(255) types..

I hope this is what you meant with object type?

[Plater]

What is "query" it's not a string or an int, it's some kind of object. Knowing that would be most helpful.

[BD5]

Hi,

I hope you mean this :):

protected void SearchButton_Click(object sender, EventArgs e)
    {
Query query = CalendarItem.CreateQuery();
 
query.AddWhere(CalendarItem.Columns.Description, Comparison.Like, "%" + SearchTextBox.Text + "%");
query.AddWhere(CalendarItem.Columns.IsPublished, true);
 
LoadAndBindQuery(query);
 
    }
 

[Plater]

Yes, I do not have this "Query" object nor can I find in on msdn.
Maybe someone who has used it before can help, because I can't find any info about it.

[BD5]

I found this about it:

http://www.codeproject.com/cs/databa...eryBuilder.asp


If you look at complex queries, they use this:

query.AddWhere("CustomerID", Comparison.Equals, 
                                   "VINET", 1);
query.AddWhere("OrderDate", Comparison.LessThan, 
                     new DateTime(2005,1,1), 1);
 
// Add first 'Or...' column to level 2
query.AddWhere("CustomerID", Comparison.Equals, "TOMSP", 2);
query.AddWhere("OrderDate", Comparison.LessThan, 
                    new DateTime(2004,6,30), 2);
 

You can see the numbers, I suppose they are different 'layers' in Or statements? I tried to do it this way, adding ,1 and ,2 in my query.Addwhere , but that doesn't work with me..

[Plater]

I always build my queries by hand with a string, the "old school" way.

I cannot find anything in MSDN about "SelectQueryBuilder" either.

Are you using some 3rd party software?

[BD5]

Subsonic..

If you mean that...

[Plater]

It sounds like you would be better off directing your questions to "subsonic" then if they're some thirdparty plugin software.

Subsonic..

If you mean that...

[BD5]

Yeah, but I didn't find a subcategory in this forum..

maybe someone else knows how to deal with this?

[Plater]

There's not a subcatagory because it's a 3rd party software.
I ment you should go talk with the people who made the software.