User Profile & Activity

Way Hang Wee Member
Page
of 6

Hi Andi,

Now i have been able to get eventID during Page_Load.

Now i would like to get the StartDate and EndDate of the recurring event clicked.

For example:

User click on a recurring event and click "only this instance" which the data as below:

RecurrintEvents 

ID RecurrenceID StaffID ActivityCode RoomID ScheduleID ParentID StartTime EndTime
320 320 50 ICSALab1 7 1 NULL 2010-01-05 13:00:00.000 2010-01-05 14:00:00.000

 

RecurrenceInfo

ID StartDate EndDate TotalRecurrence WeekDay ScheduleID Mode RangeMode
320 2010-01-05 00:00:00.000 2010-03-31 00:00:00.000 10 1 1 2 00:00.0

 

So if i query from RecurringEvents or RecurrenceInfo table, i'll get StartDate 2010-01-05, but what i need is the exact date of the event clicked by the user. For example if the recurring events occur on every monday from 2010-01-05 to 2010-03-31, and the user click on 1 of the instance where the date is 2010-03-02. So i want to get the date 2010-03-02 instead of query from table and get 2010-01-05.

 

Pls advise.

Thanks!

Hi Andi,

The system do alert the value of "Text1" correctly. But at the EditingForm page_load event, the "Text1" return empty string when i try to get the value. I believe the value of "Text1" is assigned after page_load.

In my case, i need to be able to get the EventID during page_load.

Pls advise.

Thanks!

Hi Andi,

I tested with the code but it doesn't work. Attached is the sample. Inside the folder, there's CreateTable.sql to create the needed tables.

Note that during OnEditingFormShow, at checking if (eventType == "Event"), the eventType is actually = "Exception" instead of "Event". I'm not sure if this has anything to do with not able to set the value.

Pls advise.

Thanks!

Posted: February 24, 2010 2:05 AM

ok that solves the problem.

Thanks!

Posted: February 22, 2010 1:54 AM

Attached is the sample to reproduce the issue. Inside the folder, there's CreateTable.sql to create the needed tables.

There are 2 issues here:

1) The function is not called during onLoad when there's WebScheduler in the aspx. If the WebScheduler is removed, then the function is called without problem during onLoad.

2) I'm not able to refresh the WebSchduler after page post back.

 

Pls advise.

Hi Andi,

I tested with your snippet but it doesn't work.

In the EditingForm, during page load i try to get the value of "Text1" but empty string is returned.

Pls advise.

Hi Andi,

If that's the case (cannot remove some objects), then i would like to have my own editing form. But how can i get the EventID in the new window so that i can populate the information in the new window and let the user edit the information allowed?

Thanks!

Posted: February 5, 2010 2:31 AM

Hi Andi,

The new aatached sample is different with my scenario.

My scenario is:

WebCombo1, WebCombo2 & WebCombo3 is independent with each other, only record of WebCombo4 is retrieved based on selection in WebCombo1, WebCombo2 & Webcombo3.

Pls advise.

Thanks!

Posted: February 4, 2010 10:42 PM

Hi Andi,

The sample provided doesn't solve the issue. The total records retrieved in WebCombo 4 is 830 which is all the records in Orders table of Northwind database.

Pls advise.

Thanks!

Same thing happen when i removed:

1) WebCombo for Importance

2) WebCombo for Categories

 

Pls advise.

All times are GMT -5. The time now is 1:21 AM.
Previous Next