PDA

View Full Version : CONVERT using sql + php


xypno
01-08-02, 17:02
Warning: MS SQL message: Disallowed implicit conversion from data type varchar to data type money, table 'test.dbo.test', column 'Yearly Income'. Use the CONVERT function to run this query. (severity 16) in c:\program files\apache group\apache\htdocs\3.php on line 14

How do I use the CONVERT Function and where do I use it?
I have an example of a row of salaries, and during an input in a form

I had input type = text (which im pretty sure is wrong) But even besides that Where would I use and how would I use convert in order to add into the database?

MattR
01-08-02, 17:16
You need to use CONVERT in the SQL query; CONVERT is a MS SQL function.