hi guys, ive got a script(below) that updates the listings images and then the channel images and finally deletes the image details from the pictures table..... here is the code...

strFile = request.Querystring("File")

strSQL = "UPDATE tblListings SET "
strSQL = strSQL & "tblListings.Image =xxxxxx "
strSQL = strSQL & "WHERE tblListings.Image =" & strFile & " "
 
 
 'Write to the database
 adoCon.Execute(strSQL)

strSQL = "UPDATE tblChannel SET "
strSQL = strSQL & "tblChannel.Channel_Image=xxxxxx "
strSQL = strSQL & "WHERE tblChannel.Channel_Image = '" & strFile & "';"
       
 'Write to the database
 adoCon.Execute(strSQL)

 'Delete the topic from the database 
 'Initalise the strSQL variable with an SQL statement to get the topic from the database
 strSQL = "DELETE FROM PICTURES WHERE PICTURES.PIC_IMAGE =" & strFile
   
 'Delete the message from the database
 adoCon.Execute(strSQL)

here is the error message im getting