Error in Advanced Query

Error in Advanced Query

  
Executing an advanced query gives us the following error, anybody any clue ??
We're using SQL Server full text search ...

Error in advanced query AdvQuery1 in Ok in MenuColumn in testWEC_flow in LAB_Roy (SELECT Number FROM {ARTICLE} INNER JOIN CONTAINSTABLE({ARTICLE},*, 'ISABOUT (Grohe* weight (.5), Costa* weight (.6), kraan* weight (.2) )',100 ) AS KEY_TBL ON IDENTIFIER = KEY_TBL.[KEY] ORDER BY KEY_TBL.RANK DESC; ): Could not assign '24652175' to 'ARTICLE.Number'... Index was outside the bounds of the array.

at ssLAB_Roy.Flows.FlowtestWEC_flow.WBlkMenuColumn.FuncCommandOk.QueryAdvQuery1_Submit(HeContext heContext, Int32 maxRecords, Int32& outParamCount)
at ssLAB_Roy.Flows.FlowtestWEC_flow.WBlkMenuColumn.CommandOk_Submit(HeContext heContext)
at ssLAB_Roy.Flows.FlowtestWEC_flow.WBlkMenuColumn.wt_ButtonKpNY2xv889UqBfQhLHMw5qA_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at OutSystems.HubEdition.WebWidgets.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) -Env-
eSpaceVer: 2 (Id=41, PubId=68, CompiledWith=5.0.2.1)
RequestUrl: XXXXXXXXXXX
AppDomain: /LM/W3SVC/1/ROOT/LAB_Roy/jstringer-4-129107988724328048
FilePath: C:\...\PS\test\LAB_Roy\jstringer\Home.aspx
Locale: en-US
DateFormat: dd-MM-yyyy
PID: 4400 ('w3wp', Started='16-2-2010 12:18:41', Priv=118Mb, Virt=2879Mb)
TID: 15
.NET: 2.0.50727.4200

Hi Joop,

This problem is normally caused by a mismatch between the SELECT output parameters and the Advance Query output structures/entities.

Please, check that the SELECT output parameters match, in number and type, the Advance Query ones. In this case, if 'Number' is an integer, it looks like
'24652175' could be a Text/String and not an integer value. I think it's a mismatch between the types of t


Regards,
João Portela

João,

It looks like you're right.
I changed the query to

SELECT * FROM {ARTICLE}
INNER JOIN CONTAINSTABLE( {ARTICLE},*, 'ISABOUT (Grohe* weight (.5), Costa* weight (.6), kraan* weight (.2) )',100 ) AS KEY_TBL
ON IDENTIFIER = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC;

So instead of having 1 field as return from the query, I now return all fields, then it works fine.

Joop