bind_columns() question

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

To: dbi-users@perl.org
Date: Tue, 19 Oct 2004 13:36:23 -0400

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

Relevant Pages

  • Re: bind_columns() question
    ... Robert wrote: ... > I then do a loop over the contents but I am only getting the $last and ... > database. ... Ah, never mind. ...
    (perl.dbi.users)
  • Re: RunCommand acCmdRecordsGoToNext
    ... Another thing that may come in handy if that doesn't is to loop through the ... The database I am utilizing this ... increasing intRecordCount on each loop. ... Dim strPassword As String ...
    (microsoft.public.access.forms)
  • Re: an old worn interview question
    ... I suppose Oracle could implement this in a cheesy fashion: ... the size of the graph, ... I doubt hierarchical query loop detection is possible. ...
    (comp.programming)
  • Re: Sql Connection
    ... ..i dont like the code either....again a example of a loop ... making calls to the database .... ... what i did yesterday is just get the parsed data to a temp table on the ... the question is the open connection where the Datareader is used insid ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Converting from Access to SQL2k via Excel- HELP!!!!!
    ... Then create a new query and paste the following into its SQL ... > In your database you'd need to start with a query that ... The function that you pointed me to allows me to concatenate all ... The problem that I have is that I need to put it into a loop ...
    (microsoft.public.access.conversion)