尝试将新记录插入数据库时​​遇到问题.我认为问题在于比特字段.当我赋值True时,我得到这个错误：

Failed: Array ( [0] => Array ( [0] => 22018 [sqlstatE] => 22018 [1] 
=> 245 [code] => 245 [2] => [Microsoft][sql Server Native Client 10.0]
[sql Server]Conversion Failed when converting the vArchar value ' 1 ' 
to data tyPE bIT. [message] => [Microsoft][sql Server Native Client 10.0]
[sql Server]Conversion Failed when converting the VARchar value ' 1 ' to 
data type bit. ) )

但如果我把它改成假就行了.我将展示一些我的代码.由于我已将其缩小到此变量,因此我已将其中的大部分缩减：

$active = True;

这是我的插入查询.

$sqlInsert = "INSERT INTO customers(
                customerID,registeredDate,givenName,familyName,email,password,phone,mobile,PRoperty,street,locality,town,area,postalCode,active
            ) 
            VALUES(" .
                $newUser . "," .
                $date . ",' " .
                $given . " ',' " .
                $family . " ',' " .
                $email . " ',' " .
                $pwd . " ',' " .
                $phone . " ',' " .
                $mob . " ',' " .
                $property . " ',' " .
                $street . " ',' " .
                $locality . " ',' " .
                $town . " ',' " .
                $area . " ',' " .
                $postalcode . " ',' " .
                $active . " ')";

$stmtInsert = sqlsrv_query($conn,$sqlInsert);

$sqlInsert = "INSERT INTO customers(customerID,active) 
              VALUES(" . $newUser . "," . $date . ",' " . $given . " ',' " . $family . " ',' " . $email . " ',' " . $pwd . " ',' " . $phone . " ',' " . $mob . " ',' " . $property . " ',' " . $street . " ',' " . $locality . " ',' " . $town . " ',' " . $area . " ',' " . $postalcode . " '," . $active . ")";
$stmtInsert = sqlsrv_query($conn,$sqlInsert);