Article View: bit.databases.mssql-l
Article #141how can insert image data into my server
From: artmelkon
Date: Sat, 21 Oct 2000 00:00
Date: Sat, 21 Oct 2000 00:00
70 lines
3370 bytes
3370 bytes
This is a multi-part message in MIME format.
------=_NextPart_000_0012_01C03B4A.F661D800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi there,
Need some advise.
I'm using mssql 7.0 and have created an image data type.
Now when I am trying to insert an image, it's fails.
the script that I'm using is:
insert into table_name
(image_column_name)
values
(c:\image.gif)
Am I doing something wrong here?
Thanks
Arthur Melkonyan
www.ifuse.com
e-mail: artygub@hotmail.com
------=_NextPart_000_0012_01C03B4A.F661D800
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi there,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Need some advise.</FONT></DIV>
<DIV><FONT size=3D2>I'm using mssql 7.0 and have created an image data=20
type.</FONT></DIV>
<DIV><FONT size=3D2>Now when I am trying to insert an image, it's=20
fails.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>the script that I'm using is:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT color=3D#ff0000 size=3D2>insert into table_name</FONT></DIV>
<DIV><FONT color=3D#ff0000 size=3D2> =20
(image_column_name)</FONT></DIV>
<DIV><FONT color=3D#ff0000 size=3D2>values</FONT></DIV>
<DIV><FONT color=3D#ff0000 size=3D2> =
(c:\image.gif)</FONT></DIV>
<DIV><FONT color=3D#008080 size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Am I doing something wrong here?</FONT></DIV>
<DIV><FONT size=3D2></FONT><FONT size=3D2></FONT><BR><FONT =
size=3D2>Thanks<BR>Arthur=20
Melkonyan<BR></FONT><A href=3D"http://www.ifuse.com"><FONT=20
size=3D2>www.ifuse.com</FONT></A><BR><FONT size=3D2>e-mail: </FONT><A=20
href=3D"mailto:artygub@hotmail.com"><FONT=20
size=3D2>artygub@hotmail.com</FONT></A></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0012_01C03B4A.F661D800--
Technical Details
Message-ID:
<LtkI5.6176$1S5.573184@newsread1.prod.itd.earthlink.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f816f,370925c24c8fcd47,start X-Google-Attributes: gidf816f,public X-Google-Thread: f6611,370925c24c8fcd47,start X-Google-Attributes: gidf6611,public X-Google-Thread: 104de1,370925c24c8fcd47,start X-Google-Attributes: gid104de1,public From: "artmelkon" <artyagub@hotmail.com> Subject: how can insert image data into my server Date: 2000/10/21 Message-ID: <LtkI5.6176$1S5.573184@newsread1.prod.itd.earthlink.net> X-Deja-AN: 684198177 X-Priority: 3 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0012_01C03B4A.F661D800" X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Complaints-To: abuse@earthlink.net X-Trace: newsread1.prod.itd.earthlink.net 972149739 216.249.72.67 (Sat, 21 Oct 2000 10:35:39 PDT) Organization: EarthLink Inc. -- http://www.EarthLink.net X-MSMail-Priority: Normal MIME-Version: 1.0 NNTP-Posting-Date: Sat, 21 Oct 2000 10:35:39 PDT Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,microsoft.public.sqlserver.misc