Re: [Zope] storing blob data in SQLServer using ZSQL

2006-06-29 Thread rawsystems 
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" <[EMAIL PROTECTED]>

To: "Satchidanand Haridas" <[EMAIL PROTECTED]>
Cc: 
Sent: Wednesday, June 28, 2006 4:50 PM
Subject: Re: [Zope] storing blob data in SQLServer using ZSQL




- Original Message - 
From: "Dieter Maurer" <[EMAIL PROTECTED]>

To: "Satchidanand Haridas" <[EMAIL PROTECTED]>
Cc: 
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 = 
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 ) 


___
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 )

Re: [Zope] storing blob data in SQLServer using ZSQL

2006-06-28 Thread Jonathan 


- Original Message - 
From: "Dieter Maurer" <[EMAIL PROTECTED]>

To: "Satchidanand Haridas" <[EMAIL PROTECTED]>
Cc: 
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 = 
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 )

Re: [Zope] storing blob data in SQLServer using ZSQL

2006-06-28 Thread Dieter Maurer 
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 = 
>> 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
___
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 )

[Zope] storing blob data in SQLServer using ZSQL

2006-06-27 Thread Satchidanand Haridas 

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 = 
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 )