Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: James Stewart
  Where is James Stewart?
 Christchurch
 New Zealand
 James Stewart
 To: Ronald de Jesus
  Where is Ronald de Jesus?
 Los Baños
 Philippines
 Ronald de Jesus
 Tags
Subject: RE: How to upload/download an image to/from mysql?
Thread ID: 35172 Message ID: 55149 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Saturday, November 06, 2004 4:23:33 AM         
   


> > after i retrieve an image from blob field from mysql to vfp, the field will become general in vfp..??
> > how can i retrieve the image from a general field in vfp..??
> >
> > really thx for ur help~!
>
> Yes if you use blob field the field becomes general in vfp. You can save the image to blob field
> but the problem is thers an OLE Error : OLE object is invalid or corrupted in displaying it.
> Maybe others can help us with this.
>
> I'm using Text field instead of blob field:
>
> after select... you can use strtofile() to copy string to image file then display the image file in form.
>
>
> Ronski

Hi

So is this actually saving the image file to the db itself or just a reference to where the image file resides?
Cheers
Jimbo
Have you been foxed today?
I have :-) !

ENTIRE THREAD

How to upload/download an image to/from mysql? Posted by penny tsang @ 1/2/2004 2:58:02 AM
RE: How to upload/download an image to/from mysql? Posted by Ronald de Jesus @ 1/2/2004 3:53:15 AM
RE: How to upload/download an image to/from mysql? Posted by penny tsang @ 1/3/2004 2:27:50 AM
RE: How to upload/download an image to/from mysql? Posted by Ronald de Jesus @ 1/4/2004 3:18:53 AM
RE: How to upload/download an image to/from mysql? Posted by penny tsang @ 1/5/2004 2:56:19 AM
RE: How to upload/download an image to/from mysql? Posted by Boudewijn Lutgerink @ 1/5/2004 8:48:44 AM
RE: How to upload/download an image to/from mysql? Posted by suhas hegde @ 1/5/2004 10:57:41 AM
RE: How to upload/download an image to/from mysql? Posted by James Stewart @ 11/6/2004 4:23:33 AM