can you show the model? On Feb 8, 3:24 pm, sunneach <nvd...@gmail.com> wrote: > There are two tables: > > or_organisation (id, name, sector_id, ...) > and > or_sector(id, name, ...) > > And the sector_id is pointing to or_sector.id through the "reusable" > field concept. > > It is all fine when I pull the or_organisation records and then use > method represent to fill in the or_sector.name to display. > > But if we want the MySQL (or any other engine) to get the right > related or_sector.name to > > a) order it via ... ORDER BY or_sector.name DESC and > b) search it via WHERE or_sector.LIKE '%context% > > the DAL 'left' construct does not work because the type of reusable > field is 'string' and not numeric: > > left=or_sector.on(or_sector.id = or_organisation.sector_id) > > What's more, it is having, say, u'|1|' which can be converted to 1 > via specific CAST and TRIM. > > Is there any way to do that for table.on method? > OR how do we pull joins otherwise?
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.