Search Results

Search found 1421 results on 57 pages for 'distinct'.

Page 23/57 | < Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >

• Can I create an ASP.NET MVC 2 project with multiple areas without referencing each Child in the pare

  - by No Refunds No Returns

  This is a follow-up question to my original query: http://stackoverflow.com/questions/1791605/how-can-i-use-multiple-projects-to-separate-a-large-asp-net-mvc-site-into-departm Now that I have this working, is there a way to still have multiple project but not have to reference each child area from the parent project? Ideally I'd like to be able…

  Read the article

• Advanced SQL query with lots of joins

  - by lund.mikkel

  Hey fellow programmers Okay, first let me say that this is a hard one. I know the presentation may be a little long. But I how you'll bare with me and help me through anyway :D So I'm developing on an advanced search for bicycles. I've got a lot of tables I need to join to find all, let's say, red and brown bikes. One bike may come in more then…

  Read the article

• how do twisted/tornado et cetera work

  - by aharon

  I understand that they work in some way distinct from making a thread per user. How exactly does that work? (Does 'non-blocking' have something to do with it?)

  Read the article

• What is the most efficient way to determine if a directed graph is singly connected?

  - by zebraman

  I am working on an assignment where one of the problems asks to derive an algorithm to check if a directed graph G=(V,E) is singly connected (there is at most one simple path from u to v for all distinct vertices u,v of V. Of course you can brute force check it, which is what I'm doing right now, but I want to know if there's a more efficient…

  Read the article

• Extract log file

  - by k38

  Hi, xxxxxxxxmessageyyyyyyymessagexxxxxxxxxx xxxxxxxxmessagezzzzzzzmessagexxxxxxxxxx xxxxxxxxmessageaaaaaaamessagexxxxxxxxxx xxxxxxxxmessageyyyyyyymessagexxxxxxxxxx The above is my log file I need to extract the phrase which is inside the message tag and I need to save the distinct messages in a file in the above example I need to save…

  Read the article

• Deleting Duplicates in MySQL

  - by elmaso

  Query was this: CREATE TABLE `query` ( `id` int(11) NOT NULL auto_increment, `searchquery` varchar(255) NOT NULL default '', `datetime` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM first I want to drop the table with: ALTER TABLE `querynew` DROP `id` and then delete the double entries.. I tried it with: INSERT…

  Read the article

• How to specifically identify server issues from a load test result (using LoadRunner)?

  - by Bash

  How do you isolate a performance issue to a specific component of the application infrastructure? Specifically, are there distinct markers in the result logs that distinguish between bottlenecks at web, application and/or database server levels? I was asked this question in an interview and went blank on it. Seems this information is…

  Read the article

• SQL join produces one result only

  - by Rami

  Can anyone please tell me why this result is generation only one results? taking in mind that everything is set right and the three tables are populated correctly, i took out the group_concat and it worked but of course with a php undefined index error! SELECT `songs`.`song_name`, `songs`.`add_date`, `songs`.`song_id`,…

  Read the article

• How to use group by and having count in Linq

  - by Luke

  I am having trouble trying to convert the following query from SQL to Linq, in particular with the having count and group by parts of the query: select ProjectID from ProjectAssociation where TeamID in ( select TeamID from [User] where UserID in (4)) group by ProjectID having…

  Read the article

• Split comma separated string to count duplicates

  - by josepv

  I have the following data in my database (comma separated strings): "word, test, hello" "test, lorem, word" "test" ... etc How can I transform this data into a Dictionary whereby each string is separated into each distinct word together with the number of times that it occurs, i.e. {"test", 3}, {"word", 2},…

  Read the article

• ActiveRecord WHERE NOT EXISTS

  - by jspooner

  Is there a way to use EXISTS with ActiveRecord besides find_by_sql? I'd like a nice way to find all records without an association in a One-to-Many relationship. SELECT DISTINCT store_type FROM stores WHERE NOT EXISTS (SELECT * FROM cities_stores WHERE cities_stores.store_type =…

  Read the article

• How do I combine 3 date columns from 3 tables in Foxpro sql?

  - by Tass-man

  I am writing a foxpro sql & need to combine three date columns from three different tables into a new date column. As an example if the three tables are A,B,& C and the date Columns are Adate, Bdate and Cdate, how do I combine them as distinct and separate dates into a column called TransDate…

  Read the article

• MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

  - by user198729

  SELECT u.id AS u__id, u.username AS u__username, p.id AS p__id, p.phonenumber AS p__phonenumber, p.user_id AS p__user_id FROM user u INNER JOIN phonenumber p ON u.id = p.user_id WHERE u.id IN (SELECT DISTINCT u2.id FROM user u2 INNER…

  Read the article

• number of comparisons of binary search

  - by user307496

  What is the total number of comparisons necessary to locate all the n sorted distinct integers in an array using binary search, I think it is nlogn, but I am not sure. What do u guys think?

  Read the article

• Why "Finalize method should not reference any other objects" ?

  - by mishal153

  I have been pondering why it is recommended that we should not release managed resources inside finalize. If you see the code example at http://msdn.microsoft.com/en-us/library/system.gc.suppressfinalize.aspx , and search for string "Dispose(bool disposing) executes in two distinct scenarios" and…

  Read the article

• Continuous Form, how to add/update records with external connection

  - by Mohgeroth

  EDIT After some more research I found that I cannot use a continuous form with an unbound form since it can only reference a single record at a time. Given that I've altered my question... I have a sample form that pulls out data to enter into a table as an intermediary. Initially the form is…

  Read the article

• How to create different asp.net User Profiles

  - by Gianluca RIcceri

  Is possible define different profiles a the same time? I have two type of users in my web site and they have different properties. Using asp.net profile is possible to define two or more profiles with distinct properties?

  Read the article

• Normalizing Item Names & Synonyms

  - by RabidFire

  Consider an e-commerce application with multiple stores. Each store owner can edit the item catalog of his store. My current database schema is as follows: item_names: id | name | description | picture | common(BOOL) items: id | item_name_id | picture | price | description | picture…

  Read the article

• Trying to understand the usage of class_eval

  - by eMxyzptlk

  Hello everyone, I'm using the rails-settings gem, and I'm trying to understand how you add functions to ActiveRecord classes (I'm building my own library for card games), and I noticed that this gem uses one of the Meta-programming techniques to add the function to the…

  Read the article

• How do I optimize this query?

  - by InnateDev

  SELECT DISTINCT wposts.* FROM wp_2_posts wposts, wp_2_postmeta wpostmeta, wp_2_postmeta wpostmeta1, wp_2_term_taxonomy, wp_2_terms, wp_2_term_relationships WHERE wposts.ID = wpostmeta.post_id AND wp_2_terms.term_id = '8' AND wp_2_term_taxonomy.term_id =…

  Read the article

• Is there something like clock() that works better for parallel code?

  - by Jared P

  So I know that clock() measures clock cycles, and thus isn't very good for measuring time, and I know there are functions like omp_get_wtime() for getting the wall time, but it is frustrating for me that the wall time varies so much, and was wondering if there was some…

  Read the article

• I really want to use Xapian on a project, but for the life of me I can't figure out how to install i

  - by Sean

  If this was on a linux box I'd be set, but there's a distinct lack of documentation! I want to use this with c# and the omega indexing app. There doesn't seem to be any documentation on how to actually BUILD xapian & omega on windows (or, pre-compiled binaries…

  Read the article

• Using DefaultIfEmpty in Linq - problem substituting a null value for a default value

  - by FiveTools

  I have questions that may or may not have a question_group if all the questions do not have a question_group and if I use default if empty like this: question_group defaultQuestion = new question_group {question_group_id = Guid.Empty}; questions.Select(x =>…

  Read the article

• Help with Query - Access

  - by yae

  Hi I have 4 tables: machines, categories, users and usersMAchines machines is linked to categories and usersMachines. Machines -------- idMachine machine idCat Categories -------- idCat category Users -------- idUser nameUser UsersMachines --------…

  Read the article

• i m doing paginnation meanwhile i want to select all element of a particular coloumn,but i m getting

  - by vivek

  var vals = new Array();     var i=0;     var options='';     jQuery('#SearchResultsTable123 tr:gt(0) td:nth-child(2)').each(function(){       var t=jQuery(this).html();…

  Read the article

< Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >