I saw on here that someone has one table with all of his users in it, and then has a query/view for each domain. You could use the same principal and make your SQL query look like: Select Top 30 * From tablename Order by somefield
Normally I wouldn't put the order by in there but since you want to grab the 1st X records in the order they were created. You don't want the last account created to show if it's over X. I hope thats not to confusing. My only question is, will imail not let you create that last user? Or will it, and it just not work? Scott ---------- Original Message ---------------------------------- From: "Samuel J Stanaitis" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 21 Jan 2004 09:05:30 -0500 >What external database are you using? Active Directory? Maybe there's some >sort of limit which can be created on the database itself? > >Sam > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Mike Callahan >Sent: Wednesday, January 21, 2004 7:19 AM >To: [EMAIL PROTECTED] >Subject: [IMail Forum] Controlling number of users per domain > > >Hello, I'm currently running IMail v8.05 using an external database server >for user information. The problem I'm experiencing is that with the >external database IMail no longer recognizes the limit placed on the number >of users as applied to each domain. For instance, if domain.com is limited >to 50 mailboxes the system no longer prevents the addition of mailboxes over >a quantity of 50, so the user can add a 51st, 52nd, and so fourth. I was >told by IPSwitch that this functionality does not work when using an >external user database. So I'm wondering if anyone has found a work-around >for this. It seems very odd to me that this is not a more major issue given >the number of places this information often has to be exported to, i.e. >billing and customer management systems. Any advice would be appreciated. > >Regards, > >Mike > >To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html >List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ >Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > > >To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html >List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ >Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
