Page 1 of 1

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 6:06 am
by kamal.oulhadj
Hello,

In my search query I have the following filter:
Title like $ qpDoc_Title

By testing in advanced research, I have the following error:
Unknown Parametric Search Query operator or field `title '.

I do not know where it comes this error?

thanks

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 7:09 am
by John
It looks as if this is a Texis question. Field names are case sensitive, so check your query against the table.

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 9:45 am
by kamal.oulhadj
Hello,

I have the same error when I use "Title like $ qpDoc_Title" and "title like $ qpDoc_Title"




thanks

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 10:48 am
by mark
Try without the space after $

Title like $qpDoc_Title

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 11:14 am
by kamal.oulhadj
I have this query

Doc_Ref = $qpDoc_Ref and
Doc_Lang like $qpDoc_Lang and
Doc_Date>=$qpDoc_DateDebut and Doc_Date<=$qpDoc_DateFin and
( Doc_Title like $qpDoc_Title or Title like $qpDoc_Title ) and
Doc_Type like $qpDoc_Type and
Doc_SubType like $qpDoc_SubType and
Doc_Descriptors like $qpDoc_Descriptors and
Doc_Authors like $qpDoc_Authors and
Doc_ID_Session = $qpDoc_ID_Session and
Doc_ID_Commission =$qpDoc_ID_Commission


Without space after $, and I have always this error.


Thanks

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 11:45 am
by John
Just to confirm, which product are you using, and where is the query?

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 11:58 am
by kamal.oulhadj
Commercial Version 5.01.1258488718 20091117 (i686-intel-winnt-64-32)
Scripts Version: 5.1.86

In Profile Search Settings, section Parametric Search Query ,SQL Query Clause

I use this SQL Query clause :

"Doc_Ref = $qpDoc_Ref and
Doc_Lang like $qpDoc_Lang and
Doc_Date>=$qpDoc_DateDebut and Doc_Date<=$qpDoc_DateFin and
( Doc_Title like $qpDoc_Title or Title like $qpDoc_Title ) and
Doc_Type like $qpDoc_Type and
Doc_SubType like $qpDoc_SubType and
Doc_Descriptors like $qpDoc_Descriptors and
Doc_Authors like $qpDoc_Authors and
Doc_ID_Session = $qpDoc_ID_Session and
Doc_ID_Commission =$qpDoc_ID_Commission "

Thanks

Unknown Parametric Search Query field or operator `Title'

Posted: Tue Mar 30, 2010 3:12 pm
by Kai
What are the data types for each of the Doc_... fields?