Re: bind_columns() question

From: Hardy Merrill (HMerrill_at_dhcr.state.ny.us)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 08:07:50 -0400
To: <sigzero@gmail.com>,<dbi-users@perl.org>

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

Relevant Pages

  • Re: Bowling Game once more
    ... >Robert C. Martin wrote: ... >> to the score function, and changing the loop in the score function to ... scoring loop I could query that array and set the type of split. ...
    (comp.object)
  • Re: Limit .find to one pass
    ... "Robert H" skrev i meddelelsen ... Dim r As Long ... 'Copy the right-most character to the next column ... Loop Until ActiveCell.Address = startCell.Address ...
    (microsoft.public.excel.programming)
  • Re: dual processors and linux
    ... Robert> In csh in an xterm: ... Your loop is mainly I/O-bound. ... It doesn't occupy the CPU ... system interactive response was a ...
    (comp.os.linux.misc)
  • Re: fixnum, range and array into one single loop?
    ... On 06.05.2007 15:30, Robert Klemme wrote: ... It has a loop just e.g. like this: ... The userinput is the loop count: but now this userinput can be a fixnum like 12 or 36 or it can be a range like 1..10 or 24..84 or an array like and for every 3 different input kinds the loop shall do the same. ... raise ArgumentError, "Don't know what to do with: ...
    (comp.lang.ruby)
  • Re: dual processors and linux
    ... Robert> In csh in an xterm: ... Robert> order, created a new xterm running su, logged in as root, ... Your loop is mainly I/O-bound. ... I had some simulation optimization runs ...
    (comp.os.linux.misc)