Search Results

Search found 7311 results on 293 pages for 'rows'.

Page 178/293 | < Previous Page | 174 175 176 177 178 179 180 181 182 183 184 185  | Next Page >

• Replace with wildcard, in SQL

  - by Jay

  I know MS T-SQL does not support regular expression, but I need similar functionality. Here's what I'm trying to do: I have a varchar table field which stores a breadcrumb, like this: /ID1:Category1/ID2:Category2/ID3:Category3/ Each Category name is preceded by its Category ID, separated by a colon. I'd like to select and display these…

  Read the article

• How to Prevent SelectionChange a Silverlight DataGrid

  - by Matt Eland

  I'm using a Silverlight 3 DataGrid control and have set the SelectionMode to Extended. The DataGrid takes care of managing the extended selection for me in an almost perfect manner out of the box, but a key piece of the logic is interfering with me. I have a cell that can function as a drag and drop thumb and initiate a drag operation but…

  Read the article

• No scrolling occurs when UITableView scrollToRowAtIndexPath is invoked

  - by theactiveactor

  My view contains a simple TableView with 6 rows and a button that invokes doScroll when clicked. My objective for doScroll() is simply scroll to the 5th cell such that it's at top of the table view. - (void)doScroll: (id)sender { NSIndexPath *index = [NSIndexPath indexPathForRow:4 inSection: 1]; [m_tableView…

  Read the article

• Ext GWT (GXT) tooltip over a grid row

  - by Eduardo Palma

  I'm developing a custom tooltip using Ext GWT (GXT) for a project of mine, and this tooltip has to appear over Grid rows when they're selected. I can't use the default GXT tooltip or quicktip because I need be able to add Components (like buttons) to this tooltip. The problem is that the GXT Grid component doesn't…

  Read the article

• Combine multiple dataset columns to one dataset

  - by Matt

  I have multiple datasets that I would like to combine into one. There is a common ID field that can be associated to each row. Calling Merge on the dataset will add additional rows to the dataset, but I would like to combine the additional columns. There are too many fields to do this in one query and therefore…

  Read the article

• plsql show query

  - by CC

  Hi all, I have a small problem using oracle pl sql. I have a sql file with some cursor, etc, and the treatement fail but with no details. I have an idea about the problem (a function with parameters) but I would like to see the parameter for each call, to be able to debug, to see exactly with wich parameter fail.…

  Read the article

• T-sql Common expression query as subquery

  - by ase69s

  I have the following query: WITH Orders(Id) AS ( SELECT DISTINCT anfrageid FROM MPHotlineAnfrageAnhang ) SELECT Id, ( SELECT CONVERT(VARCHAR(255),anfragetext) + ' | ' FROM MPHotlineAnfrageAnhang WHERE anfrageid = Id ORDER BY anfrageid, erstelltam FOR XML PATH('') ) AS Descriptions FROM Orders Its…

  Read the article

• Freeze the indent of a row group in DevExpress GridControl

  - by brader

  I am required to display a DevExpress WinForms GridControl where the rows must be grouped by a date column. When horizontally scrolling the grid, I am required to keep the group row and group indents fixed to the left of the control (so they do not scroll with the columns). I have so far been unable…

  Read the article

• Oracle analytic functions for "the attribute from the row with the max date"

  - by tpdi

  I'm refactoring a colleague's code, and I have several cases where he's using a cursor to get "the latest row that matches some predicate": His technique is to write the join as a cursor, order it by the date field descending, open the cursor, get the first row, and close the cursor. This requires…

  Read the article

• Reordering matrix elements to reflect column and row clustering in naiive python

  - by bgbg

  Hello, I'm looking for a way to perform clustering separately on matrix rows and than on its columns, reorder the data in the matrix to reflect the clustering and putting it all together. The clustering problem is easily solvable, so is the dendrogram creation (for example in this blog or in…

  Read the article

• Merge\Combine two datatables

  - by madlan

  I'm trying to merge\combine two datatables. I've looked at various examples and answers but they seem to create duplicate rows or require indexes (merge on datatable etc) I can't do this via SQL as one source is from a linked Oracle server accessed via MSSQL and the other from a different…

  Read the article

