Search Results

Search found 21942 results on 878 pages for 'named query'.

Page 596/878 | < Previous Page | 592 593 594 595 596 597 598 599 600 601 602 603  | Next Page >

• How can I implement String.Concat(object, object) to L2E framework?

  - by Eran Betzalel

  I have two long type columns that I want to concat during sql query. Using Linq to Entities making it impossible, because it only supports String.Concat(string, string). I'd like to know how can I implement this function myself and add it to the L2E framework.

  Read the article

• how to remove hazardous character in php

  - by Ajay

  Hi All, I have to remove hazardous chracter from my query post string. Is there any function define in php to remove directly or another way ?

  Read the article

• MySQL How to select friends from a friendship table?

  - by Thomas Puthoor

  Hi I have a simple database for storing friendship, with just two columns person_a, person_b , denoting that person_a and person_b are friends. From a big list like this what query should I run to get say get all friends of 'sam'. Thank you.

  Read the article

• morethan one between clause

  - by tismon

  hi how can i use more than one 'between' clause in mysql query ? like if i want to select students having height between 20 and 25 and weight between 50 and 70.. thanks in advance tismon

  Read the article

• Sharepoint 2007: How to define the content type of a listitem using webservices

  - by AnnVB

  I'm create a list item via ASP.Net to be published automatically on Sharepoint. However, I cannot find how to define the content type via the CAML query.

  Read the article

• Is there any sql interpreter for objects?

  - by Behrooz

  Is there any interpreter that takes a string or even a custom object as input and execute it on my datasource? I cannot use linq to object because query always changes and the report i'm working on, has about 6000 queries which i can reduce to 9 if i find some tool doing that for me. Opensource is very applicable. thanks in advance.

  Read the article

• SELECT table name that is inside UNION

  - by LexRema

  I have two same tables. I need to union them in such way: SELECT f1,f2, xxx FROM (SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2) where xxx would query for a table name, where f1 and f2 fields are taken from. Example output: 123 345 'tbl1' -- this rows are from the first table 121 345 'tbl1' 121 345 'tbl1' 123 345 'tbl1' 124 345 'tbl1' 125 345 'tbl2' -- this rows are from the second table 127 345 'tbl2' Thank you in advance.

  Read the article

• Select 5, 10, 15, 20 and so on with LINQ

  - by Johan Leino

  Hey guys, I want to display items in a dropdownlist like 5%, 10%, 15%, 20% until 100. Is there a way to bind an intelligent LINQ query to the datasource that will do this for me?

  Read the article

• ado.net-data-services filer using composite

  - by Thurein

  Hi, I am having a problem filter a query. I have Contact and Tag entities. Actually in the database, they are 3 different tables, Contacts, Tags and ContactTag table. I would like to filter contacts using the Tag name. I was trying this filter but it did not work. http://localhost:50143/ContactDataService.svc/Contacts?$filter=Tags/TagName eq 'Tag1' Am I missing any thing ? Thanks Thurein

  Read the article

• hibernate restrictions.in with and, how to use?

  - by cometta

  I have table like below id, employee_no, survey_no, name 1 test 1 test_name 2 test2 1 test_name2 3 test3 1 test_name3 4 test4 2 test_name4 how to query with Restriction.in by combining below AND into one IN statement? IN[ (if(survey_no==1) && employee_no== 'test') , (if(survey_no==1) && employee_no== 'test2') , ... ]

  Read the article

• How to change querydef sql programmatically in MS Access

  - by asksuperuser

  I have done Dim qd as querydef set qd = Querydefs("MyQuery") set qd.sql = "..." In debug qd.sql has been updated but the physical MyQuery still contains the old sql. How to update this physical query ?

  Read the article

• NHibernate join and projection properties

  - by devgroup

  Hello, I have simple situation (like on the image link text) and simple SQL query SELECT M.Name, A.Name, B.Name FROM Master M LEFT JOIN DetailA A ON M.DescA = A.Id LEFT JOIN DetailB B ON M.DescB = B.Id How to achive the same effect in nHibernate using CriteriaAPI ?

  Read the article

• Oracle equaivalent of java System.currentTimeMillis()?

  - by Gaurav

  Hi, I want to be able to store the current time in millis in an oracle number field. How do I do this via a query? select systimestamp from dual; returns the actual timestamp. Is there anyway that I can convert this into milliseconds the same way java's System.currentTimeMillis() does?

  Read the article

