2. ASPRunnerPro General questions
  3. SQL Server Image data type not showing
This topic is locked

SQL Server Image data type not showing

 		2/17/2006 4:04:32 PM
ASPRunnerPro General questions
F
 funklet author

Hi,
I cannot get the data type image to show as a picture from SQL Server 2000.
I am sure when I was testing I had it displaying but that was a while ago now and I cannot get it to show now.
All that displays is the 1010 file gif.
I have the image in a query in a detail table with everything else working fine.
I can't seem to work it out.....
Admin 2/20/2006

Hi,
please ensure that you set Database Image in View as and Edit as dropdown boxes on Formatting Tab.
F
 		funklet author 3/18/2006

Hi,

please ensure that you set Database Image in View as and Edit as dropdown boxes on Formatting Tab.


Turns out this was not an ASPRunner problem. The image was stored in the SQL Server Database as a vector image which is just a long string of text to describe the image.
The image is now exported to a PNG which I have shown using HTML in ASPRunner.
Thank you for your assistance.