View Complete Post
I actually faced a strange problem which is that when I add events in september 2011, they don't show up in the calendar view and the view remains empty but they appear in the all events view but events in other months appear.
Another strange thing is that I was adding events in July 2011. In the calendar view of July 2011, the first 6 days of August appear but this isn't the problem but the problem is that when I add about 3 events
in 31 July then about another three from 31 July to 4 August and then about 2 events from 1 to 4 August, the events are collapsed and the 3 more items appear but when I click the link, I don’t see
the events that were just on 31 July and I tried this too in the end of March so it seems that the months whose calendar view includes some days from the next month have a problem.
And finally when I change the month to be october 2010, I get error page with the text:
An unexpected erro has occured.
web parts maintenance page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
and I checked in more than one calendar and in more than one site and it's the same, So I'm asking if any one faced something like th
I have a dropdownbox which I want to use to search records based on a timescale. The gridview populates results based from that search.
So here is how I want to work this;
If a user selects "today" - a list of records input today are populated. If "this week" is selected, a list of all records added within that week from todays date is populated.
I created a forum on this issue previously but to no avail whatsoever. How do I work around this problem?
Help would be much appreciated
I have a requirement to use the MOSS 2007 Calendar Control - month view is to apply a custom css to have a look and feel as per our requirements.
We tried applying the custom css to the MOSS 2007 calendar control - month view, it does take the custom css and applies it, but when i click on any date and come back to the calendar control, it changes the CSS of the MOSS calendar control back to the default
Let me know if anyone has any suggestion on how to customize the calendar control for css for our intranet application.
Your response would be highly appreciated.
I have a challenge of which I can't figure out how to achieve it.
at this moment I have a gridview that can be dynamicly filled with cell's based upon the number of items selected (throug a drop down list) by a user.
the user then can enter some values in the cells to perform a bulk insert.
What I rather want is that the user selects a month, like august, and then the gridview is filled with the amount of days from that month, so you get 31 cells in the gridview. second all the first cells should be filled with the daynumber for that day...
I hope the explanation is clear :)
Does anyone know a solution to this?
consider that i have columns like tax_amount,item_amount,month,year in a table..
i want to get
current month & year - tax_amount,item_amount
previus month and current year- tax_amount,item_amount
current month & previus year - tax_amount,item_amount
how to get all the values in a single select query.
i am waiting for ur reply..
I want to get all records that are 7 days pass today's date and not equal to today's date. Don't know how to write it so I can get records 7 days old but with this procedure I'm still getting records that are due today. Hope this makes sense. Can someone assist me.
select * from libraryrequestwhere duedate > getdate() and duedate != getdate()
Hi Below is my Scenario.
Record Start Date
I tried finding a QA which already addressed this idea, but with no luck. Sorry if it's been addressed before.
I have a table where sales pricing is managed; it contains history of pricing where every price record has an 'effective date'. Currently when a user needs the 'active' price for a customer/item combination, the table is queried by the record that has the
most recent 'EffectiveDate' before GETDATE(). Here is the def for table 'tim_PriceSheet'
ItemKey int, not null
EffectiveDate datetime, notnull
ListPrice decimal (15,5)
The primary key is set on ItemKey, EffectiveDate
ItemKey EffectiveDate CurrID ListPrice
45 2010-07-01 00:00:00.000 CAD 100.00000
45 2010-09-14 00:00:00.000 CAD 110.00000
45 2010-10-01 00:00:00.000 CAD 112.00000
63 2010-09-01 00:00:00.000 CAD 45.00000
63 2010-09-01 00:00:00.000 USD 45.00000
63 2010-09-18 00:00:00.000 CAD 40.00000
63 2010-10-01 00:00:00.000 USD 40.00000
63 2010-10-15 00:00:00.000 CAD 41.00000
63 2010-10-21 00:00:00.000 USD 41.00000
My challenge is this:
I want to return a record set which shows the current price for each distinct item and currency code; in the example below the result would be based on the date being September 16, 2010