I have a problem with a database query. Coldfusion Problem

[nikos101]

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.'

[JR__Bob__Dobbs-qSBHQ2]

Can you post your code?

[nikos101]

Basically its a simple query

[nikos101]

Basically its a simple query

[nikos101]

sorry please ignore the above posts :(

The query is:

select dealID, forwardValue
from DEALS LEFT OUTER JOIN PARTIES
ON PARTIES.PartyID = DEALS.PartyID LEFT OUTER JOIN CURRENCYPAIRS
ON CURRENCYPAIRS.currencyPairID = DEALS.currencyPairID

the forwardValue column is the problem

[Newsgroup_User]

do you really have a , (comma) after forwardValue in your query sql?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[nikos101]

no sorry it was a typo in my pasting of code in this editor,please ignore

[paross1]

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