[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: back-sql Varchar2 Primary Key Support



King, Leon C wrote:
Hi all,
	
	Is there a way to wrap oracle functions to where clauses passed
into back-sql?  I have a non-numeric primary key value of my users'
table which in some cases is preceeded by a '0'.  None of the data
mapped via the ldap_entries.keyval and my table are being retrieve when
I execute an ldap search.  If I remove the preceeding '0' the values are
retrieved.

Manually edit servers/slapd/back-sql/back-sql.h and #define BACKSQL_ARBITRARY_KEY (it's #undef'd right now). This allows to use arbitrary keys (treated as strings) instead of integers. Note: it's not very well tested, and performances obviously may decrease (lots of mallocs/frees, more demanding comparisons and so).

p.


Ing. Pierangelo Masarati
OpenLDAP Core Team

SysNet s.r.l.
via Dossi, 8 - 27100 Pavia - ITALIA
http://www.sys-net.it
-----------------------------------
Office:  +39 02 23998309
Mobile:  +39 333 4963172
Fax:     +39 0382 476497
Email:   ando@sys-net.it
-----------------------------------