table

JTable or some other Java table class with advanced cell selection?

Right now I'm using a JTable for what I'm doing. After looking through the Java API and various web resources, I don't think a JTable is going to cut it anymore. What I'm looking for is a table for which I can specify very strict selection procedures. I want to be able to not only select rows and columns, but also select cells in a diago...

Using Multiple Tables, Multiple Values with Min() SQL

HI, New to StackOverflow... I am using SQLite in an application that I am developing. I am trying to run a pretty complex query (complex for me!!) and I have gotten the basic results i need but I am stuck on getting over the last hurdle. I presently have this query that does what i need it to do... SELECT SUM(activity) FROM activitie...

[Q] Dojo(x) Widgets within HTML table do not resize

I have the following page using Dojo 1.3.1 javascript toolkit Content Pane HTML table two columns, N rows Column 1 (left): text Column 2 (right) Dojo widget (can be any, but mostly Grids, pullodwn, etc) Problem: When page loads, it renders Ok (the type of widget and the number per page are determined at runtime, so I ca...

<div> element instead of <table>?

Duplicate of: Why not use tables for layout in HTML? DIV’s vs Tables or CSS vs. Being Stupid Theres been a lot of talk lately about rather using div than table tags to make your pages more browser fiendly. Why is div better? ...

What should I replace this code with?

I recently got an example of some code from a friend but he told me one line needs to be changed to make it work for me. Here's the code: - (void)tableView:(NSTableView *)aTableView willDisplayCell:(id)aCell forTableColumn: (NSTableColumn *)aTableColumn row:(int)rowIndex { if ([aCell respondsToSelector:@selector(setTextColor:)]) {...

Displaying/Formatting Tabular Data (web)

In my example I have a table where each row is a user for example. Columns could include their name, address, email address, etc. I now need to add a column for (hypothetical example) their cat's names. While most people will have no cats and some people will have 1- 2 cats there will be the occasional person with 20 cats that create one...

How do you make a Menu Bar Item display how many rows there are in a table?

I have a core data table and would like the Menu Bar item to display how many rows there are in the table. I have already created the menu bar item using this code: -(void)applicationDidFinishLaunching:(NSNotification *)aNotification { NSStatusItem *statusItem = [[[NSStatusBar systemStatusBar] statusItemWithLength:NSVariableStatusItem...

Redesign Table (dynamic width) with Div tags

I want to display a html page, with a classic design. Header, footer, content and bar to the right. For some reason I don't like the fixed width of the content. On a wide screen you should be able to resize your page, so it fills the screen, or make it very small to display two pages side by side. I also would like to use div tags inst...

Hiding Text in Word (particularly tables)

Hi I've been working on a document that has a number of hidden sections that can be made visible using check boxes (and VBA). Most of this works fine including hiding Tables, Pictures, Formatting and Text using Range.Font.Hidden = True. My problem lies with leaving a table hidden, saving the document and then re-opening the document. ...

Jquery Search and filter table

Hi all, I was looking for a jquery plugin that'll filter a table according to input values. I came across http://rikrikrik.com/jquery/quicksearch/, but i can't figure out how to make it work for an already existing input box. Currently it create a new input form for me (which i don't want) but i'd like to be able to use it with an exis...

auto width of the error label

the error label displays till the width of the table. as this: how can i display it till the text of the label? this is the css: label.error { color: red; font-size:16px; font-family:Nyala; background-color: #FFFFCC; display:block; width:auto; } ...

Generic-like behavior in PL/SQL procedure parameters

Suppose I have some data types defined in PL/SQL: TYPE foo_t IS RECORD (...); TYPE foo_table_t IS TABLE OF foo_t INDEX BY BINARY_INTEGER; TYPE bar_t IS RECORD (...); TYPE bar_table_t IS TABLE OF bar_t INDEX BY BINARY_INTEGER; Is it possible for me to write a procedure capable of accepting any data type derived from TABLE (for example...

Advanced SQL Data Compare throught multiple tables

Hello, Consider the situation below. Two tables (A & B), in two environments (DEV & TEST), with records in those tables. If you look the content of the tables, you understand that functionnal data are identical. I mean except the PK and FK values, the name Roger is sill connected to Fruit & Vegetable. In DEV environment : Table A 1 Ro...

How to list all tables or only those of a given database

You can get a list of databases using PRAGMA database_list or a list of tables in the "main" database using select name from sqlite_master where type='table' but as I just wrote, it only returns the tables from the "main" DB only, and I don't see a way to know which tables are in the other DBs. So how does one list the tables in t...

How to Pivot data from one table with SQL server 2005

Hello, I would like to create a query from a single table with the following columns. SEQNO is a unique key Name ID Amount Date JOBID SEQNO Mark 9 200 1/2/09 1001 1 Peter 3 300 1/2/09 1001 2 Steve 1 200 2/2/09 1001 3 Mark 9 200 3...

do extra empty columns affect sql table size significantly?

i have a few columns that i know won't be used initially. is it a good practice to add columns only when needed or just leave those extra columns there? is it just a little more space in the header or every row? ...

Listing all tables in a database

Is there a SQL command that will list all the tables in a database and which is provider independent (works on MSSQLServer, Oracle, MySQL)? ...

How to select a row in table using jquery?

I have created a table in my application, I want to select (change background color) whole row on click of a checkbox, same as gmail is doing, When we click checkbox in gmail, the whole row becomes yellow. <table> <tbody> <tr> <td><input type="checkbox" name="chk" id="chk" /></td> <td>My Name</td> <td>Description of the job</td> </tr> <...

cols, colgroups and css :hover psuedoclass.

I'm trying to create a table to display an individual's BMI. As part of this, I'd like, on :hover, for the <tr> and <col> (or <colgroup>) to be highlighted also, in order for the intersection to be more apparent. As the table will feature both metric and imperial measurements, the :hover doesn't have to stop at the cell (from any direc...

How to load data in a Ruby on Rails Join Table ?

Hello I have the following join table that works: class CreateRolesUsers < ActiveRecord::Migration def self.up create_table :roles_users,:id => false do |t| t.integer :role_id, :null => false t.integer :user_id, :null => false end end def self.down drop_table :roles_users end end But I don't know h...