PHP MSSQL Money Datatype crash
Posted: Mon Jun 11, 2007 9:16 am
In MSSQL database i have a Money datatype. When i run the a bit of code to insert some data into the database i get the following error:
I did have a problem similiar to this with the date, i resolved it using this bit of code:
if any one is got some code that can help with the MONEY problem will be much apperciated...
Know i have adapted the code to convert but that does not seem to work...Disallowed implicit conversion from data type varchar to data type money, table 'PBSalesRes.dbo.Flights', column 'AdultCost'. Use the CONVERT function to run this query.
I did have a problem similiar to this with the date, i resolved it using this bit of code:
Code: Select all
$csds = str_replace("/","-",$canceldate);
$newcancel = date ("d M Y", strtotime ($csds));