Sending null values in SQL statements

From: James Bowman (james_at_jbassoc.biz)
Date: 05/23/04 

Date: Sat, 22 May 2004 18:36:25 -0700

I am using an authoring program called Authorware to send
student scores to ASP pages which send SQL INSERT and
UPDATE statements to an Access database. Everything
works well as long as I provide a value for each variable
that places a value in one of the Access database
fields. For both the INSERT and UPDATE statements, I
would like to provide "real" values for some fields and
null values for the others. For example, I would like to
INSERT a new record with strings in some fields and null
values in others. Later, an UPDATE statement may place
values in some of the null fields and place no value in
the other null fields.
 
I use two ASP pages: one for INSERT and one for UPDATE.
I would like to use one complete SQL statement in each
ASP page that specifies all fields. Then, I would
provide values for some fields and not others. In my
tests, I'm unable to do this. Is there a workaround?
 
Thanks.
 
Jim Bowman

Relevant Pages

  • Only want to insert a record
    ... I'm trying again to develop my web application locally using IIS and asp ... scripting with a local MS Access database. ... The sql works fine within Access itself. ...
    (microsoft.public.data.ado)
  • Re: Sending null values in SQL statements
    ... > I am using an authoring program called Authorware to send ... > UPDATE statements to an Access database. ... For both the INSERT and UPDATE statements, ... > I use two ASP pages: one for INSERT and one for UPDATE. ...
    (microsoft.public.inetserver.asp.db)
  • RE: Learning SQL Server
    ... How does the site interact with the Access database? ... SQL, i.e. are the SQL statements generated in the ASP and then sent to the ...
    (microsoft.public.inetserver.asp.db)
  • QUERY: Is this possible with ASP & Access?...
    ... I am fairly familiar with using ASP to open an Access database table. ... What I need to know is whether it's possible to open multiple tables ... If possible I don't want to use SQL ...
    (microsoft.public.frontpage.programming)
  • Re: How do you insert a carriage return in Management Studio?
    ... I think I've tried everything - including copying and pasting something with a carriage return in it. ... The field is NTEXT, ... Obviously I know how to use INSERT and UPDATE statements, but sometimes you just quickly want to change a value or two and having to write an insert or update query just to do something this simple is a hassle. ... You could do this easily in SQL 2000 so I don't see why they've opted to remove this possibility in SQL 2005. ...
    (microsoft.public.sqlserver.tools)