nested

nested sql statment using and

hi guys, how to make this work in mysql? select ID,COMPANY_NAME,contact1, SUBURB, CATEGORY, PHONE from Victoria where (city in ( select suburb from allsuburbs)) and CATEGORY='Banks' this below statement is working: select ID,COMPANY_NAME,contact1, SUBURB, CATEGORY, PHONE from Victoria where city in ( select suburb from allsuburbs...

Use jQuery's dataTable plugin with a nested Ajax call

I am trying to use a nested ajax call to populate a table, and once the table is built, use jQuery's dataTable plugin to pretty it up. The problem I am running into is an order of operations question. When do I call the dataTable function so that I can be assured that the table is built AFTER the values are populated? When I try the f...

ASP.NET Nested masterpages, how to set content in the top page from the aspx file?

I have some content from a CMS that I need to move to raw asp.net pages. Since the templates are nested I guess I can use nested masterpages to acomplish it, but I'm finding that I can't set values on the top masterpage from the deep child page. Here is a sample. I have several nested masterpages with contentplaceholders: top master...

MS-Access nested DIR - check if a file exists elsewhere whilst looping through a folder

I have used the DIR() command in Microsoft Access 2003 to loop through the files in folder A. This works fine, but I need to check if each file also exists in another location (folder B), and only process the file if it doesn't exist in folder B. The problem is that checking for the file existing in folder B also uses the DIR() function...

How to implement a UINavigationController to a standard UIView

This is the structure of my application currently: UIWindow UIViewController (Root View Controller) UINavigationController UITableView UIViewController (PresentModalViewControllerAnimated:YES) UITableView This is how I want it to be: UIWindow UIViewController (Root View Controller) UINavigationController UITableView UIView...

Sorting by custom field and fetching whole tree from DB

Hello everyone, I am trying to do file browser in a tree form and have a problem to sort it somehow. I use PHP and MySQL for that. I've created mixed (nested set + adjacency) table 'element' with the following fields: element_id, left_key, right_key, level, parent_id, element_name, element_type (enum: 'folder','file'), element_size. ...

Adding Items to an Inner (Nested) ListView

I have 2 asp:ListView controls, one embedded in the other (OuterListView and InnerListView respectively). I am trying to add an asp:linkbutton in the InnerListView layout that will allow the user to add an item to the InnerListView. Unfortunately, when I handle the OnClick event in the linkbutton control, I can't figure out how to get ...

How to fill DataGridView from nested table oracle

I want to create my type: CREATE TYPE t_read AS OBJECT ( id_worker NUMBER(20), how_much NUMBER(5,2), adddate_r DATE, date_from DATE, date_to DATE ); I create a table of my type: CREATE TYPE t_tab_read AS TABLE OF t_read; Next step is create a table with my type: enter code hereCREATE TABLE Reading ( id_watermeter NUMBER(20) co...

Order awesome nested set array for combo box lookup

I'm using Awesome Nested Sets and Formtastic within Rails and am having trouble listing the nester set records in a structured order within a lookup (combo) box. I'd list to show the lookup box like so: -Parent1 --P1Child1 --P1Child2 -Parent2 --P2Child1 --P2Child2 --P2Child3 etc... Origionally the lookup box was displaying the resul...

Changing the innerHTML of elements in a nested div tag..

It has become apparent I'm quite an idiot - there was an error in my JS above this code - sorry for the bother - all the below are correct in one form or another.. (also I'm selecting the one that works in IE is the correct answer).. Thanks for all your help!! -- Representative code only - I need to know how to change the innerhtml of t...

MVVM pattern and nested view models - communication and lookup lists

I am using Prism for a new application that I am creating. There are several lookup lists that will be used in several places in the application. Therefore it makes sense to define it once and use that everywhere I need that functionality. My current solution is to use typed data templates to render the controls inside a content control....

Rails: what are the benefits of using nested routes / forms

I am starting to use some nested routes which is definitely a different way of planning things and I'm really failing to see added benefits. So what are they? ...

Creating objects and referencing before saving object to db

Sorry about the vague title, but i didnt know how to ask the question in one line :) I have an order with nested itemgroups that again have nested items. the user specify the amount of item that he would like to have in each itemgroup. I would like to create these items in the create method of the orders controller when the order itself...

Need help nesting an Excel calculation

Here's what's currently happening: Z8: 100 Z9: =((Z8*W2)+Z8) Z10: =Z9*X2+Z9 Z11: =Z10*Y2+Z10 I start with a value of 100 and then add data from W2, X2 and Y2. This works, but it spans across three cells. I need it to fit into one. I'm drawing a blank on nesting the equations to fit into the one. Help? ...

Move node in Nested Sets tree

Hi everyone, I am working on an adjacency list with mySQL and can not (atleast by myself) do the thinking needed to make a decent enough query to be able to move a set of nodes (together with eventual children nodes) around. The table has following columns: id name left right Thanks a lot! ...

writing a Simplest XML DeSerialization class for the simplest xml file. How to avoid the nesting? deserialize at root?

Hi, I want to deserialize an xml file which has to be just in this form <Basket> <Fruit>Apple</Fruit> <Fruit>Orange</Fruit> <Fruit>Grapes</Fruit> </Basket> Out of the examples I read on internet the least possible format I could find was the following <Basket> <FruitArray> <Fruit>Apple</Fruit> </FruitArray> <FruitArr...

CommandBinding broken in inner Custom Control when nesting two Custom Controls of the same type.

I've done a Custom Control in form of a GroupBox but with an extra header which purpose is to hold a button or a stackpanel with buttons at the other side. I've added the a Dependency Property to hold the extra header and I've connected the customized template. Everything works fine until I put one of these controls in another one. Now...

shell scripting: nested subshell ++

Hi guys, more than a problem, this is a request for "another way to do this" actually, if a want to use the result from a previous command I into another one, I use: R1=$("cat somefile | awk '{ print $1 }'" ) myScript -c $R1 -h123 then, a "better way"is: myScript -c $("cat somefile | awk '{ print $1 }'" ) -h123 but, what if I h...

In Python, how to make sure database connection will always close before leaving a code block?

I want to prevent database connection being open as much as possible, because this code will run on an intensive used server and people here already told me database connections should always be closed as soon as possible. def do_something_that_needs_database (): dbConnection = MySQLdb.connect(host=args['database_host'], user=args['...

Nested loops break out unexpectedly

Hi guys, I'm trying to create a sudoku game, for those that do not know what it is. You have a 9x9 box that needs to be filled with numbers from 1-9, every number must be unique in its row and column, and also in the 3x3 box it is found. I ended up doing loads of looping within a 2 dimensional array. But at some point it just stops, wi...