Hallo Zusammen
Ich versuche verweifelt eine Detailseite zu erstellen.
Das ist die Funktion:
<CMS_FUNCTION name="contentSelect" resultname="fr_jobData">
<CMS_PARAM name="schema" value="sfs_inserate_erecruiting" />
<CMS_VALUE_PARAM name="stellentyp" value="st_stellen_typ" />
<QUERY entityType="SFS_INSERATE_ERECRUITING">
<FILTERPARAM parameter="stellentyp" datatype="java.lang.String" />
<AND>
<LIKE attribute="stellentyp" parameter="stellentyp"/>
</AND>
<ORDERCRITERIA attribute="StellenId" descending="0" />
</QUERY>
</CMS_FUNCTION>
Das der a href indem ich ein CMS_REF(VARIABLE, contentId: item.Stellenid)$ mitgebe.
<a class="molecule-responsive-datalist-entry entry" href="$CMS_IF(!ss_jobDetailPage.isEmpty())$$CMS_REF(ss_jobDetailPage, contentId: item.Stellenid)$$CMS_END_IF$" $CMS_IF(#global.preview && #global.node.content2Params.isEmpty())$$CMS_VALUE(editorId(entity: item,view: "inserate"))$$CMS_END_IF$>
Detailpage mit der Funktion:
<CMS_FUNCTION name="contentSelect" resultname="fr_jobDataDetail">
<CMS_PARAM name="schema" value="sfs_inserate_erecruiting" />
<CMS_VALUE_PARAM name="stellenid" value="#row.Stellenid" />
<QUERY entityType="SFS_INSERATE_ERECRUITING">
<AND>
<FILTERPARAM parameter="stellenid" datatype="java.lang.String" />
<LIKE attribute="stellenid" parameter="stellenid"/>
</AND>
</QUERY>
</CMS_FUNCTION>
Datenbank:
Stellenid: xs:integer definiert.
Fehler beim generieren:
ERROR 23.05.2022 21:11:17.927{g-sec=1826467,g-node=1826016} (de.espirit.firstspirit.generate.SiteProduction): Error resolving reference - Error code: 8114, state: S0005
inside of: Template 'dynamic content' (id=1825374)
inside of: $CMS_TRIM(level:3)$ - at 88, 1
inside of: $CMS_IF( ! #global.preview )$ - at 232, 2
inside of: $CMS_VALUE(#global.page.body("main_content"))$ - at 236, 6
inside of: Template 'responsive_datalist' (id=1825373)
inside of: $CMS_IF( ! st_dataSource.isEmpty() && st_dataSource.toString() == "inserate" )$ - at 134, 1
inside of: $CMS_IF( ! fr_jobData.isEmpty() && fr_jobData.size() > 0 )$ - at 199, 8
inside of: $CMS_FOR( item, fr_jobData )$ - at 200, 15
inside of: $CMS_IF( #for.index <= 14 )$ - at 201, 17
inside of: $CMS_IF( ! ss_jobDetailPage.isEmpty() )$ - at 203, 76
inside of: $CMS_REF(ss_jobDetailPage, contentId:item.Stellenid)$ - at 203, 113
de.espirit.or.QueryException: Error code: 8114, state: S0005
Caused by: java.sql.SQLException: Error converting data type varchar to bigint.
Wir komme zu bigint?
Aber die Jobseiten werden einfach nicht generiert. Warum?
Danke um Hilfe 🙂
Grüsse
Thomas