At first glance your configuration seems fine. But looking at your <editor /> above, there is an error in the Title-field: <fieldtitle="Title"sourceField="Title"umbracoDataType="Textstring" / Is missing the last >. So should be: <fieldtitle="Title"sourceField="Title"umbracoDataType="Textstring" />
If this is not the problem, does an actual error occur when you try to edit or how does the problem manifest itself?
About your question in the other thread about "yourowntype and yourownassembly", it was just related to the example, but I don't think it's applicable in your situation.
Oh, I just spotted the problem - you need to move your <editor /> element out of the <view /> element like this: <container name="External database" connection="data source=;database=;user id=;password="> <repository name="Reviews"> <primaryKey name="reviewID" /> <view name="Reviews entries" pageSize="50" > </view> <editor tableName="tblReview"> </editor> </repository> </container>
So that view and editor elements are on the same level - both as children of the repository-element.
Edit column in external database
I'm connecting from external db and it show my data. But I can't figure out a way to add edit those records. Below is the my code.
Hi Eshan,
At first glance your configuration seems fine. But looking at your <editor /> above, there is an error in the Title-field:
<fieldtitle="Title"sourceField="Title"umbracoDataType="Textstring" /
Is missing the last >. So should be:
<fieldtitle="Title"sourceField="Title"umbracoDataType="Textstring" />
If this is not the problem, does an actual error occur when you try to edit or how does the problem manifest itself?
About your question in the other thread about "yourowntype and yourownassembly", it was just related to the example, but I don't think it's applicable in your situation.
- Sune
Oh, I just spotted the problem - you need to move your <editor /> element out of the <view /> element like this:
<container name="External database" connection="data source=;database=;user id=;password=">
<repository name="Reviews">
<primaryKey name="reviewID" />
<view name="Reviews entries" pageSize="50" >
</view>
<editor tableName="tblReview">
</editor>
</repository>
</container>
So that view and editor elements are on the same level - both as children of the repository-element.
- Sune
Tx Sune. last one is the answer. :))))
is working on a reply...