Skip navigation
Currently Being Moderated

I have a problem with a database query. Coldfusion Problem

Dec 17, 2008 7:13 AM

I have a problem with a database query. I have varchar column which when contains a '+' character I get an error in a coldfusion database query, however I do not get this error when I do the query in ms 2005 server.

faultCode:Server.Processing faultString:'Unable to invoke CFC - Error Executing Database Query.' faultDetail:'[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type.'
 
Replies
  • Currently Being Moderated
    Dec 17, 2008 8:49 AM   in reply to nikos101
    Can you post your code?
     
    |
    Mark as:
  • Currently Being Moderated
    Dec 18, 2008 2:05 AM   in reply to nikos101
    do you really have a , (comma) after forwardValue in your query sql?

    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/
     
    |
    Mark as:
  • Currently Being Moderated
    Dec 23, 2008 10:46 AM   in reply to nikos101
    Does it help if you explicitly CAST it as a varchar?

    select dealID, CAST(forwardValue AS varchar) AS fwdValue
    from DEALS LEFT OUTER JOIN PARTIES
    ON PARTIES.PartyID = DEALS.PartyID LEFT OUTER JOIN CURRENCYPAIRS
    ON CURRENCYPAIRS.currencyPairID = DEALS.currencyPairID

    Phil
     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points