Solved

sql and xml syntax issue

Posted on 2003-11-11
7
236 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
ID: 9729116
this sounds strange, but can you maybe write "LESS THAN" directly?
0
 
LVL 20

Accepted Solution

by:
Venabili earned 125 total points
ID: 9731664
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
ID: 9731762
Just wait till we're writing and mixing C# and sql procs in SQL Server! That ought casue some problems :)
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 20

Expert Comment

by:Venabili
ID: 9731798
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
ID: 9756727
I'm sorry, I wasn't fully aware of the grading paradigm. An "A" is fine.
0
 
LVL 2

Expert Comment

by:Lunchy
ID: 9756777
Done, thank you.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle query help 18 111
recursion example 16 124
SUM 2 INTEGER ARRAYS INTO 1 10 100
Apps blocked by Java 9 79
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
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 …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

805 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