columns

ABAP Column Tree Model doesn't expand node after EXPAND_NO_CHILDREN event

I am displaying a list of items using a SAP ABAP column tree model, basically a tree of folder and files, with columns. I want to load the sub-nodes of folders dynamically, so I'm using the EXPAND_NO_CHILDREN event which is firing correctly. Unfortunately, after I add the new nodes and items to the tree, the folder is automatically colla...

Select all columns except one in MySQL?

I'm trying to use a select statement to get all of the columns from a certain MySQL table except one. Is there a simple way to do this? EDIT: There are 53 columns in this table (NOT MY DESIGN) Sounds like there's no good solution, thanks anyways guys. ...

How do you create an HTML table with adjustable columns?

I want to know how to create a table where you can adjust the column widths. I have not figured out how to do this. If you know the secret sauce to this technique please let me know. ...

SQL Server: Copying column within table

Hi, what is the easiest way to copy the all the values from a column in a table to another column in the same table? ...

Sorting a list into multiple vertical columns

Does anyone have a good algorithm for re-sorting an array of values (already pre-sorted) so that they can be displayed in multiple (N) columns and be read vertically? This would be implemented in .Net but I'd prefer something portable and not some magic function. A good example of it working is the ASP.Net CheckBoxList control rendering...

Setting default values for columns in JPA

Is it possible to set a default value for columns in JPA, and if, how is it done using annotations? ...

Rows in their own columns depending on their value

I have a select query that currently produces the following results: Description   Code   Price Product 1       A       5 Product 1       B       4 Product 1       C       2 Using the following query: SELECT DISTINCT np.Description, p.promotionalCode, p.Price FROM Price AS p INNER JOIN ...

SQL - Table Design - DateCreated and DateUpdated columns

For my application there are several entity classes, User, Customer, Post, and so on I'm about to design the database and I want to store the date when the entities were created and updated. This is where it gets tricky. Sure one option is to add created_timestamp and update_timestamp columns for each of the entity tables but that isn't...

How to change data in JTable cells?

I can set data in JTable constructor, and then user can change this data when program is running manually(typing from keyboard). But what method should I use in case I want to change data in some column? To change column header I use TableColumn method setHeaderValue. What should I use to set value in JTable cell? ...

How do I add custom column to existing WSS list template

I need to use feature stapler to add some text columns to Posts list inside OOTB blog site definition. I plan not to use site columns, but only to add those columns to list (I don't use site columns because I have multiple site collections and there will be only one Posts list per site collection, so site columns are not very reusable in...

frameset - swap columns with rows using javascript.

Hey everyone, I have a frameset with it's cols attribute set to "50%,50%" at the moment. I have a toggleView method which is called after a click on an element. What I aim to do is to change frameset from displaying cols to rows, again divided 50/50. I have attempted to perform a removeAttribute("cols") on the frameset, while this doe...

Fluid CSS layout and Borders

In designing a fluid layout, how do you use borders without ruining the layout. More specifically, I have a HTML widget which consists of five divs. I would like the five divs to take up all the room in the containing element. I would also like to have a 1px border around each. I tried: .box { float: left; height: 100%; width: 100%; ...

GridView - Show headers on empty data source.

In C# how do I still show the headers of a gridview, even with the data source is empty. I am not auto generating the columns as they are all predefined. Currently what I am doing is the following. Get a DataTable back from a stored procedure, then set the DataSource of the gridview, and then call DataBind(). This works fine when I...

Floating columns both ways Javascript

I am trying to float columns using css so they stack up evenly like on this blog: http://typeneu.com It seems to be impossible using css so I am looking in to javascript. The website listed above uses this javascript file: http://typeneu.com/wp-content/themes/grid-a-licious/scripts/grid-a-licious.js I have tried to implement it to exp...

Hide (or fold) columns of text in (g)Vim (horizontally)

Hi all, is there a way to hide columns of a buffer (text file, you know what I mean) while editing it in Vim? e.g. text visible in the buffer before hiding column 2&3: abbcccccc accdddddd And after hiding them: acccccc adddddd (Not to mention I'm working with really huge files (sometimes over 200 gb).) And yeah, I had found fold...

Is it possible to increase the max columns of an Oracle database to store huge arrays?

For reasons that are beyond my control I need to store huge arrays (10000+ entries) in database rows, and it has to be easy to access each index of the array individually, which means I'd rather avoid serialization/blobs, if at all possible. So my first idea, and the actual question here, is can I increase max columns for Oracle in anyw...

How do I merge two columns in a DataSet?

Previously I've asked about inserting a column into a dataset. I now have a similar question...namely merging two or more columns into a single column. Lets say I have the following data set: DataSet ds = new DataSet(); ds.Tables.Add(new DataTable()); ds.Tables[0].Columns.Add("id", typeof(int)); ds.Tables[0].Columns.Add("firstname", ty...

C#: Should a standard .Net string be stored in varchar or nvarchar?

We have an application written in C#, using .NET Framework 3.0 or 3.5 or something like that. As storage we use SQL Server, and we use Linq 2 SQL to talk with it. Currently most (if not all) text columns in the database, are set to the varchar type (of different lengths of course). But I started thinking... according to MSDN "The stri...

Is it better to use the column name or column index on .Net DataSets?

When retrieving values from a DataRow is it better to use the column name or column index? The column name is more readable and easier to maintain: int price = (int)dr["Price"]; While column index is just faster (I think): int price = (int)dr[3]; Would using column names break if you decide to obfuscate the database? ...

Disadvantage of choosing large MAX value for varchar or varbinary

What's the disadvantage of choosing a large value for max when creating a varchar or varbinary column? I'm using MS SQL but I assume this would be relevant to other dbs as well. Thanks ...