🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: bit.databases.mssql-l
Article #141

how can insert image data into my server

#141
From: artmelkon
Date: Sat, 21 Oct 2000 00:00
70 lines
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>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT size=3D2>the script that I'm using is:</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#ff0000 size=3D2>insert into table_name</FONT></DIV>
<DIV><FONT color=3D#ff0000 size=3D2>&nbsp;&nbsp;&nbsp;=20
(image_column_name)</FONT></DIV>
<DIV><FONT color=3D#ff0000 size=3D2>values</FONT></DIV>
<DIV><FONT color=3D#ff0000 size=3D2>&nbsp;&nbsp;&nbsp; =
(c:\image.gif)</FONT></DIV>
<DIV><FONT color=3D#008080 size=3D2></FONT>&nbsp;</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>&nbsp;</DIV>
<DIV>&nbsp;</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-mail

Show 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