How to count number of entries depending on the string in a field in sql

Question

I am having table Inbox in which i have two fields sender mailid and subject....
I should generate number of entries whose subject starts with "Re" for a unique mailid........


Please help me out in telling the query how to solve the above problem

Answer 1

I am sorry that I cannot help any more. I wish I could help. I hope someone else can help you and that they do help.

Answer 2

yes ping reply is coming you can see it from screen shot

Answer 3

I am sorry that I cannot help very much but I am surprised that no one else is helping.

Can you ping that server? Do you know how to ping? You can go to a command prompt window and use the ping command with the url as a parameter, as in:

ping localhost

Answer 4

Hi thanks for the reply
                               following is try catch error msg and my firewall is already set off.

{System.Net.WebException: Could not establish connection to network.
at System.Net.HttpWebRequest.finishGetResponse()
at System.Net.HttpWebRequest.GetResponse()
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse()
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse()
at System.Web.Services.Protocols.SoapHttpClientProtocol.doInvoke()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke()
at DeviceApplication1.localhost.WebService.HelloWorld()
at DeviceApplication1.Form1.button1_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Button.OnClick()
at System.Windows.Forms.ButtonBase.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at DeviceApplication1.Program.Main()
}

Answer 5

That is not the complete and accurate error message. Please provide the complete and accurate error message. You can use try/catch to get the complete error message.

Are you sure the firewall is allowing the connection? It might be not allowing it.