Unknown Parametric Search Query field or operator `Title'

Post Reply
kamal.oulhadj
Posts: 15
Joined: Mon Mar 01, 2010 7:53 am

Unknown Parametric Search Query field or operator `Title'

Post 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
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Unknown Parametric Search Query field or operator `Title'

Post by John »

It looks as if this is a Texis question. Field names are case sensitive, so check your query against the table.
John Turnbull
Thunderstone Software
kamal.oulhadj
Posts: 15
Joined: Mon Mar 01, 2010 7:53 am

Unknown Parametric Search Query field or operator `Title'

Post by kamal.oulhadj »

Hello,

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




thanks
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Unknown Parametric Search Query field or operator `Title'

Post by mark »

Try without the space after $

Title like $qpDoc_Title
kamal.oulhadj
Posts: 15
Joined: Mon Mar 01, 2010 7:53 am

Unknown Parametric Search Query field or operator `Title'

Post 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
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Unknown Parametric Search Query field or operator `Title'

Post by John »

Just to confirm, which product are you using, and where is the query?
John Turnbull
Thunderstone Software
kamal.oulhadj
Posts: 15
Joined: Mon Mar 01, 2010 7:53 am

Unknown Parametric Search Query field or operator `Title'

Post 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
User avatar
Kai
Site Admin
Posts: 1271
Joined: Tue Apr 25, 2000 1:27 pm

Unknown Parametric Search Query field or operator `Title'

Post by Kai »

What are the data types for each of the Doc_... fields?
Post Reply