Calling children of specified index?
Anyone know the proper syntax to write this statement? $('.nav ul li')[0].children("a") For some reason this is not working. The return is that its not a function. :( ...
index
C# - Combobox index change after editing
Hi again, A moment ago someone answered my question on how to edit the combobox loaded with a text file, and how to save the recently edited line. http://stackoverflow.com/questions/3750990/c-real-time-combobox-updating The problem now is that I can only change one letter before it updates, and then the selectedindex changes to -1, so...
How to use an analyzer in compass-lucene search.
How do I add compass analyzer while indexing and searching data in compass.I am using schema based configuration for compass.I want to use StandardAnalyzer with no stopwords.Because I want to index data as it is,without ignoring search terms like AND , OR , IN . The default analyzer will ignore AND , OR , IN from the data I give for inde...
LINQ to XML - how do I obtain index
I have an array of Car objects and using the following piece of code I create an XML Document from these objects. I have set up a counter variable i to be able to index the Car elements in the document. Is there a different way of obtaining the index of the currently processed element? int i = 0; XDocument doc = ...
Lucene .NET fixed filenames in index directory possible?
When building a Lucene .NET index it creates several randomly named files under the root index directory. My question is, is there a way to have these files have a static or fixed name and just overwrite upon re-index, or all be in one file? ...
In MongoDB, if an index is on 3 fields, we can use that index when querying on 2 fields? (wildcard on the 3rd field)
If there is an index on page_type, our_id, date and when querying, db.analytics.find({page_type: 'ingredients', ga_date: {$gte : new Date('Wed Sep 08 2010 12:00:00 GMT-0800')}}) db.analytics.find({page_type: 'ingredients', ga_date: {$gte : new Date('Wed Sep 08 2010 12:00:00 GMT-0800')}}).explain() if our_id is omitted, or da...
Find indices of duplicates in a NSArray
i have an array like [chapter,indent,left,indent,nonindent,chapter,chapter,indent,indent,left]; i need to find indexes of duplicates and also non duplicate elements . how to do this...........give some sample code or logic...... thanks in advance iam using objective c..... NSArray *myWords = [string componentsSeparatedByString:@...
IndexOutofRange Exception at pkey
I get below error in follwoing code.Any ideas? Exception of type 'System.Web.HttpUnhandledException' was thrown. pKey at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at ReadyCo...
CANNOT create unique index in SQL Server, how to know what index is the index ID referring to
I have a script that gives an error when being executed: Msg 1505, Level 16, State 1, Server CBR07I300FVA1, Line 1 CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 17. Most significant primary key is '44'. The statement has been terminated. The script contains thousands of lines of queries so I have no idea...
Why does select statement influence query execution and performance in MySQL?
I'm encountering a strange behavior of MySQL. Query execution (i.e. the usage of indexes as shown by explain [QUERY]) and time needed for execution are dependent on the elements of the where clause. Here is a query where the problem occurs: select distinct e1.idx, el1.idx, r1.fk_cat, r2.fk_cat from ent e1, ent_leng el1, rel_c r1, _tax_...
How to use Oracle Indexes
I am a PHP developer with little Oracle experience who is tasked to work with an Oracle database. The first thing I have noticed is that the tables don't seem to have an auto number index as I am used to seeing in MySQL. Instead they seem to create an index out of two fields. For example I noticed that one of the indexes is a combinati...
How to use index efficienty in mysql query
Hi: My db is running on mysql v5.x. I have a table T1 with 5 columns and column C1 is the primary key. C1 is of type varchar(20). It contains about 2000 rows with values like: fxg axt3 tru56 and so on.. Now my application's job is to read input data and find if the input data has a starting pattern similar to that found in column C1...
ActionScript - Retrieving Index Of Specific Filter
i have a few filters on a sprite. on mouse over i would like to access one of the filters in the filters array, but i'm having a bit of trouble trying to accomplish this. mySprite.filters = [new DropShadowFilter(), new GlowFilter(), new BlurFilter()]; mySprite.addEventListener(MouseEvent.MOUSE_OVER, mouseOverEventHandler); function mo...
How can I compare a variable to a MySQL full-text index without a gigantic loop?
Let's say I've got two tables: NOTES has two columns: ID and BODY. BODY is a FULLTEXT index. KEYWORDS has two columns: ID and KEYWORD. I want to search every BODY for every KEYWORD and get one row for each match, the NOTES.ID and the KEYWORD.ID. So if there were 15 notes and each one matched 3 keywords, I would get 45 rows. But as ...
How do I remove elements at a set of indices in a vector in MATLAB?
I have a vector with 100 elements. I have another vector with index positions of elements I want to remove from this vector. How do I do this? ...
jquery - append indexed input fields depending on value of other input
I have a group of indexed input fields that contain an autocomplete text field that returns a list of names found in the database. The user can add as many "groups" as they need to, with each "group" containing a set of incremented indexed input fields. If the user begins typing, however, and ultimately enters a name that isn't found i...
UNIQUE argument for INDEX creation - what's for?
Why does INDEX creation statement have UNIQUE argument? As I understand, the non-clustered index contains a bookmark, a pointer to a row, which should be unique to distinguish even non-unique rows, so insuring non-clustered index to be unique ? Correct? So, do I understand that no-unique index can be only on clustered table? since ...
what is index and can non-clustered index be non-unique?
Subquestion to my question [1]: All definitions of (MS SQL Server) index (that I could find) are ambiguous and all explanations, based on it, narrate something using undefined or ambiguously defined terms. What is the definition of index? For ex., the most common definition of index from wiki (http://en.wikipedia.org/wiki/Index_(d...
Diff on SQL Server XML Data Type?
I have an automated process that inserts an XML document into SQL Server 2008 table, the column is of Type XML. There is a lot of duplicated data, I wonder if anyone can recommend a good way to delete non-distinct values based on the XML column? The table has thousands of rows and each XML document is about 70k. Each XML document looks ...
When SQL Server bcps into an empty table with an index what does it do internally?
If I have an empty table with an index and I do a bcp, does SQL Server (internally) drop/disable the index, load the data and then re-apply/enable/build the index? ...