PH Web and BLOBS
Peter Bateman
shediac92@hotmail.com
Thu, 13 May 2004 11:39:17 -0300
JP:
I guess the way to do what Harold needs is to have a stored procedure or a
user defined
function to create the file on the database server and return the fully
qualified filename
to the field. In your example, DOCS of EMPLOYEES
Regards,
Peter
>From: "Deskin, Bob" <Bob.Deskin@Cognos.COM>
>To: "Peter Bateman" <shediac92@hotmail.com>,<powerh-l@lists.sowder.com>
>Subject: RE: PH Web and BLOBS
>Date: Thu, 13 May 2004 09:08:06 -0400
>
>DO BLOB is not supported in PH Web at this time. Allowing a portion of the
>DO BLOB functionality, specifically copying BLOBs to an external file, is
>being considered for a future release.
>
>Bob Deskin
>Senior Product Manager, Application Development Tools, Cognos Inc.
>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
>
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com
>[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Peter Bateman
>Sent: May 13, 2004 8:58 AM
>To: powerh-l@lists.sowder.com
>Subject: RE: PH Web and BLOBS
>
>
>JP:
>
>In Harold's case this may work. His code most likely is generating a
>differently named
>PDF file with each call to DO BLOB. Is DO BLOB supported in PowerHouse Web?
>
> >Images, PDF files, and Movies can also be referenced dynamically and
> > then linked to from the Web page. This is accomplished by:
> >
> >FIELD Docs OF EMPLOYEES Label &
> > "<A HREF=/media/<!--PH:FIELD:EMPLOYEES:DOCS-->>Document</A>"
> > or
> >FIELD Docs OF EMPLOYEES Label "Document"
> >Title "<A HREF=/media/<!--PH:FIELD:EMPLOYEES:DOCS-->>View Document</A>"
> >
> >An example of the result page is attached.
> >
> >JP Fortin
> >
> >-----Original Message-----
> >From: powerh-l-admin@lists.sowder.com
> >To: 'Peter Bateman'; powerh-l@lists.sowder.com
> >Sent: 5/12/04 12:46 PM
> >Subject: RE: PH Web and BLOBS
> >
> >We are actually using the blob fields to store images in PDF format.
> >Currently, using PH for VMS and Reflections, we can extract the blob and
> >display it on Windows using Adobe reader. As I understand it however,
> >the
> >DO BLOB doesn't exist under PH Web, so I'm looking for another method
> >to allow us to extract and display these PDF's over the web.
> >
> >
> >cheers
> >
> >
> >-----Original Message-----
> >From: powerh-l-admin@lists.sowder.com
> >[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Peter Bateman
> >Sent: 2004 May 12 9:35 AM
> >To: powerh-l@lists.sowder.com
> >Subject: RE: PH Web and BLOBS
> >
> >
> >Harold:
> >
> > If you are viewing and editing text from your blob column then you
> > could use a multi-line scrollable field. PowerHouse Web should be
> > able
> >
> >handle this situation.
> > It would be interesting to see if it can handle more text than that
> >which can be displayed on one
> > screen.
> >
> > DO BLOB uses the user interface embedded in the editing program most
> >likely EDT for VMS.
> >
> > You might be able to run you terminal version of PowerHouse under
> > Reflections for the Web
> > http://www.wrq.com/products/reflection/win/ruov/specs.html
> >
> > But that is not what you most likely need. I suspect you need to
> >have a local editing capablitity.
> > But how do you keep the editing under transaction control? Or do you
> >
> >need that?
> >Regards,
> >Peter
> >
> >
> > >From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson@gems1.gov.bc.ca>
> > >To: powerh-l@lists.sowder.com
> > >Subject: PH Web and BLOBS
> > >Date: Tue, 11 May 2004 14:40:53 -0700
> > >
> > >Anyone used PH web to extract blobs (ie: text files, PDF files,
> > >etc..)
> >from
> > >an RDB database and display on screen? (windows)
> > >
> > >If so, any hints?
> > >
> > >thnx
> > >= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> > >powerh-l@lists.sowder.com
> > >Subscribe: "subscribe" in message body to
> >powerh-l-request@lists.sowder.com
> > >Unsubscribe: "unsubscribe <password>" in message body to
> > >powerh-l-request@lists.sowder.com
> > >http://lists.sowder.com/mailman/listinfo/powerh-l
> > >This list is closed, thus to post to the list you must be a
> > >subscriber.
> >
> >_________________________________________________________________
> >http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&S
> >U
> >=htt
> >p://hotmail.com/enca&HL=Market_MSNIS_Taglines
> >
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> >powerh-l@lists.sowder.com
> >Subscribe: "subscribe" in message body to
> >powerh-l-request@lists.sowder.com
> >Unsubscribe: "unsubscribe <password>" in message body to
> >powerh-l-request@lists.sowder.com
> >http://lists.sowder.com/mailman/listinfo/powerh-l
> >This list is closed, thus to post to the list you must be a subscriber.
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> >powerh-l@lists.sowder.com
> >Subscribe: "subscribe" in message body to
> >powerh-l-request@lists.sowder.com
> >Unsubscribe: "unsubscribe <password>" in message body to
> >powerh-l-request@lists.sowder.com
> >http://lists.sowder.com/mailman/listinfo/powerh-l
> >This list is closed, thus to post to the list you must be a subscriber.
> >
> >
> >This message may contain privileged and/or confidential information.
> >If
> >you
> >have received this e-mail in error or are not the intended recipient, you
> >may not use, copy, disseminate or distribute it; do not open any
> >attachments, delete it immediately from your system and notify the sender
> >promptly by e-mail that you have done so. Thank you.
> >
> >
> ><< PHWeb_pdf.doc >>
>
>_________________________________________________________________
>Add photos to your e-mail with MSN Premium. Get 2 months FREE*
>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
_________________________________________________________________
Add photos to your e-mail with MSN Premium. Get 2 months FREE*
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines