How does contains() in PL-SQL work?
Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or something else. It is hardcoded and couldn't be changed. ...
contains
jQuery :contains(unicode_characters)
I have an element like this: <span class="tool_tip" title="The full title">The ful…</span> This seems to work: jQuery('span:contains(…)'); But this does not: jQuery('span:contains(…)'); I am pretty sure that it would be bad to use the first one because if someone else saves the file, or the browser decides to get the...
Java List with Objects - find and replace (delete) entry if Object with certain attribute already exists
Hi there I've been working all day and I somehow can't get this probably easy task figured out - probably a lack of coffee... I have a synchronizedList where some Objects are being stored. Those objects have a field which is something like an ID. These objects carry information about a user and his current state (simplified). The point...
Linq help using "Contains"
Good Morning All, I'm trying to use "Contains" to see if an object is within the collection. When I break I can see that the object is indeed part of the collection however "Contains" seems to be returning false indicating the item is not in the collection. Any idea what I'm doing wrong? if(HttpContext.Current.Session["AutoPayTypes"] !...
SQL Server CONTAINS with digits gives no results
Hi, I have a database table which is full-text indexed and i use the CONTAINS-function to perform a search-query on it. When I do: SELECT * FROM Plants WHERE CONTAINS(Plants.Description, '"Plant*" AND "one*"'); I get back all correct results matching a description with the words "Plant" and "one". Some plant are named like "Plant 1...
nhibernate activerecord linq Contains problem
Hi, I am having problems with the following query in Castle ActiveRecord 2.12: var q = from o in SodisceFMClientVAR.Queryable where taxnos2.Contains(o.TaxFileNo) select o; taxNos2 is an array of strings. When run I get an exception: + InnerException {"Index was out of range. Must be non-negative and ...
Trying to use contains selector within nested divs
<div> <div>test</div> </div> $("div:contains('test')").css('display','none'); I know I am going to kick myself on this. The problem is that when this runs all divs are hidden due to nesting. How do I make it so that the parent div does not get hidden? I am limited to using 1.2.6 ...
Wildcard query expansion resulted in too many terms.
I am receiving a "wildcard query expansion resulted in too many terms" error when executing a query similar to the following: SELECT * FROM table_a WHERE contains(clob_field, '%a%') > 0; Does anyone know a workaround/solution to this problem? ...
How to use Contains() in my join
I am trying to get my linq query to replicate my t-sql but I am lost. SELECT * FROM BaiDetail INNER JOIN BaiDetailMap ON BaiDetail.DetailText LIKE '%' + BaiDetailMap.BaiDetailMapSearchText +'%' This is what I have so far... but no go from det in Source from map in Map where det.DetailText.Contains(map.SearchText) select ne...
.Contains on a list of custom class objects
Hello, I'm trying to use the .Contains function on a list of custom objects This is the list: List<CartProduct> CartProducts = new List<CartProduct>(); And the CartProduct: public class CartProduct { public Int32 ID; public String Name; public Int32 Number; public Decimal CurrentPrice; /// <summary> /// ...
Problem with Contains
Hello there, I have a little problem which i can't solve. I want to use an SQL-In-Statement in Linq. I've read in this Forum and in other Forums that I have to use the .Contains (with reverse-thinking-notation :-)). As input i have a List of Guids. I first copied them into an array and then did something like that : datatoget = (from p...
linq like empty string
var list = (from i in _dataContext.aspnet_Users.Include("aspnet_Membership") where i.UserName.Contains(userName) select i ).ToList(); if userName="" then nothing return. how can i do that if empty string then return all records? ...
SQL search for containing terms
Hi, If it possible to search in a table for records of which its name contains a search term? Thanks ...
Extract item in a list if Contains returns true
I have two lists A and B, at the beginning of my program, they are both filled with information from a database (List A = List B). My program runs, List A is used and modified, List B is left alone. After a while I reload List B with new information from the database, and then do a check with that against List A. foreach (CPlayer play...
Deep containing and paginating in Cakephp
My Database is formed like this: Recipient belongs to a Distribution, Admin HABTM Distribution Now, when I want to find all the Distributions for which I am an Admin I do as follows: $userid = $this->Session->read('Auth.User.id'); $meineListen = $this->find('all',array( 'contain' => array( 'Recipient' => array( 'id' ), 'A...
jquery contains with class
I'm using jQuery :contains selector to filter through some link tags. The following code works great. $('a:contains("string")').each(function(i){ //do some stuff }); I'd like only run this function if the anchor tags are inside a specific class, I've tried the following but it does not appear to work: $('.my_class a:contains("string...
Can someone explain this javascript code to me?
var vTableExp = "//a[contains(@href,'newdid')]/ancestor::td/ancestor::tr/ancestor::tbody"; var vTable = dom.find(vTableExp, XPFirst); thanks ...
Problem with ranking of search results in SharePoint 2007 if using the CONTAINS predicate
While writing a front-end for the SharePoint Search web service for work, I did some quick testing with the MOSS Search Tool to make sure things were working right under the hood. What I found was that queries composed only of CONTAINS predicates (FREETEXT ones were fine) would have a rank of 1000 for any results that were returned. Acc...
collection/string .Contains vs collection/string.IndexOf
Is there a reason to use .Contains on a string/list instead of .IndexOf? Most code that I would write using .Contains would shortly after need the index of the item and therefore would have to do both statements. But why not both in one? if ((index = blah.IndexOf(something) >= 0) // i know that Contains is true and i also have the ...
Problem with excluding conditions in complex cakephp model
I'm fairly new to cakephp and I'm having a problem with a complicated find function on my models. I have a number of Groups each containing a number of Users, and each group can make a number of Orders. Each order consists of a number of OrderAmounts which contain an amount and a user_id (relating to a User). I have a find which finds ...