Search Results

Search found 17583 results on 704 pages for 'query analyzer'.

Page 444/704 | < Previous Page | 440 441 442 443 444 445 446 447 448 449 450 451  | Next Page >

• Django database caching

  - by hekevintran

  The object user has a foreign key relationship to address. Is there a difference between samples 1 and 2? Does sample 1 run the query multiple times? Or is the address object cached? # Sample 1 country = user.address.country city = user.address.city state = user.address.state # Sample 2 address = user.address country = address.country city = address.city state = address.state

  Read the article

• How to do a join that removes values?

  - by Georg

  Customers Holidays id | name customer_id | start | end ---+------ ------------+--------+------ 1 | Peter 1 | 5 | 10 2 | Simon 1 | 15 | 20 3 | Mary 2 | 5 | 20 How should my SQL query look that out of start=11,end=14 I get these customers: Peter Mary Is this even manageable with a simple SQL join, or do I need to use sub-queries?

  Read the article

• Database schema for multiple category/product relationship

  - by sree01

  I want to design a database for an e-commerce application with category/subcategory management. Please suggest a database schema where we can create categories and subcategories and add products to those categories. Each product can have multiple categories and we can select products belong to multiple categories using a boolean database query Thanks

  Read the article

• Adding miliseconds to a datetime in tsql INSERT INTO

  - by DavRob60

  I'm doing a INSERT INTO query in order to initialize a new table. The primary key is RFQ_ID and Action_Time How could add 1 milisecond to each Action_Time on new record in order to avoid "Violation of PRIMARY KEY constraint" INSERT INTO QSW_RFQ_Log (RFQ_ID, Action_Time, Quote_ID) SELECT RFQ_ID , GETDATE() AS Action_Time , Quote_ID , 'Added to RFQ on Initialization' AS Note FROM QSW_Quote

  Read the article

• Hibernate Criteria API equivalent to HQL select clause?

  - by Visus Zhao

  I'd like to have a combined query for two persistent classes. In HQL this could be achieved by the select clause, select new Family(mother, mate, offspr) from DomesticCat as mother join mother.mate as mate left join mother.kittens as offspr In the above example, Family is a conbined class with DemesticCat as its construtor params What is the Criteria equivalent of the HQL select clause ?

  Read the article

• Programmatically measure size and way-order of L1 and L2 caches

  - by osgx

  How can I measure programmatically (not query the OS, but measure) the size and order of associativity of L1 and L2 caches (data caches)? Assumptions about system: It has L1 and L2 cache (may be L3 too, may be cache sharing), It may have a hardware prefetch unit (just like P4+), It has a stable clocksource (tickcounter or good HPET for gettimeofday). There are no assumptions about OS (it can be Linux, Windows, or something non-standard), and we can't use POSIX queries. Language is C. And compiler optimizations may be disabled.

  Read the article

• prob. with tquery.requestlive

  - by Vijay Bobba

  hi, do any one know how to request a "live result set" in MySQl when query has offset(eg: select * from table where limit 10 offset 20;). it is throughing an error like 'invalid use of key word'. Thanks, Vijay.

  Read the article

• PreparedStatement alternative within JPA ?

  - by worldpython

  Dear all, I am new to JPA, I used to used prepared statement in JDBC. Is there alternative to be used within JPA ? as there is a query which I call frequently see this for info about prepared statment http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html thanks in advance,,,

  Read the article

• "Select NOT IN" clause in Linq to Entities

  - by lnetanel

  Hi, Is there a way to use the "NOT IN (select XXX...)" clause in Linq to Entities? All the questions I found were regarding a list of objects (IN (1,2,3)) but I want to generate a query with the following syntax: "select * from table1 where field1 not in(select subfield from subtable)" Be aware that this is Linq to Entities and not Linq to Sql... Is it possible? Thanks!

  Read the article

• Non-Linear Database Retrieval

  - by pws5068

  I'm building an article system, and each article will have one more Tags associated with it (similar to the Tags on this site). The tables are set up something like this: Article_Table Article_ID | Title | Author_ID | Content | Date_Posted | IP ... Tag_Table Tag_ID | Name ... Tag_Intersect_Table Tag_ID | Article_ID Is it possible query an article and all of its associated tags in one database call? If so, how is this done?

  Read the article

• Question on compiling java program

  - by Hulk

  I am a newbie to java, i have a query, /home/bob/java/jdk1.5.0_06/bin/javac /home/bob/output/a.java In the above when the program is compiled how to generate the classfile in /home/bob/class. Also how should the environment variables set for the following i.e, JAVA_HOME,CLASSPATH,JAVAPATH Thanks..

  Read the article

• SqlDataAdapter Update

  - by Santhosh

  Can any one help me why this error occurs when i update using sqlDataadapter with join query Dynamic SQL generation is not supported against multiple base tables.

  Read the article

• Most Efficient Way To Retrieve MYSQL data in random order PHP

  - by Belgin Fish

  Hey, I have a query like so SELECT * FROM table WHERE premium = 3 I'm just wondering how I can have it return a random order for the results! i was told not to use ORDER BY RAND(); because of the amount of system resources it uses. Thanks.

  Read the article

• How to schedule HTML or TXT report format in OpenReports

  - by Damir Sudarevic

  I am using OpenReports with a simple query (QueryReports) to generate reports. Once generated, only CSV, Excel and PDF are offered as formats for scheduled emails. Would anyone know how to enable HTML or TXT for emailing? The version is 3.0.

  Read the article

• How do you find the disk size of a Postgres table and its indexes

  - by mmrobins

  I'm coming to Postgres from Oracle and looking for a way to find the table and index size in terms of bytes/MB/GB/etc, or even better the size for all tables. In Oracle I had a nasty long query that looked at user_lobs and user_segments to give back an answer. I assume in Postgres there's something I can use in the information_schema tables, but I'm not seeing where. Thanks in advance.

  Read the article

