Send Skunkworks mailing list submissions to
    skunkworks@lists.my.co.ke

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
or, via email, send a message with subject or body 'help' to
    skunkworks-request@lists.my.co.ke

You can reach the person managing the list at
    skunkworks-owner@lists.my.co.ke

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Skunkworks digest..."


Today's Topics:

  1. Re: @iLabAfrica-Google Mobile Boot Camp (victor yegon)
  2. Re: Domain Transfer Problem (Steve Muchai)
  3. SQL Help (julianne anyim)
  4. Re: SQL Help (Christian Ledermann)
  5. Re: SQL Help (Rad!)
  6. Best prices HWIC 1FE Card - 2800 Series Router (benson maina)
  7. Re: @iLabAfrica-Google Mobile Boot Camp (Leonard Kore)
  8. Re: SQL Help (Richard Gathogo)


----------------------------------------------------------------------

Message: 1
Date: Tue, 15 May 2012 12:48:30 +0300
From: victor yegon <viktayeg@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] @iLabAfrica-Google Mobile Boot Camp
Message-ID:
    <CAOtXiXeSUewOEjRh+jNzktgfEhZRA_QmA7uvjnnzMpFi_UnbHg@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

I have also trie opening with safari and ie still not working

On Tue, May 15, 2012 at 12:45 PM, Wanjohi Ndegwa <andegs2000@gmail.com>wrote:

> Sorry guys, it was working upto a minute ago. I now also cant access it.
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> ------------
> List info, subscribe/unsubscribe
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
>
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
>



--
Regards
Yegon Victor
Web Specialist/Internet Consultant
Freelance Webs Specialists
http://freelancewebspecialists.kbo.co.ke <http://salient.co.ke/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/cgi-bin/mailman/private/skunkworks/attachments/20120515/74447991/attachment-0001.htm>

------------------------------

Message: 2
Date: Tue, 15 May 2012 13:06:51 +0300
From: Steve Muchai <smuchai@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Domain Transfer Problem
Message-ID:
    <CAHMh28K9q5Ds2YEfY49H4R0_JV3h=SN_bePLvqHZR7z=AbvELw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

On Tue, May 15, 2012 at 12:20 PM, Andrew Kiptoo <andrewkiptoo@live.com> wrote:
> The is a local company that is becoming stubborn to transfer a domain for
> the last 3 months. The client still receives his mails and the website is
> still hosted by the company but he does not owe the company anything and he
> wishes to transfer his domain due to poor services he received recently. He

Let the chequebook do the talking. Assuming the stubbon company,
hereinafter referred to as "the said company" actually runs the DNS
server for the domain, advise them to:

1. transfer all revenue-generating services to another service
provider. So, they move their connectivity, their web site, their
email etc to someone they're paying (or not paying, for example if
they qualify for free services on Google). The said company will have
to modify the zone records to reflect all changes to the domain (MX,
A, CNAME records);

2. after this is all done, refer the dispute to the domain registry.
If it's a .ke domain, I've found the folks at KENIC to be very helpful
and objective. The objective of this is to process domain renewals
directly with the registry, thus denying the said company revenue for
domain renewals while the said company is obligated to continue
providing DNS service for the domain;

Also, to re-read the fine print in their contract (assuming one exists).

Regards,
Steve


------------------------------

Message: 3
Date: Tue, 15 May 2012 03:12:43 -0700
From: julianne anyim <julianneanyim@gmail.com>
To: skunkworks <skunkworks@lists.my.co.ke>
Subject: [Skunkworks] SQL Help
Message-ID:
    <CAA-shGOexDT25tMxSXxmqjA0OHd+dF8EtXM5o-YtqR-er3BRRA@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hello people,

I have a query in the form;

SELECT A, B, (C-D) AS E ...

I need to return only values where E<0 for instance. I know i can achieve
this in php, but is there a way i can achieve it at the SQL level?

I have tried:


SELECT A, B, (C-D) AS E
WHERE E<0

but i get an "ORA-00904: : invalid identifier" error. E is not recognized.

Any insights?

Thank you
Julianne
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://orion.my.co.ke/cgi-bin/mailman/private/skunkworks/attachments/20120515/8379fdbd/attachment-0001.htm>

------------------------------

Message: 4
Date: Tue, 15 May 2012 13:17:08 +0300
From: Christian Ledermann <christian.ledermann@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] SQL Help
Message-ID:
    <CABCjzWpSr-0tkh7qpfcMgbFc6j3e+ECqJcLRChBed=2Mya0H+w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

try HAVING instead of WHERE (iirc)

