No, the 4 refers to 4 bytes required to store the value, not the number of characters
in the value. The range that can be stored in an int is -2^31 to 2^31-1.
Craig
> -----Original Message-----
> From: ibtoad [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 12:32 PM
> To: CF-Talk
> Subject: RE: OT SQL Server (OK 1 More ?)
>
> OK I got it. Now that I have the primary key set with datatype int, the
> length is limited to 4. Is this correct and will this limit the table to
> 9999 records?
>
> Thanks,
> Rich
>
> -----Original Message-----
> From: Craig Bowes [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 11:30 AM
> To: CF-Talk
> Subject: RE: OT SQL Server
>
>
> You must set a field to be identity and not null. You can set its seed to
> any number (start autonumbering at 1000 for example.)
>
> -----Original Message-----
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 9:37 AM
> To: CF-Talk
> Subject: OT SQL Server
>
> I have a simple question. How do you set the primary key field to
> autonumber in SQL server? I have always used Access where this is a choice
> but don't see how to do it with SQL Server 2000.
>
> Thanks,
> Rich
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
