Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Thanks, I'll try that.

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;); }...

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

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

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