[IronPython] What is .AppendChunk expecting?
vernondcole at gmail.com
Wed Aug 27 19:36:29 PDT 2008
I tried both
both of which work, but then the execution fails with:
File "C:\Program Files\IronPython 2.0
Beta4\lib\site-packages\adodbapi\adodbapi.py", line 675, in _executeHelper
rs = self.cmd.Execute(ra)
EnvironmentError: The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data.
-- on command: "INSERT INTO tblTemp (fldId,fldData) VALUES (?,?)"
-- with parameters: (2, <read-only buffer for 0x000000000000003A, size 4,
0 at 0x000000000000003B>)
which lead me to believe that I'm not giving .AppendChunk() the argument it
I even tried
p.Value = elem
which results in:
StandardError: Exception has been thrown by the target of an invocation.
On Wed, Aug 27, 2008 at 7:40 PM, Curt Hagenlocher <curt at hagenlocher.org>wrote:
> This will probably need to be a string. I don't think we do any automatic
> conversions of buffer objects for CLR or COM calls.
> On Wed, Aug 27, 2008 at 6:28 PM, Vernon Cole <vernondcole at gmail.com>wrote:
>> Dear miracle workers:
>> This may actually be the last failed unittest for adodbapai. Progress
>> has been remarkable.
>> Can you help with one more?
>> Situation: filling in the parameter list for an ADO execute. The second
>> parameter (parameter 1) is a python "buffer" to be loaded into a binary(4)
>> "elem" contains the value of the parameter.
>> "p" is the parameter object.
>> Pywin32 uses p.AppendChunk successfully to pass the buffer to SQL, but
>> Iron objects:
>> <console output>
>> -- Trying parameter 1 = <read-only buffer for 0x000000000000003A, size 4,
>> 0 at 0x000000000000003B>
>> Traceback (most recent call last):
>> File "C:\Program Files\IronPython 2.0
>> pi.py", line 659, in _executeHelper
>> TypeError: Specified cast is not valid.
>> -- on command: "INSERT INTO tblTemp (fldId,fldData) VALUES (?,?)"
>> -- with parameters: (2, <read-only buffer for 0x000000000000003A, size 4,
>> 0 at 0x000000000000003B>)
>> </console output>
>> What coercion should be supplied to make AppendChunk happy to accept the
>> buffer contents without trying to cast it?
>> Vernon Cole
>> Users mailing list
>> Users at lists.ironpython.com
> Users mailing list
> Users at lists.ironpython.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users