[Building Sakai] melete db column question

[Mallika M Thoppay]

David,

That should be sufficient. The users column stores a list of user ids. I 
will add a jira issue so we change this in our Oracle scripts too.

Thanks,
Mallika

David Haines wrote:
>
> Hi,
>
> We are upgrading melete with our upcoming release.  We've added the 
> melete_special_access table.  The type of the USER column was 
> translated as LONG but the following query fails since a LIKE doesn't 
> work on a LONG field in Oracle.  We plan to use varchar2(4000) 
> instead.  Is there any reason to think that 4000 characters won't be 
> sufficient? 
>
>   String sql = "select a.module_id,a.start_date,a.end_date from 
> melete_special_access a,melete_course_mod
>      ule c where a.users like ? and a.module_id=c.module_id and 
> c.course_id = ?";
>
>
> Thanks - Dave
>
>
>
> David Haines
> CTools Developer
> Digital Media Commons
> University of Michigan 
> dlhaines at umich.edu <mailto:dlhaines at umich.edu>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"


-- 
Mallika M Thoppay
Learning Systems Developer
Etudes Inc
http://etudes.org