Tinyint(1) in db = Tinyint(3) in WPDA

  • Hi,

    Noobie here, be gentle!

    I have a table in the database with several values set to Tinyint(1), and was hoping they’d show up as checkboxes. However, in the Project Template > Data Entry tab, they’re reported as being Tinyint(3), and the fields are displayed as text inputs with 0 as default value.

    Any ideas?

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @austenozzy,

    Only columns of type tinyint(1) will be shown as checkboxes. The question is: why are these column types changed to tinyint(3)? How have you created this table? Can you share your SQL script?

    Thanks,
    Peter

    Thread Starter austenozzy

    (@austenozzy)

    Hi Peter,

    Thanks for the reply.

    It was originally imported as tinyyint(3), and I updated the db setting to tinyint(1), and used the alter function in the data designer to reflect that change in wpda. I tried to remake the project template, to no effect.

    Are there other steps involved in making this change apply to the wpda settings?

    Thanks

    Austen

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Austen,

    Can you send me your SQL script and some data? You can use the contactform on the plugin website if you prefer to send it in private.

    Thanks,
    Peter

    Thread Starter austenozzy

    (@austenozzy)

    Thanks Peter – just sent an email via Freemius.

    Austen

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Thank you Austen! It’s a busy right now, but I’ll look into it later… ??

    Best regards,
    Peter

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Tinyint(1) in db = Tinyint(3) in WPDA’ is closed to new replies.