IDS Forum

RE: LOTOFILE - To Get Image From Database

Posted By: Dharmendra Sharma
Date: Friday, 10 June 2011, at 7:33 p.m.

In Response To: Re: LOTOFILE - To Get Image From Database (Art Kagel)

Hi Art,

First, thanks a lot for quick response.

I believe , this will require us to store the pathName as part of the file name, correct? This is great solution..but unfortunately, this might not work either
as in our case as the file_name_column is responsibily of another program that stores the images into database and therefore,
the file name/path name will be different than the path we want images to be downloaded via LOTOFILE. Any other suggestion?

Also , while running my tests today, I noticed that "LOTOFILE" when downloads the image to a directory adds hex values at the end of file name.
For example, instead of "fileName.jpg", I got the file called "fileName.jpg.a400140ea..". To prevent addtional suffix values after .jpg, I had to put "!" at the end of file
name in LOTOFILE function as "LOTOFILE(iod_image,'/tmp/IMAGES/fileName.jpg!','server')..This will also need to be consider while adding
customize/columnName in LOTOFILE syntax.

Regards,

Dharmendra

> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: LOTOFILE - To Get Image From Database [23983]
> Date: Fri, 10 Jun 2011 19:15:19 -0400
>
> SELECT LOTOFILE(iod_image, file_name_column, 'server') FROM
> imageorderdetail where img_id = 1;
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Fri, Jun 10, 2011 at 7:10 PM, DHARMENDRA SHARMA <
> dharmendrasharma@hotmail.com> wrote:
>
> > Hi All,
> >
> > I have a question about LOTOFILE function to get the images stored in Blob.
> > So
> > far, I am able to store and retrive images from the database table by using
> > FILETOBLOB and LOTOFILE respectively and hardcoded path/filename. It works
> > great!! Now, I am looking for a way to substitute the hardcoded path/file
> > name
> > to a variable name so PathName/fileName can be customized.
> >
> > Here is syntax for LOTOFILE :
> >
> > SELECT LOTOFILE(iod_image,'/tmp/IMAGES/fileName.jpg','server') FROM
> > imageorderdetail where img_id = 1;
> >
> > Per requirement, the above SELECT will be used multiple times by passing
> > img_id as a parameter. To do so, I will prepare this SELECT statement..but
> > got
> > stuck on how to handle the fileName portion. For each id, the fileName
> > needs
> > to be different. Please note, I do have a column in the same table that
> > stores
> > fileName for each image. I need to know the best way to use the same in
> > LOTOFILE.
> >
> > Here are additional information. : IDS 11.50
> >
> > ESQL/C
> >
> > Please let me know if you need further information..Thanks in advance.
> >
> > Regards,
> >
> > Dharmendra
> >
> >
> >
> >
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --20cf3071c69614263904a563be46
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• LOTOFILE - To Get Image From Database
  DHARMENDRA SHARMA -- Friday, 10 June 2011, at 7:10 p.m.
  • Re: LOTOFILE - To Get Image From Database
    Art Kagel -- Friday, 10 June 2011, at 7:15 p.m.
    • RE: LOTOFILE - To Get Image From Database
      Dharmendra Sharma -- Friday, 10 June 2011, at 7:33 p.m.
      • Re: LOTOFILE - To Get Image From Database
        Art Kagel -- Saturday, 11 June 2011, at 9:30 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.