Search Results

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

Page 468/704 | < Previous Page | 464 465 466 467 468 469 470 471 472 473 474 475  | Next Page >

• inserting large number of dates

  - by Radhe

  How can I insert all dates in an year(or more) in a table using sql My dates table has following structure dates(date1 date); Suppose I want to insert dates between "2009-01-01" to "2010-12-31" inclusive. Is there any sql query for the above?

  Read the article

• Where should rookie go for best SQL tutorial resources?

  - by Jack Johnstone

  I´m interested in both web resources and books. It´s a jungle out there, please give me a hand. My goal is to learn the SQL language so I can query Sql Server databases within a couple of weeks. I´ve got a programming background, and I know some basic stuff about relational databases, but almost nothing on how to use the SQL language.

  Read the article

• Is it possible to simulate TMenuBreak functionality with Dev Express TdxBarSubItems?

  - by mcmar

  In my application I'm dynamically adding new TdxBarSubItems based off of a SQL query. In some cases the result set is rather large so the menu fills the entire screen and sometimes has a down arrow to scroll the list. In a previous version of the code before switching to Dev Express, I was able to add TMenuBreak objects to make the list divide into columns. Is there a way to do this with Dev Express components?

  Read the article

• How to find if lat/long falls in an area using Django and geopy

  - by Duane Hilton

  I'm trying to create a Django app that would take an inputted address and return a list of political races that person would vote in. I have maps of all the districts (PDFs). And I know that I can use geopy to convert an inputted address into coordinates. How do I define the voter districts in Django so that I can run a query to see what districts those coordinates fall in?

  Read the article

• Does UrlDecode handle plus (+) correctly?

  - by harpo

  According to RFC 2396, The plus "+", dollar "$", and comma "," characters have been added to those in the "reserved" set, since they are treated as reserved within the query component. Indeed, search this site for "plus + comma , dollar $", and you get http://stackoverflow.com/search?q=plus+%2B+comma+,+dollar+$ Plus is only encoded (by the application) when it's not being used as a delimiter. But as others have observed, .NET's UrlDecode function converts plus to space. Where is this behavior specified?

  Read the article

• users in a domain with NO login scripts.

  - by robd

  I'm trying to write an LDAP query for find all users in a domain with NO login scripts. The following works for users with a login script = db.bat: (&(objectCategory=user)(ScriptPath=DA.BAT)) However, what i thought will be the obvious logic for a Null ScriptPath field returns no values: (&(objectCategory=user)(ScriptPath="")) I'll appreciate any assistance. Robd

  Read the article

• Replace CHAR with VARCHAR2

  - by Aaron Digulla

  How can I replace CHAR with VARCHAR2 in all tables in a schema? Note: I'm content with a query that returns the ALTER TABLE statements so I can save the script and run it again.

  Read the article

• LINQ Single vs First

  - by BahaiResearch.com

  LINQ: Is it more efficient to use the Single() operator over First() when ever I know for certain that the query will return a single record? Is there a difference?

  Read the article

• Crystal Reports - Passing a current value of grouping field into a subreport as a parameter

  - by DarkDeny

  Hello All! I have a query with grouping on one of the fields in Crystal Reports. My question is - is there a way to pass that value into a subreport? I.e. if there are three values in that field, there will be three groups in report. I want a subreport in every group to have that value as its parameter. Is that possible to accomplish with CR 2008?

  Read the article

• Bizarre WHERE col = NULL behavior

  - by Kenneth

  This is a problem one of our developers brought to me. He stumbled across an old stored procedure which used 'WHERE col = NULL' several times. When the stored procedure is executed it returns data. If the query inside the stored procedure is executed manually it will not return data unless the 'WHERE col = NULL' references are changed to 'WHERE col IS NULL'. Can anyone explain this behavior?

  Read the article

• How would be data stored at database in case of social networking site?

  - by Abhishek Jain

  In social networking site, a person has friends/followers. There is a chain of relation. How would be data stored at database in this scenario? This is a very huge information, still result of a query comes back very fast on these sites.

  Read the article

• Is it possible to keep mysql migration running without keeping connection open?

  - by taw

  ALTER TABLE can easily take a few days - and during this time there's a non-negligible chance of connection getting terminated due to network problems. Is it possible to start ALTER TABLE (or CREATE TABLE ... SELECT ...; or some other very long running query) and leave it running without keeping connection open all the time? (the obvious solution of screen + console mysql client won't easily work as there's no ssh running on that server, only mysqld).

  Read the article

• Find Rank in Microsoft Report

  - by Alex Essilfie

  Is there any way I can find the rank of a set of values in Microsoft Reports? For instance, in order to produce a table like the one below, what function/formula do I enter in the Rank column? +------+-----+ |Value | Rank| +------+-----+ | 12 | 3 | | 30 | 5 | | 5 | 1 | | 10 | 2 | | 24 | 4 | +------+-----+ Update Values in the value column are produced from calculations on the report-side so I cannot find the rank using a query.

  Read the article

