Search Results

Search found 24675 results on 987 pages for 'table'.

Page 118/987 | < Previous Page | 114 115 116 117 118 119 120 121 122 123 124 125  | Next Page >

• TableAdapter UpdateCommand For Table Without Primary Key

  - by Steven

  What is the syntax for an Update query for a table without a primary key? Disclaimer: Frustratingly, adding a primary key is not an option. My program is a small program in a much larger system with poor data management. My development time does not include rewriting the other software.

  Read the article

• Using mysqlimport where the filename is different from the table name

  - by Mike Q

  Hi all, I've been playing with mysqlimport and I've run into the restriction where the filename has to be the same as the table name. Is there any way to work round this? I want to use mysqlimport not LOAD INFILE.

  Read the article

• Azure table storage: maximum variable size ?

  - by Egon

  I will be using the table storage to store a lot of blob names, in a single string, appended to each other using some special character. This string will sky rockets pretty soon. But is there a maximum size to the length of a property for a particular entity ? in my case the string ?

  Read the article

• SQL Server combining 2 rows into 1 from the same table

  - by Maton

  Hi, I have a table with an JobID (PK), EmployeeID (FK), StartDate, EndDate containing data such as: 1, 10, '01-Jan-2010 08:00:00', '01-Jan-2010 08:30:00' 2, 10, '01-Jan-2010 08:50:00', '01-Jan-2010 09:05:00' 3, 10, '02-Feb-2010 10:00:00', '02-Feb-2010 10:30:00' I want to return a record for each EndDate for a Job and then the same employees StartDate for his next immediate job (by date time). So from the data above the result would be Result 1: 10, 01-Jan-2010 08:30:00, 01-Jan-2010 08:50:00 Result 2: 10, 01-Jan-2010 09:05:00, 02-Feb-2010 10:00:00 Greatly appreciate any help!

  Read the article

• What does the "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION" checkbox do in phpmyadmin

  - by aslum

  Under the structure tab, when EXPORTing a database using phpmyadmin there is a check box labeled: Add DROP TABLE / VIEW / PROCEDURE / FUNCTION What does this do?

  Read the article

• hibernate for dynamic table creation

  - by user369316

  i AM A HIBERNATE BEGINNER ,Since i need to create dynamic tables with dynamic fields in them i chose to use hibernate . As far as my understanding , creating tables requires a class with the fields defined in the class . How do i generate the classes dynamically based on the table with the required fields ?

  Read the article

• Table Valued UDF vs Views

  - by vaibhav

  I have never used UDF in sql server. Today I got to know that we can have functions which can return a table. So I just wanted to know can I use functions in place of views. If yes, which one is the better choice and why

  Read the article

• jQuery related item table highlighter

  - by Forkrul Assail

  I have a table fill with cell items. If I click on a cell item, that cell item is 'linked' or related to other cell items, which need to be highlighted. If another cell item is clicked, that cell's related cells need to light up. Is there a jQuery plugin to accomplish something like this? Or would I have to look into writing one myself?

  Read the article

• Display Multiple Form Submit Buttons Inline Same Line In IE8 In Table

  - by aherrick

  I am trying to display two form submit buttons on the same line inside a table. In IE7 the following code works great, however in IE8 the Delete button drops down to the next line even though I declared the form to display inline. Any suggestions? I created a basic test page here to show the issue: http://ajondeck.net/test/displayinline.html

  Read the article

• minus value in mysql table not worked

  - by Richa Media and services

  in my mysql table i want to use minus value. if i do 0 -1 = -1 but he work as 0 -1 = 2147483647 what i do for it.

  Read the article

• access: read CSV file into table

  - by every_answer_gets_a_point

  is it possible to programmatically have access open a certain csv file and read it into a datasheet and set parameters like what time of delimiter, TEXT QUALIFIER etc, including all the steps that one takes to manually import a csv file into a table?

  Read the article

• reset the data in the table of data set in c#.net

  - by shruti

  im populating the data in the combo box using dataset tables...with some table name..now i want to clear those entries or data populated in the combobox every time when the button is clicked...so that new entries can be done.... is there any way to clear the comobo box values??

  Read the article

• IB Linking iPad SplVC table view

  - by Sam Jarman

  hey guys When you have an iPad Project, and you want to put a table view in your landscape view... I did this i dragged in a UITableView. but what do you 'hook' the data source to? there are about 3 options that all seem to crahing for me... when not hooked up, app launches fine. Any help would be appreciated. Cheers Sam

  Read the article

• Html Table styles

  - by Hulk

  Can any body point me to the links which has some table beautification code like the one mentioned and easy to implement http://24ways.org/2005/tables-with-style Thanks..

  Read the article

• Get table with maximum number of rows in a page using BeautifulSoup

  - by Mridang Agarwalla

  Hi, Can anyone tell me how i can get the table in a HTML page which has a the most rows? I'm using BeautifulSoup. Thanks.

  Read the article

