Win 2000 to win 2003 Server switch

[because]

I have 5400 lines of speghetti logic in one page that works in 2000 and does not in 2003.

I have used a series of tools to narrow it down to one statement which is not working.

sqlstr = "Update Sr set LastModifyDt = '" & Date() & "' WHERE SrNum = '" & upl.form("SrNum") & "';"

I am not actually that familiar with ASP as I am a web programmer who uses Ruby and JScript.

Any suggestion or further trouble shooting that I can do?

[mcmcom]

well you could try

sqlstr = "Update Sr set LastModifyDt = '" & System.DateTime.Now().ToString() & "' WHERE SrNum = '" & upl.form("SrNum") & "';"


hth,
mcm