Hello,
first of all, I must say that I am an (happy) beginner with cocoon and
postgresql.
I created a postgres database in which I store blob (Binary Large OBjet
such as jpeg images).
Though, I use <sql:query> to do all of my queries but I really don't
know how to access to a blob.
in PHP the code will be something like :
<?php
$db = pg_connect("dbname=db-pfe host=localhost user=apache");
pg_freeresult(pg_exec($db, "begin"));
$lo = pg_loopen($db, 164907, "r");
header("Content-type: image/jpeg");
pg_loreadall($lo);
pg_loclose($lo);
pg_freeresult(pg_exec($db, "rollback"));
pg_close($db);
?>
My main problem is the use of lo_open lo_read and others in XML/XSL.
(I do not find any example on the web with these funtions)
thank you in advance,
Stephane
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
