Hi,

How can I save blob data in SQLServer using ZSQLs? I'm using mxODBC. I have a ZSQL that looks something like this:


update
    table_name
set
    blob_data = <dtml-sqlvar "i_blob_data" type="nb">
where
    conditions....
But I get the following error when I run the above ZSQL:

ProgrammingError: ('07002', 0, '[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error', 6108)


Any comments will be much appreciated.

thanks,
Satchit

_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to