asp,SQLServer,Image field. how to update and delete it

asp,SQLServer,Image field. how to update and delete it

am 11.05.2005 11:18:10 von frank

We know that we can use appendchunk() to add new image data to an image
field. The question is how can we delete the data or change the data to new
one?
Thank you !
Frank

Re: asp,SQLServer,Image field. how to update and delete it

am 11.05.2005 13:16:05 von reb01501

frank wrote:
> We know that we can use appendchunk() to add new image data to an
> image field. The question is how can we delete the data or change the
> data to new one?
> Thank you !
> Frank

A simple SQL UPDATE statement should accomplish this. Have you tried it?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: asp,SQLServer,Image field. how to update and delete it

am 11.05.2005 16:33:29 von frank

No idea.
Whould you please give me some more detail example?
thanks

"Bob Barrows [MVP]" дÈëÓʼþ
news:utL6NrhVFHA.584@TK2MSFTNGP15.phx.gbl...
> frank wrote:
> > We know that we can use appendchunk() to add new image data to an
> > image field. The question is how can we delete the data or change the
> > data to new one?
> > Thank you !
> > Frank
>
> A simple SQL UPDATE statement should accomplish this. Have you tried it?
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Re: asp,SQLServer,Image field. how to update and delete it

am 11.05.2005 16:39:06 von reb01501

sql = "update table set imgcol = Null where "
conn.execute sql,,129

Bob Barrows

Frank wrote:
> No idea.
> Whould you please give me some more detail example?
> thanks
>
> "Bob Barrows [MVP]" дÈëÓʼþ
> news:utL6NrhVFHA.584@TK2MSFTNGP15.phx.gbl...
>> frank wrote:
>>> We know that we can use appendchunk() to add new image data to an
>>> image field. The question is how can we delete the data or change
>>> the data to new one?
>>> Thank you !
>>> Frank
>>
>> A simple SQL UPDATE statement should accomplish this. Have you tried
>> it?
>>
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: asp,SQLServer,Image field. how to update and delete it

am 11.05.2005 17:08:28 von frank

Oh my god!
It is so simple! My brain maight be hitted by a big hammer.
Thank you!


"Bob Barrows [MVP]" дÈëÓʼþ
news:eiT1wcjVFHA.3024@TK2MSFTNGP14.phx.gbl...
> sql = "update table set imgcol = Null where "
> conn.execute sql,,129
>
> Bob Barrows
>
> Frank wrote:
> > No idea.
> > Whould you please give me some more detail example?
> > thanks
> >
> > "Bob Barrows [MVP]" дÈëÓʼþ
> > news:utL6NrhVFHA.584@TK2MSFTNGP15.phx.gbl...
> >> frank wrote:
> >>> We know that we can use appendchunk() to add new image data to an
> >>> image field. The question is how can we delete the data or change
> >>> the data to new one?
> >>> Thank you !
> >>> Frank
> >>
> >> A simple SQL UPDATE statement should accomplish this. Have you tried
> >> it?
> >>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>