parent-child

Move Child Rows to new Parent FK ID ?

SQL Server 2008. I have a parent row with pk id 1. While blocking all other DB users (this is a cleanup operation so resource contention is not an issue), I would like to insert a new row, then take all of the child rows and change their fk column to the new row. With the below DDL for example, I would like to insert a new row and give ...

SQL - detecting loops in parent child relations

I have parent child data in excel which gets loaded into a 3rd party system running MS SQL server. The data represents a directed (hopefully) acyclic graph. 3rd party means I don't have a completely free hand in the schema. The excel data is a concatenation of other files and the possibility exists that in the cross-references between...

Windows State Machine workflow: How can we achieve Parent Child workflow communication when both are hosted as WF service.

I am trying to spawn child workflows as services from parent workflow which is also a workflow hosted as a service. Problems I am facing: How to spawn multiple child workflows as service "synchronously"? How to communicate to the consuming applications that the child workflows are ready for action? How to communicate to the parent tha...

Web app code generator

I have a request to create a web application on a a public web site that would display data from about 5 tables in mySQL. I would like to display parent/child relationships. Is there a product that I could use to generate code to do this? I was thinking PHP would be good to use. ...

PHP - child process blocking SIGTERM for parent

Hi all, I'm having problems with killing parent process that have 1 child - parent is waiting for child to exit and only after that kill handler is called. When the kill handler is not installed (pcntl_signal(SIGTERM, "kill_handler")) script terminates immediately. I need that after submitting kill command to terminate parent process ...

recursive self query

I have the following table: myTable: +----+----------+ | id | parentID | +----+----------+ | 1 | null | | 2 | 1 | | 3 | 1 | | 4 | 2 | | 5 | 4 | ----------------- i would like to get all rows tracing back until there's no parentID anymore. So ".... WHERE id=5" would give me: 5, 4, 2, 1 ...

Two distinct projects with a shared dependent project in maven

I have two projects, "appA" and "appB", that each depend on a third project, "common". I'm in the process of moving them from ant to maven, but I'm having some difficulty figuring out the best way to do it in maven. My folder structure looks like this: root + common + appA + appB I've been able to add a parent pom.xml to the root and...

method_exists in parent class php

Hi, I'm trying to use the php function method_exists, but I need to check if the method exists in the parent class of an object. so: class Parent { public function myFunction() { /* ... */ } } class Child extends Parent { /* ... */ } $myChild = new Child(); if (method_exists($myChild, 'myFunction')) { /*...

NHibernate ICriteria - order by child collection count ?

Hi, Here is a simple example scenario - A 'Tag' has many 'Questions'. When I get a list of Tags how do I order by the Tags Question Count using the Criteria API? I have done this before but haven't touched NH in about 4 months and have forgotten... projections maybe? help!!! Thanks ...

IE8 and Firefox CSS selector difference?

I am getting really weird behavior, it seems like IE8 is not handling the child selector in CSS correctly. Consider the following: <html> <head> <style> ul>li {font-style: italic} </style> </head> <body> <ul> <li>Hello </li> </ul> </body> </html> This displays Hello in italics on FF, but not on IE8. If you change the...

Is it possible to call a function in a parent component from a child component in Flex?

I need to call a function located in the parent component and make the call from the child component in Flex 3. Is there a way to access functions in the parent component from the child component? I know I can dispatch an event in the child and add a listener in the parent to call the function, but just wanted to know if could also dir...

How to call javascript function of child page from master page javascript

Hi All, I am writing an ASP.Net application. I am making use of master page in it. I have several child pages with me, which consist of some java script functions; Let's say; function ChildPageFunction() { //Do something; } And master page java script function as; function MasterPagefunction() { //Need to call ChildPagefunc...

WPF DataGrid Parent Child Data

Hi All. I'm new to WPF/C#/NET but I have been learning by way of coding some small exercises. Anyway, I'm stuck. I have seached on here and google and can't find the answer or maybe more correctly can't find an answer I can make sense of. My problem is this... using the Entity Framework I have two tables. One for Employee details and ...

Linking a new child with its parent when adding a new child.

I have a customer model that has_many events When I go to the customer show page, I have links to all of the events that are owned by customer. I want to add a "New event for this customer" link. Right now, I'm doing that with <%= link_to "New Event for this Customer", new_event_path %> but when I follow that link, I have to manually ent...

php - adding elements to other elements

Hey, I have been using .net for the past couple of years, and I like the way you can add controls at any point in the page from anywhere. For example, you can say Head.Controls.add(new LiteralControl("")) even if there is already a body. Is it possible to do this kind of thing in php? My site is set up so that we have agents, customers...

python: simple approach to killing children or reporting their success?

I want to call shell commands (for example 'sleep' below) in parallel, report on their individual starts and completions and be able to kill them with 'kill -9 parent_process_pid'. There is already a lot written on these kinds of things already but I feel like I haven't quite found the elegant pythonic solution I'm looking for. I'...

Access controls of parent dialog in VB6

Hello, I have a dialog in vb6 which changes the values being displayed in its parent dialog. the x1 is displayed in txt_c1 text in parent dialog and it has a txt_1validate funtion too for the text box. Now i want to change the value of txt_c1 txtbox from child dialog and then call its validate function. But the problem is that txt_c1 is...

How to pass data from parent view to child upon opening?

I want to load data (an array of strings) from the parent view into a set of UITextFields in the child view upon presenting the modalView. I know how to pass from child to parent, and I'm sure it's even easier to go the other way, but I don't know how. Thanks in advance! UPDATE: Update removed because I found the problem (double relea...

Rails: Getting the most recent datetime in a child model

I have the parent model of user and user has_many :events. From the user view, how can I find the most recent datetime (event.time) of event? I'm thinking that a find_by will work, but I'm not sure on how to do that. ...

Reap children without setting $SIG{CHLD} to IGNORE or to a custom signal handler

I am trying to write a socket server that forks for every connection. I have been successful except for one small caveat: my child processes use Net:OpenSSH->capture2() which requires that $SIG{CHLD} not be set to IGNORE or to a custom signal handler. How can I reap my children without setting the signal handler or slowing down the paren...