X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fproducer%2FPDFPreFormattingProducerNode.java;h=50e69bf27037a145c8e4b764dac0ad0b88d81571;hb=4451d4c8c25d46e9c405e966ff6bd016a1512f4f;hp=261ab65ee7429d0113b82b86eb61a9b4c18f27d7;hpb=462a3b8839a8a841351adae553e9fa7b1f2d219c;p=mir.git

diff --git a/source/mircoders/producer/PDFPreFormattingProducerNode.java b/source/mircoders/producer/PDFPreFormattingProducerNode.java
index 261ab65e..50e69bf2 100755
--- a/source/mircoders/producer/PDFPreFormattingProducerNode.java
+++ b/source/mircoders/producer/PDFPreFormattingProducerNode.java
@@ -35,6 +35,7 @@ import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.Iterator;
 import java.util.Map;
+import java.util.Vector;
 
 import mir.entity.Entity;
 import mir.entity.EntityBrowser;
@@ -103,11 +104,13 @@ public class PDFPreFormattingProducerNode implements ProducerNode {
 
       ArrayList brokenUpContent = new ArrayList();
 
+
+      Vector extraTables = new Vector();
+      extraTables.add("content_x_media cxm");
       Iterator images = new EntityBrowser(
-         // TODO rewrite as relational sql, see also PDF Generator
-         DatabaseImages.getInstance(),
-          "exists (select * from content_x_media where content_id=" + entity.getId() + " and media_id=id)",
-          "id desc", 30, -1, 0);
+        DatabaseImages.getInstance(), "i", extraTables,
+          "cxm.content_id="+entity.getId()+"and cxm.media_id=i.id",
+          "i.id desc", 30, -1, 0);
 
       String theContent = ((EntityContent) entity).getValue("content_data");
       //remove pesky characters