- Joined
- Jun 3, 2011
- Messages
- 70
- Reaction score
- 0
hello ragezone
anyone know about this problem
error says
Warning: mssql_query() [function.mssql-query]: message: An explicit value for the identity column in table 'Account' can only be specified when a column list is used and IDENTITY_INSERT is ON. (severity 16) in C:\xampp\htdocs\include\form.php on line 145
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\include\form.php on line 145
7bf6a5111a982b58
REMOVED
and here my line 145 on form.php
mssql_query("INSERT INTO Account VALUES ('$Email', '$UserID', '$Password' , '$UserKey', '0', NULL, NULL, NULL, '$SecretQuestion', '$Answer', '$FirstName', '$MI', '$LastName', '$Birthday', '00:00:00', '$Sex', '$Address', NULL, NULL, '$Country', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$_SERVER[REMOTE_ADDR]', newid(), GETDATE(), 0, NULL, 0, 0, 0, NULL, 0, 1, NULL, 0, 0, NULL, NULL, 0, '$KSCode', 0, '$KSActivation')") or die($KSActivation);
Big Thanks To Anyone who help me and Also ragezone
anyone know about this problem
error says
Warning: mssql_query() [function.mssql-query]: message: An explicit value for the identity column in table 'Account' can only be specified when a column list is used and IDENTITY_INSERT is ON. (severity 16) in C:\xampp\htdocs\include\form.php on line 145
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\include\form.php on line 145
7bf6a5111a982b58
REMOVED
and here my line 145 on form.php
mssql_query("INSERT INTO Account VALUES ('$Email', '$UserID', '$Password' , '$UserKey', '0', NULL, NULL, NULL, '$SecretQuestion', '$Answer', '$FirstName', '$MI', '$LastName', '$Birthday', '00:00:00', '$Sex', '$Address', NULL, NULL, '$Country', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$_SERVER[REMOTE_ADDR]', newid(), GETDATE(), 0, NULL, 0, 0, 0, NULL, 0, 1, NULL, 0, 0, NULL, NULL, 0, '$KSCode', 0, '$KSActivation')") or die($KSActivation);
Big Thanks To Anyone who help me and Also ragezone