From harvester at lists.evolt.org Mon Nov 20 00:00:10 2006 From: harvester at lists.evolt.org (harvester at lists.evolt.org) Date: 20 Nov 2006 00:00:10 -0600 Subject: [thelist] Tip Harvest for the Week of Monday Nov 13, 2006 Message-ID: <20061120060010.6156.qmail@tempest.evolt.org> The tip harvest for the Week of Monday Nov 13, 2006 has been added to the lists.evolt.org site. Get it at: http://lists.evolt.org/harvest/show.cgi?w=20061113 Week at a glance listing at: http://lists.evolt.org/harvest/week.cgi?w=20061113 Harvest Summary --------------- Number of messages: 147 Number of tips : 1 Tip Authors ----------- Rob.Smith (1) Tip Types --------- Useful SQL Date Query Freebies (1) ------------------------------------------------------------------------------ What: Tips are how a list subscriber "pays" for making an off-topic post to the list (see List Info for more information). Of course, this does not make off-topic posts acceptable. :) How : You include a tip in your posting by using the [tip]...[/tip] tag (replace the square brackets with angle brackets). The tip tag takes the optional attributes of 'type' and 'author'. From barney at textmatters.com Mon Nov 20 03:56:56 2006 From: barney at textmatters.com (Barney Carroll) Date: Mon, 20 Nov 2006 09:56:56 +0000 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled Message-ID: <45617BE8.8040100@textmatters.com> Hi folks, Just uploaded a big site to external hosting, and as might be expected it now takes a couple of seconds for each page to load instead of instants. This is a huge problem for IE6: I'm using 60Kb's worth of css (yeah, I know), with complex layouts depending on multiple measurement scales and all sorts of inter-div dependency, javascript that replaces markup on load, dozens of images etc. Based on this description you might call it an innately terrible site, but I'm past changing its nature now and I've got to find a fix for the central problem this poses, namely the fact that a pig's ear is made out of the design with IE trying to render before it has fully digested all the code it has to compile. As it stands it renders things in weird layouts before bouncing them into place, images re-load, the whole thing flickers... It's an absolute animated eye-sore. Does anyone know of any simple way to make IE wait til it has fully digested the content before prematurely displaying it? Regards, Barney From jason.handby at corestar.co.uk Mon Nov 20 04:37:41 2006 From: jason.handby at corestar.co.uk (jason.handby) Date: Mon, 20 Nov 2006 10:37:41 -0000 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled In-Reply-To: <45617BE8.8040100@textmatters.com> Message-ID: <9A50776858A21848A96469CDFCBCDEFF389D54@exch-be12.exchange.local> > Does anyone know of any simple way to make IE wait til it has > fully digested the content before prematurely displaying it? It used to be the case that IE would not display the contents of a table until it had reached the closing . So you could try enclosing everything in a table with one cell? Not very CSS though! Alternatively perhaps you could use CSS to set the position of your enclosing div to be way off the page (hence not visible), and then reposition it using Javascript once the page has loaded? Jason From lee.kowalkowski at googlemail.com Mon Nov 20 05:17:21 2006 From: lee.kowalkowski at googlemail.com (Lee kowalkowski) Date: Mon, 20 Nov 2006 11:17:21 +0000 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled In-Reply-To: <45617BE8.8040100@textmatters.com> References: <45617BE8.8040100@textmatters.com> Message-ID: <610592c90611200317pfe309f8wf5ac193ac8044dd1@mail.gmail.com> On 20/11/06, Barney Carroll wrote: > Does anyone know of any simple way to make IE wait til it has fully > digested the content before prematurely displaying it? You could put this in your head element... It has the added bonus of filtering out impatient users too. Think how much you'll save on traffic! -- Lee From julian.rickards at gmail.com Mon Nov 20 06:05:55 2006 From: julian.rickards at gmail.com (Julian Rickards) Date: Mon, 20 Nov 2006 07:05:55 -0500 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled In-Reply-To: <9A50776858A21848A96469CDFCBCDEFF389D54@exch-be12.exchange.local> References: <45617BE8.8040100@textmatters.com> <9A50776858A21848A96469CDFCBCDEFF389D54@exch-be12.exchange.local> Message-ID: <7613e9690611200405r23991045xccf707f04dfb7740@mail.gmail.com> The delay in rendering tables is according to spec which is why if you have multiply-nested tables, it takes so much longer because each nested table must be rendered before the outer table. On 20/11/06, jason.handby wrote: > > > Does anyone know of any simple way to make IE wait til it has > > fully digested the content before prematurely displaying it? > > It used to be the case that IE would not display the contents of a table > until it had reached the closing . So you could try enclosing > everything in a table with one cell? Not very CSS though! > > Alternatively perhaps you could use CSS to set the position of your > enclosing div to be way off the page (hence not visible), and then > reposition it using Javascript once the page has loaded? > > > > Jason > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- Website: http://jrickards.ca Blog: http://pen-and-ink.ca E-mail: julian dot rickards at gmail dot com From gsm_color at yahoo.com Mon Nov 20 07:24:05 2006 From: gsm_color at yahoo.com (Kane Wilson) Date: Mon, 20 Nov 2006 05:24:05 -0800 (PST) Subject: [thelist] apache cgi-bin Message-ID: <20061120132405.91789.qmail@web33408.mail.mud.yahoo.com> hi , How can i change the cgi-bin directory for some other different location in apache ( httpd ) web server ? for example , i wanted to chnage that into /var/www/html/zoo-bin/. Thank you, Kane. ____________________________________________________________________________________ Sponsored Link Mortgage rates near 39yr lows. $310k for $999/mo. Calculate new payment! www.LowerMyBills.com/lre From thomas.nilsson at framfab.com Mon Nov 20 09:11:08 2006 From: thomas.nilsson at framfab.com (Thomas Nilsson) Date: Mon, 20 Nov 2006 16:11:08 +0100 Subject: [thelist] IE JavaScript issues? In-Reply-To: <455D6658.6050809@zimmer428.net> Message-ID: >-----Original Message----- >From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] >On Behalf Of Kristian Rink >Sent: den 17 november 2006 08:36 >To: thelist at lists.evolt.org >Subject: Re: [thelist] IE JavaScript issues? > > >When attaching the JavaScript debugger, I can see the MSIE complains about > > > hint = document.getElementById("hint"); > > >... why on earth? Testbed environment so far is MSIE 6.0, and according to the manual I use >(selfhtml ...), getElementById() should be perfect for post-5.5 IE's. Or am I wrong on that? --- (My mail server seems to have lost some recent messages, so this might have been answered already. In that case, my apologies) --- In Internet Explorer, "hint" is itself a reference to the element, another (older and IE only) way of accessing elements. The code in your example is trying to assign an element as a value to itself. It's easily fixed by using another variable name, e.g. elmHint = document.getElementById("hint"); /Thomas From lee.kowalkowski at googlemail.com Mon Nov 20 10:11:13 2006 From: lee.kowalkowski at googlemail.com (Lee kowalkowski) Date: Mon, 20 Nov 2006 16:11:13 +0000 Subject: [thelist] IE JavaScript issues? In-Reply-To: References: <455D6658.6050809@zimmer428.net> Message-ID: <610592c90611200811l5198e6d1i6a5d07ee2a7dc33b@mail.gmail.com> On 20/11/06, Thomas Nilsson wrote: > > hint = document.getElementById("hint"); > > In Internet Explorer, "hint" is itself a reference to the element, > another (older and IE only) way of accessing elements. > > It's easily fixed by using another variable name, e.g. > > elmHint = document.getElementById("hint"); Well spotted! Perhaps better to just restrict the scope of the variable in the first place: var hint = document.getElementById("hint"); // works a treat. Although it's sometimes preferable to use a naming convention like hintElement, hintDiv or whatever in more complicated scripts. -- Lee From anthony at baratta.com Mon Nov 20 10:36:43 2006 From: anthony at baratta.com (Anthony Baratta) Date: Mon, 20 Nov 2006 08:36:43 -0800 Subject: [thelist] apache cgi-bin Message-ID: <4889b4107cf979cf5c6aabebcf5cd357@baratta.com> http://httpd.apache.org/docs/2.2/howto/cgi.html -----Original message----- From: Kane Wilson gsm_color at yahoo.com Date: Mon, 20 Nov 2006 05:24:05 -0800 To: Evolt thelist at lists.evolt.org Subject: [thelist] apache cgi-bin > hi , > > How can i change the cgi-bin directory for some other different location in apache ( httpd ) web server ? > for example , i wanted to chnage that into /var/www/html/zoo-bin/. > > Thank you, > Kane. > > > > > > ____________________________________________________________________________________ > Sponsored Link > > Mortgage rates near 39yr lows. > $310k for $999/mo. Calculate new payment! > www.LowerMyBills.com/lre > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From volkan.ozcelik at gmail.com Mon Nov 20 10:39:41 2006 From: volkan.ozcelik at gmail.com (=?ISO-8859-9?Q?VOLKAN_=D6Z=C7EL=DDK?=) Date: Mon, 20 Nov 2006 18:39:41 +0200 Subject: [thelist] how to add favicon to favelets In-Reply-To: References: <610592c90611170302ke4b1d24xfcd032f13d1203fc@mail.gmail.com> Message-ID: Thank you guys (and gals) for sharing your insights. I've have not found a solution yet but the question is pondering in my brain as a background mental process. I'll share with you, it if I find a sensible way to achive it. Cheers, -- Volkan Ozcelik +>Yep! I'm blogging! : http://www.volkanozcelik.com/cre8/blog/ +> Going solo in Turkish: http://www.volkanozcelik.com/donkisot/ +> My projects/studies/trials/errors : http://www.sarmal.com/ +> Sardalya JavaScript Library: http://www.sarmal.com/sardalya/ From jslist at sbcglobal.net Mon Nov 20 12:10:56 2006 From: jslist at sbcglobal.net (j s) Date: Mon, 20 Nov 2006 10:10:56 -0800 (PST) Subject: [thelist] Not Printing 1st 3 Characters Message-ID: <20061120181056.34681.qmail@web81006.mail.mud.yahoo.com> Hello, There's a simple asp page. A field, in a form, is called from the previous page and is displayed on the screen. Here's the code: <%=request.form("Vine")%>  The complete field displays on the screen. When 1 particular user goes to print the page the first 3 characters of this field do not print. Other users can print it fine. Any ideas? I'm stumped. From anthony at baratta.com Mon Nov 20 12:35:21 2006 From: anthony at baratta.com (Anthony Baratta) Date: Mon, 20 Nov 2006 10:35:21 -0800 Subject: [thelist] Not Printing 1st 3 Characters Message-ID: Check the printer margin settings for the browser on the affected user's PC. -----Original message----- From: j s jslist at sbcglobal.net Date: Mon, 20 Nov 2006 10:10:56 -0800 To: thelist at lists.evolt.org Subject: [thelist] Not Printing 1st 3 Characters > Hello, > > There's a simple asp page. A field, in a form, is called from the previous page and is displayed on the screen. > Here's the code: > <%=request.form("Vine")%>  > > The complete field displays on the screen. When 1 particular user goes to print the page the first 3 characters of this field do not print. Other users can print it fine. > > Any ideas? I'm stumped. > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From hershel at galleryrobinson.com Mon Nov 20 13:01:01 2006 From: hershel at galleryrobinson.com (Hershel Robinson) Date: Mon, 20 Nov 2006 21:01:01 +0200 Subject: [thelist] Windows Dedicated or VPS Message-ID: <4561FB6D.7030707@galleryrobinson.com> I need a Windows dedicated server or VPS for 2 or 3 months. We have a project we need to do to transfer data between MySQL and QuickBooks and we have located this tool: QODBC Web Server Edition ( http://www.qodbc.com/QODBCweb.htm ) which appears to suit our needs. We will only need it for a few months tops, to finalize the code and perform the transfer. I have found one host: webserve.ca that seems feasible, but their rates for installation work are a big high, so we wanted to keep looking a bit. There is a bit of installation and configuration involved in getting this QODBC tool to work. :) Any ideas appreciated. Thanks, Hershel -- Web Site Construction by Gallery Robinson http://galleryrobinson.com/ From evolt at markgroen.com Mon Nov 20 13:44:57 2006 From: evolt at markgroen.com (Mark Groen) Date: Mon, 20 Nov 2006 11:44:57 -0800 Subject: [thelist] Windows Dedicated or VPS In-Reply-To: <4561FB6D.7030707@galleryrobinson.com> References: <4561FB6D.7030707@galleryrobinson.com> Message-ID: <1164051897.12110.11.camel@localhost.localdomain> On Mon, 2006-11-20 at 21:01 +0200, Hershel Robinson wrote: > I need a Windows dedicated server or VPS for 2 or 3 months. We have a > project we need to do to transfer data between MySQL and QuickBooks and > we have located this tool: > > QODBC Web Server Edition ( http://www.qodbc.com/QODBCweb.htm ) > > which appears to suit our needs. We will only need it for a few months > tops, to finalize the code and perform the transfer. I have found one host: > > webserve.ca Stay far, far away from that company. Here's my experience with them. My client had a brochure-ware site with them that he never monitored or really even used, but as it had sat there for a few years it was a company name he was familiar with and so created a new account for the launch of a new domain that was destined to be much more active. The user name they sent us with the IP address for Cpanel returned a 404 error and we were unable to access Cpanel. No problem I thought, someone just made a typo and some time later we had a new account with a different user name that worked. Next day I started uploading files, the first batch was for an administrative function that doesn't have ANY sensitive information what so ever, but is nevertheless secure for it's own sake. Logged into Cpanel and created the database for it, then went back to the local config file to adjust the parameters to match and uploaded the new copy. The config file is safe on it's own in it's own directory, but I wanted to protect the folder itself and went back to Cpanel again to do that. That's when the fun started, upon logging in, a virus laden WMF file wanted to download along with a javascript file that I'm guessing was the front end for a key logger script. These were being called from within Cpanel and were trying to contact a Russian hack server, unless someone can tell me differently it would appear that at the very least this virtual space had been hacked. I put a support ticket in with the subject line "rootkit found", thinking that was sure to catch someone's eye. After about three hours, I checked Cpanel and the thing was still running, so used the Live Chat to try to get an ETA. Was assured the problem was being looked at and would be fixed soon. It's the next day, and they still haven't got back to me but a little over 12 hours after the problem was discovered by me, they did send an email to the client: "Hello. At this point in time we are planning an urgent server rebuild to eliminate recent technical problems we have encountered with the server ns38.servepower.com. This should take place within the next few days during the late evening to early morning hours (10 PM to 7 AM PST). Sorry but an exact date has not been determined as of yet. " "If at all possible, please avoid making changes to your site over the next few days. Also, we would like stress the importance of using virus scanners and other forms of security on any computers you regularly use to connect to this server, and that it is important to choose a complicated password for your account. Thank you for your patience in this matter. We apologize for the short notice and any inconvenience the technical problems have caused for you. " The two phrases that stick out for me are the warning to use a virus scanner, thought this vulnerability had a patch for it out for some time now.... then "choose a complicated password", the one they sent was in the same clear text email as the user name, and consisted of real English words, all in small case and no warning to change the password to something more secure. As well, instead of working around the problem of some ISP's blocking port 25 for relayed outbound email by setting both 25 and 26 to accept at the domain mail server, the instructions for email had this, "you will NOT be able to use your SMTP server listed above to send mail if you are using one of the following ISP for your internet access: Telus, Rogers, Sympatico etc ... " which as already mentioned above, is not quite correct. Tons of horror stories about them on webhostingtalk.com. -- cheers, Mark From hershel at galleryrobinson.com Mon Nov 20 14:00:11 2006 From: hershel at galleryrobinson.com (Hershel Robinson) Date: Mon, 20 Nov 2006 22:00:11 +0200 Subject: [thelist] Windows Dedicated or VPS In-Reply-To: <1164051897.12110.11.camel@localhost.localdomain> References: <4561FB6D.7030707@galleryrobinson.com> <1164051897.12110.11.camel@localhost.localdomain> Message-ID: <4562094B.2030003@galleryrobinson.com> >> webserve.ca > > Stay far, far away from that company. > Tons of horror stories about them on webhostingtalk.com. Wow. Thanks. I will definitely put in a bit more research then. :) Thanks, Hershel -- Web Site Construction by Gallery Robinson http://galleryrobinson.com/ From peter at easylistbox.com Mon Nov 20 12:59:45 2006 From: peter at easylistbox.com (Peter Brunone (EasyListBox.com)) Date: Mon, 20 Nov 2006 11:59:45 -0700 Subject: [thelist] Not Printing 1st 3 Characters Message-ID: <06e556ca8db647ecb2e0b7fb4b551768@easylistbox.com> Where is the field in the page? Can we see the output? If it's near the left side, there could be a margin issue. Is the user on a different browser from most, or are the regional settings different? Has this user had problems printing anything else? Just shooting in the dark here... Peter From: j s jslist at sbcglobal.net Hello, There's a simple asp page. A field, in a form, is called from the previous page and is displayed on the screen. Here's the code: ]]> The complete field displays on the screen. When 1 particular user goes to print the page the first 3 characters of this field do not print. Other users can print it fine. Any ideas? I'm stumped. From skellos at skellos.com Mon Nov 20 14:37:47 2006 From: skellos at skellos.com (Skellos) Date: Mon, 20 Nov 2006 15:37:47 -0500 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled In-Reply-To: <45617BE8.8040100@textmatters.com> References: <45617BE8.8040100@textmatters.com> Message-ID: <0J910044LURBWM41@VL-MH-MR001.ip.videotron.ca> Hi Barney, I think using to fix your problem might not be such a good solution. Browser such as Firefox will display the content of your table before it finds the bracket. Here are a few possibilities that might do the job for you, 1) If you have a flash movie of some kind (if not, maybe create a small one) that requires a few seconds to load with a loading sequence, you should use it as an opening page and have your page load all your CSS and most of your images in cache at the same time so IE can then use the cache to display your page faster once the movie has been loaded and displayed. 2) You can set 'Invisible' the things you wish not to be displayed right away. Using the StyleDisplay : none. And at the end of your page, after it load, or in your body, you can use a timer-set delay Javascript action that will switch those invisible to visible. Or, use Lee's code as he suggested which makes everything invisible until the page is finished loading. ------- Skellos CEO Skellos corp. www.skellos.com www.camarillamontreal.com www.draconiens.com www.skullfire.info ------- At 04:56 AM 20/11/2006, you wrote: >Hi folks, > >Just uploaded a big site to external hosting, and as might be expected >it now takes a couple of seconds for each page to load instead of instants. > >This is a huge problem for IE6: I'm using 60Kb's worth of css (yeah, I >know), with complex layouts depending on multiple measurement scales and >all sorts of inter-div dependency, javascript that replaces markup on >load, dozens of images etc. Based on this description you might call it >an innately terrible site, but I'm past changing its nature now and I've >got to find a fix for the central problem this poses, namely the fact >that a pig's ear is made out of the design with IE trying to render >before it has fully digested all the code it has to compile. > >As it stands it renders things in weird layouts before bouncing them >into place, images re-load, the whole thing flickers... It's an absolute >animated eye-sore. > >Does anyone know of any simple way to make IE wait til it has fully >digested the content before prematurely displaying it? > >Regards, >Barney >-- > >* * Please support the community that supports you. * * >http://evolt.org/help_support_evolt/ > >For unsubscribe and other options, including the Tip Harvester >and archives of thelist go to: http://lists.evolt.org >Workers of the Web, evolt ! From mwarden at gmail.com Mon Nov 20 16:28:10 2006 From: mwarden at gmail.com (Matt Warden) Date: Mon, 20 Nov 2006 17:28:10 -0500 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled In-Reply-To: <0J910044LURBWM41@VL-MH-MR001.ip.videotron.ca> References: <45617BE8.8040100@textmatters.com> <0J910044LURBWM41@VL-MH-MR001.ip.videotron.ca> Message-ID: On 11/20/06, Skellos wrote: > 2) You can set 'Invisible' the things you wish not to be displayed > right away. Using the StyleDisplay : none. And at the end of your > page, after it load, or in your body, you can use a timer-set delay > Javascript action that will switch those invisible to visible. > Or, use Lee's code as he suggested which makes everything invisible > until the page is finished loading. ... which would make even the most basic of brochureware websites completely useless to anyone without JavaScript turned on. All this just to avoid a flicker? Well, let's be honest -- what we're really trying to avoid is a redesign. The OP even said it in his post: "Based on this description you might call it an innately terrible site, but I'm past changing its nature now..." So, if that's our constraint, then I guess we're left with hacks that attack symptoms and not the cause. If you refuse to clean up your 60 kb of css, then the *least* you can do is minify the production file and configure the server to send it gzipped. Same with your external javascript files (you can even automate most of this process with jslint and then jsmin). Also, if you are referencing multiple external JS and CSS files, concatenate them in a sensible way (keeping in mind the overhead each file request adds and balancing that with what makes sense from a caching perspective). And, stop using window.onload to fire JavaScript events that dont need to wait for the entire page to load (99.9% of them fall into this category). That's about all you can do. The solutions which completely destroy accessibility aren't really valid options. What you really need is a redesign. -- Matt Warden Cleveland, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From lee.kowalkowski at googlemail.com Mon Nov 20 17:53:20 2006 From: lee.kowalkowski at googlemail.com (Lee kowalkowski) Date: Mon, 20 Nov 2006 23:53:20 +0000 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled In-Reply-To: References: <45617BE8.8040100@textmatters.com> <0J910044LURBWM41@VL-MH-MR001.ip.videotron.ca> Message-ID: <610592c90611201553y1714700cqc95e52712c4d87b3@mail.gmail.com> On 20/11/06, Matt Warden wrote: > So, if that's our constraint, then I guess we're left with hacks that > attack symptoms and not the cause. > > If you refuse to clean up your 60 kb of css, then the *least* you can > do is minify the production file and configure the server to send it > gzipped. I reckon as the web moves to CSS based layout, larger CSS files are a safe bet. Perhaps not 60kb mind. > And, stop using window.onload to fire JavaScript events > that dont need to wait for the entire page to load (99.9% of them fall > into this category). That's gonna help more than minifying. Minifying just means you need a quicker eye to see the animated eyesore. Setting the width and height attributes on image elements might also help. -- Lee From bedouglas at earthlink.net Mon Nov 20 17:54:54 2006 From: bedouglas at earthlink.net (bruce) Date: Mon, 20 Nov 2006 15:54:54 -0800 Subject: [thelist] adsense/seo information requested.. Message-ID: <279801c70cff$486d60b0$0301a8c0@tmesa.com> hi. forgive me if this is off the topic of the list. i'm trying to find out if there's a im/irc list (or lists) where you have serious/good real time conversations going on regarding SEO issues, like adsense, etc... i've seen lots of websites, some with forums. but i haven't run across anything that gives real-time/ongoing conversations regarding the biz of advertising online. any info would be appreciated thanks From santilal at scorpioneng.co.nz Mon Nov 20 18:37:02 2006 From: santilal at scorpioneng.co.nz (Santilal Parbhu) Date: Tue, 21 Nov 2006 13:37:02 +1300 Subject: [thelist] (no subject) Message-ID: Hi I am developing a web-based sports draw application using PHP and MYSQL. After making a draw, I want to allocate times and courts. When making an allocation I want to display a drop down list showing only the available time/court combinations, i.e. only those that remain unallocated. This is easy enough when the page is first served, but I want to try to keep track in the browser window of the allocations made and those still available. This is because the way someone would typically use this is that they would display all of the draw, and allocated times and courts while viewing the complete page. They might choose to enter all of the time/court details, or they might do some and come back later to do some more. When the allocations have been made and the form is uploaded, the allocations would be entered into the database. The next time this page is displayed, the updated data would be displayed and the user could then continue to allocated any matched not yet allocated. Again only the available time/court combinations would be shown. I have never used Javascript, but is this what I would need to use. Thanks Santilal From Paul.Bennett at wcc.govt.nz Mon Nov 20 18:58:37 2006 From: Paul.Bennett at wcc.govt.nz (Paul Bennett) Date: Tue, 21 Nov 2006 13:58:37 +1300 Subject: [thelist] (no subject) Message-ID: Hi Santilal, It looks like PHP's session handling would be the best bet: http://nz.php.net/session You could keep track of what the user has done via the $_SESSION array and update the database if need be... Paul From santilal at scorpioneng.co.nz Mon Nov 20 20:45:16 2006 From: santilal at scorpioneng.co.nz (Santilal Parbhu) Date: Tue, 21 Nov 2006 15:45:16 +1300 Subject: [thelist] (no subject) In-Reply-To: Message-ID: Thanks Paul, I will look into it. It will probably take me a few months as this is a hobby project more than anything else. Cheers Santilal -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Paul Bennett Sent: Tuesday, 21 November 2006 1:59 p.m. To: thelist at lists.evolt.org Subject: Re: [thelist] (no subject) Hi Santilal, It looks like PHP's session handling would be the best bet: http://nz.php.net/session You could keep track of what the user has done via the $_SESSION array and update the database if need be... Paul -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From gsm_color at yahoo.com Mon Nov 20 23:24:32 2006 From: gsm_color at yahoo.com (Kane Wilson) Date: Mon, 20 Nov 2006 21:24:32 -0800 (PST) Subject: [thelist] php extension Message-ID: <20061121052432.96936.qmail@web33402.mail.mud.yahoo.com> Hi , Generally , when we hosting php in apache , we need to host that files as *.php, php3....etc ( php extension ). Is it possible to put that files with different extensions ? (like hello.xyz) If it is possible , how ? can i find a proper guide on for apache web server ? Thank you, Kane. ____________________________________________________________________________________ Sponsored Link Compare mortgage rates for today. Get up to 5 free quotes. www2.nextag.com From anthony at baratta.com Mon Nov 20 23:38:09 2006 From: anthony at baratta.com (Anthony Baratta) Date: Mon, 20 Nov 2006 21:38:09 -0800 Subject: [thelist] php extension In-Reply-To: <20061121052432.96936.qmail@web33402.mail.mud.yahoo.com> References: <20061121052432.96936.qmail@web33402.mail.mud.yahoo.com> Message-ID: <456290C1.60805@baratta.com> http://us3.php.net/manual/en/security.hiding.php Kane Wilson wrote: > Hi , > > Generally , when we hosting php in apache , we need to host that files as *.php, php3....etc ( php extension ). Is it possible to put that files with different extensions ? (like hello.xyz) > If it is possible , how ? can i find a proper guide on for apache web server ? > > Thank you, > Kane. > > > > > > ____________________________________________________________________________________ > Sponsored Link > > Compare mortgage rates for today. > Get up to 5 free quotes. www2.nextag.com From barney at textmatters.com Tue Nov 21 05:51:37 2006 From: barney at textmatters.com (Barney Carroll) Date: Tue, 21 Nov 2006 11:51:37 +0000 Subject: [thelist] (how to stop) IE6 rendering before it has fully compiled In-Reply-To: <610592c90611200317pfe309f8wf5ac193ac8044dd1@mail.gmail.com> References: <45617BE8.8040100@textmatters.com> <610592c90611200317pfe309f8wf5ac193ac8044dd1@mail.gmail.com> Message-ID: <4562E849.5030709@textmatters.com> Lee kowalkowski wrote: > I forgot to thank you for this Lee, it's a neat little script. I have since found the problem to be loads of nonsensical and (significantly) contradictory styles that were loading before mine. > It has the added bonus of filtering out impatient users too. Think > how much you'll save on traffic! Hehehe. Can't wait to tell the clients! Regards, Barney From sales at lycosa.co.uk Tue Nov 21 06:15:57 2006 From: sales at lycosa.co.uk (Sales @ Lycosa) Date: Tue, 21 Nov 2006 12:15:57 -0000 Subject: [thelist] web site check please In-Reply-To: <4.2.0.58.20061116020743.068463e8@mx1.delime.com> Message-ID: <000901c70d66$d1cda8d0$0201a8c0@DEV> Marc, Thanks so much for taking the time to look at this in so much depth - it is much appreciated. There is so much there, I've printed it out and will work through it. Sometimes you just can't see the wood for the trees... thanks again. Thanks to everyone else who has contributed - all very useful. Phil From jslist at sbcglobal.net Tue Nov 21 07:39:46 2006 From: jslist at sbcglobal.net (j s) Date: Tue, 21 Nov 2006 05:39:46 -0800 (PST) Subject: [thelist] Not Printing 1st 3 Characters Message-ID: <20061121133946.82805.qmail@web81014.mail.mud.yahoo.com> Well I solved the problem. When I forced a space ( ) in there the info prints correctly. Thanks for the advice. ----- Original Message ---- From: Peter Brunone (EasyListBox.com) To: thelist at lists.evolt.org; thelist at lists.evolt.org Sent: Monday, November 20, 2006 12:59:45 PM Subject: Re: [thelist] Not Printing 1st 3 Characters Where is the field in the page? Can we see the output? If it's near the left side, there could be a margin issue. Is the user on a different browser from most, or are the regional settings different? Has this user had problems printing anything else? Just shooting in the dark here... Peter From: j s jslist at sbcglobal.net Hello, There's a simple asp page. A field, in a form, is called from the previous page and is displayed on the screen. Here's the code: ]]> The complete field displays on the screen. When 1 particular user goes to print the page the first 3 characters of this field do not print. Other users can print it fine. Any ideas? I'm stumped. -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From hershel at galleryrobinson.com Tue Nov 21 08:37:47 2006 From: hershel at galleryrobinson.com (Hershel Robinson) Date: Tue, 21 Nov 2006 16:37:47 +0200 Subject: [thelist] Testing Tools In-Reply-To: <4eedb92a0611161846n7c6be6d5k4accff7943a9b897@mail.gmail.com> References: <455C76E5.7050804@galleryrobinson.com> <4eedb92a0611161846n7c6be6d5k4accff7943a9b897@mail.gmail.com> Message-ID: <45630F3B.4030405@galleryrobinson.com> > Webtest: > and associated FF plugin: to help > generate tests -- record once, test many :-) -- are tools I use regularly > for all sizes of engagements. > > And JMeter ---- is nominally for > performance testing, but creating an automated multiple-user simulation > can help uncover memory/connection pool leaks, etc. before deployment... Thanks. :) -- Web Site Construction by Gallery Robinson http://galleryrobinson.com/ From dejan at kozina.com Tue Nov 21 09:31:28 2006 From: dejan at kozina.com (Dejan Kozina) Date: Tue, 21 Nov 2006 16:31:28 +0100 Subject: [thelist] php extension In-Reply-To: <456290C1.60805@baratta.com> References: <20061121052432.96936.qmail@web33402.mail.mud.yahoo.com> <456290C1.60805@baratta.com> Message-ID: <45631BD0.8020002@kozina.com> AddType should almost always do the trick, but sometimes Apache just won't play along (with PHP loaded as CGI instead of Apache module). In these cases this usually works: SetHandler application/x-httpd-php djn Anthony Baratta wrote: > http://us3.php.net/manual/en/security.hiding.php -- Dejan Kozina Dolina 346 (TS) - I-34018 Italy tel./fax: +39 040 228 436 - cell.: +39 348 7355 225 http://www.kozina.com/ - e-mail: dejan at kozina.com From peter at easylistbox.com Tue Nov 21 09:36:07 2006 From: peter at easylistbox.com (Peter Brunone (EasyListBox.com)) Date: Tue, 21 Nov 2006 08:36:07 -0700 Subject: [thelist] Not Printing 1st 3 Characters Message-ID: That's... different. Where did you put the space? From: j s jslist at sbcglobal.net Well I solved the problem. When I forced a space ( ) in there the info prints correctly. Thanks for the advice. ----- Original Message ---- From: Peter Brunone (EasyListBox.com) Where is the field in the page? Can we see the output? If it's near the left side, there could be a margin issue. Is the user on a different browser from most, or are the regional settings different? Has this user had problems printing anything else? Just shooting in the dark here... Peter From: j s jslist at sbcglobal.net Hello, There's a simple asp page. A field, in a form, is called from the previous page and is displayed on the screen. Here's the code: ]]> The complete field displays on the screen. When 1 particular user goes to print the page the first 3 characters of this field do not print. Other users can print it fine. Any ideas? I'm stumped. From joe at artlung.com Tue Nov 21 09:40:18 2006 From: joe at artlung.com (Joe Crawford) Date: Tue, 21 Nov 2006 07:40:18 -0800 Subject: [thelist] php extension In-Reply-To: <20061121052432.96936.qmail@web33402.mail.mud.yahoo.com> References: <20061121052432.96936.qmail@web33402.mail.mud.yahoo.com> Message-ID: On 11/20/06, Kane Wilson wrote: > Hi , > > Generally , when we hosting php in apache , we need to host that files as *.php, php3....etc ( php extension ). Is it possible to put that files with different extensions ? (like hello.xyz) > If it is possible , how ? can i find a proper guide on for apache web server ? > # Another approach, place this in your .htaccess file: # it requires htaccess # how to make .php files masquerade as .xyz RewriteEngine On RewriteRule ^(.+).xyz $1.php - Joe -- http://joecrawford.com/ 805-857-3951 From evolt_org at striderweb.com Tue Nov 21 12:11:13 2006 From: evolt_org at striderweb.com (Stephen Rider) Date: Tue, 21 Nov 2006 12:11:13 -0600 Subject: [thelist] mod_rewrite safety Message-ID: <53F5697F-10AA-4AB3-B7F7-F47FE2A4B967@striderweb.com> I've been doing a lot of fooling around with mod_rewrite lately, and thought it might be worthwhile to write up a semi-tutorial on my site and share what I've learned with others, using what I've done as examples. My question is: Would it be unsafe to reveal what mod_rewrites I use on my site? It's not as though my site has any state secrets or anything, but I would prefer to keep it (reasonably) safe from hackers. Would revealing this in this way open the door to people messing with my site or my host's servers? Thanks, Stephen Rider http://www.striderweb.com/nerdaphernalia From evolt_org at striderweb.com Tue Nov 21 12:17:00 2006 From: evolt_org at striderweb.com (Stephen Rider) Date: Tue, 21 Nov 2006 12:17:00 -0600 Subject: [thelist] Web Page Response Times.... In-Reply-To: References: <39872f621ca0e56d2ba87ded69acdaba@baratta.com> <4559321E.8060208@frii.com> Message-ID: <523C2FD7-E8D5-4C6B-B58F-1FEED0766395@striderweb.com> On Nov 13, 2006, at 9:15 PM, Steven Streight wrote: > I would like to know how to measure the size of my own blog, > relative to > page loading times and optimizing download speed. Is there also a > chart or > set of guidelines for such evaluations as "900k is a lot for > broadband and > impossible for dial up modems to handle"? Time to get Sloppy!!! If you're trying to figure out what it's like to use your site via dial-up modem or other type of connection, get Sloppy. Sloppy is a "slow proxy for dial-up modem speed simulation" -- that is, it's a deliberately slow web proxy that runs on your computer and slows down your connection to simulate specific types of slow connections. Just what you need to show that graphic designer with the 22" screen and T1 line what you've been talking about all this time. Get it here: http://www.dallaway.com/sloppy/ From info at thesitedoctor.co.uk Tue Nov 21 12:25:58 2006 From: info at thesitedoctor.co.uk (Tim Gaunt) Date: Tue, 21 Nov 2006 18:25:58 -0000 Subject: [thelist] Web Page Response Times.... In-Reply-To: <523C2FD7-E8D5-4C6B-B58F-1FEED0766395@striderweb.com> Message-ID: <02f301c70d9a$7dc73380$1302a8c0@officedesktop> On Nov 21, 2006, at 18:17 Stephen Rider wrote: > Time to get Sloppy!!! +1 for Sloppy, it's amazingly useful to check response times, that and to reminisce about the good ol' days of 9.6kbps... Tim From RPringle at aurora-il.org Wed Nov 22 10:43:36 2006 From: RPringle at aurora-il.org (Pringle, Ron) Date: Wed, 22 Nov 2006 10:43:36 -0600 Subject: [thelist] MySQL Query problem: unique vals from two fields Message-ID: <4A27645B1A4F4D4181909FA5D213FEF402A0A814@coaexb.coa.aurora-il.org> I'm attempting to write a query that grabs unique Years from two date fields in the same table in a MySQL db (5.0.26 IIRC), preferably as a single column or as an array of results. I have a table of art exhibit start and end dates. I want to find all unique years from the exStartDate and exEndDate fields and use them to populate a dropdown for a search form. The problem stems from exhibits that might start one year but end the next, such as the first entry below. Querying JUST the start or end dates will miss a year. Below is some sample data showing the table structure as well: exStartDate exEndDate ---------------------------------------- 2004-12-01 2005-01-20 2005-01-21 2005-03-20 2005-09-16 2005-10-23 2005-10-26 2006-02-06 2005-11-04 2006-01-06 2005-12-09 2006-01-06 2006-01-20 2006-03-19 2006-09-15 2006-11-26 2006-12-08 2007-01-07 Below is the query I've started with, which misses the 2004 date: SELECT DISTINCT(Year(exEndDate)) as exhibitYear FROM tbl_exhibitDates WHERE exEndDate < CURRENT_DATE() ORDER BY exhibitYear ASC; Ideas, blows to the head with blunt objects, etc. much appreciated. Happy Thanksgiving all Ron From mwarden at gmail.com Wed Nov 22 10:50:01 2006 From: mwarden at gmail.com (Matt Warden) Date: Wed, 22 Nov 2006 11:50:01 -0500 Subject: [thelist] MySQL Query problem: unique vals from two fields In-Reply-To: <4A27645B1A4F4D4181909FA5D213FEF402A0A814@coaexb.coa.aurora-il.org> References: <4A27645B1A4F4D4181909FA5D213FEF402A0A814@coaexb.coa.aurora-il.org> Message-ID: On 11/22/06, Pringle, Ron wrote: > SELECT DISTINCT(Year(exEndDate)) as exhibitYear FROM tbl_exhibitDates WHERE exEndDate < CURRENT_DATE() ORDER BY exhibitYear ASC; > > > Ideas, blows to the head with blunt objects, etc. much appreciated. Fresh out of blunt objects, but maybe I can help with the query. select distinct year(exEndDate) as exhibitYear from tbl_exhibitDates where exEndDate < current_date() union select distinct year(exStartDate) from tbl_exhibitdates where exStartDate < current_date() This *should* return only distinct years, because it is union and not union all. However, give it a try in your DB of choice and if it is duping years that exist in both sets, we will have to filter those out in the where clause of the second query. HTH, -- Matt Warden Cleveland, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From anthony at baratta.com Wed Nov 22 10:56:52 2006 From: anthony at baratta.com (Anthony Baratta) Date: Wed, 22 Nov 2006 08:56:52 -0800 Subject: [thelist] MySQL Query problem: unique vals from two fields Message-ID: Sounds like you need a "view". Create a view using both tables and the Union selecting only the Date column. Then you can create a query that grabs the Unique Years. http://dev.mysql.com/doc/refman/5.0/en/views.html -----Original message----- From: "Pringle, Ron" RPringle at aurora-il.org Date: Wed, 22 Nov 2006 08:43:36 -0800 To: "theList \(E-mail\)" thelist at lists.evolt.org Subject: [thelist] MySQL Query problem: unique vals from two fields > I'm attempting to write a query that grabs unique Years from two date fields in the same table in a MySQL db (5.0.26 IIRC), preferably as a single column or as an array of results. I have a table of art exhibit start and end dates. I want to find all unique years from the exStartDate and exEndDate fields and use them to populate a dropdown for a search form. From RPringle at aurora-il.org Wed Nov 22 11:17:52 2006 From: RPringle at aurora-il.org (Pringle, Ron) Date: Wed, 22 Nov 2006 11:17:52 -0600 Subject: [thelist] MySQL Query problem: unique vals from two fields Message-ID: <4A27645B1A4F4D4181909FA5D213FEF402303856@coaexb.coa.aurora-il.org> Matt- Worked like a charm thanks! I obviously have much to learn. Anthony, thanks for the pointer on views. I will look into those as well! Have a good Thanksgiving all! Ron Matt wrote: Fresh out of blunt objects, but maybe I can help with the query. select distinct year(exEndDate) as exhibitYear from tbl_exhibitDates where exEndDate < current_date() union select distinct year(exStartDate) from tbl_exhibitdates where exStartDate < current_date() This *should* return only distinct years, because it is union and not union all. However, give it a try in your DB of choice and if it is duping years that exist in both sets, we will have to filter those out in the where clause of the second query. HTH, -- Matt Warden Cleveland, OH, USA http://mattwarden.com From psm2713 at hotmail.com Wed Nov 22 11:22:03 2006 From: psm2713 at hotmail.com (Ken Moore) Date: Wed, 22 Nov 2006 10:22:03 -0700 Subject: [thelist] MySQL Query problem: unique vals from two fields In-Reply-To: <4A27645B1A4F4D4181909FA5D213FEF402A0A814@coaexb.coa.aurora-il.org> Message-ID: Hi all, The problem is that you want to condense 2 fields with different data into one field. You would have the same thing if you were searching ?First_Name? and ?Last_Name? while attempting to put them into one field, ?All_Names?. Some data would be unique to one or the other while other data, i.e. ?Morgan?, could be in either, both or neither. I would suggest a short script that creates a temporary table which populates the drop-down list. An alternative method, using only queries is the following. One query returns all years from one field into a temp. table. A second query does the same into the same table. A third does a select DISTINCT into a second temp. table which is used for the list. This is a little more award. But unless you have 100,000?s of records, it should work. Ken >From: "Pringle, Ron" wrote > >I'm attempting to write a query that grabs unique Years from two date >fields in the same table in a MySQL db (5.0.26 IIRC), preferably as a >single column or as an array of results. I have a table of art exhibit >start and end dates. I want to find all unique years from the exStartDate >and exEndDate fields and use them to populate a dropdown for a search form. > >The problem stems from exhibits that might start one year but end the next, >such as the first entry below. Querying JUST the start or end dates will >miss a year. Below is some sample data showing the table structure as well: > >exStartDate exEndDate >---------------------------------------- >2004-12-01 2005-01-20 >2005-01-21 2005-03-20 >2005-09-16 2005-10-23 >2005-10-26 2006-02-06 >2005-11-04 2006-01-06 >2005-12-09 2006-01-06 >2006-01-20 2006-03-19 >2006-09-15 2006-11-26 >2006-12-08 2007-01-07 > >Below is the query I've started with, which misses the 2004 date: > >SELECT DISTINCT(Year(exEndDate)) as exhibitYear FROM tbl_exhibitDates WHERE >exEndDate >CURRENT_DATE() ORDER BY exhibitYear ASC; > > >Ideas, blows to the head with blunt objects, etc. much appreciated. > >Happy Thanksgiving all > >Ron _________________________________________________________________ All-in-one security and maintenance for your PC.? Get a free 90-day trial! http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?href=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail From RPringle at aurora-il.org Wed Nov 22 12:54:18 2006 From: RPringle at aurora-il.org (Pringle, Ron) Date: Wed, 22 Nov 2006 12:54:18 -0600 Subject: [thelist] MySQL Query problem: unique vals from two fields Message-ID: <4A27645B1A4F4D4181909FA5D213FEF402A0A815@coaexb.coa.aurora-il.org> To close this out, turns out you don't need to use DISTINCT in the query. The default behavior of UNION in MySQL is to remove duplicate rows anyhow. So the final query now looks like: select year(exEndDate) as exhibitYear from tbl_exhibitDates where exEndDate < current_date() union select year(exStartDate) from tbl_exhibitdates where exStartDate < current_date() Thanks again Matt. Ron Matt wrote: Fresh out of blunt objects, but maybe I can help with the query. select distinct year(exEndDate) as exhibitYear from tbl_exhibitDates where exEndDate < current_date() union select distinct year(exStartDate) from tbl_exhibitdates where exStartDate < current_date() This *should* return only distinct years, because it is union and not union all. However, give it a try in your DB of choice and if it is duping years that exist in both sets, we will have to filter those out in the where clause of the second query. HTH, -- Matt Warden Cleveland, OH, USA http://mattwarden.com From mwarden at gmail.com Wed Nov 22 13:02:47 2006 From: mwarden at gmail.com (Matt Warden) Date: Wed, 22 Nov 2006 14:02:47 -0500 Subject: [thelist] MySQL Query problem: unique vals from two fields In-Reply-To: <4A27645B1A4F4D4181909FA5D213FEF402A0A815@coaexb.coa.aurora-il.org> References: <4A27645B1A4F4D4181909FA5D213FEF402A0A815@coaexb.coa.aurora-il.org> Message-ID: On 11/22/06, Pringle, Ron wrote: > To close this out, turns out you don't need to use DISTINCT in the > query. The default behavior of UNION in MySQL is to remove duplicate > rows anyhow. So the final query now looks like: To clarify, you are saying that for a unioned set A and B, where A and/or B have duplicates within its own set, the union operation will remove such duplicates? So, it must combine sets and then perform the un-dupe over the entire set, rather than take set A and only append from set B if the item in set B is not found in A. Did you do any tests to make sure the DB does not use a different algorithm when it knows the two sets have no dupes already? -- Matt Warden Cleveland, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From RPringle at aurora-il.org Wed Nov 22 13:17:27 2006 From: RPringle at aurora-il.org (Pringle, Ron) Date: Wed, 22 Nov 2006 13:17:27 -0600 Subject: [thelist] MySQL Query problem: unique vals from two fields Message-ID: <4A27645B1A4F4D4181909FA5D213FEF402A0A816@coaexb.coa.aurora-il.org> On 11/22/06, Pringle, Ron wrote: > To close this out, turns out you don't need to use DISTINCT in the > query. The default behavior of UNION in MySQL is to remove duplicate > rows anyhow. So the final query now looks like: To clarify, you are saying that for a unioned set A and B, where A and/or B have duplicates within its own set, the union operation will remove such duplicates? So, it must combine sets and then perform the un-dupe over the entire set, rather than take set A and only append from set B if the item in set B is not found in A. Did you do any tests to make sure the DB does not use a different algorithm when it knows the two sets have no dupes already? -- Matt Matt- No, I didn't. My reading of it is that it combines all data from both tables and then removes any duplicates. But I see what you're saying regarding using distinct on the individual selects versus using distinct on the union. My dataset in this case is so incredibly small that I don't know that I could see any differences in the two methods, but it'd be interesting to know for future reference. I don't know how you'd go about testing it. Here is the text from the MySQL site: "The default behavior for UNION is that duplicate rows are removed from the result. The optional DISTINCT keyword has no effect other than the default because it also specifies duplicate-row removal. With the optional ALL keyword, duplicate-row removal does not occur and the result includes all matching rows from all the SELECT statements." http://dev.mysql.com/doc/refman/5.0/en/union.html Ron From joel at spinhead.com Wed Nov 22 14:28:31 2006 From: joel at spinhead.com (Joel D Canfield) Date: Wed, 22 Nov 2006 12:28:31 -0800 Subject: [thelist] accessibility resources? design resources? Message-ID: <72E9FAA171D63B48AAC707C72900E6B4A718D9@ireland.spinhead.com> what's your favorite/most useful book/resource re: accessibility? (not usability) or, if your bent is more toward the artistic, what's your favorite/most useful book/resource re: design (however you choose to define it) ? I don't normally have money for books, but I've got a gift cert burning a hole in my pocket. thanks joel From julian.rickards at gmail.com Wed Nov 22 14:33:02 2006 From: julian.rickards at gmail.com (Julian Rickards) Date: Wed, 22 Nov 2006 15:33:02 -0500 Subject: [thelist] accessibility resources? design resources? In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B4A718D9@ireland.spinhead.com> References: <72E9FAA171D63B48AAC707C72900E6B4A718D9@ireland.spinhead.com> Message-ID: <7613e9690611221233v60c24f2ei634f0506305af534@mail.gmail.com> Where do you live Joel? On 22/11/06, Joel D Canfield wrote: > > what's your favorite/most useful book/resource re: accessibility? (not > usability) > > or, if your bent is more toward the artistic, what's your favorite/most > useful book/resource re: design (however you choose to define it) ? > > I don't normally have money for books, but I've got a gift cert burning > a hole in my pocket. > > thanks > > joel > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- Website: http://jrickards.ca Blog: http://pen-and-ink.ca E-mail: julian dot rickards at gmail dot com From Groups at beachcomp.com Wed Nov 22 15:02:01 2006 From: Groups at beachcomp.com (Beach Computers) Date: Wed, 22 Nov 2006 16:02:01 -0500 Subject: [thelist] Community Protal/Homepage Script In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B4A718D9@ireland.spinhead.com> Message-ID: <006601c70e79$79b49d20$0202fea9@home.dmoadab.com> Anyone know of a free ASP or .net based community/homepage script/system to run on IIS? We currently use start.tucows.com and are looking for a different option. Thanks Dave ----------------------------------- |Beach Computers | |Affordable Hosting Solutions | |http://www.beachcomp.com | =================================== |Cheap Domain Warehouse | |Get Your Own Dot! | |http://www.cheapdomainwarehouse.com| ---------------------------------- ------------------------------------ Disclaimer and confidentiality note: The contents of this communication are intended/meant only for addressee(s) and may contain information that is privileged or otherwise confidential. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. The contents of this e-mail shall not be forwarded to any third party. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email, so that the sender's address records can be corrected. Views and opinions are solely those of the sender unless clearly indicated as being that of Beach Computers or any of it's affiliated companies. Beach Computers cannot assure that the integrity of this communication has been maintained or that it is free of errors, virus, interception or interference. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Joel D Canfield Sent: Wednesday, November 22, 2006 3:29 PM To: thelist at lists.evolt.org Subject: [thelist] accessibility resources? design resources? what's your favorite/most useful book/resource re: accessibility? (not usability) or, if your bent is more toward the artistic, what's your favorite/most useful book/resource re: design (however you choose to define it) ? I don't normally have money for books, but I've got a gift cert burning a hole in my pocket. thanks joel -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From thelist at tonygrimes.com Wed Nov 22 15:08:22 2006 From: thelist at tonygrimes.com (Tony Grimes) Date: Wed, 22 Nov 2006 14:08:22 -0700 Subject: [thelist] IE7 List Numbering Bug Message-ID: I'm not sure if this will help anyone, but I just found a glaring bug in the way IE renders ordered lists when widths are set. It took me forever to figure out why my lists were breaking, so maybe this will save someone some time: http://www.tonygrimes.com/test/ie7bug_ol.html I originally thought it was just an IE7 bug, but older version don't do well either. Is this a known issue? MS doesn't seem to have a bug reporting utility, so I guess this is the best I can do. Tony From taurus_james at yahoo.com Wed Nov 22 17:26:36 2006 From: taurus_james at yahoo.com (Taurus James) Date: Wed, 22 Nov 2006 15:26:36 -0800 (PST) Subject: [thelist] Community Protal/Homepage Script In-Reply-To: <006601c70e79$79b49d20$0202fea9@home.dmoadab.com> Message-ID: <20061122232636.32520.qmail@web38013.mail.mud.yahoo.com> http://forum.snitz.com/ - Taurus http://taurusbeats.com Beach Computers wrote: Anyone know of a free ASP or .net based community/homepage script/system to run on IIS? We currently use start.tucows.com and are looking for a different option. --------------------------------- Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. From volkan.ozcelik at gmail.com Wed Nov 22 22:22:07 2006 From: volkan.ozcelik at gmail.com (=?ISO-8859-9?Q?VOLKAN_=D6Z=C7EL=DDK?=) Date: Thu, 23 Nov 2006 06:22:07 +0200 Subject: [thelist] Not Printing 1st 3 Characters In-Reply-To: <20061121133946.82805.qmail@web81014.mail.mud.yahoo.com> References: <20061121133946.82805.qmail@web81014.mail.mud.yahoo.com> Message-ID: On 11/21/06, j s wrote: > > Well I solved the problem. When I forced a space ( ) in there the > info prints correctly. Well actually you seem to hack or kludge the problem rather than solving it. Anyway if it ain't broke, don't fix it. Cheers, -- Volkan Ozcelik +>Yep! I'm blogging! : http://www.volkanozcelik.com/cre8/blog/ +> Going solo in Turkish: http://www.volkanozcelik.com/donkisot/ +> My projects/studies/trials/errors : http://www.sarmal.com/ +> Sardalya JavaScript Library: http://www.sarmal.com/sardalya/ From lee.kowalkowski at googlemail.com Thu Nov 23 03:21:30 2006 From: lee.kowalkowski at googlemail.com (Lee kowalkowski) Date: Thu, 23 Nov 2006 09:21:30 +0000 Subject: [thelist] IE7 List Numbering Bug In-Reply-To: References: Message-ID: <610592c90611230121j1814e590x5ef61a5cdc1b80a5@mail.gmail.com> On 22/11/06, Tony Grimes wrote: > http://www.tonygrimes.com/test/ie7bug_ol.html > > I originally thought it was just an IE7 bug, but older version don't do well > either. Is this a known issue? MS doesn't seem to have a bug reporting > utility, so I guess this is the best I can do. The LI-width bug has been in since IE5. It can be fixed with "display:list-item;", but that property wasn't introduced until IE6. The OL-width bug was introduced in IE 6. It can be fixed with a left-margin on the LIs big enough to fit your widest LI number. -- Lee From chris.price at choctaw.co.uk Thu Nov 23 06:11:08 2006 From: chris.price at choctaw.co.uk (Chris Price) Date: Thu, 23 Nov 2006 12:11:08 +0000 Subject: [thelist] AOL strange behaviour on search Message-ID: I have a website http://www.serekundapoodles.com which is readily searchable by typing 'serekunda poodles' in the popular search engines. The client, whose website this is, uses AOL as his ISP and when he searches using AOL's customized search facility he can only find his website by typing in the full url. Unfortunately many of the people who wish to view the website are in the USA and also use AOL and, unless they remember the url they cannot find the website. My client has contacted AOL and they can't figure out what the problem is. They can see that there is no problem with Google but AOL uses Google. Anyone had a similar experience or have any idea what's happening? It would seem that AOL is filtering Google's data but they don't seem to think that's the case. Kind Regards -- Chris Price Choctaw chris.price at choctaw.co.uk http://www.choctaw.co.uk Tel. 01524 825 245 Mob. 0777 451 4488 Beauty is in the eye of the beholder while excellence is in the hand of the professional ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -+- Sent on behalf of Choctaw Media Ltd -+- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The information in the email (including any attachments) is confidential and intended solely for the use of the individual to whom it is addressed. Access to this email by anyone else is unauthorized. Any views or opinions presented are solely those of the author and do not necessarily represent those of Choctaw Media Ltd. If you have received this email in error be advised that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. Please notify the sender and please delete the message from your system immediately. From gsm_color at yahoo.com Thu Nov 23 06:15:13 2006 From: gsm_color at yahoo.com (Kane Wilson) Date: Thu, 23 Nov 2006 04:15:13 -0800 (PST) Subject: [thelist] File uploading ISSUE Message-ID: <20061123121513.11488.qmail@web33408.mail.mud.yahoo.com> Hi , I wrote a small php script, to upload contents into mysql database. It works well . There is a function , while i upload a content , automatically it takes the file size , file name , and the file type ( basically MIME ) . when i upload a picture (jpg/gif) , it takes as image/jpeg and image/gif. But , when i uploading a SIS and CAB files into the database , that file types taking as "application/octet-stream". This is not the correct mime types of that relavent contents. why this is happened ? SIS - application/vnd.symbian.install application/cab application/x-compress application/x-compressed zz-application/zz-winassoc-cab ------>>>> for CAB Can somebody help me on this please ? Thanx in advance, Kane. ____________________________________________________________________________________ Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index From derwert at hotmail.com Thu Nov 23 08:33:48 2006 From: derwert at hotmail.com (der wert) Date: Thu, 23 Nov 2006 09:33:48 -0500 Subject: [thelist] File uploading ISSUE Message-ID: when uploading files the mime type is set by your browser, this means it can be different depending on which browser you are usingmake sure to use a whitelist of allowed file extensions for your upload script _________________________________________________________________ Express yourself with gadgets on Windows Live Spaces http://discoverspaces.live.com?source=hmtag1&loc=us From mr.sanders at geekjock.ca Thu Nov 23 08:44:37 2006 From: mr.sanders at geekjock.ca (Sarah Adams) Date: Thu, 23 Nov 2006 10:44:37 -0400 Subject: [thelist] AOL strange behaviour on search In-Reply-To: References: Message-ID: <4565B3D5.5050804@geekjock.ca> > I have a website http://www.serekundapoodles.com which is readily > searchable by typing 'serekunda poodles' in the popular search engines. > > The client, whose website this is, uses AOL as his ISP and when he > searches using AOL's customized search facility he can only find his > website by typing in the full url. Unfortunately many of the people who > wish to view the website are in the USA and also use AOL and, unless > they remember the url they cannot find the website. I noticed that the AOL search page says "enhanced by google", and since the AOL search only returns 14 results, whereas google returns 237, obviously they aren't using google's exact search results. I don't have much help to offer as to why this is happening, but in terms of search engine optimization, it would certainly help if the work "serekunda" were in the of the home page. -- sarah adams web developer & programmer portfolio: http://sarah.designshift.com blog: http://hardedge.ca From morrison.ben at gmail.com Thu Nov 23 08:54:13 2006 From: morrison.ben at gmail.com (ben morrison) Date: Thu, 23 Nov 2006 14:54:13 +0000 Subject: [thelist] AOL strange behaviour on search In-Reply-To: <B3448672-7AEB-11DB-9F65-000393DAF542@choctaw.co.uk> References: <B3448672-7AEB-11DB-9F65-000393DAF542@choctaw.co.uk> Message-ID: <6073aef90611230654x2ef12a44ybb01b310b3b9831a@mail.gmail.com> On 11/23/06, Chris Price <chris.price at choctaw.co.uk> wrote: > I have a website [snipped] which is readily > searchable by typing '[snipped]' in the popular search engines. > By sending this email, this will now list highly in the search engines for anyone searching on those terms, for that reason i will change the name to www.kundaserapoodles.com for the sake of my question, still with me?... Excuse my ignorance, but what does 'kundasera' mean in terms of poodles? Or rather why would a user type in 'kundasera poodles' into a search engine? ben -- Ben Morrison From spencer at hyperlinkage.com Thu Nov 23 13:40:36 2006 From: spencer at hyperlinkage.com (Spencer Judge) Date: Thu, 23 Nov 2006 19:40:36 +0000 Subject: [thelist] Community Protal/Homepage Script In-Reply-To: <006601c70e79$79b49d20$0202fea9@home.dmoadab.com> References: <006601c70e79$79b49d20$0202fea9@home.dmoadab.com> Message-ID: <4565F934.2030202@hyperlinkage.com> Beach Computers wrote: > Anyone know of a free ASP or .net based community/homepage > script/system to > run on IIS? You could perhaps consider DotNetNuke. ASP.NET framework with plenty of open source modules available to build community web sites. http://www.dotnetnuke.com/ Spencer From joel at spinhead.com Thu Nov 23 14:37:00 2006 From: joel at spinhead.com (Joel D Canfield) Date: Thu, 23 Nov 2006 12:37:00 -0800 Subject: [thelist] site check: http://intranetIntelligence.com/ Message-ID: <72E9FAA171D63B48AAC707C72900E6B4A718E6@ireland.spinhead.com> I'm a firm believer in constructive criticism as a learning tool. This statement > why the heck couldn't they get a better designer? could be converted to something constructive by pointing out specific design fundamentals being violated, or by providing specific suggestions for improvement; perhaps even resources for learning design (most helpful re: resources would be those available to a family man trying to make a living, meaning time for training is tight, and money for training is virtually non-existent.) thanks joel From evolt07 at delime.com Thu Nov 23 16:22:19 2006 From: evolt07 at delime.com (M. Seyon) Date: Thu, 23 Nov 2006 18:22:19 -0400 Subject: [thelist] site check: http://intranetIntelligence.com/ In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B4A718E6@ireland.spinhead.co m> Message-ID: <4.2.0.58.20061123174342.00a72e98@mx1.delime.com> Message from Joel D Canfield (11/23/2006 12:37 PM) >I'm a firm believer in constructive criticism as a learning tool. This >statement > > > why the heck couldn't they get a better designer? > >could be converted to something constructive by pointing out specific >design fundamentals being violated, or by providing specific suggestions >for improvement; perhaps even resources for learning design (most >helpful re: resources would be those available to a family man trying to >make a living, meaning time for training is tight, and money for >training is virtually non-existent.) Joel, Your desin skills may not be the best in the world but I have to way, great job on the spin doctoring man! In the very same email you've so exquisitely edited, I provided several pieces of technical feedback - which is specifically what you requested - on how the layout was broken and offered suggestions to solve them. So please don't intimate that I simply bashing your site and not adding value. I withheld further comments for two reasons: 1. Others had already offered their own opinions on the layout, none of which I disagreed with, and I did not want to be redundant. 2. You yourself admitted that certain aspects were under development, such as selecting more appropriate photos so honestly, therefore I opted not to comment on what I considered a work in progress, subject to change anyways. Additionally, the very first time you posted about your site I sent you an offlist message with a suggestion on a potential avenue to improve your site design - not a suggestion for how you could personally improve the site because as a non-designer myself I know there are limits to what can be achieved. If you can't do it, you just can't. And if it looks good to you then there's no changing your mind. Which is why outside help can be so valuable, and presumably why so many people request site checks on evolt. Or ask a third party to proofread their important documents. But getting back to the issue at hand. What I did do was couch my comment - the marvellously manipulated one - in terms of what a potential client might say. Because honestly, as someone who has sought partners to outsource technical development work to in the past, if I were to come across your site, based on the bold assertion about "every technical skill", *as a potential client* I would ask the question I asked. And chances are the answer I formulated would cost a company with a design like this serious points. Again, *as a potential client*, which is the hat I clearly (or so I thought) donned when delivering that piece of feedback, you can be sure that I would *not* be giving you feedback on how to fix your site. Well, actually I might, if I thought it might be mutually beneficial - I would suggest something along the lines of "maybe I can provide you with design skills and you can provide me with technical skills", but I already made that suggestion to you offlist, weeks ago. So whether you wish to recognise the value of the feedback or not, this is feedback, and if I were the one seeking advice it's something I'd rather see a whole lot more than an empty "looks great, keep it up". Because as a one man shop sometimes you get so close to a design that you CAN'T see the flaws. Especially when it's something you've no doubt invested considerable time and effort into and who the heck is this smart aleck upstart no-nothing to bad mouth me on a public list I've been a member of for donkey years anyways! However, if you want some feedback on my subjective opinion of a self-described work in progress, please read on: 1. Whitespace is an important design element. But in the same way that you can have too little, and end up with a cluttered look, you can have too much. I think the large L shaped are across the top and down the side, where the "It is said..." phrase sits is too much. Consider the relationship between the previous two paragraphs - one line apart, and the subsequent one - It's totally disconnected. I think your content suffers the same problem. It's too far from the rest of the site - the header and navigation. I suspect that you were probably trying to use the photo to help bridge this disconnect but it is not working, probably because the photos are small, positioned all the way to the right of the box and possibly even because they are within a border of their own, hence another barrier, so to speak. 2. The "Ii" logo is not a bad concept, but the execution screams 1990's Photoshop overload with the embossing. And as this is the only texture on an otherwise flat design, it sticks out like a sore thumb. Giving the main content box a slight shadow *might* help balance this. 3. There are too many different font styles. There's regular, italic, bold, bolded italic, each in varying sizes. The intent may be to draw attention, but it's not really drawing the right sort of attention. It has something of a ransom-note look to it 4. I don't think the analogous colour scheme is working for you. Analagous schemes tend to give a more casual air, while complementary schemes are more formal and businessy. Hence the popularity of orange and blue or green and blue these days. Incidentally, apparently orange is popular with the modern designers because it's one of the few colours that haven't been emotionalised, ie red is passion or love or hate, blue is calm, tranquil, etc. http://www.limov.com/colour/ is a great place to play with colour schemes. Try either the Colour Schemes or Make Swatches links. I think Paola is, or at least used to be, an evolter. Why not hit her up for some advice if she's still around? 5. When you're choosing your new photos may I suggest you consider standardising between all black and white or all colour. That may help to bring them together as a recognisable set, as it is they're just too vaguely grouped to add much impact. 6. I know there's the whole bring back Times font movement but personally I don't like Times. At least not for every single element. How about for headers only, or content only. Use a sans-serif for the other. 7. I think the best looking page is http://intranetintelligence.com/ii/intranet/ It's tight, well structured, and there is an easy flow to browsing it, without all the jerkiness caused by the rambling fonts. 8. On the contact page, I personally don't like putting the contact form and alternate contact methods one below the other. If someone wants to use the one below it shouldn't be at the expense of additional scrolling. The general method I've adopted is to have the contact form as the more prominent, with the offline methods listed in a box to the side that's easily visible. Good luck. regards. -marc -- Now available: Trinidad and Tobago 2007 wall calendars http://phototnt.com/ From joel at spinhead.com Thu Nov 23 16:46:40 2006 From: joel at spinhead.com (Joel D Canfield) Date: Thu, 23 Nov 2006 14:46:40 -0800 Subject: [thelist] site check: http://intranetIntelligence.com/ Message-ID: <72E9FAA171D63B48AAC707C72900E6B4A718E7@ireland.spinhead.com> > please don't intimate that I simply bashing your site and not > adding value. I didn't intimate that. I explicitly stated that the one single comment didn't add value, value I very much wanted to have. Most of your reply is exactly the kind of information I was looking for. It's unfortunate that you had to include all the invective before you got to the single most useful review I've gotten on my site. I didn't specifically respond to every comment made by you or others, here or offline. I have an enormous amount of work to do on the site and figured I'd address things as they became important to me. The 'design', whatever you consider that, is important to me now, thus my question. As I said, I appreciate constructive criticism. I also try *really hard* to keep emotion out of it. You may note that there was nearly a week between your unsolicited, unsupported (until now) criticism of my design, and my question requesting clarification of it. I didn't spend that week trying to put a spin on your comment (you may also note I didn't ascribe the comment to anyone in particular, nor was I asking only you to elucidate on it) I thought long and hard before I asked for further comment on your statement, but in the end, I decided to risk your continued cranky attitude towards me, offline and here, in the hopes that you had some productive feedback. You did, and I hope I can stifle my annoyance at your bad manners well enough to make use of your intelligent, well-thought-out suggestions. I'm not sure what I've done to piss you off, Marc; other listees whose opinions I trust have referred to you as 'a pleasure to work with' - unfortunately, I seem to consistently bring out another side of you. For whatever it was, I apologize. Your posts to thelist are full of useful info and I often find something I can use in them. I just wish I could access your knowledge without getting slapped around. joel From steven.streight at gmail.com Thu Nov 23 21:06:28 2006 From: steven.streight at gmail.com (Steven Streight) Date: Thu, 23 Nov 2006 21:06:28 -0600 Subject: [thelist] site check: http://intranetIntelligence.com/ In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B4A718E7@ireland.spinhead.com> References: <72E9FAA171D63B48AAC707C72900E6B4A718E7@ireland.spinhead.com> Message-ID: <fad66b420611231906j1273dadbua217f96db7a5f2cd@mail.gmail.com> Gee, Joel, I thought my review was the most valuable. Go to Jakob Nielsen's Use It dot com for extremely valuable insight on designing and writing web sites. That's the best advice I can give you. I will also help you revise your written content, if you simply email me and request it. Email me directly and I'll be sure to notice it. You boys quit fussing now. You both is cool. I. Have. Spoken. Ping me. -- Steven Streight aka Vaspers the Grate Web Usability. IT. Ecommerce. Video. Vaspers the Grate http://www.vaspersthegrate.blogspot.com Corporate Blog Revolution http://electrica.wordpress.com From steven.streight at gmail.com Thu Nov 23 21:09:39 2006 From: steven.streight at gmail.com (Steven Streight) Date: Thu, 23 Nov 2006 21:09:39 -0600 Subject: [thelist] should I speed optimize my site more? Message-ID: <fad66b420611231909l6963037bs5466b6fade1d51d8@mail.gmail.com> Happy Thanksblogging Day everyone. If anyone could check out my blog and let me know if I should remove more images, maybe even the non-productive Amazon widgets in the sidebar? I wish to optimize my site for download speed. All strident opinions and cranky harshing are welcome. Thanks. -- Steven Streight aka Vaspers the Grate Web Usability. IT. Ecommerce. Video. Vaspers the Grate http://www.vaspersthegrate.blogspot.com Corporate Blog Revolution http://electrica.wordpress.com From mwarden at gmail.com Thu Nov 23 22:41:08 2006 From: mwarden at gmail.com (Matt Warden) Date: Thu, 23 Nov 2006 23:41:08 -0500 Subject: [thelist] should I speed optimize my site more? In-Reply-To: <fad66b420611231909l6963037bs5466b6fade1d51d8@mail.gmail.com> References: <fad66b420611231909l6963037bs5466b6fade1d51d8@mail.gmail.com> Message-ID: <bbc8fa430611232041l1dc3af2cm45ba4c3526a4bffd@mail.gmail.com> Viewing on my Q shows the total page weight at just over 685KB. So, yes, I would strongly suggest trimming it down. -Matt -- Matt Warden Cleveland, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From chilijoe at gmail.com Thu Nov 23 23:10:24 2006 From: chilijoe at gmail.com (Joe Ngo) Date: Fri, 24 Nov 2006 13:10:24 +0800 Subject: [thelist] MySQL Query problem: unique vals from two fields In-Reply-To: <4A27645B1A4F4D4181909FA5D213FEF402A0A816@coaexb.coa.aurora-il.org> References: <4A27645B1A4F4D4181909FA5D213FEF402A0A816@coaexb.coa.aurora-il.org> Message-ID: <6a81c2300611232110r3e2168f1qe7e90fbb555822b4@mail.gmail.com> The effect of UNION is similar to performing a UNION ALL and a DISTINCT operation. I think this is standard behavior not just for MySQL. Other enterprise databases DB2, MSSQL, Oracle have this behavior as well On 11/23/06, Pringle, Ron <RPringle at aurora-il.org> wrote: > On 11/22/06, Pringle, Ron <RPringle at aurora-il.org> wrote: > > To close this out, turns out you don't need to use DISTINCT in the > > query. The default behavior of UNION in MySQL is to remove duplicate > > rows anyhow. So the final query now looks like: > > To clarify, you are saying that for a unioned set A and B, where A > and/or B have duplicates within its own set, the union operation will > remove such duplicates? So, it must combine sets and then perform the > un-dupe over the entire set, rather than take set A and only append > from set B if the item in set B is not found in A. > > Did you do any tests to make sure the DB does not use a different > algorithm when it knows the two sets have no dupes already? > > -- > Matt > > > > Matt- > > No, I didn't. My reading of it is that it combines all data from both > tables and then removes any duplicates. But I see what you're saying > regarding using distinct on the individual selects versus using distinct > on the union. My dataset in this case is so incredibly small that I > don't know that I could see any differences in the two methods, but it'd > be interesting to know for future reference. I don't know how you'd go > about testing it. > > Here is the text from the MySQL site: > > "The default behavior for UNION is that duplicate rows are removed from > the result. The optional DISTINCT keyword has no effect other than the > default because it also specifies duplicate-row removal. With the > optional ALL keyword, duplicate-row removal does not occur and the > result includes all matching rows from all the SELECT statements." > > http://dev.mysql.com/doc/refman/5.0/en/union.html > > Ron > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- http://xtrahot.chili-mango.net There's still no place like ~ From brian at hondaswap.com Thu Nov 23 23:30:34 2006 From: brian at hondaswap.com (Brian Cummiskey) Date: Fri, 24 Nov 2006 00:30:34 -0500 Subject: [thelist] simple sql question Message-ID: <4566837A.9020308@hondaswap.com> how do i re-write this as a DELETE statement instead of a SELECT? I'm pruing out some duplicate files... SELECT max(fileid) FROM files GROUP BY title HAVING count(*) >1 Everytime i try to delete it via phpmyadmin on the X, it gives me the following error: Error *SQL query:* DELETE FROM `files` WHERE `files`.`max( fileid )` =563 LIMIT 1 *MySQL said: * | #1054 - Unknown column 'files.max( fileid )' in 'where clause' I'm not sure how to get around this. Thanks! | From joel at spinhead.com Fri Nov 24 00:36:19 2006 From: joel at spinhead.com (Joel D Canfield) Date: Thu, 23 Nov 2006 22:36:19 -0800 Subject: [thelist] site check: http://intranetIntelligence.com/ Message-ID: <72E9FAA171D63B48AAC707C72900E6B4A718EA@ireland.spinhead.com> > Gee, Joel, I thought my review was the most valuable. :) > I will also help you revise your written content, if you > simply email me and > request it. Email me directly and I'll be sure to notice it. we'll talk > You boys quit fussing now. You both is cool. I. Have. Spoken. we can do that :) apologies for temporarily lowering SNR. consider this an IOU for a tip, should such occur to me. thanks to all who took what was clearly considerable time and effort to review and comment on the site. I have plenty to think about, and need to make sure my intense paternal feelings for this particular site don't get in the way of good advice. lots and lots of it. joel From joel at spinhead.com Fri Nov 24 00:45:02 2006 From: joel at spinhead.com (Joel D Canfield) Date: Thu, 23 Nov 2006 22:45:02 -0800 Subject: [thelist] should I speed optimize my site more? Message-ID: <72E9FAA171D63B48AAC707C72900E6B4A718EB@ireland.spinhead.com> > If anyone could check out my blog and let me know if I should > remove more > images, maybe even the non-productive Amazon widgets in the sidebar? well, personal pref: my 384k DSL slurped it right down, and I found myself perusing the goofy little bits and pieces, all the way down > I wish to optimize my site for download speed. All strident > opinions and > cranky harshing are welcome. optimize for download speed? eh, um, massive JPEGectomy. I can imagine that over dialup this wouldn't load before my grandchildren's time. but, I personally like my personal opinion above. it works for me. who else could you possible care about? joel From gsm_color at yahoo.com Fri Nov 24 01:07:57 2006 From: gsm_color at yahoo.com (Kane Wilson) Date: Thu, 23 Nov 2006 23:07:57 -0800 (PST) Subject: [thelist] File uploading ISSUE Message-ID: <20061124070757.91426.qmail@web33410.mail.mud.yahoo.com> Actually , it's not clear . That php hosted in apache web server and MIME types are in /etc/mime.types. what are the other things i have to do for capture all the MIME types with relative of uploaded file ? Please help me , Thank you, Kane. ----- Original Message ---- From: der wert <derwert at hotmail.com> To: thelist at lists.evolt.org Sent: Thursday, November 23, 2006 8:03:48 PM Subject: Re: [thelist] File uploading ISSUE when uploading files the mime type is set by your browser, this means it can be different depending on which browser you are usingmake sure to use a whitelist of allowed file extensions for your upload script _________________________________________________________________ Express yourself with gadgets on Windows Live Spaces http://discoverspaces.live.com?source=hmtag1&loc=us -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! ____________________________________________________________________________________ Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com From steven.streight at gmail.com Fri Nov 24 02:43:48 2006 From: steven.streight at gmail.com (Steven Streight) Date: Fri, 24 Nov 2006 02:43:48 -0600 Subject: [thelist] should I speed optimize my site more? In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B4A718EB@ireland.spinhead.com> References: <72E9FAA171D63B48AAC707C72900E6B4A718EB@ireland.spinhead.com> Message-ID: <fad66b420611240043v540e41fbx3770cf90c99dbc2f@mail.gmail.com> JPEGectomy done, Amazon gone, Digg feedroll gone, almost all ads gone, most sidebar photos gone, miscellaneous junk gone. I feel refreshed and free. I'm also axing the word verification for comments, since I have comment moderation. And I"m tinkering with background colors, etc. Blog surgery is not so painful. Thanks guys. Big time. > > I wish to optimize my site for download speed. All strident > > opinions and > > cranky harshing are welcome. > > optimize for download speed? eh, um, massive JPEGectomy. I can imagine > that over dialup this wouldn't load before my grandchildren's time. > > but, I personally like my personal opinion above. it works for me. who > else could you possible care about? > > joel > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- Steven Streight aka Vaspers the Grate Web Usability. IT. Ecommerce. Video. Vaspers the Grate http://www.vaspersthegrate.blogspot.com Corporate Blog Revolution http://electrica.wordpress.com From codepo8 at gmail.com Fri Nov 24 08:27:54 2006 From: codepo8 at gmail.com (Christian Heilmann) Date: Fri, 24 Nov 2006 14:27:54 +0000 Subject: [thelist] Del.icio.us data and JavaScript made easy Message-ID: <30bd6ffd0611240627h31279e73m9c1befd236acdbdf@mail.gmail.com> Hello there, I just threw out a helper library (well one object, really) for using data from del.icio.us with JSON. Maybe you can find it useful, too. http://icant.co.uk/sandbox/dishy/ -- Chris Heilmann Book: http://www.beginningjavascript.com Blog: http://www.wait-till-i.com Writing: http://icant.co.uk/ From evolt at davestevens.co.uk Fri Nov 24 09:36:22 2006 From: evolt at davestevens.co.uk (Dave Stevens) Date: Fri, 24 Nov 2006 15:36:22 +0000 Subject: [thelist] simple sql question In-Reply-To: <4566837A.9020308@hondaswap.com> References: <4566837A.9020308@hondaswap.com> Message-ID: <45671176.80701@davestevens.co.uk> Hi Brian, I'm sure more knowledgeable list members will be able to advise you of a better method, but I would do: DELETE FROM files WHERE fileid IN (SELECT max(fileid) FROM files GROUP BY title HAVING count(*) >1) Hope this helps. Dave Brian Cummiskey wrote: > how do i re-write this as a DELETE statement instead of a SELECT? I'm > pruing out some duplicate files... > > > SELECT max(fileid) FROM files > GROUP BY title HAVING count(*) >1 > > > Everytime i try to delete it via phpmyadmin on the X, it gives me the > following error: > > Error > *SQL query:* > > DELETE FROM `files` WHERE `files`.`max( fileid )` =563 LIMIT 1 > > *MySQL said: * > | #1054 - Unknown column 'files.max( fileid )' in 'where clause' From mwarden at gmail.com Fri Nov 24 14:05:44 2006 From: mwarden at gmail.com (Matt Warden) Date: Fri, 24 Nov 2006 15:05:44 -0500 Subject: [thelist] simple sql question In-Reply-To: <4566837A.9020308@hondaswap.com> References: <4566837A.9020308@hondaswap.com> Message-ID: <bbc8fa430611241205l2e182309o9f0c86129a508a8c@mail.gmail.com> On 11/24/06, Brian Cummiskey <brian at hondaswap.com> wrote: > SELECT max(fileid) FROM files > GROUP BY title HAVING count(*) >1 I assume you want to delete the record with the maximum fileid for each title. Something like this should get you started in the right direction: delete from files where fileid in ( select max(fileid) from files group by title ) This assumes that fileid is the sole member of a candidate key. -- Matt Warden Cleveland, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From pturmel-webdev at turmel.org Fri Nov 24 19:17:35 2006 From: pturmel-webdev at turmel.org (Phil Turmel) Date: Fri, 24 Nov 2006 20:17:35 -0500 Subject: [thelist] simple sql question In-Reply-To: <4566837A.9020308@hondaswap.com> Message-ID: <E1GnmAh-0000SQ-Kf@alt.turmel.org> On 11/24/2006, "Brian Cummiskey" <brian at hondaswap.com> wrote: >how do i re-write this as a DELETE statement instead of a SELECT? I'm >pruing out some duplicate files... > >SELECT max(fileid) FROM files >GROUP BY title HAVING count(*) >1 > >Everytime i try to delete it via phpmyadmin on the X, it gives me the >following error: > >DELETE FROM `files` WHERE `files`.`max( fileid )` =563 LIMIT 1 > >*MySQL said: * >| #1054 - Unknown column 'files.max( fileid )' in 'where clause' > Brian, Try something like this: DELETE FROM `files` WHERE fileid IN (SELECT max(fileid) FROM files GROUP BY title HAVING count(*)>1) Note that you need a sub-query capable db to do this. Otherwise you'll have to script it in two operations... Also, I left out the "LIMIT 1" clause, as I'm not exactly sure what you wanted it to accomplish. Add it back if your testing suggests you need it. (You are going to test this, right?) HTH, Phil From chilijoe at gmail.com Fri Nov 24 23:09:13 2006 From: chilijoe at gmail.com (Joe Ngo) Date: Sat, 25 Nov 2006 13:09:13 +0800 Subject: [thelist] simple sql question In-Reply-To: <4566837A.9020308@hondaswap.com> References: <4566837A.9020308@hondaswap.com> Message-ID: <6a81c2300611242109j2243412ey2631b2c64b444496@mail.gmail.com> On 11/24/06, Brian Cummiskey <brian at hondaswap.com> wrote: > > how do i re-write this as a DELETE statement instead of a SELECT? I'm > pruing out some duplicate files... > > > SELECT max(fileid) FROM files > GROUP BY title HAVING count(*) >1 > > What version of MySQL are you using? Earlier versions does not support subqueries, in which case the following will not work: DELETE FROM files Where fileid NOT IN (SELECT min(fileid) FROM files GROUP BY title HAVING count(*) >1) Since you're trying to remove duplicates, the above deletion retains the min(fileid) of the same title. You don't have to iterate more than once when there are multiple duplicates for a title. -- http://xtrahot.chili-mango.net There's still no place like ~ From chilijoe at gmail.com Fri Nov 24 23:19:59 2006 From: chilijoe at gmail.com (Joe Ngo) Date: Sat, 25 Nov 2006 13:19:59 +0800 Subject: [thelist] simple sql question In-Reply-To: <6a81c2300611242109j2243412ey2631b2c64b444496@mail.gmail.com> References: <4566837A.9020308@hondaswap.com> <6a81c2300611242109j2243412ey2631b2c64b444496@mail.gmail.com> Message-ID: <6a81c2300611242119s2e8452eagdd1fc121b4d76ce5@mail.gmail.com> On 11/25/06, Joe Ngo <chilijoe at gmail.com> wrote: > > > DELETE FROM files > Where fileid NOT IN > (SELECT min(fileid) FROM files > GROUP BY title HAVING count(*) >1) > > I goofed. Hoped you haven't tried that yet. It will also delete titles that don't have duplicates. Should be: DELETE FROM files Where fileid NOT IN (SELECT min(fileid) FROM files GROUP BY title) -- http://xtrahot.chili-mango.net There's still no place like ~ From Wendy_Fite at ao.uscourts.gov Tue Nov 21 15:19:28 2006 From: Wendy_Fite at ao.uscourts.gov (Wendy_Fite at ao.uscourts.gov) Date: Tue, 21 Nov 2006 16:19:28 -0500 Subject: [thelist] CN=Wendy Fite/OU=DCA/OU=AO/O=USCOURTS is out of the office. Message-ID: <OFAD10AA4C.FE393AAD-ON8525722D.007523A3-8525722D.007523A3@uscmail.uscourts.gov> I will be out of the office starting 11/21/2006 and will not return until 11/29/2006. I am out of the office today. Please contact Cindy_Green at ao.uscourts.gov if you need immediate assistance. From steven.streight at gmail.com Sun Nov 26 14:49:36 2006 From: steven.streight at gmail.com (Steven Streight) Date: Sun, 26 Nov 2006 14:49:36 -0600 Subject: [thelist] a malicious site? Message-ID: <fad66b420611261249r5d527570n2ae055e525d10ceb@mail.gmail.com> I have never encountered a browser message, on Firefox, asking me to launch Windows Media Player, to view a home page. www.aniboom.com is a video site dedicated to animation videos. I received an email from aniBOOM asking me to check out the site and comment on it in my blog. Please let me know if this site is safe, because I'd like to help the guy out, but I'm no chump. -- Steven Streight aka Vaspers the Grate Web Usability. Universal Content Utopia. Share Economy. Destroying the MSM Vaspers the Grate http://www.vaspersthegrate.blogspot.com From julian.rickards at gmail.com Sun Nov 26 14:58:56 2006 From: julian.rickards at gmail.com (Julian Rickards) Date: Sun, 26 Nov 2006 15:58:56 -0500 Subject: [thelist] a malicious site? In-Reply-To: <fad66b420611261249r5d527570n2ae055e525d10ceb@mail.gmail.com> References: <fad66b420611261249r5d527570n2ae055e525d10ceb@mail.gmail.com> Message-ID: <7613e9690611261258o16ec8005wd93df832a9f774bc@mail.gmail.com> I didn't get that prompt. On 26/11/06, Steven Streight <steven.streight at gmail.com> wrote: > > I have never encountered a browser message, on Firefox, asking me to > launch > Windows Media Player, to view a home page. -- Website: http://jrickards.ca Blog: http://pen-and-ink.ca E-mail: julian dot rickards at gmail dot com From joel at spinhead.com Sun Nov 26 18:01:42 2006 From: joel at spinhead.com (Joel D Canfield) Date: Sun, 26 Nov 2006 16:01:42 -0800 Subject: [thelist] a malicious site? Message-ID: <72E9FAA171D63B48AAC707C72900E6B4A718F2@ireland.spinhead.com> > I didn't get that prompt. > > On 26/11/06, Steven Streight <steven.streight at gmail.com> wrote: > > > > I have never encountered a browser message, on Firefox, asking me to > > launch > > Windows Media Player, to view a home page. this is the prompt I got: http://www.joeldcanfield.com/images/aniboom.gif no thanks. joel