Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Login

Or Register
Accueil / forum / Public Forum / Main Forum / [RESOLVED] dropbox field with external table datas

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

×

Notice

The forum is in read only mode.

× OLD Forum post could be checked here : forum.joomprod.com

[RESOLVED] dropbox field with external table datas

More
11 years 11 months ago - 11 years 11 months ago #8316 by ita4012
Hi, I would like to create a new field (Country of the world), with dropbox option, in order to let people select from a list of countries in the world, while adding a new add.
I would like to use an external table of my database, in which I uploaded all countries of the world (I imported them in the database from a table in csv format). The name of the table in the database is TABLE 136, codes are in COL 1, and countries name in COL 2. If I set these values in the specific boxes of the field, I get no result. What do I have to do?

Thanks
Last edit: 11 years 11 months ago by loic.
More
11 years 11 months ago #8332 by tompap
Replied by tompap on topic dropbox field with external table datas
You have to create a dropdown field. Use external sotrage.
enter the table name and the column names.

Note: your database table names are not correct in your message to "space allowed in tablename"
More
11 years 11 months ago #8455 by ita4012
Replied by ita4012 on topic dropbox field with external table datas

tompap wrote: You have to create a dropdown field. Use external sotrage.
enter the table name and the column names.

Note: your database table names are not correct in your message to "space allowed in tablename"


I still don't understand what to do. Please could you show it with an example?
Moreover, what do you mean with "your database table names are not correct in your message to "space allowed in tablename"?

Thanks
More
11 years 11 months ago #8474 by tompap
Replied by tompap on topic dropbox field with external table datas
Sorry i mean you cannot have a database name with a "space " => TABLE 136" is not valid
a correct name could be xdzje_cities mytable etc...
More
11 years 11 months ago #8480 by ita4012
Replied by ita4012 on topic dropbox field with external table datas
I tried with a table name without spaces, but it was no use. Still doesn't work
More
11 years 11 months ago #8493 by loic
Replied by loic on topic dropbox field with external table datas
Hello,

You must create the table in your database before trying to link the select to it.

The table is not generated by AdsManager.

Did you create the table containing the datas ?

Best regards.
Moderators: perry
Time to create page: 0.071 seconds
Powered by Kunena Forum