Stack Overflow
Stack Overflow

Questions tagged [contains]

The "contains" operator/method is used to determine if an entity collection contains an element with a particular property.

The contains operator/method is used to determine whether one (or more) of the entities in an entity collection has a particular property.

3008 questions
1
vote
1 answer

Cannot use t-sql contains with short words

I call my statement with CONTAINS function, but sometimes it does not return correct records, e.g. I want to return row which contain in one field word 'Your': SELECT [Email] ,[Comment] FROM [USERS] WHERE CONTAINS(Comment, 'Your') It…
szaman
  • 6,666
  • 13
  • 53
  • 81
1
vote
2 answers

SELECT statement SQL Server (full text) similar to "CONTAINS(column, 'term1 or term 2 or term3') AND NOT (anything else)"

I have a full text search going with the following scenario: I'd like to look for rows containing exactly the terms I have specified, and nothing more. My column looks like: Col1 apples oranges grapes apples oranges …
Rachael
  • 1,965
  • 4
  • 29
  • 55
1
vote
1 answer

How do I match records which have a certain entry IN their rdfs:label attribute?

I'm trying to query dbpedia for programming languages like D by name: http://dbpedia.org/page/D_(programming_language) And I figure rdfs:label is a good way to do this. But I'm having trouble coming up with syntax for searching by labels containing…
mcandre
  • 22,868
  • 20
  • 88
  • 147
1
vote
2 answers

How to Check if a Div is Empty and Then Execute Action

I'm Building a Personal Assistant with HTML5, CSS, & Javascript This is what my current Problem is. I Have a
that contains scripts with the responses for when a Question is asked and if the question matches one it writes that response. I Need…
electrikmilk
  • 1,013
  • 1
  • 11
  • 23
1
vote
4 answers

jQuery contains() - select only the bottom div

OK so I'm trying to use the contains() selector to modify the css of a div. Please see the fiddle: http://jsfiddle.net/6mdqf/ As you can see, the function selects the parent div even though it doesn't directly contain the text "John"; the text is…
harryg
  • 23,311
  • 45
  • 125
  • 198
1
vote
3 answers

need get unique set of keys from Multiple dictionaries

I have 20 dictionaries of that are mostly for the same range of dates (e.g. feb 24-2012 through june 4 2012). Some dictionaries have extra days, and some are missing days. I want an array of all the unique dates being used. …
FistOfFury
  • 6,735
  • 7
  • 49
  • 57
1
vote
1 answer

unable to retrieve a virtual field within a contains container cakephp

I am trying to retrieve a list of id's with a friendly_name (a virtualField in a model), but I keep on getting a unknown column on the virtual field. Any ideas? public $virtualFields = array( 'friendly_name' => "CONCAT(ReAgent.first_name,…
mauzilla
  • 3,574
  • 10
  • 50
  • 86
1
vote
2 answers

jQuery search (:contains) without punctuation excluding specific class

Currently I search within a div within an html file and remove the hideMe class if a result is found inside it, to reveal the found hymn. I'm wondering if I can search the hymn without punctuation (removing punctuation from both input and output),…
Nathan
  • 67
  • 8
1
vote
2 answers

InStr not finding substring

I have the following code: Columns("F:F").Select For Each cell In Selection Select Case cell Case InStr(1, cell, ",") <> 0 MsgBox ("found") Case IsEmpty(cell) Or Null MsgBox ("empty") Case Else …
thedeepfield
  • 6,138
  • 25
  • 72
  • 107
1
vote
1 answer

How to check whether column in table contains any of a set of values?

If I have a set of strings, what SQL statement would determine which of those strings are found in one column of a table? I would want it to return which strings are found, or Null if none are found.
CJ7
  • 22,579
  • 65
  • 193
  • 321
1
vote
2 answers

SQL Contains returns no results

I am trying to upgrade the search on my website. I have stumbled across CONTAINS. I have set the columns that I want to search to FULLTEXT. What am I missing? title = Test is what i'm doing SELECT * FROM test WHERE title LIKE "%Test%" Works…
Steve Payne
  • 612
  • 3
  • 8
  • 16
1
vote
1 answer

Where In clause against nullable field in Linq

How can I write Linq to Entities to make a where in clause similar to one in SQL Server? The issue is that the field I need to search against is nullable int. I have following code, but it returns "Unable to create a constant value of type…
user1588861
  • 13
  • 2
1
vote
2 answers

How can to use fn:contains case-insensitive in JSL EL?

I trying to find out if one string contains another. But, unfortunately, fn:contains function is case-sensitive. Are there are any ways to make it case-insensitive? I tried to put both into one case: fn:contains(car.color.toLowerCase(),…
Don_Quijote
  • 936
  • 3
  • 18
  • 27
1
vote
1 answer

How to create a contains method on two different table with multiple column comparison using sql in vb6

I have (Table1.column1 and Table1.column2) and another (Table2.column1 and Table2.column2) in my db and i wanna get result where (Table1.column1 and Table1.column2) values not found in (Table2.column1 and Table2.column2)? Table1 …
Berker Yüceer
  • 7,026
  • 18
  • 68
  • 102
1
vote
3 answers

check the value of a textbox that whether it contains a particular set of strings or not

I want to check the value of a textbox that whether it contains a particular set of strings or not. How do I do this? (preferably using jquery) I have a textbox where a user enters something. I want to check whether the string he enters contains…
Kaustubh
  • 1,475
  • 2
  • 12
  • 12
1 2 3
…
99 100