Re: Copying Binary data from one table to another

Bob Barrows [MVP] wrote:

dim sql,cmd,arParms
sql="insert into binary_b (copy_a,copy_b,copy_c) values (?,?,?)"
arParms=array(original("org_a"),original("org_b"), _
original("org_c"))
set cmd=createobject("adodb.command")
set cmd.activeconnection = CecExe
cmd.commandtext = sql
cmd.commandtype=1
cmd.execute ,,128

Oops - I hit Send too soon. If this fails, then you are going to need to
explicitly create parameters and probably use GetChunk to get the binary
data from the recordset and AppendChunk to put the binary data into the
binary parameter ... are you sure you don't want to bypass using the
recordset?

Oh! and one more thing. I think in this case you need to be more
explicit:

sql="insert into binary_b (copy_a,copy_b,copy_c) values (?,?,?)"
arParms=array(original("org_a").value, _
original("org_b").value, _
original("org_c").value)

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Access sending data to Word VBA Userform
    ... To get assistance on that, it would be best to ask in an Access newsgroup, ... Doug Robbins - Word MVP ... Dim rs As DAO.Recordset ... ' Set the number of Columns = number of Fields in recordset ...
    (microsoft.public.word.vba.userforms)
  • Re: How To Return Record Number From AddNew
    ... Instead, use SQL DML ... source of a recordset: ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Recordset used in Select/Option pick list
    ... Bob Barrows [MVP] wrote: ... to the list of options generated from your recordset. ... What the getstring is doing is constructing a string from all the ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Multihomed DNS Server Mailserver Webserver Fileserver
    ... Kevin D. Goodknecht posted their thoughts, ... Newsgroup Etiquette: ... Please direct all replies to the newsgroup so all can benefit. ... Ace Fekay, MCSE 2000, MCSE+I, MCSA, MCT, MVP ...
    (microsoft.public.win2000.dns)
  • Re: Multihomed DNS Server Mailserver Webserver Fileserver
    ... Kevin D. Goodknecht posted their thoughts, ... Newsgroup Etiquette: ... Please direct all replies to the newsgroup so all can benefit. ... Ace Fekay, MCSE 2000, MCSE+I, MCSA, MCT, MVP ...
    (microsoft.public.windows.server.dns)
Loading