Re-publish all records

4 posts by 3 authors in: Forums > CMS Builder
Last Post: July 26, 2016   (RSS)

By Toledoh - July 25, 2016

Hey Guys.

Is there a way to update all records in a section?  I've made some changes to a site which produces a sitemap.xml.php and I need to update the time-stamp for all the pages...

Cheers,

Tim (toledoh.com.au)

By Toledoh - July 25, 2016

That'll work Damon!

What would the command look like to do that for all records in the "posts" table?

Cheers,

Tim (toledoh.com.au)

By ross - July 26, 2016

Hi Tim

We don't support custom SQL like this in the forums. 

What you are looking for, though, is and UPDATE statement that sets your timestamp field to "NOW()".

See what you can come up with and send through a support request if you have any further questions.

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/