Create hash from MySQL field headers

From: Steve Bertrand (iaccounts_at_ibctech.ca)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 12:19:37 -0400 (EDT)
To: beginners@perl.org

Hi all,

I've been developing a module for our accounting system and am trying
to create a hash with the names equal to the fieldnames of the
database table.

It seems as though 'ListFields' is not functioning, and am wondering
if there is another way.

I simply want to SELECT a single line from the table, have it stored
in a hash, with the name as the fieldname and the value as the actual
data.

Any help would be greatly appreciated, and I am not afraid to go
R'ingAFM if someone could supply decent links.

TIA,

Steve

Relevant Pages

  • Re: Create hash from MySQL field headers
    ... > to create a hash with the names equal to the fieldnames of the ... > database table. ... > It seems as though 'ListFields' is not functioning, ... > in a hash, with the name as the fieldname and the value as the actual ...
    (perl.beginners)
  • Re: Create hash from MySQL field headers
    ... > Steve Bertrand wrote: ... >> I've been developing a module for our accounting system and am ... >> to create a hash with the names equal to the fieldnames of the ...
    (perl.beginners)
  • Re: Newbie - Is this Reasonable?
    ... because this hash is stored in the database. ... So you use PKCS5v2 to generate a key hash from a salt and the user's passphrase, then store the salt and the hash in a database. ... are even more critical in database applications because the payoff from tampering with selected fields may be much higher, fields tend to be fixed-length so it's easier to tamper with them in a meaningful way, and databases lend themselves to off-line analysis, so the attacker can marshall more resources and take more time to attack your system. ... You're using a stream cipher for encryption. ...
    (sci.crypt)
  • Re: looking for help with a counting algorithm
    ... >> subcategory is counted, the code goes back up the tree to the root, adding ... >> involve retrieving all the category memberships from the database, ... sub ReadCategories{ ... ReadCategories is called with two empty hash pointers by any of the ...
    (comp.lang.perl.misc)
  • Re: Secure Password in database
    ... Subject: Secure Password in database ... > in database as SHA hash. ... You don't want to be able to compromise the client, ... get a bunch of garbage back when you try to get the 2-way encrypted data. ...
    (SecProg)