Click here to Skip to main content
15,914,500 members
Home / Discussions / XML / XSL
   

XML / XSL

 
AnswerRe: Is this legal, barely? Pin
Michael A. Barnhart7-Dec-04 11:46
Michael A. Barnhart7-Dec-04 11:46 
AnswerRe: retrive the XML Data? Pin
DavidNohejl30-Nov-04 2:03
DavidNohejl30-Nov-04 2:03 
Questionretrive the XML Data? Pin
sudheerreddy30-Nov-04 1:51
sudheerreddy30-Nov-04 1:51 
GeneralTree View with text as nodes..help please Pin
help_cplus25-Nov-04 0:22
help_cplus25-Nov-04 0:22 
GeneralRe: Tree View with text as nodes..help please Pin
help_cplus25-Nov-04 0:25
help_cplus25-Nov-04 0:25 
GeneralXML Web Service Pin
Rofida Refat23-Nov-04 20:33
sussRofida Refat23-Nov-04 20:33 
GeneralXSLT with Dataset.SaveXML Pin
PeterNilsJohnson23-Nov-04 2:58
PeterNilsJohnson23-Nov-04 2:58 
GeneralSQLXML Issue Pin
Anonymous22-Nov-04 19:24
Anonymous22-Nov-04 19:24 
Hi there.

I have an SQL XML template residing on a web server which takes a parameter (japanese characters) and calls a stored proc.

If I hard code the japanese parameter into the XML file, I can execute the stored proc and have records returned.

However, the XML template is called from an ASP page, also on the web server, using the ("Msxml2.ServerXMLHTTP.4.0") object. I call the template using the following code:


-------------------------------------------------------------------------
Set SearchObj = Server.CreateObject("Msxml2.ServerXMLHTTP.4.0")

templateURL = "http://localhost/xmldir/xmltemplate/global_search.xml"

Param = "?PRIM_NAME=" & JAPANESE_NAME

SearchObj.open "GET", templateURL & Param, False

SearchObj.send
-------------------------------------------------------------------------

Variable 'JAPANESE_NAME' is a company name in japanese (ie. double byte).

Every other instance of double byte characters are handled fine by my ASP and XML, however it is only when I am trying to send some double byte characters as arguments to this template that it fails.

I have also tried passing the japanese data to the XML template manually via a URL call....but it also fails.

My XML template looks like this:

----------------------------------------------------------

<root xmlns:sql="urn:schemas-microsoft-com:xml-sql" sql:xsl="global_search.xsl">

<sql:header>
<sql:param name="PRIM_NAME">


<sql:query>

exec my_stored_proc @PRIM_NAME




----------------------------------------------------------

I can run the stored proc through query analyzer and give it some japanese characters as arguments and it works fine.

Can SQL XML templates handle double byte data passed as a parameter or does it have to be hard coded in the file?

Any help would be appreciated
GeneralXSL with Javascript issue when using XslTransform. Pin
Bart-Man22-Nov-04 8:24
Bart-Man22-Nov-04 8:24 
GeneralRe: XSL with Javascript issue when using XslTransform. Pin
DavidNohejl22-Nov-04 8:44
DavidNohejl22-Nov-04 8:44 
GeneralRe: XSL with Javascript issue when using XslTransform. Pin
Bart-Man22-Nov-04 9:00
Bart-Man22-Nov-04 9:00 
GeneralRe: XSL with Javascript issue when using XslTransform. Pin
DavidNohejl22-Nov-04 9:36
DavidNohejl22-Nov-04 9:36 
GeneralRe: XSL with Javascript issue when using XslTransform. Pin
Bart-Man22-Nov-04 10:12
Bart-Man22-Nov-04 10:12 
GeneralRe: XSL with Javascript issue when using XslTransform. Pin
Philip Fitzsimons30-Nov-04 2:54
Philip Fitzsimons30-Nov-04 2:54 
GeneralRe: XSL with Javascript issue when using XslTransform. Pin
Philip Fitzsimons30-Nov-04 2:53
Philip Fitzsimons30-Nov-04 2:53 
GeneralRe: XSL with Javascript issue when using XslTransform. Pin
DavidNohejl30-Nov-04 4:00
DavidNohejl30-Nov-04 4:00 
QuestionHow to add attributes to element? Please help Pin
manivannan.p20-Nov-04 7:08
manivannan.p20-Nov-04 7:08 
AnswerRe: How to add attributes to element? Please help Pin
Ajit K24-Nov-04 3:50
Ajit K24-Nov-04 3:50 
GeneralEditing XML in a user friendly manner Pin
profoundwhispers18-Nov-04 7:13
profoundwhispers18-Nov-04 7:13 
GeneralValidating xml against schema using System.Xml in unmanagedC++ Pin
Murlai16-Nov-04 3:47
Murlai16-Nov-04 3:47 
GeneralRe: Validating xml against schema using System.Xml in unmanagedC++ Pin
DavidNohejl16-Nov-04 4:21
DavidNohejl16-Nov-04 4:21 
GeneralRe: Validating xml against schema using System.Xml in unmanagedC++ Pin
Murlai16-Nov-04 19:31
Murlai16-Nov-04 19:31 
GeneralRe: Validating xml against schema using System.Xml in unmanagedC++ Pin
DavidNohejl16-Nov-04 22:56
DavidNohejl16-Nov-04 22:56 
Generalinitial xml template with xmldatadocument Pin
Raduenzel12-Nov-04 3:37
Raduenzel12-Nov-04 3:37 
GeneralHosting xml editor in WinForm application Pin
Member 151042610-Nov-04 14:20
Member 151042610-Nov-04 14:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.