Search Results

Search found 25852 results on 1035 pages for 'linq query syntax'.

Page 383/1035 | < Previous Page | 379 380 381 382 383 384 385 386 387 388 389 390  | Next Page >

• limiting consecutive values of one column in a sql query.

  - by Brad Smith

  I have a table with the following structure: id -int(11) event_id -int(11) photo_id -int(11) created_at -datetime How do I write a query that will return the 100 most recent rows, but insuring that there are no more than 4 consecutive rows with the same value in photo_id

  Read the article

• How do i append query string from managed bean to url? JSF

  - by Nitesh Panchal

  Hello, Can this method work? public String sayHello(){ return "Hello.jsp?name=" + "laala"; } I am unable to access, query string using the above method. I tried ${param.name} as well as request.getParameter("name"). They both return null. Please help!

  Read the article

• How may I store geographical data in an android database and query for it?

  - by Eduardo

  I want to store locations in my Android phone and be able for the application to tell me if I am inside these points&radius. What is the best way to store many point&radius locations and efficiently query for them?

  Read the article

• How to concatenate all the records in a column returned by a query into one varchar string in T-SQL?

  - by Ivan

  A query (SELECT/FUNCTION/VIEW/PROCEDURE) returns a column of varchar records. I need to concatenate them all into one single varchar line. How do I best do it in T-SQL?

  Read the article

• SQL query that returns columns form table A plus a bit column that specifies with the PK of table A

  - by dannie.f

  How can I write an efficient SQL query that returns columns form table A plus a bit column that specifies whether the PK of table A exists in table B? I am using MS SQLServer 2005. Thanks.

  Read the article

• How to find out whether SqlCe query Has rows?

  - by Tomas

  Hi, In my simple db I use SqlCe and I cannot figure out how to correctly find out whether the query has rows or not. HasRows does not work. So far I have this: _DbCommand.CommandText="SELECT * FROM X" SqlCeDataReader reader=_DbCommand.ExecuteQuery(); if (reader.FieldCount!=0) //I thought it could work (O rows - 0 fields?), but its true even with 0 rows { while (reader.Read()) { // } } Thanks

  Read the article

• How do I select the first row per group in an SQL Query?

  - by mafutrct

  I've got this SQL query: SELECT Foo, Bar, SUM(Values) AS Sum FROM SomeTable GROUP BY Foo, Bar ORDER BY Foo DESC, Sum DESC This results in an output similar to this: 47 1 100 47 0 10 47 2 10 46 0 100 46 1 10 46 2 10 44 0 2 I'd like to have only the first row per Foo and ignore the rest. 47 1 100 46 0 100 44 0 2 How do I do that?

  Read the article

• SQL Server 2000: Why is this query w/ variables so slow vs w/o variables?

  - by William DiStefano

  I can't figure out why this query would be so slow with variables versus without them. I read some where that I need to enable "Dynamic Parameters" but I cannot find where to do this. DECLARE @BeginDate AS DATETIME ,@EndDate AS DATETIME SELECT @BeginDate = '2010-05-20' ,@EndDate = '2010-05-25' -- Fix date range to include time values SET @BeginDate = CONVERT(VARCHAR(10), ISNULL(@BeginDate, '01/01/1990'), 101) + ' 00:00' SET @EndDate = CONVERT(VARCHAR(10), ISNULL(@EndDate, '12/31/2099'), 101) + ' 23:59' SELECT * FROM claim c WHERE (c.Received_Date BETWEEN @BeginDate AND @EndDate) --this is much slower --(c.Received_Date BETWEEN '2010-05-20' AND '2010-05-25') --this is much faster

  Read the article

• MDX: How to exclude ancestors from being returned in this query?

  - by wgpubs

  I have this MDX query: Exists([Group].[Group Hierarchy].allmembers, {[Group].[Group Full Name].&[121 - Group A], [Group].[Group Full Name].&[700000 - Group C]}) ... which works fine EXCEPT that it returns all of the ancestors of the specified groups as well. What I want is to return JUST the groups from the hierarchy with the specified Group Names (this is a type 2 dimension so there may be many at different levels). Any ideas?

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery if we only want to

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery or vice versa if we only want to find the intersection? For example, select * from gifts g where g.giftID in (select giftID from sentGifts); can do a join and show the gifts sent in the sentGifts table, but it won't be able to show the sentTime because that is inside the subquery. But if all we care is to find the intersection, without caring what is being displayed, then we can always convert one to the other?

  Read the article

• Turning On General Query Logging FOR WINDOWS in MySQL.

  - by Joshua

  I want to view the actual SQL resulting from a php call to mysqli-prepare, and apparently the only way to do that is by logging all queries. However, I can't seem to manage to turn on query logging in mysql for windows. Help?

  Read the article

• MySQL Sub-query.. Doesn't provide proper information after 3 entries into table.

  - by Chris Keefer

  After I get 3 rows in my forum_threads table this no longer does it's job; to organize a list of active forum threads and put the most recently responded-to thread at the top of the list, followed by second most recent posted-to thread, followed by third, fourth, etc. Like I said, the query works wonders up until there is a fourth row added to forum_threads. SELECT forum_threads.*, forum_posts.thread_id FROM forum_threads INNER JOIN (SELECT MAX(id) AS id, thread_id as thread_id FROM forum_posts group by thread_id order by id DESC) forum_posts ON forum_threads.id = forum_posts.thread_id

  Read the article

