August 2012 - skunkworks - Skunkworks Site

Internet Radio
by bernard kioko 04 Sep '12

04 Sep '12

Hi, If you would like to listen to Kenyan Music non-stop with no talk, then point your browser here: http://bernsoft.com/radio Works on computer & mobile. Enjoy Kenyan Music. Regards

3 2

Hospital Management System
by Nicholas Odanga 02 Sep '12

02 Sep '12

Hi skunks, Who has experience building hospital management system on ASP.NET and Microsoft SQL Server? An example is MP Shah Hospital one. I dont know what language their system was built on. Who knows that too?

5 4

Google nexus 7 case
by Joseph Tintale 31 Aug '12

31 Aug '12

Hi all, My Google Nexus 7 just landed and I'm looking for a case here in Nairobi. I tried fitting a Samsung case but the nexus has a slightly longer height so it doesn't fit. Anyone who knows or sells these stuff? A price quote will also be highly appreciated. KR, Joseph.

3 3

Modem Connection Error
by Bwana Lawi 31 Aug '12

31 Aug '12

Hi guys, Anyone encountered this error before? "*A connection to the remote computer could not be established. You might need to change the network settings for this connection*." The only solution that seems to work is restarting the machine. Brief details: OS: Win 7 64 Modem: Safcom Huawei modem, E220 Error Code: 720 How to replicate. Disconnect the modem, then attempt to reconnect. Yes, am still in touch with Mr. Google. Thanx in advance

3 3

Skunkworks Digest, Vol 30, Issue 255
by Kinpro Computers-All IT soutions 31 Aug '12

31 Aug '12

What is your intention after you find out the Language behind?Do you want to develop add ons/Ins or editonal modules?Care 2X is PHP, afyaPro is C#, and many others in Java. Date: Fri, 31 Aug 2012 13:51:33 +0300 From: Nicholas Odanga <niodanga(a)gmail.com> To: Skunkworks(a)lists.my.co.ke Subject: [Skunkworks] Hospital Management System Message-ID: <CAB1CssyBSe6hfSO2fL5Mjyy=Wad-aurY5ewDghHPhvtNgPcERg(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Hi skunks, Who has experience building hospital management system on ASP.NET and Microsoft SQL Server? An example is MP Shah Hospital one. I dont know what language their system was built on. Who knows that too?

1 0

Kindly assist in Job placement
by Martin Muraguri 31 Aug '12

31 Aug '12

> > Hi Good People, > > Kindly assist Iskander Moreno, An ICT Consultant with an edge in network > management and customer care. > Any help offered is highly appreciated. > Download CV here www.muraguri.me.ke/Iskander_Moreno_Maina_CV.pdf You can also reach him on his cell 0729162276 > Thank you in advance. > > -- > *Kind Regards > Martin Muraguri > C: +254726937792 > E: martinmur87(a)gmail.com > W: www.OctoberICT.com > * > * *

3 3

Quote for asset tagging labels
by Jac 31 Aug '12

31 Aug '12

Hi Skunkers I have a client who needs to tag about 200 laptops and desktops but he might add other equipments. Is there a skunker who is in this biz who can quickly send me an estimated cost of having a tag with the following sample detail: 'Property of: 13 character for the company name. Serial name: maximum of 10 digits, Please give options for printing this on a metallic sticker or engraving it on the laptops. Also give an option for incoporating a barcode en the cost implication. Give the estimated cost per piece. Best Jack

2 1

Looking for IPad2 3g
by Brian Munyao Longwe 31 Aug '12

31 Aug '12

Anyone has this in 16, 32 or 64 gb? Please let me know?

2 1

Data recovery, please help!!
by Alex Njiru 31 Aug '12

31 Aug '12

Hi Skunks Anyone who can assist in recovering data from a failing external hard drive?? I am getting an error message that reads 'You need to format the disk before you can use it'!! I need data that is in the hard drive urgently. Any assistance will be highly appreciated. Regards Alex

9 10

Re: [Skunkworks] Skunkworks MySQL question
by William Muriithi 31 Aug '12

31 Aug '12

> > *Real life:* > A questionnaire is grouped into several sections (e.g. personal details, > contacts, education, work experience etc), each section then has multiple > questions. > > *Current implementation:* > I have 3 tables; questionnaires (columns: id, title, ...), sections (id, > questionnaire_id, ...) and questions (id, section_id, ...). The columns > questionnaire_id and section_id are indexed, and all "id" columns are > primary keys, auto increment. > > *The need:* > I need to get all questions that belong to a specific questionnaire. Lets > assume the id of this questionnaire is 1. > > *Method 1:* > 1. Run the query "SELECT id FROM sections WHERE questionnaire_id=1" > 2. Do some PHP code to retrieve the ids and convert them into CSV format, > e.g. 1, 2, 3 > 3. Run the query "SELECT id, title, ... FROM questions WHERE section_id IN > (1,2,3)" > > *Method 2:* > 1. Run the query "SELECT id, title, ... FROM questions WHERE section_id IN > (SELECT id FROM sections WHERE questionnaire_id=1)" > > *Question:* > Which is the better method in terms of speed and scalability? Would go with the first one. Sub queries are better avoided. But test which is faster by running them through explain William >

2 1