>-----Original Message-----
>Thank you for reply -
>So your saying, to check if any values are null and if
>so, then conn.execute "update table set field(s)...=null"
>it sounds good.
>problem is that I have 5 of 25 pages with 20 or more
>values to check.
>would I be doing 20 checks and 20 conn.executes??
>NO
>sounds like array might work better??
>maybe I'll make the users delete and add new record!
>OK - can I conn.execute "table set 'all value fields to
>null (fields 1-20), then load in # values on top"
>ie
>conn.exe"table set fields 1-20=null"
>Then run Sql load
>and then conn.execute(Sql)
>Thank you again
>>-----Original Message-----
>>Good morning from Seoul.
>>Compose sql with clear text /null/, ie,
>>conn.execute "update table1 set field1=null"
>>--
>>Han Pohwan
>>Seoul, Korea, MS Asia MVP
>>> I am having trouble sending Null values thru SQL
Update
>>> I have tried everything including;
>>> varB = TRIM(Request.form("varB"))
>>> ' text value passes properly
>>> varA = Request.form("varA")
>>> ' value passes properly
>>> if varA = "" Then
>>> varA = Null
>>> else
>>> varA = CInt(varA)
>>> end if
>>> ' value converts properly
>>> SQL = "Update Table Set "
>>> SQL = SQL & "varB= '" & varB & "', "
>>> SQL = SQL & "varA= " & varA
>>> SQL = SQL & " WHERE Id=" & (Request.Form("Recid"))
>>> Conn.Execute(SQL)
>>> If the Num Value varA = "any value" then all is fine,
>>> If value becomes Null then error;
>>> "Datatype mismatch in criteria expression"
>>> ON THE Conn.Execute(SQL) LINE
>>> But I need to send it to Access sometimes as a null
>value.
>>> Using;
>>> ADO
>>> oRS.AddNew
>>> varA = .....
>>> oRS.Update
>>> Works fine with Null value, but in SQL it Doesn't
>>> Is there a way I can pass a null value thru SQL
>Update????
>>> Thank you in advance
>>> Matt
>>.
>.
SQL Update - Sending Null values