Search Results

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

Page 152/293 | < Previous Page | 148 149 150 151 152 153 154 155 156 157 158 159  | Next Page >

• Linq to SQL - Returning two values with one query

  - by Sir Psycho

  Hi, Is it possible to return a single value and an enumerable collection using LINQ to SQL? The problem is, I'm trying to do paging across a large recordset. I only want to return 10 rows at a time so I'm using .Skip(20).Take(10) approach. However I need to know the total number of records so I can show an appropriate page x of y. Trying to…

  Read the article

• SQL Server - Test the result of a stored procedure

  - by Melursus

  In SQL Server, it is possible to test the result of a stored procedure to know if the result return rows or nothing ? Example : EXEC _sp_MySp 1, 2, 3 IF @@ROWCOUNT = 0 BEGIN PRINT('Empty') END ELSE BEGIN PRINT(@@ROWCOUNT) END But @@ROWCOUNT always return 0 so maybe is there another way of doing this ?

  Read the article

• JPA: what is the proper pattern for iterating over large result sets?

  - by Caffeine Coma

  Let's say I have a table with millions of rows. Using JPA, what's the proper way to iterate over a query against that table, such that I don't have all an in-memory List with millions of objects? I suspect that the following will blow up if the table is large: List<Model> models = entityManager().createQuery("from Model m",…

  Read the article

• Why do websites generate random alphanumeric strings for urls instead of using row ids?

  - by jorm

  Why does many sites (youtube is good example) generate string of random number and letter instead of using for example the row id? usually its something likes this bla?v=wli4l73Chc0 instead of like bla?id=83934 Is it just to keep it short if you have many rows? Or is there other good things about this? Because i can…

  Read the article

• Sum values in a DataTable by a given criteria

  - by šljaker

  Which is the most effective way to sum data in the DataTable by a given criteria? I have the following table: KEY_1 KEY_2, VALUE_1, VALUE_2 Input: 01101, P, 2, 3 01101, F, 1, 1 01101, P, 4, 4 10102, F, 5, 7 Desired output (new DataTable): 01101, P, 6, 7 01101, F, 1, 1 01101, SUM, 7, 8 10102, F, 5, 7 10102, SUM, 5, 7…

  Read the article

• Datable.Select sort expression

  - by xyz

  Hi, I have datatable with column name tag and 100 rows of data.I need to filter this table with tag starting with "UNKNOWN". What should my sortexpression for datatable.select be ? I'm trying the following. Datarow[] abc = null; abc = dtTagList.Select(string.format("tag='{0}'","UNKNOWN")) How can I achieve tag…

  Read the article

• mysql query help please

  - by moustafa

  i have forum_topics table and have topics_posts table now i want to select from forum_topics where have no posts from topics_posts can any one give me the one syntax like this selct from * forum_topics where have no rows in topics_posts table

  Read the article

