Seems that my VS2008 help index has finally become FUBAR. It's already a known issue that after installing SQL Books Online 2008 SP1 a lot of inter-topic links break down, but this is even worse. When index entries start pointing to completely unrelated topics and things like "System.Collections.IList namespace" appear - then you know yo...
Hello all i like to browse open source software that are released as public domain type of software license , is there such list ? if i think about it is there some kind of index that sort open source applications by license ? Thanks ...
<select id="sel"> <option value="123" selected="selected">text1</option> <option value="44">text2</option> <option value="882">text3</option> ... </select> How to get the index of selected option with jQuery? May be .index(subject), but all possibilities tested, didn't work... P.S. Indexes: value="123" => 0, value="44" => 1, ... Than...
Hi, I am working on a Rails project and hitting a performance problem. Here is the simplified db schema table gaming_platforms ( ~5 rows) id table games ( ~10k rows) id gaming_platform_id winner (black or white or n/a) black_id => online_players.id white_id => online_players.id table onlin...
I've made a small slideshow script to cycle through a list of images. The problem with it is selecting the current index during the next() and prev() functions. When viewing the slideshow, it performs one too many next()'s resulting in no image being shown for one slide. The index is too high. When click prev(), it seems to sit at 0 ind...
When we declare a parameter as ICollection and instantiated the object as List, why we can't retrive the indexes? i.e. ICollection<ProductDTO> Products = new List<ProductDTO>(); Products.Add(new ProductDTO(1,"Pen")); Products.Add(new ProductDTO(2,"Notebook")); Then, this will not work: ProductDTO product = (ProductDTO)Products[0]; W...
It may looks a naive question but I am wondering about the relationship between primary keys and indexes in most common SQL databases. Is it a standard rule for a SQL database to create automatically an index for every primary key? I am asking that because I am designing a model with Django and I am wondering if it is redundant to set...
Given a (simplified) table CREATE TABLE `transactions` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `CREATION_DT` datetime DEFAULT NULL, `STATUS_IND` int(11) DEFAULT NULL, `COMPANY_ID` bigint(20) DEFAULT NULL, `AMOUNT` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FKE7E81F1ED170D4C9` (`COMPANY_ID`), KEY `RPTIDX_CREATI...
Hello, I have a problem with a stored procedure of a transactional table, the user have a web form to find transactions by several values. The process is taking too long and I don't know how to set proper index. here is my stored procedure: CREATE PROCEDURE dbo.cg_searchTransactions ( @id_Ent tinyint, @transactionTypeID int = ...
i want to make my threads content searchable with full text search engines like solr. but i wonder one thing. should i index just the thread.title, thread.body and post.body or should i index username, created date, nr of posts, views, country, region and city too that belongs to thread? i mean when an user search for a thread he will ...
Say I have a program that searches a database for columns to modify, as part of a database conversion process. If I attempt to alter a column with a functional index defined gives the following error: ORA-30556: functional index is defined on the column to be modified Looking up the ORA code, the solution is to "Drop the functional i...
I currently got two problems I, both about the index of a UITableView I want to change the color of some section-tags in the index, to show that there are new changes within this section. I need to position the index on the left side of the table so it doesn't interfere with the detail disclosure Button Is there a way to realize this...
Hello It may be quite easy to do, but I can't find out how : I want to add a vertical index in my sorted tableViewController, like in the "Contacts" application. Any idea ? Thks Martin ...
I'm trying to drop an index that I have but when I execute the statement it just runs and runs (up to 30 mins before i stopped it last time). Has anyone ever run into this before? Any suggestions on how to free it up for deletion? ...
I am getting a weird exception code. The code that I am trying to use is as follows: do { //blah blah actions. System.out.print("\nEnter another rental (y/n): "); another = Keyboard.nextLine(); } while (Character.toUpperCase(another.charAt(0)) == 'Y'); The error code is: Exception in thread "main" java.lang.StringIn...
Hi all, I have a simple table based queue system. In its simplest form, it consist of an id, a queue name, and a status. When reading the next message from a given queue, we need to ensure FIFO (first in first out), i.e. the lowest id from the given queue with the given status. This all works fine with some thousand rows, but when we re...
How does one generate a set of lists that incorporate the index from a for loop in the list name: for j in range(10): li"j" = [] How can the index 'j' be part of the name, so the lists are li0, li1, li2, ... Thanks! ...
I am working on a site currently (first one solo) and went to go make an index page. I have been attempting to follow django best practices as I go, so naturally I go search for this but couldn't a real standard in regards to this. I have seen folks creating apps to serve this purpose named various things (main, home, misc) and have see...
I've recently been assigned the task of updating a "legacy" database (previously managed by an ex-coworker who left the company a while ago). The new database has the exact same structure as the previous one; the only difference is in the content itself, as this database now has more recent data. The problem is that the old database ha...
I'm trying to do the most efficient select on a table with 3 million records. First some detailed info Table: CREATE TABLE IF NOT EXISTS `activities_index` ( `id` int(9) NOT NULL auto_increment, `activity_id` int(6) NOT NULL, `activity_status_id` int(2) NOT NULL, `activity_source_id` int(6) default NULL, `account_id` int(6) ...