"select A.Id from TbFeedItem A Where A.FeedLibid='711' and lower(A.Url)='http://feeds.feedburner.com/~r/alternativemedicineandmeditationnewsweblog/~3/12843564/meditation-balancing-act.html' and lower(A.Title)='meditation: a balancing act : hindustantimes.com'"

what is wrong with query, some time this query works fine for other records and fails for some. Why?

Thanks in Advance.
KT

Hey Guys ,
what is wrong with this query?

select A.Id from DomainManager.BusinessObjects.TbFeedItem A Where A.FeedLibid=301 and A.Url='http://archderm.ama-assn.org/cgi/content/short/142/7/927?rss=1' and A.Title='CORRESPONDENCE: A Randomized, Placebo-Controlled, Double-blind Trial Comparing Narrowband UV-B Plus 0.1% Tacrolimus Ointment With Narrowband UV-B Plus Placebo in the Treatment of Generalized Vitiligo'

I get this error:
The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)

in function at ib bold below :

public static object GetConstantValue( string typeName, string fieldName )
{
System.Type clazz = System.Type.GetType( typeName, false );

if( clazz == null ) return null;

try
{
return clazz.GetField( fieldName ).GetValue( null );
}
catch( Exception )
{
return null;
}
}

===========================================
other query:
Not all named parameters have been set: [] [select A.Id from TbFeedItem A Where A.FeedLibid=968 and A.Url='http://www.biomedcentral.com/1471-2482/6/6' and A.Title='Minimally invasive ''step-up approach'' versus maximal necrosectomy in patients with acute necrotising pancreatitis (PANTER trial): design and rationale of a randomised controlled multicenter trial [ISRCTN38327949]']

I get the above error at this function (line below in bold):
protected void VerifyParameters()
{
if ( actualNamedParameters.Count != namedParameters.Count + namedParameterLists.Count )
{
Set missingParams = new ListSet( actualNamedParameters );
missingParams.RemoveAll( namedParameterLists.Keys );
missingParams.RemoveAll( namedParameters.Keys );
throw new QueryException( "Not all named parameters have been set: " + CollectionPrinter.ToString( missingParams ), QueryString );
}

if ( positionalParameterCount != values.Count )
{
throw new QueryException( string.Format( "Not all positional parameters have been set. Expected {0}, set {1}", positionalParameterCount, values.Count ),
QueryString );
}

for ( int i = 0; i < values.Count; i++ )
{
if ( values[i] == UNSET_PARAMETER || types[i] == UNSET_TYPE )
{
throw new QueryException( string.Format( "Not all positional parameters have been set. Found unset parameter at position {0}", i),
QueryString );
}
}
}

NHibernate uses a simple parser which easily gets confused if you embed literal values in the query. Use parameters instead.