RE: How to perform JOINs with DBI

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 11:23:43 -0600
To: "Moreno, Javier" <JavierMoreno@eaton.com>, <dbi-users@perl.org>

Javier,

This is not a DBI issue. What does the query do in SQL*Plus? Is the relationship between the tables mandatory, or should you be using an outer or inner join? 

--
Ron Reidy
Sr, DBA
Array BioPharma, Inc.
-----Original Message-----
From:	Moreno, Javier [mailto:JavierMoreno@eaton.com]
Sent:	Fri 7/23/2004 11:19 AM
To:	dbi-users@perl.org
Cc:	
Subject:	How to perform JOINs with DBI
Hi all,
I am having issues trying to do the following:
SELECT I.idIssue, I.Description, I.idEntry, I.idStatus, E.Description, E.CreateDate, E.idPriority, E.idSeverity, E.idUser, E.DueDate FROM MASTER_Issue I, MASTER_Entry E WHERE I.idIssue = ? AND I.idEntry = E.idEntry
The query runs fine but I get no information back from it. What could be wrong? I ran the same query (replacing the placeholder with the value) on the database and it ran fine and returned information.
Regards,
Javier Moreno
----------------
 <<ole0.bmp>> 
Systems Engineer - Transmissions
"When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth" - Sherlock Holmes
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Relevant Pages

  • RE: Problem retrieving Number Data (Oracle)
    ... Why not look at the internal representation of the data using Devel::Peek to look at the data fetched from the query. ... That shows Oracle telling DBD::Oracle the field is a NUMBER ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: How to perform JOINs with DBI
    ... How to perform JOINs with DBI ... What does the query do in SQL*Plus? ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • Re: Order by statement stopped working but not in all cases
    ... If what you say is true and none of you SW (Perl, DBI, DBD, Oracle) has ... by statement in the query, it again returned results though not sorted. ... The apps have not been changed in the past week. ...
    (perl.dbi.users)
  • RE: binding multiple values and retain blanks
    ... Join this table to the main table in your query. ... When i do like above, trailing spaces are lost, as DBI treats default ... So i have to bind one value at a time and specify type as CHAR in order ...
    (perl.dbi.users)
  • Re: Error on DBI
    ... DBI never falsely reports errors. ... Copy and paste the SQL statement from rpt_preview.plx into an SQL query tool, and use the username and password from rpt_preview.plx to login. ...
    (perl.dbi.users)