Posted on 2006-11-20
We have a web site we are designing but our client has asked for something a little different.
Currently the web site uses the following code to display ALL items from a list with a TOTAL for each item next to it :
SQL="SELECT Distinct Address FROM Listings ORDER BY Address ASC"
do while not rs.eof
Total = conn.execute("SELECT count(Address) FROM Listings WHERE Address ='"&rs("Address")&"'")
This works fine.
However what we now require is for one item in the 'listing' table to be displayed according to a criteria:
i.e. display all addresses for a specific 'x' area and a total of houses in that area - so our code so far at the moment (Which does not work) looks like this:
SQL=(SELECT Address FROM Listings WHERE Address="London")
Why is this not working???
These are ASP pages
The database is access
Could someone help us out with the right code and also to summarise next to the location - the total number of "London's" in the list.