[PHP-DB] Re: PDO ?

2013-01-15 Thread Jim Giner
Never Mind A little careful re-reading of the docs told me what I was doing wrong. I always use PDO::FETCH_ASSOC in my fetch statements. Discovered that I have to have numerical array results in order to utilize the List command. Voila! -- PHP Database Mailing List (http://www.php.net/

[PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Jim Giner
On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of "new PDO", "prepare", "bindParam", "execute", "fetch", and "query", it seems that bindParam is the only one that throws an exception. So i

[PHP-DB] Re: [PDO] unexpected behaviour

2005-07-09 Thread Wez Furlong
There were some issues with in the mysql driver; they were fixed just yesterday. If you upgrade to the latest snapshot from http://snaps.php.net, you should have better luck. You'll probably benefit from a deeper explanation of what's going on here, so here we go: Generally speaking, a driv

[PHP-DB] Re: PDO user question

2012-09-10 Thread Jim Giner
On 9/8/2012 2:02 PM, Jim Giner wrote: I finally delved into learning how I was going to replace my MYSQL calls with a different interface. Had to go with PDO since my hoster doesn't support MYSQLI for my plan. I've had some success with querying using pdo and prepared statements as well. One t

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Lars Nielsen
> On 4/22/2013 11:55 AM, Onatawahtaw wrote: >> Greetings, >> >> I am new to this list. I have a question about which functions need to >> be included in a try block. >> >> Of "new PDO", "prepare", "bindParam", "execute", "fetch", and "query", >> it seems that bindParam is the only one that throws a

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Jim Giner
On 4/24/2013 9:43 AM, Lars Nielsen wrote: On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of "new PDO", "prepare", "bindParam", "execute", "fetch", and "query", it seems that bindParam is th

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Lars Nielsen
> On 4/24/2013 9:43 AM, Lars Nielsen wrote: >>> On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of "new PDO", "prepare", "bindParam", "execute", "fetch", and "query"

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Jim Giner
On 4/24/2013 10:04 AM, Lars Nielsen wrote: On 4/24/2013 9:43 AM, Lars Nielsen wrote: On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of "new PDO", "prepare", "bindParam", "execute", "fetch"

[PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-20 Thread David Robley
Matt Pelmear wrote: > Hello, > > I'm trying to detect data truncation on insert to MySQL using PDO. > > As far as I can tell, this gets reported at least in some cases (ex: > http://drupal.org/node/1528628), but I have been unable to see this > myself. > > The test table I'm using has a column

Re: [PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-20 Thread Matt Pelmear
On 08/21/2012 01:08 AM, David Robley wrote: Matt Pelmear wrote: Hello, I'm trying to detect data truncation on insert to MySQL using PDO. As far as I can tell, this gets reported at least in some cases (ex: http://drupal.org/node/1528628), but I have been unable to see this myself. The test

Re: [PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-21 Thread Amit Tandon
Dear Matt, Even with MySQL, u get the warning as the show warnings is enabled. With php bound scripts, you have to check warnings to see the warnings. However, php is quite flexible and you an use error_reporting(E_WARNING) for non-fatal error reporting regds amit On Aug 21, 2012 10:41 AM, "Matt

Re: [PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-21 Thread Matt Pelmear
Amit, Thanks for the suggestion. Unfortunately, even when I explicitly enable E_WARNING or even E_ALL error reporting in php I still do not receive any indication that data was truncated on insert. -Matt On 08/21/2012 07:09 AM, Amit Tandon wrote: Dear Matt, Even with MySQL, u get the warn

Re: [PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-21 Thread Bastien Koert
On Tue, Aug 21, 2012 at 4:44 PM, Matt Pelmear wrote: > Amit, > > Thanks for the suggestion. Unfortunately, even when I explicitly enable > E_WARNING or even E_ALL error reporting in php I still do not receive any > indication that data was truncated on insert. > > -Matt > > > On 08/21/2012 07:09 A

Re: [PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-21 Thread Karl DeSaulniers
On Aug 21, 2012, at 3:44 PM, Matt Pelmear wrote: Amit, Thanks for the suggestion. Unfortunately, even when I explicitly enable E_WARNING or even E_ALL error reporting in php I still do not receive any indication that data was truncated on insert. -Matt On 08/21/2012 07:09 AM, Amit Tando

[PHP-DB] Re: [PDO] Cannot execute queries while other unbuffered queries are active

2008-03-24 Thread Roberto Mansfield
Have you tried using closeCursor() after your query is finished? -Roberto Fabian Golle wrote: > Hey, > > I'm using a PDO-MySQL in a class of my Accounting-Framework. The problem: if > I call my function query(), see below, multiple times, I get the error: > > > > Array ( [0] => HY000 [1] =>