Search Results

Search found 22358 results on 895 pages for 'django raw query'.

Page 642/895 | < Previous Page | 638 639 640 641 642 643 644 645 646 647 648 649  | Next Page >

• cakePHP and GROUP BY

  - by Lizard

  I am trying to solve a hopefully simple problem here is the query I am trying produce: SELECT `categories`.*, COUNT(`entities`.id) FROM `categories` LEFT JOIN `entities` ON (`categories`.`id` = `entities`.`category_id`) GROUP BY `categories`.`id` I am really struggling to do this is in cakePHP 1.2 How would/should I go about doing this... (I am using 'Containable' if that helps) Thanks in advance

  Read the article

• How to avoid fast rate page refresh in ASP.NET ?

  - by eugeneK

  I have a page that shows statistics for users, this cannot be cached because each user has different statistics and there are many thus the real time query must be made. What the way to avoid database server overload when user will click F5's to refresh or to ask different queries in short time intervals ?

  Read the article

• Need some sort of "conditional grouping" in MySQL.

  - by serg555

  I have Article table: id | type | date ----------------------- 1 | A | 2010-01-01 2 | A | 2010-01-01 3 | B | 2010-01-01 Field type can be A, B or C. I need to run a report that would return how many articles of each type there is per every day, like this: date | count(type="A") | count(type="B") | count(type="C") ----------------------------------------------------- 2010-01-01 | 2 | 1 | 0 2010-01-02 | 5 | 6 | 7 Currently I am running 3 queries for every type and then manually merging the results select date, count(id) from article where type="A" group by date Is it possible to do this in one query? (in pure sql, no stored procedures or anything like that). Thanks

  Read the article

• contacts quey with name and picture URI.

  - by codeScriber

  Hi i couldn't find a single query that would give me in API 2.0 of the contacts API the URI of the contact's image and the display name. For now as far as i know i can create a uri by having the contact's _ID , but i didn't see any row name that i can use in the projection of Data or Contact to get all that i need. can anyone help ? (i refer to using API 2 of the contacts API on android SDK V5 and above ) 10x.

  Read the article

• Comma separated list of values as different rows, not as fields for one row, for an SQL INSERT

  - by Petruza

  I want to make many inserts in a single SQL statement, pretty much like INSERT INTO xxx SELECT field FROM zzz But with values I don't have in a table, and are just a list of literals. Normal way would be executing one SQL query for each value, but if there exists a standard SQL statement, or MySQL-specific, it would be great.

  Read the article

• Parse multiple filters in SQL

  - by Jeff Meatball Yang

  I have a problem parsing a stored procedure parameter in the form: declare @S varchar(100) set @S = '4=2,24=1534' Here's the query: select cast(idx as varchar(100)) 'idx' , value , SUBSTRING(value, 1, charindex(value, '=')+1) 'first' , SUBSTRING(value, charindex(value, '=')+1, LEN(value)-charindex(value, '=')-1) 'second' from Common.SplitToTable(@S, ',') -- returns (idx int, value varchar(max)) where len(value) > 0 But here is the result I get: idx value first second 0 4=2 4 4= 1 24=1534 2 24=153 Here's what I expected: idx value first second 0 4=2 4 2 1 24=1534 2 1534 Help?

  Read the article

• Regex Question ...

  - by kate

  Hi, Could someone help me with the following RegEx query: based on the following rules: 1) 1 letter followed by 4 letters or numbers, then 2) 5 letters or numbers, then 3) 3 letters or numbers followed by a number and one of the following signs: ! & @ ? You will have to allow customers to input the fidelity card code as a 15-character string, or as 3 groups of 5 chars, separated by one space.

  Read the article

• Is it possible to include JButton in a JTable?

  - by Benjamin Confino

  I have a JTable that stores the results of a database query, so far so good. What I want is for the last column in each table to have a clickible JButton that will open the edit screen for the object represented in that row, and that means the button will need to know the details of the first column in the table from its own row (the ID from the database). Any advice? I already tried just adding JButtons but they turned into Text when I tried to run it.

  Read the article

• itunes http link to apps with a keyword

  - by BahaiResearch.com

  Is there a way to generate an http link which will open iTunes to the results of a query for apps with a specific keyword. I have a number of apps and I want my users from my web site to see those with a common keyword. So not to my full list by default.

  Read the article

• How do I create a stored procedure that calls sp_refreshview for each view in the database?

  - by Allrameest

  Today I run this select 'exec sp_refreshview N''['+table_schema+'].['+table_name+']''' from information_schema.tables where table_type = 'view' This generates a lot of: exec sp_refreshview N'[SCHEMA].[TABLE]'. I then copy the result to the query editor window and run all those execs. How do I do this all at once? I would like to have a stored procedure called something like dev.RefreshAllViews which I can execute to do this...

  Read the article

• How to round down a DateTime value

  - by timpone

  I have a Location that can have Events. I want to have an upcoming_events method but want it to round down such that if someone looks at 10pm at night, it will show todays events. I have this: def upcoming_events d=Time.new d.strftime("%m-%d-%Y") l=Event.where('location_id=? and start_datetime>?',self.id, d) end I gets converted down correctly but in d.strftime but the query is: SELECT `events`.* FROM `events` WHERE (location_id=301 and start_datetime>'2012-06-20 02:49:23') Any idea how to just get it to do '2012-06-20'?

  Read the article

• Mysql SQL join question

  - by David

  I am trying to find all deals information along with how many comments they have received. My query select deals.*, count(comments.comments_id) as counts from deals left join comments on comments.deal_id=deals.deal_id where cancelled='N' But now it only shows the deals that have at least one comment. What is the problem?

  Read the article

• Silverlight 4 Datagrid Sorting

  - by DavyMac23

  I'm having a heck of a time trying to get a silverlight datagrid to properly sort, and do so quickly (sub 1/10 second). Here's the scenario: -WCF callback every 1/5 of a second -Take the callback, match up to the existing record in an ObservableCollection -Update the ObservableCollection's properties -Bind the grid. I've tried a linq query, PagedCollectionView, and observablecollection.select(), all are waaaaaaay too slow, and introduce 12+ second delays in processing. Anyone else experience this?

  Read the article

• Generate several sql insert from an sql select sentence

  - by blgnklc

  How can I generate some insert sql sentences using a specific select query. Are there any tool from Ms Sql Server 2008? or else?

  Read the article

• Does it make sense to create index on field with less changeability ?

  - by Maciej

  I heard opinion that it make no sense to create indexes when field has less changeability. Eg if it stores only A,B,C,D values then there wouldn't be benefit of having such index, and further more SQL server will not use it at all when executing query. I wonder your opinion on that matter?

  Read the article

• 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

• 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

• 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

• 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

• 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

• Insert the lowest possible unique positve integer in an atomic fashion in MySql

  - by Jason Christa

  Say I have a table with a unique positive integer field. I currently have rows with id's of [1, 2, 3, 4, 5, 8, 12, 35]. Is there a insert query that I could write that would assign the id field to the lowest unique positive integer (in this case 6)? It would have to do this atomically so there isn't the possibility of concurrent inserts wiping out each other or failing.

  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

• 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

• 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

• 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

< Previous Page | 638 639 640 641 642 643 644 645 646 647 648 649  | Next Page >