hi to all,
MembersTable -- this is dbtable contails Email,name,pan etc fields.
1)before passing email as a parameter to the query i validate the email address.And store that value in one string say emailidvalue,
("select Name,Email from MembersTable where Email like '"+emailidvalue+"' ");
it is not working am i doing in right path..
please help me
thanks in advance.
first of all thanks for repling my post,
actually my requirment is setting email value dynamically.
first i am trying to do in static manar that is i am fixing the email value as String se="firstname.lastname@example.org"; This is "se" value may sent to the query as a paramater value.
In database also Email is stored like this only(email@example.com)
query is :
rs=("select Name,Email from MembersTable where Email like '"+se+"' ");
out put : nothing will come .
is it use any regular expression related values in the query please help me ..
thanks in advance..