- skunkworks - Skunkworks Site

Barcamp Nairobi Update
by Phares Kariuki 05 Mar '10

05 Mar '10

Hi, We will be having the barcamp on June 11-13th or 12-13th depending on sponsorship success. It will be a merger of 2 events, Wherecamp Africa (which will not be held in Bamako, but in NBO this year). the idea is to have a 3 day event with the first day being dedicated to entrepreneurship (the Friday), the second tech in general (the Saturday) and the third being focussed on mapping. Volunteers, sponsors etc, as always, can fill out the wiki :) http://barcamp.org/BarCampNairobi2010 <http://barcamp.org/BarCampNairobi2010>Thanks! -- With Regards, Phares Kariuki | T: +254 734 810 802 | E: pkariuki(a)gmail.com | Twitter: kaboro | Skype: kariukiphares |

1 0

A quick one: Regex in .NET
by Simon Mbuthia 04 Mar '10

04 Mar '10

Hi guys, I'm having a little problem here, I want to validate an entry in a text field using the regex pattern "\d{10}". the said field should have exactly 10 digits, but my application is accepting all entries matching 10+ digits :-( What should I do? -- Everyone's days are numbered. It's called a calendar

5 7

Invitation to connect on LinkedIn
by john Mash 04 Mar '10

04 Mar '10

LinkedIn ------------john Mash requested to add you as a connection on LinkedIn: ------------------------------------------ Josiah, I'd like to add you to my professional network on LinkedIn. - john Accept invitation from john Mash http://www.linkedin.com/e/T4Pevh2Eh7RcyFJhPqi__ymPVOifi_KTYW6abNc/blk/I1860… View invitation from john Mash http://www.linkedin.com/e/T4Pevh2Eh7RcyFJhPqi__ymPVOifi_KTYW6abNc/blk/I1860… ------------------------------------------ DID YOU KNOW you can conduct a more credible and powerful reference check using LinkedIn? Enter the company name and years of employment or the prospective employee to find their colleagues that are also in your network. This provides you with a more balanced set of feedback to evaluate that new hire. http://www.linkedin.com/e/rsr/inv-27/ ------ (c) 2010, LinkedIn Corporation

5 5

OT: Request For Email address
by Brian Ngure 04 Mar '10

04 Mar '10

Hi, Would anyone on the list have any email addresses for Lloyd Masika? I have a problem I need sorted out and can't find much info on their website. -- Regards, Brian Ngure

4 5

Invitation to connect on LinkedIn
by john Mash 04 Mar '10

04 Mar '10

LinkedIn ------------john Mash requested to add you as a connection on LinkedIn: ------------------------------------------ Mulutu, I'd like to add you to my professional network on LinkedIn. - john Accept invitation from john Mash http://www.linkedin.com/e/XqwhZ3Ffzi6Tax09giG2G5ucHu2sPa0/blk/I1860010924_2… View invitation from john Mash http://www.linkedin.com/e/XqwhZ3Ffzi6Tax09giG2G5ucHu2sPa0/blk/I1860010924_2… ------ (c) 2010, LinkedIn Corporation

1 0

HP EliteBook
by Mr. Lawi 04 Mar '10

04 Mar '10

Hi Guys Kindly send me quotes for the following: HP EliteBook (Specify the models and prices) with the following included: Windows XP (At least SP2) MS Office Enterprise 2003 Send them to mail2lawi(a)gmail.com Mr. Lawi

2 1

IVRS expert
by Wamukunas Jim 04 Mar '10

04 Mar '10

Hi Where can I get a good IVRS(interactive Voice Response System) developer here in kenya. Just Reply urgently Regards

2 1

- call - Workshop on Internet Governance and Policies @ ICANN meeting in Nairobi, 11-12 March 2010 (RSVP)
by mwende njiraini 03 Mar '10

03 Mar '10

