Adding a Null

[mdr227]

I am trying to pre-determine a sort order for an insert statement I am using. I create a recordset with a statement such as this:

set rs1=conn.execute("select max(sort) maxsort from tblTest where category = ' & request.form("txtCategory&quot & "'&quot

I think have a variable that I am trying to increment by one to find the new sort order. Something like varsort = rs1("maxsort&quot + 1. The problem is that if there is no match on my select statement I am not able to set the varsort = 1 because the addition won't work when the recordset is empty.

 

[Funka]

if you are getting a NULL returned from your query, you could either just check for that special case, or instead tell SQL to return some value in place of the NULL by using the ISNULL() function,

SELECT ISNULL(Max(sort), 0) as maxsort

this would return 0 in place of a null, which would be the cause of your addition problems.

Another way might might be to just check the value before trying to do any addition on it, such as

Set rs = myConn.Execute(...)
If rs("maxsort&quot = NULL Then
' handle appropriately or use default value
Else
' handle normally
End If


regards,
-f!