sir ,,,,,,, i m using MS ACESS and want to retrieve from the database......
ResultSet rs = st.executeQuery("select name from general_information where name ='jai mata di'");
but it is not showing the result properly ....... it is not matching 'jai mata di' in database but when i write only 'gaurav' then it matches and give the proper result.....i think that is is the problem of space......... please tell me that thank you gaurav
Do you mean that the problem is because "jai mata di" contains spaces (which is the way Jeanne understood it, I think)?
If Jeanne's interpretation is correct, then spaces have nothing to do with it. There simply is no row in the GENERAL_INFORMATION table where the value of the NAME column is "jai mata di". And if you think there should be, then you must be mistaken.
However, if you think that there is a NAME that contains "jai mata di", then Jeanne's query should find it for you.
Good Luck, Avi. [ March 03, 2005: Message edited by: Avi Abrami ]
author & internet detective