January 2009 - binari@psb.ugent.be - maillist.psb.ugent.be

[Binari] Re: new email domain active
by Thomas Van Parys 29 Jan '09

29 Jan '09

HelpDesk schreef: > For Your Information: > > the new mail domain is in use since 10u today. Your outgoing email > address is now /yourfullname/(a)psb.vib-ugent.be. > Is it? T. -- ================================================================== Thomas Van Parys Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM thomas.vanparys(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] aaaah, good old religion
by Sofie Van Landeghem 28 Jan '09

28 Jan '09

Thankfully, I know for a fact that we won't destroy the planet, because I know there will be a densely-populated world for Jesus to judge, return to, and rule over. It will be remade one day, and it will be a verdant Paradise one day — literally. But it won't happen through our recycling programs, solar panels, windmills, or odd-looking cars. It will be done by the triune God of Scripture. So what we need to know most is not how to recycle, worthwhile though that is. We need to know Jesus. jupjup. -Sofie

5 10

[Binari] Doing it wrong...
by Thomas Van Parys 27 Jan '09

27 Jan '09

I believe this one was the funniest of the doingitwrong.com website... I start laughing every time I see it again. T. -- ================================================================== Thomas Van Parys Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM thomas.vanparys(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] euhm .. oral defence
by Kenny Billiau 26 Jan '09

26 Jan '09

Hoi, anyone wants to sit in while I take the orals? I'm in the PC room. -Kenny ps: Michiel already has a Joker card he can use in this case -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

3 2

[Binari] MySQL exam
by Kenny Billiau 26 Jan '09

26 Jan '09

Hi, these are the MySQL questions! Have fun ;) (it's a basic course, so they shouldn't be that hard.) > Theory 1/ Give a way to solve ambiguous column names in a SELECT statement. 2/ How can you test if a value is undefined? 3/ Why is x IN (SELECT columnname FROM large_table) slow? 4/ How can you do inexact stringmatching? e.g. I want all names that have a 'en' in them. 5/ In which order are multiple order by's evaluated? 6/ Why can't you group aggregate functions? 7/ Why can't you use another attribute in the SELECT after the use of an aggregate function? 8/ Are NULL values 'used' with aggregate functions? 9/ What happens to NULL values in a GROUP BY? 10/ Why is ORDER BY useless/usefull in a subquery? 11/ Where can you use aggregate functions outside of the SELECT ... FROM ? 12/ Does the following query return any rows: DO expression(); 13/ Why do we use placeholders in a DBI query? 14/ With what can you replace the HAVING if you don't use aggregate functions in HAVING? 15/ What does NOT EXISTS check? > practice: 1/ Correct following query: SELECT sum(max(P.discount) * BD.price / 100) AS summed_price, P.bought, id FROM Buydetails, Books JOIN Promotions WITH BD.book_id = P.bought ORDER BY summed_price GROUP BY BD.book_id 2/ Correct following query SELECT title, SUM(price)*21/100 As PriceWithBTW FROM Buydetails, Books WHERE PriceWithBTW != price 3/ Add yourself to the table Members (provide at least a first and lastname). 4/ Change your id to '42'. 5/ Delete yourself again from the table Members. 6/ List all members (firstname, lastname) that live in Gent, Mariakerke and Belsele. Order them on their lastname. 7/ List all members (firstname, lastname) that have bought the book 'The Art of War' with VISA or Contant. 8/ List all members (firstname, lastname) that have bought the book 'The Art of War' three times. 9/ List all members (fristname, lastname) that have bought the book 'The Art of War'. Only list those members that have payed with VISA. Only list those members who payed more for 'The Art of War' then for any book sold in month of August. 10/ Write a perl DBI program that can print the title of all books a person bought. Don't panic! List the books the person with id 42 bought. -Kenny

4 4

[Binari] Cat DIY playhouse
by Kenny Billiau 23 Jan '09

23 Jan '09

http://www.suck.uk.com/product.php?rangeID=96 Cats are Brats -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

2 1

[Binari] Maybe an important hint for Symbrion?
by Thomas Van Parys 23 Jan '09

