Search Results

Search found 19449 results on 778 pages for 'query builder'.

Page 550/778 | < Previous Page | 546 547 548 549 550 551 552 553 554 555 556 557  | Next Page >

• How do I set prifix to django contrib tables names?

  - by Software Enthusiastic

  HI One of my requirement is to have prefix on all the tables of the django based project (Because db is hosted on shared server). I have used db_table Meta option to set the prefix for the tables which I have created. Now my query is how do I set the prefix for tables provided by django.contrib. Instead of auth_group django should create prefix_auth_group.... How do I do that? Thank you very much...

  Read the article

• Why cant i use the field user in SQL Server 8?

  - by acidzombie24

  Maybe not literally but the query below gets an error near user. If i change it to userZ it works. WHY can i not use that name? Is there a way to specific its a field instead of a keyword? (or whatever it is) create table Post2 ( id INTEGER PRIMARY KEY NOT NULL, title nvarchar(max) NOT NULL, body nvarchar(max) NOT NULL, user integer REFERENCES Post1(id));

  Read the article

• Removing part of a string in PHP

  - by Nik

  I'm trying to take a query: SHOW TABLES; which will display a bunch of tables with the chat_ prefix. I want to remove the chat_ prefix from the string, format the variable (with a link), and display it. How is this accomplished?

  Read the article

• 'Subquery returned more than 1 value' problem in EntityFramework

  - by plotnick

  I have one 'Transaction' entity object with 'Operations' navproperty with multiplicity of 'Many'. When I'm adding only one operation per transaction nothing happens, but when I'm trying to add more than one operation, db.SaveChanges() throws an exception like 'Subquery returned more than 1 value blah, blah, blah' How can I solve that? Help me guys please... BTW... Could you tell me how can I see the exact query string that EF passes to Sql Server on db.SaveChanges() method?

  Read the article

• MySQL skip first 10 results

  - by Brian

  Is there a way in MySQL to have the first 10 result from a SELECT query skipped? I'd like it to work something like LIMIT.

  Read the article

• Get top rated item using AVG mysql

  - by user1876234

  I want to find top rated item using AVG function in mysql, right now my query looks like this: SELECT a.title, AVG(d.rating) as rating FROM in8ku_content a JOIN in8ku_content_ratings d ON a.id = d.article_id ORDER BY rating DESC Problem is that it takes AVG of all items and the result is not accurate, what should be changed here to get correct result ? Tables: in8ku_content [id, title] in8ku_content_ratings [id, article_id, rating]

  Read the article

• select records from table in the order in which i inserted

  - by echo

  consider a tale is as follows, EmployeeId | Name | Phone_Number Now, i insert 10 records... When i query them back, select * from myTable they are not selected in the order i inserted. I can obviously keep an autoincrement index and ORDER BY index. But i dont want to alter the table. How can i do this without altering the table?

  Read the article

• Hibernate (JPA) Entity with Static collection as a member

  - by Kyle Partridge

  Is it possible to have a static collection as a member of a hibernate entity? Say I have an object Question: public class Question { private String category; ... } Would it be possible to populate a static Set<String> that is a distinct set of all categories in the Database? I know I could just query this, but I was wondering if there was a more elegant solution, as it seems like something that other people may have come across.

  Read the article

• "Ambiguous column name" error on one particular server

  - by jazbit

  This simple query throws the "Ambiguous column name TaskID" error on one db-server only. This is ridiculous. We tested this with the same database structure on different servers and different versions of ms sql (2005/2008), and it's only THIS particular client's server that throws the error. I'm actually frustrated. SELECT Tasks.TaskID FROM Tasks INNER JOIN TaskHelpers ON TaskHelpers.TaskID = Tasks.TaskID order by TaskID Yes, I know I can put "Tasks.TaskID" into the order by clause, but for some reasons I can't.

  Read the article

• Resultset To List

  - by Gnaniyar Zubair

  I want to convert my Resultset to List in my JSP page. and want to display all the values. This is my query: SELECT userId, userName FROM user; I have executed that using preparedstatement and got the Resultset. But how to convert it as a List and want to display the result like this: userID userName ------------------ 1001 user-X 1006 user-Y 1007 user-Z

  Read the article

• R equivalent of SELECT DISTINCT on two or more fields/variables

  - by wahalulu

  Say I have a dataframe df with two or more columns, is there an easy way to use unique() or other R function to create a subset of unique combinations of two or more columns? I know I can use sqldf() and write an easy "SELECT DISTINCT var1, var2, ... varN" query, but I am looking for an R way of doing this. It occurred to me to try ftable coerced to a dataframe and use the field names, but I also get the cross tabulations of combinations that don't exist in the dataset: uniques <- as.data.frame(ftable(df$var1, df$var2))

  Read the article

• Log of SVN activity for a certain user?

  - by Louis W

  Is it possible to query for all activity relating to a specific user across all repositories. Including any check out action? Thanks.

  Read the article

