From Ken at adOpenStatic.com Mon May 9 00:56:06 2005 From: Ken at adOpenStatic.com (Ken Schaefer) Date: Mon, 9 May 2005 15:56:06 +1000 Subject: [thelist] A question on proxy caching. Message-ID: <160489103479AB4892187638EE7D1E6914BA73@kjserver1.kjhome.local> Without knowing the actual proxy server in use, and how it's configured, it's impossible to say with any certainty how it will behave with your proposed system. That said, what you are proposing generally works. You just need to ensure that the element generated is actually random (or at least changes between requests). If the code that generates the suffix is client-based and is cached by the proxy server, then you need to make sure that it's still capable of generating different values each time it's loaded by the browser. Cheers Ken -- www.adOpenStatic.com/cs/blogs/ken/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of VOLKAN ?Z?ELIK : Subject: [thelist] A question on proxy caching. : : Hi evolters! : : We're developing a site and some of our clients (ADSL users actually) : showed that their js files are being cached. When we make a change it : might take around 1 day for the changes to propagate to the client. : : We've tried the usual tricks ctrl+R, ctrl+f5, type the url of the js : file to the address bar and then ctrl+f5, adding pragma no cache and : several other browser specific "please don't cache me, I beg on my : knees" headers. : None of them worked :( : : My intelligent guess is that not the client's browser but TurkTelecom : (the ADSL provider) is caching the files to reduce network traffic. : : After this much introduction, here is my question? : : say my js file is included like : : : : Can appending a random generated query string will deceive the ISP and : prevent the file from being cached? I mean: : : : : given that rand changes at each request, will the proxy server send : the fresh file, instead of providing the cached one. : : Or can the ISP proxy be"clever-enough" to detect that the two HTTP : requests (with and without the appended query string) refer to the : same file and provide the cached version of the file in either : situation? : : This cache issue is causing a lot of headache, and when the usage of : the system spreads more, things will be much worse. We are updating : the system/scripts etc approximately thrice a week. So caching is an : important issue. : : I hear you saying "don't bother us, just try and see". But it is at : least 1-day work. (not all the files cached, and it appears that the : files are cached at random, so it will be a project-wide : implementation) So if it will definetely not work, I'd be glad to : learn before I begin. Similarly if it will definetely solve the : problem, I will be rushing to implement it. : : Thank you very much in advance, : Volkan. From morrison.ben at gmail.com Mon May 9 04:18:21 2005 From: morrison.ben at gmail.com (ben morrison) Date: Mon, 9 May 2005 10:18:21 +0100 Subject: [thelist] defaul browser stylesheets as CSS In-Reply-To: <427C05CE.8040306@oceanicsky.com> References: <427C05CE.8040306@oceanicsky.com> Message-ID: <6073aef9050509021830ac2620@mail.gmail.com> On 5/7/05, David Siedband wrote: > It seems like every browser has a default stylesheet that gets > overridden by CSS... > > Has anyone documented the default styles (by browser) for each element? Each browser does indeed have default settings for CSS and they do vary. Some developers reset each element before beginning a new project. A good article about undoing css: http://www.meyerweb.com/eric/thoughts/2004/09/15/emreallyem-undoing-htmlcss/ ben From joshua at waetech.com Mon May 9 07:52:55 2005 From: joshua at waetech.com (Joshua Olson) Date: Mon, 9 May 2005 08:52:55 -0400 Subject: [thelist] [TIP] SQL Message-ID: This tip is specifically for MS SQL Server. If you'd like to group all the records for a particular day, you can do some fancy footwork with date part, or you could do something like this: SELECT Convert(varchar, [date], 111) AS [date] , [agg_columnlist] GROUP BY Convert(datetime, Convert(varchar, [date], 111), 111) AS [date] The first column now contains the date formatted as "YYYY/MM/DD", casted as a string. If you want the results in date order, you need only sort by the first column. So, add "ORDER BY 1" or "ORDER BY 1 DESC" If you want back a real date object in the results, change the query to this: SELECT Convert(datetime, Convert(varchar, [date], 111), 111) AS [date] , [agg_columnlist] GROUP BY Convert(datetime, Convert(varchar, [date], 111), 111) AS [date] <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From bedouglas at earthlink.net Mon May 9 08:57:49 2005 From: bedouglas at earthlink.net (bruce) Date: Mon, 9 May 2005 06:57:49 -0700 Subject: [thelist] project looking for a web designer/developer Message-ID: <08e901c5549f$16e53320$0301a8c0@Mesa.com> hi.. Is this a correct mailing list to submit a posting looking for a web developer/web designer? The project will initially be a Sweat Equity project? Are there members here interested in being part of a Start-Up. We have a layout of a hybrid hotornot/'yahoo groups'/'distributed streaming video' and we're looking to create a mockup/prototype, and to then get the functionality up/running. Your skills would be used to convert what we have, into a css/jscript/etc.. mockup... Once we get the look/feel/links/etc.. nailed down, we'll layer it on top of the underlying functionality.. Thanks Bruce bedouglas at earthlink.net From michele at wizardev.ca Mon May 9 10:17:22 2005 From: michele at wizardev.ca (Michele Foster (WizarDev)) Date: Mon, 9 May 2005 11:17:22 -0400 Subject: [thelist] Data Shaping and Count Message-ID: <004001c554aa$34143440$47699c84@mef> I have this query .... strShapeSQL = "SHAPE {SELECT JobID, PositionEn, ApplicationDeadline, Uniterra" &_ " FROM Jobs WHERE Uniterra=Yes ORDER BY ApplicationDeadline DESC}" & _ " APPEND({SELECT VolApply.VolApplyID, VolApply.VolApplyContactID, VolApply.DateSubmitted, VolApply.Position, Contacts.ContactID, Contacts.FirstName, Contacts.LastName" &_ " FROM VolApply INNER JOIN Contacts ON VolApply.VolApplyContactID = Contacts.ContactID ORDER BY VolApply.DateSubmitted} AS Applicants " & _ " RELATE JobID TO Position)" Which gives me, JobTitle1 (PositionEn) Applicant1 (FirstName, LastName) Applicant2 Applicant3 JobTitle2 Applicant1 Applicant2 etc. This all works fine. Now, what the client would like, is to know the total number of jobs a particular applicant has applied for. I'm clueless how I could add that to the above SQL. In a perfect world .. they'd like to go one step further and do this .. JobTitle1 Applicant1 This person has also applied for the following jobs: List of other jobs applied for However, I think that's asking too much, and what they've said would meet their needs, is just to have the total number of positions applied for on the current screen, that number is clickable, then they could see all of the positions on the next screen. Any help greatly appreciated. Michele From joshua at waetech.com Mon May 9 10:36:13 2005 From: joshua at waetech.com (Joshua Olson) Date: Mon, 9 May 2005 11:36:13 -0400 Subject: [thelist] Data Shaping and Count In-Reply-To: <004001c554aa$34143440$47699c84@mef> Message-ID: > -----Original Message----- > From: Michele Foster (WizarDev) > Sent: Monday, May 09, 2005 11:17 AM > > I have this query .... > > strShapeSQL = "SHAPE... (complex query here...)" > > Which gives me, > > JobTitle1 (PositionEn) > Applicant1 (FirstName, LastName) > Applicant2 > Applicant3 > > JobTitle2 > Applicant1 > Applicant2 > etc. Michele, Before we delve into a solution for your other problem... is there a real need here for data shaping? Have you tried to tackle this with normal SQL and some creative output looping? <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From swehren at gmail.com Mon May 9 11:22:12 2005 From: swehren at gmail.com (Scott Wehrenberg) Date: Mon, 9 May 2005 11:22:12 -0500 Subject: [thelist] Grep Question - match multiple lines but not greedy In-Reply-To: <49a399d3551160b30ce9b1b4b2a71eb0@erikheerlein.com> References: <427B8A15.2090507@kickasswebdesign.com> <8d6d3a5dd17081bf7a09cdf9f5cb49f2@comcast.net> <49a399d3551160b30ce9b1b4b2a71eb0@erikheerlein.com> Message-ID: <3fb252250505090922477803b6@mail.gmail.com> On 5/6/05, Erik Heerlein wrote: > I can match line 1 and line 30 separately but I don't know how to match > the stuff in between without being greedy and matching the whole file. > I'd like to say, "Find a block of text where the first line is the > date, followed by some text I don't care about and the last line is the > Subtotal with the price that I do care about. Or to put it another way: Syntax (and support) depends mostly on which tool you're using to do the regex, but generally speaking simply appending a question mark after your wildcard will make it non-greedy. So you probably want something like this: Date: May 5, 2005.*?Subtotal[ ]+= \$([0-9]+\.00) The "*?" should match the smallest possible number of occurences to make the regex work. From dan.mccullough at gmail.com Mon May 9 11:57:28 2005 From: dan.mccullough at gmail.com (Dan McCullough) Date: Mon, 9 May 2005 12:57:28 -0400 Subject: [thelist] still images to a movie in flash Message-ID: Doing about a 3 minute "inspirational" movie, mostly with still images and music. I pretty much have settled on Flash as the creation software since it offers the most in terms of flexibilty with the creative presentation. There are some question since this is not something I have done before and it is definatly not something I know a lot about. Does anyone have other software suggestions? PowerPoint has been squashed, we not going to even consider PowerPoint. This will be shown in an auditorium so does anyone have gotchas or comments about using Flash for presenting in a large room, knowing that most of the display will be about the projection equiptment, but is there a good resolution to create the movie in, or canvas size? Any other thoughts or comments? From jay.blanchard at niicommunications.com Mon May 9 12:34:36 2005 From: jay.blanchard at niicommunications.com (Jay Blanchard) Date: Mon, 9 May 2005 12:34:36 -0500 Subject: [thelist] MySQL display on web w/ PHP Message-ID: [snip] I have done some PHP and some MySQL but I am very new at doing both together. Assuming the following: Database = "Sales" Table = "Orders" Name = "Jones" When Jones' page opens up, I need his order number and date of order to appear on the screen in a table format. I keep getting syntax errors with this. I am certain that someone has an example of this. [/snip] Since you provided no examples of your syntax errors there will have to be several assumptions made. The first assumption is that you did not do a Google search for PHP MySQL tutorial. There are several examples available. From Brian at hondaswap.com Mon May 9 12:49:06 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Mon, 09 May 2005 13:49:06 -0400 Subject: [thelist] MySQL display on web w/ PHP In-Reply-To: References: Message-ID: <427FA292.80209@hondaswap.com> Ken Moore wrote: > Hello everyone, > > I have done some PHP and some MySQL but I am very new at doing both > together. > Assuming the following: > > Database = ?Sales? > Table = ?Orders? > Name = ?Jones? > > When Jones? page opens up, I need his order number and date of order to > appear on the screen in a table format. I keep getting syntax errors > with this. > $db = mysql_connect($dbhost, $username, $password); mysql_select_db("Sales", $db); $sql = "select order_number, order_date from Orders where name = 'Jones'"; if (!$result = mysql_query($sql, $db)) die("Sorry, We could not find this person"); while ($r = mysql_fetch_array($result)) { echo "Order # " . $r['order_number'] . "
"; echo "Date of Order: " . $r['order_date'] . "
"; } From lists at neptunewebworks.com Mon May 9 13:06:51 2005 From: lists at neptunewebworks.com (Maximillian Schwanekamp) Date: Mon, 09 May 2005 11:06:51 -0700 Subject: [thelist] MySQL display on web w/ PHP In-Reply-To: References: Message-ID: <427FA6BB.4010605@neptunewebworks.com> Ken Moore wrote: > When Jones? page opens up, I need his order number and date of order to > appear on the screen in a table format. I keep getting syntax errors > with this. Can you give a little more detail? What does your code look like right now? Are you getting PHP syntax errors or MySQL syntax errors? Anyway, Google is your friend. If you're not finding what you want there, try Safari Bookshelf[0]. Scads of MySQL/PHP books online there, e.g. "Teach Yourself PHP and MySQL In 13 Seconds" and the like, any of which will get you going quickly. Also, you might look at PEAR DB, which makes things even easier[1]. David Sklar's PHP Cookbook has some good usage examples for PEAR DB (you can buy it or read it online at Safari). [0] http://mandrake.safaribooksonline.com/ [1] http://pear.php.net/package/DB -- Maximillian Von Schwanekamp http://www.neptunewebworks.com/ From mar961 at libero.it Mon May 9 13:24:41 2005 From: mar961 at libero.it (Marcello Cerruti) Date: Mon, 9 May 2005 20:24:41 +0200 Subject: [thelist] Database of countries administrative subdivisions References: <427E0766.10406@danromanchik.com> <00c201c553e7$160711c0$f51b2697@marcello> <427E3D9C.3020200@wanadoo.fr> Message-ID: <007401c554c4$5e2196f0$f51b2697@marcello> > Hi Marcello, > try this for France : > http://www.insee.fr/fr/nom_def_met/nomenclatures/cog/cog.htm Thanks a lot suit perfectly my needs, though the database of the "communes" is related to the number of the "Regions" and the number of the "Departments" so I'll had to edit manually to change the Regions and Departments numbers to their name manually :-) Thanks again Marcello Cerruti PS: Anyone for other countries? From getafixx at getafixx.com Mon May 9 13:19:51 2005 From: getafixx at getafixx.com (Getafixx) Date: Mon, 09 May 2005 19:19:51 +0100 Subject: [thelist] date selection and mysql and PHP In-Reply-To: References: Message-ID: <427FA9C7.6070409@getafixx.com> OK I am working on a simple calender (OK I know it's pretty dull stuff) My questions are - I am storing the date and the timing of an event with DATETIME, which seams to work OK. I have been trying to craft a search to get ONLY the events on the day in question.. The only way I could do that and it was a big hack was to use this query, where I have to arse around with figuring out what the next day is and go from the correct day to the next day... SELECT * FROM `events` WHERE `date_time` BETWEEN "20050509" AND "20050510" ORDER BY "20050509" I don't like this because I don't want to have to write loads of code to check that the next day (ie just making day ++) is still a valid day, and by this time I have broken down (OK on having written this line, I think of a few more ways I could do that.. ) Maybe my question is why can't I just say where date row = where I try and match just the first part of the date with the first part of any dates in the table SELECT * FROM `my_table` WHERE `date_time` = "20050509" but this doesnt seam to work... Any ideas? or am I doing it right? Also on reading the db for a months worth of dates, would it be better to do one query for the whole month and then parse it up, or lots of small queries, for each day? Thanks in advance. Justin -- ============================================================== Justin / Getafixx 07967 638 529 mailto:qwerty1 at getafixx.com http://getafixx.com http://getafixxhosting.com for really cheap web hosting ============================================================== From jay.blanchard at niicommunications.com Mon May 9 13:45:21 2005 From: jay.blanchard at niicommunications.com (Jay Blanchard) Date: Mon, 9 May 2005 13:45:21 -0500 Subject: [thelist] date selection and mysql and PHP Message-ID: [snip] Maybe my question is why can't I just say where date row = where I try and match just the first part of the date with the first part of any dates in the table SELECT * FROM `my_table` WHERE `date_time` = "20050509" but this doesnt seam to work... Any ideas? or am I doing it right? [/snip] SELECT * FROM `my_table` WHERE `date_time` LIKE "20050509%" From michele at wizardev.ca Mon May 9 14:02:17 2005 From: michele at wizardev.ca (Michele Foster (WizarDev)) Date: Mon, 9 May 2005 15:02:17 -0400 Subject: [thelist] Data Shaping and Count References: <200505091602.j49G29No018022@mail107.megamailservers.com> Message-ID: <008801c554c9$9f93a420$47699c84@mef> ----- Original Message ----- From: "Joshua Olson" > > Before we delve into a solution for your other problem... is there a real > need here for data shaping? Have you tried to tackle this with normal SQL > and some creative output looping? Yes, I wasted 1/2 a day trying to get it to work with no luck... then spent 15 mins getting it to work with data shaping. :) Are there reasons why data shaping is bad and shouldn't be used? Mich From dan at danromanchik.com Mon May 9 14:17:50 2005 From: dan at danromanchik.com (Dan Romanchik) Date: Mon, 09 May 2005 15:17:50 -0400 Subject: [thelist] AdWords vs. BrightAds vs. ??? Message-ID: <427FB75E.4070606@danromanchik.com> On several sites recently--at the behest of the client--I have posted Kanoodle BrightAds instead of Google AdWords. I also just included them on one of my own sites, KB6NU.Com. Unfortunately, it looks as thought the BrightAds are a lot less relevant to the content of the page they appear on than are Google AdWords. For example, KB6NU.Com is my amateur radio blog. I guess Kanoodle equates radio to music because all three BrightAds are music-related ads. None of them have anything to do with amateur radio. I guess there could be several reasons for this: 1. The Kanoodle algorithm for selecting ads is whacked. 2. Kanoodle has a much smaller pool of ads to choose from, and these actually are the most relevant in their pool. 3. Kanoodle figures that they're going to make more money from these ads than from ads actually related to amateur radio. So, now the questions: 1. Do any of you have experience with BrightAds? 2. Are you getting similar results? 3. Is there a third option for these kinds of ads? Regards, Dan ================================================= Dan Romanchik, Freelance Web Developer 734-930-6564, dan at danromanchik.com http://www.webpublishinggroup.com From mwarden at gmail.com Mon May 9 14:41:19 2005 From: mwarden at gmail.com (Matt Warden) Date: Mon, 9 May 2005 15:41:19 -0400 Subject: [thelist] Data Shaping and Count In-Reply-To: <427f896b.0eac6f66.1172.2761SMTPIN_ADDED@mx.gmail.com> References: <004001c554aa$34143440$47699c84@mef> <427f896b.0eac6f66.1172.2761SMTPIN_ADDED@mx.gmail.com> Message-ID: Michele, On 5/9/05, Joshua Olson wrote: > > -----Original Message----- > > From: Michele Foster (WizarDev) > > Sent: Monday, May 09, 2005 11:17 AM > > > > I have this query .... > > > > strShapeSQL = "SHAPE... (complex query here...)" > > > > Which gives me, > > > > JobTitle1 (PositionEn) > > Applicant1 (FirstName, LastName) > > Applicant2 > > Applicant3 > > > > JobTitle2 > > Applicant1 > > Applicant2 > > etc. > > Michele, > > Before we delve into a solution for your other problem... is there a real > need here for data shaping? Have you tried to tackle this with normal SQL > and some creative output looping? As rudy says: "I have seen data shaping and it is the spawn of satan." It took a while, but working off of that, I would suggest (pardon my reformulation): SELECT a.VolApplyID, a.VolApplyContactID, a.DateSubmitted, j.PositionEn, c.ContactID, c.FirstName, c.LastName, count(otherapplications.VolApplyID) FROM VolApply a, Contacts c, Jobs j, VolApply otherapplications WHERE a.VolApplyContactID = c.ContactID AND a.Position = j.JobID AND j.Uniterra = 'Yes' AND otherapplications.VolApplyContactID = a.VolApplyContactID GROUP BY a.VolApplyID, a.VolApplyContactID, a.DateSubmitted, j.PositionEn, c.ContactID, c.FirstName, c.LastName ORDER BY j.ApplicationDeadline, a.DateSubmitted (that might not be exactly right. I tried to get in all the conditions you had, but it has been years since I've used data shaping, and i could be forgetting something it does.) The above is based on your subject, where you say you only want a count. If you want an actual list, you would want something like this (however, your loop just became thrice nested, I believe): SELECT a.VolApplyID, a.VolApplyContactID, a.DateSubmitted, j.PositionEn, c.ContactID, c.FirstName, c.LastName, otherjobs.PositionEn FROM VolApply a, Contacts c, Jobs j, VolApply otherapplications, Jobs otherjobs WHERE a.VolApplyContactID = c.ContactID AND a.Position = j.JobID AND j.Uniterra = 'Yes' AND otherapplications.VolApplyContactID = a.VolApplyContactID AND otherapplications.Position = otherjobs.PositionEn ORDER BY j.ApplicationDeadline, a.DateSubmitted Both of these might need tweaking, as they are untested and there's only so much the database engine in my head can do. If the results look close, we can try to work out the kinks. Thanks, -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From mr.sanders at designshift.com Mon May 9 15:16:04 2005 From: mr.sanders at designshift.com (Sarah Sweeney) Date: Mon, 09 May 2005 17:16:04 -0300 Subject: [thelist] mysql index not being used in query Message-ID: <427FC504.3020602@designshift.com> I have a table called "Cats" with the following fields (other fields omitted to simplify): CategoryID NodeLeft NodeRight Title I've added indexes on CategoryID -> CatID NodeLeft, NodeRight -> NodeLR I ran this EXPLAIN statement: EXPLAIN SELECT CategoryID, Title, NodeLeft, NodeRight FROM Categories WHERE NodeLeft BETWEEN 2 AND 1705 ORDER BY NodeLeft which returned the following: table | type | possible_keys | key | key_len | ref | rows | Extra ------+------+---------------+--------+---------+--------+------+---------------------------- Cats | ALL | NodeLR | (NULL) | (NULL) | (NULL) | 852 | Using where; Using filesort I'm not really sure why the query isn't using the NodeLR index - any ideas? From ox4dboy at comcast.net Mon May 9 15:31:28 2005 From: ox4dboy at comcast.net (Jono) Date: Mon, 9 May 2005 16:31:28 -0400 Subject: [thelist] still images to a movie in flash In-Reply-To: References: Message-ID: On May 9, 2005, at 12:57 PM, Dan McCullough wrote: > Doing about a 3 minute "inspirational" movie, mostly with still images > and music... > > Does anyone have other software suggestions?... > This will be shown in an auditorium so does anyone have gotchas or > comments about using Flash for presenting in a large room, knowing > that most of the display will be about the projection equiptment, but > is there a good resolution to create the movie in, or canvas size? > Any other thoughts or comments? > -- Are you by any chance using a Mac? If so, I'd just use iMovie. IT is easy to get the hang of, and handles photos, music, and movies extremely well. The interface is very intuitive. If not a Mac, then you'll most likely want to go with Flash, which can be a real hassle to a new user. As for size, if you are using a projector, it will just project what ever size you choose in your document onto the screen/wall. I generally like to go with a wide format, sorta' like a wide-formatted DVD - 4:3 or 16:9 I think it is? IT's been a while. From fuzzylizard at gmail.com Mon May 9 15:35:26 2005 From: fuzzylizard at gmail.com (Chris Johnston) Date: Mon, 9 May 2005 16:35:26 -0400 Subject: [thelist] still images to a movie in flash In-Reply-To: References: Message-ID: On 5/9/05, Dan McCullough wrote: > > This will be shown in an auditorium so does anyone have gotchas or > comments about using Flash for presenting in a large room, knowing > that most of the display will be about the projection equiptment, but > is there a good resolution to create the movie in, or canvas size? > Any other thoughts or comments? Know the resolution that the projector can handle and create the project for that size. The last thing you want is to create the project for a smaller size then what the project can handle and have all your lovely images have to be scaled up. General rule of thumb, always work to the final output size of the project. This will probably mean 1024x768 at 72ppi. -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd From michele at wizardev.ca Mon May 9 15:41:44 2005 From: michele at wizardev.ca (Michele Foster (WizarDev)) Date: Mon, 9 May 2005 16:41:44 -0400 Subject: [thelist] Data Shaping and Count References: <004001c554aa$34143440$47699c84@mef> <427f896b.0eac6f66.1172.2761SMTPIN_ADDED@mx.gmail.com> Message-ID: <00b001c554d7$8560c2a0$47699c84@mef> Matty, ----- Original Message ----- From: "Matt Warden" > As rudy says: "I have seen data shaping and it is the spawn of satan." Ok, point taken ... I didn't realize it was "evil". I'll remember that for next time. I should have asked thelist before abandoning my first approach. :) > > SELECT a.VolApplyID, a.VolApplyContactID, a.DateSubmitted, > j.PositionEn, c.ContactID, c.FirstName, c.LastName, > otherjobs.PositionEn > FROM VolApply a, Contacts c, Jobs j, VolApply otherapplications, Jobs otherjobs > WHERE a.VolApplyContactID = c.ContactID > AND a.Position = j.JobID > AND j.Uniterra = 'Yes' > AND otherapplications.VolApplyContactID = a.VolApplyContactID > AND otherapplications.Position = otherjobs.PositionEn > ORDER BY j.ApplicationDeadline, a.DateSubmitted This is very slick ... and in Access it is returning the record set as I would like it. Thank you!!! I made a few minor changes, and this is what I'm working with now .. SELECT a.VolApplyID, a.VolApplyContactID, a.DateSubmitted, j.PositionEn, j.JobID, c.ContactID, c.FirstName, c.LastName, otherjobs.PositionEn, otherjobs.JobID FROM VolApply AS a, Contacts AS c, Jobs AS j, VolApply AS otherapplications, Jobs AS otherjobs WHERE a.VolApplyContactID=c.ContactID And a.Position=j.JobID And j.Uniterra=true And otherapplications.VolApplyContactID=a.VolApplyContactID And otherapplications.Position=otherjobs.JobID ORDER BY j.jobID DESC, j.ApplicationDeadline, a.DateSubmitted; Now, below is a sample of the data (only the numbers, easier to see the patterns), j.JobID ContactID otherjobs.JobID 74 23909 74 72 23635 72 72 23635 52 72 23635 63 72 23635 54 70 23905 70 69 23852 69 69 23890 69 69 23831 69 69 23831 67 Where I'm confused, and why I abandoned earlier approaches was my looping through the recordset. Could you, or anyone really, give me some guidance on how to approach this. I was getting lost with my do until, do while, and if not end of RS statements. Something rough is fine, I don't want someone else to do this for me ... just a push in the right direction would be helpful. :) One thing I do notice with the above query .. it doesn't give me the jobs even if there are no applicants, i.e. Project71 currently has no applicants for it yet. With the data shaping because I in essence had two recordsets I could check that while it looped. It's not a big deal though, just thought I would ask if it were possible to get that into the mix somehow. Thanks again, Mich From keith at digital-crew.com Mon May 9 15:43:30 2005 From: keith at digital-crew.com (Keith Gaughan) Date: Mon, 09 May 2005 21:43:30 +0100 Subject: [thelist] mysql index not being used in query In-Reply-To: <427FC504.3020602@designshift.com> References: <427FC504.3020602@designshift.com> Message-ID: <427FCB72.6060309@digital-crew.com> Sarah Sweeney wrote: > I have a table called "Cats" with the following fields (other fields > omitted to simplify): > > CategoryID > NodeLeft > NodeRight > Title > > I've added indexes on > > CategoryID -> CatID > NodeLeft, NodeRight -> NodeLR > > I ran this EXPLAIN statement: > > EXPLAIN SELECT CategoryID, Title, NodeLeft, NodeRight > FROM Categories > WHERE NodeLeft BETWEEN 2 AND 1705 > ORDER BY NodeLeft > > which returned the following: > > table | type | possible_keys | key | key_len | ref | rows | Extra > ------+------+---------------+--------+---------+--------+------+---------------------------- > > Cats | ALL | NodeLR | (NULL) | (NULL) | (NULL) | 852 | Using > where; Using filesort > > I'm not really sure why the query isn't using the NodeLR index - any ideas? First thing to know is that MySQL only ever uses one (yes, one) index. Now, NodeLR is a compound index, meaning that it will only be used if *both* columns are involved in the lookup. What you probably need is a seperate index on NodeLeft so that it will do the lookup on that. K. From mwarden at gmail.com Mon May 9 15:52:52 2005 From: mwarden at gmail.com (Matt Warden) Date: Mon, 9 May 2005 16:52:52 -0400 Subject: [thelist] mysql index not being used in query In-Reply-To: <427FC504.3020602@designshift.com> References: <427FC504.3020602@designshift.com> Message-ID: On 5/9/05, Sarah Sweeney wrote: > I have a table called "Cats" with the following fields (other fields > omitted to simplify): > > CategoryID > NodeLeft > NodeRight > Title > > I've added indexes on > > CategoryID -> CatID > NodeLeft, NodeRight -> NodeLR > > I ran this EXPLAIN statement: > > EXPLAIN SELECT CategoryID, Title, NodeLeft, NodeRight > FROM Categories > WHERE NodeLeft BETWEEN 2 AND 1705 > ORDER BY NodeLeft > > which returned the following: > > table | type | possible_keys | key | key_len | ref | rows | Extra > ------+------+---------------+--------+---------+--------+------+---------------------------- > Cats | ALL | NodeLR | (NULL) | (NULL) | (NULL) | 852 | Using > where; Using filesort > > I'm not really sure why the query isn't using the NodeLR index - any ideas? I believe it is because you are not using NodeRight in an AND condition in the WHERE clause. You can confirm this by adding "FORCE INDEX" to the SQL query. If the EXPLAIN still doesn't use the index, then using the index is not possible (likely due to what I suggest above). If this is the case, create separate indexes for NodeLeft and NodeRight, if you plan on using queries that reference only one of them in an AND-type condition. Here's the specific query you want to run to confirm this: EXPLAIN SELECT CategoryID, Title, NodeLeft, NodeRight FROM Categories FORCE INDEX NodeLR WHERE NodeLeft BETWEEN 2 AND 1705 ORDER BY NodeLeft -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From mwarden at gmail.com Mon May 9 16:02:55 2005 From: mwarden at gmail.com (Matt Warden) Date: Mon, 9 May 2005 17:02:55 -0400 Subject: [thelist] Data Shaping and Count In-Reply-To: <00b001c554d7$8560c2a0$47699c84@mef> References: <004001c554aa$34143440$47699c84@mef> <427f896b.0eac6f66.1172.2761SMTPIN_ADDED@mx.gmail.com> <00b001c554d7$8560c2a0$47699c84@mef> Message-ID: Michele, On 5/9/05, Michele Foster (WizarDev) wrote: > j.JobID ContactID otherjobs.JobID > 74 23909 74 > 72 23635 72 > 72 23635 52 > 72 23635 63 > 72 23635 54 > 70 23905 70 > 69 23852 69 > 69 23890 69 > 69 23831 69 > 69 23831 67 > > Where I'm confused, and why I abandoned earlier approaches was my looping > through the recordset. Could you, or anyone really, give me some guidance > on how to approach this. I was getting lost with my do until, do while, and > if not end of RS statements. Something rough is fine, I don't want someone > else to do this for me ... just a push in the right direction would be > helpful. :) Basically, you would do something like this (very rough, like you asked for, so you will have to alter it -- not to mention i havent done ASP in a while): do while not rs.eof iJobID = rs(x) ' print out job do while rs(x)=iJobID and not rs.eof ' loop while same job iApplicantID = rs(y) ' print out applicants for this job do while rs(y)=iApplicantID and not rs.eof ' loop while same applicant ' print out applicant's other applications loop loop loop To get this to work, you will have to make sure your data set is ordered by jobid, then applicantid, then otherjobid. > One thing I do notice with the above query .. it doesn't give me the jobs > even if there are no applicants, i.e. Project71 currently has no applicants > for it yet. With the data shaping because I in essence had two recordsets I > could check that while it looped. It's not a big deal though, just thought > I would ask if it were possible to get that into the mix somehow. You need to outer join on the first jobs-volapply join rather than just inner join. You need to use the formal join syntax (like you used in your original query and I arrogantly destroyed due to my hatred of it) to do this in Access, I believe. -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From Brian at hondaswap.com Mon May 9 16:06:32 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Mon, 09 May 2005 17:06:32 -0400 Subject: [thelist] Data Shaping and Count In-Reply-To: <00b001c554d7$8560c2a0$47699c84@mef> References: <004001c554aa$34143440$47699c84@mef> <427f896b.0eac6f66.1172.2761SMTPIN_ADDED@mx.gmail.com> <00b001c554d7$8560c2a0$47699c84@mef> Message-ID: <427FD0D8.9040806@hondaswap.com> Michele Foster (WizarDev) wrote: > > Where I'm confused, and why I abandoned earlier approaches was my looping > through the recordset. Could you, or anyone really, give me some guidance > on how to approach this. I was getting lost with my do until, do while, and > if not end of RS statements. Michelle: This is what i usually use: if not rst.EOF then do until rst.eof for x = 0 to rst.Fields.count - 1 ' row stuff here... next rst.movenext loop else response.write "No results" end if From technique at oceanicsky.com Mon May 9 16:40:43 2005 From: technique at oceanicsky.com (David Siedband) Date: Mon, 09 May 2005 14:40:43 -0700 Subject: [thelist] mysql - selecting based on count of key Message-ID: <427FD8DB.7050205@oceanicsky.com> I have an index table that linkes to Projects and Documents based on foreign keys: ProjID , DocID, and I want to find documents that are linked to more than a threshold number of projects. trying some vartions on this... select distinct ProjID from ProjectDocuments where Count(DocID) > '3' Can this be done in a single query? thanks -- David From keith at digital-crew.com Mon May 9 16:54:15 2005 From: keith at digital-crew.com (Keith Gaughan) Date: Mon, 09 May 2005 22:54:15 +0100 Subject: [thelist] mysql - selecting based on count of key In-Reply-To: <427FD8DB.7050205@oceanicsky.com> References: <427FD8DB.7050205@oceanicsky.com> Message-ID: <427FDC07.4020608@digital-crew.com> David Siedband wrote: > I have an index table that linkes to Projects and Documents based on > foreign keys: ProjID , DocID, and I want to find documents that are > linked to more than a threshold number of projects. > > trying some vartions on this... > > select distinct ProjID > from ProjectDocuments > where Count(DocID) > '3' > > Can this be done in a single query? You need to do a GROUP BY on ProjID. From joshua at waetech.com Mon May 9 17:31:04 2005 From: joshua at waetech.com (Joshua Olson) Date: Mon, 9 May 2005 18:31:04 -0400 Subject: [thelist] mysql - selecting based on count of key In-Reply-To: <427FD8DB.7050205@oceanicsky.com> Message-ID: > -----Original Message----- > From: David Siedband > Sent: Monday, May 09, 2005 5:41 PM > > I have an index table that linkes to Projects and Documents based on > foreign keys: ProjID , DocID, and I want to find documents that are > linked to more than a threshold number of projects. > > trying some vartions on this... > > select distinct ProjID > from ProjectDocuments > where Count(DocID) > '3' > > Can this be done in a single query? Becomes: select ProjID from ProjectDocuments GROUP BY ProjID HAVING Count(*) > 3 <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From jdillon at boehm-ritter.com Mon May 9 18:23:05 2005 From: jdillon at boehm-ritter.com (Jonathan Dillon) Date: Mon, 9 May 2005 16:23:05 -0700 Subject: [thelist] Simple table question... In-Reply-To: Message-ID: <20050509223810.F1BDC518827@mx1.nexiderm.com> SELECT DISTINCT(email), firstname, lastname, phone FROM tablename; This is rather retarded, but why would this pull up duplicate emails? I just don't understand. I thought DISTINCT would explicitly be distinct to the column name. Anyone? Jonathan From mwarden at gmail.com Mon May 9 18:31:11 2005 From: mwarden at gmail.com (Matt Warden) Date: Mon, 9 May 2005 19:31:11 -0400 Subject: [thelist] Simple table question... In-Reply-To: <20050509223810.F1BDC518827@mx1.nexiderm.com> References: <20050509223810.F1BDC518827@mx1.nexiderm.com> Message-ID: On 5/9/05, Jonathan Dillon wrote: > SELECT DISTINCT(email), firstname, lastname, phone FROM tablename; > > This is rather retarded, but why would this pull up duplicate emails? I > just don't understand. I thought DISTINCT would explicitly be distinct to > the column name. What is it to do with the following data? joe at blow.com Joe Blow 555-555-5555 joe at blow.com Joe Blow 555-555-5556 What row is it supposed to return? The reality is that every unique *combination* of fields listed after the DISTINCT keyword will be returned. -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From jdillon at boehm-ritter.com Mon May 9 19:03:30 2005 From: jdillon at boehm-ritter.com (Jonathan Dillon) Date: Mon, 9 May 2005 17:03:30 -0700 Subject: [thelist] Simple table question... In-Reply-To: Message-ID: <20050509231836.76B6A51864F@mx1.nexiderm.com> >On 5/9/05, Jonathan Dillon wrote: >> SELECT DISTINCT(email), firstname, lastname, phone FROM tablename; >> >> This is rather retarded, but why would this pull up duplicate emails? >> I just don't understand. I thought DISTINCT would explicitly be >> distinct to the column name. > >What is it to do with the following data? > >joe at blow.com Joe Blow 555-555-5555 >joe at blow.com Joe Blow 555-555-5556 > >What row is it supposed to return? > >The reality is that every unique *combination* of fields listed after the DISTINCT keyword will be returned. Matt: Doh! Yea, that's exactly what the data is doing. So, would changing the order help? SELECT firstname, lastname, phone, DISTINCT(email) FROM tablename; How do you get around this seemingly simple problem? I've got about 15% too many records! I need records distinctly keyed off their emails... ;-) Thanks for the reply, Jonathan From mwarden at gmail.com Mon May 9 19:20:23 2005 From: mwarden at gmail.com (Matt Warden) Date: Mon, 9 May 2005 20:20:23 -0400 Subject: [thelist] Simple table question... In-Reply-To: References: <20050509231836.76B6A51864F@mx1.nexiderm.com> Message-ID: On 5/9/05, Jonathan Dillon wrote: > >On 5/9/05, Jonathan Dillon wrote: > >> SELECT DISTINCT(email), firstname, lastname, phone FROM tablename; > >> > >> This is rather retarded, but why would this pull up duplicate emails? > >> I just don't understand. I thought DISTINCT would explicitly be > >> distinct to the column name. > > > >What is it to do with the following data? > > > >joe at blow.com Joe Blow 555-555-5555 > >joe at blow.com Joe Blow 555-555-5556 > > > >What row is it supposed to return? > > > >The reality is that every unique *combination* of fields listed after the > DISTINCT keyword will be returned. > > Matt: > > Doh! > > Yea, that's exactly what the data is doing. So, would changing the order > help? > > SELECT firstname, lastname, phone, DISTINCT(email) FROM tablename; Did you try it? I suspect this does not work (you may even get a syntax error). The database still will not know what to do with "duplicate" rows. > How do you get around this seemingly simple problem? I've got about 15% too > many records! I need records distinctly keyed off their emails... ;-) Then you should clean out the bad data and put a unique constraint on the email column so this can't happen in the future. Even if you were to find a solution that gives you unique emails, your data is going to be bad (see example I provided and assume that one of those phone numbers is not accurate). -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From Ed at ComSimplicity.com Mon May 9 19:27:40 2005 From: Ed at ComSimplicity.com (Ed McCarroll) Date: Mon, 9 May 2005 17:27:40 -0700 Subject: [thelist] Simple table question... In-Reply-To: <20050509231836.76B6A51864F@mx1.nexiderm.com> Message-ID: <00f201c554f7$154cb0d0$650000c8@ednais> > How do you get around this seemingly simple problem? I've got about > 15% too many records! I need records distinctly keyed off their emails. Then don't select any other fields that might duplicate. In the case below, don't select the SSN. > >What is it to do with the following data? > > > >joe at blow.com Joe Blow 555-555-5555 > >joe at blow.com Joe Blow 555-555-5556 ---------------------------------------------------------------------- Ed McCarroll EdMcCarr at CDrewU.edu IS Programmer/Analyst (323) 357-3431 From Ken at adOpenStatic.com Mon May 9 19:27:54 2005 From: Ken at adOpenStatic.com (Ken Schaefer) Date: Tue, 10 May 2005 10:27:54 +1000 Subject: [thelist] Simple table question... Message-ID: <160489103479AB4892187638EE7D1E6914BA83@kjserver1.kjhome.local> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Jonathan Dillon : Subject: RE: [thelist] Simple table question... : : >On 5/9/05, Jonathan Dillon wrote: : >> SELECT DISTINCT(email), firstname, lastname, phone FROM tablename; : >> : >> This is rather retarded, but why would this pull up duplicate emails? : >> I just don't understand. I thought DISTINCT would explicitly be : >> distinct to the column name. : > : >What is it to do with the following data? : > : >joe at blow.com Joe Blow 555-555-5555 : >joe at blow.com Joe Blow 555-555-5556 : > : >What row is it supposed to return? : > : >The reality is that every unique *combination* of fields listed after the : DISTINCT keyword will be returned. : : Matt: : : Doh! : : Yea, that's exactly what the data is doing. So, would changing the order : help? : : SELECT firstname, lastname, phone, DISTINCT(email) FROM tablename; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Not really ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : How do you get around this seemingly simple problem? I've got about 15% : too many records! I need records distinctly keyed : off their emails... ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ You need to answer the following question. Given the following data, what should be returned by your query? joe at blow.com Joe Blow 555-555-5555 joe at blow.com Joe Blow 555-555-5556 When you answer that question, we can give you a query that meets your needs. Cheers Ken From technique at oceanicsky.com Mon May 9 19:36:48 2005 From: technique at oceanicsky.com (David Siedband) Date: Mon, 9 May 2005 17:36:48 -0700 Subject: [thelist] still images to a movie in flash In-Reply-To: References: Message-ID: If you have access to a mac, iPhoto makes it really easy to export a set of photos to a slideshow along with music, that you can save to a .mov file. Select the photos into an album, put them in the order you want, select the song you want from iTunes and and the display time for each slide. You can even do some math to figure out how long to show each slide for so it exactly matches the length of your song. If you can't find out the resolution of the projector you'll be using, I would suggest making one at 800x600 and one at 1024x768. Less control over presentation than Flash, but it possibly a lot faster to produce. -- David On May 9, 2005, at 9:57 AM, Dan McCullough wrote: > Doing about a 3 minute "inspirational" movie, mostly with still images > and music. I pretty much have settled on Flash as the creation > software since it offers the most in terms of flexibilty with the > creative presentation. > > There are some question since this is not something I have done before > and it is definatly not something I know a lot about. > > Does anyone have other software suggestions? PowerPoint has been > squashed, we not going to even consider PowerPoint. > This will be shown in an auditorium so does anyone have gotchas or > comments about using Flash for presenting in a large room, knowing > that most of the display will be about the projection equiptment, but > is there a good resolution to create the movie in, or canvas size? > Any other thoughts or comments? > -- From jdillon at boehm-ritter.com Mon May 9 20:07:27 2005 From: jdillon at boehm-ritter.com (Jonathan Dillon) Date: Mon, 9 May 2005 18:07:27 -0700 Subject: [thelist] Simple table question... In-Reply-To: <160489103479AB4892187638EE7D1E6914BA83@kjserver1.kjhome.local> Message-ID: <20050510002233.A5D625185BC@mx1.nexiderm.com> > You need to answer the following question. Given the following data, what should be returned by your query? > > joe at blow.com Joe Blow 555-555-5555 > joe at blow.com Joe Blow 555-555-5556 This actually finally clicked. Look, in relation to the question of proper architecture, this is a really bad table. BAD table no donut. Didn't architect, can't change, as a lot of recurring transactions come off this table. Soooo... I'm screwed. I've never worked on a db with this kind of flat architecture before (which is probably why I've never seen this). It's retarded, like I said. ;-) Thanks for taking the time to explain. J From Ken at adOpenStatic.com Mon May 9 20:40:07 2005 From: Ken at adOpenStatic.com (Ken Schaefer) Date: Tue, 10 May 2005 11:40:07 +1000 Subject: [thelist] Simple table question... Message-ID: <160489103479AB4892187638EE7D1E6914BA89@kjserver1.kjhome.local> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Jonathan Dillon : Subject: RE: [thelist] Simple table question... : : : > You need to answer the following question. Given the following data, : > what should be returned by your query? : > : > joe at blow.com Joe Blow 555-555-5555 : > joe at blow.com Joe Blow 555-555-5556 : : This actually finally clicked. : : Look, in relation to the question of proper architecture, this is : a really bad table. BAD table no donut. Didn't architect, : can't change, as a lot of recurring transactions come off : this table. : : Soooo... I'm screwed. I've never worked on a db with this kind of flat : architecture before (which is probably why I've never seen this). It's : retarded, like I said. ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I don't think there's anything wrong with the table structure per se (given what you've told us). What you probably needed was better constraints on entering data in the first place (e.g. a unique constraint on the email address, or a unique constraint on email + name + phone number). But, if you want to clean this up, and you can write a rule base (e.g. we are going to select the first phone number when sorted alphanumerically and discard the rest) then we can write a query to do this for you. If you can't determine the rule base in advance you're going to have to go through the data manually and make ad hoc decisions about each set of duplicate data. HTH Cheers Ken -- www.adOpenStatic.com/cs/blogs/ken/ From justin at jazzmanagement.com.au Mon May 9 21:11:53 2005 From: justin at jazzmanagement.com.au (Justin Zachan Mgmt) Date: Tue, 10 May 2005 12:11:53 +1000 Subject: [thelist] Print job not going quite right Message-ID: Hey there. We have designed a brochure which we organised/managed the offset printing for the client. The job was a lot bigger type of job than we normally give to our printer. The end result has a number of faults, which are not acceptable (in my view). The print job is passable but what I thought would be a portfolio piece is now something I would not want to show to anyone. Due to the tight timeframes/deadlines my client has had to accept the final product i.e. no time for a reprint. The printers have really tried to sneak this by without any honesty i.e. "don't tell the client and hopefully she won't notice." Not our approach to business. Our work agreement does not have any specific penalty clauses (unfortunately), but I think the printer should offer compensation (that I can pass on to the client) for a pretty poor job on the quality control front. I would have demanded a reprint if time allowed. So I guess the questions are; -How should I handle this? -What should I expect from the printer? -Are we legally allowed to withhold some of the payment? I will not use this printer again (been using them for 2 years), but I want to do everything possible to hopefully keep our biggest client. Any help would be appreciated. Cheers Justin From dcsquare at myrealbox.com Tue May 10 01:50:51 2005 From: dcsquare at myrealbox.com (Dan CRACIUN) Date: Tue, 10 May 2005 09:50:51 +0300 Subject: [thelist] Print job not going quite right Message-ID: <428059CB.50000@myrealbox.com> Justin Zachan Mgmt wrote: >Hey there. We have designed a brochure which we organised/managed the offset >printing for the client. The job was a lot bigger type of job than we >normally give to our printer. > >The end result has a number of faults, which are not acceptable (in my >view). The print job is passable but what I thought would be a portfolio >piece is now something I would not want to show to anyone. > >Due to the tight timeframes/deadlines my client has had to accept the final >product i.e. no time for a reprint. The printers have really tried to sneak >this by without any honesty i.e. "don't tell the client and hopefully she >won't notice." Not our approach to business. > >Our work agreement does not have any specific penalty clauses >(unfortunately), but I think the printer should offer compensation (that I >can pass on to the client) for a pretty poor job on the quality control >front. I would have demanded a reprint if time allowed. > >So I guess the questions are; >-How should I handle this? >-What should I expect from the printer? >-Are we legally allowed to withhold some of the payment? > > > Unfortunately this type of situation do occur. The best approach is to not work on a very tight deadline, but that's not allways possible. Here's how I work with the printers: I allways ask for a matchprint and state in the contract that if the end result does not accurately match that the whole order will be refused. This usually makes the printer very carefull about the quality. As a side note, people that work in the printer's night shift are usually "don't drink and drive" walking ads (at least in my experience) so if you're unlucky enough to have your order printed on someone's birthday then you're in for big surprises. If you accepted the order, even faulty (as you said you did) then legally you have to pay your printer. But you can delay that payment due to "reasonable causes", or better pay in small amounts over the next 6-8 months. That and refusing to work with them again is the only legal way I know. Cheers, Dan CRACIUN From thelist at meidomus.com Tue May 10 02:14:50 2005 From: thelist at meidomus.com (Burhan Khalid) Date: Tue, 10 May 2005 10:14:50 +0300 Subject: [thelist] date selection and mysql and PHP In-Reply-To: <427FA9C7.6070409@getafixx.com> References: <427FA9C7.6070409@getafixx.com> Message-ID: <42805F6A.4080008@meidomus.com> Getafixx wrote: > OK I am working on a simple calender (OK I know it's pretty dull stuff) > > My questions are - I am storing the date and the timing of an event with > DATETIME, which seams to work OK. > > I have been trying to craft a search to get ONLY the events on the day > in question.. The only way I could do that and it was a big hack was to > use this query, where I have to arse around with figuring out what the > next day is and go from the correct day to the next day... > > SELECT * FROM `events` WHERE `date_time` BETWEEN "20050509" AND > "20050510" ORDER BY "20050509" I can't believe this query works on a DATETIME type field, because the format of that field is '0000-00-00 00:00:00' You can check the different date and time types in the manual to see their default format by checking the "zero" value. [ snipped ] > Maybe my question is why can't I just say where date row = > where I try and match just the first part of the date with the first > part of any dates in the table > > SELECT * FROM `my_table` WHERE `date_time` = "20050509" > > but this doesnt seam to work... SELECT `col`, `col2` FROM `my_table` WHERE DATE_FORMAT('%Y%m%d',`date_time`) = '20050509'; > Also on reading the db for a months worth of dates, would it be better > to do one query for the whole month and then parse it up, or lots of > small queries, for each day? I'm not a database guru -- but I believe that many small select queries, not one large complicated one are generally faster. The speed depends on many other factors, such as your table size, the type of query, indices on the table, etc. In your case, I don't think it will matter that much. From michele at wizardev.ca Tue May 10 02:21:21 2005 From: michele at wizardev.ca (Michele Foster (WizarDev)) Date: Tue, 10 May 2005 03:21:21 -0400 Subject: [thelist] Monthly Counts in order Message-ID: <012c01c55530$df16c610$47699c84@mef> Another SQL question ... SELECT Month(RefDate) as MyMonth, Year(RefDate) as MyYear, COUNT (Month(RefDate)) AS MonthlyTotal FROM ext_Refs GROUP BY Month(RefDate), Year(RefDate) This is giving me the correct totals for the month .. October 2004 = 32 January 2005 = 158 May 2004 = 44 However, I need the output in chronological order (May 2005 first). Can't seem to get an ORDER BY to work .. and still give me the monthly totals. If I add the ORDER BY to the end, after the GROUP BY, I get this error: Column name 'ext_Refs.RefDate' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause. If I add RefDate to the GROUP BY clause, gets rid of the above error, but I no longer get monthly totals, but daily totals instead. I'm stumped ... perhaps because it's after 3:00 a.m. ;) Thanks, Mich From bclark at eccotours.dyndns.org Tue May 10 04:55:49 2005 From: bclark at eccotours.dyndns.org (Brent Clark) Date: Tue, 10 May 2005 11:55:49 +0200 Subject: [thelist] javascript help please Message-ID: <42808525.9040404@eccotours.dyndns.org> Hi all My deepest apologies for posting here, but im so stuck with Javascript at the moment. I have a index.html file when on loading executes a javascript function (random_mainpage() ). which reads the array (sarray) and displays in content on the browser. I to have a link that onclicking must execute (pframe(number)) with the argument of the number, which in the element of the sarray. The problem is that onclicking the link the pframe() executes but does not display the content in the same place as where the random_mainpage() displays its content. Also the problem is the images that must be displayed, dont get displayed (think its a cache issuse, can this be forces to be displayed.) Im sure that since this thread had nothing to do with this mailing list that most others would appreciate that it be taken of the list, taken in a of the list manner. If anyone would be so kind as to help, it would be greatly be appreciated. Kind Regards Brent Clark P.s. if someone wants to see a demo of what im trying to do, please contact me off the list. ======================== My array ======================== var sarray = new Array(); sarray[1] = new Array(); to sarray[21] = new Array(); sarray[1][0] = ''; sarray[1][1] = ''; TO sarray[1][23] = ''; sarray[1][24] = '
  Cape Town
'; ======================= My javascript function ======================= function pframe(numb){ var MyMap = "/images/index/map_"+numb+".gif"; document['map'].src=MyMap; misc = ""; for(a = 0; a < sarray[numb].length; a++){ misc += (sarray[numb][a]); } //alert(misc); document.getElementById('mainpage').innerHTML = ""; document.getElementById('mainpage').innerHTML = misc; document['pic1'].src="/images/index/"+numb+"-1.jpg"; document['pic2'].src="/images/index/"+numb+"-2.jpg"; document['pic3'].src="/images/index/"+numb+"-3.jpg"; document['pic4'].src="/images/index/"+numb+"-4.jpg"; misc = ""; MyMap = ""; } function random_mainpage(element){ var num = Math.floor( (Math.random() * sarray.length)); if(num < 0){ num + 1; } var MyMap = "/images/index/map_"+num+".gif"; document['map'].src=MyMap; for(a = 0; a < sarray[num].length; a++){ document.write(sarray[num][a]); } } ======================= My html code =======================
From codepo8 at gmail.com Tue May 10 05:33:33 2005 From: codepo8 at gmail.com (Christian Heilmann) Date: Tue, 10 May 2005 11:33:33 +0100 Subject: [thelist] javascript help please In-Reply-To: <42808525.9040404@eccotours.dyndns.org> References: <42808525.9040404@eccotours.dyndns.org> Message-ID: <30bd6ffd05051003331788e867@mail.gmail.com> On 5/10/05, Brent Clark wrote: > Hi all > > My deepest apologies for posting here, but im so stuck with Javascript > at the moment. > > I have a index.html file when on loading executes a javascript function > (random_mainpage() ). which reads the array (sarray) and displays in > content on the browser. I've looked a bit into the problem and considered it just useless to deal with such outdated and obtrusive methods for achieving the effect. You'll make your life a lot easier by starting with a clean version that works without JavaScript: http://www.icant.co.uk/sandbox/maps/example1.php and then enhance it to avoid the need for a reload: http://www.icant.co.uk/sandbox/maps/example2.php and you can get funky and simulate the real experience by removing the links and adding a loading message: http://www.icant.co.uk/sandbox/maps/example3.php This will make your solution accessible to all users and much cleaner to maintain. You are also less likely to bump into caching issues. HTH Chris -- Chris Heilmann Blog: http://www.wait-till-i.com Writing: http://icant.co.uk/ Binaries: http://www.onlinetools.org/ From danieleastwell at onetel.com Tue May 10 06:30:17 2005 From: danieleastwell at onetel.com (Dan Eastwell) Date: Tue, 10 May 2005 12:30:17 +0100 Subject: [thelist] Tip: Fixing IE include external javascript file 'bug' Message-ID: <42809B49.6070702@onetel.com> |Hope it's not been included before, but had trouble googling for it. I'd also like to know the reason why, too, but I'm nowhere near being a script guru, just a hack..! Any ideas? If an included external javascript file causes your HTML to die at the point of the (ignore type attribute so it's the same as #3) 2. (the default one) and 3. (no language attribute so defaults to #2) are all the same, they fall back to (2) eventually. just a few question to clarify things: Are you sure that you've closed your script tag properly? What is your ie version and OS? Is there a url that we can check the problem? Anyways, ie is a peculiar guy, he can do almost anything :) Cheers, Volkan. On 5/10/05, Dan Eastwell wrote: > |Hope it's not been included before, but had trouble googling for it. > I'd also like to know the reason why, too, but I'm nowhere near being a > script guru, just a hack..! Any ideas? > > > If an included external javascript file causes your HTML to die at the > point of the tag, not the language attribute. But thanks, Volkan, for letting me know the nuts and bolts of why IE does what it does. FF seemed to overlook my closing the script tag as (ignore type >attribute so it's the same as #3) > > >2. (the default one) > >and > >3. (no language attribute so defaults to #2) > >are all the same, they fall back to (2) eventually. > >... > >Anyways, ie is a peculiar guy, he can do almost anything :) >... > >On 5/10/05, Dan Eastwell wrote: > > >>|Hope it's not been included before, but had trouble googling for it. >>I'd also like to know the reason why, too, but I'm nowhere near being a >>script guru, just a hack..! Any ideas? >> >> >>If an included external javascript file causes your HTML to die at the >>point of the