column

Using jqGrid with sortable columns... paging then results in a data/column mismatch.

I have a very vanilla jqGrid with "sortable: true" (which allows you to drag/drop to reorder the columns). There are 8 columns, none are hidden, none have any properties set other than name, index, and width. The column drag/drop works initially. I drag a column header, and drop it in a new location. The header and the data in the colum...

3 Column CSS Equal Height jQuery solution

Hey, I was working on a solution to my equal height three columns CSS equal height layout with jQuery, because the CSS workarounds were really giving me some trouble. I came up with the following code: $('.columns').css("height", "$('#detail').height()"); But for some reason, I don't see any effect when I reload my web page. I even ...

problem with wrapping jqGrid column headers on IE

Hi I'm using jqGrid in my pages, I modified the ui.jqgrid.css file to wrap the column headers like this: .ui-jqgrid tr.jqgrow td { white-space: normal !important; } .ui-th-column,.ui-jqgrid .ui-jqgrid-htable th.ui-th-column{ white-space:normal; } it works fine in all of the browsers but IE! I tried IE7 and IE8 and the probl...

Fixed-width HTML table with scrolling column group – is it possible?

A friend of mine asked me a question that I couldn't answer or figure out yet. The problem is: he wants to make an HTML table having width of 100% and many columns, of which the first one (or two) should be always visible, while others should scroll if their total width is higher than [width of the table (100%) minus width of the first ...

How to make a DataGridView column no-entry in VS2010/C#

Hi, I have a DataGridView which allows me to enter name/value pairs. The names are pre-defined, so the user just needs to enter a value. I have made the name (the first) column read-only so it can't be changed - that's great, but it can still be selected, and indeed, is by default when the form is displayed. Is it possible to make this...

Adding a column to a dataframe in R

I have the following dataframe (df) start end 1 14379 32094 2 151884 174367 3 438422 449382 4 618123 621256 5 698271 714321 6 973394 975857 7 980508 982372 8 994539 994661 9 1055151 1058824 . . . . . . . . . And a long vector with numeric values (vec). I would like to add to eac...

sqlplus compute sum of multiple columns with underline display before totals

I am attempting to generate a report with multiple numeric columns, each of which I am providing a column total. However, when I include each column in my "compute sum...on report" statement, only one of the columns displays a dash underline before the total amount. Is there a way to format all of the columns this way? Thanks. ...

How can I find the index of the maximum value in a matrix column in MATLAB?

I'm trying to find the maximum value of a certain column in a matrix. I want to find both the maximum value and the index of the row in which it is. How can I do this? ...

Sharepoint Edit or New item meta data page Title shows up twice...

current setup: 1. Parent content type (PCT1) has 5 columns (including Title column) 2. Child content type (CCT1-A) inherites from PCT1 and adds 5 more columns (but child ct also comes with it's own Title column). 3. Now I associates Child control type to a document library. 4. I see two titles in the edit item or new item page 5. If i d...

creating a "total" column in datagrid flex

Here is what I want to do: I want to have a datagrid that displays a total value for each row. Lets say for example I have a datagrid. In this datagrid on each row I have five columns. Of the five columns four are for the user to input numbers. The fifth column is the the "total" column which is the result of a formula that calculates t...

How to use secure encryption of an existing column in SQL Server 2005

I want to encrypt an existing column in SQL Server 2005, using an UPDATE statement, moving the old content into the new encrypted column. So I have 2 choices: Symmetric and Asymmetric. The issue I have is that with a symmetric key, I have to embed the password into an SP in order to read the column like: -- Create key (at some earlier...

how to counting data from each column in MySQL?

i have some mysql script for pivot table and then counting some data inside that: SELECT A.Line, week1.1stweek, week2.2ndweek, IFNULL(week1.1stweek,0) + IFNULL(week2.2ndweek,0) AS TOTAL FROM inspection_report AS A LEFT JOIN( SELECT Line, (SUM(S) + SUM(A) + SUM(B)*0.4 + SUM(C)*0.1)/COUNT(Serial_number) AS 1stweek...

Drop constraints for a certain column

I need to delete all constraints for a certain column. I found this related SO question but the indicated script actually deletes all constraints related to a certain table, not only for certain columns in it. Is there a way of dropping only constraints applied on a given column? Alternatively, my bigger problem is, how to drop a colum...

Evaluating expression of Facelets components in Richfaces sort

Hello guys, I have some problem evaluating expression in a Facelets component defined in a .taglib.xml SortField2.getExpression() gives me the value "#{sortBy}" instead of evaluating the value. My component (a simple column) is defined as: <ui:composition> <rich:column sortBy="#{sortBy}" width="#{width}" styleClass="#{style...

Change devexpress grid control column header caption

Hai all, How to change devexpress gridconrol column header caption using c#. please help ...

JTable column headers localization

I have a subclass of javax.swing.table.AbstractTableModel that defines table column headers like this: protected String[] columnNames = new String[] { "Column1", "Column2};. How do I localize the columnNames from a resource bundle? I want to read the column headers from a .properties file instead on hard-coding them in my code. Is there ...

itextsharp nextcolumn not working

Hi I'm trying to set up a simple 2 column page, write to the first column, then the second. However the code below places both paragraphs in the second column. The current column trace appears to be correct (first 0, then 1) Any ideas what I'm doing wrong? MultiColumnText columns = new MultiColumnText(); columns.AddSimpleColumn(0, 20...

pivot table: getting data from one column

lets say my table like: Date Status 2010-01-02 2010-01-03 accept 2010-01-03 accept 2010-01-03 reject 2010-01-03 2010-01-04 reject i want if value null, it means accept. Beside that i want show the result like: Date Accept Reject 201...

How to get checkBox object from c# Xtragrid colum

Hai all, Am using DevExpress XtraGrid control in C#.Net application.And binding one table values to grid,that table contain one bit field ("Authorized") so grid displaying with bit field column having checkBox.I want to get that checkBox object or get the event of that control. ...

How can I compare a variable to a MySQL full-text index without a gigantic loop?

Let's say I've got two tables: NOTES has two columns: ID and BODY. BODY is a FULLTEXT index. KEYWORDS has two columns: ID and KEYWORD. I want to search every BODY for every KEYWORD and get one row for each match, the NOTES.ID and the KEYWORD.ID. So if there were 15 notes and each one matched 3 keywords, I would get 45 rows. But as ...