ASP Update Command Help!

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Please could somebody give this code a once over ive been staring at it for hours it keeps producing a 80040e14 missing operator in query expression error. Many thanks in advance. 

Code:

if(Session("fldFeatureID") <> "") then Command1__varFeatureID = Session("fldFeatureID") 

if(Session("fldImageStatus") <> "") then Command1__varStatusChangedTo = Session("fldImageStatus") 

if(Now() <> "") then Command1__varDateTime = Now() 

if(Session("MM_Username") <> "") then Command1__varChangedBy = Session("MM_Username") 

set Command1 = Server.CreateObject("ADODB.Command") 
Command1.ActiveConnection = MM_stormv2_STRING 
Command1.CommandText = "INSERT INTO tblImageControlLog (fldFeatureID, fldStatusChangedTo, fldDateTime, fldChangedBy)  VALUES (" + Replace(Command1__varFeatureID, "'", "''") + ", " + Replace(Command1__varStatusChangedTo, "'", "''") + ", " + Replace(Command1__varDateTime, "'", "''") + ", " + Replace(Command1__varChangedBy, "'", "''") + ") " 
Command1.CommandType = 1 
Command1.CommandTimeout = 0 
Command1.Prepared = true 
Command1.Execute() 