Search Results

Search found 25852 results on 1035 pages for 'linq query syntax'.

Page 742/1035 | < Previous Page | 738 739 740 741 742 743 744 745 746 747 748 749  | Next Page >

• SQL Count in View as column

  - by alex

  I'm trying to get the result of a COUNT as a column in my view. Please see the below query for a demo of the kind of thing I want (this is just for demo purposes) SELECT ProductID, Name, Description, Price, (SELECT COUNT(*) FROM ord WHERE ord.ProductID = prod.ProductID) AS TotalNumberOfOrders FROM tblProducts prod LEFT JOIN tblOrders ord ON prod.ProductID = ord.ProductID This obviously isn't working... but I was wondering what the correct way of doing this would be?

  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

• Ip address to country with database

  - by newbie

  I have downloaded ip-to-country.csv that has ip ranges that are mapped to countries. How should I store this data to database and how can I query in what range Ip address is to know where Ip address is coming from?

  Read the article

• Recommended way to perform Lucene search without limit

  - by Thomas

  The Lucene documents tell me that "Hits" will be removed from the API in Lucene 3.0. Deprecated. Hits will be removed in Lucene 3.0. Use search(Query, Filter, int) instead. The proposed overload limits the number of documents returned to the value of the int. So my question is: what is the recommended way to perform a search in Lucene with no limit on the number of documents to be returned?

  Read the article

• Using GROUP BY to fetch rows from SQLiteDatabase and then render them using SimpleCursorAdapter

  - by jgauffin

  I want to display total amount of seconds that was spent each day on a project. I want to use SQLiteDatabase to fetch rows using the query below and then use SimpleCursorAdapter to fill a ListView. SELECT projectId, date, sum(endedAt-startedAt) as hours FROM project_reports WHERE startedAt >= 1270098000 AND endedAt <= 1272776399 GROUP BY date, projectId

  Read the article

• Thinking-sphinx and relevance or similarity score

  - by Sohan

  Does someone know if there is a way to get the raw relevance or similarity score between a query and a result when using sphinx in general or thinking-sphinx as a wrapper? Any help is greatly appreciated.

  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

• Rollback SQL Server 2012 Sequence

  - by VAAA

  I have a SQL Server 2012 Sequence object: /****** Create Sequence Object ******/ CREATE SEQUENCE TestSeq START WITH 1 INCREMENT BY 1; I have a SP that runs some queries inside a transaction: BEGIN TRAN SELECT NEXT VALUE FOR dbo.TestSeq <here all the query update code......> ROLLBACK TRAN If the transaction fails all the updates are rolledback without problem but the Sequence is not rolled back I guess because Its out of the scope of the transaction. Any clue on way to handle that? Thanks

  Read the article