• Get records which not starts with alphabet in linq

  - by Prasad

  I need to get the list of records that does not starts with alphabets. i.e. Which starts with numeric and any special character. I am using asp.net mvc (C#) for my application. Whats the simple linq query to get this list?

  Read the article

• Multiple OR Clauses in MySQL

  - by Grant

  I'm trying to grab content where id = 3 OR id = 9 OR id = 100... Keep in mind, I can have a few hundred of these ids. What is the most efficient way to write my query? $sql = "SELECT name FROM artists WHERE (id=3 OR id=9 OR .... id-100)"

  Read the article

• Do Response.Redirect As A HTTP Post

  - by Lennie De Villiers

  Hi, I know that you can do a GET with Response.Redirect where you build the query string up but how can I do a post? I got a bunch of values in a list that I want to post using Response.Redirect to another page e.g. POST from one page to another.

  Read the article

• Hibernate - get the size of a list in a property

  - by mada

  I have a class A which have a list of B elements. In my A class i would like to add: int size; which will be valued with the number of B elements. So when I would call myA.getSize() I will have it. Is it possible to map a count query with a single property in the hibernate mapping? I don't want to load the list that is why i would like to add a size property.

  Read the article

• Synchronous database reads inside IHttpAsyncHandler

  - by sayao

  On asp.net if i call a synchronous database query inside an IHttpAsyncHandler with delegate.BeginInvoke, would it still release the asp.net worker thread while reading the database? For example, this post: http://madskristensen.net/post/How-to-use-the-IHttpAsyncHandler-in-ASPNET.aspx If i put a synchronous database call inside ServeContent, would the request still happen asynchronously?

  Read the article

• Store java.util.Calendar field into one column

  - by Rasika

  How to store java.util.Calendar field into one column with Datanucleus JDO. By default it is stored into two columns (millisecs, Timezone) with following JDO metadata. field name="startDate" serialized="true" embedded="true" persistence-modifier="persistent" What need to be changed in metadata to store it into single column (Timestamp)? Is it posible query (JDOQL) on calendar field when it is in two clumn?

  Read the article

• How do I create a table in SQLite using the VS2008 Server Explorer

  - by fishhead

  Hello, I would like to create a table in a SQLite database using the Server Explorer in VS2008. I am able to do other operations on the database but when it comes to creating a table using the query builder I get Not Supported messages. is there another way other than writing code just for the sole purpose of creating the table? CREATE TABLE myTable ( ID INTEGER PRIMARY KEY AUTOINCREMENT, Name VARCHAR(100) ) .NET Framework Data Provider for SQLite 3.6.16

  Read the article

• Is there a way to combine IN and LIKE in MySQL?

  - by abeger

  I'm currently running a query like this: SELECT * FROM email WHERE email_address LIKE 'ajones@%' OR email_address LIKE 'bsmith@%' OR email_address LIKE 'cjohnson@%' The large number of OR's bothers me. Is there a way to condense this up with something akin to an IN operator, e.g.: SELECT * FROM email WHERE email_address LIKE ('ajones@%', 'bsmith@%', 'cjohnson@%') Or is this just wishful thinking?

  Read the article

• Java library suggestions for implementing a custom web server

  - by dexter

  I would like to create a web server that will serve/accept json files through REST. The JSON files being served will come from a database query and format the results into JSON. Any suggestions for a good java library. I have tried using Apache HTTPComponents. While maybe I can just create a servlet but I am not really allowed to install a servlet container in the server machine.

  Read the article

• Application in which I need Auto-update just like Gmail inbox,calendar Face-Book etc

  - by Dhaval dave

  I have made application in which I have kept calendar,now I need that if admin changes his calendar and if it is affected to user and if that user is currently looking that calendar then whatever changes Admin has done that should reflect to user without refreshing the page, just like when email comes to Gmail then without refreshing we can see the inbox marked as unread... SO to implement that what should I do? I am using J-query for user interface and Python as back-end?????

  Read the article

• Can I use Linq-to-xml to persist my object state without having to use/know Xpath & XSD Syntax?

  - by Greg

  Hi, Can I use Linq-to-xml to persist my object state without having to use/know Xpath & XSD Syntax? ie. really looking for simple but flexible way to persist a graph of object data (e.g. have say 2 or 3 classes with associations) - if Linq-to-xml were as simple as saying "persist this graph to XML", and then you could also query it via Linq, or load it into memory again/change/then re-save to the xml file.

  Read the article

• Django: Sum on an date attribute grouped by month/year

  - by Sébastien Piquemal

  Hello, I'd like to put this query from SQL to Django: "select date_format(date, '%Y-%m') as month, sum(quantity) as hours from hourentries group by date_format(date, '%Y-%m') order by date;" The part that causes problem is to group by month when aggregating. I tried this (which seemed logical), but it didn't work : HourEntries.objects.order_by("date").values("date__month").aggregate(Sum("quantity"))

  Read the article

< Previous Page | 464 465 466 467 468 469 470 471 472 473 474 475  | Next Page >