My SQL logic problem
2 posts
• Page 1 of 1
My SQL logic problem
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;
"He either fears his fate too much, Or his desserts are small, Who dares not put it to the touch, To win or lose it all!" - James Graham, 5th Earl of Montrose (1612 to 1650)
- Thomas52
- PROfessional Member
- Posts: 136
- Joined: Sat Dec 14, 2002 5:03 am
- Location: The foothills of the beautiful Blue Ridge Mountains of Western North Carolina
- Real Name: Thomas Adkins
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]
"He either fears his fate too much, Or his desserts are small, Who dares not put it to the touch, To win or lose it all!" - James Graham, 5th Earl of Montrose (1612 to 1650)
- Thomas52
- PROfessional Member
- Posts: 136
- Joined: Sat Dec 14, 2002 5:03 am
- Location: The foothills of the beautiful Blue Ridge Mountains of Western North Carolina
- Real Name: Thomas Adkins
2 posts
• Page 1 of 1
Return to HTML, CSS, and Scripts
Who is online
Users browsing this forum: No registered users and 3 guests