Search Results

Search found 5233 results on 210 pages for 'records'.

Page 108/210 | < Previous Page | 104 105 106 107 108 109 110 111 112 113 114 115  | Next Page >

• Updating gridview using ado.net entity framework

  - by Ravi

  Hello everyone, I am trying to figure out the best way of getting the record and update in to gridview using ado.net entity framework in C#. I need implement Next & Previous button in gridview and based on pagesize i want to navigate records using Next&Back button. Any one give simple example for this context.

  Read the article

• Why this search can not generate correct result?

  - by user482742

  Hi, All: Below is to find same customer and if he is in list, the number add one. If he is not in the list, just add him in the list. I use Search function to do this, but failed and generated incorrect records. It can not find the customer or the right number of customers. But if I use For..loop to iterate the list, it does well and can find the customer and add new customer in that for..loop search procedure. (I did not paste for ..loop search procedrue here). Another problem is that there is no difference between setting list.sorted true and false. It seems Search function is not correct. This search function is from an example of delphi textbook. The below is with Delphi 7. Thank you. Procedure Form1.create; begin list:=Tstringlist.create; list.sorted:=true; // Search function will generate exactly Same and Incorrect //records no matter list.sorted is set true or false. list.duplicates:=dupignore; .. end; Procedure addcustomer; var .. begin while p1.MatchAgain do begin //p1 is regular expression customer:=p1.MatchedExpression; if (search(customer)=false) then begin list.Add(customer+'=1'); end; allcustomer:=allcustomer+1; .. end; Function Tform1.search(customer: string): boolean; var fre:string; num:integer; L:integer; R:integer; M: Integer; CompareResult: Integer; found: boolean; begin result:=false; found:=false; L := 0; R := List.Count - 1; while (L <= R) and ( not found ) do begin M := (L + R) div 2; CompareResult := Comparetext(list.Names[m]), customer); if (compareresult=0) then begin fre:=list.ValueFromIndex [m]; num:=strtoint(fre); num:=num+1; list.ValueFromIndex[m]:=inttostr(num); Found := True; Result := true; exit; end else if compareresult > 0 then r := m - 1 else l := m + 1; end; end;

  Read the article

• Handling a button click in MVC, why is there a string parameter?

  - by SLC

  I'm following this awful textbook, going through the basics of create/edit/delete records. The delete bit has a confirm button, and it is handled like so: [AcceptVerbs(HttpVerbs.Post)] public ActionResult Delete(int id, string confirmButton) { It offers no explanation of why the button is passed as a string or how MVC interprets it. Can anyone help clarify what's going on here? The Create code has no such string being passed.

  Read the article

• MySQL DATE_FORMAT comparison to CURDATE() query...

  - by Crazy Serb

  Hey guys, I am just trying to pull all the records from my database who have a rec_date (varchar) stored as m/d/Y and are expired (as in, less than curdate()), and this call isn't giving me what I want: SELECT member_id, status, DATE_FORMAT(STR_TO_DATE(rec_date, '%m/%d/%Y'), '%Y-%m-%d') AS rec FROM members WHERE rec_date CURDATE() AND status = '1' I'm obviously doing something wrong, so can you help? Thanks.

  Read the article

• Does SQL Server guarantee sequential inserting of an identity column?

  - by balpha

  In other words, is the following "cursoring" approach guaranteed to work: retrieve rows from DB save the largest ID from the returned records for later, e.g. in LastMax later, "SELECT * FROM MyTable WHERE Id > {0}", LastMax In order for that to work, I have to be sure that every row I didn't get in step 1 has an Id greater than LastMax. Is this guaranteed, or can I run into weird race conditions?

  Read the article

• Doctrine: Keep 'Timestampable' behavior when using stored procedures?

  - by ropstah

  I have complex logic which is not possible (too slow) to run through PHP with Doctrine, so I need to create a stored procedure for this. The logic also includes inserting/updating records in a table using the Timestampable behavior. How do I preserve this behavior in the stored procedure?

  Read the article