• How to tell if a query will scale well?

  - by Randy Minder

  What are some of the methods/techniques experienced SQL developers use to determine if a particular SQL query will scale well as load increases, rows in associated tables increase etc.

  Read the article

• Mysql question: is there something like IN ALL query?

  - by jaycode

  For example this query: SELECT `variants`.* FROM `variants` INNER JOIN `variant_attributes` ON variant_attributes.variant_id = variants.id WHERE (variant_attributes.id IN ('2','5')) And variant has_many variant_attributes What I actually want to do is to find which variant has BOTH variant attributes with ID = 2 and 5. Is this possible with MySQL? Bonus Question, is there a quick way to do this with Ruby on Rails, perhaps with SearchLogic?

  Read the article

• How can I query the database culture (SQL Server 2005) ?

  - by Quandary

  How can I query the database culture (SQL Server 2005) ? I have problems inserting and getting dates, because the client's servers don't run on the same culture as my developer server. I can adjust the date, but I need to know the server's culture...

  Read the article

• Xpath Query to match immediate sibling nodes in a sequence.

  - by Pritam Damania

  Hi, I'm new to XPATH and I'd like to know if there is a nice way to do this using XPATH queries. I want to match consecutive sibling nodes in a XML tree to certain predefined rules for example if there are three sibling nodes occurring immediately one after the other and they have the attributes value="A", value="B" and value="C", I want the XPATH query to match the first node/last node in such a sequence and I want to extract all such consecutive sequence of nodes from the XML tree so that I can process them later on. Thanks!

  Read the article

• PostgreSQL: Why does this simple query not use the index?

  - by David

  I have a table t with a column c, which is an int and has a btree index on it. Why does the following query not utilize this index? explain select c from t group by c; The result I get is: HashAggregate (cost=1005817.55..1005817.71 rows=16 width=4) -> Seq Scan on t (cost=0.00..946059.84 rows=23903084 width=4) My understanding of indexes is limited, but I thought such queries were the purpose of indexes.

  Read the article

• How can I select records from two different tables in one MySQL query?

  - by Fernando

  I have first names stored in one table and last names stored in another. I know this is silly but I am trying out different things as I'm just starting with MySQL. Anyway is it possible to select the first name from one table and the last name from another in one query? And put the result inside a PHP variable?

  Read the article

• is it possible to change the query parameters in REST API from script editor in SOAPUI?

  - by user1518659

  i am doing load test on this REST API using SOAPUI. http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=false i ve successfully setup the testsuite and all. my doubt is is it possible to change the query parameters in the REST API url by passing values from the script editor(either javascript or groovy) for the test suite when i perform test? if so, how should i write the script? Hope I am clear with my ques.

  Read the article

• Design ideas in constructing (from the UI) and parsing (at the server) a query.

  - by Vishal

  The UI looks like: I am looking for an elegant logic or any library to parse the query for all possible combinations of the above. PS: May be the UI can be designed better. Posts appreciated. Thanks

  Read the article

• Simple 301 redirect; how do I get it to drop the query string?

  - by Throlkim

  Hopefully there's a simple solution to this. I'm setting up a redirect for old search listings, but I don't want any of the query string to carry over. The current rule is: redirect 301 /blog http://newdomain.com But this would redirect the following: http://www.olddomain.com/blog/2009/11/article-name-etc To this: http://newdomain.com/2009/11/article-name-etc When I just want: http://newdomain.com Can this be done in the simple 301 redirect, or will I have to write a mod_rewrite rule?

  Read the article

• Whats better query with long where in condition or many small queries?

  - by DCrystal

  Maybe it's a little dumb, but i'm just not sure what is better. If i have to check about 30k rows in db for existanse, what i'd do? #1 - one query select id from table1 where name in (smth1,smth2...{till 30k}) #2 - many queries select id from table1 where name=smth1 Though, perfomance is not the goal, i don't want to go down with mysql either ;) Maybe, any other solutions will be more suitable... Thanks.

  Read the article

• How to use Rx to asynchronously query Twitter search ?

  - by Jalfp

  Hi, I'm thinking about using Rx (Reactive Framework) in order to asynchronously query Twitter search API on a given keyword. The sample app I'd like to build should be able to display new tweets in the console. Do you think it is possible to do that ? Would it be simpler than using standard programming techniques ? How would you do that ? Thank ! Jeremy

  Read the article

• How do I return count and not count in a SQL query?

  - by Gribbler

  Hi, If I have a table AgentID | IsNew | TeamID 1 N 1 2 Y 2 3 Y 2 4 N 2 5 Y 1 I want to return the following from a query: Team | CountIsNew = N | CountIsNew = Y 1 1 1 2 1 2 Is there a way I can do this? Using Oracle 10

  Read the article

• Is it safe to use connection.createStatement().executeQuery(String query);?

  - by javanix

  Is it safe to do connection.createStatement().executeQuery(String query);, or should each java.sql.Statement object be created and closed by "hand" on every use, even if the connection is closed in a finally block? If multiple queries are executed in one method by one connection it would use much less code if instantiating and closing each statement wasn't strictly necessary.

  Read the article

< Previous Page | 379 380 381 382 383 384 385 386 387 388 389 390  | Next Page >