23 Jan '09

http://xkcd.com/534/ -- ================================================================== Thomas Van Parys Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM thomas.vanparys(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] The guy is doing it wrong!
by Kenny Billiau 20 Jan '09

20 Jan '09

Not the football guy (that's just to keep you off work) The wetlab guy! Should we forward him doingitwrong.com to him? ;) http://www.doingitwrong.com/wrong/wrong33.jpg =?UTF-8?B?U3ViamVjdDogRXZlbnQgSW52aXRhdGlvbjogQ29udHJvbCBvZiBCcmE=?= =?UTF-8?B?c3Npbm9zdGVyb2lkIEdlbm9taWMgUmVzcG9uc2VzOixXaGVuIHBob3NwaG9yeWw=?= =?UTF-8?B?YXRpb24gdGFrZXMgdGhlIGxlYWTigJ0=?= Content-type: multipart/mixed; boundary="Boundary_(ID_qyG4ZdjoAsiZ+Jo19dCbWQ)" --Boundary_(ID_qyG4ZdjoAsiZ+Jo19dCbWQ) Content-type: multipart/alternative; boundary="Boundary_(ID_ryU4ZdJoASiZ+Jo21dCbwA)" --Boundary_(ID_ryU4ZdJoASiZ+Jo21dCbwA) Content-type: text/plain; charset=UTF-8 Content-transfer-encoding: 8BIT Jerome Martin <jemar(a)psb.ugent.be> has invited you to Control of Brassinosteroid Genomic Responses:,When phosphorylation takes the leadâ? --Boundary_(ID_ryU4ZdJoASiZ+Jo21dCbwA) Content-type: text/calendar; method=REQUEST; charset=UTF-8 Content-transfer-encoding: 8BIT BEGIN:VCALENDAR PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN VERSION:2.0 METHOD:REQUEST BEGIN:VTIMEZONE TZID:Europe/Brussels X-LIC-LOCATION:Europe/Brussels BEGIN:DAYLIGHT TZOFFSETFROM:+0100 TZOFFSETTO:+0200 TZNAME:CEST DTSTART:19700329T020000 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=3 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:CET DTSTART:19701025T030000 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10 END: STANDARD END: VTIMEZONE BEGIN:VEVENT CREATED:20090120T131230Z LAST-MODIFIED:20090120T131342Z DTSTAMP:20090120T131342Z UID:fd1ba4c4-9a68-4f8e-bac4-9609b3948350 SUMMARY:Control of Brassinosteroid Genomic Responses:\,When phosphorylation takes the leadâ? ORGANIZER;RSVP=FALSE;CN=Jerome Martin;PARTSTAT=ACCEPTED; ROLE=REQ-PARTICIPANT:mailto:jemar@psb.ugent.be ATTENDEE;RSVP=TRUE;PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT:mailto: research(a)psb.ugent.be DTSTART;TZID=Europe/Brussels:20090126T110000 DTEND;TZID=Europe/Brussels:20090126T120000 DESCRIPTION:Dear \nAllPlease find enclosed the announcement of our next \ntalk.On Monday 26 January\, Dr. GrÃ©gory Vert will give a talk at \n11am.If you would like to meet GrÃ©gory Vert\, please contact me before Friday \n22 January.Thank you in advance for your answer.Kind \nregards\nNathalie\n__________________________________________\n\nNathali e Vanden \nHautteAdministrative \nAssistantVIB Department of \nPlant Systems Biology\, UGentTechnologiepark \n9279052 Gent \n(Zwijnaarde)BelgiumTel: +32 / 9 33 13 800 Fax: +32 / 9 33 \n13 809Http: //www.psb.ugent.be\n TRANSP:OPAQUE SEQUENCE:0 END: VEVENT END: VCALENDAR --Boundary_(ID_ryU4ZdJoASiZ+Jo21dCbwA)-- --Boundary_(ID_qyG4ZdjoAsiZ+Jo19dCbWQ) Content-type: application/ics; name=invite.ics Content-transfer-encoding: 8BIT Content-disposition: attachment; filename=invite.ics BEGIN:VCALENDAR PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN VERSION:2.0 METHOD:REQUEST BEGIN:VTIMEZONE TZID:Europe/Brussels X-LIC-LOCATION:Europe/Brussels BEGIN:DAYLIGHT TZOFFSETFROM:+0100 TZOFFSETTO:+0200 TZNAME:CEST DTSTART:19700329T020000 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=3 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:CET DTSTART:19701025T030000 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10 END: STANDARD END: VTIMEZONE BEGIN:VEVENT CREATED:20090120T131230Z LAST-MODIFIED:20090120T131342Z DTSTAMP:20090120T131342Z UID:fd1ba4c4-9a68-4f8e-bac4-9609b3948350 SUMMARY:Control of Brassinosteroid Genomic Responses:\,When phosphorylation takes the leadâ? ORGANIZER;RSVP=FALSE;CN=Jerome Martin;PARTSTAT=ACCEPTED; ROLE=REQ-PARTICIPANT:mailto:jemar@psb.ugent.be ATTENDEE;RSVP=TRUE;PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT:mailto: research(a)psb.ugent.be DTSTART;TZID=Europe/Brussels:20090126T110000 DTEND;TZID=Europe/Brussels:20090126T120000 DESCRIPTION:Dear \nAllPlease find enclosed the announcement of our next \ntalk.On Monday 26 January\, Dr. GrÃ©gory Vert will give a talk at \n11am.If you would like to meet GrÃ©gory Vert\, please contact me before Friday \n22 January.Thank you in advance for your answer.Kind \nregards\nNathalie\n__________________________________________\n\nNathali e Vanden \nHautteAdministrative \nAssistantVIB Department of \nPlant Systems Biology\, UGentTechnologiepark \n9279052 Gent \n(Zwijnaarde)BelgiumTel: +32 / 9 33 13 800 Fax: +32 / 9 33 \n13 809Http: //www.psb.ugent.be\n TRANSP:OPAQUE SEQUENCE:0 END: VEVENT END: VCALENDAR --Boundary_(ID_qyG4ZdjoAsiZ+Jo19dCbWQ)--

1 0

[Binari] [Fwd: Re: rafken ....]
by lieven sterck 20 Jan '09

20 Jan '09

da wordt morgenvroeg is binnenspringen zekers, of ister iemand die da aan de praat krijgt. L. -------- Original Message -------- Subject: Re: rafken .... Date: Mon, 19 Jan 2009 16:13:32 +0100 From: Raf De Schepper <rasch(a)psb.ugent.be> To: lieven sterck <lieven.sterck(a)psb.ugent.be> References: <4974936C.5000609(a)psb.ugent.be> 1. folder maken met naam folder/ 2. in deze folder kan je dan een subfolder aanmaken. 3. als je een lege map wil wissen: a. mail sluiten b. *.*subscritions openen in notepad2.exe (juiste regel wissen) Als't nie moest lukken, springt dan morgenvroeg 's binnen (moe nu effe nr de Ledeganck) Raf lieven sterck wrote: > kan da dat ik geen subfolders in folders kan maken via imap?? > kunde da arangeren dat da wel lukt? kzou dat wel nodig hebben eigenlijk. > > thx, > L. > -- ================================================================== Raf De Schepper IT Support Tel:+32 (0)9 331 38 16 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM rasch(a)psb.ugent.be http://www.psb.ugent.be ================================================================== -- ============================================================== Lieven Sterck, PhD Tel:+32 (0)9 3313821 Fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, UGent Bioinformatics and Evolutionary Genomics Division Technologiepark 927, B-9052 Gent, Belgium Email: lieven.sterck(a)psb.ugent.be Website: http://bioinformatics.psb.ugent.be ============================================================== "Facts are meaningless. You could use facts to prove anything that's even remotely true!" H. Simpson

2 2

[Binari] What do you call people who are not on the internet?
by Kenny Billiau 16 Jan '09

16 Jan '09

http://brepettis.com/blog/2009/01/12/who-are-the-people-that-arent-on-the-i… Well .. people 1.0 made me laugh :) -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0