• MySQL subqueries

  - by swamprunner7

  Can we do this query without subqueries? SELECT login, post_n, (SELECT SUM(vote) FROM votes WHERE votes.post_n=posts.post_n)AS votes, (SELECT COUNT(comments.post_n) FROM comments WHERE comments.post_n=posts.post_n)AS comments_count FROM users, posts WHERE posts.id=users.id AND (visibility=2 OR visibility=3) ORDER BY date DESC LIMIT 0, 15 tables: Users: id, login Posts: post_n, id, visibility Votes: post_n, vote id — it`s user id, Users the main table.

  Read the article

• SQL: Select distinct values from 1 column

  - by Parm

  I want to select distinct values from only one column (the BoekingPlaatsId column) with this query: SELECT MAX(BoekingPlaatsId), BewonerId, Naam, VoorNaam FROM table GROUP BY BewonerId, Naam, VoorNaam How do I do that in SQL Server?

  Read the article

• Question regarding MySQL indices and their functionality

  - by user281434

  Hi Say I have an ordinary table in my db like so ---------------------------- | id | username | password | ---------------------------- | 24 | blah | blah | ---------------------------- A primary key is assigned to the id column. Now when I run a Mysql query like this: SELECT id FROM table WHERE username = 'blah' LIMIT 1 Does that primary key index even help? If I am telling it to match usernames, then shouldn't the username column be indexed instead? Thanks for your time

  Read the article

• What's a good PHP Active Record library?

  - by Luca Matteis

  I've been using CodeIgniter for some quite time, and I've been extremely happy with its Active Record stuff. It's great to query the database with it. Recently I've started a new project and I can't use such a framework anymore. Is there a simple PHP Active Record library that does its job and gets out of the way (similar to CodeIgniter's version)?

  Read the article

• mysql custom sorting first alpha then numeric using case when

  - by Nizzy

  How can you sort a query using ORDER BY CASE WHEN REGEXP? or other alternatives? I don't want to use UNION. Thank you mysql> SELECT `floor_id`, `floor_number` FROM `floors`; +----------+--------------+ | floor_id | floor_number | +----------+--------------+ | 1 | 4 | | 2 | 7 | | 3 | G | | 4 | 19 | | 5 | B | | 6 | 3 | | 7 | A | +----------+--------------+ Expected result: +----------+--------------+ | floor_id | floor_number | +----------+--------------+ | 7 | A | | 5 | B | | 3 | G | | 6 | 3 | | 1 | 4 | | 2 | 7 | | 4 | 19 | +----------+--------------+

  Read the article

• How to order by column with null values last in entity framework

  - by devlife

  Does anyone know how to return an ordered list of strings with null values last? I have something like this: using(var context = new DomainEntities()) { var result = context.Users.OrderBy(u = u.LastName).ThenBy(u = u.FirstName); } My problem though is that this query returns null values before non-null values. Any thoughts?

  Read the article

• security when using MyModel.objects.get(name=some_var) in Django

  - by pablo

  Hi, Is it safe to query with object.get without escaping or validation user submitted value? For example: some_var = request.POST.get('some_key') obj = MyModel.objects.get(name=some_var) Can the user submit malicious data? Thanks

  Read the article

• how can i loop through all of the columns of the OracleDataReader

  - by ooo

  I have the following code and i want to loop through all the fields in the result of this query and populate the dictionary called field. Given a datareader is this possible? OracleCommand command = connection.CreateCommand(); string sql = "Select * from MYTABLE where ID = " + id; command.CommandText = sql; Dictionary<string, string> fields = new Dictionary<string, string>(); OracleDataReader reader = command.ExecuteReader();

  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

• Self Authenticating Links in Django

  - by awolf

  In my web app I would like to be able to email self-authenticating links to users. These links will contain a unique token (uuid). When they click the link the token being present in the query string will be enough to authenticate them and they won't have to enter their username and password. What's the best way to do this?

  Read the article

• selecting when an aggregate column has two or more items

  - by blockhead

  Let's say I had a query like this: SELECT * FROM ( SELECT 'a' AS a, '1' AS b UNION SELECT 'a' AS a, '2' AS b UNION SELECT 'b' AS a, '1' AS b) AS a GROUP BY a.a In this case "a".b is an aggregate of 1,2 while "b".b is only an aggregate of 1. How can I select only "a"?

  Read the article

• 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

• jquery hide certain form elements untill a certain textfield has been populated?

  - by Rubytastic

  I have a long signup form and would like to hide a few fields and only show them when a certain input field is populated with text, if the user types some text in this field the other form fields will show. I have looked at hide and show divs but have some trouble getting form elements hide and show them on a certain trigger ( populating a form with text ) anyone can point me in the right direction on how to implement such feature in query ? thx in advanche!

  Read the article

• MySQL: Is it possible to compute MAX( AVG (field) )?

  - by Brad

  My current query reads: SELECT entry_id, user_id, cat_id, AVG( rating ) as avg_rate FROM entry_rate WHERE 1 GROUP BY entry_id cat_id relates to different categories: 1, 2, 3 or 4 Is there a way I can find the maximum average for each user in each category without setting up an additional table? The return could potentially be 4 maximum avg_rate for each user_id Visit the link below for example: http://lh5.ggpht.com/_rvDQuhTddnc/S8Os_77qR9I/AAAAAAAAA2M/IPmzNeYjfCA/s800/table1.jpg

  Read the article

• Jquery .getScript getting the redirect url of javascript

  - by user177883

  I d like to execute a remote javascript which redirects the user to another page on my domain with data that s passes as query string. I want to get this data which is passed on to the page on my domain. $.getScript('http://site.com/foo.js', function() { **//foo.js redirects to another page on my domain with data // and i d like to capture that data from this function, // at least if i find the parameters that passed on there, i ll be fine.** }); What to do ?

  Read the article

• Database structure, optimizing table with lots of rows

  - by aepheus

  I have a table with a lot of rows. The structure is something like this: UserID | ItemID | Item Data... Would I see any gains in query time if I separated this into a table per user, or per smaller group of users? Queries are always single user getting/modifying a selection of items.

  Read the article

• MySql Join using 4 tables

  - by Ionut Flavius Pogacian

  I have 4 tables and i want to join them and extarct 4 values. I wrote the followig MySql Query, but it does not work. select `a`.`id`,`a`.`page` xpage,`a`.`action`, `b`.`header` xheader, `b`.`page_id`, `c`.`content` xcontent,`b`.`page_id`, `d`.`footer` xfooter,`d`.`page_id` join `header` b on `a`.`id`=`b`.`page_id` join `content` c on `a`.`id`=`c`.`page_id` and `a`.`id`=`d`.`page_id` join `footer` d on `a`.`id`=`d`.`page_id` where `a`.`page`='main'

  Read the article

< Previous Page | 738 739 740 741 742 743 744 745 746 747 748 749  | Next Page >