Try = 1
On Mon, Sep 22, 2008 at 4:23 PM, burkhard_m
[EMAIL PROTECTED]wrote:
@Eric: thanks the Expression.Sql() restriction works.
Anyhow there must be a way to register the function with NHibernate.
So I tried Ayende Rahien's suggestion but still no success.
I registered the CONTAINS
The answer is still the same:
System.Data.SqlClient.SqlException: Incorrect syntax near '='.
NHibernate: select descriptio0_.Id as Id0_, descriptio0_.Text as
Text0_ from [T_Descriptions] descriptio0_ where
(contains(descriptio0_.Text , @p0)=1 ); @p0 = 'Text*'
On 22 Sep., 15:34, Ayende Rahien
Hm, that is a bug then, with NH.
Please file a JIRA issue for this.
On Mon, Sep 22, 2008 at 5:25 PM, burkhard_m
[EMAIL PROTECTED]wrote:
The answer is still the same:
System.Data.SqlClient.SqlException: Incorrect syntax near '='.
NHibernate: select descriptio0_.Id as Id0_,
Adding a SQLFunction that does not need to be compared to anything?
On Mon, Sep 22, 2008 at 5:30 PM, Ayende Rahien [EMAIL PROTECTED] wrote:
Hm, that is a bug then, with NH.
Please file a JIRA issue for this.
On Mon, Sep 22, 2008 at 5:25 PM, burkhard_m
[EMAIL PROTECTED] wrote:
The
Hi everyone!
I'm currently working on a small merchandise management tool and have
to implement a full-text search for the article descriptions.Our
project is based on NHibernate ActiveRecord as well as MSSQL Server
2005 and we would prefer to use the indexing capability of the SQL
Server
If you don't want to mess with learning the Criteria API for complex
queries, then just use the native SQL option:
http://www.hibernate.org/hib_docs/nhibernate/html/querysql.html
On Sep 19, 11:10 am, burkhard_m [EMAIL PROTECTED]
wrote:
Hi Eric,
Thanks, I read about that kind of solution.