XML / XSL

Re: XML Web Services publishing

16-Jul-04 19:08

Sounds like you don't have IIS configured for ASMX files. That is ASP.NET right? If so you should try that forum you might get more response in there.

"No matter where you go, there your are." - Buckaroo Banzai

-pete

Javier Lozano16-Jul-04 20:12

Javier Lozano

16-Jul-04 20:12

You need to install ASP.NET on the IIS Server. For that, you will need the .NET Framework runtime installed on the machine. After you install it, go to the following folder in the server:

C:\WINDOWS\Microsoft.NET\Framework\<framework version="">

Then run the following command line tool with params:
aspnet_regiis.exe -i -enable

After tool runs, reboot... Smile | :)

ASP.NET will be properly configured on the server!

Hope this helps!
~javier

"I don't suffer from insanity, I enjoy every minute of it." -- Unknown

Select from View in Access

blankg15-Jul-04 8:53

blankg

15-Jul-04 8:53

Im trying to do the following query on a view in access db:
"SELECT List Totals.Expr1,List Totals.Order ID FROM List Totals"

this is the view definition that i got from the db:
"SELECT Sum([Orders Detail].[Unit Price]*[Orders Detail].[Quantity]) AS Expr1, Orders.[Order ID]\r\nFROM Orders INNER JOIN [Orders Detail] ON Orders.[Order ID] = [Orders Detail].[Order ID]\r\nGROUP BY Orders.[Order ID];\r\n"

and i get syntax error missing operator in query expression List Totals.Expr1

how do i do this right?

Re: Select from View in Access

palbano16-Jul-04 15:56

16-Jul-04 15:56

What does this have to do with XML / XSL ?

I don't know if this is correct but in your posted View Definition SQL statement the schema entity names with spaces are delimited with brackets []. It seems likely that your query would have to do the same right?

On a side note I would recommend not using spaces in schemas.

"No matter where you go, there your are." - Buckaroo Banzai

-pete

Advisory system

DotNet14-Jul-04 21:19

DotNet

14-Jul-04 21:19

To All,

How do I extract the XML value where user has selected, and make comparison.

Q1. Are you using computer for web surfing? (Yes / No)

Q2. Are you going to play games and listening to music? (Yes / No)

Q3. Are you going to watch movies on the computer? (Yes / No)

If Q1 = Yes AND Q2 = Yes AND Q3 = Yes then
( PC - Need modem & speakers & CD-ROM drive )
------------------------------------------------------------------------

Please give me some suggestion?

Thanks....

Aaron

palbano16-Jul-04 15:51

16-Jul-04 15:51

DotNet wrote:
How do I extract the XML

What XML? Confused | :confused:

DotNet wrote:
and make comparison

Confused | :confused:

What are you comparing?

"No matter where you go, there your are." - Buckaroo Banzai

-pete

DotNet16-Jul-04 18:02

DotNet

16-Jul-04 18:02