• Can't get SubSonic insert to work

  - by Darkwater23

  I'm trying to insert a record into a table without using the SubSonic object in a VB.Net Windows app. (It will take too long to explain why.) Dim q As New SubSonic.Query("tablename") q.QueryType = SubSonic.QueryType.Insert q.AddUpdateSetting("Description", txtDescription.Text) q.Execute()…

  Read the article

• Start position for a reused t- sql cursor?

  - by Span

  I'm working on a stored procedure that uses a cursor on a temporary table (I have read a bit about why cursors are undesirable, but in this situation I believe I still need to use one). In my procedure I need to step through the rows of the table twice. Having declared the cursor,…

  Read the article

• Android: Filtering a SimpleCursorAdapter ListView

  - by Diego Tori

  Right now, I'm running into issues trying to implement a FilterQueryProvider in my custom SimpleCursorAdapter, since I'm unsure of what to do in the FilterQueryProvider's runQuery function. In other words, since the query that comprises my ListView basically gets the rowID, name,…

  Read the article

• How to select the top n from a union of two queries where the resulting order needs to be ranked by individual query?

  - by Jedidja

  Let's say I have a table with usernames: Id | Name ----------- 1 | Bobby 20 | Bob 90 | Bob 100 | Joe-Bob 630 | Bobberino 820 | Bob Junior I want to return a list of n matches on name for 'Bob' where the resulting set first contains exact matches followed by similar…

  Read the article

• POI dynamic templates

  - by gabriela

  Hello, Can anyone tell me where do I find some useful documentation on handling copying rows, cells, columns from one excel file to another, using POI? I need to insert in one blank excel file, 2 or more templates from other files, dynamic. I also need to keep all the styles…

  Read the article

• C# asp:ListBox hide vertical scrollbar

  - by Codeffect

  How to hide the vertical scroll bar of a Listbox that is present inside a div. <div id="lstQueriesDiv" style="overflow-y: hidden !important; overflow-x: auto !important; Width: 650px; height:167px;" > <asp:ListBox ID="lstQueries" runat="server"…

  Read the article

• One row is skipped each time the program scans a matrix from file !

  - by ZaZu

  Hello there, I had this code working yesterday, but it seems like I edited it a bit and lost the working version. I cant get this to work anymore. I basically want to scan a matrix from a .txt file. But each time it scans the first row, the second one is skipped,…

  Read the article

• Linq-to-SQL statement issue

  - by Anicho

  I am basically looking to bind a search query to a gridview which is nice, but this must be done by a users input query (sort of like a search function). I can get single values and rows returned, but how would I get it to search all columns in my database for the…

  Read the article

• Silverlight Textbox scrollviewer problem

  - by user328902

  In silverlight, I got a textbox which I want to be multiline and have mousescrolling available. If I only use textbox then I dont have mousescrolling. If I use a scrollviewer I will have mousescrolling. BUT everytime my writing exceeds the rows that are shown…

  Read the article

• SQL: Return "true" if list of records exists?

  - by User

  An alternative title might be: Check for existence of multiple rows? Using a combination of SQL and C# I want a method to return true if all products in a list exist in a table. If it can be done in all in SQL that would be preferable. I have written a method…

  Read the article

• Excel and Tab Delimited Files Question

  - by OneNerd

  I am encountering what I believe to be a strange issue with Excel (in this case, Excel 2007, but maybe also Excel 2003, but don't have access to it as I write this). I can reliably convert some server data over into a tab-delimited format (been doing this for…

  Read the article

• JPQL / SQL: How to select * from a table with group by on a single column?

  - by DavidD

  I would like to select every column of a table, but want to have distinct values on a single attribute of my rows (City in the example). I don't want extra columns like counts or anything, just a limited number of results, and it seems like it is not possible…

  Read the article

• Get Column Header in GridViewRow in asp.net

  - by Suryakavitha

  Hi, I am using a website and i have a gridview in that website.... I want to delete a row in that gridview by using that selected row column values and Column headers... i got the column values by using GridViewRow but i cant get that column value's…

  Read the article

• Using NHibernate with an EAV data model

  - by devonlazarus

  I'm trying to leverage NH to map to a data model that is a loose interpretation of the EAV/CR data model. I have most of it working but am struggling with mapping the Entity.Attributes collection. Here are the tables in question: --------------------…

  Read the article

< Previous Page | 174 175 176 177 178 179 180 181 182 183 184 185  | Next Page >