Avoid foreach() with Active Record?

[eluser]stevefink[/eluser]
Hi all,

Is there any possibility for avoiding a foreach() construct when using Active Record type queries? For instance, I'm trying to receive just a single row/value from a table which can simply be assigned to a scaler, so using a foreach construct to get the results seems a bit overkill.

Thanks .... as usual. :-)

- sf