July 2011 - skunkworks - Skunkworks Site

MySQL QUERY TO FIND DUBLICATES IN DATABASE
by The sherminator 27 Jul '11

27 Jul '11

Hi, All I have a query in MsAccess to find duplicates which works fine. the statement is as follows: SELECT First(table1.field1) AS field1Field, Count(table1.field1) AS NumberOfDups FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1 HAVING (((Count(table1.field1))>1)) I want to now use this statement in MySQL, but it has a problem with the syntax (most probable it does not understand the statements first and count) Could you maybe give me an alternative statement?

2 2

Dell M301Z screen
by Lawrence Kago 27 Jul '11

27 Jul '11

Hi, Anyone knows where i can get the above laptop's screen? Pls inbox me Thanks -- *W/Regards *Lawrence * Fear Not,For the Lord God is with you..*

4 3

Nanostation 2 needed urgently
by Frank Kiprono 27 Jul '11

27 Jul '11

Guys, I'm looking for firms selling the above. Please inbox me your details ASAP if selling the above.

3 2

ISOC Kenya Chapter Creation efforts
by Barrack Otieno 27 Jul '11

27 Jul '11

Dear Colleagues, There has been growing interest on various lists to have a local ISOC Chapter up and running, we have had many Kenyans participate in ISOC programs as fellows, unfortunately we haven't had a forum where we can share the knowledge and experiences gained through the fellowship opportunities. The purpose of this email is to invite all interested parties to join a mailing list that has been created to bring together interested stakeholders so that we can deliberate on how to establish an open and inclusive ISOC chapter that will be based on a multistakeholder model. Kindly note that we will be required to be global ISOC members as a prerequistite. https://portal.isoc.org/EBusiness/NewMemberStepOne.aspx. Below please find instructions on how to join the mailing list. Welcome to the isoc(a)lists.my.co.ke mailing list! To post to this list, send your email to: isoc(a)lists.my.co.ke General information about the mailing list is at: http://lists.my.co.ke/cgi-bin/mailman/listinfo/isoc If you ever want to unsubscribe or change your options (eg, switch to or from digest mode, change your password, etc.), visit your subscription page at: http://lists.my.co.ke/cgi-bin/mailman/options/isoc/otieno.barrack%40gmail.c… You can also make such adjustments via email by sending a message to: isoc-request(a)lists.my.co.ke with the word `help' in the subject or body (don't include the quotes), and you will get back a message with instructions. You must know your password to change your options (including changing the password, itself) or to unsubscribe. It is: haakabso Normally, Mailman will remind you of your lists.my.co.ke mailing list passwords once every month, although you can disable this if you prefer. This reminder will also include instructions on how to unsubscribe or change your account options. There is also a button on your options page that will email your current password to you. -- Barrack O. Otieno +254721325277 +254-20-2498789 Skype: barrack.otieno

1 0

<OT>Samsung laptop p530
by Yast Labs 27 Jul '11

27 Jul '11

i got a samsung laptop p530 with the following spects -core i3,2.4ghz -3GB -320GB -webcam -wifi -dvd rw -15.6" if interested,contact me. also available; -Transcend ext. Hdd.-1TB,750GB,500GB, with 3.0 usb all 2.5" -Nvidia ge-force 210 graphics card,1GB ddr3,pci-e,with vga,DVI and HDMI ports -HDMI cable -TP-Link 3g routers,outdoor cpe -WD ext HDD 1TB with network. -- Regards, Kenneth Njuguna, Sales Executive, YastLabs Computer Solutions, 0723511949.

1 0

Access Kenya
by george 27 Jul '11

27 Jul '11

Has anyone else been experiencing slow speeds in AK since yesterday reason being SEACOM maintenance and how much is the degradation? Thanks, George.

9 12

Internet connections
by Lawrence Kago 27 Jul '11

27 Jul '11

Who knows of a good ISP that can provide connections for upto 8 computers.. Zuku is a mess Cyber :) -- *W/Regards *Lawrence * Fear Not,For the Lord God is with you..*

1 1

Alternative Sources of Power
by David Kiania | Asentric Consulting Ltd 26 Jul '11

26 Jul '11

Sometime ago I think I saw a thread where we were discussing how we can ensure there's elec even during rationing. I have heard some excellent ideas around how you can retrofit a UPS with External batteries to create an inverter with better uptimes. Have anyone done it practically? and could you please post a howto. Think this would come in very handy in the season starting tomorrow. Thx Kiania D -- [Asentric Consulting Ltd] "The more you sweat in training, the less you bleed in war." - Navy SEAL INSTRUCTOR

2 1

ISP in Gatundu
by Pithon Kamau 26 Jul '11

26 Jul '11

Greetings, Which is the best ISP i can use to supply internet to secondary schools in Gatundu? Regards -- Pithon K. Kamau Mobile: 0723 588705 / 0733 686562 *Tel*: +254 20 8083989 *Website*: www.heartbitsolutions.com *Blog*: www.heartbitsolutions.com/blog Website Design, Domain Registration, Website Hosting, Corporate Email Solutions, Website Maintainance, Website Marketing, Logo Design and Branding, Computer Hardware and Maintainance, Network Design and Set Up............. *"Better Late Than Never, But Never Late is Better"*

5 4

GeForce 200 series Axle
by Yast Labs 26 Jul '11

26 Jul '11

i got a Nvidia GeForce 210 series graphic card with 1GB memory ddr3, pci express at a good price. -- Regards, Kenneth Njuguna, Sales Executive, YastLabs Computer Solutions, 0723511949.

1 0