On Mon, Aug 16, 2010 at 7:01 AM, <skunkworks-request@lists.my.co.ke> wrote:
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: minimum cost for setting a cyber (Solomon Mburu Kamau)
  2. Re: minimum cost for setting a cyber (Solomon Mburu Kamau)
  3. MSSQL - getting time different excluding weekends (Calvin Omari)
  4. Re: Can One Pick a phone Number directly from a wap       browser?
     (Chris Mwirigi)
  5. Re: MSSQL - getting time different excluding weekends
     (Edwin Kaduki)


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

Dear Solomon,
Setting a cybe cafe with your specification, is a good small scale start up. Are you looking at getting branded systems? well i think you can always figure out the cost of computers of your choice.
The aspect which we could deliberate on is the networking devices and billing systems.
For Networking devices, i will suggest you go for Mikrotik router and Dlink switches but if you can raise a little more funds, go for hp procurve switches, for 10 pcs you could just get a 24port switch. Are you looking at providing wireless services too? for the router you could also consider Vyatta(if cost is major)
Billing System: If you will be using mikrotik router, then you have no problem with billing system as mikrotik has quite a good hotspot services with the user manager package installed, you will be printing tickets in no time! Smile....

NB
If cost is then a major major issue then go for a link sys router which also has wireless and use any of the widely available billing softwares, chilisoft is ok....

Regards

Message: 1
Date: Mon, 16 Aug 2010 14:31:33 +0300
From: Solomon Mburu Kamau <solo.mburu@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Cc: skunkworks@my.co.ke
Subject: Re: [Skunkworks] minimum cost for setting a cyber
Message-ID:
       <AANLkTikRzy7Scz_UGwFJxT7tt4y9VRqQQsUsq11nXQET@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

On 16 August 2010 13:21, kiiru polly <wairimukiiru@yahoo.com> wrote:

> hello,
>
> morning good people, i have a question which i would like honest answers in
> regard to a cyber come mpesa setup budget.
>
> i hereby hope to set up a cyber and an Mpesa place in the near future and i
> justed wanted to work with actual or somewhat close up figures.
>
> i have a plan of setting up a cyber of about 10 comps, with broadband
> internet, and wi-fi services to charge. at the same time im thinking of
> combining it with M-pesa/mkesho, yu n zain transfer money services.
>
> who would assist me carry out a feasibility study and come up with the
> numbers of setting up shop??
>
> also from all young at heart out there what do young people really wish
> they would find in a cyber/lounge ??
>
> thanks.
>

I'm also interested in this too.

>
>
>
>
> _______________________________________________
> 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
>



--
*Solomon Mb?r? Kamau*

*****************************************************
*Man is a gregarious animal and enjoys agreement as cows will graze all the
same way to the side of a hill!*

AND

*It is better to die in dignity than in the ignominy of ambiguous
generosity! *

http://smiley2.wordpress.com
http://mburu.sikika.co.ke
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://orion.my.co.ke/pipermail/skunkworks/attachments/20100816/a045cf4a/attachment-0002.htm>

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

Message: 2
Date: Mon, 16 Aug 2010 14:31:33 +0300
From: Solomon Mburu Kamau <solo.mburu@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Cc: skunkworks@my.co.ke
Subject: Re: [Skunkworks] minimum cost for setting a cyber
Message-ID:
       <AANLkTikRzy7Scz_UGwFJxT7tt4y9VRqQQsUsq11nXQET@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

On 16 August 2010 13:21, kiiru polly <wairimukiiru@yahoo.com> wrote:

> hello,
>
> morning good people, i have a question which i would like honest answers in
> regard to a cyber come mpesa setup budget.
>
> i hereby hope to set up a cyber and an Mpesa place in the near future and i
> justed wanted to work with actual or somewhat close up figures.
>
> i have a plan of setting up a cyber of about 10 comps, with broadband
> internet, and wi-fi services to charge. at the same time im thinking of
> combining it with M-pesa/mkesho, yu n zain transfer money services.
>
> who would assist me carry out a feasibility study and come up with the
> numbers of setting up shop??
>
> also from all young at heart out there what do young people really wish
> they would find in a cyber/lounge ??
>
> thanks.
>

