Search Results

Search found 33538 results on 1342 pages for 'select query'.

Page 318/1342 | < Previous Page | 314 315 316 317 318 319 320 321 322 323 324 325  | Next Page >

• 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

• When using skip and take to page data, how can I get the total record count without a separate query

  - by Keith Myers

  I don't see how this is possible, but I really, really hate to run my query an extra time just to get the record count so I can build a pager. When I say a "pager" I simply mean the common gizmo with a link for each 10 records for example.

  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

• Get the count of items in a GroupBy Linq-to-sql Query?

  - by Curtis White

  I have a groupby that I groups all elements. I can see the items are there in LinqPad but can't find a way to get the count. Here is what I have so far: SurveyResponses.Where( q = q.QuestionId == 4).GroupBy(q = q.AnswerNumeric).Where( g = g.Key == 1) In Linq Pad I can see there are 4 items in this query. If I do Count it returns 1. I've tried, ToList().Count, Select(x = x).Count, etc.

  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

• 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

• 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

• 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

• 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

• 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

• 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

• Best way to format a query string in an asp.net mvc url?

  - by Stuart

  I've noticed that if you sent a query string routevalue through asp.net mvc you end up with all whitespaces urlencoded into "%20". What is the best way of overriding this formatting as I would like whitespace to be converted into the "+" sign? I was thinking of perhaps using a custom Route object or a class that derives from IRouteHandler but would appreciate any advice you might have.

  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

• How can I split mySQL query logs by database?

  - by barnaby

  I've been trying to implement a mySQL Proxy solution that can separate out the queries into per-database logs. Everything I've Googled has pointed to mySQL Proxy but I can only seem to capture the database a connection was opened to, not which the current query is being issued against. Is it even possible? Is there a different tool to use? Thanks for any suggestions.

  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

• 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 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

• 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

• Excel macro to change external data query connections - e.g. point from one database to another

  - by Rory

  I'm looking for a macro/vbs to update all the external data query connections to point at a different server or database. This is a pain to do manually and in versions of Excel before 2007 it sometimes seems impossible to do manually. Anyone have a sample? I see there are different types of connections 'OLEDB' and 'ODBC', so I guess I need to deal with different formats of connection strings?

  Read the article

• How can I "merge", "flatten" or "pivot" results from a query which returns multiple rows into a sing

  - by dsm

  I have a simple query over a table, which returns results like the following: id id_type id_ref 2702 5 31 2702 16 14 2702 17 3 2702 40 1 2702 26 4 And I would like to merge the results into a single row, for instance: id concatenation 2702 5,16,17,40,26:31,14,3,1,4 Is there any way to do this within a trigger? NB: I know I can use a cursor, but I would really prefer not to unless there is no better way.

  Read the article

• How to get and disect the query string appended into a url? PHP

  - by Stanley Ngumo

  Hi, I am trying to develop a PHP class which would enable me to get the query string appended into a url and process it according to the variables passed. How can this be done? Eg www.example.com?var1=a&var2=b&var3=c now I want to get '?var1=a&var2=b&var3=c' section and process it based on the variables. Thanks

  Read the article

• Why is recordset result being returned in this way for Python database query?

  - by Scott

  I have searched high and low for an answer to why query results returned in this format and how to convert to a list. data = cursor.fetchall() When I print data, it results in: (('car',), ('boat',), ('plane',), ('truck',)) I want to have the results in a list as ["car", "boat", "plane", "truck"]

  Read the article

• How to query database where date and time field are separate?

  - by learner

  In Table, Time and date fields are two separate fields. I need to make a query something like this give all records where date and time <= givenDateTime. How do i do that please?

  Read the article

• Is there any query in sqlite to choose a substring ?

  - by john terry

  Hey, Lets say I have a table Y with column X. There is one row of "X" with the string "abcdefg", and another row with "qwerty". Can I make a SELECT query in sqlite to choose the row which contains the substring "abcd" ? Thanks in advance.

  Read the article

< Previous Page | 314 315 316 317 318 319 320 321 322 323 324 325  | Next Page >