I have the same problem before. If the datatype of the field is not number, you will need to single quote it even though you are using place holder.
-----Original Message----- From: Moreno, Javier [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 1:19 PM To: [EMAIL PROTECTED] 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
