Comparing Two Attributes

[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 := "%{sql: SELECT xxx}"
>   }
>
> update request {
>         SQL-Location-Id := "%{sql: SELECT * where XXX =
> '%{SQL-Location-Id}' }"
> }

Read that carefully again; is this really what you mean? Don't you want 
"SQL-Location" in there, not "SQL-Location-Id"?