storing blob data in SQLServer using ZSQL
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
Satchidanand Haridas wrote at 2006-6-27 19:37 -0500:
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)
You cannot use "ZSQL" to put binary (blob) data into the database. You can have some chance when you use base64 encoding -- provided, your data is not too large. -- Dieter
----- Original Message ----- From: "Dieter Maurer" <dieter@handshake.de> To: "Satchidanand Haridas" <sharidas@zeomega.com> Cc: <zope@zope.org> Sent: Wednesday, June 28, 2006 4:10 PM Subject: Re: [Zope] storing blob data in SQLServer using ZSQL
Satchidanand Haridas wrote at 2006-6-27 19:37 -0500:
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)
You cannot use "ZSQL" to put binary (blob) data into the database. You can have some chance when you use base64 encoding -- provided, your data is not too large.
An easy work-around would be to store your blob in the zodb and then store the path/id of the zodb object in your SQL db. Jonathan
Years ago i posted something on this list (gosh, two years ago and i'm still a newbie :) ) http://mail.zope.org/pipermail/zope-db/2004-July/003356.html Google is your friend. hth bobb ----- Original Message ----- From: "Jonathan" <dev101@magma.ca> To: "Satchidanand Haridas" <sharidas@zeomega.com> Cc: <zope@zope.org> Sent: Wednesday, June 28, 2006 4:50 PM Subject: Re: [Zope] storing blob data in SQLServer using ZSQL
----- Original Message ----- From: "Dieter Maurer" <dieter@handshake.de> To: "Satchidanand Haridas" <sharidas@zeomega.com> Cc: <zope@zope.org> Sent: Wednesday, June 28, 2006 4:10 PM Subject: Re: [Zope] storing blob data in SQLServer using ZSQL
Satchidanand Haridas wrote at 2006-6-27 19:37 -0500:
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)
You cannot use "ZSQL" to put binary (blob) data into the database. You can have some chance when you use base64 encoding -- provided, your data is not too large.
An easy work-around would be to store your blob in the zodb and then store the path/id of the zodb object in your SQL db.
Jonathan
_______________________________________________ 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 )
participants (4)
-
Dieter Maurer -
Jonathan -
rawsystems＠gmail.com -
Satchidanand Haridas