Search Results

Search found 17537 results on 702 pages for 'doctrine query'.

Page 150/702 | < Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >

• Parameters in query with in clause ?

  - by Hugues Van Landeghem

  Hi all, I want to use parameter for query like this : SELECT * FROM MATABLE WHERE MT_ID IN (368134, 181956) so I think about this SELECT * FROM MATABLE WHERE MT_ID IN (:MYPARAM) but it doesn't work... Is there a way to do this ? I actually use IBX and Firebird 2.1 I don't know how many parameters in IN clause.

  Read the article

• MySQL query count multiple values

  - by Sqlclown

  Consider the following DB table: c p ========= 1 'a' 1 'b' 2 'a' 2 'c' Now, my goal is to retrieve a list of numbers c, for which holds that each number in this list has at least a record with p='a' AND p='b'. In the example table above, that would be c=1. Now my question is, how do I accomplish this using one MySQL query?

  Read the article

• Query labels with a specific attribute in ClearCase

  - by Vereb

  How can I query those of the labels in ClearCase with cleartool that have a specific attribute. I can list the labels with lstype -kind lbtype but I'd like to get only those that have an attribute called TestAttr.

  Read the article

• Recursive t-sql query

  - by stackoverflowuser

  Hi I have a table as shown below. ID ParentID Node Name Node Type ------------------------------------------------------------------ 525 524 Root Area Level 1 526 525 C Area Level 2 527 525 A Area Level 2 528 525 D Area Level 2 671 525 E Area Level 2 660 527 B Area Level 3 672 671 F Area Level 3 How can i write a recursive t-sql query to generate below output? Output ("Root" node not required in the output): Node ID ----------------------- A 527 A/B 660 C 526 D 528 E 671 E/F 672 Thanks

  Read the article

• sharepoint full text query with attributes missing isn't returning the results I expected

  - by Jason Hocker

  If I am doing a search in sharepoint, some of the results I'm expecting are not being returned. I believe its because in active directory these entries may not have all the fields. So a name that doesn't have the givenName attribute set in active directory is not being returned from this query. Is there a way I can get this to work like I expected? "select LastName, FirstName, PreferredName, AccountName from scope() where \"scope\"='People' AND (LastName like '%" + search + "%' OR FirstName like '%" + search + "%' OR PreferredName like '%" + search + "%')";

  Read the article