Dear colleagues, DiploFoundation is pleased to invite participants from ACP (Africa-Caribbean-Pacific) Group of States who are attending the ICANN meeting to register for a workshop on Internet Governance (IG) and Policies – “Internet Governance Diplomats”. The workshop will assist participants to grasp the multidisciplinary field of IG (including technical, legal, economic, socio-cultural and developmental aspects) and provide links with the international and regional processes (World Summit on Information Society and Internet Governance Forum). The discussions will also highlight the importance of IG and ICT issues and its effect on national and regional policies. *Time and Location:* March 11th and 12th (announcement and programme attached) Kenyatta International Conference Center, Nairobi * Registration:* Open to all stakeholders from ACP (Africa-Caribbean-Pacific) countries Limited to 30 participants on a first come basis Please send an email with your full name, country of residence, institution and position to: acpinfo(a)diplomacy.edu Deadline for applications: 5 March 2010 The workshop is a first event in a range of activities of the “Capacity Development in ICT Policy and Internet Governance for Africa – Caribbean – Pacific (ACP)” programme of DiploFoundation, with support of the European Commission and Secretariat of the ACP Group of States. For detailed info on this programme, please visit: www.diplomacy.edu/acp Looking forward to cooperating with you, Best regards, Vladimir Radunovic DiploFoundation

1 0

PHP/MySQL logic problem
by Peter Karunyu 03 Mar '10

03 Mar '10

Good evening skunks, I am retrieving the data below from a MySQL table, I want to display it on a page as follows: for any given day, I want to show the earliest time and the latest time, (for example, 2010-02-02 09:53:00 and 2010-02-02 10:50:00) on one row. In cases where there is only one entry for a given day ( for example 2010-02-01 08:55:00), I will show that entry as both the earliest time and the latest time, still on one row I am sure I can write more than one query which can use MIN() and MAX() and subqueries to retrieve the same, but I want to run the query once, retrieve all the data then apply logic in code to achieve the same. I had written some PHP code which works only until it encounters single entries but its too messy to post here, someone please help? 2010-02-01 08:55:00 2010-02-02 09:53:00 2010-02-02 09:54:00 2010-02-02 10:48:00 2010-02-02 10:50:00 2010-02-04 16:55:00 2010-02-05 17:29:00 2010-02-16 09:35:00 2010-02-16 18:10:00 2010-02-17 10:09:00 2010-02-18 11:28:00 2010-02-18 14:58:00 2010-02-19 09:31:00 2010-02-19 12:28:00 2010-02-19 12:33:00 2010-02-19 16:58:00 2010-02-22 09:40:00 2010-02-22 15:26:00 2010-02-22 15:31:00 2010-02-23 11:52:00 2010-02-24 10:41:00 2010-02-24 18:32:00 2010-02-25 11:38:00 2010-02-25 18:08:00 2010-02-26 11:00:00 2010-02-26 18:20:00

2 1

Re: [Skunkworks] PHP/MySQL logic problem
by Steve Obbayi 03 Mar '10

03 Mar '10

