Mailing List Archive


Back to the month index Back to the list index
Anthony Harris (tony@ntech.com)
Thu, 16 Jan 1997 18:47:40 -0600 (CST) 

From: Anthony Harris <tony@ntech.com>
Message-Id: <199701170047.SAA01889@reliant.ntech.com>
Subject: Re: [mSQL] Finding an empty "slot"
Date: Thu, 16 Jan 1997 18:47:40 -0600 (CST)

> Jonas> elements;
> Jonas> NDF-M-0000
> Jonas> NDF-M-0001
> Jonas> NDF-M-0003
>
> Jonas> how can I make my program determin which memberid it should use
> Jonas> for new members? In the example above, it would use NDF-M-0002
> Jonas> since it's not in use.
>
> If I were coding this, I'd use MsqlPerl. I'd extract all the
> memberids into an array, and loop over the array. I'd split each
> memberid based on the '-' character, and compare the last portion to
> the last portion of the previous element in the array. If they were
> not different by one, I would calculate the desired value, and use it.
> All this is rather trivial if you know Perl, but if not, it can be
> coded with difficulty in other languages.

It can be coded very easily into C or C++ too.

-Tony

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!