I have two data files in tab separated CSV format. The files are in the following format: EP Code EP Name Address Region ... 101654 Alpha York Street Northwest ... 103628 Beta 5th Avenue South ... EP codes are unique. What I want to do is to compare two files with respect to EP codes, determine the...
I need to update multiple rows with one query. For the insert we usually do something like INSERT INTO `table` (c1,c2,c3) VALUES (1,2,3), (4,5,6), .. Yet how can we do something similar for the update where each row has different values than the other? And there is a condition that is related to the id of each row? Any one faced ...
Hi! I have some view (Views 2 - list of invitations, table style) which uses embedded forms to edit records directly in view rows. I am using ahah to change values in records. What I need is to refresh all records dynamically (some calculations) after I change some checkboxes. Is there any way to refresh view using Ajax? To trigger reloa...
Hi all, I have the following 2 data.frames: a1 <- data.frame(a = 1:5, b=letters[1:5]) a2 <- data.frame(a = 1:3, b=letters[1:3]) I want to find the row a1 has that a2 doesn't. Is there a built in function for this type of operation? (p.s: I did write a solution for it, I am simply curious if someone already made a more crafted code)...
I am trying to implement row moving in a DataGridView. I want to be able to select multiple rows and click on any of the selected row's cells to begin the drag operation. The problem is that the rows become deselected when I hold the mouse down on a cell. How can I prevent this from happening? ...
Hey there, I have the following Problem. Let's Say I have a JTable with the folowing Values: 1 2 3 4 5 Now I select "3" and press a button which saves the index of the row and prints "3" I have another Button let's call it the "next button", when I press it it will print "4" Now I sort (Or in this Case just randomise) the whole Table...
Hi guys, I've used animatedcollapse for my div sliders with no flaws. However, I now need to use a table row slider and it isn't performing the same at all. Here is a portion of the table I am using so you get an idea. <table> Reply to post... </div> <script type="text/javascript"> ...
When I try to remove the last row from a single column data frame, I get a vector back instead of a data frame: > df = data.frame(a=1:10) > df a 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 > df[-(length(df[,1])),] [1] 1 2 3 4 5 6 7 8 9 The behavior I'm looking for is what happens when I use this command on a two-c...
I've spent hours trying to figure this one out. This is for a manufacturing plant. A person on the plant floor logs their activities on different machines using a computer system which produces data like this: Empnbr Datestamp Shift Machnbr Time 00090 6/30/2010 1 0354 11:10 00090 6/30/2010 1 S 12:00 00098 6/...
Working in MS Access 2003 SP3: I have a query that I am running to find what 'cars' were sold with a date after the delivery date. I have thousands of rows. When it is all said and done, I want to just have a handful of rows for each 'car' and then the oldest date. Any suggestions? CAR DATE ORDERED DATE DELIVERED CUSTOMER NU...
Hi, I'm looking for a jQuery plugin but I'm not sure which I should use to get the desired effect. Essentially I'm looking to copy the TabularInline style data entry table from Django, but also allow the user to drag-and-drop re-order the position of the inlines. I'd also need the ability to add a new row. Which would be the best plug...
For example, the table has columns MYINDEX and NAME. MYINDEX | NAME ================= 1 | BOB 2 | BOB 3 | CHARLES Ho do I find row with highest MYINDEX for specific NAME? E.g. I want to find ROW-2 for name "BOB". ...
I have a table called [Sectors], which stores industry sectors. [SectorId] is defined as an INT and is the primary key of this table. These sectors are referenced throughout the database using the primary key, but there are no foreign key constraints for this primary key in the other tables. Now there are 2 sectors in this table that no...
How would I set the background color for for alternating rows (say: 1st, 3rd, 5th, 7th...) in a ListView using .net 2.0. ...
<LOV> <_3081><![CDATA[136]]></_3081> <_3082><![CDATA[ Test Patient7 Test Patient7 - Individual Group]]></_3082> <_3083><![CDATA[Individual Group]]></_3083> <_3084><![CDATA[05/08/2010]]></_3084> <_3085><![CDATA[05/08/2010]]></_3085> <_3081><![CDATA[137]]></_3081> <_3082><![CDATA[Demo Mcn]]></_3082> <_3083><![CDATA[MCN Group]]></_3083> <_...
Hi, I am new to Nhibernate. I want to retrieve collection of records against an entity. For example to retrieve a single record I have used the following statement: resultObject=session.Get(id); This above statement would retrieve a single record based on the 'id" I provide. But I want to retrieve multiple rows from a table the way w...
Consider the following table and rows: Listing A. ID, name, event, type 1, 'John Doe', '2010-09-01 15:00:00.000', 'input' 1, 'John Doe', '2010-09-03 11:00:00.000', 'input' 1, 'John Doe', '2010-09-04 17:00:00.000', 'input' 1, 'John Doe', '2010-09-02 15:00:00.000', 'output' 1, 'John Doe', '2010-09-03 16:00:00.000', 'output' 1, 'John Doe'...
I need to have a MsSql database table and another 8 (identical) processes accessing the same table in parallel - making a select top n, processing those n rows, and updating a column of those rows. The problem is that I need to select and process each row just once. This means that if one process got to the database and selected the top ...
Hi, I am using open source BIRT reports. I developed a detail reports. The setting are per page 100 records. There are more then 1 million records. When I show the reports it failed to show that report and stuck in processing 1 million records. Is the some server side pagination in BIRT like Crystal report. ...
I have this situation: I have to create a dataset that takes all data from another dataset. In some cases I have to remove some rows from each of the new dataset. When both foreach cycles are finished, both datasets are empty, even when finish only the first, the first dataset has some rows. Any idea why, ... or tell where I have code w...