dqd3690 2013-11-01 14:42
浏览 40

yii mssql无法更新标识列

yii 1.1.13, MS SQL Server 2012

 CREATE TABLE [dbo].[name](
   [id] [int] IDENTITY(1,1) NOT NULL,
   [name] [nvarchar](50) NOT NULL,
   CONSTRAINT [PK_name] PRIMARY KEY CLUSTERED

Model, contoller and CRUD created via gii.

_form.php:

$form=$this->beginWidget('CActiveForm', array('id'=>'name-form',));
echo $form->textField($model,'name',array('size'=>50,'maxlength'=>50));
echo CHtml::submitButton($model->isNewRecord ? 'Create' : 'Save');
$this->endWidget();

When

$model->attributes=$_POST['Name'];
$model->save();

General error: 20018 Cannot update identity column 'id'. [20018] (severity 5)

Temporary solution is: unset($model->id), but it's not clear.

What solution is nice?

  • 写回答

1条回答 默认 最新

  • drlma06060 2013-11-05 06:07
    关注

    Yii make's SQL:

    UPDATE [name] SET [id]=:yp0,
    [name]=:yp1 WHERE [name].[id]=2
    

    My _form.php have not field 'id'. Why yii set

    [id]=:yp0

    ?

    评论

报告相同问题?

悬赏问题

  • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
  • ¥500 火焰左右视图、视差(基于双目相机)
  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?