Re: How to query for LOWER(Column) = 'value'

2010-06-13 Thread Mike Christensen
So something like this? return (new Castle.ActiveRecord.Queries.SimpleQueryUser(FROM User u WHERE LOWER(u.Alias) = ?, a)).Execute().Length != 0; This seems to work, thanks!! Mike On Sat, Jun 12, 2010 at 8:15 PM, Gauthier Segay gauthier.se...@gmail.com wrote: Hi, I don't have an answer for

Re: Querying items in a HasAndBelongToMany relationship

2010-06-13 Thread ubahn
Hi Markus, The problem is that each product can have more than one category and I cannot query 'SELECT p.Category'. Is there something in HQL that can handle such associations ? Mark On Jun 13, 7:30 am, Markus Zywitza markus.zywi...@gmail.com wrote: Why don't you use HQL for that, it is dead

Re: How to query for LOWER(Column) = 'value'

2010-06-13 Thread Tuna Toksoz
If you want, you can implement your own function and the corresponding criteria. Inherit from a dialect and register the function and using SqlFunctionCriteria it is possible. (not sure about the names and the like, because it's been more than 1 year) Tuna Toksöz Eternal sunshine of the open

Re: How to query for LOWER(Column) = 'value'

2010-06-13 Thread Mike Christensen
That's kinda overkill at the moment, but good information to know for the future.. I was just wondering if Castle/NHibernate had a built in way for doing this. Sounds like a HQL expression using SimpleQuery is the best way. I've looked at the SQL it generates and it's fine. On Sun, Jun 13,

Re: Querying items in a HasAndBelongToMany relationship

2010-06-13 Thread Markus Zywitza
http://nhforge.org/doc/nh/en/index.html#queryhql-select select *elements(*p.Categories*)* from Product p where p.Brand = ? -Markus Am 13. Juni 2010 11:04:42 UTC+2 schrieb ubahn markmb...@gmail.com: Hi Markus, The problem is that each product can have more than one category and I cannot

Re: Routing and ARDataBind

2010-06-13 Thread Marc Pickett
Did I not phrase this question correctly, or leave some necessary piece of information out? Anyone? On Fri, Jun 11, 2010 at 12:01 PM, Marc marcpick...@gmail.com wrote: I may be missing something basic here but I can not get the ARDataBind to work with my routes. Here is my setup. I have a

Re: Routing and ARDataBind

2010-06-13 Thread Patrick Steele
Have you checked the FORM data to make sure the study.id is coming through properly? --- Patrick Steele http://weblogs.asp.net/psteele On Sun, Jun 13, 2010 at 7:32 AM, Marc Pickett marcpick...@gmail.com wrote: Did I not phrase this question correctly, or leave some necessary piece of

Re: Querying items in a HasAndBelongToMany relationship

2010-06-13 Thread Mark Borg
Thanks Markus that worked perfectly On Sun, Jun 13, 2010 at 1:10 PM, Markus Zywitza markus.zywi...@gmail.comwrote: http://nhforge.org/doc/nh/en/index.html#queryhql-select select *elements(*p.Categories*)* from Product p where p.Brand = ? -Markus Am 13. Juni 2010 11:04:42 UTC+2 schrieb

Re: IModelInterceptorsSelector question

2010-06-13 Thread Simone Busoli
Great, thanks. I left my comments therehttp://github.com/castleproject/Castle.InversionOfControl/commit/8b08c71e8ccf591027b39a2c5010e72ec5060d58#commitcomment-93441 . 2010/6/12 Krzysztof Koźmic krzysztof.koz...@gmail.com Simone, let me know what you think about this change: