Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hi,
This is the situation:
In umbraco database, table CMSDataType I have 44 records. Grouping them by the column ControlID, it shows only 28. Everything fine, but under Developer section, Data Types, there are only 27, so, 1 is not showing.
I think that is the cause if my problem here.
How can I know which ControlID of the table CMSDataType corresponds to each DataType?
Thanks for any help.
Regards
Javier
Join the table with the umbracoNode table:
select * from cmsDataType D INNER JOIN umbracoNode N on D.nodeId = N.id
everything is a node except the build in datatypes which have negative nodeId's
hth, Thomas
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Help with database
Hi,
This is the situation:
In umbraco database, table CMSDataType I have 44 records. Grouping them by the column ControlID, it shows only 28. Everything fine, but under Developer section, Data Types, there are only 27, so, 1 is not showing.
I think that is the cause if my problem here.
How can I know which ControlID of the table CMSDataType corresponds to each DataType?
Thanks for any help.
Regards
Javier
Join the table with the umbracoNode table:
select * from cmsDataType D INNER JOIN umbracoNode N on D.nodeId = N.id
everything is a node except the build in datatypes which have negative nodeId's
hth, Thomas
is working on a reply...