Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • javier 59 posts 79 karma points
    Jul 29, 2010 @ 13:09
    javier
    0

    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

    Copy Link
  • Thomas Höhler 1237 posts 1709 karma points MVP
    Jul 29, 2010 @ 13:22
    Thomas Höhler
    0

    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

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies