Hi, I am a new Yii user and am learning PHP as well. Whenever a user leaves a non-required field blank, and submit a form the following error is thrown: "CDbCommand failed to execute the SQL statement: SQLSTATE[HY104]: [Microsoft][SQL Server Native Client 10.0]Invalid precision value. If all fields are completed, the error is not thrown. Also, I imported data into the database and when I view a record in Yii all the <NULL> fields are showing as "not set" Any assistance with handling MSSQL fields that "allow null" is greatly appreciated. I am not sure what, I am doing wrong here…
Error in executing SQL: INSERT INTO [dbo].[grantees] ([awardno],
[granteeName], [address1], [address2], [city], [state], [zipcode],
[granteeContactFirstName], [granteeContactLastName],
[granteeContactDegree], [granteeContactLicense], [granteeContactPhone],
[granteeContactEmail], [programcode], [projectOfficerFirstName],
[projectOfficerLastName], [projectOfficerPhone]) VALUES (:yp0, :yp1, :yp2,
:yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13,
:yp14, :yp15, :yp16)
in
…\protected\controllers\GranteesController.php
(72)
in …\index.php (15)