I had problems inserting large memo fields in VFP via ODBC I solved the problem bybreaking the memo into smaller chunks (120 bytes) and doing an insert of the first chunk and then "update VFPTable set memo_field=memo_field+next_chunk where key_field=key_var" for each of the remaining chunks. __________________________________________________________________ Jim Sanford . Database/Web Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Nucleus. All You NEED in an RTOS. Royalty Free. __________________________________________________________________ ----- Original Message ----- From: Carlos Neves <cneves@ruido-visual.pt> To: <zope@zope.org> Sent: Friday, April 14, 2000 5:29 AM Subject: [Zope] Using blobs with sql Hi... I'm trying to insert binary images in a table on an SQL Server, but I don't seem to be able to pass the image through sql insert. Is there some special way I can quote such an object in orther to avoid errors? Errors raised are such as: Traceback (innermost last): File F:\Portal\lib\python\ZPublisher\Publish.py, line 165, in publish File F:\Portal\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: update) File F:\Portal\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: update) File F:\Portal\lib\python\OFS\DTMLMethod.py, line 150, in __call__ (Object: update) File F:\Portal\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: update) File F:\Portal\lib\python\OFS\DTMLMethod.py, line 146, in __call__ (Object: update_sub) File F:\Portal\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: update_sub) File F:\Portal\lib\python\DocumentTemplate\DT_In.py, line 691, in renderwob (Object: Articles) File F:\Portal\lib\python\DocumentTemplate\DT_Util.py, line 335, in eval (Object: sqlInsertArticle(theme=Topic,number=Number, date=Today,summary=Summary,article=Article,image=Image)) (Info: Topic) File , line 0, in ? File F:\Portal\lib\python\Shared\DC\ZRDB\DA.py, line 430, in __call__ (Object: sqlInsertArticle) File F:\Portal\lib\python\Products\ZODBCDA\db.py, line 186, in query sql.error: ('37000', 105, "[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quote before the character string '\377\330\377\340'.") I have tried all I could remember... Thanx in advance -- Carlos Neves cneves@ruido-visual.pt _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )