> Benoît Minisini a écrit :
> >> Benoît Minisini a écrit :
> Hi,
>
> How can I escape a picture in order to insert it into a BYTEA
> postgresql data field?
> >>>
> >>> Normally, if the postgresql field datatype is BYTEA, the gb.db
> >>> component will see it as a blob.
> >>>
> >
Benoît Minisini a écrit :
>> Benoît Minisini a écrit :
Hi,
How can I escape a picture in order to insert it into a BYTEA
postgresql data field?
>>> Normally, if the postgresql field datatype is BYTEA, the gb.db component
>>> will see it as a blob.
>>>
>>> Let's suppose the field
Benoît Minisini a écrit :
>> Benoît Minisini a écrit :
Hi,
How can I escape a picture in order to insert it into a BYTEA
postgresql data field?
>>> Normally, if the postgresql field datatype is BYTEA, the gb.db component
>>> will see it as a blob.
>>>
>>> Let's suppose the field
> Benoît Minisini a écrit :
> >> Hi,
> >>
> >> How can I escape a picture in order to insert it into a BYTEA
> >> postgresql data field?
> >
> > Normally, if the postgresql field datatype is BYTEA, the gb.db component
> > will see it as a blob.
> >
> > Let's suppose the field name is "Picture". You
Charlie Reinl a écrit :
...
> http://www.ms-office-forum.net/forum/sitemap/index.php?t-243720.html
>
> - encode the binary file using base64 and store as TEXT
> - is using ADODB.Stream (are there something like that in gambas )
Thanks Charlie
--
Q: What does it say on the bottom of Coke ca
Benoît Minisini a écrit :
>> Hi,
>>
>> How can I escape a picture in order to insert it into a BYTEA
>> postgresql data field?
>>
>
> Normally, if the postgresql field datatype is BYTEA, the gb.db component will
> see it as a blob.
>
> Let's suppose the field name is "Picture". You will do:
>
>
> Hi,
>
> How can I escape a picture in order to insert it into a BYTEA
> postgresql data field?
>
Normally, if the postgresql field datatype is BYTEA, the gb.db component will
see it as a blob.
Let's suppose the field name is "Picture". You will do:
MyResult!Picture = File.Load("/path/to/pic
Am Dienstag, den 24.11.2009, 19:30 +0100 schrieb Jean-Yves F. Barbier:
> Hi,
>
> How can I escape a picture in order to insert it into a BYTEA
> postgresql data field?
>
Salut,
no idea whats a BYTEA, I looked in the I-net, and found something in
german.
http://www.ms-office-forum.net/forum/si
richard terry a écrit :
...
> Note also with gambas. I've raised this with the list/devel/benoit and had no
> replies
Ducking is never a good answer...
--
The proof of the pudding is in the eating.
-- Miguel de Cervantes
richard terry a écrit :
...
> Don't forget to commit your transaction
>
>
> sample table:
>
> CREATE TABLE all_images
> (
> pk serial NOT NULL,
> image bytea,
> deleted boolean,
> CONSTRAINT all_images_pkey PRIMARY KEY (pk)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE all_images OWNER
richard terry a écrit :
No Richard, I can't do that for:
* I already have a connection, and I wanna keep connection number as low
as possible,
* I do things as they should be done, so not any direct user permission
on any DB schema/table/index/sequence/etc; So I can't insert anything
On Wednesday 25 November 2009 07:46:31 you wrote:
> On Wednesday 25 November 2009 05:30:52 Jean-Yves F. Barbier wrote:
> > Hi,
> >
> > How can I escape a picture in order to insert it into a BYTEA
> > postgresql data field?
>
> Having mucked around with this interminably looking at different ways,
On Wednesday 25 November 2009 05:30:52 Jean-Yves F. Barbier wrote:
> Hi,
>
> How can I escape a picture in order to insert it into a BYTEA
> postgresql data field?
>
Having mucked around with this interminably looking at different ways, the
solution is in the picture database sample file, but ba
Hi,
How can I escape a picture in order to insert it into a BYTEA
postgresql data field?
--
Cocaine: using tomorrow's energy today.
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial.
14 matches
Mail list logo
