in reply to Re: (jeffa) Re: DBI and MySQL wild card function?
in thread DBI and MySQL wild card function?

Hello:

Well, I wanted to include 50 columns, Didn't know select * would hurt it. I guess I should just type all 50 column names out? i.e select id, clte, claimno, date, name, city, etc.

Anthony
  • Comment on Re: Re: (jeffa) Re: DBI and MySQL wild card function?

Replies are listed 'Best First'.
Re: Re: Re: (jeffa) Re: DBI and MySQL wild card function?
by diotalevi (Canon) on Oct 02, 2002 at 15:45 UTC

    Yes, you type them out or do something like Re: Re: (jeffa) Re: DBI and MySQL wild card function? where I do a SELECT ..., * but don't care about the order since they values just get stuck into a single hash object. There the trick is to use the statement handle's knowledge of the column names and either do it as a single assignment (hash slice and the preferred method) or if you prefer tedium, iterate over the row.

    __SIG__
    printf "You are here %08x\n", unpack "L!", unpack "P4", pack "L!", B::svref_2object(sub{})->OUTSIDE