picture and text insert

[Ruslan Zasukhin]

On 10/4/07 12:31 PM, "Kim Kohen" <kim at webguide.com.au> wrote:

Hi Kim,

> I'd like to do an insert into a db of a picture (picture or BLOB),
> some text (varchar) and a base64 encoded folderitem (varchar). I've
> looked at the picture field examples but even the SQL version uses
> the API to insert the pictures. I want a purely SQL way of doing the
> insert and a purely SQL way of retrieving them.

SQL way with binding should be good choice.
Because it is bad idea to insert big blob/text values inside of SQL query.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]