<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Request.QueryString End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_poll_STRING MM_editTable = "poll" MM_editRedirectUrl = "" MM_fieldsStr = "excellent|value|very_good|value|good|value|satisfactory|value|poor|value" MM_columnsStr = "excellent|',none,''|[very good]|',none,''|good|',none,''|satisfactory|',none,''|poor|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> ONSITE@OED Issue 2 - an e-newsletter from OED
 

 
Thank you for all your wonderful feedback on our first issue of Onsite@OED. We had great fun reading all your comments and suggestions on how we can further improve our newsletter.
So we've added in a new Section called Your Say for all feedback and comments to be published. And of course, I couldn't resist adding some replies of my own...
read more
 
 
 
Yong Siew Toh Conservatory of Music
The new 2-storey interim building for Yong Siew Toh Conservatory of Music (YSTCM) was completed in April 2003. It is situated amidst lush greenery adjacent to the School of Design and Environment Block 2 (SDE2)...
read more
 
 
Kent Ridge and Sheares Halls of Residences
The Kent Ridge and Sheares Halls at Heng Mui Keng (HMK) Terrace are the latest additions to NUS student housing projects and comprises of about 1000 single-room units. The project features modern architectural design and encompasses up-to-date facilities. Among the highlights are electronic card access system, architectural trellis, sunscreens and covered linkways for both functional and aesthetical purposes...
read more
 
 

Campus Upgrading Phase 2A Updates
To date, more than 50% of offices, dry labs and wet labs in faculties and administrative departments have been upgraded under the Campus Upgrading Phase 2A programme...
read more

 
 

Extension Tablets for Upgraded Lecture Theatres
Students sitting for their examinations in the upgraded LTs 6 and 12 this year were able to do so in comfort. This was made possible with the invention of the 'extension tablets' specially designed to fit onto the existing writing tablets in the newly upgraded LTs...
read more

 
 
"Singapore's OK" Arrives at NUS
Has the label "Singapore's OK" caught your eye before? Ever wondered what "Singapore's OK" all about?
The National Environment Agency (NEA) has been spearheading the drive to harness the collective commitment of managers of public toilets, cleaners and the general public to work together in order to raise the standard of hygiene and cleanliness of all public toilets in Singapore
...
read more
 
 
Going Green at Kent Vale
Residents at Kent Vale apartments could now play a role to contribute to a greener environment. OED has kicked off a recycling programme at Kent Vale since 1 December 2003.
Recycling Bins are provided by the appointed recycling contractor at strategic locations in each residential block to receive items which residents wish to recycle
....
read more
 
 
Think Road Safety - Do Not Jaywalk
By now, many of you should have seen the bright orange banners along the main roads in campus bearing the message "Be Safe, Not Sorry, Do Not Jaywalk". These banners serve to encourage and remind the NUS community not to jaywalk as part of our road safety campaign...
read more
 

 
Water Conservation Initiative
OED has adopted a new water tank cleaning chemical since August 2003 that will conserve large amounts of potable water. The pilot trial was carried out in water tanks of 84 m3 capacity located at Engineering Block EA. Two bottles of sampling water were sent to an accredited laboratory for water quality analysis at the end of the cleaning process. The test results showed that the water sample complied with authority requirements and was safe for consumption...
read more
 
 
A Whiff of Cherry Blossoms
"Shingapo-ru e yokoso", in English, that means, "Welcome to Singapore". OED played host to a group of Japanese visitors on a one-day visit to NUS on 1 March 2004.
At 9.00am, Assistant Professor Mitsuharu Hattori (Division of Molecular Neurobiology, University of Tokyo), Mr Takeharu Kawai (Project Manager, Mitsubishi Research Institute) and Ms Junko Ogawara (interpreter) arrived at OED on a study trip to learn more about campus planning, design and development with a focus on research facilities for lab-based programmes.
...
read more
 
 
Customer Service Centre
"Good morning, OED Customer Service Centre. How can I help you?", you may have heard this each time you call the OED for assistance and wonder what is this Customer Service Centre all about.
The Customer Service Centre (CSC) is the merger of two units – the NUS Main Line and OED Maintenance Response Centre. This newly-merged unit was formed since 1 January 2004. The unit has a team of five wonderful Customer Service Officers - Mr Syed Nasir bin Syed Mohamed, Ms R Thenmozli, Ms Rosnah bte Samat, Mrs Arumugam and Ms Jasmin Tay..
.
read more
 
 
 
Staff Feature - Our Iron Lady, Mrs Arumugam
"Good morning, OED Customer Service Centre, Mrs Aru speaking. May I help you?" a friendly voice greets you when you call our Customer Service Centre hotline, 68741515.
Sounds familiar? Yes, the sweet voice behind that polite greeting belongs to our loyal and dedicated staff, Mrs Arumugam. If you have a hard time twisting your tongue to pronounce Arumugam, it's alright, she won't mind you calling her Mrs Aru for short...

read more
 
 
Social Activities - Weekend Cruise
The SWRC Committee for FY03/04 ended its term of service on a high note, a weekend cruise on board the Starship Virgo. The annual Dinner and Dance was held in conjunction with the event and was attended by 75 staff members and their families...
read more
 
 
Handy Tips
Success In Growing Indoor Plants
....depends to a large extent on how close we come to simulating the conditions under which the plants grew in their natural surroundings. Because, really, there are no "true" indoor plants - most are native to warm, humid areas...
read more
 


 





Other Issues





Office of Estate and Development
2 Estate Office Drive
Singapore 117587

Customer Service Centre: 6874 1515
Fax: 6778 6031

Website: http://www.nus.edu.sg/oed