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.
>
>