Load data from antoher tabel with sql

18 years 2 months ago #3574 by petschni
Load data from antoher tabel with sql was created by petschni
Hello,

I have the following problem. I have a second table with telephone numbers etc.. This comes from another database so i cannot have the user type it in.

What I would like is to have fields in CB that are automatically filled with the values of this other table.

Is there a way to realize that?

greetings
peter

Please Log in to join the conversation.

18 years 2 months ago #3580 by mikko
Replied by mikko on topic Re:Load data from antoher tabel with sql
You need to either enter the data manually, or make a custom plugin for this.

The List Tab plugin uses external tables for storing data, and is propably quite close to your needs. The only modifications needed would be the matching algorith and disabling the javascript things.

But as such, CB connot do what you need.

mikko

Please Log in to join the conversation.

18 years 2 months ago #3794 by petschni
Replied by petschni on topic Re:Load data from antoher tabel with sql
Ok thank you - i think i will just write an PHP Script that updates that updates cb's database every 24 hours....

Please Log in to join the conversation.

18 years 2 months ago #3856 by mikko
Replied by mikko on topic Re:Load data from antoher tabel with sql
In a few days I will release a plugin that will help you a lot. Please see the discussion about preprosessor plugin.

mikko

Please Log in to join the conversation.

18 years 2 months ago #3858 by petschni
Replied by petschni on topic Re:Load data from antoher tabel with sql
thanks - looking forward to the plugin!

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.292 seconds

Facebook Twitter LinkedIn