Solved

sql and xml syntax issue

Posted on 2003-11-11
7
234 Views
Last Modified: 2010-04-17
In Query Analyzer (MSsql) one enters "<" for less than, however, pasting the query into an xml file for another routine to read is syntactically incorrect. That is, "<" signals a tag to follow and the query bombs. I'm unsure if changing "<" in an xml file to "&lt;" is the workaround. Any suggestions? Thanks.
0
Comment
Question by:cwest1
7 Comments
 
LVL 5

Expert Comment

by:drnick
Comment Utility
this sounds strange, but can you maybe write "LESS THAN" directly?
0
 
LVL 20

Accepted Solution

by:
Venabili earned 125 total points
Comment Utility
For xml < means starting a Tag. Just replace them with  "&lt;". It will fix the things. And when reading at the other side be sure this changed is handled also
0
 

Author Comment

by:cwest1
Comment Utility
Just wait till we're writing and mixing C# and sql procs in SQL Server! That ought casue some problems :)
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 20

Expert Comment

by:Venabili
Comment Utility
cwest1,

Glad I helped.

Can you please explain why B grade? I think I answered you completely... if not - you can ask for clarifications.

See the grading policy here:
http://www.experts-exchange.com/help.jsp#hi73

It's not for the points but for the PAQ value - if it is be then whoever sees the question will think it is not complete answer. But if you have your reasons, I'll be happy to hear them

Venabili
0
 

Author Comment

by:cwest1
Comment Utility
I'm sorry, I wasn't fully aware of the grading paradigm. An "A" is fine.
0
 
LVL 2

Expert Comment

by:Lunchy
Comment Utility
Done, thank you.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

A short article about a problem I had getting the GPS LocationListener working.
This is about my first experience with programming Arduino.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now