ihave at table with columns sales(int),month (int) . i want to retrieve sum of sales corresponding to every month .i need ouput in form of 12 columns corresponding to each month.in which there will be single record containing sales for for each column(month) ...
The situation is, that i need to create table in grid view looking like this: ----------| ID---|---Name--|--1/2002--|--2/2002--|--1/2003--|........| 2/2009 | Cust1--| Cust2--| : : I have two tables in db - Customers and orders, throught LINQ to SQL DataContext ID and Name of the customers i´m getting from a simple query var custInfo = ...
Is there a way to calculate the maximum number of columns? Thanks. ...
I have a bunch of DIVs that contain textual information. They're all the same width (maybe 400px or so), but different heights. For space reasons, I'd like to have two or three columns of these DIVs (sort of like a want-ad section in a newspaper). See attractive ascii-art below :) DIV1 DIV3 DIV1 DIV3 DIV1 DIV1 DIV4...
I'm trying to split my footer so that there is left aligned and right aligned text. I have the following but the two elements are displaying one after the other: #footer { clear: both; background-color: #330066; padding: .5em; font-size: 0.8em; color: #fff; } #footer p .left { text-align:left; float:left; }...
So m.SourceCollection has 1000 records going into this, which is a collection of items with a Lat and Lon property; nothing else. I run this: var results = from locs in m.PlacesBeen group locs by new {locs.Lat, locs.Lon } into myGroup select new { Lat = myGroup.K...
I was thinking about my code, and I accidentally clicked the "Ln 74" at the botton of the MSVC++ window. I got a screen that said "Line number (1 - 136):", and it jumped the cursor to the line I entered. When I click the "Col 1" or "Ch 1" I get the same screen. I know Ln 74 means I'm on line 74, and Col 1 means I'm on column 1, but wh...
May be this question has been answered before but I couldn't find it. I am using a 2/3 yr old MySQL database which has hyphens in its column names. When I try to use these names from my Java code, the names are broken at the hyphen (e.g. air_port becomes air) and thus are not found. I tried replacing hyphens to underscores in my code ho...
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...
I am using gridView. I have 4 auto generated columns and 1 generated by my self. Now the column which i have generated is displayed first and then the auto generated columns. I want to display auto generated columns first then my generated column. ...
Hi all, I have a couple of tables which look like this Table 1 user_id | name ------------------------- x111 | Smith, James x112 | Smith, Jane etc.. Table 2 id | code | date | incident_code | user_id ----------------------------------------------------------------- 1 | 102008 | 10/2...
There are 2 columns that I want data from. Basically I want to see new signups per day. Go easy on me, my first day with mysql (or any DB for that matter) So far I have this mysql> select created, count(id) from user group by created; +---------------------+-----------+ | created | count(id) | +---------------------+-------...
I would like to be able to add / remove columns to my datagrid, based on UI inputs from the user. Is this possible? Any good articles on this? Thanks, Mark ...
Possible Duplicates: The 80 column limit, still useful? Studies on optimal code width? I do not remember where I read that. That would make it easier to print out the code. ...
Hi, I'm making issue tracking portal based on Sharepoint. Users should be able to add entries, but in the entry itself i want one column be only visible to specific group of users (Administrators). Is there a way to set column based access control? Thanks in advance ...
First of all, hello all. This problem is driving me to insanity so I hope for a simple solution Here is an image of what I wanted originally. But I didnt want to use hacks to get Box 1 and (Box 2+Box 3) to expand with each other. So I will just use a background color on the wrapper instead so its not noticeable that they have differe...
I have two columns in the table hours at sea - Would be good to be able to store hours and mins so you could say at sea for 1hr and 20mins and to be able to add up all the hours and minutes easily. team - this stores IDs from the team table, so you may have ids 1,3,10,23,45,34. Number in team changes often. So which types would you us...
I'm trying to do documentation on an SQL server 2008 database. This includes listing all tables, their columns, and the column types. I've been so far as to use "get-childitem | get-member" while browsing the table, the column, and the column's extended properties, and none of them return the data type of the columns. Is there a way to l...
The definition I found for the blueprint css class called .column says: .column Use with .span-x classes to create combinations of columns in the layout. But the span-x classes seem to overlap this functionality since they allow columns to be defined without referring to .column? Could someone explain what distinguishes these two cla...
Hey all, I see this post on highlighting even columns but can I highlight only selected columns? Here is the code they use: $("table.Table22 > tbody > tr > td:nth-child(even)").css("background","blue"); But I would like: NOTE: the class="highlight" will be on the selected columns, so if I selected column 3 the class="highlight" woul...