Re: bind_columns() question

From: Robert (catcher_at_linuxmail.org)
Date: 10/21/04


To: dbi-users@perl.org
Date: Thu, 21 Oct 2004 09:09:13 -0400


"Hardy Merrill" <HMerrill@dhcr.state.ny.us> wrote in message
news:s1776e76.059@smtp.dhcr.state.ny.us...
> So what did the problem turn out to be?
>
> >>> Robert <sigzero@gmail.com> 10/20/04 11:23PM >>>
> Robert wrote:
> > My select looks like this:
> >
> > SELECT surname, first_name, msf810.email_address,
> msf810.employee_id
> > FROM msf810, msf020, MSF829
> > WHERE msf810.employee_id = msf020.employee_id
> > AND msf810.employee_id = msf829.employee_id
> > AND msf020.dstrct_code = 'ATTU' AND physical_loc = '05'
> > AND global_profile != 'JRADMIN'
> >
> > My bind_columns looks like this:
> >
> > $sth->bind_columns( \$last, \$first, \$email, \$userid );
> >
> > I then do a loop over the contents but I am only getting the $last
> and
> > $first to print and not the other columns that are bound.
> >
> > I am using Perl 5.8.4 from ActiveState on Windows using Oracle 9i as
> the
> > database.
> >
> > Robert
> >
> >
> Ah, never mind. I got it.
>
> Robert

Me. :-)



Relevant Pages

  • Re: OOP/OOD Philosophy
    ... >From where I sit, as an observer to this conversation, Robert made his ... It is not only quite possible for a change in the database to crash ... No one said that you would isolate the change in the persistence layer. ...
    (comp.object)
  • Re: Breaking into a running app?
    ... Great idea, Robert! ... then, if a user reports problems, I can go back and look at ... creating a installation package may solve your ... > database... ...
    (microsoft.public.vb.general.discussion)
  • Re: Connecting to a database
    ... Robert, Visual Basic is fundamentally different to Access. ... program to the actual database management program, MS Jet. ... Your database is a Jet database, ...
    (microsoft.public.access.formscoding)
  • Re: IE will not open or DL Office ".doc" files, but will ".rtf" fi
    ... positive I do not understand fully database driven content, ... "Robert Aldwinckle" wrote: ... >> the settings you mention...can you give me an idea how or information where I ... >>> could prevent even a download. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: update multiple columns
    ... > Build your update query dynamically by querying the ... >> I'm cleaning up a database where i have one table that shouldn't have ... Hi Robert, ... I have some trouble with my sql skills. ...
    (microsoft.public.sqlserver.programming)