put the IDENTITY value on the column when restoring a db.
And just to be sure, you are not trying to insert anything in the identity
column?
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Monday, 16 February 2004 4:15 AM
To: CF-Talk
Subject: RE: SQL server question
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[properties]') and OBJECTPROPERTY(id, N'IsUserTable')
= 1)
drop table [dbo].[properties]
GO
CREATE TABLE [dbo].[properties] (
[autoid] [int] IDENTITY (1, 1) NOT NULL ,
[mls_no] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[prop_type] [int] NULL ,
[land_size] [int] NULL ,
[land_size2] [decimal](18, 2) NULL ,
[price] [numeric](19, 4) NULL ,
[price2] [int] NULL ,
[no_beds] [int] NULL ,
[no_baths] [int] NULL ,
[county_id] [int] NULL ,
[zip_code] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[agent_no] [int] NULL ,
[description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[style_id] [int] NULL ,
[year_built] [nvarchar] (50) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[waterfront] [int] NULL ,
[date_time2] [datetime] NULL ,
[upsize_ts] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
-----Original Message-----
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 12:54 PM
To: CF-Talk
Subject: RE: SQL server question
Tim, right click on the table and generate the sql script for it... then
post the script to the list.. I'll take another look.
Mike
_____
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 12:43 PM
To: CF-Talk
Subject: RE: SQL server question
Michael... thanks... all of those things are set as you indicated...
interestingly enough, it works on my development box but now on the
ISP's SQL server... I use crystaltech for hosting
-----Original Message-----
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 12:31 PM
To: CF-Talk
Subject: RE: SQL server question
Tim,
Make sure that the datatype of the column i set to int. In addition,
down in
the column attributes area (assuming you are using enterprise manager)
set
the identity attribute to yes and make sure that the "Identity Seed" and
"Identity Increment" attributes have a value.. usually 1 and 1 by
default.
HTH,
Mike
_____
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 11:23 AM
To: CF-Talk
Subject: SQL server question
I'm getting this error from a form submission (autoid is an integer
column that is set to be the "identity" column)... having only used
access in the past, I'm not sure how to resolve this. I would think the
autoid column would automatically increment because it is set to
"identity" . do you have to insert something into an int/identity column
in sql server? If o what?
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value
NULL into column 'autoid', table sampletest.hometeam.properties'; column
does not allow nulls. INSERT fails.
The error occurred in
D:\Inetpub\century21-todayschoice\admin\add_properties_process.cfm: line
18
16 : INSERT into properties (mls_no)
17 :
18 : VALUES ('#mls_no#')
19 : </cfquery>
20 :
Tim Laureska
1st-String Technologies
443-496-1261
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
