auro2u
02-06-2006, 08:02 AM
sir,
I have a job segment in my site where the recruiters will search for the appropiate candidate.
The search goes like this :
academic qualification which is text(datatype) +
age(numeric ) from : dd-mm-yy
to (numeric ) from : dd-mm-yy
gender text(datatype)
keyword text(datatype)
Now when i want to search all this at once my sql commands , where i have written the between statements and the "AND" function do not reveal the appropiate results please help.
Ur Utter meditation in this regard is generously expected.
Regards
Auro.
I have a job segment in my site where the recruiters will search for the appropiate candidate.
The search goes like this :
academic qualification which is text(datatype) +
age(numeric ) from : dd-mm-yy
to (numeric ) from : dd-mm-yy
gender text(datatype)
keyword text(datatype)
Now when i want to search all this at once my sql commands , where i have written the between statements and the "AND" function do not reveal the appropiate results please help.
Ur Utter meditation in this regard is generously expected.
Regards
Auro.