[Fwd: Kesalahan posting: Don Komo]
am 31.01.2008 10:35:04 von Evert Lammerts--------------050402080401070609060309
Content-Type: text/plain; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Is anybody else getting similar emails after sending an email to the
php-db list? I don't understand any of this 2006 google group with 5
members.
-------- Original Message --------
Subject: Kesalahan posting: Don Komo
Date: Thu, 31 Jan 2008 09:17:40 +0000
From: noreply@googlegroups.com
To: evert.lammerts@gmail.com
Anda tidak memiliki izin untuk memposting ke grup donkomo. Anda mungkin
harus bergabung ke grup agar dibolehkan memposting atau grup ini mungkin tidak
dapat terbuka untuk memposting.
Kunjungi http://groups.google.com/group/donkomo/about?hl=id untuk bergabung atau
mempelajari lebih lanjut tentang siapa yang dibolehkan memposting ke grup.
Bantuan untuk menggunakan Google Groups juga tersedia di:
http://groups.google.com/support?hl=id
--------------050402080401070609060309
Content-Type: message/rfc822;
name="ForwardedMessage.eml"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="ForwardedMessage.eml"
Received: by 10.35.13.4 with SMTP id q4mr13287958pyi.7.1201771060430; Thu, 31 Jan 2008 01:17:40 -0800 (PST)
Return-Path:
Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by mx.google.com with ESMTP id v63si4453340pyh.2.2008.01.31.01.17.40; Thu, 31 Jan 2008 01:17:40 -0800 (PST)
Received-SPF: pass (google.com: domain of donkomo+caf_=donkomo=googlegroups.com@gmail.com designates 64.233.166.182 as permitted sender) client-ip=64.233.166.182;
Authentication-Results: mx.google.com; spf=pass (google.com: domain of donkomo+caf_=donkomo=googlegroups.com@gmail.com designates 64.233.166.182 as permitted sender) smtp.mail=donkomo+caf_=donkomo=googlegroups.com@gmail.com; dkim=neutral (body hash did not verify) header.i=@gmail.com
Received: by py-out-1112.google.com with SMTP id p76so786334pyb.5 for
Received: by 10.142.139.19 with SMTP id m19mr944867wfd.7.1201771059299; Thu, 31 Jan 2008 01:17:39 -0800 (PST)
X-Forwarded-To: donkomo@googlegroups.com
X-Forwarded-For: donkomo@gmail.com donkomo@googlegroups.com
Delivered-To: donkomo@gmail.com
Received: by 10.142.207.1 with SMTP id e1cs389364wfg; Thu, 31 Jan 2008 01:17:38 -0800 (PST)
Received: by 10.150.146.14 with SMTP id t14mr583312ybd.67.1201771058031; Thu, 31 Jan 2008 01:17:38 -0800 (PST)
Return-Path:
Received: from lists.php.net (lists.php.net [216.92.131.4]) by mx.google.com with ESMTP id 39si3079361wrl.2.2008.01.31.01.17.37; Thu, 31 Jan 2008 01:17:37 -0800 (PST)
Received-SPF: pass (google.com: domain of php-db-return-44545-donkomo=gmail.com@lists.php.net designates 216.92.131.4 as permitted sender) client-ip=216.92.131.4;
Authentication-Results: mx.google.com; spf=pass (google.com: domain of php-db-return-44545-donkomo=gmail.com@lists.php.net designates 216.92.131.4 as permitted sender) smtp.mail=php-db-return-44545-donkomo=gmail.com@lists.php.ne t; dkim=neutral (body hash did not verify) header.i=@gmail.com
Return-Path:
Authentication-Results: pb1.pair.com header.from=evert.lammerts@gmail.com; domainkeys=bad
DomainKey-Status: bad
X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01
X-Host-Fingerprint: 216.92.131.4 lists.php.net
Received: from [216.92.131.4] ([216.92.131.4:28146] helo=lists.php.net) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 76/1A-49295-03291A74 for
Received: (qmail 32420 invoked by uid 1010); 31 Jan 2008 09:16:31 -0000
Mailing-List: contact php-db-help@lists.php.net; run by ezmlm
Precedence: bulk
list-help:
list-unsubscribe:
list-post:
Delivered-To: mailing list php-db@lists.php.net
Received: (qmail 32412 invoked by uid 1010); 31 Jan 2008 09:16:30 -0000
Delivered-To: ezmlm-scan-php-db@lists.php.net
Delivered-To: ezmlm-php-db@lists.php.net
Authentication-Results: pb1.pair.com header.from=evert.lammerts@gmail.com; sender-id=pass; domainkeys=bad
Authentication-Results: pb1.pair.com smtp.mail=evert.lammerts@gmail.com; spf=pass; sender-id=pass
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 72.14.220.159 as permitted sender)
X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01
X-PHP-List-Original-Sender: evert.lammerts@gmail.com
X-Host-Fingerprint: 72.14.220.159 fg-out-1718.google.com
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-t o:content-type:content-transfer-encoding; bh=j5srtasAIDD7/McXi52yrykjzn+l+jAdqvQJgAwzKNg=; b=qWugFEgN80eXxgUihpRFLVeCIlD1VpVTQKiT5Yx9Vx0BqHq2Zjfps7fLgB anyHmC+BYaPxBK7BUuGvT0XYFr4d/F8o4LnjWbbHwHG+uSAr/S3bBfuIHSIp fBaXj0CmqnSOrwiOmYKJ2R2WdPhGL5b7fmJtB9IjQqWZ9HLxJRaL4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encodi ng; b=eKNRLwNoW38LvDvd1nPvLyvwn416uP9nI4Aj/qmyt9KV6U797DgVB2hU7T +4DC1ztM+vC2PPIy5OdkOMqw8Nznj2/4IwfcxL1i42uRx4mIuplChPsb1iYm NBtspvipwADMYyGe4556MOkoB6kspQDubUOD1V1lJ7+vWLLd6YkDo=
Message-ID: <47A191E7.5080408@gmail.com>
Date: Thu, 31 Jan 2008 10:16:23 +0100
From: Evert Lammerts
User-Agent: Thunderbird 2.0.0.6 (X11/20071022)
MIME-Version: 1.0
To: Bastien Koert
CC: php-db@lists.php.net
References:
In-Reply-To:
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DB] A little SQL help
Not completely sure what type of result you expect, but here's one that makes sense to me.
SELECT tour.record_id, tour.event_start_date, tour.event_end_date, tour.event_name, angler_results.result
FROM tour
LEFT JOIN angler_results
ON angler_results.tour_id = tour.record_id
AND angler_results.angler_id = 1
I've taken out the CASE - I personally never worked with that and I'd probably put a default value of 'N/A' in the column angler_results.result. The DISTINCT has to go too, I'm guessing that the relation tour.record_id -> angler_results.tour_id is 1 -> *. The LEFT join CAN stay (as far as I know OUTER is only necessary when using ODBC or for maintaining compatibility with it, and then I'm still not sure what it does), if you want to have all rows in tour regardless of the join condition with NULL values for angler_results.result where tour.record_id is not in angler_results.tour_id. To leave out the NULL values use an INNER JOIN instead.
Evert
Bastien Koert wrote:
> Hi All,
>
> Got myself stuck in a little sql here and can't seem to work out what I am doing wrong
>
> SELECT
> DISTINCT (tour.record_id), tour.event_start_date, tour.event_end_date, tour.event_name,CASE WHEN result is NULLTHEN 'N/A'ELSE angler_results.resultEND CASE
> FROM
> tourLEFT OUTER JOIN angler_results
> ON angler_results.tour_id = tour.record_idWHERE angler_results.angler_id =1
>
> where the table TOUR is as above in the primary part of the select and table ANGLER_RESULTS is (record_id, tour_id, angler_id, result)
>
>
> Any ideas?
>
> Bastien
>
>
>
> ____________________________________________________________ _____
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------050402080401070609060309
Content-Type: text/plain; charset=us-ascii
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------050402080401070609060309--