in reply to Check out my Recordset

Out of curiosity does it always create SQL with the "SELECT *" in there? If it does, it's pretty much guaranteed to be useless in my shop. We have huge tables and millions of records. Having to grab that extra information would kill us.

Also, why are you using a typeglob (*zipset) instead of a scalar? Is there some benefit that I'm not seeing?

Cheers,
Ovid

New address of my CGI Course.

Replies are listed 'Best First'.
Re: Re: Check out my Recordset
by princepawn (Parson) on Oct 10, 2003 at 04:26 UTC
    1. oh no, you can select whatever fields you want
    2. well, one the first things mentioned in the DBIx::Recordset docs is that you use each part of the typeglob for something different... if you feel like it... you can simply setup a scalar and use Recordset that way with no loss of functionality... the array is used to index in the result set. The hash can have one of two uses, you can access the current record in the result set... or if you called Search() with !HashAsPrimaryKey then the hash is tied to the database and the keys of the hash are used to retrieve records.
    3. DBIx::Recordset::Playground is the new living docs for Recordset.

      Carter's compass: I know I'm on the right track when by deleting something, I'm adding functionality.

[reply]
[d/l]

In Section Meditations