This repository has been archived by the owner on Nov 11, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
createAccount.cfm
131 lines (126 loc) · 3.85 KB
/
createAccount.cfm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<cfquery name="GetCircUnit" datasource="#CircStatsDSN#">
SELECT
UnitID,
Unit
FROM
CircUnit
WHERE
Active = 1
ORDER BY
Unit
</cfquery>
<cfquery name="GetRefUnit" datasource="#CircStatsDSN#">
SELECT DISTINCT
SUBSTRING(UnitID, 1, 3) AS ParentUnitID,
CASE
WHEN SUBSTRING(UnitID, 1, 3) = 'ART' THEN 'Arts Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'BIO' THEN 'Biomed Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'CLK' THEN 'Clark Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'COL' THEN 'Powell Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'EAL' THEN 'East Asian Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'LAW' THEN 'Law Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'MAN' THEN 'Management Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'MUS' THEN 'Music Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'RBR' THEN 'Rieber Hall'
WHEN SUBSTRING(UnitID, 1, 3) = 'SEL' THEN 'Science & Engineering Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'SRL' THEN 'SRLF'
WHEN SUBSTRING(UnitID, 1, 3) = 'YRL' THEN 'Young Research Library'
WHEN SUBSTRING(UnitID, 1, 3) = 'DLP' THEN 'Digital Library Program'
WHEN SUBSTRING(UnitID, 1, 3) = 'SSD' THEN 'Social Science Data Archive'
ELSE NULL
END AS "ParentUnit"
FROM
View_RefUnit
ORDER BY
ParentUnit
</cfquery>
<html>
<head>
<title>UCLA Library Public Service Statistics</title>
<cfinclude template="../library_pageincludes/banner.cfm">
<cfinclude template="../library_pageincludes/nav.cfm">
<!--begin you are here-->
Public Service Statistics
<!-- end you are here -->
<CFINCLUDE TEMPLATE="../library_pageincludes/start_content.cfm">
<h1>Public Service Statistics</h1>
<p>
Welcome to UCLA Library Public Service Statistics Web site.
</p>
<form action="addAccount.cfm"
method="post"
name="Login"
id="Login">
<!--onsubmit="JavaScript:return validateForm(this);"-->
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right">User name</td>
<td> </td>
<td>
<input name="LogonID" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Password</td>
<td> </td>
<td>
<input name="newPassword" type="password" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">First Name</td>
<td> </td>
<td>
<input name="FirstName" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Last Name</td>
<td> </td>
<td>
<input name="LastName" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Email Address</td>
<td> </td>
<td>
<input name="EmailAddress" type="text" size="15" maxlength="50">
</td>
</tr>
<tr>
<td align="right">Circ Unit</td>
<td> </td>
<td>
<select name="CircUnit" class="form">
<cfoutput query="GetCircUnit">
<option value="#GetCircUnit.UnitID#">#GetCircUnit.Unit#</option>
</cfoutput>
</select>
</td>
</tr>
<tr>
<td align="right">Ref Unit</td>
<td> </td>
<td>
<select name="RefUnit" class="form">
<cfoutput query="GetRefUnit">
<option value="#GetRefUnit.ParentUnitID#">#GetRefUnit.ParentUnit#</option>
</cfoutput>
</select>
</td>
</tr>
<tr><td colspan="3"> </td></tr>
<tr>
<td> </td>
<td align="right">
<input type="submit" class="mainControl" value="Create Account">
</td>
<td valign="top">
</td>
</tr>
</table>
</form>
<CFINCLUDE TEMPLATE="../library_pageincludes/footer.cfm">
<CFINCLUDE TEMPLATE="../library_pageincludes/end_content.cfm">