Search Results

Search found 6257 results on 251 pages for 'columns'.

Page 38/251 | < Previous Page | 34 35 36 37 38 39 40 41 42 43 44 45  | Next Page >

• how to put array of user control in the columns of Grid.

  - by jolly

  Hi I have array of Employee data which includes photo,description, title name,salary. I have to show each employee data in separate panel control structure that means if I have 10 employees there will be 10 panels. and I have to show these panels in a grid which has two columns. Also width of the panel in each column will vary according to main…

  Read the article

• How do I specify unique constraint for multiple columns in MySQL?

  - by Niyaz

  I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want to make the columns user, email, address unique (together). How do I do this in MySql? Thanks in advance. Of course the example is just... an example. So please don't worry about the semantics.

  Read the article

• How to list all duplicated rows which may include NULL columns?

  - by Yousui

  Hi guys, I have a problem of listing duplicated rows that include NULL columns. Lemme show my problem first. USE [tempdb]; GO IF OBJECT_ID(N'dbo.t') IS NOT NULL BEGIN DROP TABLE dbo.t END GO CREATE TABLE dbo.t ( a NVARCHAR(8), b NVARCHAR(8) ); GO INSERT t VALUES ('a', 'b'); INSERT t VALUES ('a', 'b'); INSERT t VALUES ('a', 'b');…

  Read the article

• Name that blog entry - Modelling changes over time with two db columns only.

  - by disown

  I vaguely remember reading a blog entry (written by a well-known blogger I think) about how to model price changes over time, and that you could model most changes by saving two dates only (two columns in a db). The blog talked about prices on a website changing over time and how you could figure out the right price to charge knowing only when…

  Read the article

• SQL Server: How do I convert all varchar(max) columns to text type?

  - by bakerjr

  How do I convert all varchar(max) columns to text type? I know varchar(max) is recommended but I still want to use type text because CakePHP doesn't automagically convert varchar(max) to textarea (HTML form). How do I do it? Thanks in advance

  Read the article

