ASPX templates
Version 3.x > ASPX templates > ASPX Tutorial - Products not working View modes: 
User avatar
Member
Member
simon@hobman.com.au - 6/7/2008 12:07:02 PM
   
ASPX Tutorial - Products not working
Hi there,

I'm following the ASPX Tutorial document for creating products (around page 95), and I'm having some problems.

1) After completing all the steps in creating the 'Computer' document type and creating its transformations and creating the product list page template and adding the 'Products' page... This error is produced when I click the new 'Products' page.

[DataConnection.ExecuteQuery]: Query: SELECT * FROM View_CMS_Tree_Joined_Versions WHERE (SiteName = N'KTAS') AND (DocumentCulture = N'en-US') AND (NodeAliasPath LIKE N'/Products/%') ORDER BY ComputerName ASC: caused exception: Invalid column name 'ComputerName'.

2) If I then remove the 'OrderBy' attribute within the CMSDataList control on the product list page template, I get no error however... The the CMSDataList displays the two computer records I've entered, but all the field bindings are empty.

Here is what I have within the <content> part of the ProductList.aspx template page:

<cms:CMSBreadCrumbs ID="CMSBreadCrumbs1" runat="server" />

<cms:CMSDataList ID="CMSDataList1" runat="server"
ClassName="custom.computer"
TransformationName="custom.computer.preview"
SelectedItemTransformationName="custom.computer.default"
RepeatColumns="2">
<%-- OrderBy="ComputerName ASC" --%>
</cms:CMSDataList>

is there somethign I'm doing wrong? I have followed the instructions twice from scratch and I got the same problem both times.

Cheers,

/Simon

User avatar
Member
Member
simon@hobman.com.au - 6/10/2008 6:14:52 AM
   
RE:ASPX Tutorial - Products not working
Support said there is an error in the documentation. Instead of using the ClassName property in the CMSDataList control, you should use the ClassNames property.

So, the code should be:
<cms:CMSDataList ID="CMSDataList1" runat="server" ClassNames="custom.computer" TransformationName="custom.computer.preview" SelectedItemTransformationName="custom.computer.default" RepeatColumns="2" OrderBy="ComputerName ASC" />

Cheers,

/Simon