• Help with ASP.NET 4.0 routing and subfolders

  - by pixel3cs

  If I use routing with 2 query parameters, like this: System.Web.Routing.RouteTable.Routes.MapPageRoute("HomeRoute", "home/{f1}/{f2}", "~/Home.aspx"); My image does not appear on my Home.aspx page: <img src="~/img/img.jpg" /> or <img src="img/img.jpg" /> But it does appear when I access the http://localhost:3760/Website/Home.aspx URL I tried using Routing.Ignore with no luck. I look for a solution wich should work for an unlimited number of subfolders: "home/{f1}/{f2}/.../{fn}"

  Read the article

• PHP & MySQL Pagination

  - by Francesc

  Hi. I have a MySQL query SELECT * FROM 'redirect' WHERE 'user_id'= \''.$_SESSION['user_id'].' \' ORDER BY 'timestamp'` I want to paginate 10 results per page. How Can I do it?

  Read the article

• how to select different parts of an image

  - by abhinav

  there is a .png image displaying human body skeleton.My query is that how to select diffrent parts of the skeleton like hand,foot,head etc in the image and then after selection control moves into another view which displays information about that selected part.

  Read the article

• Splitting up UDP packet

  - by m3n

  Heyo, I'm using UdpClient to query game servers about server name, map, number of players, etc. I've followed the guidelines on this page http://developer.valvesoftware.com/wiki/Server_queries#Source_servers and I'm getting a correct reply: I have no idea how I would go about to get each chunk of information (server name, map and the like). Any help? I'm assuming one would have to look at the reply format specified in the wiki I linked, but I don't know what to make of it. Cheers,

  Read the article

• tsql replace value on select

  - by Zelter Ady

  I have a column (SERVICE_ID) in my table where I can have only 3 values: 0, 1 and 2. I'd like on select, on displayed result table, to change those value with some english words. select client, SERVICE_ID from customers displays now: -------------------------- | John | 1 | Mike | 0 | Jordan | 1 | Oren | 2 -------------------------- I'd like to change the query to get: -------------------------- | John | QA | Mike | development | Jordan | QA | Oren | management -------------------------- There is any way to do this using only the select?

  Read the article

• FIND_IN_SET exists in MySQL but how do I make it in SQLite?

  - by Pentium10

  In MySQL there exists FIND_IN_SET, that locates a match in a comma separated list. mysql> SELECT FIND_IN_SET('b','a,b,c,d'); -> 2 How would I be able to do this in SQLite in query? Please note, that I can't define or add user defined functions, the Android platform doesn't allow it.

  Read the article

• What is the big deal with IQueryable?

  - by jjr2527

  I've seen a lot of people talking about IQueryable and I haven't quite picked up on what all the buzz is about. I always work with generic List's and find they are very rich in the way you can "query" them and work with them, even run LINQ queries against them. So I'm wondering if there is a good reason to start considering a different default collection in my projects.

  Read the article

• How can I use geoalchemy with elixir autoload tables?

  - by Dan Ellis

  I'm using geoalchemy and autoloaded tables, but I'd like to use Elixir, because it has a nicer query syntax. Does anyone know how to get them to work together? I did get it working with this code -- http://pastie.textmate.org/private/y3biyvosuejkrtxbpdv1a -- but that still gives the ugly warning about not recognising the geometry column when the table is reflected. Ideally, what I'd like to do is to get SQLAlchemy's own table reflection to recognise the geometry columns. How would I plumb them together?

  Read the article

• uploading file size

  - by Anup Prakash

  As we all know, By default in PHP+MySQL, we can upload a file of size 1.4MB (max). 1) My Question is how can i increase the limitation of this uploading file size? 2) What is the maximum limitation for file to be uploaded in database? Thanx for viewing my query and special thanx for answering my questin.

  Read the article

• How effective are technical test(s) and is it necessary?

  - by The Elite Gentleman

  Hi everyone, I recently took a Java technical test (for a company who wanted are looking for senior java developers) and, funny enough, I only realised the technical terms of what I've been doing all along after I've written the test. I'm not too IT jargon when it comes to development but I can pretty much code and create solutions unaware that I'm using design pattern (or the specifics of that design pattern) or technology. I learned things such as JMS, Frameworks, etc. while programming at home and having to google stuff online to problems I have. Others e.g. IoC, Surrogates in Databases, etc., I have used extensively without knowing that it had a name for it. Do you think that these technical test are effective and why? What interesting questions did you find that boggled your brains out while the clock kept ticking? Seeing that IT is vastly evolving at a rapid rate, do we have to constantly be updated with new terms that comes out? Some questions I was asked : What object oriented principle is violated by this architectural mechanism for dot notation? Is indexing tables effective for range query or point query search? What is ThreadLocal and what is it used for? Method overloading vs Method overriding. What is the difference between the 2? What is dynamic binding? Now, imagine my poor head trying to understand these jargons (considering I use it almost everyday) PS The question was not a programming question, where you have a problem and write code to solve it. Rather, a thinking type question and you write answers (against the clock). Update I clearly didn't come out clearly as I should have. There are those that are technically "book smart" but with very little hands-on experience and vice versa. So, the question (in connection to what I've asked) is that are these technical test seeking "book smart" people or people with lots of hands-on experience (some who are not that well clued up with too much book-smart jargons). How effective is it then, for companies to look for developers if most of the questions are too terminology-centric? (if that's the correct term, :))

  Read the article

< Previous Page | 440 441 442 443 444 445 446 447 448 449 450 451  | Next Page >