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