I have a problem with a database query. Coldfusion Problem

Forum|Forum|17 years ago
December 17, 2008
6 replies
1396 views

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

Database access

This topic has been closed for replies.

nikos101Author

Inspiring

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

P

paross1

Participating Frequently

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

N

Newsgroup_User

Inspiring

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

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

nikos101Author

Inspiring

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