Comments by Bigprey - CodeProject

Bigprey 8-Nov-16 23:55pm View

Since they are limiting a lot such as how the images are shown in the Emails strictly, I too thought of getting a copy of the each mails through a BCC to my own Gmail. But's its not allowed, it seems. Anyway, thanks

Bigprey 8-Nov-16 6:34am View

@F-ES Sitecore You are right... Only the Gmail's BCC are not allowed. I thought since "To" addresses including some gmail ids are going fine, then it should also accept BCC. Anyway, I only thought of knowing how the mail gets shown up in gmail. So, I can't find it through BCC method.

Thanks mate for your help.

Bigprey 8-Nov-16 3:55am View

I don't receive the BCC mails. It's one of my own email id and it does exist.

Bigprey 17-Oct-16 5:16am View

For the corrected query

SELECT DISTINCT roo.[Sports], roo.[Name], COUNT(DISTINCT chu.ChatUserLogId) AS TotalUsers, COUNT(DISTINCT liu.[LoggedInUserID]) AS UserOnline

FROM Room AS roo

LEFT JOIN LoggedInUser AS liu ON roo.RoomID = liu.RoomID
LEFT JOIN ChatUserLog AS chu ON roo.RoomID = chu.RoomID AND chu.LoggedInTime >= DATEADD(DAY,-30,GETDATE())

GROUP BY roo.[Sports]

ORDER BY TotalUsers DESC";

I am getting say, Basketball repeated n number of times for n number of Roomnames and Football repeated m number of times for m number of Roomnames in Football category.

What are the mistakes, I have done here?

Bigprey 13-Oct-16 5:48am View

And have to remove "ChatRoomName" alias as well for roo.[Name], right? It is being used at the last.

One more doubt. Don't I have to use ISNULL for Count, since it has more chance to be coming 0 too?

Thanks

Bigprey 13-Oct-16 3:39am View

So, I need to change Sports to Sport in Select (Aliasing) part or in Group BY part at the last? Thanks

Bigprey 13-Oct-16 3:07am View

But ain't the column "Sports" is created in the Room table?

CREATE TABLE [dbo].[Room] (
[RoomID] INT IDENTITY (6666, 1) NOT NULL,
[Name] VARCHAR (100) NOT NULL,
[Sports] VARCHAR (50) NOT NULL,
[CreatedDate] DATETIME DEFAULT (getdate()) NOT NULL,
[CreatedBy] VARCHAR (50) NOT NULL,
[CreatedUserID] INT NOT NULL,
PRIMARY KEY CLUSTERED ([RoomID] ASC)
);

Thanks in advance and have a nice day ahead.

Bigprey 13-Oct-16 2:45am View

It's different... If you could read or compare it with the 1st one, you would have known it already.

I am trying to post this different question 2-3 times already and got deleted... That's why I have put the error itself as the title over here... Please understand and let it be.

Bigprey 13-Oct-16 0:28am View

Hi,

I have put this question little bit wrong and since I don't know how to delete it, I have created a new one at http://www.codeproject.com/Questions/1138117/MS-SQL-query-error-in-my-chatroom-code-when-any-us. The query you gave was almost fitting but could you modify it according to the question at this new url

Thanks in advance and have a nice day ahead.

Bigprey 12-Oct-16 0:25am View

Nothing special to mention around it though.

Bigprey 10-Oct-16 2:55am View

I am not much of a coder. So, will the problem solved if I use con.Dispose() instead of Con.Close()?

con.Open();
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
con.Dispose();

Among 30 other pages of the same site, there is no SQL Connection coming except here. So, I don't guess, there are any disclosed connection from other pages.

Thanks in advance and have a nice day ahead.

Bigprey 1-Oct-16 4:45am View

Please check it out now. I have added the Insert queries too and you would find it easy to understand now. Looking forward for your help.

Thanks and have a nice day ahead.

Bigprey 1-Oct-16 4:45am View

Please check it out now. I have added the Insert queries too and you would find it easy to understand now. Looking forward for your help.

Thanks and have a nice day ahead.

Bigprey 1-Oct-16 3:04am View

Deleted

Please check it out now. I have added the Insert queries too and you would find it easy to understand now. Looking forward for your help.

Thanks and have a nice day ahead.

Bigprey 30-Sep-16 6:06am View

Deleted

Thanks for your suggestion and I have edited my question further for more understanding.

Bigprey 30-Sep-16 5:30am View

Now, you could find the data. I have elaborated further details in the question now.
Thanks and have a nice day ahead.

Bigprey 16-Sep-16 4:45am View

I guess, the library should be fine because it's working fine in the other pages of the same website... It's happening only here, may be, because of the Emptydatatemplate of the gridview or Jquery's inability to call the panel since it's not loading when $(document).ready

Similar issue is posted at http://stackoverflow.com/questions/17811844/gridview-filtering-wont-work-when-it-has-returned-empty

Thanks

Bigprey 16-Sep-16 2:02am View

http://cdnjs.cloudflare.com/ajax/libs/fancybox/1.3.4/jquery.fancybox-1.3.4.css

http://fancybox.net/

Bigprey 16-Sep-16 0:48am View

I tried their documentation already and it's working fine in all my other pages except here.

I had the doubt that the problem might be due to the fact that the Panel is set to false while loading, so that $(document).ready(function () doesn't function properly. So, I tried

<asp:Panel ID="TourPoster" runat="server" style="visibility:hidden;">

-----------

protected void LBSampleTournPosters_Click(object sender, EventArgs e)
{
TourPoster.Style.Add("Visibility", "Visible");
}

But it's not activating the "Fancybox" too.

Even if I put <asp:Panel ID="TourPoster" runat="server" style="visibility:Visible;"> or simply <asp:Panel ID="TourPoster" runat="server">, the fancybox is not working...

Actually, this whole Panel is called from inside an Empty Data template of a gridview.

Will it be a concern? Thanks for your time mate and have a nice day ahead.

Bigprey 16-Sep-16 0:47am View

No errors are shown.

I had the doubt that the problem might be due to the fact that the Panel is set to false while loading, so that $(document).ready(function () doesn't function properly. So, I tried

<asp:Panel ID="TourPoster" runat="server" style="visibility:hidden;">

-----------

protected void LBSampleTournPosters_Click(object sender, EventArgs e)
{
TourPoster.Style.Add("Visibility", "Visible");
}

But it's not activating the "Fancybox" too.

Even if I put <asp:Panel ID="TourPoster" runat="server" style="visibility:Visible;"> or simply <asp:Panel ID="TourPoster" runat="server">, the fancybox is not working...

Actually, this whole Panel is called from inside an Empty Data template of a gridview.

Will it be a concern? Thanks for your time mate and have a nice day ahead.

Bigprey 15-Sep-16 7:20am View

Even if I put <asp:Panel ID="TourPoster" runat="server" style="visibility:Visible;"> or simply <asp:Panel ID="TourPoster" runat="server">, the fancybox is not working...

Actually, this whole Panel is called from inside an Empty Data template of a gridview.

Similar issue is posted at http://stackoverflow.com/questions/17811844/gridview-filtering-wont-work-when-it-has-returned-empty

Will it be a concern? Thanks for your time mate and have a nice day ahead.

Bigprey 15-Sep-16 1:12am View

I also had the same doubt and have tried like

<asp:Panel ID="TourPoster" runat="server" style="visibility:hidden;">

-----------

protected void LBSampleTournPosters_Click(object sender, EventArgs e)
{
TourPoster.Style.Add("Visibility", "Visible");
}

But it's not activating the "Fancybox" too.

Comments by Bigprey (Top 22 by date)