Search Results

Search found 2729 results on 110 pages for 'fk relationship'.

Page 57/110 | < Previous Page | 53 54 55 56 57 58 59 60 61 62 63 64  | Next Page >

• Querying with foreign key

  - by theactiveactor

  Say I have 2 tables whose structures are as follows: tableA id | A1 | A2 tableB id | tableA_id (foreign key) | B1 Entries in A have a one-to-many relationship with entries in B. What kind of query operation would I need to achieve "something like this: select all objects from table B where A1="foo""? Basically, apply a query on tableA and from those result, find corresponding dependent objects in tableB

  Read the article

• Mapping @OneToOne with @Where clause

  - by Gabriel

  I am trying to map an entity as following @OneToOne(mappedBy = "localizedLabel") @JoinColumn(insertable = false, updatable = false) @WhereJoinTable(clause = "locale='en_US'") public Localization getEn_US() { return en_US; } I can assure that the data will return only one or null if the not found, but hibernate seems to ignore my @Where clause: ERROR com.eventtouch.bc.business.core.log.LoggingInterceptor - org.hibernate.HibernateException: More than one row with the given identifier was found: 4211, for class: com.eventtouch.bc.business.domain.LocalizedLabel Any ideas on ho to map a @OneToOne relationship with @Where clause? Thanks

  Read the article

• Basic Database Design

  - by Thurein

  Hi, This question would be a bit childish, I have three tables, users, usergroups and contacts. In my system, the end user can create a contact and subsequently he\she may define the visibility of the contact by setting only for that user, or for a set of users or a set of usergroups. So I am wondering, how my database design would be, it should be many to many between users and contacts or many to many between usergroups and contacts. Definitely there is a one to many relationship between users and usergroups. Thanks Thurein

  Read the article

• How to get all the descendants of a given instance of a model in google app engine?

  - by M.A. Cape

  Using parent child relationship where a parent can have children while each child has only one parent, does using Children.all().ancestor(parent.key) a good solution where a child is constructed by setting parent=parent.key in the constructor? Is the 1000 limit applies with this kind of query?

  Read the article

• Where clause in nhibernate map

  - by Phil Whittaker

  I have an Nhibernate hbm that maps a many to many relationship. For database simplicity it uses a where clause on the bag to filter the joining table. this works well until I start to test and I use the hbm file to create a database from the generated schema. The root and user tags columns aren't created. In the hbm file how do I define these two columns so they are generated in the schema?

  Read the article

• entity framework join

  - by Luca Romagnoli

  Hi, i have 2 table (user, user_profile) without a explicit relationship in the sql db. and i can't add it to the db. so, i can't do this: db.user.include("user_profile") the attribute in for the join is user_id is possible do anything like this? db.user.join("user_profile On user.id = user_profile.user_id") How can i do that? thanks

  Read the article

• rails checkbox has_many is hunted

  - by sebajb

  check_box is hunted in rails; but I would like to select some objects and save the relationship to the database anyways. When I debug the code all I see is the value='on' instead of the value I want to save. Any Help or tutorial would be appreciated.

  Read the article

• How do I get Enterprise Achitect to use correct class relationships when importing java source code?

  - by Sam

  I've just imported some java source into 'Enterprise Architect', e.g: class Truck { BumperSticker bumperSticker; Vector<Wheel> wheels; } It's added the first member as an association, and it hasn't added the second as a relationship at all. How do I get it to instead, add them both as aggregations, the second with a multiplicity of '*'?

  Read the article

• Django display manytomany field in form when definition is on other model

  - by John

  Hi I have the definition for my manytomany relationship on one model but want to display the field on the form of my other model. How do I do this? for example: # classes class modelA(models.Model): name = models.CharField(max_length=300) manytomany = models.ManyToManyField(modelA) class modelB(models.Model): name = models.CharField(max_length=300) # forms class modelBForm(forms.ModelForm): class Meta: model = modelB If I then used modelBForm it would show a select box with the models from modelA rather than just name. Thanks

  Read the article

• Fluent Nhibernate napping to existing database with primary key in joining table of a many to many r

  - by Todd

  I have an existing database with a many to many relationship however the joining table has a primary key ID and 2 foreign keys to do the join. Is it possible to configure the mapping files to handle this? at the moment i am stuck. Thanks

  Read the article

• UML - Object Method Returns a Collection

  - by derekerdmann

  How can I indicate that a method will return a collection of objects in UML? Is there a better way to explain the relationship than to have a collection class as a return type?

  Read the article

• Big O and Little o

  - by hyperdude

  If algorithm A has complexity O(n) and algorithm B has complexity o(n^2), what, if anything, can we say about the relationship between A and B? Note: the complexity of A is expressed using big-Oh, and the complexity of B is expressed using little-Oh.

  Read the article

• Reading POM's with it's children

  - by khmarbaise

  Based on the post it is mentioned (By Brett Porter) that a POM can be read. What i need is to read not only a single pom. I need to read the whole tree of pom's in a multimodule build. Starting with the root pom and it should read automatically the child pom's if it's possible? I need to do this in separate Java Code not in relationship with Maven itself.

  Read the article

