Page 1 of 1

Query problem...

Posted: Wed Mar 31, 2004 3:09 pm
by potato
Is it possible to make a query like:

SELECT * FROM agenda WHERE agenda_year = '2004' & agenda_month = '4' ORDER BY agenda_day ASC

With this code i get nothing. Somebody knows how to do it?

thnx

Posted: Wed Mar 31, 2004 3:16 pm
by markl999
Try,
SELECT * FROM agenda WHERE agenda_year = '2004' AND agenda_month = '4' ORDER BY agenda_day

ASC is the default, so you don't need that.

Posted: Wed Mar 31, 2004 3:19 pm
by potato
thanx, i found it just myself, but thanx for the help anyway

Posted: Wed Mar 31, 2004 6:23 pm
by Pyrite
I think you either have to use AND or && (not just one &) .