• How can I provide values for non-grouped columns in NHibernate?

  - by ddc0660

  I have a criteria query: Session.CreateCriteria<Sell043Report>() .SetProjection(.ProjectionList() .Add(LambdaProjection.GroupProperty<Sell043Report>(r => r.location)) .Add(LambdaProjection.GroupProperty<Sell043Report>(r => r.agent)) .Add(LambdaProjection.GroupProperty<Sell043Report>(r =>…

  Read the article

• [R] How to create a data.frame with a unknow number of columns ?

  - by Olivier

  Hello I would like to create, in a function, a boucle to create a data.frame with a variable number of columns. WIth something like : a = c("a","b") b = c(list(1,2,3), list(4,5,6)) data.frame(a,b) I would like to get a data-frame like : a 1 2 3 b 4 5 6 Instead of I obtain : a 1 2 3 4 5 6 b 1 2 3 4 5 6 Thank you !…

  Read the article

• How to set fixed width for columns of a table with expand/collapse functionality?

  - by Cagey

  I have a table with expand/collapse functionality. How do I enforce fixed width for columns in such a table? I used COL tags with width property. But the table becomes distorted when I expand/collapse the rows.

  Read the article

• How do I assign different weights to columns in SQL Server Full Text Search?

  - by gcaprio

  I'm using SQL Server 2008 FTS and I'd like to be able to integrate weighted rankings into my search results. However, I'd like to weight the columns that a search term is found in differently. For example, if I have a Title column and a Description column, I want matches fond in Title to rank higher than matches in Description. Is…

  Read the article

• How are lookup columns for lists maintained in Sharepoint Content database?

  - by Abhishek Rao

  Can someone explain how are lookup columns for lists maintained in Sharepoint Content database? How is the relationship maintained in the database?

  Read the article

• Is it possible to set a SQL server columns' description using a fluent nhibernate map?

  - by Simon

  I am using my fluent nhibernate mappings to generate my MS SQL Server database. I would like to be able to set a columns' description as part of this generation.

  Read the article

• Do you have a hard time keeping to 80 columns with Python?

  - by ApplePieIsGood

  I find myself breaking strings constantly just to get them on the next line. And of course when I go to change those strings (think logging messages), I have to reformat the breaks to keep them within the 80 columns. How do most people deal with this?

  Read the article

• Does Oracle re-hash the driving table for each join on the same table columns?

  - by thecoop

  Say you've got the following query on 9i: SELECT /*+ USE_HASH(t2 t3) */ * FROM table1 t1 -- this has lots of rows LEFT JOIN table2 t2 ON t1.col1 = t2.col1 AND t1.col2 = t2.col2 LEFT JOIN table3 t3 ON t1.col1 = t3.col1 AND t1.col2 = t3.col2 Due to 9i not having RIGHT OUTER HASH JOIN, it needs to hash table1 for both…

  Read the article

• How to convert rows returned by a query into columns in oracle?

  - by Piyush Lohana

  I have to display the results of the below query as columns. select to_char(sysdate + 1 - rownum,'MON-YYYY') as d from all_objects where trunc(sysdate + 1 - rownum,'MM') = trunc(to_date(:from_date,'MON-YYYY'),'MM') minus select to_char(sysdate + 1 - rownum,'MON-YYYY') as d from all_objects where trunc(sysdate + 1 -…

  Read the article

• Can you get Tableau to work with sparse columns?

  - by Clay

  We are evaluating Tableau and noticed that it doesn't appear to recognize sparse columns in our SQL Server 2008 tables. Is this possible or are there any common workarounds?

  Read the article

• Effects of order of columns, while defining an index on them, on the performance of the queries

  - by Hossein

  Hi, Does order of the columns in an Index definition for a table in a database has any effect on the performance? for e.g. are these two queries different ? CREATE INDEX xxx ON tablex(col1,col2) CREATE INDEX xxx ON tablex(col2,col1) what about the in case that I use a BTREE index? I am using Mysql. thanks

  Read the article

• How to sort a data table if we are using <t:columns> in JSF?

  - by Hari

  Hi I am studying tomahawk, I just want to know if I generate a datatable using <t:columns> then how to sort the dataTable on the click on the header of that particular column, like we are using <t:commandSortHeader> in normal <t:column> attribute. Kindly Help.

  Read the article

• How to use 2 or more columns with FlowDocumentScrollReader (WPF) ?

  - by ArielR

  Hi, I would like to use at the same time multiple columns and scrollbar with FlowDocument. Is that possible ? Actually, I can only have multiple column in page mode but no scrollbar. Thanks !!

  Read the article

• Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.

  - by Anilkumar

  while inserting into temp table inside a cursor am getting this error Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.

  Read the article

• How to quickly re-sort a MySQL table by one of the columns?

  - by Vacilando

  What are the most efficient SQL queries that would take an existing MySQL table and re-sort it by one of the columns? Not a selection, but the whole table should be sorted by one column. Somehow using a temporary table, I guess, but what's the best way?

  Read the article

• How do you query a MySQL table columns highest entry and store it in a variable.

  - by user315819

  How do you query a MySQL table columns highest entry and store it in a variable. Here is what I have but it is not working. $query = "SELECT MAX(date) FROM Records WHERE ips='$currentip'"; $result = mysql_query($query) or die(mysql_error()); echo $result;

  Read the article

• How could i get selected value from dropdownlist in kendo ui grid in mvc

  - by Karthik Bammidi

  I am working on Kendo UI with asp.net mvc razor. I am trying to bind database table data with kendo grid that supports CRUD operations. Here i need to populate a dropdownlist for one of my table field. I have used the following code View: @model IEnumerable<MvcApplication1.PriceOption> …

  Read the article

• How can I generate HTML tables in Perl?

  - by anon

  I need to create a 2 tables in HTML format. Each has 5 rows: 1st Table 1st row has FRUITS in it, occupying all columns 2nd row has January(month), occupying all columns 3rd row has names of some 6 fruits (apple, orange, grapes,...)These names do not change. so this row has 6 columns 4th row has…

  Read the article

• Using pthread to perform matrix multiplication

  - by shadyabhi

  I have both matrices containing only ones and each array has 500 rows and columns. So, the resulting matrix should be a matrix of all elements having value 500. But, I am getting res_mat[0][0]=5000. Even other elements are also 5000. Why? #include<stdio.h> #include<pthread.h>…

  Read the article

• How to mix HTML in Perl

  - by anon

  Hi, I need to create a 2 tables in html format. each has 5 rows. 1st Table *) 1st row has FRUITS in it, occupying all columns *) 2nd row has January(month), occupying all columns *) 3rd row has names of some 6 fruits (apple, orange, grapes,...)These names do not change. so this row…

  Read the article

< Previous Page | 34 35 36 37 38 39 40 41 42 43 44 45  | Next Page >