Copying Binary Data between tables - Type Mismatch

• • Reply

  13 years ago

  by nesren

  nesreen fawzy

  , Egypt

  Joined 13 years ago

  Hi,
  
  I have these tables with binary data stored in tinyblobs and blobs in MySql. In my application I sometimes need to copy them to another table. Not all the data, maybe just a column or two. So I first select the data into a record set and then loop and insert it (its the only way can do it)
  
  Eg:
  Select blah blah
  
  Do while not rs.eof
  insert here
  rs.movenext
  loop
  
  I thought this would be easy, but its not. No matter what I do I get:
  Error Type:
  Microsoft VBScript runtime (0x800A000D)
  Type mismatch
  
  I suppose copying binary data is not easy. So just how do I do this? Whats the right way to copy Binary Data from one table to another.
  
  Most of you might have done this before. The problem is with the binary stuff. Thats the thing that causes the error. Please can you help.
  
  Thanx
  

  Report abuse