absolutely... gotta pad with zeros for place... even better maybe add a
alpha as the first character so leading zeros don't get dropped by
someone or something along the way... so it will require a little
planning to define an appropriate namespace of number size. I suppose
it could always be changed(expanded) later with a little scripting
dave
Emmanuel Lecharny wrote:
This sounds a good idea, but be aware that again, this is a String
comparizon, not a numeric one.
Something like :
(&(00067>minRangeBoundary)(00067<=maxRangeBoundary))
would work, I think (assuming that you store IDs between 0 and 999 999)
Emmanuel
On 3/16/07, *Dave Bennett* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
wrote:
What if you set a minRangeBoundary and maxRangeBoundary attribute for
all of the objects you were searching?
then you could do something like this...
(&(67>minRangeBoundary)(67<=maxRangeBoundary))
dave
Emmanuel Lecharny wrote:
> Hmmm... Sorry, I didn't understood your need.
>
> I *think* that you can't do that in ldap, natively (but I may be
wrong
> ...).
>
> Another way to handle such a feature might be to create one
entry with
> all those characteristics for this range, and to add a referral
to it
> within each product. Then you will be able to get the
characteristic
> of a product X, but you will loose the product ID (of course, X is
> within the range for this characteristic. This is far from being
> perfect, but a Ldap server is not really a RDBMS...
>
> Do you really care of the data storage size ? I mean, if you
have one
> million entries, this is not a big deal, unless they change very
often.
>
> Sorry, but I don't see any 'magic bullet' solution for your problem.
> Someone else, maybe ?
>
> Emmanuel
>
> On 3/16/07, *qazmlp* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>> wrote:
>
> What you have suggested is just a way of searching for a range.
> What I require is to store a range in the LDAP and search
whether
> a given
> number is within any entry having the range.
>
> For example, if there are 100 products with exactly same
> characteristics(colour, size, weight etc.), apart from their
'Id',
> then it
> would be better to store a single LDAP entry with all the
> characteristics
> and make the DN as a range (Id=1-100). It saves a lot of space.
> Also, when I search for an Id=67, the above-mentioned LDAP entry
> should
> get matched. Is such a requirement/handling possible with
the LDAP?
>
> ---
> You are currently subscribed to [email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>> as: [
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>]
> To unsubscribe send email to [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> with the word UNSUBSCRIBE as the
> SUBJECT of the message.
>
>
>
>
> --
> Cordialement,
> Emmanuel Lécharny
> www.iktek.com <http://www.iktek.com> <http://www.iktek.com> ---
You are currently subscribed
> to [email protected] <mailto:[email protected]> as: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>] To unsubscribe send email to
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> with the
word UNSUBSCRIBE as the SUBJECT of the
> message.
---
You are currently subscribed to [email protected]
<mailto:[email protected]> as: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>]
To unsubscribe send email to [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> with the word UNSUBSCRIBE as the
SUBJECT of the message.
--
Cordialement,
Emmanuel Lécharny
www.iktek.com <http://www.iktek.com> --- You are currently subscribed
to [email protected] as: [EMAIL PROTECTED] To unsubscribe send email to
[EMAIL PROTECTED] with the word UNSUBSCRIBE as the SUBJECT of the
message.
---
You are currently subscribed to [email protected] as: [EMAIL PROTECTED]
To unsubscribe send email to [EMAIL PROTECTED] with the word UNSUBSCRIBE as the
SUBJECT of the message.