+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Update Author with a query

Update Author with a query

3 posts, 0 answered
  1. Bachar Zeidan
    Bachar Zeidan avatar
    67 posts
    Registered:
    01 Jul 2010
    15 Sep 2010
    Link to this post
    Hello every body
    I need to update the Author Metakey from my Db but I don't know the table name that contains the range!
    I need to do it with a  Query
    something like this:
    Update Table.name set Author="xxx" where Author="yyy"
    thank  you very much
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    15 Sep 2010
    Link to this post
    Hello Bachar Zeidan,

    The table that you have to update is [sf_GCMetaData] where the "Author" metakey is a record in KeyValue column.

    sample query
    Update [sf_GCMetaData] Set ShortText = 'ivan' where KeyValue = 'Author' and ShortText = ''



    Greetings,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Bachar Zeidan
    Bachar Zeidan avatar
    67 posts
    Registered:
    01 Jul 2010
    15 Sep 2010
    Link to this post
    Thank you Ivan Dimitrov.
Register for webinar
3 posts, 0 answered