To give you a better picture, this system is something like Sales Consultancy System which helps to advice or educate the customer to buy the (let's say, personal computer) according a sets of question they have answered. After that, the system will analyse from what the customer have selected and make a comparison on which computer model is likely the suitable one to display out the list of PC specification.

Here is the example:

Q1. What is your budget?
<pulldown -="" user="" to="" select="" the="" range=""> 2000 - 2500 , 2500 - 3000 , 3000 - 4000
"Click Next button"

Q2. Are you using computer for?
<user click="" on="" the="" checkbox="">
()- [games and listening to music]
()- [watch movies]
()- [Web surfing, online chatting]

"Click Next button"

After customer have answered this two questions, a list of PC specification will be listed out. This will show the customer which PC to buy.

palbano16-Jul-04 19:45

16-Jul-04 19:45

It's entirly possible that I am totally dense but I don't beleive we can tell you how to "get the XML value" when you have not provided the XML. Also my exprience tells me we also should know your development platform, operating environment and what specific XML engine you are working with.

"No matter where you go, there your are." - Buckaroo Banzai

-pete

DotNet16-Jul-04 23:42

DotNet

16-Jul-04 23:42

It's just Microsoft Windows platform, using Microsoft Visual Studio.NET 2003, ASP.NET, XML. Below is the coding part, you can amend it.

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

<consult xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<beginnerchoice>
<question>What is your budget?
<answer>2000-2500
<answer>2500-3000
<answer>3000-3500
<answer>3500-4000

<beginnerchoice>
<question>Are you going to watch movies on the computer?
<answer>PC games and listening music
<answer>watch movies
<answer>Web surfing, online chatting

What is your advice?

Regards,
Aaron

palbano17-Jul-04 8:03

DateTime using XPath new one

17-Jul-04 8:03

Well if the use chooses answer number 2 for the first question in the following XML...

<?xml version="1.0" encoding="utf-8" ?>
<consult xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<beginnerchoice>
<question>What is your budget?</question>
<answer>2000-2500</answer>
<answer>2500-3000</answer>
<answer>3000-3500</answer>
<answer>3500-4000</answer>
</beginnerchoice>
<beginnerchoice>
<question>Are you going to watch movies on the computer?</question>
<answer>PC games and listening music</answer>
<answer>watch movies</answer>
<answer>Web surfing, online chatting</answer>
</beginnerchoice>
</consult>

Then the XPath query to extract the value that they choose would be:

//beginnerchoice[1]/answer[2]/text()

Hope that helps

-pete

Anonymous10-Jul-04 5:47

Anonymous

10-Jul-04 5:47

Hi all,
How can we query xml data between two dates by using XPath.
For example:
I have an XML file like this
"<Employees>
<Employee>
<Name>xxxx</Name>
<DateOfJoin>'2000-04-12T10:12:30'</DateOfJoin>
</Employee>
<Employee>
<Name>yyyy</Name>
<DateOfJoin>'2001-04-12T10:12:30'</DateOfJoin>
</Employee>
<Employee>
<Name>zzzz</Name>
<DateOfJoin>'2002-04-12T10:12:30'</DateOfJoin>
</Employee>
<Employee>
<Name>aaaa</Name>
<DateOfJoin>'2003-04-12T10:12:30'</DateOfJoin>
</Employee>
<Employee>
<Name>bbbb</Name>
<DateOfJoin>'2004-04-12T10:12:30'</DateOfJoin>
</Employee>
</Employees>"

Now I want employee names between 2002 and 2003.
Thanks inadvance. Rose | [Rose]

Re: DateTime using XPath new one

gmu0414-Jul-04 5:13

Re: DateTime using XPath new one

14-Jul-04 5:13

Mr/Mrs Anonymous,

According to Microsoft(moc 2663) and www.W3.org(XPath link), only nodes, node, string, bool and number items might return. So if you want to query a date you might use XmlReader or derived class. If you want it with XPath, you should do it like this.

?* If you have better idea or sth better let me know.

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

...
DateTime dt;
string name = "";

XPathExpression expression = navigator.Compile(
"/Employees/Employee/Name | /Employees/Employee/DateOfJoin");

XPathNodeIterator i = navigator.Select(expression);
while(i.MoveNext())
{
if(i.Current.Name == "DateOfJoin")
{
dt = XmlConvert.ToDateTime(i.Current.Value);
if(2002< dt.Year && dt.Year < 2004)
{
//TODO
//tbx_msg.Text += name +"\r\n";
}
}
else
{
name = i.Current.Value;
}

}

Javier Lozano18-Jul-04 17:23

Javier Lozano

18-Jul-04 17:23

Try the following XPath:

<br />
/Employees/Employee[substr(DateOfJoin,0,4) <= 2003 and substr(DateOfJoin,0,4) >= 2002]/Name<br />

If you are using XSLT, it will better to select the Employee node and do with it what you please

<br />
<xsl:apply-templates select="/Employees/Employee[substr(DateOfJoin,0,4) <= 2003 and substr(DateOfJoin,0,4) >= 2002]"/><br />
<br />
<xsl:template match="Employee"><br />
  <!--More Rules--><br />
</xsl:template><br />

~javier lozano
(blog || email)

DateTime using XPath

Anonymous10-Jul-04 5:43

Anonymous

10-Jul-04 5:43

Hi all,
How can we query xml data between two dates by using XPath.
For example:
I have an XML file like this
<employees>
<employee>
<name>xxxx
<dateofjoin>'2000-04-12T10:12:30'

<employee>
<name>yyyy
<dateofjoin>'2001-04-12T10:12:30'

<employee>
<name>zzzz
<dateofjoin>'2002-04-12T10:12:30'

<employee>
<name>aaaa
<dateofjoin>'2003-04-12T10:12:30'

<employee>
<name>bbbb
<dateofjoin>'2004-04-12T10:12:30'

Now I want employee names between 2002 and 2003.
Thanks inadvance. Rose | [Rose]

Merging Xml Docs by priority

Mr. Rogers9-Jul-04 8:52

Mr. Rogers

9-Jul-04 8:52

I have two XmlDocuments. One is default settings for a new user and the other is user specific settings. I want to merge the user specific settings over the default settings while keeping all of the default settings not specified in the user specific document. I've looked at using DataSet merging but it doesn't seem like the right answer. Anyone have any ideas?

syntax coloring of xml document in text box

Rashid_Mehmood8-Jul-04 16:41

Rashid_Mehmood

8-Jul-04 16:41

Dear professionals
How can be syntax coloring applied to an XML document if it is to be loaded in a rich text box for user viewing?

Mr. Rogers9-Jul-04 8:56

Mr. Rogers

9-Jul-04 8:56

If this is just for viewing the XML then just use a IE web browser control. You'll get the sweet IE formatting of XML.

gmu049-Jul-04 21:15

9-Jul-04 21:15

Besides the given answer, you may use this tag.(It is working with IE.)

<iframe src="D:\w3home\www\TestXML\xmlDocs\sam.xml" width="400" height="400" scrolling="auto" frameborder="1"></iframe>

But if you want user to modify xml doc, you should write or find JavaScript code to do it.

Rashid_Mehmood10-Jul-04 15:23

Rashid_Mehmood

10-Jul-04 15:23

Mr.mutlugokhan
Thanks for considering my problem and responding therein. Since the user should be provided to modify the xml doc, I need some javescript to accomplish that(as per your advice). Can you help me with some such code? Or if I can get some code like this, how woul I embed it in my c# code?

gmu0414-Jul-04 4:50

Web services .. authentication .. .asmx on fly

14-Jul-04 4:50

I will examine this project later but it seems to be ok for you.

http://www.codeproject.com/aspnet/TextEditControl.asp

dotnet_cpp6-Jul-04 10:49

dotnet_cpp

6-Jul-04 10:49

Hi,

I just inherited code at my work which creats .asmx file on the fly. To make changes don't need to compile just stop iis make changes to XML file and when iis restart and by invoking web services it generates .asmx file.

My task was to add a method to that web service. I am able to see all my changes in web services ... logic is in store procedures that passed along with the other two required parameters.

I can invoke any other method from the webservice but the one I just created.. I can see the method description their... nothing is different in .asmx .... It asks for the parameters but when I invoke its gives me authentication fail error.

One more thing is... it's using SQLXML .... I m thinking t has to do with some sqlxml rights... but have no idea ... I m struggling from last 2 days... please.. Any help.. Any idea .. any suggestion are appreciated ...

thanks

Re: Web services .. authentication .. .asmx on fly

Javier Lozano16-Jul-04 19:58

Javier Lozano

16-Jul-04 19:58

What's the authentication error you are receiving? Also, could you show me a sample of the code?

Thanks!
~Javier

"I don't suffer from insanity, I enjoy every minute of it." -- Unknown

'doc.SelectSingleNode' problem

gmu046-Jul-04 6:49

Re: 'doc.SelectSingleNode' problem

6-Jul-04 6:49

<employees xmlns="http://www.x.com">
<employee>
<fname>x<lname>y

when i run this line
XmlNode node = doc.SelectSingleNode("/employees/employee[lname='y']/fname");
node obj is null and it made me sick because XPath expr is right..

But, if i clear below part from xml doc, query runs properly.
xmlns="http://www.x.com"

What is wrong?
Any idea..

GMtl

palbano6-Jul-04 7:08

Re: 'doc.SelectSingleNode' problem

6-Jul-04 7:08

Is the XML doc available on a Web site so we can see access it?

"No matter where you go, there your are." - Buckaroo Banzai

-pete

gmu046-Jul-04 7:33