dbQuery with multiple statements How can I get this Sql Server dbQuery to work? The INSERT is completing fine, but I need to get the inserted identity PK and Arc is not picking it up.<arc:set attr="db.query"> insert into table (...) values (...); select SCOPE_IDENTITY();</arc:set><arc:call op="dbQuery" in="db" out="results"> ...Is there a better way to get the identity? (I have to use ArcScript, the upsert connector is not an option)