• T-SQL generated from LINQ to SQL is missing a where clause

  - by Jimmy W

  I have extended some functionality to a DataContext object (called "CodeLookupAccessDataContext") such that the object exposes some methods to return results of LINQ to SQL queries. Here are the methods I have defined: public List<CompositeSIDMap> lookupCompositeSIDMap(int regionId, int marketId) { var…

  Read the article

• Validation of textarea

  - by Hulk

  How to validate a textarea in a form.i.e, it should not be empty or have any new lines and if so raise an alert <script> function val() { //ifnewline found or blank raise an alert } </script> <form> <textarea name = "pt_text" rows = "8" cols = "8" class =…

  Read the article

• What are the differences between these?

  - by Amit Ranjan

  What are the differences between the two queries? SELECT CountryMaster.Id FROM Districts INNER JOIN CountryMaster ON Districts.CountryId = CountryMaster.Id SELECT CountryMaster.Id FROM CountryMaster INNER JOIN Districts ON Districts.CountryId = CountryMaster.Id …

  Read the article

• How to get datarow array refering to datatable 's field value with linq

  - by Michael

  I want to use linq to get datarow array from a datatable which its string type ColumnA is not null or depending on its length 0 , so I can get the row index with Indexof() method to deal with something else. ColumnA ColumnB ColumnC A0 B0 C0 Null B1 C1 A2 B2 C2 Null …

  Read the article

• Python: inserting double or single quotes around a string

  - by Jessy

  Im using python to access a MySQL database and im getting a unknown column in field due to quotes not being around the variable. code below: cur = x.cnx.cursor() cur.execute('insert into tempPDBcode (PDBcode) values (%s);' % (s)) rows = cur.fetchall() How do i manually insert double or single quotes…

  Read the article

• User has many computers, computers have many attributes in different tables, best way to JOIN?

  - by krismeld

  I have a table for users: USERS: ID | NAME | ---------------- 1 | JOHN | 2 | STEVE | a table for computers: COMPUTERS: ID | USER_ID | ------------------ 13 | 1 | 14 | 1 | a table for processors: PROCESSORS: ID | NAME |…

  Read the article

• xpath - limit search to node not working?

  - by Mr W

  What am I doing wrong here? I am trying to limit my xpath search to a specific row in my table but my query always returns the content of the span in the first row: var query = "//span[contains(@id, 'timer')]"; var root = document.getElementById('movements').rows[1];…

  Read the article

• Parsing a file with column data in Python

  - by rejinacm

  I have a file that contains the symbol table details.Its in the form of rows and columns. I need to extract first and last column. How can I do that?

  Read the article

• Ensure Oracle row represents a unique timespan

  - by Dan F.

  I have to make a process in Oracle/PLSQL. I have to verify that the interval of time between start_date and end_date from a new row that I create must not intersect other start_dates and end_dates from other rows. Now I need to check each row for that condition and…

  Read the article

• When a asp.net button is clicked, add #button to the url

  - by Blankman

  Using jquery, when a button is clicked (server side), I want to append #button to the url. This will only be used when there is validation errors, I want the browser to scroll to the bottom where the button is. I already tried MaintainScrollPositionOnPostback but…

  Read the article

• aggregate over several variables in r

  - by Misha

  Dear overflowers, I have a rather large dataset in a long format where I need to count the number of instances of the ID due to two different variables, A & B. E.g. The same person can be represented in multiple rows due to either A or B. What I need to do is…

  Read the article

• ASP.NET How to call my function when the selected index changes in radio button list without updatin

  - by DedovecES

  I have a table in my form, where I put n-rows, every row contains 1 RadioButtonList, when user select the item in RadioButtonList, I need to get number of selected Item, without updating the page.

  Read the article

• GROUP BY a date, with ordering by date.

  - by standard

  Take this simple query: SELECT DATE_FORMAT(someDate, '%y-%m-%d') as formattedDay FROM someTable GROUP BY formatterDay This will select rows from a table with only 1 row per date. How do I ensure that the row selected per date is the earliest for that date,…

  Read the article

• How to delete from table if count is greater than 20

  - by joseph

  Hi, I have a mysql table that I need to only contain 20 newest records before adding additional records. New rows are added daily so I would like it first delete any records that are greater than the 20 allowed starting with the earliest. The table contains an…

  Read the article

• How to select the last 2-element group by a topic_id in MySQL

  - by Luca Romagnoli

  Hi i have to select the 2 lastest element for every topic ex: table: msg id | topic_id ----------- 1 | 1 2 | 1 3 | 1 4 | 1 5 | 2 6 | 2 7 | 2 8 | 3 9 | 3 10 | 3 i want obtain these rows: 3 1 4 1 6 2 7 2 9 3 10 3 How can i do? …

  Read the article

• questions regarding the use of A* with the 15-square puzzle

  - by Cheeso

  I'm trying to build an A* solver for a 15-square puzzle. The goal is to re-arrange the tiles so that they appear in their natural positions. You can only slide one tile at a time. Each possible state of the puzzle is a node in the search graph. For the…

  Read the article

• Insert Image on Excel using Open XML

  - by Pankaj

  Hello All I am using this toolkit to write Excel.Every thing is fine with this, but i am not getting how can i inset image and also put style on some rows on my excel …

  Read the article

• Linq2Sql How to write outer join query?

  - by Malcolm

  Hi, I have following SQL tables. ImportantMessages impID Message ImportantMessageUsers imuID imuUserID imuImpID I want to write a Linq2Sql query so that it…

  Read the article

< Previous Page | 148 149 150 151 152 153 154 155 156 157 158 159  | Next Page >