Location Table View and CCK nodes

yes, using Location views module

Updated to latest cvs as advised and works now with the nodes created with CCK that include Location Information are shown. good.

other messages when choosing:
Name: All City: All Province: All Country not = Anguilla

    * user warning: 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 '= 'ai')' at line 1 query: SELECT count(*) FROM node node LEFT JOIN location location ON node.nid = location.oid WHERE (node.status = '1') AND (node.type IN ('user','story','content-painting')) AND (location.country NOT = 'ai') in /usr/local/apache/htdocs/sitename.com/dpa/includes/database.mysql.inc on line 120.
    * user warning: 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 '= 'ai') ORDER BY node.title ASC LIMIT 0, 10' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, location.name AS location_name, location.street AS location_street, location.additional AS location_additional, location.city AS location_city, location.province AS location_province, location.postal_code AS location_postal_code, location.country AS location_country, location.latitude AS location_latitude, location.longitude AS location_longitude FROM node node LEFT JOIN location location ON node.nid = location.oid WHERE (node.status = '1') AND (node.type IN ('user','story','content-painting')) AND (location.country NOT = 'ai') ORDER BY node.title ASC LIMIT 0, 10 in /usr/local/apache/htdocs/sitename.com/dpa/includes/database.mysql.inc on line 120.

note: there is no information with location country Anguilla.

works and no warnings messages.

other observations:

the Page listings number 1 2 Next and Last Button are shown in first page and not on the following pages.

Unable to show all listings for all countries in Country options selection

design is excellent, but the user can choose one country (good) not all countries; I think the (All) option is not listed under Country.

to see the error, need to have more than 10 nodes that meet condition (a)
a.- Name: All City: All Province: All Country: Not Anguilla
b.- results display more than 10 nodes
c.- click one of the options [1 2 3 4 5 next last], it list the next page
d.- there is no page numbering or previous page button
e.- BUT the current Views parameters are CHANGED in the Next page to:
f.- Name: All City: All Province: All Country: United States <--here

The Country selection option is being changed in the next page!

As advised, latest version of Views resolved all outstanding issues.

In reference to Country selection, there is not option to do a Worldwide search or All countries?

for Country, there are 2 options:
1.- , =, not = (this is ok)
2.- Anguilla, Aruba, ..., United States, (this option forces a country selection even if All is selected above)
All and None can be added to option list, similar to Province option

sorry for the misunderstanding.

Hi Karen,

In exposed filters, for Location: Country, I checked the box for Optional and the All option is now available. As advised, it is a subjective issue.

thanks for a great contrib.