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. Fingerprint

    Count same column 2 different conditions, 1 recordset

    Lots of thought later - my solution is: SELECT Artist.name, SUM(IIF(Tracks.genreRef = 1,1,0)) AS unclassifiedCount, SUM(IIF(Tracks.genreRef <> 1,1,0) AS classifedCount FROM (SELECT DISTINCT Artist.name, Tracks.trackName, Tracks.genreRef FROM Artist, Tracks WHERE Artist.artistRef =...
  2. Fingerprint

    Count same column 2 different conditions, 1 recordset

    Just after I posted again I thought 'Duh! Just try it'. Bad brain day : ) It works perfectly, but I do need to modify it into the layout you mention - so if you can tell me how, I'll be forever grateful! Thanks again, &quot;The secret to creativity is knowing how to hide your sources&quot; -...
  3. Fingerprint

    Count same column 2 different conditions, 1 recordset

    Thanks for the advice! I've never come across one of those statements before (being a web developer, I only have basic SQL knowledge). What type of output does it give me? &quot;The secret to creativity is knowing how to hide your sources&quot; - Einstein
  4. Fingerprint

    Count same column 2 different conditions, 1 recordset

    Hi All, I'm working with a database of musical records. There's a table of artists, and another of tracks by that artist. Each track has a genre, where '1' is unclassfied, and anything else is a foreign key to the table of genres. What I'm trying to do is produce a single html table which has...
  5. Fingerprint

    Odd behaviour when class changed dynamically

    After a lot of research, I've found out that the problem is due to an Internet Explorer 6 bug - the way it redraws some content when any properties affecting layout (such as background) are changed. It was nothing to do with the Javascript involved, annoyingly enough after I'd changed...
  6. Fingerprint

    Odd behaviour when class changed dynamically

    Thanks for the tip - I've only been working with CSS properly for a few months, so I guess the first solution that occurred to me wasn't the best one : ) I'll try it out when I'm back in the office on Monday - as long as it all works out I'll give you a star. Still a bit curious to know why I...
  7. Fingerprint

    Odd behaviour when class changed dynamically

    I've been writing an electronic form with multiple pages, and tried to be good by positioning everything with CSS. There is a lefthand menu to jump between sections, and at the bottom of each page are back and next buttons. All the menu buttons and the back and next buttons are made using...
  8. Fingerprint

    Dynamic clipping for Netscape/Mozilla

    I've written a script to produce a statically placed menu that opens and closes when you click on it, based on an idea one of my friends saw elsewhere. It works fine in all versions of IE and Opera, but I can't work out why it isn't working in NS & Mozilla. (I know clip must be specified...
  9. Fingerprint

    Including # in a string

    Thanks guys! Guess I should have been a little more patient huh? Stars all round! fingerprint a posse ad esse
  10. Fingerprint

    Including # in a string

    I have given up and moved to focusing on a different linked element :( Oh well... Thanks for trying newbiepg! fingerprint a posse ad esse
  11. Fingerprint

    Including # in a string

    Tried it already - no luck I'm afraid! a posse ad esse
  12. Fingerprint

    Including # in a string

    Hi, hope someone can help because this is a pain in the bum! I have written some code as part of a validation routine which automatically determines which anchor tag to go to depending on the name of the field that was validated. The problem is that I keep getting an invalid character...
  13. Fingerprint

    Quick Script for a Wiz PLEASE!

    Hi, haven't tested this, but have had to use something similar on a really big form recently. You need to use a particular naming structure for your fields. Call the text boxes &quot;Q1&quot; - change the 1 to the right question number each time - then call your drop down boxes...
  14. Fingerprint

    Strange ActiveX Problem

    Hi All, I've written a program in HTML and Javascript that uses ActiveX controls to check for the existence of files on my local computer (it's not running on the web, it's just supposed to be a time saver). It runs fine in my editor (1st page 2000), finds all the .csv files in a folder for...
  15. Fingerprint

    Filter out carriage returns?

    Thanks for your help - guys, problem now sorted. Hopefully, it'll be the last one... - fingerprint
  16. Fingerprint

    Filter out carriage returns?

    Thanks, I'll try that.
  17. Fingerprint

    Filter out carriage returns?

    I've already tried that, and it doesn't work. Perhaps it's how I'm calling it - see below. var textaone { textaone = strReplaceAll(document.form1.tasks.value,&quot;,&quot;,&quot;&quot;); } var textatwo { textatwo = strReplaceAll(textaone,&quot;\n&quot;,&quot;&quot;); }...
  18. Fingerprint

    Filter out carriage returns?

    I'm having a hard time following that! The code detects the 'push enter key' event? It was more a case of removing the character at validation: the form output saves as a '*.csv' file, which is why a carriage return character messes up the output - Excel thinks that the data from that field...
  19. Fingerprint

    Filter out carriage returns?

    Thanks to all the help from people using this forum, my project is now up to the user testing stage, and we've only found one error. If a user of my form pushes enter/carriage return in a textarea, it messes up the form output - I get the field split into several output fields. I have wrap...
  20. Fingerprint

    Naming table rows

    Ok - so my code (abridged version) is now as follows: <html> <head> <title>Transporter</title> <script language=&quot;javascript&quot;> function addData() { var more more = document.givemore.loadthis.value; document.tdcInfo.dataURL = &quot;&quot;; document.tdcInfo.dataURL = more...

Part and Inventory Search

Back
Top