PH Web and BLOBS
Johnson, Harold A EDUC:EX
Harold.A.Johnson@gems1.gov.bc.ca
Wed, 12 May 2004 12:32:48 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C43857.C8D79BA0
Content-Type: text/plain;
charset="iso-8859-1"
This looks like it's just getting the NAME of the document from the
database, not the actual PDF itself from a database blob? Is this code
segment correctly laid out?
cheers
-----Original Message-----
From: Fortin, Jean-Pierre [mailto:Jean-Pierre.Fortin@cognos.com]
Sent: 2004 May 12 11:33 AM
To: Johnson, Harold A EDUC:EX; ''Peter Bateman' ';
'powerh-l@lists.sowder.com '
Subject: RE: PH Web and BLOBS
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
<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
<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
<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
<http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU>
&page=byoa/prem&xAPID=1994&DI=1034&SU
=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
<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
<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.
------_=_NextPart_001_01C43857.C8D79BA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: PH Web and BLOBS</TITLE>
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D188563119-12052004><FONT face=3DArial =
color=3D#0000ff size=3D2>This=20
looks like it's just getting the NAME of the document from the =
database, not the=20
actual PDF itself from a database blob? Is this code =
segment=20
correctly laid out?</FONT></SPAN></DIV>
<DIV><SPAN class=3D188563119-12052004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D188563119-12052004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>cheers</FONT></SPAN></DIV>
<DIV><SPAN class=3D188563119-12052004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Fortin, =
Jean-Pierre=20
[mailto:Jean-Pierre.Fortin@cognos.com]<BR><B>Sent:</B> 2004 May 12 =
11:33=20
AM<BR><B>To:</B> Johnson, Harold A EDUC:EX; ''Peter Bateman' ';=20
'powerh-l@lists.sowder.com '<BR><B>Subject:</B> RE: PH Web and=20
BLOBS<BR><BR></FONT></DIV><BR>
<P><FONT size=3D2>Images, PDF files, and Movies can also be =
referenced=20
dynamically and</FONT> <BR><FONT size=3D2> then linked to from =
the Web=20
page. This is accomplished by:</FONT> <BR><FONT =
size=3D2> </FONT> <BR><FONT=20
size=3D2>FIELD Docs OF EMPLOYEES Label =20
&</FONT> <BR><FONT size=3D2> "<A=20
=
HREF=3D/media/<!--PH:FIELD:EMPLOYEES:DOCS-->>Document</A>=
"</FONT>=20
<BR><FONT=20
=
size=3D2> &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; =20
or</FONT> <BR><FONT size=3D2>FIELD Docs OF=20
EMPLOYEES Label "Document" =20
</FONT><BR><FONT size=3D2>Title "<A=20
HREF=3D/media/<!--PH:FIELD:EMPLOYEES:DOCS-->>View=20
Document</A>"</FONT> </P>
<P><FONT size=3D2>An example of the result page is attached.</FONT> =
</P>
<P><FONT size=3D2>JP Fortin</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=3D2>To: 'Peter =
Bateman';=20
powerh-l@lists.sowder.com</FONT> <BR><FONT size=3D2>Sent: 5/12/04 =
12:46=20
PM</FONT> <BR><FONT size=3D2>Subject: RE: PH Web and BLOBS</FONT> =
</P>
<P><FONT size=3D2>We are actually using the blob fields to store =
images in PDF=20
format.</FONT> <BR><FONT size=3D2>Currently, using PH for VMS and =
Reflections,=20
we can extract the blob and</FONT> <BR><FONT size=3D2>display it on =
Windows=20
using Adobe reader. As I understand it however,</FONT> =
<BR><FONT=20
size=3D2>the</FONT> <BR><FONT size=3D2>DO BLOB doesn't exist under PH =
Web, so I'm=20
looking for another method to</FONT> <BR><FONT size=3D2>allow us to =
extract and=20
display these PDF's over the web.</FONT> </P><BR>
<P><FONT size=3D2>cheers</FONT> </P><BR>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=3D2>[<A=20
=
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>]On=20
Behalf Of Peter Bateman</FONT> <BR><FONT size=3D2>Sent: 2004 May 12 =
9:35=20
AM</FONT> <BR><FONT size=3D2>To: powerh-l@lists.sowder.com</FONT> =
<BR><FONT=20
size=3D2>Subject: RE: PH Web and BLOBS</FONT> </P><BR>
<P><FONT size=3D2>Harold:</FONT> </P>
<P><FONT size=3D2> If you are viewing and editing text from =
your blob=20
column then you</FONT> <BR><FONT size=3D2> could use a =
multi-line=20
scrollable field. PowerHouse Web should be able</FONT> </P>
<P><FONT size=3D2>handle this situation.</FONT> <BR><FONT =
size=3D2> It would=20
be interesting to see if it can handle more text than that</FONT> =
<BR><FONT=20
size=3D2>which </FONT><BR><FONT size=3D2>can be displayed on =
one</FONT> <BR><FONT=20
size=3D2> screen.</FONT> </P>
<P><FONT size=3D2> DO BLOB uses the user interface embedded in =
the editing=20
program most </FONT><BR><FONT size=3D2>likely</FONT> <BR><FONT =
size=3D2>EDT for=20
VMS.</FONT> </P>
<P><FONT size=3D2> You might be able to run you terminal =
version of=20
PowerHouse under</FONT> <BR><FONT size=3D2> Reflections for the =
Web</FONT>=20
<BR><FONT size=3D2> <A=20
href=3D"http://www.wrq.com/products/reflection/win/ruov/specs.html"=20
=
target=3D_blank>http://www.wrq.com/products/reflection/win/ruov/specs.ht=
ml</A></FONT>=20
</P>
<P><FONT size=3D2> But that is not what you most likely need. I =
suspect=20
you need to have</FONT> <BR><FONT size=3D2>a </FONT><BR><FONT =
size=3D2>local=20
editing capablitity.</FONT> <BR><FONT size=3D2> But how do you =
keep the=20
editing under transaction control? Or do you</FONT> </P>
<P><FONT size=3D2>need that?</FONT> <BR><FONT =
size=3D2>Regards,</FONT> <BR><FONT=20
size=3D2>Peter</FONT> </P><BR>
<P><FONT size=3D2>>From: "Johnson, Harold A EDUC:EX"=20
<Harold.A.Johnson@gems1.gov.bc.ca></FONT> <BR><FONT =
size=3D2>>To:=20
powerh-l@lists.sowder.com</FONT> <BR><FONT size=3D2>>Subject: PH =
Web and=20
BLOBS</FONT> <BR><FONT size=3D2>>Date: Tue, 11 May 2004 14:40:53 =
-0700</FONT>=20
<BR><FONT size=3D2>></FONT> <BR><FONT size=3D2>>Anyone used PH =
web to=20
extract blobs (ie: text files, PDF files, etc..)</FONT> <BR><FONT=20
size=3D2>from</FONT> <BR><FONT size=3D2>>an RDB database and =
display on=20
screen? (windows)</FONT> <BR><FONT size=3D2>></FONT> =
<BR><FONT=20
size=3D2>>If so, any hints?</FONT> <BR><FONT size=3D2>></FONT> =
<BR><FONT=20
size=3D2>>thnx</FONT> <BR><FONT size=3D2>>=3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT> <BR><FONT =
size=3D2>>Mailing list:=20
powerh-l@lists.sowder.com</FONT> <BR><FONT size=3D2>>Subscribe: =
"subscribe"=20
in message body to</FONT> <BR><FONT=20
size=3D2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT=20
size=3D2>>Unsubscribe: "unsubscribe <password>" in message =
body to=20
</FONT><BR><FONT =
size=3D2>>powerh-l-request@lists.sowder.com</FONT> <BR><FONT=20
size=3D2>><A =
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
=
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></F=
ONT>=20
<BR><FONT size=3D2>>This list is closed, thus to post to the list =
you must be=20
a subscriber.</FONT> </P>
<P><FONT=20
=
size=3D2>_______________________________________________________________=
__</FONT>=20
<BR><FONT size=3D2><A=20
=
href=3D"http://join.msn.com/?pgmarket=3Den-ca&page=3Dbyoa/prem&x=
APID=3D1994&DI=3D1034&SU"=20
=
target=3D_blank>http://join.msn.com/?pgmarket=3Den-ca&page=3Dbyoa/pr=
em&xAPID=3D1994&DI=3D1034&SU</A></FONT>=20
<BR><FONT size=3D2>=3Dhtt</FONT> <BR><FONT=20
size=3D2>p://hotmail.com/enca&HL=3DMarket_MSNIS_Taglines</FONT> =
</P>
<P><FONT size=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>=20
<BR><FONT size=3D2>Mailing list: powerh-l@lists.sowder.com</FONT> =
<BR><FONT=20
size=3D2>Subscribe: "subscribe" in message body to</FONT> <BR><FONT=20
size=3D2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2>Unsubscribe:=20
"unsubscribe <password>" in message body to</FONT> <BR><FONT=20
size=3D2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2><A=20
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
=
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></F=
ONT>=20
<BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
subscriber.</FONT> <BR><FONT size=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
=3D =3D =3D =3D =3D =3D =3D</FONT> <BR><FONT size=3D2>Mailing list:=20
powerh-l@lists.sowder.com</FONT> <BR><FONT size=3D2>Subscribe: =
"subscribe" in=20
message body to</FONT> <BR><FONT=20
size=3D2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2>Unsubscribe:=20
"unsubscribe <password>" in message body to</FONT> <BR><FONT=20
size=3D2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT =
size=3D2><A=20
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"=20
=
target=3D_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></F=
ONT>=20
<BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
subscriber.</FONT> </P><BR>
<P><FONT size=3D2>This message may contain privileged and/or =
confidential=20
information. If you have received this e-mail in error or are =
not the=20
intended recipient, you may not use, copy, disseminate or distribute =
it; do=20
not open any attachments, delete it immediately from your system and =
notify=20
the sender promptly by e-mail that you have done so. Thank=20
you.</FONT></P>
<P><FONT size=3D2></FONT> </P>
<P><FONT face=3DArial color=3D#000000 size=3D2></FONT> =
</P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C43857.C8D79BA0--