Execute SQL vs Execute SQL Array

[Tim Anderson]

I have been using the Execute SQL function with very simple statements for create, update and select for a year or so and enjoying the benefits. But I have one simple question that I am sure those with a ore than basic level of SQL knowledge will be able to answer:

What is the difference between Execute SQL and Execute SQL Array?

Surely if the statement in an Execute SQL command returns more than 1 record and has more than 1 field then the result is a two-dimensional array as described in the Execute SQL Array notes in the ScriptMaster demo file?

Thanks for anyone talking the time to explain the difference.

TIm

[dansmith65]

Execute SQL returns text

Execute SQL Array returns an array

You can read about Array's here: http://groovy.codehaus.org/JN1025-Arrays

[Tim Anderson]

Thanks Dan,

So the 'array' option would be used If I wanted to (and knew how to!) perform further manipulations on the returned data.

Anyone recommend any good learning materials?