аЯрЁБс > ўџ 8 : ўџџџ 7 џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџьЅС M јП bjbjт=т= "" W W
џџ џџ џџ l F F F F F F F Z , Z щ Ж J ` ` ` ` ` ` ` h j j j j j j $ П F ` ` ` ` `
F F ` ` Ѓ
` F ` F ` h
` h
^
h F F h ` > rдЇ;ТZ Ќ
ђ h h Й 0 щ h ? є ? h
Z Z F F F F й CHANGES FOR MS ACCESS
For those of you who wish to run the Weekly Calendar application using a MS Access database, instead of a SQL Server database, please note that the following changes will need to be made.
Special thanks to Eduardo Rodriguez, of Columbia Basin College ( HYPERLINK "http://www.cbc2.org/" http://www.cbc2.org/), for contributing this document to the Distributed Development effort.
- Jordan Michaels
Line number is in parenthesis
Event_detail_popup:
Added quotes WHERE ID = '#ID#' (8)
Add_event:
Removed quotes TypeID = 1 (166)
WHERE TypeID = #TypeID# (188)
Add_event_action:
Added quotes WHERE ID = '#ID#' (90)
Modify_event:
Added quotes WHERE ID = '#ID#' (29)
Removed quotes AND TypeID = #GetEvent.TypeID# (54)
Removed quotes AND TypeID = 1 (46)
Removed quotes AND TypeID = 1 (205)
Removed quotes WHERE TypeID = #TypeID# (234)
Removed quotes WHERE TypeID = #GetEvent.TypeID# (243)
Removed quotes WHERE TypeID = #GetEvent.TypeID# (218)
Modify_event_action:
Removed quotes WHERE ID = #form.ID# (64)
Removed quotes TypeID = #form.TypeID#, (79)
Removed quotes AND TypeID = #GetCurrent.TypeID# (83)
Starting on line 61
before:
SELECT Title, TypeID
FROM Events
WHERE ID = '#form.ID#'
AND OU = '#form.OU#'
after:
SELECT Title, TypeID
FROM Events
WHERE ID = #form.ID#
AND OU = '#form.OU#'
Starting on line 68
before:
UPDATE Events
SET Title = '#form.Title#',
StartHour = '#form.StartHour#',
StartMinute = '#form.StartMinute#',
StartAMPM = '#form.StartAMPM#',
ShowST = '#form.ShowST#',
EndHour = '#form.EndHour#',
EndMinute = '#form.EndMinute#',
EndAMPM = '#form.EndAMPM#',
ShowET = '#form.ShowET#',
TypeID = '#form.TypeID#',
Description = '#form.Description#',
Modified = '#form.Modified#'
WHERE Title = '#GetCurrent.Title#'
AND TypeID = '#GetCurrent.TypeID#'
AND OU = '#form.OU#'
after:
UPDATE Events
SET Title = '#form.Title#',
StartHour = #form.StartHour#,
StartMinute = #form.StartMinute#,
StartAMPM = '#form.StartAMPM#',
ShowST = #form.ShowST#,
EndHour = #form.EndHour#,
EndMinute = #form.EndMinute#,
EndAMPM = '#form.EndAMPM#',
ShowET = #form.ShowET#,
TypeID = #form.TypeID#,
Description = '#form.Description#',
Modified = '#form.Modified#'
WHERE Title = '#GetCurrent.Title#'
AND TypeID = #GetCurrent.TypeID#
AND OU = '#form.OU#'
Delete_confirm:
Removed quotes AND TypeID = 1 (31)
Removed quotes AND TypeID = #GetEvent.TypeID# (40)
Added quotes WHERE ID = '#ID#' (22)
Delete_event:
Removed quotes AND TypeID = 1 (30)
Removed quotes AND TypeID = #GetEvent.TypeID# (39)
Added quotes WHERE ID = '#ID#' (21)
Added quotes WHERE ID = '#ID#' (52)
Update_user:
Removed quotes WHERE TypeID = #GetRights.TypeID# (71)
Update_user_remove:
Removed quotes AND TypeID = #Permission# (28)
Update_user_give:
Removed quotes AND TypeID = #Permission# (28)
Type_management:
Removed quotes WHERE TypeID <> 1 (66)
Removed quotes AND TypeID <> 3 (67)
Removed quotes AND TypeID <> 10 (68)
7 8 9 M N Ъ п M _ Ы р ) 0 ч № : A | З Ф ћ > P њђхђехЫхђ Ч Ч Ч Ч Ч Ч Ч Ч Ч Ч Ч Ч Ч Ч Ч 5\ 0J 5B*\ph j 5B*U\ph j 5B*U\ph 5B*\ph B*ph ( г д Њ Ћ Ќ Ъ Ы п . L M _ Ж щ 0 ] њ ј ј ј ј і і ь ј ј і і і і і і і і і і і і і і і і і
&d PЦ џ $a$ ў ] Ъ Ы р 5 j k Ч о ь ( ) 0 q Ф а б в ч ш № § § § § § § § § § § § § § § § § § § § § § § § § § § ћ § § № ё 2
B
`
Њ
Э
ъ
, K h
Ќ Ь ё - 9 : A А б і
4
Q
§ § § § § § § § § § § § § § § § § § § § § § § § § § § § § Q
r
Ќ
Ч
ю
3 V m y z { | Џ т 9 l Е Ж З Ф њ ћ § § § § § § § § § § § § § § § § § § § § § § § § § § § § § = > P ~ Ж к џ § § § § § § § § § §
1hАа/ Ар=!А"А# $ %А Щ D аЩъyљКЮ Њ KЉ h t t p : / / w w w . c b c 2 . o r g / рЩъyљКЮ Њ KЉ* h t t p : / / w w w . c b c 2 . o r g /
i 8 @ёџ 8 N o r m a l CJ _HaJ mH sH tH 2 @ 2 H e a d i n g 1 $@&