Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

updating blob in mysql

Status
Not open for further replies.

notuserfriendly

Programmer
May 7, 2004
82
SE
Has anybody succeded in doing this. Can update text but when I try with the blobs it doesn't work.
Running (Testing) on a Win XP, MyOBDC 3.51, IIS 5.

the error I get is:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Query-based update failed because the row to update could not be found.



Show = "SELECT date FROM products WHERE id=" & Request.QueryString("id") & " "
rs.Open Show, strConnect, adOpenKeyset, 3
rs("date") = Date & " " & Time
rs.Update

this works, adding blobs to this does not
(rs("blob1") = Image.Binary)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top