|
|
Post by davos1 on Apr 15, 2009 14:15:11 GMT -5
simple question... when reading a blob field from a sqlite .. #row imagefield$() how to display that image (.jpg) stored in that blob field?  |
|
|
|
Post by Brent on Apr 15, 2009 16:18:29 GMT -5
If it's an image, I think your only option is to write it to a file and then refer to it in an IMG tag. ' tempFile$ = whatever.jpg
open ResourcesRoot$+"\"+tempFile$ for binary as #1
print #1, #row imagefield$()
close #1
html "<img src=""/"+tempFile$+""" />" |
|
|
|
Post by Carl Gundel - admin on Apr 15, 2009 17:29:18 GMT -5
That's right. The webserver needs it to be in a file in order to serve it up.
-Carl
|
|
|
|
Post by davos1 on Apr 16, 2009 9:54:08 GMT -5
thanks a lot,
maybe could better if I set the jpgs in independent files to avoid recreating those each time...
|
|
