Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    7

    Unanswered: CONVERT using sql + php

    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?

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    You need to use CONVERT in the SQL query; CONVERT is a MS SQL function.
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •