Search Results

Search found 33538 results on 1342 pages for 'select query'.

Page 235/1342 | < Previous Page | 231 232 233 234 235 236 237 238 239 240 241 242  | Next Page >

• Like query ing LINQ to Object

  - by Pankaj

  Hello All i have a US states list List<string> state // contain all 51 US states Now i have a string which contain some text like okl (it means Oklahoma for me). what i want i want 'like' query in List state and get Oklahoma state.

  Read the article

• how i group do this mysql query

  - by moustafa

  i want to make charts system and i think it must be like that 1 jan 2009 = 10 post 2 jan 2009 = 2 post 4 jan 2009 = 10 post 6 jan 2009 = 60 post and i have posts table that has id,user_id,date how i can select from posts to show it like that

  Read the article

• Error: operation must use an updateable query

  - by Indranil Mutsuddy

  halo, After making the set up of the application(developed using VS 2008 and MS Access) the installation another system works fine. But whenever I try to change the Password or id it shows an error sayin "operation must use an updateable query" Thank you, Indranil

  Read the article

• Total of float column in linq query

  - by Krummelz

  I have a linq query, that gets data from a table in a DataContext object. One of the columns in this table has a Datatype of float. I would like to get the total of that specific column. How could I go about doing this?

  Read the article

• SQL Server Query

  - by Scott Jackson

  Hi, I'm trying to do some work with my SQL table. I have 2 buildings with room numbers 1 - 100 in building 1 and 101 - 199 in building 2. I have a location field (which I've just created) and want to run a query to populate it with either 'Building 1' or 'Building 2' depending on which room number it has in the 'Room' field. Many thanks for your help. Regards Scott

  Read the article

• How do I optimize this query?

  - by InnateDev

  SELECT DISTINCT wposts.* FROM wp_2_posts wposts, wp_2_postmeta wpostmeta, wp_2_postmeta wpostmeta1, wp_2_term_taxonomy, wp_2_terms, wp_2_term_relationships WHERE wposts.ID = wpostmeta.post_id AND wp_2_terms.term_id = '8' AND wp_2_term_taxonomy.term_id = wp_2_terms.term_id AND wp_2_term_taxonomy.term_taxonomy_id = wp_2_term_relationships.term_taxonomy_id AND wp_2_term_relationships.object_id = wposts.ID AND wpostmeta.meta_key = 'validity' AND wpostmeta.meta_value > '".$logic_date."' AND wpostmeta1.meta_key != 'permanent' AND wposts.post_status = 'publish' AND wposts.post_type = 'post' ORDER BY wposts.post_date DESC

  Read the article

• microsoft.office.server.search.query not found

  - by Lalit

  I have added reference to my application of Microsoft.Office.Server as well as Microsoft.Sharepoint . but while importing the namespace in program , there is no option like microsoft.office.server.search.query after microsoft.office.server.search. I am getting their Microsoft.Office.Server.Search.PortalCrawl;. Why this is?? please guide me.

  Read the article

• ado sql update table with result of group by query

  - by brett

  I am trying to update records in an .mdb table with the number of records containing the same value The sql below does not work but I think gives an indication of what I am trying to achieve. UPDATE table1 AS A INNER JOIN (SELECT PH_BSP , Count(PH_BSP) AS PHCOUNT FROM table1 GROUP BY PH_BSP) AS B ON A.PH_BSP=B.PH_BSP SET A.PH_SORT = B.PHCOUNT; any ideas?

  Read the article

• MySQL SUM Query daily values of a week problem

  - by davykiash

  Am trying to return the sum of each day of a week in mysql but it returns nothing despite having values for the 3rd Week of March 2010 SELECT SUM(expense_details_amount) AS total FROM expense_details WHERE YEAR(expense_details_date) = '2010' AND MONTH(expense_details_date) = '03' AND WEEK(expense_details_date) = '3' GROUP BY DAY(expense_details_date) How do I go about this?

  Read the article

• Query posts based on author id

  - by user338109

  I have the current author id stored in $theauthorid I want to do a query based on the author id so I do this query_posts('author=$theauthorid'); However it does not work unless I write the id manually. I know the id is stored correctly as I get the correct id when I echo it.

  Read the article

• Difference between Facebook query from iphone and from web

  - by Aashutosh

  Hi, I am creating a iphone application for the existing web application. The fql which is happening at the web is giving me right results but the fql happening at the iphone is not giving all the results. select name, pic_square, pic_big, uid, sex, birthday, relationship_status , current_location, meeting_sex, interests, music, tv, movies, books, quotes, education_history, work_history from user where uid = XXXXXXX is giving me different result in web when compared to the iphone. Thanks, Aashutosh

  Read the article

• SQL dynamic date but fixed time query

  - by Marko Lombardi

  I am trying to write a sql query like the example below, however, I need it to always choose the DateEntered field between the current day's date at 8:00am and the current day's date at 4:00pm. Not sure how to go about this. Can someone please help? SELECT OrderNumber , OrderRelease , HeatNumber , HeatSuffix , Operation , COUNT(Operation) AS [Pieces Out of Tolerance] FROM Alerts WHERE (Mill = 3) AND (DateEntered BETWEEN GetDate '08:00' AND GetDate '16:00') GROUP BY OrderNumber, OrderRelease, HeatNumber, HeatSuffix, Operation

  Read the article

• How to query the roster using JSJAC XMPP client

  - by araja

  How can I query full roster using JSJAC XMPP client? I have tried following function for this, but it does not work: function getRoster(con){ var roster = new JSJaCIQ(); roster.setIQ(null, 'get', 'roster_1'); roster.setQuery(NS_ROSTER); con.send(roster); }

  Read the article

