Search Results

Search found 8547 results on 342 pages for 'hash join'.

Page 40/342 | < Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >

• Left Outer Join on Many-to-One Mapping

  - by Colin Bowern

  I have a reference to call that may or may not be there. When I add the nullable option it still doing Inner Join when I want an Outer Left Join (show the left even if the right is null). Is this possible in the NH map? References(x => x.DefaultCategory, "CATEGORY_ID") .Nullable();

  Read the article

• Hibernate custom join clause on association

  - by myso

  I would like to associate 2 entities using hibernate annotations with a custom join clause. The clause is on the usual FK/PK equality, but also where the FK is null. In SQL this would be something like: join b on a.id = b.a_id or b.a_id is null From what I have read I should use the @WhereJoinTable annotation on the owner entity, but I'm puzzled…

  Read the article

• How can I write Join statements on dataset..

  - by Preetham

  How can I write Join statements on dataset.. I have data in xml format..I can load that data into a dataset.. but how do i fetch data from two datatables using a join query

  Read the article

• innerJoin query show error

  - by Chithri Ajay

  just i print the two table data so i am using inner join SELECT sd.GameName FROM LottoryTickets AS sd JOIN group AS p ON sd.Group = p.groupname WHERE p.groupname = 11 now i get #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group AS p ON…

  Read the article

• Doctrine join enitiy or null

  - by Medvedev

  I have an entity Entity\User with avatar: /** * @ORM\OneToOne(targetEntity="Entity\Avatar", cascade={"remove"}, fetch="LAZY") */ protected $avatar; And Entity\Message entity /** * @ORM\ManyToOne(targetEntity="Entity\User") */ protected $user; When i try to load all messages with users and avatars. But not all user have avatar. …

  Read the article

• unique hash of string

  - by Aly

  Hi, I want to create a unique hash (16 chars long) of an arbitrary length String. Is there a good library that implements MD5 or SHA-1 for C++ with which I can achieve this? (and possibly an example of how to use it)

  Read the article

• INNER JOIN keywords | with and without using them

  - by cedar715

  SELECT * FROM TableA INNER JOIN TableB ON TableA.name = TableB.name SELECT * FROM TableA, TableB where TableA.name = TableB.name Which is the preferred way and why? Will there be any performance difference when keywords like JOIN is used? Thanks

  Read the article

• MySQL join problem

  - by snaken

  Whats wrong with this SQL? It should return results but returns nothing SELECT `pid` FROM `products` LEFT JOIN `prods_to_features` ON (`ptf_pid` = `pid`) WHERE (`ptf_id` = '66' OR `ptf_id` = '67') AND (`ptf_id` = '76') Is it not possible to have the 2nd where clause for the table that has been used in the left join?

  Read the article

• MySQL doesn't use index in join query

  - by Kocsonya Laci

  I have two tables: comments(id(primary key), author, ip(index)) and visitors(id(primary key), date_time, ip(index)) I want to join them like that: SELECT visitors.date_time FROM comments LEFT JOIN visitors ON ( comments.ip = visitors.ip ) WHERE comments.author = 'author' LIMIT 10 It works, but very slow.. In EXPLAIN it shows that it…

  Read the article

• Hash Table v/s STL map in C++

  - by anon

  Hi, I am trying to learn C++ maps. Was just wondering about the implementation of STL map. I read it employs Binary search tree. Is there a implementation of hash table in STL? How exactly do STL map stores Key Value pairs?

  Read the article

• MySQL search for user and their roles

  - by Jenkz

  I am re-writing the SQL which lets a user search for any other user on our site and also shows their roles. An an example, roles can be "Writer", "Editor", "Publisher". Each role links a User to a Publication. Users can take multiple roles within multiple publications. Example table setup: "users" : user_id, firstname, lastname…

  Read the article

• NHibernate join and projection properties

  - by devgroup

  Hello, I have simple situation (like on the image link text) and simple SQL query SELECT M.Name, A.Name, B.Name FROM Master M LEFT JOIN DetailA A ON M.DescA = A.Id LEFT JOIN DetailB B ON M.DescB = B.Id How to achive the same effect in nHibernate using CriteriaAPI ?

  Read the article

