have a look at encoding on your xml. ms word produces those ghey little double quotes that are in the ISO character set and not utf-8, which i've had trouble with before. just an idea, may be something completely unrelated. G
On 5/12/06, <cfgroupie> <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---