---------------------------------------------------------------------
OK thanks.
I downloaded the http://arswiki.org/dist/ars/api/api_win_en_700_000.zip from the web.
Now, how do I write a C program to display a BLOB file (PDF) from the table B52CXXXXXXXXX in the aradmin schema? Also, I would like the program to automatically know the MIME type (its stored in B52 table)...so the C program must query the B52 table and find out the MIME type and then open it in a suitable program. Any pointers?
Thanks.
On 7/31/06, Jason McDonald <[EMAIL PROTECTED]> wrote:
OK thanks.I downloaded the http://arswiki.org/dist/ars/api/api_win_en_700_000.zip from the web.Now, how do I write a C program to display a BLOB file (PDF) from the table B52CXXXXXXXXX in the aradmin schema? Also, I would like the program to automatically know the MIME type (its stored in B52 table)...so the C program must query the B52 table and find out the MIME type and then open it in a suitable program. Any pointers?Thanks.
On 7/30/06, Michiel Beijen <[EMAIL PROTECTED] > wrote:you could use it from a C program, or from java, or other langages.
See http://arswiki.org/wiki/index.php?title=API_Programming
-- Michiel
On 7/30/06, Jason McDonald <[EMAIL PROTECTED] > wrote:
> **
> Could you please explain how to use the API?
>
> Thanks
>
>
> On 7/30/06, Michiel Beijen < [EMAIL PROTECTED]> wrote:
> >
> they are not exactly encrypted, but they ARE compressed. That's why
> you could not just extract the binary data and open the file. But
> that's also the reason that a 30MB word doc only occupies a fraction
> of that once stored in the database...
> If you'd extract the attachment using the API it would uncompress the
> file nicely.
> --
> Michiel
>
> On 7/30/06, Jason McDonald < [EMAIL PROTECTED]> wrote:
> > **
> > Hi All,
> >
> > I wanted to know how Remedy ( 7.0) stores LOB data. I was trying to extract
> > directly from the database a BLOB field (attachment in remedy ; in this
> case
> > it was a PDF file) but although I knew the MIME type and opened it in a
> > special tool designed to extract BLOB data, Acrobat Reader refused to open
> > it (it said invalid file).
> >
> > Further, following the same process as above, even if I open a 'text file'
> > attachment, the contents seem to be encrypted and I see junk data when
> > opening it in Notepad.
> >
> > Are attachments encrypted by Remedy before storing it in the database? If
> > so, how do I bypass remedy and view BLOB data?
> >
> > (Dev Env)
> > ARS 7.0
> > Oracle 10g
> > OS - Windows
> >
> > Thanks,
> > Jason __20060125_______________________This posting was
> > submitted with HTML in it___
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
> __20060125_______________________This posting was
> submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