• Do hash functions exist in nature?

  - by Klerk

  Given that there are quite a few bioinformaticians around these days, wondering if any of you have seen examples of hash functions (or mapping mechanisms) occuring in nature? And if so how does they work?

  Read the article

• HQL query to join 2 tables with the same key

  - by kawtousse

  Hi everyone Iam trying to this in HQL: select A.a A.a1, B.b,B.b1 from A,B where A.x=B.x; It is simple to realize the join with sql but when returninig in HQL I find a problem. would you please give me the HQL syntax for the join Thanks for help.

  Read the article

• Using a Hash table

  - by Maria Attard

  I have 2 lists in my program one that store objects of type student and another one which stores objects of type marks. I have 3 methods one that inputs the details of the students, one that inputs the marks and one to view student details and their marks. My question is how I can use a hash table to get the Id of a student and…

  Read the article

• Ordered hash in JavaScript

  - by hekevintran

  JavaScript objects have no order stored for properties (according to the spec). Firefox seems preserve the order of definition of properties when using a for...in loop. Is this behaviour something that I can rely on? If not is there a piece of JavaScript code somewhere that implements an ordered hash type?

  Read the article

• Hash Tables - Java

  - by Antony

  Am about to do a homework, and i need to store quite a lot of information (Dictionary) in a data structure of my choice. I heard people in my classroom saying hash-tables are the way to go. How come?

  Read the article

• Good resource for explaining how hash codes are used in collections

  - by Michael

  Hi, Can anyone give a good explanation and / or links to a good resource of how hash codes are used in storing and retrieving objects in hashtables, dictionaries etc, specifically in C# / .NET. I'm interested to see how Equals and GetHashCode are used collectively when storing and retrieving items.

  Read the article

• Mysql filling in missing dates

  - by bsandrabr

  I have the following query SELECT * FROM attend RIGHT OUTER JOIN noattend ON attend.date = noattend.date2 WHERE attend.date BETWEEN '2010-02-01' AND '2010-04-01' AND attend.customerid =1 ORDER BY date DESC LIMIT 0 , 30 Attend is the table with customerid noattend is the table with a row for each date (date2) I followed the…

  Read the article

• Java getQueryString() doesnt return hash value to me

  - by Parhs

  I am using java ee and request.getQueryString() doesnt return the #hashpart my/page?id=4#hash I am using Struts 2 Is there any solution?

  Read the article

• Difference between "and" and "where" in joins

  - by Midhat

  Whats the difference between SELECT DISTINCT field1 FROM table1 cd JOIN table2 ON cd.Company = table2.Name and table2.Id IN (2728) and SELECT DISTINCT field1 FROM table1 cd JOIN table2 ON cd.Company = table2.Name where table2.Id IN (2728) both return the same result and both have…

  Read the article

• CONCAT_WS rows in JOIN

  - by Alex Kiselev

  i have tables profiles (id, name, deleted) categories (id, name, deleted) profiles_categories (id, profile_id, category_id, , deleted) I have wrong query SELECT p.id, p.name CONCAT_WS(', ', c.name) AS keywords_categories FROM profiles p LEFT JOIN profiles_categories pc ON p.id = pc.profile_id LEFT JOIN categories c ON…

  Read the article

• Remote Desktop Client Crashes following domain join

  - by Roberto Charlie Ciarleglio

  I recently joined my laptop to our windows domain and now the remote desktop client crashes when i try and connect to any machine. It works if I run as administrator but not ordinarily. The domain join migrated my local profile to the domain profile which i think is where the problem lies. I'm guessing its a permission…

  Read the article

• How can I rip a DVD but merge/join episodes

  - by Nifle

  Some background. I have the Pink Panther Collection, they have about 30 episodes on each DVD. Now I want to watch this on my $MobileDevice. So I went and converted it to m4v or avi. This of course went splendid with both Handbrake and AutoGK but the problem is that I want ONE file per DVD, both Handbrake and AutoGK…

  Read the article

• Netdom Join Failed To Complete Successfully

  - by BubbleMonster

  I have two servers on VMWare. One is a standard install of Server 2008 r2 and the other is Server 2008 core. Server 2008's IP is: 192.168.186.135 and computer name is: SERVER01. This is a domain controller and has DNS installed along with Active Directory. The domain is called: contoso.com Server 2008 Core's IP is:…

  Read the article

< Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >