Hi guys,
Not sure how to explain this. So I'll try to make this as simple as
possible for me. I have a web service that is called and we pass a
query to it. Now in that web service query we have descriptions. Now
here is the issue;
If the description has funny characters such as (I think ascii
characters) it will fail the webservice from sending over the data. I
notice this inparticular when you copy and paste from either MS Word or
from the web.
Below is a snapshot of the error. I believe this is an issue with web
services and the way it reads and writes the xml but I'm unsure. Anyone
have an issue like this. I might just add that when I save it to the
database directly it works perfectly....
Here is the fault returned when invoking the web service operation:
AxisFault
faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.tagext.sql.QueryTag$DatabaseQueryException : Error
Executing Database Query.][java.sql.SQLException :
[Macromedia][SQLServer JDBC Driver][SQLServer]Unclosed quotation mark
before the character string '<SPAN id=Contentinclude1>Top Shelf
Opportunity for a .Net Guru!<BR><BR>Dont miss this rare permanent
opportunity to join a leading international consulting organisation. As
a Senior Analyst Programmer/Team Lead in the Enabling Technologies
Delivery Centre, your key responsibilities will be as a Microsoft
Technology Specialist and Technical M...]
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.tagext.sql.QueryTag$DatabaseQueryException : Error
Executing Database Query.][java.sql.SQLException :
[Macromedia][SQLServer JDBC Driver][S...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
