Search Results

Search found 23568 results on 943 pages for 'select'.

Page 513/943 | < Previous Page | 509 510 511 512 513 514 515 516 517 518 519 520  | Next Page >

• c#: xdocument and reading xsi:nil="true" gives "String was not recognized as a valid DateTime"

  - by DingoCC

  Happily reading xml with var q2 = from c in xmlDoc.Descendants("Ticket") select new { Responded_Date = (DateTime)c.Element("Responded_Date") } However when the tag is <Responded_Date xsi:nil="true" /> I get "String was not recognized as a valid DateTime". I don't wish to use the null coalescing operator…

  Read the article

• can this simple SQL query be optimized?

  - by ibiza

  Hi, I have the following query : SELECT COUNT(*) FROM Address adr INNER JOIN Auditable a on adr.UniqueId = a.UniqueId on a big DB (1.3M adresses, 4M+ auditables) both UniqueId columns are clustered primary keys the query is taking quite long to complete...I feel dumb, but is there any way to optimize it? I want to count all the address…

  Read the article

• We hear: Order by Rand() is bad for large tables. But how many rows is large?

  - by ggg

  I use order by rand() LIMIT 1. I have a database with 150,000 rows and I'm getting split second results after a select of three tables. If I stay under a million rows, am I going to be OK? At what point should I consider upgrading my code to something more sophisticated?

  Read the article

• Can XPath concatenate two nodeset values? (for use in XForms)

  - by iHeartGreek

  Hi! I am wanting to concatenate two nodeset values using XPath in XForms. I know that XPath has a concat(string, string) function, but how would I go about concatenating two nodeset values? BEGIN EDIT: I tried concat function.. I tried this.. and variations of it to make it work, but it doesn't <xf:value…

  Read the article

• Nokogiri find text in paragraphs

  - by astropanic

  I want to replace the inner_text in all paragraphs in my XHTML document. I know I can get all text with Nokogiri like this doc.xpath("//text()") But I want only operate on text in paragraphs, how I can select all text in paragraphs without affecting eventually existent anchor texts in links ? #For example :…

  Read the article

• JPA query many to one association

  - by Random Joe

  I want to build the following pseudo query Select a From APDU a where a.group.id= :id group is a field in APDU class of the type APDUGroup.class. I just want to get a list of APDUs based on APDUGroup's id. How do i do that using a standard JPA query?

  Read the article

• How to remove back button action while page is loading.

  - by user133611

  Hi All In my project i have a list when select on a item it will take to next controller using PushViewController. When i go there i will get data using libxml parser. But when i am clicking on the back button while loading it is showing exception. So i want to disable back button action till loading of data is…

  Read the article

• Ajax & Forms Question (Looking for Resources)

  - by Paul

  I have a select form. After a user selects option A, B, or C I need to use Ajax to load another form based on the users decision. I'm not asking for someone to program this for me. I am just wondering, does anyone know of any good resources to help me accomplish this? Thanks for your time.

  Read the article