• Delete query in Linq

  - by Ani

  I have this simple code but it shows error. I dont know where I am going wrong. I shows error in last line.."DeleteOnSubmit" linq_testDataContext db = new linq_testDataContext(); var remove = from aremove in db.logins where aremove.username == userNameString && aremove.Password == pwdString select aremove; db.logins.DeleteOnSubmit(remove); Thanks, Ani

  Read the article

• Rails routes matching query parameters

  - by Harry Wood

  Rails routes are great for matching RESTful style '/' separated bits of a URL, but can I match query parameters in a map.connect config. I want different controllers/actions to be invoked depending on the presence of a parameter after the '?'. I was trying something like this... map.connect "api/my/path?apple=:applecode", :controller = 'apples_controller', :action = 'my_action' map.connect "api/my/path?banana=:bananacode", :controller = 'bananas_controller', :action = 'my_action' For routing purposes I don't care about the value of the parameter, as long as it is available to the controller in the 'params' hash

  Read the article

• question with its query

  - by user329820

  Hi this is my homework and the question is this: List the average balance of customers by city and short zip code (the first five digits of thezip code). Only include customers residing in Washington State (‘WA’). also the Customer table has 5 columns(Name,Family,CustZip,CustCity,CustAVGBal) I wrote the query like below is this correct? SELECT CustCity,LEFT(CustZip,5) AS NewCustZip,CustAVGBal FROM Customer WHERE CustCity = 'WA' THANKS!!

  Read the article

• PHP GET number query

  - by Jordan

  Hi to all! I have a query that gets the name and an id. The results is like this : 54 - Rian Ree Barrientos I wanted to get the number 54. I used echo (int)$_GET['number']; But the result is "0". How can I get the number?

  Read the article

• SQL Query to get the table names which use a particular column as a foriegn key

  - by vinayvasyani

  What sql query would you write to get the table names which have a particular foriegn key. Eg. Person_Table(person_id,name,address,...) Purchases_Table(purchaseid, purchased_by_id(fkey)....) AccountDetails_Table(AccountId,PersonID,....) Roles_Table(PersonId,RoleID) Now i want to find the table names where Person id is used as a foreign key. The above schema would return me Purchases_Table,AccountDetails_Table, Roles_Table Database: SQL Server

  Read the article

• Elegant way of parsing (at the server side) the query constructed from the UI

  - by Vishal

  The UI looks like: Condition 1 (Checkbox) and/or (Radio buttons) Condtion 2 (Checkbox) and/or (Radio buttons) Condition 3 (Checkbox) and/or (Radio buttons) Condition 4 (Checkbox) I would like to parse (at the server-side) the query constructed from the client (for possible combinations). Any design ideas? PS: May be the UI can be designed better. Posts appreciated. Thanks

  Read the article

• please help me construct this MYSQL Query (date / time)

  - by sebb

  Hi there i would like to construct a query that fetches results that occurred between NOW and 15 minutes ago, im getting a mysql error when I try the following , can you help me? thanks SELECT * WHERE user_id = '000' AND date_time < now( ) AND date_time > DATE_SUB( now( ) , INTERVAL 15 MINUTE)

  Read the article

• Can I create a table with check constrain whose values are dependent on sql query

  - by Shantanu Gupta

  Is it possible to create a table which has a check constraint on one of the column whose value lies within the result set given by another sql query eg. create table tablename ( name varchar(10), rollno int )check rollno in (select rollno from anotherDatabase.TableName,candidateRoll) or any thing like that. I dont have to use it anywhere but still want to know.

  Read the article

• solr range query errors

  - by mquinsland

  http://localhost:8983/solr/select?wt=json&q=lat:[35%20to%2038] results in **org.apache.lucene.queryParser.ParseException: Cannot parse 'lat:[35 to 38]': Encountered " "38 "" at line 1, column 11. Was expecting: "]" This is a pretty basic range query and this error will prevent us from using SOLR for our projects

  Read the article

• Instantiate defined object with Linq Query

  - by Heinz

  I know that you can instantiate anonymous types with Linq but I am looking to instantiate an object I have already defined. Every time I do, all the properties are returned with their defaults (null, 0, etc.) Is there a way to make this work? I've tried something like this: ServiceDepartment[] serviceDepartments = (from d in departments orderby d.department_name select new ServiceDepartment { DepartmentID = d.department_id, DepartmentName = d.department_name }).ToArray();

  Read the article

• MySQL: How to add one day to datetime field in query

  - by phpBOY

  Hello, In my table I have a field named eventdate in datetime format like 2010-05-11 00:00:00. How do i make a query so that it adds one day to the eventdate eg if today is 2010-05-11, i want to show in where clause to return all records with tomorrow's date.

  Read the article

• Filter list as a parameter in a compiled query

  - by JK

  I have the following compiled query that I want to return a list of "groups" that don't have a "GroupID" that's contained in a filtered list: CompiledQuery.Compile(ConfigEntities contexty, List list) = from c in context.Groups where (!csList.Contains(c.GroupID)) select c).ToList() However I'm getting the following run-time error: The specified parameter 'categories' of type 'System.Collections.Generic.List`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c261364e126]]' is not valid. Only scalar parameters (such as Int32, Decimal, and Guid) are supported. Any ideas?

  Read the article

< Previous Page | 231 232 233 234 235 236 237 238 239 240 241 242  | Next Page >