• Query having 2 Where Clause

  - by Harsha M V

  i am trying to login and want to validate username and password against the records in the database. I am not sure how to pass two Where clause public Boolean login(String username, String password) throws SQLException { Cursor mCursor = db.query(TABLE_USERS, new String[] { ID, KEY_NAME, KEY_USERNAME}, KEY_USERNAME + "=" + "'"+username+"'", KEY_PASSWORD + "=" + "'"+password+"'", null, null, null, null, null); if (mCursor.moveToFirst()) { return true; } return false; } Am getting a Syntax Error.

  Read the article

• attempt to write a readonly database in Android2.1

  - by JoJo

  This is the error: android.database.sqlite.SQLiteException: attempt to write a readonly database This is my code: SQLiteDatabase db = mDatabase.getWritableDatabase(); db.beginTransaction(); try { // add new records ContentValues newRecord = new ContentValues(); newRecord.put(Emergencydetails.EMERGENCYNUMBER, emergencyNumber.getText().toString()); db.insert(Emergencydetails.EMERGENCY_TABLE_NAME, null, newRecord); db.setTransactionSuccessful(); } finally { db.endTransaction(); }

  Read the article

• SQL Complex Select - Trouble forming query

  - by JoshSpacher

  I have three tables, Customers, Sales and Products. Sales links a CustomerID with a ProductID and has a SalesPrice. select Products.Category, AVG(SalePrice) from Sales inner join Products on Products.ProductID = Sales.ProductID group by Products.Category This lets me see the average price for all sales by category. However, I only want to include customers that have more than 3 sales records or more in the DB. I am not sure the best way, or any way, to go about this. Ideas?

  Read the article

• Oracle join issue

  - by acadia

  Hello, I have 3 tables and I am joining these 2 tables as follows: SELECT EMP.FNAME,EMP.LNAME,EMP.AGE,EMPD.TQ,EMPD.TA,CTY.CITY_NAME FROM EMPLOYEE EMP,EMPLOYEE_DETAIL EMPD, CITY CTY WHERE EMP.EMP_ID=EMPD.EMP_ID AND EMPD_CITY_ID=CTY.CITY_ID I want to display records even if City record is not in CITY table. For eg. if City_ID record for say 10 is not in City table but there is an employee detail record with City_id 10 it should display City_name as null instead of not displaying the record at all. Appreciate your help

  Read the article

• replace function in dml statements in oracle 8i

  - by maheshasoni

  Can we use Replace function in a update statement ? If yes then How? I have a column 'enrollno' having values like '800-00001' to '800-01800'. I want to replace inital '800-' to '800' in all 1800 records. (Output should be '8000001' to '80001800') Is it possible through replace function or any other option is there in ORACLE8i ? MaheshA...

  Read the article

• How to read CSV files line by line in VBScript

  - by Shyju

  I am using an ASP page where I have to read a CSV file and insert it into DB table "Employee". I am creating an object of TestReader. How can I write a loop to execute up to the number of rows/records of the CSV file which is being read?

  Read the article

• LINQ to SQL .Count takes way to much process time and decreases performances.

  - by soldieraman

  LINQ to SQL .Count takes way to much process time and decreases performances. I am doing a recursive loop and for one child (lets call it parent) I have to check the number of children under it to make a decision if it should be included or not. The Count is too slow 8 ms :( for 120 parent records. Any ideas to make it quicker.

  Read the article

• find all text before using regex

  - by jeff

  How can I use regex to find all text before the text "All text before this line will be included"? I have includes some sample text below for example This can include deleting, updating, or adding records to your database, which would then be reflex. All text before this line will be included You can make this a bit more sophisticated by encrypting the random number and then verifying that it is still a number when it is decrypted. Alternatively, you can pass a value and a key instead.

  Read the article

• Mysql - GROUP BY Avoid using tempoary

  - by jwzk

  The goal of this query is to get a total of unique records (by IP) per ref ID. SELECT COUNT(DISTINCT ip), GROUP_CONCAT(ref.id) FROM `sess` sess JOIN `ref` USING(row_id) WHERE sess.time BETWEEN '2010-04-21 00:00:00' AND '2010-04-21 23:59:59' GROUP BY ref.id ORDER BY sess.time DESC The query works fine, but its using a temporary table. Any ideas?

  Read the article

• Hiernate's version values in Grails app

  - by xain

  Hi, looking at a database dump file, and I see many records in various tables with their version number set in values other than 0 (even 94 in one case). I understand it has to do with hibernate locking strategy, but my concern is that today is Sunday, and the site has almost no visitors so is: is this normal ? Or is there a known hibernate bug or even some programming malpractice producing this ? Thanks in advance.

  Read the article

• Date comparison in Oracle database

  - by Jasim

  I have two variable TO_DATE and FROM_DATE. My table has two fields DOJ and DOL. I want to select all the records whose DOJ < TO_DATE and DOL FROM_DATE. How can i write an SQL query in for this??

  Read the article

• Is it okay to store user data in XML files?

  - by rity

  I have an app that is being used by a few users (< 12 users). There are less than 2000 records so I decided to use an XML file and store the file under \company\product\p.xml. Is this okay or am I breaking some design guidelines without realizing it? EnvironmentL .net/c#/winforms

  Read the article

• How to parse a "Mysql result JSON String" in Javascript?

  - by user330429

  Is there a way to convert it into object form? So that each field of the result can be accessed results[i].field where i is the number of records in the mysql result.. This is my JSON String http://pastebin.com/Cky1va3K

  Read the article

• displaying multiple values with .FIELDS adodb

  - by every_answer_gets_a_point

  i am getting some data: rs.Filter = "datapath='" + dpath + "' and analystname='" + aname + "' and reportname='" + rname + "' and batchstate='" + bstate + "'" If Not rs.EOF Then MsgBox rs.Fields("rowid") End If if the rs.filter returns multiple records, how do i get rs.fields("rowid") to give me multiple rowid values?

  Read the article

• Codeigniter: Get affected fields in update

  - by Roberto

  There's a way to get which fields were modified after a update query? I want to keep track what field XXX user modified... any ways using active records?

  Read the article

• how to do reverse fulltext search in MySQL?

  - by Shore

  By default it's like this: select * from main_table where match(col1,col2) against('search_item'); but what I want to fetch is the reverse, say,I've restored all the search_item(1000 records,for example), and I want to see which of them matches a specified row in main_table. Is that doable?

  Read the article

• Insert ADO.Net DataTable into an SQL table

  - by strakastroukas

  The current solution i implemented is awful! I use a for... loop for inserting records from an ADO.NET data-table into an SQL table. I would like to insert at once the data-table into the SQL table, without iterating... Is that possible, or am i asking too much?

  Read the article

• MySQL: LOAD DATA reclaim disk space after delete

  - by Michael

  I have a DB schema composed of MYISAM tables, i am interested to delete old records from time to time from some of the tables. I know that delete does not reclaim the memory space, but as i found in a description of DELETE command, inserts may reuse the space deleted In MyISAM tables, deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. I am interested if LOAD DATA command also reuses the deleted space? UPDATE I am also interested how the index space reclaimed?

  Read the article

• How to count two fields by using Select statement in SQL Server 2005?

  - by user144842

  Total records in table are 10. Select count(ID) from table1 where col1 = 1 (Result is 8) Select count(ID) from table1 where col2 = 1 (Result is 2) So its a same table but count is based on different condition. How am i gonna get two results (counts) using one select statement? Also Performance is a big concern here. PS: I am using Stored procedure...

  Read the article

< Previous Page | 104 105 106 107 108 109 110 111 112 113 114 115  | Next Page >