Comparing Two Attributes

[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 {
>        SQL-Location-Id := "%{sql: SELECT * where XXX =
> '%{SQL-Location-Id}' }"
> }
> 
> 
> Is this possible?

  Of course.  It works.  There's no magic.

  Read the debug log to see what's going on.  And post the REAL
configuration lines you're using.  Re-typing them means typos &&
mistakes, which makes it impossible to help you.

  i.e. your second line updates SQL-Location-Id by referencing
SQL-Location-Id.  That looks wrong.

  Alan DeKok.