From reo80 at gadishproperties.com Mon Jul 20 13:18:39 2009 From: reo80 at gadishproperties.com (Gadish REO80) Date: Mon, 20 Jul 2009 11:18:39 -0700 Subject: [thelist] Shopping Cart / Licensing package Message-ID: My employer wants to set up a system where he sells limited-term access to parts of his website, sort of like the way porn sites do. [no it's not!] They want to put up what are essentially e-books and sell short term access licenses allowing purchasers to read them online. Google tells me that there are lots of packages out there that do all or part of this. Does anyone have any good or bad things to say about their most or least favorite? Edward McCarroll Gadish Properties 4221 Wilshire Blvd. Suite 395 Los Angeles, CA 90010 Tel: (323)934-1430 Email: reo80 at GadishProperties.com Web: www.GadishProperties.com REO Brokers of California - Your Source for REOs / Foreclosures __________ Information from ESET NOD32 Antivirus, version of virus signature database 3553 (20081024) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com From nan at nanharbison.com Mon Jul 20 15:22:28 2009 From: nan at nanharbison.com (Nan Harbison) Date: Mon, 20 Jul 2009 16:22:28 -0400 Subject: [thelist] photo copyrights Message-ID: Evolters, I am about to do a website for a former US Olympic athlete. She wants to use several of the photos taken of her during the Olympics, and afterwards, like when Campbell Soup used a photo of her (and paid her for it). Another photo was in Life Magazine. So the question is - what about the copyrights on these photos? Since they are of her, does she have any rights to use them on her website for her business? Or does she have to track down the photographers, call Campbell Soup, etc. and get their permissions? Thanks, Nan From nan at nanharbison.com Mon Jul 20 15:36:40 2009 From: nan at nanharbison.com (Nan Harbison) Date: Mon, 20 Jul 2009 16:36:40 -0400 Subject: [thelist] photo copyrights In-Reply-To: References: Message-ID: <1D0CF5083302404483EC82350EC6B8DF@nancyb0bda4ba6> Thanks Paul, it is a good opportunity. I am psyched! This is what I thought about getting permission. Could she claim that she didn't know any better? Does that hold up in court? Or could she have the pants sued off of her? She doesn't remember signing any contracts, which I have a hard time believing, I think she may have forgotten. Thanks again, Nan -----Original Message----- From: Paul Bennett [mailto:Paul.Bennett at mch.govt.nz] Sent: Monday, July 20, 2009 4:29 PM To: nan at nanharbison.com; thelist at lists.evolt.org Subject: RE: [thelist] photo copyrights Hi Nan, First of all - this sounds like a great opportunity :) Depending upon the contracts she signed, she may have waived the rights to those photos when they were taken. As she got paid for them, the photos may become the property of the company which commissioned them. Ditto for the other photos - unless you want a nasty 'cease and desist' letter (or a court summons) you need to seek and get permission from the individuals or companies who own the rights. Paul -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Nan Harbison Sent: Tuesday, 21 July 2009 8:22 a.m. To: thelist at lists.evolt.org Subject: [thelist] photo copyrights Evolters, I am about to do a website for a former US Olympic athlete. She wants to use several of the photos taken of her during the Olympics, and afterwards, like when Campbell Soup used a photo of her (and paid her for it). Another photo was in Life Magazine. So the question is - what about the copyrights on these photos? Since they are of her, does she have any rights to use them on her website for her business? Or does she have to track down the photographers, call Campbell Soup, etc. and get their permissions? Thanks, Nan -- * * 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 ! www.mch.govt.nz - www.teara.govt.nz - www.nzhistory.net.nz - www.nzlive.com The information contained in this email message does not necessarily reflect the views of the Ministry for Culture and Heritage and may contain information that is confidential or subject to legal privilege. If you are not the intended recipient and receive this email in error: please notify the Ministry for Culture and Heritage by return email or telephone (64 4 499 4229) and delete this email; you must not use, disclose, copy or distribute this message or the information in it. PLEASE CONSIDER THE ENVIRONMENT BEFORE YOU PRINT THIS EMAIL From niklaso at swipnet.se Mon Jul 20 15:27:01 2009 From: niklaso at swipnet.se (Niklas) Date: Mon, 20 Jul 2009 22:27:01 +0200 Subject: [thelist] photo copyrights In-Reply-To: References: Message-ID: <4A64D315.1000100@swipnet.se> Nan Harbison wrote: > Evolters, > > I am about to do a website for a former US Olympic athlete. She wants to use > several of the photos taken of her during the Olympics, and afterwards, like > when Campbell Soup used a photo of her (and paid her for it). Another photo > was in Life Magazine. > > So the question is - what about the copyrights on these photos? Since they > are of her, does she have any rights to use them on her website for her > business? Or does she have to track down the photographers, call Campbell > Soup, etc. and get their permissions? > > Thanks, > > Nan > Hi Nan, Without knowing the exact rules in the different countries I would say generally she would not have any rights to use them as they are the property of the photographer or the company that had them taken. I guess there could be exceptions though. Asking if you can use them is probably a good idea either way. /Niklas From Paul.Bennett at mch.govt.nz Mon Jul 20 15:28:46 2009 From: Paul.Bennett at mch.govt.nz (Paul Bennett) Date: Tue, 21 Jul 2009 08:28:46 +1200 Subject: [thelist] photo copyrights In-Reply-To: Message-ID: Hi Nan, First of all - this sounds like a great opportunity :) Depending upon the contracts she signed, she may have waived the rights to those photos when they were taken. As she got paid for them, the photos may become the property of the company which commissioned them. Ditto for the other photos - unless you want a nasty 'cease and desist' letter (or a court summons) you need to seek and get permission from the individuals or companies who own the rights. Paul -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Nan Harbison Sent: Tuesday, 21 July 2009 8:22 a.m. To: thelist at lists.evolt.org Subject: [thelist] photo copyrights Evolters, I am about to do a website for a former US Olympic athlete. She wants to use several of the photos taken of her during the Olympics, and afterwards, like when Campbell Soup used a photo of her (and paid her for it). Another photo was in Life Magazine. So the question is - what about the copyrights on these photos? Since they are of her, does she have any rights to use them on her website for her business? Or does she have to track down the photographers, call Campbell Soup, etc. and get their permissions? Thanks, Nan -- * * 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 ! www.mch.govt.nz - www.teara.govt.nz - www.nzhistory.net.nz - www.nzlive.com The information contained in this email message does not necessarily reflect the views of the Ministry for Culture and Heritage and may contain information that is confidential or subject to legal privilege. If you are not the intended recipient and receive this email in error: please notify the Ministry for Culture and Heritage by return email or telephone (64 4 499 4229) and delete this email; you must not use, disclose, copy or distribute this message or the information in it. PLEASE CONSIDER THE ENVIRONMENT BEFORE YOU PRINT THIS EMAIL From symeon at systasis.com Mon Jul 20 15:41:04 2009 From: symeon at systasis.com (Symeon Charalabides) Date: Mon, 20 Jul 2009 21:41:04 +0100 Subject: [thelist] photo copyrights In-Reply-To: References: Message-ID: <4A64D660.6060001@systasis.com> Hi Nan, Photographs are generally copyrighted to the photographers/publications by default and the subject don't generally enjoy great privileges, although they have a good stab at "fair use" as you might expect. She has to track them down and ask for permission to use the images. It shouldn't be a problem as photography copyright holders usually allow free access to the subject - it's only a distinct group of people after all. If she gets any hassle from them, she should subtly suggest how she's going to cry blue murder at the greedy corporations making money off our (your) esteemed athletes etc. > I am about to do a website for a former US Olympic athlete. She wants to use > several of the photos taken of her during the Olympics, and afterwards, like > when Campbell Soup used a photo of her (and paid her for it). Another photo > was in Life Magazine. > > So the question is - what about the copyrights on these photos? Since they > are of her, does she have any rights to use them on her website for her > business? Or does she have to track down the photographers, call Campbell > Soup, etc. and get their permissions? -- Symeon Charalabides (cosmopolite trainee) ----------------------------------------- http://www.systasis.com http://twitter.com/bluesymeon http://www.linkedin.com/in/symeon http://www.last.fm/user/bluesymeon From Paul.Bennett at mch.govt.nz Mon Jul 20 16:28:36 2009 From: Paul.Bennett at mch.govt.nz (Paul Bennett) Date: Tue, 21 Jul 2009 09:28:36 +1200 Subject: [thelist] photo copyrights In-Reply-To: <4A64D315.1000100@swipnet.se> Message-ID: Hi Nan, You'll be surprised at what response you get when you just ask. Many people may be happy to have their photos on the site so long as the appropriate image credit is given. Paul -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Niklas Sent: Tuesday, 21 July 2009 8:27 a.m. To: thelist at lists.evolt.org Subject: Re: [thelist] photo copyrights Nan Harbison wrote: > Evolters, > > I am about to do a website for a former US Olympic athlete. She wants to use > several of the photos taken of her during the Olympics, and afterwards, like > when Campbell Soup used a photo of her (and paid her for it). Another photo > was in Life Magazine. > > So the question is - what about the copyrights on these photos? Since they > are of her, does she have any rights to use them on her website for her > business? Or does she have to track down the photographers, call Campbell > Soup, etc. and get their permissions? > > Thanks, > > Nan > Hi Nan, Without knowing the exact rules in the different countries I would say generally she would not have any rights to use them as they are the property of the photographer or the company that had them taken. I guess there could be exceptions though. Asking if you can use them is probably a good idea either way. /Niklas -- * * 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 ! www.mch.govt.nz - www.teara.govt.nz - www.nzhistory.net.nz - www.nzlive.com The information contained in this email message does not necessarily reflect the views of the Ministry for Culture and Heritage and may contain information that is confidential or subject to legal privilege. If you are not the intended recipient and receive this email in error: please notify the Ministry for Culture and Heritage by return email or telephone (64 4 499 4229) and delete this email; you must not use, disclose, copy or distribute this message or the information in it. PLEASE CONSIDER THE ENVIRONMENT BEFORE YOU PRINT THIS EMAIL From laurel at artistcrafts.com Mon Jul 20 19:25:23 2009 From: laurel at artistcrafts.com (Laurel S. Nevans) Date: Mon, 20 Jul 2009 20:25:23 -0400 Subject: [thelist] photo copyrights References: Message-ID: <0C402628B4514B6F9A275C491BBE3BE5@LaurelsLap> I am a part time craft-artist, and as such, had my picture appear on the front of the local paper. My sister is a former Newspaper Reporter. I asked her about reprinting my cover on my website, in marketing materials, etc. She told me that I had a certain right to "fair use" of my image in marketing materials. However, she said that I should include the WHOLE fromt page in any scan, and be sure to include the newspaper's masthead and any photo credit/caption in the scan. In terms of advising me on web design customers, who don't seem to understand that they just cant "save as" that picture of them on that website and use it on their own, she advised me that I needed to get permission from the newspaper to reprint any copy, and permission from both the publisher and the photographer to reproduce any photo. Depending on the photographer's contract with the paper, either the photographer or the publication may own the photo copyright. (Did they employ the photographer, as in he was on staff, on which case the paper generally owns the photo. Or did they buy single photos from a freelancer, in which case it's doubtful the paper owns the copyright.) I'm sure most advertisers fair use policies run along the lines of the newspapers: you must reproduce the ad in its entirety, rather than just clip the image. I'd probably send a screen shot of the ad's intended use with a cover letter to their corporate offices, just for the CYA factor. If I was handling a client of any "note", I'd probably also see what someplace like Getty Images has and what they'd charge for use. The advantage to purchaseing images from places like that is that they handle all of that legal use stuff for you. Usual disclosures. IANAL. YMMV. Laurel Nevans Independent Computer Guru Sunny FL, USA From mac.jordan at gmail.com Tue Jul 21 02:03:54 2009 From: mac.jordan at gmail.com (mac jordan) Date: Tue, 21 Jul 2009 08:03:54 +0100 Subject: [thelist] photo copyrights In-Reply-To: <1D0CF5083302404483EC82350EC6B8DF@nancyb0bda4ba6> References: <1D0CF5083302404483EC82350EC6B8DF@nancyb0bda4ba6> Message-ID: On Mon, Jul 20, 2009 at 9:36 PM, Nan Harbison wrote: > This is what I thought about getting permission. Could she claim that she > didn't know any better? > Does that hold up in court? Or could she have the pants sued off of her? > But *you* do. And you have been informed on a publicly searchable web list. Don't do it. -- mac jordan www.webhorus.net | www.reactivecooking.com | www.nibblous.com | www.jordan-cats.org twitter: @ramtops From chris.price at choctaw.co.uk Mon Jul 20 15:56:08 2009 From: chris.price at choctaw.co.uk (Chris Price) Date: Mon, 20 Jul 2009 21:56:08 +0100 Subject: [thelist] photo copyrights In-Reply-To: References: Message-ID: <4A64D9E8.4050005@choctaw.co.uk> Nan Harbison wrote: > Evolters, > > I am about to do a website for a former US Olympic athlete. She wants to use > several of the photos taken of her during the Olympics, and afterwards, like > when Campbell Soup used a photo of her (and paid her for it). Another photo > was in Life Magazine. > > So the question is - what about the copyrights on these photos? Since they > are of her, does she have any rights to use them on her website for her > business? Or does she have to track down the photographers, call Campbell > Soup, etc. and get their permissions? > > Thanks, > > Nan > My understanding is that the photos are the property of the author by default unless the rights are signed over to another. If the photographer is freelance, he/she owns the copyright, if employed then the employer owns it. If your client could use the photos without permission that would mean she either owned the copyright, in which case others would need to seek her permission, or that they were public domain. In any case, if you are unsure you should seek permission. If you don't need it then that's a bonus. -- Kind Regards Chris Price Choctaw chris.price at choctaw.co.uk www.choctaw.co.uk Tel. 01524 825 245 Mob. 0777 629 0227 Choctaw Media Fertile Ground for Websites Follow me on Twitter Catch up with me on LinkedIn Its a Living Thing~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Sent on behalf of Choctaw Media Ltd << ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Choctaw Media Limited is a company registered in England and Wales with company number 04627649 Registered Office: Priory Close, St Mary's Gate, Lancaster LA1 1XB, United Kingdom. From symeon at systasis.com Tue Jul 21 03:56:16 2009 From: symeon at systasis.com (=?utf-8?Q?Symeon=20Charalabides?=) Date: Tue, 21 Jul 2009 08:56:16 +0000 Subject: [thelist] =?utf-8?q?photo_copyrights?= Message-ID: <20090721085616.22665.qmail@station187.com> Nan, > > This is what I thought about getting permission. Could she claim that she > > didn't know any better? > > Does that hold up in court? Or could she have the pants sued off of her? > > But *you* do.??And you have been informed on a publicly searchable web list. Even if neither of you did, and you had never asked and never been informed, a staple of law internationally is that ignorance of the law does NOT constitute a valid defence, ever. Just ask for permission to use the images. The chances are that you'll get it without problems. Symeon Charalabides (cosmopolite trainee) ----------------------------------------- http://www.systasis.com http://twitter.com/bluesymeon http://www.linkedin.com/in/symeon http://www.last.fm/user/bluesymeon From nan at nanharbison.com Tue Jul 21 05:21:37 2009 From: nan at nanharbison.com (Nan Harbison) Date: Tue, 21 Jul 2009 06:21:37 -0400 Subject: [thelist] photo copyrights In-Reply-To: References: <1D0CF5083302404483EC82350EC6B8DF@nancyb0bda4ba6> Message-ID: excellent point! Thanks, Nan _____ From: mac jordan [mailto:mac.jordan at gmail.com] Sent: Tuesday, July 21, 2009 3:04 AM To: nan at nanharbison.com; thelist at lists.evolt.org Subject: Re: [thelist] photo copyrights On Mon, Jul 20, 2009 at 9:36 PM, Nan Harbison wrote: This is what I thought about getting permission. Could she claim that she didn't know any better? Does that hold up in court? Or could she have the pants sued off of her? But *you* do. And you have been informed on a publicly searchable web list. Don't do it. -- mac jordan www.webhorus.net | www.reactivecooking.com | www.nibblous.com | www.jordan-cats.org twitter: @ramtops From nan at nanharbison.com Tue Jul 21 05:22:25 2009 From: nan at nanharbison.com (Nan Harbison) Date: Tue, 21 Jul 2009 06:22:25 -0400 Subject: [thelist] photo copyrights In-Reply-To: <0C402628B4514B6F9A275C491BBE3BE5@LaurelsLap> References: <0C402628B4514B6F9A275C491BBE3BE5@LaurelsLap> Message-ID: Thanks everyone for all of your helpful advice! Nan -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Laurel S. Nevans Sent: Monday, July 20, 2009 8:25 PM To: thelist at lists.evolt.org Subject: Re: [thelist] photo copyrights I am a part time craft-artist, and as such, had my picture appear on the front of the local paper. My sister is a former Newspaper Reporter. I asked her about reprinting my cover on my website, in marketing materials, etc. She told me that I had a certain right to "fair use" of my image in marketing materials. However, she said that I should include the WHOLE fromt page in any scan, and be sure to include the newspaper's masthead and any photo credit/caption in the scan. In terms of advising me on web design customers, who don't seem to understand that they just cant "save as" that picture of them on that website and use it on their own, she advised me that I needed to get permission from the newspaper to reprint any copy, and permission from both the publisher and the photographer to reproduce any photo. Depending on the photographer's contract with the paper, either the photographer or the publication may own the photo copyright. (Did they employ the photographer, as in he was on staff, on which case the paper generally owns the photo. Or did they buy single photos from a freelancer, in which case it's doubtful the paper owns the copyright.) I'm sure most advertisers fair use policies run along the lines of the newspapers: you must reproduce the ad in its entirety, rather than just clip the image. I'd probably send a screen shot of the ad's intended use with a cover letter to their corporate offices, just for the CYA factor. If I was handling a client of any "note", I'd probably also see what someplace like Getty Images has and what they'd charge for use. The advantage to purchaseing images from places like that is that they handle all of that legal use stuff for you. Usual disclosures. IANAL. YMMV. Laurel Nevans Independent Computer Guru Sunny FL, USA -- * * 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 chris.price at choctaw.co.uk Tue Jul 21 06:48:33 2009 From: chris.price at choctaw.co.uk (Chris Price) Date: Tue, 21 Jul 2009 12:48:33 +0100 Subject: [thelist] photo copyrights In-Reply-To: References: <0C402628B4514B6F9A275C491BBE3BE5@LaurelsLap> Message-ID: <4A65AB11.7040108@choctaw.co.uk> Nan Harbison wrote: > Thanks everyone for all of your helpful advice! > Nan > > -----Original Message----- > > I am a part time craft-artist, and as such, had my picture appear on the > front of the local paper... > > Laurel Nevans > Independent Computer Guru > Sunny FL, USA > > Well Laurel, I wish I could get more advice like that. You've put all the other replies in the shade. Nothing like getting advice from someone who's been there, done it and got the T shirt. -- Kind Regards Chris Price Choctaw chris.price at choctaw.co.uk www.choctaw.co.uk Tel. 01524 825 245 Mob. 0777 629 0227 Choctaw Media Fertile Ground for Websites Follow me on Twitter Catch up with me on LinkedIn Its a Living Thing~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Sent on behalf of Choctaw Media Ltd << ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Choctaw Media Limited is a company registered in England and Wales with company number 04627649 Registered Office: Priory Close, St Mary's Gate, Lancaster LA1 1XB, United Kingdom. From fredthejonester at gmail.com Fri Jul 24 06:10:58 2009 From: fredthejonester at gmail.com (Fred Jones) Date: Fri, 24 Jul 2009 14:10:58 +0300 Subject: [thelist] Stuck on SQL Message-ID: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> I have this: SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) FROM civicrm_contact LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id LEFT JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id GROUP BY civicrm_contact.id; which is good. I get results like 1 4 2 0 3 0 5 3 What I really want, however, is to get all contacts which do NOT have a tag where the tag name is: civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" I don't care if he has zero tags or if he has 6 tags. I just care that he has zero tags where the tag has "Primary" or "Secondary" somewhere in its name. I am not succeeding in figuring out how to do this with one SQL. :( F From raoul.snyman at saturnlaboratories.co.za Fri Jul 24 06:27:58 2009 From: raoul.snyman at saturnlaboratories.co.za (Raoul Snyman) Date: Fri, 24 Jul 2009 13:27:58 +0200 Subject: [thelist] Stuck on SQL In-Reply-To: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> References: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> Message-ID: <1ea79c4539c7c5d49c3dffc95edb4542@localhost> On Fri, 24 Jul 2009 14:10:58 +0300, Fred Jones wrote: > What I really want, however, is to get all contacts which do NOT have > a tag where the tag name is: > > civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" SELECT civicrm_contact.id, COUNT(civicrm_entity_tag.tag_id) FROM civicrm_contact LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id LEFT JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id WHERE civicrm_tag.name NOT LIKE "%Primary%" AND civicrm_tag.name NOT LIKE "%Secondary%" GROUP BY civicrm_contact.id This should work in MySQL, not sure about PostgreSQL but I don't see why not. -- Raoul Snyman, B.Tech IT (Software Engineering) Saturn Laboratories e: raoul.snyman at saturnlaboratories.co.za w: http://www.saturnlaboratories.co.za/ b: http://blog.saturnlaboratories.co.za/ http://raoulsnyman.co.za/ From fredthejonester at gmail.com Fri Jul 24 08:20:12 2009 From: fredthejonester at gmail.com (Fred Jones) Date: Fri, 24 Jul 2009 16:20:12 +0300 Subject: [thelist] Stuck on SQL In-Reply-To: <1ea79c4539c7c5d49c3dffc95edb4542@localhost> References: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> <1ea79c4539c7c5d49c3dffc95edb4542@localhost> Message-ID: <177c0a10907240620q316dba9nd229fb8a44b2bdc4@mail.gmail.com> > WHERE > ?civicrm_tag.name NOT LIKE "%Primary%" AND civicrm_tag.name NOT LIKE > "%Secondary%" > GROUP BY > ?civicrm_contact.id > > This should work in MySQL, not sure about PostgreSQL but I don't see why > not. It's MySQL but the problem is what if someone has two tags, on "Joe" and one "Primary." He will be found by your query due to "Joe" but due to "Primary" I actually do NOT want him. F From Chris at activeide.com Fri Jul 24 06:39:24 2009 From: Chris at activeide.com (Chris Anderson) Date: Fri, 24 Jul 2009 12:39:24 +0100 Subject: [thelist] Stuck on SQL References: <2DD9ACEEE232498FB70450647B20E8CC@ActiveIDE.local> Message-ID: <09DEC79B6F995248B402303C86CA491244E5FE@scarlet.ActiveIDE.local> > What I really want, however, is to get all contacts which do NOT have > a tag where the tag name is: > > civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" > > I don't care if he has zero tags or if he has 6 tags. I just care that > he has zero tags where the tag has "Primary" or "Secondary" somewhere > in its name. > > I am not succeeding in figuring out how to do this with one SQL. :( How about counting the number of tags, then using the HAVING clause to just select those with 0 tags: SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) FROM civicrm_contact LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id LEFT JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id WHERE civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" GROUP BY civicrm_contact.id HAVING COUNT(civicrm_entity_tag.tag_id) = 0 Chris From fredthejonester at gmail.com Fri Jul 24 08:25:14 2009 From: fredthejonester at gmail.com (Fred Jones) Date: Fri, 24 Jul 2009 16:25:14 +0300 Subject: [thelist] Stuck on SQL In-Reply-To: <09DEC79B6F995248B402303C86CA491244E5FE@scarlet.ActiveIDE.local> References: <2DD9ACEEE232498FB70450647B20E8CC@ActiveIDE.local> <09DEC79B6F995248B402303C86CA491244E5FE@scarlet.ActiveIDE.local> Message-ID: <177c0a10907240625wa8859e1v42080dd174258d6c@mail.gmail.com> > How about counting the number of tags, then using the HAVING clause to just select those with 0 tags: > > SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) > ?FROM civicrm_contact > ?LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = > civicrm_contact.id > ?LEFT JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id > WHERE civicrm_tag.name LIKE "%Primary%" ?OR civicrm_tag.name ?LIKE "%Secondary%" > GROUP BY civicrm_contact.id > HAVING COUNT(civicrm_entity_tag.tag_id) = 0 I tried such a thing but it gets zero rows. Based on what Rudy did for me once, I actually think it's like this: SELECT civicrm_contact.id FROM civicrm_contact LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id LEFT JOIN (SELECT id FROM civicrm_tag WHERE civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%") AS derivedtable ON derivedtable.id = civicrm_entity_tag.tag_id WHERE derivedtable.id IS NULL GROUP BY civicrm_contact.id but I can't get it right. :( I think the trick is to use a derived table for the join. That was his trick. From mwarden at gmail.com Fri Jul 24 08:58:13 2009 From: mwarden at gmail.com (Matt Warden) Date: Fri, 24 Jul 2009 09:58:13 -0400 Subject: [thelist] Stuck on SQL In-Reply-To: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> References: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> Message-ID: On Fri, Jul 24, 2009 at 7:10 AM, Fred Jones wrote: > I have this: > > SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) > ?FROM civicrm_contact > ?LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = > civicrm_contact.id > ?LEFT JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id > ?GROUP BY civicrm_contact.id; > > which is good. I get results like > > 1 ?4 > 2 ?0 > 3 ?0 > 5 ?3 > > What I really want, however, is to get all contacts which do NOT have > a tag where the tag name is: > > civicrm_tag.name LIKE "%Primary%" ?OR civicrm_tag.name ?LIKE "%Secondary%" > > I don't care if he has zero tags or if he has 6 tags. I just care that > he has zero tags where the tag has "Primary" or "Secondary" somewhere > in its name. So ask that question. Untested... SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) FROM civicrm_contact WHERE 1 > ( select count(*) from civicrm_entity_tag inner join civicrm_tag on civicrm_tag.id = civicrm_entity_tag.tag_id where civicrm_entity_tag.contact_id = civicrm_contact.id AND civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" ); I didn't understand why you had left joins. Apologies if I missed a part of your logic... -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From fredthejonester at gmail.com Fri Jul 24 09:18:38 2009 From: fredthejonester at gmail.com (Fred Jones) Date: Fri, 24 Jul 2009 17:18:38 +0300 Subject: [thelist] Stuck on SQL In-Reply-To: References: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> Message-ID: <177c0a10907240718k584659d7qbf260da7ee2700ef@mail.gmail.com> > Untested... > > SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) > FROM civicrm_contact > WHERE 1 > ( > ? ? ? ?select count(*) > ? ? ? ?from civicrm_entity_tag > ? ? ? ?inner join civicrm_tag > ? ? ? ? ? ? ? ?on civicrm_tag.id = civicrm_entity_tag.tag_id > ? ? ? ?where civicrm_entity_tag.contact_id = > ? ? ? ? ? ? ? ?civicrm_contact.id > ? ? ? ? ? ? ? ?AND civicrm_tag.name LIKE "%Primary%" > ? ? ? ? ? ? ? ?OR civicrm_tag.name ?LIKE "%Secondary%" > ); > > I didn't understand why you had left joins. Apologies if I missed a > part of your logic... That was just the code the last guy had. If we remove the first COUNT from your select, then it runs, but it brings no results, whether I use 1 > or 1 =. I know, BTW, that there are results to what I want. :) Thanks however. I will keep working on it. Now I have more ideas anyhow. :) From pturmel-webdev at turmel.org Fri Jul 24 09:52:35 2009 From: pturmel-webdev at turmel.org (Phil Turmel) Date: Fri, 24 Jul 2009 10:52:35 -0400 Subject: [thelist] Stuck on SQL In-Reply-To: <177c0a10907240625wa8859e1v42080dd174258d6c@mail.gmail.com> References: <2DD9ACEEE232498FB70450647B20E8CC@ActiveIDE.local> <09DEC79B6F995248B402303C86CA491244E5FE@scarlet.ActiveIDE.local> <177c0a10907240625wa8859e1v42080dd174258d6c@mail.gmail.com> Message-ID: <4A69CAB3.9020506@turmel.org> Fred Jones wrote: >> How about counting the number of tags, then using the HAVING clause to just select those with 0 tags: >> >> SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) >> FROM civicrm_contact >> LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = >> civicrm_contact.id >> LEFT JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id >> WHERE civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" >> GROUP BY civicrm_contact.id >> HAVING COUNT(civicrm_entity_tag.tag_id) = 0 > > I tried such a thing but it gets zero rows. Based on what Rudy did for > me once, I actually think it's like this: > > SELECT civicrm_contact.id > FROM civicrm_contact > LEFT JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = > civicrm_contact.id > LEFT JOIN (SELECT id FROM civicrm_tag WHERE civicrm_tag.name LIKE > "%Primary%" OR civicrm_tag.name LIKE "%Secondary%") AS derivedtable > ON derivedtable.id = civicrm_entity_tag.tag_id > > WHERE derivedtable.id IS NULL > GROUP BY civicrm_contact.id > > but I can't get it right. :( > > I think the trick is to use a derived table for the join. That was his trick. Hi Fred, I think you are on the right track. Try this (untested): SELECT civicrm_contact.id FROM civicrm_contact LEFT JOIN (SELECT civicrm_entity_tag.contact_id, civicrm_tag.id FROM civicrm_entity_tag INNER JOIN civicrm_tag ON civicrm_entity_tag.tag_id = civicrm.tag.id) AS derivedtable ON derivedtable.contact_id = civicrm_contact.id WHERE derivedtable.id IS NULL HTH, Phil Turmel From rudy at r937.com Fri Jul 24 09:25:11 2009 From: rudy at r937.com (r937) Date: Fri, 24 Jul 2009 10:25:11 -0400 Subject: [thelist] Stuck on SQL Message-ID: <334D271206C2423887C733B5E6CBE7AF@curly> fred, first of all, thanks for the kind words in the original query that you posted -- SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) FROM civicrm_contact LEFT OUTER JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id LEFT OUTER JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id GROUP BY civicrm_contact.id; you can actually remove the second join and get the same results ;o) so if this query produces the results you want, then we must leave this SELECT clause as is, because it counts the tags the contacts ~do~ have, and we want to keep showing that the qualification of which contacts survive the new filter criterion can easily be done with a subquery in the WHERE clause chris nailed it when he said "How about counting the number of tags, then using the HAVING clause to just select those with 0 tags" here's his query -- SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) FROM civicrm_contact LEFT OUTER JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id LEFT OUTER JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id WHERE civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" GROUP BY civicrm_contact.id HAVING COUNT(civicrm_entity_tag.tag_id) = 0 chris, you could've omitted COUNT(civicrm_entity_tag.tag_id) from the SELECT clause, because you know what it's going to be, right? note that here we do have to extend the joins to the tags table, in order to perform the test on the tag name however, WHERE is wrong, it has to be AND this query will identify all of those contacts for whom you want results returned by the original query, so we push it down a level of nesting, and make it a subquery in the WHERE clause... SELECT civicrm_contact.id , COUNT(civicrm_entity_tag.tag_id) FROM civicrm_contact LEFT OUTER JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id WHERE civicrm_contact.id IN ( SELECT civicrm_contact.id FROM civicrm_contact LEFT OUTER JOIN civicrm_entity_tag ON civicrm_entity_tag.contact_id = civicrm_contact.id LEFT OUTER JOIN civicrm_tag ON civicrm_tag.id = civicrm_entity_tag.tag_id AND ( civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%" ) GROUP BY civicrm_contact.id HAVING COUNT(civicrm_entity_tag.tag_id) = 0 ) GROUP BY civicrm_contact.id let me know if that works ;o) rudy http://simply-sql.com/ From jason.handby at corestar.co.uk Fri Jul 24 09:45:02 2009 From: jason.handby at corestar.co.uk (Jason Handby) Date: Fri, 24 Jul 2009 15:45:02 +0100 Subject: [thelist] Stuck on SQL In-Reply-To: <177c0a10907240718k584659d7qbf260da7ee2700ef@mail.gmail.com> References: <177c0a10907240410n1d0ea771m8322139bee302a34@mail.gmail.com> <177c0a10907240718k584659d7qbf260da7ee2700ef@mail.gmail.com> Message-ID: <9A50776858A21848A96469CDFCBCDEFF025E4C65@exch-be12.exchange.local> > That was just the code the last guy had. If we remove the first COUNT > from your select, then it runs, but it brings no results, whether I > use 1 > or 1 =. I know, BTW, that there are results to what I want. :) > > Thanks however. I will keep working on it. Now I have more ideas > anyhow. :) If you just want those contacts who have no tags containing "Primary" or "Secondary", and you don't need the tag count, something like this should work: SELECT civicrm_contact.id FROM civicrm_contact WHERE NOT EXISTS (SELECT * FROM civicrm_entity_tag INNER JOIN civicrm_tag ON civicrm_entity_tag.tag_id=civicrm_tag.id WHERE civicrm_entity_tag.contact_id=civicrm_contact.id AND (civicrm_tag.name LIKE "%Primary%" OR civicrm_tag.name LIKE "%Secondary%")) Jason From fredthejonester at gmail.com Sat Jul 25 15:39:09 2009 From: fredthejonester at gmail.com (Fred Jones) Date: Sat, 25 Jul 2009 23:39:09 +0300 Subject: [thelist] Stuck on SQL In-Reply-To: <334D271206C2423887C733B5E6CBE7AF@curly> References: <334D271206C2423887C733B5E6CBE7AF@curly> Message-ID: <177c0a10907251339l2eb05864p32657a8d77d11e67@mail.gmail.com> > fred, first of all, thanks for the kind words :) > however, WHERE is wrong, it has to be AND Ah, that's the trick this time. Yes, I don't think I ever would have thought of that. :) > this query will identify all of those contacts for whom you want results > returned by the original query, so we push it down a level of nesting, and > make it a subquery in the WHERE clause... > > ?SELECT civicrm_contact.id > ? ? ? , COUNT(civicrm_entity_tag.tag_id) > ? ?FROM civicrm_contact > ?LEFT OUTER > ? ?JOIN civicrm_entity_tag > ? ? ?ON civicrm_entity_tag.contact_id = civicrm_contact.id > ? WHERE civicrm_contact.id IN > ? ? ? ? ( SELECT civicrm_contact.id > ? ? ? ? ? ? FROM civicrm_contact > ? ? ? ? ? LEFT OUTER > ? ? ? ? ? ? JOIN civicrm_entity_tag > ? ? ? ? ? ? ? ON civicrm_entity_tag.contact_id = civicrm_contact.id > ? ? ? ? ? LEFT OUTER > ? ? ? ? ? ? JOIN civicrm_tag > ? ? ? ? ? ? ? ON civicrm_tag.id = civicrm_entity_tag.tag_id > ? ? ? ? ? ? ?AND ( > ? ? ? ? ? ? ? ? ?civicrm_tag.name LIKE "%Primary%" > ? ? ? ? ? ? ? OR civicrm_tag.name LIKE "%Secondary%" > ? ? ? ? ? ? ? ? ?) > ? ? ? ? ? GROUP > ? ? ? ? ? ? ? BY civicrm_contact.id > ? ? ? ? ? HAVING COUNT(civicrm_entity_tag.tag_id) = 0 ?) > ?GROUP > ? ? ?BY civicrm_contact.id > > let me know if that works Your basic query works, meaning the subquery above, and is actually all I need for the job at hand--the full query is not quite as I originally published--it's part of a system, but anyhow your solution is what I need. Your full solution, i.e. the whole query quote above, doesn't work for me--it took up my CPU for a few minutes so I restarted MySQL. No matter, however, the subquery is the answer. Thank you very much. From moseley at hank.org Sun Jul 26 14:50:11 2009 From: moseley at hank.org (Bill Moseley) Date: Sun, 26 Jul 2009 12:50:11 -0700 Subject: [thelist] Absolute positioned element and width 100% in IE Message-ID: <16f65d000907261250i401e8fd3j64598fa5ea94139a@mail.gmail.com> Playing with one of these bar graph layouts:
20%
I set the span (as a block element) to be relative to the "out" div and position it absolute. Yet, in IE setting the span 100% is 100% of the "bar" element. Other browsers it is 100% of the element marked "relative" (the "out"). Is there a trick to make IE use the relative block's width? Or is the only solution to set "width: 100px" directly on the span? #out { width: 100px; height: 60px; border: 1px solid red; position: relative; padding: 3px; } #out .bar { width: 20%; height: 100%; background-color: yellow; } #out .bar span { position: absolute; top: 0; left: 0; width: 100%; /* This is relative to enclosing block, not relative block */ height: 100%; text-align: center; border: 1px solid green; } -- Bill Moseley moseley at hank.org From jimmyropes at gmail.com Sun Jul 26 15:02:22 2009 From: jimmyropes at gmail.com (James O'Donnell) Date: Sun, 26 Jul 2009 16:02:22 -0400 Subject: [thelist] Absolute positioned element and width 100% in IE In-Reply-To: <16f65d000907261250i401e8fd3j64598fa5ea94139a@mail.gmail.com> References: <16f65d000907261250i401e8fd3j64598fa5ea94139a@mail.gmail.com> Message-ID: <004e01ca0e2b$fe08e9a0$fa1abce0$@com> It probably has to do with the way IE interprets the CSS box model, which is different than the W3C box model. Take a look at http://en.wikipedia.org/wiki/Internet_Explorer_box_model_bug It may explain what is happening. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Bill Moseley Sent: Sunday, 26 July, 2009 15:50 To: thelist at lists.evolt.org Subject: [thelist] Absolute positioned element and width 100% in IE Playing with one of these bar graph layouts:
20%
I set the span (as a block element) to be relative to the "out" div and position it absolute. Yet, in IE setting the span 100% is 100% of the "bar" element. Other browsers it is 100% of the element marked "relative" (the "out"). Is there a trick to make IE use the relative block's width? Or is the only solution to set "width: 100px" directly on the span? #out { width: 100px; height: 60px; border: 1px solid red; position: relative; padding: 3px; } #out .bar { width: 20%; height: 100%; background-color: yellow; } #out .bar span { position: absolute; top: 0; left: 0; width: 100%; /* This is relative to enclosing block, not relative block */ height: 100%; text-align: center; border: 1px solid green; } -- Bill Moseley moseley at hank.org -- * * 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 ! No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.31/2264 - Release Date: 07/26/09 11:07:00 From nan at nanharbison.com Sun Jul 26 18:02:36 2009 From: nan at nanharbison.com (Nan Harbison) Date: Sun, 26 Jul 2009 19:02:36 -0400 Subject: [thelist] Absolute positioned element and width 100% in IE In-Reply-To: <004e01ca0e2b$fe08e9a0$fa1abce0$@com> References: <16f65d000907261250i401e8fd3j64598fa5ea94139a@mail.gmail.com> <004e01ca0e2b$fe08e9a0$fa1abce0$@com> Message-ID: How funny that wikipedia calls this a bug. I thought Micro$oft did it this way on purpose to be the biggest pain in the *** they could possibly be! And I love this article on wikipedia, very well explained. I always have pointed people to the excellent 456BereaStreet article, which explains the best workaround, the conditional comments: http://www.456bereastreet.com/archive/200612/internet_explorer_and_the_css_b ox_model/ Cheers, Nan -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of James O'Donnell Sent: Sunday, July 26, 2009 4:02 PM To: thelist at lists.evolt.org Subject: Re: [thelist] Absolute positioned element and width 100% in IE It probably has to do with the way IE interprets the CSS box model, which is different than the W3C box model. Take a look at http://en.wikipedia.org/wiki/Internet_Explorer_box_model_bug It may explain what is happening. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Bill Moseley Sent: Sunday, 26 July, 2009 15:50 To: thelist at lists.evolt.org Subject: [thelist] Absolute positioned element and width 100% in IE Playing with one of these bar graph layouts:
20%
I set the span (as a block element) to be relative to the "out" div and position it absolute. Yet, in IE setting the span 100% is 100% of the "bar" element. Other browsers it is 100% of the element marked "relative" (the "out"). Is there a trick to make IE use the relative block's width? Or is the only solution to set "width: 100px" directly on the span? #out { width: 100px; height: 60px; border: 1px solid red; position: relative; padding: 3px; } #out .bar { width: 20%; height: 100%; background-color: yellow; } #out .bar span { position: absolute; top: 0; left: 0; width: 100%; /* This is relative to enclosing block, not relative block */ height: 100%; text-align: center; border: 1px solid green; } -- Bill Moseley moseley at hank.org -- * * 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 ! No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.31/2264 - Release Date: 07/26/09 11:07:00 -- * * 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 moseley at hank.org Sun Jul 26 18:23:03 2009 From: moseley at hank.org (Bill Moseley) Date: Sun, 26 Jul 2009 16:23:03 -0700 Subject: [thelist] Absolute positioned element and width 100% in IE In-Reply-To: <004e01ca0e2b$fe08e9a0$fa1abce0$@com> References: <16f65d000907261250i401e8fd3j64598fa5ea94139a@mail.gmail.com> <004e01ca0e2b$fe08e9a0$fa1abce0$@com> Message-ID: <16f65d000907261623p62164c80obfa83641042dfc06@mail.gmail.com> On Sun, Jul 26, 2009 at 1:02 PM, James O'Donnell wrote: > It probably has to do with the way IE interprets the CSS box model, which > is > different than the W3C box model. > > Take a look at > http://en.wikipedia.org/wiki/Internet_Explorer_box_model_bug Thanks. I was actually curious about how IE inherited the width value. I guess it could be part of the box model bug.
20%
If the outer div "out" is position:relative and the span is position absolute it seems in IE the width is inherited (well, via width: 100%) from the inner "bar" div, not from the outer div, which seemed to be the case in other browsers. The goal is for the span to have the same width as the "out" div. The solution is to not use width: 100% on the span, but set it explicitly. The other approach is to simply not inherit from it.
20%
-- Bill Moseley moseley at hank.org From greshnikov at gmail.com Sun Jul 26 18:59:37 2009 From: greshnikov at gmail.com (Tony Peltier) Date: Mon, 27 Jul 2009 02:59:37 +0300 Subject: [thelist] New project Qippo.com Message-ID: <6610493125.20090727025937@gmail.com> Hi, Glad to be subscribed fro this mailing list. I found a newly started project http://www.qippo.com/ Will be glad to receive any comments -- Regards, Tony http://www.qippo.com/ From UITDEV at GMAIL.COM Sun Jul 26 20:21:09 2009 From: UITDEV at GMAIL.COM (UIT DEV) Date: Sun, 26 Jul 2009 21:21:09 -0400 Subject: [thelist] New project Qippo.com In-Reply-To: <6610493125.20090727025937@gmail.com> References: <6610493125.20090727025937@gmail.com> Message-ID: You must take some of us for idiots. Below is your copy from one other mailing list. You just spammed other email lists with similar messages - in an attempt to get people to go to your site. You've been reported to your ISP. Dont you think that people here can tell what you ate for breakfast? Fool. OH and in a matter of 25 minutes you managed to change your email address too? Yea. OK. How's the weather in Russia? from : Dirlinx reply-to: Dirlinx to: css-d at lists.css-discuss.org date: Sun, Jul 26, 2009 at 20:44 subject: [css-d] CSS check for qippo.com mailing list: css-d.lists.css-discuss.org Filter messages from this mailing list 20:44 (34 minutes ago) Hi, I'm working on comparison site (http://www.qippo.com/) using Ajax. Looks like everything Ok, but I can't check it in IE6. Please, can some one look on it and say if there any problems? Thanks! ---- Regards, Tony. http://www.qippo.com/