Hi again, Firstly the fix for joins worked a treat, however the same issue has now showed itself when I use something like the following: assessments = ads.filter(:elements_pages__element_id => self.pk ).reverse_order(:elements_assessments__offset).all
Which generates the following SQL: SELECT `assessment_id`, `name`, `code`, `created_on` FROM assessments INNER JOIN elements_assessments ON (elements_assessments.`assessment_id` = assessments.`id`) WHERE (elements_pages.`element_id` = 3) ORDER BY `elements_assessments.`offset`` DESC. As you can see in the order by clause, the quoting is incorrect again. Curiously, it is only for the reverse_order, using order gives correct qualified column quoting. So for now I'm using a normal order and reversing it myself, rather than in the query. I'm currently using sequel (0.4.1.3). Christian On 11/11/07, Sharon Rosner <[EMAIL PROTECTED]> wrote: > > > > > quoting is wrong. It seems that sequel sends the > > > qualified table names to be quoted, which results in this: > > > table.`column` being turned into this: `table.`column``. > > Fixed in the trunk now. Please let me know if there are any more > issues. > > best > Sharon > > > > > -- "Every child has many wishes. Some include a wallet, two chicks and a cigar, but that's another story." --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
