VB.Net: Resizing ListBoxView Column When Form Resizes
How can I have a single column resize with the form so that the ListView columns continue to fill the whole form? ...
columns
How can you tell which columns are unused in ALL_TAB_COLS?
When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can ...
[R] Select columns for heatmap in R
Hi stackoverflow-pros, I need your help again :) I wrote an R script, that generates a heatmap out of a given tab-seperated txt or xls file. At the moment, I delete all columns I don't want to have in the heatmap by hand in the xls file. Now I want to automatize it, but I don't know how :( The interesting columns all start the same i...
Excel - Combine multiple columns into one column
Hey everyone. I'm new to excel and VBA and I'm stuck at this problem. I have multiple lists that are in separate columns in excel. What I need to do is combine these columns of data into one big column. I do not care if there are duplicate entries, however I want it to skip row 1 of each column. ROW1| 1 2 3 ROW2| A D G ROW3|...
Java Swing: JTextArea columns question
How do i put the text in specific columns with jTextArea? private javax.swing.JTextArea jTextArea1; jTextArea1.setColumns(4); jTextArea1.insert(price, 0); //column 1 jTextArea1.insert(cost, 0); //column 2 jTextArea1.insert(quantity, 0); //column ect.. jTextArea1.insert(itemName...
Consolidating Columns in Excel
I have two columns in excel like the following a,apple a,bannana a,orange a,plum b,apple b,berry b,orange b,grapefruit c,melon c,berry c,kiwi I need to consolidate them like this on a different sheet a,apple,bannana,orange,plum b,apple,berry,orange,grapefruit c,melon,berry,kiwi Any help would be appreciated This code works...
mysql select column from view problem
i create a view table like : CREATE VIEW ViewManager AS SELECT us.UserId AS 'Account Manager', ......... after that, when i run a query to select data from this view like : SELECT 'Account Manager' , .. from ViewManager then the data i get in this column is the text 'Account Manager' and not the value of the this columns. Is th...
How to output an array's content in columns in BASH.
I wanted to display a long list of strings from an array. Right now, my script run through a for loop echoing each value to the standard output: for value in ${values[@]} do echo $value done Yeah, that's pretty ugly! And the one column listing is pretty long too... I was wondering if i can find a command or builtin helping me to d...
SQL: How to use a column that was just added
I am trying to add 2 columns and then I would like to set some values to them but I get a compile-error saying the column does not exist. I am using the following script: IF @LogProcessed = 0 Begin IF NOT EXISTS (select column_name from INFORMATION_SCHEMA.columns where table_name = 'SYSTM_FRM' and column_name = 'SF_Ip_TXT') ALTER TABLE...
Resizing columns in adobe flex AdvancedDataGrid
Hi, I'm using an AdvancedDataGrid without the header row (AdvancedDataGrid.showHeaders="false"), my AdvancedDataGrid has 2 columns, where the first one will show a hierarchical data (tree). The tree may be very long and very deep or may contain a long string in the node label so the user will not be able to see the whole vale of the tree...
How to get a list of the columns (in order) in a database table using a Hibernate session?
Hi, I need to retrieve a list of the columns in a table in the order in which they appear. Is this possible using Hibernate? I've got a Hibernate session object, and I don't mind whether I can do it in Hibernate itself, or using JDBC. The database is MySQL, and the equivalent SQL command I want to execute is: "SHOW COLUMNS FROM " + t...
2-column table with two foreign keys. Performance/design question.
Hello everyone! I recently ran into a quite complex problem and after looking around a lot I couldn't find a solution to it. I've found answers to my questions many times before on stackoverflow.com, so I decided to post here. So I'm making a user/group managment system for a web-based project, and I'm storing all related data into a p...
CSS three column layout, liquid center, no left-margin!
Hi, I am all in favor of CSS based layouts, but this one I just can't figure out. With a table it is oh-so-easy: <html> <head><title>Three Column</title></head> <body> <p>Test</p> <table style="width: 100%; border: 1px solid black; min-height: 300px;"> <tr> <td style="border: 1px solid green;" colspan="3">Header</td> </tr> <tr> <td...
Cannot format first column in WxPython's ListCtrl
If I set the format of the first column in a ListCtrl to align centre (or align right) nothing happens. It works for the other columns. This only happens on Windows - I have tested it on Linux and it works fine. Does anyone know if there is a work-round or other solution? Here is an example based on code found at http://zetcode.com/wxp...
How to add columns at runtime in WPF DataGrid from ViewModel?
I don't have the column names at compile time. I would be available in an array of strings at runtime. I need to read this array and create columns for wpf datagrid. I have MVVM pattern setup and my View has the DataContext setup to ViewModel. I am able to use ObservableCollection and make it work, but I have to fix the column number/na...
Simulating variable column names in sqlite
I want to store entries (a set of key=>value pairs) in a database, but the keys vary from entry to entry. I thought of storing with two tables, (1) of the keys for each entry and (2) of the values of specific keys for each entry, where entries share a common id field in both tables, but I am not sure how to pull entries as a key=>value ...
Jface tableviewer multi sort columns
dear all, i am implementing a tableviewer that is able to sort values depengin on their column order. e.g. column1-column2-columnX sorts the rows first on the values of column 1, then column 2, column.... Therefore i want to use a ColumnViewerSorter, especially the method "int doCompare(Viewer viewer, Object e1, Object e2);" inside t...
TSQL Optimal / Acceptable table column count
What is the optimal / acceptable column count when you are designing a table that serves as a datastore for huge forms to be filled? ...
How do I keep one column consistently updated?
Hello, another newbie mysql question I have a faculty table, and each faculty has a certain number of students under him/her. So there is a 'current' column, which is the number of students currently under them. However, I don't want to ++ and -- everytime I switch a student to another faculty. Is there a way to keep the column update...
How do you specify a database column that contains a space in a linq statement
I thought this would have been quite common but can't find anything on this. I'm trying to query columns that have spaces immbedded within them. For the life of me I don't see a way of selecting them when I'm trying to assign them to an alias when creating an anonymous type result. Here's the code, but not sure how to go from here: D...