• Copying an entire table with Postgres

  - by NudeCanalTroll

  Hello, I'm trying to copy the contents of one table into another in Postgres, however it appears some rows aren't being copied correctly: ActiveRecord::StatementInvalid: PGError: ERROR: column "email_date" is of type timestamp without time zone but expression is of type character varying HINT: You will need to rewrite or cast the expression. Is there any way I can have it automatically skip (or ignore) invalid rows? Here's the query I'm using: SET statement_timeout = 0; INSERT INTO emails3 SELECT * FROM emails

  Read the article

• How to identify whether the table has identity column

  - by Shiny

  My Scenario is... I want to find out whether the table has an identity column or not.Table is unknown to me.I have not done the structure of the table.using Query? Im using Sql Compact.

  Read the article

• Confused about distinct/aggregate queries with (N)Hibernate

  - by nw

  I'm not sure how to approach queries that don't map 1:1 to my persistent entities - in other words, distinct and aggregate queries. For example, I need to retrieve a distinct list of property values for populating a drop-down list. Should I write a class and a mapping for the "entities" that are returned by this query? Or should I just use the native DB provider and work with native data sets instead?

  Read the article

• Side-by-side comparison of data by month in SQL

  - by ScottR

  I have table similar to the following: Year | Product | Value 2006 A 10 2006 B 20 2006 C 30 2007 A 40 2007 B 50 2007 C 60 I would like a query that would return the following comparison Product | 2006 Value | 2007 Value A 10 40 B 20 50 C 30 60 What are the options to do so? Can it be done without joins? I'm working with DB2, but answers in all SQL types would be helpful.

  Read the article

• Count # of links programmatically

  - by Duber

  You know how if you type links: "yourwebsite.com" into the normal google search box, it tells you the number of sites linking to you and their addresses. How can I do it programmatically with php? Does google provide an api that can I can programmatically query? What are my options?

  Read the article

• Is it possible to execute the two update queries in phpmyadmin together?

  - by Parth

  Is it possible to execute the two update queries in phpmyadmin together? Like wise UPDATE jos_menu SET home = 0 WHERE 1; UPDATE jos_menu SET home = 1 WHERE id = 9; Now can we copy both these queries together and Run it on phpmyadmin sql query panel? will it be executed?

  Read the article

• Php function within SQL statement syntax

  - by Vafello

  I have the following code. I would like username to take the value of the getUserName function however I am fighting with syntax. Can anybody tell me what should be the correct one? $query = "SELECT user FROM users_entity WHERE username = getUserName()";

  Read the article

• MySQL grouping by a previously declared alias, what do I wrap it in? ' OR `

  - by cgmojoco

  I have an SQL query that has an alias in the SELECT statement SELECT CONCAT(YEAR(r.Date),_utf8'-',_utf8'Q',QUARTER(r.Date)) AS 'QuarterYear' Later, I want to refer to this in my group by statement. I'm a little confused...should I wrap this with backticks, single quote or just leave it unwrapped int he group by GROUP BY `QuarterYear ` or should I do this?: GROUP BY 'QuarterYear' or just this?: GROUP BY QuarterYear

  Read the article

• ListView: Display data divided into groups?

  - by jawonlee

  I would like to display the contents of a DataTable, divided into several groups depending on the value of one of the columns. So, if I have a DataTable (from SQL query) with: GroupID Name Description 1 foo bar 1 one two 2 some thing I would like to place all records containing GroupID 1 in one div, all records with GroupID 2 in another div, and so on. How can I do this? I'm writing in ASP.NET 4.0, with C# codebehind.

  Read the article

• Foreign keys - temporarily bypass?

  - by Industrial

  Hi, I have just started to learn about the pros of foreign keys in database design (mySQL / innoDB) and I wonder if there's any way to temporarily bypass the foreign key when doing a specific delete query, to just delete in the parent table, and not from the linked child tables. Thanks

  Read the article

• How to select distinct in SQl Server 2008 but for only one field out of many?

  - by bakerjr

  I have a query: SELECT Content.content_name, Language2.Name, Language2.language_id, Content.id, Content.content_description, FROM Language AS Language2 LEFT JOIN contents AS Content ON (Language2.language_id = Content.language_id) How do I select only the distinct content_name?

  Read the article

• Navigate through .Net Grid

  - by SH

  is there a way to navigate through gird found on this page by passing parameters in query string? http://pubrec3.hillsclerk.com/oncore/search.aspx?bd=01/01/2008&ed=12/31/2008&bt=O&lb=1000000&ub=1000000000&d=5/6/2010&pt=-1&dt=D,%20MTG&st=consideration Or any code suggestion? All example could i need in C#.

  Read the article

• c# update xml file

  - by Pila

  I want to replace a xml node that is not a child of the root element. how can I do it - not in .Net 3.5? I don't know the exact path to the node I want to replace, I get the node by XPath query like : XmlElement root = doc.DocumentElement; oldItem = root.SelectSingleNode("//Node1[@name='aaa']//Node2[Item='bbb']/Value"); how can I replace this olditem?

  Read the article

< Previous Page | 546 547 548 549 550 551 552 553 554 555 556 557  | Next Page >