Search Results

Search found 19690 results on 788 pages for 'result partitioning'.

Page 377/788 | < Previous Page | 373 374 375 376 377 378 379 380 381 382 383 384  | Next Page >

• oracle query returns 4 duplicates of each row

  - by ajoe

  hello, I am Running a oracle query, it seems to work except that it returns 4 dupes of each result. here is the code: Select * from (Select a.*, rownum rnum From (SELECT NEW_USER.*, NEW_EHS_QUIZ_COMPLETE.datetime FROM NEW_USER, NEW_EHS_QUIZ_COMPLETE WHERE EXISTS(select * from NEW_EHS_QUIZ_COMPLETE where NEW_USER.id=NEW_EHS_QUIZ_COMPLETE.USER_ID) ORDER by last_name ASC ) a where rownum <= #pgtop# ) where rnum >= #pgbot# does anyone know why this isnt working properly? thanks in advance.

  Read the article

• Counting the instances of customers

  - by Mikae Combarado

  Say that I have a table with one column named CustomerId. The example of the instance of this table is : CustomerId 14 12 11 204 14 204 I want to write a query that counts the number of occurences of customer IDs. At the end, I would like to have a result like this : CustomerId NumberOfOccurences 14 2 12 1 11 1 204 2 14 1 I cannot think of a way to do this.

  Read the article

• &nbsp; displays a tiny line.

  - by Kyle Sevenoaks

  Hi, when I make &nbsp; in my site, it displays a tiny line, which can be hidden on some elements because I'm usually using them on CSS buttons, but I have an if statement that says if this show the result if not show a non breaking space. How do you reset the &nbsp; to display nothing? Thanks.

  Read the article

• mysql extra columns with same name from two tables

  - by salmane

  Table 1 has columns : entry_id user_id ... Table 2 has columns : entry_id user_id ... the user_id entry is not always the same so I would like to extract both of them so I can later on compare them in my script SELECT * FROM table1 as t1 INNER JOIN table2 as t2 on t1.entry_id=t2.entry_id WHERE t1.user_id='%s' I would like to extract t1.user_id and t2.user_id ...the problem is the result array has only user_id thank you

  Read the article

• What should be DefaultLocation property of VS2010 setup to install application in C:\Users\[username

  - by Michael

  I have to install windows service using Visual Studio. Target location for the install is handled by “DefaultLocation” property in Visual Studio setup project. I had used [AppDataFolder] tag to install the application. As the result, it has been installed in “C:\Users[username]\AppData*Roaming*” folder. I can not figure out how to modify “DefaultLocation” property in such a way that application will be installed in C:\Users[username]\AppData*Local* folder. Any idea how to accomplish that?

  Read the article

• remove the content in directory and subdirectory hierarichally with out distroy the directory structure

  - by user3713876

  In shell script, I want to clear only text files and log files in the following structure with out removing the directory as well as subdirectories | |------bar/ | |---file1.txt |---file2.txt | |---subdir1/ | |---file1.log | |---file2.log | |---subdir2/ |---image1.log |---image2.log I am using rm -rf /bar/* so I am getting the result as follows. |------bar/ but I want the output like following | |------bar/ | | | | |---subdir1/ | | | |---subdir2/ I want to remove only text files or log files or csv with out removing the directory and the subdirectories

  Read the article

• How to Count tickets as DateWise

  - by user560716

  I have a query regarding my report, the report format is as under **Date** **Received** **Closed** **Pending** 12/01/10 1000 900 100 12/02/10 2000 1000 1000 12/03/10 1500 1300 200 The above report shows the Help Desk tickets Received, Closed, Pending Count as date wise. How can I create a dynamic SQL query to show above result? Received Tickets is calculated on SubmitedDate Closed Tickets is calculated on ClosedDate with status "Closed" same for Pending Tickets whose status is "Pending". Please provide me the idea or some sample SQL queries.

  Read the article

• C# Reading a file and writing out replacing string

  - by Mike

  What I have is a C# windows app that reads a bunch of SQL tables and creates a bunch of queries based on the results. What I'm having a small issue with is the final "," on my query This is what I have ColumnX, from I need to read the entire file, write out exactly what is in the file and just replace the last , before the from with nothing. I tried .replace(@",\n\nfrom),(@"\n\nfrom) but it's not finding it. Any help is appreciated. Example: ColumnX, from Result: ColumnX from

  Read the article

• conditions on count in a select

  - by Luca Romagnoli

  Hi, i have a table like this: Table(MissioneID, Type) Type can be 1,2 or 3 i have to count missions by type value: ex. if table's content is: MissioneID Type 1,1 1,2 1,1 2,3 1,2 The result of query is MissioneID,Count1,Count2,Count3 1, 2,2,0 2,0,0,1 How can i do? thanks

  Read the article

• Using jQuery, how do you mimic the form serialization for a select with multiple options selected in

  - by CarolinaJay65

  Below is my $.ajax call, how do I put a selects (multiple) selected values in the data section? $.ajax({ type: "post", url: "http://myServer" , dataType: "text", data: { 'service' : 'myService', 'program' : 'myProgram', 'start' : start, 'end' : end , }, success: function(request) { result.innerHTML = request ; } // End success }); // End ajax method EDIT I should have included that I understand how to loop through the selects selected options with this code: $('#userid option').each(function(i) { if (this.selected == true) { but how do I fit that into my data: section?

  Read the article

• Servlet as Proxy via https

  - by khiem77

  Hi i tried to implement a servlet with servlet (in tomcat 6) which act as as a proxy (for browser), it takes the parsed url, use apache httpclient to get the result & push it back to the client (browser), with http it works well, doesnt work with https , seems the problem concerns unsupported CONNECT method in servlet-api & servlet even doesn't see the request is there any solution/workaround for this? thanx in advanced

  Read the article

• SharpDX Not Implemented Exception

  - by clamp

  What could be the reason I am getting a SharpDX NotImplemented Exception? SharpDX.SharpDXException: HRESULT: [0x80004001], Module: [General], ApiCode: [E_NOTIMPL/Not implemented], Message: Not implemented at SharpDX.Result.CheckError() at SharpDX.MediaFoundation.MediaFactory.Startup(Int32 version, Int32 dwFlags) at SharpDX.MediaFoundation.MediaManager.Startup(Boolean useLightVersion) this is on windows 8 desktop. the same code runs fine on windows 7.

  Read the article

• What will be the return status in the following sheel script.

  - by Pradip Bhojania

  i have two shell scripts: script1.sh echo "date : DATE" exit 0; script2.sh ./scripts1.sh if [ $? -eq 0 ]; then reboot; else echo "Failed" fi What should be the result. Ideally it should have been "reboot" , however on some execution i got the "failed" message too. Can anyone explain why this happens?

  Read the article

• How to understand such C macro expansion

  - by upton

  A macro definition: #define HTTP_ERRNO_MAP(XX) \ /* No error */ \ XX(OK, "success") \ \ /* Callback-related errors */ \ XX(CB_message_begin, "the on_message_begin callback failed") \ XX(CB_url, "the on_url callback failed") \ /* Define HPE_* values for each errno value above */ #define HTTP_ERRNO_GEN(n, s) HPE_##n, enum http_errno { HTTP_ERRNO_MAP(HTTP_ERRNO_GEN) }; #undef HTTP_ERRNO_GEN After expand it by "gcc -E", enum http_errno { HPE_OK, HPE_CB_message_begin, HPE_CB_url,}; How does the macro expand to the result?

  Read the article

• How to select with Linq to Entity from one table with two different variables?

  - by George

  I have a table where I have items under two different types as you can see below: How can I select from this table with Linq to Entity to get the result with two variables? where ItemType = Type1 and ItemType == Type2 .... select new {typeOne == "", typeTwo == ""}; ID ItemName ItemType 1 ItemOne Type1 2 ItemTwo Type1 3 ItemThree Type1 4 ItemFour Type1 5 ItemTFive Type2 6 ItemSix Type2 7 ItemSeven Type2 8 ItemEight Type2

  Read the article

• Difference between "and" and "where" in joins

  - by Midhat

  Whats the difference between SELECT DISTINCT field1 FROM table1 cd JOIN table2 ON cd.Company = table2.Name and table2.Id IN (2728) and SELECT DISTINCT field1 FROM table1 cd JOIN table2 ON cd.Company = table2.Name where table2.Id IN (2728) both return the same result and both have the same explain output

  Read the article

• freeing a memory twice

  - by benjamin button

  Hi, AFAIAK, freeing a NULL will result in nothing.i mean nothing is being done by the compiler/no functionality is performed. Still i do see some statements where people say that one of the scenario,where a memory corruption can occur is "freeing a memory twice"? Is this still true?

  Read the article

• how to get latet entry of a item when item have multiple rows?

  - by I Like PHP

  i have an table tbl_exp id| exp_id|qnty| last_update 1 | 12 | 10|2010-05-18 19:34:29 2 | 13 | 50|2010-05-19 19:34:29 3 | 12 | 50|2010-05-19 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 now i need only latest entry of each exp_id id| exp_id|qnty| last_update 3 | 12 | 50|2010-05-19 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 please suggest me the mysql query to retrive above result?? thanks!

  Read the article

• rails, accepts_nested and has_many :through is creating duplicate entries

  - by Sam

  Hi, I have a store model that has many products with a has_many :through relationship. I have this working with accepts_nested_attributes, but the result is that rails is making duplicate associates. I don't have anything special going on it is a very simple app. Any ideas on why duplicates associates are getting created?

  Read the article

• Merging some columns of two mysql tables where id = fileid

  - by garg

  There are two tables TableA filedata_id | user_id | filename 1 | 1 | file.txt 2 | 1 | file2.txt TableB a_id | date | filedataid | counter | state | cat_id | subcat_id | med_id 99 | 1242144 | 1 | 2 | v | 55 | 56 | 90 100 | 1231232 | 2 | 3 | i | 44 | 55 | 110 I want to move columns cat_id, subcat_id, med_id to TableA where tableA.filedata_id = TableB.filedataid The result should be: TableA filedata_id | user_id | filename | cat_id | subcat_id | med_id 1 | 1 | file.txt | 55 | 56 | 90 2 | 1 | file2.txt | 44 | 55 | 110 and so on. Is there a way to do this easily?

  Read the article

• piping to variables

  - by lego69

  cut -d" " -f2 ${2} | $callsTo hello, can somebody please explain can I pipe the result of cut to variable callsTo, and how will it be stored, as the string or list?

  Read the article

• join two tables but want one matching columns instead of showing it separately sql server 2008

  - by amby

  Hi i want to display join result of two tables but don't want to show matching column separately. I want it one instead of two. so please tell me what query should i use for this. I m using sql server 2008 and my query is like: select * from Customer_Order, optRelation where Customer_Order.orderNumber = optRelation.orderNumber AND optRelation.orderNumber = 21. please reply soon

  Read the article

• Zend Framework date without hours minutes and seconds

  - by Trimm

  Anybody can help me to get date formated with Zend framework What I do is: <?php echo new Zend_Date(2010-05-23, false, 'en');?> Result I get is: May 22, 2010 12:00:00 AM I what I need is: May 22, 2010 Thanks.

  Read the article

• boolean VB expression returning false for integer 1

  - by Bill

  This is probably a really basic (no pun intended) question, but I can't seem to find an answer anywhere. Why does the result of func1 return False and func2 returns True? On every other test I have done, integer 1 is converted to boolean true and 0 to false. Works ok if I just set rtnValue to 1 or 0. Public Function func1() As Boolean Dim rtnValue As Integer = 0 Return rtnValue = 1 End Function Public Function func2() As Boolean Dim rtnValue As Integer = 0 Return rtnValue = 0 End Function

  Read the article

• How do I pass a conditional expression as a parameter in Ruby?

  - by srayhan

  For example this what I am trying to do, def method_a(condition, params={}, &block) if condition method_b(params, &block) else yield end end and I am trying to call the method like this, method_a(#{@date > Date.today}, {:param1 => 'value1', :param2 => 'value2'}) do end The result is the condition is always evaluated to true. How do I make it work?

  Read the article

< Previous Page | 373 374 375 376 377 378 379 380 381 382 383 384  | Next Page >