show all values from my database

[news]

Hello
I have a problem with show all values from my database into my html page!

Example of my database:
Namn: test.mdb
Table: tblTest
Columns: col1, col2, col3

The thing I want is to search the database for "2005-04-27" in the columns
col1 and col3 but I can only get values from col1 !!!

Here is an example of my SQL code:

******************************************'
strSQL = "SELECT * FROM tblTest WHERE Col1 = #" & CDate(strVarde) & "# & AND
(Col3 = #" & CDate(strVarde) & "#" ' ORDER BY Col1"
******************************************
Can someone please help meeeeeee..

// Kenneth

 

[dave]

use OR instead of AND
******************************************'
strSQL = "SELECT * FROM tblTest WHERE Col1 = #" & CDate(strVarde) & "# & OR
(Col3 = #" & CDate(strVarde) & "#" ' ORDER BY Col1"
******************************************
dave