displaying blob fields

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

displaying blob fields

Author

Message

PeterJ

Posts: 90

Posted: 09/08/2007, 4:25 AM

This is new to me. How do I display the results from a table in a grid? What settings are required?

Thank you anyone who can assist me.

Wkempees

Posted: 09/08/2007, 12:25 PM

What is the content of your blob?

In Forms and grids it is type Memo, useful only of not containing binary
data. Use field text/textarea type Memo

Walter

PeterJ

Posts: 90

Posted: 09/08/2007, 12:45 PM

Hello Walter

It is actually a "sketch" from a PDA which is part of a form gather ing data to deliver to a MySQL DB so I have assumed that the image will be stored in a blob field, naively I must admit!

Peter

wkempees

Posted: 09/10/2007, 4:59 AM

So this sketch is stored in a Blob, not a big problem.
What image type would that have been?
You can store (gif, jpg and the lot) in a blob and properly display it.
Important is to know what the original image type is/was.
A few image types can be recognized from the binary data itself, but knowing
up front is best.
The way to display imagedata from blob field is through an external .php
file.
That file retreives the row from the daabase, loads the data from the blob
field and 'streams' it back to the caller (your form) adding the appropraite
header to the data.
If this is what you try to achive, report back image type and i will post
example.
I think it is in the forum already, try search for "blob" "image blob"

Walter

PeterJ

Posts: 90

Posted: 09/11/2007, 6:35 AM

Hello Walter

Thank you for the response. The original format is BMP.

Peter

DonP

Posted: 09/12/2007, 10:31 AM

Unfortunately, the lossless BMP image format is not a Web-compatible image
type. Only JPG (JPEG) and GIF are supported in all browsers and PNG is
supported in many newer ones. I created a form for uploading images that
lets me upload BMP but it converts on-the-fly to JPG before inserting into
the BLOB.

Your script for displaying the images would need no HTML and have only a
Before Show event to get the BLOB contents, add headers to it, then output
the results as an image. You call it from your other grid as though it were
an image itself.

DonP

"PeterJ" <PeterJ@forum.codecharge> wrote in message
news:546e2868eb28a8@news.codecharge.com...
> This is new to me. How do I display the results from a table in a grid?
> What
> settings are required?
>
> Thank you anyone who can assist me.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

klwillis

Posts: 428

Posted: 09/12/2007, 1:07 PM

Sounds nice DonP.

Care sharing your script (BMP->JPG) converter?

Quote DonP:
Unfortunately, the lossless BMP image format is not a Web-compatible image
type. Only JPG (JPEG) and GIF are supported in all browsers and PNG is
supported in many newer ones. I created a form for uploading images that
lets me upload BMP but it converts on-the-fly to JPG before inserting into
the BLOB.

Your script for displaying the images would need no HTML and have only a
Before Show event to get the BLOB contents, add headers to it, then output
the results as an image. You call it from your other grid as though it were
an image itself.

DonP

"PeterJ" <PeterJ@forum.codecharge> wrote in message
news:546e2868eb28a8@news.codecharge.com...
> This is new to me. How do I display the results from a table in a grid?
> What
> settings are required?
>
> Thank you anyone who can assist me.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"

Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login