Search Results

Search found 49435 results on 1978 pages for 'query string'.

Page 279/1978 | < Previous Page | 275 276 277 278 279 280 281 282 283 284 285 286  | Next Page >

• Add elements to XDocument after LINQ Query

  - by Jon

  I have the following XML LINQ query from my XDocument. var totals = (from x in MyDocument.Descendants("TOTALS") select x).FirstOrDefault(); Once I have found my totals node I need to add some elements to that node and push that change to the XDocument.

  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

• HQL Insert Query in Grails

  - by WaZ

  I want to write an insert query in Grails. I have tried all possible combinations but cant get the syntax correct. Can anybody please help? class Person { int age int name } i tried the following: Person.executeUpdate("insert into Person values (20,30)") p.s.:Please do not mention using save()

  Read the article

• MySQL query to order by parent then child places

  - by Swanny

  I have a table of pages in my database, each page can have a parent as below: id parent_id title 1 0 Home 2 0 Sitemap 3 0 Products 4 3 Product 1 5 3 Product 2 6 4 Product 1 Review Page What would be the best MySQL query to select all pages ordered by parent then child then child again if there is more than one level, there will be a maximum of three levels. The above example would produce the desired order: Home Sitemap Products Product 1 Product 1 Review Page Product 2

  Read the article

• Appropriate C# command for ADO.NET SQlite when implementing COUNT() query

  - by Soham

  Hi All, Consider this command, as written here: Command.CommandText = "SELECT COUNT(ASSET) AS POSEXISTS FROM POSITIONS WHERE ASSET = @ASSET"; Command.Parameters.Add("@ASSET",DbType.String).Value = Symbol; So here, how should I execute this query so that, I can receive the POSEXISTS variable in the C# environment. Soham

  Read the article

• Help with a t-sql query

  - by user324650

  Hi Based on the following table Path ---------------------- area1 area1\area2 area1\area2\area3 area1\area2\area3\area4 area1\area2\area5 area1\area2\area6 area1\area7 Input to my stored procedure is areapath and no.of children (indicates the depth that needs to considered from the input areapath) areapath=area1 children=2 Above should give Path ----------- area1 area1\area2 area1\area2\area3 area1\area2\area5 area1\area2\area6 area1\area7 similary for areapath=area2 and children=1 output should be Path --------------- area1\area2 area1\area2\area3 area1\area2\area5 area1\area2\area6 I am confused how to write a query for this one.

  Read the article

• Mysql Query problem ?

  - by deep

  ID NAME AMT 1 Name1 1000 2 Name2 500 3 Name3 3000 4 Name1 5000 5 Name2 2000 6 Name1 3000 consider above table as sample. am having a problem in my sql query, Am using like this. Select name,amt from sample where amt between 1000 and 5000 it returns all the values in the table between 1000 and 5000, instead I want to get maximum amount record for each name i.e., 3 name3 3000 4 name1 5000 5 name2 2000

  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

• Optimization t-sql query

  - by phenevo

  Hi, I'm newbie in t-sql, and I wonder why this query executes so long ? Is there any way to optimize this ?? update aggregateflags set value=@value where objecttype=@objecttype and objectcode=@objectcode and storagetype=@storagetype and value != 2 and type=@type IF @@ROWCOUNT=0 Select * from aggregateflags where objecttype=@objecttype and objectcode=@objectcode and storagetype=@storagetype and value = 2 and type=@type IF @@ROWCOUNT=0 insert into aggregateflags (objectcode,objecttype,value,type,storagetype) select @objectcode,@objecttype,@value,@type,@storagetype @value int @storagetype int @type int @objectcode nvarchar(100) @objecttype int There is not foreign key.

  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

• 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

• Cleansing string / input in Coldfusion 9

  - by Jakub

  I have been working with Coldfusion 9 lately (background in PHP primarily) and I am scratching my head trying to figure out how to 'clean/sanitize' input / string that is user submitted. I want to make it HTMLSAFE, eliminate any javascript, or SQL query injection, the usual. I am hoping I've overlooked some kind of function that already comes with CF9. Can someone point me in the proper direction?

  Read the article

• LInq to sql query

  - by Mohit

  Hi, I have a sql query as follows: Declare @DivisionNo INT SET @DivisionNo = 5117 SELECT distinct CASE WHEN ISNULL([DivisionNo],'') < @DivisionNo THEN @DivisionNo ELSE [DivisionNo] END as DivisionNo --,[RecordID] ,[AcctCat] ,[AcctCatDesc] ,[CostCode] ,[CostCodeDesc] FROM [dbo].[vw_eSchdl_AcctCat_CostCode] WHERE DivisionNo = @DivisionNo UNION SELECT distinct CASE WHEN ISNULL([DivisionNo],'') < @DivisionNo THEN @DivisionNo ELSE [DivisionNo] END as DivisionNo --,[RecordID] ,[AcctCat] ,[AcctCatDesc] ,[CostCode] ,[CostCodeDesc] FROM [dbo].[vw_eSchdl_AcctCat_CostCode] WHERE AcctCat not in ( SELECT [AcctCat] FROM [dbo].[vw_eSchdl_AcctCat_CostCode] WHERE DivisionNo = @DivisionNo) How can I duplicate it using linq to sql? Thanks

  Read the article

