Search Results

Search found 18542 results on 742 pages for 'nhibernate query'.

Page 191/742 | < Previous Page | 187 188 189 190 191 192 193 194 195 196 197 198  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• SQL Server - Query for retreiving value from user input

  - by John

  For Eg...if the User needs to retrieve the 10th highest mark in a "mark" column. The column may be in any order. I need Query for to get stud_name of 10th highest mark. Say for eg..table name is student columns are id, name, mark.

  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

• if-else equivalent via linq-to-sql query in where clause c#

  - by Darcy

  Hi guys, Basically I wanted to have an if-else statement in my linq to sql statement. var query = from d in database if(x == y) { where d.Attr = x } else { where d.Attr = y } select d; Any ideas?

  Read the article

• mysql count query

  - by S.PRATHIBA

  Hi all, i have the following table: mysql select * from consumer1; Service_ID | Service_Type | consumer_feedback 31 Printer -1 34 Printer 0 31 Printer 0 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 I need a query such that I need THE COUNT(Service_ID)=2 AS Service_ID is 31 and 34.Please help me and give me some suggestions.

  Read the article

• how to use conditional select query ? in sqlserver

  - by Arunachalam

  how to use conditional select query ? in sqlserver i have a column in which i store date type variable .now i should retrieve one value from that column and find the difference with the curent_timestamp and if the difference is less than 10 mins i should a return 1 and if more than 10 mins i should return 0.is it possible ? 05-12-2010 13.58.30 - 05-12-2010 13.56.30 here the difference is 2 so it should return 1 .

  Read the article

• Query String in javascript

  - by Ajith

  By using document.referrer we will get all the reference of url in javascript.ie,may be output like follows http://localhost/testwordpress/wp-admin/admin.php?page=thesis-options&upgraded=true.From this output how can we differentiate the query string part only ( ie,?page=thesis-options&upgraded=true).Is there any method in javacript?Please help anybody knows........

  Read the article

• content://sms/inbox query

  - by soclose

  Hi, I use Android 1.6. I'd like to query "content://sms/inbox". How to implement it?

  Read the article

• zend_db_select with a hexadecimal query parameter against a binary column

  - by Jack Tanner

  How do you represent this query as a Zend_Db_Select? select * from t where id = x'0cc175b9c0f1b6a831c399e269772661'; The database is MySQL, using either PDO or mysqli adapters.

  Read the article

• Basic join query understanding

  - by OM The Eternity

  I know this very silly, but can anybody help me in understanding what does this join query is doing in elabortive description? SELECT j1.* FROM jos_audittrail j1 LEFT OUTER JOIN jos_audittrail j2 ON (j1.trackid = j2.trackid AND j1.field = j2.field AND j1.changedone < j2.changedone) WHERE j1.operation = 'UPDATE' AND j1.trackid=$t_ids[$n] AND j2.id IS NULL I know its very silly, but i need to go ahead with my further need... Pls do help me...

  Read the article

• How can "set timestamp" be a slow query?

  - by Peder

  My slow query log is full of entries like the following # Query_time: 1.016361 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1273826821; COMMIT; I guess the set timestamp command is issued by replication but I don't understand how set timestamp can take over a second. Any ideas?

  Read the article

• how to create a linq query using join and max

  - by geoff swartz

  I have 2 tables in my linq dbml. One is people with a uniqueid called peopleid and the other is a vertical with a foreign key for peopleid and a uniqueid called id. I need to create a type of linq query that does a left outer join on people and gets the latest record in the vertical table based off the max(id) column. Can anyone suggest what this should look like? Thanks.

  Read the article

• how to write query string for webrick?

  - by kshama

  Hi, My rails application requires few values to be specified in the text box. My web page contains few text boxes .How can i specify the values of these text boxes in the url as query string while using webrick?can any one help, am new to this. Thanks in advance.

  Read the article

< Previous Page | 187 188 189 190 191 192 193 194 195 196 197 198  | Next Page >