Search Results

Search found 17593 results on 704 pages for 'wmi query'.

Page 228/704 | < Previous Page | 224 225 226 227 228 229 230 231 232 233 234 235  | Next Page >

• 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

• What the linq query for SQL like and Soudex for sql server 2008?

  - by KentZhou

  In sql server, we can issue sql to get data like select * from table where column like '%myword%' select * from person where Soundex(LastName) = Soundex('Ann') what's the linq query to match above sql?

  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

• 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

• 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

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

• 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

• 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

• 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

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

• 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

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

• 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

• 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

• How do you query posts from more than one author in Wordpress?

  - by Thinkbetter

  How do you query posts from more than one author in Wordpress? something like: query_posts('author=9,10&post_status=publish&orderby=date') This is not working though.

  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

• 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 | 224 225 226 227 228 229 230 231 232 233 234 235  | Next Page >