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]
- SQL Server Question Tangorre, Michael T.
- RE: SQL Server Question Won Lee
- RE: SQL Server Question Tangorre, Michael T.
- RE: SQL Server Question Greg Luce
- RE: SQL Server Question Won Lee
- RE: SQL server question Dave Watts
- RE: SQL server question Robyn Follen
- SQL server question Tim Laureska
- RE: SQL server question Michael T. Tangorre
- RE: SQL server question Tim Laureska
- RE: SQL server question Michael T. Tangorre
- RE: SQL server question Tim Laureska
- RE: SQL server question Taco Fleur
- RE: SQL server question Tim Laureska
- RE: SQL server question Tim Laureska