Error while inserting values to database
Posted: Tue Oct 05, 2010 9:59 am
Hi,
I have created a page which will take ask for certain details and those details will be added to the database(MS SQL SERVER 2008).
But when I press submit the following error code is displayed
00sadfsfad23sdfasdfasdfasd1Error in executing query.
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 8114
I have created a page which will take ask for certain details and those details will be added to the database(MS SQL SERVER 2008).
But when I press submit the following error code is displayed
00sadfsfad23sdfasdfasdfasd1Error in executing query.
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 8114
Code: Select all
=> 8114 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type varchar to numeric. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type varchar to numeric. ) )
it says that there is some error while converting varchar to numeric.All values are taken with a textbox and the values i have given is correct.Please find a solution for this
Thanks in advance
Faiz