How to concatenate 2 fields

[jrheltmach]

Hi All, have a question I hope someone can help me out with. I have a
file from our financial application here at work that creates
invoices. In it, it pulls data from our SQL Server 2000 database and
using XML, creates text file invoices. Question I have is this. One
of our fields is an ID field called Timekeeper. It's a unique 4 digit
number assigned to every person. What I want to do is create a new
field that will take a -0- and add it to the Timekeeper field.
Example: 01710. How can I concatenate 2 fields in XML where one is a
hardcoded value and one is a database field??

Thanks!
jim

[Joseph Kesselman]

jr********@michaelbest.com wrote:

How can I concatenate 2 fields in XML where one is a
hardcoded value and one is a database field??

Using what tools? XML is just a data syntax. You're talking about a
programming task, which means you need to pick a programming language
(Java, C, XSLT stylesheets, XQuery or whatever query language you're
already using to retrieve the information and render it as XML ...)

--
Joe Kesselman / Beware the fury of a patient man. -- John Dryden

[jrheltmach]

On Aug 1, 9:09 am, Joseph Kesselman <[e-mail]>
wrote:

[e-mail] wrote:

How can I concatenate 2 fields in XML where one is a
hardcoded value and one is a database field??

Using what tools? XML is just a data syntax. You're talking about a
programming task, which means you need to pick a programming language
(Java, C, XSLT stylesheets, XQuery or whatever query language you're
already using to retrieve the information and render it as XML ...)

--
Joe Kesselman / Beware the fury of a patient man. -- John Dryden

I guess I'd be using XSLT stylesheets....Sorry about my ignorance with
this, I just thought I could open the file up in text pad and start
keying away....Anyway, below is where I believe it's pulling the
Timekeeper field from my datasource....

</xsl:choose>
<xsl:text>|</xsl:text>
<xsl:value-of select="tk_id"/> <!-- TIMEKEEPER_ID -->
<xsl:text>|</xsl:text>