On 7-7-2014 19:02, Mark Rotteveel [email protected] [firebird-support] wrote: > On 7-7-2014 17:54, [email protected] [firebird-support] wrote: >> I am using Delphi XE6 and Firedac and my query is similar to >> >> SELECT A.NAME, 'HTTP://WWW.XYZ.COM?URN=' || A.URN || '&ACTION=' || >> A.ACTIONFIELD >> FROM MYTABLE >> >> the problem I have is that the returned result doesn't include the >> &ACTION so it looks like HTTP://WWW.XYZ.COM?URN=1234=myaction >> >> I have tried various ways of escaping the & but no joy. >> >> Any ideas? thanks > > It is not Firebird doing the escaping. Executing such a query using for > example Firebird will simply return the ampersand. How are you > displaying/checking the value?
I am not sure what my head is doing, but my hands should have typed Flamerobin... Mark -- Mark Rotteveel
