Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 38F66633AEF for ; Wed, 9 Sep 2009 12:21:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 82911-07 for ; Wed, 9 Sep 2009 15:21:23 +0000 (UTC) X-Greylist: delayed 12:56:52.589663 by SQLgrey-1.7.6 Received: from a2s36.a2hosting.com (a2s36.a2hosting.com [74.126.18.130]) by mail.postgresql.org (Postfix) with ESMTP id 6DF48633A8C for ; Wed, 9 Sep 2009 12:21:23 -0300 (ADT) Received: from 96-28-97-106.dhcp.insightbb.com ([96.28.97.106] helo=[127.0.0.1]) by a2s36.a2hosting.com with esmtpa (Exim 4.69) (envelope-from ) id 1MlCrF-0006F3-Af for pgsql-php@postgresql.org; Tue, 08 Sep 2009 22:24:29 -0400 Message-ID: <4AA73C10.2080709@rdwonline.com> Date: Tue, 08 Sep 2009 22:24:32 -0700 From: "Ronald D. Willis" User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: PostgreSQL PHP Subject: Re: Stored procedures, PDO, and PHP issue References: 62DC7EB1-B4BB-4289-B880-4C7AD1B1AF02@zonarsystems.com Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s36.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - rdwonline.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.275 tagged_above=-10 required=5 tests=BAYES_50=0.001, DATE_IN_FUTURE_03_06=0.274 X-Spam-Level: X-Archive-Number: 200909/13 X-Sequence-Number: 4071 Add this as a PDO option array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION) I bet there's a PDOException being thrown and I would NOT be at all surprised if it is a HY000 error where PDO is complaining about unbuffered queries.... On 2009-08-19 20:47, Eric Chamberlain wrote: > Wow, I apologize. The code is exactly like what yours is. In my rush > I missed the correct code. > > Eric > > > >>> $stmt->bindParam(1, $userId, $hashPass, PDO::PARAM_INT); > > > > > > You should be calling bindParam once for each parameter > > $stmt->bindParam(1, $userId, PDO::PARAM_INT); > > $stmt->bindParam(2, $hashPass, PDO::PARAM_STR); > > > > > > Nick > > > >