Search results for query: *

that answer could have been given sooner if people would have just read my first post completley as i stated in it "I am trying to get a count of entries per month"" it does not iterate through the whole month. How can i have it so it will give me the total count from each month." such is...

that did it thanks denis. "why do you have a where claue that includes this month if you want more than this month?" I don't know i was trying so many different things that is the one that got me closes to the results. thanks again!!!

yes query anylzer. "Have you taken into account that it is May first and you probably don't have data for May yet???????" no because I am trying to get results for EACH month not just one month like this month id year entry count February 2 2006 1 April 4 2006 1 June 6 2005...

tried sqldenis too still i get no rows

I already tried rudy's query as i stated in my 2nd post "if i run the query with that and keep the datecreated group clause i do not get any rows returned" other ideas? i appreciate all the help..

my entire query was in my first post, but here it is with the changes i made after reading the previous posts Select distinct datename(Month,DateCreated)As Month,datepart(Month,DateCreated)As Monthid, datepart(year,DateCreated) As Year, count(*) As EntryCount from blog_entry WHERE...

There are some other weirdos in this query... later. " well then how about helping me out instead of making snide remarks!

tried it still get no rows. tried this group by datename(Month,DateCreated),datepart(Month,DateCreated),datepart(year,DateCreated),datecreated also tried adding just the datepart month and date created fields in the group by same thing no rows returned.

i changed the datename(Month,DateCreated)=datename(Month,getdate()) like you suggested. if i run the query with that and keep the datecreated group clause i do not get any rows returned. IF i remove the group by datecreated i get Column DateCreated is invalid in the select list because it is...

I am trying to get a count of entries per month. The date created field is the field that holds the date of an entry. When i run the below query it only gives me data from one day for each month, it does not iterate through the whole month. How can i have it so it will give me the total count...

I just added this to my query and orderby by it and it worked, it ehre a better way of doing it? datepart(Month,DateCreated)As Monthnum order by monthnum

I have a stored procedure that gets the month name and the number of items for that month from a table. I get all that fine however I cannot get it to orderby or group by the date name properly. it sorts it by the actually name instead of the order of the month. ie july is sorted before june...

worked thanks. hate that though

I am having a brain cramp as i have done this several times in the past. I want to run multiple queries just one after another. I either get ERROR at line 1: ORA-00911: invalid character if i have ; to end line one, or if i remove ; from line 1 i get sql command not properly ended properly. I...

here's the full code for that basepage class. Imports Microsoft.VisualBasic Imports System Imports System.Data Imports System.Configuration Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports...

Ok i just discover this as well, when i commented out the Server.Transfer(Request.FilePath) If i click on one of my internal links to my site it changed the theme to the very firt theme that was loaded when i made this change that them is applied, however it stays applied to all my pages even...

Well I tried removing the Server.Transfer(Request.FilePath) that does make a change, but not the one i desire. With this change when i click on the drop down list it changes to the wrong theme. IE if i click on a "green" them it changes to the red theme, etc. If i click on a link within my site...

I am trying to set up themes in ASP.Net 2.0 I set up an page load event that grabs the themes by checking the app_themes folder. Added some events for my dropdown list. There are 2 issues i am having 1. When i choose a theme from my dropdown it changes my themes. However when I choose the theme...

That does not solve my problem. I use the hyperlink/link button field to pass a query string, and also on the click it changes my details view to insertmode. When clicking on this The query string is not passed to the url. <asp:TemplateField HeaderText="Add New"> <ItemStyle...

they are hyperlink fields of the gridview like this <asp:TemplateField HeaderText="Edit"> <ItemStyle Font-Underline="True" /> <ItemTemplate> <asp:HyperLink ID="HlinkEdit" runat="server" NavigateUrl='<%# Eval("ClassID"...