Re: Setting an image datatype to NULL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roger Withnell (rogerREMOVE_at_THISFIRSTupperbridge.co.uk)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 15:03:44 +0000 (UTC)

I'm using AspUpload to upload two images at the same time. Don't see how I
can do that with an UPDATE, so I'm stuck with updating a record set.

Any other ideas appreciated.

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OfQCdyNlEHA.3372@TK2MSFTNGP09.phx.gbl...
> Use an UPDATE statement, then you don't have to worry about how the word
> "null" is misinterpreted in the various layers.
>
> conn.execute "UPDATE tbl SET imageCOLUMN = NULL [...where...]", , 129
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Roger Withnell" <rogerREMOVE@THISFIRSTupperbridge.co.uk> wrote in message
> news:chipc3$4v5$1@titan.btinternet.com...
>> I'm updating a record by opening a recordset, setting the fields and the
>> updating it with objRS.Update.
>>
>> I need to set an image datatype to NULL. objRS("field") = NULL works
>> for
>> datatypes int and varchar but not for datatype image, although there is
>> no
>> error - the image field still contains the image!
>>
>> I'm using SQL server and running an UPDATE statement including image =
> NULL
>> works.
>>
>> Any help would be much appreciated.
>>
>>
>
>

Relevant Pages

  • Re: Download website
    ... jumpstart on updating the text and images. ... you can't really download the site files anyway. ... use a "download helper" like HTTrack, ...
    (microsoft.public.vb.general.discussion)
  • Re: Megami 69
    ... them, there are almost always some nice images, and I'm glad you've made them available. ... interesting for me to watch or at least note for that bloody webpage I'm soon going to need someone to help me to do more updating. ... Still halfway through updating the Grenadier entry and have to pick up from there. ... Dave Watson, Severed Heads Liberation Front ...
    (rec.arts.anime.misc)
  • where to place htm file and its images
    ... All the images for xmas2005.htm are stored in xmas2005_files_folder. ... put xmas2005.htm in the image folder as well or do I keep it seperate (one ... updating as a link is added). ...
    (microsoft.public.frontpage)
  • Re: Setting an image datatype to NULL
    ... I can run different SQL statements depending on whether new images are ... >> I'm using AspUpload to upload two images at the same time. ... >> can do that with an UPDATE, so I'm stuck with updating a record set. ...
    (microsoft.public.inetserver.asp.general)
  • Re: New Records printing on odd pages - Word 2000
    ... Possibly you need to do this repeatedly, because if updating ... > Well I've tried the coding again seperately and it all worked fine. ... > on what page the MOD function gets stuck on. ... > letter it then represents the proper page number but the MOD function has ...
    (microsoft.public.word.docmanagement)