V4MD - Blob embedded images with text

[Ruslan Zasukhin]

On 6/23/04 6:23 PM, "Joseph Lantis" <joseph at lantis.cc> wrote:

Hi Joseph, 

> I am a Valentina and Director newbie and am attempting to use the Valentina
> dbe for a cd-rom project.  I have imported my data into a vdb and have a
> blob field which contains some HTML formatted text data.  This data may have
> a reference to zero, one, two or three image links.   I need to know how to
> get the image references to display at the appropriate spot in the text.  Is
> there a way to do this?  Is there a way to change my image file source to
> some type of pointer to an image blob reference?

> Can I import both text
> data and image data into the same blob field?

Only if you self prepare them to be as single block.

1) HTML text you better store not into BLOB field, but into TEXT field.

2) DBMS do not care about your HTML links inside of TEXT.
    so answer is no, there is no way to link your links to images stored in
the db...you need build some own mechanism.

For example,

* you store some HTML into TEXT field of table 'HTML'
    when you do AddRecord() you get RecID of just added record.

* you self parse and find link, and get images.

    let you store images into Table "Images" that have at least fields:

        HTML_ptr of ObjectPtr type.
        image of Picture type.

So you store for example 3 images into this table,
And each image you link to record in HTML table
Assigning HTML_Ptr = recid of record.

Now you will be able find in db images that are linked to that HTML
document.

> Example of datablob:
> 
> <p class=absbody><b>Background:</b> Approximately half of CLL patients do
> not
> respond to alemtuzumab and others progress after responding to alemtuzumab.
> We
> report ...snipped data... relapse are reported. <b>Results:</b> The chance
> of response was associated with lymph node size (p &lt;0.0001): </p>
> 
> <p class=absbody><img width=350 height=68 id="_x0000_i1025"
> src="file:///G://AAAAA/04/DB/RTF/TABLE/PUBUpdatedTables/TIFs/B001823_1.tif"
> type="image/tiff"></img></p>
> 
> <p class=absbody><br>
> High dose methyl prednisolone (HDMP; 1g/m²/day x5 every 4 weeks; 4 patients)
> or
> CHOP (1) were used to reduce bulky nodes prior to alemtuzumab. 2 of 5 had a
> resolution of lymph nodes with both achieving MRD negative remissions with
> alemtuzumab. ...snipped data... </p>
> 
> <p class=absbody><img width=350 height=68 id="_x0000_i1025"
> src="file:///G://AAAAA/04/DB/RTF/TABLE/PUBUpdatedTables/TIFs/B001823_2.tif"
> type="image/tiff"></img></p>

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------