Re: Stumped again

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Bob wrote:

UPDATE e
SET xmlEmail.modify('insert <br>{sql:column("t.txtTitle")}</br> into (/email/body/p)[1]')

I couldn't quite get your tags right ( I've used <br></br> instead of <br/> ) but hopefully the technique will work for you?

That can be fixed by using

SET xmlEmail.modify(
'insert (<br/>,text{sql:column("t.txtTitle")}) into (/email/body/p)[1]')

to construct a br element plus a text node.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
.

Relevant Pages

  • Re: A motion profile problem or Mathcad sucks. Will some other CAS
    ... Bob, ... I like your scripts and technique. ... you can do with Maxima and it is free. ...
    (sci.math.symbolic)
  • Re: Help with adjusting front derailleur (triple)
    ... Bob in CT wrote: ... Should I just use this technique, or is there an easier way to do this? ... cog but can also result in chain rub in small ring, ...
    (rec.bicycles.tech)
  • Chicken Chasing??????????????????????
    ... is a technique to, but you just automatically pick it up without any ... showed me how to bob and weave and I was only able to do it so so. ... weave underneath this string that was tied accross the gym and within ...
    (rec.sport.boxing)
  • Re: Nadal vs Federer, attributes on clay
    ... bob wrote: ... ...technique, consistency, point construction, endurance. ... if you look at most FO champs of past 17 yrs, where does technique come into play? ...
    (rec.sport.tennis)
  • Re: request.params advice
    ... using the querystring, cookies, session,context. ... technique is best for your application. ... "Bob H" wrote in message ...
    (microsoft.public.dotnet.framework.aspnet)