Is there a way to get a list of cms tables that already exist?

Re: [greg] Is there a way to get a list of cms tables that already exist?

Tue, 18 Sep 2012 19:19:19 -0700

Works perfectly!!!

Thanks so much - I will begin replacing all instances of my entry fields with this - it will be very nice. I have this concept in literally 10-15 places throughout my "normal" site setup. This will be so nice.

Gary.

Re: [garyhoffmann] Is there a way to get a list of cms tables that already exist?

Tue, 18 Sep 2012 11:47:37 -0700

Hi Gary,

This is a good question, and we've found a solution to it! If you use this MySQL code for the get options from MySQL query option on the list field type:

SELECT REPLACE(TABLE_NAME, '', '') FROM information_schema.`TABLES` where TABLE_SCHEMA = '' AND TABLE_NAME like '_%'

This should get the all of the table names from the information_schema table, and uses the MySQL replace function to remove the 'cms_' part of the table name in the results. It should all be dynamic so you shouldn't have to change anything in the code above.

Thanks

Is there a way to get a list of cms tables that already exist?

Mon, 17 Sep 2012 16:38:22 -0700

I've been doing this for several years now with text fields, but would like to use a drop-down if it's possible. Keep in mind, this is all referencing the admin area - I already have it all worked out in the presentation of the site.

Our scenario: I have a "form information record" which includes general information about the form (form name, what should happen when a user submits it, etc.). I also create a section called form fields in which the user lays out their form (record with keys of FirstName, LastName, etc.).

In my form info section, I have a field called form_fields_section_name in which the user has to type the name of the table (minus the cms_ prefix).

I'm wondering if there is a way to get a drop down list of all the tables in the database - I could use SHOW TABLES LIKE 'cms_%' but then I get the cms_ portion of the name back. I'm wondering if there is a "cms friendly" way to get the table names back?

Thanks,
Gary.