27 Jul
2012
27 Jul
'12
9:33 a.m.
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"?