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]
