Re: Comparing Two Attributes

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.