Re: OID output problems

From: surfer girl <gidget(at)getitgear(dot)com>
To: gidget(at)getitgear(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: OID output problems
Date: 2000-05-03 06:13:14
Message-ID: 20000503051314.F281640BD@sitemail.everyone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- "Robert B. Easter" <reaster(at)comptechnews(dot)com> wrote:
>
>Try recompiling php 4.0RC1 or whatever is current with the latest Apache
>source (1.3.12). I'm thinking maybe you are not running php as compiled into
>the server.

Thanks - I had PHP compiled into the server - though I may try the recompile as a last resort (before the major last resort of just keeping images as files and putting the filename and location into the db).

Someone asked if my INPUT was correct. Here's what I've got:

pg_Exec($conn, "BEGIN");
$oid = pg_locreate($conn);
$handle = pg_loopen($conn, $oid, "w");
pg_lowrite($handle, $file);
pg_loclose($handle);
$result = pg_Exec($conn, "INSERT INTO file (file, filetype, permissions, key_imageid) VALUES ('$oid', '$filetype','$permissions','$imageid')" );
pg_Exec($conn, "COMMIT");

Unfortunately there aren't tons of examples around for this stuff so I don't have much to compare this to. (Based this off the Addison Wesley book).

Thanks

_____________________________________________________________
Get It Gear --> http://www.getitgear.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Barnes 2000-05-03 08:21:41 RE: date format problem
Previous Message Anand Raman 2000-05-03 05:35:32 Re: date format problem