Inserting Null Value

First question.

Whay would you want to enter a NULL into a field in a database?  NULL means 'undefined' or 'not known'.

What is wrong with an empty string field? Most of the time, NULLS are better avoided and alternatives preferred.

There may be legit reasons for this cause, although I can't think of any at the moment.

Perhaps if you tell us the details of what you are trying to accomplish, we might be able to provide a better solution.

Cheers,
Andrew

Ok. 

In your database, make sure 'Allow Nulls' option is selected. (Might be something else depending on the database - which database are you using).

If you are adding new records and you want a field to contain <NULL>, then you can simply leave it out of your INSERT statement.

If you want to UPDATE an existing record so as to record <NULL> in a field then we'll have to work out something else..

What database are you using again?

Cheers,
Andrew

ah ok.

Its just NULL without the quotes. So you'll need to test to see if the user entered anything before constructing your SQL statement, to avoid adding the quotes.  Assume that your form value has been transferred to the variable: theValue.

If len([TheValue]) > 0 then
   strField2 = "'" & theValue & "'"
Else
   strField2 = "NULL"
End If

strSQL = "INSERT INTO myTable (Field1, Field2, Field3)"
strSQL = strSQL & " VALUES ('" & Value1 & "',"
strSQL = strSQL & strField2
strSQL = strSQL & ",'" & Value3 & "')"
conn.execute (strSQL)

So basically, the quotes are only added to the variable strField2 if a value has been entered into that form field.

Note that you could also just leave that field out using a similar method..

Hope this helps,
Andrew

place this code before conn.execute(strSQL)

response.write strSQL
response.end

and tell us what is sent to the screen in both cases.