• Using NSPredicate to segment table by dates in iPhone

  - by pabloruiz55

  I have an array of dictionaries with several jobs. I want to have a table display these jobs sorted by month - year. How could i divide that array so i end up having for example: section: july 2009 and the amount of rows for each job in that date. section: august 2009 and the amount of rows for each job in that date. and so on. Thanks

  Read the article

• Creation date column in SQL table

  - by MatsT

  What is the easiest way to automatically fill a datetime column in an SQL data table with the date the row was created? Using SQL Server 2005 if that matters.

  Read the article

• Summarising (permanently) data in a SQL table

  - by Cylindric

  Geetings, Stackers. I have a huge number of data-points in a SQL table, and I want to summarise them in a way reminiscent of RRD. Assuming a table such as ID | ENTITY_ID | SCORE_DATE | SCORE | SOME_OTHER_DATA ----+-----------+------------+-------+----------------- 1 | A00000001 | 01/01/2010 | 100 | some data 2 | A00000002 | 01/01/2010 | 105 | more data 3 | A00000003 | 01/01/2010 | 104 | various text ... | ......... | .......... | ..... | ... ... | A00009999 | 01/01/2010 | 101 | ... | A00000001 | 02/01/2010 | 104 | ... | A00000002 | 02/01/2010 | 119 | ... | A00000003 | 02/01/2010 | 119 | ... | ......... | .......... | ..... | ... | A00009999 | 02/01/2010 | 101 | arbitrary data ... | ......... | .......... | ..... | ... ... | A00000001 | 01/02/2010 | 104 | ... | A00000002 | 01/02/2010 | 119 | ... | A00000003 | 01/01/2010 | 119 | I want to end up with one record per entity, per month: ID | ENTITY_ID | SCORE_DATE | SCORE | ----+-----------+------------+-------+ ... | A00000001 | 01/01/2010 | 100 | ... | A00000002 | 01/01/2010 | 105 | ... | A00000003 | 01/01/2010 | 104 | ... | A00000001 | 01/02/2010 | 100 | ... | A00000002 | 01/02/2010 | 105 | ... | A00000003 | 01/02/2010 | 104 | (I Don't care about the SOME_OTHER_DATA - I'll pick something - either the first or last record probably.) What's an easy way of doing this on a regular basis, so that anything in the last calendar month is summarised in this way? At the moment my plan is kind of: For each EntityID For each month Find average score for all records in given month Update first record with results of previous step Delete all records that aren't the first I can't think of a neat way of doing it though, that doesn't involve lots of updates and iteration. This can either be done in a SQL Stored Procedure, or it can be incorporated into the .Net app that's generating this data, so the solution doesn't really need to be "one big SQL script", but can be :) (SQL-2005)

  Read the article

• <table> column and row style....

  - by jitendra

  I've a <table> which has 10 column and 10 row i want to give different background to 1st and and 3rd column and another different background color to 8th row . is it possible without css class/id

  Read the article

• sql query for fetching distinct records from table having count greater than 3

  - by saurav

  i have a table with coloumn id , name and city I want to fetch those rows where city is same and the number of rows are greater than 3. Is it possible in single sql query?

  Read the article

• I cannot get the value of a table view cell in cocoa

  - by Michael Amici

  I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great. int numberOfChecks = -1; numberOfChecks = numberOfChecks +1; if ([objectsForTable count]-1 >= numberOfChecks) { UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks]; NSString *cellTitle = cell.textLabel.text; }

  Read the article

• retrieving description item from sql server table column

  - by Pablo

  is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc?

  Read the article

• Conditional row coloring in a PocketPyGUI table (PythonCE)

  - by PabloG

  I'm working on a an PythonCE application, using the PocketPyGUI toolkit. I'm using the gui.Table control to display a large list of choices (addresses, codes and data associated), and I want to assign a different color to the rows that have been completed. Is there any way to colorize the rows given certain conditions? TIA, Pablo

  Read the article

• Getting $_POST variable from table

  - by Sakamoto Kazuma

  I'm trying to build a sort of resource allocation form. I'd like to be able to print a table from a database, and then allow users to click on each cell that they would like to reserve. Also, being able to drag and select multiple cells. Then send all of this via $_POST to another php script. Problem is, I have no idea where to start. Any suggestions?

  Read the article

• ado sql update table with result of group by query

  - by brett

  I am trying to update records in an .mdb table with the number of records containing the same value The sql below does not work but I think gives an indication of what I am trying to achieve. UPDATE table1 AS A INNER JOIN (SELECT PH_BSP , Count(PH_BSP) AS PHCOUNT FROM table1 GROUP BY PH_BSP) AS B ON A.PH_BSP=B.PH_BSP SET A.PH_SORT = B.PHCOUNT; any ideas?

  Read the article

< Previous Page | 114 115 116 117 118 119 120 121 122 123 124 125  | Next Page >