I think what you are missing is:
my $contacts = $sth->fetchall_arrayref({}); # This needs to return an
arrayref of HASHREFS not ar of ar
my $contact_list = $q->scrolling_list(-name=>'contacts',
-values=>$contacts,
-multiple=>'true');
----- Original Message -----
From: "Zachary Buckholz" <[EMAIL PROTECTED]>
To: "Gary Ashton-Jones" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 8:55 PM
Subject: Re: [cgiapp] help with scrolling_list and htmltmpl from cgiapp
> Thanks Gary -
>
> I tried that too and I get this
> ARRAY(0x83ffc14)
> ARRAY(0x83ffc20)
> ARRAY(0x83fada4)
>
> Any other ideas?
>
> Thanks
> zack
>
> ----- Original Message -----
> From: "Gary Ashton-Jones" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 30, 2002 12:47 AM
> Subject: Re: [cgiapp] help with scrolling_list and htmltmpl from cgiapp
>
>
> > I think this 'values' line should be:
> > -values=>$contacts,
> >
> >
> > Zachary Buckholz wrote:
> > > I have been trying to generate a page based on the code fragment
below.
> > > But
> > > when the page appears I get the scrolling_list on the page, but the
> > > value
> > > inside the list is \@contacts.
> > >
> > > I must be doing something wrong because the docs say I can pass an
array
> > > reference as I am doing.
> > >
> > > Can anyone point out my mistake?
> > >
> > > my $select_contacts_query = "SELECT contact_email
> > > FROM
monitor_contact
> > > WHERE mc_id =
> > > $account_id";
> > > my $sth = $dbh->prepare($select_contacts_query);
> > > $sth->execute();
> > > my $contacts = $sth->fetchall_arrayref();
> > >
> > > my $contact_list = $q->scrolling_list(-name=>'contacts',
> > > -values=>'\@contacts',
> > > -multiple=>'true');
> > >
> > > $tmpl_obj->param(CONTACTS => $contact_list);
> > >
> > > $tmpl_obj->param(ADD_URL=>1);
> > >
> > > return $tmpl_obj->output;
> > >
> > > Thanks
> > >
> > > Zack
> > >
> > > ---------------------------------------------------------------------
> > > Web Archive: http://www.mail-archive.com/[email protected]/
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > Web Archive: http://www.mail-archive.com/[email protected]/
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
> ---------------------------------------------------------------------
> Web Archive: http://www.mail-archive.com/[email protected]/
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
Web Archive: http://www.mail-archive.com/[email protected]/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
