XModPro

Any way to use MyTokens replacement value as DataSource Parameter?

Fenske Fenske posted Mar 13, 2015
Active Oct 8 · Viewed 1576 times

Hi there!

I've successfully used MyTokens to place token values within content in the ItemTemplate area. When I'm trying to use one to set the value of a Parameter for the ListDataSource stored procedure, however, I get a data conversion error:

Here's what I'm trying:

<%@ Register TagPrefix="MyTokens" Namespace="avt.MyTokens.Core" Assembly="avt.MyTokens.Core" %>

<xmod:template UsePaging="False">

<ListDataSource CommandText="EXEC getRelatedCoursesByExam @ExamID, @SiteID" ConnectionString="[[ConnectionString:ECommDB]]">

<Parameter name="ExamID" value='[[Url:ExamID]]'/>

<Parameter name="SiteID" value='<MyTokens:Tokenize runat="server">[nh:PrimarySiteID]</MyTokens:Tokenize>' />

</ListDataSource>

The error I'm getting is this:

Error

MESSAGE:
Error converting data type nvarchar to int.

Is this just not possible? Any workaround to plug that value in as a parameter for the stored procedure?

4 Replies

Loading replies...