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 gkittelson 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. JeepStone

    Join Comma Sep field items to another field

    I have a users table which contains fields which hold marketing information in the form of a comma separated list. These are inputted from a web form and appear in the database fields as i.e. mkting_info1 1,2,5 mkting_info2 10,30,9 Each mkting_info field has a table with an ID and a...
  2. JeepStone

    XSLT - Refer to nodes outside current node

    Indeed! I used <xsl:with-param> to pass it through and have now got it working. Cheers m8 JeepStone www.eggsbox.co.uk
  3. JeepStone

    XSLT - Refer to nodes outside current node

    I have the following XML: <skills> <level1 skillid=&quot;1&quot;> <level2 skillid=&quot;20&quot;> ... </skills> <selected> <row number=1> <level1>1</level1> <level2>30</level2> ... </row> </selected> I'm using an apply templates for each <row> which creates a...
  4. JeepStone

    Multiple SELECT from nested queries

    Sorry Rudy, I've also provided you with some duff info. I'm not concerned with more than 3 levels in the site, so it doesn't matter where the article comes as long as I always show the top 3 parents. Also, a child will never have more than one parent. I misunderstood what you said in the...
  5. JeepStone

    Multiple SELECT from nested queries

    Thanks for the reply rudy, t_heirarchy is the structure of the site: Parent Child 0 1 0 2 0 3 1 10 1 11 i.e. A Parent ID of 0 is the top level (Home). It has 3 children. In this example, Child ID = 1 has two further levels below it...
  6. JeepStone

    Multiple SELECT from nested queries

    I'm using Access/ASP I have a navigation heirarchy which is structured as follows (simplified): Parent Child 0 1 1 2 2 3 The ID's of these are joined with the contents of the site. I'm trying to develop a 'breadcrumb' navigation section so I get...
  7. JeepStone

    Alter String to change grouping order (MAGIC)

    Cheers Naith! Worked a treat. I needed the 'else' bit obviously
  8. JeepStone

    Alter String to change grouping order (MAGIC)

    Hi guys, I'm running 8.0.1.0 with Magic HelpDesk. I'm trying to run a report of Ticket Calls (grouped) by Subject ID. In Magic, although the Subject ID's have a parent/child relationship, they come over to Crystal as a flat list. I need to be able to separate my report to show all Subject IDs...
  9. JeepStone

    Show null fields in a Magic Report

    I'm using Crystal 8 and Magic Helpdesk. I am pulling through information regarding Help Desk tickets and grouping them firstly by the department responsible and then by the client(vendor) who the work is for. We are do this to display the time taken for the number of calls. However, when Crystal...

Part and Inventory Search

Back
Top