display all records from a table

[subashini Thiyagarajan]

Hi all,

i have just displayed all the records from one table of access database.it is very easy right. Now....... i have given sort by option on the top using list box.when we select any item from the list box it will compare with the column data and where the same content is there in any record,only those records it display.everything working fine..


now my problem is without selecting any content it is defaultly selecting the last search and displaying those records.......................pls help, at the intial stage (i mean without any selection) all records should get displayed.


How to do??????????????????

[jhardman]

now my problem is without selecting any content it is defaultly selecting the last search and displaying those records.......................pls help, at the intial stage (i mean without any selection) all records should get displayed.

First check that your query statement is correct. It sounds like the query is keeping the wrong info.

Jared

[subashini Thiyagarajan]

Hi,
My query is this


"select * from tablename where columnname=" & selection

Intially selection is nothing so it supposed to show all records.but for me intial stage as soon as the page displays it automatically takes the first selection and showing the details.
in select option i have not specified any selected near any option


could u help me?

[jhardman]

That looks good, I always use the "SELECT * " as well no matter what I pull up.

I have done something very similar to the project you described. I was listing books by different authors, but instead of the user selecting a sort field from a drop down list I put a link in each table header, so under the field "title" or "author" or whatever, I put a link to [HTML]<a href="datalister.asp?sort=author">Author</a>[/HTML] When I create the query statement I say:

query = "SELECT * FROM works"
if request("sort") = "" then
   query = query & " ORDER BY title"
else
   query = query & " ORDER BY " & request("sort")
end if
 
'the next line will be commented out in the final version:
response.write query & "<br>" & vbNewLine

There is a lot that can go wrong with any query statement, so I print the query as a matter of fact now until everything is up. I would first try to eliminate the possibility that the query string is being written wrong. Try to get the table to display incorrectly AND show the actual query string and you might be able to catch the problem, or at least eliminate that possibility.

Does that make sense?

Jared

[jhardman]

Ok, now that I re-read your post, I see that you are using your selection drop down box to add a "where" clause, and I was using it to add an "order by" clause, but my answer is still the same: try to get the error AND print the query string.

Jared