Author_ID int 9999 limit
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20831
Printed Date: 29 March 2026 at 3:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Author_ID int 9999 limit
Posted By: dfrancis
Subject: Author_ID int 9999 limit
Date Posted: 26 July 2006 at 6:42pm
|
I posted this question at http://new2asp.com - new2asp.com but I thought I would post it here too.
I was wondering of you knew how this worked... according to the table design in wwf, table tblauthor key is an int which is limited to 4 characters. But in looking at (the WWF) forum, he has users in the 20 thousands... I'm confused. I thought it would have been limited to 9999.
Do you know?
int = 4 characters. I'm confused.
 |
Replies:
Posted By: VBScript
Date Posted: 26 July 2006 at 7:21pm
|
The limit is the number of characters so the maximum author id would be 999 followed by 9996 nines. ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: dfrancis
Date Posted: 26 July 2006 at 8:04pm
| whoa... that's allota nines. |
Posted By: WebWiz-Bruce
Date Posted: 26 July 2006 at 8:26pm
|
An Int datatype in SQL Server can handle 2^31-1 which is a massive number, even if I know what it meant!! An interger in VBscript can hold numbers upto 32,000, which is why Long Intergers are used which can hold upto 2147483647. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: dfrancis
Date Posted: 26 July 2006 at 8:34pm
| thanks boRg |
Posted By: dfrancis
Date Posted: 26 July 2006 at 9:37pm
|
Did I just become a "Senior Member?"
I talk too much.
 |