On Tue, May 15, 2012 at 1:12 PM, julianne anyim <julianneanyim@gmail.com> wrote:
> Hello people,
>
> I have a query in the form;
>
> SELECT A, B, (C-D) AS E ...
>
> I need to return only values where E<0 for instance. I know i can achieve
> this in php, but is there a way i can achieve it at the SQL level?
>
> I have tried:
>
>
> SELECT A, B, (C-D) AS E
> WHERE E<0
>
> but i get an "ORA-00904: : invalid identifier" error. E is not recognized.
>
> Any insights?
>
> Thank you
> Julianne
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> ------------
> List info, subscribe/unsubscribe
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
>
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke



--
Best Regards,

Christian Ledermann


<*)))>{

If you save the living environment, the biodiversity that we have left,
you will also automatically save the physical environment, too. But If
you only save the physical environment, you will ultimately lose both.

1) Don?t drive species to extinction

2) Don?t destroy a habitat that species rely on.

3) Don?t change the climate in ways that will result in the above.

}<(((*>


------------------------------

Message: 5
Date: Tue, 15 May 2012 13:17:37 +0300
From: "Rad!" <conradakunga@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] SQL Help
Message-ID:
    <CAC=61PcFctgz0aNRE4toAFH8ByHxgV3g7kq6awGxkZpzVBoFqA@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Try WHERE C-D < 0

Not all databases (like Sybase) allow you to alias an expression and use it
later as a reference

On Tuesday, May 15, 2012, julianne anyim wrote:

> Hello people,
>
> I have a query in the form;
>
> SELECT A, B, (C-D) AS E ...
>
> I need to return only values where E<0 for instance. I know i can achieve
> this in php, but is there a way i can achieve it at the SQL level?
>
> I have tried:
>
>
> SELECT A, B, (C-D) AS E
> WHERE E<0
>
> but i get an "ORA-00904: : invalid identifier" error. E is not recognized.
>
> Any insights?
>
> Thank you
> Julianne
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://orion.my.co.ke/cgi-bin/mailman/private/skunkworks/attachments/20120515/bb6197f9/attachment-0001.htm>

------------------------------

Message: 6
Date: Tue, 15 May 2012 13:35:19 +0300
From: benson maina <bensonmaina@gmail.com>
To: skunkworks <skunkworks@my.co.ke>
Subject: [Skunkworks] Best prices HWIC 1FE Card - 2800 Series Router
Message-ID:
    <CAK4Vj9t9zzoMLxyS8e3Bauf3K-3Q-m=DFBi_qcX2fr4go8x7MQ@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

needed urgently ......... drop me a quote asap
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://orion.my.co.ke/cgi-bin/mailman/private/skunkworks/attachments/20120515/387731ea/attachment-0001.htm>

------------------------------

Message: 7
Date: Tue, 15 May 2012 13:43:41 +0300
From: Leonard Kore <leonardkore@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] @iLabAfrica-Google Mobile Boot Camp
Message-ID:
    <CABS72YcQuZ1Tt2a6R7c2y2j6wOnALLosoMCMC2UjPT_ENYsxQw@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Lemme try and fix it then get back to you guys

On Tue, May 15, 2012 at 12:09 PM, Wanjohi Ndegwa <andegs2000@gmail.com>wrote:

> Its up and running, just registered myself
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> ------------
> List info, subscribe/unsubscribe
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
>
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
>



--
Leonard Kore
@iLabAfrica-Strathmore University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/cgi-bin/mailman/private/skunkworks/attachments/20120515/f222a1db/attachment-0001.htm>

------------------------------

Message: 8
Date: Tue, 15 May 2012 13:54:13 +0300
From: Richard Gathogo <muraguri2005@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] SQL Help
Message-ID:
    <CADAxfyuzgS9bFErEiO++yBG7CtE3Oc8aqpC37VvXNvHWfLmkXA@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi Julianne,
HAVING should make sure on the database (SQL)  level. I am sure it works
for MySQL.
Regards Richard Gathogo.

*Love covers a multitude of sins.*




On Tue, May 15, 2012 at 1:17 PM, Rad! <conradakunga@gmail.com> wrote:

> Try WHERE C-D < 0
>
> Not all databases (like Sybase) allow you to alias an expression and use
> it later as a reference
>
>
> On Tuesday, May 15, 2012, julianne anyim wrote:
>
>> Hello people,
>>
>> I have a query in the form;
>>
>> SELECT A, B, (C-D) AS E ...
>>
>> I need to return only values where E<0 for instance. I know i can achieve
>> this in php, but is there a way i can achieve it at the SQL level?
>>
>> I have tried:
>>
>>
>> SELECT A, B, (C-D) AS E
>> WHERE E<0
>>
>> but i get an "ORA-00904: : invalid identifier" error. E is not recognized.
>>
>> Any insights?
>>
>> Thank you
>> Julianne
>>
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> ------------
> List info, subscribe/unsubscribe
> http://orion.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
>
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/cgi-bin/mailman/private/skunkworks/attachments/20120515/4a30f2f9/attachment.htm>

------------------------------

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

End of Skunkworks Digest, Vol 27, Issue 124
*******************************************