Home All Groups Group Topic Archive Search About

select for output columns from table and local file as image.

Author
11 Feb 2006 4:36 AM
hazz
I would like to use a select statement that selects various columns from a
database table but also contains as the output of the select statement an
image datatype which has been set to the value of a bitmap btained from a
local file at location c://
How would I do that?

Thank you.
-hazz

Author
11 Feb 2006 12:01 PM
John Bell
Hi

To display an image you will need to use a machanism on the client and this
is not part of the SQL Server tools.

Reading this may help http://www.aspfaq.com/show.asp?id=2149

John

Show quote
"hazz" <h***@sonic.net> wrote in message
news:uC95aRsLGHA.2696@TK2MSFTNGP14.phx.gbl...
>I would like to use a select statement that selects various columns from a
>database table but also contains as the output of the select statement an
>image datatype which has been set to the value of a bitmap btained from a
>local file at location c://
> How would I do that?
>
> Thank you.
> -hazz
>
Author
11 Feb 2006 6:35 PM
hazz
Thank you for the idea John.

Show quote
"John Bell" <jbellnewspo***@hotmail.com> wrote in message
news:%23JsJfLwLGHA.3856@TK2MSFTNGP12.phx.gbl...
> Hi
>
> To display an image you will need to use a machanism on the client and
> this is not part of the SQL Server tools.
>
> Reading this may help http://www.aspfaq.com/show.asp?id=2149
>
> John
>
> "hazz" <h***@sonic.net> wrote in message
> news:uC95aRsLGHA.2696@TK2MSFTNGP14.phx.gbl...
>>I would like to use a select statement that selects various columns from a
>>database table but also contains as the output of the select statement an
>>image datatype which has been set to the value of a bitmap btained from a
>>local file at location c://
>> How would I do that?
>>
>> Thank you.
>> -hazz
>>
>
>

AddThis Social Bookmark Button