[horde] (no subject)

gmk at gmx.at gmk at gmx.at
Tue Feb 24 01:13:41 PST 2004


Hello all, 

i have problems with ansel and a mssql db backend depended also to
Datatree_sql.

When i create a gallery, the entrys are added to the database, but they
could not be listed due SQL query Syntax errors.

The errors within the getByAttributes function:

x) mssql cannot check text fields with the = operator, this fieldtype forces
the use of the LIKE operator (used in the where clause with the
attribute_value field)
x) mssql cannot convert text fields (used in the where clause with the
attribute_value field)
x) mssql (and also postgres) cannot parse a (field_value & number)
expression because they need a boolean result. So the expression maybe changed to
(field_value & number = number), this results into a boolean

However, a main problem seems the text datatype in mssql tables. How large
is the data stored in the category_attributes.attribute_value field. Is it
possible to use another datatype ?

-- 
kind regards, gernot

GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...)
jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++




More information about the horde mailing list