Search Results

Search found 23955 results on 959 pages for 'insert query'.

Page 604/959 | < Previous Page | 600 601 602 603 604 605 606 607 608 609 610 611  | Next Page >

• Distinct with Count and SQl Server

  - by chopps

  Hey everyone, Trying to work on a query that will return the top 3 selling products with the three having a distinct artist. Im getting stuck on getting the unique artist. Simplified Table schema Product ProductID Product Name Artist Name OrderItem ProductID Qty So results would look like this... PID artist qty 34432, 'Jimi Hendrix', 6543 54833, 'stevie ray vaughan' 2344 12344, 'carrie underwood', 1

  Read the article

• 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

• 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

• 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

• 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

• 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

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

• 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

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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Why use TRANSACTION ISOLATION LEVEL READ UNCOMMITTED?

  - by Kip Birgen

  In plan in English what are the disadvanges and advantages of using SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in query for .net applications and reporting services application?

  Read the article

• Installing ngResource in Factory

  - by rackhamup

  I am trying to install ngResource into a factory like so: 'use strict'; var DTapp = angular.module('DeviceTraining'); /* Services */ DTapp.factory('Slides', ['ngResource', function($resource) { return $resource('slides/:slideID.json', {}, { query: {method:'GET', params:{slideID:'slides'}, isArray: true} }); }]); But I am getting this error message: Error: [$injector:unpr] Unknown provider: ngResourceProvider <- ngResource <- Slides Any help?

  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

< Previous Page | 600 601 602 603 604 605 606 607 608 609 610 611  | Next Page >