Re: Comparing Two Attributes

2012-07-27 Thread Jenny Blunt
: SELECT * where XXX = '%{SQL-Location-Id}' } } Is this possible? On 26 Jul 2012, at 12:41, Jenny Blunt wrote: How do I go about comparing two attributes from an update request? I have the following in my default conf. file: update request { SQL-Location := %{sql: SELECT xxx

Re: Comparing Two Attributes

2012-07-27 Thread Alan DeKok
Jenny Blunt wrote: On a similar note, If I wanted to use the first result in the second update request, how can I go about that? I've tried the following, but I get a blank value for SQL-Location-Id update request { SQL-Location := %{sql: SELECT xxx} } update request {

Re: Comparing Two Attributes

2012-07-27 Thread Phil Mayers
On 27/07/12 14:12, Jenny Blunt wrote: On a similar note, If I wanted to use the first result in the second update request, how can I go about that? I've tried the following, but I get a blank value for SQL-Location-Id Yes, because it's not set. update request { SQL-Location :=

Re: Comparing Two Attributes

2012-07-27 Thread Jenny Blunt
Thanks, my mistake - copied from wrong place. On 27 Jul 2012, at 14:27, Alan DeKok wrote: Jenny Blunt wrote: On a similar note, If I wanted to use the first result in the second update request, how can I go about that? I've tried the following, but I get a blank value for SQL-Location-Id

Comparing Two Attributes

2012-07-26 Thread Jenny Blunt
How do I go about comparing two attributes from an update request?I have the following in my default conf. file:update request { SQL-Location := "%{sql: SELECT xxx}"} update request { SQL-Location-Id := "%{sql: SELECT yyy }"}if (SQL-Location != SQL-Location-Id ) { rej

Re: Comparing Two Attributes

2012-07-26 Thread Phil Mayers
On 26/07/12 12:41, Jenny Blunt wrote: How do I go about comparing two attributes from an update request? I have the following in my default conf. file: update request { SQL-Location := %{sql: SELECT xxx} } update request { SQL-Location-Id := %{sql: SELECT yyy } } if (SQL

Re: Comparing Two Attributes

2012-07-26 Thread Jenny Blunt
Mucho graciasOn Jul 26, 2012, at 01:01 PM, Phil Mayers p.may...@imperial.ac.uk wrote:On 26/07/12 12:41, Jenny Blunt wrote: How do I go about comparing two attributes from an update request? I have the following in my default conf. file: update request { SQL-Location := "%{sql: SELEC