[Zope] storing blob data in SQLServer using ZSQL

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

Re: [Zope] ExtFile Extention Mappings

[Satchidanand Haridas]

Hi,
Have you had a look at the Config.py file? I believe you can change the 
settings there so that the Zope filenames are preserved including the 
extensions. More specifically, I am referring to the following section 
in Config.py:


# repository file extension handling
ZOPEID = 0  # use ZOPEID (even if it doesn't include an 
extension)
MIMETYPE_APPEND = 1 # append extension to ZOPEID according to mimetype
MIMETYPE_REPLACE = 2# remove extension from ZOPEID, then append mime 
extension

REPOSITORY_EXTENSIONS = MIMETYPE_REPLACE

Thanks.
Satchit
Edward Pollard wrote:
In our quest to replace the not-quite-working External File product, 
we're looking at ExtFile. However, when I upload files into an 
ExtFile, file extensions on the file system are being changed. 
test1.txt becomes test1.ksh, test2.doc becomes test2.dot. They have 
the correct ID's in the ZMI, but on the file system they now have 
something quite new.

Our solution relies on accessing via the ZMI and the file system at 
the same time, so the name being changed is somewhat inconvenient in 
its unpredictability (and I think Apaches mime types will get nicely 
screwed if we start bypassing Zope to get at them). I've done some 
poking at the source code but don't see why ExtFile is doing this or 
what logic it uses.

I bet someone out there knows.
---
Edward J. Pollard, B.Sc
Webmaster, University of Lethbridge
Ext. 1828
___
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 )