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 / fields to cascade

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

fields to cascade

More
12 years 3 months ago #6431 by nikkodago
fields to cascade was created by nikkodago
Hello everyone

I have a gold package for AdsManager with the fields to cascade already 'installed,
the problem 'that I could use a file with all regions of provinces and municipalities to be included in automatic ,
not to transcribe everything by hand ... it would be a big job. there is' someone who knows how to say where to find this file.

Greetings to all and thank you very much
More
12 years 3 months ago #6454 by tompap
Replied by tompap on topic fields to cascade
Hello, I am not sure to understand what you want.

You have a "file" you mean a database table with one column by language ?

by transcribe you mean multiple language ?

In the cascade file you can use "external storage" (a db table) to avoid to enter manually all the value inside the file
More
12 years 3 months ago #6464 by nikkodago
Replied by nikkodago on topic fields to cascade
no .... I have not explained well!
must go into the fields to cascade: the regions,provinces and municipalities; choosing one region to the next field should
appear only the provinces belonging to the selected region, and in the next field of the provinces, must
appear only municipalities in the province choice. since municipalities are many, I would not put them in hand, but it would take something so that all regions are inserted. provinces and municipalities, automatically. I hope I was a little bit more 'clear. greetings and thanks
More
12 years 3 months ago #6484 by tompap
Replied by tompap on topic fields to cascade
For my understanding, you don't want to set manually which municipalities are in which provinces etc...

For that you need to have a SQL DUMP with several tables
in each table you need an "ID" an "Label" a "Parent ID" (province id for munitcipalities)
Then you can set fields to use these tables.

You can build your "dump SQL" with website like geoname.
More
12 years 2 months ago #6510 by nikkodago
Replied by nikkodago on topic fields to cascade
...... I found sql file that might be fine for my problem; imported into the databese and gives me this error:Errore
Query SQL:

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 18 Apr, 2007 at 04:00 PM
-- Versione MySQL: 3.23.58
-- Versione PHP: 4.3.11
--
-- Database: `test`
--
--
--
-- Struttura della tabella `comuni`
--
CREATE TABLE `comuni` (

`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`nome` TEXT NOT NULL ,
`idprovincia` INT( 4 ) NOT NULL DEFAULT '0',
`idregione` INT( 4 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `idcomune` )
) TYPE = MYISAM AUTO_INCREMENT =8085;

Messaggio di MySQL: Documentazione

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`id` int(5) NOT NULL auto_increment,
`nome` text NOT NULL,
`idprovincia` int' at line 2


how can I fix this? .... thanks
More
12 years 2 months ago #6530 by tompap
Replied by tompap on topic fields to cascade
I think the error in PRIMARY KEY (ìdcomune`)

should be PRIMARY KEY (`ìd`)
Moderators: perry
Time to create page: 0.051 seconds
Powered by Kunena Forum