• How to get array with clear data from Active Record query without using map

  - by Suborx

  Hi I would like to ask if its possible get array with clear data from ActiveRecord query without using map, collect or each. names = User.find(:all, :select => "name") return names == [#<User name:"Peter">,#<User name:"Martin">] and I want names == ["Peter", "Martin"] without using map, collect or each. Thanks for your answers.

  Read the article

• Codeigniter ignoring query strings. Only loading

  - by Keyo

  I have setup remote debugging in netbeans. It works except codeigniter only loads the default controller (home page). I have enabled query strings with $config['enable_query_strings'] = TRUE; The debugger opens up a page with the following url http://blinkfilms.ben.dev/myid/tests?XDEBUG_SESSION_START=netbeans-xdebug So codeigniter should fire up the controller in controllers/myid/tests.php

  Read the article

• loading multiple line query in one row

  - by bharath

  Hi, How to load a multiple line query in one row using mysql.The data is stored in a text file. For example: "GGAGTTGTGGGAGTGGAGGAGGAAGAGGCGGTGGGGAGTACGGGGGCTGGTCCCAGAAGATGGCGGAGGC GGGGGATTTCTGGTAGGTCCTACTTTAGGACAAGATGTGGTGGTACTGTTGAAGCGTCAGTCTTTGATTC" Thanks in advance.

  Read the article

• Is there a way to turn this query to regular inline SQL

  - by Luke101

  I would like to turn this query to regular inline sql without using stored procedures declare @nod hierarchyid select @nod = DepartmentHierarchyNode from Organisation where DepartmentHierarchyNode = 0x6BDA select * from Organisation where @nod.IsDescendantOf(DepartmentHierarchyNode) = 1 Is there a way to do it?

  Read the article

• PHP: using REGEX to get the tablename from a mysql query

  - by Matt

  Hi Guys, Consider these three mysql statements: select * from Users; select id, title, value from Blogs; select id, feelURL, feelTitle from Feeds where id = 1; Now im not very good at REGEX, but i want to get the table name from the mysql query. Could someone possibly create one for me with a little explanation. Thanks,

  Read the article

• t-sql grouping query

  - by stackoverflowuser

  Hi based on the following table Name --------- A A A B B C C C I want to add another column to this table called 'OnGoing' and the values should alternate for each group of names. There are only two values 'X' and 'Y'. So the table will look like Name OnGoing ---------------- A X A X A X B Y B Y C X C X C X how to write such a query that can alternate the values for each group of names.

  Read the article

• How can I add default values to a parameterized query

  - by Sean Taylor

  When using stored procedures I am able to add default values to parameters, for example: @name varchar(50) = NULL Is is possible to do something similar when using a parameterized query in .NET. Thanks

  Read the article

• Django query to get a unique set based on a particular column's value

  - by kchau

  Hope this makes sense... Is there a simple way to return a set of values from a table based on a single column's values being distinctly unique? What I'm hoping for is something like: SegCode.query.filter(ref.unique()).only('ref') That's not real code, but I was hoping there was some simple function out there that will accomplish this...

  Read the article

• MySQL query advice

  - by vasion

  I am lost in MySQL documentation. I have a table with votes - it has these columns id song_id user_id created I cannot find the query which will process the information and output the 10 most voted songs in a given time period. What is it?

  Read the article

• sql query to return items based on text and group ID

  - by mattgcon

  I am not sure how to best describe what I am trying to do (or search for it for that matter) but I am going to try. I have a pre-existing query (stored procedure) that returns items based on 3 specific ID's. What I want to do is to be able to reduce the results even further based upon a column within the results having the exact same string. For some reason I am confused about how to do this, I am drawing a complete blank about this. Please help

  Read the article

• Rails 3 equivalent of complex SQL query

  - by Bryan

  Given the following models: class Recipe < ActiveRecord::Base has_many :recipe_ingredients has_many :ingredients, :through => :recipe_ingredients end class RecipeIngredient < ActiveRecord::Base belongs_to :recipe belongs_to :ingredient end class Ingredient < ActiveRecord::Base end How can I perform the following SQL query using Arel in Rails 3? SELECT * FROM recipes WHERE NOT EXISTS ( SELECT * FROM ingredients WHERE name IN ('chocolate', 'cream') AND NOT EXISTS ( SELECT * FROM recipe_ingredients WHERE recipe_ingredients.recipe_id = recipes.id AND recipe_ingredients.ingredient_id = ingredients.id))

  Read the article

• Query for a exact string in Zend Lucene PHP Not fuzzy match

  - by Podlsk

  Im using the Zend Lucene however Im have a little trouble. I wish to query the index for the exact tring so page_name IS test123, not any fuzzy match. Currently I have: $hits = $index-find('page_name:"test123"'); And advice appreciated, thanks!

  Read the article

• Apache Rewrite - put parts of query string in replacement string

  - by Rangi Robinson

  Hello, I'd like to rewrite: www.example.com/file.html?username=john&number=1234 To: www.example.com/users/john But I can't figure out how to extract the "username" value from the query string. I've been Googling this all morning and reading the official docs but no luck. I need to solve this problem with a rewrite, rather than changing the application. Any help much appreciated! Rangi

  Read the article

• sql query problem

  - by benjamin button

  why this query give me an error:ORA-01790 SELECT TO_CHAR(logical_date,'MM') MONTH FROM logical_date WHERE logical_date_type='B' UNION SELECT TO_CHAR(logical_date,'MM')+1 MONTH FROM logical_date WHERE logical_date_type='B' but when i run them separately,they give the proper output.

  Read the article

• How to make CodeIgniter accept "query string" URLs?

  - by Peter

  According to CI's docs, CodeIgniter uses a segment-based approach, for example: example.com/my/group If I want to find a specific group (id=5), I can visit example.com/my/group/5 And in the controller, define function group($id='') { ... } Now I want to use the traditional approach, which CI calls "query string" URL. Example: example.com/my/group?id=5 If I go to this URL directly, I get a 404 page not found. So how can I enable this?

  Read the article

• Help speed this MySQL query which is taking too long because of an aggregate function

  - by Joseph

  Hi all, I am using a following query in MySQL for fetching data from a table. Its taking too long because the conditional check within the aggregate function.Please help how to make it faster SELECT testcharfield , SUM(IF (Type = 'pi',quantity, 0)) AS OB , SUM(IF (Type = 'pe',quantity, 0)) AS CB FROM Table1 WHERE sequenceID = 6107 GROUP BY testcharfield

  Read the article

• SQL query on table that has 2 columns with a foreign id on the same table

  - by spyk

  Hello all, I have a table let's say in the form of: match(id, hometeam_id, awayteam_id) and team(id, name). How do I build my SQL query in order to get a result table in the form of (match_id, hometeam_name, awayteam_name), since they both (hometeam_id, awayteam_id) reference the same table (team)? Thank you

  Read the article

• Query for a exact string in Zend Lucene PHP

  - by Podlsk

  Im using the Zend Lucene however Im have a little trouble. I wish to query the index for the exact tring so page_name IS test123, not any fuzzy match. Currently I have: $hits = $index->find('page_name:"test123"'); And advice appreciated, thanks!

  Read the article

• How can I see the numbers of rows a query affects when deleting

  - by Carl Bergquist

  I want to see how many rows my delete query effects so I know its correct. Is this possible using pgadmin?

  Read the article

• Simple ASP.NET Database Query

  - by Steven

  I have loaded my database with one table under "Data Connections" in the "Server Explorer" pane. What is the standard / best-practices way to handle a simple query in a VB ASPX page? My left <div> would be a set of form elements to filter rows, and when the button is clicked, the main <div> would show the columns I want for the rows returned. Note: Answers in C# are okay too, I'll just translate.

  Read the article

< Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >