|
 |
asp_databases thread: null value using "update"
Message #1 by Rowenaperks@d... on Tue, 23 May 2000 17:25:28
|
|
-----Original Message-----
From: Howard, Brett J. [mailto:brett.howard@t...]
Sent: 23 May 2000 14:29
To: 'rowenaperks@d...'
Subject: asp databases
I would like to know how to input a null value into a field using an
"update" sql statement.
Brett Howard
Message #2 by "Ken Schaefer" <ken.s@a...> on Wed, 24 May 2000 10:11:26 +1000
|
|
UPDATE table1 SET field1 = NULL
Cheers
Ken
----- Original Message -----
From: <Rowenaperks@d...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, May 23, 2000 5:25 PM
Subject: [asp_databases] null value using "update"
> -----Original Message-----
> From: Howard, Brett J. [mailto:brett.howard@t...]
> Sent: 23 May 2000 14:29
> To: 'rowenaperks@d...'
> Subject: asp databases
>
>
>
> I would like to know how to input a null value into a field using an
> "update" sql statement.
>
> Brett Howard
Message #3 by "Ponciano Davila" <ponciano@h...> on Wed, 24 May 2000 09:27:23 -0700
|
|
Update the record and not include the field you like to be null.
----- Original Message -----
From: <Rowenaperks@d...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, May 23, 2000 5:25 PM
Subject: [asp_databases] null value using "update"
> -----Original Message-----
> From: Howard, Brett J. [mailto:brett.howard@t...]
> Sent: 23 May 2000 14:29
> To: 'rowenaperks@d...'
> Subject: asp databases
>
>
>
> I would like to know how to input a null value into a field using an
> "update" sql statement.
>
> Brett Howard
>
Message #4 by Tomm Matthis <matthis@b...> on Wed, 24 May 2000 09:58:20 -0400
|
|
You don't have to... if the column is set to allow NULLS then don't include it
in the Update list of fields...
Tomm
Rowenaperks@d... wrote:
>
> -----Original Message-----
> From: Howard, Brett J. []
> Sent: 23 May 2000 14:29
> To: 'rowenaperks@d...'
> Subject: asp databases
>
> I would like to know how to input a null value into a field using an
> "update" sql statement.
>
> Brett Howard
>
Message #5 by "Jeffrey Ciesla" <JCiesla@o...> on Wed, 24 May 2000 10:22:35 -0400
|
|
What if you have a field that is only sometimes filled in. I am working on
a PO db and when they fill out the PO, they sometimes do not know the
total amount yet, so it is usually left blank. I have my UPDATE statement
updating the database, but it is only sometimes a NULL field. Is there
away
around having them just enter 0 and go back an enter it?
Jeffrey P. Ciesla
Information Technology
Oglebay Norton Company
http://www.oglebaynorton.com
>>> ponciano@h... 05/24/00 12:27PM >>>
Update the record and not include the field you like to be null.
----- Original Message -----
From: <Rowenaperks@d...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, May 23, 2000 5:25 PM
Subject: [asp_databases] null value using "update"
> -----Original Message-----
> From: Howard, Brett J. [mailto:brett.howard@t...]
> Sent: 23 May 2000 14:29
> To: 'rowenaperks@d...'
> Subject: asp databases
>
>
>
> I would like to know how to input a null value into a field using an
> "update" sql statement.
>
> Brett Howard
>
|
|
|
View Cart
