Technology, Support, and News Forum

[Thomas52 Profile Website]

I know I looked at it a hundred times and still get an error, but
IF I import a .cvs formatted file with:
"1;USA;Alabama;;;W86.80;N32.79;7;places/USA/flags/AL.gif"
that creates a 'Location' (at the top level) for USA with Alabama as a state
(and with the 'lat-longs', 'zoomlevel' and icon shown),
(Level;"Country";"State";"County";"Place";"Longitude";"Latitude";"ZoomLevel";"Icon"),

AND
"2;USA;Alabama;Autauga;;W86.65;N32.53;9;"
creates a 'county' (at the second level) named 'Autauga' in Alabama, USA,

AND
"3;USA;Alabama;Autauga;Autaugaville;W86.65;N32.43;12;"
creates a 'city' (at the third level) named 'Autaugaville' in Autauga, Alabama, USA,

THEN what changes do I need to make to these .csv files to create a 'Location' with
Alabama AT THE TOP level, as "Alabama, Autauga, Autaugaville, W86.65; N32.43; 12"?
1;USA;Alabama;;;W86.80;N32.79;7;places/USA/flags/AL.gif
2;USA;Alabama;Autauga;;W86.65;N32.53;9;
3;USA;Alabama;Autauga;Autaugaville;W86.65;N32.43;12;

[Thomas52 Profile Website]

Forgot to mention, getting error message similar to:
ERROR:-2 DB Error: syntax error
SQL:INSERT INTO pgv_placelocation (pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon) VALUES (16855, 16854, 1, "Unknown", "7" , "places/USA/flags/AL.gif ", ,""); [nativecode=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 '"")' at line 1]