[Building Sakai] melete db column question

[David Haines]

Thanks - Dave

David Haines
CTools Developer
Digital Media Commons
University of Michigan 
dlhaines at umich.edu



On Dec 15, 2010, at 12:43 PM, Mallika M Thoppay wrote:

> 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 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101215/9cb72232/attachment.html