table

How should I display a validation error detected by an ICellEditorValidator?

I have a TableViewer with an ICellModifier which seems to work fine. I set an ICellEditorValidator on one of the cell editors, though, and I can't get it to behave the way I would like. Here's my abbreviated code: cellEditors[1] = new TextCellEditor(table); cellEditors[1].setValidator(new ICellEditorValidator() { public String isV...

Oracle Large Table Search and DML

Hi I have three tables, t1, t2 and t3. 80% of the fields/columns are similar in these tables. Around 75,000 records are posted in table t1 and t2 on daily basis, totaling to 150,000. A process, say P123, is executed which moves 40-60 % records from t1 and t2 to t3 in a pair. The user searches frequently for records in all three tables wi...

Too many columns in a single database table?

An application I am dealing has a single table with 170 columns. In my mind, it would make more sense to break this table up into smaller, more logical groupings, though you could have an issue where numerous tables have to be joined if you needed data from columns in the various tables. I am wondering what the pros and cons of these...

Is there any reason to worry about the column order in a table?

I know you can ALTER the column order in MySQL with FIRST and AFTER, but why would you want to bother? Since good queries explicitly name columns when inserting data, is there really any reason to care what order your columns are in in the table? ...

Oracle External Tables: Advanced Flat File Layout

I wish to create an external table in an Oracle database, retrieving its data from a flat file on the server. The format of this file is non-trivial. Each line in this file can be one of several different layouts, depending on the line's prefix (the prefix itself is always a fixed length). For example, a line beginning with 'TYPE1' would...

How to edit tabular data (ASP MVC)

Hi, I need to be able to edit a table of data in the browser. I have seen in MVCContrib there is a HTML helper to render out a table. Useful... but what about if I want the user to be able to edit that table? From what I can see it does not help there. What is the best way to approach this? Traditional FORM with a TABLE inside? If so...

Sqlite database table: can an array become one column of a record?

I'm designing an iPhone app, which needs to store data into Sqlite database. One record of the table looks like - @interface Record:NSObject { NSInteger primaryKey; NSString *name; NSInteger priority; NSMutableArray *items; }; Please be noted one column in the record is an array and the size of the array is not fixed....

sqlserverquestion

how to write 2 tables and how insert into it in a single statement ...

Rails combined ('AND') searches on associated join tables

I cant get rails to return combined ('AND') searches on associated join tables of an Object. E.g. I have Books that are in Categories. Lets say: Book 1: is in category 5 and 8 But I cant get 'AND' to filter results using the join table? E.g ::-> Class Books has_and_belongs_to_many :categories, :join_table => "book_categories" Book.fi...

App hangs calling DefaultCellEditor constructor

I have control of a small piece of an application built on Eclipse, and I'm having a problem creating a DefaultCellEditor. The code actually uses a subclass of DefaultCellEditor, but I can recreate the problem using DefaultCellEditor, so that's what I'm going to ask about, hoping that it will solve the problem with the actual class. I'...

jQuery Ajax grid

Hello, We are starting a new ASP.NET MVC application and want to use an jQuery Ajax grid. I came across following options: - jqGrid (better than Flexigrid because it supports editable cells) - Flexigrid (looks better than jqGrid) - tablesorter - Ingrid - jqGridView - OTHERS? Which is the best choice for jQuery Ajax grid ? W...

Using @Table with schema name in Hibernate 3.3.1ga and HSQLDB

How can I make this work in unit tests using Hibernate 3.3.1ga and HSQLDB: @Entity @Table(name="CATEGORY", schema="TEST") public static class Category { ... } The problem is that Hibernate expects the schema to exist. The second problem is that Hibernate issues the CREATE TABLE TEST.CATEGORY before any of my code runs (this happens de...

Recommended Table Set up for one to many/many to one situation

I need to create a script where someone will post an opening for a position, and anyone who is eligible will see the opening but anyone who is not (or opts out) will not see the opening. So two people could go to the same page and see different content, some potentially the same, some totally unique. I'm not sure the best way to arrange ...

Need help partitioning a field on a sql 2008 table to a different filegroup

Hi folks, in a previous question i asked, the suggested answer was for me to partition my field onto another Filegroup, keeping the field in the same table. I'm not sure how to do this. I've tried to google for things like partition table, partition view, etc. Could anyone provide me with some links or some sample sql code? DB Server ...

Checking for and dropping an existing table via C# and SMO

I am trying to look for a SQL table by name and if it exists drop it. This all needs to be done in C# using SMO. To complicate it a bit more the table also has a schema other then "dbo". Ultimatly the table will be recreated via SMO (I have this working) but I have to make sure it is not there before I can recreate it. All of the exam...

What text format can I use to present data originally in an Excel spreadsheet?

I have an Excel spreadsheet that has many people's estimates of another person's height and weight. In addition, some people have left comments on both estimate cells like "This estimate takes into account such and such". I want to take the data from the spreadsheet (I've already figured out how to parse it), and represent it in a plain...

Setting table column width

I've got a simple table that is used for an inbox as follows: <table border="1"> <tr> <th>From</th> <th>Subject</th> <th>Date</th> </tr> How do I set the width so the From and Date are 15% of the page width and the Subject is 70%. I also want the table to take up the whole page width. ...

need help with some html/css trickery to get around drawback in struts2

I am trying to get an html page like http://jsbin.com/awoco This is a JSP page so it will include scriptlet. Final html will be kind of like this (i left tags unclosed to save space): <% Iterator it = MyList.iterator() While (it.hasNext()) SomeClass all = it.next(); SomeClass a = it.next(); SomeClass b = it.nex...

Is there a parser for the output from Perl's Text::Table?

Suppose I have a bunch of tables created with Text::Table. Does there exist a parser to convert them back to Perl data structures, or do I have to write my own? ...

Mysql Create Table with dynamic database name

Hi All, I am creating database at runtime and I want to create the tables in that database at the same time. can anyone give me any thought on how to do that? For Example - I have created one database named 'mydb' and now in the same proess i am trying to create the table i am using the mysql stored procedure for the same. my proc inp...