From: bjo-sag@online.no   
      
   "Jim Hargan"  wrote in message   
   news:1g2tyrwgkgooc$.1lfnh6ix2g62b$.dlg@40tude.net...   
   > On Sun, 12 Nov 2006 10:39:31 +0100, Bjorn Sagbakken wrote:   
   >   
   >> Eventually I will use .NET for web-pages,   
   >> so I need to figure out how to store images into the SQL from that side   
   >> also.   
   >   
   > At the risk of showing my ignorance of most of the topics discussed in   
   > this   
   > thread -- are you trying to serve images into web pages? If you are, you   
   > realize that the web page won't contain the bits and bytes of the actual   
   > image, but only the path (URL) to where the image is stored as a jpg, png,   
   > or gif. So maybe you only need to store the images's URLs in your SQL   
   > table, and not the images themselves. All you need to do for the images is   
   > save them as jpegs and load them into a subdirectory on your web site   
   > server, then store the paths to these images in the table.   
      
   What you describe is pretty much how our web-pages work at the time, the   
   images stored in a subdirectory and the SQL tables only the path. However, a   
   few yars ago I designed some ASP pages that presented images that were   
   stored in the SQL table itself. This worked very well, but I could not   
   upload the images through web-pages, but used a VB-application to do that.   
      
   This time I want the SQL-server to serve both the WEB-pages as well as the   
   Paradox application. I can surely go for images saved into subdirectories in   
   both cases, but I have experienced major access problems in the network,   
   because the Anonymous user from the webserver hardly should be given access   
   anywhere else in the network than the local directory on the webserver, and   
   on the other side; other users in the network (Paradox users) would not   
   normally have access to the company's webserver. At the moment I have an   
   experiment going on, where Paradox (with a higher user credential on the   
   network login) is copying files back and forth with an interval of a few   
   minutes. But this is messy workaround I rather would avoid.   
   So-images stored into the table itself is still my prefered idea.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)