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!

  • Congratulations strongm 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. kloner

    Get all children tree query

    Ok, I have 9 levels at the moment .... it's a website struction, lots of sections and information. I have created the query as such, which seems to be fine. I just thought it could be shortened a little ... select DISTINCT M2.SectionID from TBL_SectionsTree as M1 left outer join...
  2. kloner

    Get all children tree query

    Thanks Rudy, however, would a query like this drain the CPU? Is there a way to create a SP and call itself. What happens if I have 10 levels? I just keep building up the query do i? kloner
  3. kloner

    Get all children tree query

    Hi all, I am pulling my hair out here! I am trying to select all the children records from the following data (i.e. I need to return all of the data you see below.) The only 'where clause' data is have is WHERE ID = 37 [ID] [ParentID] [Title] 37 1 BIG GIG 38 37...
  4. kloner

    Distinct Count Query

    Ah I finally worked it out! Thanks anyway guys! Happy I answered my own question ... SELECT [FunctionName], [ModuleName], [ErrorCode], [ErrorDescription], COUNT(*) AS ErrorCount FROM [dbo].[Tbl_Error] GROUP BY [FunctionName], [ModuleName], [ErrorCode], [ErrorDescription]...
  5. kloner

    Distinct Count Query

    Hi guys, I would appreciate any helpon this one as I am pulling out my hair trying to get it to work. What I have got so far is a recordset with all the correct distict data. The query is below. What I am after is to also return the count of each distinct record. SQL Query: SELECT...
  6. kloner

    Tree / Hierarchy Stored Procedure Help

    Hi all, I am getting close to solving my problem, however some extra help would be great as I am now stumped! I have a table that contains 'Sections'. There is a root section and many children, which can have more children etc. As you can see from my tree result below, the output is looking...
  7. kloner

    Help stripping string

    Hi all, was wondering if someone could help me strip this string : Dim strURL strURL = /products.asp?L1=3&L2=0&PARENT_PAGEID=0&TBL_PAGEID=4&offset=50 If the string contains "&offset=" then i would like the string stripped so that it looks like : strURL =...
  8. kloner

    Hierarchical Query

    Anyone able to help me out here? kloner
  9. kloner

    SQL selecting records help

    Thankyou for your help! That worked! Can someone explain what the different JOIN's are, and what they do? kloner
  10. kloner

    SQL selecting records help

    SELECT E.Name, E.GroupClass, E.NIIN FROM Equipment E WHERE (E.Assessor LIKE 'te%') AND (E.ArchivedBy IS NULL OR WHERE (E.Assessor LIKE 'te%') AND (E.ArchivedBy IS NULL OR E.ArchivedBy = '') AND (E.ArchivedByID IS NULL OR E.ArchivedByID = 0) AND (E.ArchivedByPosID IS NULL OR...
  11. kloner

    Hierarchical Query

    Hi all, I am trying to write my first hierarchical query in oracle 8i. The data I have is as follows : WID Name ParentID 1 Telecomunications NULL 2 Mobiles 1 3 Handheld Phones 8 4 Foxtel 1 5 Wholesale NULL 6...
  12. kloner

    Hanging Application

    I have just had the same problem today! WinNT\system32\msdtc.exe was hanging, using all my CPU. I installed McAfee 7.0 yesterday and thought it would be the cause of the problem. I acually booted up into safe mode, and manually stopped the service from continuing. Have now uninstalled McAfee and...
  13. kloner

    Printing a break after every x amount of chars??

    Hi all, In VBSCRIPT, how do you print a &quot;<BR>&quot; after every 15 characters of a string? eg strTempString = &quot;abcdefghijklmnopqrstuvwxyz123456789098gfjkgdfgkd&quot; and output would be : abcdefghijklmno <br> pqrstuvwxyz1234 <br> 56789098gfjkgdf <br> gkd Thanks kloner
  14. kloner

    Ignoring symbols and numbers

    Thanks for that, however I am still after a solution to display all 'NAMES' starting with 'A' (or any other letter), but ignoring all numbers and symbols until I reach the 'A'. eg. 'T' would be ... 2-(4,4,5,5-Tetramethyl-1,3,2-dioxaborolan-2-yl)phenol ignoring the &quot;2-(4,4,5,5-&quot...
  15. kloner

    Ignoring symbols and numbers

    Hi all, I am trying to come up with a way to ignore numbers and symbols in my query for a particular field. If i have a word like &quot;4-Acetamidophenylboronic&quot; I want to ignore all numbers and symbols. For example I want my query to display the word...
  16. kloner

    Format String Help

    Hi all, I'm going crazy! I need to format a formula. I have a string that looks like this &quot;a56c5t78h10K7&quot;. What I need to do is somehow loop through the string and append the html tag <sub></sub> around the integers. eg final string returned should look like ...
  17. kloner

    Create shared folder in VB?

    HI all, I was wondwring if it was possible to created a share on a specified folder in VB 6.0. I have looked everywhere for some help but to no sucess. EG. Directory is C:\MY_DEMO And I want to share it under the name &quot;MY_DEMO&quot;, and let only authenticated people have full control...
  18. kloner

    Create shared folder in VB?

    HI all, I was wondwring if it was possible to created a share on a specified folder in VB 6.0. I have looked everywhere for some help but to no sucess. EG. Directory is C:\MY_DEMO And I want to share it under the name &quot;MY_DEMO&quot;, and let only authenticated people have full control...
  19. kloner

    How to create IIS Application using VB/COM

    Hi all, I'm trying to create a IIS 5 application with virtual directories etc using Visual Basic. Can someone please tell me what reference library I should be using. I am using VB 6.0. thanks so much kloner
  20. kloner

    How to create IIS Application using VB/COM

    Hi all, I'm trying to create a IIS 5 application with virtual directories etc using Visual Basic. Can someone please tell me what reference library I should be using. I am using VB 6.0. thanks so much kloner

Part and Inventory Search

Back
Top