• SQL Query with conditional JOIN

  - by mariki

  The scenario: Table1 CatId|Name|Description Table2 ItId|Title|Date|CatId (foreign key) I want to return all rows from Table1 and Title,Date from Table2, where The returned from Table 2 must be the Latest one by the date column. (in second table there many items with same CatId and I need just the latest) I have 2 queries but can't merge them together: Query 1: SELECT Table1.Name, Table1.Description, Table2.Title, Table2.Date FROM Table1 LEFT JOIN Table2 ON Table1.CatId=Table2.CatId Query2: SELECT TOP 1 Table2.Title, Table2.Date FROM Table2 WHERE Table2.CatId = @inputParam ORDER BY Table2.Date DESC

  Read the article

• Oracle query to select rows with unique code

  - by Jasim

  I have a table like this C1 C2 C3 Code 1 2 3 33 1 2 3 34 2 4 1 14 1 2 3 14 i want to select only those record whose code is appearing only in single row. ie, in this case rows with code 33 and 34.. as they appear only once in this table. How can i write a query for that

  Read the article

• Avoid duplication of values in a SELECT query in PostgreSQL

  - by Shyam Solanki

  I have a table named product which contains two columns: id name 1 p1 2 p2 3 p1 4 p3 5 p4 I run the following query: SELECT DISTINCT id, name FROM product; As a result, PostgreSQL gives me the following output: id name 1 p1 2 p2 3 p1 4 p3 5 p4 I want to avoid duplication of values in the name field, so the desired output should look like this: 1 p1 2 p2 4 p3 5 p4 How should I go about achieving this?

  Read the article

• Query a List of List of Items in LINQ c#

  - by call me Steve

  I am a bit new to LINQ, here is my problem. I have a List of List of Items I like to get the Items which are present in only one List (and if I could get the List in which they are without re-iterating through the "list of list" that would be great). I am trying without success to use the Aggregate / Except / Group keywords in the Linq query but nothing close to a solution so far.

  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

• 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

• 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

• 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

• C++ using cdb_read returns extra characters on some reads

  - by Moe Be

  Hi All, I am using the following function to loop through a couple of open CDB hash tables. Sometimes the value for a given key is returned along with an additional character (specifically a CTRL-P (a DLE character/0x16/0o020)). I have checked the cdb key/value pairs with a couple of different utilities and none of them show any additional characters appended to the values. I get the character if I use cdb_read() or cdb_getdata() (the commented out code below). If I had to guess I would say I am doing something wrong with the buffer I create to get the result from the cdb functions. Any advice or assistance is greatly appreciated. char* HashReducer::getValueFromDb(const string &id, vector <struct cdb *> &myHashFiles) { unsigned char hex_value[BUFSIZ]; size_t hex_len; //construct a real hex (not ascii-hex) value to use for database lookups atoh(id,hex_value,&hex_len); char *value = NULL; vector <struct cdb *>::iterator my_iter = myHashFiles.begin(); vector <struct cdb *>::iterator my_end = myHashFiles.end(); try { //while there are more databases to search and we have not found a match for(; my_iter != my_end && !value ; my_iter++) { //cerr << "\n looking for this MD5:" << id << " hex(" << hex_value << ") \n"; if (cdb_find(*my_iter, hex_value, hex_len)){ //cerr << "\n\nI found the key " << id << " and it is " << cdb_datalen(*my_iter) << " long\n\n"; value = (char *)malloc(cdb_datalen(*my_iter)); cdb_read(*my_iter,value,cdb_datalen(*my_iter),cdb_datapos(*my_iter)); //value = (char *)cdb_getdata(*my_iter); //cerr << "\n\nThe value is:" << value << " len is:" << strlen(value)<< "\n\n"; }; } } catch (...){} return value; }

  Read the article

• Using sqlalchemy to query using multiple column where in clause

  - by crunkchitis

  I'm looking to execute this query using sqlalchemy. SELECT name, age, favorite_color, favorite_food FROM kindergarten_classroom WHERE (favorite_color, favorite_food) IN (('lavender','lentil soup'),('black','carrot juice')); I only want kids that like (lavender AND lentil soup) OR (black and carrot juice). This is similar, but doesn't get me all of the way there: Sqlalchemy in clause

  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

< Previous Page | 275 276 277 278 279 280 281 282 283 284 285 286  | Next Page >