| Subject | Re: [firebird-support] Escaping an ampersand in a select |
|---|---|
| Author | H. S. |
| Post date | 2014-07-07T20:30:11Z |
Hi Sent from Yahoo! Mail on Android |
From: russell@... [firebird-support] <firebird-support@yahoogroups.com>;
To: <firebird-support@yahoogroups.com>;
Subject: [firebird-support] Escaping an ampersand in a select
Sent: Mon, Jul 7, 2014 3:54:35 PM
|
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
|