X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BA55CD1B4F6 for ; Thu, 18 Sep 2003 12:39:33 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 48539-06 for ; Thu, 18 Sep 2003 09:39:05 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 71C2FD1B4E5 for ; Thu, 18 Sep 2003 09:39:01 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h8ICc9Mc002658; Thu, 18 Sep 2003 06:38:09 -0600 (MDT) Date: Thu, 18 Sep 2003 06:34:03 -0600 (MDT) From: "scott.marlowe" To: Brion Wikes Cc: Subject: Re: Interview questions? In-Reply-To: <000a01c37d8e$d8dc2540$026fa8c0@global.cadence.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/60 X-Sequence-Number: 2337 On Wed, 17 Sep 2003, Brion Wikes wrote: > Odd request. > I am not a developer myself, but would like to know what kinds of technical > interview questions (and possible answers) I can ask developers to try to > find someone that really knows what they are doing. > > I need to hire a postreSQL/php developer for some maintenance and upgrade > work on my site. > > The site is fairly sophisticated. I think it was built on postreSQL 6X and > PHP. When we loaded to the server, we ended up with 7X and there seems to be > a few wrinkles with the code on the newer version. > A few of the main issues that I am going to need this person to deal with > are: > > > > 1) On one custom form, I am getting the error - "no OID was passed" > > 2) Being able to search "non-case sensitive" AND being able to hold the > order of the results from page to page. substitute ilike for like or ~* for ~ in the where clause for this one. > 3) Using an "apostrophe" anywhere in any of the forms, creates a page error Turn on the magic_quotes_gpc, and magic_quotes_runtime parameters to fix this. You may only need the first. Test it both ways. Either that or put addslashes/stripslashes all over the place. > 4) Every time I edit one of the forms with a url, an extra "http://" gets > put into the address simple fix, the code is probably programmed to prepend http://. The old code may have been programmed to remove the http:// during display but got broken somehow. > 5) On several forms, if you have not completed all the information, and you > get an error message, ALL of the info that was input during that session, is > cleared. > > > > I am nervous to have a complete stranger working on the code, but the > original developer is no longer available. > I am guessing most of these should be fairly straight forward fixes. > > So any help on screening questions that will help me find a developer > capable of solving these problems, is most appreciated. Ask them what they think of these issues and what the likely causes are. any competent PHP/Postgresql programmer should be able to fix 2, 3, or 4 in an afternoon.