Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrgulic

    Trying to create a linq OrderBy alias

    I use the following to sort text containing strings and integers naturally Current .OrderBy(x => x.some_class_property_string, new OrdinalStringComparer(true))) I have been trying to create an alias (I hope I am using the correct terminology) so I can centralize and end up doing the...
  2. mrgulic

    Why doesn't my jQuery extension work? (TypeError: validStatus.arrayContains is not a function)

    Thanks Feherke, that did not occur to me.
  3. mrgulic

    Why doesn't my jQuery extension work? (TypeError: validStatus.arrayContains is not a function)

    I wrote the following to enable/disable elements, and it works fine. jQuery.fn.enable = function (enable) { var $this = $(this); if (enable) { $this.removeAttr("disabled"); } else { $this.attr("disabled", "disabled"); } }...
  4. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    I would have posted to an Oracle forum except that out of the following I didn't see one that was the equivalent of or close to "Microsoft SQL Server: Programming Forum". Oracle: Oracle release - 9i and earlier Oracle: Oracle release 10g Oracle: Oracle release 11g Oracle certification and...
  5. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    I had to make the following change from: ,DECODE(COALESCE(t1.REOPEN_FLG,T2.REOPEN_FLG), '1', 'true', '0', 'false') AS REOPEN_FLG to: ,COALESCE (DECODE(t1.REOPEN_FLG, '1', 'true', '0', 'false'), DECODE(t2.REOPEN_FLG, '1', 'true', '0', 'false')) AS REOPEN_FLG as I was getting the following...
  6. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    One small issue.............I didn't include my condition statement.....and when i added that on i received null results. SELECT COALESCE (t1.TESTGROUP, t2.TESTGROUP) AS TESTGROUP, COALESCE (t1.APPROVER, t2.APPROVER) AS APPROVER, COALESCE (t1.LEVL, t2.LEVL) AS LEVL, COALESCE (t1.TYPEREPORT...
  7. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    Thanks Frederico, I didn't know what dual was, thought is was one of your tables. Works great.
  8. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    Thanks for your reply fredericofonseca but when I was finally able to get your query to work it output thousands of null records when none existed and the same when one did exist. select coalesce (t1.TESTGROUP, t.TESTGROUP) as TESTGROUP, coalesce (t1.APPROVER, t.APPROVER) as APPROVER from...
  9. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    I tried your suggestion but i get an error. If Exists(Select 1 From Table) SELECT TESTGROUP, APPROVER, LEVL FROM [APPROVAL] Else SELECT '0' As TESTGROUP, NULL as APPROVER, NULL As LEVL ; Perhaps I have the syntax wrong, but I have never used If Exists, so I am in unknown territory. Here...
  10. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    Thanks for your reply, but there where no results returned.
  11. mrgulic

    SELECT UNION statement works in MSSQL but not in Oracle

    The following query SELECT column1, column2, column3 FROM [table1] UNION ALL SELECT '0',NULL,NULL FROM [table1] HAVING COUNT(*)=0 in MSSQL it will produce the following results (which i will display as comma separated values) when there are no records 0,NULL,NULL if there are records then...
  12. mrgulic

    Where is Textcopy.exe?

    Thanks, I found a solution when I found out that Textcopy was obsolete. Install Adobe IFilter (verify that it is installed) SELECT * FROM sys.fulltext_document_types Crate table. you can call the columns whatever you like. CREATE TABLE [dbo].[Blob]( [BlobFileId] [int] IDENTITY(1,1) NOT...
  13. mrgulic

    Where is Textcopy.exe?

    I have installed every single component for SQL Server 2008 R2 Developer Edition except for Reporting and Analysis Services and textcopy.exe is nowhere to be found. Everything I have read says it should be under C:\Program Files\Microsoft SQL Server\100\Tools\Bin\ or C:\Program...
  14. mrgulic

    Need help with DISTINCT on single column with multiple output with multiple joins

    The WHERE condition is NOT static. The statement used in SMS was for example purposes.
  15. mrgulic

    Need help with DISTINCT on single column with multiple output with multiple joins

    I have a GridView (populated by MSSQL) that displays information about order line items. Each Line Item is part of an Order and each Order belongs to a Project (3 tables). The GridView has several DropDownList's that filter the GridView results (based on user selection). I am currently...
  16. mrgulic

    How do you open a UNC path from ASP.NET

    If this is what you meant protected void ibtnSharePath_Click(object sender, ImageClickEventArgs e) { HyperLink h = new HyperLink(); h.Text = "test"; h.NavigateUrl = lblRoot.Text; } then no, it didnt work. The end URL I saw when debugging...
  17. mrgulic

    How do you open a UNC path from ASP.NET

    I don't know that this is the best way to occomplish my task but I wanted to share how I did it nonetheless. System.Diagnostics.Process.Start("explorer.exe", lblRoot.Text); This also work's, but it appears to open the explorer window behind IE, instead of out front...
  18. mrgulic

    How do you open a UNC path from ASP.NET

    My app retrieves all servers on the domain and populates a listbox with the server name. When server is clicked in the listbox, the shares on that server is listed in another listbox. When the share listbox is clicked, details about the share is displayed in labels, etc. What I am trying to do...
  19. mrgulic

    How to get only users from DirectorySearcher query

    Of course after several days of searching for an answer, a few hours after posting something here and a small change in the seach string on google yeilds positive results. I needed the following added to my filter ("objectCategory=Person") So i changed this: searchADS.Filter =...
  20. mrgulic

    How to get only users from DirectorySearcher query

    I have the following code that i use to search for users in the domain. When I enter a complte user name it finds it but when i use wildcards and gets even computer names that contain the string too. How to i filter for only only users? There has to be some flag that indicates a AD objct is a...

Part and Inventory Search

Back
Top