Please, am I doing something simple wrong. My database has a date field, but I can't search successfully on this field. Everything else works fine. All dates are entered as 23-Aug-57. Here is my database definition:
%db_def = (

ID => [0, 'numer', 3, 4, 1, '', ''],

fname => [1, 'alpha', 20, 20, 1, '', ''],

sname => [2, 'alpha', 20, 20, 1, '', ''],

street => [3, 'alpha', 30, 30, 0, '', ''],

suburb => [4, 'alpha', 20, 20, 0, '', ''],

pcode => [5, 'alpha', 4, 4, 0, '', ''],

phone => [6, 'alpha', 15, 15, 0, '', ''],

email => [7, 'alpha', 40, 40, 0, '', ''],

dob => [8, 'date', 12, 15, 1, '', ''],

sex => [9, 'alpha', 1, 1, 1, 'M', ''],

feespaid => [10, 'alpha', 1, 1, 1, '', 'Y|N|y|n'],

sendnewsletter => [11, 'alpha', 1, 1, 0, '', ''],

yearjoined => [12, 'alpha', 4, 5, 0, '', ''],

);
Thanks for any help.

Graham

Hi there,

Please post a link to your database and also copy the html.pl script and name it as htmppl.txt and upload it to the server and leave a link to it here.

We may be able to help you futher.

If you would like your links to sho9w up in the forum use the following http://www.mylink.com

Regards

Mark Priest

Mydatabase is at http://www.southwest.com.au/cgi-bin/cgiwrap/alex/mtcmembers/db.cgi
User ID: guest
Password: guest

My html.pl script at http://www.southwest.com.au/~alex/htmppl.txt

Thanks very much for your help.

Graham