ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Add a default value for a textfield

July 05, 2012 3:08pm

Subscribe [1]
  • #1 / Jul 05, 2012 3:08pm

    soire

    25 posts

    Perhaps this is a better how-to thread, but wasn’t sure…so…

    I just added a textfield to a channel field group whose channel has about 800-1000 entries. Basically, I need to make the value of said new field be “0” (the number zero) for all of my entries (it is a inventory field for a eCommerce site, BTW). That way, once I have one of the products in stock, I can switch it from 0 to a positive number for a given entry. I’m sure that there is a way I could accomplish this via an sql script, but my knowledge of sql is not so hot.

    Any tips for how I could accomplish this in a batch fashion?

    Thank you!

  • #2 / Jul 06, 2012 11:04am

    Shane Eckert

    7174 posts

    Hey soire,

    I am going to move this on over to the Community Help Forum where I am sure someone with SQL chops will lend you a hand.

    Cheers!

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases