Re: [htmltmpl] dereferencing issues

[Thomas N. <th...@te...>]

12 aug 2005 kl. 11.10 skrev Thomas Nyman:

> Hi
>
> I've tried studying perldoc pages, the htmps template pages and  
> most things relating to dbi etc.
>
> Despite this I have been unable to understand how to dereference  
> fetchall_arrayref({})
>
> I can dereference fetchall_arrayref()  but not  fetchall_arrayref 
> ( {} ), i.e the arrayref of hash refs.
>
> I would like to query the database using fetchall_arrayref({}), the  
> dereference that and perhaps make changes to some values, put it  
> back into  an arrayref({}) and then dump it to html template.
>
> SO far I'm stumped with the first part..i simply cant dereference  
> the *fg!?*-thing  <grinning> .. anyway, please is there some who  
> can help iterate through arrayref({}) (both key and value).
>
> AN example
>
> I query the database for "Name", "Adress", "Phone", "Fax", "Email"
>
> the $rows = $sth->fetchall_arrayref({});
>
> now i would like to dump my rows into an array and check for  
> certain values etc, for instance lets say the phonenumber is  
> represented as 512445566 in the database, but i want it to display  
> as 512-445566 in the html-template..therefore i would need to  
> access the "Phone" query, check its format, possibly change it,  
> insert the new value in my arrayref of hashrefs.
>
> (on my knees and waiting)
>
> Thomas
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle  
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams *  
> Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/ 
> bsce5sf
> _______________________________________________
> Html-template-users mailing list
> Htm...@li...
> https://lists.sourceforge.net/lists/listinfo/html-template-users
>

Never mind guys .. I finally figured it out :)