Hi Peter, Based on your table assuming the dates are stored in a column called 'mydate' and table called 'datetable' then you need to run a query similar to this then am sure you can handle the presentation in PHP: SELECT mydate AS given_day, EXTRACT(DAY FROM mydate) AS unique_days, MIN(mydate) AS earliest_time, MAX(mydate) AS latest_time FROM datetable GROUP BY unique_days; if you want to extract just the time and ignore the days then use this one: SELECT mydate AS given_day, TIME_FORMAT(EXTRACT(HOUR_SECOND FROM MIN(mydate)), '%H:%i:%s') AS earliest_time, TIME_FORMAT(EXTRACT(HOUR_SECOND FROM MAX(mydate)), '%H:%i:%s') AS latest_time, EXTRACT(DAY FROM mydate) AS unique_days FROM datetable GROUP BY unique_days; Cheers ;-) Steve Obbayi SKYPE: sobbayi http://sobbayi.com http://blog.sobbayi.com ----- Original Message ----- From: "Peter Karunyu" <pkarunyu(a)gmail.com> To: "Skunkworks forum" <skunkworks(a)lists.my.co.ke> Sent: Wednesday, March 3, 2010 10:43:18 AM GMT -05:00 US/Canada Eastern Subject: [Skunkworks] PHP/MySQL logic problem Good evening skunks, I am retrieving the data below from a MySQL table, I want to display it on a page as follows: for any given day, I want to show the earliest time and the latest time, (for example, 2010-02-02 09:53:00 and 2010-02-02 10:50:00) on one row. In cases where there is only one entry for a given day ( for example 2010-02-01 08:55:00), I will show that entry as both the earliest time and the latest time, still on one row I am sure I can write more than one query which can use MIN() and MAX() and subqueries to retrieve the same, but I want to run the query once, retrieve all the data then apply logic in code to achieve the same. I had written some PHP code which works only until it encounters single entries but its too messy to post here, someone please help? 2010-02-01 08:55:00 2010-02-02 09:53:00 2010-02-02 09:54:00 2010-02-02 10:48:00 2010-02-02 10:50:00 2010-02-04 16:55:00 2010-02-05 17:29:00 2010-02-16 09:35:00 2010-02-16 18:10:00 2010-02-17 10:09:00 2010-02-18 11:28:00 2010-02-18 14:58:00 2010-02-19 09:31:00 2010-02-19 12:28:00 2010-02-19 12:33:00 2010-02-19 16:58:00 2010-02-22 09:40:00 2010-02-22 15:26:00 2010-02-22 15:31:00 2010-02-23 11:52:00 2010-02-24 10:41:00 2010-02-24 18:32:00 2010-02-25 11:38:00 2010-02-25 18:08:00 2010-02-26 11:00:00 2010-02-26 18:20:00 _______________________________________________ Skunkworks mailing list Skunkworks(a)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-dHlQVTMxU1VBdU1BSWJxdy1… ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general

2 1

cisco gurus - any bsci tips?
by francis kamau 03 Mar '10

03 Mar '10

Has anybody attempted bsci recently? share your experience

1 0

Kaspersky,Symantec,AVG or MCafee
by Lawrence kago 03 Mar '10

03 Mar '10

Hi Skunkers. Can anyone help me to choose between the CORPORATE edition of the above antivirus BASED on facts. Currently our organisation(over 30 users) is using symantec,however i am not sure this is the best option. I know Kav single user is 'prefect',is it the same for corporate version? -- If u have to take a rest,please do so, but never quit.. Lawrence Kago Computer Tech Free consultation.

9 11

DLP Projectors with WiFi
by Andrew Wachira 03 Mar '10

03 Mar '10

Hi, Does anyone know where i can get a DLP projector in town with WiFi like this one: Acer DLP projector with WiFi<http://www.itechnews.net/2008/06/12/acer-p5260i-wifi-dlp-projector/> The WiFi requirement is not that strict but if there are any around please let me know. Thanks ahead.

3 4

Re: [Skunkworks] Kenyan J2ME Mobile UI Library (Flemil)
by fyodor 03 Mar '10

03 Mar '10

Hi This is a lovely initiative. However, wouldnt it be great if this was open-source? you know have guys look at the libraries and stuff? Cuz in my humble opinion, this might just turn me to alternatives which are open-sourced. thanks. -tyrus

2 1

Developing A Website for a Training Institution
by Joseph McDonald 03 Mar '10

03 Mar '10

Good Day! Am consulting for some investors who want to set up a training institution. So am in process of getting a person/company who I can work with on a fixed price project to develop a website. I have attached the RFP. Sorry the timeline is crazy,I will evaluate the proposals and hoping to start working early next week. Thanks

1 0

Where to get MPEG-4 Digital Decorder
by Edward Obiko 03 Mar '10

03 Mar '10

Does anyone know where I can get the above decoder? The ones certified by the Ministry. Thanks Regards, -- OO Omingo Obiko

