From e70f14a76b41db651fd4618299f046fa715397fe Mon Sep 17 00:00:00 2001
From: rk <rk>
Date: Tue, 5 Feb 2002 21:50:14 +0000
Subject: [PATCH] media_id -> to_media

---
 .../mircoders/storage/DatabaseContentToMedia.java  | 24 +++++++++++-----------
 1 file changed, 12 insertions(+), 12 deletions(-)

diff --git a/source/mircoders/storage/DatabaseContentToMedia.java b/source/mircoders/storage/DatabaseContentToMedia.java
index 3e5db784..2f85cd28 100755
--- a/source/mircoders/storage/DatabaseContentToMedia.java
+++ b/source/mircoders/storage/DatabaseContentToMedia.java
@@ -39,7 +39,7 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
     this.hasTimestamp = false;
     this.theTable="content_x_media";
   }
-  
+
   /**
    * get all the media-files belonging to a content entity
    *
@@ -51,7 +51,7 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
       // get all to_topic from media_x_topic
       String id = content.getId();
       //this is not supported by mysql
-      String subselect = "id in (select media_id from " + theTable + " where content_id=" + id+")";
+      String subselect = "id in (select to_media from " + theTable + " where content_id=" + id+")";
 
       try {
         returnList = DatabaseMedia.getInstance().selectByWhereClause(subselect,-1);
@@ -62,7 +62,7 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
     }
     return returnList;
   }
-  
+
   /**
    * get all the images belonging to a content entity
    *
@@ -121,7 +121,7 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
     }
     //first delete all row with content_id=contentId
     String sql = "delete from "+ theTable +" where content_id=" + contentId;
-  
+
     Connection con=null;Statement stmt=null;
     try {
       con = getPooledCon();
@@ -134,7 +134,7 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
     } finally {
       freeConnection(con,stmt);
     }
-  
+
     //now insert
     //first delete all row with content_id=contentId
     for (int i=0;i<mediaId.length;i++) {
@@ -159,10 +159,10 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
     if (contentId == null && mediaId == null) {
       return;
     }
-    
+
     Connection con=null;Statement stmt=null;
     //now insert
-    
+
     String sql = "insert into "+ theTable +" (content_id,media_id) values ("
           + contentId + "," + mediaId + ")";
     try {
@@ -178,7 +178,7 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
       freeConnection(con,stmt);
     }
   }
-  
+
   public void setMedia(String contentId, String mediaId)
     throws StorageObjectException {
     if (contentId == null && mediaId == null) {
@@ -268,7 +268,7 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
       freeConnection(con,stmt);
     }
   }
-  
+
   public void delete(String contentId, String mediaId)
     throws StorageObjectException {
     if (mediaId == null || contentId==null) {
@@ -331,15 +331,15 @@ public class DatabaseContentToMedia extends Database implements StorageObject{
     }
     return returnList;
   }
-  
+
 /**
  * Returns a EntityList with all content-objects having a relation to a media
  */
-  
+
 public EntityList getContent()
     throws StorageObjectException {
     EntityList returnList=null;
-    
+
     String select = "select distinct content_id from " + theTable;
     // execute select statement
     Connection con=null;Statement stmt=null;
-- 
2.11.0