• Assigining ID vs object - linq to sql

  - by jess

  Say, I have an entity Customer which has relationship with city,order etc.Now,when I am adding a customer object,should I assign customer.cityid, or customer.city? Now,from form I get cityid from dropdown,to assign city object,I will have to make a query using id selected.

  Read the article

• How to implement "select sum()" in Grails

  - by xain

  I have a relationship like this: class E { string name hasMany = [me:ME] } class M { float price } class ME { E e M m int quantity } And I'd hate to iterate to achieve this: "obtain the sum of the quantity in ME times the price of the corresponding M for a given E". Any hints on how to implement it using GORM/HQL ? Thanks in advance

  Read the article

• WordPress Business Directory - best approach

  - by NTulip

  I want to implement a business directory in WordPress and I am looking for feedback on the best approach: I have a categories and a businesses table Do I create a page for every business together with it's category relationship Do I create a page and assign it a template? What are the ups and downs with each approach? Looking for some answers from people that might of already done this and can speak from experience

  Read the article

• QuickGraph - is there algorithm for find all parents (up to root vertex's) of a set of vertex's

  - by Greg

  Hi, In QuickGraph - is there algorithm for find all parents (up to root vertex's) of a set of vertex's. In other words all vertex's which have somewhere under them (on the way to the leaf nodes) one or more of the vertexs input. So if the vertexs were Nodes, and the edges were a depends on relationship, find all nodes that would be impacted by a given set of nodes. If not how hard is it to write one's own algorithms?

  Read the article

• in relation to web development, what is a taxonomy?

  - by isolatedIterator

  Can people explain what taxonomy means in terms of a web site? My current understanding it a classification of the contents in relationship to each other, but it seems like it must go beyond that simplistic definition. and yes, I have read the wikipedia entry for this.

  Read the article

• Data Application based on OO Concepts

  - by The King

  Hi... I'm looking for an application developed in C# with following qualities, which is available as source code... Based on OO Architecture Must connect to DB. Must handle atleast a "one to many master child" relationship (eg: Order and items ordered) Should display the data using Datagrid or other similar controls. Reports (either with report buider or otherwise) I want to understand the layering of objects better... Do you have any links... Thanks.

  Read the article

• Mapping One-to-One subclass in Fluent NHibernate

  - by Mike C.

  I have the following database structure: Event table Id - Guid (PK) Name - NVarChar Description - NVarChar SpecialEvent table Id - Guid (PK) StartDate - DateTime EndDate - DateTime I have an abstract Event class, and a SpecialEvent class that inherits from it. Eventually I will have a RecurringEvent class which will inherit from the Event class also. I'd like to map the SpecialEvent class while preserving a one-to-one relationship mapped with the Ids, if possible. Can anybody point me in the correct direction? Thanks!

  Read the article

• Is it possible to write a database view that encompasses one-to-many relationships?

  - by Brandon Linton

  So I'm not necessarily saying this is even a good idea if it were possible, since the schema of the view would be extremely volatile, but is there any way to represent a has-many relationship in a single view? For example, let's say I have a customer that can have any number of addresses in the database. Is there any way to list out each column of each address with perhaps a number as a part of the alias (e.g., columns like Customer Id, Name, Address_Street_1, Address_Street_2, etc)? Thanks!

  Read the article

• Need help with a SELECT statement

  - by Travis

  I express the relationship between records and searchtags that can be attached to records like so: TABLE RECORDS id name TABLE SEARCHTAGS id recordid name I want to be able to SELECT records based on the searchtags that they have. For example, I want to be able to SELECT all records that have searchtags: (1 OR 2 OR 5) AND (6 OR 7) AND (10) Using the above data structure, I am uncertain how to structure the SQL to accomplish this. Any suggestions? Thanks!

  Read the article

• NSManagedObject get parent object

  - by Jacob

  I have an NSManagedObject who has a one to many relationship with the parent Object. How can I get the parent object using the child object?

  Read the article

• Java: iterating through list of lists?

  - by HH

  The question but in C#. So does Java have C#'s command? I need it for Matches-SearchTerm-Files-relationship. foreach(var i in BunchOfItems.SelectMany(k => k.Items)) {}

  Read the article

• Django admin: how do I add an unrelated model field to a model change/add page?

  - by NP

  I have the following models: class Foo(models.Model): field1 = models.IntegerField() ... class Bar(models.Model): field1 = models.IntegerField() ... class Foo_bar(models.Model): foo = models.ForeignKey(Foo) bar = models.ForeignKey(Bar) ... In the admin, I want it so that in the Foo change/add page, you can specify a Bar object, and on save I want to create a Foo_bar object to represent the relationship. How can I do this through customizing the Admin site/ModelAdmins? Thanks.

  Read the article

< Previous Page | 53 54 55 56 57 58 59 60 61 62 63 64  | Next Page >