• apply $expand to service operation

  - by Thurein

  Hi, I have a service operation in my dataservice, which returns a list of objects. Is it possible to apply $expand to the result. [WebGet] public IQueryable<contact> GetFilterByContactDetailCount(String city) { var result = from c in CurrentDataSource.Contacts join ca in…

  Read the article

• Linux: is here a read or recv from socket with timeout?

  - by osgx

  Hello How can I try to read data from socket with timeout? I know, select, pselect, poll, has a timeout field, but using of them disables "tcp fast-path" in tcp reno stack. The only idea I have is to use recv(fd, ..., MSG_DONTWAIT) in a loop

  Read the article

• VB.Net Linq Datatable Exists

  - by LarsH

  I would like to use Linq instead of below function : Friend Function IsCollectionInTable2(ByVal apps As DataTable, ByVal collectionId As String) As Boolean For Each row As DataRow In apps.Rows If row("CollectionId").ToString = collectionId Then Return True Next Return False End Function …

  Read the article

• Versant OQL Statement with an Arithmetic operator

  - by Pascal

  I'm working on a c# project that use a Versant Object Database back end and I'm trying to build a query that contains an arithmetic operator. The documentation states that it is supported but lack any example. I'm trying to build something like this: SELECT * FROM _orderItemObject WHERE _qtyOrdered -…

  Read the article

• Generate A Simple Read-Only DAL?

  - by David

  I've been looking around for a simple solution to this, trying my best to lean towards something like NHibernate, but so far everything I've found seems to be trying to solve a slightly different problem. Here's what I'm looking at in my current project: We have an IBM iSeries database as a primary…

  Read the article

• Converting SQL Query to LINQ 2 SQL expression

  - by Shyju

  How can i rewrite the below SQL query to its equivalent LINQ 2 SQL expression (both in C# and VB.NET) SELECT t1.itemnmbr, t1.locncode,t1.bin,t2.Total FROM IV00200 t1 (NOLOCK) INNER JOIN IV00112 t2 (NOLOCK) ON t1.itemnmbr = t2.itemnmbr…

  Read the article

• fetch fourth maximum record from the table field

  - by chetan

  Following is the command to fetch maximum salary form empsalary table in mysql select max(salary) from empsalary; but I want to fetch employee who got fourth highest from the list of employee. I don't want to use trigger or function because I know there is direct command to fetch.

  Read the article

• How does the where clause in MySQL work ?

  - by Eternal Learner

  I have a doubt. Assume R and S are 2 relations with attributes A and B respectively . If I have a query Select * From R, S Where R.A = S.B Does this work like a double For Loop in say c or c++ For( i=0; i<n; i++) For( j=0; j<n; j++) if (i == j) //DO some work

  Read the article

• SQL query trick

  - by wo_shi_ni_ba_ba

  I need to do select * from xxx where name in (a,b,c...); but I want the result set to be in the order of (a,b,c...) is this possible?

  Read the article

• Split string with delimiter in sql server

  - by Renju

  I'm having a coloumn name with varchar field that holds some folder path like "C:\Program Files\Internet Explorer\en-US" .I need to update the root folder name(Program files to profilesNew).Can anyone please help. I tried with a query declare @val as varchar(100) set @val='C:\Program Files\Internet…

  Read the article

• how to this query in right syntax or right way??

  - by MZT

  i write this query using t-sql and give me an error (Incorrect syntax near the keyword 'OR') How to write it in correct way ? SELECT SUM(Quantity) FROM Invoices WHERE Invoices.InvoiceDocStatusID = CASE @InventoryType WHEN 1 THEN ((2)OR(1)) ELSE 2…

  Read the article

• Which database invented the "limit" SQL query syntax?

  - by Howard

  MySQL has a nice feature (although non standard) which allow to query resultsets' limit, offset as SELECT * FROM TABLE LIMIT M, N; Is it created by MySQL? or Postgres?

  Read the article

• MySQL search a text from two columns

  - by I Like PHP

  i have a table (tbl_world) which look like this id | first_name | last_name | age | class | now i want to search the text which can be anywhere in first_name or in last_name i m using below mysql query "SELECT * FROM tbl_world WHERE REGEXP '".$word."' IN( first_name, last_name)"; where…

  Read the article

• Convert byte to boolean string in HyperLinkField.DataNavigateUrlFormatString

  - by abatishchev

  I have a asp:GridView with a HyperLinkField. It's DataNavigateUrlFormatString property is set to View.aspx?id={0}&isTechnical={1} Select command of appropriate SqlDataSource returns columns of type INT and BYTE (from SQL Server 2008). So displayed string becomes something like…

  Read the article

• A rule doesn't appear in the Style tab of Firebug

  - by user248959

  Hi, i have this page. login: maria@mail.com password: m You can see two selects in the filter for which i have this rule in gente.css: td.select label{ margin-left:12px; } The problem: the rule is applied but doesn't appear in the Style tab of Firebug. Any idea? …

  Read the article

• Java: Making concurrent MySQL queries from multiple clients synchronised

  - by Misha Gale

  I work at a gaming cybercafe, and we've got a system here (smartlaunch) which keeps track of game licenses. I've written a program which interfaces with this system (actually, with it's backend MySQL database). The program is meant to be run on a client PC and (1) query the…

  Read the article

• Resort (reorder) table data

  - by Dave Jarvis

  What is the fastest way to reorder (resort) a table? In MySQL, you can do: CREATE TABLE table2 LIKE table1; INSERT INTO table2 SELECT * FROM table1 ORDER BY by name; DROP TABLE table1; RENAME TABLE table2 TO table1; What about PostgreSQL? Is there a faster way?

  Read the article

< Previous Page | 509 510 511 512 513 514 515 516 517 518 519 520  | Next Page >