Search Results

Search found 52538 results on 2102 pages for 'two column layout'.

Page 73/2102 | < Previous Page | 69 70 71 72 73 74 75 76 77 78 79 80  | Next Page >

  • SQL Select between two fields depending on the value of one field

    - by Filip
    Hi. I am using a PostgreSQL database, and in a table representing some measurements I've two columns: measurement, and interpolated. In the first I've the observation (measurement), and b is the interpolated value depending on nearby values. Every record with an original value has also an interpolated value. However, there are a lot of records without "original" observations (NULL), hence the values are interpolated and stored in the second column. So basically there are just two cases in the database: Value Value NULL Value Of course, it is preferable to use the value from the first column if available, hence I need to build a query to select the data from the first column, and if not available (NULL), then the database returns the value from the second column for the record in question. I have no idea how to build the SQL query. Please help. Thanks.

    Read the article

  • Dynamic Data - Make Friendly Column Names?

    - by davemackey
    I've created a Dynamic Data project with an Entity Framework model. It works nicely. But, right now it shows all my database tables with the db column names - which aren't always the most friendly (e.g. address_line_1). How can I got about giving these more friendly column titles that will display to the end user?

    Read the article

  • .htaccess two different rules but only one per time

    - by dragon112
    I'm rather new to the whole .htaccess thing and I'm using the following right now to use 'pretty url's': <IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME} !-f RewriteRule ^(.*)$ index.php?path=$1 [NS,L] </IfModule> Now i found my website a bit slow and decided to start gzipping my CSS files thru a php script I found somewhere on the web (the website). For this to work I need to rewrite the url to open the correct php file. That would look something like this: RewriteRule ^(.*).css$ /csszip.php?file=$1.css [L] But I only want the first to happen when the second doesn't and vice versa. In other words i'd like something like this: <IfModule mod_rewrite.c> RewriteEngine On if request doesn't contain .css do RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME} !-f RewriteRule ^(.*)$ index.php?path=$1 [NS,L] else do RewriteRule ^(.*).css$ /csszip.php?file=$1.css [L] </IfModule> Can anyone help me with the proper code or a place where i can find a way to use some kind of conditional statement in htaccess files? Thanks in Advance!:)

    Read the article

  • Highlight column when a row is clicked, depending on condition

    - by Fredrik
    We have a large matrix with lists of servers on the rows and persons as columns. Then we mark the column/row with an X if the person has access to the server. Pretty basic. But as the matrix grows, it becomes more difficult to quickly find the right person with access. So I'd like some way to make it easier to use In the example above I have clicked on the row "Resource B" and would like all the columns where there is an "X" (User 1, User 2) to be highlighted somehow. Then if I click the row for "Resource C", "User 1" should be highlighted.

    Read the article

  • MySQL - Update the same column twice

    - by uzioriluzan
    Hello, I need to update a column in a mysql table. If I do it in two steps as below, is the column "col" updated twice in the disk ? update table SET col=3*col, col=col+2; or is it written only once as in : update table SET col=3*col+2; Thanks

    Read the article

  • Concatenate Row and Column names from Data.Frame

    - by user338714
    Is there a way to concatenate the row and column names from an existing data.frame into a new data frame. For example, I have column names of (A, B, C) and row names of (1, 2, 3) and I would like to combine these into a 3x3 matrix [A1, B1, C1; A2, B2, C2; A2, B2, C2]. Thanks for your help

    Read the article

  • Problem when trying to disappear a column

    - by eddy
    I need to hide a column as well as other elements when my page is printed , and in order to do that I have a print style sheet, everything works fine, except for the column I want to make disappear, the strange thing is that my stylesheet works in IE , but it didn't in Mozilla and chrome, why's that? Html code <col width="10%" class="art-editcolumn"/> and here's the CSS class: .art-editcolumn { display: none; } Hope you can help me out with this.

    Read the article

  • Dynamic column heading from user input

    - by user79127
    Hi, How can I use the user input for column heading in reporting service please? My situation is User will enter first (200901) and the second parameter (05). I want to display the column heading like 200901 200902 200903 200904 200905 Thanks for all helps.

    Read the article

  • How can I add custome column on NewForm.aspx on SharePoint 2007

    - by kedk
    There is a custome column name "Tag" in my Discussion List. How can I add a textbox to init "Tag" column when I new one. As we know, NewForm.aspx only show Subjet, Body textbox as default. But only show Body text when reply. How can i custome NewForm.aspx to show Subject, Tag,Body textbox when I new one and only show Body textbox when reply. Thanks

    Read the article

  • SQL - Add up all row-values of one column in a singletable

    - by ThE_-_BliZZarD
    Hello Everybody, I've got a question regarding a SQL-select-query: The table contains several columns, one of which is an Integer-column called "size" - the task I'm trying to perform is query the table for the sum of all rows (their values), or to be more exact get a artifical column in my ResultSet called "overallSize" which contains the sum of all "size"-values in the table. Preferable it would be possible to use a WHERE-clause to add only certain values ("WHERE bla = 5" or something similar). The DB-engine is HSQLDB (HyperSQL), which is compliant to SQL2008. Thank you in advance :)

    Read the article

  • 42S22 SQL error: Column not found, why?

    - by Vincenzo
    This is my SQL: SELECT `tbl`.*, 123 AS `test` FROM `tbl` GROUP BY `test` It works when I run it directly in MySQL. But PDO says: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'test' in 'field list' Why so? How to cure this problem? I'm using Zend_Db.

    Read the article

  • Getting all rows from a Table where the column contains only 0

    - by Auro
    I got a little problem i need a sql query that gives all rows back that only contains 0 in it. the column is defined as varchar2(6) the values in the column looks like this: 0 00 00 100 bc00 000000 00000 my first solution would be like this: Oracle: substr('000000' || COLUMN_NAME, -6) = '000000' SQL Server: right('000000' + COLUMN_NAME, 6) = '000000' is there an other way? (it needs to work on both systems)

    Read the article

  • Add an column to dataset in .net 1.1

    - by prince23
    hi, i have dataset(dataset name dsEmp) with an 25 columns , here i need to add an new column with columname as "EndDate" of data type as string now i need to import all the data from column18 whose datatype is Datetime to the newely created datacolumn "EndDate" once we import all the data from the column 18 to the newcolumn "EndDate" , we should remove the column18 hope my Question is clear, can any one please help me this.

    Read the article

  • match two data.frame

    - by Elb
    I have a situation like this: DF1 COL1 COL2 COL3 ... a b c b d b f e a g m f DF2 COL a b c d e f g h i l m n o I would like to match each column of DF1 with the only one column of DF2 and score how many occurrence of DF2 are in each column of DF1. How this can be done? Thanks in advance, E.

    Read the article

< Previous Page | 69 70 71 72 73 74 75 76 77 78 79 80  | Next Page >