Hi there,
Please could someone help me out with this problem I am experiencing :
I seem to getting this error when I got to upate data in a database via a form : Type mismatch Cint and it occurs spcecifically on the following piece of code (the line it specifically referrs to is the first line...)
sql10 = "UPDATE Anuncios SET CodPais=" & co & ",CodProvincia=" & pr & ",CodCP=" & fcp & ",Poblacion='" & fpob & _
"',Opcion='" & op & "',Tipo=" & ti & ",Precio='" & fpre & "',Moneda='" & fmon & "',Habitaciones=" & fhab & ",Superficie=" & fsup & _
",Banyos=" & fban & ",Aseos=" & fase & ",Antiguedad=" & fan & ",SuperficieHab='" & fshab & "',Garaje=" & fgar & ",Ascensor=" & fasc & _
",Trastero=" & ftra & ",Calefacción=" & fcal & ",Aire=" & fair & ",Amueblado=" & famu & ",Terraza=" & fter & ", Cocina=" & fcoc & ",Piscina=" & fpis & ",Chimenea=" & fchi & _
",CodIdiomaA='" & fida & "',DescripcionA='" & fdea & "',CodIdiomaB='" & fidb & "',DescripcionB='" & fdeb & "',RutaImagen1='" & fimg1 & _
"',RutaImagen2='" & fimg2 & "',RutaImagen3='" & fimg3 & "' WHERE ID=" & CInt(idanun)
To explain a little this code is on a form page where a client may update the information in a database via this form. If I simply update textboxes radio check boxes, this updates fine. It is when i go to update an uploaded image, which all works fine, I can go to the upload page, and it all uploads fine, and displays in the page fine, it is just when i hit accept to update the information in the database, it then hits the error. Like I say ONLY when an image has been updated.
These are the variables relating to the image location info :
RutaImagen1='" & fimg1 & _ "',RutaImagen2='" & fimg2 & "',RutaImagen3='" & fimg3 &
I would be ever so grateful for ANY help you can offer me on this... its driving me maddd!!
Thanks