• Problem with libxml2 and Unicode char in XML Soap with Qotes (") and &amp;quot;

  - by x2on

  I'm using libxml2 for SOAP-Actions in an iPhone App. The big problem is that i want send an SQL-Statement with NSString *query = @"SELECT test FROM database WHERE test = \"string\"" But libxml2 converts the qotes " into &amp;quot; Any ideas how to prevent this?

  Read the article

• An Alternative to Views?

  - by Abs

  Hello all, I am just reading this article and I came across this: Filter: Remove any functions in the WHERE clause, don't include views in your Transact-SQL code, may need additional indexes. If I do not use views, what are the alternatives? I mean, in my situation, I want to select some data from a table and then use a few other select queries to work on the subset of data from the first select query? How can I do this efficiently? Thanks all

  Read the article

• How to transfer json data to html with php?

  - by cj333

  How to transfer json data to html with php? $url="http://api.nytimes.com/svc/search/v1/article?format=json&query=usa&rank=newest&api-key=mykey" when I type the url in browser, it return {"offset" : "0" , "results" : [{"body" : "A guide to cultural and recreational goings-on in and around the Hudson Valley. ...}]} how to put the json body data into html? I mean like this echo '<div class="body"></div>';

  Read the article

• url.rewrite-once with Kohana and with urls

  - by mike clagg

  currently I have this setup in our simple-hosts.conf: url.rewrite-once = ( ".*.(js|ico|gif|jpg|png|css|php|htm)(?.*)?$" = "$0", "/slapi" = "/slapi/index.php" ) Works great, except the above fails when I have a dot in the query string: ?url=http://google.com My regexpy is not 1337

  Read the article

• How can you tell which columns are unused in ALL_TAB_COLS?

  - by thecoop

  When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can filter them out of ALL_TAB_COLS?

  Read the article

• What is LINQ? How can I use this with PHP?

  - by Ygam

  Language Integrated Query. Now I know that the acronyms are. I have seen C# examples, but can't really understand them. Can I use them with PHP? Can I use it along with ORM? Has any PHP MVC framework has this?

  Read the article

• How do I use cvs to compare two points in time on a branch?

  - by andrewducker

  I can use something like: cvs.exe rdiff -D2010-03-23 -D2010-03-24 -s "ProjectName" to get the changes which occurred on the 23rd. But I want to get the changes that were checked in on the 23rd on a specified branch - and if I add in a -v branchv1-0-0-0 into that it tells me I can't have more than two dates/revisions in one query. Any suggestions?

  Read the article

• Problems with MySQL OR clause

  - by Simon

  I have a problem with AND and OR clause in SQL. Here is my query: SELECT `act1`.`name`, `act1`.`surname`, `act2`.`name`, `act2`.`surname`, `act3`.`name`, `act3`.`surname` FROM `videos`, `actors` AS act1, `actors` AS act2, `actors` AS act3 WHERE `videos`.`ident` = 'somethink' AND ( `act1`.`id` = `videos`.`id_actor1` OR `act2`.`id` = `videos`.`id_actor2` OR `act3`.`id` = `videos`.`id_actor3` ) It returns me all variations of {name, surname}, but I want the name and surname of first exactly, second and thirth, if they exist.

  Read the article

• MySQL: How to check if a string is a valid DATE, TIME or DATETIME

  - by Svish

  When I try to put a value into a DATE field which is invalid, MySQL seems to use 0000-00-00 instead. Is there a way I can do this "check" without updating a DATE field? And to do it from for example PHP? Like, is there a way I can query the MySQL server and ask "Hey, is this DATE, TIME or DATETIME valid to you?" Or is there maybe an even better way of doing it?

  Read the article

• JPA: How do I get a scalar result of type Long-- not BigNumber-- from Oracle NUMBER?

  - by rektide

  The default mapping from an Oracle NUMBER value is into BigNumber... How can I get a scalar result query to return a Long instead?

  Read the article

• How to access values of previous page at client-side?

  - by Gaurav

  I have a page and clicked on the button there it will open a new page containing some text boxes, user fill all the text boxes and clicked the button now first page open again and the question is : How can I get the vales of text boxes on the current page using both server-side and client-side There is a restrictions to use of : - Cross-paging - Cookies - Sessions - Query strings

  Read the article

• Crystal Report displaying Group Header multiple times

  - by Ravi Gupta

  Hi I am using Crystal Reports 10 to generate my reports. In one of the reports I see that a group header is getting repeated 2 times in the output document while in the design tab I can that it is present only one time. I am having my query as a "Union All" of 2 data sets. Please advise what could be the cause. Thanks.

  Read the article

< Previous Page | 592 593 594 595 596 597 598 599 600 601 602 603  | Next Page >