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
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/ASP/applications/Tv_guide/sample/tv/admin/Pic_delete.asp, line 23
ive spent hours on this code and can't see whats wrong can anyone help me with this problem...
thanx in advanced