MySQL image retrieval Issue

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

MySQL image retrieval Issue

Justin Bartak
I am using the MySQL LOAD_FILE function to upload binary data to a blob field (which is working), however I am having problems displaying the image from the database. Firefox returns the following error " The image "http://xxx.com/xxx.lasso" cannot be displayed, because it contains errors".

I am sure that the image was uploaded correctly since I was able to use 'CocoaMySQL' (http://cocoamysql.sourceforge.net/) to view the image from that field.

Any help would be greatly appreciate.

[content_type:'image/jpeg']
[Inline:-Database='xxx',-Table='xxx','ID'='1']
<img src="[Field:'image', -EncodeNone]" alt="test">
[Abort]
[/Inline]


Lasso: 8.04
MySQL: 4.1.11

Justin Bartak
[hidden email]


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: MySQL image retrieval Issue

Peter D Bethke
Justin,

You need to take a few steps to do image pulls from mysql properly.  
Check out this link here for a technique I use:

http://www.listsearch.com/lassotalk.lasso?id=135725


Peter

On May 27, 2005, at 11:49 AM, Justin Bartak wrote:

> I am using the MySQL LOAD_FILE function to upload binary data to a  
> blob field (which is working), however I am having problems  
> displaying the image from the database. Firefox returns the  
> following error " The image "http://xxx.com/xxx.lasso" cannot be  
> displayed, because it contains errors".
>
> I am sure that the image was uploaded correctly since I was able to  
> use 'CocoaMySQL' (http://cocoamysql.sourceforge.net/) to view the  
> image from that field.
>
> Any help would be greatly appreciate.
>
> [content_type:'image/jpeg']
> [Inline:-Database='xxx',-Table='xxx','ID'='1']
> <img src="[Field:'image', -EncodeNone]" alt="test">
> [Abort]
> [/Inline]
>
>
> Lasso: 8.04
> MySQL: 4.1.11
>
> Justin Bartak
> [hidden email]
>
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription:
> http://www.listsearch.com/lassotalk.lasso?manage
>


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: MySQL image retrieval Issue

Paul Melia
In reply to this post by Justin Bartak
Here another link with a similar solution to Peter's...

http://www.listsearch.com/lassotalk.lasso?id=121627


HTH,
Paul

On May 27, 2005, at 11:56 AM, Peter Bethke wrote:

> Justin,
>
> You need to take a few steps to do image pulls from mysql properly.  
> Check out this link here for a technique I use:
>
> http://www.listsearch.com/lassotalk.lasso?id=135725
>
>
> Peter
>
> On May 27, 2005, at 11:49 AM, Justin Bartak wrote:
>
>
>> I am using the MySQL LOAD_FILE function to upload binary data to a  
>> blob field (which is working), however I am having problems  
>> displaying the image from the database. Firefox returns the  
>> following error " The image "http://xxx.com/xxx.lasso" cannot be  
>> displayed, because it contains errors".
>>
>> I am sure that the image was uploaded correctly since I was able  
>> to use 'CocoaMySQL' (http://cocoamysql.sourceforge.net/) to view  
>> the image from that field.
>>
>> Any help would be greatly appreciate.
>>
>> [content_type:'image/jpeg']
>> [Inline:-Database='xxx',-Table='xxx','ID'='1']
>> <img src="[Field:'image', -EncodeNone]" alt="test">
>> [Abort]
>> [/Inline]
>>
>>
>> Lasso: 8.04
>> MySQL: 4.1.11
>>
>> Justin Bartak
>> [hidden email]
>>
>>
>> --
>> ------------------------------
>> Lasso Support: http://support.omnipilot.com/
>> Search the list archives: http://www.listsearch.com/lassotalk.lasso
>> Manage your list subscription:
>> http://www.listsearch.com/lassotalk.lasso?manage
>>
>>
>
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription: http://www.listsearch.com/ 
> lassotalk.lasso?manage
>


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage