Search Results

Search found 6407 results on 257 pages for 'reorder columns'.

Page 142/257 | < Previous Page | 138 139 140 141 142 143 144 145 146 147 148 149  | Next Page >

• NoSQL vs Relational Coding Styles

  - by Chris Henry

  When building objects that make use of data stored in a RDBMS, it's normally pretty clear what you're getting back, as dictated by the tables and columns being queried. However, when dealing with NoSQL, document-based systems, it's less clear what is being retrieved. What are common methods of keeping track of structure in which data is stored?

  Read the article

• How should i store availability calendar information in mysql? for [id] [date] [available/unavailab

  - by Haroldo

  I'm building a simple calendar for holiday cottages to show when they are booked or available. What would be the fastest mysql table design for this, bearing in mind when users mark dates as available/booked they will do so via a start date and an end date. i can see 2 obvious options Store 'booked' data for every day [more rows] or, store 'booked' data with 2 columns a start_date and end_date [more processing?] Which is best or is there another method i'm missing?

  Read the article

• How to display HTML-like table data on iPhone?

  - by Jason

  I have a set of data in a matrix which I would like to display in my iPhone app with all of the rows and columns intact. Everything I can find on the web dealing with "tables iPhone" gives me information on UITableView, which only lets you show a list of items to the user - not an actual table in the HTML sense. What's the best way on the iPhone to display an actual table of data to the user, with column & row headings and table cells?

  Read the article

• magento show categories on left sidebar on a page

  - by misulicus

  I cant manage to show on a page, on the left side the categories. I selected for the page under Design - layout to 3 columns, Right side shows fine but nothing on left side. New to magento so i`m not sure in wich file in the template i have to look for. Its a custom template installed so i got so far to: app/design/frontend/default/f001/template/ but not sure now if to look under catalog or paeg folders

  Read the article

• How effecient is a details table?

  - by Jeffrey Lott

  At my job, we have pseudo-standard of creating one table to hold the "standard" information for an entity, and a second table, named like 'TableNameDetails', which holds optional data elements. On average, for every row in the main table will have about 8-10 detail rows in it. My question is: What kind of performance impacts does this have over adding these details as additional nullable columns on the main table?

  Read the article

• Getting data from ListView control

  - by James

  I need to retrieve my data from a ListView control set up in Details mode with 5 columns. I tried using this code: MessageBox.Show(ManageList.SelectedItems(0).Text) And it works, but only for the first selected item (item 0). If I try this: MessageBox.Show(ManageList.SelectedItems(2).Text) I get this error: InvalidArgument=Value of '2' is not valid for 'index'. Parameter name: index I have no clue how I can fix this, any help? Edit: Sorry, should have said, I'm using Windows.Forms :)

  Read the article

• draw rectangle in grid

  - by kombsh

  Please find the attached image in this posting. We have a requirement to draw a rectangle at run time on selected grid columns.The rectangle must cover all of the selected grid cells as the described in the below image.

  Read the article

• How to manage and make look of complex data <table> identical in all browser?

  - by metal-gear-solid

  What are helpful CSS properties which can be helpful for table? I have to make so many complex tables which have different type of colors in columns, thead, borders, padding, alternate row and column colors etc. I want to use as less as possible of css classes. How to make complex tables design with combination of as much as possible of HTML tags and CSS properties? and should look identical in all browsers.

  Read the article

• Lucene MultiFieldQueryParser which column of the three generated the hit

  - by user549432

  I am using Lucene MultiFieldQueryParser and the implementation is as shown below QueryParser parser = new MultiFieldQueryParser (Version.LUCENE_30,new String[] {"First Name","Middle Name","Last Name"}, standardAnalyzer); Query query = parser.parse(queryString); and using it to find a match for the input string in my DB columns First Name, Middle Name and Last name . I am able to get the hits with normal search and fuzzy search - The only problem I am facing is finding which column of the three generated the hit - Can you pls help me here - Thanks

  Read the article

• ListView: Display data divided into groups?

  - by jawonlee

  I would like to display the contents of a DataTable, divided into several groups depending on the value of one of the columns. So, if I have a DataTable (from SQL query) with: GroupID Name Description 1 foo bar 1 one two 2 some thing I would like to place all records containing GroupID 1 in one div, all records with GroupID 2 in another div, and so on. How can I do this? I'm writing in ASP.NET 4.0, with C# codebehind.

  Read the article

• Retrive column names of a table into a combo box

  - by syedsaleemss

  Im using c# windows form application. I have a database with many tables. Each table has several columns. I need to populate the combo box with the column names for a selected table.

  Read the article

• MYSQL: Udate table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• how to select the records whose several fields' combination will equal to a specific value

  - by poiu2000

  Hi all, Assume I have the following style table, col1 col2 and col3 have same value scopes, I want to select the records when two of the 3 columns have a value combination such as ('ab' and 'bc'), in the following example, the first 3 records should be selected. Any good way to do this? I am using Sybase. | id | col1 | col2 | col3 | 1 ab bc null 2 null ab bc 3 ab ab bc 4 de ab xy Thanks.

  Read the article

• Variable table or column names.

  - by Frank Computer

  INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some columns, example: company.code char(3) {abc} company.brach char(2) {01} Can I construct table name "abc01" for inclusion in SELECT * FROM abc01; ? In other words, a variable table name.. same question applies for column names.

  Read the article

• How to get an array size

  - by John Doe

  I'd like to know how to get an array rows & columns size. For instance it would be something like this: int matrix[][] = { { 2, 3 , 4}, { 1, 5, 3 } } The size of this one would be 2 x 3. How can I calculate this without including other libraries but stdio or stdlib?

  Read the article

• i want to add a column in my table

  - by Abid

  there is already some columns added in my table starsin.. i want to add a column address in my table starsin by using a query..

  Read the article

• When to use reflection to convert datarow to an object

  - by Daniel McNulty

  I'm in a situation now were I need to convert a datarow I've fetched from a query into a new instance of an object. I can do the obvious looping through columns and 'manually' assign these to properties of the object - or I can look into reflection such as this: http://www.codeproject.com/Articles/11914/Using-Reflection-to-convert-DataRows-to-objects-or What would I base the decision on? Just scalability??

  Read the article

• how to use fillWeight property and yet enable horizontal scrolling

  - by GreatWorld

  I have a few columns in a dataGridView want them to fill the space. column A has a fixed width column B can be long and scrolling should be possible column C is fixed- unresizeable, and minimum width is set. what is the way to use these property for achieving the desired behavior

  Read the article

• How to use another type of EditingControl in a single .NET 3.5 DataGridView column ?

  - by too

  Is this possible to have two (or more) different kinds of cells to be displayed interchangeably in single column of C# .Net 3.5 WinForms DataGridView? I know one column has specified single EditingControl type, yet I think grid is flexible enough to do some tricks, I may think of only: Adding as many invisible columns to grid as required types of cells and on CellBeginEdit somehow exchange current cell with other column's cell Creating custom column and custom cell with possibility of changing EditingControl for single cell Which approach is better, is there any other solution, are there any examples ?

  Read the article

• Cloning the datatable to datagridview does not copying the records to datagridview.

  - by Harikrishna

  I am copy the datatable records to datagridview to dispaly those records Datagridview1.DataSource=dataTable1.Clone(); But only columns are copied not records,what the problem can be ?

  Read the article

• How to get the top most parent in PostgreSQL

  - by wereach

  I have a tree structure table with columns: id,parent,name. Given a tree A-B-C, how could i get the most top parent A's ID according to C's ID? Especially how to write SQL with "with recursive"? Thanks!

  Read the article

• Count if with two criteria excel vba

  - by Manasa J

  can some one help me create a macro for the following Data.The values in GradeA,GradeB etc.. columns need to be populated by checking sheet1 ColumnB(Student Name) and columnH(Grade).I need both row wise and Column wise total. Student GradeA GradeB GradeC GradeD GradeE GrandTotal Std1 1 0 2 0 0 3 Std2 0 0 0 1 1 2 Std3 1 0 1 0 0 2 Std4 0 2 0 3 0 5 Std5 0 1 2 1 0 4 Std6 1 0 2 0 2 5 Grnd 3 3 7 5 3 21

  Read the article

• Where is all_nested_table_cols in 9i?

  - by thecoop

  Oracle 9i has nested tables, however it doesn't have the all_nested_table_cols sysview (like 10g and 11g) which lets me see what the columns are for these nested tables. How can I find this information on a 9i database?

  Read the article

• Need recommendation for a table structure

  - by yapiskan

  I have an entity which has 4 different types of property that could have only one value for each case which are boolean, decimal, string or text. I don't want to define the table with 4 boolean, decimal, nvarchar and ntext columns. What would you recommend to cover this case?

  Read the article

• Query on Vertical partitioning in Sybase

  - by Sairam

  hi, Am working with sybase.In that i have a table A of some 2 million records containing some columns which i want to move out and make it as a separate table B. I have some questions in this process... 1. I have decided to use vertical partitioning.Is that ok? 2.Or what other technique can i go about using in this process? Please provide your valuable inputs in this. Thanks.

  Read the article

< Previous Page | 138 139 140 141 142 143 144 145 146 147 148 149  | Next Page >