I'm also interested in this too.

>
>
>
>
> _______________________________________________
> 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
>



--
*Solomon Mb?r? Kamau*

*****************************************************
*Man is a gregarious animal and enjoys agreement as cows will graze all the
same way to the side of a hill!*

AND

*It is better to die in dignity than in the ignominy of ambiguous
generosity! *

http://smiley2.wordpress.com
http://mburu.sikika.co.ke
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://orion.my.co.ke/pipermail/skunkworks/attachments/20100816/a045cf4a/attachment-0003.htm>

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

Message: 3
Date: Mon, 16 Aug 2010 14:57:31 +0300
From: Calvin Omari <calvinebarongo@gmail.com>
To: Skunkworks Forum <skunkworks@lists.my.co.ke>
Subject: [Skunkworks] MSSQL - getting time different excluding
       weekends
Message-ID:
       <AANLkTim6zgL26HKi1R21V=XJ8pH-Zc3B8F9qOgNeuJ-g@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi,
I am doing an ms sql select but i want to exclude week ends as i want am
doing a different bewteen when a product was sold and when payment was done
I need the diffrent between the sold date and paid date excluding weekends

Any idea is highly appreciated

Regards
--
Our greatest fear is not that we are inadequate,
but that we are powerful beyond measure.
It is our light, not our darkness, that frightens us.

Calvin Omari Systems Developer/Designer
http://www.facebook.com/barongo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://orion.my.co.ke/pipermail/skunkworks/attachments/20100816/6c6591d0/attachment-0001.htm>

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

Message: 4
Date: Mon, 16 Aug 2010 14:59:53 +0300
From: Chris Mwirigi <mwirigic@gmail.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Can One Pick a phone Number directly from a
       wap     browser?
Message-ID:
       <AANLkTikfCY2B=9WHa_CbU4gp2NWkca5r_5GvzFXcWGs8@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

it is very possible

On Thu, Aug 5, 2010 at 3:46 PM, Billy <billyx5@gmail.com> wrote:
>
>> Could it be possible that when you click that banner - an AT command is
>> initiated that communicates with those people's number - with which they get
>> your MSISDN and call you ??
>>
>
> @ndungu Its not possible to do that unless there was some kind of app on
> your phone. It's WAP meaning you are merely fetching data from the server
> you are not executing any code on your phone (unless your phone has been
> hacked or you downloaded some trojan pretending to be a browser)
>
> -Billy
>
>
> _______________________________________________
> 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
>


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

Message: 5
Date: Mon, 16 Aug 2010 15:01:48 +0300
From: Edwin Kaduki <kaduki@edwinkaduki.com>
To: calvine_barongo@yahoo.com,  Skunkworks Mailing List
       <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] MSSQL - getting time different excluding
       weekends
Message-ID:
       <AANLkTimXS4TFEXHqthkFg_qpJEWW+1beK5BaLggWsXVt@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Seems you have to use a function. Check out
http://stackoverflow.com/questions/2258767/calculating-how-many-working-days-between-2-dates-t-sql

On Mon, Aug 16, 2010 at 2:57 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:

>
> Hi,
> I am doing an ms sql select but i want to exclude week ends as i want am
> doing a different bewteen when a product was sold and when payment was done
> I need the diffrent between the sold date and paid date excluding weekends
>
> Any idea is highly appreciated
>
> Regards
> --
> Our greatest fear is not that we are inadequate,
> but that we are powerful beyond measure.
> It is our light, not our darkness, that frightens us.
>
> Calvin Omari Systems Developer/Designer
> http://www.facebook.com/barongo
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/pipermail/skunkworks/attachments/20100816/27eef9e2/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 6, Issue 194
******************************************



--
------------------------------------------------------------------------
Seun Ojedeji,
System Analyst/Network Admin
ICT Centre,
University of Nigeria, Enugu Campus.
web:      http://www.unn.edu.ng
Mobile: +2348035233535
Email:   seun.ojedeji@unn.edu.ng
            seun.ojedeji@gmail.com
Skype:  seun.ojedeji