On May 7, 3:15 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> FeelLikeA...@gmail.com wrote:
> > I'm using the example on the following page for selecting and fetching
> > a large data object. <http://publib.boulder.ibm.com/infocenter/db2luw/
> > v9/index.jsp?topic=/com.ibm.db2.udb.apdv.php.doc/doc/t0023504.htm>
>
> > Here's what I've tried:
>
> > $avatarFile = tempnam('', '');
> > $avatarSteam = fopen($avatarFile, 'wb');
>
> > $stmt = $dbh->prepare('SELECT user_avatar FROM users WHERE user_id =
> > 29');
> > $stmt->execute();
> > $stmt->bindColumn('user_avatar', $avatarSteam, PDO::PARAM_LOB);
> > $stmt->fetch(PDO::FETCH_BOUND);
>
> > var_dump($coverSteam);
>
> > Ideally, $coverSteam should be a stream to a temporary file containing
> > the large data, but instead it's coming out as a string. And holding
> > the large data as a string in memory is exactly what I'm trying to
> > avoid. What am I doing wrong and how do I fix it? (I'm using SQLite,
> > in case it matters.)
>
> Where does $coverStream come from? The first time you use it here is on
> the var_dump() call.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================

Sorry. That was a mistake in the post. It should be $avatarSteam.