4 5

OT: looking for a macbookpro
by Ukang'a Dickson 02 Mar '10

02 Mar '10

Hi, Are Macbook Pro's available locally? Core 2 Duo, 4GB RAM, 250GB HD 7200/5400, nvidia graphics. where n how much? Regards Ukang'a Dickson

6 7

postapay /bank payment of elec and water
by david gathu 02 Mar '10

02 Mar '10

hi to you all i would wished to be helped , on how banks and other institution transact with utility companies and the security involved. thanks regards DAVID

1 0

Shorter days
by Denis G. Wahome 02 Mar '10

02 Mar '10

According to cnn *http://tinyurl.com/yjw4f7 *the earth quake in Chile may have tilted the Earths Axis. R D

2 2

Flash/Silverlight vs Javascript.
by albert kamau 02 Mar '10

02 Mar '10

Hi Skunks/ettes, Need a bit of advice . My cousin came to me and told me he needed to add a new tool to his arsenal . She was torn between flash/silverlight and javascript. We visited quite a few sites and noted developers could achieve similar experiences that were traditionally done with flash using javascript . Javascript has the additional advantage over flash in terms of accessibility, Search engine friendliness, speed, Cross browser compatibility. The only downside we found with javascript was scripts turned off. A flash banner that would take hours tweening, importing, exporting can be done in minutes with javascripts jquery. The only usage of flash I can see in the near future is making games and an intermediate javascript developer should be able create a decent javascript game Given that, Apple is not longer supporting flash in some of its latest products(iPhone, iPad) and HTML 5 which allows embedding of videos, which was the domain of flash, are the days of flash numbered ?

4 8

Kenyan J2ME Mobile UI Library (Flemil)
by solomon kariri 02 Mar '10

02 Mar '10

Hi all, Check out a new Kenyan mobile UI library at http://flemil.com To download and play around with the library demo on your mobile device point your phone browser to http://m.flemil.com if the phone browser doesn't redirect to the mobile site automatically. Regards, -- Solomon Kariri, Software Developer, Cell: +254736 729 450 Skype: solomonkariri

4 6

MDAEMON ANTIVIRUS SOLUTION
by Alvin Jason Ochieng 02 Mar '10

02 Mar '10

Hello Skunks? I have a client running mdaemon 12 user standard and he requires an Antivirus ASAP. What would you recommend as the worstations Vista Biz/ XP-pro on pcs and use microsoft office and have been mixed to use Kaspersky Internet Versions.......KIS What would you recommend for a smaller server ML110 running WIN SERVER 2008? Am looking for experiences here cost is an issue......Cheers Alvin

2 1

Msc. IT
by Eric Mugo 02 Mar '10

02 Mar '10

Good people, I would like to pursue an Msc I.T course at strathmore and i just discovered i'm suppossed to do an aptitude test. Does anyone here have any clue/pointers on what type of aptitude they usually give. What preparation should i do before I go. Regards, Eric M.

4 4

MPESA
by Edmund Okumu 02 Mar '10

02 Mar '10

Who knows whats wrong with MPESA? Were we worned in time cause i don't remember.Its been down two days -- Edmund C. O. Okumu

4 5

OT : Unemployment benefits, housing benefits, child benefits and benefits of all kinds
by aki 02 Mar '10

02 Mar '10

BENEFITS being the keyword here, would anyone have information to how Kenya handles these issues. In many other countries, the govts do this for their citizens, besides the necessary health care and other benefits : - Housing Benefit is to help those who are on a low income or unemployed to pay their rent - Unemployment benefits are payments made by the state or other authorized bodies to unemployed people. It may be based on a compulsory para-governmental insurance system. Depending on the jurisdiction and the status of the person, those sums may be meager, covering only basic needs (thus a form of basic welfare), or may compensate the lost pay somewhat proportionally to the previous earned salary. They often are part of a larger social security scheme. - Child benefit Kenya income tax collection is used to do what? Me thots..

3 3